stock_lot

-1 rows


Description

Lot/Serial

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_lot_id_seq'::regclass)
mrp_production.lot_producing_id mrp_production_lot_producing_id_fkey N
mrp_unbuild.lot_id mrp_unbuild_lot_id_fkey N
stock_move.order_finished_lot_id stock_move_order_finished_lot_id_fkey N
stock_move_line.lot_id stock_move_line_lot_id_fkey N
stock_quant.lot_id stock_quant_lot_id_fkey R
stock_scrap.lot_id stock_scrap_lot_id_fkey N
product_id int4 10 null
product_product.id stock_lot_product_id_fkey R

Product
product_uom_id int4 10 √ null
uom_uom.id stock_lot_product_uom_id_fkey N

Unit of Measure
company_id int4 10 null
res_company.id stock_lot_company_id_fkey R

Company
location_id int4 10 √ null
stock_location.id stock_lot_location_id_fkey N

Location
create_uid int4 10 √ null
res_users.id stock_lot_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Lot/Serial Number
ref varchar 2147483647 √ null

Internal Reference
lot_properties jsonb 2147483647 √ null

Properties
note text 2147483647 √ null

Description
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
stock_lot_pkey Primary key Asc id
stock_lot__company_id_index Performance Asc company_id
stock_lot__product_id_index Performance Asc product_id

Relationships

Close relationships within degrees of separation