1. Tables and Views for SCM
  2. CST_TRANSACTIONS

CST_TRANSACTIONS

These are costing transactions. The imported inventory transactions are converted to costing transaction type, exploded for Cost Org - Book and stamped with suitable costing setup like item cost profile, valuation unit and costing method etc.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_TRANSACTIONS_PK

TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSACTION_ID NUMBER 18 Yes Transaction identifier which uniquely identifies a transaction in costing.
UNREFERENCED_RMA_COST_CODE VARCHAR2 30 Cost option to value sales returns without any reference to the original sales order, which can be the existing item cost or the price on RMA order.
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.
LE_TIMEZONE_CODE VARCHAR2 50 Indicates Legal Entity Timezone for transaction.
COST_ORG_ID NUMBER 18 Yes Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Yes Single column FK: Identifies the Cost Book assigned to the Cost Organization.
VAL_STRUCTURE_ID NUMBER 18 Single column FK: Identifies the Valuation Structure.
STRUCTURE_INSTANCE_NUMBER NUMBER 18 Indicates Structure instance number for transaction.
VAL_UNIT_ID NUMBER 18 Indicates Valuation unit identifier for transaction.
VAL_UNIT_COMBINATION_ID NUMBER 18 Valuation Units Code Combination Identifier.
INVENTORY_ITEM_ID NUMBER 18 Yes Value that identifies the inventory item associated with the transaction.
INVENTORY_ORG_ID NUMBER 18 Indicates The Inventory Org To Which The Item Belongs.
COST_TRANSACTION_TYPE VARCHAR2 10 Yes Costing transaction type ISSUE or RECEIPT.
ADDITIONAL_PROCESSING_CODE VARCHAR2 240 Code specifying what kind of processing needs to be done. The value is defined in CST_INTERNAL_TXN_TYPE for the transaction type and is used by Cost Processors for additional processing.
LOGICAL_FLAG VARCHAR2 1 Yes This indicates whether this transaction type is logical. Such transactions have no on-hand quantity impact and do not trigger re-averaging. These transaction show the financial flow.
INTRANSIT_FLAG VARCHAR2 5 Yes To identify whether the transaction is a issue or receipt into intransit.
BASE_TXN_TYPE_ID NUMBER 18 Yes Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.
BASE_TXN_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.
BASE_TXN_ACTION_ID NUMBER 18 Yes Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS.
TRANSACTION_DATE TIMESTAMP The date when this transaction happened.
COST_DATE TIMESTAMP Date to be used for transaction sequencing.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
USE_ITEM_COST_FLAG VARCHAR2 1 Yes Identifies receipt transactions that did not come with its own cost and are to use an existing item cost in the system (current perpetual average, a specific layer cost, or the current standard cost). Valid values are Y/N. Does not apply to transfer transactions.
MATCHED_TO_COST_FLAG VARCHAR2 5 Yes Identifies transactions that have an associated cost in the CST_TRANSACTION_COSTS child table. Valid values are N/Y/X. Transactions for which this does not apply are marked with X. N means waiting for the incoming acquisition cost, transfer cost, or current item cost to be stamped in CTC.
MATCHED_TO_ADDL_TAX_FLAG VARCHAR2 4 Yes The values in this column indicates if additional taxes are required and available for the transaction. X - Not expected, N - Expected but missing, Y - Expected and present.
ITEM_COST_PROFILE_ID NUMBER 18 Single column FK: Identifies the Item Cost Profile.
COST_PROFILE_ID NUMBER 18 Single column FK: Identifies Cost Profile associated with the transaction.
EXPENSE_TRANSACTION_FLAG VARCHAR2 1 Identifies whether a transaction is an asset or expense transaction.
COST_METHOD_CODE VARCHAR2 30 The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup_type CST_COST_METHODS.
NEGATIVE_QTY_CODE VARCHAR2 30 The negative quantity code defines the action of cost method processors when the inventory quantity becomes negative. Value comes from lookup_type CST_NEGATIVE_QUANTITY_CODES.
QUANTITY_FLOW_CODE VARCHAR2 30 Quantity flow code, FIFO or LIFO. Value comes from lookup_type CST_QUANTITY_FLOW_CODES.
ENFORCE_TXN_DATE_ORDER_FLAG VARCHAR2 5 Profile option to have cost dates in the same order as the transaction date. Possible values are (Y)es and (N)o.
QUANTITY NUMBER Value that identifies the transaction quantity.
UOM_CODE VARCHAR2 3 Unit of measure code of the transaction quantity.
UOM_CONVERSION_FACTOR NUMBER UOM Conversion factor from primary UOM to costing UOM (because the incoming cost is always in the primary uom).
PREPROCESSING_STATUS VARCHAR2 30 Yes Indicates Cost PreProcessing status for transaction.
ERROR_CODE VARCHAR2 100 Indicates Error code for transaction.
POSTED_FLAG VARCHAR2 5 Whether or not the transaction has been posted to quantity layers. Updated by Cost Method processors.
VAL_ONHAND_FLAG VARCHAR2 1 Indicates if the onhand calculations have been done for the layer. Values: N = No processed, NULL = Processed for onhand calculations.
REC_ONHAND_AVAIL_FLAG VARCHAR2 1 Indicates receipt onhand available flag.
WO_LAYER_POSTED_FLAG VARCHAR2 1 Indicates whether the transaction has been created in the WIP layer table. N ??? layer not created Y ??? Layer created X ??? Excluded from layer creation.
RUN_MODE VARCHAR2 5 Yes The mode in which this transaction is created, to specify whether it can be reprocessed. It is FINAL in v1.
CST_INV_TRANSACTION_ID NUMBER 18 The inventory transaction identifier that references costing's inventory transaction table.
CST_INV_TRANSACTION_DTL_ID NUMBER 18 The source inventory transaction detail identifier that references costing's inventory transaction details table.
TRANSFER_COST_ORG_ID NUMBER 18 Cost Organization identifier associated with Inventory organization of the other leg of transfer transaction.
TRANSFER_BOOK_ID NUMBER 18 Cost Book to be used for processing transfer transaction.
OWNING_COST_ORG_ID NUMBER 18 The cost organization that owns the transaction. Owning Cost Org is different from Cost Org for consignment transactions.
TRANSFER_CST_INV_TXN_ID NUMBER 18 Source inventory transaction identifying the other leg of transfer transaction.
TRANSFER_VAL_UNIT_ID NUMBER 18 Valuation unit identifier associated with the other leg of transfer transaction.
TRANSFER_UOM_CONVERSION_FACTOR NUMBER Conversion factor between primary uom code of the issue transaction and the primary uom code of the receipt transaction.
FOB_POINT NUMBER 1 Indicates the 'Free on board' point and determines the point of transfer of liability/ownership. It is 1 for 'SHIPMENT' and 2 for 'RECEIPT'.
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier.
PO_DISTRIBUTION_ID NUMBER 18 Purchasing distribution identifier.
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 description. Valid values are GOODS or SERVICES.
WSH_DELIVERY_DETAIL_ID NUMBER 18 Shipping delivery detail identifier.
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 Code Combination identifier for the referenced account.
TXN_SOURCE_DOC_TYPE VARCHAR2 50 Transactions Source Document Type.
TXN_SOURCE_DOC_NUMBER VARCHAR2 240 Transactions Source Document Number.
TXN_SOURCE_REF_DOC_TYPE VARCHAR2 50 Transactions Source Documents Reference Document Type.
TXN_SOURCE_REF_DOC_NUMBER VARCHAR2 240 Transactions Source Documents Reference Document Number.
CST_WORK_ORDER_ID NUMBER 18 Single column FK indicating the work order associated with the transaction.
CST_WORK_ORDER_OPERATION_ID NUMBER 18 Single column FK indicating the work order operation associated with the transaction.
SUPPLY_TYPE VARCHAR2 30 Indicates the supply type on WIP transactions. The various supply types are Assembly Pull, Operation Pull, Push and Phantom.
WORK_CENTER_ID NUMBER 18 Surrogate ID identifying the work center where the operation is executed.
CST_WO_OPERATION_TXN_ID NUMBER 18 Surrogate ID identifying the work order operation transaction.
WO_UPDATE_EVENT_TXN_ID NUMBER 18 Surrogate ID identifying the work order close transaction. This reference is used to identify if a product transaction was available in the system during work order close. If this reference is missing and the work order is closed, a re-close of the work order is performed.
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.
TRANSFER_PERCENTAGE NUMBER Percentage of value to attribute to transfer costs in an Inter-Org transfer.
PRICING_OPTION NUMBER 18 Pricing Option identifier. It signifies whether the option is to use the PO price (1), transfer price (2) or the cost+markup (3) as the transfer cost.
BUSINESS_UNIT_ID NUMBER 18 Business Unit Id of the Inventory Organization.
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.
INTERNAL_PROFIT_TRACKING VARCHAR2 1 This column is used by Costing and the values it can hold are 'Y' and 'N'. It indicates whether or not to track profit in inventory.
VAL_UNIT_DETAIL_ID NUMBER 18 Single column FK: Identifies the valuation unit detail line.
TRANSACTION_QTY NUMBER Yes Transaction quantity of the inventory transaction.
TRANSACTION_UOM_CODE VARCHAR2 3 Yes The unit of measure code in which transaction quantity is specified.
PROCESS_DATE TIMESTAMP Date at which the average cost processor processed this transaction. It gives the sequence of transaction processing.
COGS_POSTED_FLAG VARCHAR2 5 A flag that indicates whether COGS or RMA Recognition transaction has been created for the costing transaction. Possible values are: NULL: Transaction not eligible for COGS or RMA Recognition. N: New. Transaction yet to be processed by COGS Processor. H: Hold. Transaction moved to hold status by COGS Processor due to unavailability of revenue line and ship-bill reference. R: Reprocess. There are 2 scenarios where a transaction will be marked for reprocessing by COGS Processor. 1. Upon availability of revenue line and ship-bill reference, transaction status will change from H to R for reprocessing. 2. In case of partial revenue recognition, transaction status will change from Y to R for reprocessing the next partial revenue lines. Y: COGS or RMA Recognition transaction has been created. X: Excluded from COGS or RMA Recognition. For Projects related transactions.
COSTED_QTY NUMBER Quantity that has been processed in costing.
COSTING_UOM_CODE VARCHAR2 3 Unit of measure for the costed quantity.
COSTING_STATUS VARCHAR2 1 Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting.
TRANSFER_CST_INV_TXN_DTL_ID NUMBER 18 Source inventory transaction detail, such as lot or serial, identifying the other leg of transfer transaction. This is populated only if the item is lot or serial controlled in both source and destination organizations.
STAGED_FOR_TXFR_COST_FLAG VARCHAR2 5 Yes Indicates if the physical transfer transaction has the cost staged in the cst_transfer_txn_costs tables for transfer cost pre-processing.
COST_STATUS VARCHAR2 1 Current costing status of the transaction for display: N-Not Processed, P-Partially Processed, C-Fully Costed, E-Error, X-Excluded from Costing.
ACCOUNTING_STATUS VARCHAR2 1 Current accounting status of the transaction for display: N-Not Processed, D-Draft Accounted, F-Final Accounted, E-Error, X-Excluded from Accounting.
PROPAGATE_COST_ADJ_FLAG VARCHAR2 1 The values can be Y or N (Default) and dictates whether or not cost adjustments will be propagated.
RECEIPT_WITHOUT_COST_CODE VARCHAR2 30 The values can be either of FIRST, LAST, CURRENT (Default) and dictates which receipt cost will be used for a receipt without any cost.
REFERENCED_RMA_COST_CODE VARCHAR2 30 What cost to be used for referenced RMA transactions. The default value is SO_COST.
TRANSACTION_GROUP_ID NUMBER 18 Used to group related transactions together.
TRANSFER_TRANSACTION_GROUP_ID NUMBER 18 The transaction group whose average cost is required to process this transaction.
INTERCOMPANY_INVOICING_FLAG VARCHAR2 1 Indicates whether the transaction is eligible for intercompany invoicing or not.
CONSIGNED_FLAG VARCHAR2 1 Yes Indicates whether the transaction is consigned or owned.
CONSIGNED_ACCT_DIST_BASIS VARCHAR2 30 Indicates the Consigned Accounting Distribution basis for the cost profile.
CREATE_ACCT_FOR_CONS_TXNS VARCHAR2 1 Creating accounting for consigned transactions Flag - Y or N.
PROVISIONAL_COMPLETION_TYPE VARCHAR2 30 Work order valuation option for valuing work order partial completions into inventory. Following options will be available: - Value at standard cost (available for all cost methods) - Value at last actual cost (available for actual and perpetual average cost method) - Value at perpetual average cost ( available for perpetual average cost method).
OPERATION_SCRAP_COST_TYPE VARCHAR2 30 Work order valuation option for including scrap costs as a part of inventory or expensing out 'Operation Scrap' will have the following options available in a LOV choice list: - Include in Inventory - Expense Out.
CST_TRANSFER_ORDER_LINE_ID NUMBER 18 Transfer order line identifier.
CST_TRANSFER_ORDER_DIST_ID NUMBER 18 Transfer Order distribution identifier.
PARTIAL_COMPLETION_FLAG VARCHAR2 1 Indicates if a product completion transaction is processed as partial completion. Valid values are NULL, N and Y.
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.
REFERENCE_DELIVERY_ID NUMBER 18 This column has the reference delivery identifier that points to delivery identifier of the forward flow.
REFERENCED_RETURN_FLAG VARCHAR2 5 Possible values Y/N/NULL. Mainly used in R13 for referenced RMA. May be used for more flows later. Y means return is a referenced return N means it is unreferenced NULL means that it is a pre-R13 return flow or this column is not applicable for the flow.
SIMPLE_PROC_FLAG VARCHAR2 5 Whether the Dropship Delivery is for Simple Procurement (Y) or for Global Procurement flow (N).
PROJECT_FLAG VARCHAR2 1 Flag for identifying if projects is enabled. Will be populated as Y for project enabled sales order issue transaction for now and later extended to all transaction types where projects is enabled.
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.
QUANTITY_DEPLETED NUMBER Total quantity that has been depleted for an issue transaction. This does not include the negative depletions or reversals.
STD_OH_ABSORPTION_FLAG VARCHAR2 1 This column indicates the decision derived by Cost processor whether to absorb or not absorb the overhead for a costing transaction. This is applicable only for standard cost method. Valid values are Y/N. 'Y' or null means absorb overheads, 'N' means do not absorb overheads.
PAC_PROCESSED_FLAG VARCHAR2 1 This column indicates if the transaction has been included for PAC calculation. Possible values are null/N - transaction is not eligible for PAC or is not yet included in PAC calculation, Y - transaction is included in PAC calculation.
IGNORE_INTRA_VU_FLAG VARCHAR2 1 This flag indicates whether to ignore intra valuation unit transfers for costing. Possible values are 'Y','N' and NULL.

