1. Tables and Views for SCM
  2. INV_MATERIAL_TXNS_TEMP

INV_MATERIAL_TXNS_TEMP

INV_MATERIAL_TXNS_TEMP is the gateway for all material transactions. . . . Records are processed from this table into Inventory through the transaction processor. All Inventory transaction forms write directly to this table. Outside applications must write transaction records to INV_TRANSACTIONS_INTERFACE to be processed through INV_MATERIAL_TXNS_TEMP and the transaction processor by the Transaction Worker concurrent program. . . . Lots and serial numbers for a INV_MATERIAL_TXNS_TEMP(MMTT) record are stored in the tables INV_TRANSACTION_LOTS_TEMP(MTLT) and INV_SERIAL_NUMBERS_TEMP(MSNT). If the item is under lot control, then MMTT.TRANSACTION_TEMP_ID joins to MTLT.TRANSACTION_TEMP_ID. If the item is also under serial number control, then MTLT.SERIAL_TRANSACTION_TEMP_ID joins to MSNT.TRANSACTION_TEMP_ID. If the item is only under serial number control, then MMTT.TRANSACTION_TEMP_ID joins to MSNT.TRANSACTION_TEMP_ID. . . . Transfer transactions are stored in this table as a single record. The transaction processor creates two transactions from the single record. . .

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_MATERIAL_TXNS_TEMP_PK

