Purchasing.ProductVendor (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:10Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:38Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:07Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:51Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:13Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:10Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:19Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:42Z

Bot at 22:57, 26 November 2009

2009-11-26T22:57:56Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:08Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Purchasing.ProductVendor
@@ Line 8: / Line 8: @@
 | '''Description
 | Cross-reference table mapping vendors with the products they supply.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ProductID
@@ Line 94: / Line 92: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ProductVendor_ProductID_VendorID
 | ProductID, VendorID
@@ Line 105: / Line 103: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_ProductVendor_UnitMeasureCode
+|
 | UnitMeasureCode
-|-
+|- valign="top"
 | IX_ProductVendor_VendorID
+|
@@ Line 122: / Line 120: @@
 | '''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))
@@ Line 155: / Line 153: @@
 | '''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
@@ Line 177: / Line 175: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key. Foreign key to Product.ProductID.<br />PK_ProductVendor_ProductID_VendorID
+| Primary key. Foreign key to Product.ProductID.
 |- valign="top"
 | VendorID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Primary key. Foreign key to Vendor.VendorID.<br />PK_ProductVendor_ProductID_VendorIDIX_ProductVendor_VendorID
+| Primary key. Foreign key to Vendor.VendorID.
 |- valign="top"
 | AverageLeadTime
@@ Line 37: / Line 38: @@
 | not null
+|
-| The average span of time (in days) between placing an order with the vendor and receiving the purchased product.<br />
+| The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
 |- valign="top"
 | StandardPrice
@@ Line 43: / Line 44: @@
 | not null
+|
-| The vendor's usual selling price.<br />
+| The vendor's usual selling price.
 |- valign="top"
 | LastReceiptCost
@@ Line 49: / Line 50: @@
 | null
+|
-| The selling price when last purchased.<br />
+| The selling price when last purchased.
 |- valign="top"
 | LastReceiptDate
@@ Line 55: / Line 56: @@
 | null
+|
-| Date the product was last received by the vendor.<br />
+| Date the product was last received by the vendor.
 |- valign="top"
 | MinOrderQty
@@ Line 61: / Line 62: @@
 | not null
+|
-| The maximum quantity that should be ordered.<br />
+| The maximum quantity that should be ordered.
 |- valign="top"
 | MaxOrderQty
@@ Line 67: / Line 68: @@
 | not null
+|
-| The minimum quantity that should be ordered.<br />
+| The minimum quantity that should be ordered.
 |- valign="top"
 | OnOrderQty
@@ Line 73: / Line 74: @@
 | null
+|
-| The quantity currently on order.<br />
+| The quantity currently on order.
 |- valign="top"
 | UnitMeasureCode
@@ Line 79: / Line 80: @@
 | not null
+|
-| The product's unit of measure.<br />IX_ProductVendor_UnitMeasureCode
+| The product's unit of measure.
 |- valign="top"
 | ModifiedDate
@@ Line 85: / Line 86: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 110: / Line 170: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Purchasing.ProductVendor
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | ProductID
 | int
 | not null
+|
-| PK_ProductVendor_ProductID_VendorID
+| Primary key. Foreign key to Product.ProductID.<br />PK_ProductVendor_ProductID_VendorID
+|- valign="top"
 | VendorID
 | int
 | not null
+|
-| PK_ProductVendor_ProductID_VendorID
+| Primary key. Foreign key to Vendor.VendorID.<br />PK_ProductVendor_ProductID_VendorIDIX_ProductVendor_VendorID
-| IX_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.<br />
+|- valign="top"
 | StandardPrice
 | money
 | not null
+|
+| The vendor's usual selling price.<br />
+|- valign="top"
 | LastReceiptCost
 | money
 | null
+|
+| The selling price when last purchased.<br />
+|- valign="top"
 | LastReceiptDate
 | datetime
 | null
+|
+| Date the product was last received by the vendor.<br />
+|- valign="top"
 | MinOrderQty
 | int
 | not null
+|
+| The maximum quantity that should be ordered.<br />
+|- valign="top"
 | MaxOrderQty
 | int
 | not null
+|
+| The minimum quantity that should be ordered.<br />
+|- valign="top"
 | OnOrderQty
 | int
 | null
+|
+| The quantity currently on order.<br />
+|- valign="top"
 | UnitMeasureCode
 | nchar(3)
 | not null
+|
+| The product's unit of measure.<br />IX_ProductVendor_UnitMeasureCode
-| IX_ProductVendor_UnitMeasureCode
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 118: / Line 109: @@
 | VendorID
 |}
 == automatically generated ==

@@ Line 125: / Line 125: @@
 | Purchasing.ProductVendor
 |- valign="top"
 | '''Description
 | Cross-reference table mapping vendors with the products they supply.
 |-
 |}

@@ Line 234: / Line 234: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}