update vs4tpayment set tpymtpytalias='COUPON' WHERE tpymtpytalias='CHANGECOUPON' or tpymtpytalias='VOUCHER'
GO
update vs4tpayment set tpymtpytalias='CREDIT' WHERE tpymtpytalias='ARREAR'
GO
update vs4tpayment set tpymcode='CRED' WHERE tpymcode='ARRE'
GO
update vs4tpayment set tpymtpytalias='CREDIT' WHERE tpymcode='ARRE' or tpymcode='CRED'
GO
update vs4tpayment set tpymcode='THB' WHERE tpymcode='BHT'
GO
