Vendor Table

The Vendor table contains a list of all the vendors in the system.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `Vendor` table
Database Column	Details
`VendorID`	Type: integer. Key. Generated ID A unique identifier for the vendor.
`VendorName`	Type: text (max 64 characters). Key The name of the vendor.
`VendorPreviousName`	Type: text (max 64 characters). Nullable Any earlier name that the vendor was previously known as.
`BusinessPhoneNumber`	Type: text (max 30 characters). Nullable The business phone number of the vendor.
`FaxPhoneNumber`	Type: text (max 30 characters). Nullable The fax number of the vendor.
`Address_Street`	Type: text (max 200 characters). Nullable The street address of the vendor.
`Address_City`	Type: text (max 200 characters). Nullable The city of the vendor.
`Address_State`	Type: text (max 200 characters). Nullable The state or province of the vendor.
`Address_ZIP`	Type: text (max 20 characters). Nullable The ZIP or postal code of the vendor.
`Address_Country`	Type: text (max 100 characters). Nullable The country of the vendor.
`Address2_Street`	Type: text (max 200 characters). Nullable The second street address of the vendor, if applicable.
`Address2_City`	Type: text (max 200 characters). Nullable The second city of the vendor.
`Address2_State`	Type: text (max 200 characters). Nullable The second state or province of the vendor.
`Address2_ZIP`	Type: text (max 20 characters). Nullable The second ZIP or postal code of the vendor.
`Address2_Country`	Type: text (max 100 characters). Nullable The second country of the vendor.
`WebSite`	Type: text (max 200 characters). Nullable The web site of the vendor.
`Email`	Type: text (max 200 characters). Nullable The email address of the vendor.
`ParentVendorID`	Type: integer. Nullable A link to a vendor’s parent vendor. Foreign key to another vendor record in this `Vendor` table. Vendor hierarchies are not currently implemented.
`CreationUser`	Type: text (max 128 characters). Nullable The operator who created the record.
`CreationDate`	Type: datetime The date the record was created.
`UpdatedUser`	Type: text (max 128 characters). Nullable The operator who last updated the record.
`UpdatedDate`	Type: datetime. Nullable The date the record was last updated.
`AutomaticallyAccept Purchases`	Type: boolean Whether purchases from this vendor should have their license linking recommendations in the `EntitlementRecommendation` table automatically accepted.