ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
Tracks payment schedules (for example, installments) for a customer’s transactions, ensuring consistent collections and visibility.
Columns
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId [KEY] | Long | The unique identifier for the customer account linked to the transaction payment schedule, used to track payments and their associated accounts. |
| InstallmentId [KEY] | Long | The unique identifier for each installment in the payment schedule, allowing for individual tracking of scheduled payments. |
| InstallmentNumber | Long | The sequential number assigned to each installment in the payment schedule, indicating its order in the payment plan. |
| TotalOriginalAmount | Decimal | The original amount due for the installment before any adjustments, discounts, or partial payments. |
| TotalBalanceAmount | Decimal | The remaining balance for the installment that is still due for payment, accounting for any partial payments made. |
| PaymentDaysLate | Int | The number of days that the payment is late, used to assess whether any penalties or interest should be applied. |
| InstallmentStatus | String | The current status of the installment, such as 'Pending', 'Paid', or 'Overdue', indicating the payment's progress. |
| TransactionNumber | String | A unique reference number assigned to the transaction associated with the installment, used for tracking and reporting. |
| TransactionId | Long | The unique identifier for the transaction related to the installment, linking it to a specific financial entry. |
| TransactionDate | Date | The date when the transaction was recorded, providing context for the installment's timing. |
| TransactionClass | String | The classification of the transaction, used to group similar types of financial activities for accounting purposes. |
| PaymentScheduleDueDate | Date | The date by which the payment for the installment is due, helping to track deadlines and ensure timely payments. |
| AccountingDate | Date | The date when the transaction is recorded in the system for accounting purposes, used to align with financial periods. |
| PurchaseOrder | String | The purchase order number associated with the transaction, often used in business processes to match payments to specific orders. |
| TransactionType | String | The type of transaction, such as 'Payment', 'Refund', or 'Adjustment', providing context for the financial event. |
| ReceiptMethod | String | The method used to receive payment, such as 'Check', 'Wire Transfer', or 'Credit Card', indicating how the installment was paid. |
| EnteredCurrency | String | The currency in which the transaction was originally entered, ensuring accurate currency conversion and reporting. |
| TransactionSourceName | String | The name of the source system or origin of the transaction, such as 'Order Entry' or 'Payment Gateway'. |
| StructuredPaymentReference | String | A reference used for structured payments, which may include specific formatting or identifiers for tracking purposes. |
| CreatedBy | String | The user who created the payment schedule record, ensuring accountability for the initial entry. |
| CreationDate | Datetime | The date and time when the payment schedule record was created, used for auditing and tracking record creation. |
| LastUpdateDate | Datetime | The date and time when the payment schedule record was last updated, providing a history of changes made. |
| LastUpdatedBy | String | The user who last updated the payment schedule record, providing accountability for modifications. |
| BillToSiteNumber | String | The site number for the bill-to location associated with the customer, indicating where invoices are directed. |
| AccountId | Long | The unique identifier for the account associated with the payment schedule, allowing for easy lookup and tracking. |
| AccountNumber | String | The account number for the customer receiving the payment schedule, used for identification and reporting. |
| CustomerName | String | The name of the customer associated with the payment schedule, used to identify the party responsible for the payments. |
| Finder | String | A reference or search term that helps locate the specific transaction payment schedule in the system for reporting or management. |
| TaxpayerIdentificationNumber | String | The Tax Indentification 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 payments in the payment schedule, used to enforce time-based rules for transactions. |
| TransactionStatus | String | The status of the transaction, such as 'Completed', 'Pending', or 'Canceled', indicating the payment's processing state. |