Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-15785

CloudLink - Update 'RetrieveAndRefund' Transactions to capture linked Transaction

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Sprint:
      2021.R6 CloudLink Sprint 3
    • SCRUM Team:
      Globogym Purple Cobras
    • Story Points:
      2
    • Work Type Classification:
      Sustaining

      Description

      We need to link the Transaction that's being refunded by populating the PluCodeId in the 'F', 'Refunds' record

      It appears as though this Transaction ID will be stored in OtherInfo2 in tbTransactionControlnfo:

      select top 100 tci.TransactionControlInfoId, ci.ControlInfo, tci.ControlInfoAmount, tci.RegisterNumber, tci.ClerkID, tci.ClerkName, tci.TransactionDate, tci.OtherInfo3, tci.POSTransactionID
      from tbTransactionControlInfo as tci with (nolock) 
      join tbControlInfo as ci with (nolock)  on tci.ControlInfoId = ci.ControlInfoId
      where ci.ControlInfo = 'RetrieveandRefund'
      order by 1 desc
      

      We'll need to populate the PluCodeId using the "transactionLink" JSON field:

      "transactionLink": 1439
      

      Regards,
      Brent

        Attachments

        1. screenshot-2.png
          screenshot-2.png
          75 kB
        2. screenshot-1.png
          screenshot-1.png
          35 kB
        3. RefundWithTax.txt
          68 kB
        4. Refund.txt
          57 kB

          Issue Links

            Activity

              People

              • Assignee:
                Gareth.Leibbrandt Gareth Leibbrandt (Inactive)
                Reporter:
                brent.jacobz Brent Jacobz (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4.5h
                  4.5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h 50m Time Not Required
                  3h 50m

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.