{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Contexte","GAMIMT_A_SAISIR","IMPORT_GAMIMT"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":15,"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":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["PRINCIPE D'INTEGRATION DES DONNEES"]
["Vous êtes sur le point d'intégrer vos immobilisations dans l'outil Cegid XRP Ultimate."]
["Ces données sont propres à votre organisation et à vos règles de gestion."]
[]
["CONSIGNES"]
["L'onglet \"GAMIMT_A_SAISIR\" va permettre de référencer vos immobilisations de reprises."]
["Il contient également des explications concernant chaque colonne et des exemples pour mieux comprendre le format attendu."]
["Vos données doivent être saisies dans cet onglet."]
["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"]
[]
[]
["Les colonnes B à V contiennent les principaux champs à alimenter."]
["Il est possible lors d'une reprise détaillée d'ajouter certaines champs :"]
["Quels sont les champs complémentaires à afficher en plus de ceux du socle ?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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_GAMIMT_AAAAMMJJ_HHMMSS.csv"]

{"sheet":"GAMIMT_A_SAISIR","index":1,"n_rows":8,"n_cols":153,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,22],[0,121,0,152],[0,30,0,44],[0,51,0,62],[0,105,0,109],[0,110,0,117],[0,118,0,120],[0,100,0,104],[0,95,0,99],[0,45,0,50],[0,63,0,70],[0,71,0,78],[0,79,0,86],[0,87,0,94],[0,23,0,29]]}
[null,"SOCLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLAN AMORTISSEMENT N°1",null,null,null,null,null,null,"INFORMATIONS COMPTABLES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEVISE",null,null,null,null,null,"INFORMATIONS ACHATS",null,null,null,null,null,null,null,null,null,null,null,"PLAN AMORTISSEMENT N°2",null,null,null,null,null,null,null,"PLAN AMORTISSEMENT N°3",null,null,null,null,null,null,null,"PLAN AMORTISSEMENT N°4",null,null,null,null,null,null,null,"PLAN AMORTISSEMENT N°5",null,null,null,null,null,null,null,"LIBELLES",null,null,null,null,"IDENTIFIANTS",null,null,null,null,"DATES",null,null,null,null,"VALEURS",null,null,null,null,null,null,null,"PARAMETRES",null,null,"AUTRES CHAMPS"]
["Nom informatique","amimt.etsamimt","amimt.numamimt","amimt.tamamimt","amimt.cptamimt","amimt.cgaamimt","amimt.ob1amimt","amimt.plnamimt","amimt.typamimt","amimt.qteamimt","amimt.intamimt","amimt.inramimt","amimt.dacamimt","amimt.datamimt","amimt.mhaamimt","amimt.mhiamimt","amimt.resamimt","amimt.mdramimt","amimt.depamimt","amimt.demamimt","amimt.invamimt","amimt.ucramimt","amimt.dcramimt","amimt.pl1amimt","amimt.mt1amimt","amimt.md1amimt","amimt.re1amimt","amimt.dt1amimt","amimt.ca1amimt","amimt.cb1amimt","amimt.domamimt","amimt.seqamimt","amimt.ecramimt","amimt.mvcamimt","amimt.pieamimt","amimt.necamimt","amimt.pixamimt","amimt.decamimt","amimt.tvaamimt","amimt.mtvamimt","amimt.tptamimt","amimt.tieamimt","amimt.tiaamimt","amimt.posamimt","amimt.cgbamimt","amimt.devamimt","amimt.dvmamimt","amimt.ddvamimt","amimt.vpramimt","amimt.mtdamimt","amimt.mtramimt","amimt.artamimt","amimt.faaamimt","amimt.nicamimt","amimt.claamimt","amimt.cdaamimt","amimt.snuamimt","amimt.lcaamimt","amimt.recamimt","amimt.dreamimt","amimt.cafamimt","amimt.mptamimt","amimt.fouamimt","amimt.ob2amimt","amimt.pl2amimt","amimt.mt2amimt","amimt.md2amimt","amimt.re2amimt","amimt.dt2amimt","amimt.ca2amimt","amimt.cb2amimt","amimt.ob3amimt","amimt.pl3amimt","amimt.mt3amimt","amimt.md3amimt","amimt.re3amimt","amimt.dt3amimt","amimt.ca3amimt","amimt.cb3amimt","amimt.ob4amimt","amimt.pl4amimt","amimt.mt4amimt","amimt.md4amimt","amimt.re4amimt","amimt.dt4amimt","amimt.ca4amimt","amimt.cb4amimt","amimt.ob5amimt","amimt.pl5amimt","amimt.mt5amimt","amimt.md5amimt","amimt.re5amimt","amimt.dt5amimt","amimt.ca5amimt","amimt.cb5amimt","amimt.l01amimt","amimt.l02amimt","amimt.l03amimt","amimt.l04amimt","amimt.l05amimt","amimt.g01amimt","amimt.g02amimt","amimt.g03amimt","amimt.g04amimt","amimt.g05amimt","amimt.da1amimt","amimt.da2amimt","amimt.da3amimt","amimt.da4amimt","amimt.da5amimt","amimt.vdramimt","amimt.assamimt","amimt.va1amimt","amimt.va2amimt","amimt.va3amimt","amimt.va4amimt","amimt.va5amimt","amimt.va6amimt","amimt.pr1amimt","amimt.pr2amimt","amimt.pr3amimt","amimt.famamimt","amimt.achamimt","amimt.staamimt","amimt.paramimt","amimt.ncfamimt","amimt.unoamimt","amimt.nimamimt","amimt.imoamimt","amimt.comamimt","amimt.ddcamimt","amimt.mneamimt","amimt.gesamimt","amimt.stpamimt","amimt.rgiamimt","amimt.suiamimt","amimt.sucamimt","amimt.simamimt","amimt.cetamimt","amimt.ccpamimt","amimt.ccdamimt","amimt.cfaamimt","amimt.tx1amimt","amimt.tx2amimt","amimt.tx3amimt","amimt.infamimt","amimt.etaamimt","amimt.natamimt","amimt.genamimt","amimt.rolamimt","amimt.udmamimt","amimt.ddmamimt","amimt.trtamimt"]
["Libellé","Etablissement","Numéro","Type d'amortissement","Compte","CGR A","Objectif 1","Plan amortissement","Type immobilisation","Quantité","Intitulé complet","Intitulé réduit","Date d'acquisition","Date de mise en service","Achat HT","Immobilisé","Valeur résiduelle","Reprise","Dépôt","Emplacement","Numéro d'inventaire","Créateur","Créé le","Plan 1","Montant 1","Montant reprise 1","Valeur résiduelle 1","Date 1","CGR A 1","CGR B 1","Domaine","Séquence","Ecriture","Mouvement","Pièce","N° échéance","Pièce externe","Date comptable","Code TVA","Montant TVA","Taux prorata","Tiers","Adresse","Poste","CGR B","Devise","Mode de change","Date début validité","Valeur prévue du cours","Montant en devise","Montant de reporting","Référence article","Facture","Numéro interne commande","Commande","N° de cde","Sous-n° de cde","Ligne","Réception","Date de réception","Montant des CAF","Montant prorata de TVA","Fournisseur","Objectif 2","Plan 2","Montant 2","Montant reprise 2","Valeur résiduelle 2","Date 2","CGR A 2","CGR B 2","Objectif 3","Plan 3","Montant 3","Montant reprise 3","Valeur résiduelle 3","Date 3","CGR A 3","CGR B 3","Objectif 4","Plan 4","Montant 4","Montant reprise 4","Valeur résiduelle 4","Date 4","CGR A 4","CGR B 4","Objectif 5","Plan 5","Montant 5","Montant reprise 5","Valeur résiduelle 5","Date 5","CGR A 5","CGR B 5","Libellé 1","Libellé 2","Libellé 3","Libellé 4","Libellé 5","Identifiant long 1","Identifiant long 2","Identifiant long 3","Identifiant long 4","Identifiant long 5","Date 1","Date 2","Date 3","Date 4","Date 5","Valeur de remplacement","Valeur d'assurance","Valeur 1","Valeur 2","Valeur 3","Valeur 4","Valeur 5","Valeur 6","Paramètre 1","Paramètre 2","Paramètre 3","Famille","Neuf/Occasion","Stabilité","Numéro de parc","Nombre de chevaux fiscaux","Unité d'oeuvre","Numéro de lien","Immo. à fusionner","Sous-numéro immo. à fusionner","Date de cession","Mnémonique","Gestionnaire","Taxe professionnelle","Regroupement","Immo. sup.","Ss-numéro immo. sup.","Simulation","Code entrée","Contexte comptabilité","Contexte commande","Contexte facture","Texte 1","Texte 2","Texte 3","Informations","Etat","Nature","Genre","Rôle","Modificateur","Modifié le","Code traitement"]
["Descriptif","Etablissement","Numéro d'immobilisation provisoire","Type d'amortissement","Compte","Imputation analytique","Objectif 1\n * Obligatoire pour les immobilisations amortissables","Plan amortissement\n* Obligatoire pour les immobilisations amortissables","Type immobilisation","Quantité","Intitulé complet","Intitulé réduit","Date d'acquisition","Date de mise en service","Montant d'achat HT","Montant immobilisé","Valeur résiduelle\nMettre 0 par défaut","Montant de reprise","Permet de localiser l'immobilisation.","Permet de préciser la localisation de l'immobilisation à l'intérieur du dépôt ci-dessus.","Numéro d'inventaire","Créateur","Date de création","Plan 1","Montant 1","Montant reprise 1","Valeur résiduelle 1","Date 1","CGR A 1","CGR B 1","En phase de reprise de données, si le domaine est égal à X (domaine inconnu), on a la possibilité de reprendre des numéros de commande, de facture ou de réception non référencés dans Cegid XRP Ultimate","Le numéro de séquence est incrémenté automatiquement de 10 en 10 lors de la création automatique par les achats ou la comptabilité.\nCeci permet d'avoir plusieurs enregistrements pour une même ligne de commande ou pour un même mouvement comptable.","N°Ecriture","Mouvement","N°Pièce","Echéance","Pièce externe","Date comptable","Code TVA","Montant TVA","Taux prorata","Code Tiers","Adresse","Poste","CGR B","Devise","Mode de change","Date début validité","Valeur prévue du cours","Montant en devise","Montant de reporting","Référence article","Facture","Numéro interne commande","Commande","N° de cde","Sous-n° de cde","Ligne","Réception","Date de réception","Montant des CAF","Montant prorata de TVA","Fournisseur","Objectif 2","Plan 2","Montant 2","Montant reprise 2","Valeur résiduelle 2","Date 2","CGR A 2","CGR B 2","Objectif 3","Plan 3","Montant 3","Montant reprise 3","Valeur résiduelle 3","Date 3","CGR A 3","CGR B 3","Objectif 4","Plan 4","Montant 4","Montant reprise 4","Valeur résiduelle 4","Date 4","CGR A 4","CGR B 4","Objectif 5","Plan 5","Montant 5","Montant reprise 5","Valeur résiduelle 5","Date 5","CGR A 5","CGR B 5","Libellé 1","Libellé 2","Libellé 3","Libellé 4","Libellé 5","Identifiant long 1","Identifiant long 2","Identifiant long 3","Identifiant long 4","Identifiant long 5","Date 1","Date 2","Date 3","Date 4","Date 5","Valeur de remplacement","Valeur d'assurance","Zone montant libre.","Zone montant libre.","Zone montant libre.","Zone montant libre.","Zone montant libre.","Zone montant libre.","Paramètre 1","Paramètre 2","Paramètre 3","Zone libre permettant de faire des sous-ensembles d'immobilisations.\n","Si \"N\" : Neuf\nSi \"O\" : Occasion","Permet de définir la stabilité de l'immobilisation.\nLes valeurs définies au produit sont :\n- \"F\" : Fixe\n- \"M\" : Mobile.","Numéro de parc","Nombre de chevaux fiscaux","Unité d'oeuvre","Numéro de lien","Permet de préciser directement le numéro de l'immobilisation à mettre à jour","Sous-numéro immo. à fusionner","Date de cession","Mnémonique","Celui qui est responsable de l'immobilisation, qui est chargé de sa maintenance.","Permet de définir si l'immobilisation est soumise ou non à la taxe professionnelle. Peut être utilisé pour définir uine autre information.\nLes valeurs définies au produit sont :\n- \"N\" : non soumis à la taxe ;\n      - \"O\" : oui, soumis à la taxe.","Le regroupement est une zone libre. Cette zone peut être choisie comme critère de tri et de totalisation dans les éditions.","Immobilisation supérieure","Sous-numéro immobilisation supérieure","Simulation","Code entrée : Mise à jour ou création ou fusion","Contexte comptabilité","Contexte commande","Contexte facture","Texte 1","Texte 2","Texte 3","Informations","\"A\" si actif, \"I\" si inactif et \"S\" si supprimé","Nature","Genre","Rôle","Modificateur","Date de modification","Les enregistrements avec le code traitement à \"A\" ne sont pas sélectionnés par le traitement de transfert TAMIMT.\nIl est positionné à \"R\" en cas de rejet lors du transfert par TAMIMT."]
["Type de champs","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Alphanumérique","Alphanumérique","Date (JJ/MM/AAAA)","Date (JJ/MM/AAAA)","Numérique","Numérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date (JJ/MM/AAAA)","Alphanumérique","Numérique","Numérique","Numérique","Date (JJ/MM/AAAA)","Alphanumérique","Alphanumérique","Alphanumérique","Entier","Alphanumérique","Entier","Alphanumérique","Entier","Alphanumérique","Date (JJ/MM/AAAA)","Alphanumérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Date (JJ/MM/AAAA)","Numérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Entier ","Alphanumérique","Alphanumérique","Alphanumérique","Entier","Alphanumérique","Date (JJ/MM/AAAA)","Numérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Numérique","Numérique","Date (JJ/MM/AAAA)","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Numérique","Numérique","Date (JJ/MM/AAAA)","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Numérique","Numérique","Date (JJ/MM/AAAA)","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Numérique","Numérique","Numérique","Date (JJ/MM/AAAA)","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 (JJ/MM/AAAA)","Date (JJ/MM/AAAA)","Date (JJ/MM/AAAA)","Date (JJ/MM/AAAA)","Date (JJ/MM/AAAA)","Numérique","Numérique","Numérique","Numérique","Numérique","Numérique","Numérique","Numérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Entier","Alphanumérique","Entier","Alphanumérique","Entier","Date (JJ/MM/AAAA)","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Alphanumérique","Entier","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 (JJ/MM/AAAA)","Alphanumérique"]
["Nombre caractères",6,30,4,10,80,2,6,2,99,60,20,10,10,99,99,99,99,10,10,20,30,10,6,99,99,99,10,80,20,1,11,8,11,10,11,30,10,10,99,99,10,10,10,20,6,2,10,99,99,99,14,14,11,4,10,5,11,7,10,null,99,14,2,6,null,null,null,10,80,20,2,6,99,99,99,10,80,20,2,6,99,99,99,10,80,20,2,6,99,99,99,10,80,20,60,60,60,60,60,20,20,20,20,20,10,10,10,10,10,99,99,99,99,99,99,99,99,10,10,10,6,2,2,20,11,6,11,10,5,10,10,6,2,10,10,5,1,null,60,60,60,60,60,60,240,1,2,2,1,30,10,2]
["Obligatoire ou facultatif","Obligatoire","Obligatoire","Obligatoire","Obligatoire","Obligatoire","Facultatif (*)","Facultatif (*)","Obligatoire","Facultatif","Obligatoire","Obligatoire","Obligatoire","Facultatif","Obligatoire","Obligatoire","Obligatoire","Obligatoire","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"]
["Majuscule","O","O","O","O","O","O","O","O","N","N","N","N","N","N","N","N","N","O","O","N","O","N","O","N","N","N","N","O","O","O","O","O","O","O","O","O","N","O","N","N","O","O","O","O","O","O","N","N","N","N","O","O","N","O","O","O","O","O","N","N","N","O","O","O","N","N","N","N","O","O","O","O","N","N","N","N","O","O","O","O","N","N","N","N","O","O","O","O","N","N","N","N","O","O","N","N","N","N","N","O","O","O","O","O","N","N","N","O","N","N","N","N","N","N","N","N","N","O","O","O","O","O","O","O","N","O","N","O","N","N","O","O","O","O","O","N","O","O","N","N","N","N","N","N","N","N","O","O","O","O","N","O"]

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