SupplyRequestssupplyOrderLines
Tracks and manages supply information for each order line, supporting detailed monitoring of supply creation and fulfillment processes.
Columns
| Name | Type | SupportedFinders | 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 | FindBySupplyDestination | Binding code that links the supply order line to the destination organization. |
| BindDocumentNumber | String | FindBySupplyExecutionDocumentNumber | Binding document number associated with the supply order line. |
| BindItemNumber | String | FindBySupplyRequestItemNumber | Binding item number used for linking supply order data. |
| BindNeedByDate | Datetime | FindByRequestedDeliveryDateTo, findByRequestedDeliveryDateFrom | Binding field indicating the required delivery date for the supply request. |
| BindSupplyOrderNumber | String | FindBySupplyOrderNumber | Binding field for linking the supply order number. |
| BindSupplyOrderReferenceNumber | String | FindBySupplyRequestReferenceNumber | Binding field for linking the supply order reference number. |
| BindSupplyOrderSource | String | FindBySupplyRequestSource | Binding field for linking the supply order source application. |
| BindSupplyRequestDate | Datetime | FindBySupplyRequestDateFrom, findBySupplyRequestDateTo | Binding field indicating when the supply request was submitted. |
| BindSupplyStatus | String | FindBySupplyStatus | Binding field for tracking the processing status of the supply request. |
| BindSupplyType | String | FindBySupplyType | Binding field specifying the type of supply order. |
| Finder | String | Utility field used for retrieving specific supply order lines. | |
| SupplyOrderReferenceNumber | String | FindBySupplyRequestReferenceNumber, PrimaryKey, bySupplyOrderReferenceNumber | Reference number used to track the supply order associated with this line. |