APBill
Retrieves APBill report data.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
The Recordno field of the APBill object. |
| Recordtype | String | False |
The Recordtype field of the APBill object. |
| Recordid | String | False |
The Recordid field of the APBill object. |
| Financialentity | String | False |
The Financialentity field of the APBill object. |
| State | String | False |
The State field of the APBill object. |
| Rawstate | String | False |
The Rawstate field of the APBill object. |
| Entity | String | False |
The Entity field of the APBill object. |
| Vendorid | String | False |
The Vendorid field of the APBill object. |
| Vendorname | String | False |
The Vendorname field of the APBill object. |
| Form1099type | String | False |
The Form1099type field of the APBill object. |
| Vendtype1099type | String | False |
The Vendtype1099type field of the APBill object. |
| Trx_entitydue | Double | False |
The Trx_entitydue field of the APBill object. |
| Docnumber | String | False |
The Docnumber field of the APBill object. |
| Description | String | False |
The Description field of the APBill object. |
| Description2 | String | False |
The Description2 field of the APBill object. |
| Termname | String | False |
The Termname field of the APBill object. |
| Termkey | Int64 | False |
The Termkey field of the APBill object. |
| Whencreated | Datetime | False |
The Whencreated field of the APBill object. |
| Whenposted | Datetime | False |
The Whenposted field of the APBill object. |
| Whendiscount | Datetime | False |
The Whendiscount field of the APBill object. |
| Whendue | Datetime | False |
The Whendue field of the APBill object. |
| Whenpaid | Datetime | False |
The Whenpaid field of the APBill object. |
| Recpaymentdate | Datetime | False |
The Recpaymentdate field of the APBill object. |
| Paymentpriority | String | False |
The Paymentpriority field of the APBill object. |
| Onhold | Boolean | False |
The Onhold field of the APBill object. |
| Basecurr | String | False |
The Basecurr field of the APBill object. |
| Currency | String | False |
The Currency field of the APBill object. |
| Exch_rate_date | Datetime | False |
The Exch_rate_date field of the APBill object. |
| Exch_rate_type_id | Int64 | False |
The Exch_rate_type_id field of the APBill object. |
| Exchange_rate | Double | False |
The Exchange_rate field of the APBill object. |
| Totalentered | Double | False |
The Totalentered field of the APBill object. |
| Totalselected | Double | False |
The Totalselected field of the APBill object. |
| Totalpaid | Double | False |
The Totalpaid field of the APBill object. |
| Totaldue | String | False |
The Totaldue field of the APBill object. |
| Trx_totalentered | Double | False |
The Trx_totalentered field of the APBill object. |
| Trx_totalselected | Double | False |
The Trx_totalselected field of the APBill object. |
| Trx_totalpaid | Double | False |
The Trx_totalpaid field of the APBill object. |
| Trx_totaldue | Double | False |
The Trx_totaldue field of the APBill object. |
| Billtopaytocontactname | String | False |
The Billtopaytocontactname field of the APBill object. |
| Shiptoreturntocontactname | String | False |
The Shiptoreturntocontactname field of the APBill object. |
| Billtopaytokey | Int64 | False |
The Billtopaytokey field of the APBill object. |
| Shiptoreturntokey | Int64 | False |
The Shiptoreturntokey field of the APBill object. |
| Prbatch | String | False |
The Prbatch field of the APBill object. |
| Prbatchkey | Int64 | False |
The Prbatchkey field of the APBill object. |
| Modulekey | String | False |
The Modulekey field of the APBill object. |
| Schopkey | Int64 | False |
The Schopkey field of the APBill object. |
| Systemgenerated | String | False |
The Systemgenerated field of the APBill object. |
| Auwhencreated | Datetime | False |
The Auwhencreated field of the APBill object. |
| Whenmodified | Datetime | False |
The Whenmodified field of the APBill object. |
| Createdby | Int64 | False |
The Createdby field of the APBill object. |
| Modifiedby | Int64 | False |
The Modifiedby field of the APBill object. |
| Megaentitykey | Int64 | False |
The Megaentitykey field of the APBill object. |
| Megaentityid | String | False |
The Megaentityid field of the APBill object. |
| Record_url | String | False |
The Record_url field of the APBill object. |