1. Tables and Views for SCM
  2. INV_MATERIAL_TXNS

INV_MATERIAL_TXNS

INV_MATERIAL_TXNS stores a record of every material transaction or cost update performed in Inventory. . . . Records are inserted into this table either through the transaction processor or by the standard cost update program. The columns TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID and TRANSACTION_SOURCE_NAME describe what the transaction is and against what entity it was performed. . . . If the item is under lot control then the lot records are stored in INV_TRANSACTION_LOT_NUMBERS, joined by the column TRANSACTION_ID. If the item is under serial control then the serial records are stored in INV_UNIT_TRANSACTIONS, joined by the column TRANSACTION_ID. The Item revision and locator control are stored in the columns REVISION and LOCATOR_ID respectively. . . . Transfer transactions are represented as two single records in the table. They are related through the column TRANSFER_TRANSACTION_ID, which contains the TRANSACTION_ID of the other transaction in the transfer. . . . . . . . . The index INV_MATERIAL_TXNS_UPGD is used only during install and upgrade, and will be dropped during the course thereof, but is included here for completeness.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_MATERIAL_TXNS_PK

TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
TRANSACTION_ID NUMBER 18 Yes Primary key of the inventory transaction. Active
REPAIR_TXN_CODE_ID NUMBER 18 Foreign key reference to CSE condition events.
CSE_INTERFACE_STATUS_CODE VARCHAR2 25 Flag to indicate that the transaction has been interfaced/Pending to be interfaced to ALM
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
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 Transaction secondary inventory Active
LOCATOR_ID NUMBER 18 This identifies the item locator. 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. Active
TRANSACTION_QUANTITY NUMBER Yes This is the transaction quantity in the user's preferred unit of measure. Active
TRANSACTION_UOM VARCHAR2 3 Yes This is the user preferred unit of measure for this transaction. Active
PRIMARY_QUANTITY NUMBER Yes Transaction quantity in terms of primary uom of the item Active
TRANSACTION_DATE DATE Yes This is the date when the transaction was processed. Active
VARIANCE_AMOUNT NUMBER Used for average cost update transactions Active
ACCT_PERIOD_ID NUMBER 18 This identifies an accounting period. Active
TRANSACTION_REFERENCE VARCHAR2 240 This code is the transaction reference. Active
REQUESTER_ID NUMBER 18 Reference to unique identifier of the requester.
REASON_ID NUMBER 18 This identifies the transaction reason. Active
DISTRIBUTION_ACCOUNT_ID NUMBER 18 Distribution account identifier Active
ENCUMBRANCE_ACCOUNT NUMBER 18 Encumbrance account identifier for PO transactions Active
ENCUMBRANCE_AMOUNT NUMBER This is the total encumbrance amount. Active
COST_UPDATE_ID NUMBER 18 This identifies the cost update. Active
COSTED_FLAG VARCHAR2 1 Costed flag to mark if the transactions are costed or not Active
ACTUAL_COST NUMBER This column is the actual cost. Active
TRANSACTION_COST NUMBER The cost entered by the user during a transaction Active
PRIOR_COST NUMBER Item cost before the transaction Active
NEW_COST NUMBER Item cost after the transaction processing 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
QUANTITY_ADJUSTED NUMBER Standard cost quantity adjusted Active
EMPLOYEE_CODE VARCHAR2 10 Code indicates the transaction requestor. Active
DEPARTMENT_ID NUMBER 18 Holds WIP WORK CENTER ID required for Costing purposes Active
OPERATION_SEQ_NUM NUMBER 18 Operation sequence number within a routing Active
MASTER_SCHEDULE_UPDATE_CODE VARCHAR2 10 This code indicates the master schedule update. Active
RECEIVING_DOCUMENT VARCHAR2 10 This indicates the receiving document. Active
PICKING_LINE_ID NUMBER 18 This identifies the picking line. Active
TRX_SOURCE_LINE_ID NUMBER 18 Line level transaction source id Active
TRX_SOURCE_DELIVERY_ID NUMBER 18 Sales order delivery identifier Active
REPETITIVE_LINE_ID NUMBER 18 This identifies the repetitive line. 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
TRANSFER_TRANSACTION_ID NUMBER 18 Transaction id of the opposing transfer transaction Active
TRANSACTION_SET_ID NUMBER 18 This identifies the transaction group. Active
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction cross reference Active
MOVE_TRANSACTION_ID NUMBER 18 Move transaction cross reference. Currently redundant for Fusion Manufacturing transactions as no longer needed for Costing. Active
COMPLETION_TRANSACTION_ID NUMBER 18 Completion transaction cross reference. Currently redundant for Fusion Manufacturing transactions as no longer needed for Costing. 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
VENDOR_LOT_NUMBER VARCHAR2 30 This is the supplier lot number. Active
TRANSFER_ORGANIZATION_ID NUMBER 18 Transfer opposing organization id Active
TRANSFER_SUBINVENTORY VARCHAR2 10 Transfer transaction opposing subinventory Active
TRANSFER_LOCATOR_ID NUMBER 18 Transfer transaction opposing locator id Active
SHIPMENT_NUMBER VARCHAR2 30 This is the intratransit shipment number. Active
TRANSFER_COST NUMBER Transfer cost specified for inter-org transfers Active
TRANSPORTATION_DIST_ACCOUNT NUMBER 18 Transfer transportation distribution account Active
TRANSPORTATION_COST NUMBER This is the transportation cost for transfer. Active
TRANSFER_COST_DIST_ACCOUNT NUMBER 18 Transaction transfer cost distribution account Active
WAYBILL_AIRBILL VARCHAR2 20 This is the waybill or airbill number. Active
FREIGHT_CODE VARCHAR2 30 Intransit shipment freight code Active
NUMBER_OF_CONTAINERS NUMBER 18 This is the count of packing units. Active
VALUE_CHANGE NUMBER Total value change for average cost update Active
PERCENTAGE_CHANGE NUMBER Percentage average cost change for average cost update 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
DEPARTMENT_CODE VARCHAR2 10 This code indicates the department. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
MOVEMENT_ID NUMBER 18 Movement statistics cross reference Active
INVOICED_FLAG VARCHAR2 1 Invoiced flag to mark if the transactions are invoiced Active
TRANSACTION_GROUP_ID NUMBER 18 Transaction group iIdentifier for distribution processing by the cost processor 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
SHORTAGE_PROCESS_CODE NUMBER 18 Flag indicating workflow notifications should be provided for this transaction if shortage exists 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
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
ERROR_CODE VARCHAR2 240 This is the error code returned by the transaction manager. Active
ERROR_EXPLANATION VARCHAR2 240 This is the error explanation text. Active
PRIOR_COSTED_QUANTITY NUMBER Costed quantity before this transaction Active
TRANSFER_PRIOR_COSTED_QUANTITY NUMBER Transfer quantity costed before this transaction Active
FINAL_COMPLETION_FLAG VARCHAR2 1 Indicates if job costs need to be flushed out for this discrete jobcompletion Active
PM_COST_COLLECTED VARCHAR2 1 Specifies whether the row has been interfaced to Oracle Projects Active
PM_COST_COLLECTOR_GROUP_ID NUMBER 18 Group identifier used by cost collector to process group of records. Active
SHIPMENT_COSTED VARCHAR2 1 Indicates if the shipment transaction has been processed by the cost worker Active
TRANSFER_PERCENTAGE NUMBER Percentage of value to attribute to transfer costs in an Inter-Orgtransfer Active
MATERIAL_ACCOUNT NUMBER 18 This specifies the material account. Active
MATERIAL_OVERHEAD_ACCOUNT NUMBER 18 Specifies the material overhead account Active
RESOURCE_ACCOUNT NUMBER 18 This specifies the resource account. Active
OUTSIDE_PROCESSING_ACCOUNT NUMBER 18 Specifies the acount to be charged for outside processing Active
OVERHEAD_ACCOUNT NUMBER 18 This specifies the overhead account. Active
COST_GROUP_ID NUMBER 18 This identifies the cost group. Active
TRANSFER_COST_GROUP_ID NUMBER 18 This identifies the transfer cost group. Active
FLOW_SCHEDULE VARCHAR2 1 Specifies whether the WIP transaction is a flow or a schedule type transaction Active
QA_COLLECTION_ID NUMBER 18 This identifies the quality results. 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
MVT_STAT_STATUS VARCHAR2 240 Flag to indicate that the transaction is updated/processed/new Active
COMMON_BOM_SEQ_ID NUMBER 18 This identifies the common bill. Active
COMMON_ROUTING_SEQ_ID NUMBER 18 Routing identifier of common routing Active
ORG_COST_GROUP_ID NUMBER 18 This identifies the organization's cost group. Active
COST_TYPE_ID NUMBER 18 This column identifies the cost type. Active
PERIODIC_PRIMARY_QUANTITY NUMBER transaction quantity converted to primary uom of the transfer organization in case of periodic costing Active
MOVE_ORDER_LINE_ID NUMBER 18 The move order line 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
LPN_ID NUMBER 18 License Plate Number Identifier - used by WMS only Active
TRANSFER_LPN_ID NUMBER 18 Transfer License Plate Number Identifier Active
PICK_STRATEGY_ID NUMBER 18 This identifies the WMS strategy used for picking. Used by WMS only. Active
PICK_RULE_ID NUMBER 18 This identifies the WMS rule used for picking. Active
PUT_AWAY_STRATEGY_ID NUMBER 18 This identifies the put away strategy. Used by WMS only. Active
PUT_AWAY_RULE_ID NUMBER 18 This identifies the put away rule. Used by WMS only. Active
RESERVATION_ID NUMBER 18 This identifies the reservation. Active
CONTENT_LPN_ID NUMBER 18 Transfer License Plate Number Identifier - used by WMS only Active
PICK_SLIP_DATE DATE This column is the date of pick slip. Active
COST_CATEGORY_ID NUMBER 18 This identifies the cost category. 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 NUMBER 18 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 NUMBER 18 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 NUMBER 18 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 NUMBER 18 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
SHIP_TO_LOCATION_ID NUMBER 18 This identifies the ship-to location. Active
TRANSACTION_MODE NUMBER 18 This code indicates the processing mode: 1=online; 2=immediate concurrent; and 3=batch. Active
TRANSACTION_BATCH_ID NUMBER 18 This identifies the batch for transactions. Active
TRANSACTION_BATCH_SEQ NUMBER 18 Batch Sequence for Transactions Active
INTRANSIT_ACCOUNT NUMBER 18 INTRANSIT_ACCOUNT corresponds to INV_INTRANSIT_ACCOUNT from INV_INTERORG_PARAMETERS Active
FOB_POINT NUMBER 18 FOB_POINT corresponds to FOB_POINT between two Organizations in INV_INTERORG_PARAMETERS Active
PARENT_TRANSACTION_ID NUMBER 18 This identifies the parent transaction in this table. Active
LOGICAL_TRX_TYPE_CODE NUMBER 18 Logical Transaction Type Identifier Active
TRX_FLOW_HEADER_ID NUMBER 18 This identifies the transaction flow being used for this transaction. Active
LOGICAL_TRANSACTIONS_CREATED NUMBER 18 Identifies Deferred Transactions Active
LOGICAL_TRANSACTION NUMBER 18 This identifies the logical transaction. Active
INTERCOMPANY_COST NUMBER This column is the intercompany cost. Active
INTERCOMPANY_PRICING_OPTION NUMBER 18 Intercompany Pricing Option Identifier Active
INTERCOMPANY_CURRENCY_CODE VARCHAR2 15 This code indicates the currency of intercompany cost. Active
ORIGINAL_TRANSACTION_TEMP_ID NUMBER 18 Required for electronic records to keep the original transaction's temp ID Active
TRANSFER_PRICE NUMBER This column is the transfer price. Active
EXPENSE_ACCOUNT_ID NUMBER 18 This identifies the expense account. Active
COGS_RECOGNITION_PERCENT NUMBER This is COGS recognition in percent. Active
SO_ISSUE_ACCOUNT_TYPE NUMBER 18 This indicates the type of sales order issue account. Active
OPM_COSTED_FLAG VARCHAR2 1 Flag to mark if the transaction is costed or not (for Process Organizations) 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
DEPRECIABLE_FLAG NUMBER 9 Signal whether this transaction relates to depreciable inventory. Value 1 signifies depreciable inventory Value 2 signifies non depreciable inventory 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
FROM_GRADE_CODE VARCHAR2 150 This code indicates the original lot grade. Active
TO_GRADE_CODE VARCHAR2 150 This code indicates the lot grade to transact to. Active
BUILD_BREAK_TO_UOM VARCHAR2 3 Code of the unit of measure for build break to. 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 This code indicates the original subinventory. Active
ORIG_LOCATOR_ID NUMBER This identifies the original locator. Active
ORIG_LOT_NUMBER VARCHAR2 20 This is the original lot number. Active
PJC_ORGANIZATION_ID NUMBER 18 This identifies the expenditure organization used to build the transaction descriptive flexfield for project-related transactions. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
LOCATION_TYPE VARCHAR2 30 Location type identifier which qualifies the Ship To Location. 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. Active
AGING_EXPIRATION_DATE DATE Aging expiration date is the date that this consigned item will become owned. Active
OWNERSHIP_CHANGE_TXN_ID NUMBER 18 This column identifies the Transfer to Owned transaction with which this Transfer to Consigned record is associated. Active
CONSUMPTION_LINE_ID NUMBER 18 This is a foreign key to INV_CONS_ADVICE_LINES.CONSUMPTION_LINE_ID that aggregates this transaction record for consumption advice. If the column has value -1, the consumption advice line will not be created because the consumption has been completely transferred back to consigned. Active
CONSUMPTION_UNIT_PRICE NUMBER This is the unit price at the time of consumption in CURRENCY_CODE. Active
CONSUMPTION_TAX_EXC_UNIT_PRICE NUMBER This is tax exclusive unit price at the time of consumption in CURRENCY_CODE. Active
ERROR_CONS_HEADER_ID NUMBER 18 This column points to the consumption advice where this transaction failed to be grouped into a consumption advice line. Active
CONS_ERROR_TYPE_CODE VARCHAR2 30 This column marks the ownership change transaction with an error detected during consumption advice generation. Active
CONS_ERROR_ACTION_CODE VARCHAR2 30 This column identifies the action that the user needs to take to resolve the error set by CONS_ERROR_TYPE_CODE. Active
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 transaction id of the shipment from the originating Transfer Order.
CONSIGNMENT_SOURCE_TXN_ID NUMBER 18 This column is populated only for transactions involving consigned material, with the original deliver transaction identifier in Receiving.
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.
WIP_SUPPLY_TYPE NUMBER WIP Supply Type; describes the consumption method.
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 Operation Transaction ID that generated the given Inventory transaction. WIP populate this value which is needed for Costing purposes.
AVAIL_XFER_TO_CONSIGNED_QTY NUMBER Only Transfer to Owned transactions have a value for this column. When the transaction is created, it is populated with the Primary Quantity. When a Transfer to Consigned transaction utilizes this Transfer to Owned transaction, the value of the column gets decremented by the primary quantity of the Transfer to Consigned transaction. When the value of this column becomes zero, the transaction cannot be utilized by any more Transfer to Consigned transactions.
ASSEMBLY_SERIAL_NUMBER VARCHAR2 80 The serial number of the parent assembly where the component was issued or returned.
MANUAL_RECEIPT_EXPENSE VARCHAR2 1 Flag which is set to 'Y' when there is a requirement for Manual Receipt at EXPENSE destination
ALM_INTERFACE_STATUS VARCHAR2 30 Column to indicate the ALM interface (for Genealogy) status. A blank value indicates that the transaction is not applicable for ALM interfacing, a value of 'P' indicates that there was an error while interfacing the transaction with ALM and a value of 'I' indicates that the transaction has been interfaced to ALM successfully. The lookup type corresponding to this column is ORA_INV_ALM_INTERFACE_STATUS.
ALM_INTERFACE_ERROR_CODE VARCHAR2 30 Column to store the error code returned by the ALM Interface API (for Genealogy).
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_serial_numbers inv_material_txns LAST_TRANSACTION_ID
rcv_transactions inv_material_txns INV_TRANSACTION_ID
rcv_transactions_interface inv_material_txns INV_TRANSACTION_ID
inv_transaction_lot_numbers inv_material_txns TRANSACTION_ID

