ReceivablesCustomerAccountActivitiestransactionAdjustments
Details any adjustments (increases or decreases) applied to a customer’s transactions, reflecting corrections or policy updates.
Columns
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId [KEY] | Long | The unique identifier for the customer account, linking the transaction adjustment to a specific account in the ReceivablesCustomerAccountActivities transaction adjustments table. |
| AdjustmentId [KEY] | Long | The unique identifier for the adjustment, used to track and manage individual transaction adjustments applied to a customer account. |
| AdjustmentNumber | String | A unique number assigned to each transaction adjustment for tracking and reference purposes within the accounting system. |
| AdjustmentAmount | Decimal | The total amount of the adjustment applied to the customer account, either increasing or decreasing the balance. |
| ApplicationDate | Date | The date when the adjustment was applied to the customer account, indicating when the financial change took place. |
| AccountingDate | Date | The date when the adjustment is recognized for accounting purposes, typically aligning with the posting date for financial reporting. |
| ProcessStatus | String | The current status of the adjustment in the process flow, such as 'Pending', 'Applied', or 'Rejected'. |
| EnteredCurrency | String | The currency used for the adjustment, reflecting the currency in which the transaction was originally recorded. |
| AdjustmentType | String | The type of adjustment being made, such as 'Credit', 'Debit', or other category defined by business rules. |
| AdjustmentReason | String | The reason for making the adjustment, helping to provide context for the financial modification. |
| ReferenceTransactionNumber | String | The transaction number of the original transaction to which the adjustment is applied, used for reference and auditing purposes. |
| ReferenceTransactionId | Long | The unique identifier for the transaction referenced by the adjustment, linking the adjustment to its original transaction. |
| ReferenceInstallmentId | Long | The unique identifier for the installment related to the adjustment, used to track partial payments or installment-based adjustments. |
| LastUpdateDate | Datetime | The date and time when the adjustment was last updated in the system, used to track changes or corrections to the adjustment record. |
| LastUpdatedBy | String | The user who last updated the adjustment record, providing accountability for changes made to the transaction. |
| CreatedBy | String | The user who initially created the adjustment record, providing accountability for the creation of the adjustment. |
| CreationDate | Datetime | The date and time when the adjustment record was created, used to track the historical context of the adjustment. |
| BillToSiteNumber | String | The site number for the billing address associated with the adjustment, helping to identify the location of the customer making the adjustment. |
| ReferenceTransactionStatus | String | The status of the referenced transaction, indicating whether the original transaction is 'Paid', 'Unpaid', or in another state. |
| AccountId | Long | The unique identifier for the account to which the adjustment is applied, linking the adjustment to a specific customer account. |
| AccountNumber | String | The account number for the customer account receiving the adjustment, helping to identify the correct account for processing. |
| CustomerName | String | The name of the customer associated with the adjustment, used to identify the party making or receiving the adjustment. |
| Finder | String | A search term or reference that helps locate specific adjustment records in the system for reporting or management purposes. |
| TaxpayerIdentificationNumber | String | The Tax Identification Number (TIN) associated with the customer, used for tax reporting and compliance. |
| TaxRegistrationNumber | String | The tax registration number of the customer, important for legal and tax reporting in certain jurisdictions. |
| TransactionLimitByDays | Int | The maximum number of days allowed for processing adjustments on a specific transaction, used to enforce time-based rules for financial transactions. |
| TransactionStatus | String | The status of the transaction adjustment, indicating whether it is 'Completed', 'Pending', or 'Rejected'. |