{"id":4011,"date":"2020-07-21T09:27:01","date_gmt":"2020-07-21T00:27:01","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=4011"},"modified":"2020-07-26T05:19:23","modified_gmt":"2020-07-25T20:19:23","slug":"%e3%82%a4%e3%83%b3%e3%82%b9%e3%82%bf%e3%83%b3%e3%82%b9","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=4011&lang=en","title":{"rendered":"Proof-of-concept implementation trial of international standard data formats 2\uff08XBRL 2.1 instance document\uff09"},"content":{"rendered":"<p>Views: 60<\/p><div id=\"top\"><\/div>\n<h2>Implement definition linkbase (requires-element) relationship using typed dimension<\/h2>\n<h5>accountingEntries &#8211; entryHeader &#8211; entryDetail<\/h5>\n<p>In XBRL GL, an instance document is defined in a nested structure of ComplexContent without using Context. By setting the maximum number of repetitions of child elements, multiple entryHeaders are expressed under accountingEntries, and multiple entryDetails are expressed under entryHeader. Arbitrary repetition is possible. When disassembling this, the problem is how to express the relationship between accountingEntries and entryHeader and the relationship between entryHeader and entryDetail.<\/p>\n<p>Note: The files can be found at <a href=\"https:\/\/github.com\/pontsoleil\/xBRL-Alpha\/tree\/master\/withTuple\/gl\">GitHub<\/a>.<\/p>\n<div id=\"s1\"><\/div>\n<h5>xbrldt:dimensionItem definition in taxonomy document<\/h5>\n<pre class=\"lang:default decode:true \" title=\"xbrldt:dimensionItem\u5b9a\u7fa9\" >&lt;!-- Domain --&gt;\r\n&lt;element name=\"EntryNumber\" id=\"gl-cor_EntryNumber\"&gt;\r\n\t&lt;simpleType&gt;\r\n\t\t&lt;restriction base=\"string\"\/&gt;\r\n\t&lt;\/simpleType&gt;\r\n&lt;\/element&gt;\r\n&lt;element name=\"dEntryNumber\" id=\"gl-cor_dEntryNumber\" type=\"xbrli:stringItemType\" substitutionGroup=\"xbrldt:dimensionItem\" abstract=\"true\" xbrli:periodType=\"instant\" xbrldt:typedDomainRef=\"#gl-cor_EntryNumber\"\/&gt;\r\n&lt;element name=\"LineNumber\" id=\"gl-cor_LineNumber\"&gt;\r\n\t&lt;simpleType&gt;\r\n\t\t&lt;restriction base=\"string\"\/&gt;\r\n\t&lt;\/simpleType&gt;\r\n&lt;\/element&gt;\r\n&lt;element name=\"dLineNumber\" id=\"gl-cor_dLineNumber\" type=\"xbrli:stringItemType\" substitutionGroup=\"xbrldt:dimensionItem\" abstract=\"true\" xbrli:periodType=\"instant\" xbrldt:typedDomainRef=\"#gl-cor_LineNumber\"\/&gt;\r\n<\/pre>\n<div id=\"s2\"><\/div>\n<h5>xbrli:context definition in instance document<\/h5>\n<p>&lt;xbrli:segment&gt;\u306b&lt;xbrldi:typedMember dimension=&#8221;gl-cor:dEntryNumber&#8221;&gt; and &lt;xbrldi:typedMember dimension=&#8221;gl-cor:dLineNumber&#8221;&gt; define &lt;xbrli:context&gt;.<\/p>\n<pre class=\"lang:default decode:true \" title=\"xbrli:context definition\" >&lt;!-- context --&gt;\r\n&lt;xbrli:context id=\"now\"&gt;\r\n\t&lt;xbrli:entity&gt;\r\n\t\t&lt;xbrli:identifier scheme=\"http:\/\/www.xbrl.org\/xbrlgl\/sample\"&gt;SAMPLE&lt;\/xbrli:identifier&gt;\r\n\t&lt;\/xbrli:entity&gt;\r\n\t&lt;xbrli:period&gt;\r\n\t\t&lt;xbrli:instant&gt;2020-01-01&lt;\/xbrli:instant&gt;\r\n\t&lt;\/xbrli:period&gt;\r\n&lt;\/xbrli:context&gt;\r\n&lt;xbrli:context id=\"H1\"&gt;\r\n\t&lt;xbrli:entity&gt;\r\n\t\t&lt;xbrli:identifier scheme=\"http:\/\/www.xbrl.org\/xbrlgl\/sample\"&gt;SAMPLE&lt;\/xbrli:identifier&gt;\r\n\t\t&lt;xbrli:segment&gt;\r\n\t\t\t&lt;xbrldi:typedMember dimension=\"gl-cor:dEntryNumber\"&gt;\r\n\t\t\t\t&lt;gl-cor:EntryNumber&gt;H1&lt;\/gl-cor:EntryNumber&gt;\r\n\t\t\t&lt;\/xbrldi:typedMember&gt;\r\n\t\t&lt;\/xbrli:segment&gt;\r\n\t&lt;\/xbrli:entity&gt;\r\n\t&lt;xbrli:period&gt;\r\n\t\t&lt;xbrli:instant&gt;2020-01-01&lt;\/xbrli:instant&gt;\r\n\t&lt;\/xbrli:period&gt;\r\n&lt;\/xbrli:context&gt;\r\n&lt;xbrli:context id=\"H1L1\"&gt;\r\n\t&lt;xbrli:entity&gt;\r\n\t\t&lt;xbrli:identifier scheme=\"http:\/\/www.xbrl.org\/xbrlgl\/sample\"&gt;SAMPLE&lt;\/xbrli:identifier&gt;\r\n\t\t&lt;xbrli:segment&gt;\r\n\t\t\t&lt;xbrldi:typedMember dimension=\"gl-cor:dEntryNumber\"&gt;\r\n\t\t\t\t&lt;gl-cor:EntryNumber&gt;H1&lt;\/gl-cor:EntryNumber&gt;\r\n\t\t\t&lt;\/xbrldi:typedMember&gt;\r\n\t\t\t&lt;xbrldi:typedMember dimension=\"gl-cor:dLineNumber\"&gt;\r\n\t\t\t\t&lt;gl-cor:LineNumber&gt;L1&lt;\/gl-cor:LineNumber&gt;\r\n\t\t\t&lt;\/xbrldi:typedMember&gt;\r\n\t\t&lt;\/xbrli:segment&gt;\r\n\t&lt;\/xbrli:entity&gt;\r\n\t&lt;xbrli:period&gt;\r\n\t\t&lt;xbrli:instant&gt;2020-01-01&lt;\/xbrli:instant&gt;\r\n\t&lt;\/xbrli:period&gt;\r\n&lt;\/xbrli:context&gt;\r\n\t&lt;xbrli:context id=\"H1L2\"&gt;\r\n\t\t&lt;xbrli:entity&gt;\r\n\t\t\t&lt;xbrli:identifier scheme=\"http:\/\/www.xbrl.org\/xbrlgl\/sample\"&gt;SAMPLE&lt;\/xbrli:identifier&gt;\r\n\t\t\t&lt;xbrli:segment&gt;\r\n\t\t\t\t&lt;xbrldi:typedMember dimension=\"gl-cor:dEntryNumber\"&gt;\r\n\t\t\t\t\t&lt;gl-cor:EntryNumber&gt;H1&lt;\/gl-cor:EntryNumber&gt;\r\n\t\t\t\t&lt;\/xbrldi:typedMember&gt;\r\n\t\t\t\t&lt;xbrldi:typedMember dimension=\"gl-cor:dLineNumber\"&gt;\r\n\t\t\t\t\t&lt;gl-cor:LineNumber&gt;L2&lt;\/gl-cor:LineNumber&gt;\r\n\t\t\t\t&lt;\/xbrldi:typedMember&gt;\r\n\t\t\t&lt;\/xbrli:segment&gt;\r\n\t\t&lt;\/xbrli:entity&gt;\r\n\t\t&lt;xbrli:period&gt;\r\n\t\t\t&lt;xbrli:instant&gt;2020-01-01&lt;\/xbrli:instant&gt;\r\n\t\t&lt;\/xbrli:period&gt;\r\n\t&lt;\/xbrli:context&gt;\r\n<\/pre>\n<div id=\"s3\"><\/div>\n<h5>Instance document<\/h5>\n<p>A entryHeader is defined as &lt;gl-cor:entryHeader contextRef=&#8221;H1&#8243;&gt;H1&lt;\/gl-cor:entryHeader&gt; and &lt;gl-cor:entryHeader.Detail&gt; for presentation linkbase\u3002<br \/>\nA entryDetail corresponding to entryHeader is defined as &lt;gl-cor:specified.entryDetail contextRef=&#8221;H1L1&#8243;\/&gt; under tuple structure. &lt;gl-cor:entryDetail.Detail&gt;&#8217;s children defines correspondent relation with contextRef=&#8221;H1L1&#8243; attribute.<\/p>\n<pre class=\"lang:default decode:true \" title=\"entryHeader and entryDetail\" >&lt;!-- entryHeader --&gt;\r\n\t&lt;gl-cor:entryHeader.Detail&gt;\r\n\t\t&lt;gl-cor:enteredBy contextRef=\"H1\"&gt;Otto Wellwood&lt;\/gl-cor:enteredBy&gt;\r\n\t\t&lt;gl-cor:enteredDate contextRef=\"H1\"&gt;2005-07-01&lt;\/gl-cor:enteredDate&gt;\r\n\t\t&lt;gl-cor:sourceJournalID contextRef=\"H1\"&gt;gj&lt;\/gl-cor:sourceJournalID&gt;\r\n\t\t&lt;gl-bus:sourceJournalDescription contextRef=\"H1\"&gt;JE&lt;\/gl-bus:sourceJournalDescription&gt;\r\n\t\t&lt;gl-cor:entryType contextRef=\"H1\"&gt;standard&lt;\/gl-cor:entryType&gt;\r\n\t\t&lt;gl-cor:entryNumber contextRef=\"H1\"&gt;1&lt;\/gl-cor:entryNumber&gt;\r\n\t\t&lt;gl-cor:entryComment contextRef=\"H1\"&gt;Current period depreciation expense&lt;\/gl-cor:entryComment&gt;\r\n\t\t&lt;gl-cor:qualifierEntry contextRef=\"H2\"&gt;standard&lt;\/gl-cor:qualifierEntry&gt;\r\n\t\t&lt;gl-bus:totalDebit decimals=\"2\" contextRef=\"H1\" unitRef=\"usd\"&gt;7700.00&lt;\/gl-bus:totalDebit&gt;\r\n\t\t&lt;gl-bus:totalCredit decimals=\"2\" contextRef=\"H1\" unitRef=\"usd\"&gt;7700.00&lt;\/gl-bus:totalCredit&gt;\r\n\t\t&lt;gl-cor:bookTaxDifference contextRef=\"H1\"&gt;temporary&lt;\/gl-cor:bookTaxDifference&gt;\r\n\t\t&lt;gl-cor:specified.entryDetail contextRef=\"H1L1\"\/&gt;\r\n\t\t&lt;gl-cor:specified.entryDetail contextRef=\"H1L2\"\/&gt;\r\n\t\t&lt;gl-cor:specified.entryDetail contextRef=\"H1L3\"\/&gt;\r\n\t\t&lt;gl-cor:specified.entryDetail contextRef=\"H1L4\"\/&gt;\r\n\t&lt;\/gl-cor:entryHeader.Detail&gt;\r\n&lt;!-- entryDetail --&gt;\r\n\t&lt;gl-cor:entryDetail.Detail&gt;\r\n\t\t&lt;gl-cor:lineNumber contextRef=\"H1L1\"&gt;L1&lt;\/gl-cor:lineNumber&gt;\r\n\t\t&lt;gl-cor:specified.account contextRef=\"ACCOUNT6200\"\/&gt;\r\n\t\t&lt;gl-cor:amount decimals=\"2\" contextRef=\"H1L1\" unitRef=\"usd\"&gt;7000.00&lt;\/gl-cor:amount&gt;\r\n\t\t&lt;gl-cor:debitCreditCode contextRef=\"H1L1\"&gt;D&lt;\/gl-cor:debitCreditCode&gt;\r\n\t\t&lt;gl-cor:postingDate contextRef=\"H1L1\"&gt;2005-06-30&lt;\/gl-cor:postingDate&gt;\r\n\t\t&lt;gl-cor:postingStatus contextRef=\"H1L1\"&gt;posted&lt;\/gl-cor:postingStatus&gt;\r\n\t\t&lt;gl-cor:detailComment contextRef=\"H1L1\"&gt;Current period depreciation expense - books&lt;\/gl-cor:detailComment&gt;\r\n\t&lt;\/gl-cor:entryDetail.Detail&gt;<\/pre>\n<p><a  href=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig2.jpg\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"fig2\" data-rl_caption=\"\" title=\"fig2\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig2-1024x975.jpg\" alt=\"\" width=\"1024\" height=\"975\" class=\"alignnone size-large wp-image-3810\" srcset=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig2-1024x975.jpg 1024w, https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig2-300x286.jpg 300w, https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig2-768x731.jpg 768w, https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig2-1536x1462.jpg 1536w, https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig2.jpg 1789w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<div id=\"s4\"><\/div>\n<h5>Execution result of formula linkbase<\/h5>\n<p>Running the formula link-based test to verify that the total debit and debit amounts match in the instance document expressed in the definition above yields the following results:<br \/>\n<a href=\"https:\/\/www.sambuichi.jp\/?p=3858\">another page<\/a> describes more detail.<br \/>\n<a  href=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig12-scaled.jpg\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"fig12\" data-rl_caption=\"\" title=\"fig12\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.sambuichi.jp\/wp-content\/uploads\/2020\/07\/fig12-1024x427.jpg\" alt=\"\" width=\"1024\" height=\"427\" class=\"alignnone size-large wp-image-3796\" \/><\/a><\/p>\n<div class=\"index\" style=\"width: 90%; margin: auto; padding-left: 8px; border: solid 1px #d0d0d0;\">\n<p style=\"text-align:center\">Proof-of-concept implementation trial of international standard data formats<\/p>\n<p style=\"margin: 0;\">\n<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en\"><b>1 XBRL 2.1 taxonomy<\/b><\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en#top\">UN\/CEFACT Core Component Technical Specification\uff08CCTS\uff09\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en#goal\">Objective: Improve transparency and extensibility by expressing CCTS structure in XBRL 2.1<\/a><br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en#s1\">Tuple child of tuple does not include child tuple<\/a><br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en#s2\">DTS<\/a><br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en#s3\">Tuple definition<\/a><br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en#s4\">Definition linkbase<\/a><br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3786&#038;lang=en#s5\">Presentation linkbase<\/a><br \/>\n<a href=\"https:\/\/www.sambuichi.jp\/?p=3846&#038;lang=en\"><b>2 XBRL 2.1 instance document<\/b><\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3846&#038;lang=en#top\">Implement definition linkbase (requires-element) relationship using typed dimension<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3846&#038;lang=en#s1\">xbrldt:dimensionItem definition in taxonomy document<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3846&#038;lang=en#s2\">xbrli:context definition in instance document<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3846&#038;lang=en#s3\">Instance document<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3846&#038;lang=en#s4\">Execution result of formula linkbase<\/a><br \/>\n<a href=\"https:\/\/www.sambuichi.jp\/?p=3858&#038;lang=en\"><b>3 XBRL 2.1 formula<\/b><\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3858&#038;lang=en#top\">Definition<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3858&#038;lang=en#s1\">Execution result of formula linkbase<\/a><br \/>\n<a href=\"https:\/\/www.sambuichi.jp\/?p=3932&#038;lang=en\"><b>4 XBRL 2.1 table linkbase [in trial]<\/b><\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3932&#038;lang=en#top\">Definition<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3932&#038;lang=en#s1\">Execution result\/a><br \/>\n<a href=\"https:\/\/www.sambuichi.jp\/?p=3965&#038;lang=en\"><b>5 XBRL 2.1 without child tuple1 [in trial]<\/b><\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3965&#038;lang=en#top\">Definition<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3965&#038;lang=en#s3\">Instance document<\/a><br \/>\n&nbsp;&nbsp;<a href=\"https:\/\/www.sambuichi.jp\/?p=3965&#038;lang=en#s5\">Execution result<\/a>\n<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Implement definition linkbase (requires-element) relationship using typed dimension accountingEntries &#8211; entryHeader &#8211; entryDetail In XBRL GL, an instance document is defined in a nested structure of ComplexContent without using Context. By setting the maximum number of repetitions of child elements, multiple entryHeaders are expressed under accountingEntries, and multiple entryDetails are expressed under entryHeader. Arbitrary repetition is possible. When disassembling this, the problem is how to express the relationship between accountingEntries and entryHeader and the relationship between entryHeader and entryDetail.<\/p>\n","protected":false},"author":2,"featured_media":3811,"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\/4011"}],"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=4011"}],"version-history":[{"count":10,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/4011\/revisions"}],"predecessor-version":[{"id":4097,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/4011\/revisions\/4097"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/3811"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}