reconcile_model_line |
Rules for the reconciliation model
Catalog: Odoo
Schema: account
Documentation:
Populate factory part for account.reconcile.model.line.
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 reconcile_model_line are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_id_label |
string |
|
☐ |
|
account_id |
string |
|
☐ |
|
allow_payment_tolerance |
boolean |
Payment Tolerance |
☐ |
Difference accepted in case of underpayment. |
amount_string |
string |
Amount |
☑ |
Value for the amount of the writeoff line* Percentage: Percentage of the balance, between 0 and 100.* Fixed: The fixed value of the writeoff. The amount will count as a debit if it is negative, as a credit if it is positive.* From Label: There is no need for regex delimiter, only the regex is needed. For instance if you want to extract the amount fromR:9672938 10/07 AX 9415126318 T:5L:NA BRT: 3358,07 C:You could enterBRT: ([\d,]+) |
amount_type |
string |
Amount Type |
☑ |
|
amount |
decimal |
Float Amount |
☐ |
|
analytic_distribution |
string |
Analytic Distribution |
☐ |
|
analytic_precision |
int32 |
Analytic Precision |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
force_tax_included |
boolean |
Tax Included in Price |
☐ |
Force the tax to be managed as a price included tax. |
id |
int32 |
ID |
☐ |
|
journal_id_label |
string |
|
☐ |
|
journal_id |
string |
|
☐ |
|
label |
string |
Journal Item Label |
☐ |
|
model_id_label |
string |
|
☐ |
|
model_id |
string |
|
☐ |
|
payment_tolerance_param |
decimal |
Gap |
☐ |
The sum of total residual amount propositions matches the statement line amount under this amount/percentage. |
rule_type |
string |
Type |
☐ |
|
sequence |
int32 |
Sequence |
☑ |
|
show_force_tax_included |
boolean |
Show Force Tax Included |
☐ |
|
tax_ids |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826