account_journal

-1 rows


Description

Journal

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_journal_id_seq'::regclass)
account_account_account_journal_rel.account_journal_id account_account_account_journal_rel_account_journal_id_fkey C
account_accrued_orders_wizard.journal_id account_accrued_orders_wizard_journal_id_fkey C
account_analytic_line.journal_id account_analytic_line_journal_id_fkey N
account_bank_statement.journal_id account_bank_statement_journal_id_fkey N
account_journal_account_journal_group_rel.account_journal_id account_journal_account_journal_group_r_account_journal_id_fkey C
account_journal_account_reconcile_model_rel.account_journal_id account_journal_account_reconcile_model_account_journal_id_fkey C
account_move.journal_id account_move_journal_id_fkey R
account_move_line.journal_id account_move_line_journal_id_fkey N
account_move_reversal.journal_id account_move_reversal_journal_id_fkey C
account_payment.destination_journal_id account_payment_destination_journal_id_fkey N
account_payment_method_line.journal_id account_payment_method_line_journal_id_fkey C
account_payment_register.journal_id account_payment_register_journal_id_fkey N
account_reconcile_model_line.journal_id account_reconcile_model_line_journal_id_fkey C
journal_account_control_rel.journal_id journal_account_control_rel_journal_id_fkey C
res_company.automatic_entry_default_journal_id res_company_automatic_entry_default_journal_id_fkey N
res_company.currency_exchange_journal_id res_company_currency_exchange_journal_id_fkey N
res_company.tax_cash_basis_journal_id res_company_tax_cash_basis_journal_id_fkey N
sale_order.journal_id sale_order_journal_id_fkey N
stock_valuation_layer_revaluation.account_journal_id stock_valuation_layer_revaluation_account_journal_id_fkey N
alias_id int4 10 √ null
mail_alias.id account_journal_alias_id_fkey R

Alias
default_account_id int4 10 √ null
account_account.id account_journal_default_account_id_fkey R

Default Account
suspense_account_id int4 10 √ null
account_account.id account_journal_suspense_account_id_fkey R

Suspense Account
sequence int4 10 √ null

Sequence
currency_id int4 10 √ null
res_currency.id account_journal_currency_id_fkey N

Currency
company_id int4 10 null
res_company.id account_journal_company_id_fkey R

Company
profit_account_id int4 10 √ null
account_account.id account_journal_profit_account_id_fkey N

Profit Account
loss_account_id int4 10 √ null
account_account.id account_journal_loss_account_id_fkey N

Loss Account
bank_account_id int4 10 √ null
res_partner_bank.id account_journal_bank_account_id_fkey R

Bank Account
sale_activity_type_id int4 10 √ null
mail_activity_type.id account_journal_sale_activity_type_id_fkey N

Schedule Activity
sale_activity_user_id int4 10 √ null
res_users.id account_journal_sale_activity_user_id_fkey N

Activity User
secure_sequence_id int4 10 √ null
ir_sequence.id account_journal_secure_sequence_id_fkey N

Secure Sequence
create_uid int4 10 √ null
res_users.id account_journal_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id account_journal_write_uid_fkey N

Last Updated by
color int4 10 √ null

Color Index
access_token varchar 2147483647 √ null

Security Token
code varchar 5 null

Short Code
type varchar 2147483647 null

Type
invoice_reference_type varchar 2147483647 null

Communication Type
invoice_reference_model varchar 2147483647 null

Communication Standard
bank_statements_source varchar 2147483647 √ null

Bank Feeds
name jsonb 2147483647 null

Journal Name
sequence_override_regex text 2147483647 √ null

Sequence Override Regex
sale_activity_note text 2147483647 √ null

Activity Summary
active bool 1 √ null

Active
restrict_mode_hash_table bool 1 √ null

Lock Posted Entries with Hash
refund_sequence bool 1 √ null

Dedicated Credit Note Sequence
payment_sequence bool 1 √ null

Dedicated Payment Sequence
show_on_dashboard bool 1 √ null

Show journal on dashboard
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
check_sequence_id int4 10 √ null
ir_sequence.id account_journal_check_sequence_id_fkey N

Check Sequence
check_manual_sequencing bool 1 √ null

Manual Numbering

Indexes

Constraint Name Type Sort Column(s)
account_journal_pkey Primary key Asc id
account_journal__company_id_index Performance Asc company_id
account_journal_code_company_uniq Must be unique Asc/Asc company_id + code

Relationships

Close relationships within degrees of separation