---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "ActivityLedger Report"
  tags: null
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "SSDT Transfer Advance Activity with Repays"
    suppressDetail: false
    showOptions: true
    sortProperties: !<java.util.ArrayList>
    - !<java.util.ArrayList>
      propertyName: "cashAccount.fullAccountCode"
      label: "Full Account Code"
      ascending: true
      controlBreak: true
      pageBreak: false
    - propertyName: "date"
      label: "Date"
      ascending: true
      controlBreak: false
      pageBreak: false
    - propertyName: "account.fullAccountCode"
      label: "Full Account Code"
      ascending: true
      controlBreak: false
      pageBreak: false
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "SSDT Transfer Advance Activity with Repays"
  querySpecification:
    specification: "date.ge param(\"startDate\",\"\",\"Start Date\")\ndate.le param(\"\
      endDate\",\"\",\"End Date\")\ntype.oneOf (['TA_In','TA_Out'])\ninterFundCashTransaction.type.oneOf\
      \ ([param(\"type\",'',\"Transaction Type (Transfer, Advance, Repay_Advance)\"\
      )])\ncashAccount.fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"Fund-SCC\
      \ (i.e. 001-0000)\")])"
    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: 1
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Cash Account"
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 28
    relativePropertyName: "cashAccount.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "cashAccount"
    columnOrder: 1
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Transaction Number"
    type: "java.lang.Integer"
    propertyName: "transactionNumber"
    propertyPath: null
    entityName: "ActivityLedger"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: ""
    columnTitle: "Reference #"
    alignment: "CENTER"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 5
    relativePropertyName: "transactionNumber"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 2
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Date"
    type: "java.util.Calendar"
    propertyName: "date"
    propertyPath: null
    entityName: "ActivityLedger"
    sortOrder: 2
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "CALENDAR"
    source: "FIELD"
    label: ""
    columnTitle: null
    alignment: "CENTER"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 11
    relativePropertyName: "date"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 3
    suppressRepeating: false
    permission: null
  - !<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: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 20
    relativePropertyName: "itemDescription"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 4
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: "account"
    entityName: "Account"
    sortOrder: 4
    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: 28
    relativePropertyName: "account.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList>
      - "account"
    columnOrder: 5
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Type"
    type: "org.ssdt_ohio.usas.model.interfundcash.InterFundTransactionType"
    propertyName: "type"
    propertyPath: "interFundCashTransaction"
    entityName: "InterFundCashTransaction"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Type"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 10
    relativePropertyName: "interFundCashTransaction.type"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "interFundCashTransaction"
    columnOrder: 6
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Type"
    type: "org.ssdt_ohio.usas.model.interfundcash.InterFundTransactionType"
    propertyName: "type"
    propertyPath: "repayAdvance"
    entityName: "InterFundCashTransaction"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Type"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "repayAdvance.type"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "repayAdvance"
    columnOrder: 7
    suppressRepeating: false
    permission: null
  - !<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: 0
    relativePropertyName: "receivedAmount"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
    permission: null
  - !<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: 0
    relativePropertyName: "expendedAmount"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 9
    suppressRepeating: false
    permission: null