Assembly Header #900

Assembly table in Microsoft Dynamics 365 Business Central. 61 fields, 0 records in Cronus demo.

61
Fields
0
Records
2
Primary key
5
FlowFields
18
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Document Type, No..

All fields (61)

Assembly Header — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document Type PK Option Normal
2 No. PK Code Normal
3 Description Text Normal
4 Search Description Code Normal
5 Description 2 Text Normal
6 Creation Date Date Normal
7 Last Date Modified Date Normal
10 Item No. Code Normal → Item #27
12 Variant Code Code Normal → Item Variant #5401
15 Inventory Posting Group Code Normal → Inventory Posting Group #94
16 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
17 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
19 Comment ⚡ FLOW Boolean FlowField
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 Posting Date Date Normal
24 Due Date Date Normal
25 Starting Date Date Normal
27 Ending Date Date Normal
33 Bin Code Code Normal
40 Quantity Decimal Normal
41 Quantity (Base) Decimal Normal
42 Remaining Quantity Decimal Normal
43 Remaining Quantity (Base) Decimal Normal
44 Assembled Quantity Decimal Normal
45 Assembled Quantity (Base) Decimal Normal
46 Quantity to Assemble Decimal Normal
47 Quantity to Assemble (Base) Decimal Normal
48 Reserved Quantity ⚡ FLOW Decimal FlowField
49 Reserved Qty. (Base) ⚡ FLOW Decimal FlowField
50 Planning Flexibility Option Normal
51 MPS Order Boolean Normal
54 Assemble to Order ⚡ FLOW Boolean FlowField
63 Posting No. Code Normal
65 Unit Cost Decimal Normal
67 Cost Amount Decimal Normal
68 Rolled-up Assembly Cost ⚡ FLOW Decimal FlowField
75 Indirect Cost % Decimal Normal
76 Overhead Rate Decimal Normal
80 Unit of Measure Code Code Normal → Item Unit of Measure #5404
81 Qty. per Unit of Measure Decimal Normal
82 Qty. Rounding Precision Decimal Normal
83 Qty. Rounding Precision (Base) Decimal Normal
107 No. Series Code Normal → No. Series #308
108 Posting No. Series Code Normal → No. Series #308
120 Status Option 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
9000 Assigned User ID Code Normal → User Setup #91
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 (15)

Tables referenced by fields on the Assembly Header table through TableRelation properties.

Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Inventory Posting Group
#94 · Other · via Inventory Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Location
#14 · General Ledger · via Location Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code
No. Series
#308 · Other · via No. Series, Posting No. Series
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Sustainability Account
#6210 · Other · via Sustainability Account No.
Sustain. Account Category
#6211 · Other · via Sustainability Account Category
Sustain. Account Subcategory
#6212 · Other · via Sustainability Account Subcategory
User Setup
#91 · Other · via Assigned User ID