chart_template |
Account Chart Template
Catalog: Odoo
Schema: account
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 chart_template are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_ids |
string |
|
☐ |
|
account_journal_early_pay_discount_gain_account_id_label |
string |
|
☐ |
|
account_journal_early_pay_discount_gain_account_id |
string |
|
☐ |
|
account_journal_early_pay_discount_loss_account_id_label |
string |
|
☐ |
|
account_journal_early_pay_discount_loss_account_id |
string |
|
☐ |
|
account_journal_payment_credit_account_id_label |
string |
|
☐ |
|
account_journal_payment_credit_account_id |
string |
|
☐ |
|
account_journal_payment_debit_account_id_label |
string |
|
☐ |
|
account_journal_payment_debit_account_id |
string |
|
☐ |
|
account_journal_suspense_account_id_label |
string |
|
☐ |
|
account_journal_suspense_account_id |
string |
|
☐ |
|
bank_account_code_prefix |
string |
Prefix of the bank accounts |
☑ |
|
cash_account_code_prefix |
string |
Prefix of the main cash accounts |
☑ |
|
code_digits |
int32 |
# of Digits |
☑ |
No. of Digits to use for account code |
country_id_label |
string |
|
☐ |
The country this chart of accounts belongs to. None if it's generic. |
country_id |
string |
|
☐ |
The country this chart of accounts belongs to. None if it's generic. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
default_cash_difference_expense_account_id_label |
string |
|
☐ |
|
default_cash_difference_expense_account_id |
string |
|
☐ |
|
default_cash_difference_income_account_id_label |
string |
|
☐ |
|
default_cash_difference_income_account_id |
string |
|
☐ |
|
default_pos_receivable_account_id_label |
string |
|
☐ |
|
default_pos_receivable_account_id |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
expense_currency_exchange_account_id_label |
string |
|
☐ |
|
expense_currency_exchange_account_id |
string |
|
☐ |
|
id |
int32 |
ID |
☐ |
|
income_currency_exchange_account_id_label |
string |
|
☐ |
|
income_currency_exchange_account_id |
string |
|
☐ |
|
name |
string |
Name |
☑ |
|
parent_id_label |
string |
|
☐ |
|
parent_id |
string |
|
☐ |
|
property_account_expense_categ_id_label |
string |
|
☐ |
|
property_account_expense_categ_id |
string |
|
☐ |
|
property_account_expense_id_label |
string |
|
☐ |
|
property_account_expense_id |
string |
|
☐ |
|
property_account_income_categ_id_label |
string |
|
☐ |
|
property_account_income_categ_id |
string |
|
☐ |
|
property_account_income_id_label |
string |
|
☐ |
|
property_account_income_id |
string |
|
☐ |
|
property_account_payable_id_label |
string |
|
☐ |
|
property_account_payable_id |
string |
|
☐ |
|
property_account_receivable_id_label |
string |
|
☐ |
|
property_account_receivable_id |
string |
|
☐ |
|
property_advance_tax_payment_account_id_label |
string |
|
☐ |
|
property_advance_tax_payment_account_id |
string |
|
☐ |
|
property_cash_basis_base_account_id_label |
string |
|
☐ |
Account that will be set on lines created in cash basis journal entry and used to keep track of the tax base amount. |
property_cash_basis_base_account_id |
string |
|
☐ |
Account that will be set on lines created in cash basis journal entry and used to keep track of the tax base amount. |
property_stock_account_input_categ_id_label |
string |
|
☐ |
|
property_stock_account_input_categ_id |
string |
|
☐ |
|
property_stock_account_output_categ_id_label |
string |
|
☐ |
|
property_stock_account_output_categ_id |
string |
|
☐ |
|
property_stock_valuation_account_id_label |
string |
|
☐ |
|
property_stock_valuation_account_id |
string |
|
☐ |
|
property_tax_payable_account_id_label |
string |
|
☐ |
|
property_tax_payable_account_id |
string |
|
☐ |
|
property_tax_receivable_account_id_label |
string |
|
☐ |
|
property_tax_receivable_account_id |
string |
|
☐ |
|
tax_template_ids |
string |
|
☐ |
List of all the taxes that have to be installed by the wizard |
transfer_account_code_prefix |
string |
Prefix of the main transfer accounts |
☑ |
|
use_anglo_saxon |
boolean |
Use Anglo-Saxon accounting |
☐ |
|
use_storno_accounting |
boolean |
Use Storno accounting |
☐ |
|
visible |
boolean |
Can be Visible? |
☐ |
Set this to False if you don't want this template to be used actively in the wizard that generate Chart of Accounts from templates, this is useful when you want to generate accounts of this template only when loading its child template. |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826