stock_putaway_rule

-1 rows


Description

Putaway Rule

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_putaway_rule_id_seq'::regclass)
stock_package_type_stock_putaway_rule_rel.stock_putaway_rule_id stock_package_type_stock_putaway_rul_stock_putaway_rule_id_fkey C
product_id int4 10 √ null
product_product.id stock_putaway_rule_product_id_fkey C

Product
category_id int4 10 √ null
product_category.id stock_putaway_rule_category_id_fkey C

Product Category
location_in_id int4 10 null
stock_location.id stock_putaway_rule_location_in_id_fkey C

When product arrives in
location_out_id int4 10 null
stock_location.id stock_putaway_rule_location_out_id_fkey C

Store to sublocation
sequence int4 10 √ null

Priority
company_id int4 10 null
res_company.id stock_putaway_rule_company_id_fkey R

Company
storage_category_id int4 10 √ null
stock_storage_category.id stock_putaway_rule_storage_category_id_fkey C

Storage Category
create_uid int4 10 √ null
res_users.id stock_putaway_rule_create_uid_fkey N

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

Last Updated by
active bool 1 √ null

Active
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_putaway_rule_pkey Primary key Asc id
stock_putaway_rule__company_id_index Performance Asc company_id
stock_putaway_rule__location_in_id_index Performance Asc location_in_id

Relationships

Close relationships within degrees of separation