invantive documentation
Forum di supporto InvantiveAccedi / Registrati

warehouse_orderpoint: Odoo itgen_odoo_warehouse_orderpoint

read only per partition

  • Catalogo: Odoo
  • Schema: stock
  • Etichetta: itgen_odoo_warehouse_orderpoint

Minimum Inventory Rule

È possibile solo recuperare i dati.

Defines Minimum stock rules.

Colonne della tabella

Di seguito sono riportate le colonne della tabella warehouse_orderpoint. 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
active boolean Active If the active field is set to False, it will allow you to hide the orderpoint without removing it.
allowed_location_ids varchar2
bom_id varchar2
bom_id_label varchar2
company_id varchar2
company_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
days_to_order numeric Days To Order Numbers of days in advance that replenishments demands are created.
display_name varchar2 Nome visualizzato
group_id varchar2 Moves created through this orderpoint will be put in this procurement group.If none is given, the moves generated by stock rules will be grouped into one big picking.
group_id_label varchar2 Moves created through this orderpoint will be put in this procurement group.If none is given, the moves generated by stock rules will be grouped into one big picking.
id int32 ID
lead_days_date datetime Lead Days Date
location_id varchar2
location_id_label varchar2
manufacturing_visibility_days numeric Manufacturing Visibility Days Visibility Days applied on the manufacturing routes.
name varchar2 Name
product_category_id varchar2
product_category_id_label varchar2
product_id varchar2
product_id_label varchar2
product_max_qty numeric Max Quantity When the virtual stock goes below the Min Quantity, Odoo generates a procurement to bring the forecasted quantity to the Quantity specified as Max Quantity.
product_min_qty numeric Min Quantity When the virtual stock goes below the Min Quantity specified for this field, Odoo generates a procurement to bring the forecasted quantity to the Max Quantity.
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_uom varchar2 Default unit of measure used for all stock operations.
product_uom_label varchar2 Default unit of measure used for all stock operations.
product_uom_name varchar2 Product unit of measure label
purchase_visibility_days numeric Purchase Visibility Days Visibility Days applied on the purchase routes.
qty_forecast numeric Forecast
qty_multiple numeric Multiple Quantity The procurement quantity will be rounded up to this multiple.If it is 0, the exact quantity will be used.
qty_on_hand numeric Disponibile
qty_to_order numeric To Order
route_id varchar2
route_id_label varchar2
rule_ids varchar2
show_bom boolean Show BoM column
show_supplier boolean Show supplier column
snoozed_until datetime Snoozed Hidden until next scheduler.
supplier_id varchar2
supplier_id_label varchar2
trigger varchar2 Trigger
vendor_id varchar2
vendor_id_label varchar2
visibility_days numeric Visibility Days Consider product forecast these many days in the future upon product replenishment, set to 0 for just-in-time.The value depends on the type of the route (Buy or Manufacture)
warehouse_id varchar2
warehouse_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: