APPayment
Captures information on payments made in the accounts payable module, including vendor details and amounts.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the accounts payable payment record. |
| Prbatchkey | Int64 | The batch key associated with this payment record. |
| Recordtype | String | The type of record associated with this accounts payable payment. |
| Description | String | A description of the accounts payable payment. |
| Totalentered | Double | The total payment amount entered for this record. |
| Totalpaid | Double | The total payment amount paid for this record. |
| Totalselected | Double | The total payment amount selected for this record. |
| Totaldue | Double | The total payment amount still due for this record. |
| State | String | The current state or status of the payment record. |
| Whencreated | Datetime | The timestamp indicating when the payment record was created. |
| Whenpaid | Datetime | The date on which the payment was made. |
| Termkey | Int64 | The key representing the payment terms associated with this record. |
| Termname | String | The name of the payment terms associated with this record. |
| Whendiscount | Datetime | The date when any applicable discount was applied to the payment. |
| Recordid | String | A unique identifier for the payment record. |
| Userkey | Int64 | The key identifying the user responsible for this payment. |
| Whendue | Datetime | The due date for the payment. |
| Docnumber | String | The document number associated with the payment. |
| Cleared | String | Indicates whether the payment has been cleared. |
| Clrdate | Datetime | The date on which the payment was cleared. |
| Modulekey | String | The module key associated with this payment record. |
| Status | String | The status of the payment record, such as completed or pending. |
| Systemgenerated | String | Indicates whether the payment record was system-generated. |
| Whenposted | Datetime | The date on which the payment was posted. |
| Onhold | Boolean | Indicates whether the payment is currently on hold. |
| Currency | String | The currency used for this payment. |
| Trx_totalentered | Double | The total transaction amount entered for this payment record. |
| Trx_totalpaid | Double | The total transaction amount paid for this payment record. |
| Trx_totalselected | Double | The total transaction amount selected for payment in this record. |
| Trx_totaldue | Double | The total transaction amount still due for this payment record. |
| Deliverymethod | String | The method of delivery used for this payment, such as electronic or manual. |
| Recon_date | Datetime | The date on which the payment was reconciled. |
| Basecurr | String | The base currency for this payment. |
| Locationkey | Int64 | The key identifying the location associated with this payment. |
| Auwhencreated | Datetime | The timestamp indicating when the payment record was initially created in the audit trail. |
| Whenmodified | Datetime | The timestamp indicating the last modification of the payment record. |
| Createdby | Int64 | The identifier of the user or process that created this payment record. |
| Modifiedby | Int64 | The identifier of the user or process that last modified this payment record. |
| Nr_totalentered | Double | The total non-reconciled amount entered for this payment. |
| Nr_trx_totalentered | Double | The total non-reconciled transaction amount entered for this payment. |
| Paymenttype | String | The type of payment, such as check, ACH, or wire transfer. |
| Paymentdate | Datetime | The date on which the payment was processed. |
| Receiptdate | Datetime | The date on which the payment receipt was recorded. |
| Paymentamount | Double | The amount of the payment made. |
| Documentnumber | String | The document number associated with the payment. |
| Memo | String | A memo or note associated with this payment. |
| Financialaccount | String | The financial account used for this payment. |
| Vendorname | String | The name of the vendor receiving this payment. |
| Vendorid | String | The identifier of the vendor receiving this payment. |
| Megaentitykey | Int64 | The unique key representing the associated mega entity. |
| Megaentityid | String | The identifier of the mega entity associated with this payment. |
| Record_url | String | The URL linking to the detailed record of the payment. |