--- reportDefinition: ! description: "InvoiceItem Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "CSV" templateName: "Inventory items to include on pending file" suppressDetail: false queryParameters: ! {} title: "Inventory items to include on pending file" entity: "org.ssdt_ohio.usas.model.invoice.InvoiceItem" properties: ! - ! description: "PO #" type: "java.lang.Integer" propertyName: "number" propertyPath: "poChargeId.purchaseOrderId.purchaseOrder" entityName: "PurchaseOrder" sortOrder: 1 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: "poChargeId.purchaseOrderId.purchaseOrder.number" dataSourcePath: path: ! [] currentPath: ! - "poChargeId" - "purchaseOrderId" - "purchaseOrder" columnOrder: 1 suppressRepeating: false - ! description: "Line Number" type: "java.lang.Integer" propertyName: "lineNumber" propertyPath: null entityName: "InvoiceItem" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Item #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "lineNumber" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 2 suppressRepeating: false - ! description: "Invoice Number" type: "java.lang.String" propertyName: "invoiceNumber" propertyPath: "invoice" entityName: "Invoice" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Invoice Number" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "invoice.invoiceNumber" dataSourcePath: path: ! [] currentPath: ! - "invoice" columnOrder: 3 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: 4 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "InvoiceItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "InvoiceItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: null columnTitle: "Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false - ! description: "Quantity" type: "java.math.BigDecimal" propertyName: "quantity" propertyPath: "charge" entityName: "PurchaseOrderCharge" 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: 0 relativePropertyName: "charge.quantity" dataSourcePath: path: ! [] currentPath: ! - "charge" columnOrder: 7 suppressRepeating: false - ! description: "Vendor #" type: "java.lang.Integer" propertyName: "number" propertyPath: "invoice.vendor" entityName: "Vendor" sortOrder: 0 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: "invoice.vendor.number" dataSourcePath: path: ! [] currentPath: ! - "invoice" - "vendor" columnOrder: 8 suppressRepeating: false - ! description: "Primary Name" type: "java.lang.String" propertyName: "primaryName" propertyPath: "invoice.vendor" entityName: "Vendor" sortOrder: 0 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: "invoice.vendor.primaryName" dataSourcePath: path: ! [] currentPath: ! - "invoice" - "vendor" columnOrder: 9 suppressRepeating: false - ! description: "Date" type: "java.util.Calendar" propertyName: "date" propertyPath: "invoice" entityName: "Invoice" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "invoice.date" dataSourcePath: path: ! [] currentPath: ! - "invoice" columnOrder: 10 suppressRepeating: false - ! description: "Issued" type: "java.util.Calendar" propertyName: "issued" propertyPath: "charge" entityName: "PurchaseOrderCharge" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Issued" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "charge.issued" dataSourcePath: path: ! [] currentPath: ! - "charge" columnOrder: 11 suppressRepeating: false querySpecification: specification: "account.budget.code.object.between param(\"startObj\",\"\",\"\ Beginning Object code\"),param(\"endObj\",\"\",\"Ending Object code\")\ninvoice.date.between\ \ param(\"startDate\",\"\",\"Start Invoice Date\"),param(\"endDate\",\"\",\"\ End Invoice Date\")\namount.ge param(\"amount\",\"\",\"Threshold amount (Greater\ \ than or equal to)\")"