ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers
Identifies cross-customer payments applied to site-related transactions, aiding reconciliation when a third party settles balances.
Columns
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId [KEY] | Long | The unique identifier linking the bill-to site use to the transaction paid by other customers, helping to associate the payment schedule with a specific site. |
| ApplicationId [KEY] | Long | The identifier for the payment application in the context of transactions paid by other customers. |
| ApplicationDate | Date | The date when the payment was applied to the transaction, marking the payment processing date. |
| ApplicationAmount | Decimal | The amount applied from the payment to the transaction, indicating how much was paid against the outstanding balance. |
| ApplicationStatus | String | The status of the payment application, such as 'completed', 'pending', or 'failed', reflecting the current state of the payment. |
| AccountingDate | Date | The accounting date when the transaction related to the payment is recognized in the financial system, often used for period-end reporting. |
| ReferenceInstallmentId | Long | The installment ID that links the payment to a specific installment of the transaction being paid. |
| ReferenceTransactionNumber | String | The reference number for the transaction being paid by another customer, used to trace the payment application back to its original transaction. |
| ReferenceTransactionId | Long | The unique identifier for the transaction that is being paid, allowing easy identification of the specific transaction. |
| StandardReceiptId | Long | The identifier of the standard receipt associated with the payment, useful for tracking and managing receipts in the system. |
| ReceiptNumber | String | The receipt number assigned to the payment transaction, providing a unique reference for the receipt in the accounting system. |
| EnteredCurrency | String | The currency in which the payment was entered, important for multi-currency transactions and conversions. |
| ReceiptMethod | String | The method used to make the payment, such as 'wire transfer', 'check', or 'credit card', indicating how the payment was made. |
| ProcessStatus | String | The current status of the payment processing, such as 'pending', 'processed', or 'failed', to track the lifecycle of the payment. |
| IsLatestApplication | String | Indicates whether this application is the most recent payment applied to the transaction, helping to identify the current state of the payment. |
| CreatedBy | String | The user or system that created the payment application, typically the responsible party or system generating the transaction. |
| CreationDate | Datetime | The date and time when the payment application was created, providing a timestamp for audit and tracking purposes. |
| LastUpdateDate | Datetime | The date and time when the payment application record was last updated, reflecting the most recent changes or actions taken. |
| LastUpdatedBy | String | The user or system responsible for the most recent update to the payment application, allowing for accountability in changes. |
| ReferenceTransactionStatus | String | The status of the reference transaction, such as 'open', 'paid', or 'closed', showing the payment's effect on the underlying transaction. |
| AccountNumber | String | The account number associated with the payment, helping to link the payment to the customer account. |
| BillToSiteNumber | String | The bill-to site number for the customer, specifying the site where the payment is applied and helping to track transactions at multiple customer locations. |
| BillToSiteUseId | Long | The identifier for the specific use of the bill-to site in the transaction, ensuring the payment is applied to the correct site. |
| CustomerName | String | The name of the customer whose transaction is being paid, useful for identifying the paying party. |
| Finder | String | A search term or keyword used to help locate the payment application in the system, aiding in quick retrieval of transaction details. |
| TaxpayerIdentificationNumber | String | The Tax Indentification Number (TIN) for the customer, necessary for tax reporting and compliance purposes. |
| TaxRegistrationNumber | String | The tax registration number for the customer, required for tax purposes and necessary in international transactions. |
| TransactionLimitByDays | Int | The maximum number of days allowed for the payment application to be processed, helping to track the timeliness of payments. |
| TransactionStatus | String | The status of the transaction being paid, such as 'pending', 'paid', or 'closed', indicating the state of the underlying transaction. |