Vendor

vendor

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Account Number accountnumber text Yes Yes Yes
ACH achacct sublist Yes Yes Yes
Address Book addressbook sublist Yes Yes Yes
Alt. Email altemail email Yes Yes Yes
Alt. Phone altphone phone Yes Yes Yes
Balance balanceprimary currency Yes Yes Yes
Balance (Base) balance currency Yes Yes Yes
Billing Class billingclass select Yes Yes Yes
Bulk Merge bulkmerge sublist Yes Yes Yes
Campaigns campaigns sublist Yes Yes Yes
Category category select Yes Yes Yes
Comments comments textarea Yes Yes Yes
Company Name companyname text Yes Yes Yes
Contacts contactlist multiselect Yes Yes Yes
Credit Limit creditlimit currency2 Yes Yes Yes
Currencies currencylist sublist Yes Yes Yes
Currency currency select Yes Yes Yes
Date Created datecreated datetime Yes Yes Yes
Default Bank Account defaultbankaccount select Yes Yes Yes
Default Billing Address defaultbillingaddress select Yes Yes Yes
Default Expense Account expenseaccount select Yes Yes Yes
Default Shipping Address defaultshippingaddress select Yes Yes Yes
Default Tax Reg. Number defaulttaxreg select Yes Yes Yes
Duplicate duplicate checkbox Yes Yes Yes
Edition subsidiaryedition text Yes Yes Yes
Email Preference emailpreference select Yes Yes Yes
Email Transactions emailtransactions checkbox Yes Yes Yes
Enable Online Bill Pay billpay checkbox Yes Yes Yes
Entity ID entityid text Yes Yes Yes
External ID externalid text Yes Yes Yes
Fax fax phone Yes Yes Yes
Fax Transactions faxtransactions checkbox Yes Yes Yes
First Name firstname text Yes Yes Yes
Furigana phoneticname text Yes Yes Yes
Global Subscription Status globalsubscriptionstatus select Yes Yes Yes
Home Phone homephone phone Yes Yes Yes
Hourly Rate rate currency Yes Yes Yes
Incoterm incoterm select Yes Yes Yes
Internal ID id integer Yes Yes Yes
In-Transit Balance intransitbalance currency Yes Yes Yes
Is Individual isperson checkbox Yes Yes Yes
Job Resource isjobresourcevend checkbox Yes Yes Yes
Job Title title text Yes Yes Yes
Labor Cost laborcost currency Yes Yes Yes
Last Modified Date lastmodifieddate datetime Yes Yes Yes
Last Name lastname text Yes Yes Yes
Login Access giveaccess checkbox Yes Yes Yes
Manufacturing Locations manufacturinglocations multiselect Yes Yes Yes
Middle Name middlename text Yes Yes Yes
Mobile Phone mobilephone phone Yes Yes Yes
Mr./Ms... salutation text Yes Yes Yes
-No label- payablesaccount select Yes Yes Yes
Number entitynumber integer Yes Yes Yes
Phone phone phone Yes Yes Yes
Predicted Days Late/Early predicteddays integer Yes Yes Yes
Predicted Risk Confidence predconfidence percent Yes Yes Yes
Primary Contact contact select Yes Yes Yes
Print on Check As printoncheckas text Yes Yes Yes
Print Transactions printtransactions checkbox Yes Yes Yes
Rates rates sublist Yes Yes Yes
Represents Subsidiary representingsubsidiary select Yes Yes Yes
Roles rolesforsearch multiselect Yes Yes Yes
Subscription Message History subscriptionmessagehistory sublist Yes Yes Yes
Subscriptions subscriptions sublist Yes Yes Yes
Tax Registrations taxregistration sublist Yes Yes Yes
Terms terms select Yes Yes Yes
Time Approver timeapprover select Yes Yes Yes
Unbilled Orders unbilledordersprimary currency Yes Yes Yes
Unbilled Orders (Base) unbilledorders currency Yes Yes Yes
URL url url Yes Yes Yes
Vendor altname text Yes Yes Yes
Vendor Bill - Item Receipt Amount Tolerance receiptamount posfloat Yes Yes Yes
Vendor Bill - Item Receipt Quantity Difference receiptquantitydiff posfloat Yes Yes Yes
Vendor Bill - Item Receipt Quantity Tolerance receiptquantity posfloat Yes Yes Yes
Vendor Bill - Purchase Order Amount Tolerance purchaseorderamount posfloat Yes Yes Yes
Vendor Bill - Purchase Order Quantity Difference purchaseorderquantitydiff posfloat Yes Yes Yes
Vendor Bill - Purchase Order Quantity Tolerance purchaseorderquantity posfloat Yes Yes Yes
Vendor Email email email Yes Yes Yes
Vendor ID entitytitle text Yes Yes Yes
Vendor is Inactive isinactive checkbox Yes Yes Yes
Work Calendar workcalendar select Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Address to Address (vendorAddressbookEntityAddress.nkey) address (vendoraddressbook, vendoraddressbook.addressbookaddress) No Yes Yes
Tax Registrations to Address (vendorAddressbook.internalid) tax registrations (vendortaxregistration, vendortaxregistration.address) No Yes Yes
Tax Registrations to Nexus (Nexus.id) tax registrations (vendortaxregistration, vendortaxregistration.nexus) No Yes Yes
ACH to Vendor (vendor.id) ach (vendorachacct, vendorachacct.vendor) No Yes Yes
Address to Vendor (vendor.id) address (vendoraddressbook, vendoraddressbook.entity) No Yes Yes
Vendor to Billing Class (billingClass.id) vendor (vendor, vendor.billingclass) No Yes Yes
Bulk Merge to Vendor (vendor.id) bulk merge (vendorbulkmerge, vendorbulkmerge.entity) No Yes Yes
Campaigns to Vendor (vendor.id) campaigns (vendorcampaigns, vendorcampaigns.entity) No Yes Yes
Vendor to Contact (Contact.id) vendor (vendor, vendor.contact) No Yes Yes
Vendor to Currency (currency.id) vendor (vendor, vendor.currency) No Yes Yes
Vendor to Account (account.id) vendor (vendor, vendor.defaultbankaccount) No Yes Yes
Vendor to Address (EntityAddress.nkey) vendor (vendor, vendor.defaultbillingaddress) No Yes Yes
Vendor to Email Preference Type (EmailPreferenceType.id) vendor (vendor, vendor.emailpreference) Yes Yes Yes
Vendor to Account (account.id) vendor (vendor, vendor.expenseaccount) No Yes Yes
Vendor to Incoterm (incoterm.id) vendor (vendor, vendor.incoterm) No Yes Yes
Vendor to Account (account.id) vendor (vendor, vendor.openingbalanceaccount) No Yes Yes
Vendor to Account (account.id) vendor (vendor, vendor.payablesaccount) No Yes Yes
Rates to Vendor (vendor.id) rates (vendorrate, vendorrate.employee) No Yes Yes
Vendor to Subsidiary (subsidiary.id) vendor (vendor, vendor.representingsubsidiary) No Yes Yes
Role to -No label- (vendorRolesForSearch.role) role (role, role.id) No Yes Yes
Subscription Message History to Vendor (vendor.id) subscription message history (vendorsubscriptionmessagehistory, vendorsubscriptionmessagehistory.recipient) No Yes Yes
Subscription to Vendor (vendor.id) subscription (vendorsubscriptions, vendorsubscriptions.entity) No Yes Yes
Tax Registrations to Vendor (vendor.id) tax registrations (vendortaxregistration, vendortaxregistration.entity) No Yes Yes
Vendor to Terms (term.id) vendor (vendor, vendor.terms) No Yes Yes
Vendor to Employee (employee.id) vendor (vendor, vendor.timeapprover) No Yes Yes
Vendor to Work Calendar (workCalendar.id) vendor (vendor, vendor.workcalendar) No Yes Yes