This table captures transfer order distribution information. Transfer order disctributions are created when sourced from requisition.
Module: Inventory Management
TRANSFER_ORDER_DISTRIBUTION_ID
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 | 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 | 512 | 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 | 1024 | This column will store the note to receiver. | ||||
NOTE_TO_SUPPLIER | VARCHAR2 | 1024 | 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 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 |