Modify DB amount/currency fields from 2 decimal point scale to 4

[elnyry-sam-k]

Goal:

As a Hub Operator
I want to support the maximum precision as specified in the API Definition along with enforcing precision based on currency
so that requests with input values for amounts that only conform to the conditions based on currency are accepted and the others are rejected (via error callbacks)

Tasks:

• Analyze ISO 4217 against current currency.js seeds [@ggrg]
• Modify DB amount/currency fields from 2 decimal point precision to 4 [@ggrg]
  • 6 tables affected e3a5644 [@ggrg]
• Modify central-ledger.currency table to store currency scale [@ggrg]
  • Add data migration script (non-optional) to populate data from ISO 4217 [@ggrg]
• Ensure 4 scale amounts are propagated properly throughout the system for:
  • PrepareHandler (transfer, transferParticipant) [@ggrg]
  • PositionHandler (participantPosition, participantPositionChange) [@ggrg]
  • Limit adjustment (participantLimit) [@ggrg]
  • Create settlement, settlement transfer (settlementTransferParticipant, settlementParticipantCurrency) [@ggrg]
  • Verify FundsIn, FundsOut operations [@ggrg]
• Fix issues with JavaScript math: parseFloat((a + b).toFixed(Config.AMOUNT.SCALE)) [@ggrg]
• Fix issues with non-updated participantPosition.changedDate [@ggrg]
• Fix unit tests according to the changes above [@ggrg] a1f5b39
• Ensure no trailing zeros are returned with responses and callbacks
• Implement & enforce currency decimal point precision validation in Prepare handler

Acceptance Criteria:

• Unit Tests pass
• Integration Tests pass
• Changes made to config (default.json) are broadcast to team and follow-up tasks added to update helm charts and other deployment config.
• The DB supports max precision of 4 digits as specified in the API Definition v1.0
• Validation based on currency for precision is put in place (error callbacks)

Pull Requests:

• Feature/949 Change Scale to decimal(18,4) central-ledger#367

Follow-up:

• N/A

Dependencies:

• N/A

Accountability:

• Owner: TBC
• QA/Review: TBC