CST_WO_COST_VARIANCES_I

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
CST_WO_COST_VARIANCES_I_GT_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 UOM.
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.
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	Columns
CST_WO_COST_VARIANCES_I_GT_U1	Unique	WO_COST_VARIANCE_ID