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