ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

CostAdjustments

Tracks cost adjustments for item receipts or perpetual average costs, including performance optimization using REST APIs.

Columns

Name Type Description
AdjustmentHeaderId [KEY] Long The unique identifier for the cost adjustment header, grouping related cost transactions under a single adjustment entry. This identifier ensures traceability and consolidated reporting of cost modifications in financial records.
AdjustmentNumber String The unique alphanumeric identifier assigned to the cost adjustment. This identifier is used for tracking, financial reconciliation, and audit purposes within the cost management system.
AdjustmentTypeCode String An abbreviation that identifies the type of cost adjustment, determining how cost updates are processed. Values include 'P-Perpetual' for ongoing cost changes, 'R-Receipt' for adjustments based on receipts, and 'L-Layer' for layered cost valuation updates.
AdjustmentDate Datetime The date when the cost adjustment was made, indicating when inventory cost changes were applied in the system. This date ensures that cost updates align with financial reporting periods and inventory valuation cycles.
AdjustmentStatusCode String An abbreviation that represents the current status of the adjustment, indicating its progress in the approval workflow. Values include 'P-Pending' for unapproved changes, 'S-Submitted' for adjustments awaiting review, and 'C-Voided' for canceled transactions.
ReasonCode String An abbreviation that identifies the reason for the cost adjustment transaction, providing an explanation for cost updates. This abbreviation supports audit trails and compliance with financial reporting requirements.
TransactionId Long The unique identifier for the transaction in the costing system. This identifier ensures accurate traceability of cost-related updates and proper alignment with inventory movements.
CostOrganizationId Long The unique identifier for the cost organization responsible for managing and tracking cost transactions across inventory locations. This identifier ensures accurate financial reporting and compliance with cost accounting policies.
CostBookId Long The unique identifier for the cost book associated with the adjustment. This identifier determines the financial policies, accounting rules, and valuation methods that apply to the cost update.
ItemId Long The unique identifier for the inventory item being adjusted, ensuring that cost changes are applied to the correct product. This identifier maintains accuracy in stock valuation and cost reporting.
InventoryOrganizationId Long The unique identifier for the inventory organization responsible for managing stock and applying cost adjustments. This identifier ensures that inventory costing is recorded correctly for financial and operational reporting.
ReceiptQuantity Decimal The quantity of the item received, affecting inventory valuation and cost calculations. This value helps determine the impact of new stock on the overall inventory cost.
QuantityOnhand Decimal The remaining quantity of the item in inventory after adjustments. This value ensures that stock records accurately reflect actual availability and financial valuation.
TotalUnitCost Decimal The total cost per unit of the received item, used in cost valuation and inventory financial calculations. This value influences profitability analysis and cost management.
TotalNewCost Decimal The total revised cost of the received item after applying the adjustment. This information impacts financial reporting, stock valuation, and the cost of goods sold (COGS).
ValuationUnitId Long The unique identifier for the valuation unit, defining cost groupings within inventory accounting. This identifier ensures accurate cost tracking and reporting across different inventory segments.
CostDate Datetime The date of the costing transaction for the adjustment, used to align cost updates with financial periods. This date supports historical cost tracking and ensures compliance with accounting principles.
ReceiptNumber String The unique number identifying the receipt related to the transaction. This number ensures proper cost tracking, reconciliation, and validation of received inventory.
CurrencyCode String An abbreviation that identifies the currency in which the cost adjustment is recorded. This abbreviation ensures proper financial alignment in multi-currency transactions and financial reporting.
CostOrganizationName String The name of the cost organization responsible for managing the adjustment. This field can be reviewed and updated using the Setup and Maintenance work area under the Manage Cost Organizations task.
CostBook String The name of the cost book that applies to the adjustment, determining financial policies and cost methodologies. This field can be updated using the Manage Cost Books task.
InventoryOrganizationName String The name of the inventory organization where the cost adjustment is applied, ensuring accurate stock valuation and tracking.
Item String The name of the inventory item affected by the cost adjustment, providing a readable reference for users managing stock valuation.
ValuationUnit String The valuation unit for the adjustment, defining cost management levels. This information can be reviewed and updated using the Manage Valuation Units task.
AdjustmentType String The type of adjustment being made. Values include 'Perpetual', 'Receipt', or 'Layer', which define how inventory costs are recalculated.
AdjustmentStatus String The status of the adjustment ('Pending', 'Submitted', or 'Voided'), which helps track approval workflows.
Reason String The reason for the cost adjustment transaction, providing an explanation for cost updates (for example, supplier price changes or corrections).
UOMCode String The abbreviation that identifies the unit of measure (UOM) associated with the inventory item, ensuring consistent stock tracking.
UOMName String The full name of the UOM, providing clarity on how the inventory quantity is recorded and managed.
BindAdjustmentDate Datetime The date when the bound adjustment was recorded, used to link related cost adjustments and ensure accurate historical tracking.
BindAdjustmentNumber String The unique number assigned to the bound adjustment, providing a reference for tracking and validating cost adjustments.
BindAdjustmentStatus String The current status of the bound adjustment, indicating whether it is pending, submitted, or voided, and linking it to cost transactions and approvals.
BindAdjustmentType String The category of the bound adjustment (for example, 'Perpetual', 'Receipt', or 'Layer'), determining how inventory costs are recalculated.
BindCostBook String The name of the cost book linked to the bound adjustment, which defines the financial policies and rules governing cost calculations.
BindCostOrgName String The name of the cost organization associated with the bound adjustment, ensuring accurate cost tracking across financial entities.
BindItem String The name of the inventory item affected by the bound adjustment, ensuring that cost updates apply to the correct stock item.
BindReason String The explanation for the bound adjustment, documenting the justification for the cost change (for example, corrections or supplier price updates).
BindReceiptNumber String The receipt number associated with the bound adjustment, linking it to the corresponding inventory receipt for accurate cost reconciliation.
BindValuationUnit String The valuation unit assigned to the bound adjustment, determining how inventory costs are grouped and reported in financial records.
Finder String The reference key used to quickly search and retrieve specific cost adjustments within the system, improving efficiency in cost tracking and reporting.

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