CST_STD_COST_MISSING_VU_GT
The table is used to populate the standard cost and valuation unit code combination information for standard costs defined at inventory control attribute level and do not have valuation unit defined yet
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STD_COST_ID | NUMBER | 18 | Yes | Identifies the standard cost record | |
| 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 | Inventory item identifier | |
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Yes | Populated form the transaction, here it indicates what kind of valuation structure to be used; expense or asset. | |
| VAL_STRUCTURE_ID | NUMBER | 18 | Yes | Identifies the Valuation Structure. | |
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Yes | Structure Instance number | |
| VAL_STRUCTURE_MODE_CODE | VARCHAR2 | 30 | Yes | The mode of creation of valuation units. It can be AUTO, MANUAL or BOTH. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates The Inventory Org To Which The Item Belongs | ||
| SUBINVENTORY_CODE | VARCHAR2 | 240 | The subinventory code where the item is stored | ||
| LOCATOR_ID | NUMBER | 18 | Inventory locator identifier | ||
| LOT_NUMBER | VARCHAR2 | 240 | The lot number of the item | ||
| SERIAL_NUMBER | VARCHAR2 | 240 | Serial number of the item | ||
| GRADE_CODE | VARCHAR2 | 240 | Grade of the Lot for a grade controlled Item | ||
| COST_PROFILE_ID | NUMBER | 18 | Yes | The Cost profile for cost org - book - item - asset_identifier combination | |
| VAL_UNIT_COMBINATION_ID | NUMBER | 18 | Yes | Valuation Units Code Combination Identifier |