CST_RESOURCE_COSTS_GT
This transaction temporary table will be used to create the resource transaction costs and intermediate processing. This table will be specifically used to map the incoming cost component cost to cost elements.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| RESOURCE_TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying the resource transaction within costing. | |
| COST_ORG_ID | NUMBER | 18 | Surrogate ID identifying the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Surrogate ID identifying the cost book associated to the cost organization. | |
| RESOURCE_ID | NUMBER | 18 | Surrogate ID identifying the resource for which cost is recorded. | |
| COST_DATE | TIMESTAMP | Costing date of the transaction. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | |
| STD_RESOURCE_RATE_ID | NUMBER | 18 | Surrogate ID identifying the resource rate definition that was used to create this cost. | |
| COMPONENT_GROUP_ID | NUMBER | 18 | Surrogate ID identifying the component group mapping derived from the cost profile. | |
| COST_COMPONENT_ID | NUMBER | 18 | Surrogate ID identifying the cost component against which the cost is recorded. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Surrogate ID identifying the expense pool associated with the cost. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Surrogate ID identifying the internal transaction type. | |
| COST_SOURCE | VARCHAR2 | 30 | Identifies the source of the cost, such as Standard cost (STDC). The LOOKUP_TYPE for these values is CST_COST_SOURCES. | |
| COST_REFERENCE | VARCHAR2 | 100 | Identifies a specific business object or value that further refines the cost source information, such as the source cost organization identifier or an effective date. Value would be Resource Rate Plan code. | |
| COST_TRANSACTION_TYPE | VARCHAR2 | 30 | Identifies the cost transaction type such as a RECEIPT or ISSUE. For resources it would be NULL. | |
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 20 | Additional Processing Code is an optional further definition of the Cost Transaction Type. It is used on adjustment transactions (Cost Transaction Type is set to 'ADJUST') and is set to 'WIP_STD_RESOURCE' when the adjustment was triggered by cost change; otherwise, it is set to null. | |
| QUANTITY | NUMBER | This column indicates resource usage in primary UOM. | ||
| UOM_CODE | VARCHAR2 | 3 | The primary unit of measure of the resource transaction. | |
| UNIT_RATE | NUMBER | Per unit Resource rate in cost book currency. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the Cost org-cost book in which the resource transaction is processed. | |
| COST_ELEMENT_ID | NUMBER | 18 | Surrogate ID identifying the cost element that was derived for the cost component. | |
| STATUS | VARCHAR2 | 30 | Status of resource cost creation. SUCCESS and ERROR are the possible states. | |
| ERROR_CODE | VARCHAR2 | 30 | FND error code in case of error. |