invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_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 Creato il
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 Nome visualizzato
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 Numero di allegati
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 Numero di azioni 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 Identificatore di sessione
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 Data di chiusura
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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: