1. Tables and Views for SCM
  2. CST_I_INV_TRANSACTIONS

CST_I_INV_TRANSACTIONS

This is the interface table receiving the inventory transactions from inventory system.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CST_I_INV_TRANSACTIONS_PK

EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID

Columns

Name Datatype Length Precision Not-null Comments
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Yes Reference Information from an External system (external to Cost Management).
DOO_SPLIT_FULFILL_LINE_ID NUMBER 18 Reference to the distributed order orchestration (DOO) fulfillment line identifier.
DS_SOURCE_LINE_ID NUMBER 18 Based on Flow Type(ASN OR INVOICE) either Shipment Line Id or Transaction Event Id will be stored
REFERENCE_DELIVERY_ID NUMBER 18 Referenced delivery id identifier for RMA.
FISCAL_DOC_HEADER_ID NUMBER 18 This column stores the unique identifier for the fiscal document header.
FISCAL_DOC_ACCESS_KNUM VARCHAR2 64 This column stores the access key number corresponding to the fiscal document.
FISCAL_DOC_LINE_ID NUMBER 18 This column stores the unique identifier for the fiscal document line.
REF_FISCAL_DOC_HEADER_ID NUMBER 18 This column stores the unique identifier for the reference fiscal document header.
REF_FISCAL_DOC_LINE_ID NUMBER 18 This column stores the unique identifier for the reference fiscal document line.
REF_FISCAL_DOC_ACCESS_KNUM VARCHAR2 64 This column stores the access key number corresponding to the reference fiscal document.
FISCAL_DOC_SCHEDULE_ID NUMBER 18 This column stores the unique identifier for the fiscal document schedule.
REF_FISCAL_DOC_SCHEDULE_ID NUMBER 18 This column stores the unique identifier for the reference fiscal document schedule.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Stores a value that uniquely identifies a certain instance of an object within the external system
BUSINESS_UNIT_ID NUMBER 18 Yes Business Unit Id of the Inventory Organization
INVENTORY_ORG_ID NUMBER 18 Yes Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory Item identifier entered on the transaction.
TRANSACTION_SOURCE_TYPE_ID NUMBER 18 Yes Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, but a custom source type is treated as INVENTORY (value>100 is brought in as 13), and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES
INV_TXN_SOURCE_TYPE_ID NUMBER 18 Yes Transaction source type identifier including custom source types.
TRANSACTION_ACTION_ID NUMBER 18 Yes Transaction action identifier maps inventory transaction action.
TRANSACTION_TYPE_ID NUMBER 18 Yes Transaction type identifier including custom and logical transactions.
TRANSACTION_DATE DATE Yes Transaction Date when the quantity movement is tracked.
TRANSACTION_CREATION_DATE DATE Yes Transaction creation date when transaction is performed.
TRANSACTION_TIMEZONE_CODE VARCHAR2 50 Timezone code based on transaction date
TRANSACTION_QTY NUMBER Yes Transaction Quantity in transaction unit of measure.
TRANSACTION_UOM_CODE VARCHAR2 3 Yes Transaction unit of measure Code.
PRIMARY_QTY NUMBER Yes Transaction quantity in primary unit of measure
PRIMARY_UOM_CODE VARCHAR2 3 Yes Primary unit of measure of the item.
SECONDARY_TRANSACTION_QTY NUMBER Transaction quantity in secondary unit of measure
SECONDARY_TRANSACTION_UOM_CODE VARCHAR2 3 Inventory Items secondary UOM Code
SUBINVENTORY_CODE VARCHAR2 10 The subinventory code where the item is stored.
LOCATOR_ID NUMBER 18 Item locator identifier entered while performing a transaction
PARENT_TRANSACTION_ID NUMBER 18 OBSOLETE: Parent Transaction identifier
TRANSACTION_REASON_ID NUMBER 18 User entered transaction reason Identifier while performing inventory transaction.
TRANSFER_TRANSACTION_ID NUMBER 18 Transaction id of the opposing transfer transaction
ORIGINAL_TRANSACTION_TEMP_ID NUMBER 18 Transaction Temp Id that was generated when the Inventory transaction was saved.
TRANSFER_INVENTORY_ORG_ID NUMBER 18 Transfer opposing inventory organization id
TRANSFER_SUBINVENTORY_CODE VARCHAR2 10 Transfer transaction opposing subinventory
TRANSFER_LOCATOR_ID NUMBER 18 Transfer transaction opposing locator id
TRANSFER_PERCENTAGE NUMBER OBSOLETE: Percentage of value to attribute to transfer costs in an Inter-Orgtransfer
TRANSACTION_FLOW_TYPE NUMBER 18 Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others.
EXPENSE_TRANSACTION_FLAG VARCHAR2 1 Identifies whether a transaction is an asset or expense transaction
FOB_POINT NUMBER 1 OBSOLETE: Indicates the 'Free on board' point and determines the point of transfer of liability/ownership.
INTERCOMPANY_INVOICING_FLAG VARCHAR2 1 OBSOLETE: Indicates whether the transaction is eligible for intercompany invoicing or not
PRICING_OPTION NUMBER 18 OBSOLETE: Pricing Option Identifier
INTERFACE_BATCH_NUMBER VARCHAR2 50 Batch Number of External Systems interface run. Added to facilitate source system to identify which transactions were sent in which run on the source system.
INTERFACE_BATCH_NAME VARCHAR2 250 Batch Name of External Systems interface run.
TRANSACTION_STATUS VARCHAR2 5 Preprocessing status of the transaction. Valid values are 'P' - Pending, and 'E' - Error
RCV_TRANSACTION_ID NUMBER 18 Single column FK: identifies the Receiving transaction of this interfaced transaction.
PO_DISTRIBUTION_ID NUMBER 18 Single column FK: identifies the PO distribution of this interfaced transaction.
PO_ITEM_DESCRIPTION VARCHAR2 240 Item Description for purchase orders where purchase is made for non inventory items.
TRANSACTION_AMOUNT NUMBER Transaction Amount in purchase order currency. Applicable for fixed price lines.
TRANSACTION_CURRENCY_CODE VARCHAR2 15 Purchase order currency for the amount column. Applicable for fixed price lines
PO_ITEM_DESCRIPTION_TYPE VARCHAR2 30 Indicates the type of purchase in case purchase is made for non-inventory item based on a description. Valid values are GOODS or SERVICES.
WSH_DELIVERY_DETAIL_ID NUMBER 18 Single column FK: identifies the Shipment delivery detail of the interfaced transaction. This column actually stores the DELIVERY_ID from Fusion Logistics.
DOO_FULLFILL_LINE_ID NUMBER 18 Reference to the unique identifier of the source fulfillment line in distributed order orchestration (DOO).
CODE_COMBINATION_ID NUMBER 18 Single column FK: identifies the Code combination of the account entered by the users while creating the transactions (Misc. Transactions).
WORK_ORDER_ID NUMBER 18 Surrogate ID identifying a work order in manufacturing.
SUPPLY_TYPE VARCHAR2 30 The various supply types are "Assembly Pull", "Operation Pull", "Push", and Phantom. This list will have to be seeded as lookups with the type "EGP_WIP_SUP_TYPE".
WORK_ORDER_OPERATION_ID NUMBER 18 Surrogate ID identifying an operation within a work order.
WORK_CENTER_ID NUMBER 18 Surrogate ID identifying Work Center where the operation is executed.
WO_OPERATION_TRANSACTION_ID NUMBER 18 Surrogate ID identifying a work order operation transaction that created this material transactions.
TXN_SOURCE_DOC_TYPE VARCHAR2 50 This Transaction's Source Document Type
TXN_SOURCE_DOC_NUMBER VARCHAR2 240 This Transaction's Source Document Number
TXN_SOURCE_REF_DOC_TYPE VARCHAR2 50 This Transaction's Source Document's Reference Document Type
TXN_SOURCE_REF_DOC_NUMBER VARCHAR2 240 This Transaction's Source Document's Reference Document Number
TRANSACTION_REFERENCE VARCHAR2 240 Source system transaction reference.
FROM_GRADE_CODE VARCHAR2 150 Transaction from grade code during grade transfers.
TO_GRADE_CODE VARCHAR2 150 Transaction to grade code during grade transfers.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE21 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE22 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE23 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE24 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE25 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE26 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE27 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE28 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE29 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE30 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
PJC_PROJECT_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget
PJC_TASK_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget
PJC_EXPENDITURE_ITEM_DATE DATE DFF Column used by Standardized Project Cost Collection Widget
PJC_ORGANIZATION_ID NUMBER 18 Project expenditure item organization Identifier for project related transactions
PJC_EXPENDITURE_TYPE_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget
PJC_CONTEXT_CATEGORY VARCHAR2 40 DFF Context Column used by Standardized Project Cost Collection Widget
PJC_BILLABLE_FLAG VARCHAR2 1 DFF Column used by Standardized Project Cost Collection Widget
PJC_CONTRACT_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget
PJC_WORK_TYPE_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget
PJC_FUNDING_ALLOCATION_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget
PJC_CONTRACT_LINE_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE1 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE2 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE3 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE4 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE5 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE6 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE7 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE8 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE9 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_USER_DEF_ATTRIBUTE10 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_CAPITALIZABLE_FLAG VARCHAR2 1 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE1 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE2 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE3 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE4 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE5 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE6 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE7 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE8 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE9 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
PJC_RESERVED_ATTRIBUTE10 VARCHAR2 150 DFF Column used by Standardized Project Cost Collection Widget
INTERNAL_PROFIT_TRACKING VARCHAR2 1 OBSOLETE: Internal Profit Tracking (Used by internal processes)
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.
PROD_FC_CATEG_ID NUMBER 18 Tax Determinant : Category ID, used to store the internal ID for Product Fiscal Classification.
PRODUCT_CATEGORY VARCHAR2 240 Tax Determinant: Product category code of the transaction line.
INTENDED_USE_CLASSIF_ID NUMBER 18 Tax Determinant: Intended Use Classification Identifier.
PRODUCT_TYPE VARCHAR2 240 Tax Determinant: Product type code of the inventory item. Possible values are GOODS and SERVICES.
ASSESSABLE_VALUE NUMBER Tax Determinant: Assessable value 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.
SHIP_FROM_LOCATION_ID NUMBER 18 Tax Determinant: Ship from location identifier.
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Tax Determinant: Tax exemption certificate number.
EXEMPT_REASON_CODE VARCHAR2 30 Tax Determinant: Tax exemption reason code.
TRX_WAYBILL_NUMBER VARCHAR2 50 Tax Determinant: Waybill or airbill number.
PORT_OF_DISCHARGE VARCHAR2 150 Port of discharge for the sales order shipment.
PORT_OF_LOADING VARCHAR2 150 Port of loading for the sales order shipment.
DELIVERY_TYPE VARCHAR2 30 Delivery type of the sales order shipment - STANDARD, CONSOLIDATED
DELIVERY_DETAIL_ID NUMBER 18 Single column FK: identifies the Shipment delivery detail id of the interfaced transaction.
TRADE_AGREEMENT_PTR_ID NUMBER 18 Identifies the primary trade relationship of the SFO agreement.
TRADE_AGREEMENT_FTR_ID NUMBER 18 Financial agreement identifier defined on a document flow in financial orchestration system.
TRADE_AGREEMENT_TYPE VARCHAR2 20 To be used by the accounting template instead of transaction_flow_type. Populate this for all SFO related physical transactions (even when we do not explicitly call SFO)
TRADE_AGREEMENT_NUMBER VARCHAR2 100 Required for interorg shipment, SO Issue, RMA receipt to identify that it is SFO related. All these cases call SFO to figure it out.
SUCCESSOR_INVENTORY_ORG_ID NUMBER 18 Required for SO Issue, interorg shipment, TO shipment to provide as a source in SLA because accounting of this hits Trade Intransit.
SUCCESSOR_BUSINESS_UNIT_ID NUMBER 18 Required for SO Issue, interorg shipment, TO shipment to provide as a source in SLA because accounting of this hits Trade Intransit.
PRIOR_INVENTORY_ORG_ID NUMBER 18 Required for direct interorg receipt to provide as a source in SLA because accounting of this hits Trade Intransit (as there is no receiving involved here).
PRIOR_BUSINESS_UNIT_ID NUMBER 18 Required for direct interorg receipt to provide as a source in SLA because accounting of this hits Trade Intransit (as there is no receiving involved here).
TRANSFER_ORDER_LINE_ID NUMBER 18 Inventory transaction transfer order document line identifier.
TRANSFER_ORDER_DISTRIBUTION_ID NUMBER 18 Required for transfer order related receipts. Where it does not come from the interface, qty preprocessor will derive it based on ascending order of distribution identifier (to keep it in sync with how Inventory derives it).
ORIGINAL_RECEIPT_TXN_ID NUMBER 18 This column is populated only for transactions involving consigned material, with the original deliver transaction identifier in Receiving.
ORIGINAL_RECEIPT_INV_ORG_ID NUMBER 18 The Inventory organization where the original receipt of consigned goods was received.
OWNER_TYPE NUMBER 18 This is the party that transfers the ownership to the org where the ownership change happens. Values: 1 is SUPPLIER, 2 is INVENTORY_ORG, null is for non-consigned scenario
OWNING_ENTITY_ID NUMBER 18 Identifies the party who currently owns the goods.
TRANSFER_TO_REGULAR_TXN_ID NUMBER 18 Identifies the transfer to regular transaction that is being returned. This is only populated to transfer to consigned transactions.
CURRENCY_CONVERSION_RATE NUMBER The conversion rate from the entered currency on the purchase order to the functional currency of the Bill to business unit on the purchase order. This is relevant only for supplier consigned ownership change transactions.
OWNER_NAME VARCHAR2 30 For consigned transactions this column stores the supplier number in case an external supplier is involved. For internal consigned functionality this column stores the inventory org information.
ORIGINAL_RECEIPT_NUMBER VARCHAR2 50 This column stores the receipt number of the transaction along with the Inventory Org code of org where goods are first received.
TRANSACTION_INTERFACE_LINE_NUM VARCHAR2 30 Identifies the inventory transaction entered via the saas interface.
LOAD_REQUEST_ID NUMBER 18 Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
TRANSACTION_INTERFACE_ID NUMBER 18 Transaction Identifier from INV_TRANSACTIONS_INTERFACE
SOURCE_SALES_ORDER_NUMBER VARCHAR2 150 Sales order document number from shipping system.
SOURCE_SALES_ORDER_LINE_NUMBER VARCHAR2 150 Sales order line number from shipping
SOURCE_SO_SHIPMENT_NUMBER VARCHAR2 20 Sales order shipment number from shipping
SALES_ORDER_SOURCE_SYSTEM VARCHAR2 90 Source system indicator of sales order document
RECEIPT_ADVICE_NUMBER VARCHAR2 80 Consigned Receipt advice number.
RECEIPT_ADVICE_LINE_NUMBER VARCHAR2 80 Consigned Receipt advice line number.
REFERENCED_SO_NUMBER VARCHAR2 80 Reference Sales Order document number on a transaction.
REFERENCED_SO_LINE_NUMBER VARCHAR2 80 Reference Sales Order document line number on a transaction.
INV_TRANSFER_ORDER_LINE_ID NUMBER 18 Transfer order line identifier and every transfer order related transaction must have this.
INV_TRANSFER_ORDER_DIST_ID NUMBER 18 Transfer Order distribution identifier.
INV_TRANSFER_ORDER_HEADER_ID NUMBER 18 Inventory transaction transfer order header id.
ORIGINAL_TO_SHIPMENT_TXN_ID NUMBER 18 For return shipment transactions, this references the original forward flow transaction id.
MANUAL_RECEIPT_REQD_FLAG VARCHAR2 1 Flag to denote Manual receipt is created or not for transfer to expense destination
REFERENCE_DOO_FULLFILL_LINE_ID NUMBER 18 Referenced fulfillment line identifier
CST_WORK_ORDER_ID NUMBER 18 Surrogate ID identifying a work order in costing.
CST_WORK_ORDER_OPERATION_ID NUMBER 18 Surrogate ID identifying a work order operation in costing.
CST_WO_OPERATION_TXN_ID NUMBER 18 Surrogate ID identifying the manufacturing operation transaction creating the material transaction.
SHIPPING_INV_ORG_ID NUMBER 18 Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows.
SHIPPING_BU_ID NUMBER 18 Profit Center Business Unit of Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows.
RETURN_INV_ORG_ID NUMBER 18 Inventory org of return receipt.
RETURN_BU_ID NUMBER 18 Profit Center Business Unit of Inventory Org where the return receipt.
REFERENCED_RETURN_FLAG VARCHAR2 1 Possible values Y/N/NULL. Mainly used for referenced RMA. Y means return is a referenced return N means it is unreferenced NULL means that it is a pre-R13 return flow.
SIMPLE_PROC_FLAG VARCHAR2 5 Whether the Dropship Delivery is for Simple Procurement (Y) or for Global Procurement flow (N).
CONSUMPTION_UNIT_PRICE NUMBER Transfer to owned transaction unit price
WO_OUTPUT_TYPE VARCHAR2 30 Type of output produced on a process manufacturing work order. Valid values exist in the lookup ORA_WIS_WD_OUTPUT_MATERIAL.
PRIMARY_PRODUCT_FLAG VARCHAR2 1 Indicates whether this is the primary output for the work order. Valid values are Y or N.
WO_COST_ALLOCATION_BASIS VARCHAR2 30 The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. Valid values exist in lookup ORA_WIS_COST_ALLOC_BASIS.
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for Inventory striping attributes
PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions
TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions
WMS_FLAG VARCHAR2 1 Indicates whether the transaction is WMS reconciliation.
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
SUPPLIER_RETURN_HEADER_ID NUMBER 18 Unique identifier for supplier return header.
SUPPLIER_RETURN_LINE_ID NUMBER 18 Unique identifier for supplier return line.
RECALL_HEADER_ID NUMBER 18 Unique identifier for recall header.
RECALL_LINE_ID NUMBER 18 Unique identifier for recall line.
PARENT_ID NUMBER 18 This column identifies source and resultant transaction group for lot merge, translate and split flows.
SOURCE_LOT_FLAG VARCHAR2 3 To identify source transactions for lot merge, translate and split flows. Values: (Y) for Source transaction, (N) for resultant transaction and null in case of other flows.
TXN_COST_CALLBACK_FLAG VARCHAR2 1 Interface the transaction cost to financial orchestration system or not.
REF_RCV_TRANSACTION_ID NUMBER 18 This column identifies the receiving transaction identifier for Shipment and Receipt transactions in the Internal Material Transfers forward and return flows.

Foreign Keys

Table Foreign Table Foreign Key Column
cst_i_inv_transaction_dtls cst_i_inv_transactions EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID

Indexes

Index Uniqueness Tablespace Columns
CST_I_INV_TRANSACTIONS_N1 Non Unique FUSION_TS_TX_DATA REQUEST_ID
CST_I_INV_TRANSACTIONS_N2 Non Unique FUSION_TS_TX_DATA INVENTORY_ORG_ID
CST_I_INV_TRANSACTIONS_N3 Non Unique FUSION_TS_TX_DATA TRANSFER_INVENTORY_ORG_ID
CST_I_INV_TRANSACTIONS_N4 Non Unique FUSION_TS_TX_DATA TRANSACTION_STATUS
CST_I_INV_TRANSACTIONS_N5 Non Unique FUSION_TS_TX_DATA TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, DOO_FULLFILL_LINE_ID
CST_I_INV_TRANSACTIONS_N6 Non Unique FUSION_TS_TX_DATA EXTERNAL_SYSTEM_REFERENCE, TRANSACTION_INTERFACE_LINE_NUM, LOAD_REQUEST_ID
CST_I_INV_TRANSACTIONS_N7 Non Unique FUSION_TS_TX_DATA EXTERNAL_SYSTEM_REFERENCE, TO_CHAR("TRANSACTION_INTERFACE_ID"), LOAD_REQUEST_ID
CST_I_INV_TRANSACTIONS_N8 Non Unique Default WORK_ORDER_ID
CST_I_INV_TRANSACTIONS_PK Unique FUSION_TS_TX_DATA EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID