---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "RevenueAccount Report"
  tags: null
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Revenue Summary Report"
    suppressDetail: true
    showOptions: false
    sortProperties: !<java.util.ArrayList>
    - !<java.util.ArrayList>
      propertyName: "cashAccount.fullAccountCode"
      label: "Full Account Code"
      ascending: true
      controlBreak: true
      pageBreak: false
    - propertyName: "cashAccount.description"
      label: "Description"
      ascending: true
      controlBreak: false
      pageBreak: false
    - propertyName: "fullAccountCode"
      label: "Full Account Code"
      ascending: true
      controlBreak: false
      pageBreak: false
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Revenue Summary Report"
  querySpecification:
    specification: "fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"Full Account\
      \ Code  (i.e. 006-1512-0000-000000-000)\")])\ncode.fund.like param(\"includecode.fund\"\
      ,\"\",\"Include Fund (use % for wildcard)\")\ncode.receipt.like param(\"includecode.receipt\"\
      ,\"\",\"Include Receipt (use % for wildcard)\")\ncode.scc.like param(\"includecode.scc\"\
      ,\"\",\"Include SCC (use % for wildcard)\")\ncode.subject.like param(\"includecode.subject\"\
      ,\"\",\"Include Subject (use % for wildcard)\")\ncode.opu.like param(\"includecode.opu\"\
      ,\"\",\"Include OPU (use % for wildcard)\")\nactive.oneOf ([param(\"active\"\
      ,'',\"Active only? (true/false)\")])\nfilter.eq param(\"Filter Name\",\"\")\n\
      asOfPeriod.eq param(\"asOfPeriod\",\"\",\"Total As of Period (If a date is specified\
      \ FYTD and MTD amounts will be calculated as of that period)\")\nallAmountsZero.ne\
      \ param(\"allAmountsZero\",\"\", \"Exclude Accounts with Zero Amounts? (true/false)\
      \  Leave blank to include all accounts\")"
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.account.RevenueAccount"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: "cashAccount"
    entityName: "Account"
    sortOrder: 1
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "METHOD"
    label: null
    columnTitle: "FUND-SCC"
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 36
    relativePropertyName: "cashAccount.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 1
    suppressRepeating: true
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Description"
    type: "java.lang.String"
    propertyName: "description"
    propertyPath: "cashAccount"
    entityName: "Account"
    sortOrder: 1
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Description"
    alignment: "LEFT"
    controlHeaderOnly: true
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 25
    relativePropertyName: "cashAccount.description"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "cashAccount"
    columnOrder: 2
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: null
    entityName: "Account"
    sortOrder: 2
    controlBreak: false
    suppressed: true
    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: 0
    relativePropertyName: "fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 3
    suppressRepeating: false
    permission: null
  - !<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: null
    label: null
    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
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Receivable"
    type: "java.math.BigDecimal"
    propertyName: "FYTDReceivable"
    propertyPath: "anticipatedRevenue"
    entityName: "AnticipatedRevenue"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "anticipatedRevenue.FYTDReceivable"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 5
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Received"
    type: "java.math.BigDecimal"
    propertyName: "FYTDReceived"
    propertyPath: null
    entityName: "RevenueAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    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
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "MTD Received"
    type: "java.math.BigDecimal"
    propertyName: "MTDReceived"
    propertyPath: null
    entityName: "RevenueAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "MTDReceived"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 7
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "YTD Received"
    type: "java.math.BigDecimal"
    propertyName: "YTDReceived"
    propertyPath: null
    entityName: "RevenueAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "YTDReceived"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Remaining Balance"
    type: "java.math.BigDecimal"
    propertyName: "remainingBalance"
    propertyPath: "anticipatedRevenue"
    entityName: "AnticipatedRevenue"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "anticipatedRevenue.remainingBalance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 9
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Percent Received"
    type: "java.math.BigDecimal"
    propertyName: "FYTDPercentReceived"
    propertyPath: null
    entityName: "RevenueAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "PERCENT"
    source: "METHOD"
    label: "FYTD Percent Receivable"
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDPercentReceived"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 10
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fund"
    type: "java.lang.String"
    propertyName: "fund"
    propertyPath: "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: "code.fund"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 11
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Receipt"
    type: "java.lang.String"
    propertyName: "receipt"
    propertyPath: "code"
    entityName: "RevenueCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Receipt"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.receipt"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 12
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Receipt One Digit Level"
    type: "java.lang.String"
    propertyName: "receiptOneDigitLevel"
    propertyPath: "code"
    entityName: "RevenueCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Receipt One Digit Level"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.receiptOneDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 13
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Receipt Two Digit Level"
    type: "java.lang.String"
    propertyName: "receiptTwoDigitLevel"
    propertyPath: "code"
    entityName: "RevenueCode"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Receipt Two Digit Level"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.receiptTwoDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 14
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "SCC"
    type: "java.lang.String"
    propertyName: "scc"
    propertyPath: "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: "code.scc"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 15
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Subject"
    type: "java.lang.String"
    propertyName: "subject"
    propertyPath: "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: "code.subject"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 16
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Subject Two Digit Level"
    type: "java.lang.String"
    propertyName: "subjectTwoDigitLevel"
    propertyPath: "code"
    entityName: "RevenueCode"
    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: "code.subjectTwoDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 17
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "OPU"
    type: "java.lang.String"
    propertyName: "opu"
    propertyPath: "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: "code.opu"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 18
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Opu One Digit Level"
    type: "java.lang.String"
    propertyName: "opuOneDigitLevel"
    propertyPath: "code"
    entityName: "RevenueCode"
    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: "code.opuOneDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 19
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Forecast Line#"
    type: "java.lang.String"
    propertyName: "forecastLineNumber"
    propertyPath: "forecastRecord.odeLineNumber"
    entityName: "ODELineNumber"
    sortOrder: 0
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "METHOD"
    label: "Forecast Line#"
    columnTitle: "Forecast Line#"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "forecastRecord.odeLineNumber.forecastLineNumber"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "forecastRecord"
      - "odeLineNumber"
    columnOrder: 20
    suppressRepeating: false
    permission: null