---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "The report has parameters that allow for multiple funds with use of\
    \ comma separated rather than fund choice with wildcard option "
  tags: "Public Shared"
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Open Purchase Orders"
    suppressDetail: false
    showOptions: false
    sortProperties: !<java.util.ArrayList> []
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Open Purchase Orders"
  querySpecification:
    specification: "invoiceable.eq 'true'\ncharges.account.code.fund.oneOf ([param(\"\
      Fund\",'',\"Include Funds (001,006)\")])"
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.po.PurchaseOrder"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Vendor #"
    type: "java.lang.Integer"
    propertyName: "number"
    propertyPath: "vendor"
    entityName: "Vendor"
    sortOrder: 1
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: null
    columnTitle: "Vendor #"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: true
    width: 0
    relativePropertyName: "vendor.number"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "vendor"
    columnOrder: 1
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Primary Name"
    type: "java.lang.String"
    propertyName: "primaryName"
    propertyPath: "vendor"
    entityName: "Vendor"
    sortOrder: 1
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: null
    columnTitle: ":"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: true
    width: 0
    relativePropertyName: "vendor.primaryName"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "vendor"
    columnOrder: 2
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "PO #"
    type: "java.lang.Integer"
    propertyName: "number"
    propertyPath: null
    entityName: "PurchaseOrder"
    sortOrder: 3
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: false
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: null
    columnTitle: "PO #"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "number"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 3
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Date"
    type: "java.util.Calendar"
    propertyName: "date"
    propertyPath: null
    entityName: "PurchaseOrder"
    sortOrder: 2
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: false
    function: null
    baseClassProperty: false
    format: "CALENDAR"
    source: "FIELD"
    label: null
    columnTitle: "Date"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 11
    relativePropertyName: "date"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 4
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Description"
    type: "java.lang.String"
    propertyName: "description"
    propertyPath: null
    entityName: "PurchaseOrder"
    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: 30
    relativePropertyName: "description"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 5
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Source"
    type: "java.lang.String"
    propertyName: "source"
    propertyPath: null
    entityName: "PurchaseOrder"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: null
    columnTitle: "Source"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "source"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 6
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportableCustomFieldImpl>
    propertyName: "createdDate"
    reportableProperty: !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
      description: "Created Date"
      type: "java.util.Calendar"
      propertyName: "customFields.createdDate.value"
      propertyPath: null
      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: "customFields.createdDate.value"
      dataSourcePath:
        path: !<java.util.ArrayList> []
        currentPath: !<java.util.ArrayList> []
      columnOrder: 0
      suppressRepeating: false
      permission: null
    ascending: true
    entityName: "PurchaseOrder"
    columnOrder: 7
    function: null
    sortOrder: 0
    suppressed: false
    columnTitle: "Created Date"
    suppressRepeating: false
    controlBreak: false
    pageBreak: false
    baseClassProperty: false
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    format: "TIMESTAMP"
    width: 11
    description: "Created Date"
    name: "customFields.createdDate.value"
    type: "java.util.Calendar"
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "PO Total"
    type: "java.math.BigDecimal"
    propertyName: "purchaseOrderTotal"
    propertyPath: null
    entityName: "PurchaseOrder"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "FIELD"
    label: null
    columnTitle: "PO Total"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 17
    relativePropertyName: "purchaseOrderTotal"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Total Paid"
    type: "java.math.BigDecimal"
    propertyName: "totalPaid"
    propertyPath: null
    entityName: "PurchaseOrder"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "FIELD"
    label: null
    columnTitle: "Total Paid"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 17
    relativePropertyName: "totalPaid"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 9
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fund"
    type: "java.lang.String"
    propertyName: "fund"
    propertyPath: "charges.account.budget.code"
    entityName: "AccountCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    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.code.fund"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 10
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Func"
    type: "java.lang.String"
    propertyName: "func"
    propertyPath: "charges.account.budget.code"
    entityName: "BudgetCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Func"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.budget.code.func"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 11
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Object"
    type: "java.lang.String"
    propertyName: "object"
    propertyPath: "charges.account.budget.code"
    entityName: "BudgetCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Object"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.budget.code.object"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 12
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "SCC"
    type: "java.lang.String"
    propertyName: "scc"
    propertyPath: "charges.account.budget.code"
    entityName: "AccountCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    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.code.scc"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 13
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Subject"
    type: "java.lang.String"
    propertyName: "subject"
    propertyPath: "charges.account.budget.code"
    entityName: "BudgetCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Subject"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.budget.code.subject"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 14
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "OPU"
    type: "java.lang.String"
    propertyName: "opu"
    propertyPath: "charges.account.budget.code"
    entityName: "BudgetCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: "OPU"
    columnTitle: "OPU"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.budget.code.opu"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 15
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "IL"
    type: "java.lang.String"
    propertyName: "il"
    propertyPath: "charges.account.budget.code"
    entityName: "BudgetCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: "IL"
    columnTitle: "IL"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.budget.code.il"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 16
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Job"
    type: "java.lang.String"
    propertyName: "job"
    propertyPath: "charges.account.budget.code"
    entityName: "BudgetCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Job"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.budget.code.job"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "charges"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "budget"
      - "code"
    columnOrder: 17
    suppressRepeating: false
    permission: null