Vendors

Vendors table for AvalaraAvatax data provider.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this vendor.
CompanyId [KEY]	Int	False	The unique ID number of the company that owns this vendor.
CustomerCode	String	False	The unique code identifying this vendor.
AlternateId	String	False	A customer-configurable alternate ID number for this vendor.
Name	String	False	A friendly name identifying this vendor.
AttnName	String	False	Indicates the 'Attn' component of the address for this vendor.
Line1	String	False	First line of the street address of this vendor.
Line2	String	False	Second line of the street address of this vendor.
City	String	False	City component of the street address of this vendor.
Region	String	False	ISO 3166 code identifying the region within the country.
PostalCode	String	False	Postal Code / Zip Code component of the address of this vendor.
Country	String	False	Name or ISO 3166 code identifying the country.
PhoneNumber	String	False	The main phone number for this vendor.
FaxNumber	String	False	The fax phone number for this vendor, if any.
EmailAddress	String	False	The main email address for this vendor.
ContactName	String	False	The name of the main contact person for this vendor.
TaxpayerIdNumber	String	False	For vendors in the United States, this field is the federal taxpayer ID number.
IsBill	Bool	False	True if this vendor record is specifically used for bill-to purposes.
IsShip	Bool	False	True if this vendor record is specifically used for ship-to purposes.
IsVendor	Bool	False	True if this record represents a vendor.
LastTransaction	Datetime	False	Date when this vendor last executed a transaction.
CreatedDate	Datetime	False	The date when this record was created.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
LinkedCertificates	String	False	A list of exemption certificates that apply to this vendor.

JDBC Driver for Avalara

Vendors

Columns