1. Tables and Views for SCM
  2. CST_INV_TXNS_CPVUUOM_GT

CST_INV_TXNS_CPVUUOM_GT

Intermediate table used while creation of cost transaction. The table has data from CST_INV_TXNS_CP_VU_GT and then applies the uom conversion on the transactions.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments
CST_INV_TRANSACTION_ID NUMBER 18 Yes Costing inventory transaction identifier
CST_INV_TRANSACTION_DTL_ID NUMBER 18 Costing inventory transaction lot/serial detail identifier
COST_ORG_ID NUMBER 18 Yes Cost organization identifier
COST_BOOK_ID NUMBER 18 Yes Cost book identifier
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory item identifier
INVENTORY_ORG_ID NUMBER 18 Yes Inventory organization identifier
ITEM_COST_PROFILE_ID NUMBER 18 Item cost profile identifier
COST_PROFILE_ID NUMBER 18 Cost profile identifier
STATUS VARCHAR2 30 Status of the transaction
ERROR_CODE VARCHAR2 30 Error code associated with the transaction
LOGICAL_FLAG VARCHAR2 1 Whether a transaction is logical (not physical) or not
INTRANSIT_FLAG VARCHAR2 1 Wjether a transaction affects in-transit or physical inventory
QUANTITY NUMBER Quantoity in costing unit of measure
UOM_CODE VARCHAR2 3 Costing unit of measure as specified on the item cost profile
UOM_CONVERSION_FACTOR NUMBER UOM conversion factor between the Primary quantity specified in Primary uom of the item and the Costing quantity specified in the costing uom defined in the item cost profile. If the Cost by UOM type is Primary, then the conversion factor is "1" and if it is Secondary, then the conversion factor is secondary_qty/primary_qty. There are cases where the uom on the transaction would be different from the costing uom, in that case uom conversion api is used to get the conversion from primary uom to costing uom.
TRANSACTION_QTY NUMBER Trnasaction quantity as specified in the transaction uom
COST_TRANSACTION_TYPE VARCHAR2 10 Costing transaction type which is either RECIPT or ISSUE
ADDITIONAL_PROCESSING_CODE VARCHAR2 240 Specifies the transactions that are further classified with the cost transaction type. It can either be null or TRANSFER
USE_ITEM_COST_FLAG VARCHAR2 1 Specifies whether to use the current item cost or the incoming cost
VAL_STRUCTURE_ID NUMBER 18 Valuation structure identifier
STRUCTURE_INSTANCE_NUMBER NUMBER 18 Structure instance number for the valuation unit
VAL_UNIT_ID NUMBER 18 Valuation unit identifier
VAL_UNIT_DETAIL_ID NUMBER 18 Valuation uni detail identifier
VAL_UNIT_COMBINATION_ID NUMBER 18 Valuation unit code combination identifier
EXPENSE_TRANSACTION_FLAG VARCHAR2 1 Whether a transaction is asset or expense
TRANSFER_CST_INV_TXN_DTL_ID NUMBER 18 Links the transfer transactions back to the costing inventory transaction identifier
VU_STRUCTURE_COMPARE_FLAG VARCHAR2 1 Contains C if the VU structure is at Cost Org only or I if VU structure is at Cost Org & Inventory Org (and no other attributes)
VU_COMPARE_STATUS VARCHAR2 1 Possible values: X:Ignore Costing; NULL:normal processing
TRANSACTION_DATE TIMESTAMP The date when the transaction happened.
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.

Indexes

Index Uniqueness Columns
CST_INV_TXNS_CPVUUOM_GT_N1 Non Unique TRANSACTION_DATE, CST_INV_TRANSACTION_ID, CST_INV_TRANSACTION_DTL_ID