Vendor Table

FlexNet Manager Suite (Cloud)

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.

FlexNet Manager Suite (Cloud)

Current