DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'323',N'01323002',N'ABBank - An Binh',N'970425',N'ABBank - An Binh Commercial Joint Stock Bank',N'ABBank',NULL,N'ABBank - An Bình',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'664',N'01664001',N'ABC - Agricultural Bank of China HN',N'',N'ABC - Agricultural Bank of China Limited – Ha Noi Branch',N'ABC',NULL,N'ABC - Agricultural Bank of China – Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'307',N'79307001',N'ACB - A Chau',N'970416',N'ACB - Asia Commercial Joint Stock Bank',N'ACB',NULL,N'ACB - Á Châu',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'204',N'01204001',N'Agribank - Nong nghiep va PTNT VN',N'970405',N'Agribank - Vietnam Bank for Agriculture and Rural Development',N'Agribank',NULL,N'Agribank - Nông nghiệp và PTNT VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'602',N'01602002',N'ANZ VN',N'',N'ANZ Bank VN Limited',N'ANZ',NULL,N'ANZ VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'313',N'01313007',N'BacABank - Bac A',N'970409',N'BacABank - North Asia Commercial Joint Stock Bank',N'BacABank',NULL,N'BacABank - Bắc Á',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'359',N'01359001',N'BaoVietBank - Bao Viet',N'970438',N'BaoVietBank - Bao Viet Commercial Joint Stock Bank',N'BaoVietBank',NULL,N'BaoVietBank - Bảo Việt',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'638',N'01638001',N'BIDC - DT va PT Campuchia Ha Noi',N'',N'BIDC - Bank for Investment and Development of Cambodia - Ha Noi Branch',N'BIDC',NULL,N'BIDC - Đầu tư và Phát triển Campuchia Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'648',N'79648001',N'BIDC - DT va PT Campuchia HCM',N'',N'BIDC - Bank for Investment and Development of Cambodia - HCMC Branch',N'BIDC',NULL,N'BIDC - Đầu tư và Phát triển Campuchia HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'202',N'01202001',N'BIDV - DT va PT VN',N'970418',N'BIDV - Joint Stock Commercial Bank for Investment and Development of Vietnam',N'BIDV',NULL,N'BIDV - Đầu tư và Phát triển VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'660',N'79660001',N'BNK - Busan',NULL,N'BNK - Busan Bank',N'BNK',NULL,N'BNK - Busan',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'657',N'01657001',N'BNP - Paribas Ha Noi',N'',N'BNP Paribas - Ha Noi Branch',N'BNP',NULL,N'BNP - Paribas Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'614',N'79614001',N'BNP - Paribas HCM',N'',N'BNP Paribas - HCMC Branch',N'BNP',NULL,N'BNP - Paribas HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'620',N'79620001',N'BOCHK - Bank of China (Hongkong)',N'',N'BOCHK - Bank of China (Hongkong) Limited',N'BOCHK',NULL,N'BOCHK - Bank of China (Hongkong)',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'615',N'79615001',N'BOCOM - Bank of Communications',N'',N'BOCOM - Bank of Communications Limited',N'BOCOM',NULL,N'BOCOM - Bank of Communications',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'659',N'79659001',N'BOI - Bank of India',N'',N'BOI - Bank of India',N'BOI',NULL,N'BOI - Bank of India',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'339',N'80339001',N'CBBank - Xay dung',N'970444',N'CBBank - Construction Bank',N'CBBank',NULL,N'CBBank - Xây dựng',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'611',N'79611001',N'CCB - China Construction Bank',N'',N'CCB - China Construction Bank Corporation',N'CCB',NULL,N'CCB - China Construction Bank',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'661',N'01661001',N'CIMB VN',N'422589',N'CIMB Bank VN Limited',N'CIMB',NULL,N'CIMB VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'654',N'79654001',N'Citibank HCM',N'',N'Citibank VN - HCMC Branch',N'Citibank',NULL,N'Citibank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'605',N'01605001',N'Citibank Ha Noi',N'',N'Citibank VN - Hanoi Branch',N'Citibank',NULL,N'Citibank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'901',N'01901001',N'Co-op Bank - Hop tac xa VN',N'970446',N'Co-op Bank - Co-operative Bank of VN',N'Co-op Bank',NULL,N'Co-op Bank - Hợp tác xã VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'629',N'79629001',N'CTBC HCM',N'',N'CTBC Bank Co.,Ltd - HCMC Branch',N'CTBC',NULL,N'CTBC HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,NULL,N'49634001',N'CUBCL - Cathay United Bank Chu Lai',N'',N'CUBCL - Cathay United Bank - Chu Lai Branch',N'CUBCL',NULL,N'CUBCL - Cathay United Bank Chu Lai',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'650',N'79650001',N'DBS HCM',N'796500',N'DBS Bank Ltd - HCMC Branch',N'DBS',NULL,N'DBS HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,NULL,N'79668001',N'DGB - Daegu Bank HCM',N'',N'DGB - Daegu Bank - HCMC Branch',N'DGB',NULL,N'DGB - Daegu Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'304',N'79304001',N'DAB - Dong A',N'970406',N'DAB - East Asia Commercial Joint Stock Bank',N'DAB',NULL,N'DAB - Đông Á',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'658',N'75658001',N'ESB - E.Sun Bank Dong Nai',N'',N'ESB - E.SUN Commercial Bank Ltd. – Dong Nai Branch',N'ESB',NULL,N'ESB - E.Sun Bank Đồng Nai',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'305',N'79305001',N'Eximbank - Xuat nhap khau VN',N'970431',N'Eximbank - Vietnam Export Import Bank',N'Eximbank',NULL,N'Eximbank - Xuất nhập khẩu VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'608',N'01608001',N'First Commercial Bank Ha Noi',N'',N'First Commercial Bank - Ha Noi Branch',N'First Bank',NULL,N'First Bank - First Commercial Bank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'630',N'79630001',N'First Commercial Bank HCM',N'',N'First Commercial Bank - HCMC Branch',N'First Bank',NULL,N'First Bank - First Commercial Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'320',N'01320001',N'GPBank - Dau khi toan cau',N'970408',N'GPBank - Global Petro Commercial Joint Stock Bank',N'GPBank',NULL,N'GPBank - Dầu khí toàn cầu',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'321',N'79321001',N'HDBank - Phat trien TP HCM',N'970437',N'HDBank - HCMC Development Joint Stock Commercial Bank',N'HDBank',NULL,N'HDBank - Phát triển TP HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'603',N'79603001',N'HLBVN - Hong Leong Bank VN',N'970442',N'HLBVN - Hong Leong Bank Vietnam Limited',N'HLBVN',NULL,N'HLBVN - Hong Leong Bank VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'617',N'79617001',N'HSBC VN',N'458761',N'HSBC Private International Bank',N'HSBC',NULL,N'HSBC VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'640',N'79640001',N'HNCB - Hua Nan Bank HCM',N'',N'HNCB - Hua Nan Commercial Bank Ltd HCMC Branch',N'HNCB',NULL,N'HNCB - Hua Nan Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'641',N'79641001',N'Cong nghiep Han Quoc HCM',N'970456',N'Industrial Bank of Korea HCMC Branch',N'IBK Bank',NULL,N'IBK Bank - Công nghiệp Hàn Quốc HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'652',N'01652001',N'Cong nghiep Han Quoc Ha Noi',N'970455',N'Industrial Bank of Korea - Ha Noi Branch',N'IBK Bank',NULL,N'IBK Bank - Công nghiệp Hàn Quốc Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'649',N'01649001',N'ICBC - Cong thuong Trung Quoc',N'',N'ICBC - Industrial and Commercial Bank of China',N'ICBC',NULL,N'ICBC - Công thương Trung Quốc',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'502',N'79502001',N'IVB - Indovina Bank',N'970434',N'IVB - Indovina Bank Limited',N'IVB',NULL,N'IVB - Indovina Bank',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'627',N'79627001',N'JPM - JP Morgan Chase',N'',N'JPM - JP Morgan Chase Bank & Co.',N'JPM',NULL,N'JPM - JP Morgan Chase',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'626',N'01626001',N'Keb Hana Bank Ha Noi',N'',N'Keb HanaBank Ha Noi Branch',N'Keb Hana',NULL,N'Keb Hana Bank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'656',N'79656001',N'Keb Hana Bank HCM',N'',N'Keb HanaBank HCMC Branch',N'Keb Hana',NULL,N'Keb Hana Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'353',N'91353001',N'Kienlongbank - Kien Long',N'970452',N'Kienlongbank - Kien Long Commercial Joint Stock Bank',N'Kienlongbank',NULL,N'Kienlongbank - Kiên Long',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'631',N'79631001',N'KB - Kookmin Bank HCM',N'970463',N'KB - Kookmin Bank - HCMC Branch',N'KB',NULL,N'KB - Kookmin Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'357',N'01357001',N'LPB - Buu Dien Lien Viet',N'970449',N'LPB - Lien Viet Post Joint Stock Commercial Bank',N'LPB',NULL,N'LPB - Bưu Điện Liên Việt',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'609',N'01609001',N'May Bank Ha Noi',N'',N'Malayan Banking Berhad - Ha Noi Branch',N'MayBank',NULL,N'May Bank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'635',N'79635001',N'May Bank HCM',N'',N'Malayan Banking Berhad - HCMC Branch',N'MayBank',NULL,N'May Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'311',N'01311001',N'MB - Quan doi',N'970422',N'MB - Military Commercial Joint Stock Bank',N'MB',NULL,N'MB - Quân đội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'623',N'79623001',N'Mega ICBC HCM',N'',N'Mega International Commercial Bank - HCMC Branch',N'Mega ICBC',NULL,N'Mega ICBC HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'613',N'01613001',N'Mizuho Bank Ha Noi',N'',N'Mizuho Bank, LTd – Ha Noi Branch',N'Mizuho',NULL,N'Mizuho Bank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'639',N'79639001',N'Mizuho Bank HCM',N'',N'Mizuho Bank, LTd – HCMC Branch',N'Mizuho',NULL,N'Mizuho Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'302',N'01302001',N'MSB - Hang hai VN',N'970426',N'MSB - Vietnam Maritime Commercial Join Stock Bank',N'MSB',NULL,N'MSB - Hàng hải VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'653',N'01653001',N'MUFG Bank Ha Noi',N'',N'Mufg Bank, Ltd. - Ha Noi Branch',N'MUFG',NULL,N'MUFG Bank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'622',N'79622001',N'MUFG Bank HCM',N'',N'Mufg Bank, Ltd - HCMC Branch',N'MUFG',NULL,N'MUFG Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'306',N'79306001',N'NamAbank - Nam A',N'970428',N'NamAbank - Nam A comercial Join Stock Bank',N'NamAbank',NULL,N'NamAbank - Nam Á',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'352',N'01352002',N'NCB - Quoc Dan',N'970419',N'NCB - National Citizen Commercial Joint Stock Bank',N'NCB',NULL,N'NCB - Quốc Dân',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'662',N'01662001',N'NHB - NongHyup Bank Ha Noi',N'801011',N'NHB - Nonghyup Bank Ha Noi Branch',N'NHB',NULL,N'NHB - NongHyup Bank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'333',N'79333001',N'OCB - Phuong Dong',N'970448',N'OCB - Orient Commercial Joint Stock Bank',N'OCB',NULL,N'OCB - Phương Đông',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'625',N'79625001',N'OCBC - Oversea Chinese Banking',N'',N'OCBC - Oversea-Chinese Banking Corporation, Limited',N'OCBC',NULL,N'OCBC - Oversea Chinese Banking',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'319',N'01319001',N'Oceanbank - Dai Duong',N'970414',N'Oceanbank - Ocean Commercial One Member Limited Liability Bank',N'Oceanbank',NULL,N'Oceanbank - Đại Dương',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'501',N'01501001',N'PBVN - Public VN',N'970439',N'PBVN - Public Bank Vietnam Limited',N'PBVN',NULL,N'PBVN - Public VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'341',N'01341001',N'PGBank - Xang dau Petrolimex',N'970430',N'PGBank - Petrolimex Group Commercial Joint Stock Bank',N'PGBank',NULL,N'PGBank - Xăng dầu Petrolimex',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'360',N'01360002',N'PVcomBank - Dai chung VN',N'970412',N'PVcomBank - Vietnam Public Bank',N'PVcomBank',NULL,N'PVcomBank - Đại chúng VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'303',N'79303001',N'Sacombank - Sai Gon Thuong Tin',N'970403',N'Sacombank - Sai Gon Thuong Tin Commercial Joint Stock Bank',N'Sacombank',NULL,N'Sacombank - Sài Gòn Thương Tín',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'308',N'79308001',N'SaigonBank - Sai Gon Cong Thuong',N'970400',N'SaigonBank - Sai Gon Bank For Industry and Trade',N'SaigonBank',NULL,N'SaigonBank - Sài Gòn Công Thương',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'604',N'01604002',N'SCVN - Standard Chartered VN',N'970410',N'SCVN - Standard Chartered (VN) Limited',N'SCVN',NULL,N'SCVN - Standard Chartered VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'334',N'79334001',N'SCB - Sai Gon',N'970429',N'SCB - Sai Gon Joint Stock Commercial Bank',N'SCB',NULL,N'SCB - Sài Gòn',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'600',N'79600001',N'SCB - Siam Commercial Bank VN',N'',N'SCB - The Siam Commercial Bank Public Company Limited',N'SCB',NULL,N'SCB - Siam Commercial Bank VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'606',N'75606001',N'Shanghai Bank Dong Nai',N'',N'The Shanghai Commercial & Savings Bank, Ltd Dong Nai Branch',N'SCSB',NULL,N'SCSB - Shanghai Commercial Savings Bank Đồng Nai',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'317',N'01317001',N'SeaBank - Dong Nam A',N'970440',N'SeaBank - Southeast Asia Commercial Joint Stock Bank',N'SeaBank',NULL,N'SeaBank - Đông Nam Á',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'348',N'01348002',N'SHB - Sai Gon Ha Noi',N'970443',N'SHB - Saigon Hanoi Commercial Joint Stock Bank',N'SHB',NULL,N'SHB - Sài Gòn Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'616',N'79616001',N'SHV - Shinhan VN',N'970424',N'SHV - Shinhan Bank Vietnam Limited',N'SHV',NULL,N'SHV - Shinhan VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'936',N'01636001',N'SMBC - Sumitomo Mitsui Ha Noi',N'',N'SMBC - Sumitomo Mitsui Banking Corporation - Ha Noi Branch',N'SMBC',NULL,N'SMBC - Sumitomo Mitsui Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'636',N'79636001',N'SMBC - Sumitomo Mitsui HCM',N'',N'SMBC - Sumitomo Mitsui Banking Corporation - HCMC Branch',N'SMBC',NULL,N'SMBC - Sumitomo Mitsui HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'655',N'74655001',N'Taipei Fubon Bank Binh Duong',N'',N'Taipei Fubon Commercial Bank Co.,Ltd - Binh Duong Branch',N'Taipei Fubon',NULL,N'Taipei Fubon Bank Bình Dương',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'651',N'79651001',N'Taipei Fubon Bank HCM',N'',N'Taipei Fubon Commercial Bank Co.,Ltd - HCMC Branch',N'Taipei Fubon',NULL,N'Taipei Fubon Bank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'642',N'01642001',N'Taipei Fubon Bank Ha Noi',N'',N'Taipei Fubon Commercial Bank Co.,Ltd - Ha Noi Branch',N'Taipei Fubon',NULL,N'Taipei Fubon Bank Hà Nội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'310',N'01310001',N'Techcombank - Ky Thuong',N'970407',N'Techcombank - Vietnam Technology and Commercial Joint Stock Bank',N'Techcombank',NULL,N'Techcombank - Kỹ Thương',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'358',N'01358001',N'TPBank - Tien Phong',N'970423',N'TPBank - Tien Phong commercial Joint Stock Bank',N'TPBank',NULL,N'TPBank - Tiên Phong',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'665',N'79665001',N'UOB - United Overseas Bank (VN)',N'970458',N'UOB - United Overseas Bank (Vietnam) Limited',N'UOB',NULL,N'UOB - United Overseas Bank (VN )',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'207',N'01207001',N'VBSP - Chinh sach xa hoi',N'',N'VBSP - Vietnam Bank For Social Policies',N'VBSP',NULL,N'VBSP - Chính sách xã hội',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'208',N'01208001',N'VDB - Phat trien VN',N'',N'VDB - VN Development Bank',N'VDB',NULL,N'VDB - Phát triển VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'314',N'79314013',N'VIB - Quoc te',N'970441',N'VIB - VN International Commercial Joint Stock Bank',N'VIB',NULL,N'VIB - Quốc tế',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'355',N'01355002',N'VietABank - Viet A',N'970427',N'VietABank - VN Asia Commercial Joint Stock Bank',N'VietABank',NULL,N'VietABank - Việt Á',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'356',N'79356001',N'VietBank - VN Thuong Tin',N'970433',N'VietBank - VN Thuong Tin Commercial Joint Stock Bank',N'VietBank',NULL,N'VietBank - VN Thương Tín',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'201',N'01201001',N'VietinBank - Cong thuong VN',N'970415',N'VietinBank - VN Joint Stock Commercial Bank for Industry and Trade',N'VietinBank',NULL,N'VietinBank - Công thương VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'309',N'01309001',N'VPBank - VN Thinh Vuong',N'970432',N'VPBank - VN Prosperity Joint Stock Comercial Bank',N'VPBank',NULL,N'VPBank - VN Thịnh Vượng',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'505',N'01505001',N'VRB - Lien doanh Viet Nga',N'970421',N'VRB - VN - Russia Joint Venture Bank',N'VRB',NULL,N'VRB - Liên doanh Việt Nga',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'663',N'01663001',N'Woori bank VN',N'970457',N'Woori Bank VN Limited',N'Wooribank',NULL,N'Wooribank - Woori VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'601',N'79601001',N'BPCE IOM',N'',N'BPCE IOM',N'BPCEIOM',NULL,N'BPCE IOM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'619',N'79619001',N'Deutsche Bank VN',N'',N'Deutsche Bank AG, Vietnam',N'DeutscheBank',NULL,N'Deutsche Bank VN',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'632',N'79632001',N'BSP - SinoPac',N'',N'BSP - Bank SinoPac',N'BSP',NULL,N'BSP - SinoPac',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'309',N'',N'Cake by VPBank',N'546034',N'Cake by VPBank',N'Cake',NULL,N'Cake by VPBank',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'309',N'',N'Ubank by VPBank',N'546035',N'Ubank by VPBank',N'UBank',NULL,N'Ubank by VPBank',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'203',N'01203001',N'Vietcombank - Ngoai thuong',N'970436',N'Vietcombank - Joint Stock Commercial Bank for Foreign Trade of VN',N'Vietcombank',NULL,N'Vietcombank - Ngoại thương',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'612',N'79612001',N'Bangkok Bank HCM',N'',N'Bangkok Bank Public Company Limited - HCMC Branch',N'Bangkok Bank',NULL,N'Bangkok Bank - Bangkok Đại Chúng HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'669',N'79669001',N'KBANK - Kasikornbank HCM',N'668888',N'KBANK - Kasikornbank HCM',N'KBank',NULL,N'KBANK - Kasikornbank HCM',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'700',N'',N'Umee by KienlongBank',N'963399',N'Umee by KienlongBank',N'Umee',NULL,N'Umee by KienlongBank',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,N'700',N'',N'Umee by KienlongBank',N'963399',N'Umee by KienlongBank',N'Umee',NULL,N'Umee by KienlongBank',NULL,NULL)

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKID],[BANKCODE],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME],[CREATE_DT],[AUTH_STATUS])VALUES(NULL,NULL,NULL,NULL,N'',N'KB - Kookmin Bank Ha Noi',N'970462',N'KB - Kookmin Bank - Ha Noi Branch',N'KB',NULL,N'KB - Kookmin Bank Hà Nội',NULL,NULL)