APPayment
Retrieves APPayment report data.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | The Recordno field of the APPayment object. |
| Prbatchkey | Int64 | The Prbatchkey field of the APPayment object. |
| Recordtype | String | The Recordtype field of the APPayment object. |
| Description | String | The Description field of the APPayment object. |
| Totalentered | Double | The Totalentered field of the APPayment object. |
| Totalpaid | Double | The Totalpaid field of the APPayment object. |
| Totalselected | Double | The Totalselected field of the APPayment object. |
| Totaldue | Double | The Totaldue field of the APPayment object. |
| State | String | The State field of the APPayment object. |
| Whencreated | Datetime | The Whencreated field of the APPayment object. |
| Whenpaid | Datetime | The Whenpaid field of the APPayment object. |
| Termkey | Int64 | The Termkey field of the APPayment object. |
| Termname | String | The Termname field of the APPayment object. |
| Whendiscount | Datetime | The Whendiscount field of the APPayment object. |
| Recordid | String | The Recordid field of the APPayment object. |
| Userkey | Int64 | The Userkey field of the APPayment object. |
| Whendue | Datetime | The Whendue field of the APPayment object. |
| Docnumber | String | The Docnumber field of the APPayment object. |
| Cleared | String | The Cleared field of the APPayment object. |
| Clrdate | Datetime | The Clrdate field of the APPayment object. |
| Modulekey | String | The Modulekey field of the APPayment object. |
| Status | String | The Status field of the APPayment object. |
| Systemgenerated | String | The Systemgenerated field of the APPayment object. |
| Whenposted | Datetime | The Whenposted field of the APPayment object. |
| Onhold | Boolean | The Onhold field of the APPayment object. |
| Currency | String | The Currency field of the APPayment object. |
| Trx_totalentered | Double | The Trx_totalentered field of the APPayment object. |
| Trx_totalpaid | Double | The Trx_totalpaid field of the APPayment object. |
| Trx_totalselected | Double | The Trx_totalselected field of the APPayment object. |
| Trx_totaldue | Double | The Trx_totaldue field of the APPayment object. |
| Deliverymethod | String | The Deliverymethod field of the APPayment object. |
| Recon_date | Datetime | The Recon_date field of the APPayment object. |
| Basecurr | String | The Basecurr field of the APPayment object. |
| Locationkey | Int64 | The Locationkey field of the APPayment object. |
| Auwhencreated | Datetime | The Auwhencreated field of the APPayment object. |
| Whenmodified | Datetime | The Whenmodified field of the APPayment object. |
| Createdby | Int64 | The Createdby field of the APPayment object. |
| Modifiedby | Int64 | The Modifiedby field of the APPayment object. |
| Nr_totalentered | Double | The Nr_totalentered field of the APPayment object. |
| Nr_trx_totalentered | Double | The Nr_trx_totalentered field of the APPayment object. |
| Paymenttype | String | The Paymenttype field of the APPayment object. |
| Paymentdate | Datetime | The Paymentdate field of the APPayment object. |
| Receiptdate | Datetime | The Receiptdate field of the APPayment object. |
| Paymentamount | Double | The Paymentamount field of the APPayment object. |
| Documentnumber | String | The Documentnumber field of the APPayment object. |
| Memo | String | The Memo field of the APPayment object. |
| Financialaccount | String | The Financialaccount field of the APPayment object. |
| Vendorname | String | The Vendorname field of the APPayment object. |
| Vendorid | String | The Vendorid field of the APPayment object. |
| Megaentitykey | Int64 | The Megaentitykey field of the APPayment object. |
| Megaentityid | String | The Megaentityid field of the APPayment object. |
| Record_url | String | The Record_url field of the APPayment object. |