Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production ProductInventory (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 17:47


wikibot

TableProduction.ProductInventory
DescriptionProduct inventory information.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
PK_ProductInventory_ProductID_LocationID
LocationIDsmallintnot null Inventory location identification number. Foreign key to Location.LocationID.
PK_ProductInventory_ProductID_LocationID
Shelfnvarchar(10)not null Storage compartment within an inventory location.
Bintinyintnot null Storage container on a shelf in an inventory location.
Quantitysmallintnot null((0))Quantity of products in the inventory location.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.LocationLocationIDLocationID
Production.ProductProductIDProductID

Reference TypeObject TypeReferencing Object
SelectFunctiondbo.ufnGetStock

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