Manufacturing table in Microsoft Dynamics 365 Business Central. 18 fields, 0 records in Cronus demo.
The Sales Planning Line table (ID 99000800) is part of the Manufacturing area in Microsoft Dynamics 365 Business Central. It contains 18 fields, with a primary key of Sales Order No., Sales Order Line 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: Sales Order No., Sales Order Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Sales Order No. PK | Code | Normal | → Sales Header #36 |
| 2 | Sales Order Line No. PK | Integer | Normal | → Sales Line #37 |
| 3 | Item No. | Code | Normal | → Item #27 |
| 4 | Description | Text | Normal | |
| 5 | Shipment Date | Date | Normal | |
| 6 | Available | Decimal | Normal | |
| 7 | Next Planning Date | Date | Normal | |
| 8 | Expected Delivery Date | Date | Normal | |
| 9 | Planning Status | Option | Normal | |
| 10 | Needs Replanning | Boolean | Normal | |
| 11 | Variant Code | Code | Normal | → Item Variant #5401 |
| 12 | Planned Quantity | Decimal | Normal | |
| 15 | Low-Level Code | Integer | 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 Sales Planning Line table through TableRelation properties.