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