Foreign Keys

Table Foreign Table Foreign Key Column
CST_TRANSACTIONS cst_inv_transactions CST_INV_TRANSACTION_ID
CST_TRANSACTIONS cst_cost_books_b COST_BOOK_ID
CST_TRANSACTIONS cst_cost_books_b TRANSFER_BOOK_ID
CST_TRANSACTIONS cst_inv_transactions TRANSFER_CST_INV_TXN_ID
CST_TRANSACTIONS cst_inv_transaction_dtls CST_INV_TRANSACTION_DTL_ID
CST_TRANSACTIONS cst_cost_inv_orgs COST_ORG_ID, INVENTORY_ORG_ID
CST_TRANSACTIONS cst_val_structures_b VAL_STRUCTURE_ID
CST_TRANSACTIONS cst_val_units_b VAL_UNIT_ID
CST_TRANSACTIONS cst_internal_txn_types_b BASE_TXN_TYPE_ID, BASE_TXN_SOURCE_TYPE_ID
CST_TRANSACTIONS cst_cost_profiles_b COST_PROFILE_ID
CST_TRANSACTIONS cst_item_cost_profiles ITEM_COST_PROFILE_ID
cst_writeoff_costs cst_transactions TRANSACTION_ID
cst_layer_costs cst_transactions TRANSACTION_ID
cst_transfer_src_txns cst_transactions DEST_TRANSACTION_ID
cst_transfer_src_txns cst_transactions SOURCE_TRANSACTION_ID
cst_user_adjustments cst_transactions SOURCE_TRANSACTION_ID
cst_transfer_costs cst_transactions TRANSACTION_ID
cst_transfers cst_transactions TRANSACTION_ID
cst_layer_ohcost_stg_tmp cst_transactions TRANSACTION_ID
cst_transaction_costs cst_transactions TRANSACTION_ID
cst_variance_costs cst_transactions TRANSACTION_ID
cst_perpavg_cost cst_transactions TRANSACTION_ID
cst_transfer_txn_costs cst_transactions DEST_TRANSACTION_ID
cst_transaction_overheads cst_transactions TRANSACTION_ID
cst_transaction_layers cst_transactions TRANSACTION_ID
cst_transaction_layers_i_gt cst_transactions TRANSACTION_ID
cst_interco_cost_stg cst_transactions TRANSACTION_ID

