ItemCosts
Provides detailed cost management for inventory items within cost organizations and books, optimized for perpetual average cost method.
Columns
| Name | Type | Description |
| CostOrganizationId [KEY] | Long | The unique identifier for the cost organization managing item costs. This identifier ensures accurate tracking of cost structures within specific business units or entities. |
| CostOrganizationName | String | The name of the cost organization responsible for managing item costs. This field provides clarity in cost reporting and financial tracking. |
| CostOrganizationCode | String | A code representing the cost organization. This code helps standardize cost management across multiple business units. |
| CostBookId [KEY] | Long | The unique identifier for the cost book associated with the item. This identifier ensures proper cost valuation and financial reporting. |
| CostBook | String | The name of the cost book used for tracking inventory valuation. This field helps define cost structures within different financial periods or business scenarios. |
| CostProfile | String | The cost profile assigned to the item. This field determines how inventory costs are calculated and recorded, based on cost accounting rules. |
| CostProfileId | Long | The unique identifier for the cost profile assigned to the item. This identifier links the cost methodology to the inventory item. |
| ItemCategory | String | The category classification of the inventory item. This categorization helps in cost reporting, valuation, and grouping similar products for financial analysis. |
| ItemCategoryId | Decimal | The unique identifier for the item category. This identifier ensures consistent cost classification across inventory items. |
| ItemId [KEY] | Long | The unique identifier for the inventory item. This identifier ensures accurate cost tracking and valuation of individual products. |
| ItemNumber | String | The unique item number assigned to the inventory item. This item number is used for cost tracking and financial reporting. |
| ItemDescription | String | A detailed description of the inventory item. This description provides clarity on the item's attributes for cost management purposes. |
| CostMethodCode | String | A system-generated abbreviation representing the cost method applied to the item. This abbreviation determines how item costs are calculated. |
| ValuationStructureId | Long | The unique identifier for the valuation structure used in cost accounting. This identifier ensures accurate financial reporting and compliance. |
| ValuationStructureCode | String | A code representing the valuation structure. This code helps categorize cost structures across inventory and financial systems. |
| ValuationUnitId [KEY] | Long | The unique identifier for the valuation unit associated with the item. This identifier field is used to manage cost valuation within business units. |
| ValuationUnit | String | The valuation unit used for cost calculation. This field helps define how inventory costs are assessed within financial models. |
| ReceiptNumber | String | The unique receipt number associated with the inventory transaction. This receipt number links costs to specific procurement or receiving events. |
| TransactionId [KEY] | Long | The unique identifier for the inventory transaction associated with item costs. This identifier ensures traceability between financial transactions and inventory movements. |
| CurrencyCode | String | The currency code used for item cost valuation. This code ensures financial transactions are recorded in the appropriate monetary units. |
| UOMName | String | The name of the unit of measure (UOM) associated with item costs. This field standardizes cost calculations across different measurement units. |
| UOMCode | String | A system-generated abbreviation representing the UOM for item costs. This abbreviation ensures consistency in financial calculations. |
| TotalUnitCost | Decimal | The total cost per unit of the inventory item. This cost includes material, labor, overhead, and other cost components. |
| CostChange | Decimal | The change in unit cost for the item. This information helps in analyzing cost fluctuations over time. |
| CostAsOfDate | Datetime | The date when the cost value was recorded. This date ensures that cost calculations are based on accurate and up-to-date financial data. |
| EffectiveStartDate | Date | The date when the cost record becomes active. This date that costs are applied only within valid financial periods. |
| EffectiveEndDate | Date | The date when the cost record is no longer valid. This date prevents outdated cost values from being used in financial calculations. |
| QuantityOnhand | Decimal | The quantity of inventory on hand at the time of cost valuation. This quantity is critical for accurate inventory costing and financial reporting. |
| CostMethod [KEY] | String | The cost method applied to the inventory item (for example, 'Standard Costing', 'FIFO', or 'Weighted Average'). This method determines how inventory value is calculated. |
| BindCategoryName | String | The name of the item category linked to the cost book. This field ensures consistency in cost classification. |
| BindCostBook | String | The cost book linked to the item costs. This field ensures financial transactions are recorded using the correct cost valuation rules. |
| BindCostBookId | Long | The unique identifier for the cost book linked to item costs. This identifier ensures accurate cost tracking and financial reporting. |
| BindCostDate | Datetime | The date when the cost was recorded in the cost book. This date ensures that cost transactions align with financial periods. |
| BindCostMethod | String | The cost method applied to the item within the cost book. This method determines how item costs are calculated and allocated. |
| BindCostOrg | String | The cost organization associated with the cost book entry. This field ensures proper cost allocation within different financial entities. |
| BindCostOrgId | Long | The unique identifier for the cost organization linked to the cost book entry. This identifier ensures accurate financial reporting. |
| BindCostProfile | String | The cost profile associated with the cost book entry. This information determines how inventory costs are managed and recorded. |
| BindEffectiveEndDate | Date | The date when the cost book entry is no longer valid. This date prevents outdated costs from affecting financial calculations. |
| BindEffectiveStartDate | Date | The date when the cost book entry becomes active. This date ensures accurate financial reporting within the specified period. |
| BindItem | String | The inventory item linked to the cost book entry. This information ensures that cost calculations are properly assigned to specific products. |
| BindItemDescription | String | The description of the inventory item associated with the cost book entry. This description provides clarity in financial reporting. |
| BindItemId | Long | The unique identifier for the inventory item linked to the cost book entry. This identifier ensures accurate cost tracking and valuation. |
| BindReceiptNumber | String | The receipt number associated with the cost book entry. This receipt number links costs to specific procurement or receiving events. |
| BindTotalUnitCost | String | The total unit cost associated with the cost book entry. This information ensures proper valuation of inventory within the cost book. |
| BindValStructureCode | String | The valuation structure code linked to the cost book entry. This code ensures that inventory is valued using the correct financial model. |
| BindValuationUnit | String | The valuation unit used for cost calculations within the cost book. This information ensures proper cost allocation across different financial entities. |
| Finder | String | A reference attribute used for searching and retrieving specific item cost records. This attribute enhances system usability by allowing users to locate cost-related transactions efficiently. |