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

Training 5 - Script to Add Transfers to all stores

    Details

    • Sprint:
      CFAMX 2020R3 Sprint 4
    • SCRUM Team:
      Brotherhood of Mutants
    • Story Points:
      2
    • Work Type Classification:
      Sustaining

      Description

      The initial script to create transfers was foiled by the Cloning process, so we have to rethink our plan (Original CFAMX-8869)

      We need a script that inserts transfers into all store, some summary details:

      • Two transfers per store
      • One transfer should be for 1/15/20 and should not be Received
      • One transfer should be for 1/16/20 and should be Received
      • For both transfers:
        • The sending store should NOT be the Receiving store
        • The Created by User, should be any a user within the db, NOT one of the InFORM.Training Users
        • Each transfer should contain at least two items, and each item should have a quantity than it greater than two
        • I believe that the items used in CFAMX-8869 are good, but the quantities need to be increased to support partial declines, once R3 is deployed into the Training environment

        Attachments

        1. CFA Training5 InsertTransfer.sql
          27 kB
          Stacy Privalova
        2. InsertTransfer.sql
          27 kB
          David Nayyar

          Issue Links

            Activity

              People

              • Assignee:
                stacy.privalova Stacy Privalova
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 6h
                  6h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4.5h Time Not Required
                  4.5h

                    PagerDuty

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