Power BI Connector for Sage Intacct

Build 25.0.9454

Vendor

Holds vendor records, capturing addresses, payment terms, and financial settings for accounts payable processes.

Table Specific Info

Insert

Insert is only supported when UseLegacy=False. See the example query below: 

INSERT INTO Vendor (Vendorid, Name, Itemaggregate) VALUES ('1234', 'My Vendor', '<DISPLAYCONTACT><printas>My test vendor</printas></DISPLAYCONTACT>')

Note: INSERT operations are not supported with the Legacy API.

Columns

Name Type ReadOnly Description
Recordno Int64 False

The unique identifier for each vendor record.

Vendorid [KEY] String False

The unique identifier for the vendor in the system.

Name String False

The full name of the vendor.

Name1099 String False

The name of the vendor used for tax reporting purposes (Form 1099).

Parentkey String False

The identifier for the parent entity of the vendor, if applicable.

Parentid String False

The unique identifier of the parent company, if applicable.

Parentname String False

The name of the parent company, if applicable.

Displaycontact_contactname String False

The name of the primary contact for the vendor.

Displaycontact_companyname String False

The company name of the primary contact.

Displaycontact_prefix String False

The prefix (e.g., Mr., Ms.) for the primary contact's name.

Displaycontact_firstname String False

The first name of the primary contact.

Displaycontact_lastname String False

The last name of the primary contact.

Displaycontact_initial String False

The initials of the primary contact.

Displaycontact_printas String False

The name format for printing the vendor contact (e.g., First Last, Last, First).

Displaycontact_taxable Boolean False

Indicates whether the vendor's payments are taxable.

Displaycontact_taxgroup String False

The tax group to which the vendor belongs.

Displaycontact_phone1 String False

The primary phone number for the vendor contact.

Displaycontact_phone2 String False

An alternate phone number for the vendor contact.

Displaycontact_cellphone String False

The cell phone number for the vendor contact.

Displaycontact_pager String False

The pager number for the vendor contact.

Displaycontact_fax String False

The fax number for the vendor contact.

Displaycontact_email1 String False

The primary email address for the vendor contact.

Displaycontact_email2 String False

An alternate email address for the vendor contact.

Displaycontact_url1 String False

The first website URL associated with the vendor contact.

Displaycontact_url2 String False

An alternate website URL for the vendor contact.

Displaycontact_visible Boolean False

Indicates whether the vendor contact is visible in reports and listings.

Displaycontact_mailaddress_address1 String False

The first line of the vendor's mail address.

Displaycontact_mailaddress_address2 String False

The second line of the vendor's mail address.

Displaycontact_mailaddress_city String False

The city of the vendor's mail address.

Displaycontact_mailaddress_state String False

The state of the vendor's mail address.

Displaycontact_mailaddress_zip String False

The postal code of the vendor's mail address.

Displaycontact_mailaddress_country String False

The country of the vendor's mail address.

Displaycontact_mailaddress_countrycode String False

The country code of the vendor's mail address.

Displaycontact_status String False

The status of the vendor contact (e.g., active, inactive).

Entity String False

The associated entity or organization for the vendor.

Termname String False

The payment terms for the vendor.

Termvalue String False

The specific value of the vendor's payment terms.

Vendoraccountno String False

The account number for the vendor.

Taxid String False

The tax identification number for the vendor.

Creditlimit Double False

The credit limit associated with the vendor.

Totaldue Double False

The total amount due from the vendor.

Billingtype String False

The type of billing arrangement for the vendor.

Vendtype String False

The vendor type classification (e.g., regular, temporary).

Vendtype1099type String False

The vendor's 1099 form type classification.

Glgroup String False

The general ledger group associated with the vendor.

Priceschedule String False

The pricing schedule used for the vendor's products or services.

Discount Double False

The discount percentage applied to transactions with the vendor.

Pricelist String False

The price list associated with the vendor.

Comments String False

Additional comments or notes regarding the vendor.

Accountlabel String False

The account label for the vendor's financial transactions.

Apaccount String False

The accounts payable account associated with the vendor.

Apaccounttitle String False

The title of the accounts payable account for the vendor.

Form1099type String False

The 1099 tax form type used for the vendor.

Form1099box String False

The box number on the 1099 form where the vendor's income is reported.

Paymentpriority String False

The priority of payment for the vendor (e.g., high, low).

Contactinfo_contactname String False

The full name of the primary contact for the vendor.

Contactinfo_prefix String False

The prefix (e.g., Mr., Ms.) of the vendor's primary contact.

Contactinfo_firstname String False

The first name of the vendor's primary contact.

Contactinfo_initial String False

The initials of the vendor's primary contact.

Contactinfo_lastname String False

The last name of the vendor's primary contact.

Contactinfo_companyname String False

The company name of the vendor's primary contact.

Contactinfo_printas String False

The preferred display name format for the vendor's primary contact.

