{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Überweisungen","Begleitzettel","Definition","Wertelisten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Überweisungen","index":0,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["DAB BNP Paribas SEPA Überweisungen"]
["Version 3.5",null,null,null,null,null,null,"Aggregiert buchen"]
[]
["BIC Zahlungsempfänger","IBAN Zahlungsempfänger","Purpose Code","BIC Zahlungspflichtiger","IBAN Zahlungspflichtiger","Betrag mit Komma","Name Zahlungsempfaenger","Name Auftraggeber","Verwendungszweck","Ausführungstag","End-to-End-Id","Referenz der Einreichung"]

{"sheet":"Begleitzettel","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[3,0,3,1],[25,0,25,1],[31,0,31,1]]}
["B e g l e i t z e t t e l"]
[null,null,null,null,"Hinweise:"]
["BELEGLOSER DATENTRAEGERAUSTAUSCH",null,null,null,"Folgende mit \"X\" gekennzeichneten Zeilen werden bei einer erfolgreichen Datenprüfung automatisch befüllt"]
["SAMMELÜBERWEISUNGSAUFTRAG FÜR SEPA-ÜBERWEISUNGEN"]
[]
["Erstellungsdatum: ","*aktuelles Datum Listenerstellung*",null,null,"X"]
["Postenanzahl:","*Anzahl der Transaktionen*",null,null,"X"]
["Betragssumme EURO:","*Gesamtsumme der Transaktionen*",null,null,"X"]
["Ausführungsdatum: ","*Ausführungstag*",null,null,"X"]
[]
[]
["AUFGTRAGGEBER"]
["Name:","*Name Auftraggeber*",null,null,"X"]
["Kto/ IBAN:","*IBAN Zahlungspflichtiger*",null,null,"X"]
["BLZ/BIC: ","*70120400/DABBDEMMXXX*",null,null,"X"]
[]
[]
[]
["Ort/ Datum:"]
[]
[]
[]
[]
[]
[]
["Name und Unterschrift des Kontobevollmächtigten"]
[]
[]
[]
[]
[]
["Firmenstempel"]

{"sheet":"Definition","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Spalte","Typ","max. Länge","Format","Werteliste","Wert (enthält)","Aggr. Buchen"]
["BIC Zahlungsempfänger","K","8;11","Text"]
["IBAN Zahlungsempfänger","M",34,"Text"]
["Purpose Code","K",null,"Text","X"]
["BIC Zahlungspflichtiger","K","8;11","Text",null,"DABBDEMMXXX","X"]
["IBAN Zahlungspflichtiger","M",34,"Text",null,70120400,"X"]
["Betrag mit Komma","M",13,"Zahl"]
["Name Zahlungsempfaenger","M",70,"Text"]
["Name Auftraggeber","M",70,"Text",null,null,"X"]
["Verwendungszweck","K",140,"Text"]
["Ausführungstag","M",10,"Datum",null,null,"X"]
["End-to-End-Id","K",null,"Text"]
["Referenz der Einreichung","K",null,"Text",null,null,"X"]

{"sheet":"Wertelisten","index":3,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Purpose Code","Bezeichnung","Land IBAN","Länge IBAN"]
["CBFF","Vermögenswirksame Leistung","BE",16]
["SALA","Lohn/Gehaltszahlung","BG",22]
["PAYR","Lohn/Gehaltszahlung","DK",18]
[null,null,"DE",22]
[null,null,"EE",20]
[null,null,"FI",18]
[null,null,"FR",27]
[null,null,"GR",27]
[null,null,"GB",22]
[null,null,"IE",22]
[null,null,"IS",26]
[null,null,"IT",27]
[null,null,"HR",21]
[null,null,"LV",21]
[null,null,"LI",21]
[null,null,"LT",20]
[null,null,"LU",20]
[null,null,"MT",31]
[null,null,"MC",27]
[null,null,"NL",18]
[null,null,"NO",15]
[null,null,"AT",20]
[null,null,"PL",28]
[null,null,"PT",25]
[null,null,"RO",24]
[null,null,"SM",27]
[null,null,"SE",24]
[null,null,"CH",21]
[null,null,"SK",24]
[null,null,"SI",19]
[null,null,"ES",24]
[null,null,"CZ",24]
[null,null,"HU",28]
[null,null,"CY",28]