Layer Valuation Details

The Layer Valuation Details view object contains layer valuation costs at the cost element level.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstLayerValuationDetailsExtractPVO

Primary Keys : CstLayerValuationDetailsPEOValDetailId

Initial Extract Date : CstLayerValuationDetailsPEOCreationDate

Incremental Extract Date : CstLayerValuationDetailsPEOLastUpdateDate

Attributes

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

Name Description
CstLayerValuationDetailsPEOCostBookId Value that identifies the cost book assigned to the cost organization.
CstLayerValuationDetailsPEOCostElementId Value that identifies the cost element associated with the cost.
CstLayerValuationDetailsPEOCostMethodCode Value that identifies the cost method code. Valid values include PERPETUAL AVERAGE and FIFO.
CstLayerValuationDetailsPEOCostOrgId Value that identifies the cost organization associated with the inventory organization.
CstLayerValuationDetailsPEOCreatedBy User who created the row.
CstLayerValuationDetailsPEOCreationDate Date and time the row was created.
CstLayerValuationDetailsPEOCurrencyCode Value that identifies the currency of the transaction.
CstLayerValuationDetailsPEOEndDate Value that identifies the date effectivity. The information in the row is valid up to this date.
CstLayerValuationDetailsPEOInventoryItemId Value that identifies the inventory Item Identifier for which the layer valuation is maintained.
CstLayerValuationDetailsPEOLastUpdateDate Date and time the row was last updated.
CstLayerValuationDetailsPEOLastUpdateLogin Session login associated to the user who last updated the row.
CstLayerValuationDetailsPEOLastUpdatedBy User who last updated the row.
CstLayerValuationDetailsPEOPeriodName Value that identifies the period in which the valuation exists.
CstLayerValuationDetailsPEOPerpAverageCost Value that identifies the perpetual average cost if the valuation is for a perpetual average costed item.
CstLayerValuationDetailsPEOPriorValDetailId Value that identifies the prior period valuation detail row.
CstLayerValuationDetailsPEORecTrxnId Value that identifies the receipt transaction identifier for which the layer on hand quantity is displayed. This can also contain the issue transaction identifier if the information is for a negative inventory depletion layer.
CstLayerValuationDetailsPEOStandardCost Value that identifies the standard cost if the valuation is for a standard costed item.
CstLayerValuationDetailsPEOStartDate Value that identifies the date of the snapshot of on-hand inventory and cost taken for reporting in OTBI analysis.
CstLayerValuationDetailsPEOUnitCost Value that identifies the actual cost if the valuation is for an actual cost method.
CstLayerValuationDetailsPEOUomCode Value that identifies the unit of measure of the quantities.
CstLayerValuationDetailsPEOValDetailId Value that identifies the database generated number to identify a unique record.
CstLayerValuationDetailsPEOValUnitId Value that identifies the valuation unit identifier for the transaction.