{"id":2108,"date":"2017-10-09T17:28:49","date_gmt":"2017-10-09T08:28:49","guid":{"rendered":"http:\/\/www.sambuichi.jp\/?p=2108"},"modified":"2019-10-12T09:42:07","modified_gmt":"2019-10-12T00:42:07","slug":"xml-schema-designfor-audit-data-collection","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=2108","title":{"rendered":"ADC\u306eXML\u30b9\u30ad\u30fc\u30de\u8a2d\u8a08"},"content":{"rendered":"

Views: 45<\/p>\n

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

Data Verification Requirements<\/h2>\n

UNIQUENESS<\/h3>\n

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

REFERENCE<\/h3>\n

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

FORMAT<\/h3>\n

Representation requirements<\/p>\n

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

CONDITIONAL OPTION<\/h3>\n

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

MULTI PURPOSE FIELDs<\/h3>\n

Business_Segment_X<\/h4>\n

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

Subsidiary_Item_X<\/h4>\n

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

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

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

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

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

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

Palette Design<\/h3>\n

XBRL GL Taxonomy Framework Technical Architecture 2015<\/p>\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>\n

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

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

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

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

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

Proposing XML Schema<\/h3>\n\n\n\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>\n

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

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

    Files<\/p>\n