--- reportDefinition: ! description: "ExpenditureAccount Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Budget Summary" suppressDetail: false showOptions: true queryParameters: ! {} title: "Budget Summary" querySpecification: specification: "budget.fullAccountCode.oneOf ([param(\"includeAccts\",'',\"Include\ \ Full Account Code(s)\")])\nbudget.fullAccountCode.notOneOf ([param(\"excludeAccts\"\ ,'',\"Exclude Full Account Code(s)\")])\nbudget.code.fund.like param(\"includeFund\"\ ,\"\",\"Include Fund\")\nbudget.code.func.like param(\"includeFunc\",\"\",\"\ Include Func\")\nbudget.code.scc.like param(\"includeSCC\",\"\",\"Include SCC\"\ )\nbudget.code.object.like param(\"includeObj\",\"\",\"Include Obj\")\nbudget.code.subject.like\ \ param(\"includeSubj\",\"\",\"Include Subj\")\nbudget.code.job.like param(\"\ includeJob\",\"\",\"Include Job\")\nbudget.code.opu.like param(\"includeOpu\"\ ,\"\",\"Include Opu\")\nfilter.eq param(\"filter\",\"\",\"Filter\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.account.ExpenditureAccount" properties: ! - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "budget" entityName: "BudgetBase" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Budget" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 35 relativePropertyName: "budget.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 1 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "budget" entityName: "BudgetBase" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 32 relativePropertyName: "budget.description" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 2 suppressRepeating: false - ! description: "FYTD Appropriated" type: "java.math.BigDecimal" propertyName: "FYTDAppropriated" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "FYTD Appropriated" columnTitle: "Initial Budget" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.FYTDAppropriated" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 3 suppressRepeating: false - ! description: "Prior Year Encumbrance" type: "java.math.BigDecimal" propertyName: "priorYearEncumbrance" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "" columnTitle: "Prior Year Carry Over Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.priorYearEncumbrance" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 4 suppressRepeating: false - ! description: "FYTD Expendable" type: "java.math.BigDecimal" propertyName: "FYTDExpendable" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "FYTD Expendable" columnTitle: "FYTD Expendable" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.FYTDExpendable" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 5 suppressRepeating: false - ! description: "FYTD Expended" type: "java.math.BigDecimal" propertyName: "FYTDExpended" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "FYTD Expended" columnTitle: "FYTD Actual Expenditures" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.FYTDExpended" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 6 suppressRepeating: false - ! description: "Encumbrance" type: "java.math.BigDecimal" propertyName: "currentEncumbrance" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "Encumbrance" columnTitle: "Current Encumbrance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.currentEncumbrance" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 7 suppressRepeating: false - ! description: "FYTD Additions" type: "java.math.BigDecimal" propertyName: "FYTDAdditions" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "FYTD Additions" columnTitle: "Additional Revenue" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.FYTDAdditions" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 8 suppressRepeating: false - ! description: "YTD Expended" type: "java.math.BigDecimal" propertyName: "YTDExpended" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "YTD Expended" columnTitle: "YTD Expended" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.YTDExpended" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 9 suppressRepeating: false - ! description: "Remaining Balance" type: "java.math.BigDecimal" propertyName: "remainingBalance" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "" columnTitle: "Current Budget Balance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "budget.remainingBalance" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 10 suppressRepeating: false