rule: Odoo itgen_odoo_rule
read only per partition
- Catalog:
Odoo - Schema:
stock - Label: itgen_odoo_rule
Stock Rule
Can only retrieve data.
Summary
A rule describe what a procurement should do; produce, buy, move, ...
Table Columns
The columns of the table rule are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
action |
varchar2 |
Action | |||
active |
boolean |
Active | If unchecked, it will allow you to hide the rule without removing it. | ||
auto |
varchar2 |
Automatic Move | The 'Manual Operation' value will create a stock move after the current one. With 'Automatic No Step Added', the location is replaced in the original move. | ||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
delay |
int32 |
Lead Time | The expected date of the created transfer will be computed based on this lead time. | ||
display_ |
varchar2 |
Display Name | |||
group_ |
varchar2 |
||||
group_ |
varchar2 |
||||
group_ |
varchar2 |
Propagation of Procurement Group | |||
id |
int32 |
ID | |||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
name |
varchar2 |
Name | This field will fill the packing origin and the name of its moves | ||
partner_ |
varchar2 |
Address where goods should be delivered. Optional. | |||
partner_ |
varchar2 |
Address where goods should be delivered. Optional. | |||
picking_ |
varchar2 |
Picking Type Code Domain | |||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
procure_ |
varchar2 |
Supply Method | Take From Stock: the products will be taken from the available stock of the source location. Trigger Another Rule: the system will try to find a stock rule to bring the products in the source location. The available stock will be ignored. Take From Stock, if Unavailable, Trigger Another Rule: the products will be taken from the available stock of the source location.If there is no stock available, the system will try to find a rule to bring the products in the source location. | ||
propagate_ |
boolean |
Cancel Next Move | When ticked, if the move created by this rule is cancelled, the next move will be cancelled too. | ||
propagate_ |
boolean |
Propagation of carrier | When ticked, carrier of shipment will be propagated. | ||
propagate_ |
varchar2 |
The warehouse to propagate on the created move/procurement, which can be different of the warehouse this rule is for (e.g for resupplying rules from another warehouse) | |||
propagate_ |
varchar2 |
The warehouse to propagate on the created move/procurement, which can be different of the warehouse this rule is for (e.g for resupplying rules from another warehouse) | |||
route_ |
varchar2 |
Leave this field empty if this route is shared between all companies | |||
route_ |
varchar2 |
Leave this field empty if this route is shared between all companies | |||
route_ |
varchar2 |
||||
route_ |
varchar2 |
||||
route_ |
int32 |
Route Sequence | |||
rule_ |
varchar2 |
Rule Message | |||
sequence |
int32 |
Sequence | |||
warehouse_ |
varchar2 |
||||
warehouse_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: