CST_RESOURCE_COSTS_S_GT
This table is used to temporarily store a subset of the data from cst_resource_costs table for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_RESOURCE_COSTS_S_GT_PK |
RESOURCE_COST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_COST_ID | NUMBER | 18 | Yes | Surrogate key that identifies a row in this table. | |
| RESOURCE_TRANSACTION_ID | NUMBER | 18 | Yes | The unique identifier for the resource transaction in Costing. | |
| COST_ORG_ID | NUMBER | 18 | Yes | The unique identifier for the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | The unique identifier for the cost book. | |
| RESOURCE_ID | NUMBER | 18 | Yes | The unique identifier for the resource. | |
| EFF_DATE | TIMESTAMP | Yes | Indicates the effective date of the resource cost. | ||
| COST_DATE | TIMESTAMP | Yes | Indicates the cost date of the resource transaction. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| COST_ELEMENT_ID | NUMBER | 18 | Yes | The unique identifier for the cost element. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Yes | The unique identifier for the expense pool. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Indicates the resource transaction type. | |
| COST_SOURCE | VARCHAR2 | 30 | Identifies the source of the resource cost. | ||
| 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 | Yes | Identifies the cost transaction type such as a RECEIPT or ISSUE. For resources it would be RECEIPT/ISSUE based on resource quantity sign. | |
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 20 | Additional processing code is an optional further definition of the cost transaction type. It is used on adjustment transactions and is set to 'WIP_STD_RESOURCE' when the adjustment is triggered by cost change. Else, it is set to null. | ||
| QUANTITY | NUMBER | Yes | Indicates the resource usage in primary unit of measure. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the primary unit of measure for the resource transaction. | |
| UNIT_COST | NUMBER | Yes | Indicates the per unit resource rate in cost book currency for each cost element and expense pool combination applicable on the transaction. The per unit rate is derived based on the cost date. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Identifies the currency of the cost book in which the resource transaction is processed. | |
| POSTED_FLAG | VARCHAR2 | 5 | Indicates if the distribution has been created for the resource cost. Possible values are: Y - Yes, N - No. | ||
| DISTRIBUTION_ID | NUMBER | 18 | Identifies the distribution header, if the distribution is created for the resource transaction. | ||
| STD_RESOURCE_RATE_ID | NUMBER | 18 | Yes | The unique identifier for the resource rate. | |
| DISTRIBUTION_TYPE | VARCHAR2 | 30 | Indicates the distribution type. Useful if the same event type may go into different accounting line types depending on some attribute on the cost. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_RESOURCE_COSTS_S_GT_U1 | Unique | RESOURCE_COST_ID |