---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "PurchaseOrderCharge Report"
  tags: null
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Outstanding Purchase Orders"
    suppressDetail: false
    showOptions: false
    sortProperties: !<java.util.ArrayList>
    - !<java.util.ArrayList>
      propertyName: "account.fullAccountCode"
      label: "Full Account Code"
      ascending: true
      controlBreak: true
      pageBreak: false
    - propertyName: "po.number"
      label: "PO #"
      ascending: true
      controlBreak: true
      pageBreak: false
    - propertyName: "referenceNumber"
      label: "Reference Number"
      ascending: true
      controlBreak: false
      pageBreak: false
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Outstanding Purchase Orders"
  querySpecification:
    specification: "invoiceable.oneOf ([param(\"invoiceable\",'',\"Invoiceable? (true/false)\"\
      )])\npo.amended.oneOf ([param(\"amended\",'',\"Amended only? (true/false)\"\
      )])\npo.number.between param(\"startPO\",\"\", \"Starting Purchase Order #\"\
      ), param(\"endPO\",\"\", \"Ending Purchase Order #\")\npo.date.between param(\"\
      startDate\",\"\",\"Transaction Start Date\"), param(\"endDate\",\"\", \"Transaction\
      \ End Date\")\npo.createdDate.between param(\"systemStartDate\",\"\",\"Created\
      \ Start Date\"), param(\"systemEndDate\",\"\",\"Created End Date\")\npo.vendor.number.oneOf\
      \ ([param(\"number\",'',\"Vendor #(s)\")])\naccount.fullAccountCode.oneOf ([param(\"\
      fullAccountCode\",'',\"Full Account Codes(s)\")])\naccount.code.fund.contains\
      \ param(\"fund\",\"\",\"Enter Fund - partial ok\")\naccount.code.func.contains\
      \ param(\"func\",\"\",\"Enter Function - partial ok\")\naccount.code.object.contains\
      \ param(\"obj\",\"\",\"Enter Object - partial ok\")\naccount.code.scc.contains\
      \ param(\"scc\",\"\",\"Enter SCC- partial ok\")\naccount.code.subject.contains\
      \ param(\"Subject\",\"\",\"Enter Subject - partial ok\")\naccount.code.opu.contains\
      \ param(\"opu\",\"\",\"Enter OPU - partial ok\")\naccount.code.il.contains param(\"\
      il\",\"\",\"Enter IL - partial ok\")\naccount.code.job.contains param(\"job\"\
      ,\"\",\"Enter Job - partial ok\")\ncurrentPeriodRemainingEncumbrance.ne '0'\n\
      account.filter.eq param(\"Filter Name\",\"\")\nsystemAdjustment.eq 'false'"
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.po.PurchaseOrderCharge"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Invoiceable"
    type: "java.lang.Boolean"
    propertyName: "invoiceable"
    propertyPath: null
    entityName: "PurchaseOrderCharge"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: null
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 14
    relativePropertyName: "invoiceable"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 1
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "po"
    columnOrder: 2
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: 4
    relativePropertyName: "referenceNumber"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 3
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "po"
      - "vendor"
    columnOrder: 4
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "po"
    columnOrder: 5
    suppressRepeating: false
    permission: null
  - !<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: null
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 24
    relativePropertyName: "account.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "account"
    columnOrder: 6
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 7
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Amount Filled"
    type: "java.math.BigDecimal"
    propertyName: "amountFilled"
    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: "amountFilled"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 9
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 10
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Current Period Remaining Encumbrance"
    type: "java.math.BigDecimal"
    propertyName: "currentPeriodRemainingEncumbrance"
    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: "Current Period Remaining Encumbrance"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "currentPeriodRemainingEncumbrance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 11
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    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: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 12
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Func"
    type: "java.lang.String"
    propertyName: "func"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    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.code.func"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 13
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Function One Digit Level"
    type: "java.lang.String"
    propertyName: "functionOneDigitLevel"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Function One Digit Level"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.functionOneDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 14
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Function Two Digit Level"
    type: "java.lang.String"
    propertyName: "functionTwoDigitLevel"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Function Two Digit Level"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.functionTwoDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 15
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Object"
    type: "java.lang.String"
    propertyName: "object"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    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.code.object"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 16
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Object One Digit Level"
    type: "java.lang.String"
    propertyName: "objectOneDigitLevel"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Object One Digit Level"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.objectOneDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 17
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "SCC"
    type: "java.lang.String"
    propertyName: "scc"
    propertyPath: "account.code"
    entityName: "AccountCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    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.code.scc"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 18
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Subject"
    type: "java.lang.String"
    propertyName: "subject"
    propertyPath: "account.code"
    entityName: "GeneralLedgerCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Subject"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.subject"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 19
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Subject Two Digit Level"
    type: "java.lang.String"
    propertyName: "subjectTwoDigitLevel"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Subject Two Digit Level"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.subjectTwoDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 20
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "OPU"
    type: "java.lang.String"
    propertyName: "opu"
    propertyPath: "account.code"
    entityName: "GeneralLedgerCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: "OPU"
    columnTitle: "OPU"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.opu"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 21
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Opu One Digit Level"
    type: "java.lang.String"
    propertyName: "opuOneDigitLevel"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Opu One Digit Level"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.opuOneDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 22
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Job"
    type: "java.lang.String"
    propertyName: "job"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    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.code.job"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 23
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "IL"
    type: "java.lang.String"
    propertyName: "il"
    propertyPath: "account.code"
    entityName: "ExpenditureCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    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.code.il"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 24
    suppressRepeating: false
    permission: null