CST_RESOURCE_COSTS_I_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_I_GT_PK |
RESOURCE_COST_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RESOURCE_COST_ID | NUMBER | 18 | Yes | Surrogate ID identifying a row in this table. | |
RESOURCE_TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID identifying a resource transaction in costing. | |
COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization associated to the plan where the resource was consumed. | |
COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book. | |
RESOURCE_ID | NUMBER | 18 | Yes | Surrogate ID identifying the resource that was consumed. | |
EFF_DATE | TIMESTAMP | Yes | Effective date of the resource cost. Same as cost date. | ||
COST_DATE | TIMESTAMP | Yes | Cost date of the resource transaction. | ||
COST_ELEMENT_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost element against which the cost is captured. | |
EXPENSE_POOL_ID | NUMBER | 18 | Yes | Surrogate ID identifying the expense pool against which the cost is captured. | |
BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Resource transaction type identifier. | |
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 | 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 (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 | Yes | Resource usage in primary UOM. | ||
UOM_CODE | VARCHAR2 | 3 | Yes | The primary unit of measure of the resource transaction. | |
UNIT_COST | NUMBER | Yes | 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 org-cost book in which the resource transaction is processed. | |
POSTED_FLAG | VARCHAR2 | 5 | Indicates if the distributions have been created for the resource cost. Y- Yes, N- No. | ||
DISTRIBUTION_ID | NUMBER | 18 | Identifies the Distribution Header, if the distributions have been created for the resource transaction record. | ||
STD_RESOURCE_RATE_ID | NUMBER | 18 | Yes | Surrogate ID identifying the Frozen Resource Rate line published to Cost Accounting that was used for deriving the resource rate. | |
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_I_GT_U1 | Unique | RESOURCE_TRANSACTION_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, EFF_DATE |
CST_RESOURCE_COSTS_I_GT_U2 | Unique | RESOURCE_COST_ID |