stock_scrap

-1 rows


Description

Scrap

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_scrap_id_seq'::regclass)
stock_move.scrap_id stock_move_scrap_id_fkey N
stock_warn_insufficient_qty_scrap.scrap_id stock_warn_insufficient_qty_scrap_scrap_id_fkey N
company_id int4 10 null
res_company.id stock_scrap_company_id_fkey R

Company
product_id int4 10 null
product_product.id stock_scrap_product_id_fkey R

Product
product_uom_id int4 10 null
uom_uom.id stock_scrap_product_uom_id_fkey R

Unit of Measure
lot_id int4 10 √ null
stock_lot.id stock_scrap_lot_id_fkey N

Lot/Serial
package_id int4 10 √ null
stock_quant_package.id stock_scrap_package_id_fkey N

Package
owner_id int4 10 √ null
res_partner.id stock_scrap_owner_id_fkey N

Owner
picking_id int4 10 √ null
stock_picking.id stock_scrap_picking_id_fkey N

Picking
location_id int4 10 null
stock_location.id stock_scrap_location_id_fkey R

Source Location
scrap_location_id int4 10 null
stock_location.id stock_scrap_scrap_location_id_fkey R

Scrap Location
create_uid int4 10 √ null
res_users.id stock_scrap_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Reference
origin varchar 2147483647 √ null

Source Document
state varchar 2147483647 √ null

Status
scrap_qty numeric 0 null

Quantity
should_replenish bool 1 √ null

Replenish Quantities
date_done timestamp 29,6 √ null

Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
production_id int4 10 √ null
mrp_production.id stock_scrap_production_id_fkey N

Manufacturing Order
workorder_id int4 10 √ null
mrp_workorder.id stock_scrap_workorder_id_fkey N

Work Order
bom_id int4 10 √ null
mrp_bom.id stock_scrap_bom_id_fkey N

Kit

Indexes

Constraint Name Type Sort Column(s)
stock_scrap_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation