--- reportDefinition: ! description: "Subtotal by Object first digit. Can be used with Account filter. Option\ \ to exclude accounts with all zero amounts" tags: "Reports Group" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Budget Summary by Object" suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "Budget Summary by Object" querySpecification: specification: "active.eq 'true'\nfilter.eq param(\"filter\",\"\",\"Filter\")\n\ allAmountsZero.oneOf ([param(\"allAmountsZero\",'',\"Include Accounts with all\ \ Zeros? (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: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 suppressRepeating: false - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "budget" entityName: "BudgetBase" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Fund-SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "budget.fullAccountCode" 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "budget.FYTDAppropriated" dataSourcePath: path: ! [] currentPath: ! [] 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "budget.priorYearEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "budget.FYTDExpendable" dataSourcePath: path: ! [] currentPath: ! [] 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "budget.FYTDExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "budget.MTDExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "budget.currentEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 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: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "budget.FYTDUnencumbered" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 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: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 9 relativePropertyName: "percentExpendedEncumbered" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false - ! description: "Object" type: "java.lang.String" propertyName: "object" propertyPath: "budget.appropriation.code" entityName: "AppropriationCode" sortOrder: 2 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Object Group" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "budget.appropriation.code.object" dataSourcePath: path: ! [] currentPath: ! - "budget" - "appropriation" - "code" columnOrder: 11 suppressRepeating: false - ! description: "Object" type: "java.lang.String" propertyName: "object" propertyPath: "code" entityName: "ExpenditureCode" sortOrder: 3 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Object" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.object" dataSourcePath: path: ! [] currentPath: ! - "code" columnOrder: 12 suppressRepeating: false