INV_TRANSFER_ORDER_LINES
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 is the Transfer Order lines table.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
INV_TRANSFER_ORDER_LINES_PK |
LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LINE_ID | NUMBER | 18 | Yes | Transfer Order Line Unique Identifier | |
PARENT_LINE_ID | NUMBER | 18 | Used in transfer order line hierarchies (models) to identify the immediate parent transfer order line. | ||
ROOT_PARENT_LINE_ID | NUMBER | 18 | Used in transfer order line hierarchies (models) to identify the highest transfer order line in the hierarchy. | ||
ITEM_SUB_TYPE_CODE | VARCHAR2 | 30 | Item characteristic detail (like KIT, INCLUDED). | ||
QUANTITY_PER_MODEL | NUMBER | Component quantity for a single model. | |||
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 | ||
SHIPPABLE_FLAG | VARCHAR2 | 1 | Attribute indicating whether to ship an item to a customer. | ||
DISPLAY_LINE_NUMBER | VARCHAR2 | 100 | Display Line Number Unique Identifier | ||
LINE_NUMBER | NUMBER | 9 | Yes | This is the transfer order line number. | |
HEADER_ID | NUMBER | 18 | Yes | Reference to Transfer Order Header Unique Identifier. | |
INTERFACE_STATUS_LOOKUP | VARCHAR2 | 30 | Meanings can be Awaiting Interface to DOO, Error, Awaiting Interface to Shipping, Interfaced to DOO, Interfaced to Shipping | ||
SOURCE_TYPE_LOOKUP | VARCHAR2 | 30 | Yes | Source from where this order was requested. Eg. SSP/Planning/Return/Min-Max | |
SOURCE_ORGANIZATION_ID | NUMBER | 18 | Yes | Reference to the unique identifier for the source organization. | |
PROPOSED_SOURCE_ORG_ID | NUMBER | 18 | Proposed source organization Id | ||
SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 10 | Source organization subinventory name | ||
PROPOSED_SOURCE_SUB_CODE | VARCHAR2 | 10 | Proposed source subinventory code | ||
DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Yes | Reference to the unique identifier for the destination organization. | |
DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 10 | Destination organization subinventory name | ||
PROPOSED_DEST_SUB_CODE | VARCHAR2 | 10 | Proposed destination organization subinventory name | ||
DESTINATION_TYPE_LOOKUP | VARCHAR2 | 30 | Yes | Destination type, whether Inventory or Expense | |
DESTINATION_LOCATION_ID | NUMBER | 18 | Destination location (from hr_locations) | ||
PROPOSED_DEST_LOCATION_ID | NUMBER | 18 | Proposed destination location (from hr_locations) | ||
MATERIAL_RETURN_REQUIRED | VARCHAR2 | 1 | Indicates whether physical shipping is required for a return TO. | ||
STATUS_LOOKUP | VARCHAR2 | 30 | Yes | Indicates whether line is OPEN/CLOSED/CANCELLED | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
ITEM_REVISION | VARCHAR2 | 18 | Item revision. (References EGP_ITEM_REVISIONS_VL.revision.) | ||
NEED_BY_DATE | DATE | Yes | 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 | |||
PROPOSED_NEED_BY_DATE | DATE | Date to support change management on the requested date of arrival | |||
QTY_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code of the line quantity | |
REQUESTED_QTY | NUMBER | Yes | 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 | |||
PROPOSED_REQUESTED_QTY | NUMBER | Quantity to support change management on the requested quantity | |||
SECONDARY_QTY_UOM_CODE | VARCHAR2 | 3 | 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 | |||
PROPOSED_SEC_REQUESTED_QTY | NUMBER | Quantity to support change management on the requested quantity in the secondary unit of measure | |||
UNIT_PRICE | NUMBER | Price per unit of item requested | |||
PROPOSED_UNIT_PRICE | NUMBER | This is the proposed unit price. | |||
UNIT_TAX | NUMBER | This column is not currently used. | |||
PROPOSED_UNIT_TAX | NUMBER | This column is not currently used. | |||
FREIGHT_CARRIER_ID | NUMBER | 18 | Reference to unique identification for carrier used on this line | ||
PROPOSED_CARRIER_ID | NUMBER | 18 | This identifies the proposed shipping carrier. | ||
MODE_OF_TRANSPORT_LOOKUP | VARCHAR2 | 30 | Mode of Transport for Ship Method | ||
PROPOSED_MODE_OF_TRANSPORT | VARCHAR2 | 30 | Proposed mode of transport lookup | ||
SERVICE_LEVEL_LOOKUP | VARCHAR2 | 30 | This is the service level for the shipping method. | ||
PROPOSED_SERVICE_LEVEL | VARCHAR2 | 30 | This is the proposed service level. | ||
SHIPMENT_PRIORITY_LOOKUP | VARCHAR2 | 30 | This lookup code indicates the shipment priority. | ||
PROPOSED_SHIPMENT_PRIORITY | VARCHAR2 | 30 | Proposed shipment priority lookup | ||
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??? | ||
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 | ||
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. | ||
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 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | 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. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
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. | |||
COMMENTS | VARCHAR2 | 240 | User comments such as reason for "RETURN" type of transfer order. | ||
SOURCE_HEADER_ID | NUMBER | 18 | Yes | Reference back to supply header id | |
SOURCE_LINE_ID | NUMBER | 18 | Yes | Reference back to supply line id | |
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 | ||
PROPOSED_BUY_DEF_TAX_CNTRY | VARCHAR2 | 2 | Proposed default taxation country code | ||
PROPOSED_BUY_1_PTY_REG_ID | NUMBER | 18 | Proposed first Party Tax Registration ID for the transaction | ||
PROPOSED_BUY_3_PTY_REG_ID | NUMBER | 18 | Proposed third Party Tax Registration ID for the transaction | ||
PROPOSED_BUY_FNL_DIS_LOCID | NUMBER | 18 | Proposed final discharge location identifier | ||
PROPOSED_BUY_DOC_SUB_TYPE | VARCHAR2 | 240 | Proposed document Fiscal Classification code | ||
PROPOSED_BUY_TRX_BUS_CAT | VARCHAR2 | 240 | Proposed transaction business category code | ||
PROPOSED_BUY_USR_DF_FS_CLS | VARCHAR2 | 30 | Proposed user defined fiscal classification code | ||
PROPOSED_BUY_PROD_FS_CLSIF | VARCHAR2 | 240 | Proposed product fiscal classification code of the inventory item | ||
PROPOSED_BUY_PROD_CAT | VARCHAR2 | 240 | Proposed product category code of the transaction line | ||
PROPOSED_BUY_INUSE_CLSIFID | NUMBER | 18 | Proposed intended Use Classification Identifier | ||
PROPOSED_BUY_PRODUCT_TYPE | VARCHAR2 | 240 | Proposed product type code of the inventory item. Possible values are GOODS and SERVICES | ||
PROPOSED_BUY_ASSESS_VALUE | NUMBER | Proposed assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
PROPOSED_BUY_TAX_CLSIF_CD | VARCHAR2 | 50 | Proposed tax Classification Code | ||
PROPOSED_SELL_DEF_TAX_CNTRY | VARCHAR2 | 2 | Proposed default taxation country code | ||
PROPOSED_SELL_1_PTY_REG_ID | NUMBER | 18 | Proposed first Party Tax Registration ID for the transaction | ||
PROPOSED_SELL_3_PTY_REG_ID | NUMBER | 18 | Proposed third Party Tax Registration ID for the transaction | ||
PROPOSED_SELL_FNL_DIS_LOCID | NUMBER | 18 | Proposed final discharge location identifier | ||
PROPOSED_SELL_DOC_SUB_TYPE | VARCHAR2 | 240 | Proposed document Fiscal Classification code | ||
PROPOSED_SELL_TRX_BUS_CAT | VARCHAR2 | 240 | Proposed transaction business category code | ||
PROPOSED_SELL_USR_DF_FS_CLS | VARCHAR2 | 30 | Proposed user defined fiscal classification code | ||
PROPOSED_SELL_PROD_FS_CLSIF | VARCHAR2 | 240 | Proposed product fiscal classification code of the inventory item | ||
PROPOSED_SELL_PROD_CAT | VARCHAR2 | 240 | Proposed product category code of the transaction line | ||
PROPOSED_SELL_INUSE_CLSIFID | NUMBER | 18 | Proposed intended Use Classification Identifier | ||
PROPOSED_SELL_PRODUCT_TYPE | VARCHAR2 | 240 | Proposed product type code of the inventory item. Possible values are GOODS and SERVICES | ||
PROPOSED_SELL_ASSESS_VALUE | NUMBER | Proposed assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
PROPOSED_SELL_TAX_CLSIF_CD | VARCHAR2 | 50 | Proposed tax Classification Code | ||
PROPOSED_INCL_NONRECV_TAX | NUMBER | Proposed included Unit Non-Recoverable Tax | |||
PROPOSED_INCL_RECOV_TAX | NUMBER | Proposed included Unit Recoverable Tax | |||
PROPOSED_NONINC_NONRECV_TAX | NUMBER | Proposed non-included Unit Non-Recoverable Tax | |||
PROPOSED_NONINC_RECOV_TAX | NUMBER | Proposed non-included Unit Recoverable Tax | |||
PROPOSED_AGREEMENT_PTR_ID | NUMBER | 18 | Proposed FOS Primary Trade Relationship ID | ||
IS_PROPOSED_PENDING | VARCHAR2 | 1 | Flag to indicate whether there are changes waiting to be applied. | ||
PROPOSED_SCHED_SHIP_DATE | DATE | Proposed date this transfer order is scheduled to ship | |||
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 | ||
PROPOSED_ERR_MSG_TEXT | VARCHAR2 | 2000 | Temporarily stores the errors received from other processes, eg. the tax call, before being moved to attribute interface_err_msg_text | ||
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. | ||
PROPOSED_NOTE_TO_SUPPLIER | VARCHAR2 | 1000 | This column will store the proposed note to supplier. | ||
REPRICE_FLAG | VARCHAR2 | 1 | Flag to indicate if a transfer order can be re-priced. | ||
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 | ||
ITEM_SUBSTITUTED_FLAG | VARCHAR2 | 1 | Indicates whether the item got substituted | ||
PROPOSED_ALLOW_ITEM_SUB_FLAG | VARCHAR2 | 1 | This column will store the proposed value of whether shipping substitute items is allowed. | ||
MAX_COMP_SHIPPED_QTY | NUMBER | This column stores maximum shipped quantity for the kit component. | |||
CONSUMED_REQUESTED_QTY | NUMBER | The requested quantity consumed when a shipping tolerance exists. | |||
INITIAL_REQUESTED_QTY | NUMBER | The requested quantity when the transfer order line was first created. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
INV_TRANSFER_ORDER_LINES | inv_transfer_order_headers | HEADER_ID |
inv_transfer_order_distribs | inv_transfer_order_lines | LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
INV_TRANSFER_ORDER_LINES_N1 | Non Unique | Default | SOURCE_ORGANIZATION_ID, STATUS_LOOKUP, UPPER("SUPPLY_ORDER_REFERENCE_NUMBER") |
INV_TRANSFER_ORDER_LINES_N2 | Non Unique | Default | DESTINATION_ORGANIZATION_ID, STATUS_LOOKUP, UPPER("SUPPLY_ORDER_REFERENCE_NUMBER") |
INV_TRANSFER_ORDER_LINES_N3 | Non Unique | Default | ROOT_PARENT_LINE_ID |
INV_TRANSFER_ORDER_LINES_N4 | Non Unique | Default | SOURCE_LINE_ID, LINE_ID |
INV_TRANSFER_ORDER_LINES_U1 | Unique | Default | LINE_ID |
INV_TRANSFER_ORDER_LINES_U2 | Unique | Default | HEADER_ID, LINE_NUMBER |
INV_TRANSFER_ORDER_LINES_U3 | Unique | Default | SOURCE_TYPE_LOOKUP, SOURCE_HEADER_ID, SOURCE_LINE_ID |