session: Odoo itgen_odoo_session
read only per partition
- Catálogo:
Odoo - Esquema:
pos - Etiqueta: itgen_odoo_session
Point of Sale Session
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla session. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
bank_ |
varchar2 |
Account payments representing aggregated and bank split payments. | |||
cash_ |
boolean |
Has Cash Control | |||
cash_ |
varchar2 |
||||
cash_ |
varchar2 |
||||
cash_ |
numeric |
Transaction | |||
cash_ |
numeric |
Theoretical Closing Balance | Opening balance summed to all cash transactions. | ||
cash_ |
numeric |
Ending Balance | |||
cash_ |
numeric |
Starting Balance | |||
cash_ |
numeric |
Before Closing Difference | Difference between the theoretical closing balance and the real closing balance. | ||
cash_ |
numeric |
Total Cash Transaction | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
config_ |
varchar2 |
||||
config_ |
varchar2 |
||||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
varchar2 |
This Point of sale's sales will be related to this Sales Team. | |||
crm_ |
varchar2 |
This Point of sale's sales will be related to this Sales Team. | |||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
display_ |
varchar2 |
Nombre para mostrar | |||
failed_ |
boolean |
Failed Pickings | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Using Company Currency | |||
login_ |
int32 |
Login Sequence Number | A sequence number that is incremented each time a user resumes the pos session | ||
message_ |
int32 |
Número de archivos adjuntos | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Número de acciones | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Sesión-ID | |||
opening_ |
varchar2 |
Opening Notes | |||
order_ |
int32 |
Order Count | |||
order_ |
varchar2 |
||||
payment_ |
varchar2 |
||||
picking_ |
int32 |
Picking Count | |||
picking_ |
varchar2 |
||||
rescue |
boolean |
Recovery Session | Auto-generated session for orphan orders, ignored in constraints | ||
sequence_ |
int32 |
Order Sequence Number | A sequence number that is incremented with each order | ||
start_ |
datetime |
Opening Date | |||
state |
varchar2 |
Status | |||
statement_ |
varchar2 |
||||
stop_ |
datetime |
Fecha de Cierre | |||
total_ |
numeric |
Total Payments Amount | |||
update_ |
boolean |
Stock should be updated at closing | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: