# DW_INV_TRANSFER_ORDER_CF

This table captures transfer order line level information. Transfer orders serves as the orchestration document representing demand and supply for an internal material transfer.

## Details

Module: Inventory Management

## Key Columns

TRANSFER_ORDER_LINE_ID

## Columns

Columns
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.