UPDATE VS4TBank SET TBnkTTCode='001' WHERE TBnkCode='BOT'
GO
UPDATE VS4TBank SET TBnkTTCode='002' WHERE TBnkCode='BBL'
GO
UPDATE VS4TBank SET TBnkTTCode='004' WHERE TBnkCode='KBANK'
GO
UPDATE VS4TBank SET TBnkTTCode='005' WHERE TBnkCode='RBS'
GO
UPDATE VS4TBank SET TBnkTTCode='006' WHERE TBnkCode='KTB'
GO
UPDATE VS4TBank SET TBnkTTCode='008' WHERE TBnkCode='JPM'
GO
UPDATE VS4TBank SET TBnkTTCode='011' WHERE TBnkCode='TMB'
GO
UPDATE VS4TBank SET TBnkTTCode='014' WHERE TBnkCode='SCB'
GO
UPDATE VS4TBank SET TBnkTTCode='017' WHERE TBnkCode='CITI'
GO
UPDATE VS4TBank SET TBnkTTCode='018' WHERE TBnkCode='SMBC'
GO
UPDATE VS4TBank SET TBnkTTCode='020' WHERE TBnkCode='SCBT'
GO
UPDATE VS4TBank SET TBnkTTCode='022' WHERE TBnkCode='CIMBT'
GO
UPDATE VS4TBank SET TBnkTTCode='024' WHERE TBnkCode='UOB'
GO
UPDATE VS4TBank SET TBnkTTCode='025' WHERE TBnkCode='BAY'
GO
UPDATE VS4TBank SET TBnkTTCode='026' WHERE TBnkCode='MEGA'
GO
UPDATE VS4TBank SET TBnkTTCode='027' WHERE TBnkCode='BA'
GO
UPDATE VS4TBank SET TBnkTTCode='030' WHERE TBnkCode='GSB'
GO
UPDATE VS4TBank SET TBnkTTCode='031' WHERE TBnkCode='HSBC'
GO
UPDATE VS4TBank SET TBnkTTCode='032' WHERE TBnkCode='DB'
GO
UPDATE VS4TBank SET TBnkTTCode='033' WHERE TBnkCode='GHB'
GO
UPDATE VS4TBank SET TBnkTTCode='034' WHERE TBnkCode='BAAC'
GO
UPDATE VS4TBank SET TBnkTTCode='039' WHERE TBnkCode='MHBC'
GO
UPDATE VS4TBank SET TBnkTTCode='045' WHERE TBnkCode='BNPP'
GO
UPDATE VS4TBank SET TBnkTTCode='052' WHERE TBnkCode='BOC'
GO
UPDATE VS4TBank SET TBnkTTCode='065' WHERE TBnkCode='TBANK'
GO
UPDATE VS4TBank SET TBnkTTCode='066' WHERE TBnkCode='IBANK'
GO
UPDATE VS4TBank SET TBnkTTCode='067' WHERE TBnkCode='TISCO'
GO
UPDATE VS4TBank SET TBnkTTCode='069' WHERE TBnkCode='KK'
GO
UPDATE VS4TBank SET TBnkTTCode='070' WHERE TBnkCode='ICBC'
GO
UPDATE VS4TBank SET TBnkTTCode='071' WHERE TBnkCode='TCRB'
GO
UPDATE VS4TBank SET TBnkTTCode='073' WHERE TBnkCode='LH'
GO
UPDATE VS4TBank SET TBnkTTCode='079' WHERE TBnkCode='ANZ'
GO


UPDATE VS4TBank SET TBnkTTCode='073' WHERE TBnkCode='LHBANK'
GO
UPDATE VS4TBank SET TBnkTTCode='065' WHERE TBnkCode='TNCN'
GO
UPDATE VS4TBank SET TBnkTTCode='065' WHERE TBnkCode='TNCB'
GO
UPDATE VS4TBank SET TBnkTTCode='017' WHERE TBnkCode='CTB'
GO
