mrp_unbuild

-1 rows


Description

Unbuild Order

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_unbuild_id_seq'::regclass)
stock_move.consume_unbuild_id stock_move_consume_unbuild_id_fkey N
stock_move.unbuild_id stock_move_unbuild_id_fkey N
stock_warn_insufficient_qty_unbuild.unbuild_id stock_warn_insufficient_qty_unbuild_unbuild_id_fkey N
product_id int4 10 null
product_product.id mrp_unbuild_product_id_fkey R

Product
company_id int4 10 null
res_company.id mrp_unbuild_company_id_fkey R

Company
product_uom_id int4 10 null
uom_uom.id mrp_unbuild_product_uom_id_fkey R

Unit of Measure
bom_id int4 10 √ null
mrp_bom.id mrp_unbuild_bom_id_fkey N

Bill of Material
mo_id int4 10 √ null
mrp_production.id mrp_unbuild_mo_id_fkey N

Manufacturing Order
lot_id int4 10 √ null
stock_lot.id mrp_unbuild_lot_id_fkey N

Lot/Serial Number
location_id int4 10 null
stock_location.id mrp_unbuild_location_id_fkey R

Source Location
location_dest_id int4 10 null
stock_location.id mrp_unbuild_location_dest_id_fkey R

Destination Location
create_uid int4 10 √ null
res_users.id mrp_unbuild_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 √ null

Reference
state varchar 2147483647 √ null

Status
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
product_qty float8 17,17 null

Quantity

Indexes

Constraint Name Type Sort Column(s)
mrp_unbuild_pkey Primary key Asc id
mrp_unbuild__company_id_index Performance Asc company_id

Check Constraints

Constraint Name Constraint
mrp_unbuild_qty_positive ((product_qty > (0)::double precision))

Relationships

Close relationships within degrees of separation