SupplyRequestssupplyOrderLinesatpSupply
Handles supply details for available-to-promise (ATP) inventory, ensuring real-time visibility of supply availability.
Columns
Name | Type | Description |
SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | Reference number for the supply request associated with this supply order line in Available-to-Promise (ATP) supply. |
SupplyorderlinesSupplyLineId [KEY] | Long | Unique identifier for the supply order line within the ATP supply request. |
SupplyTrackingLineId [KEY] | Long | Identifier for tracking the individual supply line status and updates. |
SupplyOrderHeaderId | Long | Unique identifier linking this supply order line to the corresponding supply order header. |
SupplyLineId | Long | Unique identifier for the supply line within the ATP supply process. |
SupplyParentTrackingLineId | Long | Identifier for the parent supply tracking line, used for hierarchical tracking of supply orders. |
SupplyTrackingLineNumber | Long | Number assigned to track the supply line throughout processing. |
SupplyTrackingLineStatus | String | Current status of the supply tracking line (for example, Open, In Progress, Completed). |
SupplyType | String | Type of supply order (for example, Transfer Order, Work Order, Purchase Order). |
SupplyOrderReferenceLineId | Long | Unique identifier linking this supply order line to its reference line in Oracle Supply Chain Orchestration Cloud. |
SupplyOrderReferenceLineNumber | String | Reference number for the supply order line in Oracle Supply Chain Orchestration Cloud. |
ItemId | Long | Unique identifier for the item associated with the supply order. |
ItemRevision | String | Revision number of the item, if applicable. |
ItemNumber | String | Human-readable item number for the requested supply. |
ItemDescription | String | Detailed description of the item in the supply order line. |
UOMCode | String | Abbreviation for the unit of measure (UOM) used for the supply order. |
UOMName | String | Full name of the UOM for the supply order. |
Quantity | Decimal | Total quantity requested for the supply order line. |
DestinationOrganizationId | Long | Unique identifier for the destination organization receiving the supply. |
DestinationOrganizationCode | String | Abbreviation identifying the destination organization. |
DestinationOrganizationName | String | Full name of the destination organization. |
SupplyFulfilledQuantity | Decimal | Quantity of supply that has been fulfilled against this supply order line. |
SupplyChangePendingFlag | Bool | Indicates whether a change request is pending for the supply order line (true/false). |
SupplyExceptionFlag | Bool | Indicates whether an exception occurred in processing the supply order (true/false). |
BackToBackFlag | Bool | Indicates if the supply order is part of a back-to-back fulfillment process (true/false). |
ReservationNumber | String | Reservation number associated with the supply order for tracking allocations. |
BindDestOrganizationCode | String | Binding code linking the supply order line to the destination organization. |
BindDocumentNumber | String | Binding document number associated with the supply order line. |
BindItemNumber | String | Binding item number used for linking supply order data. |
BindNeedByDate | Datetime | Binding field indicating the required delivery date for the supply request. |
BindSupplyOrderNumber | String | Binding field linking the supply order number. |
BindSupplyOrderReferenceNumber | String | Binding field linking the supply order reference number. |
BindSupplyOrderSource | String | Binding field linking the supply order source application. |
BindSupplyRequestDate | Datetime | Binding field indicating when the supply request was submitted. |
BindSupplyStatus | String | Binding field tracking the processing status of the supply request. |
BindSupplyType | String | Binding field specifying the type of supply order. |
Finder | String | Utility field used for retrieving specific supply order lines. |
SupplyOrderReferenceNumber | String | Reference number used to track the supply order associated with this line. |