invantive documentation
Forum di supporto InvantiveAccedi / Registrati

reconcile_model_template: Odoo itgen_odoo_reconcile_model_template

read only per partition

  • Catalogo: Odoo
  • Schema: account
  • Etichetta: itgen_odoo_reconcile_model_template

Reconcile Model Template

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella reconcile_model_template. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 Creato il
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 Nome visualizzato
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 Tipo di importo 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 Tipo di transazione 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
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
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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: