Purchasing.Vendor

Field Name Data Type Size Original Type Default Nullable Description Check

VendorID int identity int Not null Primary key for Vendor records.

AccountNumber AccountNumber nvarchar(15) Not null Vendor account (identification) number.

Name Name nvarchar(50) Not null Company name.

CreditRating tinyint Not null 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average ([CreditRating]>=(1) AND [CreditRating]<=(5))

PreferredVendorStatus Flag bit (1) Not null 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.

ActiveFlag Flag bit (1) Not null 0 = Vendor no longer used. 1 = Vendor is actively used.

PurchasingWebServiceURL nvarchar 1024 Null Vendor URL.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
VendorID	int identity		int		Not null	Primary key for Vendor records.
AccountNumber	AccountNumber		nvarchar(15)		Not null	Vendor account (identification) number.
Name	Name		nvarchar(50)		Not null	Company name.
CreditRating	tinyint				Not null	1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average	([CreditRating]>=(1) AND [CreditRating]<=(5))
PreferredVendorStatus	Flag		bit	(1)	Not null	0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
ActiveFlag	Flag		bit	(1)	Not null	0 = Vendor no longer used. 1 = Vendor is actively used.
PurchasingWebServiceURL	nvarchar	1024			Null	Vendor URL.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.Vendor'

Primary Key Name Field Name

PK_Vendor_VendorID VendorID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_Vendor_VendorID	VendorID

Indexes for table 'Purchasing.Vendor', 2 items

Index Name Description Clustered Unique Fields

PK_Vendor_VendorID Clustered index created by a primary key constraint. Yes Yes VendorID

AK_Vendor_AccountNumber Unique nonclustered index. No Yes AccountNumber

Index Name	Description	Clustered	Unique	Fields
PK_Vendor_VendorID	Clustered index created by a primary key constraint.	Yes	Yes	VendorID
AK_Vendor_AccountNumber	Unique nonclustered index.	No	Yes	AccountNumber

Triggers for table 'Purchasing.Vendor', 2 items

Name Description Type Enabled

dVendor INSTEAD OF DELETE trigger which keeps Vendors from being deleted. instead of Delete Yes

uVendor AFTER UPDATE trigger setting the ModifiedDate column in the Vendor table to the current date. after Update Yes

Name	Description	Type	Enabled
dVendor	INSTEAD OF DELETE trigger which keeps Vendors from being deleted.	instead of Delete	Yes
uVendor	AFTER 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 Name Type Field Name

Purchasing.CK_Vendor_CreditRating check cns N/A

Purchasing.uVendor trigger N/A

Purchasing.vVendor view N/A