session: Odoo itgen_odoo_session
read only per partition
- Catalog:
Odoo - Schema:
pos - Label: itgen_odoo_session
Point of Sale Session
Can only retrieve data.
Table Columns
The columns of the table session 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 |
|---|---|---|---|---|---|
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 |
Created on | |||
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 |
Display Name | |||
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 |
Attachment Count | |||
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 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Session 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 |
Closing Date | |||
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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: