P

  • Payment Details
    Select Distinct ISNULL(PD.PD_ID, 0) PaymentID, Inv.Inv_Id INVID, Inv.Inv_No, Format(Inv.Inv_Date, 'dd/MMM/yyyy') InvDate, Invd.Invd_Price, Format(PD.PD_CreatedDate, '') ReceivedDate, DateDiff(DAY, Inv.Inv_Date, GetDate()) InvTAT, MS.STAFF_NAME UserName, PT.Response_TransactionId TransID, PT.Response_TransactionDate TransDate, PT.PaymentType ...