if (window.isc == undefined || window.isc.DataSource == undefined){  alert("Can't load DataSources - SmartClient runtime not loaded");}isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"3d44f5d61a213d0393f251258badfe8a",
    ID:"prefeituras",
    fields:[
        {
            title:"Nome",
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            type:"text",
            editorType:"ComboBoxItem"
        },
        {
            title:"Codigo",
            hidden:true,
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer",
            required:true
        },
        {
            title:"Site",
            hidden:true,
            columnCode:"98defd6ee70dfb1dea416cecdf391f58",
            name:"site",
            type:"text"
        },
        {
            title:"Estado",
            hidden:true,
            columnCode:"3b070dcca931ef68a6c64b12968ac505",
            name:"estado",
            type:"integer"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"972350d545a9ba587f1ff0774e0dc336",
    ID:"orgaos",
    operationBinding:{
        operationId:"fullFetch",
        operationType:"fetch",
        serverObject:{
            className:"net.techdesk.audespSRC.server.TabelaOrgao",
            methodName:"fetchOrgao"
        }
    },
    fields:[
        {
            title:"Nome",
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            type:"text",
            editorType:"ComboBoxItem"
        },
        {
            title:"Cidade",
            hidden:true,
            columnCode:"0c25ff47c030162d31c91c9f45af496a",
            primaryKey:true,
            name:"cod_cidade",
            type:"integer",
            required:true,
            foreignKey:"prefeituras.codigo"
        },
        {
            title:"Codigo",
            hidden:true,
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer",
            required:true
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"9532e127bdaca77298d64ff47d6cfa84",
    ID:"classificacaoReceita_DS",
    dataSourceVersion:1,
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:255,
            type:"text"
        },
        {
            columnCode:"6b2e27d819e3f0395f2996cc9800ed0d",
            name:"especificacao",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql",
    generatedBy:"v8.2p_2012-10-24/EVAL Deployment 2012-10-24"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"fea3e426c994a3670f86ac48de660d60",
    ID:"codigoAplicacao_DS",
    dataSourceVersion:1,
    fields:[
        {
            columnCode:"cdbbe176df51097ab2a70fa0561a4b5e",
            primaryKey:true,
            name:"codigoFico",
            type:"integer"
        },
        {
            columnCode:"9bd11f498ac5c6addadac150494c2b3b",
            name:"codigoVariavel",
            length:5,
            type:"text"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:255,
            type:"text"
        },
        {
            columnCode:"6b2e27d819e3f0395f2996cc9800ed0d",
            name:"especificacao",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql",
    generatedBy:"v8.2p_2012-10-24/EVAL Deployment 2012-10-24"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"25f7d13f6599b62ac83f3d96dcade4fd",
    ID:"codigoTipoReceita_DS",
    dataSourceVersion:1,
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:255,
            type:"text"
        },
        {
            columnCode:"6b2e27d819e3f0395f2996cc9800ed0d",
            name:"especificacao",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql",
    generatedBy:"v8.2p_2012-10-24/EVAL Deployment 2012-10-24"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"c21a7a7c12904d3661cd2a9fa666bb29",
    ID:"codigoFonteRecurso_DS",
    dataSourceVersion:1,
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:16777215,
            type:"text"
        },
        {
            columnCode:"6b2e27d819e3f0395f2996cc9800ed0d",
            name:"especificacao",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql",
    generatedBy:"v8.2p_2012-10-24/EVAL Deployment 2012-10-24"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    addGlobalId:true,
    serverType:"sql",
    generatedBy:"v8.2p_2012-10-24/EVAL Deployment 2012-10-24",
    tableCode:"ed10be847f1c3d396954480a1c66f763",
    ID:"detalheReceita_DS",
    dataSourceVersion:1,
    fields:[
        {
            hidden:true,
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"8c8b086e4a46727c25421a476133dd2d",
            name:"prefeitura",
            type:"integer",
            foreignKey:"prefeituras.codigo"
        },
        {
            hidden:true,
            columnCode:"05bd4a38b7b08476cd18ce1ab63eb3a3",
            name:"orgao",
            type:"integer",
            foreignKey:"orgaos.codigo"
        },
        {
            hidden:true,
            columnCode:"f55b4da91567efda6c004b0ac77d380c",
            name:"fonteRecurso",
            type:"integer",
            foreignKey:"codigoFonteRecurso_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"41fc38105c0e27507201dee05e1e2fde",
            name:"recurso",
            length:16777215,
            type:"text",
            canEdit:"false"
        },
        {
            columnCode:"f1262c55b692a7f8c9ee0ff0aba8dbbe",
            name:"aplicacaoFixo",
            type:"integer",
            foreignKey:"codigoAplicacao_DS.codigoFico"
        },
        {
            hidden:true,
            columnCode:"754bc376a94894fbc98f925af62cf73f",
            name:"aplic",
            length:255,
            type:"text",
            canEdit:"false"
        },
        {
            columnCode:"490782d014e2c746374b761bfa7484be",
            name:"subCategoria",
            type:"integer",
            foreignKey:"codigoTipoReceita_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"eff143ca2a28323510c0e27a9117afac",
            name:"subCat",
            length:255,
            type:"text",
            canEdit:"false"
        },
        {
            columnCode:"d4ad10396e237d785e66d4f947bd2b3f",
            name:"fonte",
            type:"integer"
        },
        {
            columnCode:"93d9295d2a2fca808a870f09d10cc71f",
            name:"rubrica",
            type:"integer"
        },
        {
            columnCode:"229e5a743bc2e3bfff9eef79753189c8",
            name:"alinea",
            type:"integer",
            foreignKey:"classificacaoReceita_DS.codigo"
        },
        {
            columnCode:"6000848a4d39631b6eff43c529fede4d",
            name:"classificacao",
            length:255,
            type:"text",
            canEdit:"false"
        },
        {
            columnCode:"5a807bc52e7448346abf2e075c7f5794",
            name:"arrecadacao",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"bde9dee6f523d6476dcca9cae8caa5f5",
            name:"ano",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"d2db8a610f8c7c0785d2d92a6e8c450e",
            name:"mes",
            type:"integer"
        }
    ]
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"5fd4e382474ededd4fb1b66ef1cd2c6e",
    ID:"funcaoGoverno_DS",
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"abb6372dfdf7cd453cd347b1dc257c9e",
    ID:"fornecedorCredor_DS",
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"401281b092fd5f950813ba41a39cee7d",
            name:"tipo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"a2146a1fbd6871fff8849e5c82de0972",
    ID:"subFuncaoGoverno_DS",
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"de400bac1176e449937384fb2146464a",
    ID:"classificacaoDespesa_DS",
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:255,
            type:"text"
        },
        {
            columnCode:"6b2e27d819e3f0395f2996cc9800ed0d",
            name:"especificacao",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"f1596288a8138a1d73f4f40427a7af6f",
    ID:"detalheDespesa_DS",
    addGlobalId:true,
    fields:[
        {
            hidden:true,
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"f55b4da91567efda6c004b0ac77d380c",
            name:"fonterecurso",
            type:"integer",
            foreignKey:"codigoFonteRecurso_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"5fd4e382474ededd4fb1b66ef1cd2c6e",
            name:"funcaogoverno",
            type:"integer",
            foreignKey:"funcaoGoverno_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"a2146a1fbd6871fff8849e5c82de0972",
            name:"subfuncaogoverno",
            type:"integer",
            foreignKey:"subFuncaoGoverno_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"af07e46299656b47b88f1164e50eacb5",
            name:"elemento",
            type:"integer",
            foreignKey:"classificacaoDespesa_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"8c8b086e4a46727c25421a476133dd2d",
            name:"prefeitura",
            type:"integer",
            foreignKey:"prefeituras.codigo"
        },
        {
            hidden:true,
            columnCode:"05bd4a38b7b08476cd18ce1ab63eb3a3",
            name:"orgao",
            type:"integer",
            foreignKey:"orgaos.codigo"
        },
        {
            columnCode:"f1262c55b692a7f8c9ee0ff0aba8dbbe",
            name:"aplicacaofixo",
            type:"integer",
            foreignKey:"codigoAplicacao_DS.codigoFico"
        },
        {
            columnCode:"aa18a8ca28c4fb203dbf140786d113d6",
            name:"modalidadelicitatoria",
            type:"integer",
            foreignKey:"modalidadeLicitatoria_DS.codigo"
        },
        {
            columnCode:"e75ce226b868f209548b7f398757322f",
            name:"cnpjcpf",
            type:"integer",
            foreignKey:"fornecedorCredor_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"c2485bc197cd5c0599ea7c7cd95428ed",
            name:"tipodespesa",
            type:"integer"
        },
        {
            columnCode:"fb5b0722c0f353a12e29ba43e18c5fff",
            name:"noempenho",
            type:"text"
        },
        {
            columnCode:"1f3051f41d505febfb42c63910a849c9",
            name:"valorempenhado",
            type:"float"
        },
        {
            columnCode:"5f280ec383b4ba88308dd92f3ac27250",
            name:"programa",
            type:"text"
        },
        {
            columnCode:"70cc5d876fc7748c80b780a582c26527",
            name:"acao",
            type:"text"
        },
        {
            columnCode:"e8dea8de71c5c357c2cc3c6fd3c6f7f0",
            name:"historico",
            type:"text"
        },
        {
            hidden:true,
            columnCode:"bde9dee6f523d6476dcca9cae8caa5f5",
            name:"ano",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"d2db8a610f8c7c0785d2d92a6e8c450e",
            name:"mes",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"465b1f70b50166b6d05397fca8d600b0",
            name:"dia",
            type:"integer"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"9de32cdb8f112329df254e5c5625be3c",
    ID:"modalidadeLicitatoria_DS",
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"666ac576aa2666cff323f5d976d592a6",
            name:"nome",
            length:65535,
            type:"text"
        },
        {
            columnCode:"6b2e27d819e3f0395f2996cc9800ed0d",
            name:"especificacao",
            length:65535,
            type:"text"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"69234a5b4ef255e0fea0e913b2c154c1",
    ID:"logXMLImport_DS",
    fields:[
        {
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            columnCode:"8c8b086e4a46727c25421a476133dd2d",
            name:"prefeitura",
            type:"integer"
        },
        {
            columnCode:"05bd4a38b7b08476cd18ce1ab63eb3a3",
            name:"orgao",
            type:"integer"
        },
        {
            columnCode:"bde9dee6f523d6476dcca9cae8caa5f5",
            name:"ano",
            type:"integer"
        },
        {
            columnCode:"d2db8a610f8c7c0785d2d92a6e8c450e",
            name:"mes",
            type:"integer"
        },
        {
            columnCode:"9acb44549b41563697bb490144ec6258",
            name:"status",
            type:"enum"
        },
        {
            columnCode:"7e4ed04097f97d52ee75caa7e48e1762",
            name:"operacao",
            type:"enum"
        },
        {
            columnCode:"5fc732311905cb27e82d67f4f6511f7f",
            name:"date",
            type:"timestamp"
        },
        {
            columnCode:"c03eccd91936a86f68fdc6403b666036",
            name:"totregsok",
            type:"integer"
        },
        {
            columnCode:"1b2ea9d3289f57aa5f114c4e79422ee4",
            name:"totregsfail",
            type:"integer"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    tableCode:"85ceb61802f5e09ec105a620b74f2763",
    ID:"balancoAnual_DS",
    fields:[
        {
            hidden:true,
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"8c8b086e4a46727c25421a476133dd2d",
            name:"prefeitura",
            type:"integer",
            foreignKey:"prefeituras.codigo"
        },
        {
            hidden:true,
            columnCode:"05bd4a38b7b08476cd18ce1ab63eb3a3",
            name:"orgao",
            type:"integer",
            foreignKey:"orgaos.codigo"
        },
        {
            title:"Nome",
            columnCode:"05bd4a38b7b08476cd18ce1ab63eb3a3",
            name:"Orgao",
            type:"text",
            canEdit:"false",
            editorType:"ComboBoxItem"
        },
        {
            hidden:true,
            columnCode:"bde9dee6f523d6476dcca9cae8caa5f5",
            name:"ano",
            type:"integer"
        },
        {
            valueMap:{
                D:"Despesa",
                R:"Receita",
                L:"Licitacao",
                E:"Educacao"
            },
            hidden:true,
            columnCode:"401281b092fd5f950813ba41a39cee7d",
            name:"tipo",
            type:"enum"
        },
        {
            title:"Jan",
            columnCode:"c4fec9b62e971aeb25cb6d7b77d6faf6",
            name:"janPln",
            type:"float"
        },
        {
            title:"Fev",
            columnCode:"6f75346e6571de65795c7d30ba3ee7c6",
            name:"fevPln",
            type:"float"
        },
        {
            title:"Mar",
            columnCode:"a1e0ab080511aca2aef8efddfe5fb090",
            name:"marPln",
            type:"float"
        },
        {
            title:"Abr",
            columnCode:"d1a7e93a150f5e22d84b8f0df4543b10",
            name:"abrPln",
            type:"float"
        },
        {
            title:"Mai",
            columnCode:"70ea6ab75b26f93417ccca4310695ab3",
            name:"maiPln",
            type:"float"
        },
        {
            title:"Jun",
            columnCode:"4e214551100966bcd4079eaca2b1da18",
            name:"junPln",
            type:"float"
        },
        {
            title:"Jul",
            columnCode:"7ce5433b161767d2fff5e10d34fb777b",
            name:"julPln",
            type:"float"
        },
        {
            title:"Ago",
            columnCode:"47e8a99f1500752ad015477d17a39505",
            name:"agoPln",
            type:"float"
        },
        {
            title:"Set",
            columnCode:"d89ee3440b00ebc812a6a4769084a4bf",
            name:"setPln",
            type:"float"
        },
        {
            title:"Out",
            columnCode:"b2cd9bab6ab7d960d31062a8aa464a40",
            name:"outPln",
            type:"float"
        },
        {
            title:"Nov",
            columnCode:"d55a8220f364389d359973ee5ff99a46",
            name:"novPln",
            type:"float"
        },
        {
            title:"Dez",
            columnCode:"acf6b630de9e61815578496fa63eaee5",
            name:"dezPln",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"5a059e1813faa5fcfc85ede93542b3d4",
            name:"janReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"55db1772cd7a84dec144d4a75a8abcf1",
            name:"fevReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"3624eb73b6cf8bd95d40121f6193f68b",
            name:"marReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"b6e1045d60692ac478a02c14b297c627",
            name:"abrReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"bf481e76d58fc4a7307d8d90320410c1",
            name:"maiReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"0490588c19d8004290f8cd3b3ab9e01a",
            name:"junReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"2c19bf4f9944f8c8cf65ead994047919",
            name:"julReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"dd584efd4a35ca3cae867c9a1b3e02bc",
            name:"agoReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"a3c95b2f86d14145bb31aead8d1653cc",
            name:"setReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"ab9a0a42a4c8df6013d66218c0eeffbc",
            name:"outReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"140ad41afea649cf7d34be8640343530",
            name:"novReal",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"017bd26aea659a61f3e11519e555e385",
            name:"dezReal",
            type:"float"
        }
    ],
    serverType:"sql"
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    dropExtraFields:false,
    addGlobalId:true,
    serverType:"sql",
    tableCode:"ed10be847f1c3d396954480a1c66f763",
    ID:"treeDetalheReceita_DS",
    dataSourceVersion:1,
    fields:[
        {
            hidden:true,
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"490782d014e2c746374b761bfa7484be",
            name:"subCategoria",
            type:"integer",
            foreignKey:"codigoTipoReceita_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"229e5a743bc2e3bfff9eef79753189c8",
            name:"alinea",
            type:"integer",
            foreignKey:"classificacaoReceita_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"8c8b086e4a46727c25421a476133dd2d",
            name:"prefeitura",
            type:"integer",
            foreignKey:"prefeituras.codigo"
        },
        {
            hidden:true,
            columnCode:"05bd4a38b7b08476cd18ce1ab63eb3a3",
            name:"orgao",
            type:"integer",
            foreignKey:"orgaos.codigo"
        },
        {
            hidden:true,
            columnCode:"f55b4da91567efda6c004b0ac77d380c",
            name:"fonteRecurso",
            type:"integer",
            foreignKey:"codigoFonteRecurso_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"f1262c55b692a7f8c9ee0ff0aba8dbbe",
            name:"aplicacaoFixo",
            type:"integer",
            foreignKey:"codigoAplicacao_DS.codigoFico"
        },
        {
            columnCode:"eff143ca2a28323510c0e27a9117afac",
            name:"subCat",
            length:255,
            type:"text",
            canEdit:"false"
        },
        {
            columnCode:"b31e552786a58ecaff9efcfe53231ed3",
            name:"aln",
            length:255,
            type:"text",
            canEdit:"false"
        },
        {
            columnCode:"d4ad10396e237d785e66d4f947bd2b3f",
            name:"fonte",
            type:"integer"
        },
        {
            columnCode:"93d9295d2a2fca808a870f09d10cc71f",
            name:"rubrica",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"41fc38105c0e27507201dee05e1e2fde",
            name:"recurso",
            length:16777215,
            type:"text",
            canEdit:"false"
        },
        {
            hidden:true,
            columnCode:"754bc376a94894fbc98f925af62cf73f",
            name:"aplic",
            length:255,
            type:"text",
            canEdit:"false"
        },
        {
            columnCode:"5a807bc52e7448346abf2e075c7f5794",
            name:"arrecadacao",
            type:"float"
        },
        {
            hidden:true,
            columnCode:"bde9dee6f523d6476dcca9cae8caa5f5",
            name:"ano",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"d2db8a610f8c7c0785d2d92a6e8c450e",
            name:"mes",
            type:"integer"
        }
    ]
})
isc.DataSource.create({
    allowAdvancedCriteria:false,
    dropExtraFields:false,
    addGlobalId:true,
    serverType:"sql",
    tableCode:"f1596288a8138a1d73f4f40427a7af6f",
    ID:"treeDetalheDespesa_DS",
    fields:[
        {
            title:"Função",
            hidden:true,
            columnCode:"41ef894026a8cd4da247105a6036db70",
            primaryKey:true,
            name:"codigo",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"5fd4e382474ededd4fb1b66ef1cd2c6e",
            name:"funcaogoverno",
            type:"integer",
            foreignKey:"funcaoGoverno_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"a2146a1fbd6871fff8849e5c82de0972",
            name:"subfuncaogoverno",
            type:"integer",
            foreignKey:"subFuncaoGoverno_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"af07e46299656b47b88f1164e50eacb5",
            name:"elemento",
            type:"integer",
            foreignKey:"classificacaoDespesa_DS.codigo"
        },
        {
            hidden:true,
            columnCode:"8c8b086e4a46727c25421a476133dd2d",
            name:"prefeitura",
            type:"integer",
            foreignKey:"prefeituras.codigo"
        },
        {
            hidden:true,
            columnCode:"05bd4a38b7b08476cd18ce1ab63eb3a3",
            name:"orgao",
            type:"integer",
            foreignKey:"orgaos.codigo"
        },
        {
            columnCode:"4987eb15d5cc1f841005d7a6758cbb0f",
            name:"afunc ",
            length:65535,
            canEdit:"false",
            type:"text"
        },
        {
            columnCode:"ec5230253a4c09766fcc8c27944313aa",
            name:"sfunc ",
            length:65535,
            canEdit:"false",
            type:"text"
        },
        {
            columnCode:"362f2145723c67c0f876b6403beb525b",
            name:"elem ",
            length:255,
            canEdit:"false",
            type:"text"
        },
        {
            columnCode:"1f3051f41d505febfb42c63910a849c9",
            name:"valorempenhado",
            type:"float"
        },
        {
            columnCode:"465b1f70b50166b6d05397fca8d600b0",
            name:"dia",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"bde9dee6f523d6476dcca9cae8caa5f5",
            name:"ano",
            type:"integer"
        },
        {
            hidden:true,
            columnCode:"d2db8a610f8c7c0785d2d92a6e8c450e",
            name:"mes",
            type:"integer"
        },
        {
            columnCode:"e75ce226b868f209548b7f398757322f",
            name:"cnpjcpf",
            type:"integer",
            foreignKey:"fornecedorCredor_DS.codigo"
        },
        {
            columnCode:"da6ad35dd2706b772d4c061c947be714",
            name:"fornec ",
            length:65535,
            canEdit:"false",
            type:"text"
        }
    ]
})