Страница учебника А.В. Маркина "Программирование на SQL" для бакалавриата и магистратуры (издательство ЮРАЙТ, 2023)

SET CLIENTLIB 'C:\Program Files\Firebird\Firebird_4_0\WOW64\fbclient.dll';
SET SQL DIALECT 3;
CREATE DATABASE 'localhost:C:\GGGG\SQL\NN.FDB' USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384 DEFAULT CHARACTER SET WIN1251;
/*****************************************************************/
/* ДОМЕНЫ */
/*****************************************************************/
CREATE DOMAIN MONEY AS NUMERIC(15,2);
CREATE DOMAIN TMONTH AS SMALLINT
CHECK (VALUE BETWEEN 1 AND 12);
CREATE DOMAIN PKFIELD AS INTEGER;
CREATE DOMAIN TYEAR AS SMALLINT
CHECK (VALUE BETWEEN 1990 AND 2100);
/*****************************************************************/
/* ИСКЛЮЧЕНИЯ */
/*****************************************************************/
CREATE EXCEPTION INS_RESTRICT 'Ограничение добавления строки';
CREATE EXCEPTION DEL_RESTRICT 'Ограничение удаления строки';
CREATE EXCEPTION UPD_RESTRICT 'Ограничение обновления строки';
/*****************************************************************/
/* ГЕНЕРАТОРЫ */
/*****************************************************************/
CREATE SEQUENCE GEN_STREET;
CREATE SEQUENCE GEN_SERVICES;
CREATE SEQUENCE GEN_DISREPAIR START WITH 13;
CREATE SEQUENCE GEN_EXECUTOR;
CREATE SEQUENCE GEN_NACHISLSUMMA START WITH 80;
CREATE SEQUENCE GEN_PAYSUMMA;
CREATE SEQUENCE GEN_REQUEST START WITH 24;
/*****************************************************************/
/* ТАБЛИЦЫ */
/*****************************************************************/
-- Улицы
CREATE TABLE STREET (
STREETCD PKFIELD PRIMARY KEY,
STREETNM VARCHAR(30) );
CREATE TABLE SERVICES (
SERVICECD PKFIELD PRIMARY KEY,
SERVICENM VARCHAR(30) );
-- Неисправности газового оборудования
CREATE TABLE DISREPAIR (
FAILURECD PKFIELD PRIMARY KEY,
FAILURENM VARCHAR(50) );
-- Исполнители ремонтных заявок
CREATE TABLE EXECUTOR (
EXECUTORCD PKFIELD PRIMARY KEY,
Fio VARCHAR(20) );
-- Абоненты
CREATE TABLE ABONENT (
ACCOUNTCD VARCHAR(6) PRIMARY KEY,
STREETCD PKFIELD REFERENCES STREET
ON DELETE SET NULL ON UPDATE CASCADE,
HOUSENO SMALLINT,
FLATNO SMALLINT,
Fio VARCHAR(20),
PHONE VARCHAR(15));
-- Начислено
CREATE TABLE NACHISLSUMMA (
NACHISLFACTCD PKFIELD PRIMARY KEY,
ACCOUNTCD VARCHAR(6) NOT NULL REFERENCES ABONENT
ON UPDATE CASCADE,
SERVICECD PKFIELD NOT NULL REFERENCES SERVICES
ON UPDATE CASCADE,
NACHISLSUM MONEY,
NACHISLMONTH TMONTH,
NACHISLYEAR TYEAR);
-- Оплачено
CREATE TABLE PAYSUMMA (
PAYFACTCD PKFIELD PRIMARY KEY,
ACCOUNTCD VARCHAR(6) NOT NULL REFERENCES ABONENT
ON UPDATE CASCADE,
SERVICECD PKFIELD NOT NULL REFERENCES SERVICES
ON UPDATE CASCADE,
PAYSUM MONEY,
PAYDATE DATE,
PAYMONTH TMONTH,
PAYYEAR TYEAR);
-- Заявки на ремонт
CREATE TABLE REQUEST (
REQUESTCD PKFIELD PRIMARY KEY,
ACCOUNTCD VARCHAR(6) REFERENCES ABONENT
ON DELETE SET NULL ON UPDATE CASCADE,
EXECUTORCD PKFIELD REFERENCES EXECUTOR
ON DELETE SET NULL ON UPDATE CASCADE,
FAILURECD PKFIELD REFERENCES DISREPAIR
ON DELETE SET NULL ON UPDATE CASCADE,
INCOMINGDATE DATE DEFAULT CURRENT_DATE NOT NULL,
EXECUTIONDATE DATE,
EXECUTED BOOLEAN NOT NULL);
COMMIT WORK;
/*****************************************************************/
/* Insert STREET */
/*****************************************************************/
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'ЦИОЛКОВСКОГО УЛИЦА');
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'НОВАЯ УЛИЦА');
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'ВОЙКОВ ПЕРЕУЛОК');
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'ТАТАРСКАЯ УЛИЦА');
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'ГАГАРИНА УЛИЦА');
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'МОСКОВСКАЯ УЛИЦА');
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'КУТУЗОВА УЛИЦА');
INSERT INTO STREET (STREETCD, STREETNM) VALUES (NEXT VALUE FOR GEN_STREET, 'МОСКОВСКОЕ ШОССЕ');
COMMIT WORK;
/*****************************************************************/
/* Insert SERVICES */
/*****************************************************************/
INSERT INTO SERVICES (SERVICECD, SERVICENM) VALUES (NEXT VALUE FOR GEN_SERVICES, 'Газоснабжение');
INSERT INTO SERVICES (SERVICECD, SERVICENM) VALUES (NEXT VALUE FOR GEN_SERVICES, 'Электроснабжение');
INSERT INTO SERVICES (SERVICECD, SERVICENM) VALUES (NEXT VALUE FOR GEN_SERVICES, 'Теплоснабжение');
INSERT INTO SERVICES (SERVICECD, SERVICENM) VALUES (NEXT VALUE FOR GEN_SERVICES, 'Водоснабжение');
COMMIT WORK;
/*****************************************************************/
/* Insert DISREPAIR */
/*****************************************************************/
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (1, 'Засорилась водогрейная колонка');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (2, 'Не горит АГВ');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (3, 'Течет из водогрейной колонки');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (4, 'Неисправна печная горелка');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (5, 'Неисправен газовый счетчик');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (6, 'Плохое поступление газа на горелку плиты');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (7, 'Туго поворачивается пробка крана плиты');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (8, 'При закрытии краника горелка плиты не гаснет');
INSERT INTO DISREPAIR (FAILURECD, FAILURENM) VALUES (12, 'Неизвестна');
COMMIT WORK;
/*****************************************************************/
/* Insert EXECUTOR */
/*****************************************************************/
INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (NEXT VALUE FOR GEN_EXECUTOR, 'Стародубцев Е. М.');
INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (NEXT VALUE FOR GEN_EXECUTOR, 'Булгаков Т. И.');
INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (NEXT VALUE FOR GEN_EXECUTOR, 'Шубин В. Г.');
INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (NEXT VALUE FOR GEN_EXECUTOR, 'Шлюков М. К.');
INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (NEXT VALUE FOR GEN_EXECUTOR, 'Школьников С. М.');
INSERT INTO EXECUTOR (EXECUTORCD, FIO) VALUES (NEXT VALUE FOR GEN_EXECUTOR, 'Степанов А. В.');
COMMIT WORK;
/*****************************************************************/
/* Insert ABONENT */
/*****************************************************************/
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('005488', 3, 4, 1, 'Аксенов С. А.', '556893');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('115705', 3, 1, 82, 'Мищенко Е. В.', '769975');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('015527', 3, 1, 65, 'Конюхов В. С.', '761699');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('443690', 7, 5, 1, 'Тулупова М. И.', '214833');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('136159', 7, 39, 1, 'Свирина З. А.', NULL);
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('443069', 4, 51, 55, 'Стародубцев Е. В.', '683014');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('136160', 4, 9, 15, 'Шмаков С. В.', NULL);
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('126112', 4, 7, 11, 'Маркова В. П.', '683301');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('136169', 4, 7, 13, 'Денисова Е. К.', '680305');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('080613', 8, 35, 11, 'Лукашина Р. М.', '254417');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('080047', 8, 39, 36, 'Шубина Т. П.', '257842');
INSERT INTO ABONENT (ACCOUNTCD, STREETCD, HOUSENO, FLATNO, FIO, PHONE) VALUES ('080270', 6, 35, 6, 'Тимошкина Н. Г.', '321002');
COMMIT WORK;
/*****************************************************************/
/* Insert NACHISLSUMMA */
/*****************************************************************/
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (1, '136160', 2, 656, 1, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (2, '005488', 2, 646, 12, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (3, '005488', 2, 656, 4, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (4, '115705', 2, 640, 1, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (5, '115705', 2, 850, 9, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (6, '136160', 1, 518.3, 1, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (7, '080047', 2, 680, 10, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (8, '080047', 2, 680, 10, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (9, '080270', 2, 646, 12, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (10, '080613', 2, 656, 6, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (11, '115705', 2, 850, 9, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (12, '115705', 2, 658.7, 8, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (13, '136160', 2, 620, 5, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (15, '136169', 2, 620, 5, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (16, '136169', 2, 658.7, 11, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (17, '443069', 2, 680, 9, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (18, '443069', 2, 638.5, 8, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (19, '005488', 2, 658.7, 12, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (20, '015527', 1, 528.32, 7, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (21, '080047', 1, 519.56, 3, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (22, '080613', 1, 510.6, 9, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (23, '443069', 1, 538.28, 12, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (24, '015527', 1, 538.32, 4, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (25, '115705', 1, 537.15, 10, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (26, '080613', 1, 512.6, 8, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (27, '136169', 1, 525.32, 1, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (28, '080270', 1, 557.1, 2, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (29, '136159', 1, 508.3, 8, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (30, '005488', 1, 562.13, 4, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (31, '115705', 1, 537.8, 5, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (32, '443690', 1, 517.8, 6, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (33, '080047', 1, 522.56, 5, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (34, '126112', 1, 515.3, 8, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (35, '080047', 1, 532.56, 9, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (36, '080613', 1, 512.6, 4, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (37, '115705', 1, 537.15, 11, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (38, '080270', 1, 558.1, 12, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (39, '136169', 1, 528.32, 1, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (40, '015527', 1, 518.32, 2, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (41, '443690', 1, 521.67, 3, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (42, '080613', 1, 522.86, 4, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (43, '080270', 1, 560.1, 5, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (44, '136169', 1, 528.32, 2, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (45, '080047', 1, 522.2, 7, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (46, '126112', 1, 525.3, 8, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (47, '443069', 1, 538.32, 9, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (48, '136159', 1, 508.3, 10, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (49, '115705', 1, 537.15, 6, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (50, '136160', 1, 518.3, 12, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (51, '005488', 3, 2279.8, 5, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (52, '005488', 3, 2266.7, 2, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (53, '015527', 3, 2343.36, 11, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (54, '080047', 3, 2271.6, 2, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (55, '080270', 3, 2278.25, 11, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (56, '080613', 3, 2254.4, 7, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (57, '080613', 3, 2258.8, 2, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (58, '080613', 3, 2239.33, 5, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (59, '126112', 3, 2179.9, 4, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (60, '136159', 3, 2180.13, 9, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (61, '136160', 3, 2238.8, 3, 2018);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (62, '136160', 3, 2237.38, 3, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (63, '136169', 3, 2349.19, 6, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (64, '136169', 3, 2346.18, 7, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (65, '443690', 3, 2290.33, 3, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (66, '015527', 4, 280.1, 7, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (67, '015527', 4, 311.3, 10, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (68, '080270', 4, 144.34, 3, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (69, '080270', 4, 153.43, 6, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (70, '080270', 4, 154.6, 4, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (71, '115705', 4, 253.85, 1, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (72, '126112', 4, 135.5, 6, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (73, '136159', 4, 49.38, 4, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (74, '136159', 4, 118.88, 6, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (75, '136169', 4, 228.44, 10, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (76, '443069', 4, 166.69, 5, 2020);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (77, '443069', 4, 144.45, 10, 2021);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (78, '443690', 4, 180.88, 8, 2019);
INSERT INTO NACHISLSUMMA (NACHISLFACTCD, ACCOUNTCD, SERVICECD, NACHISLSUM, NACHISLMONTH, NACHISLYEAR) VALUES (79, '443690', 4, 200.13, 9, 2020);
COMMIT WORK;
/*****************************************************************/
/* Insert PAYSUMMA */
/*****************************************************************/
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '005488', 2, 658.7, '2020-01-08', 12, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '005488', 2, 640, '2019-01-06', 12, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '005488', 2, 656, '2021-05-06', 4, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 2, 640, '2018-02-10', 1, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 2, 850, '2019-10-03', 9, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136160', 2, 620, '2019-06-13', 5, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136160', 2, 656, '2021-02-12', 1, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 2, 620, '2019-06-22', 5, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080047', 2, 680, '2020-11-26', 10, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080047', 2, 680, '2019-11-21', 10, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 2, 630, '2020-01-03', 12, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 2, 658.5, '2019-07-19', 6, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 2, 850, '2018-10-06', 9, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 2, 658.7, '2019-09-04', 8, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 2, 658.7, '2019-12-01', 11, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443069', 2, 680, '2019-10-03', 9, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443069', 2, 638.5, '2019-09-13', 8, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136160', 1, 518, '2020-02-05', 1, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '015527', 1, 530, '2020-08-03', 7, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080047', 1, 519.56, '2020-04-02', 3, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 1, 511, '2020-10-03', 9, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443069', 1, 538.28, '2021-02-04', 12, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '015527', 1, 540, '2021-05-07', 4, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 1, 537.15, '2021-11-04', 10, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 1, 512, '2018-09-20', 8, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 1, 525.32, '2021-02-03', 1, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 1, 560, '2020-03-05', 2, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136159', 1, 508.3, '2021-09-10', 8, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '005488', 1, 565, '2018-05-03', 4, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 1, 537.8, '2019-07-12', 5, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443690', 1, 520, '2020-07-10', 6, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080047', 1, 522.56, '2021-06-25', 5, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '126112', 1, 515.3, '2018-09-08', 8, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080047', 1, 532.56, '2019-10-18', 9, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 1, 512.6, '2020-05-22', 4, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 1, 537.15, '2021-12-23', 11, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 1, 558.1, '2019-01-07', 12, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 1, 528.32, '2019-02-08', 1, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '015527', 1, 520, '2020-03-18', 2, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443690', 1, 519.47, '2021-04-10', 3, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 1, 522.86, '2018-05-04', 4, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 1, 560, '2019-06-07', 5, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 1, 528.32, '2020-03-05', 2, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080047', 1, 522.2, '2021-08-10', 7, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '126112', 1, 525.3, '2019-09-10', 8, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443069', 1, 538.32, '2019-10-09', 9, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136159', 1, 508.3, '2020-11-14', 10, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 1, 537.15, '2021-08-10', 6, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136160', 1, 516, '2019-01-07', 12, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '005488', 3, 2280, '2020-06-10', 5, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '005488', 3, 2260, '2021-03-11', 2, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '015527', 3, 2345, '2021-12-15', 11, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080047', 3, 2271.6, '2021-03-12', 2, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 3, 2278, '2021-12-06', 11, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 3, 2254.4, '2019-08-10', 7, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 3, 2258.8, '2021-03-08', 2, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080613', 3, 2239.35, '2021-06-11', 5, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '126112', 3, 2179.9, '2020-05-01', 4, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136159', 3, 2180.13, '2021-10-21', 9, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136160', 3, 2240, '2018-04-04', 3, 2018);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136160', 3, 2200, '2019-04-06', 3, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 3, 2349.19, '2020-07-14', 6, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 3, 2346.18, '2020-08-13', 7, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443690', 3, 2295, '2021-04-09', 3, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '015527', 4, 280.1, '2020-08-08', 7, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '015527', 4, 311.3, '2021-11-03', 10, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 4, 144.5, '2019-04-18', 3, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 4, 150, '2020-07-14', 6, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '080270', 4, 160, '2021-05-12', 4, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '115705', 4, 253.85, '2020-02-02', 1, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '126112', 4, 135.5, '2020-07-12', 6, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136159', 4, 49.38, '2019-05-18', 4, 2019);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136159', 4, 120, '2020-07-09', 6, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '136169', 4, 228.44, '2021-11-26', 10, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443069', 4, 166.69, '2020-06-03', 5, 2020);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443069', 4, 144.45, '2021-11-16', 10, 2021);
INSERT INTO PAYSUMMA (PAYFACTCD, ACCOUNTCD, SERVICECD, PAYSUM, PAYDATE, PAYMONTH, PAYYEAR) VALUES (NEXT VALUE FOR GEN_PAYSUMMA, '443690', 4, 185, '2019-09-05', 8, 2019);
COMMIT WORK;
/*****************************************************************/
/* Insert REQUEST */
/*****************************************************************/
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (1, '005488', 1, 1, '2019-12-17', '2019-12-20', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (2, '115705', 3, 1, '2019-08-07', '2019-08-12', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (3, '015527', 1, 12, '2020-02-28', '2020-03-08', False);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (5, '080270', 4, 1, '2019-12-31', NULL, False);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (6, '080613', 1, 6, '2019-06-16', '2019-06-24', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (7, '080047', 3, 2, '2020-10-20', '2020-10-24', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (9, '136169', 2, 1, '2019-11-06', '2019-11-08', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (10, '136159', 3, 12, '2019-04-01', '2019-04-03', False);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (11, '136160', 1, 6, '2021-01-12', '2021-01-12', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (12, '443069', 5, 2, '2019-08-08', '2019-08-10', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (13, '005488', 5, 8, '2018-09-04', '2018-12-05', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (14, '005488', 4, 6, '2021-04-04', '2021-04-13', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (15, '115705', 4, 5, '2018-09-20', '2018-09-23', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (16, '115705', NULL, 3, '2019-12-28', NULL, False);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (17, '115705', 1, 5, '2019-08-15', '2019-09-06', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (18, '115705', 2, 3, '2020-12-28', '2021-01-04', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (19, '080270', 4, 8, '2019-12-17', '2019-12-27', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (20, '080047', 3, 2, '2019-10-11', '2019-10-11', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (21, '443069', 1, 2, '2019-09-13', '2019-09-14', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (22, '136160', 1, 7, '2019-05-18', '2019-05-25', True);
INSERT INTO REQUEST (REQUESTCD, ACCOUNTCD, EXECUTORCD, FAILURECD, INCOMINGDATE, EXECUTIONDATE, EXECUTED) VALUES (23, '136169', 5, 7, '2019-05-07', '2019-05-08', True);
COMMIT WORK;