INV_TRANSFER_ORDERS_INT
A transfer orders serves as the orchestration document representing demand and supply for an internal material transfer. Automated or manual transfer requests of materials within and between two organizations within the same instance are supported via transfer orders. Transfer order object has header, line and distributions. This serves as an interface table to create transfer order headers and lines.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
INV_TRANSFER_ORDERS_INT_PK |
INTERFACE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_HEADER_ID | NUMBER | 18 | Transfer Order Interface Batch Identifier | ||
| INTERFACE_LINE_ID | NUMBER | 18 | Yes | Transfer Order Interface Unique Identifier | |
| TRANSFER_ORDER_HEADER_ID | NUMBER | 18 | Transfer Order Group Identifier | ||
| TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer Order Unique Identifier | ||
| TRANSFER_ORDER_HEADER_NUMBER | VARCHAR2 | 50 | This is the transfer order number. | ||
| TRANSFER_ORDER_LINE_NUMBER | VARCHAR2 | 50 | This is the transfer order line number. | ||
| PICK_COMPONENTS_FLAG | VARCHAR2 | 1 | Attribute indicating whether an item has a bill of material with options, classes, or included items picked from finished goods inventory | ||
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | 1 | Attribute indicating whether any configuration derived from this model can only be shipped when all required quantities of all configuration components options or included items are available. | ||
| SHIPPABLE_FLAG | VARCHAR2 | 1 | Attribute indicating whether to ship an item to a customer. | ||
| DESCRIPTION | VARCHAR2 | 240 | Translated description of transfer order | ||
| ORDERED_DATE | DATE | This is the date the order was created. | |||
| FULFILL_ORCHESTRATION_REQUIRED | VARCHAR2 | 1 | Indicates whether Transfer Order was interfaced to DOO | ||
| INTERFACE_STATUS_LOOKUP | VARCHAR2 | 30 | Meanings can be Awaiting Interface to DOO, Error, Awaiting Interface to Shipping, Interfaced to DOO, Interfaced to Shipping | ||
| SOURCE_INTERFACE_TXN_ID | NUMBER | 18 | Source Interface Transaction Identifier | ||
| SOURCE_TYPE_LOOKUP | VARCHAR2 | 30 | Source from where this order was requested. Eg. SSP/Planning/Return/Min-Max | ||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Reference to the unique identifier for the source organization. | ||
| SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 10 | Source organization subinventory name | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Reference to the unique identifier for the destination organization. | ||
| DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 10 | Destination organization subinventory name | ||
| DESTINATION_TYPE_LOOKUP | VARCHAR2 | 30 | Destination type, whether Inventory or Expense | ||
| DESTINATION_LOCATION_ID | NUMBER | 18 | Destination location (from hr_locations) | ||
| MATERIAL_RETURN_REQUIRED | VARCHAR2 | 1 | Indicates whether physical shipping is required for a return TO. | ||
| STATUS_LOOKUP | VARCHAR2 | 30 | Indicates whether line is OPEN/CLOSED/CANCELED | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | This identifies the inventory item. | ||
| ITEM_REVISION | VARCHAR2 | 18 | Item revision. (References EGP_ITEM_REVISIONS_VL.revision.) | ||
| NEED_BY_DATE | DATE | Date this transfer order line is requested for arrival | |||
| SCHEDULED_ARRIVAL_DATE | DATE | Date this transfer order is scheduled to arrive | |||
| SCHEDULED_SHIP_DATE | DATE | Date this transfer order is scheduled to ship | |||
| QTY_UOM_CODE | VARCHAR2 | 3 | The unit of measure code of the line quantity | ||
| REQUESTED_QTY | NUMBER | This is the quantity requested. | |||
| SECONDARY_QTY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure of line quantity | ||
| SECONDARY_REQUESTED_QTY | NUMBER | Quantity requested in secondary unit of measure | |||
| UNIT_PRICE | NUMBER | Price per unit of item requested | |||
| UNIT_TAX | NUMBER | This is tax per unit of item requested. | |||
| FREIGHT_CARRIER_ID | NUMBER | 18 | Reference to unique identification for carrier used on this line | ||
| MODE_OF_TRANSPORT_LOOKUP | VARCHAR2 | 30 | Mode of Transport for Ship Method | ||
| SERVICE_LEVEL_LOOKUP | VARCHAR2 | 30 | This is the service level for the shipping method. | ||
| SHIPMENT_PRIORITY_LOOKUP | VARCHAR2 | 30 | This lookup code indicates the shipment priority. | ||
| REQ_BU_ID | NUMBER | 18 | Business Unit for requesting organization | ||
| REQUISITION_ID | NUMBER | 18 | Reference to unique identifier of requisition number from which this Transfer Order was created | ||
| REQUISITION_LINE_ID | NUMBER | 18 | Reference to unique identifier of the requisition line number from which this Transfer order line was created | ||
| REQUESTER_ID | NUMBER | 18 | Reference to unique identifier of the requestor | ||
| PLANNER_ID | NUMBER | 18 | Reference to unique identifier of the planner | ||
| CHANGE_STATUS_LOOKUP | VARCHAR2 | 30 | Indicates whether there are changes on line for both approval required and non-approval required columns. This lookup is also used to track whether distribution related changes are pending on the distributions table. Any pending changes disallow updates to the Transfer Order. | ||
| CHANGE_REQUESTED_DATE | DATE | Date last change was requested on this Transfer Order line | |||
| CHANGE_APPROVAL_DATE | DATE | This column is not currently used. | |||
| CHANGE_PARTY_ID | NUMBER | 18 | 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 | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| COMMENTS | VARCHAR2 | 240 | User comments such as reason for "RETURN" type of transfer order. | ||
| INTERFACE_ERR_MSG_CODE | VARCHAR2 | 30 | This message code from FND_MESSAGES indicates the interface error. | ||
| INTERFACE_ERR_MSG_TEXT | VARCHAR2 | 2000 | This message text from FND_MESSAGES is the interface error text. | ||
| SOURCE_HEADER_ID | NUMBER | 18 | Reference back to supply header id | ||
| SOURCE_LINE_ID | NUMBER | 18 | Reference back to supply line id | ||
| ORIGINAL_HEADER_ID | NUMBER | 18 | Reference to unique identifier for the original Transfer Order Number in case this Transfer Order is of type 'Return' | ||
| ORIGINAL_LINE_ID | NUMBER | 18 | Reference to unique identifier for the original Transfer Order Line in case this Transfer Order is of type 'Return' | ||
| BUY_DEFAULT_TAX_COUNTRY | VARCHAR2 | 2 | Default taxation country code to buy. | ||
| BUY_FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction | ||
| BUY_THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction | ||
| BUY_FINAL_DISCHARGE_LOC_ID | NUMBER | 18 | The final discharge location identifier | ||
| BUY_DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document Fiscal Classification code | ||
| BUY_TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category code | ||
| BUY_USR_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification code | ||
| BUY_PRODUCT_FISC_CLASSIF | VARCHAR2 | 240 | Product fiscal classification code of the inventory item | ||
| BUY_PRODUCT_CATEGORY | VARCHAR2 | 240 | Product category code of the transaction line | ||
| BUY_INTEND_USE_CLASSIF_ID | NUMBER | 18 | Intended Use Classification Identifier | ||
| BUY_PRODUCT_TYPE | VARCHAR2 | 240 | Product type code of the inventory item. Possible values are GOODS and SERVICES | ||
| BUY_ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
| BUY_TAX_CLASSIF_CODE | VARCHAR2 | 50 | Tax classification code to buy. | ||
| SELL_DEFAULT_TAX_COUNTRY | VARCHAR2 | 2 | This is the default taxation country code. | ||
| SELL_FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction | ||
| SELL_THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction | ||
| SELL_FINAL_DISCHARGE_LOC_ID | NUMBER | 18 | The final discharge location identifier | ||
| SELL_DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document Fiscal Classification code | ||
| SELL_TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category code | ||
| SELL_USR_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification code | ||
| SELL_PRODUCT_FISC_CLASSIF | VARCHAR2 | 240 | Product fiscal classification code of the inventory item | ||
| SELL_PRODUCT_CATEGORY | VARCHAR2 | 240 | Product category code of the transaction line | ||
| SELL_INTEND_USE_CLASSIF_ID | NUMBER | 18 | Intended Use Classification Identifier | ||
| SELL_PRODUCT_TYPE | VARCHAR2 | 240 | Product type code of the inventory item. Possible values are GOODS and SERVICES | ||
| SELL_ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
| SELL_TAX_CLASSIF_CODE | VARCHAR2 | 50 | This is the tax classification code. | ||
| 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 | 15 | Currency code. This is the Requesting Org's default currency, value supplied by SCO | ||
| AGREEMENT_PTR_ID | NUMBER | 18 | FOS Primary Trade Relationship ID | ||
| FIRM_FLAG | VARCHAR2 | 1 | Flag to indicate if the planning schedule is firmed. | ||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 25 | Identifier for upstream integrating module. Reserved for internal use. | ||
| BACK_TO_BACK_FLAG | VARCHAR2 | 1 | Yes | To indicate whether a transfer order is a back-to-back transfer order. | |
| ORIGINAL_REQUEST_LINE_ID | NUMBER | 18 | Line ID from th original request such as a DOO fulfillment line ID in a back-to-back transaction. | ||
| PARENT_ITEM_ID | NUMBER | 18 | Parent Item Identifier for kit or PTO items | ||
| ACTION | VARCHAR2 | 10 | Action for the line. Valid values: CREATE, UPDATE, and CANCEL | ||
| BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2 | 1 | Flag to indicate that line is under budgetary control. | ||
| ACTION_SOURCE_TYPE | VARCHAR2 | 30 | Source type of the most recent action requested. | ||
| NOTE_TO_RECEIVER | VARCHAR2 | 1000 | This column will store the note to receiver. | ||
| NOTE_TO_SUPPLIER | VARCHAR2 | 1000 | This column will store the note to supplier. | ||
| REPRICE_FLAG | VARCHAR2 | 1 | Flag to indicate if a transfer order can be re-priced. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SUPPLY_ORDER_REFERENCE_NUMBER | VARCHAR2 | 200 | Reference number of the requesting system | ||
| SUPPLY_ORDER_REF_LINE_NUMBER | VARCHAR2 | 20 | Identifier of the source system that generated the interface record. Document Line reference number from the requesting system | ||
| ALLOW_ITEM_SUBSTITUTION_FLAG | VARCHAR2 | 1 | Indicates whether shipping substitute items is allowed |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| inv_trans_order_dist_int | inv_transfer_orders_int | INTERFACE_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_TRANSFER_ORDERS_INT_U1 | Unique | Default | INTERFACE_LINE_ID |