UPDATE VS4TBank SET TBnkCode='TCRB' WHERE TBnkCode='TTCR'
GO

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


UPDATE VS4TFRColumn SET TFRCTBnkCode='TCRB' WHERE TFRCTBnkCode='TTCR'
GO
UPDATE VS4TFRRow SET TFRRTBnkCode='TCRB' WHERE TFRRTBnkCode='TTCR'
GO

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

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








