{"id":4013,"date":"2020-07-21T10:24:49","date_gmt":"2020-07-21T01:24:49","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=4013"},"modified":"2020-07-26T05:19:49","modified_gmt":"2020-07-25T20:19:49","slug":"%e4%b8%96%e7%95%8c%e6%a8%99%e6%ba%96%e3%83%87%e3%83%bc%e3%82%bf%e5%bd%a2%e5%bc%8f%e3%81%aexbrl-2-1%e3%81%a7%e3%81%ae%e5%ae%9f%e8%a3%85%e4%bd%9c%e6%a5%ad%ef%bc%88%e3%83%95%e3%82%a9%e3%83%bc%e3%83%9f","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=4013&lang=en","title":{"rendered":"Proof-of-concept implementation trial of international standard data formats 3\uff08XBRL 2.1 formula\uff09"},"content":{"rendered":"

Views: 73<\/p>

<\/div>\n

Definition<\/h2>\n

Specify xbrli:xbrl for ancestorFilter, target all items including characters in typedDimension, add up the total amount of credit with test=”..\/gl-cor:debitCreditCode eq 'C'” and debit with ‘D’ in test of the filter, and verify whether the total amounts match.<\/p>\n

Note: The files can be found at GitHub<\/a>.<\/p>\n

\"\"<\/a><\/p>\n

\r\n\t<gen:link xlink:type=\"extended\" xlink:role=\"http:\/\/www.xbrl.org\/2008\/role\/link\">\r\n\t<!-- formula -->\r\n\t\t<formula:formula id=\"formula_balance\" aspectModel=\"dimensional\" implicitFiltering=\"true\" value=\"if (abs(sum( $creditAmts ) - sum( $debitAmts )) lt 1.0)   then concat(&apos;Credit Amounts(&apos;,sum($creditAmts),&apos;) Debit Amounts(&apos;,sum($debitAmts),&apos;) is in balance&apos;)   else concat(&apos;Credit Amounts(&apos;,sum($creditAmts),&apos;)Debit Amounts(:&apos;,sum($debitAmts),&apos;) is not in balance&apos;)\" source=\"formula:uncovered\" xlink:type=\"resource\" xlink:label=\"formula_balance\">\r\n\t\t\t<formula:aspects>\r\n\t\t\t\t<formula:concept>\r\n\t\t\t\t\t<formula:qname>gl-cor:entriesComment<\/formula:qname>\r\n\t\t\t\t<\/formula:concept>\r\n\t\t\t<\/formula:aspects>\r\n\t\t<\/formula:formula>\r\n\t<!-- variableArc -->\r\n\t\t<variable:variableArc name=\"debitAmts\" order=\"1.0\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-set\" xlink:from=\"formula_balance\" xlink:to=\"debitAmount\"\/>\r\n\t\t<variable:variableArc name=\"creditAmts\" order=\"2.0\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-set\" xlink:from=\"formula_balance\" xlink:to=\"creditAmount\"\/>\r\n\t<!-- factVariable -->\r\n\t\t<variable:factVariable id=\"creditAmount\" bindAsSequence=\"true\" xlink:type=\"resource\" xlink:label=\"creditAmount\"\/>\r\n\t\t<variable:factVariable id=\"debitAmount\" bindAsSequence=\"true\" xlink:type=\"resource\" xlink:label=\"debitAmount\"\/>\r\n\t<!-- variableFilterArc -->\r\n\t\t<variable:variableFilterArc order=\"1.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"creditAmount\" xlink:to=\"amount_nameFilter\"\/>\r\n\t\t<variable:variableFilterArc order=\"2.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"creditAmount\" xlink:to=\"Credit_filter\"\/>\r\n\t\t<variable:variableFilterArc order=\"3.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"creditAmount\" xlink:to=\"typedDimension\"\/>\r\n\t\t<variable:variableFilterArc order=\"4.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"creditAmount\" xlink:to=\"typedDimension1\"\/>\r\n\t\t<variable:variableFilterArc order=\"5.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"creditAmount\" xlink:to=\"ancestorFilter\"\/>\r\n\t\t<variable:variableFilterArc order=\"6.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"debitAmount\" xlink:to=\"amount_nameFilter\"\/>\r\n\t\t<variable:variableFilterArc order=\"7.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"debitAmount\" xlink:to=\"Debit_filter\"\/>\r\n\t\t<variable:variableFilterArc order=\"8.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"debitAmount\" xlink:to=\"typedDimension\"\/>\r\n\t\t<variable:variableFilterArc order=\"9.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"debitAmount\" xlink:to=\"typedDimension1\"\/>\r\n\t\t<variable:variableFilterArc order=\"10.0\" complement=\"false\" cover=\"true\" xlink:type=\"arc\" xlink:arcrole=\"http:\/\/xbrl.org\/arcrole\/2008\/variable-filter\" xlink:from=\"debitAmount\" xlink:to=\"ancestorFilter\"\/>\r\n\t<!-- filter -->\r\n\t\t<cf:conceptName id=\"amount_nameFilter\" xlink:type=\"resource\" xlink:label=\"amount_nameFilter\">\r\n\t\t\t<cf:concept>\r\n\t\t\t\t<cf:qname>gl-cor:amount<\/cf:qname>\r\n\t\t\t<\/cf:concept>\r\n\t\t<\/cf:conceptName>\r\n\t\t<gf:general id=\"Debit_filter\" test=\"..\/gl-cor:debitCreditCode eq &apos;D&apos;\" xlink:type=\"resource\" xlink:label=\"Debit_filter\"\/>\r\n\t\t<gf:general id=\"Credit_filter\" test=\"..\/gl-cor:debitCreditCode eq &apos;C&apos;\" xlink:type=\"resource\" xlink:label=\"Credit_filter\"\/>\r\n\t\t<tf:ancestorFilter id=\"ancestorFilter\" xlink:type=\"resource\" xlink:label=\"ancestorFilter\">\r\n\t\t\t<tf:ancestor>\r\n\t\t\t\t<tf:qname>xbrli:xbrl<\/tf:qname>\r\n\t\t\t<\/tf:ancestor>\r\n\t\t<\/tf:ancestorFilter>\r\n\t\t<pf:periodInstant id=\"periodInstant\" date=\"2020-01-01\" xlink:type=\"resource\" xlink:label=\"periodInstant\"\/>\t\t\r\n\t\t<df:typedDimension id=\"typedDimension\" test=\"string-length(gl-cor:EntryNumber) &gt; 0\" xlink:type=\"resource\" xlink:label=\"typedDimension\">\r\n\t\t\t<df:dimension>\r\n\t\t\t\t<df:qname>gl-cor:dEntryNumber<\/df:qname>\r\n\t\t\t<\/df:dimension>\r\n\t\t<\/df:typedDimension>\r\n\t\t<df:typedDimension id=\"typedDimension1\" test=\"string-length(gl-cor:LineNumber) &gt; 0\" xlink:type=\"resource\" xlink:label=\"typedDimension1\">\r\n\t\t\t<df:dimension>\r\n\t\t\t\t<df:qname>gl-cor:dLineNumber<\/df:qname>\r\n\t\t\t<\/df:dimension>\r\n\t\t<\/df:typedDimension>\r\n\t<\/gen:link><\/pre>\n
<\/div>\n
Execution result of formula linkbase<\/h5>\n
Altova XML Spy<\/span>
\n\"\"<\/a>
\narelle<\/span>
\n\"\"<\/a><\/p>\n
\n
Proof-of-concept implementation trial of international standard data formats<\/p>\n
\n1 XBRL 2.1 taxonomy<\/b><\/a>
\n  UN\/CEFACT Core Component Technical Specification\uff08CCTS\uff09\/a>
\n  Objective: Improve transparency and extensibility by expressing CCTS structure in XBRL 2.1<\/a>
\n    Tuple child of tuple does not include child tuple<\/a>
\n    DTS<\/a>
\n    Tuple definition<\/a>
\n    Definition linkbase<\/a>
\n    Presentation linkbase<\/a>
\n2 XBRL 2.1 instance document<\/b><\/a>
\n  Implement definition linkbase (requires-element) relationship using typed dimension<\/a>
\n  xbrldt:dimensionItem definition in taxonomy document<\/a>
\n  xbrli:context definition in instance document<\/a>
\n  Instance document<\/a>
\n  Execution result of formula linkbase<\/a>
\n3 XBRL 2.1 formula<\/b><\/a>
\n  Definition<\/a>
\n  Execution result of formula linkbase<\/a>
\n4 XBRL 2.1 table linkbase [in trial]<\/b><\/a>
\n  Definition<\/a>
\n  Execution result\/a>
\n5 XBRL 2.1 without child tuple1 [in trial]<\/b><\/a>
\n  Definition<\/a>
\n  Instance document<\/a>
\n  Execution result<\/a>\n<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Specify xbrli:xbrl for ancestorFilter, target all items including characters in typedDimension, add up the total amount of credit with test=”..\/gl-cor:debitCreditCode eq 'C'” and debit with ‘D’ in test of the filter, and verify whether the total amounts match.<\/p>\n","protected":false},"author":2,"featured_media":3797,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/4013"}],"collection":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4013"}],"version-history":[{"count":8,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/4013\/revisions"}],"predecessor-version":[{"id":4098,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/4013\/revisions\/4098"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/3797"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}