invantive documentation
Invantive Support ForumsLog In / Sign Up

sequence: Odoo itgen_odoo_sequence

read only per partition

  • Catalog: Odoo
  • Schema: ir
  • Label: itgen_odoo_sequence

Sequence

Can only retrieve data.

Summary

Sequence model.

The sequence model allows to define and use so-called sequence objects.
Such objects are used to generate unique identifiers in a transaction-safe
way.

Table Columns

The columns of the table sequence 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
active boolean Active
code varchar2 Sequence Code
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date_range_ids varchar2
display_name varchar2 Display Name
id int32 ID
implementation varchar2 Implementation While assigning a sequence number to a record, the 'no gap' sequence implementation ensures that each previous sequence number has been assigned already. While this sequence implementation will not skip any sequence number upon assignment, there can still be gaps in the sequence if records are deleted. The 'no gap' implementation is slower than the standard one.
name varchar2 Name
number_increment int32 Step The next number of the sequence will be incremented by this number
number_next int32 Next Number Next number of this sequence
number_next_actual int32 Actual Next Number Next number that will be used. This number can be incremented frequently so the displayed value might already be obsolete
padding int32 Sequence Size Odoo will automatically adds some '0' on the left of the 'Next Number' to get the required padding size.
prefix varchar2 Prefix Prefix value of the record for the sequence
suffix varchar2 Suffix Suffix value of the record for the sequence
use_date_range boolean Use subsequences per date_range
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: