Purchasing.Vendor

Table: 'Purchasing.Vendor'

8 fields. 2201 bytes.

Companies from whom Adventure Works Cycles purchases parts or other goods.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
VendorIDint identity int Not nullPrimary key for Vendor records. 
AccountNumberAccountNumber nvarchar(15) Not nullVendor account (identification) number. 
NameName nvarchar(50) Not nullCompany name. 
CreditRatingtinyint   Not null1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average([CreditRating]>=(1) AND [CreditRating]<=(5))
PreferredVendorStatusFlag bit(1)Not null0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product. 
ActiveFlagFlag bit(1)Not null0 = Vendor no longer used. 1 = Vendor is actively used. 
PurchasingWebServiceURLnvarchar1024  NullVendor URL. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.Vendor'

Primary Key NameField Name
PK_Vendor_VendorIDVendorID
There are no Foreign Keys for this table.

Indexes for table 'Purchasing.Vendor', 2 items

Index NameDescriptionClusteredUniqueFields
PK_Vendor_VendorIDClustered index created by a primary key constraint.YesYesVendorID
AK_Vendor_AccountNumberUnique nonclustered index.NoYesAccountNumber

Triggers for table 'Purchasing.Vendor', 2 items

NameDescriptionTypeEnabled
dVendorINSTEAD OF DELETE trigger which keeps Vendors from being deleted.instead of Delete Yes
uVendorAFTER UPDATE trigger setting the ModifiedDate column in the Vendor table to the current date.after Update Yes

Dependencies for table 'Purchasing.Vendor', 3 items

Object NameTypeField Name
Purchasing.CK_Vendor_CreditRatingcheck cnsN/A
Purchasing.uVendortriggerN/A
Purchasing.vVendorviewN/A