Welcome Guest, you are in: <root> • Login

Page History: Production UnitMeasure (table)

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

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

Page Revision: 2010/06/24 01:09

wikibot ¶

Table	Production.UnitMeasure
Description	Unit of measure lookup table.

Columns ¶

Column	Data Type	Nullable	Default	Description
UnitMeasureCode	nchar(3)	not null		Primary key.
Name	dbo.Name	not null		Unit of measure description.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_UnitMeasure_UnitMeasureCode	UnitMeasureCode

Indexes ¶

Index	Type	Columns
AK_UnitMeasure_Name	Unique	Name

Detail Tables ¶

Detail Table	Column	Referencing Column
Production.BillOfMaterials	UnitMeasureCode	UnitMeasureCode
Production.Product	UnitMeasureCode	SizeUnitMeasureCode
Production.Product	UnitMeasureCode	WeightUnitMeasureCode
Purchasing.ProductVendor	UnitMeasureCode	UnitMeasureCode

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Production