JDBC Driver for Sage Intacct

Build 22.0.8462

Vendor

Retrieves Vendor report data.

Columns

Name Type ReadOnly Description
Recordno Int64 False

The Recordno field of the Vendor object.

Vendorid [KEY] String False

The Vendorid field of the Vendor object.

Name String False

The Name field of the Vendor object.

Name1099 String False

The Name1099 field of the Vendor object.

Parentkey String False

The Parentkey field of the Vendor object.

Parentid String False

The Parentid field of the Vendor object.

Parentname String False

The Parentname field of the Vendor object.

Displaycontact_contactname String False

The Displaycontact_contactname field of the Vendor object.

Displaycontact_companyname String False

The Displaycontact_companyname field of the Vendor object.

Displaycontact_prefix String False

The Displaycontact_prefix field of the Vendor object.

Displaycontact_firstname String False

The Displaycontact_firstname field of the Vendor object.

Displaycontact_lastname String False

The Displaycontact_lastname field of the Vendor object.

Displaycontact_initial String False

The Displaycontact_initial field of the Vendor object.

Displaycontact_printas String False

The Displaycontact_printas field of the Vendor object.

Displaycontact_taxable Boolean False

The Displaycontact_taxable field of the Vendor object.

Displaycontact_taxgroup String False

The Displaycontact_taxgroup field of the Vendor object.

Displaycontact_phone1 String False

The Displaycontact_phone1 field of the Vendor object.

Displaycontact_phone2 String False

The Displaycontact_phone2 field of the Vendor object.

Displaycontact_cellphone String False

The Displaycontact_cellphone field of the Vendor object.

Displaycontact_pager String False

The Displaycontact_pager field of the Vendor object.

Displaycontact_fax String False

The Displaycontact_fax field of the Vendor object.

Displaycontact_email1 String False

The Displaycontact_email1 field of the Vendor object.

Displaycontact_email2 String False

The Displaycontact_email2 field of the Vendor object.

Displaycontact_url1 String False

The Displaycontact_url1 field of the Vendor object.

Displaycontact_url2 String False

The Displaycontact_url2 field of the Vendor object.

Displaycontact_visible Boolean False

The Displaycontact_visible field of the Vendor object.

Displaycontact_mailaddress_address1 String False

The Displaycontact_mailaddress_address1 field of the Vendor object.

Displaycontact_mailaddress_address2 String False

The Displaycontact_mailaddress_address2 field of the Vendor object.

Displaycontact_mailaddress_city String False

The Displaycontact_mailaddress_city field of the Vendor object.

Displaycontact_mailaddress_state String False

The Displaycontact_mailaddress_state field of the Vendor object.

Displaycontact_mailaddress_zip String False

The Displaycontact_mailaddress_zip field of the Vendor object.

Displaycontact_mailaddress_country String False

The Displaycontact_mailaddress_country field of the Vendor object.

Displaycontact_mailaddress_countrycode String False

The Displaycontact_mailaddress_countrycode field of the Vendor object.

Displaycontact_status String False

The Displaycontact_status field of the Vendor object.

Entity String False

The Entity field of the Vendor object.

Termname String False

The Termname field of the Vendor object.

Termvalue String False

The Termvalue field of the Vendor object.

Vendoraccountno String False

The Vendoraccountno field of the Vendor object.

Taxid String False

The Taxid field of the Vendor object.

Creditlimit Double False

The Creditlimit field of the Vendor object.

Totaldue Double False

The Totaldue field of the Vendor object.

Billingtype String False

The Billingtype field of the Vendor object.

Vendtype String False

The Vendtype field of the Vendor object.

Vendtype1099type String False

The Vendtype1099type field of the Vendor object.

Glgroup String False

The Glgroup field of the Vendor object.

Priceschedule String False

The Priceschedule field of the Vendor object.

Discount Double False

The Discount field of the Vendor object.

Pricelist String False

The Pricelist field of the Vendor object.

Comments String False

The Comments field of the Vendor object.

Accountlabel String False

The Accountlabel field of the Vendor object.

Apaccount String False

The Apaccount field of the Vendor object.

Apaccounttitle String False

The Apaccounttitle field of the Vendor object.

Form1099type String False

The Form1099type field of the Vendor object.

Form1099box String False

The Form1099box field of the Vendor object.

Paymentpriority String False

The Paymentpriority field of the Vendor object.

Contactinfo_contactname String False

The Contactinfo_contactname field of the Vendor object.

Contactinfo_prefix String False

The Contactinfo_prefix field of the Vendor object.

Contactinfo_firstname String False

The Contactinfo_firstname field of the Vendor object.

Contactinfo_initial String False

The Contactinfo_initial field of the Vendor object.

Contactinfo_lastname String False

The Contactinfo_lastname field of the Vendor object.

Contactinfo_companyname String False

The Contactinfo_companyname field of the Vendor object.

Contactinfo_printas String False

