CST_DEFAULT_COST_PROFILES
This table contains the default cost profiles which are identified by Cost Organization, Cost Book and Category. Default cost profiles are setup in context of cost organization and cost books. These default cost profiles are used to generate item cost profiles at runtime if an item cost profile doesnot exist. Setting up default cost profile is not mandatory to run cost management.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_DEFAULT_COST_PROFILES_PK |
DEFAULT_COST_PROFILE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| DEFAULT_COST_PROFILE_ID | NUMBER | 18 | Yes | Surrogate key identifying Default Cost Profile row in this table. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization. | Active | ||
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | Active | ||
| CATEGORY_ID | NUMBER | 18 | Item Category Identifier | Active | |||
| CATEGORY_SET_ID | NUMBER | 18 | Item Category Set Identifier | Active | |||
| ASSET_COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies the Cost Profile To Be Used For Asset Instances Of The Item | Active | |||
| EXPENSE_COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies the Cost Profile To Be Used For Expense Instances Of The Item | Active | |||
| CONSIGNED_COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies the Cost Profile To Be Used For Consigned Instances Of The Item | ||||
| PROFILE_CREATION_CODE | VARCHAR2 | 30 | Yes | Profile Creation Method | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | Active | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Default Cost Profile (CST_DEFAULT_COST_PROFILES) |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_DEFAULT_COST_PROFILES | cst_cost_profiles_b | ASSET_COST_PROFILE_ID |
| CST_DEFAULT_COST_PROFILES | cst_cost_profiles_b | EXPENSE_COST_PROFILE_ID |
| CST_DEFAULT_COST_PROFILES | cst_cost_org_books | COST_ORG_ID, COST_BOOK_ID |
| CST_DEFAULT_COST_PROFILES | egp_categories_b | CATEGORY_ID |
| CST_DEFAULT_COST_PROFILES | egp_category_sets_b | CATEGORY_SET_ID |
| cst_item_cost_profiles_t | cst_default_cost_profiles | ITEM_COST_PROFILE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CST_DEFAULT_COST_PROFILES_PK | Unique | FUSION_TS_TX_DATA | DEFAULT_COST_PROFILE_ID | |
| CST_DEFAULT_COST_PROFILES_U1 | Unique | FUSION_TS_SEED | COST_ORG_ID, COST_BOOK_ID, CATEGORY_ID, CATEGORY_SET_ID | Active |