{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"BEZ","type":"character","width":30},{"name":"PROG1","type":"character","width":8},{"name":"PROG2","type":"character","width":8},{"name":"OBEN","type":"character","width":78},{"name":"ZEILE","type":"character","width":120},{"name":"LSUMME","type":"character","width":40},{"name":"AUSGABE","type":"character","width":254},{"name":"DRUCKZEIL","type":"character","width":254},{"name":"DRUCKAUS","type":"character","width":254},{"name":"FLD1","type":"character","width":10},{"name":"SUCH1","type":"character","width":5},{"name":"TEXT1","type":"character","width":15},{"name":"FLD2","type":"character","width":10},{"name":"SUCH2","type":"character","width":5},{"name":"TEXT2","type":"character","width":15},{"name":"FLD3","type":"character","width":10},{"name":"SUCH3","type":"character","width":5},{"name":"TEXT3","type":"character","width":15},{"name":"FLD4","type":"character","width":10},{"name":"SUCH4","type":"character","width":5},{"name":"TEXT4","type":"character","width":15},{"name":"DATEI1","type":"character","width":8},{"name":"SORTIER","type":"character","width":1},{"name":"INDEX1","type":"character","width":8},{"name":"ETDRUCK","type":"logical","width":1}],"n_rows":15,"rows_kept":15,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
["Kundenumsatz","liste",null,"Kundenumsatz","Name               PLZ    Ort                       Gesamt-Umsatz          Saldo","msumme+kumsatz","substr(name,1,18)+\" \"+plz+\" \"+substr(ort,1,15)+\"           \"+str(kumsatz,13,2)+\"  \"+str(kusaldo,13,2)","Name                      PLZ    Ort                               Umsatz/Gesamt             Saldo","name+\" \"+plz+\" \"+ort+\"         \"+str(kumsatz,13,2)+\"     \"+str(kusaldo,13,2)","NAME","L","Name","ort","L","Ort","kumsatz","13.2","Gesamtumsatz","plz","L","PLZ","kunden1","N","ku1na1",false]
["Kunden1","liste","klabel","Kundenliste","Name                 PLZ    Ort               Strasse         Telefon",null,"substr(name,1,20)+\" \"+plz+\" \"+substr(ort,1,17)+\" \"+substr(strasse,1,15)+\" \"+substr(telefon,1,18)","Name                      PLZ    Ort                       Strasse                   Telefon","name+\" \"+plz+\" \"+ort+\" \"+strasse+\" \"+telefon","NAME","L","Name","KUNDNR","L","Kundennummer","plz","L","PLZ","kennz","L","Kennziffer","kunden1","N","ku1na1",true]
["Artikel1","liste","alabel","Artikelliste","Artikelnummer  WG  Bezeichnung                         VK-Preis  USt-Satz",null,"artnr+\"     \"+wg+\"  \"+artbez+\"      \"+str(vkpreis1,8,2)+\"         \"+mwstsatz","Artikelnummer   WG   Bezeichnung                            VK-Preis    USt-Satz","artnr+\"      \"+wg+\"   \"+artbez+\"         \"+str(vkpreis1,8,2)+\"           \"+mwstsatz","ARTNR","L","Artikelnummer","WG","L","Warengruppe","artbez","L","Bezeichnung","vkpreis1","10.4","VK-Preis 1","artikel","N","artarnr",true]
["Artikelpreise","dienst60",null,"Artikelpreisänderung","Artikelnummer  WG  Bezeichnung                         VK-Preis  USt-Satz",null,"artnr+\"     \"+wg+\"  \"+artbez+\"      \"+str(vkpreis1,8,2)+\"         \"+mwstsatz",null,null,"artnr","l","Artikelnummer","wg","l","Warengruppe","artbez","l","Bezeichnung","vkpreis1","8.2","VK-Preis 1","artikel","N","artarnr",false]
["Lieferanten1","liste",null,"Lieferantenliste","Name                 PLZ    Ort               Strasse         Telefon",null,"substr(name,1,20)+\" \"+plz+\" \"+substr(ort,1,17)+\" \"+substr(strasse,1,15)+\" \"+substr(telefon,1,18)","Name                      PLZ    Ort                       Strasse                   Telefon","name+\" \"+plz+\" \"+ort+\" \"+strasse+\" \"+telefon","name","L","Name","telefon","L","Telefon","plz","L","PLZ","ort","L","Ort","Liefer1","N","li1na1",false]
["Artikelumsatz","liste",null,"Netto-Artikelumsatz","Artikelnummer WG Bezeichnung                    EK-Preis  VK-Preis    Gesamtums.","msumme+arumsatz","artnr+\"    \"+wg+\" \"+artbez+\" \"+str(ekpreis,8,2)+\"  \"+str(vkpreis1,8,2)+\"  \"+str(arumsatz,12,2)","Artikelnummer   WG   Bezeichnung                               EK-Preis  VK-Preis        Umsatz/Gesamt","artnr+\"      \"+wg+\"   \"+artbez+\"            \"+str(ekpreis,8,2)+\"  \"+str(vkpreis1,8,2)+\"         \"+str(arumsatz,12,2)","ARTNR","L","Artikelnummer","wg","L","Warengruppe","artbez","L","Bezeichnung","arumsatz","12.2","Gesamtumsatz","artikel","N","artarnr",false]
["Artikel2","artper",null,"Artikelumsatz:","Artikelnummer WG Bezeichnung                    EK-Preis  VK-Preis   Gesamt-Ums.","msumme+mgesumsatz","artnr+\"    \"+wg+\" \"+artbez+\" \"+str(ekpreis,8,2)+\"  \"+str(vkpreis1,8,2)+\"  \"+str(arumsatz,12,2)","Art. Nr.    WG   Bezeichnung                          Umsatz/Gesamt      Umsatz/Periode      Anzahl","martnr+\"  \"+mwg+\"   \"+martbez+\"       \"+str(mgesumsatz,13,2)+\"       \"+str(summe,13,2)+\"  \"+str(teile,10,1)","ARTNR","L","Artikelnummer","wg","L","Warengruppe","artbez","L","Bezeichnung","arumsatz","12.2","Gesamtumsatz","artikel","N","artarnr",false]
["Kunden2","kunper",null,"Kundenumsatz:","Name               PLZ    Ort                       Gesamt-Umsatz          Saldo","msumme+mkumsatz","substr(name,1,18)+\" \"+plz+\" \"+substr(ort,1,15)+\"           \"+str(kumsatz,13,2)+\"  \"+str(kusaldo,13,2)","Name                      PLZ    Ort                               Umsatz/Gesamt     Umsatz/Periode","mname+\" \"+mplz+\" \"+mort+\"         \"+str(mkumsatz,13,2)+\"      \"+str(summe,13,2)","NAME","L","Name","kundnr","L","Kundennummer","kumsatz","13.2","Gesamtumsatz","kusaldo","13.2","Kundensaldo","kunden1","N","ku1na1",false]
["Lager",null,null,"Lagerbestand",null,null,"msumme+(mlagerwert/mpeinheit)","if(meinzel=\"G\",\"Lager  \",\"\")+\"Art. Nr.   Bezeichnung                    Datum    Bemerkung                       Bestand     Lagerwert\"","if(meinzel=\"G\",lagernr+\"     \",\"\")+martnr+\" \"+martbez+\" \"+datum+\" \"+bemerkung+\" \"+str(bestand,9,2)+\" \"+if(malle=\"A\",\"         -.--\",str(mlagerwert/mpeinheit,13,2))",null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,false]
["Bestellung",null,null,"Bestellvorschläge",null,null,"msumme+(mbestwert/mpeinheit)","if(meinzel=\"G\",\"Lager  \",\"\")+\"Art. Nr.   Bezeichnung                    Datum    Mindestbestand     Bestand      Saldo    Bestellwert\"","if(meinzel=\"G\",lagernr+\"     \",\"\")+martnr+\" \"+martbez+\" \"+datum+\"         \"+str(mmindest,6,0)+\"   \"+str(bestand,9,2)+\"  \"+str(msaldo,9,2)+\"  \"+str(mbestwert/mpeinheit,13,2)",null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,false]
["Auftrag",null,null,"Auftragsliste",null,null,"msumme+endpreis","\"Status Auf.Nr.     Rech.Nr.              Bezeichnung           Kundenname                 Datum   Rechnungsbetrag\"","aufstat+\"     \"+aufnr+\"  \"+recnr+\"  \"+aufbez+\"  \"+name+\"  \"+recdat+\"  \"+str(endpreis,13,2)",null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,false]
["OP-Liste",null,null,"OP-Liste",null,null,"msumme+(endpreis-bezsumme)","\"Auf.Nr.     Rech.Nr.              Bezeichnung           Kundenname                 Datum    Offener Betrag  Status\"","aufnr+\"  \"+recnr+\"  \"+aufbez+\"  \"+name+\"  \"+recdat+\"  \"+str(endpreis-bezsumme,13,2)+\"      \"+aufstat",null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,false]
["RE-Journal",null,null,"Rechnungsjournal",null,null,"msumme+(endpreis*raufrunter)","\"Auf.Nr.     Rech.Nr.              Bezeichnung           Kundenname                 Datum             Betrag  Status\"","aufnr+\"  \"+recnr+\"  \"+aufbez+\"  \"+name+\"  \"+recdat+\"  \"+str(endpreis*raufrunter,14,2)+\"      \"+aufstat",null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,false]
["Ertrag",null,null,"Ertragsliste",null,null,"msumme+if(!empty(recnr),mertrag,0)","\"Status Auf.Nr.     Rech.Nr.              Bezeichnung           Kundenname                 Datum      Ertrag % USt\"","aufstat+\"     \"+aufnr+\"  \"+recnr+\"  \"+aufbez+\"  \"+name+\"  \"+recdat+\"  \"+if(!empty(recnr),str(mertrag,13,2),space(13))",null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,false]
["Mahnlauf",null,null,"Mahnlauf / Kundenkonto",null,null,"msumme+(endpreis-bezsumme)","\"Auf.Nr.     Rech.Nr.              Bezeichnung           Datum      Gesamtbetrag   Offener Betrag  Status\"","aufnr+\"  \"+recnr+\"  \"+aufbez+\"  \"+recdat+\"  \"+str(endpreis,13,2)+\"    \"+str(endpreis-bezsumme,13,2)+\"      \"+aufstat",null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,false]