CST_ITEM_COST_PROFILE_DTLS_GT
This table is used to find the item cost profiles for the Cost Org - Book - Inventory item combination
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_ITEM_COST_PROFILE_DTL_PK |
COST_ORG_ID, COST_BOOK_ID, INVENTORY_ORG_ID, INVENTORY_ITEM_ID, COST_PROFILE_TYPE_FLAG |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | The inventory item for which cost profiles needs to be found and populated during Cost PreProcessing | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates The Inventory Org To Which The Item Belongs | |
| COST_PROFILE_TYPE_FLAG | VARCHAR2 | 1 | Yes | The type of cost profile needed. The possible values are (A)sset, (E)xpense and (C)onsigned. | |
| DEFAULT_COST_PROFILE_ID | NUMBER | 18 | Incase the item cost profile does not exists, it would be created using this default cost profile. | ||
| PROFILE_CREATION_CODE | VARCHAR2 | 30 | Profile creation mode can be AUTO or REQUIRES_APPROVAL. If Auto, create item cost profile, else insert into approval table for user review. | ||
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies the Item Cost Profile. | ||
| ASSET_COST_PROFILE_ID | NUMBER | 18 | Cost Profile To Be Used For Asset Instances Of The Item | ||
| EXPENSE_COST_PROFILE_ID | NUMBER | 18 | Cost Profile To Be Used For Expense Instances Of The Item | ||
| CONSIGNED_COST_PROFILE_ID | NUMBER | 18 | Cost Profile to be used for consigned transactions for the item | ||
| STATUS | VARCHAR2 | 30 | The status whether the item cost profile found or created. | ||
| ERROR_CODE | VARCHAR2 | 30 | The error code since neither the item cost profile could not be found nor could it be created. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ITEM_COST_PROFILE_DTLS_N1 | Non Unique | STATUS |
| CST_ITEM_COST_PROFILE_DTLS_N2 | Non Unique | INVENTORY_ITEM_ID |
| CST_ITEM_COST_PROFILE_DTL_PK | Unique | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ORG_ID, INVENTORY_ITEM_ID, COST_PROFILE_TYPE_FLAG |