SupplyRequestssupplyRequestLines
Tracks demand and supply details associated with each supply request, ensuring precise demand fulfillment.
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | Reference number for the supply request. |
| UOMCode | String | Unit of measure (UOM) code for the item. |
| SupplyOrderReferenceLineId | Long | Unique identifier for the supply request line. |
| SupplyOrderReferenceLineNumber | String | Number identifying the supply request line. |
| SourceSubinventoryCode | String | Subinventory code from which the item is being transferred. |
| SourceOrganizationId | Long | Unique identifier of the source organization. |
| SourceOrganizationCode | String | Organization code from which the item is transferred. |
| RequestedShipDate | Datetime | Date when the item is expected to be shipped. |
| Quantity | Decimal | Requested quantity of the item. |
| PreparerId | Long | Unique identifier of the person who prepared the request. |
| ItemId | Long | Unique identifier of the requested item. |
| InterfaceBatchNumber | String | Batch number identifying multiple supply requests. |
| InterfaceSourceCode | String | Source system code of the supply request (DOO, INV, EXT). |
| CarrierId | Long | Unique identifier of the carrier in the shipping method. |
| DeliverToRequesterId | Long | Unique identifier of the requester. |
| DestinationOrganizationCode | String | Destination inventory organization code. |
| DestinationOrganizationId | Long | Unique identifier of the destination inventory organization. |
| DestinationSubinventoryCode | String | Destination subinventory code. |
| SupplyOrderSource | String | Source system requesting the supply (DOO, INV, YPS). |
| BackToBackFlag | Bool | Indicates if the request is a back-to-back order (Y/N). |
| NeedByDate | Datetime | Date when the supply is needed at the destination. |
| SupplySourceSystem | String | Application where the supply is being created (INV, WIE, POR). |
| SupplyType | String | Type of supply request (TRANSFER, BUY, MAKE). |
| ProcessStatus | String | Processing status of the supply request (SUCCESS, ERROR). |
| PreparerName | String | Full name of the preparer (LASTNAME, FIRSTNAME). |
| PreparerEmail | String | Email address of the preparer. |
| CarrierCode | String | Carrier code associated with the shipping method. |
| DeliverToRequesterName | String | Name of the person requesting the supply. |
| DestinationLocation | String | Location code for the destination. |
| SourceLocation | String | Location code of the source from which the item is shipped. |
| DestinationTypeCode | String | Destination type (INVENTORY, EXPENSE). |
| DooShipmentFlag | Bool | Indicates if the shipment is routed through Oracle Order Management Cloud (Y/N). |
| FirmDemandFlag | Bool | Indicates if the demand is firm (Y/N). |
| GroupCode | String | Import group code for this line. |
| ScheduledShipDate | Datetime | Scheduled shipping date. |
| ShipClassOfService | String | Class of service for shipping priority (HIGH, MEDIUM, LOW). |
| ShipModeOfTransport | String | Mode of transport for shipment. |
| SupplyOperation | String | Operation performed on the request (CREATE, UPDATE, CANCEL). |
| DestinationLocationId | Long | Unique identifier for the destination location. |
| DeliverToRequesterEmail | String | Email address of the requester. |
| UOMName | String | UOM name for the item. |
| ItemDescription | String | Description of the requested item. |
| SourceOrganizationName | String | Name of the source organization. |
| SourceSubinventoryName | String | Name of the source subinventory. |
| SourceLocationId | Long | Unique identifier of the source location. |
| DestinationOrganizationName | String | Name of the destination organization. |
| DestinationSubinventoryName | String | Name of the destination subinventory. |
| TransferPrice | Decimal | Transfer price for the item. |
| TransferPriceCurrencyCode | String | Currency code for the transfer price. |
| ItemNumber | String | Item number in the request. |
| TransferOrderHeaderNumber | String | Transfer order header number. |
| TransferOrderLineNumber | String | Transfer order line number. |
| NoteToReceiver | String | Instructions for the receiver. |
| NoteToSupplier | String | Instructions for the supplier. |
| Comments | String | Additional comments in the request. |
| ItemRevision | String | Item revision number. |
| SupplySplitsAllowedFlag | Bool | Indicates if supply splits are allowed (Y/N). |
| PurchaseOrderScheduleNumber | String | Purchase order schedule number. |
| PurchaseOrderNumber | String | Purchase order number. |
| PurchaseOrderLineNumber | String | Purchase order line number. |
| PurchaseOrderLineId | String | Unique identifier for the purchase order line. |
| PurchaseOrderHeaderId | String | Unique identifier for the purchase order header. |
| SupplierId | Long | Unique identifier of the supplier. |
| SupplierSiteId | Long | Unique identifier of the supplier site. |
| SupplierNumber | String | Supplier number. |
| SupplierSiteName | String | Supplier site name. |
| PurchaseOrderScheduleId | Long | Unique identifier for the purchase order schedule. |
| SupplierName | String | Supplier name. |
| FirmPlannedFlag | Bool | Indicates if the supply request should be firmed (Y/N). |
| ShipmentPriorityCode | String | Shipment priority (LOW, MEDIUM, HIGH). |
| BindDestOrganizationCode | String | Binding field for destination organization code. |
| BindDocumentNumber | String | Binding field for document number. |
| BindItemNumber | String | Binding field for item number. |
| BindNeedByDate | Datetime | Binding field for need-by date. |
| BindSupplyOrderNumber | String | Binding field for supply order number. |
| BindSupplyOrderReferenceNumber | String | Binding field for supply order reference number. |
| BindSupplyOrderSource | String | Binding field for supply order source. |
| BindSupplyRequestDate | Datetime | Binding field for supply request date. |
| BindSupplyStatus | String | Binding field for supply request status. |
| BindSupplyType | String | Binding field for supply request type. |
| Finder | String | Utility field to search for supply request lines. |
| SupplyOrderReferenceNumber | String | Reference number for tracking the supply order. |