Cost of Goods Sold Variances

The Cost of Goods Sold Variances view object contains the distributions created by Create Cost Accounting Distributions process for the RMA transactions variances specific to cost organization and cost book.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstCogsVarianceCostsExtractPVO

Primary Keys : CstCogsVarianceCostsPEOCogsVarianceCostId

Initial Extract Date : CstCogsVarianceCostsPEOCreationDate

Incremental Extract Date : CstCogsVarianceCostsPEOLastUpdateDate

Attributes

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

Name Description
CstCogsVarianceCostsPEOCogsTransactionId Value that uniquely identifies the cost of goods sold transaction for which the layer is created. This is the primary key of the Cost of Goods Sold Transactions view object.
CstCogsVarianceCostsPEOCogsVarianceCostId Unique identifier of the cost of goods sold variances row. This is the primary key of the Cost of Goods Sold Variances view object.
CstCogsVarianceCostsPEOCreatedBy User who created the cost of goods sold variance.
CstCogsVarianceCostsPEOCreationDate Date and time when the cost of goods sold variance was created.
CstCogsVarianceCostsPEOCstTransactionId Value that uniquely identifies the cost transaction associated to the cost of goods sold transaction. This is the primary key of the Costing Transactions view object.
CstCogsVarianceCostsPEOCstVarianceCostId Value that uniquely identifies the Cost variance which the cost of goods sold layer is created. This is the primary key of the Variance Costs view object.
CstCogsVarianceCostsPEODistributionId Value that uniquely identifies the distribution created for the cost of goods sold layer. This is the primary key of the Cost Distributions view object.
CstCogsVarianceCostsPEOLastUpdateDate Date and time when the cost of goods sold variance row was last updated.
CstCogsVarianceCostsPEOLastUpdateLogin Session login associated with the user who last updated the cost of goods sold variance row.
CstCogsVarianceCostsPEOLastUpdatedBy User who last updated the cost of goods sold variance row.
CstCogsVarianceCostsPEOPostedFlag Value that indicates if distribution has been created for this layer. Y indicates yes, N indicates no. There is no LOOKUP_TYPE for this column.
CstCogsVarianceCostsPEOQuantity Value that indicates the layer quantity for the transaction.