--- reportDefinition: ! description: "ReceiptItem Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Receipts Ledger Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "receipt.number" label: "Receipt #" ascending: true controlBreak: true pageBreak: false - propertyName: "lineNumber" label: "Line Number" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Receipts Ledger Report" querySpecification: specification: "receipt.date.between param(\"startDate\",\"p\",\"Transaction Start\ \ Date\"), param(\"endDate\",\"d\", \"Transaction End Date\")\naccount.cashAccount.code.fund.oneOf\ \ ([param(\"fundCode\",'',\"Include Fund(s):\")])\ntype.oneOf (['RC','RX'])\n\ account.filter.eq param(\"Filter Name\",\"\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.receipt.ReceiptItem" properties: ! - ! description: "Receipt #" type: "java.lang.Integer" propertyName: "number" propertyPath: "receipt" entityName: "Receipt" sortOrder: 1 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "Receipt #" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "receipt.number" dataSourcePath: path: ! [] currentPath: ! - "receipt" columnOrder: 1 suppressRepeating: false - ! description: "Line Number" type: "java.lang.Integer" propertyName: "lineNumber" propertyPath: null entityName: "ReceiptItem" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NATURALID" source: "FIELD" label: null columnTitle: "Line #" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "lineNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 2 suppressRepeating: false - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "receipt" entityName: "Receipt" sortOrder: 3 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: "receipt.date" dataSourcePath: path: ! [] currentPath: ! - "receipt" columnOrder: 3 suppressRepeating: false - ! description: "Type" type: "org.ssdt_ohio.usas.model.constants.ReceiptItemType" propertyName: "type" propertyPath: null entityName: "ReceiptItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "ReceiptItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 35 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "account" entityName: "Account" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: null alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 6 suppressRepeating: false - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "ReceiptItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "account.cashAccount" entityName: "Account" sortOrder: 0 controlBreak: false 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: "account.cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" - "cashAccount" columnOrder: 8 suppressRepeating: true - ! 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: 9 suppressRepeating: false - ! 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: 10 suppressRepeating: false - ! 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: 11 suppressRepeating: false - ! 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: 12 suppressRepeating: false - ! 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: 13 suppressRepeating: false - ! 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: 14 suppressRepeating: false - ! 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: 15 suppressRepeating: false - ! 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: 16 suppressRepeating: false - ! 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: 17 suppressRepeating: false