{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"AD_NUMERO","type":"number","width":10,"decimals":0},{"name":"AD_CODE","type":"character","width":15},{"name":"AD_TITRE","type":"character","width":30},{"name":"AD_SOCIETE","type":"character","width":60},{"name":"AD_TITRE2","type":"character","width":30},{"name":"AD_NOM","type":"character","width":30},{"name":"AD_PRENOM","type":"character","width":30},{"name":"AD_RUE_1","type":"character","width":40},{"name":"AD_RUE_2","type":"character","width":40},{"name":"AD_NPA","type":"character","width":10},{"name":"AD_CODPAYS","type":"character","width":4},{"name":"AD_VILLE","type":"character","width":40},{"name":"AD_PAYS","type":"character","width":40},{"name":"AD_ADR2","type":"memo","width":10,"read":false},{"name":"AD_CODPOLI","type":"number","width":3,"decimals":0},{"name":"AD_TXTPOLI","type":"character","width":30},{"name":"AD_TEL1","type":"character","width":20},{"name":"AD_TEL2","type":"character","width":20},{"name":"AD_TEL3","type":"character","width":20},{"name":"AD_TEL4","type":"character","width":20},{"name":"AD_EMAIL","type":"character","width":60},{"name":"AD_URL","type":"character","width":250},{"name":"AD_RABTYP","type":"number","width":1,"decimals":0},{"name":"AD_RABGRP","type":"number","width":4,"decimals":0},{"name":"AD_RABTX","type":"number","width":5,"decimals":2},{"name":"AD_LANGUE","type":"number","width":1,"decimals":0},{"name":"AD_LIMCRD","type":"number","width":15,"decimals":2},{"name":"AD_VENDEUR","type":"number","width":10,"decimals":0},{"name":"AD_REGION","type":"number","width":4,"decimals":0},{"name":"AD_GROUPE","type":"number","width":4,"decimals":0},{"name":"AD_EXPEDIT","type":"number","width":4,"decimals":0},{"name":"AD_RAPPEL","type":"logical","width":1},{"name":"AD_TBLPRIX","type":"number","width":2,"decimals":0},{"name":"AD_DEBBLOC","type":"logical","width":1},{"name":"AD_DATECRE","type":"date","width":8},{"name":"AD_NAISSAN","type":"date","width":8},{"name":"AD_LAST_C","type":"date","width":8},{"name":"AD_NEXT_C","type":"date","width":8},{"name":"AD_LIBELLE","type":"character","width":20},{"name":"AD_MONNAI","type":"number","width":10,"decimals":0},{"name":"AD_TVANO","type":"character","width":20},{"name":"AD_CLEARIN","type":"character","width":5},{"name":"AD_CCP","type":"character","width":15},{"name":"AD_ADHERCP","type":"character","width":15},{"name":"AD_CPTBANQ","type":"character","width":30},{"name":"AD_BANNOM","type":"character","width":30},{"name":"AD_BANRUE","type":"character","width":30},{"name":"AD_BANNPA","type":"character","width":10},{"name":"AD_BANVILL","type":"character","width":40},{"name":"AD_BANCCP","type":"character","width":15},{"name":"AD_BANCCP2","type":"character","width":10},{"name":"AD_MOD_PMT","type":"number","width":2,"decimals":0},{"name":"AD_ADHEREN","type":"character","width":15},{"name":"AD_TVAGEST","type":"number","width":1,"decimals":0},{"name":"AD_BAN_PAY","type":"number","width":4,"decimals":0},{"name":"AD_PMT_TYP","type":"number","width":1,"decimals":0},{"name":"AD_CPT_DEB","type":"character","width":12},{"name":"AD_CPT_CRE","type":"character","width":12},{"name":"AD_FNCLINO","type":"character","width":20},{"name":"AD_CNDPMT1","type":"number","width":4,"decimals":0},{"name":"AD_CNDPMT2","type":"number","width":4,"decimals":0},{"name":"AD_CODBAR","type":"character","width":20},{"name":"AD_UTILIS1","type":"character","width":40},{"name":"AD_UTILIS2","type":"character","width":40},{"name":"AD_UTILIS3","type":"character","width":40},{"name":"AD_UTILIS4","type":"character","width":40},{"name":"AD_UTILIS5","type":"character","width":40},{"name":"AD_UTILIS6","type":"character","width":40},{"name":"AD_UTILIS7","type":"character","width":40},{"name":"AD_UTILIS8","type":"character","width":40},{"name":"AD_UTILIS9","type":"character","width":40},{"name":"AD_UTILI10","type":"character","width":40},{"name":"AD_TEXTE","type":"memo","width":10,"read":false},{"name":"AD_TEXTE1","type":"memo","width":10,"read":false},{"name":"AD_TXTACT","type":"number","width":1,"decimals":0},{"name":"AD_IS_VNDR","type":"logical","width":1},{"name":"AD_COMMETH","type":"number","width":1,"decimals":0},{"name":"AD_COMTAUX","type":"number","width":6,"decimals":2},{"name":"AD_COMSYS","type":"number","width":10,"decimals":0},{"name":"AD_BVR","type":"character","width":2},{"name":"AD_DOCPRES","type":"number","width":6,"decimals":0},{"name":"AD_PRTCODE","type":"number","width":1,"decimals":0},{"name":"AD_FACTMET","type":"number","width":1,"decimals":0},{"name":"AD_MODELE","type":"character","width":30},{"name":"AD_SELECT","type":"logical","width":1},{"name":"AD_ESCMETH","type":"number","width":1,"decimals":0},{"name":"AD_CRETXT","type":"memo","width":10,"read":false},{"name":"AD_CREMCPT","type":"number","width":6,"decimals":0},{"name":"AD_USRID","type":"number","width":10,"decimals":0},{"name":"AD_DOCMAIL","type":"number","width":1,"decimals":0},{"name":"AD_INVPER","type":"number","width":2,"decimals":0},{"name":"AD_TXTFMT","type":"number","width":10,"decimals":0},{"name":"AD_TVAGES1","type":"number","width":1,"decimals":0},{"name":"AD_PARTNER","type":"number","width":10,"decimals":0},{"name":"AD_FCT","type":"character","width":60},{"name":"AD_TVATYPD","type":"number","width":10,"decimals":0},{"name":"AD_TVATYPC","type":"number","width":10,"decimals":0},{"name":"AD_GLN","type":"character","width":15}],"n_rows":4,"rows_kept":4,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"foxpro_two","encoding_class":"enc_single_byte","reader":"statdb_count/9"}
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,1,0,0.00,0,0.00,0,0,0,0,true,1,false,"2024-03-08",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1100","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",null,1,1,"Normal",false,1,null,0,0,0,0,0,0,0,null,0,0,null]
[2,"1",null,"PROMERKA SA",null,null,null,"Chemin de Cousson 23",null,"1032","CH","Romanel-s-Lausanne","Suisse",null,0,null,null,null,null,null,null,null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2024-03-08",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1100","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,1,false,1,0.00,0,"23",1,1,1,null,false,1,null,0,0,0,1,0,1,0,null,0,0,null]
[3,"2",null,null,"Monsieur","Da Costa Fernandes","Rui Miguel","Chemin des Lentillères 13 D",null,"1023",null,"Crissier",null,null,0,null,null,null,"078 621 91 30",null,"rui_miguel17@hotmail.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2024-03-08",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1100","2000",null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"23",1,1,1,null,false,1,null,0,0,0,0,0,1,0,null,0,0,null]
[4,"3",null,"AK Sols Sàrl",null,null,null,"C/o Julien Kaiser","Chemin de la Pouponnière 12","1815",null,"Clarens",null,null,0,null,null,null,null,null,null,null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2024-06-21",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1100","2000",null,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"23",1,1,1,null,false,1,null,0,0,0,1,0,0,0,null,0,0,null]