SupplyRequestssupplyOrderLines
Tracks and manages supply information for each order line, supporting detailed monitoring of supply creation and fulfillment processes.
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | Reference number for the supply request associated with this supply order line. |
| SupplyLineId [KEY] | Long | Unique identifier for the supply order line within the supply request. |
| SupplyOrderHeaderId | Long | Identifier linking this supply order line to its corresponding supply order header. |
| SupplyLineNumber | Long | Line number within the supply order, used for tracking individual supply requests. |
| SupplyLineStatus | String | Current processing status of the supply order line (for example, Open, Completed, Canceled). |
| SupplyType | String | Type of supply order (for example, Transfer Order, Work Order, Purchase Order). |
| ItemId | Long | Unique identifier for the item requested in the supply order line. |
| ItemRevision | String | Revision number of the item, if applicable. |
| SupplyOrderReferenceLineNumber | String | Reference number for the supply order line in Oracle Supply Chain Orchestration Cloud. |
| Quantity | Decimal | Total quantity requested for the item in this supply order line. |
| UOMCode | String | Abbreviation for the unit of measure (UOM) associated with the requested quantity. |
| SupplyOrderReferenceLineId | Long | Unique identifier linking this supply order line to its reference line in Oracle Supply Chain Orchestration Cloud. |
| NeedByDate | Datetime | Date by which the requested supply is needed. |
| PreparerId | Long | Unique identifier of the user who prepared the supply request. |
| SupplyOrderSource | String | Application that originated the supply order (for example, Order Management, Inventory, External System). |
| DestinationOrganizationId | Long | Unique identifier for the destination organization receiving the supply. |
| DestinationOrganizationCode | String | Abbreviation identifying the destination organization. |
| ItemNumber | String | Human-readable item number associated with the requested supply. |
| ItemDescription | String | Detailed description of the item requested in the supply order. |
| UOMName | String | Full name of the UOM for the requested item. |
| DestinationOrganizationName | String | Full name of the destination organization where the supply is being sent. |
| PreparerName | String | Full name of the user who prepared the supply request. |
| PreparerEmail | String | Email address of the user who prepared the supply request. |
| BindDestOrganizationCode | String | Binding code that links 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 for linking the supply order number. |
| BindSupplyOrderReferenceNumber | String | Binding field for linking the supply order reference number. |
| BindSupplyOrderSource | String | Binding field for linking the supply order source application. |
| BindSupplyRequestDate | Datetime | Binding field indicating when the supply request was submitted. |
| BindSupplyStatus | String | Binding field for 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. |