CST_WO_COST_VARIANCES
This table will contain the variances between published standard cost and WIP cost of the end item. This entity will be used to compute the variances at cost element level and all the variances will be grouped under the 'Job close' variance type.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_COST_VARIANCES_PK |
WO_COST_VARIANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_COST_VARIANCE_ID | NUMBER | 18 | Yes | Surrogate ID identifying the variance transaction. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order for which variance/expense is recorded. | |
| WO_UPDATE_EVENT_TXN_ID | NUMBER | 18 | Surrogate ID identifying the work order status change transaction that lead to variance calculation. | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization associated to the plant associated with the work order. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the primary item associated to the work order. | |
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost element for which variance is recorded. | |
| VARIANCE_GROUP | VARCHAR2 | 30 | Yes | The variance group is a higher level classification to indicate the objects which were compared: - Engineering method variance: (Post r11) Difference between Published std. and Work definition Cost. - Work Order Variance: (Post r11) Difference between work definition cost and actual work order cost. - Total Work Order Variance: Difference between published std. and Actual work order cost. | |
| VARIANCE_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of variance e.g. 'Job close variance'. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Surrogate ID identifying the internal transaction type. | |
| QUANTITY | NUMBER | Quantity of end item that was produced via the work order. | |||
| UOM_CODE | VARCHAR2 | 3 | Indicates the costing Unit of Measure. | ||
| VARIANCE_AMOUNT | NUMBER | Total variance amount calculated as difference between the published standard cost at the cost element as on the cost date and the WIP cost at the cost element level. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency code in which variance is calculated. The cost book currency code. | ||
| COST_DATE | TIMESTAMP | Yes | The cost date derived on the variance transaction. This date will always be equal to the WO closed date persisted in the WO status transaction table. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| REVERSAL_FLAG | VARCHAR2 | 4 | Indicates if this is a reversal cost for a prior expense. | ||
| REVERSAL_COST_VARIANCE_ID | NUMBER | 18 | Surrogate ID identifying the original wo_cost_variance_id. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Indicates if the distributions have been created for the variance cost. Y- Yes, N- No. | ||
| DISTRIBUTION_ID | NUMBER | 18 | Identifies the Distribution Line, if the distributions have been created for the variance record. | ||
| 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 | Tablespace | Columns |
|---|---|---|---|
| CST_WO_COST_VARIANCES_N1 | Non Unique | Default | POSTED_FLAG, COST_ORG_ID, COST_BOOK_ID |
| CST_WO_COST_VARIANCES_N2 | Non Unique | Default | COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID, COST_DATE |
| CST_WO_COST_VARIANCES_PK | Unique | Default | WO_COST_VARIANCE_ID |