Layer Inventory Valuations
The Layer Inventory Valuations view object contains layer valuations with quantities at the inventory attribute level and the costs as total costs.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstLayerInventoryValuationExtractPVO
Primary Keys : CstLayerInventoryValuationPEOValuationId
Initial Extract Date : CstLayerInventoryValuationPEOCreationDate
Incremental Extract Date : CstLayerInventoryValuationPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CstLayerInventoryValuationPEOCostBookId | Value that identifies the cost book assigned to the cost organization. |
CstLayerInventoryValuationPEOCostMethodCode | Value that identifies the cost method code. Valid values include PERPETUAL AVERAGE and FIFO. |
CstLayerInventoryValuationPEOCostOrgId | Value that identifies the cost organization associated with the inventory organization. |
CstLayerInventoryValuationPEOCountryOfOriginCode | Value that identifies the country of the origin associated with the valuation. |
CstLayerInventoryValuationPEOCreatedBy | User who created the row. |
CstLayerInventoryValuationPEOCreationDate | Date and time the row was created. |
CstLayerInventoryValuationPEOCurrencyCode | Value that identifies the currency of the transaction. |
CstLayerInventoryValuationPEOEndDate | Value that identifies the date effectivity. The information in the row is valid up to this date. |
CstLayerInventoryValuationPEOInventoryItemId | Value that identifies the inventory Item associated with the transaction. |
CstLayerInventoryValuationPEOInventoryOrgId | Value that identifies the inventory organization associated with the item. |
CstLayerInventoryValuationPEOLastUpdateDate | Date and time the row was last updated. |
CstLayerInventoryValuationPEOLastUpdateLogin | Session login associated to the user who last updated the row. |
CstLayerInventoryValuationPEOLastUpdatedBy | User who last updated the row. |
CstLayerInventoryValuationPEOLocatorId | Value that identifies the transaction's inventory locator. |
CstLayerInventoryValuationPEOPeriodName | Value that identifies the period in which the valuation exists. |
CstLayerInventoryValuationPEOPerpAverageCost | Value that identifies the perpetual average cost, if the valuation is for a perpetual average costed item. |
CstLayerInventoryValuationPEOPriorValuationId | Value that identifies the prior period valuation record. |
CstLayerInventoryValuationPEOProjectId | Value that identifies the project associated with the valuation. |
CstLayerInventoryValuationPEOQuantityOnhand | Value that identifies the on hand quantity of the item in the current period. |
CstLayerInventoryValuationPEORecTrxnId | Value that identifies the receipt transaction identifier for which the layer on hand is displayed. This can also contain the issue transaction identifier if the information is for a negative inventory depletion layer. |
CstLayerInventoryValuationPEOStandardCost | Value that identifies the standard cost if the valuation is for a standard costed item. |
CstLayerInventoryValuationPEOStartDate | Value that identifies the date of the snapshot of on hand inventory and cost taken for reporting in OTBI analysis. |
CstLayerInventoryValuationPEOSubinventoryCode | Value that identifies the subinventory code where the item is stored. |
CstLayerInventoryValuationPEOTaskId | Value that identifies the project task associated with the valuation. |
CstLayerInventoryValuationPEOUnitCost | Value that identifies the actual cost if the valuation is for an actual costed item. |
CstLayerInventoryValuationPEOUomCode | Value that identifies the unit of measure of the quantities. |
CstLayerInventoryValuationPEOValUnitId | Value that identifies the valuation unit identifier for the transaction. |
CstLayerInventoryValuationPEOValuationId | Value that identifies the database generated number used to identify a unique record. |