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_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
varchar2 |
||||
display_ |
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_ |
int32 |
Step | The next number of the sequence will be incremented by this number | ||
number_ |
int32 |
Next Number | Next number of this sequence | ||
number_ |
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_ |
boolean |
Use subsequences per date_range | |||
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: