ItemCosts
The cost of an inventory item specific to a cost organization and cost book for items that use the perpetual average cost method. To achieve better performance, use the appropriate finders with the filter parameters cost organization, cost book, and item. In addition, for further improvement in performance, you need to create and enable the profile option CST_ADJ_REST_IGNORE_QTY_ONHAND in the cost management application. With this profile option, the REST process ignores on-hand calculations and returns the cost.
Columns
Name | Type | Description |
CostOrganizationId [KEY] | Long | CostOrganizationId of ItemCosts |
CostOrganizationName | String | CostOrganizationName of ItemCosts |
CostOrganizationCode | String | CostOrganizationCode of ItemCosts |
CostBookId [KEY] | Long | CostBookId of ItemCosts |
CostBook | String | CostBook of ItemCosts |
CostProfile | String | CostProfile of ItemCosts |
CostProfileId | Long | CostProfileId of ItemCosts |
ItemCategory | String | ItemCategory of ItemCosts |
ItemCategoryId | Decimal | ItemCategoryId of ItemCosts |
ItemId [KEY] | Long | ItemId of ItemCosts |
ItemNumber | String | ItemNumber of ItemCosts |
ItemDescription | String | ItemDescription of ItemCosts |
CostMethodCode | String | CostMethodCode of ItemCosts |
ValuationStructureId | Long | ValuationStructureId of ItemCosts |
ValuationStructureCode | String | ValuationStructureCode of ItemCosts |
ValuationUnitId [KEY] | Long | ValuationUnitId of ItemCosts |
ValuationUnit | String | ValuationUnit of ItemCosts |
ReceiptNumber | String | ReceiptNumber of ItemCosts |
TransactionId [KEY] | Long | TransactionId of ItemCosts |
CurrencyCode | String | CurrencyCode of ItemCosts |
UOMName | String | UOMName of ItemCosts |
UOMCode | String | UOMCode of ItemCosts |
TotalUnitCost | Decimal | TotalUnitCost of ItemCosts |
CostChange | Decimal | CostChange of ItemCosts |
CostAsOfDate | Datetime | CostAsOfDate of ItemCosts |
EffectiveStartDate | Date | EffectiveStartDate of ItemCosts |
EffectiveEndDate | Date | EffectiveEndDate of ItemCosts |
QuantityOnhand | Decimal | QuantityOnhand of ItemCosts |
CostMethod [KEY] | String | CostMethod of ItemCosts |
BindCategoryName | String | BindCategoryName of ItemCosts |
BindCostBook | String | BindCostBook of ItemCosts |
BindCostBookId | Long | BindCostBookId of ItemCosts |
BindCostDate | Datetime | BindCostDate of ItemCosts |
BindCostMethod | String | BindCostMethod of ItemCosts |
BindCostOrg | String | BindCostOrg of ItemCosts |
BindCostOrgId | Long | BindCostOrgId of ItemCosts |
BindCostProfile | String | BindCostProfile of ItemCosts |
BindEffectiveEndDate | Date | BindEffectiveEndDate of ItemCosts |
BindEffectiveStartDate | Date | BindEffectiveStartDate of ItemCosts |
BindItem | String | BindItem of ItemCosts |
BindItemDescription | String | BindItemDescription of ItemCosts |
BindItemId | Long | BindItemId of ItemCosts |
BindReceiptNumber | String | BindReceiptNumber of ItemCosts |
BindTotalUnitCost | String | BindTotalUnitCost of ItemCosts |
BindValStructureCode | String | BindValStructureCode of ItemCosts |
BindValuationUnit | String | BindValuationUnit of ItemCosts |
Finder | String | Finder of ItemCosts |