invantive documentation
Invantive Support ForumsLog In / Sign Up

reconcile_model: Odoo itgen_odoo_reconcile_model

read only per partition

  • Catalog: Odoo
  • Schema: account
  • Label: itgen_odoo_reconcile_model

Preset to create journal entries during a invoices and payments matching

Can only retrieve data.

Summary

Populate factory part for account.reconcile.model.

Table Columns

The columns of the table reconcile_model 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
allow_payment_tolerance boolean Payment Tolerance Difference accepted in case of underpayment.
auto_reconcile boolean Auto-validate Validate the statement line automatically (reconciliation based on your rule).
company_id varchar2
company_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
has_message boolean Has Message
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 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
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
name varchar2 Name
number_entries int32 Number of entries related to this model
partner_mapping_line_ids varchar2 The mapping uses regular expressions. - To Match the text at the beginning of the line (in label or notes), simply fill in your text. - To Match the text anywhere (in label or notes), put your text between .* e.g: .N°48748 abc123.
past_months_limit int32 Search Months Limit Number of months in the past to consider entries from when applying this model.
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 The sum of total residual amount propositions and the statement line amount allowed gap type.
rule_type varchar2 Type
sequence int32 Sequence
show_decimal_separator boolean Show Decimal Separator
to_check boolean To Check This matching rule is used when the user is not certain of all the information of the counterpart.
website_message_ids varchar2 Website communication history
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: