{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Contexte","GECT_A_SAISIR","IMPORT_GECT","Exemples"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":11,"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":"Contexte","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["PRINCIPE D'INTEGRATION DES DONNEES"]
["Vous êtes sur le point d'intégrer des écritures  dans l'outil Cegid XRP Ultimate."]
["Ces données sont propres à votre organisation et à vos règles de gestion."]
[]
[]
["CONSIGNES"]
["L'onglet \"GECT_A_SAISIR\" permet de référencer vos écritures."]
["Il contient des explications concernant chaque colonne."]
[]
["Les contrôles suivants sont réalisés lors des saisies :"]
["- le remplissage des champs obligatoires"]
["- le respect du nombre de caractères"]
["- le respect des majuscules"]
["- valeur différente du reste de l'écriture","VALEUR"]
["- contrôle des montants (D<>C, D+C <>0)"]
["- contrôle d'équilibre des écritures "]
[]
["FORMAT"]
["Il est possible d'ajouter des colonnes en cochant la case correspondante"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IMPORT"]
["Une fois les données saisies, le bouton \"Générer le fichier d'import\" permet de générer un fichier au format d'intégration dans les tables Cegid XRP Ultimate."]
["Le fichier sera enregistré au format .csv et avec comme nom : IMPORT_GECT_AAAAMMJJ_HHMMSS.csv"]

{"sheet":"GECT_A_SAISIR","index":1,"n_rows":8,"n_cols":205,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,84,0,147],[0,38,0,40],[0,44,0,46],[0,47,0,49],[0,1,0,33],[0,34,0,37],[0,50,0,57],[0,58,0,68],[0,69,0,83],[0,41,0,43]]}
[null,"SOCLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LITIGE",null,null,null,"RELANCE",null,null,"ACCEPTATION",null,null,"TIERS CONCERNE",null,null,"TIERS ASSOCIE",null,null,"PARAMETRES ECRITURE",null,null,null,null,null,null,null,"LISSAGE",null,null,null,null,null,null,null,null,null,null,"PARAMETRES MOUVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDENTIFIANTS MOUVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTRES CHAMPS"]
["Nom informatique","ocect.etsocect","ocect.numocect","ocect.typocect","ocect.pieocect","ocect.jrnocect","ocect.tpiocect","ocect.pixocect","ocect.libocect","ocect.decocect","ocect.echocect","ocect.democect","ocect.cptocect","ocect.tieocect","ocect.cgrocect","ocect.posocect","ocect.midocect","ocect.micocect","ocect.tvaocect","ocect.bhtocect","ocect.mtvocect","ocect.mhtocect","ocect.divocect","ocect.dimocect","ocect.didocect","ocect.virocect","ocect.tiaocect","ocect.tidocect","ocect.rgmocect","ocect.i10ocect","ocect.ucrocect","ocect.dcrocect","ocect.recocect","ocect.necocect","ocect.litocect","ocect.motocect","ocect.gslocect","ocect.dtlocect","ocect.nirocect","ocect.ddrocect","ocect.dprocect","ocect.tacocect","ocect.dacocect","ocect.uacocect","ocect.ticocect","ocect.tcaocect","ocect.tcdocect","ocect.tasocect","ocect.taaocect","ocect.tadocect","ocect.pr1ocect","ocect.pr2ocect","ocect.pr3ocect","ocect.in1ocect","ocect.in2ocect","ocect.in3ocect","ocect.doeocect","ocect.nahocect","ocect.mntocect","ocect.tytocect","ocect.eteocect","ocect.calocect","ocect.dtdocect","ocect.dtfocect","ocect.lisocect","ocect.pelocect","ocect.etlocect","ocect.mdlocect","ocect.ddlocect","ocect.p1mocect","ocect.p2mocect","ocect.p3mocect","ocect.p4mocect","ocect.p5mocect","ocect.p6mocect","ocect.p7mocect","ocect.p8mocect","ocect.p9mocect","ocect.p10ocect","ocect.p11ocect","ocect.p12ocect","ocect.p13ocect","ocect.p14ocect","ocect.p15ocect","ocect.c01ocect","ocect.c02ocect","ocect.c03ocect","ocect.c04ocect","ocect.c05ocect","ocect.c06ocect","ocect.c07ocect","ocect.c08ocect","ocect.c09ocect","ocect.c10ocect","ocect.c11ocect","ocect.c12ocect","ocect.c13ocect","ocect.c14ocect","ocect.c15ocect","ocect.c16ocect","ocect.c17ocect","ocect.c18ocect","ocect.c19ocect","ocect.c20ocect","ocect.i01ocect","ocect.i02ocect","ocect.i03ocect","ocect.i04ocect","ocect.i05ocect","ocect.i06ocect","ocect.i07ocect","ocect.i08ocect","ocect.i09ocect","ocect.i11ocect","ocect.i12ocect","ocect.i13ocect","ocect.i14ocect","ocect.i15ocect","ocect.i16ocect","ocect.i17ocect","ocect.i18ocect","ocect.i19ocect","ocect.i20ocect","ocect.g01ocect","ocect.g02ocect","ocect.g03ocect","ocect.g04ocect","ocect.g05ocect","ocect.g06ocect","ocect.g07ocect","ocect.g08ocect","ocect.g09ocect","ocect.g10ocect","ocect.l01ocect","ocect.l02ocect","ocect.l03ocect","ocect.d01ocect","ocect.d02ocect","ocect.d03ocect","ocect.d04ocect","ocect.d05ocect","ocect.d06ocect","ocect.n01ocect","ocect.n02ocect","ocect.n03ocect","ocect.n04ocect","ocect.n05ocect","ocect.n06ocect","ocect.dvlocect","ocect.licocect","ocect.limocect","ocect.mvcocect","ocect.budocect","ocect.jrcocect","ocect.mtdocect","ocect.mtcocect","ocect.borocect","ocect.devocect","ocect.dvmocect","ocect.ddvocect","ocect.vprocect","ocect.mddocect","ocect.mdcocect","ocect.dvoocect","ocect.drmocect","ocect.drvocect","ocect.vrrocect","ocect.mrdocect","ocect.mrcocect","ocect.eciocect","ocect.bvrocect","ocect.cbvocect","ocect.natocect","ocect.genocect","ocect.rolocect","ocect.etvocect","ocect.cpcocect","ocect.zonocect","ocect.namocect","ocect.gemocect","ocect.romocect","ocect.tenocect","ocect.denocect","ocect.infocect","ocect.rgdocect","ocect.rgjocect","ocect.bnqocect","ocect.gepocect","ocect.napocect","ocect.ropocect","ocect.narocect","ocect.gesocect","ocect.udmocect","ocect.ddmocect","ocect.cpaocect","ocect.tppocect","ocect.tipocect","ocect.tapocect","ocect.letocect","ocect.unoocect","ocect.quoocect","ocect.dosocect","ocect.cetocect","ocect.trtocect","ocect.nuiocect"]
["Libellé","Etablissement","Ecriture","Type de mouvement","Pièce","Journal","Type de pièce","Référence","Libellé","Date comptable","Date d'échéance","Date d'émission","Compte","Tiers","CGR A","Poste","Montant débit devise interface","Montant crédit devise interface","Code de TVA","Base hors taxes","Montant de la TVA","Montant hors taxes","Devise interface","Mode de change ","Date du cours","Cours de devise","Adresse du tiers","Domiciliation du tiers","Mode de règlement","Identifiant 10","Créateur","Créé le","Regroupement","N° d'échéance","Litige","Motif","Gestionnaire du litige","Date du litige","Niveau de relance","Date de dernière relance","Date de précédente relance","Type d'acceptation","Date d'acceptation","Utilisateur d'acceptation","Tiers concerné","Adresse du tiers concerné","Domiciliation du tiers concerné","Tiers associé","Adresse du tiers associé","Domiciliation du tiers associé","Paramètre 1","Paramètre 2","Paramètre 3","Indicateur 1","Indicateur 2","Indicateur 3","Dossier","Nature honoraires","Montant de l'extourne","Type du traitement","Etat extourne","Type de calcul","Prestation du","au","Effectuer un lissage","Périodicité du lissage","Etat lissage","Montant déjà lissé","Date dernier lissage","Paramètre 1","Paramètre 2","Paramètre 3","Paramètre 4","Paramètre 5","Paramètre 6","Paramètre 7","Paramètre 8","Paramètre 9","Paramètre 10","Paramètre 11","Paramètre 12","Paramètre 13","Paramètre 14","Paramètre 15","Identifiant court 1","Identifiant court 2","Identifiant court 3","Identifiant court 4","Identifiant court 5","Identifiant court 6","Identifiant court 7","Identifiant court 8","Identifiant court 9","Identifiant court 10","Identifiant court 11","Identifiant court 12","Identifiant court 13","Identifiant court 14","Identifiant court 15","Identifiant court 16","Identifiant court 17","Identifiant court 18","Identifiant court 19","Identifiant court 20","Identifiant 1","Identifiant 2","Identifiant 3","Identifiant 4","Identifiant 5","Identifiant 6","Identifiant 7","Identifiant 8","Identifiant 9","Identifiant 11","Identifiant 12","Identifiant 13","Identifiant 14","Identifiant 15","Identifiant 16","Identifiant 17","Identifiant 18","Identifiant 19","Identifiant 20","Identifiant long 1","Identifiant long 2","Identifiant long 3","Identifiant long 4","Identifiant long 5","Identifiant long 6","Identifiant long 7","Identifiant long 8","Identifiant long 9","Identifiant long 10","Libellé 1","Libellé 2","Libellé 3","Date 1","Date 2","Date 3","Date 4","Date 5","Date 6","Numérique 1","Numérique 2","Numérique 3","Numérique 4","Numérique 5","Numérique 6","Date de valeur","Libellé","Libellé","Séquence","CGR B","Colonne","Montant débit","Montant crédit","Bordereau","Devise","Mode de change","Date","Cours","Montant devise débit","Montant devise crédit","Devise origine","Mode de change reporting","Date de validité devise de reporting","Cours du reporting","Montant reporting débit","Montant reporting crédit","Date d'échéance initiale","Référence BVR","Clé","Nature","Genre","Rôle","Etat TVA","Compte d'équilibre","Zone","Nature du mouvement","Genre du mouvement","Rôle du mouvement","Type d'envoi","Date d'envoi","Informations de la pièce","Date de règlement","Délai de règlement","Banque","Genre de la pièce","Nature de la pièce","Rôle de la pièce","Nature du règlement","Gestionnaire","Modificateur","Modifié le","Condition particulière","Taux","Tiers","Adresse","Lettrage","Unité d'oeuvre","Quantité","Dossier","Code entrée","Code traitement","Numéro interne"]
["Descriptif","Etablissement","N° provisoire d'écriture","C : Comptable","N° de pièce","Journal de reprise","Si non renseigné alimenté avec celui du journal","Référence de la pièce comptable.\nN° de pièce de l'ancien système","Libellé de l'écriture","Date comptable","Si non renseignée, calculée en fonction des conditions de règlement du tiers","Date d'émission","Compte","Tiers","Imputation analytique","nature analytique","Montant en devise de référence ou montant en dévise","Montant en devise de référence ou montant en dévise","Code de TVA si compte soumis à la TVA","Montant HT en devise de référence ou en dévise si compte soumis à la TVA","Montant de TVA en devise de référence ou  en dévise si compte soumis à la TVA","Montant HT en devise de référence ou en dévise si compte soumis à la TVA","Si devise différente de la devise de référence","Si devise différente de la devise de référence.\nN par défaut","Si devise différente de la devise de référence","Si devise différente de la devise de référence","Code adresse du tiers","Code de la domiciliation du tiers","Mode de règlement","Référence de lettrage des pièces ",null,null,"Lot d'écritures.Si aucune erreur lors de  l'intégration alors toutes les écritures de ce lot sont intégrées; sinon, si une erreur est trouvée sur une des écritures alors toutes les écritures de ce lot sont rejetées.","Mettre 0 par défaut. Il  sera attribué lors de l'intégration","Code litige","Motif du litige","Gestionnaire du litige","Date du litige","Niveau de relance","Date de dernière relance",null,"Type d'acceptation","Date d'acceptation","Utilisateur d'acceptation",null,null,null,null,null,null,null,null,null,null,null,null,"Dossier de l'écriture","Nature honoraires pour les acomptes non soldé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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date de valeur","Libellé complémentaire de l'écriture","Libellé du mouvement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dossier du mouvement",null,null,"Numéro unique affecté lors de l'import"]
["Type de champs","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Date","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Numérique","Alphanumérique","Numérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Date","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Alphanumérique","Entier","Alphanumérique","Alphanumérique","Alphanumérique","Date","Alphanumérique","Date","Date","Alphanumérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Date","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Date","Date","Date","Date","Date","Numérique","Numérique","Numérique","Numérique","Numérique","Numérique","Date","Alphanumérique","Alphanumérique","Entier","Alphanumérique","Entier","Numérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Numérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Date","Numérique","Numérique","Numérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Alphanumérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Entier"]
["Nbre caractères max",6,8,2,10,6,4,30,30,10,10,10,10,10,80,20,310,310,10,310,310,310,6,2,10,310,10,10,6,10,30,10,10,4,6,60,6,10,2,10,10,2,10,30,10,10,10,10,10,10,10,10,10,2,2,2,20,4,310,2,1,2,10,10,1,2,1,310,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,20,20,20,20,20,20,20,20,20,20,60,60,60,10,10,10,10,10,10,310,310,310,310,310,310,10,60,30,8,20,6,310,310,15,6,2,10,310,310,310,6,2,10,310,310,310,10,40,2,2,2,1,1,10,30,2,2,1,2,10,240,6,6,3,2,2,1,2,6,30,10,6,310,10,10,6,6,310,20,2,2,9]
["Obligatoire ","Obligatoire","Obligatoire","Obligatoire","Facultatif","Obligatoire","Facultatif","Facultatif","Facultatif","Obligatoire","Facultatif","Facultatif","Obligatoire","Facultatif","Facultatif","Facultatif","Obligatoire","Obligatoire","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Obligatoire","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Obligatoire"]
["Majuscule","O","O","O","O","O","O","O","N","N","N","N","O","O","O","O","N","N","O","N","N","N","O","O","N","N","O","O","O","O","O","N","N","N","O","N","O","N","O","N","N","O","N","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","N","O","O","O","N","N","N","O","O","N","N","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","O","O","N","N","O","O","O","N","N","N","N","O","O","N","N","N","N","N","O","O","O","O","O","O","O","N","O","O","O","O","N","N","O","O","O","O","O","O","O","O","O","N","O","N","O","O","O","O","N","O","O","O","N"]

