Forums Ignite UI for jQuery
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Dusan Grujic
135
Error parsing the JSON data and applying the defined data schema
posted

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
    }
  ]
}

Parents
  • 10240
    posted

    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

     

    igHierarchicalGrid_parseError.zip
Reply Children
No Data