CST_INV_TXNS_CPVU_GT
Intermediate table used for cost transaction creation where the inventory transaction is stamped with cost org, book, cost profile and valuation unit information
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 | Inventory organization identifier. | |
| 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 | Identifies the Status of the transaction. | ||
| ERROR_CODE | VARCHAR2 | 30 | Error code associated with the transaction. | ||
| LOGICAL_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is logical (not physical) or not. | ||
| INTRANSIT_FLAG | VARCHAR2 | 1 | Identifies 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. | |||
| COST_BY_UOM_TYPE | VARCHAR2 | 30 | Defaulted from the cost profile and its value can either be PRIMARY or SECONDARY. | ||
| PRIMARY_QTY | NUMBER | Quantity as specified in the item primary uom. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | An item primary unit of measure. | ||
| TRANSACTION_QTY | NUMBER | Transaction quantity as specified in the transaction uom. | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure in which transaction quantity is specified. | ||
| SECONDARY_TRANSACTION_QTY | NUMBER | The quantity in the secondary unit of measure. | |||
| SECONDARY_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure in which the secondary transaction quantity is specified. | ||
| 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). | ||
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Stamp the transfer transaction identifier to identify the shipment leg for the transfer. | ||
| VU_COMPARE_STATUS | VARCHAR2 | 1 | Possible values: X:Ignore Costing; NULL:normal processing. | ||
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | 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. | ||
| BASE_TXN_ACTION_ID | NUMBER | 18 | 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. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifies the external source system. In case of inventory transfers it is CST with parent transaction identifier relating to original row. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Stores a value that uniquely identifies a certain instance of an object within the external system. | ||
| TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | Surrogate ID identifying the organization linked to the other leg of the transfer. | ||
| 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. | ||
| TRANSACTION_DATE | TIMESTAMP | The date when this transaction happened. | |||
| 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. | ||
| 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. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| ORIGINAL_TO_SHIPMENT_TXN_ID | NUMBER | 18 | For return shipment transactions, this references the original forward flow transaction id. |