ARPayment
Provides detailed records of accounts receivable payments, including transaction statuses and related metadata.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the AR payment record. |
| Prbatchkey | Int64 | Key for the associated payment batch. |
| Prbatch | String | Title of the associated payment batch. |
| Recordtype | String | Type of record for the AR payment. |
| Description | String | Description of the AR payment record. |
| Totalentered | Double | Total amount entered for the payment. |
| Totalpaid | Double | Total amount paid for the payment. |
| Totalselected | Double | Total amount selected for payment. |
| Totaldue | Double | Total amount still due for the payment. |
| State | String | Current state of the payment. |
| Whencreated | Datetime | Timestamp when the payment was created. |
| Whenpaid | Datetime | Timestamp when the payment was made. |
| Termkey | Int64 | Key for the associated payment terms. |
| Termname | String | Name of the associated payment terms. |
| Whendiscount | Datetime | Discount date for the payment, if applicable. |
| Recordid | String | Record ID for the AR payment. |
| Userkey | Int64 | Key for the user associated with the payment. |
| Whendue | Datetime | Due date for the payment. |
| Docnumber | String | Document number associated with the payment. |
| Cleared | String | Indicates if the payment has been cleared. |
| Clrdate | Datetime | Date the payment was cleared. |
| Modulekey | String | Key for the associated module. |
| Status | String | Current status of the payment. |
| Systemgenerated | String | Indicates if the payment was system-generated. |
| Whenposted | Datetime | Timestamp when the payment was posted. |
| Onhold | Boolean | Indicates if the payment is on hold. |
| Currency | String | Currency used for the payment. |
| Trx_totalentered | Double | Total amount entered in transaction currency. |
| Trx_totalpaid | Double | Total amount paid in transaction currency. |
| Trx_totalselected | Double | Total amount selected in transaction currency. |
| Trx_totaldue | Double | Total due amount in transaction currency. |
| Deliverymethod | String | Method used to deliver the payment. |
| Recon_date | Datetime | Reconciliation date for the payment. |
| Basecurr | String | Base currency for the payment. |
| Locationkey | Int64 | Key for the associated location. |
| Auwhencreated | Datetime | Audit timestamp when the payment was created. |
| Whenmodified | Datetime | Timestamp when the payment was last modified. |
| Createdby | Int64 | ID of the user who created the payment. |
| Modifiedby | Int64 | ID of the user who last modified the payment. |
| Nr_totalentered | Double | Total amount entered without rounding adjustments. |
| Nr_trx_totalentered | Double | Transaction currency total entered without rounding adjustments. |
| Paymentdate | Datetime | Date the payment was issued. |
| Receiptdate | Datetime | Date the payment receipt was created. |
| Paymentamount | Double | Amount of the payment. |
| Documentnumber | String | Number of the document associated with the payment. |
| Memo | String | Memo or notes associated with the payment. |
| Paymenttype | String | Type of the payment (e.g., check, transfer). |
| Financialaccount | String | Financial account associated with the payment. |
| Customername | String | Name of the customer associated with the payment. |
| Customerid | String | Customer ID associated with the payment. |
| Batchtitle | String | Title of the payment batch. |
| Postingdate | Datetime | Date the payment was posted. |
| Megaentitykey | Int64 | Key for the associated mega entity. |
| Megaentityid | String | ID for the associated mega entity. |
| Record_url | String | URL to view the AR payment record. |