XBRL Integration Server-Side Documentation
API doc:
Taxonomy
1. Retrieve XBRL Taxonomy List
/mixtaxonomy
GET
Response Body
[
{"id":1, "name":"Assets", "namespace":"ifrs", "dimension":"gender:female", "description":"xxx"},
{"id":2, "name":"Income", "namespace":"ifrs", "dimension":"duration:lessthanoneyear", "description":"xxx"},
{"id":3, "name":"Expenses", "namespace":"ifrs", "description":"xxx"}
]
2. Retrieve Taxonomy Mapping
/mixmapping
GET
Response Body
{
"identifier":''00000", //MIX identifier
"config":"{ "1": "{1001}+{1002}"}"
//"currency":"USD"
}
3. Update XBRL Taxonomy Mapping
/mixmapping
POST
Request Body
{
"identifier":''00000", //MIX identifier
"config":"{ "1": "{1001}+{1002}"}"
//"currency":"USD"
}
Response
{ "resourceId" : 1}
XBRL Reporting
1. Run an XBRL Report
/mixreport?startDate=2010-07-10&endDate=2013-07-07¤cy=USD
GET
Response: xml
<?xml version="1.0" encoding="utf-8"?>
<xbrl xmlns="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xbrldi="http://xbrl.org/2006/xbrldi" xmlns:ifrs="http://xbrl.iasb.org/taxonomy/2010-04-30/ifrs" xmlns:iso4217="http://www.xbrl.org/2003/iso4217" xmlns:mix="http://www.themix.org/int/fr/ifrs/basi/2010-08-31/mx-cor" xmlns:xbrli="http://www.xbrl.org/2003/instance" xmlns:dc-all="http://www.themix.org/int/fr/ifrs/basi/2010-08-31/dc-all">
<link:schemaRef xlink:type="simple" xlink:href="http://www.themix.org/sites/default/files/Taxonomy2010/dct/dc-all_2010-08-31.xsd" />
<!--Context Section-->
<context id="As_Of_9_30_201111">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:GenderDimension">mix:FemaleMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_201110">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:LocationDimension">mix:RuralMember</xbrldi:explicitMember>
<xbrldi:explicitMember dimension="mix:ProductsCreditDimension">mix:MicroenterpriseMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20119">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:DelinquencyDimension">mix:OneMonthOrMoreMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20118">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:DelinquencyDimension">mix:MoreThanThreeMonthsMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20117">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:ProductsDepositsDimension">mix:VoluntaryDepositsMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20116">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:LocationDimension">mix:UrbanMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20115">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:LocationDimension">mix:RuralMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20114">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:ProductsDepositsDimension">mix:CompulsoryDepositsMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20113">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:MaturityDimension">mix:OneYearOrMoreMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_20112">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
<scenario>
<xbrldi:explicitMember dimension="mix:MaturityDimension">mix:LessThanOneYearMember</xbrldi:explicitMember>
</scenario>
</context>
<context id="As_Of_9_30_2011">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<instant>2011-09-30</instant>
</period>
</context>
<context id="Duration_10_1_2010_To_9_30_2011">
<entity>
<identifier scheme="http://www.themix.org">0000000</identifier>
</entity>
<period>
<startDate>2010-10-01</startDate>
<endDate>2011-09-30</endDate>
</period>
</context>
<!--Unit Section-->
<unit id="Unit13">
<measure>xbrli:pure</measure>
</unit>
<unit id="Unit12">
<measure>iso4217:AFN</measure>
</unit>
<unit id="Unit1">
<measure>iso4217:USD</measure>
</unit>
<!--Tuple Section-->
<!--Element Section-->
<ifrs:AdministrativeExpense contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">1000</ifrs:AdministrativeExpense>
<ifrs:Assets contextRef="As_Of_9_30_2011" unitRef="Unit1" decimals="0">3000</ifrs:Assets>
<ifrs:Assets contextRef="As_Of_9_30_20112" unitRef="Unit1" decimals="0">2500</ifrs:Assets>
<ifrs:Assets contextRef="As_Of_9_30_20113" unitRef="Unit1" decimals="0">2500</ifrs:Assets>
<ifrs:CashAndCashEquivalents contextRef="As_Of_9_30_2011" unitRef="Unit1" decimals="0">3000</ifrs:CashAndCashEquivalents>
<ifrs:EmployeeBenefitsExpense contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">2500</ifrs:EmployeeBenefitsExpense>
<ifrs:Equity contextRef="As_Of_9_30_2011" unitRef="Unit1" decimals="0">10000</ifrs:Equity>
<ifrs:Liabilities contextRef="As_Of_9_30_2011" unitRef="Unit1" decimals="0">10000</ifrs:Liabilities>
<ifrs:Liabilities contextRef="As_Of_9_30_20112" unitRef="Unit1" decimals="0">2500</ifrs:Liabilities>
<ifrs:Liabilities contextRef="As_Of_9_30_20113" unitRef="Unit1" decimals="0">7500</ifrs:Liabilities>
<mix:Deposits contextRef="As_Of_9_30_2011" unitRef="Unit1" decimals="0">10000</mix:Deposits>
<mix:Deposits contextRef="As_Of_9_30_20114" unitRef="Unit1" decimals="0">1000</mix:Deposits>
<mix:Deposits contextRef="As_Of_9_30_20112" unitRef="Unit1" decimals="0">2500</mix:Deposits>
<mix:Deposits contextRef="As_Of_9_30_20113" unitRef="Unit1" decimals="0">7500</mix:Deposits>
<mix:Deposits contextRef="As_Of_9_30_20115" unitRef="Unit1" decimals="0">5000</mix:Deposits>
<mix:Deposits contextRef="As_Of_9_30_20116" unitRef="Unit1" decimals="0">5000</mix:Deposits>
<mix:Deposits contextRef="As_Of_9_30_20117" unitRef="Unit1" decimals="0">9000</mix:Deposits>
<mix:Expense contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">3500</mix:Expense>
<mix:FinancialExpense contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">-2000</mix:FinancialExpense>
<mix:FinancialRevenueOnLoans contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">5000</mix:FinancialRevenueOnLoans>
<mix:ImpairmentLossAllowanceGrossLoanPortfolio contextRef="As_Of_9_30_2011" unitRef="Unit1" decimals="0">-1000</mix:ImpairmentLossAllowanceGrossLoanPortfolio>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_2011" unitRef="Unit1" decimals="0">50000</mix:LoanPortfolioGross>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_20112" unitRef="Unit12" decimals="0">1000</mix:LoanPortfolioGross>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_20118" unitRef="Unit12" decimals="0">400</mix:LoanPortfolioGross>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_20119" unitRef="Unit12" decimals="0">500</mix:LoanPortfolioGross>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_20113" unitRef="Unit12" decimals="0">9000</mix:LoanPortfolioGross>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_20115" unitRef="Unit12" decimals="0">5000</mix:LoanPortfolioGross>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_20116" unitRef="Unit12" decimals="0">5000</mix:LoanPortfolioGross>
<mix:LoanPortfolioGross contextRef="As_Of_9_30_201110" unitRef="Unit1" decimals="0">10000</mix:LoanPortfolioGross>
<mix:NetLoanLoss contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">-1000</mix:NetLoanLoss>
<mix:NetLoanLossProvisionExpense contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">-1000</mix:NetLoanLossProvisionExpense>
<mix:NetOperatingIncome contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">5000</mix:NetOperatingIncome>
<mix:NetOperatingIncomeNetOfTaxExpense contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit1" decimals="0">6500</mix:NetOperatingIncomeNetOfTaxExpense>
<mix:NumberOfActiveBorrowers contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">20</mix:NumberOfActiveBorrowers>
<mix:NumberOfActiveBorrowers contextRef="As_Of_9_30_201111" unitRef="Unit13" decimals="0">10</mix:NumberOfActiveBorrowers>
<mix:NumberOfBoardMembers contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">10</mix:NumberOfBoardMembers>
<mix:NumberOfDepositAccounts contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">50</mix:NumberOfDepositAccounts>
<mix:NumberOfDepositors contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">50</mix:NumberOfDepositors>
<mix:NumberOfEmployees contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">10</mix:NumberOfEmployees>
<mix:NumberOfEmployees contextRef="As_Of_9_30_201111" unitRef="Unit13" decimals="0">7</mix:NumberOfEmployees>
<mix:NumberOfLoanOfficers contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">3</mix:NumberOfLoanOfficers>
<mix:NumberOfLoanOfficers contextRef="As_Of_9_30_201111" unitRef="Unit13" decimals="0">3</mix:NumberOfLoanOfficers>
<mix:NumberOfManagers contextRef="As_Of_9_30_201111" unitRef="Unit13" decimals="0">3</mix:NumberOfManagers>
<mix:NumberOfOffices contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">2</mix:NumberOfOffices>
<mix:NumberOfOutstandingLoans contextRef="As_Of_9_30_2011" unitRef="Unit13" decimals="0">50</mix:NumberOfOutstandingLoans>
<mix:OperatingExpense contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit12" decimals="0">10000</mix:OperatingExpense>
<mix:OperatingIncome contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit12" decimals="0">1000</mix:OperatingIncome>
<mix:WriteOffsOnGrossLoanPortfolio contextRef="Duration_10_1_2010_To_9_30_2011" unitRef="Unit12" decimals="0">500</mix:WriteOffsOnGrossLoanPortfolio>
</xbrl>
Server-Side Data Storing
new databases:
m_taxonomy: Store a list of required taxonomy
m_taxonomy_mapping: Store the mapping of taxonomy and items of Chart of Account
m_xbrl_report: Store the xbrl generation information
| Table | Field | Type | Properties | Description |
| mix_taxonomy | id | int | key | |
| name | varchar | |||
| namespace | varchar | |||
| dimension | varchar | |||
| unit | int | |||
| descrption | varchar | |||
| mix_taxonomy_mapping | id | int | key | |
| taxonomyId | int | |||
| mapping | varchar | |||
| update_date | datetime | |||
| mix_xbrl_report | id | int | key | |
| generate_date | datetime | Used to locate the xml file | ||
| mix_xbrl_namespace | id | |||
| prefix | ||||
| url |
XBRL file will be stored in .xml file, named as XBRL_dd_MM_yyyy_mm_ss.
Default Taxonomy Mapping and Calculation
Validation
Crossfire