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 | ||
ASSEMBLY_ASSET_ID | NUMBER | 18 | The work order asset for which the material transactions are performed. | ||||
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 | |||
SHIPMENT_LINE_NUMBER | NUMBER | 9 | This is the intratransit shipment line number. | ||||
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 |