Contactinfo_phone1 String False

The primary phone number for the vendor's primary contact.

Contactinfo_phone2 String False

The secondary phone number for the vendor's primary contact.

Contactinfo_cellphone String False

The mobile phone number for the vendor's primary contact.

Contactinfo_pager String False

The pager number for the vendor's primary contact.

Contactinfo_fax String False

The fax number for the vendor's primary contact.

Contactinfo_email1 String False

The primary email address for the vendor's primary contact.

Contactinfo_email2 String False

The secondary email address for the vendor's primary contact.

Contactinfo_url1 String False

The primary website URL for the vendor's primary contact.

Contactinfo_url2 String False

The secondary website URL for the vendor's primary contact.

Contactinfo_visible Boolean False

Indicates whether the vendor's contact information is visible in reports.

Contactinfo_mailaddress_address1 String False

The first line of the mailing address for the vendor's primary contact.

Contactinfo_mailaddress_address2 String False

The second line of the mailing address for the vendor's primary contact.

Contactinfo_mailaddress_city String False

The city of the mailing address for the vendor's primary contact.

Contactinfo_mailaddress_state String False

The state of the mailing address for the vendor's primary contact.

Contactinfo_mailaddress_zip String False

The postal code of the mailing address for the vendor's primary contact.

Contactinfo_mailaddress_country String False

The country of the mailing address for the vendor's primary contact.

Contactinfo_mailaddress_countrycode String False

The country code of the mailing address for the vendor's primary contact.

Payto_contactname String False

The full name of the vendor's payment contact.

Payto_prefix String False

The prefix (e.g., Mr., Ms.) of the vendor's payment contact.

Payto_firstname String False

The first name of the vendor's payment contact.

Payto_initial String False

The initials of the vendor's payment contact.

Payto_lastname String False

The last name of the vendor's payment contact.

Payto_companyname String False

The company name of the vendor's payment contact.

Payto_printas String False

The preferred display name format for the vendor's payment contact.

Payto_phone1 String False

The primary phone number for the vendor's payment contact.

Payto_phone2 String False

The secondary phone number for the vendor's payment contact.

Payto_cellphone String False

The mobile phone number for the vendor's payment contact.

Payto_pager String False

The pager number for the vendor's payment contact.

Payto_fax String False

The fax number for the vendor's payment contact.

Payto_email1 String False

The primary email address for the vendor's payment contact.

Payto_email2 String False

The secondary email address for the vendor's payment contact.

Payto_url1 String False

The primary website URL for the vendor's payment contact.

Payto_url2 String False

The secondary website URL for the vendor's payment contact.

Payto_visible Boolean False

Indicates whether the vendor's payment contact information is visible in reports.

Payto_mailaddress_address1 String False

The first line of the mailing address for the vendor's payment contact.

Payto_mailaddress_address2 String False

The second line of the mailing address for the vendor's payment contact.

Payto_mailaddress_city String False

The city of the mailing address for the vendor's payment contact.

Payto_mailaddress_state String False

The state of the mailing address for the vendor's payment contact.

Payto_mailaddress_zip String False

The postal code of the mailing address for the vendor's payment contact.

Payto_mailaddress_country String False

The country of the mailing address for the vendor's payment contact.

Payto_mailaddress_countrycode String False

The country code of the mailing address for the vendor's payment contact.

Returnto_contactname String False

The full name of the return-to contact for the vendor.

Returnto_prefix String False

The prefix (e.g., Mr., Ms.) of the return-to contact for the vendor.

Returnto_firstname String False

The first name of the return-to contact for the vendor.

Returnto_initial String False

The initials of the return-to contact for the vendor.

Returnto_lastname String False

The last name of the return-to contact for the vendor.

Returnto_companyname String False

The company name of the return-to contact for the vendor.

Returnto_printas String False

The preferred display name format for the return-to contact for the vendor.

Returnto_phone1 String False

The primary phone number for the return-to contact for the vendor.

Returnto_phone2 String False

The secondary phone number for the return-to contact for the vendor.

Returnto_cellphone String False

The mobile phone number for the return-to contact for the vendor.

Returnto_pager String False

The pager number for the return-to contact for the vendor.

Returnto_fax String False

The fax number for the return-to contact for the vendor.

Returnto_email1 String False

The primary email address for the return-to contact for the vendor.

Returnto_email2 String False

The secondary email address for the vendor's return-to contact.

Returnto_url1 String False

The primary website URL for the vendor's return-to contact.

Returnto_url2 String False

The secondary website URL for the vendor's return-to contact.

Returnto_visible Boolean False

Indicates whether the vendor's return-to contact information is visible in reports.

Returnto_mailaddress_address1 String False

The first line of the mailing address for the vendor's return-to contact.

Returnto_mailaddress_address2 String False

The second line of the mailing address for the vendor's return-to contact.

Returnto_mailaddress_city String False

The city of the mailing address for the vendor's return-to contact.

