Table: unit_of_measure

Previous: unanet_properties_history

Unanet Data Model

Next: vat_location

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	uom_key	decimal(15)
2.		name	varchar(25)
3.		description	varchar(128)
4.		quantity_precision	tinyint
5.		active	char(1)	('Y')

Referenced from

Table	Column	Foreign Key Name
fin_document_det_proj_item	uom_key	fk_fin_doc_det_proj_item6
item_uom	uom_key	fk_item_uom2
po_item_line_descriptor	uom_key	fk_po_item_line_descr9
pr_item_line_descriptor	uom_key	fk_pr_item_line_descr8

Check Constraints

Name	Definition
cc_unit_of_measure_active	([active]='N' OR [active]='Y')
cc_unit_of_measure_qty	([quantity_precision]>=(0) AND [quantity_precision]<=(6))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_unit_of_measure	true	uom_key	Asc
idx_unit_of_measure1	true	name	Asc