Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production Product (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 17:47


wikibot

TableProduction.Product
DescriptionProducts sold or used in the manfacturing of sold products.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductIDintnot null Primary key for Product records.
PK_Product_ProductID
Namedbo.Namenot null Name of the product.
AK_Product_Name
ProductNumbernvarchar(25)not null Unique product identification number.
AK_Product_ProductNumber
MakeFlagdbo.Flagnot null((1))0 = Product is purchased, 1 = Product is manufactured in-house.
FinishedGoodsFlagdbo.Flagnot null((1))0 = Product is not a salable item. 1 = Product is salable.
Colornvarchar(15)null Product color.
SafetyStockLevelsmallintnot null Minimum inventory quantity.
ReorderPointsmallintnot null Inventory level that triggers a purchase order or work order.
StandardCostmoneynot null Standard cost of the product.
ListPricemoneynot null Selling price.
Sizenvarchar(5)null Product size.
SizeUnitMeasureCodenchar(3)null Unit of measure for Size column.
WeightUnitMeasureCodenchar(3)null Unit of measure for Weight column.
Weightdecimal(8, 2)null Product weight.
DaysToManufactureintnot null Number of days required to manufacture the product.
ProductLinenchar(2)null R = Road, M = Mountain, T = Touring, S = Standard
Classnchar(2)null H = High, M = Medium, L = Low
Stylenchar(2)null W = Womens, M = Mens, U = Universal
ProductSubcategoryIDintnull Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
ProductModelIDintnull Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
SellStartDatedatetimenot null Date the product was available for sale.
SellEndDatedatetimenull Date the product was no longer available for sale.
DiscontinuedDatedatetimenull Date the product was discontinued.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Product_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.ProductModelProductModelIDProductModelID
Production.ProductSubcategoryProductSubcategoryIDProductSubcategoryID
Production.UnitMeasureSizeUnitMeasureCodeUnitMeasureCode
Production.UnitMeasureWeightUnitMeasureCodeUnitMeasureCode

Detail TableColumnReferencing Column
Production.BillOfMaterialsProductIDComponentID
Production.BillOfMaterialsProductIDProductAssemblyID
Production.ProductCostHistoryProductIDProductID
Production.ProductDocumentProductIDProductID
Production.ProductInventoryProductIDProductID
Production.ProductListPriceHistoryProductIDProductID
Production.ProductProductPhotoProductIDProductID
Production.ProductReviewProductIDProductID
Purchasing.ProductVendorProductIDProductID
Purchasing.PurchaseOrderDetailProductIDProductID
Sales.ShoppingCartItemProductIDProductID
Sales.SpecialOfferProductProductIDProductID
Production.TransactionHistoryProductIDProductID
Production.WorkOrderProductIDProductID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Flag
Data TypeTypedbo.Name

Reference TypeObject TypeReferencing Object
SelectViewProduction.vProductAndDescription
SelectProceduredbo.uspGetBillOfMaterials
SelectProceduredbo.uspGetWhereUsedProductID
SelectFunctiondbo.ufnGetProductDealerPrice
SelectFunctiondbo.ufnGetProductListPrice
SelectFunctiondbo.ufnGetProductStandardCost

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