--- reportDefinition: ! description: "PurchaseOrderCharge Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "CSV" templateName: "Smart Procure Purchase Order Detail" suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "Smart Procure Purchase Order Detail" querySpecification: specification: "po.createdDate.between param(\"systemStartDate\",\"\",\"Created\ \ Start Date\"), param(\"systemEndDate\",\"\",\"Created End Date\")\naccount.filter.eq\ \ param(\"Filter Name\",\"\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.po.PurchaseOrderCharge" properties: ! - ! description: "PO #" type: "java.lang.Integer" propertyName: "number" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 1 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: 1 suppressRepeating: false permission: null - ! description: "Reference Number" type: "java.lang.Integer" propertyName: "referenceNumber" propertyPath: null entityName: "PurchaseOrderCharge" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NATURALID" source: "FIELD" label: null columnTitle: "Item #" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 5 relativePropertyName: "referenceNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 2 suppressRepeating: false permission: null - ! 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: 3 suppressRepeating: false permission: null - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "po" entityName: "PurchaseOrder" sortOrder: 0 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: 8 relativePropertyName: "po.date" dataSourcePath: path: ! [] currentPath: ! - "po" columnOrder: 4 suppressRepeating: false permission: null - ! 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: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! description: "Amount Canceled" type: "java.math.BigDecimal" propertyName: "amountCanceled" propertyPath: null entityName: "PurchaseOrderCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Amount Canceled" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amountCanceled" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! 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: "CURRENCY" source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amountPaid" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false permission: null - ! description: "Vendor Number And Name" type: "java.lang.String" propertyName: "vendorNumberAndName" propertyPath: "po.vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Vendor" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.vendorNumberAndName" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" columnOrder: 8 suppressRepeating: false permission: null - ! description: "Line1" type: "java.lang.String" propertyName: "line1" propertyPath: "po.vendor.legacyDefaultPoLocation.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Line1" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.legacyDefaultPoLocation.address.line1" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" - "legacyDefaultPoLocation" - "address" columnOrder: 9 suppressRepeating: false permission: null - ! description: "Line2" type: "java.lang.String" propertyName: "line2" propertyPath: "po.vendor.legacyDefaultPoLocation.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Line2" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.legacyDefaultPoLocation.address.line2" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" - "legacyDefaultPoLocation" - "address" columnOrder: 10 suppressRepeating: false permission: null - ! description: "City" type: "java.lang.String" propertyName: "city" propertyPath: "po.vendor.legacyDefaultPoLocation.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "City" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.legacyDefaultPoLocation.address.city" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" - "legacyDefaultPoLocation" - "address" columnOrder: 11 suppressRepeating: false permission: null - ! description: "State" type: "java.lang.String" propertyName: "state" propertyPath: "po.vendor.legacyDefaultPoLocation.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "State" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.legacyDefaultPoLocation.address.state" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" - "legacyDefaultPoLocation" - "address" columnOrder: 12 suppressRepeating: false permission: null - ! description: "Zip" type: "java.lang.String" propertyName: "postalCode" propertyPath: "po.vendor.legacyDefaultPoLocation.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "Zip" columnTitle: "Zip" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.legacyDefaultPoLocation.address.postalCode" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" - "legacyDefaultPoLocation" - "address" columnOrder: 13 suppressRepeating: false permission: null - ! description: "Legacy Email Address" type: "java.lang.Object" propertyName: "legacyEmailAddress" propertyPath: "po.vendor" entityName: "Vendor" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Legacy Email Address" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "po.vendor.legacyEmailAddress" dataSourcePath: path: ! [] currentPath: ! - "po" - "vendor" columnOrder: 14 suppressRepeating: false permission: null