CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175