Order Promising Line #99000880

Other table in Microsoft Dynamics 365 Business Central. 29 fields, 0 records in Cronus demo.

29
Fields
0
Records
1
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: Entry No..

All fields (29)

Order Promising Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
10 Item No. Code Normal → Item #27
11 Variant Code Code Normal → Item Variant #5401
12 Location Code Code Normal → Location #14
13 Quantity Decimal Normal
14 Unit of Measure Code Code Normal → Item Unit of Measure #5404
15 Qty. per Unit of Measure Decimal Normal
16 Unavailable Quantity Decimal Normal
17 Quantity (Base) Decimal Normal
18 Unavailable Quantity (Base) Decimal Normal
19 Required Quantity (Base) Decimal Normal
20 Source Type Option Normal
21 Source Subtype Integer Normal
22 Source ID Code Normal
23 Source Batch Name Code Normal
25 Source Line No. Integer Normal
30 Description Text Normal
31 Required Quantity Decimal Normal
40 Requested Delivery Date Date Normal
41 Planned Delivery Date Date Normal
42 Original Shipment Date Date Normal
43 Earliest Shipment Date Date Normal
44 Requested Shipment Date Date Normal
45 Unavailability Date Date 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 Order Promising Line table through TableRelation properties.

Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Location
#14 · General Ledger · via Location Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code