CST_RESOURCE_RATES_GT
This transaction temporary table will be used to resolve the standard resource rates for the resource transactions that are to be processed.
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 | Surrogate ID identifying the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Surrogate ID identifying the resource for which the rate is to be found. | |
| EFFECTIVE_DATE | DATE | Yes | Indicates the date on which the resource rate is to be derived. | ||
| STD_RESOURCE_RATE_ID | NUMBER | 18 | Surrogate ID identifying the standard cost resource rate identified for the combination. | ||
| PREVIOUS_STD_RESOURCE_RATE_ID | NUMBER | 18 | Surrogate ID identifying the prior standard cost resource rate identified for the combination. | ||
| COST_REFERENCE | VARCHAR2 | 100 | This information will be populated into cost reference. | ||
| UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure in which the rate is defined. This will always be resource's primary unit of measure. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency code in which the rate is defined. This is always same as cost book currency. | ||
| STATUS | VARCHAR2 | 30 | Indicates if the resource rate was successfully found. SUCCESS and ERROR are the possible values. |