Assembly table in Microsoft Dynamics 365 Business Central. 42 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Document No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 2 | Document No. PK | Code | Normal | |
| 3 | Line No. PK | Integer | Normal | |
| 8 | Order No. | Code | Normal | |
| 9 | Order Line No. | 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 | |
| 25 | Position | Code | Normal | |
| 26 | Position 2 | Code | Normal | |
| 27 | Position 3 | Code | Normal | |
| 39 | Item Shpt. Entry No. | Integer | Normal | |
| 40 | Quantity | Decimal | Normal | |
| 41 | Quantity (Base) | Decimal | Normal | |
| 52 | Due Date | Date | 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 | |
| 80 | Unit of Measure Code | 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 | |
| 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 |
Tables referenced by fields on the Posted Assembly Line table through TableRelation properties.