CST_WO_COST_VARIANCES_GT
This GT table is used to calculate delta amount between variance already calculated and variance newly calculated.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Surrogate key identifying the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Surrogate key identifying the cost book. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate key identifying a work order in costing. | |
| VARIANCE_GROUP | VARCHAR2 | 30 | Variance group. | |
| VARIANCE_TYPE | VARCHAR2 | 30 | Variance Type | |
| COST_ELEMENT_ID | NUMBER | 18 | Surrogate key identifying the cost element. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Surrogate key identifying expense pool. | |
| OLD_COST | NUMBER | Old cost. | ||
| NEW_COST | NUMBER | New cost. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency Code |