{"sheet":"IMPORT_GECT","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Exemples","index":3,"n_rows":48,"n_cols":206,"rows_kept":48,"cut":false,"hidden":false,"merged":[[41,0,43,0],[45,0,47,0],[9,0,20,0],[22,0,24,0],[26,0,28,0],[30,0,31,0],[33,0,34,0],[36,0,38,0],[0,147,0,204],[0,1,0,14],[0,16,0,32],[0,33,0,36],[0,37,0,39],[0,40,0,42],[0,43,0,45],[0,46,0,48],[0,49,0,56],[0,57,0,67],[0,68,0,82],[0,83,0,146]]}
[null,"SOCLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOCLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LITIGE",null,null,null,"RELANCE",null,null,"ACCEPTATION",null,null,"TIERS CONCERNE",null,null,"TIERS ASSOCIE",null,null,"PARAMETRES ECRITURE",null,null,null,null,null,null,null,"LISSAGE",null,null,null,null,null,null,null,null,null,null,"PARAMETRES MOUVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDENTIFIANTS MOUVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTRES CHAMPS"]
[null,"ocect.etsocect","ocect.numocect","ocect.typocect","ocect.pieocect","ocect.jrnocect","ocect.tpiocect","ocect.pixocect","ocect.libocect","ocect.decocect","ocect.echocect","ocect.democect","ocect.cptocect","ocect.tieocect","ocect.cgrocect","ocect.posocect","ocect.midocect","ocect.micocect","ocect.tvaocect","ocect.bhtocect","ocect.mtvocect","ocect.mhtocect","ocect.divocect","ocect.dimocect","ocect.didocect","ocect.virocect","ocect.tiaocect","ocect.tidocect","ocect.rgmocect","ocect.i10ocect","ocect.ucrocect","ocect.dcrocect","ocect.necocect","ocect.litocect","ocect.motocect","ocect.gslocect","ocect.dtlocect","ocect.nirocect","ocect.ddrocect","ocect.dprocect","ocect.tacocect","ocect.dacocect","ocect.uacocect","ocect.ticocect","ocect.tcaocect","ocect.tcdocect","ocect.tasocect","ocect.taaocect","ocect.tadocect","ocect.pr1ocect","ocect.pr2ocect","ocect.pr3ocect","ocect.in1ocect","ocect.in2ocect","ocect.in3ocect","ocect.doeocect","ocect.nahocect","ocect.mntocect","ocect.tytocect","ocect.eteocect","ocect.calocect","ocect.dtdocect","ocect.dtfocect","ocect.lisocect","ocect.pelocect","ocect.etlocect","ocect.mdlocect","ocect.ddlocect","ocect.p1mocect","ocect.p2mocect","ocect.p3mocect","ocect.p4mocect","ocect.p5mocect","ocect.p6mocect","ocect.p7mocect","ocect.p8mocect","ocect.p9mocect","ocect.p10ocect","ocect.p11ocect","ocect.p12ocect","ocect.p13ocect","ocect.p14ocect","ocect.p15ocect","ocect.c01ocect","ocect.c02ocect","ocect.c03ocect","ocect.c04ocect","ocect.c05ocect","ocect.c06ocect","ocect.c07ocect","ocect.c08ocect","ocect.c09ocect","ocect.c10ocect","ocect.c11ocect","ocect.c12ocect","ocect.c13ocect","ocect.c14ocect","ocect.c15ocect","ocect.c16ocect","ocect.c17ocect","ocect.c18ocect","ocect.c19ocect","ocect.c20ocect","ocect.i01ocect","ocect.i02ocect","ocect.i03ocect","ocect.i04ocect","ocect.i05ocect","ocect.i06ocect","ocect.i07ocect","ocect.i08ocect","ocect.i09ocect","ocect.i11ocect","ocect.i12ocect","ocect.i13ocect","ocect.i14ocect","ocect.i15ocect","ocect.i16ocect","ocect.i17ocect","ocect.i18ocect","ocect.i19ocect","ocect.i20ocect","ocect.g01ocect","ocect.g02ocect","ocect.g03ocect","ocect.g04ocect","ocect.g05ocect","ocect.g06ocect","ocect.g07ocect","ocect.g08ocect","ocect.g09ocect","ocect.g10ocect","ocect.l01ocect","ocect.l02ocect","ocect.l03ocect","ocect.d01ocect","ocect.d02ocect","ocect.d03ocect","ocect.d04ocect","ocect.d05ocect","ocect.d06ocect","ocect.n01ocect","ocect.n02ocect","ocect.n03ocect","ocect.n04ocect","ocect.n05ocect","ocect.n06ocect","ocect.dvlocect","ocect.licocect","ocect.limocect","ocect.mvcocect","ocect.budocect","ocect.jrcocect","ocect.mtdocect","ocect.mtcocect","ocect.borocect","ocect.devocect","ocect.dvmocect","ocect.ddvocect","ocect.vprocect","ocect.mddocect","ocect.mdcocect","ocect.dvoocect","ocect.drmocect","ocect.drvocect","ocect.vrrocect","ocect.mrdocect","ocect.mrcocect","ocect.eciocect","ocect.bvrocect","ocect.cbvocect","ocect.natocect","ocect.genocect","ocect.rolocect","ocect.etvocect","ocect.cpcocect","ocect.zonocect","ocect.namocect","ocect.gemocect","ocect.romocect","ocect.tenocect","ocect.denocect","ocect.infocect","ocect.rgdocect","ocect.rgjocect","ocect.bnqocect","ocect.gepocect","ocect.napocect","ocect.ropocect","ocect.narocect","ocect.gesocect","ocect.udmocect","ocect.ddmocect","ocect.cpaocect","ocect.tppocect","ocect.tipocect","ocect.tapocect","ocect.letocect","ocect.unoocect","ocect.quoocect","ocect.dosocect","ocect.cetocect","ocect.trtocect","ocect.recocect","ocect.nuiocect"]
["Libellé","Etablissement","Ecriture","Type de mouvement","Pièce","Journal","Type de pièce","Référence","Libellé","Date comptable","Date d'échéance","Date d'émission","Compte","Tiers","CGR A","Poste","Montant débit devise interface","Montant crédit devise interface","Code de TVA","Base hors taxes","Montant de la TVA","Montant hors taxes","Devise interface","Mode de change ","Date du cours","Cours de devise","Adresse du tiers","Domiciliation du tiers","Mode de règlement","Identifiant 10","Créateur","Créé le","N° d'échéance","Litige","Motif","Gestionnaire du litige","Date du litige","Niveau de relance","Date de dernière relance","Date de précédente relance","Type d'acceptation","Date d'acceptation","Utilisateur d'acceptation","Tiers concerné","Adresse du tiers concerné","Domiciliation du tiers concerné","Tiers associé","Adresse du tiers associé","Domiciliation du tiers associé","Paramètre 1","Paramètre 2","Paramètre 3","Indicateur 1","Indicateur 2","Indicateur 3","Dossier","Nature honoraires","Montant de l'extourne","Type du traitement","Etat extourne","Type de calcul","Prestation du","au","Effectuer un lissage","Périodicité du lissage","Etat lissage","Montant déjà lissé","Date dernier lissage","Paramètre 1","Paramètre 2","Paramètre 3","Paramètre 4","Paramètre 5","Paramètre 6","Paramètre 7","Paramètre 8","Paramètre 9","Paramètre 10","Paramètre 11","Paramètre 12","Paramètre 13","Paramètre 14","Paramètre 15","Identifiant court 1","Identifiant court 2","Identifiant court 3","Identifiant court 4","Identifiant court 5","Identifiant court 6","Identifiant court 7","Identifiant court 8","Identifiant court 9","Identifiant court 10","Identifiant court 11","Identifiant court 12","Identifiant court 13","Identifiant court 14","Identifiant court 15","Identifiant court 16","Identifiant court 17","Identifiant court 18","Identifiant court 19","Identifiant court 20","Identifiant 1","Identifiant 2","Identifiant 3","Identifiant 4","Identifiant 5","Identifiant 6","Identifiant 7","Identifiant 8","Identifiant 9","Identifiant 11","Identifiant 12","Identifiant 13","Identifiant 14","Identifiant 15","Identifiant 16","Identifiant 17","Identifiant 18","Identifiant 19","Identifiant 20","Identifiant long 1","Identifiant long 2","Identifiant long 3","Identifiant long 4","Identifiant long 5","Identifiant long 6","Identifiant long 7","Identifiant long 8","Identifiant long 9","Identifiant long 10","Libellé 1","Libellé 2","Libellé 3","Date 1","Date 2","Date 3","Date 4","Date 5","Date 6","Numérique 1","Numérique 2","Numérique 3","Numérique 4","Numérique 5","Numérique 6","Date de valeur","Libellé","Libellé","Séquence","CGR B","Colonne","Montant débit","Montant crédit","Bordereau","Devise","Mode de change","Date","Cours","Montant devise débit","Montant devise crédit","Devise origine","Mode de change reporting","Date de validité devise de reporting","Cours du reporting","Montant reporting débit","Montant reporting crédit","Date d'échéance initiale","Référence BVR","Clé","Nature","Genre","Rôle","Etat TVA","Compte d'équilibre","Zone","Nature du mouvement","Genre du mouvement","Rôle du mouvement","Type d'envoi","Date d'envoi","Informations de la pièce","Date de règlement","Délai de règlement","Banque","Genre de la pièce","Nature de la pièce","Rôle de la pièce","Nature du règlement","Gestionnaire","Modificateur","Modifié le","Condition particulière","Taux","Tiers","Adresse","Lettrage","Unité d'oeuvre","Quantité","Dossier","Code entrée","Code traitement","Regroupement","Numéro interne"]
["Descriptif","Etablissement","N° provisoire d'écriture","C : Comptable","N° de pièce","Journal de reprise","Si non renseigné alimenté avec celui du journal","Référence de la pièce comptable.\nN° de pièce de l'ancien système","Libellé de l'écriture","Date comptable","Si non renseignée, calculée en fonction des conditions de règlement du tiers","Date d'émission","Compte","Tiers","Imputation analytique","nature analytique","Montant en devise de référence ou montant en dévise","Montant en devise de référence ou montant en dévise","Code de TVA si compte soumis à la TVA","Montant HT en devise de référence ou en dévise si compte soumis à la TVA","Montant de TVA en devise de référence ou  en dévise si compte soumis à la TVA","Montant HT en devise de référence ou en dévise si compte soumis à la TVA","Si devise différente de la devise de référence","Si devise différente de la devise de référence.\nN par défaut","Si devise différente de la devise de référence","Si devise différente de la devise de référence","Code adresse du tiers","Code de la domiciliation du tiers","Mode de règlement","Référence de lettrage des pièces ",null,null,"Mettre 0 par défaut. Il  sera attribué lors de l'intégration","Code litige","Motif du litige","Gestionnaire du litige","Date du litige","Niveau de relance","Date de dernière relance",null,"Type d'acceptation","Date d'acceptation","Utilisateur d'acceptation",null,null,null,null,null,null,null,null,null,null,null,null,"Dossier de l'écriture","Nature honoraires pour les acomptes non soldé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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date de valeur","Libellé complémentaire de l'écriture","Libellé du mouvement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dossier du mouvement",null,null,null,"Numéro unique affecté lors de l'import"]
["Type de champs","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Date","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Numérique","Alphanumérique","Numérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Date","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Entier","Alphanumérique","Alphanumérique","Alphanumérique","Date","Alphanumérique","Date","Date","Alphanumérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Date","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Date","Date","Date","Date","Date","Numérique","Numérique","Numérique","Numérique","Numérique","Numérique","Date","Alphanumérique","Alphanumérique","Entier","Alphanumérique","Entier","Numérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Numérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Date","Numérique","Numérique","Numérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date","Alphanumérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Entier"]
["Nbre caractères max",6,8,2,10,6,4,30,30,10,10,10,10,10,80,20,310,310,10,310,310,310,6,2,10,310,10,10,6,10,30,10,4,6,60,6,10,2,10,10,2,10,30,10,10,10,10,10,10,10,10,10,2,2,2,20,4,310,2,1,2,10,10,1,2,1,310,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,20,20,20,20,20,20,20,20,20,20,60,60,60,10,10,10,10,10,10,310,310,310,310,310,310,10,60,30,8,20,6,310,310,15,6,2,10,310,310,310,6,2,10,310,310,310,10,40,2,2,2,1,1,10,30,2,2,1,2,10,240,6,6,3,2,2,1,2,6,30,10,6,310,10,10,6,6,310,20,2,2,10,9]
["Obligatoire ","Obligatoire","Obligatoire","Obligatoire","Facultatif","Obligatoire","Facultatif","Facultatif","Facultatif","Obligatoire","Facultatif","Facultatif","Obligatoire","Facultatif","Facultatif","Facultatif","Obligatoire","Obligatoire","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Obligatoire","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Facultatif","Obligatoire"]
["Majuscule","O","O","O","O","O","O","O","N","N","N","N","O","O","O","O","N","N","O","N","N","N","O","O","N","N","O","O","O","O","O","N","N","O","N","O","N","O","N","N","O","N","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","N","O","O","O","N","N","N","O","O","N","N","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","O","O","N","N","O","O","O","N","N","N","N","O","O","N","N","N","N","N","O","O","O","O","O","O","O","N","O","O","O","O","N","N","O","O","O","O","O","O","O","O","O","N","O","N","O","O","O","O","N","O","O","O","N","N"]
["Exemples d'écritures de reprise"]
["Balance de reprise","QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",101100,null,"",null,0,1500,"",null,"",null,null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",120000,"","",null,0,130,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",211100,"","DAC00 ZPDT  ZPRJ",null,300,0,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",213100,"","DAF01 ZPDT  ZPRJ",null,500,0,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",218200,"","DLO01 ZPDT  ZPRJ",null,200,0,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",281310,"","",null,0,150,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",281820,"","",null,0,100,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",311000,"","",null,180,0,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",431000,"","",null,90,0,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",491000,"","",null,0,50,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",512100,"","",null,200,0,"","","","",null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100997,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",890000,"",null,null,460,0,null,null,null,null,null,null,null,null,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","",""]
[]
["Reprise d'une facture fournisseur non soldée avec TVA sur encaissement","QS1001",21100995,"C","FF0000001","YREP","FF","FF21100056","","2022-01-01","","","401100","00027","",null,0,120,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100995,"C","FF0000001","YREP","FF","FF21100056","","2022-01-01","","","445640","","",null,20,0,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100995,"C","FF0000001","YREP","FF","FF21100056","","2022-01-01","","",896000,"",null,null,100,0,"2700",100,20,120,"","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[]
["Reprise d'une facture client non soldée avec TVA sur encaissement","QS1001",21100994,"C","FF0000002","YREP","FC","FC21100059","","2022-01-01","","",411100,"00005","",null,480,0,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100994,"C","FF0000002","YREP","FC","FC21100059","","2022-01-01","","",445740,"","",null,0,80,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100994,"C","FF0000002","YREP","FC","FC21100059","","2022-01-01","","",897000,"",null,null,0,400,"2700",400,80,400,"","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[]
["Reprise d'une facture fournisseur non soldée avec TVA sur les débits","QS1001",21100993,"C","FF0000003","YREP","FF","FF21100060","","2022-01-01","","","401100","00027","",null,0,80,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100993,"C","FF0000003","YREP","FF","FF21100060","","2022-01-01","","",896000,"",null,null,80,0,null,null,null,null,"","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[]
["Reprise d'une facture client non soldée avec TVA sur les débits","QS1001",21100992,"C","FC0000004","YREP","FC","FC21100061","","2022-01-01","","",411100,"00005","",null,240,0,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100992,"C","FC0000004","YREP","FC","FC21100061","","2022-01-01","","",897000,"",null,null,0,240,null,null,null,null,"","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[]
["Ecriture de solde des comptes de reprises","QS1001",21100991,"C","REP0000002","YREP","OD",null,"","2022-01-01","","",890000,null,"",null,0,460,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100991,"C","REP0000002","YREP","OD",null,"","2022-01-01","","",896000,null,"",null,0,180,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001",21100991,"C","REP0000001","YREP","OD",null,"","2022-01-01","","",897000,null,null,null,640,0,null,null,null,null,"","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[]
["Exemples d'écritures détaillées"]
["Ecriture en devise de référence (EUR)","QS1001","21100996","C","","ACHI","FF","FF21100083","","25/10/2021","","","401100","00027","",null,0,5052,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001","21100996","C","","ACHI","FF","FF21100083","","25/10/2021","","","445640","","",null,842,0,"","","","","","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001","21100996","C","","ACHI","FF","FF21100083","","25/10/2021","","","626000","","DJU00 ZPDT  ZPRJ",null,4210,0,"2700",4210,842,4210,"","","","","","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[]
["Ecriture en devise (USD)","QS1001","21100998","C","","ACHI","FF","FF21100084","","25/10/2021","","","401100","00025","",null,0,1200,"","","","","USD","N","01/10/2021",1.1000000000000001,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001","21100998","C","","ACHI","FF","FF21100084","","25/10/2021","","","445640","","",null,200,0,"","","","","USD","N","01/10/2021",1.1000000000000001,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]
[null,"QS1001","21100998","C","","ACHI","FF","FF21100084","","25/10/2021","","","624100","","DSI00 ZPDT  ZPRJ",null,1000,0,"2700",1000,200,1000,"USD","N","01/10/2021",1.1000000000000001,"","","","","QS4","12/10/2021",0,"","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","",null,"","","","","","","","",""]