CST_TRANSACTION_OVERHEADS_I_GT
This transaction global temporary table will be used by cost processor for computing and processing overhead costs.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
CST_TXN_OVERHEADS_I_GT_PK |
OVERHEAD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OVERHEAD_ID | NUMBER | 18 | Yes | Surrogate key that identifies an overhead in costing. | |
| RULE_DETAIL_ID | NUMBER | 18 | Rule Detail Identifier. Foreign key reference from CST_OVERHEAD_RULE_DETAILS table. | ||
| OVERHEAD_GROUP_ID | NUMBER | 18 | Overhead group identifier - grouping based on transaction_id, expense_pool_id and cost_element_id. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Transaction identifier which uniquely identifies a transaction in costing. | |
| RULE_CODE | VARCHAR2 | 100 | Yes | Name that describes the overhead rule used for absorbing overheads. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Yes | Identifier of the expense pool that pools the overhead absorbed across overhead rules. | |
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | |
| ABSORPTION_TYPE | VARCHAR2 | 30 | Yes | This column indicates how the overhead gets absorbed. Valid values come from lookup type CST_ABSORPTION_TYPE. | |
| COST_DRIVER | VARCHAR2 | 30 | Yes | This column indicates how the cost is driven. Valid values come from lookup type CST_COST_DRIVER. | |
| COST_DRIVER_VALUE | NUMBER | Cost driver value - FK from cost element group Id in CST_COST_ELEMENT_GRPS_VL. | |||
| ESTIMATED_RATE | NUMBER | Yes | Indicates the estimated rate defined for the overhead rule. | ||
| UNIT_RATE | NUMBER | Indicates the unit rate in overhead rate currency. | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Yes | Identifies the currency of the transaction / cost. | |
| TRANSACTION_COST_ID | NUMBER | 18 | Yes | Single column FK: Identifies the transaction cost. | |
| POSTED_FLAG | VARCHAR2 | 5 | Yes | Indicates if the overheads have been created for the transaction. Possible values are:Y- Yes, N- No. | |
| EFF_DATE | TIMESTAMP | Yes | Date from which the overhead rule is effective. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period for which cost processor is run. This value is populated for the transactions in periodic average cost method. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_TXN_OVERHEADS_I_GT_U1 | Unique | OVERHEAD_ID |