Table 5410 "Prod. Order Capacity Need"

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

Learn documents this table through its pages: Page 99000820 “Prod. Order Capacity Need” (1 Learn page).

Properties

Property	Value
Caption	Prod. Order Capacity Need
DataClassification	CustomerContent

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	Status Δ BC28	Enum “Production Order Status”	Specifies the status of the production order.	enum Enum 5405 “Production Order Status”
2	Prod. Order No. Δ BC28	Code[20]	Specifies the number of the related production order.	TableRelation Table 5405 “Production Order” (“Production Order”.“No.” where(Status = field(Status)))
3	Routing No. Δ BC28	Code[20]	Specifies the routing number.	TableRelation Table 99000763 “Routing Header” (Routing Header)
4	Line No.	Integer	—
5	Operation No. Δ BC28	Code[10]	Specifies the operation number.
6	Type Δ BC28	Enum “Capacity Type”	Specifies the type of capacity need. Here you can see whether this capacity need is for a machine center or a work center.	enum Enum 5871 “Capacity Type”
7	No. Δ BC28	Code[20]	Specifies the Number of the machine center or work center depending on the entry in the Type field.	TableRelation Table 99000754 “Work Center”, Table 99000758 “Machine Center” (if (Type = const(“Work Center”)) “Work Center” else if (Type = const(“Machine Center”)) “Machine Center”)
8	Work Center No. Δ BC28	Code[20]	Specifies the work center number of the capacity need. If this capacity need occurs at a machine center that is assigned to a work center, that work center number will be shown here. If the capacity need is for a work center, the No. field and this field will show the same number.	TableRelation Table 99000754 “Work Center” (Work Center); not editable
9	Work Center Group Code	Code[10]	—	TableRelation Table 99000756 “Work Center Group” (Work Center Group); not editable
10	Routing Reference No.	Integer	—
11	Date	Date	—
12	Starting Time	Time	—
13	Ending Time	Time	—
14	Allocated Time Δ BC28	Decimal	Specifies the capacity need of planned operations.
16	Send-Ahead Type Δ BC28	Option	Specifies if the send-ahead quantity is of type Input, Output, or Both.	OptionCaption: ,Input,Output,Both
17	Time Type Δ BC28	Enum “Routing Time Type”	Specifies the time type of the capacity need. Two options are available: Setup Time and Run Time.	enum Enum 99000763 “Routing Time Type”
18	Needed Time Δ BC28	Decimal	Specifies how much time is required to meet the needs resulting from the specified capacity.
19	Needed Time (ms) Δ BC28	Decimal	Specifies how much time (in ms) is required to meet the needs resulting from the specified capacity. via Page 99000820 “Prod. Order Capacity Need”	not editable
21	Lot Size Δ BC28	Decimal	—
22	Concurrent Capacities Δ BC28	Decimal	Specifies the concurrent capacity of the operation.
23	Efficiency Δ BC28	Decimal	Specifies the efficiency of the production order capacity need.
26	Starting Date-Time Δ BC28	DateTime	Specifies the date and the starting time, which are combined in a format called “starting date-time”.	not editable
27	Ending Date-Time Δ BC28	DateTime	Specifies the date and the ending time, which are combined in a format called “ending date-time”.	not editable
31	Worksheet Template Name	Code[10]	—	TableRelation Table 244 “Req. Wksh. Template” (Req. Wksh. Template)
32	Worksheet Batch Name	Code[10]	—	TableRelation Table 245 “Requisition Wksh. Name” (“Requisition Wksh. Name”.Name where(“Worksheet Template Name” = field(“Worksheet Template Name”)))
33	Worksheet Line No.	Integer	—	TableRelation Table 246 “Requisition Line” (“Requisition Line”.“Line No.” where(“Worksheet Template Name” = field(“Worksheet Template Name”), “Journal Batch Name” = field(“Worksheet Batch Name”)))
41	Active	Boolean	—	not editable
42	Requested Only	Boolean	—

Keys

Key1: Status, Prod. Order No., Requested Only, Routing No., Routing Reference No., Operation No., Line No. (clustered)
Key2: Prod. Order No., Routing No., Routing Reference No., Operation No., Status, Line No., Requested Only
Key3: Status, Prod. Order No., Active, Requested Only, Routing No.
Key4: Work Center No., Date, Active, Starting Date-Time
Key5: Work Center Group Code, Date, Starting Date-Time
Key6: Type, No., Date, Active
Key7: Type, No., Starting Date-Time, Ending Date-Time, Active
Key8: Type, No., Ending Date-Time, Starting Date-Time, Active
Key9: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Operation No.
Key10: Status, Prod. Order No., Routing Reference No., Operation No., Date, Starting Time
Key11: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Operation No., Date, Starting Time
Key12: Worksheet Line No., Operation No.
Key13: Status, Prod. Order No., Type, No., Work Center No., Date, Requested Only

Trigger event subscribers

OnBeforeInsertEvent: Codeunit 99000788 “Mfg. Experience Tier” BlockInsertProdOrderCapacityNeed

Procedures

UpdateDatetime()
GetStartingEndingDateAndTime(var StartingTime: Time; var EndingTime: Time; var CurrDate: Date)
SetCapacityFilters(CapType: Enum "Capacity Type"; CapNo: Code[20])

Relations

drill-down page Page 99000820 “Prod. Order Capacity Need”
lookup page Page 99000820 “Prod. Order Capacity Need”
Worksheet Template Name: TableRelation Table 244 “Req. Wksh. Template”
Worksheet Batch Name: TableRelation Table 245 “Requisition Wksh. Name”
Worksheet Line No.: TableRelation Table 246 “Requisition Line”
Prod. Order No.: TableRelation Table 5405 “Production Order”
No.: TableRelation Table 99000754 “Work Center” (conditional)
Work Center No.: TableRelation Table 99000754 “Work Center”
Work Center Group Code: TableRelation Table 99000756 “Work Center Group”
No.: TableRelation Table 99000758 “Machine Center” (conditional)
Routing No.: TableRelation Table 99000763 “Routing Header”

Referenced by

9 fields in 5 objects relate to this table (TableRelation or CalcFormula).

Table 99000866 “Capacity Constrained Resource”: Prod. Order Need Qty., Prod. Order Need Qty. for Plan, Work Center Load Qty., Work Center Load Qty. for Plan
Table 5405 “Production Order”: Allocated Capacity Need, Expected Capacity Need
Table 99000754 “Work Center”: Prod. Order Need (Qty.)
Table 99000756 “Work Center Group”: Prod. Order Need (Qty.)
Table 99000758 “Machine Center”: Prod. Order Need (Qty.)

Pages and codeunits on this table

Page 99000820 “Prod. Order Capacity Need” (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: "Prod. Order Capacity Need"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.