INV_TXN_REQUEST_LINES
The table INV_TXN_REQUEST_LINES stores all of the move order lines. The lines are requests to move some quantity of an item from a source location to a destination location or account. Each move order line must be tied to a specific move order header. When a line is detailed or pick released, the quantity detailed is updated appropriately and transaction lines are created in INV_MATERIAL_TXNS_TEMP. When the transaction lines are transacted, the quantity delivered is updated.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
INV_TXN_REQUEST_LINES_PK |
LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
---|---|---|---|---|---|---|---|
HEADER_ID | NUMBER | 18 | Yes | This identifies the movement request. | Active | ||
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. | Active | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | Active | |||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | Active | |||
LINE_NUMBER | NUMBER | 18 | Yes | This is the movement request line number. | Active | ||
ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | Active | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | Active | ||
REVISION | VARCHAR2 | 18 | Revision of item if under revision control. | Active | |||
FROM_SUBINVENTORY_ID | NUMBER | 18 | This column is not currently used. | Active | |||
FROM_SUBINVENTORY_CODE | VARCHAR2 | 10 | This indicates the subinventory to transact from. | Active | |||
FROM_LOCATOR_ID | NUMBER | 18 | This indicates the original locator. | Active | |||
TO_SUBINVENTORY_CODE | VARCHAR2 | 10 | Name of the subinventory to transact to. | Active | |||
TO_SUBINVENTORY_ID | NUMBER | 18 | Identifier of the subinventory. Not currently used. | Active | |||
TO_LOCATOR_ID | NUMBER | 18 | Identifies the locator to transact to. | Active | |||
TO_ACCOUNT_ID | NUMBER | 18 | Identifies the account to transact to. | Active | |||
LOT_NUMBER | VARCHAR2 | 80 | This number identifies an inventory lot. | Active | |||
SERIAL_NUMBER_START | VARCHAR2 | 80 | This is the first unit number in range. | Active | |||
SERIAL_NUMBER_END | VARCHAR2 | 80 | This is the last unit number in range. | Active | |||
UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the unit of measure for quantities. | Active | ||
QUANTITY | NUMBER | Yes | This is the quantity requested. | Active | |||
QUANTITY_DELIVERED | NUMBER | Quantity which has been delivered | Active | ||||
QUANTITY_DETAILED | NUMBER | Quantity which has a detailed sourcing location | Active | ||||
DATE_REQUIRED | DATE | Yes | This is the date when this is required. | Active | |||
REQUESTER_ID | NUMBER | 18 | Reference to unique identifier of the requester. | ||||
REASON_ID | NUMBER | 18 | This identifies the transaction reason. | Active | |||
REFERENCE_NAME | VARCHAR2 | 240 | Move order creator reference name | Active | |||
REFERENCE_TYPE_CODE | NUMBER | 18 | This code indicates the movement request creator. | Active | |||
REFERENCE_ID | NUMBER | 18 | This identifies the movement request creator. | Active | |||
TRANSACTION_HEADER_ID | NUMBER | 18 | This identifies the transaction group and workers. | Active | |||
LINE_STATUS | NUMBER | 18 | Yes | This is the status of the movement request line. | Active | ||
STATUS_DATE | DATE | Yes | The date when the status was last changed. | Active | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
LINE_ID | NUMBER | 18 | Yes | Primary key of the movement request line. | Active | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transfer Order Lines (INV_TXN_REQUEST_LINES) | Active | ||
TXN_SOURCE_ID | NUMBER | 18 | This identifies the transaction source. | Active | |||
TXN_SOURCE_LINE_ID | NUMBER | 18 | Transaction source line identifier | Active | |||
TXN_SOURCE_LINE_DETAIL_ID | NUMBER | 18 | Transaction source line detail identifier | Active | |||
TRANSACTION_TYPE_ID | NUMBER | 18 | Yes | Identifies the transaction type. | Active | ||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | 18 | Transaction source type identifier | Active | |||
PRIMARY_QUANTITY | NUMBER | Quantity requested, in primary unit of measure | Active | ||||
TO_ORGANIZATION_ID | NUMBER | 18 | Identifies the destination organization. | Active | |||
PUT_AWAY_STRATEGY_ID | NUMBER | 18 | Put Away strategy identifier - used by WMS only | Active | |||
PICK_STRATEGY_ID | NUMBER | 18 | Picking strategy identifier - used by WMS only | Active | |||
SHIP_TO_LOCATION_ID | NUMBER | 18 | This identifies the ship-to location. | Active | |||
REFERENCE_DETAIL_ID | NUMBER | 18 | This identifies the reference detail. | Active | |||
ASSIGNMENT_ID | NUMBER | 18 | This identifies the assignment. | Active | |||
UNIT_NUMBER | VARCHAR2 | 30 | This column is the unit number. | Active | |||
FROM_COST_GROUP_ID | NUMBER | 18 | From Cost Group Identifier - used by WMS only | Active | |||
TO_COST_GROUP_ID | NUMBER | 18 | To Cost Group Identifier - used by WMS only | Active | |||
LPN_ID | NUMBER | 18 | License Plate Number Identifier - used by WMS only | Active | |||
TO_LPN_ID | NUMBER | 18 | Transfer License Plate Number Identifier - used by WMS only | Active | |||
INSPECTION_STATUS | NUMBER | 18 | Status after inspection of the movement request line. | Active | |||
PICK_METHODOLOGY_ID | NUMBER | 18 | This identifies the pick methodology. | Active | |||
CONTAINER_ITEM_ID | NUMBER | 18 | Container Item Id - used by WMS only | Active | |||
CARTON_GROUPING_ID | NUMBER | 18 | Carton Grouping Id - used by WMS only | Active | |||
BACKORDER_DELIVERY_DETAIL_ID | NUMBER | 18 | The delivery detail Id for the backorder lines | Active | |||
WMS_PROCESS_FLAG | NUMBER | 18 | Flag to indicate processing status for putaways. 1 means Ok to process,2 means Do not Allocate, 3 means Allocate but do not process. To be used by Receiving and WIP | Active | |||
PICK_SLIP_NUMBER | NUMBER | 18 | Pick slip number for this movement request line. | Active | |||
PICK_SLIP_DATE | DATE | This column is the date of pick slip. | Active | ||||
SHIP_SET_ID | NUMBER | 18 | This column identifies the ship set. | Active | |||
SHIP_MODEL_ID | NUMBER | 18 | This identifies the ship model. | Active | |||
MODEL_QUANTITY | NUMBER | Quantity of the Top Model for Ship Model Complete items | Active | ||||
CROSSDOCK_TYPE | NUMBER | 18 | This indicates the cross dock type. | Active | |||
REQUIRED_QUANTITY | NUMBER | Required quantity for the sales order | Active | ||||
GRADE_CODE | VARCHAR2 | 150 | This is the grade code for movement request line. | Active | |||
SECONDARY_QUANTITY | NUMBER | Secondary Quantity for Move Order Line | Active | ||||
SECONDARY_QUANTITY_DELIVERED | NUMBER | Secondary Quantity Delivered for Move Order Line | Active | ||||
SECONDARY_QUANTITY_DETAILED | NUMBER | Secondary Quantity Detailed for Move Order Line | Active | ||||
SECONDARY_REQUIRED_QUANTITY | NUMBER | Secondary Required Quantity for Move Order Line | Active | ||||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary Unit of Measure for Move Order Line | Active | |||
WIP_ENTITY_ID | NUMBER | 18 | Identifies the WIP entity in WIP_ENTITIES table. | Active | |||
REPETITIVE_SCHEDULE_ID | NUMBER | 18 | This identifies the repetitive schedule. | Active | |||
OPERATION_SEQ_NUM | NUMBER | 18 | Operation sequence number within a routing. | Active | |||
WIP_SUPPLY_TYPE | NUMBER | 18 | WIP supply type describes the consumption method. | Active | |||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | DFF Context Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_PROJECT_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget - This was renamed from PROJECT_ID | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_TASK_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget - This was renamed from TASK_ID | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_EXPENDITURE_ITEM_DATE | DATE | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | |||
PJC_EXPENDITURE_ORG_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Active | |||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_WORK_TYPE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_CONTRACT_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Active | |||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Active | |||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Active | |||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
SHIP_SET_NAME | VARCHAR2 | 150 | This is the name of the ship set. | Active | |||
PJC_ORGANIZATION_ID | NUMBER | 18 | DFF Context Column used by Standardized Project Cost Collection Widget | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | Active | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE20 | 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. | |||||
INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||||
PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | ||||
TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | ||||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||||
INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||||
INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||||
INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
BACKORDER_SHORTPICK_QTY | NUMBER | Quantity back ordered or short picked for a pick wave type of movement request line. | |||||
BACKORDER_SHORTPICK_SEC_QTY | NUMBER | Secondary quantity back ordered or short picked for a pick wave type of movement request line. | |||||
ALLOW_ITEM_SUBSTITUTION_FLAG | VARCHAR2 | 1 | Indicates whether shipping substitute items is allowed | ||||
ORIGINAL_ITEM_ID | NUMBER | 18 | Ordered item from the source system | ||||
EXT_SYS_GROUP_ID | NUMBER | 18 | A unique identifier to mark movement request lines that need to be interfaced to an external warehouse management system. | ||||
EXT_SYSTEM_REQUESTED_QTY | NUMBER | This column will be updated with the requested quantity interfaced to the external system. The quantity is in the UOM for the movement request line. For now used for only shop floor type of movement request. | |||||
EXT_SYSTEM_REQ_QTY_IN_PUOM | NUMBER | This column will be updated with the requested quantity interfaced to the external system in the primary UOM. For now used for only shop floor type of movement request. | |||||
EXT_SYSTEM_ALLOCATED_QTY | NUMBER | This column will be updated with the quantity allocated by the external system for the movement request interfaced to them. The quantity is in the UOM for the movement request line. For now used for only shop floor type of movement request. | |||||
EXT_SYSTEM_CANCELLED_QTY | NUMBER | This column will be updated with the quantity cancelled by the external system for the movement request interfaced to them. The quantity is in the UOM for the movement request line. For now used for only shop floor type of movement request. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
INV_TXN_REQUEST_LINES | inv_txn_request_headers | HEADER_ID |
INV_TXN_REQUEST_LINES | inv_serial_numbers | ORGANIZATION_ID, SERIAL_NUMBER_START, INVENTORY_ITEM_ID |
INV_TXN_REQUEST_LINES | inv_serial_numbers | ORGANIZATION_ID, SERIAL_NUMBER_END, INVENTORY_ITEM_ID |
INV_TXN_REQUEST_LINES | inv_transaction_reasons_b | REASON_ID |
INV_TXN_REQUEST_LINES | gl_code_combinations | TO_ACCOUNT_ID |
INV_TXN_REQUEST_LINES | inv_org_parameters | TO_ORGANIZATION_ID |
INV_TXN_REQUEST_LINES | inv_transaction_types_b | TRANSACTION_TYPE_ID |
INV_TXN_REQUEST_LINES | inv_txn_source_types_b | TRANSACTION_SOURCE_TYPE_ID |
INV_TXN_REQUEST_LINES | inv_org_parameters | ORGANIZATION_ID |
INV_TXN_REQUEST_LINES | egp_item_org_associations | INVENTORY_ITEM_ID, ORGANIZATION_ID |
INV_TXN_REQUEST_LINES | inv_secondary_inventories | FROM_SUBINVENTORY_CODE, ORGANIZATION_ID |
INV_TXN_REQUEST_LINES | inv_secondary_inventories | TO_SUBINVENTORY_CODE, ORGANIZATION_ID |
INV_TXN_REQUEST_LINES | inv_lot_numbers | INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER |
inv_material_txns_temp | inv_txn_request_lines | MOVE_ORDER_LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
INV_TXN_REQUEST_LINES_N10 | Non Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, ORGANIZATION_ID, LINE_STATUS |
INV_TXN_REQUEST_LINES_N11 | Non Unique | FUSION_TS_TX_IDX | EXT_SYS_GROUP_ID |
INV_TXN_REQUEST_LINES_N2 | Non Unique | FUSION_TS_TX_IDX | ORGANIZATION_ID, LINE_STATUS, FROM_SUBINVENTORY_CODE, TO_SUBINVENTORY_CODE |
INV_TXN_REQUEST_LINES_N4 | Non Unique | FUSION_TS_TX_IDX | TRANSACTION_TYPE_ID, TRANSACTION_SOURCE_TYPE_ID, TXN_SOURCE_ID |
INV_TXN_REQUEST_LINES_N5 | Non Unique | FUSION_TS_TX_IDX | PICK_SLIP_NUMBER |
INV_TXN_REQUEST_LINES_N6 | Non Unique | FUSION_TS_TX_IDX | BACKORDER_DELIVERY_DETAIL_ID |
INV_TXN_REQUEST_LINES_N7 | Non Unique | FUSION_TS_TX_IDX | LPN_ID |
INV_TXN_REQUEST_LINES_N9 | Non Unique | FUSION_TS_TX_IDX | WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID |
INV_TXN_REQUEST_LINES_U1 | Unique | FUSION_TS_TX_IDX | LINE_ID |
INV_TXN_REQUEST_LINES_U2 | Unique | FUSION_TS_TX_IDX | HEADER_ID, LINE_NUMBER |
INV_TXN_REQUEST_LINES_U3 | Unique | FUSION_TS_TX_DATA | LINE_ID, HEADER_ID, DATE_REQUIRED |