Comment 11 for bug 1317021

Revision history for this message
Kees van den Broek (kvdb-kvdb) wrote :

@Holger:
If I grep the :86: lines in the .940 file, I can categorize the 'unstructured' data as follows:

* Starting with a space, ING is the other party:

:86: 21-03-14 18:24 BETAALAUTOMAAT
:86: RC AFREK. REK. 15.31.365 EUR

* Starting with an IBAN:

:86:NL05ABNA0411111111 ABNANL2A ABC DEF

* Starting with a prefix, then IBAN:

:86:MD06 NL05ABNA0411111111 ABNANL2A ABC DEF
:86:AC01 NL05ABNA0411111111 ABNANL2A ABC DEF

* Mentioning of incasso, then IBAN:

:86:Europese Incasso, doorlopend NL05ABNA0411111111 ABNANL2A ABC DEF
:86:Zakelijke Europese Incasso, doorlopend NL05ABNA0411111111 ABNANL2

* One last case I can't figure out. It only appears when the preceeding :61: line contains a NONREF. The number shown is the non-IBAN account number of the other party.
:61:140214C90,75NOV NONREF
:86:0110444444 ABC DEF

The corresponding line from the CSV file looks like:
"20140214","OTHER PARTY","153xxxx","0110444444","OV","Bij","90,75","Overschrijving","ABC DEF"
https://bugs.launchpad.net/banking-addons/+bug/1317021/+addcomment
Not sure if this is structure enough to make something out of it. I can imagine the answer is no. That means I'll head back to csv...