Vendor Table
The Vendor
table contains a list of all the vendors in the system.
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.
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 |
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 |