mrp_bom_line

-1 rows


Description

Bill of Material Line

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_bom_line_id_seq'::regclass)
mrp_bom_line_product_template_attribute_value_rel.mrp_bom_line_id mrp_bom_line_product_template_attribute_va_mrp_bom_line_id_fkey C
stock_move.bom_line_id stock_move_bom_line_id_fkey N
product_id int4 10 null
product_product.id mrp_bom_line_product_id_fkey R

Component
product_tmpl_id int4 10 √ null
product_template.id mrp_bom_line_product_tmpl_id_fkey N

Product Template
company_id int4 10 √ null
res_company.id mrp_bom_line_company_id_fkey N

Company
product_uom_id int4 10 null
uom_uom.id mrp_bom_line_product_uom_id_fkey R

Product Unit of Measure
sequence int4 10 √ null

Sequence
bom_id int4 10 null
mrp_bom.id mrp_bom_line_bom_id_fkey C

Parent BoM
operation_id int4 10 √ null
mrp_routing_workcenter.id mrp_bom_line_operation_id_fkey N

Consumed in Operation
create_uid int4 10 √ null
res_users.id mrp_bom_line_create_uid_fkey N

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

Last Updated by
product_qty numeric 0 null

Quantity
manual_consumption bool 1 √ null

Manual Consumption
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
cost_share numeric 0 √ null

Cost Share (%)

Indexes

Constraint Name Type Sort Column(s)
mrp_bom_line_pkey Primary key Asc id
mrp_bom_line__bom_id_index Performance Asc bom_id
mrp_bom_line__company_id_index Performance Asc company_id
mrp_bom_line__product_tmpl_id_index Performance Asc product_tmpl_id

Check Constraints

Constraint Name Constraint
mrp_bom_line_bom_qty_zero ((product_qty >= (0)::numeric))

Relationships

Close relationships within degrees of separation