{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":[" fiche ouverture cpt client","Feuil2","Logo"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":27,"comments":0,"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":" fiche ouverture cpt client","index":0,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[31,1,31,2],[38,7,38,8],[34,3,34,5],[63,3,63,4],[51,1,51,9],[55,3,55,7],[48,3,48,9],[63,7,63,9],[35,1,35,2],[34,1,34,2],[36,1,36,2],[61,3,61,4],[59,1,59,2],[57,3,57,4],[10,1,10,2],[12,3,12,4],[36,3,36,5],[27,3,27,9],[4,1,4,2],[12,7,12,9],[30,6,30,9],[32,3,32,5],[19,3,19,9],[28,3,28,9],[16,1,16,2],[27,1,27,2],[29,3,29,9],[28,1,28,2],[23,1,23,9],[26,6,26,9],[3,1,3,2],[56,1,56,2],[55,1,55,2],[53,1,53,2],[29,1,29,2],[30,1,30,2],[19,1,19,2],[6,2,6,9],[10,7,10,9],[10,5,10,6],[11,1,11,2],[20,3,20,9],[8,1,8,9],[18,1,18,2],[16,3,16,6],[11,7,11,9],[14,3,14,5],[59,3,59,4],[62,7,62,9],[55,8,55,9],[57,1,57,2],[35,3,35,4],[42,3,42,5],[39,4,39,5],[31,3,31,5],[62,3,62,4],[52,1,52,9],[40,4,40,5],[18,3,18,4],[22,3,22,9],[33,1,33,9],[25,7,25,8],[65,1,65,9],[53,3,53,7],[49,6,49,9],[46,3,46,9],[47,3,47,9],[64,3,64,4]]}
[]
[]
[]
[null,"Listes déroulantes"]
[null,"A saisir"]
[]
[null,null,"DEMANDE D'OUVERTURE OU DE MODIFICATION D'UN COMPTE CLIENT"]
[]
[null,"1 - PARTIE A COMPLETER PAR LE RESPONSABLE DE SITE"]
[]
[null,"Date demande :",null,"2021-10-01",null,"Votre Nom",null,"terracher bruno "]
[null,"Type demande :",null,"Création",null,null,"Tél. :",545369759]
[null,"Code client si modification :"]
[]
[null,"Division :",null,"Education"]
[]
[null,"Société :",null,"SFRS",null,null,null,null,"Code société :",10]
[]
[null,"Code FR / SO :",null,"FR 101036"]
[null,"Nom du Site :",null,"cuisine centrale de jarnac "]
[]
[null,"Nom du client livré (à compléter uniquement pour les utilisateurs de MEZOES ), nom qui apparait dans la liste de recherche :"]
[]
[null,"2 - PARTIE A COMPLETER AVEC LE CLIENT"]
[]
[null,null,2,"CLIENT :",null,null,1,"Code Service Executant :"]
[null,"Adresse de facturation :"]
[null,"Nom de l'entreprise :",null,"Mairie d'AUSSAC-VADALLE"]
[null,"Adresse :",null,"61, rue de la République"]
[]
[null,"Code postal :",null,16560,null,"Ville :","AUSSAC-VADALLE"]
[null,"N° SIREN / SIRET :",null,21160024200013]
[null,"N° intracommunautaire :"]
[null,"Interlocuteur comptable chez le client :"]
[null,"Nom et prénom du contact :",null,"Mme KERJEAN Madeleine"]
[null,"Son Téléphone :",null,"05 45 20 61 60"]
[null,"Son adresse mail :",null,"adjoint2@aussac-vadalle.fr"]
[]
[null,null,null,"ENVOI DES FACTURES EN PDF SIGNE :",null,"Choix",null,"Option PDF"]
[null,null,null,"MAIL 1 :"]
[null,null,null,"MAIL 2 :"]
[]
[null,null,"Code envoi :","3 - envoi de la facture direct au client"]
[]
[null,"Adresse d'expédition (si différente de l'adresse de facturation) :"]
[]
[null,"Nom :"]
[null,"Adresse :"]
[]
[null,"Code postal :",null,null,null,"Ville :"]
[]
[null,"3 - Interne SODEXO - PARTIE A COMPLETER PAR LES SERVICES FINANCIERS du groupe SODEXO"]
[]
[null,"Conditions de Paiement :"]
[]
[null,"Frais fixes(si différent CP) :"]
[]
[null,"Mode de Paiement :"]
[]
[null,"Frais fixes(si différent MP) :"]
[]
[null,null,"Crédit manager",null,null,"CSP","comptabilité"]
[null,null,"      Code intérêt :",null,null,null,"Compte collectif :","41100100 Clients HG"]
[null,null," Note info légale :",null,null,null,"Régime TVA :","1 - encaissement"]
[null,"   Critère de recherche 2 :"]

