# DW_INV_TRANSFER_ORDER_DIST_CF

This table captures transfer order distribution information. Transfer order disctributions are created when sourced from requisition.

## Details

Module: Inventory Management

## Key Columns

TRANSFER_ORDER_DISTRIBUTION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
TRANSFER_ORDER_DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Transfer Order distribution Unique Identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Derived column |  |
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 |  |
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_ID | NUMBER | 38 | 0 |  | Transfer Order Line Unique Identifier |  |
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 |  |
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. References EGP_ITEM_REVISIONS_VL.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 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 |  |
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 | 32 |  |  | 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 |  |
DISTRIBUTION_NUMBER | NUMBER |  |  |  | Transfer order distribution number |  |
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 |  | Primary Ledger unique identifier for the charge account |  |
CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Unique identifier for the General Ledger charge account |  |
DISTRIBUTION_QTY | NUMBER |  |  |  | This is quantity for the distribution. |  |
DISTRIBUTION_DELIVERED_QTY | NUMBER |  |  |  | Quantity delivered on this distribution |  |
PERCENT | NUMBER |  |  |  | This is the allocation split value. |  |
DISTRIBUTION_AMOUNT | NUMBER |  |  |  | Amount on the transfer order line |  |
RECOVERABLE_TAX | NUMBER |  |  |  | This is the amount of recoverable tax. |  |
NONRECOVERABLE_TAX | NUMBER |  |  |  | This is the amount of non-recoverable tax. |  |
DISTRIBUTION_CREATION_DATE | DATE |  |  |  | Who column: indicates the date of the creation of the row. |  |
DISTRIBUTION_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
PJC_PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions |  |
PJC_TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions |  |
PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions |  |
PJC_EXPENDITURE_ITEM_DATE | DATE |  |  |  | Date on which project-related transaction is incurred |  |
PJC_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions |  |
FUNDS_STATUS | VARCHAR2 | 64 |  |  | Budgetary control funds status of the distribution. |  |
BUDGET_DATE | DATE |  |  |  | Budgetary control budget date of the distribution. |  |
REQ_DISTRIBUTION_ID | NUMBER | 38 | 0 |  | Source Requisition Distribution Id |  |
SECONDARY_UOM_CONVERSION_FACTOR | NUMBER |  |  |  | Conversion factor between Primary to Secondary UOM |  |
SECONDARY_DISTRIBUTION_QTY | NUMBER |  |  |  | This is quantity for the distribution in secondary unit of measure. |  |
SECONDARY_DIST_DELIVERED_QTY | NUMBER |  |  |  | Quantity delivered on this distribution in secondary unit of measure. |  |
DISTRIBUTION_AMOUNT_GLOBAL | NUMBER |  |  |  | Distribution amount in global currency |  |
RECOVERABLE_TAX_GLOBAL | NUMBER |  |  |  | Recoverable tax amount in global currency |  |
NONRECOVERABLE_TAX_GLOBAL | NUMBER |  |  |  | Non Recoverable tax amount in global currency |  |
COST_CENTER_SEGMENT | VARCHAR2 | 32 |  |  | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 |  |  | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT | VARCHAR2 | 32 |  |  | Balancing segment. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 |  |  | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE

Copyright © 2019, 2026, Oracle and/or its affiliates.