Uploaded image for project: 'mod-finance-storage'
  1. mod-finance-storage
  2. MODFISTO-188

Update Ledger schema with new Financial information

    XMLWordPrintable

Details

    • ACQ Sprint 105
    • 1
    • Thunderjet

    Description

      Purpose/Overview:
      In order to support UIF-261

      Requirements/Scope:

      1. Addition set of fields need to be added.

      Approach:
      Update schema mod-finance/schemas/ledger.json with new fields:

      Financial information

      1. initialAllocation(readOnly) - The amount of the first allocation made to this budget (Summary of all related budgets)
      2. allocationTo(readOnly) - The sum of all allocation transaction amounts made TO this budget not including the Initial allocation (Summary of all related budgets)
      3. allocationFrom(readOnly) - The sum of all allocation transaction amounts made FROM this budget not including the Initial allocation (Summary of all related budgets)
      4. totalFunding(readOnly) - budget.allocated + budget.netTransfers (Summary of all related budgets)
      5. cashBalance(readOnly) - Total Funding minus Expended (Summary of all related budgets)
      6. availableBalance(readOnly) - Total Funding minus Unavailable (Summary of all related budgets)
      Note : A possible improvement is moving these fields to a separate container "financialInformation"

      Financial activity & overages

      1. encumbered(readOnly) - The sum of all encumbrance transaction amounts (Summary of all related budgets)
      2. awaitingPayment(readOnly) - The sum of all pending payment amounts (Summary of all related budgets)
      3. expenditures(readOnly) - The sum of all Payment amounts less credits (Summary of all related budgets)
      4. overEncumbrance(readOnly) - The total amount encumbered minus the Total funding (Summary of all related budgets)
      5. overExpended(readOnly) - The total amount expended minus the Total funding (Summary of all related budgets)

      Acceptance criteria:

      • Schema updated

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Andrei_Makaranka Andrei Makaranka
                Andrei_Makaranka Andrei Makaranka
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases