Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Purchasing ProductVendor (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:04


wikibot

TablePurchasing.ProductVendor
DescriptionCross-reference table mapping vendors with the products they supply.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductIDintnot null Primary key. Foreign key to Product.ProductID.
PK_ProductVendor_ProductID_VendorID
VendorIDintnot null Primary key. Foreign key to Vendor.VendorID.
PK_ProductVendor_ProductID_VendorIDIX_ProductVendor_VendorID
AverageLeadTimeintnot null The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
StandardPricemoneynot null The vendor's usual selling price.
LastReceiptCostmoneynull The selling price when last purchased.
LastReceiptDatedatetimenull Date the product was last received by the vendor.
MinOrderQtyintnot null The maximum quantity that should be ordered.
MaxOrderQtyintnot null The minimum quantity that should be ordered.
OnOrderQtyintnull The quantity currently on order.
UnitMeasureCodenchar(3)not null The product's unit of measure.
IX_ProductVendor_UnitMeasureCode
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.ProductProductIDProductID
Production.UnitMeasureUnitMeasureCodeUnitMeasureCode
Purchasing.VendorVendorIDVendorID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.