DELETE FROM VS4TBankPattern WHERE TBnPCode='KBANK-PV'
GO

DELETE FROM VS4TBankPattern WHERE TBnPCode='TMB-PV'
GO

INSERT INTO VS4TBankPattern
           (TBnPCode
           ,TBnPTBnkCode
           ,TBnPType
           ,TBnPTCBBNo
           ,TBnPName
           ,TBnPUploadCode
           ,TBnPUploadCustom1
           ,TBnPPatternFile
           ,TBnPOutputFile
           ,TBnPFlag1)
     VALUES
           ('KBANK-FTL'
           ,'KBANK'
           ,0
           ,''
           ,''
           ,''
           ,''
           ,'KBANK-FTL.PAT'
           ,'KBANK-FTL.TXT'
           ,1)
GO

INSERT INTO VS4TBankPattern
           (TBnPCode
           ,TBnPTBnkCode
           ,TBnPType
           ,TBnPTCBBNo
           ,TBnPName
           ,TBnPUploadCode
           ,TBnPUploadCustom1
           ,TBnPPatternFile
           ,TBnPOutputFile
           ,TBnPFlag1)
     VALUES
           ('KBANK-MCL'
           ,'KBANK'
           ,0
           ,''
           ,''
           ,''
           ,''
           ,'KBANK-MCL.PAT'
           ,'KBANK-MCL.TXT'
           ,1)
GO

INSERT INTO VS4TBankPattern
           (TBnPCode
           ,TBnPTBnkCode
           ,TBnPType
           ,TBnPTCBBNo
           ,TBnPName
           ,TBnPUploadCode
           ,TBnPUploadCustom1
           ,TBnPPatternFile
           ,TBnPOutputFile
           ,TBnPFlag1)
     VALUES
           ('TMB-MCL'
           ,'TMB'
           ,0
           ,''
           ,''
           ,''
           ,''
           ,'TMB-MCL.PAT'
           ,'TMB-MCL.TXT'
           ,1)
GO

INSERT INTO VS4TBankPattern
           (TBnPCode
           ,TBnPTBnkCode
           ,TBnPType
           ,TBnPTCBBNo
           ,TBnPName
           ,TBnPUploadCode
           ,TBnPUploadCustom1
           ,TBnPPatternFile
           ,TBnPOutputFile
           ,TBnPFlag1)
     VALUES
           ('TMB-DCR'
           ,'TMB'
           ,0
           ,''
           ,''
           ,''
           ,''
           ,'TMB-DCR.PAT'
           ,'TMB-DCR.TXT'
           ,1)
GO