Order Promising Line #99000880

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

The Order Promising Line table (ID 99000880) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 29 fields, with a primary key of Entry No.. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

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.	FIELD	TYPE	CLASS	RELATION
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