Visits: 726
Data Verification Requirements
UNIQUENESS
The code must be a unique indication for the {Table_Name}. XML Schema <key>
REFERENCE
Must match the {Field_Name} in the {Table_Name} table. XML Schema <keyref>
FORMAT
Representation requirements
Data type definition with <restriction> <pattern>
CONDITIONAL OPTION
FIELDS MAY BE OMITTED IF DETAILED (LINE ITEM) DATA IS PROVIDED
MULTI PURPOSE FIELDs
Business_Segment_X
Reserved field that can be used for business segments / structures. One number for each unique reference level.
Subsidiary_Item_X
Reserved field that can be used for supplementary information associated with particular account.
Table 32 —GL Standard Data Profiling Report
ISO 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
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 can check uniqueness of data based on unique id and can validate dependent data existing.
- Can extend based on xbrl GL framework.
You can find XML schemas for test, which is simple xml schema and parallel to XBRL GL.
Files
- ADCS instance schema which is parallel schema adcs-instance-2017-12-31.xsd
- XBRL GL parallel schema adcs-xbrlgl-2017-12-31.xsd
- ADCS element schema adcs-elements-2017-12-31.xsd
- ADCS module schema adcs-module-2017-12-31.xsd
- ADCS instance XML document sample-instance.xml This xml instance document is created from ADCS module schema.
1~5 files are created with PHP and validated with Java. Please check 5. instance document first.
Why do we use these xml schema set?
Using these schema, we can generate 2 kinds of instance documents.
a) xml instance documents with Table names and Field names corresponding to ADCS
b) XBRL GL instance documents for specific table
Can verify uniqueness, references, and representation patterns.
adcs-module-2017-12-31.xsd
urn:iso:std:iso:21378:tech:xs:adcs
adcs-elements-2017-12-31.xsd
urn:iso:std:iso:21378:tech:xs:adcs
adcs-xbrlgl-2017-12-31.xsd
urn:iso:std:iso:21378:tech:xs:adcs-xbrlgl
NOT xbrli:stringItemType
adcsi: vs xbrli:
ADCS XML instance
Brief introduction to XBRL GL Schema
XBRL instance schema
http://www.xbrl.org/2003/instance
XBRL GL Schema
XBRL GL Instance
ids/BP_TrialBalance.xml
