invantive documentation
Invantive Support ForumsLog In / Sign Up

tax: Odoo itgen_odoo_tax

read only per partition

  • Catalog: Odoo
  • Schema: account
  • Label: itgen_odoo_tax

Tax

Can only retrieve data.

Table Columns

The columns of the table tax 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
active boolean Active Set active to false to hide the tax without removing it.
amount numeric Amount
amount_type varchar2 Tax Computation - Group of Taxes: The tax is a set of sub taxes. - Fixed: The tax amount stays the same whatever the price. - Percentage of Price: The tax amount is a % of the price: e.g 100 * (1 + 10%) = 110 (not price included) e.g 110 / (1 + 10%) = 100 (price included) - Percentage of Price Tax Included: The tax amount is a division of the price: e.g 180 / (1 - 10%) = 200 (not price included) e.g 200 * (1 - 10%) = 180 (price included)
analytic boolean Include in Analytic Cost If set, the amount computed by this tax will be assigned to the same analytic account as the invoice line (if any)
cash_basis_transition_account_id varchar2 Account used to transition the tax amount for cash basis taxes. It will contain the tax amount as long as the original invoice has not been reconciled ; at reconciliation, this amount cancelled on this account and put on the regular tax account.
cash_basis_transition_account_id_label varchar2 Account used to transition the tax amount for cash basis taxes. It will contain the tax amount as long as the original invoice has not been reconciled ; at reconciliation, this amount cancelled on this account and put on the regular tax account.
children_tax_ids varchar2
company_id varchar2
company_id_label varchar2
country_code varchar2 Country Code The ISO country code in two chars. You can use this field for quick search.
country_id varchar2 The country for which this tax is applicable.
country_id_label varchar2 The country for which this tax is applicable.
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
description varchar2 Label on Invoices
display_name varchar2 Display Name
hide_tax_exigibility boolean Hide Use Cash Basis Option
id int32 ID
include_base_amount boolean Affect Base of Subsequent Taxes If set, taxes with a higher sequence than this one will be affected by it, provided they accept it.
invoice_repartition_line_ids varchar2 Distribution when the tax is used on an invoice
is_base_affected boolean Base Affected by Previous Taxes If set, taxes with a lower sequence might affect this one, provided they try to do it.
name varchar2 Tax Name
name_searchable varchar2 Name Searchable This dummy field lets us use another search method on the field 'name'.This allows more freedom on how to search the 'name' compared to 'filter_domain'.See '_search_name' and '_parse_name_search' for why this is not possible with 'filter_domain'.
price_include boolean Included in Price Check this if the price you use on the product and invoices includes this tax.
real_amount numeric Real amount to apply
refund_repartition_line_ids varchar2 Distribution when the tax is used on a refund
sequence int32 Sequence The sequence field is used to define order in which the tax lines are applied.
tax_exigibility varchar2 Tax Exigibility Based on Invoice: the tax is due as soon as the invoice is validated. Based on Payment: the tax is due as soon as the payment of the invoice is received.
tax_group_id varchar2
tax_group_id_label varchar2
tax_scope varchar2 Tax Scope Restrict the use of taxes to a type of product.
type_tax_use varchar2 Tax Type Determines where the tax is selectable. Note : 'None' means a tax can't be used by itself, however it can still be used in a group. 'adjustment' is used to perform tax adjustment.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: