Assembly table in Microsoft Dynamics 365 Business Central. 61 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Document Type, No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Assembly Header table through TableRelation properties.