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 |