--- reportDefinition: ! description: "DisbursementItem Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Detailed Check Register" suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "Detailed Check Register" querySpecification: specification: "disbursement.type.oneOf ([param(\"type\",'',\"Type(s):Accounts\ \ Payable, Refund or Payroll\")])\ndisbursement.date.between param(\"startDate\"\ ,\"\",\"Transaction Start Date\"), param(\"endDate\",\"\", \"Transaction End\ \ Date\")\ndisbursement.bankTransaction.checkNumber.between param(\"startCheck\"\ ,\"\",\"Starting Check #\"), param(\"endCheck\",\"\", \"Ending Check #\")\n\ disbursement.vendor.number.oneOf ([param(\"number\",'',\"Vendor #(s)\")])\n\ disbursement.status.notOneOf ([param(\"status\",'',\"Exclude Status(es): Outstanding,\ \ Reconciled or Void\")])\naccount.filter.eq param(\"Filter Name\",\"\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.disbursement.DisbursementItem" properties: ! - ! description: "Check Number" type: "java.lang.Integer" propertyName: "checkNumber" propertyPath: "disbursement" entityName: "Disbursement" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Check #" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "disbursement.checkNumber" dataSourcePath: path: ! [] currentPath: ! - "disbursement" columnOrder: 1 suppressRepeating: true permission: null - ! description: "Type" type: "org.ssdt_ohio.usas.model.constants.DisbursementType" propertyName: "type" propertyPath: "disbursement" entityName: "Disbursement" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Type" alignment: "LEFT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "disbursement.type" dataSourcePath: path: ! [] currentPath: ! - "disbursement" columnOrder: 2 suppressRepeating: false permission: null - ! description: "Primary Name" type: "java.lang.String" propertyName: "primaryName" propertyPath: "disbursement.vendor" entityName: "Vendor" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Vendor Name" alignment: "LEFT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 20 relativePropertyName: "disbursement.vendor.primaryName" dataSourcePath: path: ! [] currentPath: ! - "disbursement" - "vendor" columnOrder: 3 suppressRepeating: true permission: null - ! description: "Vendor #" type: "java.lang.Integer" propertyName: "number" propertyPath: "disbursement.vendor" entityName: "Vendor" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "Vendor #" columnTitle: "Vendor #" alignment: "RIGHT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 8 relativePropertyName: "disbursement.vendor.number" dataSourcePath: path: ! [] currentPath: ! - "disbursement" - "vendor" columnOrder: 4 suppressRepeating: true permission: null - ! description: "Line #" type: "java.lang.Integer" propertyName: "lineNumber" propertyPath: null entityName: "DisbursementItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NATURALID" source: "FIELD" label: "Line #" columnTitle: "Line #" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "lineNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "DisbursementItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 24 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! description: "Status" type: "org.ssdt_ohio.usas.model.constants.DisbursementStatus" propertyName: "status" propertyPath: "disbursement" entityName: "Disbursement" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Status" alignment: "LEFT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "disbursement.status" dataSourcePath: path: ! [] currentPath: ! - "disbursement" columnOrder: 7 suppressRepeating: true permission: null - ! description: "Charge Po Number" type: "java.lang.Integer" propertyName: "chargePoNumber" propertyPath: null entityName: "DisbursementInvoiceItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "METHOD" label: "" columnTitle: "PO #" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 8 relativePropertyName: "chargePoNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false permission: null - ! description: "Invoice Display Number" type: "java.lang.String" propertyName: "invoiceDisplayNumber" propertyPath: null entityName: "DisbursementVoidItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Invoice #" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "invoiceDisplayNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false permission: null - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "disbursement" entityName: "Disbursement" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Date" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 8 relativePropertyName: "disbursement.date" dataSourcePath: path: ! [] currentPath: ! - "disbursement" columnOrder: 10 suppressRepeating: false permission: null - ! description: "Void Date" type: "java.util.Calendar" propertyName: "voidDate" propertyPath: "disbursement" entityName: "Disbursement" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Void Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "disbursement.voidDate" dataSourcePath: path: ! [] currentPath: ! - "disbursement" columnOrder: 11 suppressRepeating: false permission: null - ! 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: "Account Code" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 30 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 12 suppressRepeating: false permission: null - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "DisbursementItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Amount" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 13 suppressRepeating: false permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: false 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: 14 suppressRepeating: false permission: null - ! description: "Function Two Digit Level" type: "java.lang.String" propertyName: "functionTwoDigitLevel" propertyPath: "account.code" entityName: "BudgetCode" sortOrder: 0 controlBreak: false suppressed: false 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: 15 suppressRepeating: false permission: null