session: Odoo itgen_odoo_session
read only per partition
- Catalogo:
Odoo - Schema:
pos - Etichetta: itgen_odoo_session
Point of Sale Session
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella session. 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 |
|---|---|---|---|---|---|
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 |
Creato il | |||
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 |
Nome visualizzato | |||
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 |
Numero di allegati | |||
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 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Identificatore di sessione | |||
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 |
Data di chiusura | |||
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: