Sales Planning Line #99000800

Manufacturing table in Microsoft Dynamics 365 Business Central. 18 fields, 0 records in Cronus demo.

18
Fields
0
Records
2
Primary key
0
FlowFields
6
Relations
Open in Data Explorer →

Primary key

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

All fields (18)

Sales Planning Line — FIELDS
NO.FIELDTYPECLASSRELATION
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

Related tables (5)

Tables referenced by fields on the Sales Planning Line table through TableRelation properties.

Sales Header
#36 · Sales Documents · via Sales Order No.
Sales Line
#37 · Sales Documents · via Sales Order Line No.
Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code