Difference between revisions of "Purchasing.ProductVendor (table)"
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- valign="top" |
| '''Table | | '''Table | ||
| Purchasing.ProductVendor | | Purchasing.ProductVendor | ||
Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| Cross-reference table mapping vendors with the products they supply. | | Cross-reference table mapping vendors with the products they supply. | ||
− | |||
|} | |} | ||
− | |||
=== Columns === | === Columns === | ||
Line 20: | Line 18: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
− | + | ||
|- valign="top" | |- valign="top" | ||
| ProductID | | ProductID | ||
Line 94: | Line 92: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
− | |- | + | |- valign="top" |
| PK_ProductVendor_ProductID_VendorID | | PK_ProductVendor_ProductID_VendorID | ||
| ProductID, VendorID | | ProductID, VendorID | ||
Line 105: | Line 103: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
− | + | ||
− | |- | + | |- valign="top" |
| IX_ProductVendor_UnitMeasureCode | | IX_ProductVendor_UnitMeasureCode | ||
| | | | ||
| UnitMeasureCode | | UnitMeasureCode | ||
− | |- | + | |- valign="top" |
| IX_ProductVendor_VendorID | | IX_ProductVendor_VendorID | ||
| | | | ||
Line 122: | Line 120: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- valign="top" |
| CK_ProductVendor_AverageLeadTime | | CK_ProductVendor_AverageLeadTime | ||
| ([AverageLeadTime]>=(1)) | | ([AverageLeadTime]>=(1)) | ||
| Check constraint [AverageLeadTime] >= (1) | | Check constraint [AverageLeadTime] >= (1) | ||
− | |- | + | |- valign="top" |
| CK_ProductVendor_LastReceiptCost | | CK_ProductVendor_LastReceiptCost | ||
| ([LastReceiptCost]>(0.00)) | | ([LastReceiptCost]>(0.00)) | ||
| Check constraint [LastReceiptCost] > (0.00) | | Check constraint [LastReceiptCost] > (0.00) | ||
− | |- | + | |- valign="top" |
| CK_ProductVendor_MaxOrderQty | | CK_ProductVendor_MaxOrderQty | ||
| ([MaxOrderQty]>=(1)) | | ([MaxOrderQty]>=(1)) | ||
| Check constraint [MaxOrderQty] >= (1) | | Check constraint [MaxOrderQty] >= (1) | ||
− | |- | + | |- valign="top" |
| CK_ProductVendor_MinOrderQty | | CK_ProductVendor_MinOrderQty | ||
| ([MinOrderQty]>=(1)) | | ([MinOrderQty]>=(1)) | ||
| Check constraint [MinOrderQty] >= (1) | | Check constraint [MinOrderQty] >= (1) | ||
− | |- | + | |- valign="top" |
| CK_ProductVendor_OnOrderQty | | CK_ProductVendor_OnOrderQty | ||
| ([OnOrderQty]>=(0)) | | ([OnOrderQty]>=(0)) | ||
| Check constraint [OnOrderQty] >= (0) | | Check constraint [OnOrderQty] >= (0) | ||
− | |- | + | |- valign="top" |
| CK_ProductVendor_StandardPrice | | CK_ProductVendor_StandardPrice | ||
| ([StandardPrice]>(0.00)) | | ([StandardPrice]>(0.00)) | ||
Line 155: | Line 153: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- valign="top" |
| [[Production.Product_(table)|Production.Product]] | | [[Production.Product_(table)|Production.Product]] | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
− | |- | + | |- valign="top" |
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | ||
| UnitMeasureCode | | UnitMeasureCode | ||
| UnitMeasureCode | | UnitMeasureCode | ||
− | |- | + | |- valign="top" |
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]] | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]] | ||
| VendorID | | VendorID | ||
Line 177: | Line 175: | ||
| '''Referenced Object | | '''Referenced Object | ||
− | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Schema | | Schema |
Latest revision as of 23:17, 23 June 2010
Contents
wikibot[edit]
Table | Purchasing.ProductVendor |
Description | Cross-reference table mapping vendors with the products they supply. |
Columns[edit]
Column | Data Type | Nullable | Default | Description |
ProductID | int | not null | Primary key. Foreign key to Product.ProductID. | |
VendorID | int | not null | Primary key. Foreign key to Vendor.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. | |
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |
Primary Key[edit]
Primary Key | Columns |
PK_ProductVendor_ProductID_VendorID | ProductID, VendorID |
Indexes[edit]
Index | Type | Columns |
IX_ProductVendor_UnitMeasureCode | UnitMeasureCode | |
IX_ProductVendor_VendorID | VendorID |
Check Constraints[edit]
Check Constraint | Expression | Description |
CK_ProductVendor_AverageLeadTime | ([AverageLeadTime]>=(1)) | Check constraint [AverageLeadTime] >= (1) |
CK_ProductVendor_LastReceiptCost | ([LastReceiptCost]>(0.00)) | Check constraint [LastReceiptCost] > (0.00) |
CK_ProductVendor_MaxOrderQty | ([MaxOrderQty]>=(1)) | Check constraint [MaxOrderQty] >= (1) |
CK_ProductVendor_MinOrderQty | ([MinOrderQty]>=(1)) | Check constraint [MinOrderQty] >= (1) |
CK_ProductVendor_OnOrderQty | ([OnOrderQty]>=(0)) | Check constraint [OnOrderQty] >= (0) |
CK_ProductVendor_StandardPrice | ([StandardPrice]>(0.00)) | Check constraint [StandardPrice] > (0.00) |
Foreign Keys[edit]
Relation | Column | Referenced Column |
Production.Product | ProductID | ProductID |
Production.UnitMeasure | UnitMeasureCode | UnitMeasureCode |
Purchasing.Vendor | VendorID | VendorID |
References[edit]
Dependency Type | Object Type | Referenced Object |
Schema | Schema | Purchasing |
automatically generated[edit]
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 |
Dependency Type | Object Type | Referenced Object |
Schema | Schema | Purchasing |