三分一技術士事務所

Category: XBRL @en

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 […]

2020-07-07
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 […]

2020-07-06
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) […]

2019-10-20
Breathing new life into old systems

THE CORPORATION recently faced a classic problem—the need to significantly improve the quality of financial data available to key decision makers. They had little time or resources to make wholesale changes. This was old story in 2004 but still valuable today. See more detail; …

2019-10-19
Preliminary test results of each file format

Views: 119preliminary test results of each file format Prepare, Extract, Ingest No one want to read extracted data with text editor and look up relevant data without any help from software. Data accessibility requires Ingesting data to data store and/or software service. Test results for following 3 steps;Data　Preparation, Extraction, and Ingestion Extraction Results Extract time and file size for each file format. One year (12,352 records) of General Ledger entry data of Small Entity. Generated 4 files for each quarter periods. There is difference among each file. XBRL GL took more time and file size. BUT these difference has less importance with today’s IT environment. Software is written in PHP […]

2019-10-11
XML schema design for the audit data collection

Views: 83ISO PC295 WD4 initial design XML Schema for GL module Brief introduction to XBRL GL XBRL GL provides a set of Common Accounting Vocabulary Palette Design XBRL GL Taxonomy Framework Technical Architecture 2015 http://www.xbrl.org/int/gl/2015-03-25/GLTFTA-REC-2015-03-25.html#section-control-over-the-modification-of-content-models Describes how to extend taxonomy Accounting Entries Data Model Palette Model ISO PC295 CD proposing design with parallel XBRL GL Proposing XML Schema I defined simple parallel xml schema containing all elements and types used by XBRL GL. Difference between original taxonomy and this xml schema files is followings; This xml schema doesn’t use XBRL instance data but defined ADCS instance datatype. Using substitutionGroup to support field name of ADCS. Using <key> and <keyref>, we […]

2017-10-09
XML Schema validation

Views: 87 Contents XML Schema Design for Audit Data Collection XML schema validation XML schema design patterns Chinese backgroundGB/T 24589.2

2017-10-06
ISO 21378 data types and transformation

Views: 86以下は、ISO PC 295 WG1会議（2017年5月）にて発表した資料です。修正が必要な箇所もありますが、基本方針はこれで良いと考えています。残念ながらデータ型の議論を深めることができませんでした。 ORACLE Character String Datatypes in ORACLE NUMBER Datatype in ORACLE The NUMBER datatype stores fixed and floating-point numbers. Numbers of virtually any magnitude can be stored and are guaranteed portable among different systems operating Oracle Database, up to 38 digits of precision. Numbers can be stored in a NUMBER column: Positive numbers in the range 1 x 10-130 to 9.99…9 x 10125 with up to 38 significant digits Negative numbers from -1 x 10-130 to 9.99…99 x 10125 with up to 38 significant digits Zero Positive and negative infinity (generated only by importing from an Oracle Database, Version 5) If a precision is not specified, […]

2017-05-03
XBRL GL instance viewing service[Prototype](3/3)

Views: 114Viewing XBRL GL instance by period and/or account number Three steps （１）A browser side javascript program calls PHP program at server side to process request based on period and/or account number passed with an arguments of jQuery’s ajax. （２）A PHP program generate a query based on arguments and generate <table> then returns generated page to the browser. （３）A web browser displays a result from the server.

2013-10-13
XBRL GL instance viewing service[Prototype](2/3)

Views: 115Store XBRL GL instance documents in database In order to calculate summary for period and/or account numbers, we store contents of XBRL GL instance documents. In this case, we use PostgreSQL database after processed by PHP’s XML DOM functions.

2013-10-13
XBRL GL Instance Viewing Service [Prototype](1/3)

Views: 162XBRL GL Instance Viewing Service These are prototype services for viewing XBRL GL instance documents generated by accounting softwares. (You can find source programs at the GitHub site..) 1. iphix sample(XBRL 2.1) http://www.sambuichi.jp/xbrlgl/index.html Original file location http://gl.iphix.net/files.htm 2. PCA (XBRL 2.0a) 2.1 View of document structure of XBRL GL instance for each entry http://www.sambuichi.jp/xbrlgl/pca.html 2.2 View of journal entry by entered slip http://www.sambuichi.jp/xbrlgl/journal_entry.html 2.3 View of summary by month and/or chart of accounts. These documents are stored in database. http://www.sambuichi.jp/xbrlgl/list.html

2013-10-13