TRANSACTION_TEMP_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
TRANSACTION_HEADER_ID NUMBER 18 This identifies the transaction group. Active
REPAIR_TXN_CODE_ID NUMBER 18 Foreign key reference to CSE condition events.
TRANSACTION_TEMP_ID NUMBER 18 Yes Transaction line identifier used to join to lot or serial table when under these controls Active
SOURCE_CODE VARCHAR2 30 User-entered source code for outside transactions. Active
SOURCE_LINE_ID NUMBER 18 User entered source line identifier for outside transactions. Active
TRANSACTION_MODE VARCHAR2 30 This code indicates the processing mode: 1=online; 2=immediate concurrent; and 3=batch. Active
LOCK_FLAG VARCHAR2 1 Row lock flag used by Transaction Manager Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated 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
INVENTORY_ITEM_ID NUMBER 18 Yes This identifies the inventory item. Active
REVISION VARCHAR2 18 Revision of item if under revision control. Active
ORGANIZATION_ID NUMBER 18 Yes This identifies the inventory organization. Active
SUBINVENTORY_CODE VARCHAR2 10 This is name of the subinventory. Active
LOCATOR_ID NUMBER 18 This identifies the item locator. Active
TRANSACTION_QUANTITY NUMBER Yes Quantity entered at transaction time Active
PRIMARY_QUANTITY NUMBER Yes Transaction quantity in terms of the primary uom of the item Active
TRANSACTION_UOM VARCHAR2 3 Yes UOM used at the time of transaction Active
TRANSACTION_COST NUMBER Transaction cost; this is a per-unit value. Active
TRANSACTION_TYPE_ID NUMBER 18 Yes Identifies the transaction type. Active
TRANSACTION_ACTION_ID VARCHAR2 30 Yes Identifies the transaction action. Active
TRANSACTION_SOURCE_TYPE_ID NUMBER 18 Yes Transaction source type identifier Active
TRANSACTION_SOURCE_ID NUMBER 18 This identifies the transaction source record. Active
TRANSACTION_SOURCE_NAME VARCHAR2 120 Name of the transaction source. Transaction source (INV_TRANSACTION_SOURCES) Active
TRANSACTION_DATE DATE Yes This is the date when the transaction was processed. Active
DISTRIBUTION_ACCOUNT_ID NUMBER 18 Account identifier the transaction charged to Active
TRANSACTION_REFERENCE VARCHAR2 240 This code is the transaction reference. Transaction source (INV_TRANSACTION_SOURCES) Active
REQUESTER_ID NUMBER 18 Reference to unique identifier of the requester.
REASON_ID NUMBER 18 This identifies the transaction reason. Active
LOT_NUMBER VARCHAR2 80 This number identifies an inventory lot. Active
LOT_EXPIRATION_DATE DATE This is the lot expiration date. Active
SERIAL_NUMBER VARCHAR2 80 This stores the item unit number. Active
RECEIVING_DOCUMENT VARCHAR2 10 This indicates the receiving document. Active
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier Active
MOVE_TRANSACTION_ID NUMBER 18 Move transaction identifier. Currently redundant for Fusion Manufacturing transactions as no longer needed for Costing. Active
COMPLETION_TRANSACTION_ID NUMBER 18 Completion transaction identifier. Currently redundant for Fusion Manufacturing transactions as no longer needed for Costing. Active
WIP_ENTITY_TYPE VARCHAR2 30 This indicates the WIP entity type. Active
SCHEDULE_ID NUMBER 18 WIP repetitive schedule identifier Active
REPETITIVE_LINE_ID NUMBER 18 This identifies the repetitive line. Active
EMPLOYEE_CODE VARCHAR2 10 This code indicates the employee. Active
SCHEDULE_UPDATE_CODE NUMBER 18 This code indicates whether or not to update the master production schedule. Active
SETUP_TEARDOWN_CODE NUMBER 18 This code indicates the setup teardown. Active
ITEM_ORDERING NUMBER 18 This column sets the item ordering. Active
NEGATIVE_REQ_FLAG NUMBER 18 Flag controls negative requirement. Active
OPERATION_SEQ_NUM NUMBER 18 Operation sequence number within a routing Active
PICKING_LINE_ID NUMBER 18 This identifies the picking line. Active
TRX_SOURCE_LINE_ID NUMBER 18 Line level transaction source identifier Active
TRX_SOURCE_DELIVERY_ID NUMBER 18 Delivery level transaction source identifier Active
PHYSICAL_ADJUSTMENT_ID NUMBER 18 This identifies the physical adjustment. Active
CYCLE_COUNT_ID NUMBER 18 This identifies the cycle count. Active
RMA_LINE_ID NUMBER 18 Identifies the return material authorization line. Active
CUSTOMER_SHIP_ID NUMBER 18 Identifies the customer ship-to address for sales orders. Active
CURRENCY_CODE VARCHAR2 10 This indicates the currency to use. Active
CURRENCY_CONVERSION_RATE NUMBER This column sets the currency conversion rate. Active
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Indicates the type of currency conversion. Active
CURRENCY_CONVERSION_DATE DATE This column sets the currency conversion date. Active
USSGL_TRANSACTION_CODE VARCHAR2 30 This is the USSGL transaction code. Active
VENDOR_LOT_NUMBER VARCHAR2 30 This is the supplier lot number. Active
LOCATION_TYPE VARCHAR2 30 Location Type identifier which qualifies the Ship to Location. Active
SHIP_TO_LOCATION NUMBER 18 This identifies the ship-to location. Active
SHIPMENT_NUMBER VARCHAR2 30 This is the intratransit shipment number. Active
TRANSFER_COST NUMBER Transfer cost, per-transaction value. Active
TRANSPORTATION_COST NUMBER Transportation cost is per-transaction value. Active
FREIGHT_CARRIER_ID NUMBER 18 This identifies the shipping carrier. Active
CONTAINERS NUMBER 18 This is number of packing units. Active
WAYBILL_AIRBILL VARCHAR2 20 This is the waybill or airbill number. Active
EXPECTED_ARRIVAL_DATE DATE This is the expected arrival date. Active
TRANSFER_SUBINVENTORY VARCHAR2 10 Opposing subinventory identifier in transfer transactions Active
TRANSFER_ORGANIZATION NUMBER 18 Opposing organization identifier in transfer transactions Active
TRANSFER_TO_LOCATION NUMBER 18 Opposing locator identifier in transfer transactions Active
NEW_AVERAGE_COST NUMBER New average cost used for average cost update Active
VALUE_CHANGE NUMBER Value change used for average cost update Active
PERCENTAGE_CHANGE NUMBER Percent change used for average cost update Active
MATERIAL_ALLOCATION_TEMP_ID NUMBER 18 Material allocation temporary identifier Active
DEMAND_SOURCE_HEADER_ID NUMBER 18 Demand source header identifier Active
DEMAND_SOURCE_LINE VARCHAR2 30 This identifies the demand source line. Active
DEMAND_SOURCE_DELIVERY VARCHAR2 30 This identifies the demand source shipment. Active
ITEM_SEGMENTS VARCHAR2 240 These are the inventory item segments. Active
ITEM_DESCRIPTION VARCHAR2 240 This is the description of inventory item. Active
ITEM_TRX_ENABLED_FLAG VARCHAR2 1 Inventory item transaction enabled flag Active
ITEM_LOCATION_CONTROL_CODE VARCHAR2 30 Inventory item locator control code Active
ITEM_RESTRICT_SUBINV_CODE VARCHAR2 30 Inventory item restrict subinventory code Active
ITEM_RESTRICT_LOCATORS_CODE VARCHAR2 30 Inventory item restrict locators code Active
ITEM_REVISION_QTY_CONTROL_CODE VARCHAR2 30 Inventory item revision control code Active
ITEM_PRIMARY_UOM_CODE VARCHAR2 3 This is the primary unit of measure for the inventory item. Active
ITEM_UOM_CLASS VARCHAR2 10 This is the unit of measure class for inventory item. Active
ITEM_SHELF_LIFE_CODE VARCHAR2 30 Code indicates the inventory item shelf life. Active
ITEM_SHELF_LIFE_DAYS NUMBER 18 Number of days of the inventory item shelf life. Active
ITEM_LOT_CONTROL_CODE VARCHAR2 30 Inventory item lot control code Active
ITEM_SERIAL_CONTROL_CODE VARCHAR2 30 Inventory item serial control code Active
ALLOWED_UNITS_LOOKUP_CODE VARCHAR2 30 Inventory item uom conversions type Active
DEPARTMENT_ID NUMBER 18 Holds WIP WORK CENTER ID required for Costing purposes Active
WIP_SUPPLY_TYPE NUMBER 18 WIP supply type describes the consumption method. Active
SUPPLY_SUBINVENTORY VARCHAR2 10 Name of the supply subinventory. Active
SUPPLY_LOCATOR_ID NUMBER 18 This identifies the supply locator. Active
VALID_SUBINVENTORY_FLAG VARCHAR2 1 Flag indicates valid subinventory. Active
VALID_LOCATOR_FLAG VARCHAR2 1 This flag indicates valid locator. Active
LOCATOR_SEGMENTS VARCHAR2 240 These are locator flexfield segments. Active
CURRENT_LOCATOR_CONTROL_CODE VARCHAR2 30 Inventory item locator control code Active
NUMBER_OF_LOTS_ENTERED NUMBER 18 This is the count of lot number records entered. Active
WIP_COMMIT_FLAG VARCHAR2 1 This flag indicates WIP commit. Active
NEXT_LOT_NUMBER VARCHAR2 30 This is the next lot number for inventory item. Active
LOT_ALPHA_PREFIX VARCHAR2 30 This is prefix of the inventory item lot. Active
NEXT_SERIAL_NUMBER VARCHAR2 80 Inventory item next valid serial number Active
SERIAL_ALPHA_PREFIX VARCHAR2 80 This is the inventory item unit number prefix. Active
POSTING_FLAG VARCHAR2 1 This flag tracks posting in putaway. Active
REQUIRED_FLAG VARCHAR2 1 Flag indicates if this is required. Active
PROCESS_FLAG VARCHAR2 1 Row process flag used by Transaction Manager Active
ERROR_CODE VARCHAR2 240 This is the error code returned by the transaction manager. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS) Active
ERROR_EXPLANATION VARCHAR2 240 This is the error explanation text. Active
DEPARTMENT_CODE VARCHAR2 10 This code indicates the department. Active
DEMAND_ID NUMBER 18 This column identifies the demand. Active
ITEM_INVENTORY_ASSET_FLAG VARCHAR2 1 Flag enables inventory item asset. Active
PRIMARY_SWITCH NUMBER 18 Flag indicates whether inventory item is a primary assembly for WIP (1 for primary assembly; null otherwise). Active
SHIPPABLE_FLAG VARCHAR2 1 This flag indicates if the item is shippable. Active
REQUISITION_LINE_ID NUMBER 18 Identifies the requisition line. Active
REQUISITION_DISTRIBUTION_ID NUMBER 18 Requisition distribution identifier Active
MOVEMENT_ID NUMBER 18 Movement statistics cross reference Active
RESERVATION_QUANTITY NUMBER This is the reservation quantity. Active
SHIPPED_QUANTITY NUMBER This column stores the quantity shipped. Active
TRANSACTION_LINE_NUMBER NUMBER 18 This is the transaction line number. Active
FROM_TASK_ID NUMBER 18 This identifies the source task. Active
TO_TASK_ID NUMBER 18 This identifies the task to transact to. Active
FROM_PROJECT_ID NUMBER 18 This identifies the originating project. Active
TO_PROJECT_ID NUMBER 18 Identifies the destination project. Active
TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions Active
PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions Active
FINAL_COMPLETION_FLAG VARCHAR2 1 Indicates if job costs must be flushed out for this job completion. Active
TRANSFER_PERCENTAGE NUMBER Percentage of value to attribute to transfer costs in an inter-org transfer Active
TRANSACTION_SEQUENCE_ID NUMBER 18 Transaction sequence identifier (currently not used) Active
FLOW_SCHEDULE VARCHAR2 1 Specifies whether the WIP transaction is a flow or schedule type transaction Active
DEMAND_CLASS VARCHAR2 30 Class to which the demand is tied. Active
QA_COLLECTION_ID NUMBER 18 This identifies the quality results. Active
KANBAN_CARD_ID NUMBER 18 This identifies the kanban card. Active
OVERCOMPLETION_TRANSACTION_QTY NUMBER Overcompletion transaction quantity Active
OVERCOMPLETION_PRIMARY_QTY NUMBER Overcompletion Primary quantity Active
OVERCOMPLETION_TRANSACTION_ID NUMBER 18 Overcompletion Transaction Identifier Active
END_ITEM_UNIT_NUMBER VARCHAR2 60 This column is the model unit number. Active
SCHEDULED_PAYBACK_DATE DATE This is the scheduled date for payback. Active
LINE_TYPE_CODE NUMBER 18 This code indicates the type of line (pick or put away). Active
PARENT_TRANSACTION_TEMP_ID NUMBER 18 This identifies the parent transaction in this table. Active
PUT_AWAY_STRATEGY_ID NUMBER 18 Put away Strategy ID - used by WMS only Active
PUT_AWAY_RULE_ID NUMBER 18 Put away Rule ID - used by WMS only Active
PICK_STRATEGY_ID NUMBER 18 Pick Strategy ID - used by WMS only Active
PICK_RULE_ID NUMBER 18 This identifies the WMS rule used for picking. Active
COMMON_BOM_SEQ_ID NUMBER 18 Bill identifier of common bom used Active
COMMON_ROUTING_SEQ_ID NUMBER 18 Routing id of the common routing used Active
COST_TYPE_ID NUMBER 18 This column identifies the cost type. Active
MOVE_ORDER_LINE_ID NUMBER 18 Move order line identifier that this transaction line is tied to Active
TASK_GROUP_ID NUMBER 18 Task group identifier for this task Active
PICK_SLIP_NUMBER NUMBER 18 Pick Slip number for the transaction line Active
RESERVATION_ID NUMBER 18 This identifies the reservation. Active
TRANSACTION_STATUS VARCHAR2 30 Indicates if it has to be processed or just saved. NULL or 1 is default behavior. 2 is save only. 3 is ready to process Active
STANDARD_OPERATION_ID NUMBER 18 Standard operation identifier - used by WMS only Active
TASK_PRIORITY NUMBER 18 Task priority - used by WMS only Active
WMS_TASK_TYPE NUMBER 18 WMS Task Type - used by WMS only Active
PARENT_LINE_ID NUMBER 18 This identifies the parent line. For future use only. Active
LPN_ID NUMBER 18 License Plate Number Identifier - used by WMS only Active
TRANSFER_LPN_ID NUMBER 18 Transfer License Plate Number Identifier - used by WMS only Active
WMS_TASK_STATUS NUMBER 18 Indicates status of the WMS task. Active
CONTENT_LPN_ID NUMBER 18 Transfer License Plate Number Identifier - used by WMS only Active
CONTAINER_ITEM_ID NUMBER 18 Item id for suggested container item for this line - used by WMS only Active
CARTONIZATION_ID NUMBER 18 Sequential LPN Id generated by cartonization - used by WMS only Active
PICK_SLIP_DATE DATE This column is the date of pick slip. Active
REBUILD_ITEM_ID NUMBER 18 Rebuildable Inventory item identifier Active
REBUILD_SERIAL_NUMBER VARCHAR2 80 Serial Number of the rebuildable item Active
REBUILD_ACTIVITY_ID NUMBER 18 Activity performed on the Rebuildable item Active
REBUILD_JOB_NAME VARCHAR2 240 Job Name performed on the Rebuildable item Active
ORGANIZATION_TYPE NUMBER 18 Organization Type. The values are based on MTL_TP_TYPES lookup. Active
TRANSFER_ORGANIZATION_TYPE NUMBER 18 Transfer Organization Type. The values are based on MTL_TP_TYPES lookup. Active
OWNING_ORGANIZATION_ID NUMBER 18 This identifies the owning organization or entity. Active
OWNING_TP_TYPE VARCHAR2 30 Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. Active
XFR_OWNING_ORGANIZATION_ID NUMBER 18 Transfer owning organization identifier Active
TRANSFER_OWNING_TP_TYPE VARCHAR2 30 Transfer Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. Active
PLANNING_ORGANIZATION_ID NUMBER 18 Planning organization identifier Active
PLANNING_TP_TYPE VARCHAR2 30 Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. Active
XFR_PLANNING_ORGANIZATION_ID NUMBER 18 Transfer planning organization identifier Active
TRANSFER_PLANNING_TP_TYPE VARCHAR2 30 Transfer Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. Active
SECONDARY_UOM_CODE VARCHAR2 3 Secondary unit of measure that may have been used to do the material transaction Active
SECONDARY_TRANSACTION_QUANTITY NUMBER This is the secondary transaction quantity. Active
TRANSACTION_BATCH_ID NUMBER 18 Batch Identifier for transaction Active
TRANSACTION_BATCH_SEQ NUMBER 18 Batch Sequence for Transactions Active
ALLOCATED_LPN_ID NUMBER 18 This identifies the allocated packing unit. Active
SCHEDULE_NUMBER VARCHAR2 60 This column has the schedule number. Active
SCHEDULED_FLAG NUMBER 18 This flag indicates if this is scheduled. Active
CLASS_CODE VARCHAR2 10 Class code; This column is called ACCOUNTING_CLASS in INV_TRANSACTIONS_INTERFACE Active
SCHEDULE_GROUP NUMBER 18 Specifies the schedule group (used for flow manufacturing). Active
BUILD_SEQUENCE NUMBER 18 Specified the sequence to be built (used for flow manufacturing). Active
BOM_REVISION VARCHAR2 3 Item revision used for getting the bill information Active
ROUTING_REVISION VARCHAR2 3 Routing revision used for getting the routing information while charging the flow schedule. Active
BOM_REVISION_DATE DATE Date of inventory item revision used for exploding the bill. Active
ROUTING_REVISION_DATE DATE Date of item routing revision used for exploding the routing for the flow schedule. Active
ALTERNATE_BOM_DESIGNATOR VARCHAR2 10 This is the alternate BOM designator. Active
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 10 This is the alternate routing designator. Active
OPERATION_PLAN_ID NUMBER 18 Operation plan ID assigned by rule based operation plan selection process Active
FOB_POINT VARCHAR2 30 FOB_POINT corresponds to the FOB_POINT in INV_INTERORG_PARAMETERS Active
MOVE_ORDER_HEADER_ID NUMBER 18 Move Order Header ID identifier Active
SERIAL_ALLOCATED_FLAG VARCHAR2 1 This flag indicates serial allocation. Active
TRX_FLOW_HEADER_ID NUMBER 18 Indicates the transaction flow that is being used for this transaction Active
LOGICAL_TRX_TYPE_CODE VARCHAR2 30 Identifies the Logical Transaction Type that originated the logical transactions Active
ORIGINAL_TRANSACTION_TEMP_ID NUMBER 18 Required for electronic records to keep the original transaction's temp ID Active
TRANSFER_SECONDARY_QUANTITY NUMBER This is the secondary quantity to transfer. Active
TRANSFER_SECONDARY_UOM VARCHAR2 3 This is the unit of measure for secondary quantity to transfer. Active
RELIEVE_RESERVATIONS_FLAG VARCHAR2 1 Indicates whether to relieve the reservations during transaction processing Active
RELIEVE_HIGH_LEVEL_RSV_FLAG VARCHAR2 1 Indicates whether to check for high level reservations that needs to be relieved during transaction processing Active
TRANSFER_PRICE NUMBER This column is the transfer price. Active
SOURCE_LOT_NUMBER VARCHAR2 80 This column stores the source lot number. 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
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 SOURCE_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 SOURCE_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 - This was renamed from EXPENDITURE_TYPE 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_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
PICKED_QUANTITY NUMBER This column stores the quantity picked. Active
SECONDARY_PICKED_QUANTITY NUMBER This is the secondary picked quantity. Active
PICK_SLIP_LINE_NUMBER NUMBER Pick slip line number for this transaction. Active
ORIG_TRANSACTION_QUANTITY NUMBER This is the original transaction quantity. Active
ORIG_SUBINVENTORY_CODE VARCHAR2 10 Original from subinventory code Active
ORIG_LOCATOR_ID NUMBER 18 This identifies the original locator. Active
ORIG_LOT_NUMBER VARCHAR2 20 This is the original lot number. Active
SP_TRANSACTION_FLAG VARCHAR2 1 Flag indicates if this is a standard pack transaction. Active
BUILD_BREAK_TO_UOM VARCHAR2 3 Code of the unit of measure for build break to. Active
PJC_ORGANIZATION_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget - This was renamed from PA_EXPENDITURE_ORG_ID Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction history (INV_MATERIAL_TXNS)
AGING_ONSET_DATE DATE Aging onset date is the date that aging starts for this consigned item.
CONSUMPTION_UNIT_PRICE NUMBER This is the unit price at the time of consumption.
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Tax Determinant: Default taxation country code.
FIRST_PTY_REG_ID NUMBER 18 Tax Determinant: First party tax registration ID for the transaction.
THIRD_PTY_REG_ID NUMBER 18 Tax Determinant: Third party tax registration ID for the transaction.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 Tax Determinant: The final discharge location identifier.
DOCUMENT_SUB_TYPE VARCHAR2 240 Tax Determinant: Document Fiscal Classification code.
TRX_BUSINESS_CATEGORY VARCHAR2 240 Tax Determinant: Transaction business category code.
USER_DEFINED_FISC_CLASS VARCHAR2 30 Tax Determinant: User defined fiscal classification code.
TAX_INVOICE_NUMBER VARCHAR2 150 Tax Determinant: The number of the Fiscal Document.
TAX_INVOICE_DATE DATE Tax Determinant: Date of the Fiscal Document.
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Tax Determinant: Product fiscal classification code of the inventory item.
PRODUCT_CATEGORY VARCHAR2 240 Tax Determinant: Product category code of the transaction line.
INTENDED_USE_CLASSIF_ID NUMBER 18 Tax Determinant: Intended use classification identifier.
PRODUCT_TYPE VARCHAR2 240 Tax Determinant: Product type code of the inventory item. Possible values are GOODS and SERVICES.
ASSESSABLE_VALUE NUMBER Tax Determinant: This is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes.
TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax Determinant: Tax Classification Code.
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Tax Determinant: Tax exemption certificate number.
EXEMPT_REASON_CODE VARCHAR2 30 Tax Determinant: Tax exemption reason code.
SHIP_FROM_LOCATION_ID NUMBER 18 Tax Determinant: Ship from location identifier.
IS_EVENT_PUBLISHED VARCHAR2 1 Flag to indicate publishing of event for the current transaction
CATEGORY_ID NUMBER 18 Tax Determinant: Product fiscal classification identifier.
ORIGINAL_SHIPMENT_TXN_ID NUMBER 18 For Transfer Order Return cases: Identifies the inventory txn id of the shipment from the originating Transfer Order.
TRANSACTION_INTERFACE_LINE_NUM VARCHAR2 30 Transaction interface line number
TRANSACTION_INTERFACE_ID NUMBER 18 Transaction interface line identifier
LOAD_REQUEST_ID NUMBER 18 Used by Enterprise Service Scheduler. Indicates the request ID of the interface job that created the row.
OPERATION_SEQ_NUMBER_ID NUMBER 18 Identifier for the operation sequence number giving rise to this transaction. Populated for Manufacturing transactions. Required for Costing purposes.
OPERATION_TRANSACTION_ID NUMBER 18 Used for audit purposes to track the actual WIP Operation Transaction ID that generated the given Inventory transaction. WIP populate this value which is needed for Costing purposes.
ASSEMBLY_SERIAL_NUMBER VARCHAR2 80 The serial number of the parent assembly where the component was issued or returned.
LICENSE_PLATE_NUMBER VARCHAR2 30 This is the number of the packing unit.
E_RECORD_ID NUMBER 18 Electronic Signature ID
USE_CURRENT_COST_FLAG VARCHAR2 1 Indicates whether the current item cost will be used or cost will be entered by item cost component. Y - Yes signifies current cost will be used. N - No signifies cost will be entered by item cost component.
PARENT_ID NUMBER 18 Group Identifier for Lot Transactions
LOT_TXN_GROUP_NAME VARCHAR2 30 To identify the group of lot transactions
SOURCE_LOT_FLAG VARCHAR2 3 To identify the parent lot in lot transactions
EXTERNAL_SYSTEM_PACKING_UNIT VARCHAR2 150 The license plate number (LPN) of the external/third party Warehouse Management System (WMS).
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for Inventory striping attributes
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
TRANSFER_PROJECT_ID NUMBER 18 Transfer Project identifier used in project transfer transactions
TRANSFER_TASK_ID NUMBER 18 Transfer Task identifier used in project transfer transactions
EXTERNAL_SYS_TXN_REFERENCE VARCHAR2 300 This column is used to store the link to the transaction references passed by external WMS or 3PL systems.

