Assembly Line #901

Assembly table in Microsoft Dynamics 365 Business Central. 61 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: Document Type, Document No., Line No..

All fields (61)

Assembly Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Document Type PK	Option	Normal
2	Document No. PK	Code	Normal	→ Assembly Header #900
3	Line No. PK	Integer	Normal
10	Type	Option	Normal
11	No.	Code	Normal
12	Variant Code	Code	Normal
13	Description	Text	Normal
14	Description 2	Text	Normal
18	Lead-Time Offset	DateFormula	Normal
19	Resource Usage Type	Option	Normal
20	Location Code	Code	Normal	→ Location #14
21	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
22	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
23	Bin Code	Code	Normal	→ Bin #7354
25	Position	Code	Normal
26	Position 2	Code	Normal
27	Position 3	Code	Normal
38	Appl.-to Item Entry	Integer	Normal
39	Appl.-from Item Entry	Integer	Normal
40	Quantity	Decimal	Normal
41	Quantity (Base)	Decimal	Normal
42	Remaining Quantity	Decimal	Normal
43	Remaining Quantity (Base)	Decimal	Normal
44	Consumed Quantity	Decimal	Normal
45	Consumed Quantity (Base)	Decimal	Normal
46	Quantity to Consume	Decimal	Normal
47	Quantity to Consume (Base)	Decimal	Normal
48	Reserved Quantity ⚡ FLOW	Decimal	FlowField
49	Reserved Qty. (Base) ⚡ FLOW	Decimal	FlowField
50	Avail. Warning	Boolean	Normal
51	Substitution Available ⚡ FLOW	Boolean	FlowField
52	Due Date	Date	Normal
53	Reserve	Option	Normal
60	Quantity per	Decimal	Normal
61	Qty. per Unit of Measure	Decimal	Normal
62	Inventory Posting Group	Code	Normal	→ Inventory Posting Group #94
63	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
64	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
65	Unit Cost	Decimal	Normal
67	Cost Amount	Decimal	Normal
72	Date Filter	Date	FlowFilter
80	Unit of Measure Code	Code	Normal
82	Qty. Rounding Precision	Decimal	Normal
83	Qty. Rounding Precision (Base)	Decimal	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
6210	Sustainability Account No.	Code	Normal	→ Sustainability Account #6210
6211	Sustainability Account Name	Text	Normal
6212	Sustainability Account Category	Code	Normal	→ Sustain. Account Category #6211
6213	Sustainability Account Subcategory	Code	Normal	→ Sustain. Account Subcategory #6212
6214	CO2e per Unit	Decimal	Normal
6215	Total CO2e	Decimal	Normal
6216	Posted Total CO2e	Decimal	Normal
7301	Pick Qty. ⚡ FLOW	Decimal	FlowField
7302	Pick Qty. (Base) ⚡ FLOW	Decimal	FlowField
7303	Qty. Picked	Decimal	Normal
7304	Qty. Picked (Base)	Decimal	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