mrp_production

4 rows


Description

Production Order

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_production_id_seq'::regclass)
account_analytic_account_mrp_production_rel.mrp_production_id account_analytic_account_mrp_production__mrp_production_id_fkey C
change_production_qty.mo_id change_production_qty_mo_id_fkey C
mrp_consumption_warning_line.mrp_production_id mrp_consumption_warning_line_mrp_production_id_fkey C
mrp_consumption_warning_mrp_production_rel.mrp_production_id mrp_consumption_warning_mrp_production_r_mrp_production_id_fkey C
mrp_production_backorder_line.mrp_production_id mrp_production_backorder_line_mrp_production_id_fkey C
mrp_production_mrp_production_backorder_rel.mrp_production_id mrp_production_mrp_production_backorder__mrp_production_id_fkey C
mrp_production_picking_label_type_rel.mrp_production_id mrp_production_picking_label_type_rel_mrp_production_id_fkey C
mrp_production_split.production_id mrp_production_split_production_id_fkey N
mrp_unbuild.mo_id mrp_unbuild_mo_id_fkey N
mrp_workorder.production_id mrp_workorder_production_id_fkey R
stock_assign_serial.production_id stock_assign_serial_production_id_fkey N
stock_move.created_production_id stock_move_created_production_id_fkey N
stock_move.production_id stock_move_production_id_fkey N
stock_move.raw_material_production_id stock_move_raw_material_production_id_fkey N
stock_move_line.production_id stock_move_line_production_id_fkey N
stock_scrap.production_id stock_scrap_production_id_fkey N
backorder_sequence int4 10 √ null

Backorder Sequence
product_id int4 10 null
product_product.id mrp_production_product_id_fkey R

Product
product_uom_id int4 10 null
uom_uom.id mrp_production_product_uom_id_fkey R

Product Unit of Measure
lot_producing_id int4 10 √ null
stock_lot.id mrp_production_lot_producing_id_fkey N

Lot/Serial Number
picking_type_id int4 10 null
stock_picking_type.id mrp_production_picking_type_id_fkey R

Operation Type
location_src_id int4 10 null
stock_location.id mrp_production_location_src_id_fkey R

Components Location
location_dest_id int4 10 null
stock_location.id mrp_production_location_dest_id_fkey R

Finished Products Location
bom_id int4 10 √ null
mrp_bom.id mrp_production_bom_id_fkey N

Bill of Material
user_id int4 10 √ null
res_users.id mrp_production_user_id_fkey N

Responsible
company_id int4 10 null
res_company.id mrp_production_company_id_fkey R

Company
procurement_group_id int4 10 √ null
procurement_group.id mrp_production_procurement_group_id_fkey N

Procurement Group
orderpoint_id int4 10 √ null
stock_warehouse_orderpoint.id mrp_production_orderpoint_id_fkey N

Orderpoint
production_location_id int4 10 √ null
stock_location.id mrp_production_production_location_id_fkey N

Production Location
create_uid int4 10 √ null
res_users.id mrp_production_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 √ null

Reference
priority varchar 2147483647 √ null

Priority
origin varchar 2147483647 √ null

Source
state varchar 2147483647 √ null

State
reservation_state varchar 2147483647 √ null

MO Readiness
product_description_variants varchar 2147483647 √ null

Custom Description
consumption varchar 2147483647 null

Consumption
product_qty numeric 0 null

Quantity To Produce
qty_producing numeric 0 √ null

Quantity Producing
propagate_cancel bool 1 √ null

Propagate cancel and split
is_locked bool 1 √ null

Is Locked
is_planned bool 1 √ null

Its Operations are Planned
allow_workorder_dependencies bool 1 √ null

Allow Work Order Dependencies
is_outdated_bom bool 1 √ null

Outdated BoM
date_deadline timestamp 29,6 √ null

Deadline
date_start timestamp 29,6 null

Start
date_finished timestamp 29,6 √ null

End
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
product_uom_qty float8 17,17 √ null

Total Quantity
analytic_distribution jsonb 2147483647 √ null

Analytic Distribution
extra_cost float8 17,17 √ null

Extra Unit Cost

Indexes

Constraint Name Type Sort Column(s)
mrp_production_pkey Primary key Asc id
mrp_production__company_id_index Performance Asc company_id
mrp_production__date_start_index Performance Asc date_start
mrp_production__orderpoint_id_index Performance Asc orderpoint_id
mrp_production__picking_type_id_index Performance Asc picking_type_id
mrp_production__reservation_state_index Performance Asc reservation_state
mrp_production__state_index Performance Asc state
mrp_production_analytic_distribution_accounts_gin_index Performance
mrp_production_name_uniq Must be unique Asc/Asc name + company_id

Check Constraints

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

Relationships

Close relationships within degrees of separation