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