--- reportDefinition: ! description: "ActivityLedger Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Financial Detail Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "cashAccount.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: true pageBreak: true - propertyName: "account.budget.appropriation.code.objectOneDigitLevel" label: "Object One Digit Level" ascending: true controlBreak: true pageBreak: false queryParameters: ! {} title: "Financial Detail Report" querySpecification: specification: "date.ge param(\"startDate\",\"\",\"Start Date\")\ndate.le param(\"\ endDate\",\"\",\"End Date\")\ncashAccount.fullAccountCode.oneOf ([param(\"includeCashAccts\"\ ,'',\"Include Cash Account(s) i.e 000-0000\")])\naccount.code.func.like param(\"\ includeFunc\",\"\",\"Include Func\")\naccount.code.fund.oneOf ([param(\"includecode.fund\"\ ,'',\"Include Fund (s)\")])\naccount.code.object.like param(\"includeObj\",\"\ \",\"Include Obj\")\naccount.code.scc.like param(\"includeSCC\",\"\",\"Include\ \ SCC\")\ntype.oneOf (['Disb','Ref','Rec','Payroll','TA_In','TA_Out','Dist'])\n\ account.filter.eq param(\"filter\",\"\",\"Filter\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.generalLedger.ActivityLedger" 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: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "cashAccount" columnOrder: 1 suppressRepeating: false - ! 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: 2 suppressRepeating: false - ! description: "Object One Digit Level" type: "java.lang.String" propertyName: "objectOneDigitLevel" propertyPath: "account.budget.appropriation.code" entityName: "AppropriationCode" sortOrder: 2 controlBreak: true suppressed: false 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: 0 relativePropertyName: "account.budget.appropriation.code.objectOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "budget" - "appropriation" - "code" columnOrder: 3 suppressRepeating: false - ! 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: "Received Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "receivedAmount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false