ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

ReceivablesAdjustments

Allows modification of existing invoices, credit memos, or other transactions, adjusting charges, freight, taxes, or lines.

Columns

Name Type Description
AdjustmentId [KEY] Long The unique identifier assigned to each receivables adjustment, helping to distinguish one adjustment from another.
AdjustmentNumber String A unique number given to the adjustment transaction, which helps in tracking and referencing the specific adjustment.
AdjustmentType String The type of the adjustment (such as 'Write-off', 'Refund', or 'Correction') indicating the nature of the modification applied to the receivable.
AdjustmentAmount Decimal The total amount of the adjustment applied to the receivable, which could be an increase or decrease depending on the adjustment type.
AdjustmentDate Date The date on which the adjustment was processed, marking when the modification to the receivable occurred.
AccountingDate Date The accounting date assigned to the adjustment, used for accounting entries and reporting, which may differ from the transaction date.
Status String The current status of the adjustment, such as 'Pending', 'Approved', or 'Rejected', indicating the progress of the adjustment in the workflow.
ReceivablesActivity String A reference to the activity or process associated with the adjustment, such as 'Payment Application' or 'Charge-off'.
BusinessUnit String The business unit within the organization that is responsible for the receivables adjustment. It typically represents a division or a department.
CustomerTransactionId Long The unique identifier of the customer transaction that the adjustment is related to, linking the adjustment back to the original transaction.
TransactionNumber String The transaction number associated with the customer’s original transaction that is being adjusted.
TransactionClass String The class of the transaction (for example, 'Invoice', 'Credit Memo'), which categorizes the type of transaction that is being adjusted.
AccountedAmount Decimal The amount of the adjustment that has been accounted for in the general ledger, ensuring that the financial records reflect the change.
Currency String The currency in which the adjustment is made, ensuring that amounts are appropriately calculated and reported in the correct currency.
InstallmentNumber Long The specific installment of the receivable that the adjustment applies to, helping to track adjustments made to particular payment plans or installments.
InstallmentBalance Decimal The balance remaining for the specific installment after the adjustment is applied, helping to track how much is still due for that installment.
AdjustmentReason String The reason for making the adjustment, such as 'Discount Applied', 'Overpayment', or 'Write-off', which provides context for the adjustment.
ApprovedBy String The individual or system that authorized or approved the adjustment, ensuring proper governance and oversight of receivables changes.
BillToSiteUseId Long The unique identifier for the billing site associated with the adjustment, which helps to link the adjustment to a specific customer or location.
Comments String Additional comments or notes related to the adjustment, often used to provide context or explanations for the adjustment made.
AccountCombination String The account combination used for posting the adjustment in the general ledger, linking it to the appropriate accounts and ensuring proper accounting.
CreationDate Datetime The date and time when the adjustment record was initially created, used for tracking and auditing purposes.
CreatedBy String The user or system that created the adjustment entry, providing accountability for the creation of the adjustment.
LastUpdateDate Datetime The date and time when the adjustment was last modified, ensuring that the most up-to-date information is available.
LastUpdatedBy String The individual who last updated the adjustment, allowing for traceability and accountability in the adjustment’s lifecycle.
Finder String A reference field used to search for and locate receivables adjustments within the system.

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