Purchasing.ProductVendor

Table: 'Purchasing.ProductVendor'

11 fields. 104 bytes.

Cross-reference table mapping vendors with the products they supply.

Field Name Data Type Size Original Type Default Nullable Description Check

ProductID int Not null Primary key. Foreign key to Product.ProductID.

VendorID int Not null Primary key. Foreign key to Vendor.VendorID.

AverageLeadTime int Not null The average span of time (in days) between placing an order with the vendor and receiving the purchased product. ([AverageLeadTime]>=(1))

StandardPrice money 19,4 decimal(19,4) Not null The vendor's usual selling price. ([StandardPrice]>(0.00))

LastReceiptCost money 19,4 decimal(19,4) Null The selling price when last purchased. ([LastReceiptCost]>(0.00))

LastReceiptDate datetime Null Date the product was last received by the vendor.

MinOrderQty int Not null The maximum quantity that should be ordered. ([MinOrderQty]>=(1))

MaxOrderQty int Not null The minimum quantity that should be ordered. ([MaxOrderQty]>=(1))

OnOrderQty int Null The quantity currently on order. ([OnOrderQty]>=(0))

UnitMeasureCode nchar 3 Not null The product's unit of measure.

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

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ProductID	int				Not null	Primary key. Foreign key to Product.ProductID.
VendorID	int				Not null	Primary key. Foreign key to Vendor.VendorID.
AverageLeadTime	int				Not null	The average span of time (in days) between placing an order with the vendor and receiving the purchased product.	([AverageLeadTime]>=(1))
StandardPrice	money	19,4	decimal(19,4)		Not null	The vendor's usual selling price.	([StandardPrice]>(0.00))
LastReceiptCost	money	19,4	decimal(19,4)		Null	The selling price when last purchased.	([LastReceiptCost]>(0.00))
LastReceiptDate	datetime				Null	Date the product was last received by the vendor.
MinOrderQty	int				Not null	The maximum quantity that should be ordered.	([MinOrderQty]>=(1))
MaxOrderQty	int				Not null	The minimum quantity that should be ordered.	([MaxOrderQty]>=(1))
OnOrderQty	int				Null	The quantity currently on order.	([OnOrderQty]>=(0))
UnitMeasureCode	nchar	3			Not null	The product's unit of measure.
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.ProductVendor'

Primary Key Name Field Names

PK_ProductVendor_ProductID_VendorID ProductID, VendorID

Primary Key Name	Field Names
PK_ProductVendor_ProductID_VendorID	ProductID, VendorID

Foreign keys for table 'Purchasing.ProductVendor', 3 items

Foreign Primary Key Name

ProductVendor.ProductID Product.ProductID FK_ProductVendor_Product_ProductID

ProductVendor.UnitMeasureCode UnitMeasure.UnitMeasureCode FK_ProductVendor_UnitMeasure_UnitMeasureCode

ProductVendor.VendorID Vendor.VendorID FK_ProductVendor_Vendor_VendorID

Foreign	Primary	Key Name
ProductVendor.ProductID	Product.ProductID	FK_ProductVendor_Product_ProductID
ProductVendor.UnitMeasureCode	UnitMeasure.UnitMeasureCode	FK_ProductVendor_UnitMeasure_UnitMeasureCode
ProductVendor.VendorID	Vendor.VendorID	FK_ProductVendor_Vendor_VendorID

Indexes for table 'Purchasing.ProductVendor', 3 items

Index Name Description Clustered Unique Fields

PK_ProductVendor_ProductID_VendorID Clustered index created by a primary key constraint. Yes Yes ProductID, VendorID

IX_ProductVendor_UnitMeasureCode Nonclustered index. No No UnitMeasureCode

IX_ProductVendor_VendorID Nonclustered index. No No VendorID

Index Name	Description	Clustered	Unique	Fields
PK_ProductVendor_ProductID_VendorID	Clustered index created by a primary key constraint.	Yes	Yes	ProductID, VendorID
IX_ProductVendor_UnitMeasureCode	Nonclustered index.	No	No	UnitMeasureCode
IX_ProductVendor_VendorID	Nonclustered index.	No	No	VendorID

Triggers for table 'Purchasing.ProductVendor', 1 item

Name Description Type Enabled

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

Name	Description	Type	Enabled
uProductVendor	AFTER UPDATE trigger setting the ModifiedDate column in the ProductVendor table to the current date.	after Update	Yes

Dependencies for table 'Purchasing.ProductVendor', 7 items

Object Name Type Field Name

Purchasing.CK_ProductVendor_AverageLeadTime check cns N/A

Purchasing.CK_ProductVendor_LastReceiptCost check cns N/A

Purchasing.CK_ProductVendor_MaxOrderQty check cns N/A

Purchasing.CK_ProductVendor_MinOrderQty check cns N/A

Purchasing.CK_ProductVendor_OnOrderQty check cns N/A

Purchasing.CK_ProductVendor_StandardPrice check cns N/A

Purchasing.uProductVendor trigger N/A

Object Name	Type	Field Name
Purchasing.CK_ProductVendor_AverageLeadTime	check cns	N/A
Purchasing.CK_ProductVendor_LastReceiptCost	check cns	N/A
Purchasing.CK_ProductVendor_MaxOrderQty	check cns	N/A
Purchasing.CK_ProductVendor_MinOrderQty	check cns	N/A
Purchasing.CK_ProductVendor_OnOrderQty	check cns	N/A
Purchasing.CK_ProductVendor_StandardPrice	check cns	N/A
Purchasing.uProductVendor	trigger	N/A