mrp_bom

-1 rows


Description

Bill of Material

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_bom_id_seq'::regclass)
account_analytic_account_mrp_bom_rel.mrp_bom_id account_analytic_account_mrp_bom_rel_mrp_bom_id_fkey C
mrp_bom_byproduct.bom_id mrp_bom_byproduct_bom_id_fkey C
mrp_bom_line.bom_id mrp_bom_line_bom_id_fkey C
mrp_production.bom_id mrp_production_bom_id_fkey N
mrp_routing_workcenter.bom_id mrp_routing_workcenter_bom_id_fkey C
mrp_unbuild.bom_id mrp_unbuild_bom_id_fkey N
stock_scrap.bom_id stock_scrap_bom_id_fkey N
stock_warehouse_orderpoint.bom_id stock_warehouse_orderpoint_bom_id_fkey N
product_tmpl_id int4 10 null
product_template.id mrp_bom_product_tmpl_id_fkey R

Product
product_id int4 10 √ null
product_product.id mrp_bom_product_id_fkey N

Product Variant
product_uom_id int4 10 null
uom_uom.id mrp_bom_product_uom_id_fkey R

Unit of Measure
sequence int4 10 √ null

Sequence
picking_type_id int4 10 √ null
stock_picking_type.id mrp_bom_picking_type_id_fkey N

Operation Type
company_id int4 10 √ null
res_company.id mrp_bom_company_id_fkey N

Company
produce_delay int4 10 √ null

Manufacturing Lead Time
days_to_prepare_mo int4 10 √ null

Days to prepare Manufacturing Order
create_uid int4 10 √ null
res_users.id mrp_bom_create_uid_fkey N

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

Last Updated by
code varchar 2147483647 √ null

Reference
type varchar 2147483647 null

BoM Type
ready_to_produce varchar 2147483647 null

Manufacturing Readiness
consumption varchar 2147483647 null

Flexible Consumption
product_qty numeric 0 null

Quantity
active bool 1 √ null

Active
allow_operation_dependencies bool 1 √ null

Operation Dependencies
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
mrp_bom_pkey Primary key Asc id
mrp_bom__company_id_index Performance Asc company_id
mrp_bom__product_id_index Performance Asc product_id
mrp_bom__product_tmpl_id_index Performance Asc product_tmpl_id

Check Constraints

Constraint Name Constraint
mrp_bom_qty_positive ((product_qty > (0)::numeric))

Relationships

Close relationships within degrees of separation