ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

CostAdjustmentsAdjustmentDetail

Provides detailed cost adjustments at the cost-element level for receipts or items.

Columns

Name Type Description
CostAdjustmentsAdjustmentHeaderId [KEY] Long The unique identifier for the cost adjustment header associated with the adjustment detail, linking detailed cost modifications to the main adjustment record. This identifier ensures accurate tracking of cost changes across financial transactions.
AdjustmentHeaderId Long The unique identifier for the adjustment header, grouping related cost adjustments under a single transaction. This identifier allows for consolidated reporting and tracking of cost modifications in inventory valuation.
CostElementId Long The unique identifier for the cost element being adjusted, specifying the individual cost component affected by the adjustment. Cost elements include categories such as 'material', 'labor', 'overhead', and 'freight'.
ExpensePoolId Long The unique identifier for the expense pool, which represents a collection of indirect costs allocated to inventory items. This identifier supports accurate cost distribution and financial reporting in cost accounting.
NewCost Decimal The updated cost value for the specified cost element after the adjustment is applied. This change directly impacts inventory valuation, cost of goods sold (COGS), and financial reporting.
SourceTransactionCostId Long The unique identifier for the transaction cost record linked to the adjustment detail. This identifier ensures that cost adjustments are accurately applied and reconciled with original financial transactions.
SourceTransactionId Long The unique identifier for the original transaction associated with the cost adjustment. This identifier allows the system to track the adjustment back to its source, such as an inventory receipt, transfer, or financial posting.
UnitCost Decimal The cost per unit of the specified cost element, reflecting adjustments made to individual inventory or expense components. This field is used in inventory valuation and cost accounting calculations.
UserAdjustmentId [KEY] Long The unique identifier for the user-defined adjustment, distinguishing manually entered cost changes from system-generated adjustments. This identifier allows for tracking of user-initiated cost modifications.
UserComment String An optional comment entered by the user to provide additional context or justification for the cost adjustment. This field helps maintain audit trails and supports compliance with financial controls.
CostElement String The cost element used when creating an adjustment detail, such as 'material cost', 'labor cost', or 'freight'. This classification ensures that cost adjustments are properly categorized in financial reports.
ExpensePool String The expense pool associated with the cost adjustment, representing a grouping of indirect costs allocated to inventory valuation. This field supports accurate cost distribution across multiple financial periods.
UserDefinedFlag Bool Indicates whether the adjustment detail was manually created by the user ('true') or system-generated based on existing cost elements ('false'). This information helps differentiate user-driven modifications from automated cost updates.
BindAdjustmentDate Datetime The date when the bound adjustment was recorded. This date is used to link related cost adjustments and ensure accurate financial tracking across reporting periods.
BindAdjustmentNumber String A unique number assigned to the bound adjustment. This number provides a reference for cost tracking, financial reconciliation, and audit purposes.
BindAdjustmentStatus String The current status of the bound adjustment, indicating whether it is pending, submitted, approved, or voided. This status helps in tracking approval workflows and cost accounting processes.
BindAdjustmentType String The category of the bound adjustment, such as 'Perpetual', 'Receipt', or 'Layer'. This categorization determines how inventory costs are recalculated and reflected in financial statements.
BindCostBook String The name of the cost book linked to the bound adjustment. This book defines the financial policies and rules governing cost calculations, including depreciation, expense allocation, and valuation methods.
BindCostOrgName String The name of the cost organization associated with the bound adjustment. This name ensures that cost tracking is aligned with financial entities and organizational reporting structures.
BindItem String The name of the inventory item affected by the bound adjustment. This name ensures that cost updates apply to the correct stock item and are properly reflected in inventory valuation.
BindReason String The explanation for the bound adjustment, documenting the justification for the cost change. Common reasons include supplier price updates, corrections, and changes in cost allocation policies.
BindReceiptNumber String The receipt number associated with the bound adjustment, linking it to the corresponding inventory receipt transaction. This receipt number ensures proper reconciliation of cost adjustments with inbound stock movements.
BindValuationUnit String The valuation unit assigned to the bound adjustment, determining how inventory costs are grouped and reported in financial records. This field supports accurate cost accounting and inventory valuation.
Finder String The reference key used to quickly search and retrieve specific cost adjustments within the system. This reference key improves efficiency in cost tracking, reporting, and financial analysis.

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