vendor

Stores detailed information about vendors, including company details, contact information, and relationships within NetSuite.

Columns


Name	Type	References	Description
id [KEY]	Integer		Unique internal identifier for the vendor record.
accountnumber	String		Vendor's assigned account number for tracking and reference.
altemail	String		Alternative email address for vendor correspondence.
altname	String		Display name of the vendor, commonly used in reports and searches.
balance	Decimal		Total outstanding balance owed to the vendor in the base currency.
balanceprimary	Decimal		Total outstanding balance owed to the vendor in the vendor's currency.
billpay	Boolean		Indicates whether online bill payments are enabled for the vendor.
category	String		Classification or grouping assigned to the vendor, such as supplier type.
comments	String		Additional notes or remarks related to the vendor.
companyname	String		Registered name of the vendor's business or organization.
contact	String		Primary contact person associated with the vendor.
contactlist	String		List of all contacts linked to the vendor.
creditlimit	Decimal		Maximum allowable credit amount assigned to the vendor.
currency	String		Default currency used for transactions with the vendor.
datecreated	Date		Date when the vendor record was created.
defaultbankaccount	String		Primary bank account associated with the vendor for payments.
defaultbillingaddress	String		Predefined billing address for vendor transactions.
defaultshippingaddress	String		Predefined shipping address for vendor-related shipments.
duplicate	Boolean		Flag indicating if this vendor record is marked as a duplicate.
email	String		Primary email address used for vendor communications.
emailpreference	String		Vendor's preferred method for receiving email communications.
emailtransactions	Boolean		Indicates whether transaction-related emails should be sent to the vendor.
entityid	String		Unique identifier or reference number assigned to the vendor.
entitynumber	Integer		System-generated number representing the vendor entity.
entitytitle	String		Unique vendor identification used internally.
expenseaccount	String		Default expense account assigned for transactions with this vendor.
externalid	String		Custom external identifier assigned to the vendor for integrations.
faxtransactions	Boolean		Indicates whether transaction-related faxes should be sent to the vendor.
firstname	String		First name of the vendor's primary contact for individual vendors.
giveaccess	Boolean		Specifies whether the vendor has login access to a portal or system.
globalsubscriptionstatus	String		Status of the vendor's global subscription for email marketing.
incoterm	String		International Commercial Terms (Incoterms) applicable to the vendor.
isinactive	Boolean		Indicates whether the vendor record is inactive.
isjobresourcevend	Boolean		Specifies whether the vendor is a job resource for project-based work.
isperson	Boolean		Indicates whether the vendor is an individual rather than a business entity.
laborcost	Decimal		Total labor cost associated with the vendor.
lastmodifieddate	Date		Date when the vendor record was last updated.
lastname	String		Last name of the vendor's primary contact for individual vendors.
legalname	String		Vendor's registered legal name as per official records.
middlename	String		Middle name of the vendor's primary contact.
payablesaccount	String		Default accounts payable account linked to the vendor.
phoneticname	String		Phonetic representation of the vendor's name used for localization.
predconfidence	Double		Confidence level of the predicted risk assessment for the vendor.
predicteddays	Integer		Estimated number of days the vendor is likely to pay early or late.
printoncheckas	String		Vendor name format for printing on checks.
printtransactions	Boolean		Indicates whether transaction details should be printed for the vendor.
purchaseorderamount	Double		Tolerance percentage for differences in purchase order amounts on vendor bills.
purchaseorderquantity	Double		Tolerance percentage for discrepancies in purchase order quantities on vendor bills.
purchaseorderquantitydiff	Double		Allowed difference in purchase order quantity before triggering alerts.
receiptamount	Double		Tolerance percentage for discrepancies in item receipt amounts on vendor bills.
receiptquantity	Double		Tolerance percentage for discrepancies in item receipt quantities on vendor bills.
receiptquantitydiff	Double		Allowed difference in item receipt quantity before triggering alerts.
rolesforsearch	String		User roles that can access or search for this vendor.
salutation	String		Vendor's formal salutation, such as Mr., Ms., Dr., etc.
subsidiaryedition	String		Edition of the NetSuite subsidiary the vendor is associated with.
terms	String		Default payment terms agreed upon with the vendor.
timeapprover	String		Person responsible for approving time-related transactions for this vendor.
title	String		Job title of the vendor's primary contact.
unbilledorders	Decimal		Total value of purchase orders not yet billed by the vendor in the base currency.
unbilledordersprimary	Decimal		Total value of purchase orders not yet billed by the vendor in the vendor's currency.

Excel Add-In for NetSuite

vendor

Columns