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     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, 2023, Oracle and/or its affiliates.