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