rule: Odoo itgen_odoo_rule
read only per partition
- Catalogo:
Odoo - Schema:
stock - Etichetta: itgen_odoo_rule
Stock Rule
È possibile solo recuperare i dati.
Riepilogo
A rule describe what a procurement should do; produce, buy, move, ...
Colonne della tabella
Di seguito sono riportate le colonne della tabella rule. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
delay |
int32 |
Tempi di consegna | The expected date of the created transfer will be computed based on this lead time. | ||
display_ |
varchar2 |
Nome visualizzato | |||
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.Facoltativo. | |||
partner_ |
varchar2 |
Address where goods should be delivered.Facoltativo. | |||
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: