account: Odoo itgen_odoo_account
read only per partition
- Catalog:
Odoo - Schema:
account - Label: itgen_odoo_account
Account
Can only retrieve data.
Table Columns
The columns of the table account are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
account_ |
varchar2 |
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_ |
varchar2 |
Define in which journals this account can be used. If empty, can be used in all journals. | |||
asset_ |
varchar2 |
If this is selected, an expense/revenue will be created automatically when Journal Items on this account are posted. | |||
asset_ |
varchar2 |
If this is selected, an expense/revenue will be created automatically when Journal Items on this account are posted. | |||
asset_ |
varchar2 |
Asset Type | |||
can_ |
boolean |
Can Create Asset | |||
code |
varchar2 |
Code | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
consolidation_ |
varchar2 |
||||
consolidation_ |
varchar2 |
||||
consolidation_ |
int32 |
Color | |||
create_ |
varchar2 |
Create Asset | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
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_ |
varchar2 |
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_ |
numeric |
Current Balance | |||
deprecated |
boolean |
Deprecated | |||
display_ |
varchar2 |
Display Name | |||
exclude_ |
varchar2 |
Whether or not we have to make provisions for the selected foreign currencies. | |||
form_ |
varchar2 |
Form View Ref | |||
group_ |
varchar2 |
Account prefixes can determine account groups. | |||
group_ |
varchar2 |
Account prefixes can determine account groups. | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
include_ |
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_ |
varchar2 |
Internal Group | |||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
multiple_ |
boolean |
Multiple Assets per Line | Multiple asset items will be generated depending on the bill line quantity instead of 1 global asset. | ||
name |
varchar2 |
Account Name | |||
non_ |
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 |
varchar2 |
Internal Notes | |||
opening_ |
numeric |
Opening Balance | |||
opening_ |
numeric |
Opening Credit | |||
opening_ |
numeric |
Opening Debit | |||
reconcile |
boolean |
Allow Reconciliation | Check this box if this account allows invoices & payments matching of journal items. | ||
related_ |
int32 |
Related Taxes Amount | |||
root_ |
varchar2 |
||||
root_ |
varchar2 |
||||
tag_ |
varchar2 |
Optional tags you may want to assign for custom reporting | |||
tax_ |
varchar2 |
||||
used |
boolean |
Used | |||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: