Purchasing.Vendor

Generated using SQL Data Dictionary demo version.

Table Purchasing.Vendor (104 rows)

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

	Column	Data Type	Identity	Nullable	Default
PK, FK	BusinessEntityID	int
Primary key for Vendor records. Foreign key to BusinessEntity.BusinessEntityID
UK	AccountNumber	AccountNumber(nvarchar(15))
Vendor account (identification) number.
	Name	Name(nvarchar(50))
Company name.
	CreditRating	tinyint
1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average
	PreferredVendorStatus	Flag(bit)			1
0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
	ActiveFlag	Flag(bit)			1
0 = Vendor no longer used. 1 = Vendor is actively used.
	PurchasingWebServiceURL	nvarchar(1024)		X
Vendor URL.
	ModifiedDate	datetime			getdate()
Date and time the record was last updated.

Indexes:

PK_Vendor_BusinessEntityID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- BusinessEntityID

AK_Vendor_AccountNumber
- (Unique)
Unique nonclustered index.
- AccountNumber

References:

Person.BusinessEntity
- BusinessEntityID

Referenced by:

Purchasing.ProductVendor
- BusinessEntityID

Purchasing.PurchaseOrderHeader
- VendorID (BusinessEntityID)

Triggers:

dVendor
(Instead Of Delete)

INSTEAD OF DELETE trigger which keeps Vendors from being deleted.

Used by:

Function
dbo.ufnGetContactInformation
- BusinessEntityID
View
Purchasing.vVendorWithAddresses
- BusinessEntityID
- Name
View
Purchasing.vVendorWithContacts
- BusinessEntityID
- Name