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_ |
boolean |
Allow Payment Gap | Difference accepted in case of underpayment. | ||
auto_ |
boolean |
Auto-validate | Validate the statement line automatically (reconciliation based on your rule). | ||
chart_ |
varchar2 |
||||
chart_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
decimal_ |
varchar2 |
Decimal Separator | Every character that is nor a digit nor this separator will be removed from the matching string | ||
display_ |
varchar2 |
Nome visualizzato | |||
id |
int32 |
ID | |||
line_ |
varchar2 |
||||
match_ |
varchar2 |
Amount Condition | The reconciliation model will only be applied when the amount being lower than, greater than or between specified amount(s). | ||
match_ |
numeric |
Amount Max Parameter | |||
match_ |
numeric |
Amount Min Parameter | |||
match_ |
varchar2 |
The reconciliation model will only be available from the selected journals. | |||
match_ |
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_ |
varchar2 |
Label Parameter | |||
match_ |
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_ |
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_ |
varchar2 |
Note Parameter | |||
match_ |
boolean |
Partner Is Set | The reconciliation model will only be applied when a customer/vendor is set. | ||
match_ |
varchar2 |
The reconciliation model will only be applied to the selected customer/vendor categories. | |||
match_ |
varchar2 |
The reconciliation model will only be applied to the selected customers/vendors. | |||
match_ |
boolean |
Same Currency | Restrict to propositions having the same currency as the statement line. | ||
match_ |
boolean |
Match Text Location Label | Search in the Statement's Label to find the Invoice/Payment's reference | ||
match_ |
boolean |
Match Text Location Note | Search in the Statement's Note to find the Invoice/Payment's reference | ||
match_ |
boolean |
Match Text Location Reference | Search in the Statement's Reference to find the Invoice/Payment's reference | ||
match_ |
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_ |
varchar2 |
Transaction Type Parameter | |||
matching_ |
varchar2 |
Matching Order | |||
name |
varchar2 |
Button Label | |||
payment_ |
numeric |
Gap | The sum of total residual amount propositions matches the statement line amount under this amount/percentage. | ||
payment_ |
varchar2 |
Payment Tolerance Type | The sum of total residual amount propositions and the statement line amount allowed gap type. | ||
rule_ |
varchar2 |
Type | |||
sequence |
int32 |
Sequence | |||
to_ |
boolean |
To Check | This matching rule is used when the user is not certain of all the information of the counterpart. | ||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: