--- 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: false - propertyName: "account.code.objectOneDigitLevel" label: "Object One Digit Level" ascending: true controlBreak: true pageBreak: false - propertyName: "account.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: false pageBreak: false - propertyName: "date" label: "Date" ascending: true controlBreak: false pageBreak: false - propertyName: "checkNumber" label: "Check #" ascending: true controlBreak: false pageBreak: false - propertyName: "receiptNumber" label: "Receipt #" ascending: true controlBreak: false pageBreak: false - propertyName: "poNumber" label: "PO #" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Financial Detail Report" querySpecification: specification: "date.ge param(\"startDate\",\"f\",\"Start Date\")\ndate.le param(\"\ endDate\",\"l\",\"End Date\")\ncashAccount.fullAccountCode.oneOf ([param(\"\ includeCashAccts\",'',\"Include Cash Account(s) i.e 000-0000\")])\naccount.fullAccountCode.oneOf\ \ ([param(\"includeAccts\",'',\"Include Full Account Code(s)\")])\naccount.fullAccountCode.notOneOf\ \ ([param(\"excludeAccts\",'',\"Exclude Full Account Code(s)\")])\naccount.code.fund.like\ \ param(\"includeFund\",\"\",\"Include Fund\")\naccount.code.func.like param(\"\ includeFunc\",\"\",\"Include Func\")\naccount.code.receipt.like param(\"includeRcpt\"\ ,\"\",\"Include Rcpt\")\naccount.code.object.like param(\"includeObj\",\"\"\ ,\"Include Obj\")\naccount.code.scc.like param(\"includeSCC\",\"\",\"Include\ \ SCC\")\naccount.code.subject.like param(\"includeSubj\",\"\",\"Include Subj\"\ )\naccount.code.opu.like param(\"includeOpu\",\"\",\"Include Opu\")\naccount.code.il.like\ \ param(\"includeIL\",\"\",\"Include IL\")\naccount.code.job.like param(\"includeJob\"\ ,\"\",\"Include Job\")\ntype.oneOf (['PO','Disb','Ref','Rec','Payroll','TA_In','TA_Out','Dist'])\n\ account.filter.eq param(\"Filter Name\",\"\")" 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: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Cash Account" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "cashAccount" columnOrder: 1 suppressRepeating: false permission: null - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: null entityName: "ActivityLedger" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: "" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "date" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 2 suppressRepeating: false permission: null - ! description: "Check #" type: "java.lang.Integer" propertyName: "checkNumber" propertyPath: null entityName: "ActivityLedger" sortOrder: 5 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "Check #" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "checkNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false permission: null - ! description: "Receipt #" type: "java.lang.Integer" propertyName: "receiptNumber" propertyPath: null entityName: "ActivityLedger" sortOrder: 5 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "Receipt #" columnTitle: "Receipt #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "receiptNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false permission: null - ! description: "PO #" type: "java.lang.Integer" propertyName: "poNumber" propertyPath: null entityName: "ActivityLedger" sortOrder: 5 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "PO #" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "poNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! description: "Item Description" type: "java.lang.String" propertyName: "itemDescription" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 30 relativePropertyName: "itemDescription" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "account" entityName: "Account" sortOrder: 3 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 33 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 7 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: 8 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: 9 suppressRepeating: false permission: null - ! description: "Remaining Encumbrance" type: "java.math.BigDecimal" propertyName: "remainingEncumbrance" propertyPath: null entityName: "ActivityLedger" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Remaining Encumbrance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "remainingEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Fund" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.fund" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 11 suppressRepeating: false permission: null - ! description: "Func" type: "java.lang.String" propertyName: "func" propertyPath: "account.code" entityName: "AppropriationCode" sortOrder: 0 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.code.func" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 12 suppressRepeating: false permission: null - ! description: "Function One Digit Level" type: "java.lang.String" propertyName: "functionOneDigitLevel" propertyPath: "account.code" entityName: "AppropriationCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Function One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.functionOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 13 suppressRepeating: false permission: null - ! description: "Function Two Digit Level" type: "java.lang.String" propertyName: "functionTwoDigitLevel" propertyPath: "account.code" entityName: "AppropriationCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Function Two Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.functionTwoDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 14 suppressRepeating: false permission: null - ! description: "Receipt" type: "java.lang.String" propertyName: "receipt" propertyPath: "account.code" entityName: "AnticipatedRevenueCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Receipt" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.receipt" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 15 suppressRepeating: false permission: null - ! description: "Receipt One Digit Level" type: "java.lang.String" propertyName: "receiptOneDigitLevel" propertyPath: "account.code" entityName: "AnticipatedRevenueCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Receipt One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.receiptOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 16 suppressRepeating: false permission: null - ! description: "Receipt Two Digit Level" type: "java.lang.String" propertyName: "receiptTwoDigitLevel" propertyPath: "account.code" entityName: "AnticipatedRevenueCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Receipt Two Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.receiptTwoDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 17 suppressRepeating: false permission: null - ! description: "Object" type: "java.lang.String" propertyName: "object" propertyPath: "account.code" entityName: "AppropriationCode" sortOrder: 0 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: "account.code.object" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 18 suppressRepeating: false permission: null - ! description: "Object One Digit Level" type: "java.lang.String" propertyName: "objectOneDigitLevel" propertyPath: "account.code" entityName: "AppropriationCode" sortOrder: 2 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: 0 relativePropertyName: "account.code.objectOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 19 suppressRepeating: false permission: null - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "SCC" columnTitle: "SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.scc" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 20 suppressRepeating: false permission: null - ! description: "Subject" type: "java.lang.String" propertyName: "subject" propertyPath: "account.code" entityName: "AnticipatedRevenueCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Subject" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.subject" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 21 suppressRepeating: false permission: null - ! description: "Subject Two Digit Level" type: "java.lang.String" propertyName: "subjectTwoDigitLevel" propertyPath: "account.code" entityName: "AnticipatedRevenueCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Subject Two Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.subjectTwoDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 22 suppressRepeating: false permission: null - ! description: "Opu" type: "java.lang.String" propertyName: "opu" propertyPath: "account.code" entityName: "AnticipatedRevenueCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Opu" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.opu" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 23 suppressRepeating: false permission: null - ! description: "Opu One Digit Level" type: "java.lang.String" propertyName: "opuOneDigitLevel" propertyPath: "account.code" entityName: "AnticipatedRevenueCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Opu One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.opuOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 24 suppressRepeating: false permission: null - ! description: "Job" type: "java.lang.String" propertyName: "job" propertyPath: "account.code" entityName: "AppropriationCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Job" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.job" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 25 suppressRepeating: false permission: null - ! description: "IL" type: "java.lang.String" propertyName: "il" propertyPath: "account.code" entityName: "AppropriationCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "IL" columnTitle: "IL" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.il" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 26 suppressRepeating: false permission: null - ! description: "Forecast Line#" type: "java.lang.String" propertyName: "forecastLineNumber" propertyPath: "account.ODELineNumber" entityName: "ODELineNumber" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Forecast Line#" columnTitle: "Forecast Line#" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.ODELineNumber.forecastLineNumber" dataSourcePath: path: ! [] currentPath: ! - "account" - "ODELineNumber" columnOrder: 27 suppressRepeating: false permission: null