---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "InvoiceItem Report"
  tags: null
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Outstanding Invoices by Vendor Name"
    suppressDetail: false
    showOptions: false
    sortProperties: !<java.util.ArrayList>
    - !<java.util.ArrayList>
      propertyName: "invoice.vendor.primaryName"
      label: "Primary Name"
      ascending: true
      controlBreak: true
      pageBreak: false
    - propertyName: "invoice.source.purchaseOrderNumber"
      label: "Purchase Order Number"
      ascending: true
      controlBreak: false
      pageBreak: false
    - propertyName: "invoice.invoiceNumber"
      label: "Invoice Number"
      ascending: true
      controlBreak: false
      pageBreak: false
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Outstanding Invoices by Vendor Name"
  querySpecification:
    specification: "outstanding.eq 'true'\npoChargeId.purchaseOrder.date.between param(\"\
      startDate\",\"\",\"PO Start Date\"), param(\"endDate\",\"\", \"PO End Date\"\
      )\ninvoice.paymentDue.between param(\"PmtstartDate\",\"\",\"Payment Due Start\
      \ Date\"), param(\"PmtendDate\",\"\", \"Payment Due End Date\")"
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.invoice.InvoiceItem"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Purchase Order Number"
    type: "java.lang.Integer"
    propertyName: "purchaseOrderNumber"
    propertyPath: "invoice.source"
    entityName: "LegacyInvoice"
    sortOrder: 2
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "METHOD"
    label: null
    columnTitle: "Purchase Order #"
    alignment: "CENTER"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 7
    relativePropertyName: "invoice.source.purchaseOrderNumber"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "invoice"
      - "source"
    columnOrder: 1
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Invoice Number"
    type: "java.lang.String"
    propertyName: "invoiceNumber"
    propertyPath: "invoice"
    entityName: "Invoice"
    sortOrder: 3
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: null
    columnTitle: "Invoice #"
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 12
    relativePropertyName: "invoice.invoiceNumber"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "invoice"
    columnOrder: 2
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: null
    columnTitle: null
    alignment: "CENTER"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 7
    relativePropertyName: "invoice.vendor.number"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "invoice"
      - "vendor"
    columnOrder: 3
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Primary Name"
    type: "java.lang.String"
    propertyName: "primaryName"
    propertyPath: "invoice.vendor"
    entityName: "Vendor"
    sortOrder: 1
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "invoice.vendor.primaryName"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "invoice"
      - "vendor"
    columnOrder: 4
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Vendor Invoice Date"
    type: "java.util.Calendar"
    propertyName: "vendorInvoiceDate"
    propertyPath: "invoice"
    entityName: "Invoice"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "CALENDAR"
    source: "FIELD"
    label: ""
    columnTitle: "Vendor Invoice Date"
    alignment: "CENTER"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 8
    relativePropertyName: "invoice.vendorInvoiceDate"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "invoice"
    columnOrder: 5
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Payment Due"
    type: "java.util.Calendar"
    propertyName: "paymentDue"
    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: null
    alignment: "CENTER"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 10
    relativePropertyName: "invoice.paymentDue"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "invoice"
    columnOrder: 6
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 25
    relativePropertyName: "account.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "account"
    columnOrder: 7
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Amount"
    type: "java.math.BigDecimal"
    propertyName: "amount"
    propertyPath: null
    entityName: "InvoiceItem"
    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: 9
    relativePropertyName: "amount"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Line1"
    type: "java.lang.String"
    propertyName: "line1"
    propertyPath: "invoice.vendor.defaultCheckLocation.address"
    entityName: "AddressHolder"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: null
    columnTitle: "Line1"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 15
    relativePropertyName: "invoice.vendor.defaultCheckLocation.address.line1"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "invoice"
      - "vendor"
      - "defaultCheckLocation"
      - "address"
    columnOrder: 9
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "City"
    type: "java.lang.String"
    propertyName: "city"
    propertyPath: "invoice.vendor.defaultCheckLocation.address"
    entityName: "AddressHolder"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: null
    columnTitle: "City"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 10
    relativePropertyName: "invoice.vendor.defaultCheckLocation.address.city"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "invoice"
      - "vendor"
      - "defaultCheckLocation"
      - "address"
    columnOrder: 10
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "State"
    type: "java.lang.String"
    propertyName: "state"
    propertyPath: "invoice.vendor.defaultCheckLocation.address"
    entityName: "AddressHolder"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: null
    columnTitle: "ST"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 3
    relativePropertyName: "invoice.vendor.defaultCheckLocation.address.state"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "invoice"
      - "vendor"
      - "defaultCheckLocation"
      - "address"
    columnOrder: 11
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Postal Code"
    type: "java.lang.String"
    propertyName: "postalCode"
    propertyPath: "invoice.vendor.defaultCheckLocation.address"
    entityName: "AddressHolder"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: null
    columnTitle: "Postal Code"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 8
    relativePropertyName: "invoice.vendor.defaultCheckLocation.address.postalCode"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "invoice"
      - "vendor"
      - "defaultCheckLocation"
      - "address"
    columnOrder: 12
    suppressRepeating: false