Inventory Valuations

The Inventory Valuations view object contains inventory valuation with quantities at the inventory attribute level and the costs at total level.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstInventoryValuationExtractPVO

Primary Keys : CstAttrOnhandValuationsPEOValuationId

Initial Extract Date : CstAttrOnhandValuationsPEOCreationDate

Incremental Extract Date : CstAttrOnhandValuationsPEOLastUpdateDate

Attributes

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

Name	Description
CstAttrOnhandValuationsPEOAcctdAmount	Amount that's final accounted.
CstAttrOnhandValuationsPEOAcctdWriteoffAmount	Amount in write-off that should be in inventory and is final accounted.
CstAttrOnhandValuationsPEOAmount	Amount of quantity on hand.
CstAttrOnhandValuationsPEOCostBookId	Value that uniquely identifies the cost book assigned to the cost organization.
CstAttrOnhandValuationsPEOCostMethodCode	Code that identifies the cost method used for cost processing the inventory item. A list of acceptable values is defined in the lookup type CST_COST_METHODS.
CstAttrOnhandValuationsPEOCostOrgId	Value that uniquely identifies the cost organization associated with the inventory organization for which the inventory valuation is done.
CstAttrOnhandValuationsPEOCountryOfOriginCode	Code that identifies the country of origin associated to the valuation unit.
CstAttrOnhandValuationsPEOCreatedBy	User who created the inventory valuation.
CstAttrOnhandValuationsPEOCreationDate	Date and time when the inventory valuation was created.
CstAttrOnhandValuationsPEOCurrencyCode	Code that identifies the currency in which inventory valuation is done.
CstAttrOnhandValuationsPEOEndDate	Date up to which the inventory valuation is done.
CstAttrOnhandValuationsPEOExclFromAcctgAmount	Inventory valuation amount that's excluded from accounting.
CstAttrOnhandValuationsPEOExclFromAcctgWoAmount	Amount in write-off that should be in inventory and is excluded from accounting.
CstAttrOnhandValuationsPEOInventoryItemId	Value that uniquely identifies the inventory item for which the valuation is done.
CstAttrOnhandValuationsPEOInventoryOrgId	Value that uniquely identifies the inventory organization to which the item belongs.
CstAttrOnhandValuationsPEOLastUpdateDate	Date when the inventory valuation was last updated.
CstAttrOnhandValuationsPEOLastUpdateLogin	Session login associated with the user who last updated the inventory valuation.
CstAttrOnhandValuationsPEOLastUpdatedBy	User who last updated the inventory valuation.
CstAttrOnhandValuationsPEOLocatorId	Value that uniquely identifies the inventory locator.
CstAttrOnhandValuationsPEONewIssueQuantity	Newly issued quantity of the item in the current period.
CstAttrOnhandValuationsPEONewReceiptQuantity	Newly received quantity of the item in the current period.
CstAttrOnhandValuationsPEOPeriodName	Period name in which the inventory valuation is done.
CstAttrOnhandValuationsPEOPerpAverageCost	Unit cost of the item, when the inventory item is average costed.
CstAttrOnhandValuationsPEOPriorValuationId	Value that uniquely identifies the inventory valuation for the prior period.
CstAttrOnhandValuationsPEOProjectId	Value that uniquely identifies the project associated with the valuation.
CstAttrOnhandValuationsPEOQuantityOnhand	Quantity of the inventory item on hand for the period.
CstAttrOnhandValuationsPEOStandardCost	Unit cost of the item, when the inventory item is standard costed.
CstAttrOnhandValuationsPEOStartDate	Date of snapshot for inventory on hand and cost of the item.
CstAttrOnhandValuationsPEOStartingQuantity	Beginning quantity of the inventory item on hand for the period.
CstAttrOnhandValuationsPEOSubinventoryCode	Code that identifies the subinventory where the inventory item is stored.
CstAttrOnhandValuationsPEOTaskId	Value that uniquely identifies the task associated with the valuation.
CstAttrOnhandValuationsPEOUnitCost	Unit cost of the inventory item.
CstAttrOnhandValuationsPEOUomCode	Code that identifies the unit of measure for inventory item quantity.
CstAttrOnhandValuationsPEOValUnitId	Value that uniquely identifies the valuation unit of the inventory item.
CstAttrOnhandValuationsPEOValuationId	Value that uniquely identifies the inventory valuation. This is the primary key of the Inventory Valuations view object.
CstAttrOnhandValuationsPEOVuAmount	Total amount for the valuation unit.
CstAttrOnhandValuationsPEOVuQuantityOnhand	Total quantity on hand at the valuation unit level.
CstAttrOnhandValuationsPEOVuUnitCost	Unit cost of the item, when the item is actual costed.
CstAttrOnhandValuationsPEOVuValuationId	Value that uniquely identifies the valuation on hand for the costing valuation unit.
CstAttrOnhandValuationsPEOVuWriteoffAmount	Total amount that's in write-off instead of inventory at the valuation unit level.
CstAttrOnhandValuationsPEOWriteoffAmount	Amount of quantity on hand that's in write-off instead of inventory.