tax_template |
Templates for Taxes
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 tax_template are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
Set active to false to hide the tax without removing it. |
amount_type |
string |
Tax Computation |
☑ |
|
amount |
decimal |
Amount |
☑ |
|
analytic |
boolean |
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_label |
string |
|
☐ |
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 |
string |
|
☐ |
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. |
chart_template_id_label |
string |
|
☐ |
|
chart_template_id |
string |
|
☐ |
|
children_tax_ids |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
description |
string |
Display on Invoices |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
include_base_amount |
boolean |
Affect 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 |
string |
|
☐ |
Repartition 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 |
string |
Tax Name |
☑ |
|
price_include |
boolean |
Included in Price |
☐ |
Check this if the price you use on the product and invoices includes this tax. |
refund_repartition_line_ids |
string |
|
☐ |
Repartition 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 |
string |
Tax Due |
☐ |
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_label |
string |
|
☐ |
|
tax_group_id |
string |
|
☐ |
|
tax_scope |
string |
Tax Scope |
☐ |
Restrict the use of taxes to a type of product. |
type_tax_use |
string |
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. |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826