CST_ITEM_COST_PROFILES_GT
Item Cost Profile global temporary table. It is used to create item cost profiles if one does not already exist during Cost PreProcessing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies the Item Cost Profile. | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Cost Org Associated With The Item Cost Profile | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Cost Book Associated With The Item Cost Profile | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates The Validation Inventory Org To Which The Item Belongs | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Indicates The Item To Which The Cost Profile Is Assigned | |
| PRIMARY_UOM_CODE | VARCHAR2 | 30 | Primary UOM of the Item | ||
| INVENTORY_ITEM_FLAG | NUMBER | 18 | Inventory Item Flag | ||
| INVENTORY_ASSET_FLAG | NUMBER | 18 | Inventory Asset Flag | ||
| LOT_CONTROL_CODE | NUMBER | 18 | Item Lot Control Status | ||
| SERIAL_NUMBER_CONTROL_CODE | NUMBER | 18 | Item Serial Control Status | ||
| LOCATION_CONTROL_CODE | NUMBER | 18 | Item Locator Enabled Status | ||
| COST_ENABLED_FLAG | NUMBER | Item Costing Status | |||
| SECONDARY_UOM_ENABLED_FLAG | NUMBER | 18 | Item Secondary UOM Status | ||
| GRADE_CONTROL_FLAG | NUMBER | 18 | Item Grade Control Status | ||
| CREATION_SOURCE_CODE | VARCHAR2 | 30 | Yes | Indicates How The Item Cost Profile Was Created | |
| COST_PROFILE_ID | NUMBER | 18 | Yes | Cost Profile To Be Used For The Item | |
| UOM_TYPE | VARCHAR2 | 30 | Cost Profile UOM Type | ||
| UOM_CODE | VARCHAR2 | 30 | The Costing Uom Code | ||
| LOT_COST_METHOD | NUMBER | Cost Profile Uses Lot Cost Method | |||
| SERIAL_COST_METHOD | NUMBER | Cost Profile Uses Serial Cost Method | |||
| INV_ORG_ENABLED | NUMBER | 18 | Valuation Structure Has Inv Org Enabled | ||
| SUBINVENTORY_ENABLED | NUMBER | 18 | Valuation Structure Has Sub Inventory Enabled | ||
| LOCATOR_ENABLED | NUMBER | 18 | Valuation Structure Has Locator Enabled | ||
| LOT_ENABLED | NUMBER | 18 | Valuation Structure Has Lot Enabled | ||
| SERIAL_ENABLED | NUMBER | 18 | Valuation Structure Has Serial Enabled | ||
| GRADE_ENABLED | NUMBER | 18 | Valuation Structure Has Grade Enabled | ||
| DEFAULT_COST_PROFILE_ID | NUMBER | 18 | Default Cost Profile From Which This Temporary Item Cost Profile Was Created | ||
| PROFILE_CREATION_CODE | VARCHAR2 | 30 | Yes | Profile creation mode can be AUTO or REQUIRES_APPROVAL. If Auto, create item cost profile, else insert into approval table for user review. | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Code Identifying the Error or Success Status for Item Profile Generation. Also Indicates whether the Profile is to be generated. | |
| ERROR_MESSAGE | VARCHAR2 | 30 | Error Message Code | ||
| COST_PROFILE_TYPE_FLAG | VARCHAR2 | 1 | Yes | Cost Profile Type |