ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
Displays scheduled payments for site-level transactions (for example, installment plans), enhancing cash flow planning and visibility.
Columns
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId [KEY] | Long | The unique identifier for the bill-to site use in the context of transaction payment schedules, linking payment schedules to specific bill-to sites. |
| InstallmentId [KEY] | Long | The unique identifier for the installment of a transaction in the payment schedule, used to track individual installment payments. |
| InstallmentNumber | Long | The sequential number assigned to each installment in the payment schedule. |
| TotalOriginalAmount | Decimal | The original total amount for the transaction installment before any adjustments or payments are applied. |
| TotalBalanceAmount | Decimal | The remaining balance amount for the transaction installment, after applying any payments or adjustments. |
| PaymentDaysLate | Int | The number of days the payment is overdue for the transaction installment, helping to track delinquency. |
| InstallmentStatus | String | The status of the installment, which indicates whether it is pending, paid, or partially paid. |
| TransactionNumber | String | The unique identifier for the transaction associated with the payment schedule. |
| TransactionId | Long | The unique ID of the transaction, used for linking the payment schedule to a specific transaction. |
| TransactionDate | Date | The date when the transaction associated with the payment schedule was created. |
| TransactionClass | String | The classification of the transaction, providing context for categorizing the type of payment. |
| PaymentScheduleDueDate | Date | The due date for the payment schedule, indicating when payment is expected. |
| AccountingDate | Date | The accounting date associated with the payment schedule, representing the date on which the payment is recorded in the accounting system. |
| PurchaseOrder | String | The purchase order number associated with the transaction, providing additional context for the payment schedule. |
| TransactionType | String | The type of transaction related to the payment schedule, such as sale or refund. |
| ReceiptMethod | String | The method used to make the payment for the transaction installment, such as cash, check, or bank transfer. |
| EnteredCurrency | String | The currency in which the transaction installment is entered, particularly relevant for multi-currency transactions. |
| TransactionSourceName | String | The name of the source system or process that generated the transaction, helping to trace the origin of the payment schedule. |
| StructuredPaymentReference | String | A unique identifier used to structure and track the payment reference for this transaction installment. |
| CreatedBy | String | The user or system responsible for creating the payment schedule record. |
| CreationDate | Datetime | The date and time when the payment schedule was first created. |
| LastUpdateDate | Datetime | The date and time when the payment schedule record was last updated. |
| LastUpdatedBy | String | The user or system responsible for the last update to the payment schedule. |
| BillToSiteNumber | String | The number identifying the bill-to site associated with the payment schedule, providing a link to the specific location. |
| AccountNumber | String | The account number for the customer associated with the payment schedule. |
| BillToSiteUseId | Long | The unique identifier for the use of the bill-to site in relation to the payment schedule. |
| CustomerName | String | The name of the customer for whom the payment schedule is created. |
| Finder | String | A search term or identifier used to locate and retrieve payment schedule records based on specific search criteria. |
| TaxpayerIdentificationNumber | String | The Tax Indentification Number (TIN) of the customer, relevant for tax reporting and compliance. |
| TaxRegistrationNumber | String | The tax registration number of the customer, required for tax reporting and compliance. |
| TransactionLimitByDays | Int | The maximum number of days allowed for the transaction payment, after which the payment may be considered overdue. |
| TransactionStatus | String | The status of the transaction related to the payment schedule, such as pending, completed, or overdue. |