--- reportDefinition: ! description: "RevenueAccount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Revenue Summary Report" suppressDetail: true showOptions: false sortProperties: ! [] queryParameters: ! {} title: "Revenue Summary Report" querySpecification: specification: "fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"Full Account\ \ Code (i.e. 006-1512-0000-000000-000)\")])\ncode.fund.like param(\"includecode.fund\"\ ,\"\",\"Include Fund (use % for wildcard)\")\ncode.receipt.like param(\"includecode.receipt\"\ ,\"\",\"Include Receipt (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)\")\nactive.oneOf ([param(\"active\"\ ,'',\"Active only? (true/false)\")])\nallAmountsZero.ne param(\"zeroAmounts\"\ ,\"\",\"Exclude Zero Amounts (true/false)\")\nfilter.eq param(\"Filter Name\"\ ,\"\")\nasOfPeriod.eq param(\"asOfPeriod\",\"\",\"Total As of Period (If a date\ \ is specified FYTD and MTD amounts will be calculated as of that period)\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.account.RevenueAccount" 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: "Fund-SCC" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 suppressRepeating: true - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: null entityName: "Account" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "fullAccountCode" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 2 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: 3 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "Account" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false - ! description: "FYTD Receivable" type: "java.math.BigDecimal" propertyName: "FYTDReceivable" propertyPath: "anticipatedRevenue" entityName: "AnticipatedRevenue" 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: "anticipatedRevenue.FYTDReceivable" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false - ! description: "FYTD Received" type: "java.math.BigDecimal" propertyName: "FYTDReceived" propertyPath: null entityName: "RevenueAccount" 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: "FYTDReceived" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false - ! description: "MTD Received" type: "java.math.BigDecimal" propertyName: "MTDReceived" propertyPath: null entityName: "RevenueAccount" 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: "MTDReceived" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false - ! description: "YTD Received" type: "java.math.BigDecimal" propertyName: "YTDReceived" propertyPath: null entityName: "RevenueAccount" 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: "YTDReceived" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false - ! description: "Remaining Balance" type: "java.math.BigDecimal" propertyName: "remainingBalance" propertyPath: "anticipatedRevenue" entityName: "AnticipatedRevenue" 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: "anticipatedRevenue.remainingBalance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false - ! description: "FYTD Percent Received" type: "java.math.BigDecimal" propertyName: "FYTDPercentReceived" propertyPath: null entityName: "RevenueAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "PERCENT" source: "METHOD" label: "FYTD Percent Receivable" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "FYTDPercentReceived" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false