UPDATE VS4TPayment SET TPymTPyTAlias='MISC' Where TPymTPyTAlias='OTHER'
GO
UPDATE VS4TPaymenttype SET TPyTGroupSum=7 Where TPyTGroupSum=8 or TPyTGroupSum=6
GO
UPDATE VS4TARVoucherPay SET  TRVRReceiveType='MISC' Where TRVRReceiveType='OTHER'
GO
UPDATE VS4TARInvoicePay SET  TIPyReceiveType='MISC' Where TIPyReceiveType='OTHER'
GO
UPDATE VS4TAPVoucherPay SET  TPVPPaymentType='MISC' Where TPVPPaymentType='OTHER'
GO
UPDATE VS4TAPInvoicePay SET  TPIPPaymentType='MISC' Where TPIPPaymentType='OTHER'
GO
UPDATE VS4TPaymenttype SET TPyTAlias='DEDUCT',TPyTName2='Deduct',TPyTDescription='หักหนี้',TPyTName='หักหนี้' Where TPyTAlias='OTHER'
GO
