Inventory Valuation Details

The Inventory Valuation Details view object contains inventory valuation details with quantities at the inventory attribute level and the costs at cost element level.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstInvValuationDetailsExtractPVO

Primary Keys : CstAttrOnhandDetailsPEOValDetailId

Initial Extract Date : CstAttrOnhandDetailsPEOCreationDate

Incremental Extract Date : CstAttrOnhandDetailsPEOLastUpdateDate

Attributes

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

Name	Description
CstAttrOnhandDetailsPEOAcctdAmount	Amount that's final accounted.
CstAttrOnhandDetailsPEOAcctdWriteoffAmount	Amount in write-off that should be in inventory and is final accounted.
CstAttrOnhandDetailsPEOAmount	Amount of quantity on hand.
CstAttrOnhandDetailsPEOAttrValuationId	Value that uniquely identifies the inventory valuation to which the inventory valuation details belong.
CstAttrOnhandDetailsPEOCostBookId	Value that uniquely identifies the cost book assigned to the cost organization.
CstAttrOnhandDetailsPEOCostElementId	Value that uniquely identifies the cost element associated with the cost of inventory valuation details.
CstAttrOnhandDetailsPEOCostMethodCode	Code that identifies the cost method used for cost processing the inventory item. A list of acceptable values defined in the lookup type CST_COST_METHODS.
CstAttrOnhandDetailsPEOCostOrgId	Value that uniquely identifies the cost organization associated with the inventory organization for which the inventory valuation is done.
CstAttrOnhandDetailsPEOCountryOfOriginCode	Code that identifies the country of origin associated to the valuation unit.
CstAttrOnhandDetailsPEOCreatedBy	User who created the inventory valuation details.
CstAttrOnhandDetailsPEOCreationDate	Date and time when the inventory valuation details was created.
CstAttrOnhandDetailsPEOCurrencyCode	Code that identifies the currency in which inventory valuation is done.
CstAttrOnhandDetailsPEOEndDate	Date up to which the inventory valuation is done.
CstAttrOnhandDetailsPEOExclFromAcctgAmount	Inventory valuation details amount that's excluded from accounting.
CstAttrOnhandDetailsPEOExclFromAcctgWoAmount	Amount in write-off that should be in inventory and is excluded from accounting.
CstAttrOnhandDetailsPEOInventoryItemId	Value that uniquely identifies the inventory item for which the valuation is done.
CstAttrOnhandDetailsPEOInventoryOrgId	Value that uniquely identifies the inventory organization to which the item belongs.
CstAttrOnhandDetailsPEOLastUpdateDate	Date when the inventory valuation details was last updated.
CstAttrOnhandDetailsPEOLastUpdateLogin	Session login associated with the user who last updated the inventory valuation details.
CstAttrOnhandDetailsPEOLastUpdatedBy	User who last updated the inventory valuation details.
CstAttrOnhandDetailsPEOLocatorId	Value that uniquely identifies the inventory locator.
CstAttrOnhandDetailsPEONewIssueQuantity	Newly issued quantity of the item in the current period.
CstAttrOnhandDetailsPEONewReceiptQuantity	Newly received quantity of the item in the current period.
CstAttrOnhandDetailsPEOPeriodName	Period name in which the inventory valuation is done.
CstAttrOnhandDetailsPEOPerpAverageCost	Unit cost of the item, when the inventory item is average costed.
CstAttrOnhandDetailsPEOPriorValDetailId	Value that uniquely identifies the inventory valuation details for the prior period.
CstAttrOnhandDetailsPEOProjectId	Value that uniquely identifies the project associated with the valuation.
CstAttrOnhandDetailsPEOQuantityOnhand	Quantity of the inventory item on hand for the period.
CstAttrOnhandDetailsPEOStandardCost	Unit cost of the item, when the inventory item is standard costed.
CstAttrOnhandDetailsPEOStartDate	Date of snapshot for inventory on hand and cost of the item.
CstAttrOnhandDetailsPEOStartingQuantity	Beginning quantity on hand for the period.
CstAttrOnhandDetailsPEOSubinventoryCode	Code that identifies the subinventory where the inventory item is stored.
CstAttrOnhandDetailsPEOTaskId	Value that uniquely identifies the task associated to the valuation.
CstAttrOnhandDetailsPEOUnitCost	Unit cost of the inventory item.
CstAttrOnhandDetailsPEOUomCode	Code that identifies the unit of measure for the inventory item quantity.
CstAttrOnhandDetailsPEOValDetailId	Value that uniquely identifies the inventory valuation details. This is the primary key of the Inventory Valuation Details view object.
CstAttrOnhandDetailsPEOValUnitId	Value that uniquely identifies the valuation unit of the inventory item.
CstAttrOnhandDetailsPEOVuAmount	Total amount for the valuation unit.
CstAttrOnhandDetailsPEOVuQuantityOnhand	Total quantity of the inventory item at the valuation unit level.
CstAttrOnhandDetailsPEOVuUnitCost	Unit cost of the item, when the inventory item is actual costed.
CstAttrOnhandDetailsPEOVuValuationId	Value that uniquely identifies the valuation on hand for the costing valuation unit.
CstAttrOnhandDetailsPEOVuWriteoffAmount	Total amount that's in write-off instead of inventory at the valuation unit level.
CstAttrOnhandDetailsPEOWriteoffAmount	Amount of quantity on hand that's in write-off instead of inventory.