Prod. Order Capacity Need #5410

Other table in Microsoft Dynamics 365 Business Central. 33 fields, 0 records in Cronus demo.

The Prod. Order Capacity Need table (ID 5410) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 33 fields, with a primary key of Status, Prod. Order No., Routing No., Line No., Operation No., Routing Reference No., Requested Only. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Status, Prod. Order No., Routing No., Line No., Operation No., Routing Reference No., Requested Only.

All fields (33)

Prod. Order Capacity Need — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Status PK	Option	Normal
2	Prod. Order No. PK	Code	Normal	→ Production Order #5405
3	Routing No. PK	Code	Normal	→ Routing Header #99000763
4	Line No. PK	Integer	Normal
5	Operation No. PK	Code	Normal
6	Type	Option	Normal
7	No.	Code	Normal
8	Work Center No.	Code	Normal	→ Work Center #99000754
9	Work Center Group Code	Code	Normal	→ Work Center Group #99000756
10	Routing Reference No. PK	Integer	Normal
11	Date	Date	Normal
12	Starting Time	Time	Normal
13	Ending Time	Time	Normal
14	Allocated Time	Decimal	Normal
16	Send-Ahead Type	Option	Normal
17	Time Type	Option	Normal
18	Needed Time	Decimal	Normal
19	Needed Time (ms)	Decimal	Normal
21	Lot Size	Decimal	Normal
22	Concurrent Capacities	Decimal	Normal
23	Efficiency	Decimal	Normal
26	Starting Date-Time	DateTime	Normal
27	Ending Date-Time	DateTime	Normal
31	Worksheet Template Name	Code	Normal	→ Req. Wksh. Template #244
32	Worksheet Batch Name	Code	Normal	→ Requisition Wksh. Name #245
33	Worksheet Line No.	Integer	Normal	→ Requisition Line #246
41	Active	Boolean	Normal
42	Requested Only PK	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (8)

Tables referenced by fields on the Prod. Order Capacity Need table through TableRelation properties.

Production Order

#5405 · Other · via Prod. Order No.

Routing Header

#99000763 · Manufacturing · via Routing No.

Work Center

#99000754 · Manufacturing · via Work Center No.

Work Center Group

#99000756 · Manufacturing · via Work Center Group Code

Req. Wksh. Template

#244 · Setup · via Worksheet Template Name

Requisition Wksh. Name

#245 · Other · via Worksheet Batch Name

Requisition Line

#246 · Other · via Worksheet Line No.