The Contactinfo_printas field of the Vendor object.

Contactinfo_phone1 String False

The Contactinfo_phone1 field of the Vendor object.

Contactinfo_phone2 String False

The Contactinfo_phone2 field of the Vendor object.

Contactinfo_cellphone String False

The Contactinfo_cellphone field of the Vendor object.

Contactinfo_pager String False

The Contactinfo_pager field of the Vendor object.

Contactinfo_fax String False

The Contactinfo_fax field of the Vendor object.

Contactinfo_email1 String False

The Contactinfo_email1 field of the Vendor object.

Contactinfo_email2 String False

The Contactinfo_email2 field of the Vendor object.

Contactinfo_url1 String False

The Contactinfo_url1 field of the Vendor object.

Contactinfo_url2 String False

The Contactinfo_url2 field of the Vendor object.

Contactinfo_visible Boolean False

The Contactinfo_visible field of the Vendor object.

Contactinfo_mailaddress_address1 String False

The Contactinfo_mailaddress_address1 field of the Vendor object.

Contactinfo_mailaddress_address2 String False

The Contactinfo_mailaddress_address2 field of the Vendor object.

Contactinfo_mailaddress_city String False

The Contactinfo_mailaddress_city field of the Vendor object.

Contactinfo_mailaddress_state String False

The Contactinfo_mailaddress_state field of the Vendor object.

Contactinfo_mailaddress_zip String False

The Contactinfo_mailaddress_zip field of the Vendor object.

Contactinfo_mailaddress_country String False

The Contactinfo_mailaddress_country field of the Vendor object.

Contactinfo_mailaddress_countrycode String False

The Contactinfo_mailaddress_countrycode field of the Vendor object.

Payto_contactname String False

The Payto_contactname field of the Vendor object.

Payto_prefix String False

The Payto_prefix field of the Vendor object.

Payto_firstname String False

The Payto_firstname field of the Vendor object.

Payto_initial String False

The Payto_initial field of the Vendor object.

Payto_lastname String False

The Payto_lastname field of the Vendor object.

Payto_companyname String False

The Payto_companyname field of the Vendor object.

Payto_printas String False

The Payto_printas field of the Vendor object.

Payto_phone1 String False

The Payto_phone1 field of the Vendor object.

Payto_phone2 String False

The Payto_phone2 field of the Vendor object.

Payto_cellphone String False

The Payto_cellphone field of the Vendor object.

Payto_pager String False

The Payto_pager field of the Vendor object.

Payto_fax String False

The Payto_fax field of the Vendor object.

Payto_email1 String False

The Payto_email1 field of the Vendor object.

Payto_email2 String False

The Payto_email2 field of the Vendor object.

Payto_url1 String False

The Payto_url1 field of the Vendor object.

Payto_url2 String False

The Payto_url2 field of the Vendor object.

Payto_visible Boolean False

The Payto_visible field of the Vendor object.

Payto_mailaddress_address1 String False

The Payto_mailaddress_address1 field of the Vendor object.

Payto_mailaddress_address2 String False

The Payto_mailaddress_address2 field of the Vendor object.

Payto_mailaddress_city String False

The Payto_mailaddress_city field of the Vendor object.

Payto_mailaddress_state String False

The Payto_mailaddress_state field of the Vendor object.

Payto_mailaddress_zip String False

The Payto_mailaddress_zip field of the Vendor object.

Payto_mailaddress_country String False

The Payto_mailaddress_country field of the Vendor object.

Payto_mailaddress_countrycode String False

The Payto_mailaddress_countrycode field of the Vendor object.

Returnto_contactname String False

The Returnto_contactname field of the Vendor object.

Returnto_prefix String False

The Returnto_prefix field of the Vendor object.

Returnto_firstname String False

The Returnto_firstname field of the Vendor object.

Returnto_initial String False

The Returnto_initial field of the Vendor object.

Returnto_lastname String False

The Returnto_lastname field of the Vendor object.

Returnto_companyname String False

The Returnto_companyname field of the Vendor object.

Returnto_printas String False

The Returnto_printas field of the Vendor object.

Returnto_phone1 String False

The Returnto_phone1 field of the Vendor object.

Returnto_phone2 String False

The Returnto_phone2 field of the Vendor object.

Returnto_cellphone String False

The Returnto_cellphone field of the Vendor object.

Returnto_pager String False

The Returnto_pager field of the Vendor object.

Returnto_fax String False

The Returnto_fax field of the Vendor object.

Returnto_email1 String False

The Returnto_email1 field of the Vendor object.

Returnto_email2 String False

The Returnto_email2 field of the Vendor object.

Returnto_url1 String False

The Returnto_url1 field of the Vendor object.

Returnto_url2 String False

The Returnto_url2 field of the Vendor object.

Returnto_visible Boolean False

The Returnto_visible field of the Vendor object.

Returnto_mailaddress_address1 String False

The Returnto_mailaddress_address1 field of the Vendor object.

