account_account

47 rows


Description

Account

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_account_id_seq'::regclass)
account_account_account_journal_rel.account_account_id account_account_account_journal_rel_account_account_id_fkey C
account_account_account_tag.account_account_id account_account_account_tag_account_account_id_fkey C
account_account_tax_default_rel.account_id account_account_tax_default_rel_account_id_fkey C
account_accrued_orders_wizard.account_id account_accrued_orders_wizard_account_id_fkey C
account_analytic_line.general_account_id account_analytic_line_general_account_id_fkey R
account_automatic_entry_wizard.destination_account_id account_automatic_entry_wizard_destination_account_id_fkey N
account_fiscal_position_account.account_dest_id account_fiscal_position_account_account_dest_id_fkey R
account_fiscal_position_account.account_src_id account_fiscal_position_account_account_src_id_fkey R
account_journal.default_account_id account_journal_default_account_id_fkey R
account_journal.loss_account_id account_journal_loss_account_id_fkey N
account_journal.profit_account_id account_journal_profit_account_id_fkey N
account_journal.suspense_account_id account_journal_suspense_account_id_fkey R
account_move_line.account_id account_move_line_account_id_fkey C
account_payment.destination_account_id account_payment_destination_account_id_fkey N
account_payment.outstanding_account_id account_payment_outstanding_account_id_fkey N
account_payment_method_line.payment_account_id account_payment_method_line_payment_account_id_fkey R
account_payment_register.writeoff_account_id account_payment_register_writeoff_account_id_fkey N
account_reconcile_model_line.account_id account_reconcile_model_line_account_id_fkey C
account_tax.cash_basis_transition_account_id account_tax_cash_basis_transition_account_id_fkey N
account_tax_group.advance_tax_payment_account_id account_tax_group_advance_tax_payment_account_id_fkey N
account_tax_group.tax_payable_account_id account_tax_group_tax_payable_account_id_fkey N
account_tax_group.tax_receivable_account_id account_tax_group_tax_receivable_account_id_fkey N
account_tax_repartition_line.account_id account_tax_repartition_line_account_id_fkey N
journal_account_control_rel.account_id journal_account_control_rel_account_id_fkey C
res_company.account_cash_basis_base_account_id res_company_account_cash_basis_base_account_id_fkey N
res_company.account_default_pos_receivable_account_id res_company_account_default_pos_receivable_account_id_fkey N
res_company.account_discount_expense_allocation_id res_company_account_discount_expense_allocation_id_fkey N
res_company.account_discount_income_allocation_id res_company_account_discount_income_allocation_id_fkey N
res_company.account_journal_early_pay_discount_gain_account_id res_company_account_journal_early_pay_discount_gain_accoun_fkey N
res_company.account_journal_early_pay_discount_loss_account_id res_company_account_journal_early_pay_discount_loss_accoun_fkey N
res_company.account_journal_payment_credit_account_id res_company_account_journal_payment_credit_account_id_fkey N
res_company.account_journal_payment_debit_account_id res_company_account_journal_payment_debit_account_id_fkey N
res_company.account_journal_suspense_account_id res_company_account_journal_suspense_account_id_fkey N
res_company.default_cash_difference_expense_account_id res_company_default_cash_difference_expense_account_id_fkey N
res_company.default_cash_difference_income_account_id res_company_default_cash_difference_income_account_id_fkey N
res_company.expense_accrual_account_id res_company_expense_accrual_account_id_fkey N
res_company.expense_currency_exchange_account_id res_company_expense_currency_exchange_account_id_fkey N
res_company.income_currency_exchange_account_id res_company_income_currency_exchange_account_id_fkey N
res_company.revenue_accrual_account_id res_company_revenue_accrual_account_id_fkey N
res_company.transfer_account_id res_company_transfer_account_id_fkey N
sale_advance_payment_inv.deposit_account_id sale_advance_payment_inv_deposit_account_id_fkey N
stock_location.valuation_in_account_id stock_location_valuation_in_account_id_fkey N
stock_location.valuation_out_account_id stock_location_valuation_out_account_id_fkey N
stock_valuation_layer_revaluation.account_id stock_valuation_layer_revaluation_account_id_fkey N
currency_id int4 10 √ null
res_currency.id account_account_currency_id_fkey N

Account Currency
company_id int4 10 null
res_company.id account_account_company_id_fkey R

Company
group_id int4 10 √ null
account_group.id account_account_group_id_fkey N

Group
root_id int4 10 √ null

Root
create_uid int4 10 √ null
res_users.id account_account_create_uid_fkey N

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

Last Updated by
code varchar 64 null

Code
account_type varchar 2147483647 null

Type
internal_group varchar 2147483647 √ null

Internal Group
name jsonb 2147483647 null

Account Name
note text 2147483647 √ null

Internal Notes
deprecated bool 1 √ null

Deprecated
include_initial_balance bool 1 √ null

Bring Accounts Balance Forward
reconcile bool 1 √ null

Allow Reconciliation
non_trade bool 1 √ null

Non Trade
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
account_account_pkey Primary key Asc id
account_account__account_type_index Performance Asc account_type
account_account__code_index Performance Asc code

Relationships

Close relationships within degrees of separation