UPDATE VS4TBank SET TBnkCode='BOC' WHERE TBnkCode='CNB'
GO

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


UPDATE VS4TFRColumn SET TFRCTBnkCode='BOC' WHERE TFRCTBnkCode='CNB'
GO
UPDATE VS4TFRRow SET TFRRTBnkCode='BOC' WHERE TFRRTBnkCode='CNB'
GO

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

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








