Variance Costs

The Variance Costs view object contains the variance between standard cost and transaction cost.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstVarianceCostsExtractPVO

Primary Keys : CstVarianceCostsPEOVarianceCostId

Initial Extract Date : CstVarianceCostsPEOCreationDate

Incremental Extract Date : CstVarianceCostsPEOLastUpdateDate

Attributes

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

Name	Description
CstVarianceCostsPEOAbsorptionType	Indicates the type of absorption. Possible values are defined in the lookup type CST_ABSORPTION_TYPE.
CstVarianceCostsPEOAdditionalProcessingCode	Indicates the optional further definition of the cost transaction type.
CstVarianceCostsPEOBaseTxnTypeId	Unique identifier of the inventory transaction type.
CstVarianceCostsPEOCostBookId	Unique identifier of cost book assigned to cost organization.
CstVarianceCostsPEOCostDate	Date on which the transaction is costed in costing system.
CstVarianceCostsPEOCostElementId	Unique identifier of the cost element corresponding to cost of the transaction.
CstVarianceCostsPEOCostOrgId	Unique identifier of the cost organization associated with the inventory organization.
CstVarianceCostsPEOCostReference	Identifies the cost reference.
CstVarianceCostsPEOCostSource	Identifies the cost source.
CstVarianceCostsPEOCostTransactionType	Identifies the type of costing transaction. It's used by the costing engine to categorize group processing.
CstVarianceCostsPEOCreatedBy	User who created the variance cost row.
CstVarianceCostsPEOCreationDate	Date and time when the variance cost row was created.
CstVarianceCostsPEOCurrencyCode	Identifies the currency of the transaction.
CstVarianceCostsPEODepTrxnId	Unique identifier of depletion transaction
CstVarianceCostsPEODistributionId	Unique identifier of the cost distribution header record. This is the primary key of the Cost Distributions view object.
CstVarianceCostsPEODistributionType	Indicates the cost distribution type.
CstVarianceCostsPEOEffDate	Date from which cost is effective.
CstVarianceCostsPEOExpensePoolId	Unique identifier of the expense pool. This is the primary key of the Costing Expense Pools view object.
CstVarianceCostsPEOInventoryItemId	Unique identifier of the inventory item.
CstVarianceCostsPEOLastUpdateDate	Date when the variance cost row was last updated.
CstVarianceCostsPEOLastUpdateLogin	Session login associated with the user who last updated the variance cost row.
CstVarianceCostsPEOLastUpdatedBy	User who last updated the variance cost row.
CstVarianceCostsPEOPostedFlag	Indicates whether transaction is posted or not.
CstVarianceCostsPEOQuantity	Indicates the current quantity on hand.
CstVarianceCostsPEORecTrxnId	Unique identifier of the receipt transaction.
CstVarianceCostsPEOTransactionCostId	Unique identifier of the transaction cost. It's the primary key of Transaction Costs view object.
CstVarianceCostsPEOTransactionId	Unique identifier of the costing transaction. This is the primary key of the Costing Transactions view object.
CstVarianceCostsPEOUnitCost	Identifies the current transaction cost.
CstVarianceCostsPEOUomCode	Identifies the unit of measure.
CstVarianceCostsPEOValUnitId	Unique identifier of the valuation unit ID. This is part of primary key of Valuation Unit Combinations view object.
CstVarianceCostsPEOVarianceCostId	Unique identifier of the variance cost transaction.
CstVarianceCostsPEOWoCostPostedFlag	Indicates whether costs related to WIP have been transferred to CST_WORK_ORDER_COSTS. Possible values are N, Y, and X.