web based taxonomy developer yong moon lee kicpa,aicpa
TRANSCRIPT
![Page 1: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/1.jpg)
![Page 2: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/2.jpg)
Web Based Taxonomy Developer
Yong Moon LeeKICPA,AICPA
![Page 3: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/3.jpg)
Back ground
Comparison of Web Based Tool
and Single User Mode Tool
How it works?
Taxonomy generation by Web Interface
Tuple Handling
Program source(PHP samples)
Database Structure
Future
INDEX
![Page 4: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/4.jpg)
Need of CollaborationNeed of Speed Need of Visual TaxonomyNeed of Integrity of Taxonomy
Background
![Page 5: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/5.jpg)
Web vs Personal SolutionWeb Based Tool Personal S/W
Multi User Enviornment
Any Place
Any Time
Central Database
Can Download Excel
Speedy generation
Single User Mode
Restricted Location
Can not work together
at the same time
Personal Database
Excel Upload
![Page 6: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/6.jpg)
System Specification
User Interface
Visual Basic 6.0 PHP(Internet Explore)
DatabaseMySQL
Protocol TCP/IP
XML
TCP/IP
![Page 7: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/7.jpg)
How it works?
cpa 7
ibcenter.co.krcpa 2
cpa 1
cpa 3
cpa 8
cpa 6
cpa 4
cpa 5
Log in Process
![Page 8: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/8.jpg)
role grant
XBRLPrivilegeSetting
![Page 9: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/9.jpg)
XBRLTaxonomyElementDictionary
![Page 10: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/10.jpg)
XBRLTaxonomyEditor(Presentationand Label)
![Page 11: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/11.jpg)
XBRLTaxonomyEditor(DiscussionForum)
![Page 12: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/12.jpg)
XBRLTaxonomyEditor(Publisher)
![Page 13: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/13.jpg)
XBRLTaxonomyEditor(Excel Generated)
![Page 14: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/14.jpg)
Tuple list
![Page 15: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/15.jpg)
Tuple Ref List
![Page 16: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/16.jpg)
PublisherList
![Page 17: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/17.jpg)
Publisher/Reference List
![Page 18: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/18.jpg)
TaxonomyCreate 1
![Page 19: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/19.jpg)
TaxonomyCreate 2
![Page 20: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/20.jpg)
taxonomy View
![Page 21: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/21.jpg)
label excel generate
![Page 22: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/22.jpg)
Database Schema (excerpt)
id element_name
nation versionno
industrycode type
substitutionGroup abstract nillable balance
restriction_attribute_name restriction_attribute_use restriction_attribute_type
sequence_maxOccurs sequence_minOccurs
CreateDate UpdateDate CreatorUserID UpdaterUserID original_nation
element_dictionary
id parent_id weight ns
element_dictionary_idelement_order versionno
industrycode CreateDate UpdateDate CreatorUserID UpdaterUserID
DiscussionForum ColorNumber
bBold
korean_gaap
element_dictionary_id lang
industrycode documentation
label terseLabel totalLabel
periodStartLabel periodEndLabel negativeLabel positiveLabel verboseLabel
korean_label_dictionaryid
element_dictionary_id ref_publisher_id ref_Number
ref_Paragraph ref_order
ref_Chapter ref_Clause ref_IssueDate ref_Name ref_Section
ref_Subparagraph ref_URI
ref_URIDate
korean_reference_dictionary
![Page 23: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/23.jpg)
Program source samplef2echo("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n");f2echo("<schema elementFormDefault=\"qualified\"
xmlns:link=\"http://www.xbrl.org/2003/linkbase\"xmlns:xlink=\"http://www.w3.org/1999/xlink\" xmlns=\"http://www.w3.org/2001/XMLSchema\" targetNamespace=\"" . $mTargetNameSpace . "\" attributeFormDefault=\"unqualified\" xmlns:xbrli=\"http://www.xbrl.org/2003/instance\" xmlns:" . $mNameSpaceID . "=\"" . $mTargetNameSpace . "\">\r\n");
f2echo("<annotation>\r\n");f2echo("<appinfo>\r\n");if($IndustryCode=="pte"){
f2echo(GetElemLinkbaseRef($mNameSpaceID,"Label"));f2echo(GetElemLinkbaseRef($mNameSpaceID,"Reference"));
}elseif($IndustryCode=="ptr"){}elseif($IndustryCode=="fste"){
f2echo(GetElemLinkbaseRef($mNameSpaceID,"Label"));f2echo(GetElemLinkbaseRef($mNameSpaceID,"Reference"));
}elseif($IndustryCode=="fstr"){}elseif($IndustryCode=="ci" || $IndustryCode=="basi" || $IndustryCode=="ins" || $IndustryCode=="im"){
echo_roleType("BalanceSheet","Balance Sheet","link:presentationLink","link:calculationLink");echo_roleType("IncomeStatement","Income Statement","link:presentationLink","link:calculationLink");echo_roleType("StatementCashFlowsIndirect","Cash Flow Operations Indirect","link:presentationLink","link:calculationLink");echo_roleType("StatementAppropriationRetainedEarningsDispositionAccumulatedDeficit",
"Statement Appropriation Retained Earnings Disposition Accumulated Deficit","link:presentationLink","link:calculationLink");echo_roleType("NotesFinancialStatements","NotesFinancialStatements","link:presentationLink","link:calculationLink");f2echo(GetElemLinkbaseRef($mNameSpaceID,"Presentation"));f2echo(GetElemLinkbaseRef($mNameSpaceID,"Calculation"));
}f2echo("</appinfo>\r\n");f2echo("</annotation>\r\n");
![Page 24: Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA](https://reader035.vdocuments.us/reader035/viewer/2022062516/56649e555503460f94b4cd91/html5/thumbnails/24.jpg)
Future
• To 100% HTML Version
(Current VB version + PHP Version)
• Generalize Industry Taxonomy to expand
• Validation Tool To Be Installed Inside