Difference between revisions of "Purchasing.ProductVendor (table)"

From dbscript Online Help
Jump to: navigation, search
Line 94: Line 94:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| 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
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Purchasing.ProductVendor
 +
|-
 +
 +
| '''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.
 +
| PK_ProductVendor_ProductID_VendorID
 +
|-
 +
| VendorID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to Vendor.VendorID.
 +
| 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.
 +
|
 +
|-
 +
| StandardPrice
 +
| money
 +
| not null
 +
|
 +
| The vendor's usual selling price.
 +
|
 +
|-
 +
| LastReceiptCost
 +
| money
 +
| null
 +
|
 +
| The selling price when last purchased.
 +
|
 +
|-
 +
| LastReceiptDate
 +
| datetime
 +
| null
 +
|
 +
| Date the product was last received by the vendor.
 +
|
 +
|-
 +
| MinOrderQty
 +
| int
 +
| not null
 +
|
 +
| The maximum quantity that should be ordered.
 +
|
 +
|-
 +
| MaxOrderQty
 +
| int
 +
| not null
 +
|
 +
| The minimum quantity that should be ordered.
 +
|
 +
|-
 +
| OnOrderQty
 +
| int
 +
| null
 +
|
 +
| The quantity currently on order.
 +
|
 +
|-
 +
| UnitMeasureCode
 +
| nchar(3)
 +
| not null
 +
|
 +
| The product's unit of measure.
 +
| IX_ProductVendor_UnitMeasureCode
 +
|-
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:27, 26 November 2009

wikibot

Table Purchasing.ProductVendor


Column Data Type Nullable Default PK Index
ProductID int not null PK_ProductVendor_ProductID_VendorID
VendorID int not null PK_ProductVendor_ProductID_VendorID IX_ProductVendor_VendorID
AverageLeadTime int not null
StandardPrice money not null
LastReceiptCost money null
LastReceiptDate datetime null
MinOrderQty int not null
MaxOrderQty int not null
OnOrderQty int null
UnitMeasureCode nchar(3) not null IX_ProductVendor_UnitMeasureCode
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Production.Product ProductID ProductID
Production.UnitMeasure UnitMeasureCode UnitMeasureCode
Purchasing.Vendor VendorID VendorID

automatically generated

Table Purchasing.ProductVendor
Description Cross-reference table mapping vendors with the products they supply.


Column Data Type Nullable Default Description PK / Index
ProductID int not null Primary key. Foreign key to Product.ProductID. PK_ProductVendor_ProductID_VendorID
VendorID int not null Primary key. Foreign key to Vendor.VendorID. 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.
StandardPrice money not null The vendor's usual selling price.
LastReceiptCost money null The selling price when last purchased.
LastReceiptDate datetime null Date the product was last received by the vendor.
MinOrderQty int not null The maximum quantity that should be ordered.
MaxOrderQty int not null The minimum quantity that should be ordered.
OnOrderQty int null The quantity currently on order.
UnitMeasureCode nchar(3) not null The product's unit of measure. IX_ProductVendor_UnitMeasureCode
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Product ProductID ProductID
Production.UnitMeasure UnitMeasureCode UnitMeasureCode
Purchasing.Vendor VendorID VendorID
Retrieved from "http://dbshelp.devio.at/index.php?title=Purchasing.ProductVendor_(table)&oldid=1113"