Work Order Cost Variances

The Work Order Cost Variances view object contains the variances between published standard cost and WIP cost of the work order at the cost element level.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstWOCostVariancesExtractPVO

Primary Keys : CstWOCostVariancesPEOWoCostVarianceId

Initial Extract Date : CstWOCostVariancesPEOCreationDate

Incremental Extract Date : CstWOCostVariancesPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CstWOCostVariancesPEOBaseTxnTypeId	Value that uniquely identifies the work order variance transaction type.
CstWOCostVariancesPEOCostBookId	Value that uniquely identifies the cost book. This is the primary key of the Cost Books view object.
CstWOCostVariancesPEOCostDate	Cost date derived on the work order variance transaction.
CstWOCostVariancesPEOCostElementId	Value that uniquely identifies the cost element for which cost variance is recorded. This is the primary key of the Cost Elements view object.
CstWOCostVariancesPEOCostOrgId	Value that uniquely identifies the cost organization associated with the plant where the work order is carried out.
CstWOCostVariancesPEOCreatedBy	User who created the work order cost variance.
CstWOCostVariancesPEOCreationDate	Date and time when the work order cost variance row was created.
CstWOCostVariancesPEOCstWorkOrderId	Value that uniquely identifies the work order for which variance or expense is recorded. This is the primary key of the Costing Work Orders view object.
CstWOCostVariancesPEOCurrencyCode	Code that identifies the currency in which the variance is calculated.
CstWOCostVariancesPEODistributionId	Value that uniquely identifies the distribution line, if distributions have been created for the variance record.
CstWOCostVariancesPEOInventoryItemId	Value that uniquely identifies the primary product associated with the work order.
CstWOCostVariancesPEOLastUpdateDate	Date when the work order cost variance was last updated.
CstWOCostVariancesPEOLastUpdateLogin	Session login associated with the user who last updated the work order cost variance.
CstWOCostVariancesPEOLastUpdatedBy	User who last updated the work order cost variance.
CstWOCostVariancesPEOPostedFlag	Contains one of the following values: Y or N. If Y, then the distributions have been created for the variance cost. If N, then distributions haven't been created for the variance cost. This attribute doesn't have a default value.
CstWOCostVariancesPEOQuantity	Quantity of end item produced through the work order.
CstWOCostVariancesPEOReversalCostVarianceId	Value that uniquely identifies the original work order cost variance.
CstWOCostVariancesPEOReversalFlag	Contains one of the following values: Y, N or NULL. If Y, then the previously booked work order expense has been reversed. If N, then the previously booked work order expense hasn't been reversed. If NULL, then this isn't a work order expense variance. The default value is NULL.
CstWOCostVariancesPEOUomCode	Code that indicates the costing unit of measure.
CstWOCostVariancesPEOVarianceAmount	Total variance amount calculated at the cost element level as on the cost date.
CstWOCostVariancesPEOVarianceGroup	Group of variance. A list of accepted values is defined in the lookup type ORA_CST_WIP_VARIANCE_GROUPS.
CstWOCostVariancesPEOVarianceType	Type of variance. A list of accepted values is defined in the lookup type ORA_CST_WIP_VARIANCE_TYPES.
CstWOCostVariancesPEOWoCostVarianceId	Value that uniquely identifies the variance transaction. This is the primary key of the Work Order Cost Variances view object.
CstWOCostVariancesPEOWoUpdateEventTxnId	Value that uniquely identifies the work order close transaction. This is the primary key of the Costing Work Order Update Events view object.