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