UPDATE VS4TBank SET TBnkCode='MEGA' WHERE TBnkCode='MIC'
GO

UPDATE VS4TAPBank SET TAPBTBnkCode='MEGA' WHERE TAPBTBnkCode='MIC'
GO
UPDATE VS4TBankCardFee SET TBCFTBnkCode='MEGA' WHERE TBCFTBnkCode='MIC'
GO
UPDATE VS4TBankCheque SET TBCqTBnkCode='MEGA' WHERE TBcqTBnkCode='MIC'
GO
UPDATE VS4TBankSlip SET TBSLTBnkCode='MEGA' WHERE TBSLTBnkCode='MIC'
GO
UPDATE VS4TCompanyBank SET TCBBTBnkCode='MEGA' WHERE TCBBTBnkCode='MIC'
GO
UPDATE VS4TEmployeeBank SET TEmBTBnkCode='MEGA' WHERE TEmBTBnkCode='MIC'
GO
UPDATE VS4TBankPattern SET TBnPTBnkCode='MEGA' WHERE TBnPTBnkCode='MIC'
GO
UPDATE VS4TARBank SET TARBTBnkCode='MEGA' WHERE TARBTBnkCode='MIC'
GO
UPDATE VS4TBankBranch SET TBBrTBnkCode='MEGA' WHERE TBBrTBnkCode='MIC'
GO


UPDATE VS4TFRColumn SET TFRCTBnkCode='MEGA' WHERE TFRCTBnkCode='MIC'
GO
UPDATE VS4TFRRow SET TFRRTBnkCode='MEGA' WHERE TFRRTBnkCode='MIC'
GO

UPDATE VS4TChequeRec SET TCHRChqDepTBnkCode='MEGA' WHERE TCHRTBnkCode='MIC'
GO
UPDATE VS4TChequeRec SET TCHRTBnkCode='MEGA' WHERE TCHRTBnkCode='MIC'
GO
UPDATE VS4TChequeRec2IV SET TR2ITBnkCode='MEGA' WHERE TR2ITBnkCode='MIC'
GO
UPDATE VS4TChequeRec2POS SET TR2PTBnkCode='MEGA' WHERE TR2PTBnkCode='MIC'
GO
UPDATE VS4TChequeRec2RV SET TR2RTBnkCode='MEGA' WHERE TR2RTBnkCode='MIC'
GO
UPDATE VS4TChequeSub SET TCHSTBnkCode='MEGA' WHERE TCHSTBnkCode='MIC'
GO
UPDATE VS4TChequeSub2IV SET TS2ITBnkCode='MEGA' WHERE TS2ITBnkCode='MIC'
GO
UPDATE VS4TChequeSub2PV SET TS2PTBnkCode='MEGA' WHERE TS2PTBnkCode='MIC'
GO

UPDATE VS4TExchangeRate SET TExRTBnkCode='MEGA' WHERE TExRTBnkCode='MIC'
GO
UPDATE VS4TEmpSlipDoc SET TEpsTBnkCode='MEGA' WHERE TEpsTBnkCode='MIC'
GO
UPDATE VS4TPOSTransPay SET TPPyTBnkCode='MEGA' WHERE TPPyTBnkCode='MIC'
GO
UPDATE VS4TARInvoicePay SET TIPyTBnkCode='MEGA' WHERE TIPyTBnkCode='MIC'
GO
UPDATE VS4TAPInvoicePay SET TPIPTBnkCode='MEGA' WHERE TPIPTBnkCode='MIC'
GO
UPDATE VS4TAPVoucherPay SET TPVPTBnkCode='MEGA' WHERE TPVPTBnkCode='MIC'
GO
UPDATE VS4TARVoucherPay SET TRVRTBnkCode='MEGA' WHERE TRVRTBnkCode='MIC'
GO
UPDATE VS4TCashDeposit SET TDPSTBnkCode='MEGA' WHERE TDPSTBnkCode='MIC'
GO
UPDATE VS4TGLTransSub SET TGTSTBnkCode='MEGA' WHERE TGTSTBnkCode='MIC'
GO








