Table use to transform Name field.
| Name | String searched in NAME field. Symbolic strings are :
|
|---|---|
| NameNew | New value for NAME field. Symbolic strings are :
|
| Memo | New value for MEMO field if empty. Symbolic strings are :
|
| TrnType | New value for TRNTYPE field. Symbolic strings are :
|
| Code | Description |
|---|---|
| CREDIT | Credit |
| DEBIT | Debit |
| INT | Interest |
| DIV | Dividende |
| FEE | FEE |
| SRVCHG | Service charge |
| DEP | Deposit |
| ATM | Automate |
| POS | Card |
| XFER | Transfer |
| CHECK | Check |
| PAYMENT | Payment |
| CASH | Cash |
| DIRECTDEP | Direct deposit |
| DIRECTDEBIT | Direct Debit |
| REPEATPMT | Repeat Payment |
| OTHER | Other |
| NAME | NAMENEW | MEMO | TRNTYPE |
|---|---|---|---|
| CHQ. | CREDIT LYONNAIS | %NAME% | CHECK |
| TRESOR PUBLIC | TRESOR PUBLIC | %NAME% | %TRNTYPE% |
| %DEFAULT% | %NAME% | %NAME% | %TRNTYPE% |
If the field MEMO contains "CHQ.", it will be transform to "CREDIT LYONNAIS", the field MEMO (if empty) will be loaded with initial value of NAME field ("CHQ.nnnnnnnnn") and transaction type will be "CHECK".
If the field MEMO contains "TRESOR PUBLIC", it will be transform to "TRESOR PUBLIC", the fields MEMO and TRNTYPE keep there initial value.
In any other case the field MEMO (if empty) will be loaded with initial value of NAME field, the fields MEMO and TRNTYPE keep there initial value.