stock_warehouse_orderpoint

-1 rows


Description

Minimum Inventory Rule

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_warehouse_orderpoint_id_seq'::regclass)
mrp_production.orderpoint_id mrp_production_orderpoint_id_fkey N
purchase_order_line.orderpoint_id purchase_order_line_orderpoint_id_fkey N
stock_move.orderpoint_id stock_move_orderpoint_id_fkey N
stock_orderpoint_snooze_stock_warehouse_orderpoint_rel.stock_warehouse_orderpoint_id stock_orderpoint_snooze_stock_stock_warehouse_orderpoint_i_fkey C
stock_replenishment_info.orderpoint_id stock_replenishment_info_orderpoint_id_fkey N
warehouse_id int4 10 null
stock_warehouse.id stock_warehouse_orderpoint_warehouse_id_fkey C

Warehouse
location_id int4 10 null
stock_location.id stock_warehouse_orderpoint_location_id_fkey C

Location
product_id int4 10 null
product_product.id stock_warehouse_orderpoint_product_id_fkey C

Product
product_category_id int4 10 √ null
product_category.id stock_warehouse_orderpoint_product_category_id_fkey N

Product Category
group_id int4 10 √ null
procurement_group.id stock_warehouse_orderpoint_group_id_fkey N

Procurement Group
company_id int4 10 null
res_company.id stock_warehouse_orderpoint_company_id_fkey R

Company
route_id int4 10 √ null
stock_route.id stock_warehouse_orderpoint_route_id_fkey N

Route
create_uid int4 10 √ null
res_users.id stock_warehouse_orderpoint_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Name
trigger varchar 2147483647 null

Trigger
snoozed_until date 13 √ null

Snoozed
product_min_qty numeric 0 null

Min Quantity
product_max_qty numeric 0 null

Max Quantity
qty_multiple numeric 0 null

Multiple Quantity
qty_to_order numeric 0 √ null

To Order
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
bom_id int4 10 √ null
mrp_bom.id stock_warehouse_orderpoint_bom_id_fkey N

Bill of Materials
manufacturing_visibility_days float8 17,17 √ null

Manufacturing Visibility Days
supplier_id int4 10 √ null
product_supplierinfo.id stock_warehouse_orderpoint_supplier_id_fkey N

Product Supplier
vendor_id int4 10 √ null
res_partner.id stock_warehouse_orderpoint_vendor_id_fkey N

Vendor
purchase_visibility_days float8 17,17 √ null

Purchase Visibility Days

Indexes

Constraint Name Type Sort Column(s)
stock_warehouse_orderpoint_pkey Primary key Asc id
stock_warehouse_orderpoint__company_id_index Performance Asc company_id
stock_warehouse_orderpoint__location_id_index Performance Asc location_id
stock_warehouse_orderpoint__warehouse_id_index Performance Asc warehouse_id
stock_warehouse_orderpoint_product_location_check Must be unique Asc/Asc/Asc product_id + location_id + company_id

Check Constraints

Constraint Name Constraint
stock_warehouse_orderpoint_qty_multiple_check ((qty_multiple >= (0)::numeric))

Relationships

Close relationships within degrees of separation