1. Tables and Views for SCM
  2. INV_TRANSACTIONS_INTERFACE

INV_TRANSACTIONS_INTERFACE

INV_TRANSACTIONS_INTERFACE allows calling applications to post material transactions (movements, issues, receipts etc. to Oracle Inventory transaction module. Transaction Manager concurrent program polls this table at a user-specified process interval, and submits the Transaction Workers to process them. Processing consists of data derivation, validation, and the transfer of records from INV_TRANSACTIONS_INTERFACE, INV_TRANSACTION_LOTS_INTERFACE, and INV_SERIAL_NUMBERS_INTERFACE into their respective temporary tables, from where they are processed by the transaction processor. INV_TRANSACTIONS_INTERFACE follows the Inventory standard for interfacing flexfields. Any parameters which are represented by flexfields may be entered in the interface table either as code combination identifiers or as flexfield segment combinations. The Transaction Worker will validate that any given identifiers are valid and enabled. If no identifier is given, then the Transaction Worker will validate and decode the flexfield segment values, and where appropriate, create new flexfield combinations in the database. The Transaction Manager picks up the rows to process based on the LOCK_FLAG, TRANSACTION_MODE, PROCESS_FLAG. Only records with TRANSACTION_MODE of '3', LOCK_FLAG of '2', and PROCESS_FLAG of '1' will be picked up by the Transaction Manager and assigned to a Transaction Worker. If a record fails to process completely, then PROCESS_FLAG will be set to '3' and ERROR_CODE and ERROR_EXPLANATION will be populated with the cause for the error. Scope: public Lifecycle: active Display Name: Material Transactions Interface Product: INV Category: BUSINESS_ENTITY INV_MATERIAL_TRANSACTION

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

INV_TXNS_INTERFACE_PK

TRANSACTION_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
TRANSACTION_INTERFACE_ID NUMBER 18 Yes Transaction interface line identifier Active
REPAIR_TXN_CODE_ID NUMBER 18 Foreign key reference to CSE condition events.
INV_LOTSERIAL_INTERFACE_NUM VARCHAR2 30 Alternate key to link an inventory transaction to the lot or serial interface. Used for SAAS processing.
LOCATION_TYPE VARCHAR2 30 Location type identifier which qualifies the Ship To Location. Active
TRANSACTION_HEADER_ID NUMBER 18 Transaction group identifier and Workers, only user-specified values will be ignored Active
SOURCE_CODE VARCHAR2 30 Yes Transaction source identifier; Used for auditing and process control Active
SOURCE_LINE_ID NUMBER 18 Yes Transaction source line identifier; Used for auditing only Active
SOURCE_HEADER_ID NUMBER 18 Yes Transaction source group identifier; Used for process control by user-submitted Transaction Workers Active
PROCESS_FLAG VARCHAR2 30 Yes Flag indicating whether transaction is ready to be processed by the Transaction Manager or Worker ('1' for ready, '2' for not ready); if the transaction fails for some reason, the Transaction Worker sets the value of PROCESS_FLAG to '3
TRANSACTION_MODE VARCHAR2 30 Yes Code that indicates whether the transaction is to be processed in immediate concurrent processing mode (2) or background processing mode (3) Active
LOCK_FLAG VARCHAR2 30 Flag indicating whether the transaction is locked by the Transaction Manager or Workers ('1' for locked, '2' or NULL for not locked); this prevents two different Workers from processing the same transaction; You should always specify '2
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
LOAD_REQUEST_ID NUMBER 18 Used by Enterprise Service Scheduler. Indicates the request ID of the interface job that created the row.
INVENTORY_ITEM_ID NUMBER 18 This identifies the inventory item. Active
REVISION VARCHAR2 18 Revision of item if under revision control. Active
ORGANIZATION_ID NUMBER 18 This identifies the inventory organization. Active
ORGANIZATION_NAME VARCHAR2 240 Organization Name. The values are based on Organization Name in INV_ORGANIZATION_DEFINITIONS_V.
TRANSACTION_QUANTITY NUMBER Yes This is the transaction quantity in the user's preferred unit of measure. Active
PRIMARY_QUANTITY NUMBER Transaction quantity in primary unit of measure Active
TRANSACTION_UOM VARCHAR2 3 Transaction unit of measure code Active
TRANSACTION_UNIT_OF_MEASURE VARCHAR2 25 Transaction unit of measure name
TRANSACTION_DATE DATE Yes Transaction date; No timestamp, will be truncated by Transaction Worker Active
ACCT_PERIOD_ID NUMBER 18 Accounting period identifier; the Transaction Worker derives this information from the TRANSACTION_DATE column Active
SUBINVENTORY_CODE VARCHAR2 10 This is name of the subinventory. Active
LOCATOR_ID NUMBER 18 Locator identifier; locator must be specified for items under locator control either by locator identifier, or by individual segment values Active
LOC_SEGMENT1 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT2 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT3 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT4 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT5 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT6 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT7 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT8 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT9 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT10 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT11 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT12 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT13 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT14 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT15 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT16 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT17 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT18 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT19 VARCHAR2 40 This is a locator flexfield segment. Active
LOC_SEGMENT20 VARCHAR2 40 This is a locator flexfield segment. Active
TRANSACTION_SOURCE_ID NUMBER 18 This identifies the transaction source record. Active
DSP_SEGMENT1 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT2 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT3 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT4 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT5 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT6 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT7 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT8 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT9 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT10 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT11 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT12 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT13 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT14 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT15 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT16 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT17 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT18 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT19 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT20 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT21 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT22 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT23 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT24 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT25 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT26 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT27 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT28 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT29 VARCHAR2 40 This is a transaction source segment. Active
DSP_SEGMENT30 VARCHAR2 40 This is a transaction source segment. Active
TRANSACTION_SOURCE_NAME VARCHAR2 120 Name of the transaction source. Active
TRANSACTION_SOURCE_TYPE_ID NUMBER 18 Transaction source type identifier Active
TRANSACTION_SOURCE_TYPE_NAME VARCHAR2 30 Transaction Source Type Name. The values are based on Transaction Source Type Name in INV_TXN_SOURCE_TYPES_TL.
TRANSACTION_ACTION_ID VARCHAR2 30 Identifies the transaction action. Active
TRANSACTION_ACTION_NAME VARCHAR2 80 Transaction Action Name. The values are based on the lookup type INV_TRANSACTION_ACTION in FND_LOOKUPS.
TRANSACTION_TYPE_ID NUMBER 18 Identifies the transaction type. Active
TRANSACTION_TYPE_NAME VARCHAR2 80 Transaction Type Name. The values are based on Transaction Type Name in INV_TRANSACTION_TYPES_TL.
REQUESTER_ID NUMBER 18 Reference to unique identifier of the requester.
REQUESTER_NAME VARCHAR2 240 Name of the requester of the material issued or received.
REQUESTER_NUMBER VARCHAR2 30 Value that uniquely identifies the requester.
REASON_ID NUMBER 18 This identifies the transaction reason. Active
REASON_NAME VARCHAR2 80 Reason Name. The values are based on the lookup type INV_REASON_TYPES in FND_LOOKUPS.
TRANSACTION_REFERENCE VARCHAR2 240 This code is the transaction reference. Active
TRANSACTION_COST NUMBER Transaction cost; this is a per-unit value Active
DISTRIBUTION_ACCOUNT_ID NUMBER 18 This identifies the GL code combination. Active
DST_SEGMENT1 VARCHAR2 25 Distribution account segment identifier 1 Active
DST_SEGMENT2 VARCHAR2 25 Distribution account segment identifier 2 Active
DST_SEGMENT3 VARCHAR2 25 Distribution account segment identifier 3 Active
DST_SEGMENT4 VARCHAR2 25 Distribution account segment identifier 4 Active
DST_SEGMENT5 VARCHAR2 25 Distribution account segment identifier 5 Active
DST_SEGMENT6 VARCHAR2 25 Distribution account segment identifier 6 Active
DST_SEGMENT7 VARCHAR2 25 Distribution account segment identifier 7 Active
DST_SEGMENT8 VARCHAR2 25 Distribution account segment identifier 8 Active
DST_SEGMENT9 VARCHAR2 25 Distribution account segment identifier 9 Active
DST_SEGMENT10 VARCHAR2 25 Distribution account segment identifier 10 Active
DST_SEGMENT11 VARCHAR2 25 Distribution account segment identifier 11 Active
DST_SEGMENT12 VARCHAR2 25 Distribution account segment identifier 12 Active
DST_SEGMENT13 VARCHAR2 25 Distribution account segment identifier 13 Active
DST_SEGMENT14 VARCHAR2 25 Distribution account segment identifier 14 Active
DST_SEGMENT15 VARCHAR2 25 Distribution account segment identifier 15 Active
DST_SEGMENT16 VARCHAR2 25 Distribution account segment identifier 16 Active
DST_SEGMENT17 VARCHAR2 25 Distribution account segment identifier 17 Active
DST_SEGMENT18 VARCHAR2 25 Distribution account segment identifier 18 Active
DST_SEGMENT19 VARCHAR2 25 Distribution account segment identifier 19 Active
DST_SEGMENT20 VARCHAR2 25 Distribution account segment identifier 20 Active
DST_SEGMENT21 VARCHAR2 25 Distribution account segment identifier 21 Active
DST_SEGMENT22 VARCHAR2 25 Distribution account segment identifier 22 Active
DST_SEGMENT23 VARCHAR2 25 Distribution account segment identifier 23 Active
DST_SEGMENT24 VARCHAR2 25 Distribution account segment identifier 24 Active
DST_SEGMENT25 VARCHAR2 25 Distribution account segment identifier 25 Active
DST_SEGMENT26 VARCHAR2 25 Distribution account segment identifier 26 Active
DST_SEGMENT27 VARCHAR2 25 Distribution account segment identifier 27 Active
DST_SEGMENT28 VARCHAR2 25 Distribution account segment identifier 28 Active
DST_SEGMENT29 VARCHAR2 25 Distribution account segment identifier 29 Active
DST_SEGMENT30 VARCHAR2 25 Distribution account segment identifier 30 Active
REQUISITION_LINE_ID NUMBER 18 Identifies the requisition line. Active
REQUISITION_DISTRIBUTION_ID NUMBER 18 Requisition distribution identifier Active
CURRENCY_CODE VARCHAR2 30 This indicates the currency to use. Active
CURRENCY_NAME VARCHAR2 80 Currency Name. The values are based on Name in FND_CURRENCIES_VL.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Indicates the type of currency conversion. Active
CURRENCY_CONVERSION_RATE NUMBER This column sets the currency conversion rate. Active
USSGL_TRANSACTION_CODE VARCHAR2 30 This is the USSGL transaction code. Active
WIP_ENTITY_TYPE NUMBER This indicates the WIP entity type. Active
SCHEDULE_ID NUMBER 18 WIP repetitive schedule identifier Active
EMPLOYEE_CODE VARCHAR2 10 This code indicates the employee. Active
DEPARTMENT_ID NUMBER 18 Holds WIP WORK CENTER ID required for Costing purposes Active
SCHEDULE_UPDATE_CODE NUMBER Code indicating whether or not to update the Master Production Schedule Active
SETUP_TEARDOWN_CODE NUMBER This code indicates the setup teardown. Active
PRIMARY_SWITCH NUMBER Flag indicating whether inventory item is a primary assembly for WIP (1 for primary assembly, null otherwise) Active
MRP_CODE NUMBER Code indicating whether MRP should be relieved for WIP Active
OPERATION_SEQ_NUM NUMBER Operation sequence number within a routing 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
PICKING_LINE_ID NUMBER 18 Reservation picking line identifier Active
TRX_SOURCE_LINE_ID NUMBER 18 Line identifier for sales orders Active
TRX_SOURCE_DELIVERY_ID NUMBER 18 Delivery identifier for sales orders Active
CUSTOMER_SHIP_ID NUMBER 18 Customer ship-to address identifier for sales orders Active
LINE_ITEM_NUM NUMBER Line item number for purchase orders Active
RECEIVING_DOCUMENT VARCHAR2 10 This indicates the receiving document. Active
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier; Not currently used Active
SHIP_TO_LOCATION_ID NUMBER 18 This identifies the ship-to location. Active
VENDOR_LOT_NUMBER VARCHAR2 30 This is the supplier lot number. Active
TRANSFER_SUBINVENTORY VARCHAR2 10 Destination subinventory name for a transfer transaction Active
TRANSFER_ORGANIZATION NUMBER 18 Destination organization identifier for transfer transactions Active
TRANSFER_ORGANIZATION_NAME VARCHAR2 240 Transfer Organization Name. The values are based on Organization Name in INV_ORGANIZATION_DEFINITIONS_V.
TRANSFER_LOCATOR NUMBER 18 Destination locator identifier for transfer transactions; transfer to location must be specified for inventory items under location control either by transfer to location identifier, or by individual segment values Active
XFER_LOC_SEGMENT1 VARCHAR2 40 Transfer locator segment identifier 1 Active
XFER_LOC_SEGMENT2 VARCHAR2 40 Transfer locator segment identifier 2 Active
XFER_LOC_SEGMENT3 VARCHAR2 40 Transfer locator segment identifier 3 Active
XFER_LOC_SEGMENT4 VARCHAR2 40 Transfer locator segment identifier 4 Active
XFER_LOC_SEGMENT5 VARCHAR2 40 Transfer locator segment identifier 5 Active
XFER_LOC_SEGMENT6 VARCHAR2 40 Transfer locator segment identifier 6 Active
XFER_LOC_SEGMENT7 VARCHAR2 40 Transfer locator segment identifier 7 Active
XFER_LOC_SEGMENT8 VARCHAR2 40 Transfer locator segment identifier 8 Active
XFER_LOC_SEGMENT9 VARCHAR2 40 Transfer locator segment identifier 9 Active
XFER_LOC_SEGMENT10 VARCHAR2 40 Transfer locator segment identifier 10 Active
XFER_LOC_SEGMENT11 VARCHAR2 40 Transfer locator segment identifier 11 Active
XFER_LOC_SEGMENT12 VARCHAR2 40 Transfer locator segment identifier 12 Active
XFER_LOC_SEGMENT13 VARCHAR2 40 Transfer locator segment identifier 13 Active
XFER_LOC_SEGMENT14 VARCHAR2 40 Transfer locator segment identifier 14 Active
XFER_LOC_SEGMENT15 VARCHAR2 40 Transfer locator segment identifier 15 Active
XFER_LOC_SEGMENT16 VARCHAR2 40 Transfer locator segment identifier 16 Active
XFER_LOC_SEGMENT17 VARCHAR2 40 Transfer locator segment identifier 17 Active
XFER_LOC_SEGMENT18 VARCHAR2 40 Transfer locator segment identifier 18 Active
XFER_LOC_SEGMENT19 VARCHAR2 40 Transfer locator segment identifier 19 Active
XFER_LOC_SEGMENT20 VARCHAR2 40 Transfer locator segment identifier 20 Active
SHIPMENT_NUMBER VARCHAR2 30 This is the intratransit shipment number. Active
TRANSPORTATION_COST NUMBER Transportation cost; per-transaction value Active
TRANSPORTATION_ACCOUNT NUMBER Transportation account identifier Active
TRANSFER_COST NUMBER Transfer cost; per-transaction value Active
FREIGHT_CARRIER_ID NUMBER 18 This identifies the shipping carrier. Active
CONTAINERS NUMBER This is number of packing units. Active
WAYBILL_AIRBILL VARCHAR2 20 This is the waybill or airbill number. Active
EXPECTED_ARRIVAL_DATE DATE Expected arrival date; truncated, no timestamp 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 Percentage change for average cost update Active
LOT_NUMBER VARCHAR2 30 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
ERROR_CODE VARCHAR2 240 This is the error code returned by the transaction manager. Active
REQUIRED_FLAG VARCHAR2 1 Flag indicates if this is required. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE) Active
ERROR_EXPLANATION VARCHAR2 240 This is the error explanation text. Active
VALIDATION_REQUIRED NUMBER Flag indicates if full validation is required. Active
DEMAND_ID NUMBER 18 This column identifies the demand. 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 Demand source delivery identifier Active
NEGATIVE_REQ_FLAG NUMBER Flag controls negative requirement. Active
CURRENCY_CONVERSION_DATE DATE This column sets the currency conversion date. Active
SHIPPABLE_FLAG VARCHAR2 1 This flag indicates if the item is shippable. 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
INVENTORY_ITEM VARCHAR2 2000 Concatenated inventory item number used for shipping transactions interface Active
LOCATOR_NAME VARCHAR2 2000 Concatenated inventory locator name for shipping transactions interface 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 Indicates the percentage of value to be attributed to transfer costs in an inter-org transfer. Active
TRANSACTION_SEQUENCE_ID NUMBER 18 Transaction sequence identifier (currently not used) Active
ROUTING_REVISION VARCHAR2 3 Routing revision used for getting the routing information while charging the flow schedule 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
ACCOUNTING_CLASS VARCHAR2 10 Accounting class to be used for the flow schedule Active
DEMAND_CLASS VARCHAR2 30 The class to which the demand is tied Active
PARENT_ID NUMBER 18 In substitution records for flow schedules, specifies the parent completion records transaction interface id Active
SOURCE_LOT_FLAG VARCHAR2 3 To identify the parent lot in lot transactions
LOT_TXN_GROUP_NAME VARCHAR2 30 To identify the group of lot transactions
SUBSTITUTION_TYPE_ID NUMBER 18 Identifies the kind of substitution allowed Active
SUBSTITUTION_ITEM_ID NUMBER 18 The substitution item's inventory Item ID Active
SCHEDULE_GROUP NUMBER Specifies schedule group (used for flow manufacturing) Active
BUILD_SEQUENCE NUMBER Specifies the sequence to be built (used for flow manufacturing) Active
SCHEDULE_NUMBER VARCHAR2 30 This is the flow schedule number. Active
SCHEDULED_FLAG NUMBER Specifies whether flow schedule is scheduled or not Active
FLOW_SCHEDULE VARCHAR2 1 Specifies whether the WIP transaction is a flow or schedule type transaction Active
KANBAN_CARD_ID NUMBER 18 This identifies the kanban card. 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
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
COST_TYPE_ID NUMBER 18 This column identifies the cost type. Active
LPN_ID NUMBER 18 License Plate Number Identifier Active
TRANSFER_LPN_ID NUMBER 18 Transfer License Plate Number Identifier Active
CONTENT_LPN_ID NUMBER 18 Transfer License Plate Number Identifier Active
XML_DOCUMENT_ID VARCHAR2 240 This identifies the XML document. Active
ORGANIZATION_TYPE VARCHAR2 30 Organization Type. The values are based on MTL_TP_TYPES lookup. Active
TRANSFER_ORGANIZATION_TYPE VARCHAR2 30 Transfer Organization Type. The values are based on MTL_TP_TYPES lookup. Active
OWNING_ORGANIZATION_ID NUMBER 18 Owning organization identifier. Refers to the supplier site id when OWNING_TP_TYPE is 1 and inventory organization id when OWNING_TP_TYPE is 2 Active
OWNING_ORGANIZATION_NAME VARCHAR2 240 Owning Organization Name. Stores supplier site code when OWNING_TP_TYPE is 1 and inventory organization name in INV_ORGANIZATION_DEFINITIONS_V when OWNING_TP_TYPE is 2.
OWNING_TP_TYPE VARCHAR2 30 Owning Trading Partner Type. The values are based on INV_OWNING_TYPES lookup. 1- Consigned Material, 2- Owned Material Active
PRC_BU_NAME VARCHAR2 240 Procurement Business Unit Name in case the material transacted is consigned. This is required for deriving OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID for the consigned material.
VENDOR_NAME VARCHAR2 240 Vendor name in case the material transacted is consigned. This is required for deriving OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID for the consigned material.
VENDOR_NUMBER VARCHAR2 30 Vendor number in case the material transacted is consigned. This is required for deriving OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID for the consigned material.
CONSIGNMENT_AGREEMENT_NUM VARCHAR2 30 Consignment agreement number for the consigned material. Mostly to be populated if the the Vendor Name, Vendor Number, Procurement Business Unit Name, Vendor Site Code is insufficient to derive the Vendor Site Id (OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID).
XFR_OWNING_ORGANIZATION_ID NUMBER 18 Transfer owning organization identifier. Refers to the supplier site id when TRANSFER_OWNING_TP_TYPE is 1 and inventory organization id when TRANSFER_OWNING_TP_TYPE is 2 Active
XFR_OWNING_ORGANIZATION_NAME VARCHAR2 240 Transfer Owning Organization Name. Stores supplier site code when TRANSFER_OWNING_TP_TYPE is 1 and inventory organization name in INV_ORGANIZATION_DEFINITIONS_V when TRANSFER_OWNING_TP_TYPE is 2.
TRANSFER_OWNING_TP_TYPE VARCHAR2 30 Transfer Owning Trading Partner Type. The values are based on INV_OWNING_TYPES lookup. 1- Consigned Material, 2- Owned Material. 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 code that may have been used to do the material transaction Active
SECONDARY_UNIT_OF_MEASURE VARCHAR2 25 Secondary unit of measure name that may have been used to do the material transaction
SECONDARY_TRANSACTION_QUANTITY NUMBER This is the secondary transaction quantity. Active
TRANSACTION_GROUP_ID NUMBER 18 This identifies the transaction group. Active
TRANSACTION_GROUP_SEQ NUMBER This is the sequence of the transaction group. Active
REPRESENTATIVE_LOT_NUMBER VARCHAR2 80 This is the representative lot number. Active
TRANSACTION_BATCH_ID NUMBER 18 This identifies the batch for transactions. Active
TRANSACTION_BATCH_SEQ NUMBER 18 Batch sequence for transactions. Active
REBUILD_ITEM_ID NUMBER 18 Rebuildable item that needs to be replaced/repaired Active
REBUILD_SERIAL_NUMBER VARCHAR2 80 Serial Number of the Rebuild Item Active
REBUILD_ACTIVITY_ID NUMBER 18 Maintenance Activity that needs to be done on rebuildable item Active
REBUILD_JOB_NAME VARCHAR2 240 Name of Rebuild Work Order that has been defined for rebuiladable item 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_SUPPLY_TYPE NUMBER WIP supply type describes the consumption method. 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
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
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
PJC_CONTEXT_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_PROJECT_ID NUMBER 18 Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_TASK_ID NUMBER 18 Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_EXPENDITURE_TYPE_ID NUMBER 18 Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_EXPENDITURE_ITEM_DATE DATE Date on which a project-related transaction is incurred. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_BILLABLE_FLAG VARCHAR2 1 Flag that indicates if a project-related item is available to be billed to customers. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_CAPITALIZABLE_FLAG VARCHAR2 1 Flag that indicates if a project-related item is eligible for capitalization. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_WORK_TYPE_ID NUMBER 18 Identifier for project-related classification of the worked performed. Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_CONTRACT_ID NUMBER 18 Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. Active
PJC_CONTRACT_LINE_ID NUMBER 18 Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. Active
PJC_FUNDING_ALLOCATION_ID NUMBER 18 Specifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed Active
PJC_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE3 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE4 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE5 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE6 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE7 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE8 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE9 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_RESERVED_ATTRIBUTE10 VARCHAR2 150 Reserved for future project-related functionality Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
PJC_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user-definable project information Project Costing Details (PROJECTS_STD_COST_COLLECTION) Active
BOM_REVISION VARCHAR2 3 Item revision used for getting the bill information while backflushing the flow schedule Active
BOM_REVISION_DATE DATE Date of inventory item revision used for exploding the bill for the flow schedule 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
BUILD_BREAK_TO_UOM VARCHAR2 3 Code of the unit of measure for build break to. Active
BUILD_BREAK_TO_UNIT_OF_MEASURE VARCHAR2 25 Name of the unit of measure for build break to.
ITEM_NUMBER VARCHAR2 300 Added to replace KFF structure. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Transaction interface (INV_TRANSACTIONS_INTERFACE)
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 VARCHAR2 240 Tax Determinant: Intended use code of the transaction line. This identifies the purpose for which the product is used.
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.
FIRST_PTY_NUMBER VARCHAR2 30 Tax Determinant: Used to derive the First Party Reg ID. Used for SAAS processing.
TAX_REGIME_CODE VARCHAR2 30 Tax Determinant: Used to derive the First Party Reg ID. Used for SAAS processing.
TAX_JURISDICTION_CODE VARCHAR2 30 Tax Determinant: Used to derive the First Party Reg ID. Used for SAAS processing.
TAX VARCHAR2 30 Tax Determinant: Used to derive the First Party Reg ID. Used for SAAS processing.
THIRD_PTY_NUMBER VARCHAR2 30 Tax Determinant: Used to derive the Third Party Reg ID. Used for SAAS processing.
THIRD_PARTY_TYPE_CODE VARCHAR2 30 Tax Determinant: Used to derive the Third Party Reg ID. Used for SAAS processing.
THIRD_PTY_SITE_NUM VARCHAR2 30 Tax Determinant: Used to derive the Third Party Reg ID. Used for SAAS processing.
TP_TAX_REGIME_CODE VARCHAR2 30 Tax Determinant: Used to derive the Third Party Reg ID. Used for SAAS processing.
TP_TAX_JURISDICTION_CODE VARCHAR2 30 Tax Determinant: Used to derive the Third Party Reg ID. Used for SAAS processing.
TP_TAX VARCHAR2 30 Tax Determinant: Used to derive the Third Party Reg ID. Used for SAAS processing.
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.
CATEGORY_NAME VARCHAR2 250 Category Name: Alterate key for tax determinant CATEGORY_ID
FINAL_DISCHARGE_LOC_CODE VARCHAR2 60 Final Discharge Location Code : Alternate key for FINAL_DISCHARGE_LOCATION_ID
TRANSACTION_INTERFACE_LINE_NUM VARCHAR2 30 Transaction interface line number
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.
ASSEMBLY_SERIAL_NUMBER VARCHAR2 80 The serial number of the parent assembly where the component was issued or returned.
TRANSFER_LOCATOR_NAME VARCHAR2 2000 Concatenated inventory transfer locator name for shipping transactions interface Active
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.
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
INV_PROJECT VARCHAR2 25 Project used to stripe Inventory transactions
INV_TASK VARCHAR2 100 Task used to stripe Inventory transactions
COUNTRY_OF_ORIGIN_NAME VARCHAR2 80 Country of manufacture used to stripe Inventory transactions
TRANSFER_INV_PROJECT VARCHAR2 25 Transfer Project used in project transfer transactions
TRANSFER_INV_TASK VARCHAR2 100 Transfer Task used in project transfer transactions
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
PJC_PROJECT_NUMBER VARCHAR2 25 Project number used for project related transactions.
PJC_TASK_NUMBER VARCHAR2 100 Task number used for project related transactions.
PJC_EXPENDITURE_TYPE_NAME VARCHAR2 240 Expenditure type name used for project related transactions.
PJC_EXPENDITURE_ORG_NAME VARCHAR2 240 Expenditure organization used for project related transactions.
PJC_CONTRACT_NUMBER VARCHAR2 120 Contract number used for project related transactions.
PJC_FUNDING_SOURCE_NAME VARCHAR2 360 Funding source name used for project related 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_TRANSACTIONS_INTERFACE gl_code_combinations DISTRIBUTION_ACCOUNT_ID
INV_TRANSACTIONS_INTERFACE egp_item_org_associations INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_TRANSACTIONS_INTERFACE inv_item_locations LOCATOR_ID
INV_TRANSACTIONS_INTERFACE inv_item_locations TRANSFER_LOCATOR
INV_TRANSACTIONS_INTERFACE inv_secondary_inventories SUBINVENTORY_CODE, ORGANIZATION_ID
INV_TRANSACTIONS_INTERFACE inv_secondary_inventories TRANSFER_SUBINVENTORY, TRANSFER_ORGANIZATION
INV_TRANSACTIONS_INTERFACE gl_code_combinations TRANSPORTATION_ACCOUNT
inv_transaction_lots_interface inv_transactions_interface TRANSACTION_INTERFACE_ID

