schema.json

{
 
  "tableSchemas": [
    {
      "id": "tblnZRGd8tRwGJroB",
      "name": "Loans",
      "primaryColumnId": "fldtJsuK3wJaxP3cn",
      "columns": [
        {
          "id": "fldtJsuK3wJaxP3cn",
          "name": "Loan #",
          "type": "autoNumber",
          "description": "test 2",
          "typeOptions": {
            "maxUsedAutoNumber": 1
          }
        },
        {
          "id": "fldA9bk5y6BXsjAVg",
          "name": "Loan Amount",
          "type": "number",
          "typeOptions": {
            "format": "currency",
            "precision": 0,
            "symbol": "$",
            "negative": false,
            "validatorName": "positive"
          }
        },
        {
          "id": "fld4KEJAJEuFy3rfd",
          "name": "Payment Interval Rate",
          "type": "formula",
          "typeOptions": {
            "format": "decimal",
            "precision": 5,
            "formulaTextParsed": "{column_value_fld5CDmGgzRjIhB2h} / \\n100 / \\n{column_value_fldGA9Tfg9IEcumCe}\\n\\n",
            "dependencies": {
              "referencedColumnIdsForValue": [
                "fld5CDmGgzRjIhB2h",
                "fldGA9Tfg9IEcumCe"
              ]
            },
            "resultType": "number",
            "resultIsArray": false
          }
        },
        {
          "id": "fld7fteBd8MEpIPO9",
          "name": "PMT",
          "type": "formula",
          "typeOptions": {
            "format": "currency",
            "precision": 2,
            "symbol": "$",
            "formulaTextParsed": "-({column_value_fldA9bk5y6BXsjAVg} * (({column_value_fld4KEJAJEuFy3rfd} * POWER(1+{column_value_fld4KEJAJEuFy3rfd},{column_value_fldXLi4pbZTy5YZ96}))/(POWER(1+{column_value_fld4KEJAJEuFy3rfd},{column_value_fldXLi4pbZTy5YZ96})-1)))",
            "dependencies": {
              "referencedColumnIdsForValue": [
                "fldA9bk5y6BXsjAVg",
                "fld4KEJAJEuFy3rfd",
                "fldXLi4pbZTy5YZ96"
              ]
            },
            "resultType": "number",
            "resultIsArray": false
          }
        },
        {
          "id": "fld5CDmGgzRjIhB2h",
          "name": "Annual Rate",
          "type": "number",
          "typeOptions": {
            "format": "percent",
            "precision": 3,
            "negative": false,
            "validatorName": "positive"
          }
        },
        {
          "id": "fldjmfubq6kgohLzF",
          "name": "Payment Number",
          "type": "number",
          "typeOptions": {
            "format": "integer",
            "negative": false,
            "validatorName": "positive"
          }
        },
        {
          "id": "fld8bakSjOk31VXem",
          "name": "FV",
          "type": "formula",
          "typeOptions": {
            "format": "currency",
            "precision": 2,
            "symbol": "$",
            "formulaTextParsed": "-({column_value_fld7fteBd8MEpIPO9}*(POWER((1+{column_value_fld4KEJAJEuFy3rfd}),{column_value_fldjmfubq6kgohLzF})-1)/{column_value_fld4KEJAJEuFy3rfd}+{column_value_fldA9bk5y6BXsjAVg}*POWER(1+{column_value_fld4KEJAJEuFy3rfd},{column_value_fldjmfubq6kgohLzF}))",
            "dependencies": {
              "referencedColumnIdsForValue": [
                "fld7fteBd8MEpIPO9",
                "fld4KEJAJEuFy3rfd",
                "fldjmfubq6kgohLzF",
                "fldA9bk5y6BXsjAVg"
              ]
            },
            "resultType": "number",
            "resultIsArray": false
          }
        },
        {
          "id": "fld3mB3IiqLmYW9lU",
          "name": "PPMT",
          "type": "formula",
          "typeOptions": {
            "format": "currency",
            "precision": 2,
            "symbol": "$",
            "formulaTextParsed": "{column_value_fld7fteBd8MEpIPO9}-({column_value_fld8bakSjOk31VXem}*{column_value_fld4KEJAJEuFy3rfd})",
            "dependencies": {
              "referencedColumnIdsForValue": [
                "fld7fteBd8MEpIPO9",
                "fld8bakSjOk31VXem",
                "fld4KEJAJEuFy3rfd"
              ]
            },
            "resultType": "number",
            "resultIsArray": false
          }
        },
        {
          "id": "fldGA9Tfg9IEcumCe",
          "name": "Payments Per Year",
          "type": "number",
          "default": 12,
          "typeOptions": {
            "format": "integer",
            "negative": false,
            "validatorName": "positive"
          }
        },
        {
          "id": "fldi8E85pbZfNZZsr",
          "name": "Terms (yrs)",
          "type": "number",
          "default": 30,
          "typeOptions": {
            "format": "integer",
            "negative": false,
            "validatorName": "positive"
          }
        },
        {
          "id": "fldXLi4pbZTy5YZ96",
          "name": "Total Terms",
          "type": "formula",
          "typeOptions": {
            "formulaTextParsed": "{column_value_fldi8E85pbZfNZZsr}*{column_value_fldGA9Tfg9IEcumCe}",
            "dependencies": {
              "referencedColumnIdsForValue": [
                "fldi8E85pbZfNZZsr",
                "fldGA9Tfg9IEcumCe"
              ]
            },
            "resultType": "number",
            "resultIsArray": false
          }
        },
        {
          "id": "fldwOrY9swQpvpMUa",
          "name": "Terminal Value",
          "type": "number",
          "default": 0,
          "typeOptions": {
            "symbol": "$",
            "format": "currency",
            "precision": 0,
            "negative": false,
            "validatorName": "positive"
          }
        },
        {
          "id": "fldddor7fHHUkB5nX",
          "name": "IPMV",
          "type": "formula",
          "typeOptions": {
            "format": "currency",
            "precision": 2,
            "symbol": "$",
            "formulaTextParsed": "column_value_fld8bakSjOk31VXem*{column_value_fld4KEJAJEuFy3rfd}",
            "dependencies": {
              "referencedColumnIdsForValue": [
                "fld8bakSjOk31VXem",
                "fld4KEJAJEuFy3rfd"
              ]
            },
            "resultType": "number",
            "resultIsArray": false
          }
        }
      ]
    }
  ]
}