This table captures transfer order line level information. Transfer orders serves as the orchestration document representing demand and supply for an internal material transfer.
Module: Inventory Management
TRANSFER_ORDER_LINE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TRANSFER_ORDER_LINE_ID | NUMBER | 38 | 0 | True | Transfer Order Line Unique Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Derived attribute | ||||
| TRANSFER_ORDER_HEADER_ID | NUMBER | 38 | 0 | Reference to Transfer Order Header Unique Identifier. | |||
| TRANSFER_ORDER_NUMBER | VARCHAR2 | 64 | This is the transfer order number. | ||||
| SOURCE_TYPE_LOOKUP | VARCHAR2 | 32 | Source from where this order was requested. Eg. SSP/Planning/Return/Min-Max | DW_INV_TO_ORIGIN_TYPE_TL | CODE | ||
| HEADER_STATUS_LOOKUP | VARCHAR2 | 32 | This is a derived column. It will show the Transfer Order Status : OPEN/CLOSED | ||||
| DESCRIPTION | VARCHAR2 | 256 | Translated description of transfer order | ||||
| TO_CREATION_DATE | DATE | Who column: indicates the date and time of the creation of the header row. | |||||
| REQUISITION_BU_ID | NUMBER | 38 | 0 | Business Unit for requesting organization | |||
| CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the header row. | ||||
| TRANSFER_ORDER_LINE_NUMBER | NUMBER | 38 | 0 | This is the transfer order line number. | |||
| TRANSFER_ORDER_LINE_NUM_CHAR | VARCHAR2 | 64 | This is the transfer order line number in varchar. | ||||
| INTERFACE_STATUS_LOOKUP | VARCHAR2 | 32 | Meanings can be Awaiting Interface to DOO, Error, Awaiting Interface to Shipping, Interfaced to DOO, Interfaced to Shipping | DW_INV_TO_INTERFACE_STATUS_TL | CODE | ||
| SOURCE_ORGANIZATION_ID | NUMBER | 38 | 0 | Reference to the unique identifier for the source organization. | |||
| SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 16 | Source organization subinventory name | ||||
| DESTINATION_ORGANIZATION_ID | NUMBER | 38 | 0 | Reference to the unique identifier for the destination organization. | |||
| DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 16 | Destination organization subinventory name | ||||
| DESTINATION_TYPE_LOOKUP | VARCHAR2 | 32 | Destination type, whether Inventory or Expense | ||||
| DESTINATION_LOCATION_ID | NUMBER | 38 | 0 | Destination location (from hr_locations) | |||
| MATERIAL_RETURN_REQUIRED | VARCHAR2 | 16 | Indicates whether physical shipping is required for a return TO. | ||||
| FULFILLMENT_LOOKUP | VARCHAR2 | 128 | Fuilfillment Status for transfer order line | ||||
| STATUS_LOOKUP | VARCHAR2 | 32 | Indicates whether line is OPEN/CLOSED/CANCELLED | ||||
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | This identifies the inventory item. | |||
| ITEM_REVISION | VARCHAR2 | 32 | Item revision. | ||||
| REQUESTED_DELIVERY_DATE | DATE | Date this transfer order line is requested for arrival - NEED_BY_DATE | |||||
| SCHEDULED_SHIP_DATE | DATE | Date this transfer order is scheduled to ship | |||||
| QTY_UOM_CODE | VARCHAR2 | 16 | The unit of measure code of the line quantity | ||||
| REQUESTED_QTY | NUMBER | This is the quantity requested. | |||||
| SHIPPED_QTY | NUMBER | This column stores the quantity shipped. | |||||
| RECEIVED_QTY | NUMBER | This column stores the quantity received. | |||||
| DELIVERED_QTY | NUMBER | Delivered quantity - Quantity putaway in Inventory after receipt | |||||
| SECONDARY_QTY_UOM_CODE | VARCHAR2 | 16 | Secondary unit of measure of line quantity | ||||
| SECONDARY_REQUESTED_QTY | NUMBER | Quantity requested in secondary unit of measure | |||||
| SECONDARY_SHIPPED_QTY | NUMBER | Quantity shipped in secondary unit of measure | |||||
| SECONDARY_RECEIVED_QTY | NUMBER | Quantity received in secondary unit of measure | |||||
| SECONDARY_DELIVERED_QTY | NUMBER | Quantity delivered and putaway in Inventory in secondary unit of measure | |||||
| UNIT_PRICE | NUMBER | Price per unit of item requested | |||||
| FREIGHT_CARRIER_ID | NUMBER | 38 | 0 | Reference to unique identification for carrier used on this line | |||
| MODE_OF_TRANSPORT_LOOKUP | VARCHAR2 | 32 | Mode of Transport for Ship Method | ||||
| SERVICE_LEVEL_LOOKUP | VARCHAR2 | 32 | This is the service level for the shipping method. | ||||
| SHIPMENT_PRIORITY_LOOKUP | VARCHAR2 | 32 | This lookup code indicates the shipment priority. | ||||
| REQUESTER_ID | NUMBER | 38 | 0 | Reference to unique identifier of the requestor | |||
| INTERFACE_ERR_MSG_TEXT | VARCHAR2 | 999 | This message text from FND_MESSAGES is the interface error text. | ||||
| CHANGE_REQUESTED_DATE | DATE | Date last change was requested on this Transfer Order line | |||||
| CHANGE_PARTY_ID | NUMBER | 38 | 0 | Reference to unique identifier for requestor or warehouse manager initiating the last change on this Transfer Order line. Needed by SSP to figure out if notification is needed | |||
| COMMENTS | VARCHAR2 | 256 | User comments such as reason for "RETURN" type of transfer order. | ||||
| LINE_CREATION_DATE | DATE | Who column: indicates the date of the creation of the line row. | |||||
| LINE_CREATION_TIMESTAMP | TIMESTAMP | Who column: indicates the date and time of the creation of the line row. | |||||
| INCL_NONRECOVERABLE_TAX | NUMBER | Included Unit Non-Recoverable Tax | |||||
| INCL_RECOVERABLE_TAX | NUMBER | This is the included unit recoverable tax. | |||||
| NONINCL_NONRECOVERABLE_TAX | NUMBER | Non-included Unit Non-Recoverable Tax | |||||
| NONINCL_RECOVERABLE_TAX | NUMBER | Non-included Unit Recoverable Tax | |||||
| CURRENCY_CODE | VARCHAR2 | 32 | Currency code. This is the Requesting Org's default currency, value supplied by SCO | ||||
| FIRM_STATUS | VARCHAR2 | 16 | Flag to indicate if the planning schedule is firmed. | ||||
| BACK_TO_BACK_FLAG | VARCHAR2 | 16 | To indicate whether a transfer order is a back-to-back transfer order. | ||||
| NOTE_TO_RECEIVER | VARCHAR2 | 999 | This column will store the note to receiver. | ||||
| NOTE_TO_SUPPLIER | VARCHAR2 | 999 | This column will store the note to supplier. | ||||
| SUPPLY_ORDER_REFERENCE_NUMBER | VARCHAR2 | 256 | Reference number of the requesting system | ||||
| SUPPLY_ORDER_REF_LINE_NUMBER | VARCHAR2 | 32 | Identifier of the source system that generated the interface record. Document Line reference number from the requesting system | ||||
| REQUISITION_ID | NUMBER | 38 | 0 | Reference to unique identifier of requisition number from which this Transfer Order was created | |||
| REQUISITION_LINE_ID | NUMBER | 38 | 0 | Reference to unique identifier of the requisition line number from which this Transfer order line was created | |||
| REQUISITION_NUMBER | VARCHAR2 | 64 | Backing Requisition number for the given transfer order | ||||
| REQUISITION_LINE_NUMBER | NUMBER | Backing Requisition Line number for the given transfer order | |||||
| RETURN_ORIGINAL_TO_ID | NUMBER | 38 | 0 | Reference to unique identifier for the original Transfer Order Number in case this Transfer Order is of type return | |||
| RETURN_ORIGINAL_TO_LINE_ID | NUMBER | 38 | 0 | Reference to unique identifier for the original Transfer Order Line in case this Transfer Order is of type return | |||
| RETURN_ORIGINAL_TO_NUMBER | VARCHAR2 | 64 | Original Transfer Order Number for Return Transfer order | ||||
| RETURN_ORIGINAL_TO_LINE_NUMBER | NUMBER | 38 | 0 | Original Transfer Order Line Number for Return Transfer order | |||
| DEST_ORG_BUSINESS_UNIT | NUMBER | 38 | 0 | Destination Organizations business unit | |||
| MATERIAL_MGMT_LEDGER_ID | NUMBER | 38 | 0 | Material management primary Ledger | |||
| MATERIAL_MGMT_PERIOD_SET_NAME | VARCHAR2 | 16 | Material management Fiscal Period Set Name | ||||
| MATERIAL_MGMT_PERIOD_TYPE | VARCHAR2 | 16 | Material management Fiscal Period Type | ||||
| MATERIAL_MGMT_PERIOD_NAME | VARCHAR2 | 64 | Material management Fiscal Period Name | ||||
| DEST_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 | Destination Organization Profit center business unit | |||
| SECONDARY_UOM_CONVERSION_FACTOR | NUMBER | Conversion factor between Primary to Secondary UOM | |||||
| UNIT_PRICE_PLUS_NONINCL_TAX | NUMBER | Addition of UNIT PRICE and NonInclusive Taxes for Unit | |||||
| UNIT_TOTAL_TAX | NUMBER | NonInclusive Taxes for Unit | |||||
| TRANSFER_PRICE | NUMBER | Price for Requested quantity | |||||
| TOTAL_TAX | NUMBER | Total NonInclusive tax at line based on requested quantity | |||||
| TOTAL_TRANSFER_PRICE | NUMBER | Total price of Transfer Order line | |||||
| SHIPPED_AMOUNT | NUMBER | Shipped amount for transfer order Line | |||||
| RECEIVED_AMOUNT | NUMBER | Received amount for transfer order line | |||||
| DELIVERED_AMOUNT | NUMBER | Delivered amount for transfer Order line | |||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Analytical Currency Code | ||||
| GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Requesting Org's default currency code to analytical exchange rate | |||||
| UNIT_PRICE_GLOBAL | NUMBER | Price per unit of item requested in global currency | |||||
| TRANSFER_PRICE_GLOBAL | NUMBER | Transfer price in global currency | |||||
| TOTAL_TAX_GLOBAL | NUMBER | Total tax in global currency | |||||
| TOTAL_TRANSFER_PRICE_GLOBAL | NUMBER | Total tranfer price in global currency | |||||
| SHIPPED_AMOUNT_GLOBAL | NUMBER | Shipped amount in global currency | |||||
| RECEIVED_AMOUNT_GLOBAL | NUMBER | Received amount in global currency | |||||
| DELIVERED_AMOUNT_GLOBAL | NUMBER | Delivered amount in global currency |
Copyright © 2019, 2025, Oracle and/or its affiliates.