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