---
id: object/table/99000866
type: object
title: Table 99000866 "Capacity Constrained Resource"
summary: Table 99000866 "Capacity Constrained Resource" in Base Application (Microsoft.Manufacturing.Capacity). 13 fields. Present since at least BC23, still in BC30, changed in BC24, BC28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 56b8a1d23001324dbfb03924cbe508c57c27af312298fbc872503f8fefd3da6a
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Manufacturing/Capacity/CapacityConstrainedResource.Table.al
    title: src/Layers/W1/BaseApp/Manufacturing/Capacity/CapacityConstrainedResource.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/production-cancel-production-orders-that-have-consumption
    - https://learn.microsoft.com/dynamics365/business-central/production-configure-production-processes
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/manufacturing
    - topic/business-central/business-functionality/set-up-business-central/set-up-manufacturing
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 99000866
name: Capacity Constrained Resource
namespace: Microsoft.Manufacturing.Capacity
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 13
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 9
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 1
  calls: 0
  called_by: 0
  implements: 0
---

# Table 99000866 "Capacity Constrained Resource"

> Table 99000866 "Capacity Constrained Resource" in Base Application (Microsoft.Manufacturing.Capacity). 13 fields. Present since at least BC23, still in BC30, changed in BC24, BC28.

Base Application · Microsoft.Manufacturing.Capacity · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Manufacturing/Capacity/CapacityConstrainedResource.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 99000866 "Capacity Constrained Resources"](../page/99000866.md) (2 Learn pages).

## Properties

| Property | Value |
|---|---|
| Caption | Capacity Constrained Resource |
| DataClassification | CustomerContent |
| Permissions | TableData "Prod. Order Capacity Need" = r |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Capacity No. | Code[20] | Specifies the number of an existing machine center or work center to assign finite loading to. | TableRelation [Table 99000754 "Work Center"](../table/99000754.md), [Table 99000758 "Machine Center"](../table/99000758.md) (if ("Capacity Type" = const("Work Center")) "Work Center" else if ("Capacity Type" = const("Machine Center")) "Machine Center") |
| 2 | Capacity Type | Enum "Capacity Type" | Specifies the capacity type to apply finite loading to. | enum [Enum 5871 "Capacity Type"](../enum/5871.md) |
| 3 | Name | Text[100] | Specifies the name of the work center or machine center associated with the capacity number on this line. |  |
| 10 | Critical Load % | Decimal | Specifies the percentage of the available capacity of a work center or machine center to apply load to. Operations on work centers or machine centers that are set up as constrained resources will always be planned serially. This means that if a constrained resource has multiple capacities, then thos... |  |
| 11 | Dampener (% of Total Capacity) | Decimal | Specifies the tolerance as a percent that you will allow the critical load percent to be exceeded for this work or machine center. <small>via [Page 99000866 "Capacity Constrained Resources"](../page/99000866.md)</small> |  |
| 14 | Work Center No. | Code[20] | — | TableRelation [Table 99000754 "Work Center"](../table/99000754.md) (Work Center) |
| 39 | Date Filter | Date | — | FlowFilter |
| 40 | Work Shift Filter | Code[10] | — | TableRelation [Table 99000750 "Work Shift"](../table/99000750.md) (Work Shift); FlowFilter |
| 42 | Capacity (Effective) | Decimal | — | FlowField: sum("Calendar Entry"."Capacity (Effective)" where("Capacity Type" = field("Capacity Type"), "No." = field("Capacity No."), "Work Shift Code" = field("Work Shift Filter"), Date = field("Date Filter"))); not editable |
| 44 | Prod. Order Need Qty. | Decimal | — | FlowField: sum("Prod. Order Capacity Need"."Allocated Time" where(Type = field("Capacity Type"), "No." = field("Capacity No."), Date = field("Date Filter"))); not editable |
| 46 | Work Center Load Qty. | Decimal | — | FlowField: sum("Prod. Order Capacity Need"."Allocated Time" where("Work Center No." = field("Work Center No."), Date = field("Date Filter"))); not editable |
| 48 | Prod. Order Need Qty. for Plan | Decimal | — | FlowField: sum("Prod. Order Capacity Need"."Allocated Time" where(Type = field("Capacity Type"), "No." = field("Capacity No."), Date = field("Date Filter"), Active = const(true))); not editable |
| 49 | Work Center Load Qty. for Plan | Decimal | — | FlowField: sum("Prod. Order Capacity Need"."Allocated Time" where("Work Center No." = field("Work Center No."), Date = field("Date Filter"), Active = const(true))); not editable |

## Keys

- Key1: Capacity Type, Capacity No. (clustered)

## Trigger event subscribers

- OnBeforeInsertEvent: [Codeunit 99000788 "Mfg. Experience Tier"](../codeunit/99000788.md) BlockInsertCapacityConstrainedResource

## Relations

- Prod. Order Need Qty.: CalcFormula [Table 5410 "Prod. Order Capacity Need"](../table/5410.md)
- Prod. Order Need Qty. for Plan: CalcFormula [Table 5410 "Prod. Order Capacity Need"](../table/5410.md)
- Work Center Load Qty.: CalcFormula [Table 5410 "Prod. Order Capacity Need"](../table/5410.md)
- Work Center Load Qty. for Plan: CalcFormula [Table 5410 "Prod. Order Capacity Need"](../table/5410.md)
- Work Shift Filter: TableRelation [Table 99000750 "Work Shift"](../table/99000750.md)
- Capacity No.: TableRelation [Table 99000754 "Work Center"](../table/99000754.md) (conditional)
- Work Center No.: TableRelation [Table 99000754 "Work Center"](../table/99000754.md)
- Capacity (Effective): CalcFormula [Table 99000757 "Calendar Entry"](../table/99000757.md)
- Capacity No.: TableRelation [Table 99000758 "Machine Center"](../table/99000758.md) (conditional)

## Pages and codeunits on this table

- [Page 99000866 "Capacity Constrained Resources"](../page/99000866.md) (source table)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC28

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Capacity Constrained Resource")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.