---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "Compliance report - compares Estimated Revenues and Expenditures against\
    \ Actual Revenues and Expenditures."
  tags: "Reports Group"
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Appropriations and Receivables by Cash Account"
    suppressDetail: false
    showOptions: false
    sortProperties: !<java.util.ArrayList>
    - !<java.util.ArrayList>
      propertyName: "fullAccountCode"
      label: "Full Account Code"
      ascending: true
      controlBreak: false
      pageBreak: false
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Appropriations and Receivables by Cash Account"
  querySpecification:
    specification: "active.eq 't'\nmatchAny {\n    initialCash.ne '0'\n    anticipatedRevenues.FYTDReceivable.ne\
      \ '0'\n    budgets.FYTDExpendable.ne '0'\n    FYTDReceived.ne '0'\n}"
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.account.CashAccount"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: null
    entityName: "Account"
    sortOrder: 1
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 36
    relativePropertyName: "fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 1
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fund"
    type: "java.lang.String"
    propertyName: "fund"
    propertyPath: "code"
    entityName: "AccountCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 5
    relativePropertyName: "code.fund"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "code"
    columnOrder: 2
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "SCC"
    type: "java.lang.String"
    propertyName: "scc"
    propertyPath: "code"
    entityName: "AccountCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: "SCC"
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 5
    relativePropertyName: "code.scc"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "code"
    columnOrder: 3
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Description"
    type: "java.lang.String"
    propertyName: "description"
    propertyPath: null
    entityName: "Account"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 25
    relativePropertyName: "description"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 4
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Initial Cash"
    type: "java.math.BigDecimal"
    propertyName: "initialCash"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: ""
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "initialCash"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 5
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Received"
    type: "java.math.BigDecimal"
    propertyName: "FYTDReceived"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "FYTD Received"
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDReceived"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 6
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Expended"
    type: "java.math.BigDecimal"
    propertyName: "FYTDExpended"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "FYTD Expended"
    columnTitle: "FYTD Expended"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDExpended"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 7
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fund Balance"
    type: "java.math.BigDecimal"
    propertyName: "currentFundBalance"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "Fund Balance"
    columnTitle: "Fund Balance"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "currentFundBalance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Prior Year Encumbrance"
    type: "java.math.BigDecimal"
    propertyName: "priorYearEncumbrance"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: ""
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "priorYearEncumbrance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 9
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Encumbrance"
    type: "java.math.BigDecimal"
    propertyName: "currentEncumbrance"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "Encumbrance"
    columnTitle: "Encumbrance"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "currentEncumbrance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 10
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Unencumbered Balance"
    type: "java.math.BigDecimal"
    propertyName: "currentUnencumberedBalance"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "Unencumbered Balance"
    columnTitle: "Unencumbered Balance"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "currentUnencumberedBalance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 11
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTDReceivable"
    type: "java.math.BigDecimal"
    propertyName: "FYTDReceivable"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: ""
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDReceivable"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 12
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTDAppropriated"
    type: "java.math.BigDecimal"
    propertyName: "FYTDAppropriated"
    propertyPath: null
    entityName: "CashAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: ""
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDAppropriated"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 13
    suppressRepeating: false