CST_ADJ_RESOURCE_RATES_GT
This transaction temporary table is used to hold the newly published rates for which standard cost adjustments are to be made.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Surrogate ID identifying the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Surrogate ID identifying the cost book. | |
| RESOURCE_ID | NUMBER | 18 | Surrogate ID identifying the resource. | |
| STD_RESOURCE_RATE_ID | NUMBER | 18 | Surrogate ID identifying a published resource rates. | |
| UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure in which the rate is published. | |
| PREVIOUS_STD_RESOURCE_RATE_ID | NUMBER | 18 | Surrogate ID identifying the standard cost that was effective rpior to the current standard cost. | |
| EFFECTIVE_START_DATE | DATE | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| PREVIOUS_EFFECTIVE_START_DATE | DATE | Indicates the date on which the prior rate was effective. | ||
| STAGED_FOR_STD_COST_ADJ_FLAG | VARCHAR2 | 1 | Indicates whether standard cost adjustments were processed for this rate change. |