Work Order Cost Variance Details

The Work Order Cost Variance Details view object contains the cost and quantity information for each component or resource at work definition and work order side. This data is further used to find the variance information including the variance type and cost elemental details.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstWOCostVarianceDtlsExtractPVO

Primary Keys : CstWOCostVarianceDtlsPEOWoDtlCostVarianceId

Initial Extract Date : CstWOCostVarianceDtlsPEOCreationDate

Incremental Extract Date : CstWOCostVarianceDtlsPEOLastUpdateDate

Attributes

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

Name	Description
CstWOCostVarianceDtlsPEOBasisType	Basis type for the resource or component usage rate. A list of accepted values is defined in the lookup type ORA_CST_USAGE_BASIS_TYPE.
CstWOCostVarianceDtlsPEOCostBookId	Value that uniquely identifies the cost book. This is the primary key of the Cost Books view object.
CstWOCostVarianceDtlsPEOCostDate	Cost date derived on the variance transaction.
CstWOCostVarianceDtlsPEOCostElementId	Value that uniquely identifies the cost element. This is the primary key of the Cost Elements view object.
CstWOCostVarianceDtlsPEOCostOrganizationId	Value that uniquely identifies the cost organization.
CstWOCostVarianceDtlsPEOCostingBatchOutputSize	Batch size based on which costs are rolled up in the costing unit of measure.
CstWOCostVarianceDtlsPEOCreatedBy	User who created the work order cost variance detail.
CstWOCostVarianceDtlsPEOCreationDate	Date and time when the work order cost variance detail was created.
CstWOCostVarianceDtlsPEOCstWorkOrderId	Value that uniquely identifies the work order in costing. This is the primary key of the Costing Work Orders view object
CstWOCostVarianceDtlsPEOCstWorkOrderOperationId	Value that uniquely identifies the work order operation in costing. This is the primary key of the Costing Work Order Operations view object.
CstWOCostVarianceDtlsPEOCurrencyCode	Code that identifies the cost book currency in which all amounts are calculated.
CstWOCostVarianceDtlsPEOExpensePoolId	Value that uniquely identifies the expense pool. This is the primary key of the Expense Pools view object.
CstWOCostVarianceDtlsPEOLastUpdateDate	Date when the work order cost variance detail was last updated.
CstWOCostVarianceDtlsPEOLastUpdateLogin	Session login associated with the user who last updated the work order cost variance detail.
CstWOCostVarianceDtlsPEOLastUpdatedBy	User who last updated the work order cost variance detail.
CstWOCostVarianceDtlsPEOMaterialInventoryItemId	Value that uniquely identifies the component item when the transaction type is COMPONENT.
CstWOCostVarianceDtlsPEOOperationOutputItemId	Value that uniquely identifies the output item. In the case of process manufacturing work orders, the output item can be either a primary product, by-product, or coproduct.
CstWOCostVarianceDtlsPEOOperationSequenceNum	Sequence number of the operation.
CstWOCostVarianceDtlsPEOOutputInventoryItemId	Value that uniquely identifies the output item of the work order.
CstWOCostVarianceDtlsPEOOutputInventoryOrgId	Value that uniquely identifies the plant where the job is done.
CstWOCostVarianceDtlsPEOOutputUomCode	Code that identifies the costing unit of measure of the output item.
CstWOCostVarianceDtlsPEOResourceId	Value that uniquely identifies the resource when the transaction type is RESOURCE.
CstWOCostVarianceDtlsPEOSccrSourceTypeCode	Contains one of the following values: NULL, B, BM, BMT, BT, M, MT, or T. Indicates if the sourcing rule type is buy, make, transfer, or a blend of these rule types. NULL indicates that sourcing rules aren't used for this item.
CstWOCostVarianceDtlsPEOScenarioRollupDetailId	Value that uniquely identifies the scenario detail header from where the standard cost is derived.
CstWOCostVarianceDtlsPEOScenarioRollupHeaderId	Value that uniquely identifies the scenario header from where the standard cost is derived.
CstWOCostVarianceDtlsPEOStdCostId	Value that uniquely identifies the published standard cost record.
CstWOCostVarianceDtlsPEOSubstitutionFlag	Contains one of the following values: Y or N. If Y, then the cost variance detail is of type substitution variance. If N, then the cost variance detail isn't of type substitution variance. This attribute doesn't have a default value.
CstWOCostVarianceDtlsPEOTransactionType	Type of transaction. Currently the applicable values are COMPONENT and RESOURCE. COMPONENT indicates materials for a work order. RESOURCE indicates the resources for a work order.
CstWOCostVarianceDtlsPEOUomCode	Code that identifies the costing unit of measure of the resource or component.
CstWOCostVarianceDtlsPEOVarianceCost	Total calculated variance cost.
CstWOCostVarianceDtlsPEOVarianceGroup	Group of variance. A list of accepted values is defined in the lookup type ORA_CST_WIP_VARIANCE_GROUPS.
CstWOCostVarianceDtlsPEOVarianceType	Type of variance. A list of accepted values is defined in the lookup type ORA_CST_WIP_VARIANCE_TYPES.
CstWOCostVarianceDtlsPEOWdMakeUnitCost	Cost derived from rolling up the work definition of the item in cost planning.
CstWOCostVarianceDtlsPEOWdOperationId	Value that uniquely identifies the work definition operation.
CstWOCostVarianceDtlsPEOWdScaledQty	Scaled up quantity at the work definition side for the resource or component.
CstWOCostVarianceDtlsPEOWdUnitCost	Published cost per unit in the cost book currency.
CstWOCostVarianceDtlsPEOWoCompletionQty	Total quantity of output items completed by the work order.
CstWOCostVarianceDtlsPEOWoDtlCostVarianceId	Value that uniquely identifies the work order cost variance detail record. This is the primary key of the Work Order Cost Variance Details view object.
CstWOCostVarianceDtlsPEOWoQuantity	Total quantity reported at the work order side for the resource or component.
CstWOCostVarianceDtlsPEOWoUnitCost	Cost per unit calculated at work order side.
CstWOCostVarianceDtlsPEOWoUpdateEventTxnId	Value that uniquely identifies the work order update event transaction. This is the primary key of the Costing Work Order Update Event Transactions view object.