{"id":1794,"date":"2012-06-11T13:45:46","date_gmt":"2012-06-11T11:45:46","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=1794"},"modified":"2015-07-11T19:46:47","modified_gmt":"2015-07-11T17:46:47","slug":"etafi-conso-detail-des-etats-de-passage-des-etats-financiers-presentation-de-lextraction-de-donnees","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=1794","title":{"rendered":"ETAFI CONSO : D\u00e9tail des \u00e9tats de passage des \u00e9tats financiers (pr\u00e9sentation de l\u2019extraction de donn\u00e9es)"},"content":{"rendered":"<p style=\"text-align: justify;\">L\u2019article pr\u00e9c\u00e9dent pr\u00e9sente l\u2019<a href=\"http:\/\/www.auditsi.eu\/?p=1774\">extraction de donn\u00e9es d\u00e9taillant le tableau de passage des \u00e9tats financiers du social au consolid\u00e9<\/a> d\u2019ETAFI CONSO (YOURCEGID CONSOLIDATION). Ces informations, export\u00e9es dans un classeur Excel, peuvent servir de base \u00e0 l\u2019audit des comptes consolid\u00e9s par le commissaire aux comptes.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/06\/D\u00e9tail-Tableau-Passage.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1795\" title=\"D\u00e9tail Tableau Passage\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/06\/D\u00e9tail-Tableau-Passage.jpg\" alt=\"D\u00e9tail Tableau Passage\" width=\"536\" height=\"342\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/06\/D\u00e9tail-Tableau-Passage.jpg 536w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/06\/D\u00e9tail-Tableau-Passage-300x191.jpg 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/06\/D\u00e9tail-Tableau-Passage-1x1.jpg 1w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Voici les champs caract\u00e9ristiques :<\/p>\n<p style=\"text-align: justify;\">OEP_CODEETAT : identification de l\u2019\u00e9tat financier (BILAN ou COMPTE DE RESULTAT),<\/p>\n<p style=\"text-align: justify;\">OEP_CODEZONE : identification du poste de l\u2019\u00e9tat financier concern\u00e9 (code),<\/p>\n<p style=\"text-align: justify;\">OEA_ENTDET : identification de l\u2019entit\u00e9 concern\u00e9e,<\/p>\n<p style=\"text-align: justify;\">OEA_RUBCONSO : rubrique de consolidation,<\/p>\n<p style=\"text-align: justify;\">OEA_SOLDE : solde comptable,<\/p>\n<p style=\"text-align: justify;\">OEA_CODESCHEMA : code du sch\u00e9ma d\u2019\u00e9criture (cumul social, retraitement du cr\u00e9dit-bail\u2026),<\/p>\n<p style=\"text-align: justify;\">OEA_JOURNAL EC : code journal (\u00e9liminations, retraitements\u2026),<\/p>\n<p style=\"text-align: justify;\">OEA_ID : identifiant de l\u2019\u00e9criture (n\u00b0 de pi\u00e8ce utile pour retrouver les contreparties),<\/p>\n<p style=\"text-align: justify;\">OEA_ENTLIEE : entit\u00e9 li\u00e9e (en cas d\u2019\u00e9limination d\u2019op\u00e9ration r\u00e9ciproque ou de cession interne),<\/p>\n<p style=\"text-align: justify;\">OEA_LIBELLE : libell\u00e9 de l\u2019\u00e9criture,<\/p>\n<p style=\"text-align: justify;\">OEP_LIBELLETOTAL : libell\u00e9 du poste de totalisation dans les \u00e9tats financiers (par exemple : CAPITAUX PROPRES),<\/p>\n<p style=\"text-align: justify;\">OEP_LIBELLEPOSTE : libell\u00e9 du poste de rattachement dans les \u00e9tats financiers (par exemple : Capital social),<\/p>\n<p style=\"text-align: justify;\">Suivant la version d\u2019ETAFI utilis\u00e9e, le r\u00e9sultat de l\u2019exportation diff\u00e8re (l\u2019extraction pr\u00e9sent\u00e9e ici provient d\u2019un dossier sous la V4).<\/p>\n<p style=\"text-align: justify;\">Les pr\u00e9sentations \u00e9tant faites, il ne reste plus qu\u2019\u00e0 <a href=\"http:\/\/www.auditsi.eu\/?p=2029\">exploiter ces pr\u00e9cieuses donn\u00e9es<\/a>. A suivre&#8230;<\/p>\n<p style=\"text-align: justify;\"><em>Retrouvez tous les articles sur l&#8217;<a title=\"Articles sur : Audit des comptes consolid\u00e9s\" href=\"http:\/\/www.auditsi.eu\/?cat=324\">audit des comptes consolid\u00e9s<\/a>,\u00a0<a href=\"http:\/\/www.auditsi.eu\/?tag=etafi-conso\"><em>ETAFI CONSO<\/em><\/a><em>, la\u00a0<\/em><a href=\"http:\/\/www.auditsi.eu\/?tag=consolidation\"><em>consolidation<\/em><\/a><\/em><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"ETAFI%20CONSO%20%3A%20D%C3%A9tail%20des%20%C3%A9tats%20de%20passage%20des%20%C3%A9tats%20financiers%20%28pr%C3%A9sentation%20de%20l%E2%80%99extraction%20de%20donn%C3%A9es%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>L\u2019article pr\u00e9c\u00e9dent pr\u00e9sente l\u2019extraction de donn\u00e9es d\u00e9taillant le tableau de passage des \u00e9tats financiers du social au consolid\u00e9 d\u2019ETAFI CONSO (YOURCEGID CONSOLIDATION). Ces informations, export\u00e9es dans un classeur Excel, peuvent servir de base \u00e0 l\u2019audit des comptes consolid\u00e9s par le commissaire aux comptes. Voici les champs caract\u00e9ristiques : OEP_CODEETAT : identification de l\u2019\u00e9tat financier (BILAN &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=1794\" class=\"more-link\">Continue reading &lsquo;ETAFI CONSO : D\u00e9tail des \u00e9tats de passage des \u00e9tats financiers (pr\u00e9sentation de l\u2019extraction de donn\u00e9es)&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"ETAFI%20CONSO%20%3A%20D%C3%A9tail%20des%20%C3%A9tats%20de%20passage%20des%20%C3%A9tats%20financiers%20%28pr%C3%A9sentation%20de%20l%E2%80%99extraction%20de%20donn%C3%A9es%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[50,7,324,8,6],"tags":[1645,179,1632,17,1003,306,325,1633,52,1004,1001,1002,1005,995,1000,999],"class_list":["post-1794","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-breves","category-comptes-consolides","category-extractions-de-donnees","category-mission-du-commissaire-aux-comptes","tag-comptes-consolides","tag-consolidation","tag-controle-des-comptes","tag-demarche-daudit","tag-entite-liee","tag-etafi-conso","tag-etats-financiers","tag-excel","tag-exploitation-des-donnees","tag-journal","tag-poste","tag-rubrique","tag-schema-decriture","tag-tableau-de-passage","tag-v4","tag-yourcegid-consolidation"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1794"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1794\/revisions"}],"predecessor-version":[{"id":6120,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1794\/revisions\/6120"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}