Other table in Microsoft Dynamics 365 Business Central. 26 fields, 0 records in Cronus demo.
The Unplanned Demand table (ID 5520) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 26 fields, with a primary key of Demand Type, Demand SubType, Demand Order No., Demand Line No., Demand Ref. No.. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Demand Type, Demand SubType, Demand Order No., Demand Line No., Demand Ref. No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Demand Type PK | Option | Normal | |
| 2 | Demand SubType PK | Option | Normal | |
| 4 | Demand Order No. PK | Code | Normal | |
| 5 | Demand Line No. PK | Integer | Normal | |
| 6 | Demand Ref. No. PK | Integer | Normal | |
| 7 | Sell-to Customer No. | Code | Normal | |
| 8 | Description | Text | Normal | |
| 9 | Demand Date | Date | Normal | |
| 10 | Status | Option | Normal | |
| 13 | Item No. | Code | Normal | |
| 14 | Variant Code | Code | Normal | |
| 15 | Location Code | Code | Normal | |
| 16 | Quantity (Base) | Decimal | Normal | |
| 17 | Level | Integer | Normal | |
| 18 | Bin Code | Code | Normal | → Bin #7354 |
| 19 | Qty. per Unit of Measure | Decimal | Normal | |
| 20 | Unit of Measure Code | Code | Normal | → Item Unit of Measure #5404 |
| 21 | Reserve | Boolean | Normal | |
| 22 | Needed Qty. (Base) | Decimal | Normal | |
| 23 | Special Order | Boolean | Normal | |
| 24 | Purchasing Code | Code | 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 Unplanned Demand table through TableRelation properties.