{"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":14,"rows_kept":14,"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,"2019-07-30",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,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",null,"Romanel-s-Lausanne",null,null,0,null,"+41 21 633 79 19",null,null,null,"info@promerka.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2019-07-30",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,1,0,1,0,null,0,0,null]
[3,"2",null,"Workplace Solutions","Mrs","Ferrel","Mikka","9435 Waterstone","Blvd. Suite 140-2 Cincinnati","45249",null,"OH",null,null,0,null,"001513.722.5182",null,null,null,"Mikka.Ferrell@workplacesolutionsus.com",null,1,0,0.00,4,0.00,0,0,0,0,true,1,false,"2019-10-04",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,1,0,0,0,null,0,0,null]
[4,"3",null,"Trait pour Trait","Madame","Constantini","Sophie","Rue de l'Arc-en-Ciel 6",null,"1030",null,"Bussigny-Lausanne",null,null,0,null,null,null,"079 646 46 70",null,"info@traitpourtrait.ch",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-02-05",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,1,0,0,0,null,0,0,null]
[5,"4",null,"AC Immune SA","Monsieur","Monin","Jean-Fabien","EPFL Innovation Park","Building B","1015",null,"Lausanne",null,null,0,null,"021 345 91 22",null,"079 411 56 98",null,"jean-fabien.monin@acimmune.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-03-02",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,1,0,0,0,null,0,0,null]
[6,"5",null,"Instadebug Services Informatiques","Monsieur","Cofano","Daniele","Chemin des Glycines 9A",null,"1022",null,"Chavannes-Renens",null,null,0,null,null,null,"078 886 63 45",null,"info@instadebug.ch",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-03-09",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,1,0,0,0,null,0,0,null]
[7,"6",null,"You Talent","Madame","Pagés","Samantha",null,null,null,null,null,null,null,0,null,null,null,"078 611 03 13",null,"sampages77@icloud.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-03-30",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,0,0,0,0,null,0,0,null]
[8,null,null,"Interdiscount",null,null,null,"Bernstrasse 90",null,"3303",null,"Jegenstorf",null,null,0,null,null,null,null,null,null,null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-03-31",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,0,0,0,0,null,0,0,null]
[9,"7",null,"ADV Construction SA","Monsieur","Da Silva","José","Derrière-les- Bois 10",null,"1303",null,"Penthaz",null,null,0,null,"021 862 14 34",null,"079 769 15 97",null,"liberto@advsa.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-03-31",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,1,0,0,0,null,0,0,null]
[10,"8",null,"BOXPLAY SA","Monsieur","Duvoisin","Philippe","En Budron H8b",null,"1052",null,"Mont-sur-Lausanne",null,null,0,null,null,null,"079 870 54 17",null,"info@boxplaysa.ch",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-04-29",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,0,0,0,0,null,0,0,null]
[11,"9",null,"Swisstech Fenster und Türen AG","Monsieur","Rodolfi","Stefano","C/o Executive Office Gmbh","Ruessenstrasse 12","6340",null,"Baar",null,null,0,null,null,null,null,null,null,null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-05-04",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,0,0,0,0,null,0,0,null]
[12,"10",null,null,"Madame","Berisha","Merite","Av. d'Echallens 156",null,"1004",null,"Lausanne",null,null,0,null,null,null,"078 924 05 08",null,"berishaartan@hotmail.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-06-10",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,0,0,0,0,null,0,0,null]
[13,"11",null,"LG Business Creation & Distribution Sàrl","Monsieur","Gros","Laurent","Avenue de Longemalle 9 A",null,"1020",null,"Renens VD",null,null,0,null,null,null,"079 669 19 31",null,"lgros@lgbusiness.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-06-26",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,1,0,0,0,null,0,0,null]
[14,"12",null,"LAS Branding","Monsieur","Schupbach","David","Avenue des Baumettes 9",null,"1020",null,"Renens VD",null,null,0,null,null,null,"079 402 31 01",null,"david@lgbusiness.com",null,1,0,0.00,1,0.00,0,0,0,0,true,1,false,"2020-06-26",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,1,2,1,"1040","2000",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,false,0,0.00,0,"31",1,1,1,null,false,1,null,0,0,0,0,0,0,0,null,0,0,null]