{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"D1","type":"character","width":240},{"name":"D2","type":"character","width":6},{"name":"D3","type":"character","width":1},{"name":"D4","type":"character","width":1},{"name":"D5","type":"logical","width":1},{"name":"D6","type":"character","width":5},{"name":"D7","type":"character","width":60},{"name":"D8","type":"character","width":80},{"name":"D9","type":"character","width":70},{"name":"D10","type":"character","width":30},{"name":"D11","type":"character","width":10}],"n_rows":25,"rows_kept":25,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_other","reader":"statdb_count/9"}
["FACISODB.DIC+\" \"+FACISODB.ODBERATEL","C55",null,null,false,".AND.","''",null,null,".\\FACISODB.DBF","_RDI110QS6"]
["DATE()-FAKTURYV.DAT_SPLAT","N0300",null,null,false,".AND.","'Dní po spl.'","Doba po splatnosti",null,"FAKTUR\\FAKTURYV.DBF","_REX0VWJTB"]
["FAKTURYV.CASTKA-FAKTURYV.REALIZACE","N1202",null,null,false,".AND.","'Limit çástky'","Limit çástky",null,"FAKTUR\\FAKTURYV.DBF","_REX0Y6FWC"]
["DATE()-SKLAD_PR.DATUM_PR","N0200",null,null,false,".AND.","'pocet dni'",null,null,"SKLAD\\SKLAD_PR.DBF","_RFA0VFFRB"]
["SALDO.NIC","C3",null,null,false,".AND.","' A '","Oznaçení poloĹky, kt. se poęídila aktualizací",null,"UCTO\\SALDO.DBF","_RFD0G1SFC"]
["SUBST(DODAK.OBDOBI,3)","C2",null,null,false,".AND.","''","Obdobi vydání dodacího listu (rok)",null,"FAKTUR\\DODAK.DBF","_RFK0GVZ02"]
["IIF(\"SKLAD_MA\" $ SET(\"RELATION\") AND LEFT(CIS_DOKL,2)=\"SP\", SKLAD_PR.CIL_SKL, SKLAD_PR.CIS_SKLADU)","C3",null,null,false,".AND.","'Sklad'","Sklad i pro pęevodky",null,"SKLAD\\SKLAD_PR.DBF","_RFR0YHNCA"]
["SUBSTR(FAKTURYV.OBDOBI,3)+LEFT(FAKTURYV.OBDOBI,2)","C4",null,null,false,".AND.","'Období'","Pęehozené období",null,"FAKTUR\\FAKTURYV.DBF","_RH30WQJG8"]
["LEFT(FADET.CISLO,3)","C3",null,null,false,".AND.","''","Skupina sortimentu",null,"FAKTUR\\FADET.DBF","_RHA0GRII7"]
["SKLAD.CISLO_MAT","D",null,null,false,".AND.","''",null,"UPPER(&)","SKLAD\\SKLAD.DBF","_RHU0P0C45"]
["CINNOST.SKUPINAJM","C30",null,null,false,".AND.","'Skupina'","Název skupiny",null,"MZDY\\CINNOST.DBF","_RHV0U4UWW"]
["FADET.KS*FADET.CENA_KUS*(1+FADET.PRIPLAT/100)","N1202",null,null,false,".AND.","''","fakturovaná cena po slevł",null,"FAKTUR\\FADET.DBF","_RI40J5DJW"]
["SKLREZZB.MNOZSTVI*IIF(SKLREZZB.PROD_CENBD>=0,SKLREZZB.PROD_CENBD, SKLREZZB.NAKUP_CENA*(1+SKLREZZB.PRIRAZKA/100))*(1+SKLREZZB.SLEVA/100)","N1202",null,null,false,".AND.","'Pr.cena'","Celková cena prodejní cena objednávky",null,"SKLAD\\SKLREZZB.DBF","_RI40VXIHJ"]
["SKLREZZB.REALIZOVAN*IIF(SKLREZZB.PROD_CENBD>=0,SKLREZZB.PROD_CENBD, SKLREZZB.NAKUP_CENA*(1+SKLREZZB.PRIRAZKA/100))*(1+SKLREZZB.SLEVA/100)","N1202",null,null,false,".AND.","'Pr.cena vśdeje'","Celková prodejní cena realizováno objednávky",null,"SKLAD\\SKLREZZB.DBF","_RI40W0O9E"]
["IIF(FADET.V_PROC==\"%\",FADET.KS*FADET.CENA_KUS*(1+FADET.PRIPLAT/100),FADET.KS*FADET.CENA_KUS+FADET.PRIPLAT)","N1202",null,null,false,".AND.","''","Fakturovaná cena po slevł opravena",null,"FAKTUR\\FADET.DBF","_RIF0WG8LM"]
["AMZDY.STR","C006",null,null,false,".AND.","'Stęedisko'","Stęedisko",null,"MZDY\\AMZDY.DBF","_RIS0WUMC9"]
["FAKTURYP.CASTKA-FAKTURYP.SPARC","N1102",null,null,false,".AND.","''","Rozdíl spárování",null,"FAKTUR\\FAKTURYP.DBF","_RHX0U0CXR"]
["FAKTURYP.CASTKA-DODAK.CASTKAB","N1102",null,null,false,".AND.","''","Rozdíl pęíjemky od faktury",null,"FAKTUR\\FAKTURYP.DBF","_RHX0VGY4H"]
["KUR_CAST-KUR_REAL","N1002",null,null,false,".AND.","''","Zbśvá uhradit v devizách (vyd. fak.)",null,"FAKTUR\\FAKTURYV.DBF","_RIS0UJWRH"]
["KUR_CAST-KUR_REAL","N1002",null,null,false,".AND.","''","Zbśvá uhradit v dev. (pęij. fa)",null,"FAKTUR\\FAKTURYP.DBF","_RIS0V0QSM"]
["SUBSTR(DTOC(FAKTURYV.DAT_SPLAT),4)","C6",null,null,false,".AND.","''","Obdobi splatnosti vyd. fak.",null,"FAKTUR\\FAKTURYV.DBF","_RIS0W1E45"]
["SUBSTR(DTOC(FAKTURYP.DAT_SPLAT),3)","C6",null,null,false,".AND.","''","Období splatnosti pęijaté fa",null,"FAKTUR\\FAKTURYP.DBF","_RIS0W6SGW"]
["SUBSTR(MZDNAKL.OBDOBI,3,2)+LEFT(MZDNAKL.OBDOBI,2)","C04",null,null,false,".AND.","'xxx'","otocene obdobi mzdnakl",null,"ZAKAZKY\\MZDNAKL.DBF","_RIU0O4DJ3"]
["BANKA.RAZITKO == \"B\" OR EMPTY(BANKA.VNITRCISL)","L",null,null,false,".AND.","''",null,null,"ABO\\BANKA.DBF","_RHF12V0BI"]
["IIF(BANKA.RAZITKO=\"\",BANKA.KCS,0)","N1202",null,null,false,".AND.","''","Neposláno do banky",null,"ABO\\BANKA.DBF","_RI80NWEDW"]