Table 99000880 "Order Promising Line"
Base Application · Microsoft.Inventory.Availability
Across versions
- BC23present
- BC24declaration changed
- BC256 procedures added, 6 events added
- BC26-27unchanged
- BC2816 fields changed, 6 procedures removed
- BC29-30unchanged
Neighbourhood 10 connected objects and pages
Base Application · Microsoft.Inventory.Availability · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Order Promising Line |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | — | |
| 10 | Item No. Δ BC28 | Code[20] | Specifies the item number of the item that is on the promised order. | TableRelation Table 27 “Item” |
| 11 | Variant Code | Code[10] | — | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))); not editable |
| 12 | Location Code | Code[10] | — | TableRelation Table 14 “Location”; not editable |
| 13 | Quantity Δ BC28 | Decimal | Specifies the number of units, calculated by subtracting the reserved quantity from the outstanding quantity in the Sales Line table. | |
| 14 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); not editable |
| 15 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
| 16 | Unavailable Quantity Δ BC28 | Decimal | Specifies the quantity of items that are not available for the requested delivery date on the order. | |
| 17 | Quantity (Base) Δ BC28 | Decimal | — | |
| 18 | Unavailable Quantity (Base) Δ BC28 | Decimal | — | |
| 19 | Required Quantity (Base) Δ BC28 | Decimal | — | |
| 20 | Source Type | Enum “Order Promising Line Source Type” | — | enum Enum 99000880 “Order Promising Line Source Type” |
| 21 | Source Subtype | Integer | — | |
| 22 | Source ID | Code[20] | — | |
| 23 | Source Batch Name | Code[10] | — | |
| 25 | Source Line No. | Integer | — | |
| 30 | Description Δ BC28 | Text[100] | Specifies the description of the entry. | |
| 31 | Required Quantity Δ BC28 | Decimal | Specifies the quantity required for order promising lines. | |
| 40 | Requested Delivery Date Δ BC28 | Date | Specifies the requested delivery date for the entry. | |
| 41 | Planned Delivery Date Δ BC28 | Date | Specifies the planned date that the shipment will be delivered at the customer’s address. If the customer requests a delivery date, the program calculates whether the items will be available for delivery on this date. If the items are available, the planned delivery date will be the same as the requ… | |
| 42 | Original Shipment Date Δ BC28 | Date | Specifies the shipment date of the entry. | |
| 43 | Earliest Shipment Date Δ BC28 | Date | Specifies the Capable to Promise function as the earliest possible shipment date for the item. | |
| 44 | Requested Shipment Date Δ BC28 | Date | Specifies the delivery date that the customer requested, minus the shipping time. | not editable |
| 45 | Unavailability Date Δ BC28 | Date | Specifies the date when the order promising line is no longer available. |
Keys
- Key1: Entry No. (clustered)
- Key2: Requested Shipment Date
Events published
OnValidateRequestedDeliveryDate(var OrderPromisingLine: Record "Order Promising Line")+ BC25 (integration)- subscribers: Codeunit 6452 “Serv. Availability Mgt.” OnValidateRequestedDeliveryDate, Codeunit 99000871 “Job Planning Availability Mgt.” OnValidateRequestedDeliveryDate, Codeunit 99000872 “Sales Availability Mgt.” OnValidateRequestedDeliveryDate
OnValidatePlannedDeliveryDate(var OrderPromisingLine: Record "Order Promising Line")+ BC25 (integration)- subscribers: Codeunit 6452 “Serv. Availability Mgt.” OnValidatePlannedDeliveryDate, Codeunit 99000871 “Job Planning Availability Mgt.” OnValidatePlannedDeliveryDate, Codeunit 99000872 “Sales Availability Mgt.” OnValidatePlannedDeliveryDate
OnValidateEarliestDeliveryDate(var OrderPromisingLine: Record "Order Promising Line")+ BC25 (integration)- subscribers: Codeunit 6452 “Serv. Availability Mgt.” OnValidateEarliestDeliveryDate, Codeunit 99000871 “Job Planning Availability Mgt.” OnValidateEarliestDeliveryDate, Codeunit 99000872 “Sales Availability Mgt.” OnValidateEarliestDeliveryDate
Procedures
GetLastEntryNo(): IntegerCalcAvailability(): Decimal
Relations
- Location Code: TableRelation Table 14 “Location”
- Item No.: TableRelation Table 27 “Item”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Pages and codeunits on this table
- Page 99000959 “Order Promising Lines” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 5790 “Available to Promise” (1 call:
CalcAvailability → CalcQtyAvailableToPromise) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Order Promising Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.