---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "Financial detail that sorts by fund then SCC code and has full account\
    \ codes in individual columns. Has the current month's beginning and ending balances "
  tags: null
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Financial Detail Report"
    suppressDetail: false
    showOptions: false
    sortProperties: !<java.util.ArrayList> []
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Financial Detail Report"
  querySpecification:
    specification: "date.ge param(\"startDate\",\"p\",\"Start Date\")\ndate.le param(\"\
      endDate\",\"d\",\"End Date\")\naccount.fullAccountCode.oneOf ([param(\"includeAccts\"\
      ,'',\"Include Full Account Code(s)\")])\naccount.fullAccountCode.notOneOf ([param(\"\
      excludeAccts\",'',\"Exclude Full Account Code(s)\")])\naccount.code.fund.like\
      \ param(\"includeFund\",\"\",\"Include Fund\")\naccount.code.func.like param(\"\
      includeFunc\",\"\",\"Include Func\")\naccount.code.receipt.like param(\"includeRcpt\"\
      ,\"\",\"Include Rcpt\")\naccount.code.object.like param(\"includeObj\",\"\"\
      ,\"Include Obj\")\naccount.code.scc.like param(\"includeSCC\",\"\",\"Include\
      \ SCC\")\naccount.code.subject.like param(\"includeSubj\",\"\",\"Include Subj\"\
      )\naccount.code.opu.oneOf ([param(\"includeOpu\",\"\",\"Include Opu\")])\naccount.code.il.like\
      \ param(\"includeIL\",\"\",\"Include IL\")\naccount.code.job.like param(\"includeJob\"\
      ,\"\",\"Include Job\")\ntype.oneOf (['Disb','Ref','Rec','Payroll','TA_In','TA_Out','Dist'])\n\
      cashAccount.fullAccountCode.oneOf ([param(\"includeCashAccts\",'',\"Include\
      \ Cash Account(s) i.e 000-0000\")])\naccount.filter.eq param(\"filter\",\"\"\
      ,\"Filter\")\nasOfPeriod.eq param(\"asOfPeriod\",\"\",\"Report for a specific\
      \ posting period (blank means current period). A date or a shortcut can be used\"\
      )"
    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: "cashAccount"
    entityName: "Account"
    sortOrder: 3
    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: "cashAccount.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "cashAccount"
    columnOrder: 1
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Date"
    type: "java.util.Calendar"
    propertyName: "date"
    propertyPath: null
    entityName: "ActivityLedger"
    sortOrder: 4
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "CALENDAR"
    source: "FIELD"
    label: ""
    columnTitle: null
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 24
    relativePropertyName: "date"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 2
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Check #"
    type: "java.lang.Integer"
    propertyName: "checkNumber"
    propertyPath: null
    entityName: "ActivityLedger"
    sortOrder: 5
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: "Check #"
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 18
    relativePropertyName: "checkNumber"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 3
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Receipt #"
    type: "java.lang.Integer"
    propertyName: "number"
    propertyPath: "receiptItem.receipt"
    entityName: "Receipt"
    sortOrder: 5
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: "Receipt #"
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 18
    relativePropertyName: "receiptItem.receipt.number"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "receiptItem"
      - "receipt"
    columnOrder: 4
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "PO #"
    type: "java.lang.Integer"
    propertyName: "poNumber"
    propertyPath: null
    entityName: "ActivityLedger"
    sortOrder: 5
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: "PO #"
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 18
    relativePropertyName: "poNumber"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 5
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Vendor #"
    type: "java.lang.Integer"
    propertyName: "number"
    propertyPath: "vendor"
    entityName: "Vendor"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: "Vendor #"
    columnTitle: "Vendor #"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 17
    relativePropertyName: "vendor.number"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "vendor"
    columnOrder: 6
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Primary Name"
    type: "java.lang.String"
    propertyName: "primaryName"
    propertyPath: "vendor"
    entityName: "Vendor"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Vendor Name"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 32
    relativePropertyName: "vendor.primaryName"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "vendor"
    columnOrder: 7
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Item Description"
    type: "java.lang.String"
    propertyName: "itemDescription"
    propertyPath: null
    entityName: "ActivityLedger"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: ""
    columnTitle: "Desc."
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 50
    relativePropertyName: "itemDescription"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: "account"
    entityName: "Account"
    sortOrder: 4
    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: "account.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "account"
    columnOrder: 9
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Transaction Indicator"
    type: "java.lang.String"
    propertyName: "transactionIndicator"
    propertyPath: "account.code"
    entityName: "AccountCode"
    sortOrder: 3
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "METHOD"
    label: ""
    columnTitle: "TI"
    alignment: "CENTER"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "account.code.transactionIndicator"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 10
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fund"
    type: "java.lang.String"
    propertyName: "fund"
    propertyPath: "account.code"
    entityName: "AccountCode"
    sortOrder: 2
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    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: 11
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Func"
    type: "java.lang.String"
    propertyName: "func"
    propertyPath: "account.code"
    entityName: "AppropriationCode"
    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.code.func"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 12
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Receipt"
    type: "java.lang.String"
    propertyName: "receipt"
    propertyPath: "account.anticipatedRevenue.code"
    entityName: "AnticipatedRevenueCode"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Receipt"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 12
    relativePropertyName: "account.anticipatedRevenue.code.receipt"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "anticipatedRevenue"
      - "code"
    columnOrder: 13
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Object"
    type: "java.lang.String"
    propertyName: "object"
    propertyPath: "account.code"
    entityName: "AppropriationCode"
    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.code.object"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 14
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "SCC"
    type: "java.lang.String"
    propertyName: "scc"
    propertyPath: "account.code"
    entityName: "AccountCode"
    sortOrder: 3
    controlBreak: true
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    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: 15
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Subject"
    type: "java.lang.String"
    propertyName: "subject"
    propertyPath: "account.code"
    entityName: "AnticipatedRevenueCode"
    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: 18
    relativePropertyName: "account.code.subject"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 16
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Opu"
    type: "java.lang.String"
    propertyName: "opu"
    propertyPath: "account.code"
    entityName: "AnticipatedRevenueCode"
    sortOrder: 1
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    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: 17
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "IL"
    type: "java.lang.String"
    propertyName: "il"
    propertyPath: "account.code"
    entityName: "AppropriationCode"
    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.code.il"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 18
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Job"
    type: "java.lang.String"
    propertyName: "job"
    propertyPath: "account.code"
    entityName: "AppropriationCode"
    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.code.job"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "account"
      - "code"
    columnOrder: 19
    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: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 32
    relativePropertyName: "receivedAmount"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 20
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Expended Amount"
    type: "java.math.BigDecimal"
    propertyName: "expendedAmount"
    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: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 32
    relativePropertyName: "expendedAmount"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 21
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Beginning Period Balance"
    type: "java.math.BigDecimal"
    propertyName: "beginningPeriodBalance"
    propertyPath: "cashAccount"
    entityName: "CashAccount"
    sortOrder: 3
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: ""
    columnTitle: "Beginning Period Balance"
    alignment: "RIGHT"
    controlHeaderOnly: true
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 32
    relativePropertyName: "cashAccount.beginningPeriodBalance"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "cashAccount"
    columnOrder: 22
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fund Balance"
    type: "java.math.BigDecimal"
    propertyName: "currentFundBalance"
    propertyPath: "cashAccount"
    entityName: "CashAccount"
    sortOrder: 3
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "Fund Balance"
    columnTitle: "Ending Fund Balance"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: true
    detailHeaderOnly: false
    width: 32
    relativePropertyName: "cashAccount.currentFundBalance"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "cashAccount"
    columnOrder: 23
    suppressRepeating: true