Bankimport.txt

Jump to: navigation, search

Dit is de inhoud van het voorbeeld bestand 

 "0102852774","EUR",20060701,"D",75.34,"0000000000","Kosten",20060704,"DA","","Periode 01-07-2006 t/m 31-08-2","","","","",""
 "0102852774","EUR",20060701,"D",8.69,"0000000000","Kosten",20060704,"DA","","Periode 01-07-2006 t/m 31-08-2","","","","",""
 "0102852774","EUR",20060706,"D",3000.00,"0351834265","P.J.J.H. VALENTIJN EO",20060705,"TB","","salaris","","","","",""
 "0102852774","EUR",20060710,"D",134.55,"P5416107","Crediteur H",20060709,"TB","","Factuur 200512A","","","","",""
 "0102852774","EUR",20060710,"D",33.32,"P8330186","HOSTING BV",20060710,"MA","","BETALINGSKENM.  35178","35178","2527","EASYHOSTING BV","",""
 "0102852774","EUR",20060719,"C",1017.50,"0350800154","Debiteur jansen",20060713,"BY","","BETALINGSKENM.  RE0060117320179","Wereldbetaling BEN","USD 1.248,53 EUR=1,20789 USD","/RFB/4109467999/OBI/CUSTOMER 416","",""

Velden: 

Veld 1: Van Rekening
Veld 2: "EUR"
Veld 3: Rentedatum als yyyymmdd integer
Veld 4: "D" of "C"
Veld 5: Bedrag als #O.OO
Veld 6: Naar Bankrekening
Veld 7: Naar Bankrekeninghouder
Veld 8: Boekdatum als yyyymmdd integer
Veld 9: Boekcode
Veld 10: Budgetcode
Veld 11: Omschrijving 1
Veld 12: Omschrijving 2
Veld 13: Omschrijving 3
Veld 14: Omschrijving 4
Veld 15: Omschrijving 5
Veld 16: Omschrijving 6

Overgenomen uit http://www.rabobank.nl/images/Kommagescheiden_1615293.pdf

Retrieved from "http://www.osfinancials.org/mediawiki/index.php/Bankimport.txt"
Personal tools