--- reportDefinition: ! description: "ExpenditureAccount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Appropriated vs. Spent/Encumbered" suppressDetail: false showOptions: false queryParameters: ! {} title: "Appropriated vs. Spent/Encumbered" querySpecification: specification: "cashAccount.fullAccountCode.oneOf ([param(\"cashaccount.fullAccountCode\"\ ,'',\"Include Full Account Code (i.e. 001-0000)\")])\ncode.fund.like param(\"\ includecode.fund\",\"\",\"Include Fund (use % for wildcard)\")\ncode.scc.like\ \ param(\"includecode.scc\",\"\",\"Include SCC (use % for wildcard)\")\nactive.oneOf\ \ ([param(\"active\",'',\"Active only? (true/false)\")])" 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: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "METHOD" label: null columnTitle: "Cash Account" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 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: 2 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "budget.FYTDExpendable" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: true - ! 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "budget.FYTDExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: true - ! 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "budget.currentEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: true - ! 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "budget.FYTDUnencumbered" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: true