HOW TO RETRIEVE DOCUMENT REFERENCE:

  • 172.31.0.40
  • RUN THE SCRIPT: 

    SELECT TOP (1000) [IntRef]

          ,[StationRef]

          ,[IDNo]                            ENTER ID OF THE CLIENT WHO NEEDS THE APPLICATION

          ,[IDNoCheck]

          ,[ScanDate]

          ,[Uploaded]

          ,[PaymentMethodRef]

          ,[ProductRef]

          ,[ApplicationForm]

          ,[IDDocument]

          ,[SalarySlip]

          ,[Other]

          ,[UserRef]

          ,[Record_Lock_Date]

          ,[Deleted]

          ,[POS_Deletion_List_Ref]

      FROM [Edu-Dss].[dbo].[Document] d

      where d.idno = '6906010425082'