chore: location

1 files changed, 0 insertions, 468 deletions

diff --git a/Gestor.Application.Migration.Files.20200219_03.SQL b/Gestor.Application.Migration.Files.20200219_03.SQL
deleted file mode 100644
index 17e1099..0000000
--- a/Gestor.Application.Migration.Files.20200219_03.SQL
+++ /dev/null
@@ -1,468 +0,0 @@
-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 1)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (1,1, N'BANCO DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 10)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (10,41, N'BANCO DO ESTADO DO RIO GRANDE DO SUL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 100)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (100,738, N'BANCO MORADA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 101)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (101,739, N'BANCO BGN S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 102)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (102,740, N'BANCO BARCLAYS S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 103)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (103,741, N'BANCO RIBEIRAO PRETO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 104)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (104,743, N'BANCO EMBLEMA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 105)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (105,745, N'BANCO CITIBANK S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 106)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (106,746, N'BANCO MODAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 107)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (107,747, N'BANCO RABOBANK INTERNATIONAL BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 108)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (108,748, N'BANCO COOPERATIVO SICREDI S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 109)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (109,749, N'BANCO SIMPLES S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 11)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (11,44, N'BANCO BVA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 110)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (110,751, N'DRESDNER BANK BRASIL S.A. BANCO MULTIPLO');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 111)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (111,752, N'BANCO BNP PARIBAS BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 112)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (112,753, N'NBC BANK BRASIL S. A. - BANCO M?LTIPLO');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 113)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (113,756, N'BANCO COOPERATIVO DO BRASIL S.A. - BANCOOB');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 114)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (114,757, N'BANCO KEB DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 115)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (115,0, N'NENHUM');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 116)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (116,85, N'BANCO CECRED');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 117)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (117,290, N'PAGSEGURO INTERNET S.A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 12)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (12,45, N'BANCO OPPORTUNITY S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 13)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (13,47, N'BANCO DO ESTADO DE SERGIPE S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 14)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (14,62, N'HIPERCARD BANCO M?LTIPLO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 15)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (15,63, N'BANCO IBI S.A. - BANCO M?LTIPLO');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 16)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (16,65, N'BANCO LEMON S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 17)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (17,66, N'BANCO MORGAN STANLEY S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 18)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (18,69, N'BPN BRASIL BANCO M?LTIPLO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 19)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (19,70, N'BRB - BANCO DE BRASILIA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 2)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (2,3, N'BANCO DA AMAZONIA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 20)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (20,72, N'BANCO RURAL MAIS S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 21)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (21,73, N'BB BANCO POPULAR DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 22)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (22,74, N'BANCO J. SAFRA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 23)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (23,75, N'BANCO CR2 S/A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 24)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (24,76, N'BANCO KDB DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 25)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (25,77, N'BANCO INTERMEDIUM S/A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 26)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (26,79, N'JBS BANCO S/A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 27)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (27,81, N'CONC?RDIA BANCO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 28)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (28,96, N'BANCO BM&F DE SERVI?OS DE LIQUIDA??O E CUST?DIA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 29)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (29,104, N'CAIXA ECONOMICA FEDERAL');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 3)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (3,4, N'BANCO DO NORDESTE DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 30)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (30,107, N'BANCO BBM S/A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 31)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (31,151, N'BANCO NOSSA CAIXA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 32)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (32,208, N'BANCO UBS PACTUAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 33)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (33,212, N'BANCO MATONE S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 34)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (34,213, N'BANCO ARBI S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 35)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (35,214, N'BANCO DIBENS S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 36)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (36,217, N'BANCO JOHN DEERE S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 37)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (37,218, N'BANCO BONSUCESSO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 38)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (38,222, N'BANCO CALYON BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 39)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (39,224, N'BANCO FIBRA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 4)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (4,19, N'BANCO AZTECA DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 40)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (40,225, N'BANCO BRASCAN S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 41)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (41,229, N'BANCO CRUZEIRO DO SUL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 42)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (42,230, N'UNICARD BANCO M?LTIPLO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 43)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (43,233, N'BANCO GE CAPITAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 44)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (44,237, N'BANCO BRADESCO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 45)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (45,241, N'BANCO CLASSICO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 46)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (46,243, N'BANCO M?XIMA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 47)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (47,246, N'BANCO ABC BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 48)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (48,248, N'BANCO BOAVISTA INTERATLANTICO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 49)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (49,249, N'BANCO INVESTCRED UNIBANCO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 5)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (5,21, N'BANESTES S.A. BANCO DO ESTADO DO ESPIRITO SANTO');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 50)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (50,250, N'BANCO SCHAHIN S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 51)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (51,254, N'PARAN? BANCO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 52)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (52,263, N'BANCO CACIQUE S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 53)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (53,265, N'BANCO FATOR S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 54)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (54,266, N'BANCO CEDULA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 55)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (55,300, N'BANCO DE LA NACION ARGENTINA');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 56)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (56,318, N'BANCO BMG S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 57)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (57,341, N'BANCO ITAU S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 58)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (58,356, N'BANCO ABN AMRO REAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 59)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (59,366, N'BANCO SOCIETE GENERALE BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 6)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (6,25, N'BANCO ALFA S.A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 60)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (60,370, N'BANCO WESTLB DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 61)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (61,376, N'BANCO J.P. MORGAN S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 62)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (62,389, N'BANCO MERCANTIL DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 63)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (63,394, N'BANCO FINASA BMC S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 64)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (64,399, N'HSBC BANK BRASIL S.A. - BANCO MULTIPLO');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 65)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (65,409, N'UNIBANCO-UNIAO DE BANCOS BRASILEIROS S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 66)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (66,412, N'BANCO CAPITAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 67)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (67,422, N'BANCO SAFRA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 68)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (68,453, N'BANCO RURAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 69)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (69,456, N'BANCO DE TOKYO-MITSUBISHI UFJ BRASIL S/A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 7)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (7,33, N'BANCO SANTANDER BANESPA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 70)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (70,464, N'BANCO SUMITOMO MITSUI BRASILEIRO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 71)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (71,477, N'CITIBANK N.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 72)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (72,487, N'DEUTSCHE BANK S.A. - BANCO ALEMAO');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 73)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (73,488, N'JPMORGAN CHASE BANK, NATIONAL ASSOCIATION');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 74)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (74,492, N'ING BANK N.V.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 75)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (75,494, N'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 76)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (76,495, N'BANCO DE LA PROVINCIA DE BUENOS AIRES');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 77)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (77,505, N'BANCO CREDIT SUISSE (BRASIL) S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 78)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (78,600, N'BANCO LUSO BRASILEIRO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 79)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (79,604, N'BANCO INDUSTRIAL DO BRASIL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 8)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (8,37, N'BANCO DO ESTADO DO PAR? S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 80)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (80,610, N'BANCO VR S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 81)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (81,611, N'BANCO PAULISTA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 82)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (82,612, N'BANCO GUANABARA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 83)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (83,613, N'BANCO PECUNIA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 84)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (84,623, N'BANCO PANAMERICANO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 85)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (85,626, N'BANCO FICSA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 86)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (86,630, N'BANCO INTERCAP S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 87)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (87,633, N'BANCO RENDIMENTO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 88)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (88,634, N'BANCO TRIANGULO S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 89)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (89,637, N'BANCO SOFISA S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 9)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (9,40, N'BANCO CARGILL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 90)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (90,638, N'BANCO PROSPER S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 91)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (91,643, N'BANCO PINE S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 92)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (92,653, N'BANCO INDUSVAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 93)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (93,654, N'BANCO A.J. RENNER S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 94)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (94,655, N'BANCO VOTORANTIM S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 95)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (95,707, N'BANCO DAYCOVAL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 96)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (96,719, N'BANIF - BANCO INTERNACIONAL DO FUNCHAL (BRASIL), S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 97)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (97,721, N'BANCO CREDIBEL S.A.');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 98)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (98,734, N'BANCO GERDAU S.A');

-END

-IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 99)

-BEGIN

-	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (99,735, N'BANCO POTTENCIAL S.A.');

-END
\ No newline at end of file