reconcile_model: Odoo itgen_odoo_reconcile_model
read only per partition
- Catalogo:
Odoo - Schema:
account - Etichetta: itgen_odoo_reconcile_model
Preset to create journal entries during a invoices and payments matching
È possibile solo recuperare i dati.
Riepilogo
Populate factory part for account.reconcile.model.
Colonne della tabella
Di seguito sono riportate le colonne della tabella reconcile_model. 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 |
|---|---|---|---|---|---|
active |
boolean |
Active | |||
allow_ |
boolean |
Payment Tolerance | Difference accepted in case of underpayment. | ||
auto_ |
boolean |
Auto-validate | Validate the statement line automatically (reconciliation based on your rule). | ||
company_ |
varchar2 |
||||
company_ |
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 | |||
has_ |
boolean |
Has Message | |||
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 | |||
message_ |
int32 |
Numero di allegati | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
name |
varchar2 |
Name | |||
number_ |
int32 |
Number of entries related to this model | |||
partner_ |
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_ |
int32 |
Search Months Limit | Number of months in the past to consider entries from when applying this model. | ||
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 | |||
show_ |
boolean |
Show Decimal Separator | |||
to_ |
boolean |
To Check | This matching rule is used when the user is not certain of all the information of the counterpart. | ||
website_ |
varchar2 |
Website communication history | |||
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: