Engine B published their industry standard Common Data Model v1.1 on GitHub in the JSON format. Here is how Engine B explains their CDM.
I took the liberty to convert that JSON to XBRL, created several instances for testing purposes, and did a bunch of other stuff. You can have a look at what I put together here.
Amoung other things, note that I took the Microsoft Dynamics Sample Company (The World Online), loaded that onto an SQL Server, mapped the Dynamics tables to the CDM, and then generated XBRL instances for all of that data. You can download and have a look. This is what the SQL looks like: (first you see the Dynamics table, then you see the alias created which is the CDM field)
SELECT dbo_RM00101.CUSTNMBR AS customerId, dbo_RM00101.CUSTNAME AS name, dbo_RM00101.CUSTCLAS AS customerType, dbo_RM00101.ADDRESS1 AS addressStreetName, dbo_RM00101.CITY AS addressCity, dbo_RM00101.STATE AS addressRegion, dbo_RM00101.ZIP AS addressPostalCode, dbo_RM00101.COUNTRY AS addressCountry, dbo_RM00101.PHONE1 AS telephone, dbo_RM00101.FAX AS fax, dbo_RM00101.TAXSCHID AS taxType, dbo_RM00101.USERDEF1 AS customerGroup, dbo_RM00101.MODIFDT AS systemModifiedDateTime FROM dbo_RM00101;
It is really that easy. This stuff is going to be so great when computational professional services is all up and working! "Always on" audits!!!
Might want to consider brushing up on your computational thinking.
############################