ARInvoice
Retrieves ARInvoice report data.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
The Recordno field of the ARInvoice object. |
| Recordtype | String | False |
The Recordtype field of the ARInvoice object. |
| Recordid | String | False |
The Recordid field of the ARInvoice object. |
| State | String | False |
The State field of the ARInvoice object. |
| Rawstate | String | False |
The Rawstate field of the ARInvoice object. |
| Entity | String | False |
The Entity field of the ARInvoice object. |
| Custentity | String | False |
The Custentity field of the ARInvoice object. |
| Customerid | String | False |
The Customerid field of the ARInvoice object. |
| Customername | String | False |
The Customername field of the ARInvoice object. |
| Trx_entitydue | Double | False |
The Trx_entitydue field of the ARInvoice object. |
| Custmessageid | String | False |
The Custmessageid field of the ARInvoice object. |
| Delivery_options | String | False |
The Delivery_options field of the ARInvoice object. |
| Docnumber | String | False |
The Docnumber field of the ARInvoice object. |
| Description | String | False |
The Description field of the ARInvoice object. |
| Description2 | String | False |
The Description2 field of the ARInvoice object. |
| Termname | String | False |
The Termname field of the ARInvoice object. |
| Termkey | Int64 | False |
The Termkey field of the ARInvoice object. |
| Whencreated | Datetime | False |
The Whencreated field of the ARInvoice object. |
| Whenposted | Datetime | False |
The Whenposted field of the ARInvoice object. |
| Whendiscount | Datetime | False |
The Whendiscount field of the ARInvoice object. |
| Whendue | Datetime | False |
The Whendue field of the ARInvoice object. |
| Whenpaid | Datetime | False |
The Whenpaid field of the ARInvoice object. |
| Basecurr | String | False |
The Basecurr field of the ARInvoice object. |
| Currency | String | False |
The Currency field of the ARInvoice object. |
| Exch_rate_date | Datetime | False |
The Exch_rate_date field of the ARInvoice object. |
| Exch_rate_type_id | Int64 | False |
The Exch_rate_type_id field of the ARInvoice object. |
| Exchange_rate | Double | False |
The Exchange_rate field of the ARInvoice object. |
| Totalentered | Double | False |
The Totalentered field of the ARInvoice object. |
| Totalselected | Double | False |
The Totalselected field of the ARInvoice object. |
| Totalpaid | Double | False |
The Totalpaid field of the ARInvoice object. |
| Totaldue | Double | False |
The Totaldue field of the ARInvoice object. |
| Trx_totalentered | Double | False |
The Trx_totalentered field of the ARInvoice object. |
| Trx_totalselected | Double | False |
The Trx_totalselected field of the ARInvoice object. |
| Trx_totalpaid | Double | False |
The Trx_totalpaid field of the ARInvoice object. |
| Trx_totaldue | Double | False |
The Trx_totaldue field of the ARInvoice object. |
| Billtopaytocontactname | String | False |
The Billtopaytocontactname field of the ARInvoice object. |
| Shiptoreturntocontactname | String | False |
The Shiptoreturntocontactname field of the ARInvoice object. |
| Billtopaytokey | Int64 | False |
The Billtopaytokey field of the ARInvoice object. |
| Shiptoreturntokey | Int64 | False |
The Shiptoreturntokey field of the ARInvoice object. |
| Contact_contactname | String | False |
The Contact_contactname field of the ARInvoice object. |
| Contact_prefix | String | False |
The Contact_prefix field of the ARInvoice object. |
| Contact_firstname | String | False |
The Contact_firstname field of the ARInvoice object. |
| Contact_initial | String | False |
The Contact_initial field of the ARInvoice object. |
| Contact_lastname | String | False |
The Contact_lastname field of the ARInvoice object. |
| Contact_companyname | String | False |
The Contact_companyname field of the ARInvoice object. |
| Contact_printas | String | False |
The Contact_printas field of the ARInvoice object. |
| Contact_phone1 | String | False |
The Contact_phone1 field of the ARInvoice object. |
| Contact_phone2 | String | False |
The Contact_phone2 field of the ARInvoice object. |
| Contact_cellphone | String | False |
The Contact_cellphone field of the ARInvoice object. |
| Contact_pager | String | False |
The Contact_pager field of the ARInvoice object. |
| Contact_fax | String | False |
The Contact_fax field of the ARInvoice object. |
| Contact_email1 | String | False |
The Contact_email1 field of the ARInvoice object. |
| Contact_email2 | String | False |
The Contact_email2 field of the ARInvoice object. |
| Contact_url1 | String | False |
The Contact_url1 field of the ARInvoice object. |
| Contact_url2 | String | False |
The Contact_url2 field of the ARInvoice object. |
| Contact_visible | Boolean | False |
The Contact_visible field of the ARInvoice object. |
| Contact_mailaddress_address1 | String | False |
The Contact_mailaddress_address1 field of the ARInvoice object. |
| Contact_mailaddress_address2 | String | False |
The Contact_mailaddress_address2 field of the ARInvoice object. |
| Contact_mailaddress_city | String | False |
The Contact_mailaddress_city field of the ARInvoice object. |
| Contact_mailaddress_state | String | False |
The Contact_mailaddress_state field of the ARInvoice object. |
| Contact_mailaddress_zip | String | False |
The Contact_mailaddress_zip field of the ARInvoice object. |
| Contact_mailaddress_country | String | False |
The Contact_mailaddress_country field of the ARInvoice object. |
| Contact_mailaddress_countrycode | String | False |
The Contact_mailaddress_countrycode field of the ARInvoice object. |
| Shipto_contactname | String | False |
The Shipto_contactname field of the ARInvoice object. |
| Shipto_prefix | String | False |
The Shipto_prefix field of the ARInvoice object. |
| Shipto_firstname | String | False |
The Shipto_firstname field of the ARInvoice object. |
| Shipto_initial | String | False |
The Shipto_initial field of the ARInvoice object. |
| Shipto_lastname | String | False |
The Shipto_lastname field of the ARInvoice object. |
| Shipto_companyname | String | False |
The Shipto_companyname field of the ARInvoice object. |
| Shipto_printas | String | False |
The Shipto_printas field of the ARInvoice object. |
| Shipto_phone1 | String | False |
The Shipto_phone1 field of the ARInvoice object. |
| Shipto_phone2 | String | False |
The Shipto_phone2 field of the ARInvoice object. |
| Shipto_cellphone | String | False |
The Shipto_cellphone field of the ARInvoice object. |
| Shipto_pager | String | False |
The Shipto_pager field of the ARInvoice object. |
| Shipto_fax | String | False |
The Shipto_fax field of the ARInvoice object. |
| Shipto_email1 | String | False |
The Shipto_email1 field of the ARInvoice object. |
| Shipto_email2 | String | False |
The Shipto_email2 field of the ARInvoice object. |
| Shipto_url1 | String | False |
The Shipto_url1 field of the ARInvoice object. |
| Shipto_url2 | String | False |
The Shipto_url2 field of the ARInvoice object. |
| Shipto_visible | Boolean | False |
The Shipto_visible field of the ARInvoice object. |
| Shipto_mailaddress_address1 | String | False |
The Shipto_mailaddress_address1 field of the ARInvoice object. |
| Shipto_mailaddress_address2 | String | False |
The Shipto_mailaddress_address2 field of the ARInvoice object. |
| Shipto_mailaddress_city | String | False |
The Shipto_mailaddress_city field of the ARInvoice object. |
| Shipto_mailaddress_state | String | False |
The Shipto_mailaddress_state field of the ARInvoice object. |
| Shipto_mailaddress_zip | String | False |
The Shipto_mailaddress_zip field of the ARInvoice object. |
| Shipto_mailaddress_country | String | False |
The Shipto_mailaddress_country field of the ARInvoice object. |
| Shipto_mailaddress_countrycode | String | False |
The Shipto_mailaddress_countrycode field of the ARInvoice object. |
| Billto_contactname | String | False |
The Billto_contactname field of the ARInvoice object. |
| Billto_prefix | String | False |
The Billto_prefix field of the ARInvoice object. |
| Billto_firstname | String | False |
The Billto_firstname field of the ARInvoice object. |
| Billto_initial | String | False |
The Billto_initial field of the ARInvoice object. |
| Billto_lastname | String | False |
The Billto_lastname field of the ARInvoice object. |
| Billto_companyname | String | False |
The Billto_companyname field of the ARInvoice object. |
| Billto_printas | String | False |
The Billto_printas field of the ARInvoice object. |
| Billto_phone1 | String | False |
The Billto_phone1 field of the ARInvoice object. |
| Billto_phone2 | String | False |
The Billto_phone2 field of the ARInvoice object. |
| Billto_cellphone | String | False |
The Billto_cellphone field of the ARInvoice object. |
| Billto_pager | String | False |
The Billto_pager field of the ARInvoice object. |
| Billto_fax | String | False |
The Billto_fax field of the ARInvoice object. |
| Billto_email1 | String | False |
The Billto_email1 field of the ARInvoice object. |
| Billto_email2 | String | False |
The Billto_email2 field of the ARInvoice object. |
| Billto_url1 | String | False |
The Billto_url1 field of the ARInvoice object. |
| Billto_url2 | String | False |
The Billto_url2 field of the ARInvoice object. |
| Billto_mailaddress_address1 | String | False |
The Billto_mailaddress_address1 field of the ARInvoice object. |
| Billto_mailaddress_address2 | String | False |
The Billto_mailaddress_address2 field of the ARInvoice object. |
| Billto_mailaddress_city | String | False |
The Billto_mailaddress_city field of the ARInvoice object. |
| Billto_mailaddress_state | String | False |
The Billto_mailaddress_state field of the ARInvoice object. |
| Billto_mailaddress_zip | String | False |
The Billto_mailaddress_zip field of the ARInvoice object. |
| Billto_mailaddress_country | String | False |
The Billto_mailaddress_country field of the ARInvoice object. |
| Billto_mailaddress_countrycode | String | False |
The Billto_mailaddress_countrycode field of the ARInvoice object. |
| Prbatch | String | False |
The Prbatch field of the ARInvoice object. |
| Prbatchkey | Int64 | False |
The Prbatchkey field of the ARInvoice object. |
| Modulekey | String | False |
The Modulekey field of the ARInvoice object. |
| Schopkey | Int64 | False |
The Schopkey field of the ARInvoice object. |
| Systemgenerated | String | False |
The Systemgenerated field of the ARInvoice object. |
| Haspostedrevrec | String | False |
The Haspostedrevrec field of the ARInvoice object. |
| Auwhencreated | Datetime | False |
The Auwhencreated field of the ARInvoice object. |
| Whenmodified | Datetime | False |
The Whenmodified field of the ARInvoice object. |
| Createdby | Int64 | False |
The Createdby field of the ARInvoice object. |
| Modifiedby | Int64 | False |
The Modifiedby field of the ARInvoice object. |
| Megaentitykey | Int64 | False |
The Megaentitykey field of the ARInvoice object. |
| Megaentityid | String | False |
The Megaentityid field of the ARInvoice object. |
| Record_url | String | False |
The Record_url field of the ARInvoice object. |