Share via

  • Article

Vendor Table (AdventureWorks)

Contains companies from whom Adventure Works Cycles purchases parts or other goods.

Vendor Table Definition

The Vendor table is contained in the Purchasing schema.

Column

Data type

Nullability

Description

VendorID

int

Not null

Primary key.

AccountNumber

AccountNumber (user-defined type)

nvarchar(15)

Not null

Vendor account (identification) number.

Name

Name (user-defined type)

nvarchar(50)

Not null

Company name.

CreditRating

tinyint

Not null

1 = Superior

2 = Excellent

3 = Above average

4 = Average

5 = Below average

PreferredVendorStatus

Flag (user-defined type)

bit

Not null

0 = Do not use if another vendor is available.

1 = Preferred over other vendors supplying the same product.

ActiveFlag

Flag (user-defined type)

bit

Not null

0 = Vendor is no longer used.

1 = Vendor is actively used.

PurchasingWebServiceURL

nvarchar(1024)

Null

Vendor URL.

ModifiedDate

datetime

Not null

Date and time the row was last updated.