JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesCustomerAccountSiteActivitiestransactionAdjustments

Tracks adjustments (credits, debits) to site-based transactions, ensuring accurate account records and resolving discrepancies.

Columns

Name Type Description
ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId [KEY] Long The unique identifier for the bill-to site use in the context of transaction adjustments, linking the adjustment to the appropriate billing site.
AdjustmentId [KEY] Long The unique identifier for each adjustment, used to track and manage adjustments made to customer transactions.
AdjustmentNumber String The number assigned to the adjustment for easy reference and tracking in financial records.
AdjustmentAmount Decimal The amount of the adjustment applied to the transaction. It can either increase or decrease the balance of a transaction.
ApplicationDate Date The date when the adjustment was applied to the transaction, typically corresponding to the date of the action.
AccountingDate Date The accounting date for the adjustment, which determines the accounting period in which the adjustment is recorded.
ProcessStatus String The status of the adjustment, indicating whether it has been processed, is in progress, or is pending.
EnteredCurrency String The currency in which the adjustment was made, relevant for multi-currency accounting.
AdjustmentType String The type of adjustment, which could be a credit, debit, or other types of adjustments, based on the nature of the transaction.
AdjustmentReason String The reason for the adjustment, describing the cause or justification for modifying the transaction amount.
ReferenceTransactionNumber String The number of the transaction to which the adjustment is linked, providing a reference for auditing and tracking.
ReferenceTransactionId Long The unique identifier of the transaction associated with the adjustment, linking it to the original transaction.
ReferenceInstallmentId Long The installment ID associated with the transaction being adjusted, relevant when the transaction is paid in installments.
LastUpdateDate Datetime The date and time when the adjustment record was last updated.
LastUpdatedBy String The user or system that last updated the adjustment record.
CreatedBy String The user or system that created the adjustment record.
CreationDate Datetime The date and time when the adjustment record was first created.
BillToSiteNumber String The number identifying the bill-to site associated with the adjustment.
ReferenceTransactionStatus String The status of the reference transaction, indicating whether it has been fully processed, partially applied, or is still pending.
AccountNumber String The account number of the customer to which the adjustment is applied, used for identifying the customer's account.
BillToSiteUseId Long The unique identifier for the use of the bill-to site in relation to the adjustment.
CustomerName String The name of the customer associated with the adjustment, providing context for customer-related accounting.
Finder String A search term or identifier used to locate and retrieve adjustment records based on specific search criteria.
TaxpayerIdentificationNumber String The Tax Indentification Number (TIN) (TIN) of the customer, used for tax reporting and compliance purposes.
TaxRegistrationNumber String The tax registration number of the customer, required for tax reporting and compliance.
TransactionLimitByDays Int The maximum number of days by which the transaction can be adjusted, affecting the due date and payment processing.
TransactionStatus String The status of the transaction related to the adjustment, indicating its current state in the processing cycle.

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