CST_PUBLISH_SCENARIO_PARAMS_GT
This table temporarily stores the parameters which are used for the publish scenario process.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_EVENT_ID | NUMBER | 18 | Yes | Identifies the scenario event for which the publish scenario process is being executed. | |
| SCENARIO_ID | NUMBER | 18 | Yes | Identifies the scenario for which the publish scenario process is being executed. | |
| SCENARIO_HEADER_ID | NUMBER | 18 | Identifies the scenario header identifier of the scenario. | ||
| SCENARIO_VERSION_NUMBER | VARCHAR2 | 30 | Indicates the scenario version number of the scenario. | ||
| SCENARIO_VERSION_TYPE | VARCHAR2 | 30 | Indicates the scenario version type of the scenario. | ||
| SCENARIO_EVENT_TYPE | VARCHAR2 | 30 | Yes | Indicates the scenario event type for the scenario event for which the publish scenario process is being executed. | |
| SCENARIO_EVENT_DATE | TIMESTAMP | Yes | Identifies the scenario event date for the scenario event for which the publish scenario process is being executed. | ||
| SCENARIO_EVENT_NUMBER | VARCHAR2 | 30 | Identifies the scenario event number for the scenario event for which the publish scenario process is being executed. | ||
| SCENARIO_NUMBER | VARCHAR2 | 30 | Yes | Identifies the scenario number for the scenario event for which the publish scenario process is being executed. | |
| PLANNING_COST_ORG_ID | NUMBER | 18 | Yes | Identifies the planning cost organization identifier of the scenario for which the publish scenario process is being executed. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| SCENARIO_TYPE | VARCHAR2 | 30 | Yes | Indicates the scenario type of the scenario for which the publish scenario process is being executed. | |
| INV_ORG_ID | NUMBER | 18 | Identifies the plant identifier of the scenario for which the publish scenario process is being executed. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Indicates the currency code in which all the costs are maintained for the scenario for which the publish scenario process is being executed. | |
| SCENARIO_STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status code of the scenario for which the publish scenario process is being executed. | |
| PUBLISH_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether publishing is enable for the scenario for which the publish scenario process is being executed. | ||
| ACCOUNTING_COST_ORG_ID | NUMBER | 18 | Identifies the accounting cost organization identifier of the scenario for which the publish scenario process is being executed. | ||
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book identifer used for the publish process. | |
| COST_BOOK_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Indicates the cost book currency to which the costs are being published to. | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Yes | Indicates the currency conversion type which is used to derive the currency conversion factor for publishing costs to cost accounting. | |
| CURRENCY_CONVERSION_DATE | DATE | Yes | Indicates the currency conversion date which is used to derive the currency conversion factor for publishing costs to cost accounting. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Yes | Indicates the currency conversion rate which is used for publishing costs to cost accounting. | ||
| SCENARIO_PUBLISH_HEADER_ID | NUMBER | 18 | Yes | Identifies the publish header identifier for the publish costs parameters. | |
| ROLLEDUP_COST_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the rolled up costs are being published as part of the publish costs process to this cost book. | |
| ITEM_COST_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the item costs are being published as part of the publish costs process to this cost book. | |
| RESOURCE_COST_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the resource costs are being published as part of the publish costs process to this cost book. | |
| PUBLISH_STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the publish process for this publish cost parameter record. | |
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the publish process for this publish cost parameter record. | ||
| CONFIGURED_FROM_DATE | DATE | Identifies the date from which the work orders for configured items needs to be processed for the scenario. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_PUBLISH_SCN_PARAMS_PK | Unique | SCENARIO_EVENT_ID, SCENARIO_PUBLISH_HEADER_ID |