Category: ISO TC295 @en
-
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 […]
-
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 […]
-
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 […]
-
GB/T 24589.2 Chinese standard audit data collect
Views: 87 Nobu’s Comments on current pattern Revised Salami Slice design by Nobu Step 1 define element for fields → Improve visibility of field structure in table Step 2 general datatype for reuse → Improve datatype visibility of field Step 3 <substitutionGroup> Evaluation XML schema and instance documents ElementsInStandard.xsd GeneralLedger.xsd ChineseLocalization.xsd 总账.xml Contents XML schema design for Audit Data Collection XML schema validation XML schema design patterns Chinese background GB/T 24589.2
-
XML Schema validation
Views: 87 Contents XML Schema Design for Audit Data Collection XML schema validation XML schema design patterns Chinese background GB/T 24589.2
-
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, […]
