Uploaded image for project: 'OSCAR'
  1. OSCAR
  2. OS-7932

All Alerts to work for SFG SKUs

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Task
    • Resolution: Closed
    • Medium
    • 5.2
    • None
    • IO
    • None

    Description

      1. Add the Below column in web.[SR_ALERT_APIDP] table

      Pickup_Point varchar(50)
      Forwarder varchar(50) 
      Type_of_Routing varchar(20) 
      LDPG_Plant_Description varchar(100) 
      Shipping_Country varchar(100) 
      Manufacturing_Country varchar(100)
      Flow_Type varchar(100) 
      Physical_Flow_Type varchar(100)

      P2EHMC VARCHAR(50)
      P2EHC VARCHAR(50)
      P2EMC VARCHAR(50)
      P2EAC VARCHAR(50)
      SHSV VARCHAR(50)
      O2ARO VARCHAR(50)
      SSVV    varchar(20)
      SOTPVT    varchar(20)

      2. Add the above column in Job SP's to update the values in web.[SR_ALERT_APIDP]

      Attachments

        Activity

          People

            ATHISM01 Athisiva Arunachalam, Mohanakrishnan
            RKAMAR R Kamath, Rahul
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 3 days
                3d
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day Time Not Required
                1d