Editing Purchasing.ProductVendor (table)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table
| Purchasing.ProductVendor
|- valign="top"
| '''Description
| Cross-reference table mapping vendors with the products they supply.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description

|- valign="top"
| ProductID
| int
| not null
| 
| Primary key. Foreign key to Product.ProductID.
|- valign="top"
| VendorID
| int
| not null
| 
| Primary key. Foreign key to Vendor.VendorID.
|- valign="top"
| AverageLeadTime
| int
| not null
| 
| The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
|- valign="top"
| StandardPrice
| money
| not null
| 
| The vendor's usual selling price.
|- valign="top"
| LastReceiptCost
| money
| null
| 
| The selling price when last purchased.
|- valign="top"
| LastReceiptDate
| datetime
| null
| 
| Date the product was last received by the vendor.
|- valign="top"
| MinOrderQty
| int
| not null
| 
| The maximum quantity that should be ordered.
|- valign="top"
| MaxOrderQty
| int
| not null
| 
| The minimum quantity that should be ordered.
|- valign="top"
| OnOrderQty
| int
| null
| 
| The quantity currently on order.
|- valign="top"
| UnitMeasureCode
| nchar(3)
| not null
| 
| The product's unit of measure.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (getdate())
| Date and time the record was last updated.
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key
| '''Columns
|- valign="top"
| PK_ProductVendor_ProductID_VendorID
| ProductID, VendorID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index
| '''Type
| '''Columns

|- valign="top"
| IX_ProductVendor_UnitMeasureCode
| 
| UnitMeasureCode
|- valign="top"
| IX_ProductVendor_VendorID
| 
| VendorID
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint
| '''Expression
| '''Description

|- valign="top"
| CK_ProductVendor_AverageLeadTime
| ([AverageLeadTime]>=(1))
| Check constraint [AverageLeadTime] >= (1)
|- valign="top"
| CK_ProductVendor_LastReceiptCost
| ([LastReceiptCost]>(0.00))
| Check constraint [LastReceiptCost] > (0.00)
|- valign="top"
| CK_ProductVendor_MaxOrderQty
| ([MaxOrderQty]>=(1))
| Check constraint [MaxOrderQty] >= (1)
|- valign="top"
| CK_ProductVendor_MinOrderQty
| ([MinOrderQty]>=(1))
| Check constraint [MinOrderQty] >= (1)
|- valign="top"
| CK_ProductVendor_OnOrderQty
| ([OnOrderQty]>=(0))
| Check constraint [OnOrderQty] >= (0)
|- valign="top"
| CK_ProductVendor_StandardPrice
| ([StandardPrice]>(0.00))
| Check constraint [StandardPrice] > (0.00)
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|- valign="top"
| [[Production.Product_(table)|Production.Product]]
| ProductID
| ProductID
|- valign="top"
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
| UnitMeasureCode
| UnitMeasureCode
|- valign="top"
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| VendorID
| VendorID
|}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type
| '''Object Type
| '''Referenced Object

|- valign="top"
| Schema
| Schema
| [[Purchasing_(schema)|Purchasing]]

|}


== automatically generated ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Purchasing.ProductVendor
|- valign="top"
| '''Description
| Cross-reference table mapping vendors with the products they supply.
|-
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''Description / PK / Index
		
|- valign="top"
| ProductID
| int
| not null
| 
| Primary key. Foreign key to Product.ProductID.PK_ProductVendor_ProductID_VendorID
|- valign="top"
| VendorID
| int
| not null
| 
| Primary key. Foreign key to Vendor.VendorID.PK_ProductVendor_ProductID_VendorIDIX_ProductVendor_VendorID
|- valign="top"
| AverageLeadTime
| int
| not null
| 
| The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
|- valign="top"
| StandardPrice
| money
| not null
| 
| The vendor's usual selling price.
|- valign="top"
| LastReceiptCost
| money
| null
| 
| The selling price when last purchased.
|- valign="top"
| LastReceiptDate
| datetime
| null
| 
| Date the product was last received by the vendor.
|- valign="top"
| MinOrderQty
| int
| not null
| 
| The maximum quantity that should be ordered.
|- valign="top"
| MaxOrderQty
| int
| not null
| 
| The minimum quantity that should be ordered.
|- valign="top"
| OnOrderQty
| int
| null
| 
| The quantity currently on order.
|- valign="top"
| UnitMeasureCode
| nchar(3)
| not null
| 
| The product's unit of measure.IX_ProductVendor_UnitMeasureCode
|- valign="top"
| ModifiedDate
| datetime
| not null
| (GETDATE())
| Date and time the record was last updated.
|}



{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column
		
|-
| [[Production.Product_(table)|Production.Product]]
| ProductID
| ProductID
|-
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
| UnitMeasureCode
| UnitMeasureCode
|-
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| VendorID
| VendorID
|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type
| '''Object Type
| '''Referenced Object

|-
| Schema
| Schema
| [[Purchasing_(schema)|Purchasing]]

|}