---
title: "reconcile_model_template (Odoo)"
description: "itgen_odoo_reconcile_model_template"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.account.reconcile_model_template
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.account.reconcile_model_template
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# reconcile_model_template: Odoo itgen_odoo_reconcile_model_template

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `account`
- Label: itgen_odoo_reconcile_model_template

Reconcile Model Template

Can only retrieve data.

## Table Columns

The columns of the table `reconcile_model_template` 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 |
|---|---|---|:---:|---|---|
| `allow_payment_tolerance` | `boolean` | Allow Payment Gap | [ ] |  | Difference accepted in case of underpayment. |
| `auto_reconcile` | `boolean` | Auto-validate | [ ] |  | Validate the statement line automatically (reconciliation based on your rule). |
| `chart_template_id` | `varchar2` |  | [ ] |  |  |
| `chart_template_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `decimal_separator` | `varchar2` | Decimal Separator | [ ] |  | Every character that is nor a digit nor this separator will be removed from the matching string |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `line_ids` | `varchar2` |  | [ ] |  |  |
| `match_amount` | `varchar2` | Amount Condition | [ ] |  | The reconciliation model will only be applied when the amount being lower than, greater than or between specified amount(s). |
| `match_amount_max` | `numeric` | Amount Max Parameter | [ ] |  |  |
| `match_amount_min` | `numeric` | Amount Min Parameter | [ ] |  |  |
| `match_journal_ids` | `varchar2` |  | [ ] |  | The reconciliation model will only be available from the selected journals. |
| `match_label` | `varchar2` | Label | [ ] |  | The reconciliation model will only be applied when the label:         * Contains: The proposition label must contains this string (case insensitive).         * Not Contains: Negation of "Contains".         * Match Regex: Define your own regular expression. |
| `match_label_param` | `varchar2` | Label Parameter | [ ] |  |  |
| `match_nature` | `varchar2` | Amount Type | [x] |  | The reconciliation model will only be applied to the selected transaction type:         * Amount Received: Only applied when receiving an amount.         * Amount Paid: Only applied when paying an amount.         * Amount Paid/Received: Applied in both cases. |
| `match_note` | `varchar2` | Note | [ ] |  | The reconciliation model will only be applied when the note:         * Contains: The proposition note must contains this string (case insensitive).         * Not Contains: Negation of "Contains".         * Match Regex: Define your own regular expression. |
| `match_note_param` | `varchar2` | Note Parameter | [ ] |  |  |
| `match_partner` | `boolean` | Partner Is Set | [ ] |  | The reconciliation model will only be applied when a customer/vendor is set. |
| `match_partner_category_ids` | `varchar2` |  | [ ] |  | The reconciliation model will only be applied to the selected customer/vendor categories. |
| `match_partner_ids` | `varchar2` |  | [ ] |  | The reconciliation model will only be applied to the selected customers/vendors. |
| `match_same_currency` | `boolean` | Same Currency | [ ] |  | Restrict to propositions having the same currency as the statement line. |
| `match_text_location_label` | `boolean` | Match Text Location Label | [ ] |  | Search in the Statement's Label to find the Invoice/Payment's reference |
| `match_text_location_note` | `boolean` | Match Text Location Note | [ ] |  | Search in the Statement's Note to find the Invoice/Payment's reference |
| `match_text_location_reference` | `boolean` | Match Text Location Reference | [ ] |  | Search in the Statement's Reference to find the Invoice/Payment's reference |
| `match_transaction_type` | `varchar2` | Transaction Type | [ ] |  | The reconciliation model will only be applied when the transaction type:         * Contains: The proposition transaction type must contains this string (case insensitive).         * Not Contains: Negation of "Contains".         * Match Regex: Define your own regular expression. |
| `match_transaction_type_param` | `varchar2` | Transaction Type Parameter | [ ] |  |  |
| `matching_order` | `varchar2` | Matching Order | [ ] |  |  |
| `name` | `varchar2` | Button Label | [x] |  |  |
| `payment_tolerance_param` | `numeric` | Gap | [ ] |  | The sum of total residual amount propositions matches the statement line amount under this amount/percentage. |
| `payment_tolerance_type` | `varchar2` | Payment Tolerance Type | [x] |  | The sum of total residual amount propositions and the statement line amount allowed gap type. |
| `rule_type` | `varchar2` | Type | [x] |  |  |
| `sequence` | `int32` | Sequence | [x] |  |  |
| `to_check` | `boolean` | To Check | [ ] |  | This matching rule is used when the user is not certain of all the information of the counterpart. |
| `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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

