invantive documentation
Forum di supporto InvantiveAccedi / Registrati

journal: Odoo itgen_odoo_journal

read only per partition

  • Catalogo: Odoo
  • Schema: account
  • Etichetta: itgen_odoo_journal

Diario

È possibile solo recuperare i dati.

Populate factory part for account.journal.

Colonne della tabella

Di seguito sono riportate le colonne della tabella journal. 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
account_control_ids varchar2
account_online_account_id varchar2
account_online_account_id_label varchar2
account_online_link_id varchar2
account_online_link_id_label varchar2
account_online_link_state varchar2 State
active boolean Active Set active to false to hide the Journal without removing it.
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
alias_domain varchar2 Alias domain
alias_id varchar2 Send one separate email for each invoice.Any file extension will be accepted.Only PDF and XML files will be interpreted by Odoo
alias_id_label varchar2 Send one separate email for each invoice.Any file extension will be accepted.Only PDF and XML files will be interpreted by Odoo
alias_name varchar2 Alias Name It creates draft invoices and bills by sending an email.
available_payment_method_ids varchar2
bank_acc_number varchar2 Numero di conto
bank_account_id varchar2
bank_account_id_label varchar2
bank_id varchar2
bank_id_label varchar2
bank_statements_source varchar2 Bank Feeds Defines how the bank statements will be registered
code varchar2 Short Code Shorter name used for display.The journal entries of this journal will also be named using this prefix by default.
color int32 Color Index
company_id varchar2 Company related to this journal
company_id_label varchar2 Company related to this journal
company_partner_id varchar2
company_partner_id_label varchar2
compatible_edi_ids varchar2 EDI format that support moves in this journal
country_code varchar2 Codice della nazione The ISO country code in two chars.You can use this field for quick search.
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
currency_id varchar2 The currency used to enter statement
currency_id_label varchar2 The currency used to enter statement
default_account_id varchar2
default_account_id_label varchar2
default_account_type varchar2 Tipo di conto predefinito
display_name varchar2 Nome visualizzato
edi_format_ids varchar2 Send XML/EDI invoices
entries_count int32 Entries Count
expiring_synchronization_date datetime Expiring Synchronization Date Date when the consent for this connection expires
expiring_synchronization_due_day int32 Expiring Synchronization Due Day
has_message boolean Has Message
has_sepa_ct_payment_method boolean Has Sepa Ct Payment Method
has_sequence_holes boolean Has Sequence Holes
id int32 ID
inbound_payment_method_line_ids varchar2 Manual: Get paid by any method outside of Odoo.Payment Providers: Each payment provider has its own Payment Method.Request a transaction on/to a card thanks to a payment token saved by the partner when buying or subscribing online.Batch Deposit: Collect several customer checks at once generating and submitting a batch deposit to your bank.Module account_batch_payment is necessary.SEPA Direct Debit: Get paid in the SEPA zone thanks to a mandate your partner will have granted to you.Module account_sepa is necessary.
invoice_reference_model varchar2 Communication Standard You can choose different models for each type of reference.The default one is the Odoo reference.
invoice_reference_type varchar2 Communication Type You can set here the default communication that will appear on customer invoices, once validated, to help the customer to refer to that particular invoice when making the payment.
journal_group_ids varchar2
json_activity_data varchar2 Json Activity Data
kanban_dashboard varchar2 Kanban Dashboard
kanban_dashboard_graph varchar2 Kanban Dashboard Graph
loss_account_id varchar2 Used to register a loss when the ending balance of a cash register differs from what the system computes
loss_account_id_label varchar2 Used to register a loss when the ending balance of a cash register differs from what the system computes
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
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Nome della rivista
next_link_synchronization datetime Online Link Next synchronization
outbound_payment_method_line_ids varchar2 Manual: Pay by any method outside of Odoo.Check: Pay bills by check and print it from Odoo.SEPA Credit Transfer: Pay in the SEPA zone by submitting a SEPA Credit Transfer file to your bank.Module account_sepa is necessary.
payment_sequence boolean Dedicated Payment Sequence Check this box if you don't want to share the same sequence on payments and bank transactions posted on this journal
pos_payment_method_ids varchar2
profit_account_id varchar2 Used to register a profit when the ending balance of a cash register differs from what the system computes
profit_account_id_label varchar2 Used to register a profit when the ending balance of a cash register differs from what the system computes
refund_sequence boolean Dedicated Credit Note Sequence Check this box if you don't want to share the same sequence for invoices and credit notes made from this journal
restrict_mode_hash_table boolean Lock Posted Entries with Hash If ticked, the accounting entry or invoice receives a hash as soon as it is posted and cannot be modified anymore.
sale_activity_note varchar2 Activity Summary
sale_activity_type_id varchar2 Activity will be automatically scheduled on payment due date, improving collection process.
sale_activity_type_id_label varchar2 Activity will be automatically scheduled on payment due date, improving collection process.
sale_activity_user_id varchar2 Leave empty to assign the Salesperson of the invoice.
sale_activity_user_id_label varchar2 Leave empty to assign the Salesperson of the invoice.
secure_sequence_id varchar2 Sequence to use to ensure the securisation of data
secure_sequence_id_label varchar2 Sequence to use to ensure the securisation of data
selected_payment_method_codes varchar2 Selected Payment Method Codes
sepa_pain_version varchar2 SEPA Pain Version SEPA may be a generic format, some countries differ from the SEPA recommendations made by the EPC (European Payment Council) and thus the XML created need some tweaking.
sequence int32 Sequence Used to order Journals in the dashboard view
sequence_override_regex varchar2 Sequence Override Regex Technical field used to enforce complex sequence composition that the system would normally misunderstand.This is a regex that can include all the following capture groups: prefix1, year, prefix2, month, prefix3, seq, suffix.The prefix* groups are the separators between the year, month and the actual increasing sequence number (seq). e.g: ^(?P.?)(?P\d{4})(?P\D?)(?P\d{2})(?P\D+?)(?P\d+)(?P\D*?)$
show_on_dashboard boolean Show journal on dashboard Whether this journal should be displayed on the dashboard or not
suspense_account_id varchar2 Bank statements transactions will be posted on the suspense account until the final reconciliation allowing finding the right account.
suspense_account_id_label varchar2 Bank statements transactions will be posted on the suspense account until the final reconciliation allowing finding the right account.
type varchar2 Type Select 'Sale' for customer invoices journals.Select 'Purchase' for vendor bills journals.Select 'Cash' or 'Bank' for journals that are used in customer or vendor payments.Select 'General' for miscellaneous operations journals.
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: