mrp_workorder

-1 rows


Description

Work Order

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_workorder_id_seq'::regclass)
mrp_workcenter_productivity.workorder_id mrp_workcenter_productivity_workorder_id_fkey N
mrp_workorder_dependencies_rel.blocked_by_id mrp_workorder_dependencies_rel_blocked_by_id_fkey C
mrp_workorder_dependencies_rel.workorder_id mrp_workorder_dependencies_rel_workorder_id_fkey C
mrp_workorder_mo_analytic_rel.mrp_workorder_id mrp_workorder_mo_analytic_rel_mrp_workorder_id_fkey C
mrp_workorder_wc_analytic_rel.mrp_workorder_id mrp_workorder_wc_analytic_rel_mrp_workorder_id_fkey C
stock_move.workorder_id stock_move_workorder_id_fkey N
stock_move_line.workorder_id stock_move_line_workorder_id_fkey N
stock_scrap.workorder_id stock_scrap_workorder_id_fkey N
workcenter_id int4 10 null
mrp_workcenter.id mrp_workorder_workcenter_id_fkey R

Work Center
product_id int4 10 √ null
product_product.id mrp_workorder_product_id_fkey N

Product
product_uom_id int4 10 null
uom_uom.id mrp_workorder_product_uom_id_fkey R

Unit of Measure
production_id int4 10 null
mrp_production.id mrp_workorder_production_id_fkey R

Manufacturing Order
leave_id int4 10 √ null
resource_calendar_leaves.id mrp_workorder_leave_id_fkey N

Leave
duration_percent int4 10 √ null

Duration Deviation (%)
operation_id int4 10 √ null
mrp_routing_workcenter.id mrp_workorder_operation_id_fkey N

Operation
create_uid int4 10 √ null
res_users.id mrp_workorder_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Work Order
barcode varchar 2147483647 √ null

Barcode
production_availability varchar 2147483647 √ null

Stock Availability
state varchar 2147483647 √ null

Status
qty_produced numeric 0 √ null

Quantity
duration_expected numeric 0 √ null

Expected Duration
qty_reported_from_previous_wo numeric 0 √ null

Carried Quantity
date_start timestamp 29,6 √ null

Start
date_finished timestamp 29,6 √ null

End
production_date timestamp 29,6 √ null

Production Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
duration float8 17,17 √ null

Real Duration
duration_unit float8 17,17 √ null

Duration Per Unit
costs_hour float8 17,17 √ null

Cost per hour

Indexes

Constraint Name Type Sort Column(s)
mrp_workorder_pkey Primary key Asc id
mrp_workorder__production_id_index Performance Asc production_id
mrp_workorder__state_index Performance Asc state

Relationships

Close relationships within degrees of separation