ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
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''' |- | ProductID | int | not null | | Primary key. Foreign key to Product.ProductID.<br />PK_ProductVendor_ProductID_VendorID |- | VendorID | int | not null | | Primary key. Foreign key to Vendor.VendorID.<br />PK_ProductVendor_ProductID_VendorIDIX_ProductVendor_VendorID |- | AverageLeadTime | int | not null | | The average span of time (in days) between placing an order with the vendor and receiving the purchased product.<br /> |- | StandardPrice | money | not null | | The vendor's usual selling price.<br /> |- | LastReceiptCost | money | null | | The selling price when last purchased.<br /> |- | LastReceiptDate | datetime | null | | Date the product was last received by the vendor.<br /> |- | MinOrderQty | int | not null | | The maximum quantity that should be ordered.<br /> |- | MaxOrderQty | int | not null | | The minimum quantity that should be ordered.<br /> |- | OnOrderQty | int | null | | The quantity currently on order.<br /> |- | UnitMeasureCode | nchar(3) | not null | | The product's unit of measure.<br />IX_ProductVendor_UnitMeasureCode |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| 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]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.