--- reportDefinition: ! description: "PayeeCheck Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "PayeeCheck Report" suppressDetail: false showOptions: false queryParameters: ! {} title: "PayeeCheck Report" querySpecification: specification: "reconciledDate.between param(\"recStartDate\",\"\",\"Start Reconciled\ \ Date\"), param(\"endRecDate\",\"\",\"End Reconciled Date\")\ntransactionDate.between\ \ param(\"transStartDate\",\"\",\"Start Transaction Date\"), param(\"transEndDate\"\ ,\"\",\"End Transaction Date\")\nvoidedDate.between param(\"voidStartDate\"\ ,\"\",\"Start Void Date\"),param(\"voidEndDate\",\"\",\"End Void Date\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.paymenttransaction.PayeeCheck" properties: ! - ! description: "Name On Payment" type: "java.lang.String" propertyName: "nameOnPayment" propertyPath: "payment" entityName: "PayeePayment" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Name On Payment" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 24 relativePropertyName: "payment.nameOnPayment" dataSourcePath: path: ! [] currentPath: ! - "payment" columnOrder: 1 suppressRepeating: false - ! description: "Second Name On Payment" type: "java.lang.String" propertyName: "secondNameOnPayment" propertyPath: "payment" entityName: "PayeePayment" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Second Name On Payment" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 22 relativePropertyName: "payment.secondNameOnPayment" dataSourcePath: path: ! [] currentPath: ! - "payment" columnOrder: 2 suppressRepeating: false - ! description: "Check Number" type: "java.lang.Integer" propertyName: "number" propertyPath: null entityName: "Check" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: false function: null baseClassProperty: true format: "NONE" source: "FIELD" label: null columnTitle: "Check Number" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "number" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "PaymentTransaction" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: true format: "CURRENCY" source: "FIELD" label: null columnTitle: "Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 18 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false - ! description: "Transaction Date" type: "java.util.Calendar" propertyName: "transactionDate" propertyPath: null entityName: "PaymentTransaction" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "Transaction Date" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "transactionDate" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false - ! description: "Reconciled Date" type: "java.util.Calendar" propertyName: "reconciledDate" propertyPath: null entityName: "PaymentTransaction" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "Reconciled Date" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "reconciledDate" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false - ! description: "Status" type: "org.ssdt_ohio.usps.model.constants.PaymentTransactionStatus" propertyName: "status" propertyPath: null entityName: "PaymentTransaction" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Status" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "status" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false - ! description: "Transaction Type" type: "org.ssdt_ohio.usps.model.constants.PaymentTransactionType" propertyName: "transactionType" propertyPath: null entityName: "PaymentTransaction" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Transaction Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "transactionType" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false - ! description: "Voided Date" type: "java.util.Calendar" propertyName: "voidedDate" propertyPath: null entityName: "PaymentTransaction" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "Voided Date" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "voidedDate" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false - ! description: "Payment Number" type: "java.lang.Integer" propertyName: "number" propertyPath: "payment" entityName: "Payment" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "NONE" source: "FIELD" label: null columnTitle: "Payment Number" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payment.number" dataSourcePath: path: ! [] currentPath: ! - "payment" columnOrder: 10 suppressRepeating: false