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 | 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 | 512 | 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 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 | 1024 | This column will store the note to receiver. | ||||
NOTE_TO_SUPPLIER | VARCHAR2 | 1024 | 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 |