product_replenish

-1 rows


Description

Product Replenish

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_replenish_id_seq'::regclass)
product_id int4 10 null
product_product.id product_replenish_product_id_fkey C

Product
product_tmpl_id int4 10 null
product_template.id product_replenish_product_tmpl_id_fkey C

Product Template
product_uom_id int4 10 null
uom_uom.id product_replenish_product_uom_id_fkey C

Unity of measure
warehouse_id int4 10 null
stock_warehouse.id product_replenish_warehouse_id_fkey C

Warehouse
route_id int4 10 √ null
stock_route.id product_replenish_route_id_fkey N

Preferred Route
company_id int4 10 √ null
res_company.id product_replenish_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id product_replenish_create_uid_fkey N

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

Last Updated by
product_has_variants bool 1 null

Has variants
date_planned timestamp 29,6 null

Scheduled Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
quantity float8 17,17 null

Quantity
supplier_id int4 10 √ null
product_supplierinfo.id product_replenish_supplier_id_fkey N

Vendor

Indexes

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

Relationships

Close relationships within degrees of separation