Indexes

Index Uniqueness Tablespace Columns
INV_TXNS_INTERFACE_N1 Non Unique FUSION_TS_INTERFACE TRANSACTION_HEADER_ID
INV_TXNS_INTERFACE_N10 Non Unique FUSION_TS_INTERFACE TRANSACTION_BATCH_ID
INV_TXNS_INTERFACE_N11 Non Unique FUSION_TS_INTERFACE LOAD_REQUEST_ID
INV_TXNS_INTERFACE_N12 Non Unique FUSION_TS_INTERFACE LOT_TXN_GROUP_NAME
INV_TXNS_INTERFACE_N2 Non Unique FUSION_TS_INTERFACE PARENT_ID
INV_TXNS_INTERFACE_N3 Non Unique FUSION_TS_INTERFACE PICKING_LINE_ID
INV_TXNS_INTERFACE_N4 Non Unique FUSION_TS_INTERFACE TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_ID
INV_TXNS_INTERFACE_N5 Non Unique FUSION_TS_INTERFACE ORGANIZATION_ID, PROCESS_FLAG
INV_TXNS_INTERFACE_N6 Non Unique FUSION_TS_INTERFACE TRANSACTION_INTERFACE_LINE_NUM
INV_TXNS_INTERFACE_N7 Non Unique FUSION_TS_INTERFACE EXTERNAL_SYS_TXN_REFERENCE
INV_TXNS_INTERFACE_N8 Non Unique FUSION_TS_INTERFACE ITEM_NUMBER, ORGANIZATION_NAME
INV_TXNS_INTERFACE_N9 Non Unique FUSION_TS_INTERFACE INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_TXNS_INTERFACE_U1 Unique FUSION_TS_INTERFACE TRANSACTION_INTERFACE_ID