CST_SCENARIOS
This table contains the header information about the cost planning scenario.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_SCENARIOS_PK |
SCENARIO_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Yes | Surrogate key and unique identifier for each cost planning scenario. | |
| 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. | |
| SCENARIO_NUMBER | VARCHAR2 | 30 | Yes | User definable number to identify the cost planning scenario. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Indicates the accounting cost organization to which the results of the cost rollup would be associated to. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Indicates the accounting cost book to which the results of the cost rollup would be associated to. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Indicates the period for periodic average cost book based scenarios. | ||
| SCENARIO_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of the scenario. The LOOKUP_TYPE for these values is ORA_CST_SCENARIO_TYPES. | |
| STATE_CODE | VARCHAR2 | 30 | Yes | Indicates the state of the scenario. The LOOKUP_TYPE for these values is ORA_CST_SCENARIO_STATE. | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the scenario. The LOOKUP_TYPE for these values is ORA_CST_SCENARIO_STATUS_SMPL. | |
| ROLLUP_SCOPE | VARCHAR2 | 30 | Indicates the scope of the data to roll up. The LOOKUP_TYPE for these values is ORA_CST_ROLLUP_SCOPE. | ||
| COMMENTS | VARCHAR2 | 1000 | Indicates the detailed information or comments about the cost planning scenario being defined. | ||
| REASON_CODE | VARCHAR2 | 30 | Indicates the reason code of why the scenario became modified. This field is relevant and will be displayed only when the scenario status is modified. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PLANNING_COST_ORG_ID | NUMBER | 18 | OBSOLETE: Identifies the planning cost organization for which the cost planning scenario is created. | ||
| INV_ORG_ID | NUMBER | 18 | OBSOLETE: Identifies the inventory organization / plant for which the cost planning scenario is entered. It is a required value if the scenario type is manufacturing. | ||
| SCENARIO_VERSION_NUMBER | VARCHAR2 | 30 | OBSOLETE: Indicates the user identifiable number of the scenario version. Within a scenario, the version number would be a single running number for both standard scenario versions and CTO scenario versions. | ||
| SCENARIO_HEADER_ID | NUMBER | 18 | OBSOLETE: Indicates the scenario header identifier. For every new version created, the scenario header identifier would be inherited from the base version of the scenario. | ||
| PURPOSE_CODE | VARCHAR2 | 30 | OBSOLETE: Indicates the purpose for which the scenario is being defined. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | OBSOLETE: Indicates the currency code in which the costs are maintained in the cost planning scenario. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | OBSOLETE: Indicates the currency conversion type to be used to convert the item cost and resource rates from their respective currencies to the cost planning scenario currency. | ||
| PUBLISH_TO_ACCOUNTING_FLAG | VARCHAR2 | 1 | OBSOLETE: Specifies if the scenario is enabled to publish costs for Cost Accounting. | ||
| EFFECTIVE_END_DATE | DATE | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | |||
| SCENARIO_VERSION_TYPE | VARCHAR2 | 30 | OBSOLETE: Indicates the version type of the scenario version. The LOOKUP_TYPE for these values is ORA_CST_SCENARIO_VERSION_TYPES. | ||
| CONFIGURED_ENABLED | VARCHAR2 | 1 | OBSOLETE: Indicates whether the scenario is enabled for configured item processing. Valid values are Y and N. Only if the value is Y, the option to invoke build and rollup of CTO items would be possible from the scenario. | ||
| CONFIGURED_FROM_DATE | DATE | OBSOLETE: Indicates the cut-off date of the work orders which would be processed by the scenario build and roll up processes. It is be a mandatory attribute, if the configured enabled flag is set to Y. By default this date would be populated from the effective start date of the scenario and the user has the option of overriding it. | |||
| PLANNING_MODE | VARCHAR2 | 30 | Yes | OBSOLETE: The planning mode of the scenario to allow making changes to existing Published costs for New Items only. The LOOKUP_TYPE for these values is ORA_CST_SCENARIO_PLANNING_MODE. | |
| PREVIOUS_SCENARIO_ID | NUMBER | 18 | OBSOLETE: Previous Scenario Identifier. This will be populated with the value of the previous scenario. Applicable only when the NEW_ITEMS option is chosen, otherwise column is null. | ||
| SUPPLY_CHAIN_ROLLUP_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the scenario is enabled for Supply Chain Cost Rollup. | |
| ROLLUP_GROUP_ID | NUMBER | 18 | Identifies the supply chain rollup group for which the cost planning scenario is created. | ||
| ASSIGNMENT_SET_ID | NUMBER | 18 | Identifies the assignment set associated to the cost planning scenario. | ||
| TRANSFER_COST_RULE_SET_ID | NUMBER | 18 | Identifies the transfer cost rule set associated to the cost planning scenario. | ||
| ORGANIZATION_CONTEXT | VARCHAR2 | 30 | Indicates the organization context for which the cost planning scenario is created. The LOOKUP_TYPE for this column is ORA_CST_ORGANIZATION_CONTEXT with the values ORA_CST_ORG_CONTEXT_SINGLE or ORA_CST_ORG_CONTEXT_GROUP. | ||
| ROLLUP_RESULTS_CACHED_FLAG | VARCHAR2 | 1 | Indicates whether the rollup results have been cached in the rollup costs table. Valid values are N - Not cached, L - Legacy caching mode, E - Enhanced caching mode, X - XML caching mode. | ||
| ROLLUP_RESULTS | CLOB | Used to store the cached results of the rollup process either in plain text or in XML. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cst_scenario_publish_headers | cst_scenarios | SCENARIO_ID |
| cst_scenario_events | cst_scenarios | SCENARIO_ID |
| cst_scenario_wd_criteria | cst_scenarios | SCENARIO_ID |
| cst_work_definitions | cst_scenarios | SCENARIO_ID |
| cst_scenario_cost_estimates | cst_scenarios | SCENARIO_ID |
| cst_work_definition_items | cst_scenarios | SCENARIO_ID |
| cst_scenario_overhead_rates | cst_scenarios | SCENARIO_ID |
| cst_scenario_resource_rates | cst_scenarios | SCENARIO_ID |
| cst_scenario_rollup_headers | cst_scenarios | SCENARIO_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_SCENARIOS_N1 | Non Unique | FUSION_TS_TX_DATA | COST_ORG_ID, COST_BOOK_ID, EFFECTIVE_START_DATE, SCENARIO_TYPE |
| CST_SCENARIOS_N2 | Non Unique | Default | UPPER("SCENARIO_NUMBER") |
| CST_SCENARIOS_PK | Unique | FUSION_TS_TX_DATA | SCENARIO_ID |
| CST_SCENARIOS_U1 | Unique | Default | SCENARIO_NUMBER |