stock_rule

20 rows


Description

Stock Rule

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_rule_id_seq'::regclass)
stock_move.rule_id stock_move_rule_id_fkey R
stock_warehouse.buy_pull_id stock_warehouse_buy_pull_id_fkey N
stock_warehouse.manufacture_mto_pull_id stock_warehouse_manufacture_mto_pull_id_fkey N
stock_warehouse.manufacture_pull_id stock_warehouse_manufacture_pull_id_fkey N
stock_warehouse.mto_pull_id stock_warehouse_mto_pull_id_fkey N
stock_warehouse.pbm_mto_pull_id stock_warehouse_pbm_mto_pull_id_fkey N
stock_warehouse.sam_rule_id stock_warehouse_sam_rule_id_fkey N
group_id int4 10 √ null
procurement_group.id stock_rule_group_id_fkey N

Fixed Procurement Group
sequence int4 10 √ null

Sequence
company_id int4 10 √ null
res_company.id stock_rule_company_id_fkey N

Company
location_dest_id int4 10 null
stock_location.id stock_rule_location_dest_id_fkey R

Destination Location
location_src_id int4 10 √ null
stock_location.id stock_rule_location_src_id_fkey N

Source Location
route_id int4 10 null
stock_route.id stock_rule_route_id_fkey C

Route
route_sequence int4 10 √ null

Route Sequence
picking_type_id int4 10 null
stock_picking_type.id stock_rule_picking_type_id_fkey R

Operation Type
delay int4 10 √ null

Lead Time
partner_address_id int4 10 √ null
res_partner.id stock_rule_partner_address_id_fkey N

Partner Address
warehouse_id int4 10 √ null
stock_warehouse.id stock_rule_warehouse_id_fkey N

Warehouse
propagate_warehouse_id int4 10 √ null
stock_warehouse.id stock_rule_propagate_warehouse_id_fkey N

Warehouse to Propagate
create_uid int4 10 √ null
res_users.id stock_rule_create_uid_fkey N

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

Last Updated by
group_propagation_option varchar 2147483647 √ null

Propagation of Procurement Group
action varchar 2147483647 null

Action
procure_method varchar 2147483647 null

Supply Method
auto varchar 2147483647 null

Automatic Move
name jsonb 2147483647 null

Name
active bool 1 √ null

Active
propagate_cancel bool 1 √ null

Cancel Next Move
propagate_carrier bool 1 √ null

Propagation of carrier
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_rule_pkey Primary key Asc id
stock_rule__action_index Performance Asc action
stock_rule__location_dest_id_index Performance Asc location_dest_id
stock_rule__location_src_id_index Performance Asc location_src_id
stock_rule__route_id_index Performance Asc route_id
stock_rule__warehouse_id_index Performance Asc warehouse_id

Relationships

Close relationships within degrees of separation