UPDATE VS4TBank SET TBnkCode='TBANK' WHERE TBnkCode='TNBC'
GO

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


UPDATE VS4TFRColumn SET TFRCTBnkCode='TBANK' WHERE TFRCTBnkCode='TNBC'
GO
UPDATE VS4TFRRow SET TFRRTBnkCode='TBANK' WHERE TFRRTBnkCode='TNBC'
GO

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

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








