{"id":2859,"date":"2017-10-09T17:28:49","date_gmt":"2017-10-09T08:28:49","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=2859"},"modified":"2019-11-20T08:23:31","modified_gmt":"2019-11-19T23:23:31","slug":"xml-schema-designfor-audit-data-collection","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=2859&lang=en","title":{"rendered":"XML schema design for the audit data collection"},"content":{"rendered":"

Views: 86<\/p>\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Data Verification Requirements<\/h2>\r\n

UNIQUENESS<\/h3>\r\n

The code must be a unique indication for the {Table_Name}. XML Schema <key><\/p>\r\n

REFERENCE<\/h3>\r\n

Must match the {Field_Name} in the {Table_Name} table.\u00a0 XML Schema <keyref><\/p>\r\n

FORMAT<\/h3>\r\n

Representation requirements<\/p>\r\n

Data type definition with <restriction> <pattern><\/p>\r\n

CONDITIONAL OPTION<\/h3>\r\n

FIELDS MAY BE OMITTED IF DETAILED (LINE ITEM) DATA IS PROVIDED<\/p>\r\n

MULTI PURPOSE FIELDs<\/h3>\r\n

Business_Segment_X<\/h4>\r\n

Reserved field that can be used for business segments \/ structures.\u00a0 One number for each unique reference level.<\/p>\r\n

Subsidiary_Item_X<\/h4>\r\n

Reserved field that can be used for supplementary information associated with particular account.<\/p>\r\n

Table 32\u00a0\u2014GL Standard Data Profiling Report<\/b><\/h2>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

ISO PC295 WD4 initial design<\/strong><\/h2>\r\n\r\n\r\n\r\n

XML Schema for GL module<\/h3>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Brief introduction to XBRL GL<\/strong><\/h2>\r\n\r\n\r\n\r\n

XBRL GL provides a set of Common Accounting Vocabulary <\/h3>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n

Palette Design<\/h3>\r\n

XBRL GL Taxonomy Framework Technical Architecture 2015<\/p>\r\n

http:\/\/www.xbrl.org\/int\/gl\/2015-03-25\/GLTFTA-REC-2015-03-25.html#section-control-over-the-modification-of-content-models<\/a><\/p>\r\n

Describes how to extend taxonomy<\/p>\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Accounting Entries Data Model <\/h3>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Palette Model<\/h3>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

ISO PC295 CD proposing design with parallel XBRL GL<\/strong><\/h2>\r\n\r\n\r\n\r\n

Proposing XML Schema<\/h3>\r\n\r\n\r\n\r\n

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;<\/p>\r\n

    \r\n
  1. This xml schema doesn\u2019t use XBRL instance data but defined ADCS instance datatype.<\/li>\r\n
  2. Using substitutionGroup to support field name of ADCS.<\/li>\r\n
  3. Using <key> and <keyref>, we can check uniqueness of data based on unique id and can validate dependent data existing.<\/li>\r\n
  4. Can extend based on xbrl GL framework.<\/li>\r\n<\/ol>\r\n

    You can find XML schemas for test, which is simple xml schema and parallel to XBRL GL.<\/p>\r\n

    Files<\/p>\r\n