Customer
Retrieves Customer report data.
Columns
| Name | Type | ReadOnly | Description |
| Recordno | Int64 | False |
The Recordno field of the Customer object. |
| Customerid [KEY] | String | False |
The Customerid field of the Customer object. |
| Name | String | False |
The Name field of the Customer object. |
| Entity | String | False |
The Entity field of the Customer object. |
| Parentkey | Int64 | False |
The Parentkey field of the Customer object. |
| Parentid | String | False |
The Parentid field of the Customer object. |
| Parentname | String | False |
The Parentname field of the Customer object. |
| Displaycontact_contactname | String | False |
The Displaycontact_contactname field of the Customer object. |
| Displaycontact_companyname | String | False |
The Displaycontact_companyname field of the Customer object. |
| Displaycontact_prefix | String | False |
The Displaycontact_prefix field of the Customer object. |
| Displaycontact_firstname | String | False |
The Displaycontact_firstname field of the Customer object. |
| Displaycontact_lastname | String | False |
The Displaycontact_lastname field of the Customer object. |
| Displaycontact_initial | String | False |
The Displaycontact_initial field of the Customer object. |
| Displaycontact_printas | String | False |
The Displaycontact_printas field of the Customer object. |
| Displaycontact_taxable | Boolean | False |
The Displaycontact_taxable field of the Customer object. |
| Displaycontact_taxgroup | String | False |
The Displaycontact_taxgroup field of the Customer object. |
| Displaycontact_phone1 | String | False |
The Displaycontact_phone1 field of the Customer object. |
| Displaycontact_phone2 | String | False |
The Displaycontact_phone2 field of the Customer object. |
| Displaycontact_cellphone | String | False |
The Displaycontact_cellphone field of the Customer object. |
| Displaycontact_pager | String | False |
The Displaycontact_pager field of the Customer object. |
| Displaycontact_fax | String | False |
The Displaycontact_fax field of the Customer object. |
| Displaycontact_email1 | String | False |
The Displaycontact_email1 field of the Customer object. |
| Displaycontact_email2 | String | False |
The Displaycontact_email2 field of the Customer object. |
| Displaycontact_url1 | String | False |
The Displaycontact_url1 field of the Customer object. |
| Displaycontact_url2 | String | False |
The Displaycontact_url2 field of the Customer object. |
| Displaycontact_visible | Boolean | False |
The Displaycontact_visible field of the Customer object. |
| Displaycontact_mailaddress_address1 | String | False |
The Displaycontact_mailaddress_address1 field of the Customer object. |
| Displaycontact_mailaddress_address2 | String | False |
The Displaycontact_mailaddress_address2 field of the Customer object. |
| Displaycontact_mailaddress_city | String | False |
The Displaycontact_mailaddress_city field of the Customer object. |
| Displaycontact_mailaddress_state | String | False |
The Displaycontact_mailaddress_state field of the Customer object. |
| Displaycontact_mailaddress_zip | String | False |
The Displaycontact_mailaddress_zip field of the Customer object. |
| Displaycontact_mailaddress_country | String | False |
The Displaycontact_mailaddress_country field of the Customer object. |
| Displaycontact_mailaddress_countrycode | String | False |
The Displaycontact_mailaddress_countrycode field of the Customer object. |
| Displaycontact_status | String | False |
The Displaycontact_status field of the Customer object. |
| Termname | String | False |
The Termname field of the Customer object. |
| Termvalue | String | False |
The Termvalue field of the Customer object. |
| Custrepid | String | False |
The Custrepid field of the Customer object. |
| Custrepname | String | False |
The Custrepname field of the Customer object. |
| Resaleno | String | False |
The Resaleno field of the Customer object. |
| Taxid | String | False |
The Taxid field of the Customer object. |
| Creditlimit | Double | False |
The Creditlimit field of the Customer object. |
| Totaldue | Double | False |
The Totaldue field of the Customer object. |
| Comments | String | False |
The Comments field of the Customer object. |
| Accountlabel | String | False |
The Accountlabel field of the Customer object. |
| Araccount | String | False |
The Araccount field of the Customer object. |
| Araccounttitle | String | False |
The Araccounttitle field of the Customer object. |
| Last_invoicedate | String | False |
The Last_invoicedate field of the Customer object. |
| Last_statementdate | String | False |
The Last_statementdate field of the Customer object. |
| Delivery_options | String | False |
The Delivery_options field of the Customer object. |
| Territoryid | String | False |
The Territoryid field of the Customer object. |
| Shippingmethod | String | False |
The Shippingmethod field of the Customer object. |
| Custtype | String | False |
The Custtype field of the Customer object. |
| Glgroup | String | False |
The Glgroup field of the Customer object. |
| Priceschedule | String | False |
The Priceschedule field of the Customer object. |
| Discount | Double | False |
The Discount field of the Customer object. |
| Pricelist | String | False |
The Pricelist field of the Customer object. |
| Vsoepricelist | String | False |
The Vsoepricelist field of the Customer object. |
| Currency | String | False |
The Currency field of the Customer object. |
| Contactinfo_contactname | String | False |
The Contactinfo_contactname field of the Customer object. |
| Contactinfo_prefix | String | False |
The Contactinfo_prefix field of the Customer object. |
| Contactinfo_firstname | String | False |
The Contactinfo_firstname field of the Customer object. |
| Contactinfo_initial | String | False |
The Contactinfo_initial field of the Customer object. |
| Contactinfo_lastname | String | False |
The Contactinfo_lastname field of the Customer object. |
| Contactinfo_companyname | String | False |
The Contactinfo_companyname field of the Customer object. |
| Contactinfo_printas | String | False |
The Contactinfo_printas field of the Customer object. |
| Contactinfo_phone1 | String | False |
The Contactinfo_phone1 field of the Customer object. |
| Contactinfo_phone2 | String | False |
The Contactinfo_phone2 field of the Customer object. |
| Contactinfo_cellphone | String | False |
The Contactinfo_cellphone field of the Customer object. |
| Contactinfo_pager | String | False |
The Contactinfo_pager field of the Customer object. |
| Contactinfo_fax | String | False |
The Contactinfo_fax field of the Customer object. |
| Contactinfo_email1 | String | False |
The Contactinfo_email1 field of the Customer object. |
| Contactinfo_email2 | String | False |
The Contactinfo_email2 field of the Customer object. |
| Contactinfo_url1 | String | False |
The Contactinfo_url1 field of the Customer object. |
| Contactinfo_url2 | String | False |
The Contactinfo_url2 field of the Customer object. |
| Contactinfo_visible | Boolean | False |
The Contactinfo_visible field of the Customer object. |
| Contactinfo_mailaddress_address1 | String | False |
The Contactinfo_mailaddress_address1 field of the Customer object. |
| Contactinfo_mailaddress_address2 | String | False |
The Contactinfo_mailaddress_address2 field of the Customer object. |
| Contactinfo_mailaddress_city | String | False |
The Contactinfo_mailaddress_city field of the Customer object. |
| Contactinfo_mailaddress_state | String | False |
The Contactinfo_mailaddress_state field of the Customer object. |
| Contactinfo_mailaddress_zip | String | False |
The Contactinfo_mailaddress_zip field of the Customer object. |
| Contactinfo_mailaddress_country | String | False |
The Contactinfo_mailaddress_country field of the Customer object. |
| Contactinfo_mailaddress_countrycode | String | False |
The Contactinfo_mailaddress_countrycode field of the Customer object. |
| Shipto_contactname | String | False |
The Shipto_contactname field of the Customer object. |
| Shipto_prefix | String | False |
The Shipto_prefix field of the Customer object. |
| Shipto_firstname | String | False |
The Shipto_firstname field of the Customer object. |
| Shipto_initial | String | False |
The Shipto_initial field of the Customer object. |
| Shipto_lastname | String | False |
The Shipto_lastname field of the Customer object. |
| Shipto_companyname | String | False |
The Shipto_companyname field of the Customer object. |
| Shipto_printas | String | False |
The Shipto_printas field of the Customer object. |
| Shipto_taxable | Boolean | False |
The Shipto_taxable field of the Customer object. |
| Shipto_taxgroup | String | False |
The Shipto_taxgroup field of the Customer object. |
| Shipto_phone1 | String | False |
The Shipto_phone1 field of the Customer object. |
| Shipto_phone2 | String | False |
The Shipto_phone2 field of the Customer object. |
| Shipto_cellphone | String | False |
The Shipto_cellphone field of the Customer object. |
| Shipto_pager | String | False |
The Shipto_pager field of the Customer object. |
| Shipto_fax | String | False |
The Shipto_fax field of the Customer object. |
| Shipto_email1 | String | False |
The Shipto_email1 field of the Customer object. |
| Shipto_email2 | String | False |
The Shipto_email2 field of the Customer object. |
| Shipto_url1 | String | False |
The Shipto_url1 field of the Customer object. |
| Shipto_url2 | String | False |
The Shipto_url2 field of the Customer object. |
| Shipto_visible | Boolean | False |
The Shipto_visible field of the Customer object. |
| Shipto_mailaddress_address1 | String | False |
The Shipto_mailaddress_address1 field of the Customer object. |
| Shipto_mailaddress_address2 | String | False |
The Shipto_mailaddress_address2 field of the Customer object. |
| Shipto_mailaddress_city | String | False |
The Shipto_mailaddress_city field of the Customer object. |
| Shipto_mailaddress_state | String | False |
The Shipto_mailaddress_state field of the Customer object. |
| Shipto_mailaddress_zip | String | False |
The Shipto_mailaddress_zip field of the Customer object. |
| Shipto_mailaddress_country | String | False |
The Shipto_mailaddress_country field of the Customer object. |
| Shipto_mailaddress_countrycode | String | False |
The Shipto_mailaddress_countrycode field of the Customer object. |
| Billto_contactname | String | False |
The Billto_contactname field of the Customer object. |
| Billto_prefix | String | False |
The Billto_prefix field of the Customer object. |
| Billto_firstname | String | False |
The Billto_firstname field of the Customer object. |
| Billto_initial | String | False |
The Billto_initial field of the Customer object. |
| Billto_lastname | String | False |
The Billto_lastname field of the Customer object. |
| Billto_companyname | String | False |
The Billto_companyname field of the Customer object. |
| Billto_printas | String | False |
The Billto_printas field of the Customer object. |
| Billto_taxable | Boolean | False |
The Billto_taxable field of the Customer object. |
| Billto_taxgroup | String | False |
The Billto_taxgroup field of the Customer object. |
| Billto_phone1 | String | False |
The Billto_phone1 field of the Customer object. |
| Billto_phone2 | String | False |
The Billto_phone2 field of the Customer object. |
| Billto_cellphone | String | False |
The Billto_cellphone field of the Customer object. |
| Billto_pager | String | False |
The Billto_pager field of the Customer object. |
| Billto_fax | String | False |
The Billto_fax field of the Customer object. |
| Billto_email1 | String | False |
The Billto_email1 field of the Customer object. |
| Billto_email2 | String | False |
The Billto_email2 field of the Customer object. |
| Billto_url1 | String | False |
The Billto_url1 field of the Customer object. |
| Billto_url2 | String | False |
The Billto_url2 field of the Customer object. |
| Billto_visible | Boolean | False |
The Billto_visible field of the Customer object. |
| Billto_mailaddress_address1 | String | False |
The Billto_mailaddress_address1 field of the Customer object. |
| Billto_mailaddress_address2 | String | False |
The Billto_mailaddress_address2 field of the Customer object. |
| Billto_mailaddress_city | String | False |
The Billto_mailaddress_city field of the Customer object. |
| Billto_mailaddress_state | String | False |
The Billto_mailaddress_state field of the Customer object. |
| Billto_mailaddress_zip | String | False |
The Billto_mailaddress_zip field of the Customer object. |
| Billto_mailaddress_country | String | False |
The Billto_mailaddress_country field of the Customer object. |
| Billto_mailaddress_countrycode | String | False |
The Billto_mailaddress_countrycode field of the Customer object. |
| Status | String | False |
The Status field of the Customer object. |
| Onetime | Boolean | False |
The Onetime field of the Customer object. |
| Custmessageid | String | False |
The Custmessageid field of the Customer object. |
| Onhold | Boolean | False |
The Onhold field of the Customer object. |
| Prclst_override | String | False |
The Prclst_override field of the Customer object. |
| Oeprclstkey | Int64 | False |
The Oeprclstkey field of the Customer object. |
| Oepriceschedkey | Int64 | False |
The Oepriceschedkey field of the Customer object. |
| Enableonlinecardpayment | Boolean | False |
The Enableonlinecardpayment field of the Customer object. |
| Enableonlineachpayment | Boolean | False |
The Enableonlineachpayment field of the Customer object. |
| Vsoeprclstkey | Int64 | False |
The Vsoeprclstkey field of the Customer object. |
| Whenmodified | Datetime | False |
The Whenmodified field of the Customer object. |
| Arinvoiceprinttemplateid | String | False |
The Arinvoiceprinttemplateid field of the Customer object. |
| Oequoteprinttemplateid | String | False |
The Oequoteprinttemplateid field of the Customer object. |
| Oeorderprinttemplateid | String | False |
The Oeorderprinttemplateid field of the Customer object. |
| Oelistprinttemplateid | String | False |
The Oelistprinttemplateid field of the Customer object. |
| Oeinvoiceprinttemplateid | String | False |
The Oeinvoiceprinttemplateid field of the Customer object. |
| Oeadjprinttemplateid | String | False |
The Oeadjprinttemplateid field of the Customer object. |
| Oeotherprinttemplateid | String | False |
The Oeotherprinttemplateid field of the Customer object. |
| Whencreated | Datetime | False |
The Whencreated field of the Customer object. |
| Createdby | Int64 | False |
The Createdby field of the Customer object. |
| Modifiedby | Int64 | False |
The Modifiedby field of the Customer object. |
| Objectrestriction | String | False |
The Objectrestriction field of the Customer object. |
| Displaycontactkey | Int64 | False |
The Displaycontactkey field of the Customer object. |
| Contactkey | Int64 | False |
The Contactkey field of the Customer object. |
| Shiptokey | Int64 | False |
The Shiptokey field of the Customer object. |
| Billtokey | Int64 | False |
The Billtokey field of the Customer object. |
| Custrepkey | Int64 | False |
The Custrepkey field of the Customer object. |
| Shipviakey | Int64 | False |
The Shipviakey field of the Customer object. |
| Territorykey | String | False |
The Territorykey field of the Customer object. |
| Termskey | Int64 | False |
The Termskey field of the Customer object. |
| Accountlabelkey | Int64 | False |
The Accountlabelkey field of the Customer object. |
| Accountkey | Int64 | False |
The Accountkey field of the Customer object. |
| Custtypekey | Int64 | False |
The Custtypekey field of the Customer object. |
| Priceschedulekey | String | False |
The Priceschedulekey field of the Customer object. |
| Offsetglaccountno | String | False |
The Offsetglaccountno field of the Customer object. |
| Offsetglaccountnotitle | String | False |
The Offsetglaccountnotitle field of the Customer object. |
| Megaentitykey | Int64 | False |
The Megaentitykey field of the Customer object. |
| Megaentityid | String | False |
The Megaentityid field of the Customer object. |
| Megaentityname | String | False |
The Megaentityname field of the Customer object. |
| Record_url | String | False |
The Record_url field of the Customer object. |