Posted Assembly Header #910

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

47
Fields
0
Records
1
Primary key
2
FlowFields
19
Relations
Open in Data Explorer →

Primary key

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

All fields (47)

Posted Assembly Header — FIELDS
NO.FIELDTYPECLASSRELATION
2 No. PK Code Normal
3 Description Text Normal
4 Search Description Code Normal
5 Description 2 Text Normal
9 Order No. Code 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
39 Item Rcpt. Entry No. Integer Normal
40 Quantity Decimal Normal
41 Quantity (Base) Decimal Normal
54 Assemble to Order ⚡ FLOW Boolean FlowField
65 Unit Cost Decimal Normal
67 Cost Amount Decimal Normal
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
100 Reversed Boolean Normal
107 No. Series Code Normal → No. Series #308
108 Posting No. Series Code Normal → No. Series #308
109 Order No. Series Code 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
9010 User ID Code Normal
9020 Source Code Code Normal → Source Code #230
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 Posted 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
Source Code
#230 · Other · via Source Code