--- reportDefinition: ! description: "PurchaseOrderCharge Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Purchase Order Detail" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "account.budget.cashAccount.code.fund" label: "Fund" ascending: true controlBreak: true pageBreak: false - propertyName: "account.budget.cashAccount.code.scc" label: "SCC" ascending: true controlBreak: true pageBreak: false - propertyName: "po.number" label: "PO #" ascending: true controlBreak: true pageBreak: false - propertyName: "account.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: false pageBreak: false - propertyName: "po.date" label: "Date" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Purchase Order Detail" querySpecification: specification: "account.fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"\ Full Account Codes(s)\")])\naccount.code.fund.eq param(\"fund\",\"\",\"Include\ \ Fund\")\naccount.code.func.eq param(\"func\",\"\",\"Include Func\")\naccount.code.object.eq\ \ param(\"object\",\"\",\"Include Object\")\naccount.code.scc.eq param(\"scc\"\ ,\"\",\"Include SCC\")\naccount.code.subject.eq param(\"subject\",\"\",\"Include\ \ Subject\")\naccount.code.opu.eq param(\"opu\",\"\",\"Include OPU\")\naccount.code.il.eq\ \ param(\"il\",\"\",\"Include IL\")\naccount.code.job.eq param(\"job\",\"\"\ ,\"Include Job\")\ninvoiceable.oneOf ([param(\"invoiceable\",'',\"Invoiceable?\ \ (true/false)\")])\npo.amended.oneOf ([param(\"amended\",'',\"Amended only?\ \ (true/false)\")])\npo.number.between param(\"startPO\",\"\", \"Starting Purchase\ \ Order #\"), param(\"endPO\",\"\", \"Ending Purchase Order #\")\npo.date.between\ \ param(\"startDate\",\"\",\"Transaction Start Date\"), param(\"endDate\",\"\ \", \"Transaction End Date\")\npo.createdDate.between param(\"systemStartDate\"\ ,\"\",\"Created Start Date\"), param(\"systemEndDate\",\"\",\"Created End Date\"\ )\npo.vendor.number.oneOf ([param(\"number\",'',\"Vendor #(s)\")])\naccount.filter.eq\ \ param(\"Filter Name\",\"\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.po.PurchaseOrderCharge" properties: ! - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "account.budget.cashAccount.code" entityName: "AccountCode" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Fund" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.budget.cashAccount.code.fund" dataSourcePath: path: ! [] currentPath: ! - "account" - "budget" - "cashAccount" - "code" columnOrder: 1 suppressRepeating: false - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: "account.budget.cashAccount.code" entityName: "AccountCode" sortOrder: 2 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "SCC" columnTitle: "SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.budget.cashAccount.code.scc" dataSourcePath: path: ! [] currentPath: ! - "account" - "budget" - "cashAccount" - "code" columnOrder: 2 suppressRepeating: false - ! description: "Invoiceable" type: "java.lang.Boolean" propertyName: "invoiceable" propertyPath: null entityName: "PurchaseOrderCharge" sortOrder: 0 controlBreak: false suppressed: true 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: 14 relativePropertyName: "invoiceable" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false - ! description: "PO #" type: "java.lang.Integer" propertyName: "number" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 3 controlBreak: true suppressed: true 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: "po.number" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 4 suppressRepeating: false - ! description: "Vendor #" type: "java.lang.Integer" propertyName: "number" propertyPath: "po.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: 18 relativePropertyName: "po.vendor.number" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" columnOrder: 5 suppressRepeating: false - ! description: "Primary Name" type: "java.lang.String" propertyName: "primaryName" propertyPath: "po.vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Vendor Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 30 relativePropertyName: "po.vendor.primaryName" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" columnOrder: 6 suppressRepeating: false - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 5 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: 20 relativePropertyName: "po.date" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 7 suppressRepeating: false - ! description: "Transaction Indicator" type: "java.lang.String" propertyName: "transactionIndicator" propertyPath: "account.code" entityName: "ExpenditureCode" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: "TI #" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "account.code.transactionIndicator" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 8 suppressRepeating: false - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "account" entityName: "Account" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 9 suppressRepeating: false - ! description: "Item Number" type: "java.lang.Integer" propertyName: "itemNumber" propertyPath: null entityName: "PurchaseOrderCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: "Item #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "itemNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false - ! description: "Quantity" type: "java.math.BigDecimal" propertyName: "quantity" propertyPath: "item" entityName: "PurchaseOrderItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Quantity" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 12 relativePropertyName: "item.quantity" dataSourcePath: path: ! [] currentPath: ! - "item" columnOrder: 11 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "item" entityName: "PurchaseOrderItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 35 relativePropertyName: "item.description" dataSourcePath: path: ! [] currentPath: ! - "item" columnOrder: 12 suppressRepeating: false - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "PurchaseOrderCharge" 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: 32 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 13 suppressRepeating: false - ! description: "Amount Filled" type: "java.math.BigDecimal" propertyName: "amountFilled" propertyPath: null entityName: "PurchaseOrderCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 32 relativePropertyName: "amountFilled" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 14 suppressRepeating: false - ! description: "Amount Paid" type: "java.math.BigDecimal" propertyName: "amountPaid" propertyPath: null entityName: "PurchaseOrderCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 32 relativePropertyName: "amountPaid" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 15 suppressRepeating: false - ! description: "Remaining Encumbrance" type: "java.math.BigDecimal" propertyName: "remainingEncumbrance" propertyPath: null entityName: "PurchaseOrderCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 32 relativePropertyName: "remainingEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 16 suppressRepeating: false