Sambuichi Peofessional Engineers Office

  • OIM-CSV with Arelle

    OIM-CSV with Arelle

    XBRL GL in CSV file with dimensional taxonomy can be consumed with Arelle and can generate dimensional XBRL GL instance.

    Continue reading

  • Why Consider a Dimension Only Approach For XBRL GL – Part 2 –

    Why Consider a Dimension Only Approach For XBRL GL – Part 2 –

    Views: 113Goal The current XBRL GL uses the element and the SRCD module (The Summary Reporting Contextual Data (SRCD) module) to define correspondences in order to aggregate detailed data into FR. In order to interpret this definition, it had to be processed by special software. It was verified that even in XBRL GL defined by the taxonomy of XBRL in a format that does not use tuples, it is possible to define the correspondence with FR using the formula link base of XBRL and aggregate detailed data. XBRL GL and SRCD formula linkbase with typed dimensions Conversion source XBRL GL taxonomy (glTaxsonomy.xsd) Conversion source XBRL GL instance (glTargetInstance.xml) Conversion destination […]

    Continue reading

  • Why Consider a Dimension Only Approach For XBRL GL – Part 1 –

    Why Consider a Dimension Only Approach For XBRL GL – Part 1 –

    My answer to this is, “Why not use Dimension to represent highly hierarchical data? The typed Dimension can represent highly hierarchical data”. Currently, most XBRL technologies do not support tuples. Without tuples, you can take full advantage of XBRL features such as formula linkbase, table linkbase, and OIM.

    Continue reading

  • Proof-of-concept implementation trial of international standard data formats 5(XBRL2.1 without child tuple1 )[in trial]

    Proof-of-concept implementation trial of international standard data formats 5(XBRL2.1 without child tuple1 )[in trial]

    Consider what happens if you define it in the dimension hypercube without using the definition link.

    Continue reading

  • Proof-of-concept implementation trial of international standard data formats 4(XBRL 2.1 table linkbase)[in trial]

    Proof-of-concept implementation trial of international standard data formats 4(XBRL 2.1 table linkbase)[in trial]

    Views: 79 Note: Currently under trial. It has not been resolved yet. Definition Specify the parent-child relationship based on the presentation linkbase in Breakdown on the Y axis. We are currently studying how to define the X-axis. In CSV files etc., the dI would like to be able to define one-dimensional based on table links.efinition of 2 dimensions is not necessary, only the definition of 1 dimension (heading column) has meaning, and the table is defined by repeating records. Note: The files can be found at GitHub. Execution result Altova XML Spy X axis does not expand well. Although the presentation linkbase item was displayed at the time of definition, only […]

    Continue reading

  • Proof-of-concept implementation trial of international standard data formats 3(XBRL 2.1 formula)

    Proof-of-concept implementation trial of international standard data formats 3(XBRL 2.1 formula)

    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.

    Continue reading

  • Proof-of-concept implementation trial of international standard data formats 2(XBRL 2.1 instance document)

    Proof-of-concept implementation trial of international standard data formats 2(XBRL 2.1 instance document)

    Implement definition linkbase (requires-element) relationship using typed dimension accountingEntries – entryHeader – 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.

    Continue reading

  • Proof-of-concept implementation trial of international standard data formats 1(XBRL 2.1 taxonomy)

    Proof-of-concept implementation trial of international standard data formats 1(XBRL 2.1 taxonomy)

    Views: 74 UN/CEFACT Core Component Technical Specification(CCTS) I will re-post the contents introduced in ISO 21378 Audit data collection data model definition based on UN/CEFACT CCTS and comparison with other standards including XBRL GL. Association Business Information Entity defines Aggregation in CCTS. Association is required to define Audit data collection data model. [Definition] Business Information Entity (BIE) A piece of business data or a group of pieces of business data with a unique Business Semantic definition. A Business Information Entity can be a Basic Business Information Entity (BBIE), an Association Business Information Entity (ASBIE), or an Aggregate Business Information Entity (ABIE). [Definition] Basic Business Information Entity (BBIE) A Business Information […]

    Continue reading

  • How to use the standard data format comparison page

    How to use the standard data format comparison page

    Views: 107[jwplayer player=”2″ playlistid=”3775″] Screen is divided horizontally. Select a standard and click the tab menu to display the configuration.A list of aggregated business information (ABIE) is displayed. Click the item whose configuration you want to check, and the screen that expands the item list will be displayed at the bottom. Note: The response may be delayed and a different item may be selected. Move the cursor over the item and change the line color before clicking. A (+) icon is displayed at the left end of the Association Business Information Entity (ASBIE). Click the row of selected Entity to expand the related Aggregate Business Information Entity. Click the I […]

    Continue reading

  • ISO 21378 Audit data collection data model definition

    ISO 21378 Audit data collection data model definition

    Views: 79ISO 21378 Audit data collection data model definition based on UN/CEFACT CCTS and comparison with other standards including XBRL GL We are currently investigating other standards to clarify the data architecture of the audit data collection. The goal is to define an ADS data model based on the Core Component Technical Specification (CCTS) defined in ISO 15000-5. A comparison site (https://www.wuwei.space/iso/tc295/index.html) is in development. This site helps to check similarities and differences between following data model, namely, UN/CEFACT core component libraries and business information entities, OASIS Universal Business Language (UBL), AICPA’s audit data standards (ADS) including XBRL GL, ISO 21378 audit data collection. This site is constructed by analyzing […]

    Continue reading

  • Portrait

    Portrait

    I draw Japanese-traditional paintings on linen paper using Iwa-enogu(岩絵具) pigments and Doro-enogu(泥絵具) pigments to finish the work.

    Continue reading

  • Issues on Spec 2.1 JIS X 7206:2020

    Issues on Spec 2.1 JIS X 7206:2020

    Views: 97Issues on Spec 2.1 Spec 2.1 is NOT edited sufficiently clear and consistently 21 October 2019 SAMBUICHI Nobuyuki XBRL Japan Advisor Representative of JIS X 7206:2020 editorial working group ISO TC 295 Audit data services Head of delegate Japanese Industrial Standards Committee Additional PDF Files for presentation; Today’s presentation slides(PDF 724KB) JIS X 7206:2020 4.6.3 ~ 4.6.7 (Translated into English)(PDF 93KB) References IETF RFC 2119 IETF (Internet Engineering Task Force). “RFC 2119: Key words for use in RFCs to Indicate Requirement Levels” Scott Bradner. (See http://www.ietf.org/rfc/rfc2119.txt) IEEE IEEE. “IEEE Standard for Floating Point Arithmetic, IEEE Std 754™-2008” (See http://ieeexplore.ieee.org/xpl/mostRecentIssue.jsp?punumber=4610933) This standard is equivalent to following ISO standard ISO/IEC/IEEE 60559:2011(en) […]

    Continue reading

Got any book recommendations?