Table 99000866 "Capacity Constrained Resource"

Base Application · Microsoft.Manufacturing.Capacity · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 99000866 “Capacity Constrained Resources” (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. Δ BC28	Code[20]	Specifies the number of an existing machine center or work center to assign finite loading to.	TableRelation Table 99000754 “Work Center”, Table 99000758 “Machine Center” (if (“Capacity Type” = const(“Work Center”)) “Work Center” else if (“Capacity Type” = const(“Machine Center”)) “Machine Center”)
2	Capacity Type Δ BC28	Enum “Capacity Type”	Specifies the capacity type to apply finite loading to.	enum Enum 5871 “Capacity Type”
3	Name Δ BC28	Text[100]	Specifies the name of the work center or machine center associated with the capacity number on this line.
10	Critical Load % Δ BC28	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) Δ BC28	Decimal	Specifies the tolerance as a percent that you will allow the critical load percent to be exceeded for this work or machine center. via Page 99000866 “Capacity Constrained Resources”
14	Work Center No.	Code[20]	—	TableRelation Table 99000754 “Work Center” (Work Center)
39	Date Filter	Date	—	FlowFilter
40	Work Shift Filter	Code[10]	—	TableRelation Table 99000750 “Work Shift” (Work Shift); FlowFilter
42	Capacity (Effective) Δ BC24 Δ BC28	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. Δ BC24 Δ BC28	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. Δ BC24 Δ BC28	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 Δ BC24 Δ BC28	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 Δ BC24 Δ BC28	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” BlockInsertCapacityConstrainedResource

Relations

Prod. Order Need Qty.: CalcFormula Table 5410 “Prod. Order Capacity Need”
Prod. Order Need Qty. for Plan: CalcFormula Table 5410 “Prod. Order Capacity Need”
Work Center Load Qty.: CalcFormula Table 5410 “Prod. Order Capacity Need”
Work Center Load Qty. for Plan: CalcFormula Table 5410 “Prod. Order Capacity Need”
Work Shift Filter: TableRelation Table 99000750 “Work Shift”
Capacity No.: TableRelation Table 99000754 “Work Center” (conditional)
Work Center No.: TableRelation Table 99000754 “Work Center”
Capacity (Effective): CalcFormula Table 99000757 “Calendar Entry”
Capacity No.: TableRelation Table 99000758 “Machine Center” (conditional)

Pages and codeunits on this table

Page 99000866 “Capacity Constrained Resources” (source table)

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.