134 lines
No EOL
7 KiB
SQL
134 lines
No EOL
7 KiB
SQL
/* Query para insertar paises en la base de datos */
|
|
select * from Catalogo.Pais
|
|
INSERT INTO Catalogo.Pais VALUES('BELICE', 'BELICEÑO','+501', 1),
|
|
('GUATEMALA', 'GUATEMALTECO','+502', 1),
|
|
('EL SALVADOR', 'SALVADOREÑO','+503', 1),
|
|
('HONDURAS', 'HONDUREÑO','+504', 1),
|
|
('NICARAGUA', 'NICARAGUENSE','+505', 1),
|
|
('COSTA RICA', 'COSTARRICENSE','+506', 1),
|
|
('PERU', 'PERUANO','+51', 1),
|
|
('ARGENTINA', 'ARGENTINO','+54', 1),
|
|
('BRASIL', 'BRASILEÑO','+55', 1),
|
|
('CHILE', 'CHILENO','+56', 1),
|
|
('COLOMBIA', 'COLOMBIANO','+57', 1),
|
|
('VENEZUELA', 'VENEZOLANO','+58', 1),
|
|
('BOLIVIA', 'BOLIVIANO','+591', 1),
|
|
('ECUADOR', 'ECUATORIANO','+593', 1),
|
|
('PARAGUAY', 'PARAGUAYO','+595', 1),
|
|
('URUGUAY', 'URUGUAYO','+598', 1)
|
|
|
|
/* Query para insertar bancos en la base de datos */
|
|
select * from Catalogo.Banco
|
|
INSERT INTO Catalogo.Banco VALUES('BANCO DE COSTA RICA', 'BCR', 1),
|
|
('BANCO NACIONAL DE COSTA RICA', 'BNCR', 1),
|
|
('BAC SAN JOSE', 'BAC', 1),
|
|
('BANCO POPULAR Y DE DESARROLLO COMUNAL', 'BPDC', 1),
|
|
('BANCO PROMERICA', 'PROMERICA', 1),
|
|
('BANCO DAVIVIENDA', 'DAVIVIENDA', 1),
|
|
('SCOTIABANK', 'SCOTIABANK', 1),
|
|
('CATHAY BANCO', 'CATHAY', 1)
|
|
|
|
/* Query para insertar tipos de identificacion en la base de datos */
|
|
select * from Catalogo.TipoIdentificacion
|
|
INSERT INTO Catalogo.TipoIdentificacion VALUES ('CEDULA FISICA', 1),
|
|
('CEDULA JURIDICA', 1),
|
|
('DIMEX', 1),
|
|
('NITE', 1)
|
|
|
|
/* Query para insertar tipos de telefono en la base de datos */
|
|
select * from Catalogo.TipoTelefono
|
|
INSERT INTO Catalogo.TipoTelefono VALUES('MOVIL', 1),
|
|
('CASA', 1),
|
|
('TRABAJO', 1),
|
|
('EMERGENCIA', 1)
|
|
|
|
/* Query para insertar tipos de pagos en la base de datos */
|
|
select * from Catalogo.TipoPago
|
|
INSERT INTO Catalogo.TipoPago VALUES('TRASFERENCIA', 1),
|
|
('CHEQUE', 1),
|
|
('SINPE', 1),
|
|
('EFECTIVO', 1)
|
|
|
|
/* Query para insertar tipos de documentos en la base de datos */
|
|
select * from Catalogo.TipoDocumento
|
|
INSERT INTO Catalogo.TipoDocumento VALUES ('TIQUETE', 1),
|
|
('FACTURA', 1),
|
|
('NOTA DE CRÉDITO', 1),
|
|
('NOTA DE DÉBITO', 1)
|
|
|
|
/* Query para insertar monedas en la base de datos */
|
|
select * from Catalogo.Moneda
|
|
INSERT INTO Catalogo.Moneda VALUES ('Euro',null, 1),
|
|
('Us Dollar','$', 1),
|
|
('Colón','₡' , 1)
|
|
|
|
/* Query para insertar roles en la base de datos */
|
|
select * from Catalogo.Rol
|
|
INSERT INTO Catalogo.Rol VALUES ('ADMINISTRADOR', 1),
|
|
('OPERATIVO', 1),
|
|
('CONTADOR', 1)
|
|
|
|
/* Query para insertar usuarios en la base de datos */
|
|
select * from Catalogo.Usuario
|
|
INSERT INTO Catalogo.Usuario VALUES ('JDVENEGAS','JAROD','VENEGAS', 'ALPIZAR', 'JVENEGAS@ATESACR.COM', 1),
|
|
('JMOLINA','JAVIER','MOLINA', '', 'JMOLINA@ATESACR.COM', 0),
|
|
('RFUENTES','RONALD','FUENTES', 'ROJAS', 'RFUENTES@ATESACR.COM', 1)
|
|
|
|
/* Query para insertar clientes en la base de datos */
|
|
select * from Global.Cliente
|
|
INSERT INTO Global.Cliente VALUES ('3101293069', 2, 6, 'Casa de Funerales Vida de San José S.A', null, null, 'cliente1@prueba.com', 'CR', 1),
|
|
('3002084110', 2, 6, 'ACORDE', null, null, 'cliente2@prueba.com', 'CR', 1),
|
|
('3101664705', 2, 6, 'ARRIENDA EXPRESS SOCIEDAD ANONIMA', null, null, 'cliente3@prueba.com', 'CR', 1),
|
|
('3101338816', 2, 6, 'Dirbel Inversiones S.A.', null, null, 'cliente4@prueba.com', 'CR', 1),
|
|
('3101695213', 2, 6, 'Capicredit S.A.', null, null, 'cliente5@prueba.com', 'CR', 1),
|
|
('RUC225706651782627', 2, 6, 'Techno Outsourcing Services S.A.', null, null, 'cliente6@prueba.com', 'CR', 1),
|
|
('3101012009', 2, 6, 'Bac San José S.A.', null, null, 'cliente7@prueba.com', 'CR', 1),
|
|
('08019016834122', 2, 6, 'BAC Pensiones', null, null, 'cliente8@prueba.com', 'CR', 1),
|
|
('3101046008', 2, 6, 'Banco Davivienda', null, null, 'cliente9@prueba.com', 'CR', 1),
|
|
('08019995222486', 2, 4, 'Bac Honduras', null, null, 'cliente10@prueba.com', 'HN', 1),
|
|
('3101216492', 2, 6, 'Banco Cathay de Costa Rica, S.A.', null, null, 'cliente11@prueba.com', 'CR', 1)
|
|
|
|
/* Query para insertar clientes en la base de datos */
|
|
select * from Global.Telefono
|
|
INSERT INTO Global.Telefono VALUES (1, '3101293069', '1111111', 1),
|
|
(2, '3101293069', '2222222', 1),
|
|
(1, '3002084110', '333333', 1),
|
|
(2, '3002084110', '4444444', 1),
|
|
(3, '3101664705', '5555555', 1),
|
|
(1, '3101664705', '6666666', 1),
|
|
(3, '3101338816', '7777777', 1),
|
|
(2, '3101695213', '8888888', 1),
|
|
(2, 'RUC225706651782627', '999999', 1),
|
|
(3, 'RUC225706651782627', '1212121', 1),
|
|
(1, 'RUC225706651782627', '2323233', 1),
|
|
(3, '3101012009', '4545455', 1),
|
|
(2, '08019016834122', '5656566', 1),
|
|
(3, '3101046008', '7878788', 1),
|
|
(1, '3101046008', '8989899', 1),
|
|
(3, '3101046008', '1313133', 1),
|
|
(2, '08019995222486', '4646466', 1),
|
|
(1, '3101216492', '7979799', 1)
|
|
|
|
/* Query para insertar pagos en la base de datos */
|
|
--select * from Global.Pago
|
|
--INSERT INTO Global.Pago VALUES(1, 1, 1,'2023-05-02T17:13:52.828Z'),
|
|
-- ( 2, 2, 2, '2023-05-11T17:13:52.828Z'),
|
|
-- ( 5, 2, 1, '2023-03-11T17:13:52.828Z'),
|
|
-- ( 4, 1, 2, '2023-01-11T17:13:52.828Z'),
|
|
-- ( 3, 3, 1, '2023-02-11T17:13:52.828Z'),
|
|
-- ( 3, 1, 1, '2023-03-11T17:13:52.828Z'),
|
|
-- ( 4, 2, 1, '2022-04-11T17:13:52.828Z'),
|
|
-- ( 5, 3, 1, '2022-03-11T17:13:52.828Z'),
|
|
-- ( 8, 1, 2, '2022-12-11T17:13:52.828Z')
|
|
|
|
/* Query para insertar facturas en la base de datos */
|
|
--select * from Global.Factura
|
|
--INSERT INTO Global.Factura VALUES ('00100001010000001711', '3101293069', 1, 1, '2023-04-10T00:00:00', '2023-05-10T00:00:00', null, 'DAVIVIENDA', 300.7, 100.3, 401.0, 30, 0 , 'CANCELADA'),
|
|
-- ('00100001010000001724', 'RUC225706651782627', 2, 2, '2023-03-10T00:00:00', '2023-04-10T00:00:00', null, 'ARRIENDA EXPRESS SOCIEDAD ANONIMA', 200.7, 200.3, 401.0, 30, 0 , 'PENDIENTE'),
|
|
-- ('00100001010000001717', '08019016834122', 2, 3, '2023-01-10T00:00:00', '2023-02-10T00:00:00', null, 'TECHNO OUTSOURCING SERVICES S.A.', 100.7, 100.3, 201.0, 30, 0 , 'PENDIENTE'),
|
|
-- ('RC200666345353451', '08019995222486', 1, 2, '2023-02-10T00:00:00', '2023-03-10T00:00:00', null, 'BAC SAN JOSÉ S.A.', 600.7, 100.3, 701.0, 30, 0 , 'CANCELADA'),
|
|
-- ('RC2001345345345575', '3101046008', 1, 2, '2022-12-10T00:00:00', '2023-01-10T00:00:00', null, 'BAC HONDURAS', 500.7, 500.3, 1001.0, 30, 0 , 'CANCELADA'),
|
|
-- ('RC2001345445345575', '3101293069', 2, 3, '2022-11-10T00:00:00', '2022-12-10T00:00:00', null, 'DAVIVIENDA', 200.7, 600.3, 801.0, 30, 0 , 'PENDIENTE'),
|
|
-- ('RC2001444422222225', '3101293069', 1, 1, '2022-10-10T00:00:00', '2022-11-10T00:00:00', null, 'DAVIVIENDA', 300.7, 700.3, 1001.0, 30, 0 , 'PENDIENTE'),
|
|
-- ('RC2001554245345575', '3101046008', 2, 1, '2022-12-10T00:00:00', '2023-01-10T00:00:00', null, 'BAC HONDURAS', 200.7, 900.3, 1101.0, 30, 0 , 'CANCELADA')
|
|
|