Indexes

Index Uniqueness Tablespace Columns Status
INV_MATERIAL_TXNS_N1 Non Unique FUSION_TS_TX_IDX INVENTORY_ITEM_ID, ORGANIZATION_ID, TRANSACTION_DATE
INV_MATERIAL_TXNS_N10 Non Unique FUSION_TS_TX_IDX COSTED_FLAG, TRANSACTION_GROUP_ID
INV_MATERIAL_TXNS_N11 Non Unique FUSION_TS_TX_IDX PARENT_TRANSACTION_ID
INV_MATERIAL_TXNS_N12 Non Unique FUSION_TS_TX_IDX TRANSACTION_SET_ID
INV_MATERIAL_TXNS_N14 Non Unique FUSION_TS_TX_IDX COMPLETION_TRANSACTION_ID
INV_MATERIAL_TXNS_N16 Non Unique FUSION_TS_TX_IDX PICK_SLIP_NUMBER
INV_MATERIAL_TXNS_N17 Non Unique FUSION_TS_TX_IDX MOVE_ORDER_LINE_ID
INV_MATERIAL_TXNS_N18 Non Unique FUSION_TS_TX_IDX PICKING_LINE_ID
INV_MATERIAL_TXNS_N19 Non Unique FUSION_TS_TX_IDX RCV_TRANSACTION_ID
INV_MATERIAL_TXNS_N20 Non Unique FUSION_TS_TX_IDX PROJECT_ID
INV_MATERIAL_TXNS_N21 Non Unique FUSION_TS_TX_IDX TO_PROJECT_ID
INV_MATERIAL_TXNS_N22 Non Unique FUSION_TS_TX_IDX PJC_PROJECT_ID
INV_MATERIAL_TXNS_N23 Non Unique FUSION_TS_TX_IDX TRANSFER_TRANSACTION_ID
INV_MATERIAL_TXNS_N24 Non Unique FUSION_TS_TX_IDX INVOICED_FLAG
INV_MATERIAL_TXNS_N25 Non Unique FUSION_TS_TX_IDX OPM_COSTED_FLAG
INV_MATERIAL_TXNS_N26 Non Unique FUSION_TS_TX_DATA ORGANIZATION_ID, MOVE_ORDER_LINE_ID, TRANSACTION_QUANTITY Obsolete
INV_MATERIAL_TXNS_N27 Non Unique FUSION_TS_TX_DATA TRANSACTION_SOURCE_ID
INV_MATERIAL_TXNS_N28 Non Unique FUSION_TS_TX_IDX COSTED_FLAG, ORGANIZATION_ID
INV_MATERIAL_TXNS_N29 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, MOVE_ORDER_LINE_ID, TRANSACTION_QUANTITY, PICK_SLIP_NUMBER
INV_MATERIAL_TXNS_N30 Non Unique FUSION_TS_TX_IDX SUBINVENTORY_CODE
INV_MATERIAL_TXNS_N32 Non Unique FUSION_TS_TX_IDX TO_DATE((TO_CHAR("TRANSACTION_DATE",'DD-MON-YYYY')),'DD-MON-YYYY')
INV_MATERIAL_TXNS_N33 Non Unique FUSION_TS_TX_IDX TO_CHAR("ORGANIZATION_ID")
INV_MATERIAL_TXNS_N34 Non Unique FUSION_TS_TX_IDX REASON_ID
INV_MATERIAL_TXNS_N35 Non Unique FUSION_TS_TX_IDX CREATION_DATE, PICK_SLIP_NUMBER, ORGANIZATION_ID
INV_MATERIAL_TXNS_N36 Non Unique FUSION_TS_TX_IDX CONSUMPTION_LINE_ID
INV_MATERIAL_TXNS_N37 Non Unique FUSION_TS_TX_IDX CONS_ERROR_TYPE_CODE Active
INV_MATERIAL_TXNS_N38 Non Unique FUSION_TS_TX_IDX ALM_INTERFACE_STATUS
INV_MATERIAL_TXNS_N39 Non Unique FUSION_TS_TX_IDX E_RECORD_ID
INV_MATERIAL_TXNS_N4 Non Unique FUSION_TS_TX_IDX VENDOR_LOT_NUMBER
INV_MATERIAL_TXNS_N40 Non Unique FUSION_TS_TX_IDX TRANSACTION_INTERFACE_LINE_NUM
INV_MATERIAL_TXNS_N41 Non Unique Default EXTERNAL_SYS_TXN_REFERENCE
INV_MATERIAL_TXNS_N42 Non Unique FUSION_TS_TX_IDX OPERATION_TRANSACTION_ID, COUNTRY_OF_ORIGIN_CODE
INV_MATERIAL_TXNS_N5 Non Unique FUSION_TS_TX_IDX TRANSACTION_DATE, ORGANIZATION_ID, SUBINVENTORY_CODE
INV_MATERIAL_TXNS_N6 Non Unique FUSION_TS_TX_IDX SHIPMENT_NUMBER
INV_MATERIAL_TXNS_N8 Non Unique FUSION_TS_TX_IDX TRANSACTION_SOURCE_TYPE_ID, ORGANIZATION_ID, TRANSACTION_DATE, UPPER("TRANSACTION_SOURCE_NAME")
INV_MATERIAL_TXNS_U1 Unique FUSION_TS_TX_IDX TRANSACTION_ID