journal |
Journal
Catalog: Odoo
Schema: account
Documentation:
Populate factory part for account.journal.
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table journal are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_control_ids |
string |
|
☐ |
|
account_online_account_id_label |
string |
|
☐ |
|
account_online_account_id |
string |
|
☐ |
|
account_online_link_id_label |
string |
|
☐ |
|
account_online_link_id |
string |
|
☐ |
|
account_online_link_state |
string |
State |
☐ |
|
active |
boolean |
Active |
☐ |
Set active to false to hide the Journal without removing it. |
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
alias_domain |
string |
Alias domain |
☐ |
|
alias_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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 |
string |
Alias Name |
☐ |
It creates draft invoices and bills by sending an email. |
available_payment_method_ids |
string |
|
☐ |
|
bank_acc_number |
string |
Account Number |
☐ |
|
bank_account_id_label |
string |
|
☐ |
|
bank_account_id |
string |
|
☐ |
|
bank_id_label |
string |
|
☐ |
|
bank_id |
string |
|
☐ |
|
bank_statements_source |
string |
Bank Feeds |
☐ |
Defines how the bank statements will be registered |
code |
string |
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_label |
string |
|
☐ |
Company related to this journal |
company_id |
string |
|
☐ |
Company related to this journal |
company_partner_id_label |
string |
|
☐ |
|
company_partner_id |
string |
|
☐ |
|
compatible_edi_ids |
string |
|
☐ |
EDI format that support moves in this journal |
country_code |
string |
Country Code |
☐ |
The ISO country code in two chars. You can use this field for quick search. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
The currency used to enter statement |
currency_id |
string |
|
☐ |
The currency used to enter statement |
default_account_id_label |
string |
|
☐ |
|
default_account_id |
string |
|
☐ |
|
default_account_type |
string |
Default Account Type |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
edi_format_ids |
string |
|
☐ |
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 |
string |
|
☐ |
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 |
string |
Communication Standard |
☑ |
You can choose different models for each type of reference. The default one is the Odoo reference. |
invoice_reference_type |
string |
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 |
string |
|
☐ |
|
json_activity_data |
string |
Json Activity Data |
☐ |
|
kanban_dashboard_graph |
string |
Kanban Dashboard Graph |
☐ |
|
kanban_dashboard |
string |
Kanban Dashboard |
☐ |
|
loss_account_id_label |
string |
|
☐ |
Used to register a loss when the ending balance of a cash register differs from what the system computes |
loss_account_id |
string |
|
☐ |
Used to register a loss when the ending balance of a cash register differs from what the system computes |
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Journal Name |
☑ |
|
next_link_synchronization |
datetime |
Online Link Next synchronization |
☐ |
|
outbound_payment_method_line_ids |
string |
|
☐ |
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 |
string |
|
☐ |
|
profit_account_id_label |
string |
|
☐ |
Used to register a profit when the ending balance of a cash register differs from what the system computes |
profit_account_id |
string |
|
☐ |
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 |
string |
Activity Summary |
☐ |
|
sale_activity_type_id_label |
string |
|
☐ |
Activity will be automatically scheduled on payment due date, improving collection process. |
sale_activity_type_id |
string |
|
☐ |
Activity will be automatically scheduled on payment due date, improving collection process. |
sale_activity_user_id_label |
string |
|
☐ |
Leave empty to assign the Salesperson of the invoice. |
sale_activity_user_id |
string |
|
☐ |
Leave empty to assign the Salesperson of the invoice. |
secure_sequence_id_label |
string |
|
☐ |
Sequence to use to ensure the securisation of data |
secure_sequence_id |
string |
|
☐ |
Sequence to use to ensure the securisation of data |
selected_payment_method_codes |
string |
Selected Payment Method Codes |
☐ |
|
sepa_pain_version |
string |
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_override_regex |
string |
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<prefix1>.*?)(?P<year>\d{4})(?P<prefix2>\D*?)(?P<month>\d{2})(?P<prefix3>\D+?)(?P<seq>\d+)(?P<suffix>\D*?)$ |
sequence |
int32 |
Sequence |
☐ |
Used to order Journals in the dashboard view |
show_on_dashboard |
boolean |
Show journal on dashboard |
☐ |
Whether this journal should be displayed on the dashboard or not |
suspense_account_id_label |
string |
|
☐ |
Bank statements transactions will be posted on the suspense account until the final reconciliation allowing finding the right account. |
suspense_account_id |
string |
|
☐ |
Bank statements transactions will be posted on the suspense account until the final reconciliation allowing finding the right account. |
type |
string |
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 |
string |
|
☐ |
Website communication history |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826