--- reportDefinition: ! description: "ActivityLedger Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Financial Detail Report" suppressDetail: false showOptions: false queryParameters: ! {} title: "Financial Detail Report" querySpecification: specification: "date.ge param(\"startDate\",\"\",\"Start Date\")\ndate.le param(\"\ endDate\",\"\",\"End Date\")\naccount.fullAccountCode.oneOf ([param(\"includeAccts\"\ ,'',\"Include Full Account Code(s)\")])\naccount.fullAccountCode.notOneOf ([param(\"\ excludeAccts\",'',\"Exclude Full Account Code(s)\")])\ncashAccount.fullAccountCode.oneOf\ \ ([param(\"includeCashAccts\",'',\"Include Cash Account(s) i.e 000-0000\")])\n\ account.code.func.like param(\"includeFunc\",\"\",\"Include Func\")\naccount.code.fund.like\ \ param(\"includeFund\",\"\",\"Include Fund\")\naccount.code.il.like param(\"\ includeIL\",\"\",\"Include IL\")\naccount.code.job.like param(\"includeJob\"\ ,\"\",\"Include Job\")\naccount.code.object.like param(\"includeObj\",\"\",\"\ Include Obj\")\naccount.code.opu.oneOf ([param(\"includeOpu\",\"\",\"Include\ \ Opu\")])\naccount.code.receipt.like param(\"includeRcpt\",\"\",\"Include Rcpt\"\ )\naccount.code.scc.like param(\"includeSCC\",\"\",\"Include SCC\")\naccount.code.subject.like\ \ param(\"includeSubj\",\"\",\"Include Subj\")\ntype.oneOf (['Disb','Ref','Rec','Payroll','TA_In','TA_Out','Dist'])\n\ account.filter.eq param(\"filter\",\"\",\"Filter\")" 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: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "cashAccount" columnOrder: 1 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "account" entityName: "Account" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "account.description" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 2 suppressRepeating: true - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: null entityName: "ActivityLedger" sortOrder: 2 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: 3 suppressRepeating: false - ! description: "Check #" type: "java.lang.Integer" propertyName: "checkNumber" propertyPath: null entityName: "ActivityLedger" sortOrder: 3 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: 4 suppressRepeating: false - ! description: "Receipt #" type: "java.lang.Integer" propertyName: "number" propertyPath: "receiptItem.receipt" entityName: "Receipt" sortOrder: 3 controlBreak: false 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: "receiptItem.receipt.number" dataSourcePath: path: ! [] currentPath: ! - "receiptItem" - "receipt" columnOrder: 5 suppressRepeating: false - ! description: "PO #" type: "java.lang.Integer" propertyName: "poNumber" propertyPath: null entityName: "ActivityLedger" sortOrder: 3 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: 6 suppressRepeating: false - ! 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: 0 relativePropertyName: "itemDescription" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "account" entityName: "Account" sortOrder: 1 controlBreak: true 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: 36 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 8 suppressRepeating: false - ! 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: 9 suppressRepeating: false - ! 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: 10 suppressRepeating: false - ! description: "Vendor Number And Name" type: "java.lang.String" propertyName: "vendorNumberAndName" propertyPath: "vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Vendor Number And Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "vendor.vendorNumberAndName" dataSourcePath: path: ! [] currentPath: ! - "vendor" columnOrder: 11 suppressRepeating: false