{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Lastschriften","Begleitzettel","Definition","Wertelisten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":3,"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":"Lastschriften","index":0,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["DAB BNP Paribas SEPA Lastschriften"]
["Version 3.5",null,null,null,null,null,null,"Aggregiert buchen"]
[]
["Glaeubiger-ID","Lastschriftart","Sequenz","BIC Zahlungspflichtiger","IBAN Zahlungspflichtiger","Purpose Code","BIC Zahlungsempfänger","IBAN Zahlungsempfänger","Betrag mit Komma","Faelligkeitsdatum","Name Zahlungspflichtiger","Name Zahlungsempfänger","Verwendungszweck","End-to-End-ID","Referenz der Einreichung","Mandatsreferenz","Datum Unterschrift"]

{"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"]
["SAMMELEINZUGAUFTRAG FÜR SEPA-LASTSCHRIFTEN"]
[]
["Erstellungsdatum: ","*aktuelles Datum Listenerstellung*",null,null,"X"]
["Postenanzahl:","*Anzahl der Transaktionen*",null,null,"X"]
["Betragssumme EURO:","*Gesamtsumme der Transaktionen*",null,null,"X"]
["Ausführungsdatum: ","*Faelligkeitsdatum*",null,null,"X"]
[]
[]
["AUFGTRAGGEBER"]
["Name:","*Name Zahlungsempfänger*",null,null,"X"]
["Kto/ IBAN:","*IBAN Zahlungsempfänger*",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":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Spalte","Typ","max. Länge","Format","Werteliste","Wert (enthält)","Aggr. Buchen"]
["Glaeubiger-ID","M",35,"Text",null,null,"X"]
["Lastschriftart","M",4,"Text","X"]
["Sequenz","M",4,"Text","X"]
["BIC Zahlungspflichtiger","K","8;11","Text"]
["IBAN Zahlungspflichtiger","M",34,"Text"]
["Purpose Code","K",4,"Text","X"]
["BIC Zahlungsempfänger","K","8;11","Text",null,"DABBDEMMXXX","X"]
["IBAN Zahlungsempfänger","M",34,"Text",null,70120400,"X"]
["Betrag mit Komma","M",13,"Zahl"]
["Faelligkeitsdatum","M",10,"Datum",null,null,"X"]
["Name Zahlungspflichtiger","M",70,"Text"]
["Name Zahlungsempfänger","M",70,"Text",null,null,"X"]
["Verwendungszweck","K",140,"Text"]
["End-to-End-ID","K",35,"Text"]
["Referenz der Einreichung","K",50,"Text",null,null,"X"]
["Mandatsreferenz","M",35,"Text"]
["Datum Unterschrift","M",10,"Datum"]

{"sheet":"Wertelisten","index":3,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Lastschriftart","Sequenz","Vorlaufzeit","Purpose Code","Mandat geändert","Bank Zahlungspflichtiger geaendert","Land GläubigerID","Länge GläubigerID","Land IBAN","Länge IBAN"]
["CORE","FRST",2,"VERW","J","J","DE",18,"BE",16]
["CORE","OOFF",2,"FEES","N","N","AT",18,"BG",22]
["CORE","RCUR",2,null,null,null,"FR",13,"DK",18]
["CORE","FNAL",2,null,null,null,"IT",23,"DE",22]
[null,null,null,null,null,null,"LU",26,"EE",20]
[null,null,null,null,null,null,"NL",19,"FI",18]
[null,null,null,null,null,null,"ES",16,"FR",27]
[null,null,null,null,null,null,"LI",18,"GR",27]
[null,null,null,null,null,null,"CH",18,"GB",22]
[null,null,null,null,null,null,"GB",35,"IE",22]
[null,null,null,null,null,null,null,null,"IS",26]
[null,null,null,null,null,null,null,null,"IT",27]
[null,null,null,null,null,null,null,null,"HR",21]
[null,null,null,null,null,null,null,null,"LV",21]
[null,null,null,null,null,null,null,null,"LI",21]
[null,null,null,null,null,null,null,null,"LT",20]
[null,null,null,null,null,null,null,null,"LU",20]
[null,null,null,null,null,null,null,null,"MT",31]
[null,null,null,null,null,null,null,null,"MC",27]
[null,null,null,null,null,null,null,null,"NL",18]
[null,null,null,null,null,null,null,null,"NO",15]
[null,null,null,null,null,null,null,null,"AT",20]
[null,null,null,null,null,null,null,null,"PL",28]
[null,null,null,null,null,null,null,null,"PT",25]
[null,null,null,null,null,null,null,null,"RO",24]
[null,null,null,null,null,null,null,null,"SM",27]
[null,null,null,null,null,null,null,null,"SE",24]
[null,null,null,null,null,null,null,null,"CH",21]
[null,null,null,null,null,null,null,null,"SK",24]
[null,null,null,null,null,null,null,null,"SI",19]
[null,null,null,null,null,null,null,null,"ES",24]
[null,null,null,null,null,null,null,null,"CZ",24]
[null,null,null,null,null,null,null,null,"HU",28]
[null,null,null,null,null,null,null,null,"CY",28]