3 Replies Latest reply: May 3, 2013 1:26 PM by Anders Moller RSS

    generate flags in the table after treatment

      Hello community, I need help on this issue below

       

       

      ID_DOCID_CD_MOVDATEVLFLAG
      80425890101/1/20121500
      80425890102/1/20121500
      80425890104/1/20121500x
      80425890104/1/20121700x
      80425890114/1/2012-1500x
      80425890114/1/2012-1700x
      80425890104/2/20121500
      80425890104/2/20121700
      1006350105/1/20121500x
      1006350115/1/2012-1500x
      1006350105/2/20121500

       

      I have a table of payments, where I have a table of payments, where ID_CD_MOV = 10 (Payments done) and ID_CD_MOV = 11 (Payments reversed).

       

      I have a table of payments, where my problem must disregard the payments reversed and disregard previous payments related to the reversal, as they have done again after receiving the cancelation

       

      The table clearly shows what I need, the flag field does not exist in the database, just put as a reference to the need

       

      Thanks