1 / 20

XBRL GL Data Definition File (DDF)

Explore the benefits of using the XBRL.GL Data Definition File (DDF) to describe and convert text files. Discover how DDF formalizes the description of text files, facilitates their conversion to XBRL.GL, and enables more standardized transfer and validation of simple text files. This solution is applicable to various scenarios, including exporting delimited files to XBRL.GL, extracting data from large databases with minimal size, and converting information from non-accounting applications.

stevenn
Download Presentation

XBRL GL Data Definition File (DDF)

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. XBRL GL Data Definition File (DDF) Providing “XBRL GL-Colored Glasses” to Common Text Formats

  2. Why DDF? • Helping more people benefit from XBRL GL • XBRL GL is more than an export format • It is a model and framework for describing data • DDF lets us extend the model to non-XBRL information • Formalizing the description of text files • There are times when describing a text file will help • Understand the text file • Facilitate the conversion of the text file to XBRL GL • Permit the more standardized transfer of simple text files • Facilitate validation of text files • V1 Focus: “CSV” (delimited) and Fixed-Length ASCII • V2 - : Binary formats (Excel, Oracle …), XML formats

  3. Scenario 1 • XYZ Company’s ERP system can create delimited files • XYZ Company wishes to provide the exported file to a third party who can receive XBRL GL • XYZ Company provides their delimited file plus a DDF file to an intermediary, who can now convert the file to XBRL GL

  4. Scenario 2 • Auditor wishes smallest possible extract from 1 TB company database • CSV = 100 MB • XBRL GL = 400 MB • Auditor also wants to know what the file represents • DDF file accompanies CSV, adds negligible size, defines content for automated testing

  5. Scenario 3 • Audit Data Standard • Providing interoperability between • Tab-delimited format, and • XBRL GL

  6. Scenario 4 • A wide variety of software products can turn formatted (“printed to disk”) reports into data • Statistical • SAS • Audit • ACL • Caseware • Generic • Monarch • AltovaFlexText • Why not make it simple to convert information from non-accounting applications? • Turns non-accounting software into accounting software!

  7. DDF Uses XBRL GL To Define Data in Other Formats • Information about batch of information • Mappings from text file “fields” to XBRL GL • Mappings from text file content to XBRL GL enumerations, where appropriate

  8. Inspired by Excel, Access, MapForce

  9. DelimitedvsFixed Length ASCII Common: Is there a header row? What format is used for dates? Delmited (a.k.a CSV): What delimiter is used between facts? What enclosure is used for text, if any? Selection by order Fixed length ASCII: Is there a fixed record length worth checking? Selection by starting position and length

  10. CSV vs Fixed-Length ASCII The number 500 is the fifth item in this record. The number 500 starts at the 72nd character and is 3 characters long

  11. Sample Process Customer_Account_ID|Customer_Account_Name|Customer_Physical_Street_Address1|Customer_Physical_Street_Address2|Customer_Physical_City|Customer_Physical_State_Province|Customer_Physical_ZipPostalCode|Customer_Physical_Country|Customer_TIN|Customer_Billing_Address1|Customer_Billing_Address2|Customer_Billing_City|Customer_Billing_State_Province|Customer_Billing_ZipPostalCode|Customer_Billing_Country|Active_Date|Inactive_Date|Transaction_Credit_Limit|Overall_Credit_Limit|Customer_Terms_Percentage|Customer_Terms_Days|Last_Modified_Date|Last_Modified_By|User_ID|Approved_By|Entry_Date|PrimaryContact_Name|PrimaryContact_Phone|PrimaryContactEmail AAA|Arnold's Amazing Anteaters|100 Pastoral Lane||Akron|OH|12345|USA|16-4876544|100 Pastoral Lane||Akron|OH|12345|USA|Jan-01-2001||50000|100000|0.02|10|||ABC|EEC|Jan-01-2001|Arnold Aultfather|+1-616-234-9090|aa@arnoldsamazing.com It is a delimited file, with the pipe (|) delimeter There is a header row The first field is Customer_Account_ID

  12. Sample DDF Content <?xml version="1.0" encoding="UTF-8"?> <ddf:xbrl-gl …> <ddf:documentInfo> <ddf:fileType>delimited</ddf:fileType> <ddf:delimeter>|</ddf:delimeter> <ddf:firstLineHeader>true</ddf:firstLineHeader> </ddf:documentInfo> <ddf:entryMaps> <ddf:entryMap> <ddf:xbrlElement>gl-cor:identifierCode</ddf:xbrlElement> <ddf:fieldName>Customer_Account_ID</ddf:fieldName> <ddf:additionalConstraint>…</ddf:additionalConstraint> <ddf:csvInfo> <ddf:order>1</ddf:order> </ddf:csvInfo> </ddf:entryMap> …

  13. DDF XML Schema

  14. Vendor Support - Iphix Demonstration

  15. Vendor Support - XWand

  16. Vendor Support - XWand (Cont.) 1. Setup

  17. Vendor Support – XWand (Cont.) 2. Select DDF, source (text) data

  18. Vendor Support – XWand (Cont.) 3. Reap XBRL GL

  19. Possible Additional Uses • Description and documentation • Conversion • Storing meta-mappings • Use as source to AltovaMapForce for creating MapForce Mappings – “command-line” map creation

  20. Questions?

More Related