---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "Information used for uploading to a third party five year forecasting\
    \ company"
  tags: "Reports group"
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Revenue Account Activity Report"
    suppressDetail: false
    showOptions: false
    sortProperties: !<java.util.ArrayList> []
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Revenue Account Activity Report"
  querySpecification:
    specification: "date.ge param(\"start\", \"p\", \"Start Date\")\ndate.le param(\"\
      end\", \"d\", \"End Date\")\naccount.fullAccountCode.oneOf ([param(\"includeaccount.fullAccountCode\"\
      ,'',\"Full Account Code (i.e. 006-1512-0000-000000-000)\")])\naccount.code.fund.like\
      \ param(\"includeaccount.code.fund\",\"\",\"Include Fund (use % for wildcard)\"\
      )\naccount.code.receipt.like param(\"includeaccount.code.receipt\",\"\",\"Include\
      \ Receipt (use % for wildcard)\")\naccount.code.scc.like param(\"includeaccount.code.scc\"\
      ,\"\",\"Include SCC (use % for wildcard)\")\naccount.code.subject.like param(\"\
      includeaccount.code.subject\",\"\",\"Include Subject (use % for wildcard)\"\
      )\naccount.code.opu.like param(\"includeaccount.code.opu\",\"\",\"Include OPU\
      \ (use % for wildcard)\")\naccount.filter.eq param(\"Filter Name\",\"\")\nasOfPeriod.eq\
      \ param(\"asOfPeriod\",\"\",\"Total As of Period (If a date is specified FYTD\
      \ amounts will be calculated as of that period. The End Date parameter should\
      \ be the last day of the period month.)\")\nreceivedAmount.notNull() "
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.generalLedger.ActivityLedger"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: "account"
    entityName: "Account"
    sortOrder: 1
    controlBreak: true
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Full Account Code"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 36
    relativePropertyName: "account.fullAccountCode"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
    columnOrder: 1
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Description"
    type: "java.lang.String"
    propertyName: "description"
    propertyPath: "account"
    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: "account.description"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
    columnOrder: 2
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Forecast Line#"
    type: "java.lang.String"
    propertyName: "forecastLineNumber"
    propertyPath: "account.forecastRecord.odeLineNumber"
    entityName: "ODELineNumber"
    sortOrder: 1
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: "Forecast Line#"
    columnTitle: "Forecast Line#"
    alignment: "LEFT"
    controlHeaderOnly: true
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 25
    relativePropertyName: "account.forecastRecord.odeLineNumber.forecastLineNumber"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "forecastRecord"
      - "odeLineNumber"
    columnOrder: 3
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Month"
    type: "java.lang.Integer"
    propertyName: "month"
    propertyPath: "postingPeriod"
    entityName: "PostingPeriod"
    sortOrder: 2
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NATURALID"
    source: "FIELD"
    label: ""
    columnTitle: "Month"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "postingPeriod.month"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "postingPeriod"
    columnOrder: 4
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Month Name"
    type: "java.lang.String"
    propertyName: "monthName"
    propertyPath: "postingPeriod"
    entityName: "PostingPeriod"
    sortOrder: 2
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: ""
    columnTitle: "Month"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "postingPeriod.monthName"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "postingPeriod"
    columnOrder: 5
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Description"
    type: "java.lang.String"
    propertyName: "description"
    propertyPath: "receiptItem"
    entityName: "ReceiptItem"
    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: 25
    relativePropertyName: "receiptItem.description"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "receiptItem"
    columnOrder: 6
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Received Amount"
    type: "java.math.BigDecimal"
    propertyName: "receivedAmount"
    propertyPath: null
    entityName: "ActivityLedger"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "FIELD"
    label: null
    columnTitle: "Amount"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "receivedAmount"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 7
    suppressRepeating: false