--- reportDefinition: ! description: "PurchaseOrderCharge Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Open Purchase Orders" suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "Open Purchase Orders" querySpecification: specification: "invoiceable.eq 'true'\naccount.code.fund.oneOf ([param(\"Fund\"\ ,'',\"Include Funds (001,006)\")])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.po.PurchaseOrderCharge" properties: ! - ! description: "Vendor #" type: "java.lang.Integer" propertyName: "number" propertyPath: "po.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: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.number" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" columnOrder: 1 suppressRepeating: false - ! description: "Primary Name" type: "java.lang.String" propertyName: "primaryName" propertyPath: "po.vendor" entityName: "Vendor" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Primary Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.primaryName" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" columnOrder: 2 suppressRepeating: false - ! description: "PO #" type: "java.lang.Integer" propertyName: "number" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 3 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: "PO #" columnTitle: "PO #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.number" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 3 suppressRepeating: false - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "po.date" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 4 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: 25 relativePropertyName: "item.description" dataSourcePath: path: ! [] currentPath: ! - "item" columnOrder: 5 suppressRepeating: false - ! description: "Source" type: "java.lang.String" propertyName: "source" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Source" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.source" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 6 suppressRepeating: false - ! propertyName: "createdDate" reportableProperty: ! description: "Created Date" type: "java.util.Calendar" propertyName: "customFields.createdDate.value" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "TIMESTAMP" source: null label: null columnTitle: "Created Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "po.customFields.createdDate.value" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 0 suppressRepeating: false columnOrder: 7 function: null suppressed: false sortOrder: 0 columnTitle: "Created Date" suppressRepeating: false controlBreak: false pageBreak: false ascending: true baseClassProperty: false alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false format: "TIMESTAMP" entityName: "PurchaseOrder" width: 11 description: "Created Date" name: "po.customFields.createdDate.value" type: "java.util.Calendar" - ! description: "PO Total" type: "java.math.BigDecimal" propertyName: "purchaseOrderTotal" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "PO Total" columnTitle: "PO Total" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.purchaseOrderTotal" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 8 suppressRepeating: false - ! description: "Total Paid" type: "java.math.BigDecimal" propertyName: "totalPaid" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Total Paid" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.totalPaid" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 9 suppressRepeating: false - ! 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: "Full Account Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "account.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "account" columnOrder: 10 suppressRepeating: false - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "account.code" entityName: "AccountCode" sortOrder: 0 controlBreak: false 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.code.fund" dataSourcePath: path: ! [] currentPath: ! - "account" - "code" columnOrder: 11 suppressRepeating: false