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 Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Yes Identifies the Cost Book assigned to the Cost Organization.
INVENTORY_ITEM_ID NUMBER 18 Yes Value that identifies the inventory item associated with the transaction.
INVENTORY_ORG_ID NUMBER 18 Yes Indicates the Inventory Org to which the Item belongs.
ITEM_COST_PROFILE_ID NUMBER 18 Identifies the Item Cost Profile.
COST_PROFILE_ID NUMBER 18 Identifies Cost Profile associated with the transaction.
STATUS VARCHAR2 30 Indicates the 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 Whether a transaction affects in-transit or physical inventory.
QUANTITY NUMBER Quantity 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 Transaction quantity as specified in the transaction uom.
COST_TRANSACTION_TYPE VARCHAR2 10 Costing transaction type which is either RECEIPT 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 Identifies the Valuation Structure.
STRUCTURE_INSTANCE_NUMBER NUMBER 18 Structure instance number for the valuation unit.
VAL_UNIT_ID NUMBER 18 Indicates Valuation unit identifier for transaction.
VAL_UNIT_DETAIL_ID NUMBER 18 Valuation unit 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.
PAC_XFR_CO_FLAG VARCHAR2 1 Indicates if a transfer shipment will use the prior period PAC cost or the current shipment cost as the transfer cost. This value is only applicable for transfer shipments using PAC cost method. Valid values are Y - Use prior period PAC cost, NULL - Use shipment cost.

Indexes

Index Uniqueness Columns
CST_INV_TXNS_CPVUUOM_GT_N1 Non Unique TRANSACTION_DATE, CST_INV_TRANSACTION_ID, CST_INV_TRANSACTION_DTL_ID