JDBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

ItemCostscostDetails

Tracks costs at a granular cost-element level for inventory items, supporting detailed cost analysis.

Columns

Name Type Description
ItemCostsCostBookId [KEY] Long The unique identifier for the cost book associated with the item cost details. This identifier ensures that costs are recorded using the correct valuation method.
ItemCostsCostMethod [KEY] String The cost method applied to the item within the cost book, such as 'Standard Costing', 'FIFO', or 'Weighted Average'. This method determines how inventory value is calculated.
ItemCostsCostOrganizationId [KEY] Long The unique identifier for the cost organization managing the item cost details. This identifier ensures proper tracking of cost structures within specific business units.
ItemCostsItemId [KEY] Long The unique identifier for the inventory item associated with the cost details. This identifier ensures accurate cost tracking and valuation of individual products.
ItemCostsTransactionId [KEY] Long The unique identifier for the transaction associated with item costs. This identifier links item cost details to specific financial transactions and inventory movements.
ItemCostsValuationUnitId [KEY] Long The unique identifier for the valuation unit used in cost accounting. This identifier ensures proper cost allocation across different business units.
CostElementId [KEY] Long The unique identifier for the cost element used in item cost calculations. This identifier links cost components such as material, labor, and overhead to the item.
CostElement String The name of the cost element, such as 'Material Cost', 'Labor Cost', or 'Overhead'. This field helps break down total item costs into individual components.
CostElementType String The classification of the cost element, indicating whether it is a direct or indirect cost. This classification helps in analyzing cost contributions for inventory valuation.
UnitCostAverage Decimal The average unit cost of the inventory item. This information is used for inventory valuation and financial reporting.
CurrencyCode String The currency code used for cost valuation. This code ensures that item costs are recorded in the appropriate monetary units.
CostPercent Decimal The percentage of total item cost attributed to the specific cost element. This metric helps in understanding cost distribution within an item's valuation.
BindCategoryName String The name of the item category linked to the cost book entry. This name ensures consistency in cost classification.
BindCostBook String The name of the cost book associated with the cost details. This name ensures financial transactions are recorded using the correct cost valuation rules.
BindCostBookId Long The unique identifier for the cost book linked to item cost details. This identifier ensures accurate cost tracking and financial reporting.
BindCostDate Datetime The date when the cost record was created. This date ensures that cost calculations are aligned with financial periods.
BindCostMethod String The cost method applied to the item in the cost book. This method determines how item costs are calculated and allocated.
BindCostOrg String The cost organization responsible for the item cost details. This information 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 item cost details. This information determines how inventory costs are managed and recorded.
BindEffectiveEndDate Date The date when the cost entry is no longer valid. This date prevents outdated costs from affecting financial calculations.
BindEffectiveStartDate Date The date when the cost entry becomes active. This date ensures accurate financial reporting within the specified period.
BindItem String The inventory item associated with the cost entry. This field ensures that cost calculations are properly assigned to specific products.
BindItemDescription String The description of the inventory item linked to the cost entry. This description provides clarity in financial reporting.
BindItemId Long The unique identifier for the inventory item linked to the cost entry. This identifier ensures accurate cost tracking and valuation.
BindReceiptNumber String The receipt number associated with the cost entry. This receipt number links costs to specific procurement or receiving events.
BindTotalUnitCost String The total unit cost recorded in the cost book for the item. This information ensures proper valuation of inventory within financial records.
BindValStructureCode String The valuation structure code associated with the cost entry. This information ensures that inventory is valued using the correct financial model.
BindValuationUnit String The valuation unit used for cost calculations within the cost book. This unit ensures proper cost allocation across different financial entities.
CostBookId Long The unique identifier for the cost book in which the item cost details are recorded. This identifier ensures consistent cost management.
CostMethod String The cost method used for valuing the item, such as 'FIFO', 'LIFO', or 'Standard Costing'. This method determines how inventory costs are calculated.
CostOrganizationId Long The unique identifier for the organization managing item costs. This identifier ensures proper cost tracking within specific business units.
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.
ItemId Long The unique identifier for the inventory item. This identifier ensures accurate cost tracking and valuation of specific products.
TransactionId Long The unique identifier for the transaction linked to item costs. This identifier ensures traceability between financial transactions and inventory movements.
ValuationUnitId Long The unique identifier for the valuation unit associated with item costs. This identifier ensures proper cost allocation within financial models.

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