--- reportDefinition: ! description: "ExpenditureAccount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Budget Summary" suppressDetail: false showOptions: true sortProperties: ! - ! propertyName: "cashAccount.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: true pageBreak: true - propertyName: "cashAccount.description" label: "Description" ascending: true controlBreak: false pageBreak: false - propertyName: "budget.appropriation.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: true pageBreak: false - propertyName: "budget.appropriation.description" label: "Description" ascending: true controlBreak: false pageBreak: false - propertyName: "budget.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: false pageBreak: false - propertyName: "description" label: "Description" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Budget Summary" querySpecification: specification: "fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"Include\ \ Full Account Code (i.e. 001-1110-511-0000-000000-001-00-000)\")])\ncode.fund.like\ \ param(\"includecode.fund\",\"\",\"Include Fund (use % for wildcard)\")\ncode.func.like\ \ param(\"includecode.func\",\"\",\"Include Function (use % for wildcard)\"\ )\ncode.object.like param(\"includecode.object\",\"\",\"Include Object (use\ \ % for wildcard)\")\ncode.scc.like param(\"includecode.scc\",\"\",\"Include\ \ SCC (use % for wildcard)\")\ncode.subject.like param(\"includecode.subject\"\ ,\"\",\"Include Subject (use % for wildcard)\")\ncode.opu.like param(\"includecode.opu\"\ ,\"\",\"Include OPU (use % for wildcard)\")\ncode.il.like param(\"includecode.il\"\ ,\"\",\"Include IL (use % for wildcard)\")\ncode.job.like param(\"includecode.job\"\ ,\"\",\"Include Job (use % for wildcard)\")\nactive.oneOf ([param(\"active\"\ ,'',\"Active only? (true/false)\")])\nallAmountsZero.ne param(\"zeroAmounts\"\ ,\"\",\"Exclude Zero Amounts (true/false)\")\nasOfPeriod.eq param(\"asOfPeriod\"\ ,\"\",\"Total As of Period (If a date is specified FYTD, MTD and Encumbrance\ \ amounts will be calculated as of that period)\")\nfilter.eq param(\"Filter\ \ Name\",\"\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.account.ExpenditureAccount" properties: ! - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "cashAccount" entityName: "Account" sortOrder: 1 controlBreak: true suppressed: true pageBreak: true ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Fund-SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "cashAccount" columnOrder: 1 suppressRepeating: false - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "budget.appropriation" entityName: "BudgetBase" sortOrder: 2 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Appropriation" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "budget.appropriation.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "budget" - "appropriation" columnOrder: 2 suppressRepeating: false - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "budget" entityName: "BudgetBase" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Budget" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 32 relativePropertyName: "budget.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 3 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "cashAccount" entityName: "Account" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "cashAccount.description" dataSourcePath: path: ! [] currentPath: ! - "cashAccount" columnOrder: 4 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "Account" sortOrder: 5 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Desc." alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 40 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "budget.appropriation" 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: true controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "budget.appropriation.description" dataSourcePath: path: ! [] currentPath: ! - "budget" - "appropriation" columnOrder: 6 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: "FYTD Appropriated" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 21 relativePropertyName: "budget.FYTDAppropriated" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 7 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 Encumbrance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 21 relativePropertyName: "budget.priorYearEncumbrance" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 8 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: 21 relativePropertyName: "budget.FYTDExpendable" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 9 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: 21 relativePropertyName: "budget.FYTDExpended" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 10 suppressRepeating: false - ! description: "MTD Expended" type: "java.math.BigDecimal" propertyName: "MTDExpended" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "MTD Expended" columnTitle: "MTD Actual Expenditures" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 21 relativePropertyName: "budget.MTDExpended" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 11 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: 21 relativePropertyName: "budget.currentEncumbrance" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 12 suppressRepeating: false - ! description: "Future Encumbrance" type: "java.math.BigDecimal" propertyName: "futureEncumbrance" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "" columnTitle: "Future Encumbrance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 22 relativePropertyName: "budget.futureEncumbrance" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 13 suppressRepeating: false - ! description: "FYTD Unencumbered" type: "java.math.BigDecimal" propertyName: "FYTDUnencumbered" propertyPath: "budget" entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "FYTD Unencumbered" columnTitle: "FYTD Remaining Balance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 22 relativePropertyName: "budget.FYTDUnencumbered" dataSourcePath: path: ! [] currentPath: ! - "budget" columnOrder: 14 suppressRepeating: false - ! description: "Percent Expended/Encumbered" type: "java.math.BigDecimal" propertyName: "percentExpendedEncumbered" propertyPath: null entityName: "ExpenditureAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "PERCENT" source: "METHOD" label: "Percent Expended/Encumbered" columnTitle: "Percent Expended/Encumbered" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 14 relativePropertyName: "percentExpendedEncumbered" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 15 suppressRepeating: false