--- reportDefinition: ! description: "Disbursement Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Disbursement Summary by Check Type" suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "Disbursement Summary by Check Type" querySpecification: specification: "type.oneOf ([param(\"type\",'',\"Type(s):Accounts Payable, Refund\ \ or Payroll\")])\ndate.between param(\"startDate\",\"\",\"Transaction Start\ \ Date\"), param(\"endDate\",\"\", \"Transaction End Date\")\nbankTransaction.checkNumber.between\ \ param(\"startCheck\",\"\",\"Starting Check #\"), param(\"endCheck\",\"\",\ \ \"Ending Check #\")\nvendor.number.oneOf ([param(\"number\",'',\"Vendor #(s)\"\ )])\nvendor.defaultPaymentType.oneOf ([param(\"paymentType\",'',\"Vendor Default\ \ Payment Type(s): Check or Electronic\")])\nstatus.oneOf ([param(\"status\"\ ,'',\"Status(es): Outstanding, Reconciled or Void\")])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.disbursement.Disbursement" properties: ! - ! description: "Reference Number" type: "java.lang.Integer" propertyName: "referenceNumber" propertyPath: null entityName: "Disbursement" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NATURALID" source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "referenceNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 suppressRepeating: false - ! description: "Check Number" type: "java.lang.Integer" propertyName: "checkNumber" propertyPath: "bankTransaction" entityName: "BankTransaction" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "bankTransaction.checkNumber" dataSourcePath: path: ! [] currentPath: ! - "bankTransaction" columnOrder: 2 suppressRepeating: false - ! description: "Type" type: "org.ssdt_ohio.usas.model.constants.DisbursementType" propertyName: "type" propertyPath: null entityName: "Disbursement" sortOrder: 1 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: null entityName: "Disbursement" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 10 relativePropertyName: "date" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false - ! description: "Name" type: "java.lang.String" propertyName: "name" propertyPath: "payee" entityName: "Payee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payee.name" dataSourcePath: path: ! [] currentPath: ! - "payee" columnOrder: 5 suppressRepeating: false - ! description: "Vendor #" type: "java.lang.Integer" propertyName: "number" propertyPath: "vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "vendor.number" dataSourcePath: path: ! [] currentPath: ! - "vendor" columnOrder: 6 suppressRepeating: false - ! description: "Status" type: "org.ssdt_ohio.usas.model.constants.DisbursementStatus" propertyName: "status" propertyPath: null entityName: "Disbursement" 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: 0 relativePropertyName: "status" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false - ! description: "Reconcile Date" type: "java.util.Calendar" propertyName: "reconcileDate" propertyPath: "bankTransaction" entityName: "BankTransaction" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "bankTransaction.reconcileDate" dataSourcePath: path: ! [] currentPath: ! - "bankTransaction" columnOrder: 8 suppressRepeating: false - ! description: "Void Date" type: "java.util.Calendar" propertyName: "voidDate" propertyPath: null entityName: "Disbursement" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "voidDate" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "Disbursement" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false