CST_STD_RESOURCE_RATES_GT
This table contains the temporary resource rate information being published to cost accounting.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Yes | Identifies the cost organization to which the resource rate is being published to in cost accounting. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book to which the resource rate is being published to in cost accounting. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Identifies the resource for which the resource rate is being published to in cost accounting. | |
| FROM_UOM_CODE | VARCHAR2 | 3 | Identifies the unit of measure of the resource rates as defined in cost planning. | ||
| TO_UOM_CODE | VARCHAR2 | 3 | Identifies the primary unit of measure of the resource as published to cost accounting. | ||
| 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. | ||
| FROM_PERIOD_NAME | VARCHAR2 | 15 | Indicates the period from which the resource rate is effective for periodic average books. | ||
| TO_PERIOD_NAME | VARCHAR2 | 15 | Indicates the period till which the resource rate is effective for periodic average books. | ||
| SCENARIO_EVENT_ID | NUMBER | 18 | Yes | Identifies the scenario event based on which the resource rate is published to cost accounting. | |
| PREVIOUS_STD_RESOURCE_RATE_ID | NUMBER | 18 | Identifies the previously valid resource rate identifier in cost accounting. | ||
| PREVIOUS_EFFECTIVE_START_DATE | DATE | Identifies the effective start date of th previously valid resource rate identifier in cost accounting. | |||
| PREVIOUS_EFFECTIVE_END_DATE | DATE | Identifies the effective end date of th previously valid resource rate identifier in cost accounting. | |||
| FUTURE_STD_RESOURCE_RATE_ID | NUMBER | 18 | Indicates the future standard resource rate identifier which is currently valid in cost accounting prior to the current cost being published. | ||
| FUTURE_EFFECTIVE_START_DATE | DATE | Indicates the future standard resource rate start date which is currently valid in cost accounting prior to the current cost being published. | |||
| FUTURE_EFFECTIVE_END_DATE | DATE | Indicates the future standard resource rate end date which is currently valid in cost accounting prior to the current cost being published. | |||
| PLANNING_RESOURCE_RATE_ID | NUMBER | 18 | Identifies the resource rate identifier in cost planning based on which the resource rate is published to cost accounting. | ||
| SCENARIO_PUBLISH_HEADER_ID | NUMBER | 18 | Identifies the scenario publish header based on which the resource rate is published to cost accounting. | ||
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Identifies the scenario rollup header based on which the resource rate is published to cost accounting. | ||
| PREVIOUS_LAST_USED_DATE | DATE | Identifies the last date the previously valid resource rate was used for processing transactions in cost accounting. | |||
| UOM_CONVERSION_FACTOR | NUMBER | Indicates the derived uom conversion factor to convert the costs in resource rate plan currency to the primary uom of the resource in cost accounting. | |||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the resource rate being published to cost accounting. | |
| STD_RESOURCE_RATE_ID | NUMBER | 18 | Yes | Identifies the standard resource rate identifier for the resource rate being published to cost accounting. | |
| FROM_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the original currency of the resource rate. | ||
| TO_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the target, or default currency code as specified by the ledger. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate to be used between the from currency and to currency. | |||
| LAST_USED_DATE | DATE | Identifies the last date the resource rate was used for processing transactions in cost accounting. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_RESOURCE_RATES_GT_N1 | Non Unique | PLANNING_RESOURCE_RATE_ID |
| CST_RESOURCE_RATES_GT_U1 | Unique | COST_ORG_ID, COST_BOOK_ID, RESOURCE_ID, EFFECTIVE_START_DATE |
| CST_STD_RESOURCE_RATES_GT_PK | Unique | STD_RESOURCE_RATE_ID |