uom_uom


Description

Product Unit of Measure

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('uom_uom_id_seq'::regclass)
account_analytic_line.product_uom_id account_analytic_line_product_uom_id_fkey N
account_move_line.product_uom_id account_move_line_product_uom_id_fkey R
barcode_rule.associated_uom_id barcode_rule_associated_uom_id_fkey N
product_replenish.product_uom_id product_replenish_product_uom_id_fkey C
product_template.uom_id product_template_uom_id_fkey R
product_template.uom_po_id product_template_uom_po_id_fkey R
sale_order_line.product_uom sale_order_line_product_uom_fkey R
stock_lot.product_uom_id stock_lot_product_uom_id_fkey N
stock_move.product_uom stock_move_product_uom_fkey R
stock_move_line.product_uom_id stock_move_line_product_uom_id_fkey R
stock_scrap.product_uom_id stock_scrap_product_uom_id_fkey R
category_id int4 10 null
uom_category.id uom_uom_category_id_fkey R

Category
create_uid int4 10 √ null
res_users.id uom_uom_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id uom_uom_write_uid_fkey N

Last Updated by
uom_type varchar 2147483647 null

Type
name jsonb 2147483647 null

Unit of Measure
factor numeric 0 null

Ratio
rounding numeric 0 null

Rounding Precision
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
uom_uom_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
uom_uom_factor_gt_zero ((factor <> (0)::numeric))
uom_uom_factor_reference_is_one (((((uom_type)::text = 'reference'::text) AND (factor = 1.0)) OR ((uom_type)::text <> 'reference'::text)))
uom_uom_rounding_gt_zero ((rounding > (0)::numeric))

Relationships

Close relationships within degrees of separation