Inversiones/Recursos/Bancos y Cuentas Bancarias.sql

USE Inversiones
GO
/****** Object:  Table [dbo].[BAN1]    Script Date: 7/9/2019 1:28:13 AM ******/

/****** Object:  Table [dbo].[BAN0]    Script Date: 7/9/2019 1:28:13 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BAN0](
	[CodBanco] [varchar](30) NOT NULL,
	[NombreBanco] [varchar](100) NOT NULL,
	[CodPais] [varchar](3) NOT NULL,
 CONSTRAINT [PK_BAN0] PRIMARY KEY CLUSTERED 
(
	[CodBanco] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BAN1]    Script Date: 7/9/2019 1:28:13 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BAN1](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CodBanco] [varchar](30) NULL,
	[CodEmpr] [varchar](10) NULL,
	[NumCuenta] [varchar](50) NULL,
	[Activo] [bit] NULL,
	[NombreCuenta] [varchar](100) NULL,
 CONSTRAINT [PK_BAN1] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'AZULSV', N'Banco Azul de El Salvador, S.A.', N'SV')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'BACPA', N'Banco de América Central Panamá', N'PA')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'BACSV', N'Banco de América Central El Salvador', N'SV')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'BAGSV', N'Banco Agricola, S.A.', N'SV')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'CUSCASV', N'Banco Cuscatlán El Salvador', N'SV')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'IBKRUSA', N'Interactive Brokers', N'US')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'IZALSV', N'Banco Izalqueño de los Trabajadores', N'SV')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'MULTSV', N'Multi Inversiones Banco Cooperativo de los Trabajadores, S.A.', N'SV')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'PROMSV', N'Banco Promerica', N'SV')
GO
INSERT [dbo].[BAN0] ([CodBanco], [NombreBanco], [CodPais]) VALUES (N'SCOTSV', N'Scotiabank El Salvador, S.A.', N'SV')
GO
SET IDENTITY_INSERT [dbo].[BAN1] ON 
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (1, N'BAGSV', N'INV', N'5010639044', NULL, N'CTA. CTE. No. 5010639044')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (2, N'BACSV', N'INV', N'200807709', NULL, N'CTA. CTE. No. 200807709')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (3, N'BACPA', N'INV', N'106028327', NULL, N'Inversiones Merelec, S.A. de C.V.')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (4, N'IZALSV', N'INV', N'730100157172', NULL, N'Inversiones Merelec, S.A. de C.V.')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (5, N'CUSCASV', N'INV', N'008301000007869', NULL, N'CTA.ESPEC. No. 008301000007869')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (6, N'CUSCASV', N'INV', N'017-301-00002508-9', NULL, N'CTA. CTE. No. 017-301-00002508-9')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (7, N'IBKRUSA', N'INV', N'3335-02', NULL, N'A LA VISTA No. 3335-02')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (8, N'IBKRUSA', N'INV', N'U1544106', NULL, N'Inversiones Merelec, S.A. de C.V.')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (9, N'SCOTSV', N'INV', N'6840012636', NULL, N'CTA. CTE. No. 6840012636')
GO
INSERT [dbo].[BAN1] ([Id], [CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta]) VALUES (10, N'SCOTSV', N'INV', N'7140018214', NULL, N'CTA.ESPEC. No. 7140018214')
GO
SET IDENTITY_INSERT [dbo].[BAN1] OFF
GO