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. |