1 / 27

Web Based Taxonomy Developer

Web Based Taxonomy Developer. Yong Moon Lee KICPA,AICPA. Yong Moon Lee is a member of KICPA and AICPA. He is currently CEO of IBCENTER Co. Ltd. and is acting for the IT area of KICPA as a member of Board. He is active member of XBRL Korea and representative of

jhubert
Download Presentation

Web Based Taxonomy Developer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web Based Taxonomy Developer Yong Moon Lee KICPA,AICPA

  2. Yong Moon Lee is a member of KICPA and AICPA. He is currently CEO of IBCENTER Co. Ltd. and is acting for the IT area of KICPA as a member of Board. He is active member of XBRL Korea and representative of XBRL Korea for the InternationalSteering Committee of XBRL. He has been leading the development of XBRL Taxonomy of Korea and developed web based taxonomy developer by himself. He is combining the knowledge of CPA and IT for the society of XBRL Korea. He is also a software programmer and he developed and is running ibcenter.co.kr which is a ERP site for web based Application Service. ex Audit and Consulting Manager of PWC Korea ex CFO of SAP Korea ex CFO of Yahoo Korea ex Professor of Graduate school of Industrial Technology ex Auditor of Coopers & Lybrand (Houston Office in Texas) ex CFO of ISACA Korea(as a member of CISA)

  3. Back groundComparison of Web Based Tool and Single User Mode ToolHow it works?Taxonomy generation by Web InterfaceTuple HandlingProgram source(PHP samples)Database StructureFuture INDEX

  4. Taxonomy Development Process In Korea • From July 2005, formed task force team to develop 2.1 taxonomy • Most of the Task Force Team were KICPAs. • Started to develop 4 industries taxonomies(Commercial and Industrial, • Banking,Securities,Insurance) • Draft was rolled out December 2005. • Currently Open Review Process • 5 companies has been done for preparation of XBRL Instance Documents. • Pilot Project is under way for Financial Supervisory Service. • (Fujitsu Consortium)

  5. Need of CollaborationNeed of Speed Need of Visual TaxonomyNeed of Integrity of Taxonomy Background

  6. Web vs Personal Solution

  7. System Specification

  8. How it works? cpa 1 cpa 8 cpa 7 ibcenter.co.kr cpa 2 cpa 6 cpa 3 cpa 5 cpa 4 Log in Process

  9. role grant XBRL Privilege Setting

  10. XBRL Taxonomy Element Dictionary

  11. XBRL Taxonomy Editor (Presentation and Label)

  12. XBRL Taxonomy Editor (Discussion Forum)

  13. XBRL Taxonomy Editor (Publisher)

  14. XBRL Taxonomy Editor (Excel Generated)

  15. Tuple list

  16. Tuple Ref List

  17. Publisher List

  18. Publisher/Reference List

  19. Taxonomy Create 1

  20. Taxonomy Create 2

  21. taxonomy View

  22. label excel generate

  23. Database Schema (excerpt) korean_reference_dictionary element_dictionary korean_gaap id 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 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 id parent_id weight ns element_dictionary_id element_order versionno industrycode CreateDate UpdateDate CreatorUserID UpdaterUserID DiscussionForum ColorNumber bBold korean_label_dictionary element_dictionary_id lang industrycode documentation label terseLabel totalLabel periodStartLabel periodEndLabel negativeLabel positiveLabel verboseLabel

  24. Program source sample f2echo("<?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");

  25. Future • To 100% HTML Version • (Current VB version + PHP Version) • Generalize Industry Taxonomy to expand • Validation Tool To Be Installed Inside

  26. Gracias !!!

More Related