JDBC Driver for Sage Intacct

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462