Foreign Keys

Table Foreign Table Foreign Key Column
INV_MATERIAL_TXNS_TEMP gl_code_combinations DISTRIBUTION_ACCOUNT_ID
INV_MATERIAL_TXNS_TEMP inv_secondary_inventories TRANSFER_SUBINVENTORY, TRANSFER_ORGANIZATION
INV_MATERIAL_TXNS_TEMP egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_MATERIAL_TXNS_TEMP rcv_transactions RCV_TRANSACTION_ID
INV_MATERIAL_TXNS_TEMP inv_generic_dispositions TRANSACTION_SOURCE_TYPE_ID, ORGANIZATION_ID
INV_MATERIAL_TXNS_TEMP inv_txn_request_lines MOVE_ORDER_LINE_ID
INV_MATERIAL_TXNS_TEMP inv_reservations RESERVATION_ID
INV_MATERIAL_TXNS_TEMP inv_item_locations LOCATOR_ID
INV_MATERIAL_TXNS_TEMP inv_item_locations TRANSFER_TO_LOCATION
INV_MATERIAL_TXNS_TEMP inv_secondary_inventories SUBINVENTORY_CODE, ORGANIZATION_ID

Indexes

Index Uniqueness Tablespace Columns
INV_MATERIAL_TXNS_TEMP_N1 Non Unique FUSION_TS_TX_IDX TRANSACTION_HEADER_ID
INV_MATERIAL_TXNS_TEMP_N10 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID
INV_MATERIAL_TXNS_TEMP_N12 Non Unique FUSION_TS_TX_IDX TRANSFER_SUBINVENTORY, TRANSFER_TO_LOCATION, ORGANIZATION_ID
INV_MATERIAL_TXNS_TEMP_N13 Non Unique FUSION_TS_TX_IDX PICK_SLIP_NUMBER, PICK_SLIP_LINE_NUMBER
INV_MATERIAL_TXNS_TEMP_N14 Non Unique FUSION_TS_TX_IDX MOVE_ORDER_LINE_ID
INV_MATERIAL_TXNS_TEMP_N15 Non Unique FUSION_TS_TX_IDX RESERVATION_ID
INV_MATERIAL_TXNS_TEMP_N19 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, INVENTORY_ITEM_ID, TRANSACTION_ACTION_ID, POSTING_FLAG
INV_MATERIAL_TXNS_TEMP_N2 Non Unique FUSION_TS_TX_IDX INVENTORY_ITEM_ID, SUBINVENTORY_CODE, ORGANIZATION_ID
INV_MATERIAL_TXNS_TEMP_N21 Non Unique FUSION_TS_TX_IDX MOVE_ORDER_HEADER_ID
INV_MATERIAL_TXNS_TEMP_N22 Non Unique FUSION_TS_TX_IDX EXTERNAL_SYS_TXN_REFERENCE
INV_MATERIAL_TXNS_TEMP_N23 Non Unique FUSION_TS_TX_IDX SOURCE_LINE_ID
INV_MATERIAL_TXNS_TEMP_N24 Non Unique FUSION_TS_TX_IDX TRANSACTION_TYPE_ID
INV_MATERIAL_TXNS_TEMP_N25 Non Unique FUSION_TS_TX_IDX TRX_SOURCE_LINE_ID
INV_MATERIAL_TXNS_TEMP_N3 Non Unique FUSION_TS_TX_IDX PICKING_LINE_ID
INV_MATERIAL_TXNS_TEMP_N4 Non Unique FUSION_TS_TX_IDX COMPLETION_TRANSACTION_ID
INV_MATERIAL_TXNS_TEMP_N5 Non Unique FUSION_TS_TX_IDX PARENT_LINE_ID
INV_MATERIAL_TXNS_TEMP_N6 Non Unique FUSION_TS_TX_IDX PARENT_TRANSACTION_TEMP_ID
INV_MATERIAL_TXNS_TEMP_N8 Non Unique FUSION_TS_TX_IDX TRANSACTION_SOURCE_TYPE_ID, ORGANIZATION_ID, TRANSACTION_DATE, TRANSACTION_SOURCE_NAME
INV_MATERIAL_TXNS_TEMP_U1 Unique FUSION_TS_TX_IDX TRANSACTION_TEMP_ID