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 |