{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Client","Fournisseur","Format Import Tiers","Données"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":45,"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":"Client","index":0,"n_rows":80,"n_cols":3,"rows_kept":80,"cut":false,"hidden":false,"merged":[[46,0,46,1],[57,0,57,1],[0,0,0,1],[1,0,1,1],[8,0,8,1],[23,0,23,1],[38,0,38,1]]}
["FICHE D'OUVERTURE DE COMPTE\nCLIENT",null,"Vérification données\nv14"]
["GENERAL"]
["Raison sociale",null,{"$f":"IF(LEN(B3)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["N° de SIRET"]
["Code APE ou NAF"]
["N° de TVA°. (1)",null,{"$f":"IF(AND(OR(B17=\"BE\",B17=\"DK\",B17=\"DE\",B17=\"EL\",B17=\"ES\",B17=\"FR\",B17=\"IE\",B17=\"IT\",B17=\"LU\",B17=\"NL\",B17=\"AT\",B17=\"PT\",B17=\"FI\",B17=\"SE\",B17=\"GB\",B17=\"CY\",B17=\"CZ\",B17=\"EE\",B17=\"LV\",B17=\"LT\",B17=\"HU\",B17=\"MT\",B17=\"PL\",B17=\"SI\",B17=\"SK\",B17=\"BG\",B17=\"RO\",B17=\"HR\"),LEN(B6)=0),\"Champ OBLIGATOIRE pour l' UE\",IF(OR(OR(B17=\"BE\",B17=\"DK\",B17=\"DE\",B17=\"EL\",B17=\"ES\",B17=\"FR\",B17=\"IE\",B17=\"IT\",B17=\"LU\",B17=\"NL\",B17=\"AT\",B17=\"PT\",B17=\"FI\",B17=\"SE\",B17=\"GB\",B17=\"CY\",B17=\"CZ\",B17=\"EE\",B17=\"LV\",B17=\"LT\",B17=\"HU\",B17=\"MT\",B17=\"PL\",B17=\"SI\",B17=\"SK\",B17=\"BG\",B17=\"RO\",B17=\"HR\"),LEN(B6)=0),\"OK\",\"Vider la cellule\"))","v":"Champ OBLIGATOIRE pour l' UE"}]
["site web "]
["Langue","fr_FR",{"$f":"IF(LEN(B8)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["ADRESSE DE LIVRAISON"]
["Nom",null,{"$f":"IF(LEN(B10)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Adresse1",null,{"$f":"IF(LEN(B11)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Adresse2"]
["Adresse3"]
["Adresse4"]
["Ville",null,{"$f":"IF(LEN(B15)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Code postal"]
["Code PAYS","FR",{"$f":"IF(LEN(B17)=0,\"Champ OBLIGATOIRE\",IF(LEN(B17)=2,\"OK\",\"Doit contenir 2 digits\"))","v":"OK"}]
["Code Etat / Région",null,{"$f":"IF(AND(OR(B17=\"AU\",B17=\"BR\",B17=\"CA\",B17=\"US\"),LEN(B18)=0),\"Champ OBLIGATOIRE pour ce pays\",IF(AND(OR(B17=\"AU\",B17=\"BR\",B17=\"CA\",B17=\"US\"),ISERROR(VLOOKUP(CONCATENATE(B17,B18),Données!BN:BO,2,0))=TRUE),\"Incohérence pays / région\",IF(AND(OR(B17=\"AU\",B17=\"BR\",B17=\"CA\",B17=\"US\"),LEN(B18)<>0),\"OK\",IF(LEN(B18)<>0,\"Vider la cellule\",\"OK\"))))","v":"OK"}]
["Téléphone ",null,{"$f":"IF(LEN(B19)<>0,IF(LEFT(B19,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Téléphone mobile",null,{"$f":"IF(LEN(B20)<>0,IF(LEFT(B20,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Fax",null,{"$f":"IF(LEN(B21)<>0,IF(LEFT(B21,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Email"]
["Inco-term","DAP",{"$f":"IF(LEN(B23)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["ADRESSE DE FACTURATION (à compléter si différent)"]
["Nom",{"$f":"IF(B10<>\"\",B10,\"\")","v":""},{"$f":"IF(LEN(B25)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Adresse1",{"$f":"IF(B11<>\"\",B11,\"\")","v":""},{"$f":"IF(LEN(B26)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Adresse2",""]
["Adresse3",""]
["Adresse4",""]
["Ville","",{"$f":"IF(LEN(B30)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Code postal",""]
["Code PAYS","FR",{"$f":"IF(LEN(B32)=0,\"Champ OBLIGATOIRE\",IF(LEN(B32)=2,\"OK\",\"Doit contenir 2 digits\"))","v":"OK"}]
["Code Etat / Région","",{"$f":"IF(AND(OR(B32=\"AU\",B32=\"BR\",B32=\"CA\",B32=\"US\"),LEN(B33)=0),\"Champ OBLIGATOIRE pour ce pays\",IF(AND(OR(B32=\"AU\",B32=\"BR\",B32=\"CA\",B32=\"US\"),ISERROR(VLOOKUP(CONCATENATE(B32,B33),Données!BN:BO,2,0))=TRUE),\"Incohérence pays / région\",IF(AND(OR(B32=\"AU\",B32=\"BR\",B32=\"CA\",B32=\"US\"),LEN(B33)<>0),\"OK\",IF(LEN(B33)<>0,\"Vider la cellule\",\"OK\"))))","v":"OK"}]
["Téléphone ","",{"$f":"IF(LEN(B34)<>0,IF(LEFT(B34,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Téléphone mobile","",{"$f":"IF(LEN(B35)<>0,IF(LEFT(B35,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Fax","",{"$f":"IF(LEN(B36)<>0,IF(LEFT(B36,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Email",""]
["Inco-term","DAP",{"$f":"IF(LEN(B38)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["CONTACT COMPTABILITE"]
["Civilité"]
["Nom & Prénom"]
["Fonction","CONTACT COMPTA"]
["Téléphone ",null,{"$f":"IF(LEN(B43)<>0,IF(LEFT(B43,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Téléphone mobile",null,{"$f":"IF(LEN(B44)<>0,IF(LEFT(B44,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Fax",null,{"$f":"IF(LEN(B45)<>0,IF(LEFT(B45,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Email"]
["AUTRE CONTACT"]
["Civilité"]
["Nom & Prénom"]
["Fonction"]
["Téléphone ",null,{"$f":"IF(LEN(B51)<>0,IF(LEFT(B51,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Téléphone mobile",null,{"$f":"IF(LEN(B52)<>0,IF(LEFT(B52,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Fax",null,{"$f":"IF(LEN(B53)<>0,IF(LEFT(B53,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Email"]
[]
["(1) obligatoire si vous êtes membre de la communauté Européenne (Y compris la France)"]
[]
["Cadre réservé à Cordon Electronics"]
["Groupe de tiers","Client Divers France"]
["Type facture","I"]
["Planning facture","Mensuelle"]
["Règle de livraison","A"]
["Livraison via","S"]
["Tarif","SALES LIST"]
["Mode de paiement","Virement"]
["Sous méthode de paiement","Virement client"]
["Délai de paiement","Invoice date + 30 days"]
["Rappels","rappel 3 niveaux"]
["Imprimer remise","Y"]
["En-cours autorisé",14000]
["Eco Taxable","Y"]
["Statut crédit","O"]
["Groupe client (SCG)","Non affecte"]
["Famille","DIST"]
["Enseigne commerciale","DISTRIBUTEUR"]
["ID Client"]
["Client Facturé"]
["Client SAV"]
["Prestation","SAV RI"]
["Type Devis",6]

{"sheet":"Fournisseur","index":1,"n_rows":82,"n_cols":3,"rows_kept":82,"cut":false,"hidden":false,"merged":[[74,0,74,1],[0,0,0,1],[21,0,21,1],[1,0,1,1],[8,0,8,1],[34,0,34,1],[55,0,55,1],[51,2,52,2],[59,2,60,2],[38,0,38,1],[47,0,47,1],[63,0,63,1]]}
["FICHE D'OUVERTURE DE COMPTE\nFOURNISSEUR",null,"Vérification données\nv14"]
["GENERAL"]
["Raison sociale","DATAXIS SARL",{"$f":"IF(LEN(B3)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["N° de SIRET","423 163 385 00036"]
["Code APE ou NAF"]
["N° de TVA°. (1)","FR48423163385",{"$f":"IF(AND(OR(B17=\"BE\",B17=\"DK\",B17=\"DE\",B17=\"EL\",B17=\"ES\",B17=\"FR\",B17=\"IE\",B17=\"IT\",B17=\"LU\",B17=\"NL\",B17=\"AT\",B17=\"PT\",B17=\"FI\",B17=\"SE\",B17=\"GB\",B17=\"CY\",B17=\"CZ\",B17=\"EE\",B17=\"LV\",B17=\"LT\",B17=\"HU\",B17=\"MT\",B17=\"PL\",B17=\"SI\",B17=\"SK\",B17=\"BG\",B17=\"RO\",B17=\"HR\"),LEN(B6)=0),\"Champ OBLIGATOIRE pour l' UE\",IF(OR(OR(B17=\"BE\",B17=\"DK\",B17=\"DE\",B17=\"EL\",B17=\"ES\",B17=\"FR\",B17=\"IE\",B17=\"IT\",B17=\"LU\",B17=\"NL\",B17=\"AT\",B17=\"PT\",B17=\"FI\",B17=\"SE\",B17=\"GB\",B17=\"CY\",B17=\"CZ\",B17=\"EE\",B17=\"LV\",B17=\"LT\",B17=\"HU\",B17=\"MT\",B17=\"PL\",B17=\"SI\",B17=\"SK\",B17=\"BG\",B17=\"RO\",B17=\"HR\"),LEN(B6)=0),\"OK\",\"Vider la cellule\"))","v":"OK"}]
["site web ","www.dataxis.com"]
["Langue","fr_FR",{"$f":"IF(LEN(B8)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["ADRESSE DE FACTURATION"]
["Nom","GREGOIRE LAROQUE",{"$f":"IF(LEN(B10)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Adresse1","10 RUE PERGOLESE ",{"$f":"IF(LEN(B11)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Adresse2"]
["Adresse3"]
["Adresse4"]
["Ville","PARIS",{"$f":"IF(LEN(B15)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Code postal","75116"]
["Code PAYS","FR",{"$f":"IF(LEN(B17)=0,\"Champ OBLIGATOIRE\",IF(LEN(B17)=2,\"OK\",\"Doit contenir 2 digits\"))","v":"OK"}]
["Code Etat / Région",null,{"$f":"IF(AND(OR(B17=\"AU\",B17=\"BR\",B17=\"CA\",B17=\"US\"),LEN(B18)=0),\"Champ OBLIGATOIRE pour ce pays\",IF(AND(OR(B17=\"AU\",B17=\"BR\",B17=\"CA\",B17=\"US\"),ISERROR(VLOOKUP(CONCATENATE(B17,B18),Données!BN:BO,2,0))=TRUE),\"Incohérence pays / région\",IF(AND(OR(B17=\"AU\",B17=\"BR\",B17=\"CA\",B17=\"US\"),LEN(B18)<>0),\"OK\",IF(LEN(B18)<>0,\"Vider la cellule\",\"OK\"))))","v":"OK"}]
["Téléphone ","0033670618239",{"$f":"IF(LEN(B19)<>0,IF(LEFT(B19,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":"OK"}]
["Fax",null,{"$f":"IF(LEN(B20)<>0,IF(LEFT(B20,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Inco-term","DAP",{"$f":"IF(LEN(B21)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["ADRESSE DE COMMANDE / LIVRAISON (à compléter si différent de facturation)"]
["Nom",{"$f":"IF(B10<>\"\",B10,\"\")","v":"GREGOIRE LAROQUE"},{"$f":"IF(LEN(B23)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Adresse1","10 RUE PERGOLESE ",{"$f":"IF(LEN(B24)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Adresse2",""]
["Adresse3",""]
["Adresse4",""]
["Ville","PARIS",{"$f":"IF(LEN(B28)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Code postal","75116"]
["Code PAYS","FR",{"$f":"IF(LEN(B30)=0,\"Champ OBLIGATOIRE\",IF(LEN(B30)=2,\"OK\",\"Doit contenir 2 digits\"))","v":"OK"}]
["Code Etat / Région","",{"$f":"IF(AND(OR(B30=\"AU\",B30=\"BR\",B30=\"CA\",B30=\"US\"),LEN(B31)=0),\"Champ OBLIGATOIRE pour ce pays\",IF(AND(OR(B30=\"AU\",B30=\"BR\",B30=\"CA\",B30=\"US\"),ISERROR(VLOOKUP(CONCATENATE(B30,B31),Données!BN:BO,2,0))=TRUE),\"Incohérence pays / région\",IF(AND(OR(B30=\"AU\",B30=\"BR\",B30=\"CA\",B30=\"US\"),LEN(B31)<>0),\"OK\",IF(LEN(B31)<>0,\"Vider la cellule\",\"OK\"))))","v":"OK"}]
["Téléphone ","0033670618239",{"$f":"IF(LEN(B32)<>0,IF(LEFT(B32,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":"OK"}]
["Fax","",""]
["Inco-term","DAP"]
["CONDITIONS DE PAIEMENT"]
["Devise","EUR",{"$f":"IF(LEN(B36)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Mode de paiement","Virement",{"$f":"IF(LEN(B37)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Délais de paiement","Date de facture + 30 jours","OK"]
["REFERENCES BANCAIRES (joindre un RIB) (Validation par Compta Groupe)"]
["Code Pays de la banque","FR",{"$f":"IF(OR($B$37=\"Virement\",$B$37=\"Chèque\"),IF(LEN(B40)=0,\"Champ OBLIGATOIRE\",\"OK\"),IF(LEN(B40)=0,\"OK\",\"Vider les cellules\"))","v":"OK"}]
["Nom de la Banque","Banque Populaire du Midi",{"$f":"IF(OR($B$37=\"Virement\",$B$37=\"Chèque\"),IF(LEN(B41)=0,\"Champ OBLIGATOIRE\",\"OK\"),IF(LEN(B41)=0,\"OK\",\"Vider les cellules\"))","v":"OK"}]
["Nom de l'Agence","Banque Populaire du Sud","OK"]
["Ville","Montpellier","OK"]
["Titulaire","DATAXIS SARL","OK"]
["Numéro de compte","09366671012","OK"]
["Swift ou BIC","CCBPFRPPPPG\t","OK"]
["IBAN (UE)","FR7616607002190936667101272",{"$f":"IF(AND($B$37<>\"Virement\",$B$37<>\"Chèque\"),IF(LEN(B47)<>0,\"Vider la cellule\",\"OK\"),IF(B40=\"\",\"OK\",IF(AND(B40=\"FR\",LEN(B47)<>27),\"Doit contenir 27 digits\",IF(AND(B40=\"FR\",LEN(B47)=27),\"OK\",IF(AND(OR(B40=\"BE\",B40=\"DK\",B40=\"DE\",B40=\"EL\",B40=\"ES\",B40=\"IE\",B40=\"IT\",B40=\"LU\",B40=\"NL\",B40=\"AT\",B40=\"PT\",B40=\"FI\",B40=\"SE\",B40=\"GB\",B40=\"CY\",B40=\"CZ\",B40=\"EE\",B40=\"LV\",B40=\"LT\",B40=\"HU\",B40=\"MT\",B40=\"PL\",B40=\"SI\",B40=\"SK\",B40=\"BG\",B40=\"RO\",B40=\"HR\"),LEN(B47)=0),\"Champ OBLIGATOIRE\",IF(AND(OR(B40=\"BE\",B40=\"DK\",B40=\"DE\",B40=\"EL\",B40=\"ES\",B40=\"IE\",B40=\"IT\",B40=\"LU\",B40=\"NL\",B40=\"AT\",B40=\"PT\",B40=\"FI\",B40=\"SE\",B40=\"GB\",B40=\"CY\",B40=\"CZ\",B40=\"EE\",B40=\"LV\",B40=\"LT\",B40=\"HU\",B40=\"MT\",B40=\"PL\",B40=\"SI\",B40=\"SK\",B40=\"BG\",B40=\"RO\",B40=\"HR\"),LEN(B47)<>0),\"OK\",IF(B47=B45,\"OK\",\"Répéter le N° de compte\")))))))","v":"OK"}]
["CONTACT COMPTABILITE"]
["Civilité","Miss",{"$f":"IF(LEN(B49)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Nom & Prénom","Yoshita Seetohul","OK"]
["Fonction","CONTACT COMPTA"]
["Téléphone ","0033670618239",{"$f":"IF(OR(LEN(B52)<>0,LEN(B53)<>0),\"OK\",\"1 N° de téléphone OBLIGATOIRE\")","v":"OK"}]
["Téléphone mobile","0033670618239"]
["Fax","0000",{"$f":"IF(LEN(B54)<>0,IF(LEFT(B54,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":"OK"}]
["Email","yoshita.seetohul@dataxis.com",{"$f":"IF(LEN(B55)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["CONTACT COMMERCIAL"]
["Civilité","MR",{"$f":"IF(LEN(B57)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["Nom & Prénom","GREGOIRE LAROQUE","OK"]
["Fonction","CONTACT COMMERCIAL"]
["Téléphone ","0033670618239",{"$f":"IF(OR(LEN(B60)<>0,LEN(B61)<>0),\"OK\",\"1 N° de téléphone OBLIGATOIRE\")","v":"OK"}]
["Téléphone mobile","0033670618239"]
["Fax",null,{"$f":"IF(LEN(B62)<>0,IF(LEFT(B62,2)<>\"00\",\"Mettre au format International\",\"OK\"),\"\")","v":""}]
["Email","gregoire.laroque@dataxis.com",{"$f":"IF(LEN(B63)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"OK"}]
["AUTRE CONTACT"]
["Civilité","Mr"]
["Nom & Prénom"]
["Fonction"]
["Téléphone "]
["Téléphone mobile"]
["Fax"]
["Email"]
[]
["(1) obligatoire si vous êtes membre de la communauté Européenne (Y compris la France)"]
[]
["Cadre réservé à Cordon Electronics"]
["Type de compte bancaire","C"]
["Sous méthode de paiement",{"$f":"IF(B17=\"FR\",VLOOKUP(B37,Données!CX8:CY11,2,0),VLOOKUP(B36,Données!CW2:CY7,3,0))","v":"Virement Fournisseur France"}]
["Groupe de tiers","Frais Generaux"]
["Liste prix d'achat","PURCHASE LIST EUR"]
["Branche Fournisseur",null,{"$f":"IF(LEN(B80)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Info fournisseur complémentaire",null,{"$f":"IF(LEN(B81)=0,\"Champ OBLIGATOIRE\",\"OK\")","v":"Champ OBLIGATOIRE"}]
["Compte Comptable",{"$f":"IF(B80=\"\",\"\",IF(AND(B17=\"FR\",B80<>\"FR07 - Intercos\"),\"40110000\",IF(B80=\"FR07 - Intercos\",\"40150000\",\"40120000\")))","v":""}]

{"sheet":"Format Import Tiers","index":2,"n_rows":25,"n_cols":179,"rows_kept":25,"cut":false,"hidden":true,"merged":[[2,147,2,155],[2,156,2,173],[2,1,2,31],[2,174,2,178],[2,57,2,63],[2,64,2,68],[2,69,2,70],[2,95,2,124],[2,71,2,94],[2,125,2,146],[2,32,2,56]]}
["Format Import Tiers"]
["Nom de la table","C_Bpartner",null,"C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","C_Bpartner","Z_BPartner_PriceList","Z_BPartner_PriceList","Z_BPartner_PriceList","Z_BPartner_PriceList","Z_BPartner_PriceList","Z_BPartner_PriceList","Z_BPartner_PriceList","C_BPartner","C_BPartner","C_BPartner","C_BPartner","C_BPartner","C_BPartner","C_BPartner","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BP_BankAccount","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_BPartner_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_Location","C_BPartner_Location","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","AD_User","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","Z_BPartner_Location_SAV","C_OrgAssignment","C_OrgAssignment","C_OrgAssignment","C_OrgAssignment","C_OrgAssignment"]
["Nom de l'onglet","Tiers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Client",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarifs (vente) : définition des tarifs de vente selon l'origine de la commande (sites web, manuel, …)",null,null,null,null,null,null,"Fournisseur",null,null,null,null,"Employés",null,"Banque",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact (utilisateur)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAV Information",null,null,null,null,null,null,null,null,"Adresse SAV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assignation Organisation"]
[null,"Value","IsCreation","GreetingName","Z_S2MI_Value","Name","Name2","Description","IsActive","IsSummary","TaxID","IsTaxExempt","DUNS","ReferenceNo","NAICS","Rating","GroupValue","AD_Language","URL","IsProspect","PotentialLifeTimeValue","AcqusitionCost","NumberEmployees","ShareOfCustomer","SalesVolume","IncoTermName","ZRealizedTurnover","FamillyName","RepairerType","Z_CompteTiers","IsAutoInvoice","Z_IE","IsCustomer","DocumentCopies","InvoiceRule","InvoiceScheduleName","DeliveryRule","DeliveryViaRule","SO_PriceListName","DiscountSchemaName","FlatDiscount","PaymentRule","SubPaymentRuleValue","PaymentTermValue","SalesRepName","DunningName","POReference","IsDiscountPrinted","SO_Description","PrintFormatInvoiceName","ShelfLifeMinPct","SO_CreditLimit","ZCreditMessage","PrintFormatShipmentName","IsEcoTaxable","SOCreditStatus","Z_CustomerGroup_ID","BPartnerPriceListActive","PriceListName","SOPOOrigin","TV_DeliveryRule","TV_InvoiceRule","TV_PaymentTermValue","TV_SalesRepName","IsVendor","PaymentRulePO","SubPaymentRulePOValue","PO_PaymentTermValue","PO_PriceListName","IsEmployee","IsSalesRep","BankUserName","BankActive","IsACH","BankAccountType","RoutingNo","SwiftCode","AccountNo","CreditCardType","CreditCardNumber","CreditCardVV","CreditCardExpMM","CreditCardExpYY","A_Name","A_Street","Z_NAME_BANK","Z_AGENCIE_BANK","A_City","A_Zip","A_State","A_CountryCode","A_Ident_DL","A_Ident_SSN","A_EMail","ISO_Code","LocationName","ZPrintBPName","LocationActive","BPAddress1","BPAddress2","BPAddress3","BPAddress4","BPPostal","BPCity","C_Region_ID/Region_Name","BPCountry_ID/BPCountryISO","BPPhone","BPPhone2","BPFax","ISDN","IsShipTo","IsBillTo","IsPayFrom","IsRemitTo","C_SalesRegionName","Z_TransportMode","UnloadingAdress1","UnloadingAdress2","UnloadingAdress3","UnloadingAdress4","UnloadingZIPCode","UnloadingCity","UnloadingC_Region_ID/UnloadingRegion_Name","UnloadingCountryISO","LocationIncoTermName","USER_NAME","User_Description","User_Comments","User_Active","User_EMail","Password","User_C_Greeting_ID/User_GreetingName","User_Location_ID/User_LocationName","Title","Birthday","UserPhone","UserPhone2","UserFax","NotificationType","JobName","IsFullBPAccess","WebLogin","WebPassWord","HZN_ControlQuality","FirstName","LastName","Z_Matricule","Commercial_Reference","Familly","ID_Customer","ID_Customer_Invoice","ID_Customer_SAV","BPartnerSAV_IsActive","Prestation","Quotation_Type","Particulier","SAVAddress1","SAVAddress2","SAVAddress3","SAVAddress4","SAVPostal","SAVCity","SAVC_Region_ID/SAVRegion_Name","SAVCountry_ID/SAVCountryISO","BPartnerSAVLocation_IsActive","BPartnerSAV_IsBillTo","BPartnerSAV_IsShipTo","BPartnerSAV_IsQuotation","BPartnerSAV_LocationName","BPartnerSAV_Phone","BPartnerSAV_Phone2","BPartnerSAV_Fax","BPartnerSAV_Email","SAV_ZPrintBPName","Asg_OrgName","Asg_ValidFrom","Asg_ValidTo","Asg_Isactive","Asg_Description"]
[null,1,"2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71","72","73","74","75","76","77","78","19","80","81","82","83","84","85","86","87","88","89","90","91","92","93","94","95","96","97","98","99","100","101","102","103","104","105","106","107","108","109","110","111","112","113","114","115","116","117","118","119","120","121","122","123","124","125","126","127","128","129","130","131","132","133","134","135","136","137","138","139","140","141","142","143","144","145","146","147","148","149","150","151","152","153","154","155","156","157","158","159","160","161","162","163","164","165","166","167","168","169","170","171","172","173","174","175","176","177","178"]
["Nom du champ","Clé de recherche","Création?","Civilité","Code S2MI","Nom","Nom (suite)","Description","Actif","Regroupement","ID TVA","Exempt TVA","Code APE","N° Référence","NAICS/SIC","Evaluation","Groupe de tiers","Langue","URL","Prospect","Potentiel futur","Coût d'acquisition","Nombre employés","Participation","Volume des ventes","Inco Term","Chiffre d'affaires réalisé","Famille","Type Réparateur","Compte Tiers (SAGE)","Facturation Auto","Inscription Etat","Client","Nbre d'exemplaires","Type facture","Planning facture","Règle de livraison","Livraison via","Tarif","Mode remise","% remise unique","Mode de paiement","Sous méthode de paiement","Délai de paiement","Vendeur","Rappels","Référence commande","Imprimer remise","Description commande","Format d'impression facture","Durée de vie minimum (%)","En-cours autorisé","ZCreditMessage","Format d'impression expédition","Eco Taxable","Statut crédit","Groupe client","Actif","Tarif","Origine Commande","Règle de livraison","Type facture","Délai de paiement","Vendeur","Fournisseur","Mode de paiement","Sous méthode de paiement","Délai de paiement","Liste prix d'achat","Employé","Vendeur","Utilisateur","Actif","Virement","Type de compte bancaire","Code banque","Code Swift","N° Compte","Carte de crédit","Numéro C.C.","Code vérification C.C.","Exp. Mois","Exp. Année","Titulaire","Rue Tit. carte de crédit","Nom de la banque","Agence de la banque","Ville","Code postal","Pays carte de crédit","Pays","Permis de conduire","N° Sécurité Sociale","Email carte de crédit","Devise","Nom","Nom Tiers (imprimé)","Actif","Adresse 1","Adresse 2","Adresse 3","Adresse 4","Code postal","Ville","Etat","Pays","Téléphone","Téléphone 2","Fax","ISDN","Adresse de livraison","Adresse de facturation","Adresse de rappel","Adresse de paiement","Secteur commercial","Mode de transport","Adresse 1 de déchargement","Adresse 2 de déchargement","Adresse 3 de déchargement","Adresse 4 de déchargement","Code postal de déchargement","Ville de déchargement","Etat","Pays de déchargement","Inco Term","Nom","Description","Commentaire","Actif","EMail","Mot de passe","Civilité","Adresse","Fonction","Anniversaire","Téléphone","Téléphone 2","Fax","Type de notification","Poste","Accès Tiers Complet","Web Login","Mot de passe web","Contrôle Qualité","Prénom","Nom","Matricule","Enseigne commerciale","Famille","ID Client","Client Facturé","Client SAV","Actif","Prestation","Type Devis","Client particulier (Y/N)","Adresse 1","Adresse 2","Adresse 3","Adresse 4","Code postal","Ville","Etat","Pays","Actif","Adresse de facturation","Adresse de livraison","Adresse de Devis","Nom Adresse","Téléphone","Téléphone2","Fax","Email","Nom Tiers imprimé","Organisation","Valide du","Valide jusqu'au","Actif","Description"]
["Type de données","Char(13)","Char(1)","Char(3)","Char(10)","Char(60)","Char(60)","Char(255)","Char(1)","Char(1)","Char(20)","Char(1)","Char(11)","Char(40)","Char(30)","Char(1)","Char(40)","Char(6)","Char(120)","Char(1)","Nombre","Nombre","Nombre","Nombre","Nombre","Char(60)","Nombre","Char(60)","Char(2)","Char(25)","Char(1)","Char(14)","Char(1)","Nombre","Char(1)","Char(60)","Char(1)","Char(1)","Char(60)","Char(60)","Nombre","Char(1)","Char(60)","Char(40)","Char(60)","Char(60)","Char(20)","Char(1)","Char(255)","Char(60)","Nombre","Nombre","Char(255)","Char(60)","Char(1)","Char(1)","Char(60)","Char(1)","Char(60)","Char(2)","Char(1)","Char(1)","Char(40)","Char(60)","Char(1)","Char(1)","Char(60)","Char(40)","Char(60)","Char(1)","Char(1)","Char(60)","Char(1)","Char(1)","Char(1)","Char(60)","Char(20)","Char(60)","Char(1)","Char(20)","Char(4)","Nombre","Nombre","Char(60)","Char(60)","Char(35)","Char(35)","Char(60)","Char(20)","Char(40)","Char(2)","Char(20)","Char(20)","Char(60)","Char(3)","Char(60)","Char(60)","Char(1)","Char(60)","Char(60)","Char(60)","Char(60)","Char(10)","Char(60)","Char(2)","Char(2)","Char(40)","Char(40)","Char(40)","Char(40)","Char(1)","Char(1)","Char(1)","Char(1)","Char(40)","Char(1)","Char(60)","Char(60)","Char(60)","Char(60)","Char(10)","Char(60)","Char(2)","Char(2)","Char(60)","Char(60)","Char(255)","Char(2000)","Char(1)","Char(60)","Char(40)","Char(3)","Char(60)","Char(40)","Date(JJ/MM/AAAA)","Char(40)","Char(40)","Char(40)","Char(1)","Char(60)","Char(1)","Char(60)","Char(40)","Char(1)","Char(60)","Char(60)","Char(20)","Char(20)","Char(20)","Char(20)","Char(20)","Char(20)","Char(1)","Char(20)","Char(1)","Char(1)","Char(60)","Char(60)","Char(60)","Char(60)","Char(10)","Char(60)","Char(2)","Char(2)","Char(1)","Char(1)","Char(1)","Char(1)","Char(60)","Char(40)","Char(40)","Char(40)","Char(60)","Char(60)","Char(60)","Date (JJ/MM/DDDD)","Date (JJ/MM/DDDD)","Char(1)","Char(255)"]
["Obligatoire (Y/N)","Y","Y","N","N","Y","N","N","Y","Y","Y","Y","Y","N","Y","N","Y","Y","N","Y","N","N","N","N","N","Y","N","N","N","Y si tiers utilisé sur la société Cordon Electronics","Y","N","Y","N","Y si le tiers est un client","Y si le type de facture = S","Y si le tiers est un client","N","Y si le tiers est un client","N","N","Y si le tiers est un client","Y si le tiers est un client","Y si le tiers est un client","N","Y","N","Y","N","N","N","N","N","N","Y","Y","Y si le tiers est un client","Y","Y","Y","Y si le tiers est un client","Y si le tiers est un client","Y si le tiers est un client","N","Y","Y si le tiers est un fournisseur","Y si le tiers est un fournisseur","Y si le tiers est un fournisseur","Y si le tiers est un fournisseur","Y","Y","N","Y","Y","Y si virement","Y si virement","Y si virement","N","N","N","N","N","N","Y","N","Y si virement","N","Y","N","N","Y","N","N","N","N","Y","N","Y","N","N","N","N","N","Y","N","Y","N","N","N","N","Y","Y","Y","Y","N","N","N","N","N","N","N","Y","N","Y","Y","Y","N","N","Y","N","N","N","N","N","N","N","N","N","Y","N","Y","N","N","N","N","N","N","N","N","N","N","N","N","N","N","Y","N","N","N","N","N","Y","N","Y","N","N","N","N","Nom Adresse","N","N","N","N","N","N","Y si Organisation renseignée","N","Y si Organisation renseignée","N"]
["Valeur par défaut",null,"N",null,null,null,null,null,"Y","N",null,"N",null,null,null,null,null,"fr_FR",null,"Y",null,null,null,null,null,"NA",null,null,null,null,"N",null,"Y",null,"D",null,"A",null,"SALES LIST",null,null,"T","Virement client",null,null,"rappel 3 niveaux",null,"Y",null,null,null,null,null,null,"Y","X","N","Y",null,null,null,null,null,null,"N","T","Virement client",null,null,"N","N",null,"Y","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y","Y","Y",null,null,null,null,null,null,null,null,null,null,"NA",null,null,null,"Y",null,null,null,null,null,null,null,null,null,"E",null,"Y",null,null,null,null,null,null,null,null,null,null,null,"Y",null,"1 = Courrier  2 = Fax  3 = Email  4 = EDI","N",null,null,null,null,null,null,null,null,"Y","Y","Y","N",null,null,null,null,null,null,null,null,null,"Y"]
["Commentaire","Code Compiere du tiers","N si import en modification et Y si import en création","Civilité du tiers","Code du tiers chez S2MI","Nom du tiers","Complément du nom du tiers (ETS, SARL, SA, …)","Informations complémentaires","Le tiers est-il actif ?",null,"N° TVA Intra-communautaire du tiers obligatoire si tiers français (sauf particulier et employé)","Le tiers est-il exempt TVA ?","Code APE obligatoire si tiers français (sauf particulier et employé)","Notre numéro Client / Fournisseur sur le site du tiers","N° SIRET du tiers obligatoire si tiers français (sauf particulier et employé)","Classification / importance du Tiers","Groupe du tiers","Langue tu tiers","Adresse du site du tiers","Le tiers est-il un prospect ? (pas encore un client)","Revenu total attendu (si Prospect = 'Y' )","Le coût d'acquisition identifie le coût nécessaire pour passer un tiers de prospect à client (si Prospect = 'Y' )","Nombre employés (si Prospect = 'Y' )","Identifie le pourcentage du volume d'articles fourni par le Tiers (si Prospect = 'Y' )","Identifie le volume total des ventes pour un tiers (si Prospect = 'Y' )","Inco Term","Chiffre d'affaires réalisé","Voir la liste des familles disponibles dans Compiere","Voir la liste des types de réparateurs disponibles dans Compiere","Code du tiers dans SAGE","Impression automatique des factures ?","N° d'inscription du tiers dans son état","Le tiers est-il un client ?","Nombre de copies lors des impressions des documents client","Fréquence et méthode de facturation","Planning de facturation","Définit la règle de livraison","Indique le mode de livraison, par exemple enlèvement ou transporteur.","Tarif de vente. Voir la liste des tarifs disponibles dans Compiere","Mode de calcul des remises. Voir la liste des modes de remise disponibles dans Compiere","Pourcentage de remise unique","Mode de paiement des factures","Sous méthode de paiement","Voir la liste des délais de paiement disponibles dans Compiere","Utilisateur Compiere associé à ce tiers","Mode de rappels pour les factures échues","Référence à répéter sur toutes les commandes du tiers","Impression des remises sur les documents du tiers ?","Description à répéter sur toutes les commandes du tiers","Format d'impression facture","Durée de vie minimum d'un article en pourcent basée sur l'instance de date de garantie de l'article","Montant total du crédit autorisé",null,"Format d'impression expédition","Tiers ecotaxable ?",null,"Groupe client","Actif ?","Tarif de vente autorié pour ce tiers. Voir la liste des tarifs disponibles dans Compiere","Origine Commande","Définit la règle de livraison","Fréquence et méthode de facturation","Voir la liste des délais de paiement disponibles dans Compiere","Vendeur par défaut des commandes selon l'origine des commandes","Le tiers est-il fournisseur ?","Mode de paiement des factures. Valeur B interdite","Sous méthode de paiement","Voir la liste des délais de paiement disponibles dans Compiere","Tarif d'achat. Voir la liste des tarifs disponibles dans Compiere","Le tiers est-il un employé ?","Le tiers est-il un vendeur ?","Utilisateur ou contact lié au tiers","Actif ?","Le paiement se fait-il par virement ?","Type de compte bancaire","Code IBAN de la banque","Le code SWIFT est un identificateur pour la banque","Indique le numéro du compte de la banque","Type de carte de crédit (Visa, MC, Amex). Inutile si pas virement","Indique le numéro de la carte de crédit sans blancs ni espaces. Inutile si pas virement","Indique le code de vérification de la carte de crédit. (AMEX 4 caractères sur le recto; MC,Visa 3 caractères au verso).Inutile si pas virement","Mois d'expiration de la carte de crédit. Inutile si pas virement","Année d'expiration de la carte de crédit. Inutile si pas virement","Nom du titulaire de la carte de crédit ou du compte bancaire","Rue de l'adresse du titulaire de la carte de crédit ","Nom de la banque","Agence de la banque","Ville figurant sur la carte de crédit ou ville de la banque du titulaire","Code postal du titulaire de la carte de crédit ou du compte bancaire","Pays figurant sur la C.C. ou pays de la banque du titulaire. Voir liste des pays disponibles dans Compiere","Code ISO du pays. Voir liste des pays disponible dans Compiere","N° de permis de conduire utilisé pour vérifier l'identité du titulaire de la carte de crédit","N° de sécurité sociale utilisé pour identifier le titulaire de la carte de crédit","Adresse e-mail du titulaire de la carte de crédit","Code ISO de la devise","Nom de l'adresse","Nom Tiers (imprimé)","Actif ?","Adresse 1. Obligatoire pour les adresses brésiliennes et ne doit contenir que des chiffres","Adresse 2","Adresse 3","Adresse 4. Pour les adresses brésiliennes, mettre le quartier","Code postal","Ville","Code Etat du pays. Voir liste des états disponible dans Compiere. Obligatoire selon les pays","Code ISO du pays. Voir liste des pays disponible dans Compiere","N° téléphone","N° téléphone","N° fax","N° RNIS ou modem","Adresse de livraison ?","Adresse de facturation ?","Adresse de rappel ?","Adresse de paiement ?","Secteur commercial","Mode de transport","Adresse 1 de déchargement. Obligatoire pour les adresses brésiliennes et ne doit contenir que des chiffres","Adresse 2 de déchargement","Adresse 3 de déchargement","Adresse 4 de déchargement.Pour les adresses brésiliennes, mettre le quartier","Code postal de déchargement","Ville de déchargement","Code Etat du pays. Voir liste des états disponible dans Compiere. Obligatoire selon les pays","Code ISO du pays. Voir liste des pays disponible dans Compiere","Inco Term","Nom du contact","Description du contact","Commentaire","Actif ?","Email du contact","Mot de passe pour se connecter à Compiere","Civilité du tiers","Nom de l'adresse du contact. L'adresse doit être associé au tiers (onglet Adresse)","Fonction du contact","Date anniversaire du contact","N° téléphone","N° téléphone","N° fax","Les EMails et les notifications sont envoyés pour les modifications des requêtes, etc.","Poste au niveau de l'emploi du contact. Voir la liste des postes disponibles dans Compiere. Uniquement pour les employés","L'utilisateur/Contact possède un accès complet aux informations et aux ressources du Tiers","Login de connexion aux sites de vente Web ou login SAV pour les employés","Mot de passe de connexion aux sites de vente Web ou login SAV pour les employés","Les dossiers SAV traités par l'utilisatseur doivent-ils passer au contrôle qualité ?","Prénom de l'utilisateur","Nom de l'utilisateur",null,"Référence commerciale de l'enseigne","Famille SAV du Tiers","Code ORIAN, N° centrale, ... du Client","Code Compiere du Client facturé","Code SAV du Client","Actif ?","Type de prestation","Type d'envoi des devis","Client particulier ?","Adresse 1. Obligatoire pour les adresses brésiliennes et ne doit contenir que des chiffres","Adresse 2","Adresse 3","Adresse 4. Pour les adresses brésiliennes, mettre le quartier","Code postal","Ville","Code Etat du pays. Voir liste des états disponible dans Compiere. Obligatoire selon les pays","Code ISO du pays. Voir liste des pays disponible dans Compiere","Actif ?","Adresse de facturation ?","Adresse de livraison ?","Adresse de Devis?","Nom de l'adresse","Téléphone","Téléphone2","Fax","Email","Nom Tiers imprimé","Nom de l'organisation","Date début validité","Date fin validité","Assignation active","Description assignation"]
[null,"SMGMI75PARI01","Y",null,"RA8342","MGMI","MAINTENANCE GARANTIE MICRO INFORMATIQUE",null,"Y","N","FR22792877292","N","4741Z",null,"79287729200013",null,"SUP Frais Generaux","fr_FR",null,"N",null,null,null,null,null,null,null,null,null,null,null,"N","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,"N",null,null,null,null,null,"Y","Y","T","VIRT FOUR FRANCE","30 days (end of month)","PURCHASE LIST EUR","N","N",null,"Y","Y","C","FR7830002024230000070188F86","CRLYFRPP","0000070188F86",null,null,null,null,null,"VAIO REPAIR CENTER",null,"LCL","PARIS COURS DE VINCEN","PARIS COURS DE VINCEN",null,null,"FR",null,null,null,"EUR","PARIS","MGMI","Y","17 RUE MOUNET SULLY",null,null,null,75020,"PARIS",null,"FR",null,null,null,null,"Y","Y","Y","Y",null,3,null,null,null,null,null,null,null,null,"DAP",null,null,null,"Y"]
[null,"SSNT_97PORT01","Y",null,null,"SNT",null,null,"Y","N","FR24388124455","N","4941A",null,"38812445500071",null,"SUP Frais Generaux","fr_FR",null,"N",null,null,null,null,null,null,null,null,null,null,null,"N","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,"N",null,null,null,null,null,"Y","Y","S","Chèque Fournisseur","30 days (end of month)","PURCHASE LIST EUR","N","N",null,"Y","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FR",null,null,null,"EUR","LE PORT","SNT","Y","5 RUE VELASQUEZ","ZI N° 1",null,null,97822,"LE PORT",null,"FR",null,null,null,null,"Y","Y","Y","Y",null,3,null,null,null,null,null,null,null,null,"DAP",null,null,null,"Y"]
[{"$f":"IF(AND(DG13=\"Y\",Fournisseur!B66=\"\"),\"1 ligne à intégrer\",\"2 lignes à intégrer\")","v":"1 ligne à intégrer"},{"$f":"IF(AND(DB13=\"FR\",DG13=\"Y\"),UPPER(\"S\"&LEFT(F13,4)&LEFT(CY13,2)&LEFT(CZ13,4)&\"01\"),IF(AND(DB13=\"FR\",DG13=\"N\",DB14=\"FR\"),UPPER(\"S\"&LEFT(F14,4)&LEFT(CY14,2)&LEFT(CZ14,4)&\"01\"),IF(AND(DB13=\"FR\",DG13=\"N\",DB14<>\"FR\"),UPPER(\"S\"&LEFT(F14,4)&LEFT(CY14,2)&LEFT(CZ14,4)&\"01\"&\"_\"&DB14),IF(AND(DB13<>\"FR\",DG13=\"Y\"),UPPER(\"S\"&LEFT(F13,4)&LEFT(CY13,2)&LEFT(CZ13,4)&\"01\"&\"_\"&DB13),IF(AND(DB13<>\"FR\",DG13=\"N\",DB14=\"FR\"),UPPER(\"S\"&LEFT(F14,4)&LEFT(CY14,2)&LEFT(CZ14,4)&\"01\"),IF(AND(DB13<>\"FR\",DG13=\"N\",DB14<>\"FR\"),UPPER(\"S\"&LEFT(F14,4)&LEFT(CY14,2)&LEFT(CZ14,4)&\"01\"&\"_\"&DB14)))))))","v":"SDATA75PARI01"},"Y",null,null,{"$f":"IF(Fournisseur!$B$3<>\"\",UPPER(Fournisseur!$B$3),\"\")","v":"DATAXIS SARL"},null,null,"Y","N",{"$f":"IF(Fournisseur!$B$6<>\"\",UPPER(Fournisseur!$B$6),\"\")","v":"FR48423163385"},"N",{"$f":"IF(Fournisseur!$B$5<>\"\",UPPER(Fournisseur!$B$5),\"\")","v":""},null,{"$f":"IF(Fournisseur!$B$4<>\"\",UPPER(Fournisseur!$B$4),\"\")","v":"423 163 385 00036"},null,{"$f":"IFERROR(VLOOKUP(Fournisseur!$B$78,Données!$D$2:$E$10,2,0),\"\")","v":"SUP Frais Generaux"},{"$f":"IF(Fournisseur!$B$8<>\"\",Fournisseur!$B$8,\"\")","v":"fr_FR"},{"$f":"IF(Fournisseur!$B$7<>\"\",Fournisseur!$B$7,\"\")","v":"www.dataxis.com"},"N",null,null,null,null,null,{"$f":"IF(Fournisseur!$B$21=\"\",\"\",Fournisseur!$B$21)","v":"DAP"},null,null,null,null,null,"N","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,"Y",{"$f":"IF(Fournisseur!$B$37=\"\",\"\",VLOOKUP(Fournisseur!$B$37,Données!$AQ$2:$AR$5,2,0))","v":"T"},{"$f":"IF(Fournisseur!$B$77=\"\",\"\",VLOOKUP(Fournisseur!$B$77,Données!$AT$2:$AU$11,2,0))","v":"VIRT FOUR FRANCE"},{"$f":"IF(Fournisseur!$B$38=\"\",\"\",VLOOKUP(Fournisseur!$B$38,Données!$AW$2:$AX$24,2,0))","v":"Invoice date + 30 days"},{"$f":"IF(Fournisseur!$B$79=\"\",\"\",+Fournisseur!$B$79)","v":"PURCHASE LIST EUR"},"N","N",null,"Y",{"$f":"+IF(BN13=\"T\",\"Y\",\"N\")","v":"Y"},{"$f":"IF(BV13=\"Y\",Fournisseur!$B$76,\"\")","v":"C"},{"$f":"IF($BV13=\"Y\",UPPER(Fournisseur!$B$47),\"\")","v":"FR7616607002190936667101272"},{"$f":"IF($BV13=\"Y\",IF(LEN(UPPER(Fournisseur!$B$46))=11,UPPER(Fournisseur!$B$46),CONCATENATE(UPPER(Fournisseur!$B$46),\"XXX\")),\"\")","v":"CCBPFRPPPPG\tXXX"},{"$f":"IF($BV13=\"Y\",IF(Fournisseur!$B$45<>\"\",UPPER(Fournisseur!$B$45),\"\"),\"\")","v":"09366671012"},null,null,null,null,null,{"$f":"IF($BV13=\"Y\",IF(Fournisseur!$B$44<>\"\",UPPER(Fournisseur!$B$44),F13),\"\")","v":"DATAXIS SARL"},null,{"$f":"IF($BV13=\"Y\",UPPER(Fournisseur!$B$41),\"\")","v":"BANQUE POPULAIRE DU MIDI"},{"$f":"IF($BV13=\"Y\",IF(Fournisseur!$B$42<>\"\",UPPER(Fournisseur!$B$42),\"\"),\"\")","v":"BANQUE POPULAIRE DU SUD"},{"$f":"IF($BV13=\"Y\",IF(Fournisseur!$B$43<>\"\",UPPER(Fournisseur!$B$43),\"\"),\"\")","v":"MONTPELLIER"},null,null,{"$f":"IF($BV13=\"Y\",IF(Fournisseur!$B$40<>\"\",UPPER(Fournisseur!$B$40),\"\"),\"\")","v":"FR"},null,null,null,{"$f":"IF($BV13=\"Y\",IF(Fournisseur!$B$36<>\"\",Fournisseur!$B$36,\"\"),\"\")","v":"EUR"},{"$f":"IF(Fournisseur!B15<>\"\",UPPER(Fournisseur!B15),\"\")","v":"PARIS"},{"$f":"IF(Fournisseur!B10<>\"\",UPPER(Fournisseur!B10),\"\")","v":"GREGOIRE LAROQUE"},"Y",{"$f":"IF(Fournisseur!B11<>\"\",UPPER(Fournisseur!B11),\"\")","v":"10 RUE PERGOLESE "},{"$f":"IF(Fournisseur!B12<>\"\",UPPER(Fournisseur!B12),\"\")","v":""},{"$f":"IF(Fournisseur!B13<>\"\",UPPER(Fournisseur!B13),\"\")","v":""},{"$f":"IF(Fournisseur!B14<>\"\",UPPER(Fournisseur!B14),\"\")","v":""},{"$f":"IF(Fournisseur!B16<>\"\",UPPER(Fournisseur!B16),\"\")","v":"75116"},{"$f":"IF(Fournisseur!B15<>\"\",UPPER(Fournisseur!B15),\"\")","v":"PARIS"},{"$f":"IF(Fournisseur!B18<>\"\",Fournisseur!B18,\"\")","v":""},{"$f":"IF(Fournisseur!B17<>\"\",UPPER(Fournisseur!B17),\"\")","v":"FR"},{"$f":"IF(Fournisseur!$B$19<>\"\",Fournisseur!$B$19,\"\")","v":"0033670618239"},null,{"$f":"IF(Fournisseur!$B$20<>\"\",Fournisseur!$B$20,\"\")","v":""},null,{"$f":"IF(EXACT(CONCATENATE(Fournisseur!B10,Fournisseur!B11,Fournisseur!B12,Fournisseur!B13,Fournisseur!B14,Fournisseur!B15,Fournisseur!B16,Fournisseur!B17,Fournisseur!B18,Fournisseur!B19,Fournisseur!B20),CONCATENATE(Fournisseur!B23,Fournisseur!B24,Fournisseur!B25,Fournisseur!B26,Fournisseur!B27,Fournisseur!B28,Fournisseur!B29,Fournisseur!B30,Fournisseur!B31,Fournisseur!B32,Fournisseur!B33))=TRUE,\"Y\",\"N\")","v":"Y"},"Y","Y","Y",null,3,null,null,null,null,null,null,null,null,{"$f":"IF(Fournisseur!B21<>\"\",UPPER(Fournisseur!B21),\"\")","v":"DAP"},{"$f":"IF(Fournisseur!$B$50<>\"\",UPPER(Fournisseur!$B$50),\"\")","v":"YOSHITA SEETOHUL"},null,null,{"$f":"IF(Fournisseur!$B$50<>\"\",\"Y\",\"N\")","v":"Y"},{"$f":"IF(Fournisseur!$B$55<>\"\",Fournisseur!$B$55,\"\")","v":"yoshita.seetohul@dataxis.com"},null,{"$f":"IF(Fournisseur!$B$49<>\"\",Fournisseur!$B$49,\"\")","v":"Miss"},null,{"$f":"IF(DY13=\"N\",\"\",IF(Fournisseur!$B$51<>\"\",UPPER(Fournisseur!$B$51),\"\"))","v":"CONTACT COMPTA"},null,{"$f":"IF(Fournisseur!$B$52<>\"\",Fournisseur!$B$52,\"\")","v":"0033670618239"},{"$f":"IF(Fournisseur!$B$53<>\"\",Fournisseur!$B$53,\"\")","v":"0033670618239"},{"$f":"IF(Fournisseur!$B$54<>\"\",Fournisseur!$B$54,\"\")","v":"0000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[{"$f":"A13","v":"1 ligne à intégrer"},{"$f":"B13","v":"SDATA75PARI01"},"N",{"$f":"IF(D13<>\"\",D13,\"\")","v":""},"","DATAXIS SARL","","","Y","N","FR48423163385","N","","","423 163 385 00036","","SUP Frais Generaux","fr_FR","www.dataxis.com","N",null,null,null,null,null,{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"DAP"},null,null,null,null,null,{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"N"},"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,{"$f":"IF(BM13<>\"\",BM13,\"\")","v":"Y"},"T","VIRT FOUR FRANCE","Invoice date + 30 days","PURCHASE LIST EUR","N","N","","Y","Y","C","FR7616607002190936667101272","CCBPFRPPPPG\tXXX","09366671012",null,null,null,null,null,{"$f":"IF(CF13<>\"\",CF13,\"\")","v":"DATAXIS SARL"},null,{"$f":"IF(CH13<>\"\",CH13,\"\")","v":"BANQUE POPULAIRE DU MIDI"},{"$f":"IF(CI13<>\"\",CI13,\"\")","v":"BANQUE POPULAIRE DU SUD"},{"$f":"IF(CJ13<>\"\",CJ13,\"\")","v":"MONTPELLIER"},null,null,{"$f":"IF(CM13<>\"\",CM13,\"\")","v":"FR"},null,null,null,{"$f":"IF(CQ13<>\"\",CQ13,\"\")","v":"EUR"},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B28),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B23),\"\")","v":""},{"$f":"IF(DG13=\"Y\",\"N\",\"Y\")","v":"N"},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B24),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B25),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B26),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B27),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B29),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B28),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B31),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B30),\"\")","v":""},{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B32),\"\")","v":""},null,{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B33),\"\")","v":""},null,{"$f":"IF(CT14=\"N\",\"\",\"Y\")","v":""},{"$f":"IF($CT14=\"Y\",\"N\",\"\")","v":""},{"$f":"IF($CT14=\"Y\",\"N\",\"\")","v":""},{"$f":"IF($CT14=\"Y\",\"N\",\"\")","v":""},null,{"$f":"IF($CT14=\"Y\",\"3\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($CT14=\"Y\",UPPER(Fournisseur!B34),\"\")","v":""},{"$f":"IF(Fournisseur!$B$66<>\"\",UPPER(Fournisseur!$B$66),\"\")","v":""},null,null,{"$f":"IF(Fournisseur!$B$66<>\"\",\"Y\",\"N\")","v":"N"},{"$f":"IF(Fournisseur!$B$71<>\"\",Fournisseur!$B$71,\"\")","v":""},null,{"$f":"IF(Fournisseur!$B$65<>\"\",Fournisseur!$B$65,\"\")","v":"Mr"},null,{"$f":"IF(Fournisseur!$B$67<>\"\",UPPER(Fournisseur!$B$67),\"\")","v":""},null,{"$f":"IF(Fournisseur!$B$68<>\"\",Fournisseur!$B$68,\"\")","v":""},{"$f":"IF(Fournisseur!$B$69<>\"\",Fournisseur!$B$69,\"\")","v":""},{"$f":"IF(Fournisseur!$B$70<>\"\",Fournisseur!$B$70,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[{"$f":"IF(AND(Client!$B$11=Client!$B$26,Client!B49=\"\"),\"1 ligne à intégrer\",\"2 lignes à intégrer\")","v":"1 ligne à intégrer"},{"$f":"IF(AND(DB16=\"FR\",DG16=\"Y\"),UPPER(\"C\"&LEFT(F16,4)&LEFT(CY16,2)&LEFT(CZ16,4)&\"01\"),IF(AND(DB16=\"FR\",DG16=\"N\",DB17=\"FR\"),UPPER(\"C\"&LEFT(F17,4)&LEFT(CY17,2)&LEFT(CZ17,4)&\"01\"),IF(AND(DB16=\"FR\",DG16=\"N\",DB17<>\"FR\"),UPPER(\"C\"&LEFT(F17,4)&LEFT(CY17,2)&LEFT(CZ17,4)&\"01\"&\"_\"&DB17),IF(AND(DB16<>\"FR\",DG16=\"Y\"),UPPER(\"C\"&LEFT(F16,4)&LEFT(CY16,2)&LEFT(CZ16,4)&\"01\"&\"_\"&DB16),IF(AND(DB16<>\"FR\",DG16=\"N\",DB17=\"FR\"),UPPER(\"C\"&LEFT(F17,4)&LEFT(CY17,2)&LEFT(CZ17,4)&\"01\"),IF(AND(DB16<>\"FR\",DG16=\"N\",DB17<>\"FR\"),UPPER(\"C\"&LEFT(F17,4)&LEFT(CY17,2)&LEFT(CZ17,4)&\"01\"&\"_\"&DB17)))))))","v":"C01"},"Y",null,null,{"$f":"IF(Client!$B$3<>\"\",UPPER(Client!$B$3),\"\")","v":""},null,null,"Y","N",{"$f":"IF(Client!$B$6<>\"\",UPPER(Client!$B$6),\"\")","v":""},"N",{"$f":"IF(Client!$B$5<>\"\",UPPER(Client!$B$5),\"\")","v":""},null,{"$f":"IF(Client!$B$4<>\"\",UPPER(Client!$B$4),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(Client!$B$59,Données!$D$14:$E$48,2,0),\"\")","v":"CLT-DIV-FRA"},{"$f":"IF(Client!$B$8<>\"\",Client!$B$8,\"\")","v":"fr_FR"},{"$f":"IF(Client!$B$7<>\"\",Client!$B$7,\"\")","v":""},"N",null,null,null,null,null,{"$f":"IF(Client!$B$23=\"\",\"\",Client!$B$23)","v":"DAP"},null,null,null,null,null,"N","Y",null,{"$f":"IF(Client!$B$60<>\"\",Client!$B$60,\"\")","v":"I"},{"$f":"IF(Client!$B$61<>\"\",Client!$B$61,\"\")","v":"Mensuelle"},{"$f":"IF(Client!$B$62<>\"\",Client!$B$62,\"\")","v":"A"},{"$f":"IF(Client!$B$63<>\"\",Client!$B$63,\"\")","v":"S"},{"$f":"IF(Client!$B$64<>\"\",Client!$B$64,\"\")","v":"SALES LIST"},null,null,{"$f":"IFERROR(VLOOKUP(Client!$B$65,Données!$AQ$9:$AR$12,2,0),\"\")","v":"T"},{"$f":"IF(Client!$B$66<>\"\",Client!$B$66,\"\")","v":"Virement client"},{"$f":"IF(Client!$B$67<>\"\",Client!$B$67,\"\")","v":"Invoice date + 30 days"},null,{"$f":"IF(Client!$B$68<>\"\",Client!$B$68,\"\")","v":"rappel 3 niveaux"},null,{"$f":"IF(Client!$B$69<>\"\",Client!$B$69,\"\")","v":"Y"},null,{"$f":"IF(R16=\"\",\"\",IF(R16=\"fr_FR\",\"Invoice_fr\",\"Invoice_en\"))","v":"Invoice_fr"},null,{"$f":"IF(Client!$B$70<>\"\",Client!$B$70,\"\")","v":14000},null,null,{"$f":"IF(Client!$B$71<>\"\",Client!$B$71,\"\")","v":"Y"},{"$f":"IF(Client!$B$72<>\"\",Client!$B$72,\"\")","v":"O"},{"$f":"IF(Client!$B$73=\"\",\"\",Client!$B$73)","v":"Non affecte"},"N",null,null,null,null,null,null,"N",null,null,null,null,"N","N",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Client!$B$15<>\"\",UPPER(Client!$B$15),\"\")","v":""},{"$f":"IF(Client!$B$10<>\"\",UPPER(Client!$B$10),\"\")","v":""},"Y",{"$f":"IF(Client!$B$11<>\"\",UPPER(Client!$B$11),\"\")","v":""},{"$f":"IF(Client!$B$12<>\"\",UPPER(Client!$B$12),\"\")","v":""},{"$f":"IF(Client!$B$13<>\"\",UPPER(Client!$B$13),\"\")","v":""},{"$f":"IF(Client!$B$14<>\"\",UPPER(Client!$B$14),\"\")","v":""},{"$f":"IF(Client!$B$16<>\"\",UPPER(Client!$B$16),\"\")","v":""},{"$f":"IF(Client!$B$15<>\"\",UPPER(Client!$B$15),\"\")","v":""},{"$f":"IF(Client!$B$18<>\"\",UPPER(Client!$B$18),\"\")","v":""},{"$f":"IF(Client!$B$17<>\"\",UPPER(Client!$B$17),\"\")","v":"FR"},{"$f":"IF(Client!$B$19<>\"\",UPPER(Client!$B$19),\"\")","v":""},{"$f":"IF(Client!$B$20<>\"\",UPPER(Client!$B$20),\"\")","v":""},{"$f":"IF(Client!$B$21<>\"\",UPPER(Client!$B$21),\"\")","v":""},null,"Y",{"$f":"IF(EXACT(CONCATENATE(Client!B10,Client!B11,Client!B12,Client!B13,Client!B14,Client!B15,Client!B16,Client!B17,Client!B18,Client!B19,Client!B21,Client!B22),CONCATENATE(Client!B25,Client!B26,Client!B27,Client!B28,Client!B29,Client!B30,Client!B31,Client!B32,Client!B33,Client!B34,Client!B36,Client!B37))=TRUE,\"Y\",\"N\")","v":"Y"},{"$f":"DH16","v":"Y"},{"$f":"DI16","v":"Y"},null,3,null,null,null,null,null,null,null,null,{"$f":"IF(Client!$B$23<>\"\",UPPER(Client!$B$23),\"\")","v":"DAP"},{"$f":"IF(Client!$B$41<>\"\",UPPER(Client!$B$41),\"\")","v":""},null,null,{"$f":"IF(Client!$B$40<>\"\",\"Y\",\"N\")","v":"N"},{"$f":"IF(Client!$B$46<>\"\",Client!$B$46,\"\")","v":""},null,{"$f":"IF(Client!$B$40<>\"\",Client!$B$40,\"\")","v":""},null,{"$f":"IF(DY16=\"N\",\"\",IF(Client!$B$42<>\"\",UPPER(Client!$B$42),\"\"))","v":""},null,{"$f":"IF(Client!$B$43<>\"\",Client!$B$43,\"\")","v":""},{"$f":"IF(Client!$B$44<>\"\",Client!$B$44,\"\")","v":""},{"$f":"IF(Client!$B$45<>\"\",Client!$B$45,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Client!$B$75<>\"\",Client!$B$75,\"\")","v":"DISTRIBUTEUR"},{"$f":"IF(Client!$B$74<>\"\",Client!$B$74,\"\")","v":"DIST"},{"$f":"IF(Client!$B$76<>\"\",Client!$B$76,\"\")","v":""},{"$f":"IF(Client!$B$77<>\"\",Client!$B$77,\"\")","v":""},{"$f":"IF(Client!$B$78<>\"\",Client!$B$78,\"\")","v":""},"Y",{"$f":"IF(Client!$B$79<>\"\",Client!$B$79,\"\")","v":"SAV RI"},{"$f":"IF(Client!$B$80<>\"\",Client!$B$80,\"\")","v":6},{"$f":"IF(ES16=\"PART\",\"Y\",\"N\")","v":"N"},{"$f":"IF(CU16<>\"\",CU16,\"\")","v":""},{"$f":"IF(CV16<>\"\",CV16,\"\")","v":""},{"$f":"IF(CW16<>\"\",CW16,\"\")","v":""},{"$f":"IF(CX16<>\"\",CX16,\"\")","v":""},{"$f":"IF(CY16<>\"\",CY16,\"\")","v":""},{"$f":"IF(CZ16<>\"\",CZ16,\"\")","v":""},{"$f":"IF(DA16<>\"\",DA16,\"\")","v":""},{"$f":"IF(DB16<>\"\",DB16,\"\")","v":"FR"},"Y",{"$f":"IF(DH16<>\"\",DH16,\"\")","v":"Y"},{"$f":"IF(DG16<>\"\",DG16,\"\")","v":"Y"},"Y",{"$f":"IF(CR16<>\"\",CR16,\"\")","v":""},{"$f":"IF(DC16<>\"\",DC16,\"\")","v":""},"","",{"$f":"IF(Client!$B$22<>\"\",Client!$B$22,\"\")","v":""},{"$f":"IF(CS16<>\"\",CS16,\"\")","v":""},null,null,null,"N"]
[{"$f":"A16","v":"1 ligne à intégrer"},{"$f":"B16","v":"C01"},"N",{"$f":"IF(D16<>\"\",D16,\"\")","v":""},"","","","","Y","N","","N","","","","","CLT-DIV-FRA","fr_FR","","N",null,null,null,null,null,{"$f":"IF(Z16<>\"\",Z16,\"\")","v":"DAP"},null,null,null,null,null,{"$f":"IF(AF16<>\"\",AF16,\"\")","v":"N"},"Y",null,{"$f":"IF(AI16<>\"\",AI16,\"\")","v":"I"},"Mensuelle","A","S","SALES LIST",null,null,{"$f":"IF(AP16<>\"\",AP16,\"\")","v":"T"},"Virement client","Invoice date + 30 days",null,{"$f":"IF(AT16<>\"\",AT16,\"\")","v":"rappel 3 niveaux"},null,{"$f":"IF(AV16<>\"\",AV16,\"\")","v":"Y"},null,{"$f":"IF(AX16<>\"\",AX16,\"\")","v":"Invoice_fr"},null,{"$f":"IF(AZ16<>\"\",AZ16,\"\")","v":14000},null,null,{"$f":"IF(BC16<>\"\",BC16,\"\")","v":"Y"},{"$f":"IF(BD16<>\"\",BD16,\"\")","v":"O"},{"$f":"IF(BE16<>\"\",BE16,\"\")","v":"Non affecte"},"N",null,null,null,null,null,null,"N",null,null,null,null,"N","N",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CT17=\"Y\",UPPER(Client!B30),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B25),\"\")","v":""},{"$f":"IF(DH16=\"Y\",\"N\",\"Y\")","v":"N"},{"$f":"IF($CT17=\"Y\",UPPER(Client!B26),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B27),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B28),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B29),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B31),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B30),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B33),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B32),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B34),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B35),\"\")","v":""},{"$f":"IF($CT17=\"Y\",UPPER(Client!B36),\"\")","v":""},null,{"$f":"IF($CT17=\"Y\",\"N\",\"\")","v":""},{"$f":"IF($CT17=\"N\",\"\",\"Y\")","v":""},{"$f":"IF($CT17=\"N\",\"\",\"Y\")","v":""},"",null,{"$f":"IF($CT17=\"Y\",\"3\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($CT17=\"Y\",UPPER(Client!B38),\"\")","v":""},{"$f":"IF(Client!$B$49<>\"\",UPPER(Client!$B$49),\"\")","v":""},null,null,{"$f":"IF(Client!$B$48<>\"\",\"Y\",\"N\")","v":"N"},{"$f":"IF(Client!$B$54<>\"\",Client!$B$54,\"\")","v":""},null,{"$f":"IF(Client!$B$48<>\"\",Client!$B$48,\"\")","v":""},null,{"$f":"IF(Client!$B$50<>\"\",UPPER(Client!$B$50),\"\")","v":""},null,{"$f":"IF(Client!$B$51<>\"\",Client!$B$51,\"\")","v":""},{"$f":"IF(Client!$B$52<>\"\",Client!$B$52,\"\")","v":""},{"$f":"IF(Client!$B$53<>\"\",Client!$B$53,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(ER16<>\"\",ER16,\"\")","v":"DISTRIBUTEUR"},"DIST","","","","Y","SAV RI",6,"N",{"$f":"IF(CU17<>\"\",CU17,\"\")","v":""},"","","","","","","",{"$f":"IF(CT17=\"Y\",\"Y\",\"\")","v":""},{"$f":"IF(DH17<>\"\",DH17,\"\")","v":""},{"$f":"IF(DG17<>\"\",DG17,\"\")","v":""},{"$f":"IF(CT17=\"Y\",\"N\",\"\")","v":""},{"$f":"IF(CR17<>\"\",CR17,\"\")","v":""},"","","",{"$f":"IF(FI17<>\"\",Client!$B$37,\"\")","v":""},{"$f":"IF(CS17<>\"\",CS17,\"\")","v":""},null,null,null,"N"]
[]
[]
[null,null,"Données fixes"]
[null,null,"Données Calculées"]
[null,null,"Données Compte"]
[null,null,"Données Cordon"]
[null,null,"ne pas remplir"]
[null,null,"Optionnel"]

{"sheet":"Données","index":3,"n_rows":250,"n_cols":114,"rows_kept":250,"cut":false,"hidden":true,"merged":[[0,36,0,37]]}
["Civilité",null,null,"Groupe de tiers",null,null,"Langue",null,null,"IncoTerm",null,null,"Famille",null,null,"Type réparateur",null,null,"Type facture",null,null,"Planning Facture",null,null,"Règle de livraison",null,null,"Livraison via",null,null,"Liste de Prix Vente",null,null,"Liste de Prix Achat",null,null,"Type de compte bancaire",null,null,"Remise",null,null,"Mode de paiement",null,null,"Sous méthode de paiement",null,null,"Délai de paiment",null,null,"Rappel",null,"Format impression facture",null,null,"Format impression expédition",null,"Origine commande",null,null,"Pays",null,"Region",null,"Vérif","Pays","Region","Description",null,"Secteur commercial",null,null,"Transport",null,null,"Actif",null,"SOCreditStatus",null,null,"Prestation",null,"TypeDevis",null,null,"GroupeClient",null,null,"FamilleSAV",null,null,"EnseigneCommercialeSav",null,null,"Devise",null,null,null,null,"Devise","Mode de paiement","Sous méthode de paiement",null,"Branche Fournisseur",null,"Branche","Code branche",null,"Info fournisseur complémentaire",null,null,null,"Compte Comptable"]
["Mrs","Madame",null,"Frais Generaux","SUP Frais Generaux",null,"fr_FR","Français",null,"CFR","Cost and Freight",null,"a1 - NOKIA",null,null,"DA","Cont Workshop gener.",null,"D","Après livraison",null,"Hebdomadaire","Hebdomadaire",null,"A","Disponible",null,"D","Livraison",null,"E01","E01 (Ventes Cordon Multimedia)",null,"OBSOLETE LIST EUR",null,null,"C","Compte courant",null,"Client Ikoda",null,null,"Virement","T",null,"Chèque Fournisseur","Chèque Fournisseur",null,"Date de facture + 30 jours","Invoice date + 30 days",null,"rappel 3 niveaux",null,"Invoice_en","Standard invoice in english",null,null,null,"BT","Bouygues Telecom / CRTI",null,"FR","France","false",null,null,null,null,null,null,"GPE01","France + monaco",null,1,"Transport maritime",null,"Y",null,"H","credit Hold",null,"EXPERT SFR",null,4,"EDI",null,"Non affecte",null,null,"AUCH","AUCHAN",null,"ALPALLIANCE","ALPALLIANCE",null,"BRL","Brazilian Real","Virement Fournisseur hors France (BRL)",null,null,"BRL",null,"Virement Fournisseur hors France (BRL)",null,{"$f":"CONCATENATE(DC2,\" - \",DD2)","v":"FR01 - Transport"},null,"FR01","Transport",null,"LIBRE"]
["Mr","Monsieur",null,"Interim","SUP-INT",null,"de_DE","Allemand",null,"CFR (frais 8%)","Cost and Freight",null,"a10 - LG",null,null,"DB","Returns Otto",null,"I","Immédiate",null,"Mensuelle","Facture le 1er du mois",null,"F","Force",null,"P","Enlèvement",null,"E02","E02 (Ventes Cordon Multimedia)",null,"PURCHASE CORDON","Pricelists for Cordon's group agencies purchases",null,null,null,null,"Groupe G","Groupe G",null,"Carte de crédit","K",null,"Prélévement Fournisseur","Prélévement Fournisseur",null,"Date de facture + 45 jours","Invoice date + 45 days",null,null,null,"Invoice_fr","Standard Invoice in french",null,null,null,"CD","Cordon Web DORO",null,"GB","United Kingdom","false",null,{"$f":"CONCATENATE(BO3,BP3)","v":"AUACT"},"AU","ACT","Australian Capital Territory",null,"GPE02","DOM TOM",null,2,"Transport par chemin de fer",null,"N",null,"O","Credit OK",null,"SAV RI",null,6,"Standard",null,"ACER",null,null,"AUTO","AUTOMOBILE",null,"ALPES BUREAU","ALPES BUREAU",null,"EUR","Euro","Virement Fournisseur hors France (EUR)",null,null,"EUR",null,"Virement Fournisseur hors France (EUR)",null,"FR02 - F.Généraux",null,"FR02","F.Généraux",null,"IMPOSE CLIENT"]
["Miss","Mademoiselle",null,"Intra-Groupe Cordon","SUP Intra-Groupe Cordon",null,"it_IT","Italien",null,"CIF","Cost, Insurance and Freight",null,"a11 - HANNSPREE",null,null,"DC","CES Bremen",null,"O","Commande complète",null,null,null,null,"L","Ligne complète",null,"S","Transporteur",null,"E03","E03 (Ventes Cordon Multimedia)",null,"PURCHASE CORDON USD","Pricelists for Cordon's group agencies purchases USD",null,null,null,null,"Ikoda",null,null,"Prélèvement","C",null,"Carte Bleue Fournisseur","Carte Bleue Fournisseur",null,"Date de facture + 60 jours","60FACT",null,null,null,null,null,null,null,null,"CM","Cordon Multimedia",null,"DE","Germany - Deutschland","false",null,{"$f":"CONCATENATE(BO4,BP4)","v":"AUNSW"},"AU","NSW","",null,"GPE03","Autres Pays (sans risque politique important)",null,3,"Transport par route",null,null,null,"S","Credit stop",null,null,null,7,"Interdit",null,"AIRBUS DEFENSE ET SECURITE",null,null,"BOUY","BOUTIQUE BOUYGUES",null,"ATM GAUNEL","ATM GAUNEL",null,"GBP","British Pound","Virement Fournisseur hors France (GBP)",null,null,"GBP",null,"Virement Fournisseur hors France (GBP)",null,"FR03 - Employés",null,"FR03","Employés"]
[null,null,null,"Pièces / outillage constructeur","SUP Pièces / outillage constructeur",null,"es_ES","Espagnol",null,"CIP","Carriage and Insurance Paid to",null,"a11 - SONY ERICSSON MOBILE",null,null,"DD","Dealer",null,"S","Suivant planning client",null,null,null,null,"M","Manuel",null,null,null,null,"E04","E04 (Ventes Cordon Multimedia)",null,"PURCHASE FREE","Purchase for free",null,null,null,null,"Pourcentage fixe tiers",null,null,"Chèque","S",null,"Virement Fournisseur France","VIRT FOUR FRANCE",null,"Fin de mois","End of the month",null,null,null,null,null,null,null,null,"CW","CordonWeb",null,"ES","Spain","false",null,"AUNT","AU","NT","",null,"GPE04","Europe de l'Ouest",null,4,"Transport par air",null,null,null,"W","credit watvh",null,null,null,null,null,null,"AIRFREE",null,null,"BUT","BUT",null,"AUCHAN","AUCHAN",null,"JPY","Japanese Yen","Virement Fournisseur hors France (JPY)",null,null,"JPY",null,"Virement Fournisseur hors France (JPY)",null,"FR04 - Intérim",null,"FR04","Intérim"]
[null,null,null,"Pièces détachées (France)","SUP-FR-PCE",null,"pt_BR","Portuguese (Brazil)",null,"CPT","Carriage Paid To",null,"a12 - ETEN",null,null,"DE","S+H ALPHA",null,null,null,null,null,null,null,"O","Commande complète",null,null,null,null,"E08","E08 (Ventes Cordon Multimedia)",null,"PURCHASE LIST BRL TTC",null,null,"P","Compte de Portefeuille",null,"Remise Client Intra-Groupe",null,null,null,null,null,"Virement Fournisseur hors France (BRL)","VIRT FOUR ETRAN BRL",null,"Fin de mois + 30 jours","End of month + 30 days",null,null,null,null,null,null,null,null,"DO","DORO France",null,"BE","Belgium","false",null,"AUQLD","AU","QLD","",null,"GPE05","Autre pays",null,5,"Envois postaux",null,null,null,"X","no credit check",null,null,null,null,null,null,"ALCATEL-LUCENT",null,null,"CARR","CARREFOUR",null,"AUDIM","AUDIM",null,"CNY","Yuan Renminbi","Virement Fournisseur hors France (USD)",null,null,"CNY",null,"Virement Fournisseur hors UE",null,"FR05 - App. Stock",null,"FR05","App. Stock"]
[null,null,null,"Pièces détachées (Hors Union européenne)","SUP-EX-PCE",null,"en_GB","English (United Kingdom)",null,"DAF","Delivered At Frontier",null,"a13 - TCL",null,null,"DF","AUDIO GERMANY 2007",null,null,null,null,null,null,null,"R","Dès paiement",null,null,null,null,"E08+3%","E08 (Ventes Cordon Multimedia) + mark up 3%",null,"PURCHASE LIST CHF",null,null,"S","Compte de placement",null,"Remise CMM %Tiers",null,null,null,null,null,"Virement Fournisseur hors France (EUR)","VIRT FOUR ETRAN EUR",null,"Fin de mois + 45 jours","45FDM",null,null,null,null,null,null,null,null,"EC","Econectik",null,"LU","Luxembourg","false",null,"AUSA","AU","SA","",null,"Standard","Standard",null,7,"Installations de transport fixes",null,null,null,null,null,null,null,null,null,null,null,"ALTICE",null,null,"CORA","CORA",null,"BOULANGER","BOULANGER",null,"USD","US Dollar","Virement Fournisseur hors UE",null,"FR","USD",null,"Virement Fournisseur hors France (USD)",null,"FR06 - Honoraires",null,"FR06","Honoraires"]
[null,null,null,"Pièces détachées (Union européenne)","SUP-EU-PCE",null,"pt_PT","Portuguese (Portugal)",null,"DAP","DAP (Import)",null,"a14 - TCL SABA",null,null,"DI","Austria Cont Worksho",null,null,null,null,null,null,null,null,null,null,null,null,null,"E09","E09 (Ventes Cordon Multimedia)",null,"PURCHASE LIST DKK","PURCHASE LIST DKK",null,null,null,null,"Remise TCL %Tiers",null,null,null,null,null,"Virement Fournisseur hors France (GBP)","VIRT FOUR ETRAN GBP",null,"A la commande","Immediate",null,null,null,null,null,null,null,null,"IO","Importé",null,"NL","Nederlands","false",null,"AUTAS","AU","TAS","",null,null,null,null,8,"Transport by inland waterway",null,null,null,null,null,null,null,null,null,null,null,"AM TRUST",null,null,"CRTI","CRTI BOUYGUES",null,"BOUTIQUE BOUYGUES","BOUTIQUE BOUYGUES",null,null,null,null,null,"FR",null,"Virement","Virement Fournisseur France",null,"FR07 - Intercos",null,"FR07","Intercos"]
[null,null,null,"Sous-Traitance","SUP Sous-Traitance",null,null,null,null,"DAP (Europe: frais fixes 2)","Delivered At Place",null,"a15 - TCL THOMSON",null,null,"DJ","Austria Wien",null,null,null,null,null,null,null,null,null,null,null,null,null,"E10","E10 (Ventes Cordon Multimedia)",null,"PURCHASE LIST EUR",null,null,null,null,null,"Remise 15% (THO)","Remise à taux fixe 15% sur les catégories article THO01 à THO24",null,"Virement","T",null,"Virement Fournisseur hors France (JPY)","VIRT FOUR ETRAN JPY",null,null,null,null,null,null,null,null,null,null,null,"LG","CTA LGe",null,"AF","Afghanistan","false",null,"AUVIC","AU","VIC","",null,null,null,null,9,"Propulsion propre",null,null,null,null,null,null,null,null,null,null,null,"AMAZON",null,null,"CSTR","CONSTRUCTEUR",null,"BOUTIQUE ORANGE","BOUTIQUE ORANGE",null,null,null,null,null,"FR",null,"Carte de crédit","Carte Bleue Fournisseur",null,"FR08 - Stations",null,"FR08","Stations"]
[null,null,null,"Transporteurs","SUP Transporteurs",null,"ar_AE","Arabic (United Arab Emirates)",null,"DAP (Europe: frais fixes)","Delivered At Place",null,"a16 - PHILIPS",null,null,"DM","Media/saturn Austria",null,null,null,null,null,null,null,null,null,null,null,null,null,"E11","E11 (Ventes Cordon Multimedia)",null,"PURCHASE LIST GBP",null,null,null,null,null,"Remise 15% (toutes activités)","Remise à taux fixe 15%",null,"Carte de crédit","K",null,"Virement Fournisseur hors France (USD)","VIRT FOUR ETRAN USD",null,null,null,null,null,null,null,null,null,null,null,"MO","Commande manuelle (défaut)",null,"AX","Åland Islands","false",null,"AUWA","AU","WA","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APOGEE",null,null,"DART","DARTY",null,"BOUYGUES FAI","CRTI FAI BOUYGUES",null,null,null,null,null,null,null,"Prélèvement","Prélévement Fournisseur"]
[null,null,null,null,null,null,"ar_BH","Arabic (Bahrain)",null,"DAP (Europe: frais variables)","Delivered At Place",null,"a17 - GSMART",null,null,"DN","SCB ROSTOCK DVD/REC",null,null,null,null,null,null,null,null,null,null,null,null,null,"E12","E12 (Ventes Cordon Multimedia)",null,"PURCHASE LIST HKD",null,null,null,null,null,"Remise 25% (THO)","Remise à taux fixe 25% sur les catégories article THO01 à THO24",null,"Débit immédiat","D",null,"Virement Fournisseur hors UE","VIRT HORS UE EURO",null,null,null,null,null,null,null,null,null,null,null,"NL","NELI Technologies",null,"AL","Albania","false",null,"BRAC","BR","AC","Acre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPLE",null,null,"DEBI","DEBITEL",null,"BOUYGUES GSM","CRTI GSM BOUYGUES",null,null,null,null,null,null,null,"Chèque","Chèque Fournisseur"]
[null,null,null,null,null,null,"ar_DZ","Arabic (Algeria)",null,"DAP (Export: frais variable)","Delivered At Place",null,"a18 - BENQ",null,null,"DO","OTTO",null,null,null,null,null,null,null,null,null,null,null,null,null,"E13","E13 (Ventes Cordon Multimedia)",null,"PURCHASE LIST JPY",null,null,null,null,null,"Remise 25% (toutes activités)","Remise à taux fixe 25%",null,"A crédit","P",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PS","PSAU",null,"DZ","Algeria","false",null,"BRAL","BR","AL","Alagoas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARCHOS",null,null,"DIG","DIGICEL",null,"BUT","BUT",null,"CHF","Swiss Franc"]
[null,null,null,null,null,null,"ar_EG","Arabic (Egypt)",null,"DAP (Export: pas de frais)","Delivered At Place",null,"a19 - BENQ MOBILE - SIEMENS",null,null,"DP","DPM NTC ESSEN",null,null,null,null,null,null,null,null,null,null,null,null,null,"E14","E14 (Ventes Cordon Multimedia)",null,"PURCHASE LIST RON",null,null,null,null,null,"Remise 30% (toutes activités)","Remise à taux fixe 30%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM","Recyclez-moi",null,"AS","American Samoa","false",null,"BRAM","BR","AM","Amazonas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARRIS",null,null,"DIST","DISTRIBUTEUR",null,"CAMARA","CAMARA",null,"DKK","Danish Krone"]
[null,null,null,"CLT Auchan","CLT Auchan",null,"ar_IQ","Arabic (Iraq)",null,"DAP (France + Belgique -TCL)","Delivered At Place",null,"a2 - SHARP",null,null,"DS","SERTRONIC SWITZERLAN",null,null,null,null,null,null,null,null,null,null,null,null,null,"E15","E15 (Ventes Cordon Multimedia)",null,"PURCHASE LIST USD",null,null,null,null,null,"Remise 35% (THO)","Remise à taux fixe 35% sur les catégories article THO01 à THO24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SN","CTA Sony",null,"AD","Andorra","false",null,"BRAP","BR","AP","Amapá",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASURION",null,null,"ELEC","ELECTRO DEPOT",null,"CARREFOUR","CARREFOUR",null,"HKD","Hong Kong Dollar"]
[null,null,null,"CLT Boulanger","CLT Boulanger",null,"ar_JO","Arabic (Jordan)",null,"DAP (France + Belgique)","Delivered At Place",null,"a20 - HOYA",null,null,"DT","GPS WORKSHOP",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALE LIST BRL",null,null,"PURCHASE LIST USD TTC",null,null,null,null,null,"Remise 35% (toutes activités)","Remise à taux fixe 35%",null,"D","Débit immédiat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC","CTA TCL",null,"AO","Angola","false",null,"BRBA","BR","BA","Bahia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASUS",null,null,"FAIS","FAI SFR",null,"CINQ SUR CINQ","CINQ SUR CINQ",null,"HUF","Forint"]
[null,null,null,"CLT BUT","CLT BUT",null,"ar_KW","Arabic (Kuwait)",null,"DAP (pas de frais)","Delivered At Place",null,"a21 - CANAL+",null,null,"DX","DEALER / LCD",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES AASTRA GRO","Pricelists for ASSTRA sales grossiste",null,"STANDARD PRICE","Liste des prix standard",null,null,null,null,"Remise 90%","Remise 90%",null,"S","Chèque",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TL","TCL",null,"AI","Anguilla","false",null,"BRCE","BR","CE","Ceará",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUCHAN",null,null,"FNAC","FNAC",null,"CONCORDE","CONCORDE (DIVERS)",null,"NOK","Norwegian Krone",null,null,null,null,null,null,null,{"$f":"CONCATENATE(DC16,\" - \",DD16)","v":"0001 - AUCHAN"},null,"0001","AUCHAN"]
[null,null,null,"CLT CAP BOULANGER","CLT CAP BOULANGER",null,"ar_LB","Arabic (Lebanon)",null,"DAT","Delivered At Terminal",null,"a22- THOMSON",null,null,"EA","contracted workshop",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES AASTRA 1000","Pricelists for ASSTRA sales 1000",null,null,null,null,null,null,null,"Réseau Distribution",null,null,"P","A crédit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AQ","Antarctica","false",null,"BRDF","BR","DF","Distrito Federal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUDIM",null,null,"FREE","FREE MOBILE",null,"CONFORAMA","CONFORAMA",null,"PLN","Zloty",null,null,null,null,null,null,null,{"$f":"CONCATENATE(DC17,\" - \",DD17)","v":"0002 - AUTOMOBILE"},null,"0002","AUTOMOBILE"]
[null,null,null,"CLT Conforama","CLT Conforama",null,"ar_LY","Arabic (Libya)",null,"DDP","Delivered Duty Paid",null,"a23 - GIGASET",null,null,"EB","Contr. workshop 1",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES AASTRA 500","Pricelists for ASSTRA sales 500",null,null,null,null,null,null,null,"Réseau Distribution ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AG","Antigua And Barbuda","false",null,"BRES","BR","ES","Espírito Santo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BELGACOM",null,null,"FUT","FUTUR TELECOM",null,"CONNEXION","CONNEXION",null,"RON","Leu (new)",null,null,null,null,null,null,null,"0003 - BOULANGER",null,"0003","BOULANGER"]
[null,null,null,"CLT connexion","CLT connexion",null,"ar_MA","Arabic (Morocco)",null,"DES","Delivered Ex Ship",null,"a3 - HTC",null,null,"EC","Contr. workshop 2",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES ACCESSORIES","Price lists for Sales of accessories",null,null,null,null,null,null,null,"TH_Centrale d'Achats pièces détachées",null,null,null,null,null,"Carte Bleue Client","Carte Bleue Client",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR","Argentina","false",null,"BRGO","BR","GO","Goiás",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOULANGER",null,null,"GVT","GLOBAL VILLAGE TELECOM",null,"CONRAD","CONRAD",null,"SEK","Swedish Krona",null,null,null,null,null,null,null,"0004 - BUREAU V",null,"0004","BUREAU V"]
[null,null,null,"CLT CORA","CLT CORA",null,"ar_OM","Arabic (Oman)",null,"EXW","Ex Works",null,"a4 - TELESERVICE",null,null,"ED","Dealer",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES ACCESSORIES Ex.VAT","Prix public de vente des accessoires Hors Taxe",null,null,null,null,null,null,null,"TH_CSTA",null,null,null,null,null,"Cheques clients","Cheques clients",null,"30 jours","30 days (End of month)",null,null,null,null,null,null,null,null,null,null,null,"AM","Armenia","false",null,"BRMA","BR","MA","Maranhão",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOUYGUES TELECOM",null,null,"HRP","HOME REPAIR",null,"CONSTRUCTEUR","CONSTRUCTEUR",null,"SGD","Singapore Dollar",null,null,null,null,null,null,null,"0005 - BUT",null,"0005","BUT"]
[null,null,null,"CLT Darty","CLT Darty",null,"ar_QA","Arabic (Qatar)",null,"FAS","Free Alongside Ship",null,"a5 - G-MOBILE",null,null,"EF","Mastercare / new Spa",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES ACC-Retailer | Revendeur","Default price for client company",null,null,null,null,null,null,null,"TH_Grande Surface spécialisée",null,null,null,null,null,"COMP Pmt Client","COMP Pmt Client",null,"30 days end of month, the 20th","30 days end of month, the 20th",null,null,null,null,null,null,null,null,null,null,null,"AW","Aruba","false",null,"BRMG","BR","MG","Minas Gerais",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUBENDORFF",null,null,"NRJ","NRJ MOBILE",null,"CORA","CORA",null,null,null,null,null,null,null,null,null,null,"0006 - CARREF_IND",null,"0006","CARREF_IND"]
[null,null,null,"CLT DOM - TOM","CLT DOM - TOM",null,"ar_SA","Arabic (Saudi Arabia)",null,"FCA","Free Carrier",null,"a6 - HUWAI",null,null,"EG","Comet",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES ACC-TAX included","Price list including VAT for individual customer",null,null,null,null,null,null,null,"TH_Grossiste Pièces Détachées",null,null,null,null,null,"COMP Pmt Four.","COMP Pmt Four.",null,"30 days end of month, the 5th","30 days end of month, the 5th",null,null,null,null,null,null,null,null,null,null,null,"AU","Australia","true",null,"BRMS","BR","MS","Mato Grosso do Sul",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUREAU VALLEE",null,null,"ONLY","ONLY",null,"CORDON","SITE DU GROUPE CORDON ELECTRONICS",null,null,null,null,null,null,null,null,null,null,"0007 - CARREFOUR",null,"0007","CARREFOUR"]
[null,null,null,"CLT ELECTRO DEPOT","CLT ELECTRO DEPOT",null,"ar_SD","Arabic (Sudan)",null,"FOB","Free On Board",null,"a7 - NEOVIA",null,null,"EH","MFOY Services 224951",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES ACC-Wholesaler | Grossiste","Price list for client company with an more economic price",null,null,null,null,null,null,null,"TH_Revendeurs",null,null,null,null,null,"DECAISSEMENT ESPECE","DECAISSEMENT ESPECE",null,"30 days the 10th of the month","30 days the 10th of the month",null,null,null,null,null,null,null,null,null,null,null,"AT","Austria","false",null,"BRMT","BR","MT","Mato Grosso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUT",null,null,"ORAN","BOUTIQUE ORANGE",null,"CORDON ELECTRONICS","CORDON ELECTRONICS",null,null,null,null,null,null,null,null,null,null,"0008 - CASH C",null,"0008","CASH C"]
[null,null,null,"CLT Auchan","CLT Ens. Proximité",null,"ar_SY","Arabic (Syria)",null,"NA","Non applicable",null,"a8 - AMOI",null,null,"EL","Micro Electronics",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES AEP SONY HGtie","Prix vente produit en échange standart HG",null,null,null,null,null,null,null,"Vente Accessoires CRTI",null,null,null,null,null,"ENCAISSEMENT ESPECE","ENCAISSEMENT ESPECE",null,"45 days (End of month)","45 days (End of month)",null,null,null,null,null,null,null,null,null,null,null,"AZ","Azerbaijan","false",null,"BRPA","BR","PA","Pará",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAISSE D'EPARGNE",null,null,"ORC","ORANGE CARAIBES",null,"CULTURA","CULTURA",null,null,null,null,null,null,null,null,null,null,"0009 - CASH E",null,"0009","CASH E"]
[null,null,null,"CLT Expert","CLT Expert",null,"ar_TN","Arabic (Tunisia)",null,null,null,null,"a9 - SCHNEIDER",null,null,"EO","APPOLO 2000",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CANAL PLUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paiement Effets Client","Paiement Effets Client",null,"end of next month + 15 days","Fin de mois + 15 jours",null,null,null,null,null,null,null,null,null,null,null,"BS","Bahamas","false",null,"BRPB","BR","PB","Paraíba",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAMIF",null,null,"ORF","ORANGE FRANCE",null,"DARTY","DARTY",null,null,null,null,null,null,null,null,null,null,"0010 - CONFORAMA",null,"0010","CONFORAMA"]
[null,null,null,"CLT FEU VERT","CLT FEU VERT",null,"ar_YE","Arabic (Yemen)",null,null,null,null,"b1 - CORDON Dinan",null,null,"ET","UK TN",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CANAL 5 ETOILES","Ventes Canal+ Opération 5*",null,null,null,null,null,null,null,null,null,null,null,null,null,"Prélévement Client","Prélévement Client",null,"End of month + 10 days","FDM10",null,null,null,null,null,null,null,null,null,null,null,"BH","Bahrain","false",null,"BRPE","BR","PE","Pernambuco",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CANAL +",null,null,"PART","PARTICULIER",null,"DIGITAL","DIGITAL",null,null,null,null,null,null,null,null,null,null,"0011 - CONNEXION",null,"0011","CONNEXION"]
[null,null,null,"CLT FNAC","CLT FNAC",null,"be_BY","Byelorussian (Belarus)",null,null,null,null,"b10 - CORDON Dreux",null,null,"EX","MES IRELAND 111149",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CASSIDIAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regul Pmt Client","Regul Pmt Client",null,"End of month + 15 days","FDM15",null,null,null,null,null,null,null,null,null,null,null,"BD","Bangladesh","false",null,"BRPI","BR","PI","Piauí",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CANAL + REUNION",null,null,"PHOG","PHOTOGRAPHE",null,"DISTRIBUTEUR","DISTRIBUTEUR DIVERS",null,null,null,null,null,null,null,null,null,null,"0012 - CORA",null,"0012","CORA"]
[null,null,null,"CLT GITEM","CLT GITEM",null,"bg_BG","Bulgarian (Bulgaria)",null,null,null,null,"b11 - AASTRA","AASTRA",null,"FA","Classe forfait A",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CORDON","Pricelists for Cordon's group agencies sales",null,null,null,null,null,null,null,null,null,null,null,null,null,"Regul Pmt Fourn.","Regul pmt Fourn.",null,"End of month + 20 days","FDM20",null,null,null,null,null,null,null,null,null,null,null,"BB","Barbados","false",null,"BRPR","BR","PR","Paraná",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CANAL OVERSEAS",null,null,"PHOT","PHOTO SERVICE",null,"ELECTRO DEPOT","ELECTRO DEPOT",null,null,null,null,null,null,null,null,null,null,"0013 - CULTURA",null,"0013","CULTURA"]
[null,null,null,"CLT GROUP DIGITAL","CLT GROUP DIGITAL",null,"ca_ES","Catalan (Spain)",null,null,null,null,"b2 - CORDON Cesson",null,null,"FB","Classe forfait B",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CORDON USD","Pricelists for Cordon's group agencies slaes USD",null,null,null,null,null,null,null,null,null,null,null,null,null,"Traite fournisseur","Traite fournisseur",null,"End of month + 25 days","FDM25",null,null,null,null,null,null,null,null,null,null,null,"BY","Belarus","false",null,"BRRJ","BR","RJ","Rio de Janeiro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CARREFOUR",null,null,"POST","LA POSTE MOBILE",null,"ESPACE SFR","ESPACE SFR",null,null,null,null,null,null,null,null,null,null,"0014 - DARTY",null,"0014","DARTY"]
[null,null,null,"CLT HYPER U","CLT HYPER U",null,"cs_CZ","Czech (Czech Republic)",null,null,null,null,"b3 - CORDON Caissargues",null,null,"FC","A-NOVO",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CORDON +15%","Pricelists for Cordon's group agencies sales (with 15% mark-up)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Virement client","Virement client",null,"Facture Réglée","Facture Réglée",null,null,null,null,null,null,null,null,null,null,null,"BZ","Belize","false",null,"BRRN","BR","RN","Rio Grande do Norte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAT",null,null,"PRSE","POINT RELAIS SERVICE",null,"EXPERT","EXPERT",null,null,null,null,null,null,null,null,null,null,"0015 - DECATHLON",null,"0015","DECATHLON"]
[null,null,null,"CLT Intermarche","CLT Intermarche",null,"da_DK","Danish (Denmark)",null,null,null,null,"b4 - CIRMA Hongrie",null,null,"FD","Classe forfait D",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CTA LGe","Prix de vente aux stations techniques LGe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Immediate","Immediate",null,null,null,null,null,null,null,null,null,null,null,"BJ","Benin","false",null,"BRRO","BR","RO","Rondônia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDISCOUNT",null,null,"PSM","POINT SERVICE MOBILE",null,"FNAC","FNAC",null,null,null,null,null,null,null,null,null,null,"0016 - DIST_CROSS",null,"0016","DIST_CROSS"]
[null,null,null,"CLT Internity","CLT Internity",null,"de_AT","German (Austria)",null,null,null,null,"b5 - CIRMA Roumanie",null,null,"FE","DVD garantie",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CTA SONY HGtie","Prix de vente piéce HG aux CTA's SONY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice date + 10 days","10FACT",null,null,null,null,null,null,null,null,null,null,null,"BM","Bermuda","false",null,"BRRR","BR","RR","Roraima",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CELLEBRITE",null,null,"REP","REPARATEUR",null,"FOCI","FOCI",null,null,null,null,null,null,null,null,null,null,"0017 - DIVERS",null,"0017","DIVERS"]
[null,null,null,"CLT LECLERC","CLT LECLERC",null,"de_CH","German (Switzerland)",null,null,null,null,"b6 - CORDON Paris",null,null,"FF","DARTY Plasma 224403",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES CTA TCL","Tarif de référence pour refacturer SFG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice date + 14 days","14FACT",null,null,null,null,null,null,null,null,null,null,null,"BT","Bhutan","false",null,"BRRS","BR","RS","Rio Grande do Sul",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CINQ SUR CINQ",null,null,"SERC","PLATEFORME SERCA",null,"FORD","FORD",null,null,null,null,null,null,null,null,null,null,"0018 - DIVERS TEL",null,"0018","DIVERS TEL"]
[null,null,null,"CLT METRO","CLT METRO",null,"de_LU","German (Luxembourg)",null,null,null,null,"b7 - CORDON Caraïbes",null,null,"FG","DARTY GPS",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES Devis SONY HGtie","Prix de vente piéce HG pour Devis SONY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice date + 15 days","15FACT",null,null,null,null,null,null,null,null,null,null,null,"BO","Bolivia","false",null,"BRSC","BR","SC","Santa Catarina",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COME IN",null,null,"SFR","SFR",null,"FREE MOBILE","FREE MOBILE",null,null,null,null,null,null,null,null,null,null,"0019 - EASY C",null,"0019","EASY C"]
[null,null,null,"CLT MVNO","CLT MVNO",null,"el_CY","Greek (Cyprus)",null,null,null,null,"b8 - CORDON Maroc",null,null,"FN","NON AGREES",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES D&G","Vente piéces en free D&G",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice date + 20 days","20FACT",null,null,null,null,null,null,null,null,null,null,null,"BA","Bosnia And Herzegovina","false",null,"BRSE","BR","SE","Sergipe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPARECYCLE",null,null,"SFRP","SFR PRO",null,"FUTUR TELECOM","FUTUR TELECOM",null,null,null,null,null,null,null,null,null,null,"0020 - ELECTRO D",null,"0020","ELECTRO D"]
[null,null,null,"CLT Pro & cie","CLT Pro & cie",null,"el_GR","Greek (Greece)",null,null,null,null,"b9 - CIRMA Saint Loubès",null,null,"IC","A NO_VO",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES DORO","Price lists for Sales of accessories DORO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW","Botswana","false",null,"BRSP","BR","SP","São Paulo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONFORAMA",null,null,"SHR","SONY HOME REPAIR",null,"GEANT","GEANT",null,null,null,null,null,null,null,null,null,null,"0021 - EMPLOYES",null,"0021","EMPLOYES"]
[null,null,null,"CLT PSM","CLT PSM",null,"en_AU","English (Australia)",null,null,null,null,"CB","For Belgium TN",null,"IE","CENTRO VIDEO HI-FI S",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES EMPLOYEES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice date + 7 days","7FACT",null,null,null,null,null,null,null,null,null,null,null,"BV","Bouvet Island","false",null,"BRTO","BR","TO","Tocantins",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CORIOLIS",null,null,"SPB","SPB",null,"GITEM","GITEM",null,null,null,null,null,null,null,null,null,null,"0022 - EXPERT",null,"0022","EXPERT"]
[null,null,null,"CLT Pulsat","CLT Pulsat",null,"en_CA","English (Canada)",null,null,null,null,"CX","CSE : Schneider",null,"IF","Std workshop Austria",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES FREE","Vente de pièces gratuites (EUR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice date + 75 days","75FACT",null,null,null,null,null,null,null,null,null,null,null,"BR","Brazil","true",null,"CAAlberta","CA","Alberta","Alberta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CROSSCALL",null,null,"TAC","TEL AND COM",null,"GVT","GLOBAL VILLAGE TELECOM",null,null,null,null,null,null,null,null,null,null,"0023 - FNAC",null,"0023","FNAC"]
[null,null,null,"CLT REXEL","CLT REXEL",null,"en_GB","English (United Kingdom)",null,null,null,null,"C1","Réparatateur modul.agréé",null,"JF","Spc workshop Austria",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice date + 90 days","90FACT",null,null,null,null,null,null,null,null,null,null,null,"IO","British Indian Ocean Territory","false",null,"CABritish Columbia","CA","British Columbia","Colombie-Britannique",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D&G",null,null,"VERS","VERSPIEREN",null,"HAVRENNE G ET FILS","HAVRENNE G ET FILS",null,null,null,null,null,null,null,null,null,null,"0024 - GD COMPTE",null,"0024","GD COMPTE"]
[null,null,null,"CLT Serca","CLT Serca",null,"en_IE","English (Ireland)",null,null,null,null,"c1 - Emballages",null,null,"KF","Dealer Austria",null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST CHF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"invoice date + 90 days (end of month)","90CAL",null,null,null,null,null,null,null,null,null,null,null,"BN","Brunei Darussalam","false",null,"CAManitoba","CA","Manitoba","Manitoba",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DARTY",null,null,"VMF","VIRGIN MOBILE",null,"HELFRICH FARRJOP SARL","HELFRICH FARRJOP SARL",null,null,null,null,null,null,null,null,null,null,"0025 - GITEM",null,"0025","GITEM"]
[null,null,null,"CLT Tel & Com","CLT Tel & Com",null,"en_IN","English (India)",null,null,null,null,"C2","CSTA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST DKK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment in 12 time (on 12 month)","X12A",null,null,null,null,null,null,null,null,null,null,null,"BG","Bulgaria","false",null,"CANew Brunswick","CA","New Brunswick","Nouveau-Brunswick",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIGICEL",null,null,null,null,null,"HOME REPAIR","HOME REPAIR",null,null,null,null,null,null,null,null,null,null,"0026 - GPDIS",null,"0026","GPDIS"]
[null,null,null,"CLT Telecom 1","CLT Telecom 1",null,"en_MT","English (Malta)",null,null,null,null,"c2 - Matériel informatique",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST GBP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment in 2 time (on 12 month)","X2A",null,null,null,null,null,null,null,null,null,null,null,"BF","Burkina Faso","false",null,"CANewfoundland, Labrador","CA","Newfoundland, Labrador","Terre-Neuve-et-Labrador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIGITSOLE",null,null,null,null,null,"INTERMARCHE","INTERMARCHE",null,null,null,null,null,null,null,null,null,null,"0027 - HAPPY C",null,"0027","HAPPY C"]
[null,null,null,"CLT Telephone Store","CLT Telephone Store",null,"en_NZ","English (New Zealand)",null,null,null,null,"C3","Point de services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST NOK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment in 3 time (on 3 month)","X3M",null,null,null,null,null,null,null,null,null,null,null,"BI","Burundi","false",null,"CANorthwest Territories","CA","Northwest Territories","Territoires du Nord-Ouest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D-JIX",null,null,null,null,null,"INTERNITY","INTERNITY",null,null,null,null,null,null,null,null,null,null,"0028 - HYPER U",null,"0028","HYPER U"]
[null,null,null,"CLT TOP OFFICE","CLT TOP OFFICE",null,"en_PH","English (Philippines)",null,null,null,null,"c3 - Outillages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST PARTICULIER ECONECTIK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment in 4 time (on 12 month)","X4A",null,null,null,null,null,null,null,null,null,null,null,"KH","Cambodia","false",null,"CANova Scotia","CA","Nova Scotia","Nouvelle-Écosse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOMISYS",null,null,null,null,null,"JACLEM","JACLEM",null,null,null,null,null,null,null,null,null,null,"0029 - INTERCO",null,"0029","INTERCO"]
[null,null,null,"CLT Vivre Mobile","CLT Vivre Mobile",null,"en_SG","English (Singapore)",null,null,null,null,"C4","Grossiste pièces détachées",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST PLN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pre-payment","PrePayment",null,null,null,null,null,null,null,null,null,null,null,"CM","Cameroon","false",null,"CANunavut","CA","Nunavut","Nunavut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DORO",null,null,null,null,null,"JM BRUNEAU","JM BRUNEAU",null,null,null,null,null,null,null,null,null,null,"0030 - LECLERC",null,"0030","LECLERC"]
[null,null,null,"Client Divers France","CLT-DIV-FRA",null,"en_US","English (USA)",null,null,null,null,"c4 - Matériel / Consommables de bureau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST PROFESSIONNEL ECO ECONECTIK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"120 days (end of month)","120FDM",null,null,null,null,null,null,null,null,null,null,null,"CA","Canada","true",null,"CAOntario","CA","Ontario","Ontario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EAF",null,null,null,null,null,"JPG","JPG",null,null,null,null,null,null,null,null,null,null,"0031 - LJ",null,"0031","LJ"]
[null,null,null,"Client export","CLT-DIV-EXP",null,"en_ZA","English (South Africa)",null,null,null,null,"C5","Client export",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST PROFESSIONNEL ECONECTIK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 days (End of month)","15FDM",null,null,null,null,null,null,null,null,null,null,null,"CV","Cape Verde","false",null,"CAPrince Edward Island","CA","Prince Edward Island","Île-du-Prince-Édouard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En attente",null,null,null,null,null,"LA POSTE","LA POSTE",null,null,null,null,null,null,null,null,null,null,"0032 - ORANGE",null,"0032","ORANGE"]
[null,null,null,"Stations Techniques","STA-TEC",null,"es_AR","Spanish (Argentina)",null,null,null,null,"C6","G.S.S.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES LIST SEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 days (end of month)","150FDM",null,null,null,null,null,null,null,null,null,null,null,"KY","Cayman Islands","false",null,"CAQuébec","CA","Québec","Québec",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESPACE SFR",null,null,null,null,null,"LA POSTE MOBILE","LA POSTE MOBILE",null,null,null,null,null,null,null,null,null,null,"0033 - PART",null,"0033","PART"]
[null,null,null,null,null,null,"es_BO","Spanish (Bolivia)",null,null,null,null,"C7","Client Export CA min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES RMA","Prix de vente pour retour au fournisseur/constructeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"180 days (end of month)","10000001",null,null,null,null,null,null,null,null,null,null,null,"CF","Central African Republic","false",null,"CASaskatchewan","CA","Saskatchewan","Saskatchewan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FNAC",null,null,null,null,null,"LA REDOUTE","LA REDOUTE",null,null,null,null,null,null,null,null,null,null,"0034 - PRESENCE V",null,"0034","PRESENCE V"]
[null,null,null,null,null,null,"es_CL","Spanish (Chile)",null,null,null,null,"C8","Client Export CA moy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES SFG","Vente piéces en free SFG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 days (End of month)","20FDM",null,null,null,null,null,null,null,null,null,null,null,"TD","Chad","false",null,"CAYukon","CA","Yukon","Yukon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE MOBILE",null,null,null,null,null,"LDLC","LDLC",null,null,null,null,null,null,null,null,null,null,"0035 - PSM",null,"0035","PSM"]
[null,null,null,null,null,null,"es_CO","Spanish (Colombia)",null,null,null,null,"C9","Client Export CA max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES SONY HGtie","Prix des piéces en HGtie hors réseau CTA SONY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 days (End of month)","25FDM",null,null,null,null,null,null,null,null,null,null,null,"CL","Chile","false",null,"USAK","US","AK","Arkansas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FRISQUET",null,null,null,null,null,"LECLERC","LECLERC",null,null,null,null,null,null,null,null,null,null,"0036 - RECYCLAGE",null,"0036","RECYCLAGE"]
[null,null,null,"CLT EADS","CLT EADS",null,"es_CR","Spanish (Costa Rica)",null,null,null,null,"d1 - NOKIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES TCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29 days (End of month)","29FDM",null,null,null,null,null,null,null,null,null,null,null,"CN","China","false",null,"USAL","US","AL","Alabama",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUTUR TELECOM",null,null,null,null,null,"MAG U","MAG U",null,null,null,null,null,null,null,null,null,null,"0037 - RJ",null,"0037","RJ"]
[null,null,null,"CLT INSTALLATEURS CANAL +","CLT INSTALLATEURS CANAL +",null,"es_DO","Spanish (Dominican Republic)",null,null,null,null,"d2 - QTEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES TCL Hgie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 jours date de Fac le 10 du mois suivant","30FAC10",null,null,null,null,null,null,null,null,null,null,null,"CX","Christmas Island","false",null,"USAR","US","AR","Arkansas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEANT",null,null,null,null,null,"MAISON DE VALERIE","MAISON DE VALERIE",null,null,null,null,null,null,null,null,null,null,"0038 - SEC-VIE",null,"0038","SEC-VIE"]
[null,null,null,"CLT Particulier","CLT Particulier",null,"es_EC","Spanish (Ecuador)",null,null,null,null,"e1 - Transport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES Technicolor","Piéces détachées Technicolor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 days + End of month","45FDM",null,null,null,null,null,null,null,null,null,null,null,"CC","Cocos (keeling) Islands","false",null,"USAZ","US","AZ","Arizona",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GIBSON",null,null,null,null,null,"MOBILE HUT","MOBILE HUT",null,null,null,null,null,null,null,null,null,null,"0039 - SERCA",null,"0039","SERCA"]
[null,null,null,"DEPENSES DIRECTES","DEPENSES DIRECTES",null,"es_GT","Spanish (Guatemala)",null,null,null,null,"f1 - Frais généraux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES USD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 days (End of month)","60FDM",null,null,null,null,null,null,null,null,null,null,null,"CO","Colombia","false",null,"USCA","US","CA","California",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GIGASET",null,null,null,null,null,"MOBISTORE","MOBISTORE",null,null,null,null,null,null,null,null,null,null,"0040 - SFD",null,"0040","SFD"]
[null,null,null,"Employes","Employes",null,"es_HN","Spanish (Honduras)",null,null,null,null,"g1 - Vente WEB tarif distributeur normal",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TCL SALES PANEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 days (end of month)","60CAL",null,null,null,null,null,null,null,null,null,null,null,"KM","Comoros","false",null,"USCO","US","CO","Colorado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLOBAL VILLAGE TELECOM",null,null,null,null,null,"MONOPRIX","MONOPRIX",null,null,null,null,null,null,null,null,null,null,"0041 - SFR",null,"0041","SFR"]
[null,null,null,"Inter Organisation","Inter Organisation",null,"es_MX","Spanish (Mexico)",null,null,null,null,"g2 - Vente WEB tarif distributeur éco",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5408 ZCFR France",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 days end of month, the 10th","60FDM10",null,null,null,null,null,null,null,null,null,null,null,"CG","Congo","false",null,"USCT","US","CT","Connecticut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRAS SAVOYE",null,null,null,null,null,"MR BRICOLAGE","MR BRICOLAGE",null,null,null,null,null,null,null,null,null,null,"0042 - STA-TEC",null,"0042","STA-TEC"]
[null,null,null,"Intra Groupe","Intra Groupe",null,"es_NI","Spanish (Nicaragua)",null,null,null,null,"g3 - Vente WEB tarif particulier",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5408 ZCFR France PRIX NETS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 days end of month, the 15th","60FDM15",null,null,null,null,null,null,null,null,null,null,null,"CD","Congo The Democratic Republic Of The","false",null,"USDC","US","DC","District of Columbia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERCULES",null,null,null,null,null,"NEUTER","NEUTER",null,null,null,null,null,null,null,null,null,null,"0043 - VIVRE MOB",null,"0043","VIVRE MOB"]
[null,null,null,"IO CRTI","Inter Organisation CRTI",null,"es_PA","Spanish (Panama)",null,null,null,null,1,"Industrie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5409 ZCFR Export",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 days end of month, the 5th","60FDM5",null,null,null,null,null,null,null,null,null,null,null,"CK","Cook Islands","false",null,"USDE","US","DE","Deleware",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOVIDIS",null,null,null,null,null,"NRJ","NRJ",null,null,null,null,null,null,null,null,null,null,"0044 - IO",null,"0044","IO"]
[null,null,null,"Standard","Standard",null,"es_PE","Spanish (Peru)",null,null,null,null,10,"Central Achat SAV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5409 ZCFR Export PRIX NETS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"720 JOURS BLOCAGE PAIEMENTS","720 JOURS",null,null,null,null,null,null,null,null,null,null,null,"FC","Corse","false",null,"USFL","US","FL","Florida",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOYA",null,null,null,null,null,"OFFICE DEPOT/VICKING","OFFICE DEPOT/VICKING",null,null,null,null,null,null,null,null,null,null,"0045 - PR",null,"0045","PR"]
[null,null,null,"SUP Consommables (hors pièces CST)","SUP Consommables (hors pièces Constructeur)",null,"es_PR","Spanish (Puerto Rico)",null,null,null,null,13,"SAV Revendeurs PF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 days (end of month)","90FDM",null,null,null,null,null,null,null,null,null,null,null,"CR","Costa Rica","false",null,"USGA","US","GA","Georgia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP",null,null,null,null,null,"PARTICULIER","PARTICULIER"]
[null,null,null,"SUP DARTY","SUP DARTY",null,"es_PY","Spanish (Paraguay)",null,null,null,null,14,"SAV GR d'Achat PF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 days end of month, the 10th","90FDM10",null,null,null,null,null,null,null,null,null,null,null,"CI","Cote D'ivoire","false",null,"USHI","US","HI","Hawaii",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTC",null,null,null,null,null,"PARTNER JOUET","PARTNER JOUET"]
[null,null,null,"SUP MOBISTORE","SUP MOBISTORE",null,"es_SV","Spanish (El Salvador)",null,null,null,null,15,"Grossiste PF S/Contr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HR","Croatia","false",null,"USIA","US","IA","Iowa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUAWEI",null,null,null,null,null,"PHONE HOUSE","PHONE HOUSE"]
[null,null,null,null,null,null,"es_US","Spanish (USA)",null,null,null,null,16,"SAV Vte par Corresp.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CU","Cuba","false",null,"USID","US","ID","Idaho",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFINIX",null,null,null,null,null,"PHOTO SERVICE","PHOTO SERVICE"]
[null,null,null,null,null,null,"es_UY","Spanish (Uruguay)",null,null,null,null,17,"Code Interne",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CY","Cyprus","false",null,"USIL","US","IL","Illinois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INTERNITY",null,null,null,null,null,"PHOTO STATION","PHOTO STATION"]
[null,null,null,null,null,null,"es_VE","Spanish (Venezuela)",null,null,null,null,18,"Loueurs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CZ","Czech Republic","false",null,"USIN","US","IN","Indiana",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA POSTE MOBILE",null,null,null,null,null,"PHOTOGRAPHE","PHOTOGRAPHE"]
[null,null,null,null,null,null,"et_EE","Estonian (Estonia)",null,null,null,null,2,"SAV Grd Surf Aliment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DK","Denmark","false",null,"USKS","US","KS","Kansas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LECLERC",null,null,null,null,null,"PHOX","PHOX"]
[null,null,null,null,null,null,"fa_IR","Farsi (Iran)",null,null,null,null,23,"Administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJ","Djibouti","false",null,{"$f":"CONCATENATE(BO68,BP68)","v":"USKY"},"US","KY","Kentucky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LENOVO",null,null,null,null,null,"PLANETE SATURN","PLANETE SATURN"]
[null,null,null,null,null,null,"fi_FI","Finnish (Finland)",null,null,null,null,30,"DIVERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM","Dominica","false",null,"USLA","US","LA","Lousiana",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LG MOBILES",null,null,null,null,null,"POINT RELAIS SERVICE","POINT RELAI SERVICE"]
[null,null,null,null,null,null,"fr_BE","French (Belgium)",null,null,null,null,4,"SAV K7 Duplicateurs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO","Dominican Republic","false",null,"USMA","US","MA","Massachusetts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOGICOM",null,null,null,null,null,"POINT SERVICE MOBILE","POINT SERVICE MOBILE"]
[null,null,null,null,null,null,"fr_CA","French (Canada)",null,null,null,null,5,"Central Achat SAV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EC","Ecuador","false",null,"USMD","US","MD","Maryland",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAPPY",null,null,null,null,null,"PRO & CIE","PRO & CIE"]
[null,null,null,null,null,null,"fr_CH","French (Switzerland)",null,null,null,null,6,"G.S.S.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EG","Egypt","false",null,"USME","US","ME","Maine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MARSHALL HEADPHONES",null,null,null,null,null,"PULSAT","PULSAT"]
[null,null,null,null,null,null,"fr_FR","French (France)",null,null,null,null,63,"Partenaires TCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SV","El Salvador","false",null,"USMI","US","MI","Michigan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MASTERNAUT",null,null,null,null,null,"REPARATEUR","REPARATEUR"]
[null,null,null,null,null,null,"fr_LU","French (Luxembourg)",null,null,null,null,7,"Grossiste Prod Fini",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GQ","Equatorial Guinea","false",null,"USMN","US","MN","Minnesota",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC VISION",null,null,null,null,null,"SATURN","SATURN"]
[null,null,null,null,null,null,"ga_IE","Irish (Ireland)",null,null,null,null,9,"Dépanneurs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ER","Eritrea","false",null,"USMO","US","MO","Missouri",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEDION",null,null,null,null,null,"SFD","SFD"]
[null,null,null,null,null,null,"hi_IN","Hindi (India)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE","Estonia","false",null,"USMS","US","MS","Mississippi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEILLEUR MOBILE",null,null,null,null,null,"SHOWROOM PRIVE","SHOWROOM PRIVE"]
[null,null,null,null,null,null,"hr_HR","Croatian (Croatia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ET","Ethiopia","false",null,"USMT","US","MT","Montana",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEIZU",null,null,null,null,null,"SONY","SONY"]
[null,null,null,null,null,null,"hu_HU","Hungarian (Hungary)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FK","Falkland Islands (malvinas)","false",null,"USNC","US","NC","North Carolina",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOBICASH",null,null,null,null,null,"SONY HOME REPAIR","SONY HOME REPAIR"]
[null,null,null,null,null,null,"in_ID","Indonesian (Indonesia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO","Faroe Islands","false",null,"USND","US","ND","North Dakota",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOBIWIRE",null,null,null,null,null,"SPB","SPB"]
[null,null,null,null,null,null,"is_IS","Icelandic (Iceland)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FJ","Fiji","false",null,"USNE","US","NE","Nebraska",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOTOROLA",null,null,null,null,null,"SPICERS/PLEIN CIEL/CALIPAGE","SPICERS/PLEIN CIEL/CALIPAGE"]
[null,null,null,null,null,null,"it_CH","Italian (Switzerland)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FI","Finland","false",null,"USNH","US","NH","New Hampshire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NELI TECHNOLOGIES",null,null,null,null,null,"STAPLES (JPG)","STAPLES (JPG)"]
[null,null,null,null,null,null,"iw_IL","Hebrew (Israel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GF","French Guiana","false",null,"USNJ","US","NJ","New Jersey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NESPRESSO FRANCE S.A.S.",null,null,null,null,null,"SURCOUFF","SURCOUFF"]
[null,null,null,null,null,null,"ja_JP","Japanese (Japan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PF","French Polynesia","false",null,"USNM","US","NM","New Mexico",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET",null,null,null,null,null,"TEL AND COM","TEL AND COM"]
[null,null,null,null,null,null,"ko_KR","Korean (South Korea)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TF","French Southern Territories","false",null,"USNV","US","NV","Nevada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOKIA",null,null,null,null,null,"TELECOM 1","TELECOM 1"]
[null,null,null,null,null,null,"lt_LT","Lithuanian (Lithuania)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA","Gabon","false",null,"USNY","US","NY","New York",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NRJ MOBILE",null,null,null,null,null,"TELEPHONE STORE","TELEPHONE STORE"]
[null,null,null,null,null,null,"lv_LV","Latvian (Lettish) (Latvia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GM","Gambia","false",null,"USOH","US","OH","Ohio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONLY",null,null,null,null,null,"UBALDI","UBALDI"]
[null,null,null,null,null,null,"mk_MK","Macedonian (Macedonia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GE","Georgia","false",null,"USOK","US","OK","Oklahoma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORANGE CARAIBE",null,null,null,null,null,"VAG","VAG"]
[null,null,null,null,null,null,"ms_MY","Malay (Malaysia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D*","Germany - Deutschland *","false",null,"USOR","US","OR","Oregon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORANGE FRANCE",null,null,null,null,null,"VENTE PRIVEE","VENTE PRIVEE"]
[null,null,null,null,null,null,"mt_MT","Maltese (Malta)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GH","Ghana","false",null,"USPA","US","PA","Pennsylvania",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSMOS",null,null,null,null,null,"VIRGIN MOBILE","VIRGIN MOBILE"]
[null,null,null,null,null,null,"nl_BE","Dutch (Belgium)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GI","Gibraltar","false",null,"USRI","US","RI","Rhode Island",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PACE",null,null,null,null,null,"VIVRE MOBILE","VIVRE MOBILE"]
[null,null,null,null,null,null,"nl_NL","Dutch (Netherlands)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GR","Greece","false",null,"USSC","US","SC","South Carolina",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHILIPS AVM"]
[null,null,null,null,null,null,"no_NO","Norwegian (Norway)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GL","Greenland","false",null,"USSD","US","SD","South Dakato",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLANETE SATURN"]
[null,null,null,null,null,null,"pl_PL","Polish (Poland)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GD","Grenada","false",null,"USTN","US","TN","Tennessee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POINT RELAIS SERVICE"]
[null,null,null,null,null,null,"ro_RO","Romanian (Romania)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GP","Guadeloupe","false",null,"USTX","US","TX","Texas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POINT SERVICE MOBILE"]
[null,null,null,null,null,null,"ru_RU","Russian (Russia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GU","Guam","false",null,"USUT","US","UT","Utah",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO & CIE"]
[null,null,null,null,null,null,"sk_SK","Slovak (Slovakia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GT","Guatemala","false",null,"USVA","US","VA","Virginia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROXIMUS"]
[null,null,null,null,null,null,"sl_SI","Slovenian (Slovenia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GG","Guernsey","false",null,"USVT","US","VT","Vermont",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PULSAT"]
[null,null,null,null,null,null,"sq_AL","Albanian (Albania)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN","Guinea","false",null,"USWA","US","WA","Washington",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RCBT"]
[null,null,null,null,null,null,"sr_BA","Serbian (Bosnia and Herzegovina)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GW","Guinea-bissau","false",null,"USWI","US","WI","Wisconsin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAGEMCOM BROADBAND SAS"]
[null,null,null,null,null,null,"sr_CS","Serbian (Serbia and Montenegro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GY","Guyana","false",null,"USWV","US","WV","West Virginia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAGEMCOM ENERGIE ET TELECOM"]
[null,null,null,null,null,null,"sr_ME","Serbian (Montenegro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HT","Haiti","false",null,"USWY","US","WY","Wyoming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCEE"]
[null,null,null,null,null,null,"sr_RS","Serbian (Serbia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HM","Heard Island And Mcdonald Islands","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERCA"]
[null,null,null,null,null,null,"sv_SE","Swedish (Sweden)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA","Holy See (vatican City State)","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SFD"]
[null,null,null,null,null,null,"th_TH","Thai (Thailand)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HN","Honduras","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SFG"]
[null,null,null,null,null,null,"tr_TR","Turkish (Turkey)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HK","Hong Kong","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SFR NUMERICABLE"]
[null,null,null,null,null,null,"uk_UA","Ukrainian (Ukraine)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HU","Hungary","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SFR PRO"]
[null,null,null,null,null,null,"vi_VN","Vietnamese (Vietnam)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IS","Iceland","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHARP"]
[null,null,null,null,null,null,"zh_CN","Chinese (China)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN","India","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIERRA WIRELESS"]
[null,null,null,null,null,null,"zh_HK","Chinese (Hong Kong)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID","Indonesia","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOMC"]
[null,null,null,null,null,null,"zh_SG","Chinese (Singapore)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IR","Iran Islamic Republic Of","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY Automotive Entertainment Solutions Europe (AES)"]
[null,null,null,null,null,null,"zh_TW","Chinese (Taiwan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ","Iraq","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY COMPUTER ENTERTAINMENT EUROPE (SCEE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IE","Ireland","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY CORPORATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IM","Isle of Man","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY EUROPE LIMITED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IL","Israel","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY France"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Italy","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY MOBILE COMMUNICATIONS (SMC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JM","Jamaica","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY PROFESSIONAL SOLUTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JP","Japan","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sony Semiconductors Electronics Solutions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JE","Jersey","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SONY Service Quality Environment (SQE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JO","Jordan","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOURCING&CREATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KZ","Kazakhstan","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KE","Kenya","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SQUARE ENIX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KI","Kiribati","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TALDEC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KP","Korea Democratic People's Republic Of","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TCL OVERSEAS MARKETING (MCO) LTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KR","Korea Republic Of","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECHNICOLOR DELIVERY TECHNOLOGIES S.A.S."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XK","Kosovo","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TELEDIFFUSION DE France"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KW","Kuwait","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TELEFONICA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KG","Kyrgyzstan","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THEOBALD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA","Lao People's Democratic Republic","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV","Latvia","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNA Electronique"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LB","Lebanon","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOSHIBA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LS","Lesotho","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSPIEREN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LR","Liberia","false",null,{"$f":"CONCATENATE(BO132,BP132)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VESTEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LY","Libyan Arab Jamahiriya","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIRGIN MOBILE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LI","Liechtenstein","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIVENDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LT","Lithuania","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIVRE MOBILE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO","Macao","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VODAFONE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MK","Macedonia Former Yugoslav Republic Of","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIKO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MG","Madagascar","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOOX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MW","Malawi","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YOTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MY","Malaysia","false",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZTE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MV","Maldives","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ML","Mali","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT","Malta","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MH","Marshall Islands","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MQ","Martinique","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MR","Mauritania","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MU","Mauritius","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YT","Mayotte","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MX","Mexico","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FM","Micronesia Federated States Of","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD","Moldova Republic Of","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC","Monaco","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN","Mongolia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME","Montenegro","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS","Montserrat","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA","Morocco","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MZ","Mozambique","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MM","Myanmar","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA","Namibia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR","Nauru","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NP","Nepal","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN","Netherlands Antilles","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC","New Caledonia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ","New Zealand","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NI","Nicaragua","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE","Niger","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NG","Nigeria","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NU","Niue","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NF","Norfolk Island","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MP","Northern Mariana Islands","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO","Norway","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OM","Oman","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PK","Pakistan","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PW","Palau","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PS","Palestinian Territory Occupied","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA","Panama","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PG","Papua New Guinea","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PY","Paraguay","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PE","Peru","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH","Philippines","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PN","Pitcairn","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PL","Poland","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT","Portugal","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR","Puerto Rico","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QA","Qatar","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RE","Reunion","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RO","Romania","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RU","Russian Federation","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RW","Rwanda","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BL","Saint Barthélemy","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SH","Saint Helena","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KN","Saint Kitts And Nevis","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LC","Saint Lucia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MF","Saint Martin","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM","Saint Pierre And Miquelon","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VC","Saint Vincent And The Grenadines","false",null,{"$f":"CONCATENATE(BO196,BP196)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WS","Samoa","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM","San Marino","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST","Sao Tome And Principe","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA","Saudi Arabia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SN","Senegal","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RS","Serbia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC","Seychelles","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL","Sierra Leone","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SG","Singapore","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SK","Slovakia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI","Slovenia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SB","Solomon Islands","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SO","Somalia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZA","South Africa","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GS","South Georgia And The South Sandwich Islands","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LK","Sri Lanka","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD","Sudan","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR","Suriname","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SJ","Svalbard And Jan Mayen","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SZ","Swaziland","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SE","Sweden","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH","Switzerland","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SY","Syrian Arab Republic","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TW","Taiwan","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TJ","Tajikistan","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TZ","Tanzania United Republic Of","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TH","Thailand","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TL","Timor-leste","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TG","Togo","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TK","Tokelau","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","Tonga","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TT","Trinidad And Tobago","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN","Tunisia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TR","Turkey","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TM","Turkmenistan","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC","Turks And Caicos Islands","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TV","Tuvalu","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UG","Uganda","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UA","Ukraine","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AE","United Arab Emirates","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US","United States","true",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UM","United States Minor Outlying Islands","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UY","Uruguay","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UZ","Uzbekistan","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VU","Vanuatu","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VE","Venezuela","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VN","Viet Nam","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VG","Virgin Islands British","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI","Virgin Islands U.s.","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WF","Wallis And Futuna","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EH","Western Sahara","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YE","Yemen","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZM","Zambia","false",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZW","Zimbabwe","false",null,""]