UPDATE VS4TBank SET TBnkCode='BNPP' WHERE TBnkCode='BNP'
GO

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


UPDATE VS4TFRColumn SET TFRCTBnkCode='BNPP' WHERE TFRCTBnkCode='BNP'
GO
UPDATE VS4TFRRow SET TFRRTBnkCode='BNPP' WHERE TFRRTBnkCode='BNP'
GO

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

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








