Purchasing ProductVendor (table)

Modified on 2011/08/27 11:18 by wikibot Categorized as Uncategorized
== 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
| &nbsp;
| Primary key. Foreign key to Product.ProductID.
|- valign="top"
| VendorID
| int
| not null
| &nbsp;
| Primary key. Foreign key to Vendor.VendorID.
|- valign="top"
| AverageLeadTime
| int
| not null
| &nbsp;
| 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
| &nbsp;
| The vendor's usual selling price.
|- valign="top"
| LastReceiptCost
| money
| null
| &nbsp;
| The selling price when last purchased.
|- valign="top"
| LastReceiptDate
| datetime
| null
| &nbsp;
| Date the product was last received by the vendor.
|- valign="top"
| MinOrderQty
| int
| not null
| &nbsp;
| The maximum quantity that should be ordered.
|- valign="top"
| MaxOrderQty
| int
| not null
| &nbsp;
| The minimum quantity that should be ordered.
|- valign="top"
| OnOrderQty
| int
| null
| &nbsp;
| The quantity currently on order.
|- valign="top"
| UnitMeasureCode
| nchar(3)
| not null
| &nbsp;
| 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
| &nbsp;
| UnitMeasureCode
|- valign="top"
| IX_ProductVendor_VendorID
| &nbsp;
| 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]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Purchasing ProductVendor (table)