Indexes

Index Uniqueness Tablespace Columns Status
CST_TRANSACTIONS_N1 Non Unique FUSION_TS_TX_DATA POSTED_FLAG, REQUEST_ID
CST_TRANSACTIONS_N10 Non Unique Default STAGED_FOR_TXFR_COST_FLAG, ADDITIONAL_PROCESSING_CODE
CST_TRANSACTIONS_N11 Non Unique Default INVENTORY_ITEM_ID, TRANSACTION_DATE
CST_TRANSACTIONS_N12 Non Unique Default CST_WORK_ORDER_ID, COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_OPERATION_ID
CST_TRANSACTIONS_N13 Non Unique FUSION_TS_TX_DATA REQUEST_ID, CST_INV_TRANSACTION_ID, CST_INV_TRANSACTION_DTL_ID Obsolete
CST_TRANSACTIONS_N14 Non Unique FUSION_TS_TX_DATA COST_ORG_ID, COST_BOOK_ID, TRANSACTION_GROUP_ID Obsolete
CST_TRANSACTIONS_N15 Non Unique FUSION_TS_TX_DATA COST_STATUS, COST_TRANSACTION_TYPE
CST_TRANSACTIONS_N16 Non Unique Default TRANSFER_TRANSACTION_GROUP_ID
CST_TRANSACTIONS_N18 Non Unique Default MATCHED_TO_ADDL_TAX_FLAG
CST_TRANSACTIONS_N19 Non Unique Default COST_METHOD_CODE, MATCHED_TO_COST_FLAG, COST_TRANSACTION_TYPE
CST_TRANSACTIONS_N2 Non Unique FUSION_TS_TX_DATA REQUEST_ID, PREPROCESSING_STATUS
CST_TRANSACTIONS_N20 Non Unique Default WO_LAYER_POSTED_FLAG, MATCHED_TO_COST_FLAG, USE_ITEM_COST_FLAG
CST_TRANSACTIONS_N21 Non Unique Default DOO_FULLFILL_LINE_ID
CST_TRANSACTIONS_N22 Non Unique Default TXN_SOURCE_REF_DOC_NUMBER
CST_TRANSACTIONS_N23 Non Unique Default TRANSACTION_GROUP_ID, COST_ORG_ID, COST_BOOK_ID
CST_TRANSACTIONS_N24 Non Unique Default VAL_ONHAND_FLAG, COST_ORG_ID, COST_BOOK_ID, TRUNC("COST_DATE")
CST_TRANSACTIONS_N25 Non Unique Default COGS_POSTED_FLAG, COST_ORG_ID
CST_TRANSACTIONS_N26 Non Unique Default PERIOD_NAME, COST_ORG_ID
CST_TRANSACTIONS_N27 Non Unique Default TRANSACTION_DATE
CST_TRANSACTIONS_N3 Non Unique FUSION_TS_TX_IDX COST_ORG_ID, COST_BOOK_ID, CST_INV_TRANSACTION_ID Active
CST_TRANSACTIONS_N4 Non Unique FUSION_TS_TX_DATA COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, COST_TRANSACTION_TYPE, COST_DATE, POSTED_FLAG
CST_TRANSACTIONS_N5 Non Unique FUSION_TS_TX_DATA CST_INV_TRANSACTION_ID, CST_INV_TRANSACTION_DTL_ID
CST_TRANSACTIONS_N6 Non Unique FUSION_TS_TX_DATA MATCHED_TO_COST_FLAG, PREPROCESSING_STATUS, CST_INV_TRANSACTION_ID, COST_ORG_ID, COST_BOOK_ID
CST_TRANSACTIONS_N7 Non Unique FUSION_TS_TX_DATA BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID
CST_TRANSACTIONS_N8 Non Unique FUSION_TS_TX_DATA VAL_UNIT_ID
CST_TRANSACTIONS_N9 Non Unique FUSION_TS_TX_DATA TRANSFER_CST_INV_TXN_ID, COST_TRANSACTION_TYPE, ADDITIONAL_PROCESSING_CODE, INTRANSIT_FLAG
CST_TRANSACTIONS_U1 Unique FUSION_TS_TX_DATA TRANSACTION_ID
CST_TRANSACTIONS_U2 Unique FUSION_TS_TX_DATA COST_ORG_ID, COST_BOOK_ID, NVL("CST_INV_TRANSACTION_ID","TRANSACTION_ID"), NVL("CST_INV_TRANSACTION_DTL_ID",0)