account |
Account
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 account are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_type |
string |
Type |
☑ |
Account Type is used for information purpose, to generate country-specific legal reports, and set the rules to close a fiscal year and generate opening entries. |
allowed_journal_ids |
string |
|
☐ |
Define in which journals this account can be used. If empty, can be used in all journals. |
asset_model_label |
string |
|
☐ |
If this is selected, an expense/revenue will be created automatically when Journal Items on this account are posted. |
asset_model |
string |
|
☐ |
If this is selected, an expense/revenue will be created automatically when Journal Items on this account are posted. |
asset_type |
string |
Asset Type |
☐ |
|
can_create_asset |
boolean |
Can Create Asset |
☐ |
|
code |
string |
Code |
☑ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
consolidation_account_chart_filtered_ids |
string |
|
☐ |
|
consolidation_account_ids |
string |
|
☐ |
|
consolidation_color |
int32 |
Color |
☐ |
|
create_asset |
string |
Create Asset |
☑ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
Forces all journal items in this account to have a specific currency (i.e. bank journals). If no currency is set, entries can use any currency. |
currency_id |
string |
|
☐ |
Forces all journal items in this account to have a specific currency (i.e. bank journals). If no currency is set, entries can use any currency. |
current_balance |
decimal |
Current Balance |
☐ |
|
deprecated |
boolean |
Deprecated |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
exclude_provision_currency_ids |
string |
|
☐ |
Whether or not we have to make provisions for the selected foreign currencies. |
form_view_ref |
string |
Form View Ref |
☐ |
|
group_id_label |
string |
|
☐ |
Account prefixes can determine account groups. |
group_id |
string |
|
☐ |
Account prefixes can determine account groups. |
has_message |
boolean |
Has Message |
☐ |
|
id |
int32 |
ID |
☐ |
|
include_initial_balance |
boolean |
Bring Accounts Balance Forward |
☐ |
Used in reports to know if we should consider journal items from the beginning of time instead of from the fiscal year only. Account types that should be reset to zero at each new fiscal year (like expenses, revenue..) should not have this option set. |
internal_group |
string |
Internal Group |
☐ |
|
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 |
|
☐ |
|
multiple_assets_per_line |
boolean |
Multiple Assets per Line |
☐ |
Multiple asset items will be generated depending on the bill line quantity instead of 1 global asset. |
name |
string |
Account Name |
☑ |
|
non_trade |
boolean |
Non Trade |
☐ |
If set, this account will belong to Non Trade Receivable/Payable in reports and filters.If not, this account will belong to Trade Receivable/Payable in reports and filters. |
note |
string |
Internal Notes |
☐ |
|
opening_balance |
decimal |
Opening Balance |
☐ |
|
opening_credit |
decimal |
Opening Credit |
☐ |
|
opening_debit |
decimal |
Opening Debit |
☐ |
|
reconcile |
boolean |
Allow Reconciliation |
☐ |
Check this box if this account allows invoices & payments matching of journal items. |
related_taxes_amount |
int32 |
Related Taxes Amount |
☐ |
|
root_id_label |
string |
|
☐ |
|
root_id |
string |
|
☐ |
|
tag_ids |
string |
|
☐ |
Optional tags you may want to assign for custom reporting |
tax_ids |
string |
|
☐ |
|
used |
boolean |
Used |
☐ |
|
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