Returnto_mailaddress_state String False

The state of the mailing address for the vendor's return-to contact.

Returnto_mailaddress_zip String False

The postal code of the mailing address for the vendor's return-to contact.

Returnto_mailaddress_country String False

The country of the mailing address for the vendor's return-to contact.

Returnto_mailaddress_countrycode String False

The country code of the mailing address for the vendor's return-to contact.

Status String False

The current status of the vendor (e.g., active, inactive).

Paydatevalue String False

The scheduled payment date for the vendor.

Onetime Boolean False

Indicates whether this is a one-time vendor transaction.

Onhold Boolean False

Indicates whether the vendor account is on hold for payments or other reasons.

Whenmodified Datetime False

The date and time when the vendor record was last modified.

Isowner Boolean False

Indicates whether the vendor is the owner of the account or entity.

Donotcutcheck Boolean False

Indicates whether checks should not be issued to the vendor.

Owner_eqglaccount String False

The general ledger account associated with the vendor's owner.

Owner_eqglaccountlabel String False

The label for the general ledger account associated with the vendor's owner.

Owner_holddist Boolean False

Indicates whether distribution to the vendor's owner is on hold.

Owner_accountlabel_label String False

The account label for the vendor's owner account.

Currency String False

The currency used for transactions with the vendor.

Achenabled Boolean False

Indicates whether ACH payments are enabled for the vendor.

Wireenabled Boolean False

Indicates whether wire transfers are enabled for the vendor.

Checkenabled Boolean False

Indicates whether checks are enabled for the vendor's payments.

Achbankroutingnumber String False

The ACH bank routing number for the vendor's bank account.

Achaccounttype String False

The type of ACH account used by the vendor (e.g., checking, savings).

Achremittancetype String False

The type of ACH remittance for payments to the vendor.

Wirebankname String False

The name of the bank for wire transfers to the vendor.

Wirebankroutingnumber String False

The routing number of the bank for wire transfers to the vendor.

Wireaccounttype String False

The type of wire transfer account used by the vendor.

Pmplusremittancetype String False

The remittance type for payments made via PMPlus to the vendor.

Pmplusemail String False

The primary email address for the vendor's PMPlus account.

Pmplusfax String False

The fax number for the vendor's PMPlus account.

Displaytermdiscount Boolean False

Indicates whether a term discount is displayed for the vendor.

Oeprclstkey Int64 False

The key identifier for the vendor's order entry pricing list.

Displocacctnocheck Boolean False

Indicates whether checks are restricted from being issued to the vendor's account.

Whencreated Datetime False

The date and time when the vendor record was created.

Createdby Int64 False

The ID of the user who created the vendor record.

Modifiedby Int64 False

The ID of the user who last modified the vendor record.

Paymentnotify Boolean False

Indicates whether the vendor should be notified of payment status.

Paymethodkey String False

The key identifier for the vendor's preferred payment method.

Objectrestriction String False

Restrictions applied to the vendor record, such as payment or credit terms.

Mergepaymentreq Boolean False

Indicates whether the vendor requires merged payments for multiple invoices.

Displaycontactkey Int64 False

The key identifier for the vendor's primary display contact.

Primarycontactkey Int64 False

The key identifier for the vendor's primary contact.

Paytokey Int64 False

The key identifier for the vendor's pay-to contact information.

Returntokey Int64 False

The key identifier for the vendor's return-to contact information.

Accountlabelkey Int64 False

The key identifier for the account label associated with the vendor.

Accountkey Int64 False

The key identifier for the vendor's financial account.

Vendtypekey Int64 False

The key identifier for the vendor type classification.

Glgrpkey Int64 False

The key identifier for the vendor's general ledger group.

Termskey Int64 False

The key identifier for the vendor's payment terms.

Vendoracctnokey Int64 False

The key identifier for the vendor's account number.

Paymethodrec Int64 False

The record identifier for the vendor's payment method details.

Outsourcecheck Boolean False

Indicates whether the vendor's checks should be outsourced for processing.

Outsourcecheckstate String False

The current state of the vendor's outsourced check processing.

Outsourceach Boolean False

Indicates whether the vendor's ACH transactions should be outsourced for processing.

Outsourceachstate String False

The current state of the vendor's outsourced ACH transaction processing.

Vendorachaccountid String False

The ACH account ID used by the vendor for transactions.

Vendoraccountoutsourceach String False

The account identifier for the vendor's outsourced ACH account.

Offsetglaccountno String False

The general ledger account number used for offsetting vendor transactions.

Offsetglaccountnotitle String False

The title for the general ledger account used for offsetting vendor transactions.

Megaentitykey Int64 False

The key identifier for the vendor's mega entity classification.

Megaentityid String False

The identifier for the vendor's mega entity.

Megaentityname String False

The name of the vendor's mega entity.

Record_url String False

The URL for accessing the vendor's record in the system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454