{"sheet":"Feuil2","index":1,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
["TVA","Type demande","Je souhaité créer","Condition de paiement","Mode de paiement","Code Intérêt","Agence commerciale","Groupe clients (mise sous pli) :","Collectif","Division","Sociéte","Choix","Note infolégale","Option PDF",null,null,null,"Division",null,"Sociéte"]
["1 - encaissement",null,null,"Idem Modalités Paiement","Idem Modalités Paiement","F1 TAUX INTERET LEGAL X 3","Z001 Clients Publics","3 - envoi de la facture direct au client","41100000 Clients cptes attente","Entreprises ","SODEXO ENTREPRISES","Oui",1,"facture PDF en pièce jointe",null,null,null,{"$f":"' fiche ouverture cpt client'!D15","v":"Education"},null,"SFRS"]
["0 - débit","Création","Un Donneur d'Ordre","C001 payable immédiatement sans déduction","9 - Prélèvement SEPA","F2 PRIVES LEGAL 120 EUR","Z002 Clients Privés","4 - envoi de la facture sur le site","41100001 Clients Scolaires SOGERES","Santé Hôpitaux cliniques","SXO Santé Médico Social","Non",2,"Relevé avec lien URL",null,null,null,null,null,"SOGERES"]
[null,"Modification","Association (GE)","C002 au 25 du mois sans déduction (date pièce)","6 - Virement bancaire","F5 PUBLIC LEGAL 70 EUR","Z003 Concession Affermage","6 - envoi au service Crédit Management","41100002 Clients Sante SOGERES","Santé Médico-Social","SOGERES",null,3,null,null,null,null,null,null,"LA NORMANDE SA"]
[null,null,null,"C003 au 30 du mois en cours M sans déduct (date piece)","4 - Encaissement chèque","F6 PUBLIC LEGAL 120 EUR",null,"9 - pas d'envoi","41100003 Clients Entreprises SOGERES","Education","SFRS",null,4,null,null,null,null,null,null,"SMRS"]
[null,null,null,"C004 au 5 du mois suivant M+1 (date piece)","3 - Avis de domiciliation permanent","F7 BCE + 8%",null,null,"41100005 Clients HG plateaux repas","Sports et Loisirs","SODEXO SPORTS et LOISIRS",null,5,null,null,null,null,null,null,"SBRS"]
[null,null,null,"C006  au 10 du mois suivant M+1 (date piece)",null,"F8 PUBLIC BCE 120 EUR",null,null,"41100100 Clients HG","Justice, Défense, Guyane","SODEXO JUSTICE SERVICES",null,6,null,null,null,null,null,null,"STRS"]
[null,null,null,"C007  au 15 du mois suivant M+1 (date piece)",null,"FX PRIVES LEG SANS CALC",null,null,"41100110 Clients Comptant","Justice, Défense, Guyane","SODEXO ENTREPRISES",null,7,null,null,null,null,null,null,"SAGERE"]
[null,null,null,"C008  au 20 du mois suivant M+1 (date piece)",null,"FY PRIVES BCE SANS CALC",null,null,"41100140 Clients HG Armées","Entreprises ","SODEXO MONACO",null,8]
[null,null,null,"C009  au 25 du mois suivant M+1 (date piece)",null,"FZ  BCE + 10%",null,null,"41100150 Clients Hg Administration Pénitentiaire","Entreprises ","SOGERES",null,9]
[null,null,null,"C010 au 30 du mois suivant M+1 (date piece)",null,null,null,null,"41100200 Client Retenue de garantie","Entreprises ","SODEXO HYGIENE & PROPRETE",null,10]
[null,null,null,"C011 au 5 dans 2 mois M+2 (date piece)",null,null,null,null,null,"Entreprises ","SODEXO ENERGIE et MAINT.",null,11]
[null,null,null,"C012 au 10 dans 2 mois M+2 (date piece)",null,null,null,null,null,"Santé Médico-Social","SXO Santé Médico Social",null,12]
[null,null,null,"C013 au 15 dans 2 mois M+2 (date piece)",null,null,null,null,null,"Santé Médico-Social","SOC.RESTAU.AUBERGE.LIENS",null,13]
[null,null,null,"C014 au 25 dans 2 mois M+2 (date de pièce)",null,null,null,null,null,"Education","SOGERES",null,14]
[null,null,null,"C015  au 30 dans 2 mois M+2 (date de piece)",null,null,null,null,null,"Education","LA NORMANDE SA",null,15]
[null,null,null,"C016 au 10 dans 3 mois (date de piece)",null,null,null,null,null,"Education","SMRS",null,16]
[null,null,null,"C017 dans 14j sans déduction (date de piece)",null,null,null,null,null,"Education","SBRS",null,17]
[null,null,null,"C018 dans 28j sans déduction (date de piece)",null,null,null,null,null,"Education","STRS",null,18]
[null,null,null,"C019 dans 30j sans déduction (date de piece)",null,null,null,null,null,"Education","SAGERE",null,19]
[null,null,null,"C022  dans 45j sans déduction (date de piece)",null,null,null,null,null,"Justice, Défense, Guyane","ETABLISSEEMENT GUYANE",null,20]
[null,null,null,"C026 dans 30j sans déduction FdM (date de piece)",null,null,null,null,null,"Justice, Défense, Guyane","SODEXO GUYANE"]
[null,null,null,"C027 dans 60j sans déduction FdM (date de piece)",null,null,null,null,null,"Justice, Défense, Guyane","SHTG"]
[null,null,null,"C040 payable immédiatement sans déduction",null,null,null,null,null,"Justice, Défense, Guyane","SODEXNET"]
[null,null,null,"C041 au 31 du mois en cours M (date de piece)",null,null,null,null,null,"Justice, Défense, Guyane","SODEXO GUYANE SERVICES"]
[null,null,null,"C043 au 1er dans 3 mois M+3 (date de piece)",null,null,null,null,null,"Justice, Défense, Guyane","SODEXO Compétences Emploi"]
[null,null,null,"C045 au 10 du mois en cours M (date de piece)",null,null,null,null,null,"Sports et Loisirs","SEINOVISION"]
[null,null,null,"C046 au 15 du mois en cours M (date de piece)",null,null,null,null,null,"Sports et Loisirs","SEVPTE"]
[null,null,null,"C068 au 20 de M (date piece)",null,null,null,null,null,"Sports et Loisirs","BATOBUS"]
[null,null,null,"C080 dans 6j à réception de la facture (date saisie)",null,null,null,null,null,"Sports et Loisirs","SEGGSMHI (Lido)"]
[null,null,null,"C081 dans 10j à réception de la facture (date saisie)",null,null,null,null,null,"Sports et Loisirs","MILLENIA (Tour Eiffel)"]
[null,null,null,"C082 dans 15j à réception de la facture (date saisie)",null,null,null,null,null,"Sports et Loisirs","ALTIMA (Tour Eiffel)"]
[null,null,null,"C083 dans 20j à réception de la facture (date saisie)",null,null,null,null,null,"Sports et Loisirs","YACHTS de Paris"]
[null,null,null,"C084 dans 25j à réception de la facture (date saisie)"]
[null,null,null,"C085 dans 30j à réception de la facture (date saisie)"]
[null,null,null,"C087 dans 45j à réception de la facture (date saisie)"]
[null,null,null,"C097 Imm sans déduc. 25  mois suiv"]
[null,null,null,"C098 Imm sans déduc. 25 dans 2 mois"]
[null,null,null,"C099 Imm sans déduc. 30 du mois"]
[null,null,null,"C101 60 jours date de pièce"]
[null,null,null,"C103 Date édition de facture + 10"]
[null,null,null,"C104 Date édition de facture + 40"]
[null,null,null,"C105 Date édition de facture + 45"]

{"sheet":"Logo","index":2,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["SXO Santé Médico Social","Logo!$C$1",null,"004"]
["Sherpas","Logo!$C$2",null,"847"]
["Sogeres","Logo!$C$3",null,"484"]
["MILLENIA (tour Eiffel)","Logo!$C$4",null,"783"]
["SODEXO ENTREPRISES","Logo!$C$1",null,"009"]
["SEGGSMHI (Lido)","Logo!$C$6",null,775]
["ALTIMA (Tour Eiffel)","Logo!$C$7",null,784]
["SEINOVISION","Logo!$C$8",null,238]
["SEVPTE","Logo!$C$9",null,236]
["YACHTS de Paris","Logo!$C$10",null,898]
["BATOBUS","Logo!$C$11",null,232]
["SFRS","Logo!$C$1",null,"010"]
["SODEXO EN France SAS","Logo!$C$1",null,"012"]
["SODEXO SPORTS et LOISIRS","Logo!$C$14",null,"013"]
["SODEXO JUSTICE SERVICES","Logo!$C$15",null,"015"]
["SHTG","Logo!$C$16",null,222]
["SODEXNET","Logo!$C$17",null,253]
["SODEXO GUYANE SERVICES","Logo!$C$1",null,342]
["LA NORMANDE SA","Logo!$C$19",null,368]
["SAGERE","Logo!$C$20",null,546]
["SODEXO HYGIENE & PROPRETE","Logo!$C$1",null,"035"]
["S.G.P.G","Logo!$C$15",null,282]
["SODEXO Compétences Emploi","Logo!$C$15",null,1086]
["STRS","Logo!$C$1",null,154]
["ETABLISSEMENT GUYANE","Logo!$C$1",null,"003"]
["SODEXO GUYANE","Logo!$C$15",null,157]
["SFRS","Logo!$C$1",null,"010"]
["SMRS","Logo!$C$1",null,144]
["SBRS","Logo!$C$1",null,153]
["SOC.RESTAU.AUBERGE.LIENS","Logo!$C$1",null,775]
["SODEXO ENERGIE et MAINT.","Logo!$C$1",null,380]
["SODEXO MONACO","Logo!$C$1",null,"031"]