Returnto_mailaddress_address2 String False

The Returnto_mailaddress_address2 field of the Vendor object.

Returnto_mailaddress_city String False

The Returnto_mailaddress_city field of the Vendor object.

Returnto_mailaddress_state String False

The Returnto_mailaddress_state field of the Vendor object.

Returnto_mailaddress_zip String False

The Returnto_mailaddress_zip field of the Vendor object.

Returnto_mailaddress_country String False

The Returnto_mailaddress_country field of the Vendor object.

Returnto_mailaddress_countrycode String False

The Returnto_mailaddress_countrycode field of the Vendor object.

Status String False

The Status field of the Vendor object.

Paydatevalue String False

The Paydatevalue field of the Vendor object.

Onetime Boolean False

The Onetime field of the Vendor object.

Onhold Boolean False

The Onhold field of the Vendor object.

Whenmodified Datetime False

The Whenmodified field of the Vendor object.

Isowner Boolean False

The Isowner field of the Vendor object.

Donotcutcheck Boolean False

The Donotcutcheck field of the Vendor object.

Owner_eqglaccount String False

The Owner_eqglaccount field of the Vendor object.

Owner_eqglaccountlabel String False

The Owner_eqglaccountlabel field of the Vendor object.

Owner_holddist Boolean False

The Owner_holddist field of the Vendor object.

Owner_accountlabel_label String False

The Owner_accountlabel_label field of the Vendor object.

Currency String False

The Currency field of the Vendor object.

Achenabled Boolean False

The Achenabled field of the Vendor object.

Wireenabled Boolean False

The Wireenabled field of the Vendor object.

Checkenabled Boolean False

The Checkenabled field of the Vendor object.

Achbankroutingnumber String False

The Achbankroutingnumber field of the Vendor object.

Achaccounttype String False

The Achaccounttype field of the Vendor object.

Achremittancetype String False

The Achremittancetype field of the Vendor object.

Wirebankname String False

The Wirebankname field of the Vendor object.

Wirebankroutingnumber String False

The Wirebankroutingnumber field of the Vendor object.

Wireaccounttype String False

The Wireaccounttype field of the Vendor object.

Pmplusremittancetype String False

The Pmplusremittancetype field of the Vendor object.

Pmplusemail String False

The Pmplusemail field of the Vendor object.

Pmplusfax String False

The Pmplusfax field of the Vendor object.

Displaytermdiscount Boolean False

The Displaytermdiscount field of the Vendor object.

Oeprclstkey Int64 False

The Oeprclstkey field of the Vendor object.

Displocacctnocheck Boolean False

The Displocacctnocheck field of the Vendor object.

Whencreated Datetime False

The Whencreated field of the Vendor object.

Createdby Int64 False

The Createdby field of the Vendor object.

Modifiedby Int64 False

The Modifiedby field of the Vendor object.

Paymentnotify Boolean False

The Paymentnotify field of the Vendor object.

Paymethodkey String False

The Paymethodkey field of the Vendor object.

Objectrestriction String False

The Objectrestriction field of the Vendor object.

Mergepaymentreq Boolean False

The Mergepaymentreq field of the Vendor object.

Displaycontactkey Int64 False

The Displaycontactkey field of the Vendor object.

Primarycontactkey Int64 False

The Primarycontactkey field of the Vendor object.

Paytokey Int64 False

The Paytokey field of the Vendor object.

Returntokey Int64 False

The Returntokey field of the Vendor object.

Accountlabelkey Int64 False

The Accountlabelkey field of the Vendor object.

Accountkey Int64 False

The Accountkey field of the Vendor object.

Vendtypekey Int64 False

The Vendtypekey field of the Vendor object.

Glgrpkey Int64 False

The Glgrpkey field of the Vendor object.

Termskey Int64 False

The Termskey field of the Vendor object.

Vendoracctnokey Int64 False

The Vendoracctnokey field of the Vendor object.

Paymethodrec Int64 False

The Paymethodrec field of the Vendor object.

Outsourcecheck Boolean False

The Outsourcecheck field of the Vendor object.

Outsourcecheckstate String False

The Outsourcecheckstate field of the Vendor object.

Outsourceach Boolean False

The Outsourceach field of the Vendor object.

Outsourceachstate String False

The Outsourceachstate field of the Vendor object.

Vendorachaccountid String False

The Vendorachaccountid field of the Vendor object.

Vendoraccountoutsourceach String False

The Vendoraccountoutsourceach field of the Vendor object.

Offsetglaccountno String False

The Offsetglaccountno field of the Vendor object.

Offsetglaccountnotitle String False

The Offsetglaccountnotitle field of the Vendor object.

Megaentitykey Int64 False

The Megaentitykey field of the Vendor object.

Megaentityid String False

The Megaentityid field of the Vendor object.

Megaentityname String False

The Megaentityname field of the Vendor object.

Record_url String False

The Record_url field of the Vendor object.

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