Planning Component #99000829

Manufacturing table in Microsoft Dynamics 365 Business Central. 60 fields, 0 records in Cronus demo.

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: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Line No..

All fields (60)

Planning Component — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Worksheet Template Name PK	Code	Normal	→ Req. Wksh. Template #244
2	Worksheet Batch Name PK	Code	Normal
3	Worksheet Line No. PK	Integer	Normal	→ Requisition Line #246
5	Line No. PK	Integer	Normal
11	Item No.	Code	Normal	→ Item #27
12	Description	Text	Normal
13	Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
14	Quantity	Decimal	Normal
15	Position	Code	Normal
16	Position 2	Code	Normal
17	Position 3	Code	Normal
18	Lead-Time Offset	DateFormula	Normal
19	Routing Link Code	Code	Normal	→ Routing Link #99000777
20	Scrap %	Decimal	Normal
21	Variant Code	Code	Normal	→ Item Variant #5401
22	Qty. Rounding Precision	Decimal	Normal
23	Qty. Rounding Precision (Base)	Decimal	Normal
25	Expected Quantity	Decimal	Normal
28	Flushing Method	Option	Normal
30	Location Code	Code	Normal	→ Location #14
31	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
32	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
33	Bin Code	Code	Normal	→ Bin #7354
35	Supplied-by Line No.	Integer	Normal	→ Requisition Line #246
36	Planning Level Code	Integer	Normal
37	Ref. Order Status	Option	Normal
38	Ref. Order No.	Code	Normal
39	Ref. Order Line No.	Integer	Normal
40	Length	Decimal	Normal
41	Width	Decimal	Normal
42	Weight	Decimal	Normal
43	Depth	Decimal	Normal
44	Calculation Formula	Option	Normal
45	Quantity per	Decimal	Normal
46	Ref. Order Type	Option	Normal
50	Unit Cost	Decimal	Normal
51	Cost Amount	Decimal	Normal
52	Due Date	Date	Normal
53	Due Time	Time	Normal
55	Direct Unit Cost	Decimal	Normal
56	Indirect Cost %	Decimal	Normal
57	Overhead Rate	Decimal	Normal
58	Direct Cost Amount	Decimal	Normal
59	Overhead Amount	Decimal	Normal
60	Qty. per Unit of Measure	Decimal	Normal
62	Quantity (Base)	Decimal	Normal
63	Reserved Qty. (Base) ⚡ FLOW	Decimal	FlowField
71	Reserved Quantity ⚡ FLOW	Decimal	FlowField
73	Expected Quantity (Base)	Decimal	Normal
74	Original Expected Qty. (Base)	Decimal	Normal
75	Net Quantity (Base)	Decimal	Normal
76	Due Date-Time	DateTime	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
99000875	Critical	Boolean	Normal
99000915	Planning Line Origin	Option	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