--- reportDefinition: ! description: "ActivityLedger Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Monthly Finsum for PCR's" suppressDetail: true showOptions: false sortProperties: ! - ! propertyName: "account.budget.code.fund" label: "Fund" ascending: true controlBreak: true pageBreak: false - propertyName: "account.budget.code.scc" label: "SCC" ascending: true controlBreak: true pageBreak: false - propertyName: "cashAccount.currentFundBalance" label: "Fund Balance" ascending: true controlBreak: false pageBreak: false - propertyName: "account.budget.code.func" label: "Func" ascending: true controlBreak: false pageBreak: false - propertyName: "account.budget.code.objectOneDigitLevel" label: "Object One Digit Level" ascending: true controlBreak: true pageBreak: false queryParameters: ! {} title: "Monthly Finsum for PCR's" querySpecification: specification: "date.ge param(\"startDate\",\"p\",\"Start Date\")\ndate.le param(\"\ endtDate\",\"d\",\"End Date\")\naccount.code.fund.like param(\"includeFund\"\ ,\"\",\"Include Fund\")\naccount.code.scc.like param(\"includeSCC\",\"\",\"\ Include SCC\")\naccount.filter.eq param(\"Filter Name\",\"\")\ncashAccount.active.oneOf\ \ ([param(\"active\",'',\"Active only? (true/false)\")])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.generalLedger.ActivityLedger" properties: ! - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "account.budget.code" entityName: "AccountCode" sortOrder: 1 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Fund" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 5 relativePropertyName: "account.budget.code.fund" dataSourcePath: path: ! [] currentPath: ! - "account" - "budget" - "code" columnOrder: 1 suppressRepeating: false permission: null - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: "account.budget.code" entityName: "AccountCode" sortOrder: 2 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "SCC" columnTitle: "SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "account.budget.code.scc" dataSourcePath: path: ! [] currentPath: ! - "account" - "budget" - "code" columnOrder: 2 suppressRepeating: false permission: null - ! description: "Func" type: "java.lang.String" propertyName: "func" propertyPath: "account.budget.code" entityName: "BudgetCode" sortOrder: 3 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Func" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.budget.code.func" dataSourcePath: path: ! [] currentPath: ! - "account" - "budget" - "code" columnOrder: 3 suppressRepeating: false permission: null - ! description: "Object One Digit Level" type: "java.lang.String" propertyName: "objectOneDigitLevel" propertyPath: "account.budget.code" entityName: "BudgetCode" sortOrder: 3 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Object One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "account.budget.code.objectOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "budget" - "code" columnOrder: 4 suppressRepeating: false permission: null - ! description: "Expended Amount" type: "java.math.BigDecimal" propertyName: "expendedAmount" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expendedAmount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! description: "Received Amount" type: "java.math.BigDecimal" propertyName: "receivedAmount" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "receivedAmount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! description: "Fund Balance" type: "java.math.BigDecimal" propertyName: "currentFundBalance" propertyPath: "cashAccount" entityName: "CashAccount" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "Fund Balance" columnTitle: "End Balance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: true detailHeaderOnly: false width: 0 relativePropertyName: "cashAccount.currentFundBalance" dataSourcePath: path: ! [] currentPath: ! - "cashAccount" columnOrder: 7 suppressRepeating: false permission: null