invantive documentation
Invantive Support ForumsLog In / Sign Up

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_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
bank_payment_ids varchar2 Account payments representing aggregated and bank split payments.
cash_control boolean Has Cash Control
cash_journal_id varchar2
cash_journal_id_label varchar2
cash_real_transaction numeric Transaction
cash_register_balance_end numeric Theoretical Closing Balance Opening balance summed to all cash transactions.
cash_register_balance_end_real numeric Ending Balance
cash_register_balance_start numeric Starting Balance
cash_register_difference numeric Before Closing Difference Difference between the theoretical closing balance and the real closing balance.
cash_register_total_entry_encoding numeric Total Cash Transaction
company_id varchar2
company_id_label varchar2
config_id varchar2
config_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
crm_team_id varchar2 This Point of sale's sales will be related to this Sales Team.
crm_team_id_label varchar2 This Point of sale's sales will be related to this Sales Team.
currency_id varchar2
currency_id_label varchar2
display_name varchar2 Display Name
failed_pickings boolean Failed Pickings
has_message boolean Has Message
id int32 ID
is_in_company_currency boolean Is Using Company Currency
login_number int32 Login Sequence Number A sequence number that is incremented each time a user resumes the pos session
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
move_id varchar2
move_id_label varchar2
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Session ID
opening_notes varchar2 Opening Notes
order_count int32 Order Count
order_ids varchar2
payment_method_ids varchar2
picking_count int32 Picking Count
picking_ids varchar2
rescue boolean Recovery Session Auto-generated session for orphan orders, ignored in constraints
sequence_number int32 Order Sequence Number A sequence number that is incremented with each order
start_at datetime Opening Date
state varchar2 Status
statement_line_ids varchar2
stop_at datetime Closing Date
total_payments_amount numeric Total Payments Amount
update_stock_at_closing boolean Stock should be updated at closing
user_id varchar2
user_id_label varchar2
website_message_ids varchar2 Website communication history
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: