Error:"There was an error parsing the JSON data and applying the defined data schema: The input data doesn't match the schema, the following field couldn't be mapped: Details"
Init grid snipet: $("#accountsigHierarchicalGrid").igHierarchicalGrid({ odata: true, initialDataBindDepth: 0, dataSource: viewAccounts.accounts, dataSourceType: "json", dataType: "json", responseDataKey: "Invoices", width: "auto", autoGenerateColumns: false, primaryKey: "ID", columns: [ { key: "ID", headerText: "ID", dataType: "string", width: "0%", hidden: true }, { headerText: "Date", key: "TranDate", dataType: "date", width: "10%" }, { headerText: "Ref", key: "TranRef", dataType: "string", width: "10%" }, { headerText: "T Details", key: "TranDetails", dataType: "string", width: "50%" }, { headerText: "Debit ($)", key: "Debit", dataType: "number", width: "10%" }, { headerText: "Credit ($)", key: "Credit", dataType: "number", width: "10%" }, { headerText: "Balance ($)", key: "Balance", dataType: "number", width: "10%" } ],
autoGenerateLayouts: false, defaultChildrenDataProperty: "Details", columnLayouts: [ { name: "Details", key: "Details", responseDatakey: "", childrenDataProperty: "Details", autoGenerateColumns: false, primarykey: "ID", foreignkey: "ID", width: "100%", columns: [ { key: "ID", headerText: "ID", dataType: "string", width: "0%", hidden: true }, { key: "TranDate", headerText: "Date", dataType: "date", width: "10%" }, { key: "TranRef", headerText: "Ref", dataType: "string", width: "10%" }, { key: "T TranDetails", headerText: "Details", dataType: "string", width: "50%" }, { key: "Debit", headerText: "Debit ($)", dataType: "number", width: "10%" }, { key: "Credit", headerText: "Credit ($)", dataType: "number", width: "10%" }, { key: "Balance", headerText: "Balance ($)", dataType: "number", width: "10%" } ] } ] });
viewAccounts.accounts (jsonData): { "Invoices": [ { "ID": "28684|BILL023263|29/01/2013 12:00:00 AM", "Details": [ { "ID": "28684|Fee|1", "ignore": "ignore", "ForeignID": "28684|BILL023263|29/01/2013 12:00:00 AM", "TranID": 28684, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Garden-to-Kitchen Levy - Carlos", "Amount": 50.0000, "Discount": 0.0, "Outstanding": 50.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 0, "TempID": 0, "DetailID": 48829, "ItemCode": null, "ItemDescription": null, "Debit": 50.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null }, { "ID": "28684|Fee|2", "ignore": "ignore", "ForeignID": "28684|BILL023263|29/01/2013 12:00:00 AM", "TranID": 28684, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Garden-to-Kitchen Levy - Claudia", "Amount": 50.0000, "Discount": 0.0, "Outstanding": 50.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 0, "TempID": 0, "DetailID": 48830, "ItemCode": null, "ItemDescription": null, "Debit": 50.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 28684, "TranDate": "2013-01-29T00:00:00", "TranRef": "BILL023263", "TranType": "1", "TranDetails": "Garden-to-Kitchen Levy 2013, Due: 13/09/2013", "Amount": 100.0000, "Discount": 0.0, "Outstanding": 100.0000, "TranSourceID": 28684, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": 100.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "28186|BILL022765|29/01/2013 12:00:00 AM", "Details": [ { "ID": "28186|Fee|1", "ignore": "ignore", "ForeignID": "28186|BILL022765|29/01/2013 12:00:00 AM", "TranID": 28186, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2013 - Carlos", "Amount": 375.0000, "Discount": 0.0, "Outstanding": 375.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 0, "TempID": 0, "DetailID": 48078, "ItemCode": null, "ItemDescription": null, "Debit": 375.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null }, { "ID": "28186|Fee|2", "ignore": "ignore", "ForeignID": "28186|BILL022765|29/01/2013 12:00:00 AM", "TranID": 28186, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2013 - Claudia", "Amount": 375.0000, "Discount": 0.0, "Outstanding": 375.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 0, "TempID": 0, "DetailID": 48079, "ItemCode": null, "ItemDescription": null, "Debit": 375.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 28186, "TranDate": "2013-01-29T00:00:00", "TranRef": "BILL022765", "TranType": "1", "TranDetails": "Student Levy 2013, Due: 13/09/2013", "Amount": 750.0000, "Discount": 0.0, "Outstanding": 750.0000, "TranSourceID": 28186, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": 750.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "27688|BILL022267|29/01/2013 12:00:00 AM", "Details": [ { "ID": "27688|Fee|1", "ignore": "ignore", "ForeignID": "27688|BILL022267|29/01/2013 12:00:00 AM", "TranID": 27688, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Building Levy 2013", "Amount": 270.0000, "Discount": 0.0, "Outstanding": 270.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 0, "TempID": 0, "DetailID": 47580, "ItemCode": null, "ItemDescription": null, "Debit": 270.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 27688, "TranDate": "2013-01-29T00:00:00", "TranRef": "BILL022267", "TranType": "1", "TranDetails": "Building Levy 2013, Due: 13/09/2013", "Amount": 270.0000, "Discount": 0.0, "Outstanding": 270.0000, "TranSourceID": 27688, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": 270.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "27190|BILL021769|29/01/2013 12:00:00 AM", "Details": [ { "ID": "27190|Fee|1", "ignore": "ignore", "ForeignID": "27190|BILL021769|29/01/2013 12:00:00 AM", "TranID": 27190, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "School Fees 2013", "Amount": 1818.0000, "Discount": 0.0, "Outstanding": 1818.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 0, "TempID": 0, "DetailID": 47082, "ItemCode": null, "ItemDescription": null, "Debit": 1818.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 27190, "TranDate": "2013-01-29T00:00:00", "TranRef": "BILL021769", "TranType": "1", "TranDetails": "School Fees 2013, Due: 13/09/2013", "Amount": 1818.0000, "Discount": 0.0, "Outstanding": 1818.0000, "TranSourceID": 27190, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": 1818.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "29668|RCV029465|10/09/2012 10:27:43 AM", "ignore": "ignore", "TranID": 29668, "TranDate": "2012-09-10T10:27:43.78", "TranRef": "RCV029465", "TranType": "2", "TranDetails": "Cash $1,005.00", "Amount": -1005.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 29668, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 1005.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "28707|RCV028516|29/06/2012 8:40:00 AM", "ignore": "ignore", "TranID": 28707, "TranDate": "2012-06-29T08:40:00.087", "TranRef": "RCV028516", "TranType": "2", "TranDetails": "Cash $900.00", "Amount": -900.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 28707, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 900.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "27176|RCV027001|23/03/2012 8:46:58 AM", "ignore": "ignore", "TranID": 27176, "TranDate": "2012-03-23T08:46:58.137", "TranRef": "RCV027001", "TranType": "2", "TranDetails": "Cash $885.00", "Amount": -885.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 27176, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 885.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "25332|BILL020636|3/02/2012 12:00:00 AM", "Details": [ { "ID": "25332|Fee|1", "ignore": "ignore", "ForeignID": "25332|BILL020636|3/02/2012 12:00:00 AM", "TranID": 25332, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Footsteps DanceSport - Carlos", "Amount": 30.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 44467, "ItemCode": null, "ItemDescription": null, "Debit": 30.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 25332, "TranDate": "2012-02-03T00:00:00", "TranRef": "BILL020636", "TranType": "1", "TranDetails": "Footsteps Dance Sport, Due: 17/07/2012", "Amount": 30.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 25332, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 30.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "25131|BILL020435|3/02/2012 12:00:00 AM", "Details": [ { "ID": "25131|Fee|1", "ignore": "ignore", "ForeignID": "25131|BILL020435|3/02/2012 12:00:00 AM", "TranID": 25131, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Little Devils Circus Skills - Claudia", "Amount": 30.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 44250, "ItemCode": null, "ItemDescription": null, "Debit": 30.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 25131, "TranDate": "2012-02-03T00:00:00", "TranRef": "BILL020435", "TranType": "1", "TranDetails": "Little Devils Circus Skills, Due: 20/04/2012", "Amount": 30.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 25131, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 30.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "24552|BILL019856|3/02/2012 12:00:00 AM", "Details": [ { "ID": "24552|Fee|1", "ignore": "ignore", "ForeignID": "24552|BILL019856|3/02/2012 12:00:00 AM", "TranID": 24552, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2012", "Amount": 75.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 43669, "ItemCode": null, "ItemDescription": null, "Debit": 75.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 24552, "TranDate": "2012-02-03T00:00:00", "TranRef": "BILL019856", "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2012, Due: 21/09/2012", "Amount": 75.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 24552, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 75.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "24059|BILL019363|3/02/2012 12:00:00 AM", "Details": [ { "ID": "24059|Fee|1", "ignore": "ignore", "ForeignID": "24059|BILL019363|3/02/2012 12:00:00 AM", "TranID": 24059, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Building Levy 2012", "Amount": 243.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 43176, "ItemCode": null, "ItemDescription": null, "Debit": 243.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 24059, "TranDate": "2012-02-03T00:00:00", "TranRef": "BILL019363", "TranType": "1", "TranDetails": "Building Levy 2012, Due: 21/09/2012", "Amount": 243.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 24059, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 243.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "23565|BILL018869|3/02/2012 12:00:00 AM", "Details": [ { "ID": "23565|Fee|1", "ignore": "ignore", "ForeignID": "23565|BILL018869|3/02/2012 12:00:00 AM", "TranID": 23565, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2012 - Carlos", "Amount": 363.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 42440, "ItemCode": null, "ItemDescription": null, "Debit": 363.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null }, { "ID": "23565|Fee|2", "ignore": "ignore", "ForeignID": "23565|BILL018869|3/02/2012 12:00:00 AM", "TranID": 23565, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2012 - Claudia", "Amount": 363.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 42441, "ItemCode": null, "ItemDescription": null, "Debit": 363.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 23565, "TranDate": "2012-02-03T00:00:00", "TranRef": "BILL018869", "TranType": "1", "TranDetails": "Student Levy 2012, Due: 21/09/2012", "Amount": 726.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 23565, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 726.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "23072|BILL018376|3/02/2012 12:00:00 AM", "Details": [ { "ID": "23072|Fee|1", "ignore": "ignore", "ForeignID": "23072|BILL018376|3/02/2012 12:00:00 AM", "TranID": 23072, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "School Fees 2012", "Amount": 1686.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 41947, "ItemCode": null, "ItemDescription": null, "Debit": 1686.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 23072, "TranDate": "2012-02-03T00:00:00", "TranRef": "BILL018376", "TranType": "1", "TranDetails": "School Fees 2012, Due: 21/09/2012", "Amount": 1686.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 23072, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 1686.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "25258|RCV025104|23/09/2011 8:51:55 AM", "ignore": "ignore", "TranID": 25258, "TranDate": "2011-09-23T08:51:55.487", "TranRef": "RCV025104", "TranType": "2", "TranDetails": "Cash $968.00", "Amount": -968.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 25258, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 968.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "23956|RCV023821|24/06/2011 8:51:30 AM", "ignore": "ignore", "TranID": 23956, "TranDate": "2011-06-24T08:51:30.29", "TranRef": "RCV023821", "TranType": "2", "TranDetails": "Cash $864.00", "Amount": -864.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 23956, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 864.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "22902|RCV022770|7/04/2011 8:57:55 AM", "ignore": "ignore", "TranID": 22902, "TranDate": "2011-04-07T08:57:55.777", "TranRef": "RCV022770", "TranType": "2", "TranDetails": "Cash $750.00", "Amount": -750.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 22902, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 750.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "22033|BILL017960|1/02/2011 12:00:00 AM", "Details": [ { "ID": "22033|Fee|1", "ignore": "ignore", "ForeignID": "22033|BILL017960|1/02/2011 12:00:00 AM", "TranID": 22033, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Little Devils Circus Skills - Carlos", "Amount": 30.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 40139, "ItemCode": null, "ItemDescription": null, "Debit": 30.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 22033, "TranDate": "2011-02-01T00:00:00", "TranRef": "BILL017960", "TranType": "1", "TranDetails": "Little Devils Circus Skills, Due: 01/04/2011", "Amount": 30.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 22033, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 30.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "21256|BILL017185|1/02/2011 12:00:00 AM", "Details": [ { "ID": "21256|Fee|1", "ignore": "ignore", "ForeignID": "21256|BILL017185|1/02/2011 12:00:00 AM", "TranID": 21256, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2011", "Amount": 50.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 39243, "ItemCode": null, "ItemDescription": null, "Debit": 50.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 21256, "TranDate": "2011-02-01T00:00:00", "TranRef": "BILL017185", "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2011, Due: 02/12/2011", "Amount": 50.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 21256, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 50.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "20769|BILL016698|1/02/2011 12:00:00 AM", "Details": [ { "ID": "20769|Fee|1", "ignore": "ignore", "ForeignID": "20769|BILL016698|1/02/2011 12:00:00 AM", "TranID": 20769, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Building Levy 2011", "Amount": 228.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 38756, "ItemCode": null, "ItemDescription": null, "Debit": 228.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 20769, "TranDate": "2011-02-01T00:00:00", "TranRef": "BILL016698", "TranType": "1", "TranDetails": "Building Levy 2011, Due: 16/09/2011", "Amount": 228.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 20769, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 228.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "20282|BILL016211|1/02/2011 12:00:00 AM", "Details": [ { "ID": "20282|Fee|1", "ignore": "ignore", "ForeignID": "20282|BILL016211|1/02/2011 12:00:00 AM", "TranID": 20282, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2011 - Carlos", "Amount": 342.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 38043, "ItemCode": null, "ItemDescription": null, "Debit": 342.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null }, { "ID": "20282|Fee|2", "ignore": "ignore", "ForeignID": "20282|BILL016211|1/02/2011 12:00:00 AM", "TranID": 20282, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2011 - Claudia", "Amount": 342.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 38044, "ItemCode": null, "ItemDescription": null, "Debit": 342.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 20282, "TranDate": "2011-02-01T00:00:00", "TranRef": "BILL016211", "TranType": "1", "TranDetails": "Student Levy 2011, Due: 16/09/2011", "Amount": 684.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 20282, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 684.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "19795|BILL015724|1/02/2011 12:00:00 AM", "Details": [ { "ID": "19795|Fee|1", "ignore": "ignore", "ForeignID": "19795|BILL015724|1/02/2011 12:00:00 AM", "TranID": 19795, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "School Fees 2011", "Amount": 1590.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 37556, "ItemCode": null, "ItemDescription": null, "Debit": 1590.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 19795, "TranDate": "2011-02-01T00:00:00", "TranRef": "BILL015724", "TranType": "1", "TranDetails": "School Fees 2011, Due: 16/09/2011", "Amount": 1590.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 19795, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 1590.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "21198|RCV021088|20/10/2010 7:37:54 AM", "ignore": "ignore", "TranID": 21198, "TranDate": "2010-10-20T07:37:54.74", "TranRef": "RCV021088", "TranType": "2", "TranDetails": "Cash $720.00", "Amount": -720.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 21198, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 720.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "19302|RCV019205|11/05/2010 3:13:59 PM", "ignore": "ignore", "TranID": 19302, "TranDate": "2010-05-11T15:13:59.337", "TranRef": "RCV019205", "TranType": "2", "TranDetails": "Cash $670.00", "Amount": -670.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 19302, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 670.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "18607|RCV018514|19/03/2010 8:42:33 AM", "ignore": "ignore", "TranID": 18607, "TranDate": "2010-03-19T08:42:33.923", "TranRef": "RCV018514", "TranType": "2", "TranDetails": "Cash $670.00", "Amount": -670.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 18607, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 670.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "18188|BILL014881|28/01/2010 12:00:00 AM", "Details": [ { "ID": "18188|Fee|1", "ignore": "ignore", "ForeignID": "18188|BILL014881|28/01/2010 12:00:00 AM", "TranID": 18188, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2010", "Amount": 50.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 35189, "ItemCode": null, "ItemDescription": null, "Debit": 50.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 18188, "TranDate": "2010-01-28T00:00:00", "TranRef": "BILL014881", "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2010, Due: 10/09/2010", "Amount": 50.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 18188, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 50.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "17722|BILL014415|28/01/2010 12:00:00 AM", "Details": [ { "ID": "17722|Fee|1", "ignore": "ignore", "ForeignID": "17722|BILL014415|28/01/2010 12:00:00 AM", "TranID": 17722, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Building Levy 2010", "Amount": 180.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 34723, "ItemCode": null, "ItemDescription": null, "Debit": 180.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 17722, "TranDate": "2010-01-28T00:00:00", "TranRef": "BILL014415", "TranType": "1", "TranDetails": "Building Levy 2010, Due: 10/09/2010", "Amount": 180.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 17722, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 180.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "17256|BILL013949|28/01/2010 12:00:00 AM", "Details": [ { "ID": "17256|Fee|1", "ignore": "ignore", "ForeignID": "17256|BILL013949|28/01/2010 12:00:00 AM", "TranID": 17256, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2010 - Carlos", "Amount": 330.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 34033, "ItemCode": null, "ItemDescription": null, "Debit": 330.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 17256, "TranDate": "2010-01-28T00:00:00", "TranRef": "BILL013949", "TranType": "1", "TranDetails": "Student Levy 2010, Due: 10/09/2010", "Amount": 330.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 17256, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 330.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "16790|BILL013483|28/01/2010 12:00:00 AM", "Details": [ { "ID": "16790|Fee|1", "ignore": "ignore", "ForeignID": "16790|BILL013483|28/01/2010 12:00:00 AM", "TranID": 16790, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "School Fees 2010", "Amount": 1500.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 33567, "ItemCode": null, "ItemDescription": null, "Debit": 1500.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 16790, "TranDate": "2010-01-28T00:00:00", "TranRef": "BILL013483", "TranType": "1", "TranDetails": "School Fees 2010, Due: 10/09/2010", "Amount": 1500.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 16790, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 1500.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "16402|RCV016314|23/07/2009 8:50:28 AM", "ignore": "ignore", "TranID": 16402, "TranDate": "2009-07-23T08:50:28.237", "TranRef": "RCV016314", "TranType": "2", "TranDetails": "Cash $694.00", "Amount": -694.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 16402, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 694.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "15595|RCV015519|19/05/2009 8:58:01 AM", "ignore": "ignore", "TranID": 15595, "TranDate": "2009-05-19T08:58:01.92", "TranRef": "RCV015519", "TranType": "2", "TranDetails": "Cash $644.00", "Amount": -644.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 15595, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 644.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "15029|RCV014958|19/03/2009 8:51:01 AM", "ignore": "ignore", "TranID": 15029, "TranDate": "2009-03-19T08:51:01.88", "TranRef": "RCV014958", "TranType": "2", "TranDetails": "Cash $644.00", "Amount": -644.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 15029, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": 644.0000, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "15330|BILL012577|30/01/2009 12:00:00 AM", "Details": [ { "ID": "15330|Fee|1", "ignore": "ignore", "ForeignID": "15330|BILL012577|30/01/2009 12:00:00 AM", "TranID": 15330, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2009", "Amount": 50.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 31634, "ItemCode": null, "ItemDescription": null, "Debit": 50.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 15330, "TranDate": "2009-01-30T00:00:00", "TranRef": "BILL012577", "TranType": "1", "TranDetails": "Grounds Maintenance Levy 2009, Due: 11/12/2009", "Amount": 50.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 15330, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 50.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "14887|BILL012134|30/01/2009 12:00:00 AM", "Details": [ { "ID": "14887|Fee|1", "ignore": "ignore", "ForeignID": "14887|BILL012134|30/01/2009 12:00:00 AM", "TranID": 14887, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Building Levy 2009", "Amount": 165.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 31191, "ItemCode": null, "ItemDescription": null, "Debit": 165.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 14887, "TranDate": "2009-01-30T00:00:00", "TranRef": "BILL012134", "TranType": "1", "TranDetails": "Building Levy 2009, Due: 11/12/2009", "Amount": 165.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 14887, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 165.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "14444|BILL011691|30/01/2009 12:00:00 AM", "Details": [ { "ID": "14444|Fee|1", "ignore": "ignore", "ForeignID": "14444|BILL011691|30/01/2009 12:00:00 AM", "TranID": 14444, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "Student Levy 2009 - Carlos", "Amount": 312.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 30527, "ItemCode": null, "ItemDescription": null, "Debit": 312.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 14444, "TranDate": "2009-01-30T00:00:00", "TranRef": "BILL011691", "TranType": "1", "TranDetails": "Student Levy 2009, Due: 11/12/2009", "Amount": 312.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 14444, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 312.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "14001|BILL011248|30/01/2009 12:00:00 AM", "Details": [ { "ID": "14001|Fee|1", "ignore": "ignore", "ForeignID": "14001|BILL011248|30/01/2009 12:00:00 AM", "TranID": 14001, "TranDate": null, "TranRef": "Fee", "TranDate1": null, "TranType": "1", "TranDetails": "School Fees 2009", "Amount": 1455.0000, "Discount": 0.0, "Outstanding": 0.0000, "TranSourceID": 0, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 1, "Flag": 0, "Status": 2, "TempID": 0, "DetailID": 30084, "ItemCode": null, "ItemDescription": null, "Debit": 1455.0000, "Credit": null, "Balance": null, "Level": 2, "ContactID": 4, "OutstandingOnly": false, "TranIDLevel1": 0, "TranDateLevel1": null, "TranRefLevel1": null, "TranRefLevel2": null } ], "TranID": 14001, "TranDate": "2009-01-30T00:00:00", "TranRef": "BILL011248", "TranType": "1", "TranDetails": "School Fees 2009, Due: 11/12/2009", "Amount": 1455.0000, "Discount": 0.0, "Outstanding": null, "TranSourceID": 14001, "TraDetailID": null, "Color": 0, "Color1": 0, "HideExpand": 0, "Flag": 0, "Status": 2, "DetailID": 0, "Debit": 1455.0000, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false }, { "ID": "11924|RCV011872|23/04/2008 12:54:43 PM", "ignore": "ignore", "TranID": 11924, "TranDate": "2008-04-23T12:54:43.563", "TranRef": "RCV011872", "TranType": "2", "TranDetails": "Cash $100.00", "Amount": 0.0000, "Discount": 0.0000, "Outstanding": null, "TranSourceID": 11924, "TraDetailID": null, "Color": 255, "Color1": 255, "HideExpand": 0, "Flag": 0, "Status": 0, "DetailID": 0, "Debit": null, "Credit": null, "Balance": null, "ContactID": 4, "OutstandingOnly": false } ]}
Hi Dusan,
I took what you have here and folded it into a sample. For the purposes of the sample I wrapped your data in a javascript file and referenced it in. Here I was able to run your sample successfully and without the json parse error.
I attached the sample for your reference.
I am not certain though about your child row relationship with the parent row and your use of ID for both the primaryKey and foreignKey. As is the sample is unable to deliver the child rows
I am still following your post. Please let me know if you need any additional assistance on this.