16 Replies Latest reply: Feb 6, 2014 10:40 AM by Deepak Mallick RSS

    URGENT HELP!!!

    Deepak Mallick

      Field Name

      Value

      SERIAL NUMBER

      Example - A12B34

      Contract Flag

      This field will have potentially 3 values

      C – Under contract based on Contract Start Date and Contract End Date

      N – No contract based on the same dates

      P – Used to have contracts but does not have any contracts now

      For example, the serial number A12B34, has a contract number 0012345678 , which has validity of 04/12/12 to 04/11/13, in this case, the flag will have P as this serial number does not have a contract right now but it used to have in the past.

       

      I got 'C and 'N' but unable to get the 'P'...How to achieve it....Thanks in advance!!!