main.py

# Code written by Jerin Rajan on 03rd Mar 2020.
'''
Table [dbo].[Borrowings] contains loan data, each row in the table
represents a single loan.
	* BRW_Term - indicates term in months.
	* BRW_State
		- 'Withdrawn'	loan has been disbursed.
		- 'Closed'		loan has been fully repaid (matured).
		- 'NotMatched'	loan has not been approved.
		- 'Default'		loan has gone into default.
	* BRW_Amount - amount borrowed.
Table [dbo].[Repayments] contains loan repayment data, each row in the
table represents a single repayment.
	* REP_State
		- 'Paid'		Repayment received successfully
		- 'Failed'		Repayment failed


Write queries that do the following:

Q1. Find total number of loans disbursed between 9th Dec 2015
and 17th Oct 2017 (both dates included).

Q2. Which year / month had the most loans with state 'Withdrawn'
(list top three with highest number of disbursals).

Q3. Check for any duplicate records.

Q4. For each term, return total number of loans that have failed
repayments.

Q5. Find all loans with state 'Withdrawn' that have no repayments.

Q6. Return the latest 3 repayment dates for each loan with state
'Withdrawn', all three dates should be on a single row.

'''
import sqlite3

# Establish a connection to the db
conn = sqlite3.connect('loan_db.sqlite')
# Cur is a data handler to perform operations
cur = conn.cursor()

# DELETE tables if they already exist
cur.execute('DROP TABLE IF EXISTS Borrowings')
cur.execute('DROP TABLE IF EXISTS Repayments')

# CREATING TABLE - dbo.Borrowings
cur.execute('''CREATE TABLE Borrowings
(
    BRW_ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
    BRW_DisbursalDate DATETIME NOT NULL,
    BRW_Repayment_Day_Of_Month SMALLINT NOT NULL,
    BRW_Interest_Rate DECIMAL(4, 4) NOT NULL,
    BRW_Amount DECIMAL(25, 8) NOT NULL,
    BRW_Term INT NOT NULL,
    BRW_MonthlyRepaymentAmount DECIMAL(24, 8) NULL,
    BRW_State NVARCHAR(18) NOT NULL,
    BRW_NotDisplayed BIT NOT NULL,
    BRW_LastUpdateTime DATETIME NOT NULL
)
''')

print('Borrowing table created')

# DATA ENTRY - Values into the fields
cur.execute('''

INSERT INTO Borrowings (
    BRW_ID,
    BRW_DisbursalDate,
    BRW_Repayment_Day_Of_Month,
    BRW_Interest_Rate,
    BRW_Amount,
    BRW_Term,
    BRW_MonthlyRepaymentAmount,
    BRW_State,
    BRW_NotDisplayed,
    BRW_LastUpdateTime
)
VALUES
('8E49213C-0A79-E511-9E6E-005056992328','2015-11-02 16:17:29.490',2,0.0988,5180,48,131.07,'Withdrawn',0,'2016-02-03 20:47:22.123'),
('6B42DB04-7D7C-E511-9E6E-005056992328','2015-11-05 16:32:30.090',5,0.2425,1240,12,117.4,'Closed',0,'2016-02-08 21:08:56.503'),
('5BCC2A59-5F7E-E511-9E6E-005056992328','2015-11-02 17:05:11.557',2,0.0944,4610,60,96.68,'Withdrawn',0,'2016-02-03 20:06:25.687'),
('AE45089C-9D99-E511-9E6E-005056992328','2015-12-07 17:04:49.173',22,0.069,9170,48,219.16,'Withdrawn',0,'2016-01-25 07:18:05.193'),
('C8F73EBA-739A-E511-9E6E-005056992328','2015-12-17 17:34:22.393',17,0.1758,5300,36,190.49,'Closed',0,'2016-01-19 21:04:29.267'),
('398B7A32-59B1-E511-9E6E-005056992328','2016-01-14 07:57:55.160',14,0.0636,4040,60,78.78,'Withdrawn',0,'2016-01-19 06:42:00.210'),
('D6DB9A51-111D-B7C8-910B-00876A9F2291','2019-07-11 01:12:22.730',12,0.2209,10334.64,36,395.16,'Default',0,'2020-06-09 06:17:23.540'),
('C997B0E7-19B0-7ABD-180E-00D1B3FAAED6','2019-01-11 08:02:30.250',3,0.1497,3487.56,18,217.52,'Withdrawn',0,'2019-08-28 10:36:53.260'),
('B4208560-AFCA-307A-0746-02263621E8E8','2018-11-08 10:32:17.290',12,0.0758,6057.11,12,525.72,'Default',0,'2019-08-08 02:37:58.720'),
('DBC6BE91-CB4F-02E2-3F52-0338E8173DD7','2016-12-28 15:39:20.140',21,0.1988,22804.35,12,2111.16,'Closed',0,'2019-06-20 13:31:02.220'),
('1F3953BC-DF93-3BFC-A915-03B9F7DA4EF7','2019-05-28 20:40:04.690',6,0.1399,23489.84,12,2108.97,'Closed',0,'2020-03-24 12:02:21.170'),
('AEB79D84-D2C4-4DAB-2C67-03DAC4276F7C','2019-05-10 16:25:21.710',20,0.1345,11044.1,12,988.76,'Closed',0,'2020-03-05 14:32:57.390'),
('84B1CC2D-00A2-0514-5E18-04A033E46D19','2018-11-22 19:51:07.350',24,0.0145,8959.56,18,503.48,'Closed',0,'2019-08-04 19:13:17.300'),
('C94524FC-3704-39F4-8F37-05FEE1310486','2019-09-14 13:17:18.880',19,0.0694,23287.13,18,1365.97,'NotMatched',0,'2019-11-20 12:07:57.030'),
('23CB635B-2AF9-8ACE-54F7-06897007DF08','2019-04-04 03:33:27.580',26,0.2459,3777.66,12,358.29,'Withdrawn',0,'2020-01-12 14:25:29.070'),
('5408558D-8D42-8F0C-1AC5-06AFAF545BF0','2019-09-25 11:25:37.770',16,0.0118,14790.54,12,1240.43,'Closed',0,'2019-12-11 09:54:45.640'),
('6ADA3882-CA98-EB4C-86FD-07478C34CBED','2019-02-28 06:57:30.570',18,0.1181,10032.97,12,890.52,'Closed',0,'2020-01-21 09:16:47.140'),
('B42A4AA5-6349-E837-EA3F-09EA14C75AA1','2019-06-18 21:35:36.520',26,0.2093,21080.23,36,793.44,'NotMatched',0,'2020-04-18 09:24:39.140'),
('2CD63ACA-28F4-52A5-D27D-0B2557B8ADF0','2018-03-07 10:55:34.060',19,0.0369,17080.75,12,1452,'Closed',0,'2018-06-18 10:37:50.260'),
('A89777C1-E7EC-D8EF-637A-0BA5BFFB15E7','2018-10-26 12:37:54.780',13,0.0857,7723.64,12,673.9,'Closed',0,'2019-10-14 02:46:47.690'),
('8374F308-0407-27FE-E398-0F2D4B3A67EF','2019-01-28 07:54:41.390',8,0.2166,12790.34,12,1195.01,'Withdrawn',0,'2019-09-10 11:40:42.000'),
('9A33688F-8ABA-8E6F-2C16-0FC79B6B1946','2019-05-30 09:39:28.360',3,0.0856,15640.23,36,494.15,'Withdrawn',0,'2020-05-10 05:24:55.500'),
('3082DE73-A675-048B-152F-1202D0A85609','2019-05-25 00:03:56.220',7,0.1508,1130.42,18,70.56,'Closed',0,'2019-05-30 20:41:59.570'),
('E6959ACC-AFDC-6B4A-0D28-12304871C7C6','2018-10-27 06:58:59.920',12,0.0767,6406.63,12,556.32,'Default',0,'2019-08-21 17:42:36.210'),
('66DAE1C6-A7B9-972C-58CD-131595FB381C','2018-06-18 01:45:57.850',17,0.2078,3758.35,18,244.81,'Default',0,'2018-12-29 18:19:34.080'),
('D476810E-DD53-CDC2-5AB6-1471B30A6112','2018-08-29 01:49:56.170',12,0.208,7553.53,24,387.4,'Withdrawn',0,'2020-02-19 16:17:40.700'),
('B1204636-888A-AF2A-1157-157B27ACF5F5','2018-02-16 19:22:13.190',15,0.2286,9029.38,24,472.27,'Withdrawn',0,'2018-07-26 01:49:25.250'),
('A37D36E3-6C2E-8D96-5D10-163C21A4082F','2018-10-25 12:07:05.320',19,0.1991,24058.14,12,2227.57,'Withdrawn',0,'2019-08-07 12:35:16.280'),
('8453E83E-18F3-D1F5-EC70-16804FE446DF','2018-08-13 01:16:46.170',8,0.0369,2102.71,48,47.18,'Withdrawn',0,'2019-02-24 19:17:56.340'),
('FD7E7F38-7603-2F0F-5F80-16992AAC16E3','2019-03-18 10:30:27.220',3,0.1168,21510.63,12,1907.97,'Closed',0,'2020-01-01 00:27:43.920'),
('1F323E66-0FF4-AFCD-E25D-1DCC6531C220','2015-12-08 12:54:40.620',24,0.0109,8149.31,18,456.65,'Closed',0,'2019-07-03 15:32:45.930'),
('D9F5601F-AC32-8C5C-EB3D-215A8E81EB3E','2018-06-07 03:03:46.810',25,0.0956,23801.85,18,1424.65,'Withdrawn',0,'2019-03-22 03:30:58.350'),
('9B477341-C7B2-0C66-55AF-22407518C9E1','2019-06-04 04:17:21.920',14,0.0191,17978.15,12,1513.72,'Withdrawn',0,'2020-04-13 14:08:49.440'),
('C621DA30-6B27-B712-77AA-22F2F12B1800','2019-08-21 05:40:23.990',17,0.0441,20106.48,18,1156.43,'Withdrawn',0,'2020-07-12 10:01:55.980'),
('B5374F41-843D-45CE-CD00-253E4C7CE757','2018-05-23 16:00:49.310',17,0.2261,6871.15,18,453.66,'Closed',0,'2019-05-03 20:40:46.430'),
('81A11536-C6CC-2754-FC0A-256170BD34B4','2018-10-28 19:29:00.810',19,0.1901,22704.71,12,2092.49,'Withdrawn',0,'2019-06-13 18:48:49.740'),
('FE9A32E2-C930-7C48-4A85-26064C13A99D','2018-10-16 09:52:53.360',21,0.2219,3516.71,12,329.46,'Withdrawn',0,'2018-12-25 09:06:09.580'),
('76280E3D-6784-8C38-754F-2B64A14518D2','2019-05-30 04:36:12.560',15,0.0407,21177.54,18,1214.8,'NotMatched',0,'2019-08-22 02:50:25.430'),
('A103A2B1-4A5F-533E-10D8-2C11D70EC0E0','2019-04-04 08:23:57.730',9,0.2068,10133.32,48,312.04,'Closed',0,'2019-05-28 16:49:16.800'),
('CAF5365A-40D8-7886-314B-2C4A97D7F1F4','2019-01-26 17:38:05.850',24,0.2435,4695.48,12,444.79,'Withdrawn',0,'2019-02-15 18:57:37.870'),
('99B252F5-3DE0-CA32-3347-2E3A734E829D','2018-09-23 11:24:36.750',3,0.1854,10693.6,12,983.13,'Withdrawn',0,'2019-06-11 17:50:22.000'),
('D96A0AEF-8AFE-5F36-BB34-2FC86E65CB46','2018-05-11 21:57:47.870',16,0.2106,4854.15,18,316.84,'Closed',0,'2019-02-10 12:46:11.500'),
('30B5899F-5330-86FF-7AED-3151F6DB3D52','2018-09-27 01:26:13.380',2,0.1627,7358.15,36,259.67,'Closed',0,'2019-01-27 15:12:30.570'),
('6AD02D41-EBC7-D78C-B940-31E8AA2B9260','2019-02-12 22:07:44.710',20,0.1679,17497.06,24,863.32,'Withdrawn',0,'2019-11-19 09:43:25.940'),
('6D19BA94-1555-1101-D546-3410B56967A8','2018-11-03 19:38:36.060',5,0.2112,13627.79,12,1269.72,'Withdrawn',0,'2019-10-10 14:26:12.730'),
('B5C19070-B154-81C6-408D-34DFA5BEEEE5','2019-03-08 08:28:56.530',8,0.2024,10008.36,48,305.83,'Closed',0,'2019-05-22 10:02:08.800'),
('FF10996F-975F-D831-9A80-3530E03A1BD9','2018-05-29 00:15:27.620',5,0.0129,24078.95,36,682.24,'Withdrawn',0,'2018-12-01 07:22:54.090'),
('66B9046D-B54A-E55B-4CD4-36735F01E1BA','2018-01-30 04:13:08.410',16,0.2482,12178.55,48,402.58,'NotMatched',0,'2018-11-29 23:58:08.310'),
('C412DC8D-D325-2155-4648-396E70D6940C','2018-03-26 11:02:10.540',23,0.0931,24822.11,24,1137.52,'NotMatched',0,'2018-04-29 06:04:40.710'),
('EAF5CF20-808B-D769-4C58-39DC39A19850','2018-09-11 11:53:12.630',15,0.1483,17584.78,24,851.2,'Default',0,'2018-11-16 00:19:11.540'),
('179377CC-055F-2C92-AEEB-3AE221BA8A81','2018-04-03 15:15:24.040',27,0.1497,8816.74,12,795.65,'Closed',0,'2019-03-19 20:20:49.730'),
('8B465958-EE1D-C29E-8247-3CA59C145740','2018-09-06 07:39:47.790',28,0.1187,1415.01,18,86.2,'Withdrawn',0,'2019-05-30 16:08:55.790'),
('203756EA-6D90-591F-8A43-4008F459B1FA','2019-02-20 03:26:11.830',27,0.0256,8875.12,18,503.11,'Closed',0,'2019-08-05 09:30:23.860'),
('BC6C98EF-3E01-44B7-C383-410F87367367','2019-03-22 05:49:29.640',22,0.191,20114.84,36,738.34,'NotMatched',0,'2020-03-06 06:00:21.500'),
('430D79BF-6229-5076-D45C-4491BF70AB83','2018-09-01 16:09:15.130',10,0.0652,5806.57,12,501.14,'Closed',0,'2019-07-25 21:34:55.110'),
('32DDD9E9-1AE9-3152-D8EB-46DC20C3F3AD','2018-07-12 08:40:55.900',2,0.1983,13930.92,12,1289.35,'Withdrawn',0,'2018-10-17 17:51:54.210'),
('B61230B0-8653-456F-C5F2-4A61E5C4028A','2019-03-08 09:21:56.610',13,0.0381,22368.4,24,969.45,'Closed',0,'2019-10-05 16:30:21.040'),
('17F41EC1-7AF2-F724-07C9-4A7755B17FA3','2018-12-16 01:23:46.650',21,0.1992,23109.1,12,2139.81,'Closed',0,'2019-07-02 08:32:13.520'),
('A3BAD951-8B90-5A17-141C-4D2A7141BE74','2019-06-23 04:23:35.490',30,0.023,6184.51,12,521.81,'Withdrawn',0,'2020-04-22 19:31:58.290'),
('797C8DB9-FCD8-BC43-1EE8-4D548D8DF271','2019-06-22 02:28:40.220',11,0.2117,9357.5,36,353.36,'NotMatched',0,'2020-04-29 18:44:40.670'),
('556A94B4-6456-2CBF-AD6B-4D660B924C98','2019-05-28 07:22:57.150',5,0.1191,20493.85,12,1819.99,'NotMatched',0,'2019-11-23 23:20:31.930'),
('9954D128-FC41-B17B-3E9E-4E1F5172ED0E','2018-12-23 19:33:52.360',15,0.1084,9884.14,12,872.83,'Closed',0,'2019-01-12 08:37:00.030'),
('0FA04DD5-42B9-1114-74F9-500588ACE23B','2019-05-19 01:08:46.460',19,0.1133,7840.54,12,694.16,'Withdrawn',0,'2019-10-28 01:27:19.410'),
('A5D9FBE1-4276-B96A-EE8D-515B51D13EBE','2019-01-24 22:21:16.040',22,0.2022,22780.65,12,2112.67,'Closed',0,'2019-06-20 19:54:31.770'),
('09CCCB17-29A3-8F83-8F80-52BB6C979CC2','2018-12-08 07:57:56.770',23,0.2341,4276.76,12,403.18,'Withdrawn',0,'2019-01-27 14:02:39.690'),
('50C00C49-748B-DC74-EED6-54F31C61FD63','2018-03-24 04:41:08.350',3,0.0177,2003.41,12,168.55,'Closed',0,'2019-02-14 09:25:52.000'),
('88800A9D-372A-66D2-9CED-55D26413F425','2019-04-26 17:47:18.120',17,0.0861,4337.41,48,107.13,'Withdrawn',0,'2019-06-06 23:38:44.700'),
('5C4D8589-AFCE-5D28-E677-5851F16CB43B','2018-08-20 00:55:55.870',4,0.2248,17014.98,18,1122.33,'Default',0,'2019-02-21 13:27:35.310'),
('1DD2E8B4-975B-EB83-FE44-58F0BB62BA8B','2018-07-16 13:29:42.600',20,0.2498,9258.97,24,494.07,'Withdrawn',0,'2018-08-11 03:02:05.190'),
('D079C81C-DB59-C6F7-09D4-5A18BC325904','2018-12-15 07:56:37.030',20,0.1904,21852.45,60,567.34,'Closed',0,'2019-05-12 08:36:39.500'),
('12B24901-1D52-29EC-55E8-5B91FB06C964','2019-04-09 15:05:32.770',27,0.0175,6785.48,18,382.21,'Withdrawn',0,'2019-05-14 19:57:01.940'),
('FE814246-6B54-B767-6D7C-5CB294E6E025','2019-09-29 00:30:50.300',8,0.1265,19235.98,12,1714.94,'Withdrawn',0,'2019-10-09 12:37:52.260'),
('54E78514-C9DB-E50C-0F26-5F7C79D6AE83','2019-03-01 08:35:18.760',1,0.098,19120.7,12,1679.23,'NotMatched',0,'2019-09-25 07:49:14.090'),
('3273F990-FD38-1CAF-912F-5FD1B3814A63','2019-04-27 04:50:03.230',16,0.0727,2404.14,36,74.53,'Withdrawn',0,'2020-03-19 14:25:48.940'),
('F6F6A87D-D3C1-3563-8F90-62333C160785','2019-08-24 18:21:57.110',10,0.1776,3256.62,18,207.41,'Closed',0,'2019-08-29 05:18:37.390'),
('2DF20E1A-D294-B9A1-4D3C-63078F8D5712','2019-05-21 07:22:56.040',20,0.1271,9786.06,12,872.73,'Default',0,'2020-01-15 01:31:51.570'),
('1E296A35-E909-D60D-446E-68AF7F861B3D','2018-09-25 16:16:15.850',19,0.1965,24243.56,12,2241.73,'Withdrawn',0,'2019-08-13 16:50:50.670'),
('1C7F206C-58E7-C919-68BD-68AFE66E98CC','2018-05-22 01:14:22.490',26,0.1152,2926.12,24,137.08,'Default',0,'2018-07-26 03:06:09.500'),
('54024915-0570-91F4-313B-68F9D7738060','2018-12-26 05:07:58.380',15,0.099,8497.1,12,746.63,'Closed',0,'2019-11-17 05:09:25.160'),
('911E2242-B3BB-ECA3-3957-6950C298F9EB','2018-02-01 03:39:29.250',4,0.0465,7110.94,12,607.61,'Closed',0,'2018-09-07 05:37:58.710'),
('CC3163FC-697F-B7BB-8B40-6AA95B5D534E','2019-02-13 21:54:52.800',26,0.0096,6691.04,18,374.55,'NotMatched',0,'2019-05-08 12:56:17.580'),
('E34D0D9E-5330-475C-C6B5-6BF18FE74B94','2018-03-16 21:34:31.990',8,0.0925,12917.14,24,591.59,'NotMatched',1,'2018-05-02 16:14:45.130'),
('22A53B69-1603-3799-8E91-6DAFA5D3C2D8','2019-05-04 12:08:22.970',15,0.0417,21803.21,18,1251.67,'Default',0,'2019-09-15 08:04:55.170'),
('01A3F4BB-E7B3-A7B6-6D9B-7424B4C05F9F','2019-06-09 13:21:09.860',11,0.2169,10341.33,36,393.28,'Default',0,'2020-06-08 02:46:58.970'),
('904E3092-17C7-B630-72D0-744E861C6EE6','2018-07-12 19:34:02.990',20,0.0003,9417.53,24,392.51,'Withdrawn',0,'2018-08-17 09:18:57.270'),
('159350A4-87FD-D064-9100-752BD2023927','2019-03-08 22:59:47.700',29,0.0541,12654.17,24,557.48,'Closed',0,'2020-01-06 09:56:14.790'),
('03B912F3-C13B-2EE4-27F5-755030910D71','2018-02-13 09:16:14.740',3,0.018,2775.26,12,233.53,'Closed',0,'2018-03-15 22:47:10.740'),
('6707B28B-84EA-A11E-1182-776D108AA2F6','2018-01-30 21:47:40.200',13,0.1961,4676.91,18,302.01,'Closed',0,'2019-01-29 19:10:00.570'),
('4B327C2E-55F7-480F-9478-780E96ECCBC1','2018-10-13 03:38:28.150',14,0.1212,13077.95,18,798.24,'Withdrawn',0,'2019-05-18 15:51:24.290'),
('624060A2-850C-7051-4EAE-78CA3248025A','2018-07-27 07:12:10.350',30,0.1654,8905.65,60,219.13,'Withdrawn',1,'2019-03-28 14:44:13.450'),
('45E4CF31-6FFA-61D2-5A0A-7A59630B5063','2018-06-04 10:02:05.790',28,0.1552,8438.92,60,203.07,'Withdrawn',0,'2019-03-07 07:20:15.100'),
('F6225791-40E4-D2EB-255E-7AB467F53B6C','2018-12-02 18:39:49.080',17,0.1389,14668.52,18,907.44,'Withdrawn',0,'2019-07-24 10:41:42.550'),
('2F5D0956-C5CF-B36E-AD7C-7AD82E994B4E','2019-07-11 11:31:13.690',29,0.0088,3787.79,12,317.15,'Withdrawn',0,'2020-01-17 10:29:19.260'),
('187F22EF-A925-72C5-D9C3-7B150176AB93','2019-08-05 07:02:11.940',23,0.1504,11711.58,12,1057.28,'Default',0,'2020-04-05 13:46:24.990'),
('0D331A11-2B2D-F666-9B1A-7C3ACEC477A2','2018-04-30 10:32:45.360',10,0.1133,15066.75,24,704.53,'Default',0,'2018-07-30 20:38:23.460'),
('875D83BE-BEFA-D788-F78E-7E67DA2E2F10','2018-07-16 12:38:19.360',11,0.1033,12173.83,18,732.97,'Withdrawn',0,'2019-04-08 00:07:26.100'),
('E70549B5-4742-FB7A-C447-7F78AAB1834D','2019-01-18 19:03:14.140',30,0.089,18602.66,12,1625.96,'NotMatched',0,'2019-09-02 10:41:59.610'),
('07976B81-E257-1805-C726-804366B9C756','2019-05-19 06:22:26.340',7,0.1572,2158.17,18,135.36,'Withdrawn',0,'2019-07-11 06:50:39.560'),
('D0019997-EC6E-5E96-B07C-838B6DE35692','2019-08-08 21:25:22.240',24,0.1665,13957.41,18,881.6,'Closed',0,'2020-07-05 19:36:09.610'),
('3162DD41-D398-D007-A65D-83DBEBABAA5D','2019-08-09 05:49:54.810',22,0.131,8843.95,12,790.33,'Withdrawn',0,'2019-12-11 10:53:10.400'),
('81AF13E2-8951-ED3D-CDD3-85276D8FF289','2018-12-15 04:56:21.060',10,0.0163,20791.3,18,1170.03,'Closed',0,'2019-07-29 23:37:11.360'),
('C9788C94-88AA-375D-6F9B-868379DED953','2018-08-16 03:44:29.000',21,0.2479,8415.9,24,448.28,'Closed',0,'2019-07-09 07:29:08.640'),
('8BAC47FB-96AD-AB7F-3EB8-86C3933AF810','2019-05-22 18:03:54.130',8,0.183,5802.5,24,290.52,'Withdrawn',0,'2019-12-06 05:45:43.350'),
('E850159D-AC6E-B37D-8F49-8738BE0DFB49','2018-10-06 13:22:01.110',23,0.0152,9949.08,24,421.14,'Withdrawn',0,'2019-09-11 19:17:54.950'),
('A636AE06-6829-EF6D-BB81-8739AB8470F5','2018-06-13 17:17:41.330',5,0.0043,22544.29,24,943.55,'Withdrawn',0,'2018-09-30 18:36:42.520'),
('E06685AE-A9D0-9490-1879-8871F441EA43','2018-07-08 13:43:16.670',4,0.2282,18302.53,18,1210.28,'Closed',0,'2019-04-12 20:48:28.960'),
('9CAB0B55-2330-0F70-29A0-88D56B951877','2019-03-29 20:45:20.330',29,0.0418,10492.09,24,456.45,'Closed',0,'2019-10-11 16:05:56.040'),
('00BB1074-01FE-3271-A09A-8951DE22F69C','2019-06-18 16:34:46.800',26,0.2097,21134.26,36,795.9,'NotMatched',0,'2020-04-20 13:46:02.310'),
('2FB95E70-6B3D-40D8-33A2-8BDE48F9A588','2018-09-04 11:38:36.990',16,0.1554,18727.85,36,654.17,'Closed',0,'2019-01-01 01:19:39.280'),
('DED0F5C0-CE1E-EED8-EA83-8C1A91C61C0B','2018-04-11 02:09:03.410',11,0.1412,19439.37,60,453.53,'Withdrawn',0,'2019-01-23 07:45:42.990'),
('33053B8C-DAF6-201B-0E5A-8E4223CDC082','2019-05-28 11:09:39.540',28,0.0088,4619.42,12,386.78,'Withdrawn',0,'2020-02-18 04:24:04.940'),
('955580B6-7AEB-615D-E96B-8FCAC0EB335D','2019-01-08 08:39:42.490',19,0.1597,16978.36,24,831.07,'Withdrawn',0,'2019-10-27 18:26:52.590'),
('E1C2D783-F61B-2F08-2724-905624F18ABA','2019-02-18 10:33:44.500',19,0.1379,13061.61,18,807.42,'Withdrawn',0,'2019-05-23 18:31:05.820'),
('30F61B8C-9057-DEA2-A6FF-929FB7E09599','2018-05-25 18:28:14.170',3,0.2344,20017.79,24,1052.77,'Withdrawn',0,'2018-06-19 11:00:35.500'),
('096D6766-35C6-B162-F083-938176EECAB9','2019-02-17 04:31:43.260',9,0.2334,14839.04,12,1398.43,'Withdrawn',0,'2019-12-03 11:11:51.870'),
('C34210A5-6FE6-E22E-AFEB-93B2720CCEA4','2018-09-13 21:42:45.180',10,0.0587,4631.36,12,398.32,'Default',0,'2019-06-08 18:55:26.460'),
('881694D0-16F8-0647-BD24-958E305CDA7C','2019-07-08 09:49:50.510',29,0.0077,3689.51,12,308.74,'Withdrawn',0,'2020-01-13 07:30:41.740'),
('32404FF1-9BE2-4AFC-0C4C-95EBF8FFD81D','2018-12-01 22:33:40.960',26,0.0401,12466.14,24,541.39,'Withdrawn',0,'2018-12-25 10:08:03.450'),
('CD867D11-655C-623D-9F4C-9647C96BF455','2019-08-24 18:14:59.930',12,0.2116,8141.58,24,419,'Withdrawn',0,'2020-03-14 08:00:19.820'),
('AAEE799B-953E-C16D-8F9F-970DAEB0AF7D','2018-12-05 16:17:56.270',22,0.2252,3044.15,12,285.67,'Withdrawn',0,'2018-12-08 11:26:10.260'),
('473A97A8-740E-A19F-0088-9AEAD5565E65','2018-11-29 09:34:45.150',7,0.23,15850.8,12,1491.18,'Withdrawn',0,'2019-01-09 21:47:53.590'),
('BA4251DA-7AF7-E1BD-745E-9B3E1955C99F','2019-03-08 04:07:48.510',13,0.0376,22289.7,24,965.54,'Closed',0,'2019-10-02 11:40:05.320'),
('42CEB705-FA1D-4EFD-03C8-9BD89414BB8F','2018-06-09 01:37:11.580',3,0.2312,19295.96,18,1278.79,'Closed',0,'2019-05-21 19:52:36.340'),
('C0BB565B-C4A1-1443-B9E0-9D926F3492B1','2019-08-27 07:12:29.360',1,0.0137,3611.99,12,303.23,'Closed',0,'2020-01-12 09:56:38.330'),
('751C6038-CC50-B610-F85D-9FF93B861FB6','2019-08-06 15:14:40.610',3,0.065,11393.22,18,666.02,'Default',0,'2019-11-23 01:21:05.720'),
('3D20F34F-8ACB-2A2D-1A84-A1E01366BFC0','2019-08-01 08:28:10.570',1,0.0331,6900.5,18,393.48,'Withdrawn',0,'2020-05-23 14:44:18.170'),
('0620E34E-1737-2882-D4AF-A2C4A6E87B82','2018-11-06 08:39:16.060',1,0.1397,3294.4,24,158.12,'Withdrawn',0,'2019-08-17 15:21:09.280'),
('2728B8E1-327E-B204-2205-A506C436B3CA','2018-07-23 02:05:06.500',11,0.1014,11771.96,18,707.74,'Withdrawn',0,'2019-03-23 00:03:24.320'),
('96A8D8EF-C8D8-DC0D-A05C-A56DADFE9E61','2018-04-19 12:43:35.110',19,0.0169,13398.86,60,233.03,'NotMatched',0,'2019-01-22 01:26:59.670'),
('EFB3F4D2-B73F-0E15-1F52-A58B5BFC9EBB','2019-04-05 20:41:31.970',24,0.2043,21749.57,36,813.06,'Closed',0,'2019-05-13 04:56:03.640'),
('83A80A65-F75D-2163-5C9E-A5C757A806BE','2018-12-22 16:26:01.430',2,0.1289,24867.91,18,1526.79,'Withdrawn',0,'2019-05-13 07:35:50.500'),
('E282BE1D-FF52-5AED-161B-A62E10DA38DE','2018-05-21 08:27:35.510',1,0.1999,15132.9,18,979.98,'Default',0,'2018-12-03 03:36:55.530'),
('3DBF1069-AF98-0EFE-A870-A6812116F366','2019-04-05 21:01:50.600',18,0.1057,7551.9,12,665.93,'NotMatched',0,'2019-10-14 09:53:14.090'),
('06B247E1-EEA4-EF62-1111-A7838E4E0DBF','2017-10-17 07:36:14.620',8,0.1351,21007.77,12,1881.38,'Closed',1,'2019-12-19 02:10:45.490'),
('0FB9B0B2-E755-48AA-3D02-A88D322EF68C','2018-11-18 04:08:16.360',18,0.169,19278.16,36,686.35,'Closed',0,'2019-01-26 17:37:46.590'),
('E3158381-E237-AE93-2B50-A8EF3D4F29D9','2018-05-27 02:18:15.060',10,0.1063,13560.81,24,629.71,'NotMatched',0,'2018-05-31 23:39:05.950'),
('06DF2FA9-172D-A020-7D3D-AA1E92F550F4','2019-04-28 18:28:42.810',15,0.0445,22325.17,18,1284.44,'Closed',0,'2019-10-06 05:55:44.430'),
('29F03814-7D4F-509A-781A-AADF2D904D17','2019-09-04 16:04:31.190',8,0.129,20048.96,12,1789.77,'Withdrawn',0,'2019-11-10 09:37:48.950'),
('50267CE6-007B-B43E-306E-AAEC5CEC09C1','2019-09-25 05:21:54.820',8,0.1208,18484.28,60,411.92,'Withdrawn',0,'2020-09-07 20:52:32.610'),
('EBA2E72B-BE96-377A-9C73-AB82E70F3B1D','2019-07-16 20:34:04.670',17,0.0542,22229.97,18,1288.66,'NotMatched',0,'2019-10-05 22:40:46.260'),
('3D9FBBF2-448E-D277-8E56-AC15C541C2ED','2019-02-12 06:25:47.620',14,0.0625,2330.36,36,71.15,'Withdrawn',0,'2019-03-14 06:45:47.780'),
('391B6E8D-9A75-6F4F-7BAC-ACE9075839B7','2019-04-24 04:37:48.460',18,0.1097,7791.82,12,688.54,'NotMatched',0,'2019-10-24 23:11:03.130'),
('143AD437-2809-43B9-C473-ADA070426D10','2019-08-17 06:04:57.260',27,0.204,19193.8,24,980.63,'Withdrawn',0,'2020-02-04 13:23:14.580'),
('2633A837-81D8-D2FE-3595-ADA56C258725','2018-09-27 12:30:53.950',22,0.0072,8967.89,24,376.47,'Closed',0,'2019-08-02 14:31:06.440'),
('0E5AD9C3-65CF-C270-A563-B0F3F36FC6A0','2018-05-02 16:11:52.470',23,0.0807,22337.33,18,1321.75,'Withdrawn',0,'2019-01-20 03:45:08.310'),
('C541B083-8975-A7C6-1A6B-B38C2DB09869','2019-09-01 12:20:06.020',26,0.1825,15816.49,18,1011.06,'Closed',0,'2019-09-21 06:37:07.960'),
('794648C3-1E0A-B0C0-361E-B6D5CD585FE5','2019-01-29 21:11:57.950',16,0.1074,9043.17,12,798.15,'Closed',0,'2019-12-10 22:06:39.430'),
('16C91C79-5CB7-56EB-39B6-B73589988BC7','2018-01-16 01:46:13.120',13,0.2027,5897.06,18,382.67,'Withdrawn',0,'2018-03-19 14:45:40.630'),
('DD802EF9-0C7E-77DE-D767-B83566478FC8','2018-06-23 16:27:59.550',30,0.1699,10185.13,12,928.88,'Closed',0,'2019-05-17 23:47:20.650'),
('B8D1C87F-C504-2B51-96E8-B857D6ACE8F6','2018-09-16 06:12:27.960',18,0.1859,22898.67,12,2105.78,'Withdrawn',0,'2019-06-19 17:38:32.970'),
('4C83314C-0998-82EF-9F5C-B990654EF3E4','2018-05-20 14:00:42.150',18,0.2296,7433.27,24,389.15,'Withdrawn',0,'2018-05-26 12:28:57.310'),
('1360A1C8-C6CB-3983-AEE6-BAA2B5E13BD1','2018-08-04 05:35:55.680',24,0.0641,18176.5,12,1567.81,'Closed',0,'2018-08-08 14:55:55.230'),
('EF8FB7F4-BDC3-292C-4F3F-BB0F152A5A3C','2018-07-17 08:08:25.220',4,0.2385,19626.98,18,1307.72,'Closed',0,'2019-06-05 23:24:12.640'),
('0642F3A2-43D0-912F-8800-BBBA4A1F4B17','2018-06-12 15:32:58.650',20,0.0031,10386.53,24,434.17,'Withdrawn',0,'2018-09-24 07:53:54.460'),
('7DF39475-E984-02F6-F00A-BD6BB6DF1D5E','2018-02-04 15:36:54.870',26,0.154,10516.95,12,951.22,'Closed',0,'2018-05-25 04:35:53.040'),
('069094D3-97D2-D920-3E94-BF41C42179D3','2019-03-02 12:06:03.660',15,0.071,3210.85,36,99.28,'Withdrawn',0,'2019-04-19 19:28:18.810'),
('3A110E58-1BAF-E5F6-8986-BF6E22451869','2018-04-25 07:57:11.010',8,0.0856,11170.41,18,663.48,'Withdrawn',0,'2019-02-22 14:41:35.110'),
('69499FC3-B466-7D68-9FD1-C1B06D756859','2019-05-11 06:26:43.590',19,0.1085,7301.19,12,644.78,'Withdrawn',0,'2019-10-05 20:04:46.820'),
('28461816-6890-E1E3-D5AD-C2A8DB7C44EA','2018-09-10 20:23:41.820',16,0.1573,18891.43,36,661.65,'Closed',0,'2019-01-07 23:25:33.680'),
('5557CAA9-0B11-B81C-21D2-C3878742208B','2019-08-21 16:26:24.110',4,0.0698,11796.46,24,528.05,'Default',0,'2019-12-10 02:06:02.280'),
('1E4B1A35-7DC3-498C-3C60-C4733C354D36','2019-03-18 02:37:14.010',10,0.2354,14585,12,1375.9,'Withdrawn',0,'2019-11-24 11:09:43.950'),
('12240FF3-B520-6521-9CEE-C7350CDCC5A3','2018-11-29 00:52:23.050',1,0.1313,1657.56,18,101.95,'Withdrawn',0,'2019-06-13 06:39:03.920'),
('528FF567-91B4-25DE-79BA-FA86536146D3','2018-04-17 09:47:25.170',30,0.2042,16397.63,18,1065.27,'Closed',0,'2019-01-21 21:57:46.660'),
('BCC439CD-104B-96C6-F733-C741A922C2A3','2019-08-17 09:00:30.320',20,0.0905,2859.14,24,130.68,'Closed',0,'2020-04-12 02:27:06.680'),
('527B7682-60DA-C685-F2CC-CAADFCAEA1CB','2018-01-22 13:27:54.590',8,0.1152,17180.23,36,566.69,'Withdrawn',0,'2018-10-20 04:03:09.880'),
('FE521102-B5F5-CA9B-B235-CAB69F6568E7','2018-03-16 16:44:16.730',6,0.0653,9004.82,18,526.52,'Withdrawn',0,'2018-11-25 00:02:31.180'),
('639AD403-1831-B758-FDD6-CADC207C68CE','2018-03-18 05:09:58.700',25,0.1236,5368,36,179.21,'Closed',0,'2018-10-30 05:50:46.350'),
('54BAAF9F-6416-7714-C118-CB6FAAB0B78C','2019-08-03 05:52:16.940',14,0.2411,12806.29,12,1211.63,'Closed',0,'2019-09-19 13:04:45.680'),
('F667039C-7B4B-4543-76B3-CD046F4245BF','2018-06-01 21:59:49.860',21,0.0349,15174.13,12,1288.54,'Closed',0,'2019-04-06 00:14:09.430'),
('9AAD1C11-8FBE-5B5A-1056-CD64122C06E1','2018-05-01 12:27:30.410',17,0.2283,7597.05,24,397.24,'Withdrawn',0,'2018-06-01 07:18:17.070'),
('8BEE5C04-0EEC-D701-FC11-CD800A2E5C92','2018-08-04 16:48:50.420',11,0.0844,9096.14,12,793.11,'Withdrawn',0,'2018-12-05 01:13:16.930'),
('82AD0F6D-6E24-1331-EB89-CDC550E43C46','2018-10-13 10:03:16.460',4,0.1904,11031.25,12,1016.81,'Withdrawn',0,'2019-06-26 08:01:31.840'),
('C6B63E38-78C9-1E72-2913-D0B20DDAC7EF','2018-12-22 02:59:00.980',12,0.0595,2881.58,48,67.6,'Withdrawn',0,'2019-04-03 06:57:50.100'),
('982F4644-5F07-F9B4-1C5E-D0D057CCA820','2018-02-07 04:55:40.410',26,0.157,10908.76,12,988.21,'Closed',0,'2018-06-10 04:42:52.900'),
('2DB874DC-ACCE-A766-B616-D13FE51A410A','2019-09-05 22:18:35.440',5,0.0762,12423.24,24,559.71,'Default',0,'2020-01-05 04:37:42.050'),
('D41A2378-DC1E-F3DD-DEAA-D25FB924454D','2019-01-12 23:43:37.140',10,0.0173,20401.59,18,1149,'Closed',0,'2019-07-15 11:23:13.530'),
('AC631786-926B-81CA-D59D-D2C69E156972','2019-05-07 00:41:19.850',21,0.1522,13662.85,18,853.76,'Closed',0,'2019-06-20 15:31:11.800'),
('F0D02C5E-215C-E93A-DCE4-D4AE11AE6D05','2019-07-01 20:17:42.580',11,0.2045,8138.66,24,416.01,'Withdrawn',0,'2020-03-11 18:55:42.480'),
('EF539E65-2684-D87A-A71B-D518C7075C21','2019-03-28 04:58:49.780',3,0.1117,20580.76,12,1820.59,'Default',0,'2019-11-24 17:56:44.630'),
('178C92CA-1C49-4D2A-A427-D5DFC0953326','2019-05-10 14:02:00.620',29,0.0291,7876.7,18,447.74,'Withdrawn',0,'2019-06-29 11:30:40.410'),
('A0E8F8B7-2876-59E5-E838-D6E5ECDE78BE','2019-03-24 17:45:21.950',22,0.1883,19674.4,24,990.13,'NotMatched',0,'2020-02-17 12:00:25.360'),
('79453C9F-4EBD-5C84-28FE-D76DF85B895F','2018-03-12 05:33:39.240',12,0.1661,23596.47,12,2147.74,'Closed',0,'2018-07-09 13:45:18.660'),
('D7CD15A8-4CD8-6C15-1B88-D920EEE49E77','2019-08-02 07:14:17.200',7,0.1379,21962.07,12,1969.74,'NotMatched',0,'2020-01-25 11:41:27.040'),
('972FE97A-5C1C-1C77-F9FB-DA770E66EC53','2018-09-07 02:45:33.160',8,0.0276,24288.88,36,703.78,'Withdrawn',0,'2018-12-14 08:54:28.050'),
('26A83F17-411E-0E87-CA1E-DAB8E0515F1D','2019-01-14 13:55:10.590',2,0.1226,23523.69,18,1437.36,'Closed',0,'2019-03-20 19:57:03.330'),
('83A4DFBA-1DDC-1C90-991E-E868FF0BEC53','2018-01-23 12:35:08.220',20,0.0711,22820.75,18,1340.37,'Withdrawn',0,'2018-02-04 07:11:55.860'),
('20BFE0DE-BACA-AD12-24FC-ECA4176E6312','2019-05-18 06:53:16.640',14,0.0337,20394.15,18,1163.47,'NotMatched',0,'2019-07-20 19:28:30.830'),
('9011AFD2-1C39-3141-9BE8-EDAA2F3FE3DE','2018-07-24 22:40:22.610',28,0.1324,4202.32,24,200.26,'Default',0,'2018-09-18 18:16:48.830'),
('BB7F4C8E-84F0-F91E-8FFA-EDC2EC887B6A','2018-12-20 13:31:08.860',8,0.2289,15299.91,12,1438.54,'Withdrawn',0,'2019-12-19 12:27:01.880'),
('5DF33EED-0C92-D12C-6AB0-EEDA12C3DB84','2019-07-22 05:25:24.080',3,0.0749,13096.62,24,589.28,'Closed',0,'2020-01-30 10:41:16.440'),
('7B84444D-7068-277A-02A0-EF45248E9337','2019-08-06 20:10:30.430',22,0.1268,8283.81,12,738.64,'Withdrawn',0,'2019-11-18 15:04:58.140'),
('87CE0771-D3CC-5F20-B2A8-EF8F332869AA','2019-09-01 13:23:28.750',15,0.249,13386.78,12,1271.68,'Closed',0,'2019-10-14 09:44:49.790'),
('827DEF7F-5B29-35AB-1FCC-EFAA7023B0AC','2019-09-06 11:55:42.080',18,0.0553,21415.22,18,1242.49,'Withdrawn',0,'2020-09-04 05:25:57.410'),
('3239B380-8FB7-B444-0322-F08E5E177854','2019-03-27 17:10:44.510',3,0.11,20354.28,12,1798.94,'Default',0,'2019-11-15 12:58:03.830'),
('07E1C84E-3D8E-9C2E-67BB-F0E9128EB1E2','2018-08-26 12:40:48.100',7,0.0074,21597.57,24,906.85,'Withdrawn',0,'2018-08-26 16:50:54.820'),
('58FB7217-7698-0069-41DF-F1BB04A5801B','2018-05-02 23:02:28.390',15,0.186,1482.37,12,136.32,'Closed',0,'2018-09-26 09:14:17.810'),
('83FCA2DE-7389-C0C3-E8DD-F21B3FEE61A6','2018-05-25 22:17:55.980',18,0.2315,7601.29,24,398.67,'Withdrawn',0,'2018-06-02 13:47:48.840'),
('E613574C-0336-18E6-50BB-F489F7C3C910','2018-09-07 05:19:29.010',23,0.0267,12157.3,24,520.76,'Withdrawn',0,'2018-12-09 00:56:54.870'),
('EE26F5EC-4F04-E4CF-C85B-F7EF5ADAE6BC','2018-05-10 22:28:38.170',24,0.0871,23090.13,18,1373.05,'Withdrawn',0,'2019-02-20 01:24:02.770'),
('2F162A36-F4EA-09F2-B822-F80857E3AA64','2019-06-15 16:49:36.900',14,0.0246,18550.33,18,1050.76,'Withdrawn',0,'2020-05-07 07:30:59.250'),
('7A31E75B-3180-53B0-E76A-F839424815A5','2018-12-16 23:19:38.240',26,0.0406,12256.24,24,532.55,'Withdrawn',0,'2018-12-17 14:03:56.860'),
('4D801C6C-8BA3-F0E6-69E5-FA4ABA0D7348','2018-11-14 21:44:17.400',17,0.1527,16998.16,24,826.36,'NotMatched',0,'2019-10-26 02:54:15.810'),
('528FF567-91B4-25DE-79BA-FA86536146D2','2019-02-06 23:54:40.100',27,0.0394,11111.14,24,482.2,'Closed',0,'2019-11-03 11:41:58.010'),
('60AD4114-871F-F777-11FC-FC4F3F75C3ED','2018-04-17 09:47:25.170',30,0.2042,16397.63,18,1065.27,'Closed',0,'2019-01-21 21:57:46.660'),
('66382123-E1D7-DE52-7070-FD89DF67C578','2019-03-07 11:48:24.550',28,0.0318,9468.44,18,539.36,'Closed',0,'2019-08-30 03:34:38.610'),
('811E44DB-93EB-FCAE-21AB-FF4FE7BAB169','2019-03-07 02:50:00.840',6,0.1798,6786.55,24,338.74,'NotMatched',0,'2020-01-11 16:48:03.040'),
('5DC6C348-C240-6E2E-9E0C-FF6DF91386C3','2018-05-20 20:28:39.420',25,0.097,24332.88,18,1458,'Withdrawn',0,'2019-04-11 21:43:48.010');
''')

# Save the database
conn.commit()
print('Borrowing values entered')

# CREATING TABLE - dbo.Repayments
cur.execute(''' CREATE TABLE Repayments
(
    REP_ID UNIQUEIDENTIFIER NOT NULL,
    REP_State VARCHAR(16) NOT NULL,
    REP_Amount DECIMAL(18, 2) NULL,
    REP_RepaymentDate DATETIME NULL,
    REP_Borrowing UNIQUEIDENTIFIER NOT NULL,
    REP_Deleted BIT NOT NULL,
    REP_RepaymentType VARCHAR(20) NOT NULL,
    REP_LastUpdateTime DATETIME NOT NULL,
    PRIMARY KEY (REP_ID),
    FOREIGN KEY (REP_Borrowing) REFERENCES Borrowings(BRW_ID)
)
''')
print('Repayments Table Created\n')

#     PRIMARY KEY (REP_ID),
    # FOREIGN KEY (REP_Borrowing) REFERENCES Borrowings(BRW_ID)
# cur.execute('''
# ALTER TABLE Repayments WITH CHECK
# ADD FOREIGN KEY (REP_Borrowing)
#     REFERENCES Borrowings (BRW_ID);
# ''')



cur.execute('''

INSERT INTO Repayments(
	REP_ID,
    REP_State,
    REP_Amount,
    REP_RepaymentDate,
    REP_Borrowing,
    REP_Deleted,
    REP_RepaymentType,
    REP_LastUpdateTime
)
VALUES
('B09A1604-50CA-34FF-3A6A-A818761146A3', 'Paid', 2105.78, '2018-10-18 06:12:27.000', 'B8D1C87F-C504-2B51-96E8-B857D6ACE8F6', 0,'First','2018-10-18 06:12:27.000'),
('A9824DDB-3649-F01D-41B4-8D83D9EC65DB', 'Paid', 397.24, '2018-08-17 12:27:30.000', '9AAD1C11-8FBE-5B5A-1056-CD64122C06E1', 0,'Regular','2018-08-17 12:27:30.000'),
('0F2923EB-8136-E5B8-C703-DE7195F3243C', 'Paid', 661.65, '2018-10-16 20:23:41.000', '28461816-6890-E1E3-D5AD-C2A8DB7C44EA', 0,'First','2018-10-16 20:23:41.000'),
('FB95656A-A0F7-91E6-EA88-C58FFB3871E6', 'Paid', 1398.43, '2019-04-09 04:31:43.000', '096D6766-35C6-B162-F083-938176EECAB9', 0,'Regular','2019-04-09 11:32:16.000'),
('0BBD6419-4C17-A904-E9F9-FFA7CA2B3374', 'Paid', 259.67, '2018-11-02 01:26:13.000', '30B5899F-5330-86FF-7AED-3151F6DB3D52', 0,'Regular','2018-11-02 01:26:13.000'),
('B5FA4615-7143-33C8-D4A2-A53A057B527F', 'Paid', 398.32, '2018-10-10 21:42:45.000', 'C34210A5-6FE6-E22E-AFEB-93B2720CCEA4', 0,'First','2019-06-11 09:31:44.000'),
('7CA49E9A-8D02-CF26-2FC9-04BD4AF12C6A', 'Paid', 200.26, '2018-09-28 22:40:22.000', '9011AFD2-1C39-3141-9BE8-EDAA2F3FE3DE', 0,'Regular','2018-10-04 01:42:34.000'),
('CAA44A33-3DD5-19A1-9E1A-E571ED29F909', 'Paid', 907.44, '2019-02-17 18:39:49.000', 'F6225791-40E4-D2EB-255E-7AB467F53B6C', 0,'Regular','2019-02-22 21:42:01.000'),
('0400AECC-4116-A0A3-36B3-22E9C033F594', 'Paid', 482.2, '2019-03-27 23:54:40.000', '528FF567-91B4-25DE-79BA-FA86536146D2', 0,'First','2019-03-27 23:54:40.000'),
('B9A9FFC7-AEEF-9C01-9ACA-35A30CE04148', 'Paid', 969.45, '2019-05-13 09:21:56.000', 'B61230B0-8653-456F-C5F2-4A61E5C4028A', 0,'Regular','2019-05-13 09:21:56.000'),
('FCA2B62D-79B4-EAB2-8280-1A3C4A1C18C7', 'Paid', 1526.79, '2019-02-02 16:26:01.000', '83A80A65-F75D-2163-5C9E-A5C757A806BE', 0,'Regular','2019-02-02 16:26:01.000'),
('1308B710-1B48-C385-0CBB-A25271801150', 'Paid', 1065.27, '2018-05-30 09:47:25.000', '60AD4114-871F-F777-11FC-FC4F3F75C3ED', 0,'First','2018-05-30 16:47:58.000'),
('D1B5DD01-14D6-7C3E-D081-0B3A56430C6D', 'Paid', 395.16, '2019-10-12 01:12:22.000', 'D6DB9A51-111D-B7C8-910B-00876A9F2291', 0,'Regular','2019-10-12 08:12:55.000'),
('C5E1E947-6C62-4235-E652-D77B01C4570D', 'Paid', 1820.59, '2019-04-03 04:58:49.000', 'EF539E65-2684-D87A-A71B-D518C7075C21', 0,'First','2019-04-03 04:58:49.000'),
('3DFDB1EB-3B9C-4F69-3F74-5E9AF7AA98B6', 'Paid', 1458, '2018-09-25 20:28:39.000', '5DC6C348-C240-6E2E-9E0C-FF6DF91386C3', 0,'Regular','2018-09-26 03:29:12.000'),
('FA3B7183-4F43-D722-49D5-4F7BF57E4DF8', 'Paid', 403.18, '2019-02-23 07:57:56.000', '09CCCB17-29A3-8F83-8F80-52BB6C979CC2', 0,'Regular','2019-02-23 14:58:29.000'),
('86834521-1C83-C0A1-0042-97DBBC4C62D5', 'Paid', 397.24, '2018-09-17 12:27:30.000', '9AAD1C11-8FBE-5B5A-1056-CD64122C06E1', 0,'Regular','2019-06-11 09:31:44.000'),
('9A034724-D050-F650-530E-2EDEAE920DEA', 'Paid', 1149, '2019-02-10 23:43:37.000', 'D41A2378-DC1E-F3DD-DEAA-D25FB924454D', 0,'First','2019-02-11 06:44:10.000'),
('9BEE0742-59D8-7695-03A7-5BBC568DD7FB', 'Paid', 395.16, '2019-11-12 01:12:22.000', 'D6DB9A51-111D-B7C8-910B-00876A9F2291', 0,'Regular','2019-11-12 01:12:22.000'),
('A72EA643-394F-86D2-D381-414C17D0BAEB', 'Paid', 1321.75, '2018-06-23 16:11:52.000', '0E5AD9C3-65CF-C270-A563-B0F3F36FC6A0', 0,'First','2018-06-23 16:11:52.000'),
('6E30E082-82CA-D5A1-005A-6D5171D0AEBB', 'Paid', 654.17, '2018-11-16 11:38:36.000', '2FB95E70-6B3D-40D8-33A2-8BDE48F9A588', 0,'Regular','2018-11-16 11:38:36.000'),
('9D26A026-2CBE-1C77-5C0A-8782F23B7F12', 'Paid', 1798.94, '2019-05-03 17:10:44.000', '3239B380-8FB7-B444-0322-F08E5E177854', 0,'Regular','2019-06-11 09:31:44.000'),
('2F3B8B5E-D1FB-73CB-AEA6-014F051C074D', 'Paid', 807.42, '2019-04-19 10:33:44.000', 'E1C2D783-F61B-2F08-2724-905624F18ABA', 0,'Regular','2019-04-24 13:35:56.000'),
('7ED8B6BD-8C16-DA14-3724-36C595DD7F6B', 'Paid', 890.52, '2019-05-18 06:57:30.000', '6ADA3882-CA98-EB4C-86FD-07478C34CBED', 0,'Regular','2019-05-18 06:57:30.000'),
('5DD33619-E507-E60B-B978-164967A01171', 'Paid', 312.04, '2019-07-09 08:23:57.000', 'A103A2B1-4A5F-533E-10D8-2C11D70EC0E0', 0,'Regular','2019-07-09 08:23:57.000'),
('FD5679C7-7466-CA7C-695C-E080A236630B', 'Paid', 1057.28, '2019-10-23 07:02:11.000', '187F22EF-A925-72C5-D9C3-7B150176AB93', 0,'Regular','2019-10-23 07:02:11.000'),
('05D6433D-2F87-BAC1-871F-E2D36A076B2E', 'Paid', 872.83, '2019-01-15 19:33:52.000', '9954D128-FC41-B17B-3E9E-4E1F5172ED0E', 0,'First','2019-01-15 19:33:52.000'),
('6DCF94F1-5CC7-0EC3-47ED-8838BBB4663B', 'Paid', 539.36, '2019-04-28 11:48:24.000', '66382123-E1D7-DE52-7070-FD89DF67C578', 0,'First','2019-05-03 14:50:36.000'),
('2187C2C1-94EC-3683-7FF1-F66694360A05', 'Paid', 644.78, '2019-07-19 06:26:43.000', '69499FC3-B466-7D68-9FD1-C1B06D756859', 0,'Regular','2019-07-19 06:26:43.000'),
('4E71696F-27EB-EDB5-DA14-F3F86A7BAEA4', 'Paid', 395.16, '2019-12-12 01:12:22.000', 'D6DB9A51-111D-B7C8-910B-00876A9F2291', 0,'Regular','2019-12-12 01:12:22.000'),
('DCD0B6F8-611F-AE25-2132-26F985F230E5', 'Paid', 746.63, '2019-03-15 05:07:58.000', '54024915-0570-91F4-313B-68F9D7738060', 0,'Regular','2019-03-15 05:07:58.000'),
('FE36D38D-F2E3-F9D6-916D-9641541F3031', 'Paid', 382.21, '2019-08-27 15:05:32.000', '12B24901-1D52-29EC-55E8-5B91FB06C964', 0,'Regular','2019-08-27 15:05:32.000'),
('337B1877-BB88-3DC2-7EE1-C4F11CD0CD5A', 'Paid', 1373.05, '2018-07-24 22:28:38.000', 'EE26F5EC-4F04-E4CF-C85B-F7EF5ADAE6BC', 0,'Replacement','2018-07-24 22:28:38.000'),
('CC892417-80A6-5564-51D0-C3409AB018D5', 'Paid', 943.55, '2018-08-05 17:17:41.000', 'A636AE06-6829-EF6D-BB81-8739AB8470F5', 0,'Regular','2018-08-05 17:17:41.000'),
('9F574A0B-E444-7AD1-6083-856128278E73', 'Paid', 382.67, '2018-02-13 01:46:13.000', '16C91C79-5CB7-56EB-39B6-B73589988BC7', 0,'First','2018-02-13 08:46:46.000'),
('BE3AED4B-98A0-729C-63B4-453493D55F18', 'Paid', 244.81, '2018-11-17 01:45:57.000', '66DAE1C6-A7B9-972C-58CD-131595FB381C', 0,'Regular','2018-11-17 01:45:57.000'),
('67ABC743-2D82-F930-BC1C-C67E14848018', 'Paid', 969.45, '2019-04-13 09:21:56.000', 'B61230B0-8653-456F-C5F2-4A61E5C4028A', 0,'First','2019-04-13 09:21:56.000'),
('13AE69A3-D01D-D97D-8481-416CBBA8A6CB', 'Paid', 200.26, '2018-10-28 22:40:22.000', '9011AFD2-1C39-3141-9BE8-EDAA2F3FE3DE', 0,'Regular','2018-10-28 22:40:22.000'),
('2548C9D5-9D71-3CC3-5E6C-0FFA651C4275', 'Paid', 566.69, '2018-02-08 13:27:54.000', '527B7682-60DA-C685-F2CC-CAADFCAEA1CB', 0,'First','2018-02-08 13:27:54.000'),
('9911B183-FACA-CD4F-E7C7-689AA91209F3', 'Paid', 567.34, '2019-01-20 07:56:37.000', 'D079C81C-DB59-C6F7-09D4-5A18BC325904', 0,'First','2019-01-20 07:56:37.000'),
('C63F0CEF-A556-227F-0A30-C4F3271AB671', 'Paid', 704.53, '2018-05-10 10:32:45.000', '0D331A11-2B2D-F666-9B1A-7C3ACEC477A2', 0,'First','2018-05-10 10:32:45.000'),
('1AC01A4C-DBFE-DBBE-FFBE-596E191E63D6', 'Paid', 456.65, '2016-03-24 12:54:40.000', '1F323E66-0FF4-AFCD-E25D-1DCC6531C220', 0,'Regular','2016-03-24 12:54:40.000'),
('34CA3135-FCED-5EB3-3699-7A0320FE93C1', 'Paid', 305.83, '2019-05-08 08:28:56.000', 'B5C19070-B154-81C6-408D-34DFA5BEEEE5', 0,'Regular','2019-05-08 08:28:56.000'),
('78849FE1-D2EC-176D-BB62-DF3672F428BE', 'Paid', 392.51, '2018-09-20 19:34:02.000', '904E3092-17C7-B630-72D0-744E861C6EE6', 0,'Regular','2018-09-20 19:34:02.000'),
('F13AE185-DCA6-7150-8BC7-AA413BF9EA90', 'Paid', 928.88, '2018-07-30 16:27:59.000', 'DD802EF9-0C7E-77DE-D767-B83566478FC8', 0,'First','2018-07-30 16:27:59.000'),
('777C1847-277A-A591-2BF9-2A7824F9B8DE', 'Paid', 707.74, '2018-09-11 02:05:06.000', '2728B8E1-327E-B204-2205-A506C436B3CA', 0,'Regular','2018-09-11 02:05:06.000'),
('6166C41D-7E44-88D1-6702-F78EE3AC6EAD', 'Paid', 1170.03, '2019-01-10 04:56:21.000', '81AF13E2-8951-ED3D-CDD3-85276D8FF289', 0,'First','2019-01-10 04:56:21.000'),
('C36FEDE6-9B9B-020D-450E-B259DFC39AD6', 'Paid', 983.13, '2018-12-03 11:24:36.000', '99B252F5-3DE0-CA32-3347-2E3A734E829D', 0,'Regular','2018-12-03 11:24:36.000'),
('99068783-DE84-6FF2-9637-E60BF9D02E06', 'Paid', 2147.74, '2018-05-12 05:33:39.000', '79453C9F-4EBD-5C84-28FE-D76DF85B895F', 0,'Regular','2018-05-12 05:33:39.000'),
('F16954F6-7FF7-730C-825F-A74AAC153E21', 'Paid', 1016.81, '2019-01-04 10:03:16.000', '82AD0F6D-6E24-1331-EB89-CDC550E43C46', 0,'Regular','2019-01-04 10:03:16.000'),
('23C8D445-680E-89F6-A9B3-1CC6CA1AF444', 'Paid', 1567.81, '2018-09-24 05:35:55.000', '1360A1C8-C6CB-3983-AEE6-BAA2B5E13BD1', 0,'First','2019-06-11 09:31:44.000'),
('E7055CE2-B0DB-2A4D-776C-BFA8D7B29E7F', 'Paid', 416.01, '2019-09-11 20:17:42.000', 'F0D02C5E-215C-E93A-DCE4-D4AE11AE6D05', 0,'Regular','2019-09-16 23:19:54.000'),
('53102872-189E-0215-528B-52B195168498', 'Paid', 71.15, '2019-03-14 06:25:47.000', '3D9FBBF2-448E-D277-8E56-AC15C541C2ED', 0,'First','2019-03-14 06:25:47.000'),
('AE42AA38-F9DD-4231-D8E8-3B8A043E8B83', 'Paid', 1269.72, '2018-12-05 19:38:36.000', '6D19BA94-1555-1101-D546-3410B56967A8', 0,'First','2019-06-11 09:31:44.000'),
('156CB88B-AEE9-F157-2761-90731984DEBF', 'Paid', 1340.37, '2018-03-20 12:35:08.000', '83A4DFBA-1DDC-1C90-991E-E868FF0BEC53', 0,'Regular','2018-03-20 12:35:08.000'),
('7C7C006B-050D-1241-70DF-3276E87F986B', 'Paid', 1340.37, '2018-04-20 12:35:08.000', '83A4DFBA-1DDC-1C90-991E-E868FF0BEC53', 0,'Regular','2019-06-11 09:31:44.000'),
('35A1EF34-D124-58FA-1B66-D05EBFEC8F33', 'Paid', 988.21, '2018-05-26 04:55:40.000', '982F4644-5F07-F9B4-1C5E-D0D057CCA820', 0,'Regular','2018-05-26 11:56:13.000'),
('D5A077E9-0BCC-BD24-4677-5B588D560CEA', 'Failed', 2092.49, '2018-12-19 19:29:00.000', '81A11536-C6CC-2754-FC0A-256170BD34B4', 0,'Regular','2018-12-19 19:29:00.000'),
('84088C43-DC9C-C11D-97C4-CBA589BFACDC', 'Paid', 1016.81, '2018-12-04 10:03:16.000', '82AD0F6D-6E24-1331-EB89-CDC550E43C46', 0,'Regular','2018-12-04 17:03:49.000'),
('724B7595-5A66-FC6B-536C-F21AB384EFFF', 'Paid', 305.83, '2019-04-08 08:28:56.000', 'B5C19070-B154-81C6-408D-34DFA5BEEEE5', 0,'First','2019-04-08 08:28:56.000'),
('E18A1BB8-75B3-D1BB-0347-FF80B6491567', 'Paid', 1458, '2018-10-25 20:28:39.000', '5DC6C348-C240-6E2E-9E0C-FF6DF91386C3', 0,'Regular','2019-06-11 09:31:44.000'),
('4485A270-29C7-6088-05E0-968CE8CC4D3E', 'Paid', 790.33, '2019-10-22 05:49:54.000', '3162DD41-D398-D007-A65D-83DBEBABAA5D', 0,'Regular','2019-10-22 05:49:54.000'),
('B77D5A8D-92F3-BD45-A27E-701687C6468A', 'Paid', 686.35, '2019-02-18 04:08:16.000', '0FB9B0B2-E755-48AA-3D02-A88D322EF68C', 0,'Regular','2019-02-18 04:08:16.000'),
('35A761C3-9EE0-CB69-45C1-84A5080962C6', 'Paid', 928.88, '2018-08-30 16:27:59.000', 'DD802EF9-0C7E-77DE-D767-B83566478FC8', 0,'Regular','2019-06-11 09:31:44.000'),
('A18D7A9C-54DE-52A4-7267-1184269B22B1', 'Paid', 1211.63, '2019-10-14 05:52:16.000', '54BAAF9F-6416-7714-C118-CB6FAAB0B78C', 0,'Regular','2019-06-11 09:31:44.000'),
('3EFA1BF3-F676-BEC7-C6A4-81109FC14F20', 'Paid', 1195.01, '2019-02-08 07:54:41.000', '8374F308-0407-27FE-E398-0F2D4B3A67EF', 0,'First','2019-02-08 07:54:41.000'),
('159FF1F1-46F7-41A7-B99B-D50843C444DC', 'Paid', 389.15, '2018-06-18 14:00:42.000', '4C83314C-0998-82EF-9F5C-B990654EF3E4', 0,'First','2018-06-18 14:00:42.000'),
('9038893A-8684-E867-D00B-0805039FAB67', 'Paid', 928.88, '2018-09-30 16:27:59.000', 'DD802EF9-0C7E-77DE-D767-B83566478FC8', 0,'Regular','2018-09-30 16:27:59.000'),
('CD5310C4-9FB4-54F3-06FB-DF24F869A077', 'Paid', 387.4, '2018-09-12 01:49:56.000', 'D476810E-DD53-CDC2-5AB6-1471B30A6112', 0,'First','2018-09-12 01:49:56.000'),
('3D2BF5BF-D972-8BAC-B0AE-76AE1E585E6D', 'Paid', 200.26, '2018-08-28 22:40:22.000', '9011AFD2-1C39-3141-9BE8-EDAA2F3FE3DE', 0,'First','2018-08-28 22:40:22.000'),
('C80DD640-3DC0-B842-5DD4-75079ABEAF75', 'Paid', 312.04, '2019-06-09 08:23:57.000', 'A103A2B1-4A5F-533E-10D8-2C11D70EC0E0', 0,'Regular','2019-06-14 11:26:09.000'),
('70DA5DB0-1615-21F2-E495-D9281ECBDA3B', 'Paid', 881.6, '2019-09-24 21:25:22.000', 'D0019997-EC6E-5E96-B07C-838B6DE35692', 0,'First','2019-09-24 21:25:22.000'),
('1AF6EB91-9B0B-8EF5-C45A-5A8F55805208', 'Paid', 831.07, '2019-04-19 08:39:42.000', '955580B6-7AEB-615D-E96B-8FCAC0EB335D', 0,'Regular','2019-04-24 11:41:54.000'),
('7058B8B3-7CC6-9733-CE9D-0BAFF1CFE2C7', 'Paid', 1122.33, '2018-09-04 00:55:55.000', '5C4D8589-AFCE-5D28-E677-5851F16CB43B', 0,'First','2018-09-04 00:55:55.000'),
('9DEE6161-C560-F597-0EC9-E1D4F63A9293', 'Paid', 411.92, '2019-12-08 05:21:54.000', '50267CE6-007B-B43E-306E-AAEC5CEC09C1', 0,'Regular','2019-12-13 08:24:06.000'),
('B05A1BE0-5320-252C-CDC6-3C1D6FDA0A59', 'Paid', 67.6, '2019-01-12 02:59:00.000', 'C6B63E38-78C9-1E72-2913-D0B20DDAC7EF', 0,'First','2019-01-12 02:59:00.000'),
('451E4771-2581-4995-4E4C-91AE808A1776', 'Paid', 1211.63, '2019-09-14 05:52:16.000', '54BAAF9F-6416-7714-C118-CB6FAAB0B78C', 0,'First','2019-09-14 05:52:16.000'),
('BC6C83E0-95C2-1AE6-B14E-FA9444C47898', 'Paid', 566.69, '2018-03-08 13:27:54.000', '527B7682-60DA-C685-F2CC-CAADFCAEA1CB', 0,'Regular','2018-03-08 13:27:54.000'),
('0EB076A5-BA3F-2277-69FC-1A98D9CAB788', 'Paid', 644.78, '2019-06-19 06:26:43.000', '69499FC3-B466-7D68-9FD1-C1B06D756859', 0,'First','2019-06-19 06:26:43.000'),
('136749A2-8273-F7B6-85C1-CE1B5CE8A40B', 'Paid', 906.85, '2018-09-07 12:40:48.000', '07E1C84E-3D8E-9C2E-67BB-F0E9128EB1E2', 0,'First','2018-09-07 12:40:48.000'),
('5F4BF772-088A-1872-39C9-39C6296790F4', 'Paid', 1284.44, '2019-05-15 18:28:42.000', '06DF2FA9-172D-A020-7D3D-AA1E92F550F4', 0,'First','2019-05-15 18:28:42.000'),
('B27D4F01-259D-7E96-DAC9-04ABB7EF2142', 'Paid', 494.07, '2018-10-20 13:29:42.000', '1DD2E8B4-975B-EB83-FE44-58F0BB62BA8B', 0,'Regular','2018-10-20 13:29:42.000'),
('C4A5C22F-7D9B-86DF-9ADC-23E8146CDF50', 'Paid', 793.11, '2018-09-11 16:48:50.000', '8BEE5C04-0EEC-D701-FC11-CD800A2E5C92', 0,'First','2018-09-11 16:48:50.000'),
('D0481F6F-8DEB-69B8-AD07-CB8F3CF95C9D', 'Paid', 305.83, '2019-06-08 08:28:56.000', 'B5C19070-B154-81C6-408D-34DFA5BEEEE5', 0,'Regular','2019-06-11 09:31:44.000'),
('D57DA7E5-5C2F-F713-15D4-24D9A39E8E00', 'Paid', 312.04, '2019-09-09 08:23:57.000', 'A103A2B1-4A5F-533E-10D8-2C11D70EC0E0', 0,'Regular','2019-09-14 11:26:09.000'),
('459CFCAE-4FC6-80FB-D32F-2887CEDBB463', 'Paid', 358.29, '2019-05-26 03:33:27.000', '23CB635B-2AF9-8ACE-54F7-06897007DF08', 0,'First','2019-05-26 03:33:27.000'),
('660F3EC4-19ED-AAB0-23C6-4FC43AC940C2', 'Paid', 980.63, '2019-10-27 06:04:57.000', '143AD437-2809-43B9-C473-ADA070426D10', 0,'Regular','2019-10-27 06:04:57.000'),
('AF536713-071B-99F1-AC34-9C66B42B81E8', 'Paid', 813.06, '2019-05-24 20:41:31.000', 'EFB3F4D2-B73F-0E15-1F52-A58B5BFC9EBB', 0,'First','2019-05-24 20:41:31.000'),
('F998A8D4-00AF-C287-FFC7-BCF5E864CA07', 'Paid', 1242.49, '2019-11-18 11:55:42.000', '827DEF7F-5B29-35AB-1FCC-EFAA7023B0AC', 0,'Regular','2019-11-23 14:57:54.000'),
('90BA7D00-171C-E70D-A80C-613809A0EB22', 'Paid', 305.83, '2019-07-08 08:28:56.000', 'B5C19070-B154-81C6-408D-34DFA5BEEEE5', 0,'Regular','2019-07-08 08:28:56.000'),
('838AB176-C876-0EF2-F2BA-AF1ED30FCDE0', 'Paid', 1242.49, '2019-10-18 11:55:42.000', '827DEF7F-5B29-35AB-1FCC-EFAA7023B0AC', 0,'First','2019-10-18 11:55:42.000'),
('46E6E44D-C6C0-4D36-FE2B-99B0025B0946', 'Paid', 673.9, '2018-12-13 12:37:54.000', 'A89777C1-E7EC-D8EF-637A-0BA5BFFB15E7', 1,'Regular','2018-12-13 19:38:27.000'),
('C05BD766-E38D-AC9E-6F75-238ECD93ABFE', 'Paid', 456.65, '2016-01-24 12:54:40.000', '1F323E66-0FF4-AFCD-E25D-1DCC6531C220', 0,'First','2016-01-24 12:54:40.000'),
('28101931-3C9D-42C9-E657-B105FE174A3D', 'Paid', 70.56, '2019-06-07 00:03:56.000', '3082DE73-A675-048B-152F-1202D0A85609', 0,'First','2019-06-12 03:06:08.000'),
('CCBE7336-9DCF-BC14-788D-646BCC1F85F3', 'Paid', 393.48, '2020-01-01 08:28:10.000', '3D20F34F-8ACB-2A2D-1A84-A1E01366BFC0', 0,'Regular','2020-01-01 08:28:10.000'),
('97F72582-C591-1683-4366-8D223BC3278D', 'Paid', 520.76, '2018-11-23 05:19:29.000', 'E613574C-0336-18E6-50BB-F489F7C3C910', 0,'Regular','2018-11-28 08:21:41.000'),
('573091D5-7380-9099-3B45-42FEFC5CF2FB', 'Paid', 448.28, '2018-09-21 03:44:29.000', 'C9788C94-88AA-375D-6F9B-868379DED953', 0,'First','2019-06-11 09:31:44.000'),
('519E4F85-37F3-8ECE-33FC-962A62C68B78', 'Paid', 456.65, '2016-03-24 12:54:40.000', '1F323E66-0FF4-AFCD-E25D-1DCC6531C220', 0,'Regular','2016-03-29 15:56:52.000'),
('BBA147B8-5832-C894-6751-1E28CD232900', 'Paid', 541.39, '2019-05-26 22:33:40.000', '32404FF1-9BE2-4AFC-0C4C-95EBF8FFD81D', 0,'Regular','2019-06-01 01:35:52.000'),
('5CDC8C5E-613E-5E90-3433-908B11616001', 'Paid', 682.24, '2018-06-05 00:15:27.000', 'FF10996F-975F-D831-9A80-3530E03A1BD9', 0,'First','2018-06-10 03:17:39.000'),
('D1D58EA7-1374-6A9F-BEF5-2FB384801674', 'Paid', 707.74, '2018-08-11 02:05:06.000', '2728B8E1-327E-B204-2205-A506C436B3CA', 0,'First','2018-08-11 02:05:06.000'),
('37EEECED-19D2-B69C-EA94-450B39F9684F', 'Paid', 117.4, '2016-03-05 16:32:30.000', '6B42DB04-7D7C-E511-9E6E-005056992328', 0,'Regular','2016-03-10 19:34:42.000'),
('681EBF75-0B0E-1BF9-71DE-18E750CA25B5', 'Paid', 207.41, '2019-10-10 18:21:57.000', 'F6F6A87D-D3C1-3563-8F90-62333C160785', 0,'Regular','2019-10-10 18:21:57.000'),
('7EFE94D0-8B8D-351F-7D92-29F8199FA9E9', 'Paid', 853.76, '2019-06-21 00:41:19.000', 'AC631786-926B-81CA-D59D-D2C69E156972', 0,'First','2019-06-21 00:41:19.000'),
('C0D73970-12C6-C4BE-FE48-FB4506276699', 'Paid', 503.48, '2018-12-24 19:51:07.000', '84B1CC2D-00A2-0514-5E18-04A033E46D19', 0,'First','2018-12-24 19:51:07.000'),
('A140215D-B401-DF91-2283-519B9C2F4C4E', 'Paid', 521.81, '2019-08-30 04:23:35.000', 'A3BAD951-8B90-5A17-141C-4D2A7141BE74', 0,'Regular','2019-08-30 04:23:35.000'),
('3848453E-FD52-AB0F-3517-B3E140DFC9A6', 'Paid', 1011.06, '2019-11-26 12:20:06.000', 'C541B083-8975-A7C6-1A6B-B38C2DB09869', 0,'Regular','2019-11-26 12:20:06.000'),
('0ED7781D-E4BD-8932-2CE0-CFEB0BC4FE4E', 'Paid', 1373.05, '2018-06-24 22:28:38.000', 'EE26F5EC-4F04-E4CF-C85B-F7EF5ADAE6BC', 0,'First','2018-06-24 22:28:38.000'),
('79596572-0E95-011E-1D6F-A5A77E02799D', 'Paid', 539.36, '2019-05-28 11:48:24.000', '66382123-E1D7-DE52-7070-FD89DF67C578', 0,'Regular','2019-05-28 11:48:24.000'),
('B079703B-799C-476B-D313-E49224E686D0', 'Paid', 607.61, '2018-03-04 03:39:29.000', '911E2242-B3BB-ECA3-3957-6950C298F9EB', 0,'First','2019-06-11 09:31:44.000'),
('3E1DF591-7A13-1C79-B4F9-433C9961C62C', 'Paid', 2139.81, '2019-02-21 01:23:46.000', '17F41EC1-7AF2-F724-07C9-4A7755B17FA3', 0,'Regular','2019-02-21 01:23:46.000'),
('8490976F-0D50-8F96-650C-BC07799F17C7', 'Paid', 943.55, '2018-07-05 17:17:41.000', 'A636AE06-6829-EF6D-BB81-8739AB8470F5', 0,'First','2018-07-05 17:17:41.000'),
('DF24D456-382A-42DE-2255-4E36B2515514', 'Paid', 453.53, '2018-05-11 02:09:03.000', 'DED0F5C0-CE1E-EED8-EA83-8C1A91C61C0B', 0,'First','2018-05-11 09:09:36.000'),
('055178FA-2EE5-4D58-365E-EA4EE84D2509', 'Paid', 988.76, '2019-07-20 16:25:21.000', 'AEB79D84-D2C4-4DAB-2C67-03DAC4276F7C', 0,'Regular','2019-07-25 19:27:33.000'),
('24F855FE-65A5-ED83-09F2-640FA9AAE839', 'Paid', 2139.81, '2019-01-21 01:23:46.000', '17F41EC1-7AF2-F724-07C9-4A7755B17FA3', 0,'First','2019-06-11 09:31:44.000'),
('F172F36E-C6EA-644E-F1D6-EEED62AF74D6', 'Paid', 290.52, '2019-07-08 18:03:54.000', '8BAC47FB-96AD-AB7F-3EB8-86C3933AF810', 0,'Regular','2019-07-08 18:03:54.000'),
('1C22B26B-8698-E0B1-97D5-5D1C2AB7CAA2', 'Paid', 1149, '2019-03-10 23:43:37.000', 'D41A2378-DC1E-F3DD-DEAA-D25FB924454D', 0,'Regular','2019-03-10 23:43:37.000'),
('5ECE4AC6-8E66-5D39-B54B-5CD2A2A7AA2C', 'Paid', 158.12, '2019-01-01 08:39:16.000', '0620E34E-1737-2882-D4AF-A2C4A6E87B82', 0,'Regular','2019-06-11 09:31:44.000'),
('7F73CCC5-ABBB-066D-526D-1460FAEA7594', 'Paid', 494.15, '2019-08-03 09:39:28.000', '9A33688F-8ABA-8E6F-2C16-0FC79B6B1946', 0,'Regular','2019-08-03 16:40:01.000'),
('C34D1E53-A1F1-E6EB-A95A-8EB18D80306E', 'Paid', 1307.72, '2018-08-04 08:08:25.000', 'EF8FB7F4-BDC3-292C-4F3F-BB0F152A5A3C', 0,'First','2018-08-04 08:08:25.000'),
('E54F63A7-1D56-55E8-1421-A291900CCC2B', 'Paid', 1251.67, '2019-06-15 12:08:22.000', '22A53B69-1603-3799-8E91-6DAFA5D3C2D8', 0,'First','2019-06-20 15:10:34.000'),
('7117ED12-38FC-B4F5-1183-F008CABDDF2C', 'Paid', 1798.94, '2019-04-03 17:10:44.000', '3239B380-8FB7-B444-0322-F08E5E177854', 0,'First','2019-04-03 17:10:44.000'),
('C00C6CE8-BB57-3B48-4EA2-0143F01A2AFC', 'Paid', 472.27, '2018-03-15 19:22:13.000', 'B1204636-888A-AF2A-1157-157B27ACF5F5', 0,'First','2018-03-20 22:24:25.000'),
('392279CB-CAF1-6916-7C58-F2BE685A69C7', 'Paid', 1321.75, '2018-07-23 16:11:52.000', '0E5AD9C3-65CF-C270-A563-B0F3F36FC6A0', 0,'Regular','2018-07-23 23:12:25.000'),
('50D9E59E-0AD7-2DEE-7448-0BC185B5738F', 'Paid', 158.12, '2019-02-01 08:39:16.000', '0620E34E-1737-2882-D4AF-A2C4A6E87B82', 0,'Regular','2019-02-01 08:39:16.000'),
('9DCCC46A-088E-1A90-59D3-FF8F4C1BB200', 'Paid', 67.6, '2019-02-12 02:59:00.000', 'C6B63E38-78C9-1E72-2913-D0B20DDAC7EF', 0,'Regular','2019-02-17 06:01:12.000'),
('6D36F4F9-13FE-B070-A02E-B9382F947589', 'Paid', 541.39, '2019-04-26 22:33:40.000', '32404FF1-9BE2-4AFC-0C4C-95EBF8FFD81D', 0,'Regular','2019-04-26 22:33:40.000'),
('FB595B35-16CB-E087-E2FF-1FBED80E4D15', 'Paid', 2092.49, '2018-11-19 19:29:00.000', '81A11536-C6CC-2754-FC0A-256170BD34B4', 0,'First','2019-06-11 09:31:44.000'),
('7E4BB232-6FD5-5397-8A20-04296FA91E0B', 'Paid', 312.04, '2019-08-09 08:23:57.000', 'A103A2B1-4A5F-533E-10D8-2C11D70EC0E0', 0,'Regular','2019-08-09 08:23:57.000'),
('EE548BB7-BBA9-8692-2832-D1D614EC1D8B', 'Paid', 393.48, '2020-02-01 08:28:10.000', '3D20F34F-8ACB-2A2D-1A84-A1E01366BFC0', 0,'Regular','2020-02-01 15:28:43.000'),
('D0B52090-0B71-D338-C724-98F64D7C7676', 'Paid', 86.2, '2018-10-28 07:39:47.000', '8B465958-EE1D-C29E-8247-3CA59C145740', 0,'First','2018-10-28 07:39:47.000'),
('D6D938D4-6D90-C09B-CCA4-98340624CB6A', 'Paid', 1458, '2018-08-25 20:28:39.000', '5DC6C348-C240-6E2E-9E0C-FF6DF91386C3', 0,'Regular','2018-08-30 23:30:51.000'),
('49190B49-2646-A4DE-DBD7-ECED02F961F7', 'Paid', 541.39, '2019-02-26 22:33:40.000', '32404FF1-9BE2-4AFC-0C4C-95EBF8FFD81D', 0,'Regular','2019-02-26 22:33:40.000'),
('0DA51FDD-83F6-9902-E765-2D3DE0E5F8C0', 'Paid', 501.14, '2018-12-10 16:09:15.000', '430D79BF-6229-5076-D45C-4491BF70AB83', 0,'Regular','2018-12-10 16:09:15.000'),
('CA7E485A-C7BC-2CF2-A249-C0095F7A7C15', 'Paid', 559.71, '2019-11-05 22:18:35.000', '2DB874DC-ACCE-A766-B616-D13FE51A410A', 0,'Regular','2019-11-05 22:18:35.000'),
('8FF67E41-52F5-E2BB-846C-405474AB6FC8', 'Paid', 541.39, '2019-03-26 22:33:40.000', '32404FF1-9BE2-4AFC-0C4C-95EBF8FFD81D', 0,'Regular','2019-03-26 22:33:40.000'),
('7057637A-AC3A-A0E8-C2EF-87C0C4197BFE', 'Paid', 1881.38, '2017-11-17 07:36:14.000', '06B247E1-EEA4-EF62-1111-A7838E4E0DBF', 0,'First','2017-11-17 07:36:14.000'),
('AC8D2D35-B6D4-8068-8AB5-96D06FFC2718', 'Paid', 456.45, '2019-06-29 20:45:20.000', '9CAB0B55-2330-0F70-29A0-88D56B951877', 0,'Regular','2019-06-29 20:45:20.000'),
('820B31D1-4381-C60C-85E0-C0FD8B704D50', 'Paid', 532.55, '2019-02-26 23:19:38.000', '7A31E75B-3180-53B0-E76A-F839424815A5', 0,'Regular','2019-02-26 23:19:38.000'),
('697C442F-18B3-00B8-8286-D1829EB5629A', 'Paid', 890.52, '2019-04-18 06:57:30.000', '6ADA3882-CA98-EB4C-86FD-07478C34CBED', 0,'Replacement','2019-04-18 06:57:30.000'),
('0CBA431D-F88E-ABE7-84E2-8ABDA43B73A0', 'Paid', 1210.28, '2018-10-04 13:43:16.000', 'E06685AE-A9D0-9490-1879-8871F441EA43', 0,'Regular','2018-10-04 13:43:16.000'),
('46F10C5E-47A6-DD66-7C69-A600C68E0AB0', 'Paid', 1513.72, '2019-07-14 04:17:21.000', '9B477341-C7B2-0C66-55AF-22407518C9E1', 0,'First','2019-07-14 04:17:21.000'),
('8A40F3BC-D8B3-E7B4-0933-0FFEED5D72B5', 'Paid', 1288.54, '2018-07-21 21:59:49.000', 'F667039C-7B4B-4543-76B3-CD046F4245BF', 0,'First','2018-07-21 21:59:49.000'),
('7A0E32C0-81BB-3911-240A-67DC9EEFD490', 'Paid', 419, '2019-09-12 18:14:59.000', 'CD867D11-655C-623D-9F4C-9647C96BF455', 0,'First','2019-06-11 09:31:44.000'),
('8F1CAD26-EECC-5334-1CD9-56AEA54E152E', 'Paid', 1052.77, '2018-08-03 18:28:14.000', '30F61B8C-9057-DEA2-A6FF-929FB7E09599', 0,'Regular','2018-08-03 18:28:14.000'),
('62CF2463-7D62-5C16-AE10-492353C03D9E', 'Failed', 411.92, '2019-11-08 05:21:54.000', '50267CE6-007B-B43E-306E-AAEC5CEC09C1', 0,'First','2019-11-08 12:22:27.000'),
('76EB7D38-6FE2-DEB1-863F-041C1F26C3C8', 'Paid', 694.16, '2019-07-19 01:08:46.000', '0FA04DD5-42B9-1114-74F9-500588ACE23B', 0,'Regular','2019-06-11 09:31:44.000'),
('27811ED7-C2A3-37B0-B688-48A80E3D55AC', 'Paid', 732.97, '2018-09-11 12:38:19.000', '875D83BE-BEFA-D788-F78E-7E67DA2E2F10', 0,'Replacement','2018-09-16 15:40:31.000'),
('24CB4438-4325-6C34-508A-091F36A017DB', 'Paid', 790.33, '2019-11-22 05:49:54.000', '3162DD41-D398-D007-A65D-83DBEBABAA5D', 0,'Regular','2019-11-22 05:49:54.000'),
('05FD8F19-8D27-C5EE-94C6-A9407D44E6CB', 'Paid', 1269.72, '2019-01-05 19:38:36.000', '6D19BA94-1555-1101-D546-3410B56967A8', 0,'Regular','2019-01-05 19:38:36.000'),
('33E52BCB-7D52-9C0E-CE89-7BD477188672', 'Paid', 358.29, '2019-06-26 03:33:27.000', '23CB635B-2AF9-8ACE-54F7-06897007DF08', 0,'Regular','2019-07-01 06:35:39.000'),
('B36D3A58-5EC2-2A88-70F4-81FECEBF10C5', 'Paid', 1424.65, '2018-08-25 03:03:46.000', 'D9F5601F-AC32-8C5C-EB3D-215A8E81EB3E', 0,'Regular','2018-08-25 03:03:46.000'),
('088B6E40-5B10-6EE2-34BC-80A46229FE54', 'Paid', 317.15, '2019-09-29 11:31:13.000', '2F5D0956-C5CF-B36E-AD7C-7AD82E994B4E', 0,'Regular','2019-09-29 11:31:13.000'),
('0404E8DB-2AF6-A706-9C69-9E73F4E98057', 'Paid', 317.15, '2019-10-29 11:31:13.000', '2F5D0956-C5CF-B36E-AD7C-7AD82E994B4E', 0,'Regular','2019-10-29 18:31:46.000'),
('85EBAA16-65E9-BD4B-2318-8652784AC762', 'Paid', 190.49, '2016-02-17 17:34:22.000', 'C8F73EBA-739A-E511-9E6E-005056992328', 0,'Regular','2016-02-18 00:34:55.000'),
('C8E8A7B7-6D8A-7F92-4958-175F5ACA2745', 'Paid', 397.24, '2018-10-17 12:27:30.000', '9AAD1C11-8FBE-5B5A-1056-CD64122C06E1', 0,'Regular','2019-06-11 09:31:44.000'),
('2BF6A15B-AE1F-88F8-F698-671D0FB0B48D', 'Paid', 316.84, '2018-06-16 21:57:47.000', 'D96A0AEF-8AFE-5F36-BB34-2FC86E65CB46', 0,'First','2018-06-22 00:59:59.000'),
('7DC2AEEE-8E9D-BD4B-7EFC-C762EA327D0C', 'Paid', 589.28, '2019-09-03 05:25:24.000', '5DF33EED-0C92-D12C-6AB0-EEDA12C3DB84', 1,'Regular','2019-09-03 12:25:57.000'),
('1189E729-A32E-CFC1-24CE-2E3A18EFFC3A', 'Paid', 395.16, '2019-08-12 01:12:22.000', 'D6DB9A51-111D-B7C8-910B-00876A9F2291', 0,'First','2019-08-12 01:12:22.000'),
('29D24B01-8C2A-6F59-64E0-78A199F39A88', 'Paid', 943.55, '2018-09-05 17:17:41.000', 'A636AE06-6829-EF6D-BB81-8739AB8470F5', 0,'Regular','2018-09-05 17:17:41.000'),
('A52B5C68-DE54-70F5-0CD9-1B98F7DFF4C7', 'Paid', 1050.76, '2019-07-14 16:49:36.000', '2F162A36-F4EA-09F2-B822-F80857E3AA64', 0,'First','2019-07-14 16:49:36.000'),
('A387A535-3753-B120-8F98-E7EA48998A71', 'Paid', 219.16, '2016-03-22 17:04:49.000', 'AE45089C-9D99-E511-9E6E-005056992328', 0,'Regular','2016-03-27 20:07:01.000'),
('74B51373-6DF1-716C-33C2-551F80F71C46', 'Paid', 686.35, '2019-01-18 04:08:16.000', '0FB9B0B2-E755-48AA-3D02-A88D322EF68C', 0,'Replacement','2019-06-11 09:31:44.000'),
('C347ADFA-BAFA-B190-7E39-0409AA1D02C3', 'Paid', 2139.81, '2019-03-21 01:23:46.000', '17F41EC1-7AF2-F724-07C9-4A7755B17FA3', 0,'Replacement','2019-03-21 01:23:46.000'),
('5E350CCE-8A19-B9A1-DB4A-83B00D975B3C', 'Paid', 532.55, '2019-01-26 23:19:38.000', '7A31E75B-3180-53B0-E76A-F839424815A5', 0,'First','2019-01-26 23:19:38.000'),
('D90422D1-55CC-77D8-B540-D699B517CC74', 'Paid', 965.54, '2019-06-13 04:07:48.000', 'BA4251DA-7AF7-E1BD-745E-9B3E1955C99F', 0,'Regular','2019-06-13 11:08:21.000'),
('881CC0B4-A74C-7625-5D19-AEE53FEE6C6F', 'Paid', 528.05, '2019-10-04 16:26:24.000', '5557CAA9-0B11-B81C-21D2-C3878742208B', 0,'Regular','2019-10-04 16:26:24.000'),
('AC6E1F34-C9EF-6753-F9E7-0B9CCFEA85EB', 'Paid', 107.13, '2019-06-17 17:47:18.000', '88800A9D-372A-66D2-9CED-55D26413F425', 0,'Regular','2019-06-22 20:49:30.000'),
('DC605E41-5B9B-DBC4-8683-C4331068EAF7', 'Paid', 233.53, '2018-05-03 09:16:14.000', '03B912F3-C13B-2EE4-27F5-755030910D71', 0,'Regular','2018-05-08 12:18:26.000'),
('34387D0F-3182-2DE8-CE46-EE8E1848E1EF', 'Paid', 703.78, '2018-12-08 02:45:33.000', '972FE97A-5C1C-1C77-F9FB-DA770E66EC53', 0,'Regular','2018-12-13 05:47:45.000'),
('B64FD6D8-9AE3-6AEB-E702-1E32CDC32D7E', 'Paid', 503.11, '2019-03-27 03:26:11.000', '203756EA-6D90-591F-8A43-4008F459B1FA', 0,'First','2019-03-27 10:26:44.000'),
('8F83085E-6BAE-2A41-D8B4-7D44814FA215', 'Paid', 2227.57, '2018-11-19 12:07:05.000', 'A37D36E3-6C2E-8D96-5D10-163C21A4082F', 0,'First','2018-11-19 12:07:05.000'),
('DDE42500-59EA-BE90-CAEA-D7D6054A8ECB', 'Paid', 1340.37, '2018-02-20 12:35:08.000', '83A4DFBA-1DDC-1C90-991E-E868FF0BEC53', 0,'First','2018-02-20 12:35:08.000'),
('C907604D-043E-1305-E35F-EC70E67A1EC1', 'Paid', 329.46, '2018-11-21 09:52:53.000', 'FE9A32E2-C930-7C48-4A85-26064C13A99D', 0,'First','2019-06-11 09:31:44.000'),
('C0C0A068-5B8C-9101-A837-345BF7BDE3EF', 'Paid', 807.42, '2019-03-19 10:33:44.000', 'E1C2D783-F61B-2F08-2724-905624F18ABA', 0,'First','2019-03-19 10:33:44.000'),
('35C8E45A-00C2-A603-45D1-1E57116927F6', 'Failed', 101.95, '2019-01-01 00:52:23.000', '12240FF3-B520-6521-9CEE-C7350CDCC5A3', 0,'Regular','2019-01-01 00:52:23.000'),
('F0EC4EE5-B5DA-6EA6-9B92-1D6062823317', 'Paid', 1210.28, '2018-08-04 13:43:16.000', 'E06685AE-A9D0-9490-1879-8871F441EA43', 0,'First','2018-08-09 16:45:28.000'),
('EE069D8C-DE00-5B27-BA9B-A13D975B60BC', 'Paid', 395.16, '2019-09-12 01:12:22.000', 'D6DB9A51-111D-B7C8-910B-00876A9F2291', 0,'Regular','2019-09-12 01:12:22.000'),
('84EC1B5E-7893-39E3-8EFF-68A1D5DEA495', 'Paid', 980.63, '2019-09-27 06:04:57.000', '143AD437-2809-43B9-C473-ADA070426D10', 0,'First','2019-09-27 06:04:57.000'),
('962C6B1A-014B-D71E-ED60-AABBDC11E8CC', 'Paid', 244.81, '2018-10-17 01:45:57.000', '66DAE1C6-A7B9-972C-58CD-131595FB381C', 0,'Replacement','2018-10-17 08:46:30.000'),
('D0F946CF-CAC4-D978-F7FC-199A4DEC057E', 'Paid', 983.13, '2018-10-03 11:24:36.000', '99B252F5-3DE0-CA32-3347-2E3A734E829D', 0,'First','2018-10-08 14:26:48.000'),
('FE481D7B-7634-3585-77E5-A51CCF746B16', 'Paid', 290.52, '2019-06-08 18:03:54.000', '8BAC47FB-96AD-AB7F-3EB8-86C3933AF810', 0,'First','2019-06-13 21:06:06.000'),
('6769727A-3F28-D9DB-63AE-4092DB7E4FD3', 'Paid', 285.67, '2019-03-22 16:17:56.000', 'AAEE799B-953E-C16D-8F9F-970DAEB0AF7D', 0,'Regular','2019-03-22 16:17:56.000'),
('9D93270C-0934-E0E9-38E9-C515BF427460', 'Paid', 2112.67, '2019-02-22 22:21:16.000', 'A5D9FBE1-4276-B96A-EE8D-515B51D13EBE', 0,'First','2019-02-23 05:21:49.000'),
('90053212-3F68-1A50-9D99-6B59BA10862E', 'Paid', 851.2, '2018-12-15 11:53:12.000', 'EAF5CF20-808B-D769-4C58-39DC39A19850', 0,'Regular','2018-12-15 11:53:12.000'),
('402C41A0-A130-0A4D-08B0-9EB04738DA5D', 'Paid', 101.95, '2018-12-01 00:52:23.000', '12240FF3-B520-6521-9CEE-C7350CDCC5A3', 0,'First','2018-12-01 07:52:56.000'),
('69C1C407-1E68-50A6-0275-57CDC6BE0C5E', 'Paid', 2227.57, '2018-12-19 12:07:05.000', 'A37D36E3-6C2E-8D96-5D10-163C21A4082F', 0,'Regular','2018-12-19 12:07:05.000'),
('FE95F765-F3EE-2FB5-9A6A-D31CE1D6A80A', 'Paid', 158.12, '2018-12-01 08:39:16.000', '0620E34E-1737-2882-D4AF-A2C4A6E87B82', 0,'First','2019-06-11 09:31:44.000'),
('582579AF-E4A6-BFB9-ADE0-15770FFB3B85', 'Paid', 398.32, '2018-11-10 21:42:45.000', 'C34210A5-6FE6-E22E-AFEB-93B2720CCEA4', 0,'First','2018-11-11 04:43:18.000'),
('649F48EF-2CA0-965E-5815-33DD2A5603B4', 'Paid', 382.21, '2019-07-27 15:05:32.000', '12B24901-1D52-29EC-55E8-5B91FB06C964', 0,'Regular','2019-08-01 18:07:44.000'),
('97F1ED5B-2C97-EC00-C2C8-77B84FAF1122', 'Paid', 190.49, '2016-03-17 17:34:22.000', 'C8F73EBA-739A-E511-9E6E-005056992328', 0,'Regular','2016-03-17 17:34:22.000'),
('83619CEF-99FD-6AEF-9E9D-3C26DFEA5E41', 'Paid', 1195.01, '2019-05-08 07:54:41.000', '8374F308-0407-27FE-E398-0F2D4B3A67EF', 0,'Replacement','2019-05-08 07:54:41.000'),
('CAD1AF6B-1EF5-1319-9787-FF4331D0E582', 'Paid', 2147.74, '2018-04-12 05:33:39.000', '79453C9F-4EBD-5C84-28FE-D76DF85B895F', 0,'First','2018-04-12 05:33:39.000'),
('6C84AE7A-5429-CF4F-60D4-2D8B34FA1810', 'Paid', 798.15, '2019-02-16 21:11:57.000', '794648C3-1E0A-B0C0-361E-B6D5CD585FE5', 0,'First','2019-02-17 04:12:30.000'),
('23DC3032-3E0F-7C61-6E76-96A104771955', 'Paid', 1437.36, '2019-02-02 13:55:10.000', '26A83F17-411E-0E87-CA1E-DAB8E0515F1D', 0,'First','2019-02-02 20:55:43.000'),
('D0A9BD06-5CBF-4D0B-2F30-EFB80C7E413D', 'Paid', 686.35, '2018-12-18 04:08:16.000', '0FB9B0B2-E755-48AA-3D02-A88D322EF68C', 0,'First','2018-12-23 07:10:28.000'),
('4A61A6E1-F4E2-96C6-4F3C-67F854B56429', 'Paid', 503.11, '2019-04-27 03:26:11.000', '203756EA-6D90-591F-8A43-4008F459B1FA', 0,'Regular','2019-04-27 03:26:11.000'),
('A598EE2E-7C30-5509-9B19-89AC8FCC6D69', 'Paid', 501.14, '2018-10-10 16:09:15.000', '430D79BF-6229-5076-D45C-4491BF70AB83', 0,'First','2018-10-10 16:09:15.000'),
('43D0FD4D-A57F-F290-93A5-FC9B7BED9ACE', 'Paid', 135.36, '2019-06-07 06:22:26.000', '07976B81-E257-1805-C726-804366B9C756', 0,'First','2019-06-12 09:24:38.000'),
('7385DE65-D1F6-077F-5727-59390B2263F1', 'Paid', 983.13, '2018-11-03 11:24:36.000', '99B252F5-3DE0-CA32-3347-2E3A734E829D', 0,'Regular','2018-11-03 18:25:09.000'),
('D0D2708E-9CF1-50DA-5A95-D62F5FEE75D0', 'Paid', 703.78, '2018-11-08 02:45:33.000', '972FE97A-5C1C-1C77-F9FB-DA770E66EC53', 0,'Regular','2018-11-13 05:47:45.000'),
('B850DDF0-A5BE-7146-DCA8-C2FCB939768F', 'Paid', 448.28, '2018-10-21 03:44:29.000', 'C9788C94-88AA-375D-6F9B-868379DED953', 0,'Regular','2018-10-26 06:46:41.000'),
('F0D962F7-1756-0313-13C2-625355C04A05', 'Paid', 979.98, '2018-06-01 08:27:35.000', 'E282BE1D-FF52-5AED-161B-A62E10DA38DE', 0,'First','2018-06-01 08:27:35.000'),
('0D56A56D-204E-D59E-C24A-67C44C8EAB58', 'Failed', 168.55, '2018-04-03 04:41:08.000', '50C00C49-748B-DC74-EED6-54F31C61FD63', 0,'First','2018-04-03 04:41:08.000'),
('05B1050A-CEDF-E1C0-664A-B0760F692A7A', 'Paid', 2241.73, '2018-10-19 16:16:15.000', '1E296A35-E909-D60D-446E-68AF7F861B3D', 0,'First','2018-10-24 19:18:27.000'),
('96328CE3-AB70-B984-D782-14CD0C98B485', 'Paid', 795.65, '2018-05-27 15:15:24.000', '179377CC-055F-2C92-AEEB-3AE221BA8A81', 0,'First','2018-05-27 15:15:24.000'),
('47A87133-47DB-D0F8-87E6-7894F4EDE8E3', 'Paid', 1458, '2018-11-25 20:28:39.000', '5DC6C348-C240-6E2E-9E0C-FF6DF91386C3', 0,'Regular','2018-11-26 03:29:12.000'),
('E3222AC6-82B2-B433-B15C-17A2DEB1E1DB', 'Paid', 393.48, '2019-11-01 08:28:10.000', '3D20F34F-8ACB-2A2D-1A84-A1E01366BFC0', 0,'Regular','2019-06-11 09:31:44.000'),
('23FF3CA3-2A72-AA2D-8973-E5B07F8112A3', 'Paid', 131.07, '2016-03-02 16:17:29.000', '8E49213C-0A79-E511-9E6E-005056992328', 0,'Regular','2016-03-07 19:19:41.000'),
('7B8BC7A8-D0F3-19E4-15C2-CAFE7A753C91', 'Paid', 1065.27, '2018-06-30 09:47:25.000', '60AD4114-871F-F777-11FC-FC4F3F75C3ED', 0,'Regular','2018-06-30 16:47:58.000'),
('D713FFA8-1286-B6D2-A3D0-B8B56AB903A3', 'Paid', 1050.76, '2019-08-14 16:49:36.000', '2F162A36-F4EA-09F2-B822-F80857E3AA64', 0,'Regular','2019-08-19 19:51:48.000'),
('B42BC258-645C-2686-5D5C-04AF436E66D1', 'Paid', 1513.72, '2019-08-14 04:17:21.000', '9B477341-C7B2-0C66-55AF-22407518C9E1', 0,'Replacement','2019-08-14 04:17:21.000'),
('BDFE54CF-7345-6340-1746-54D7DF376C9E', 'Paid', 528.05, '2019-09-04 16:26:24.000', '5557CAA9-0B11-B81C-21D2-C3878742208B', 0,'First','2019-09-04 16:26:24.000'),
('14351E5D-1882-17A7-52D0-15F8C91758A0', 'Paid', 1452, '2018-04-19 10:55:34.000', '2CD63ACA-28F4-52A5-D27D-0B2557B8ADF0', 0,'First','2018-04-19 10:55:34.000'),
('D1D48EF9-AE21-3587-6E65-6DFACB31CE2B', 'Paid', 444.79, '2019-02-24 17:38:05.000', 'CAF5365A-40D8-7886-314B-2C4A97D7F1F4', 0,'First','2019-02-25 00:38:38.000'),
('34391961-1D45-C38C-BFB8-716092DACC37', 'Paid', 503.48, '2019-01-24 19:51:07.000', '84B1CC2D-00A2-0514-5E18-04A033E46D19', 0,'Regular','2019-01-24 19:51:07.000'),
('C14B8DB2-12AE-8E04-C50A-349A4BA44F78', 'Paid', 70.56, '2019-07-07 00:03:56.000', '3082DE73-A675-048B-152F-1202D0A85609', 0,'Regular','2019-06-11 09:31:44.000'),
('74D5C925-077E-351E-62D8-EE69E56C3BCF', 'Paid', 389.15, '2018-07-18 14:00:42.000', '4C83314C-0998-82EF-9F5C-B990654EF3E4', 0,'Regular','2018-07-18 14:00:42.000'),
('121602B8-D7EE-7A61-0F10-5C8668857ED4', 'Paid', 1195.01, '2019-03-08 07:54:41.000', '8374F308-0407-27FE-E398-0F2D4B3A67EF', 0,'Replacement','2019-03-08 14:55:14.000'),
('3F1B00BC-29A7-A2D9-60A0-63C630E529DB', 'Paid', 559.71, '2019-10-05 22:18:35.000', '2DB874DC-ACCE-A766-B616-D13FE51A410A', 0,'First','2019-10-05 22:18:35.000'),
('2455AE2A-EC03-3616-CBFB-233DC43BCAFA', 'Paid', 419, '2019-10-12 18:14:59.000', 'CD867D11-655C-623D-9F4C-9647C96BF455', 0,'Regular','2019-10-12 18:14:59.000'),
('0C315782-D2D6-8B77-3F77-4E051F3B55A5', 'Paid', 851.2, '2019-01-15 11:53:12.000', 'EAF5CF20-808B-D769-4C58-39DC39A19850', 0,'Regular','2019-01-20 14:55:24.000'),
('D8F2B2F5-1022-31FB-5205-06EEF65C8A74', 'Paid', 988.21, '2018-04-26 04:55:40.000', '982F4644-5F07-F9B4-1C5E-D0D057CCA820', 0,'Regular','2018-04-26 04:55:40.000'),
('5F895FE4-74F0-36D5-AAD5-68A2F320ED11', 'Paid', 1820.59, '2019-05-03 04:58:49.000', 'EF539E65-2684-D87A-A71B-D518C7075C21', 0,'Regular','2019-05-03 04:58:49.000'),
('ED076537-47CC-E937-FF16-202322D524A6', 'Paid', 317.15, '2019-08-29 11:31:13.000', '2F5D0956-C5CF-B36E-AD7C-7AD82E994B4E', 0,'First','2019-09-03 14:33:25.000'),
('1404ABB0-A122-A5F3-19A8-1D36D6456E70', 'Paid', 200.26, '2018-11-28 22:40:22.000', '9011AFD2-1C39-3141-9BE8-EDAA2F3FE3DE', 0,'Regular','2018-11-28 22:40:22.000'),
('F2523060-9A05-9686-88CD-799D7C4734B7', 'Paid', 179.21, '2018-04-25 05:09:58.000', '639AD403-1831-B758-FDD6-CADC207C68CE', 0,'First','2018-04-25 05:09:58.000'),
('0383A860-4294-6A2E-E906-F0CDD339B44F', 'Paid', 704.53, '2018-06-10 10:32:45.000', '0D331A11-2B2D-F666-9B1A-7C3ACEC477A2', 0,'Regular','2018-06-10 10:32:45.000'),
('8779993A-6614-15B3-84BC-C085BC4AA8A3', 'Paid', 382.21, '2019-06-27 15:05:32.000', '12B24901-1D52-29EC-55E8-5B91FB06C964', 0,'Regular','2019-06-27 15:05:32.000'),
('B43CC53D-3B77-CF32-E88D-53AA8558DC71', 'Paid', 1375.9, '2019-05-10 02:37:14.000', '1E4B1A35-7DC3-498C-3C60-C4733C354D36', 0,'Regular','2019-05-10 02:37:14.000'),
('E32046C9-67D2-E35F-2EBE-1645097134BB', 'Paid', 302.01, '2018-02-13 21:47:40.000', '6707B28B-84EA-A11E-1182-776D108AA2F6', 0,'First','2019-06-11 09:31:44.000'),
('09F2F946-076B-B072-F349-BCDCF78BEA0F', 'Paid', 1881.38, '2018-01-17 07:36:14.000', '06B247E1-EEA4-EF62-1111-A7838E4E0DBF', 0,'Regular','2018-01-17 14:36:47.000'),
('97A03F2A-E531-AEB7-9A1E-627928B35C72', 'Paid', 1458, '2018-12-25 20:28:39.000', '5DC6C348-C240-6E2E-9E0C-FF6DF91386C3', 0,'Regular','2018-12-30 23:30:51.000'),
('751AD848-0F20-2DE1-218D-016E7640366E', 'Paid', 393.48, '2019-12-01 08:28:10.000', '3D20F34F-8ACB-2A2D-1A84-A1E01366BFC0', 0,'Regular','2019-06-11 09:31:44.000'),
('20B8E5A2-7EB3-47C7-B89A-0AEDA8615187', 'Paid', 1452, '2018-05-19 10:55:34.000', '2CD63ACA-28F4-52A5-D27D-0B2557B8ADF0', 0,'Regular','2019-06-11 09:31:44.000'),
('62FE8A06-C747-DBD2-228D-DD7693B1EEED', 'Paid', 831.07, '2019-03-19 08:39:42.000', '955580B6-7AEB-615D-E96B-8FCAC0EB335D', 0,'Regular','2019-03-19 08:39:42.000'),
('72E662AD-34C5-E162-1655-E2BECDD83DDD', 'Paid', 47.18, '2018-09-08 01:16:46.000', '8453E83E-18F3-D1F5-EC70-16804FE446DF', 0,'First','2018-09-08 01:16:46.000'),
('DEDDE7D5-AB26-BB28-D051-921A1F0D7563', 'Paid', 131.07, '2016-04-02 16:17:29.000', '8E49213C-0A79-E511-9E6E-005056992328', 0,'Regular','2016-04-02 16:17:29.000'),
('5BB4A824-4CAC-DA0A-E905-A2FD1280F7EA', 'Paid', 1398.43, '2019-03-09 04:31:43.000', '096D6766-35C6-B162-F083-938176EECAB9', 0,'First','2019-03-09 04:31:43.000'),
('F9C5A7E4-FFA4-FB3D-714E-728D7D3D22E3', 'Paid', 411.92, '2019-10-08 05:21:54.000', '50267CE6-007B-B43E-306E-AAEC5CEC09C1', 0,'First','2019-10-08 12:22:27.000'),
('BC175E2E-5793-B0AC-E7BD-8CE37991E078', 'Paid', 746.63, '2019-02-15 05:07:58.000', '54024915-0570-91F4-313B-68F9D7738060', 0,'Regular','2019-06-11 09:31:44.000'),
('D5DEED2B-0C1E-14B6-BC6C-DD1CD0C5BDE5', 'Paid', 447.74, '2019-08-29 14:02:00.000', '178C92CA-1C49-4D2A-A427-D5DFC0953326', 0,'Regular','2019-08-29 14:02:00.000'),
('01C0ACA6-7234-3B84-54DF-43A792903741', 'Paid', 107.13, '2019-05-17 17:47:18.000', '88800A9D-372A-66D2-9CED-55D26413F425', 0,'First','2019-05-17 17:47:18.000'),
('C0C9559D-90F0-0276-B81D-E5702F066609', 'Paid', 130.68, '2019-11-20 09:00:30.000', 'BCC439CD-104B-96C6-F733-C741A922C2A3', 0,'Regular','2019-11-20 09:00:30.000'),
('455B0D2F-D1E5-BE77-2C68-AC9FD1FE5040', 'Paid', 1016.81, '2018-11-04 10:03:16.000', '82AD0F6D-6E24-1331-EB89-CDC550E43C46', 0,'First','2018-11-04 10:03:16.000'),
('DE12B21E-C76E-03C5-3AB3-BF365F96B67F', 'Paid', 831.07, '2019-02-19 08:39:42.000', '955580B6-7AEB-615D-E96B-8FCAC0EB335D', 0,'First','2019-02-19 08:39:42.000'),
('85C92DF0-BB32-B091-7AF1-7DC38F3567B8', 'Paid', 1156.43, '2019-09-17 05:40:23.000', 'C621DA30-6B27-B712-77AA-22F2F12B1800', 0,'First','2019-09-17 12:40:56.000'),
('9D5EF682-8124-27B1-5857-53F02A0DC670', 'Paid', 1526.79, '2019-01-02 16:26:01.000', '83A80A65-F75D-2163-5C9E-A5C757A806BE', 0,'First','2019-01-02 16:26:01.000'),
('2109B9B1-5597-8CDA-1002-A9EE301C2176', 'Paid', 1052.77, '2018-09-03 18:28:14.000', '30F61B8C-9057-DEA2-A6FF-929FB7E09599', 0,'Regular','2019-06-11 09:31:44.000'),
('063E2822-A9B0-C893-0939-CEB99C068117', 'Paid', 403.18, '2019-01-23 07:57:56.000', '09CCCB17-29A3-8F83-8F80-52BB6C979CC2', 0,'First','2019-01-23 07:57:56.000'),
('ADC9C923-3196-9A7A-BEAA-594DF104BC1D', 'Paid', 86.2, '2018-11-28 07:39:47.000', '8B465958-EE1D-C29E-8247-3CA59C145740', 0,'Regular','2019-06-11 09:31:44.000'),
('F1CB0406-64D6-DAF9-6DE0-7A19A1044B97', 'Paid', 526.52, '2018-04-06 16:44:16.000', 'FE521102-B5F5-CA9B-B235-CAB69F6568E7', 0,'First','2018-04-06 16:44:16.000'),
('D93EF8E0-C6A1-FE00-104D-19217071BFEF', 'Paid', 704.53, '2018-08-10 10:32:45.000', '0D331A11-2B2D-F666-9B1A-7C3ACEC477A2', 1,'Regular','2018-08-10 10:32:45.000'),
('8DBAA794-9248-DB44-F644-FF94E32A1CB9', 'Paid', 738.64, '2019-09-22 20:10:30.000', '7B84444D-7068-277A-02A0-EF45248E9337', 0,'First','2019-09-22 20:10:30.000'),
('530B64D6-FCBB-E3BC-AECC-EE3F82657CCC', 'Paid', 567.34, '2019-02-20 07:56:37.000', 'D079C81C-DB59-C6F7-09D4-5A18BC325904', 0,'Regular','2019-06-11 09:31:44.000'),
('A09955E0-27E4-53D9-409A-0C33CF944A5E', 'Paid', 444.79, '2019-03-24 17:38:05.000', 'CAF5365A-40D8-7886-314B-2C4A97D7F1F4', 0,'Regular','2019-03-24 17:38:05.000'),
('14D6C096-260A-C8B0-12EA-361A0D20207B', 'Paid', 456.65, '2019-06-24 12:54:40.000', '1F323E66-0FF4-AFCD-E25D-1DCC6531C220', 0,'Regular','2019-06-24 12:54:40.000'),
('8EC62B05-2A18-8145-AC9F-4D3331EF5A72', 'Paid', 1284.44, '2019-06-15 18:28:42.000', '06DF2FA9-172D-A020-7D3D-AA1E92F550F4', 0,'Regular','2019-06-15 18:28:42.000'),
('3347CEC1-66AD-3360-2204-6588AF5A886E', 'Paid', 259.67, '2018-10-02 01:26:13.000', '30B5899F-5330-86FF-7AED-3151F6DB3D52', 0,'First','2018-10-02 08:26:46.000'),
('3558F2CC-3F73-3DB2-66B9-030867575BAB', 'Paid', 386.78, '2019-07-28 11:09:39.000', '33053B8C-DAF6-201B-0E5A-8E4223CDC082', 0,'Regular','2019-07-28 18:10:12.000'),
('E6EA4852-D80D-A9C0-3EED-6DE69C635B04', 'Paid', 1210.28, '2018-09-04 13:43:16.000', 'E06685AE-A9D0-9490-1879-8871F441EA43', 0,'Regular','2018-09-04 13:43:16.000'),
('F21ADBB1-B383-E203-5EC8-32B58571C5F2', 'Paid', 528.05, '2019-11-04 16:26:24.000', '5557CAA9-0B11-B81C-21D2-C3878742208B', 0,'Regular','2019-11-04 16:26:24.000'),
('740A101F-EC12-C1D1-EE38-932F28870216', 'Paid', 790.33, '2019-12-22 05:49:54.000', '3162DD41-D398-D007-A65D-83DBEBABAA5D', 0,'Replacement','2019-12-22 05:49:54.000'),
('18672ADF-B63C-DB52-F8C5-771BC9BE2513', 'Paid', 1195.01, '2019-04-08 07:54:41.000', '8374F308-0407-27FE-E398-0F2D4B3A67EF', 0,'Regular','2019-04-08 14:55:14.000'),
('24058324-F4EB-0A2F-045B-3BD6B2D2EAE6', 'Paid', 203.07, '2018-07-28 10:02:05.000', '45E4CF31-6FFA-61D2-5A0A-7A59630B5063', 0,'First','2018-07-28 10:02:05.000'),
('C88DA96E-F72D-3DAE-FDFE-34526C3AD301', 'Paid', 244.81, '2018-08-17 01:45:57.000', '66DAE1C6-A7B9-972C-58CD-131595FB381C', 0,'Regular','2018-08-17 01:45:57.000'),
('6EE0F340-ECB6-ABC7-03CF-6D3D6AA807CD', 'Paid', 1820.59, '2019-06-03 04:58:49.000', 'EF539E65-2684-D87A-A71B-D518C7075C21', 0,'Regular','2019-06-11 09:31:44.000'),
('AB820CF7-B22E-4CE6-6434-38F452D5302C', 'Paid', 398.32, '2018-12-10 21:42:45.000', 'C34210A5-6FE6-E22E-AFEB-93B2720CCEA4', 0,'Regular','2018-12-10 21:42:45.000'),
('CCA8DF33-F8C6-6424-3AC8-79E67752EA3F', 'Paid', 1321.75, '2018-08-23 16:11:52.000', '0E5AD9C3-65CF-C270-A563-B0F3F36FC6A0', 0,'Regular','2018-08-23 16:11:52.000'),
('1DF38FD0-C131-9D78-D857-6C69746741DE', 'Paid', 979.98, '2018-07-01 08:27:35.000', 'E282BE1D-FF52-5AED-161B-A62E10DA38DE', 0,'Replacement','2019-06-11 09:31:44.000'),
('2AA1438F-29B5-0B7F-3099-FF1977E8FED0', 'Paid', 219.16, '2016-02-22 17:04:49.000', 'AE45089C-9D99-E511-9E6E-005056992328', 0,'Regular','2016-02-22 17:04:49.000'),
('5D51CDE8-0BEF-3301-1F94-A4C48331B4E3', 'Paid', 541.39, '2019-01-26 22:33:40.000', '32404FF1-9BE2-4AFC-0C4C-95EBF8FFD81D', 0,'First','2019-01-26 22:33:40.000'),
('65AAB23E-7996-0BB4-475C-E088E860C8EA', 'Paid', 704.53, '2018-07-10 10:32:45.000', '0D331A11-2B2D-F666-9B1A-7C3ACEC477A2', 0,'Regular','2018-07-10 10:32:45.000'),
('FD965089-B9FA-1189-2538-D7C4B0E4102A', 'Paid', 387.4, '2018-11-12 01:49:56.000', 'D476810E-DD53-CDC2-5AB6-1471B30A6112', 0,'Regular','2018-11-12 01:49:56.000'),
('983E283C-9BD4-11E9-A452-A339EFFF9D07', 'Paid', 244.81, '2018-09-17 01:45:57.000', '66DAE1C6-A7B9-972C-58CD-131595FB381C', 0,'Regular','2018-09-22 04:48:09.000'),
('A8DB1988-0A1F-A9C6-E4E5-0CE49BD3DAE1', 'Paid', 521.81, '2019-07-30 04:23:35.000', 'A3BAD951-8B90-5A17-141C-4D2A7141BE74', 0,'First','2019-07-30 11:24:08.000'),
('B7B1B4C9-118B-D1BA-B536-A7B024AFE4D9', 'Paid', 813.06, '2019-06-24 20:41:31.000', 'EFB3F4D2-B73F-0E15-1F52-A58B5BFC9EBB', 0,'Regular','2019-06-24 20:41:31.000'),
('29A91DA7-FD30-9E9A-1DF3-8C4424EA01A3', 'Paid', 526.52, '2018-05-06 16:44:16.000', 'FE521102-B5F5-CA9B-B235-CAB69F6568E7', 0,'Regular','2018-05-11 19:46:28.000'),
('74B05349-9D4F-876A-FB53-F1B8CC483C50', 'Paid', 503.11, '2019-05-27 03:26:11.000', '203756EA-6D90-591F-8A43-4008F459B1FA', 0,'Regular','2019-05-27 10:26:44.000'),
('FBA1F2F8-4F22-805E-529C-6C913EDBEE22', 'Paid', 501.14, '2018-11-10 16:09:15.000', '430D79BF-6229-5076-D45C-4491BF70AB83', 0,'Regular','2018-11-10 23:09:48.000'),
('1A354609-329D-2C96-C6C7-185757AFEFDF', 'Paid', 96.68, '2016-05-02 17:05:11.000', '5BCC2A59-5F7E-E511-9E6E-005056992328', 0,'Regular','2016-05-02 17:05:11.000'),
('68DFF1AE-B112-B46B-AE3B-53BE6CE39C9D', 'Paid', 907.44, '2019-01-17 18:39:49.000', 'F6225791-40E4-D2EB-255E-7AB467F53B6C', 0,'First','2019-01-17 18:39:49.000'),
('51CCDD70-5A7D-D4CC-4F8D-2A9F74F08D60', 'Paid', 988.21, '2018-03-26 04:55:40.000', '982F4644-5F07-F9B4-1C5E-D0D057CCA820', 0,'First','2018-03-26 11:56:13.000'),
('A6A4BEF9-A5B1-4F4B-1EEE-303D806F0A86', 'Paid', 793.11, '2018-10-11 16:48:50.000', '8BEE5C04-0EEC-D701-FC11-CD800A2E5C92', 0,'Replacement','2018-10-11 16:48:50.000'),
('967E0762-AB2D-D9BE-76AA-77687F1C43B9', 'Paid', 453.53, '2018-07-11 02:09:03.000', 'DED0F5C0-CE1E-EED8-EA83-8C1A91C61C0B', 0,'Replacement','2018-07-11 02:09:03.000'),
('4DD5D3D3-738A-D9ED-59EC-C694CC6FAB10', 'Paid', 520.76, '2018-10-23 05:19:29.000', 'E613574C-0336-18E6-50BB-F489F7C3C910', 0,'First','2019-06-11 09:31:44.000'),
('D7690718-8858-A9C7-4D82-01A7552BB6AA', 'Paid', 316.84, '2018-07-16 21:57:47.000', 'D96A0AEF-8AFE-5F36-BB34-2FC86E65CB46', 0,'Regular','2018-07-16 21:57:47.000'),
('AFB8FD1E-B4BA-A99E-F517-7F270C70701C', 'Paid', 136.32, '2018-06-15 23:02:28.000', '58FB7217-7698-0069-41DF-F1BB04A5801B', 0,'First','2018-06-21 02:04:40.000'),
('3D4BCA4A-B13A-5BC1-C495-4477EBA39BDB', 'Paid', 853.76, '2019-07-21 00:41:19.000', 'AC631786-926B-81CA-D59D-D2C69E156972', 0,'Regular','2019-07-21 00:41:19.000'),
('5A0ADB36-8437-D165-4C5D-F467D8C71803', 'Paid', 1340.37, '2018-05-20 12:35:08.000', '83A4DFBA-1DDC-1C90-991E-E868FF0BEC53', 0,'Regular','2018-05-20 12:35:08.000'),
('7A321118-F7C1-788C-72BE-6B62DD40120E', 'Paid', 559.71, '2019-12-05 22:18:35.000', '2DB874DC-ACCE-A766-B616-D13FE51A410A', 0,'Regular','2019-12-05 22:18:35.000'),
('ABAADFAF-1EFA-A567-A3CA-2232A498A804', 'Paid', 74.53, '2019-05-16 04:50:03.000', '3273F990-FD38-1CAF-912F-5FD1B3814A63', 0,'First','2019-05-16 04:50:03.000'),
('2B5AAD1A-66F1-1F12-9F65-4DC8D5FD38A0', 'Paid', 1052.77, '2018-07-03 18:28:14.000', '30F61B8C-9057-DEA2-A6FF-929FB7E09599', 0,'Regular','2018-07-03 18:28:14.000'),
('0C907003-79C6-59A4-54EB-36FB76EAD8F0', 'Paid', 694.16, '2019-06-19 01:08:46.000', '0FA04DD5-42B9-1114-74F9-500588ACE23B', 0,'First','2019-06-19 01:08:46.000'),
('28DD15C4-E0DC-0638-0A53-E4F372BEA2F7', 'Paid', 233.53, '2018-04-03 09:16:14.000', '03B912F3-C13B-2EE4-27F5-755030910D71', 1,'Regular','2018-04-03 09:16:14.000'),
('B3A896CC-2927-ABA0-CA75-37FCA922BE2B', 'Paid', 233.53, '2018-03-03 09:16:14.000', '03B912F3-C13B-2EE4-27F5-755030910D71', 0,'First','2018-03-03 09:16:14.000'),
('74618B0A-2B4A-BE35-185A-FAE3E28A79FD', 'Paid', 1284.44, '2019-08-15 18:28:42.000', '06DF2FA9-172D-A020-7D3D-AA1E92F550F4', 0,'Regular','2019-08-20 21:30:54.000'),
('C2F2056B-7368-6E9C-4218-17F560D56EDB', 'Paid', 303.23, '2019-09-01 07:12:29.000', 'C0BB565B-C4A1-1443-B9E0-9D926F3492B1', 0,'First','2019-09-01 07:12:29.000'),
('A7208121-A55A-5D11-DE89-6EBC76148039', 'Paid', 1242.49, '2019-12-18 11:55:42.000', '827DEF7F-5B29-35AB-1FCC-EFAA7023B0AC', 0,'Regular','2019-12-18 11:55:42.000'),
('5404FD3B-CF40-E650-9406-AB1A31878A5C', 'Paid', 1438.54, '2019-02-08 13:31:08.000', 'BB7F4C8E-84F0-F91E-8FFA-EDC2EC887B6A', 0,'Regular','2019-02-13 16:33:20.000'),
('916014E0-2AEF-B838-DB33-1EE5B4C1E9BD', 'Paid', 872.83, '2019-02-15 19:33:52.000', '9954D128-FC41-B17B-3E9E-4E1F5172ED0E', 0,'Regular','2019-02-15 19:33:52.000'),
('939C897F-C5EF-98DB-3B7C-71742514647D', 'Paid', 71.15, '2019-04-14 06:25:47.000', '3D9FBBF2-448E-D277-8E56-AC15C541C2ED', 0,'Regular','2019-04-14 06:25:47.000'),
('B1B6C8D7-98C1-1F5C-DC83-104945A3E651', 'Paid', 382.21, '2019-05-27 15:05:32.000', '12B24901-1D52-29EC-55E8-5B91FB06C964', 0,'First','2019-06-11 09:31:44.000'),
('B8EA1C14-0F3C-A060-7BCA-2FA9BC6275F7', 'Paid', 526.52, '2018-06-06 16:44:16.000', 'FE521102-B5F5-CA9B-B235-CAB69F6568E7', 0,'Regular','2018-06-06 16:44:16.000'),
('2DE70FB6-661D-9F77-3C56-9BD46A7B45D7', 'Paid', 1269.72, '2019-02-05 19:38:36.000', '6D19BA94-1555-1101-D546-3410B56967A8', 0,'Regular','2019-02-10 22:40:48.000'),
('911F89DD-BCEA-B11F-09D5-C338888204BF', 'Paid', 1438.54, '2019-01-08 13:31:08.000', 'BB7F4C8E-84F0-F91E-8FFA-EDC2EC887B6A', 0,'First','2019-01-08 13:31:08.000'),
('FA544BF0-A7E4-CC04-8771-E502BDF6430A', 'Paid', 1820.59, '2019-07-03 04:58:49.000', 'EF539E65-2684-D87A-A71B-D518C7075C21', 0,'Regular','2019-07-03 04:58:49.000'),
('A8E4D131-A0CA-6376-4AC0-59E683D9F3F3', 'Paid', 398.67, '2018-06-18 22:17:55.000', '83FCA2DE-7389-C0C3-E8DD-F21B3FEE61A6', 0,'First','2018-06-18 22:17:55.000'),
('B9CC3AFC-F188-A3B9-2C9A-938E4FDF5D53', 'Paid', 1289.35, '2018-08-02 08:40:55.000', '32DDD9E9-1AE9-3152-D8EB-46DC20C3F3AD', 0,'First','2018-08-02 08:40:55.000'),
('01778106-AB3D-893B-BD4E-525386C50D7C', 'Paid', 290.52, '2019-08-08 18:03:54.000', '8BAC47FB-96AD-AB7F-3EB8-86C3933AF810', 0,'Regular','2019-08-08 18:03:54.000'),
('1816D7FD-3644-6F54-D8BC-85C1B664AAE8', 'Paid', 1122.33, '2018-10-04 00:55:55.000', '5C4D8589-AFCE-5D28-E677-5851F16CB43B', 0,'Regular','2018-10-04 00:55:55.000'),
('11BE0BC8-A729-5A7B-6345-4A6E2EA663AD', 'Paid', 312.04, '2019-05-09 08:23:57.000', 'A103A2B1-4A5F-533E-10D8-2C11D70EC0E0', 0,'First','2019-05-09 08:23:57.000'),
('A7F679AE-87E3-ED74-3CC1-D7098E29F9A9', 'Paid', 158.12, '2019-03-01 08:39:16.000', '0620E34E-1737-2882-D4AF-A2C4A6E87B82', 0,'Regular','2019-03-01 08:39:16.000'),
('8E930DBE-8CAB-6211-E3EB-0D0817976718', 'Paid', 965.54, '2019-04-13 04:07:48.000', 'BA4251DA-7AF7-E1BD-745E-9B3E1955C99F', 0,'First','2019-06-11 09:31:44.000'),
('DA650506-445C-E14E-207B-81B6223456BB', 'Paid', 1438.54, '2019-03-08 13:31:08.000', 'BB7F4C8E-84F0-F91E-8FFA-EDC2EC887B6A', 0,'Regular','2019-03-08 20:31:41.000'),
('F62675E4-2277-5297-F508-889624183AB3', 'Paid', 207.41, '2019-09-10 18:21:57.000', 'F6F6A87D-D3C1-3563-8F90-62333C160785', 0,'First','2019-09-10 18:21:57.000'),
('78983765-63D2-2B8D-5F20-2085273B967D', 'Paid', 99.28, '2019-05-15 12:06:03.000', '069094D3-97D2-D920-3E94-BF41C42179D3', 0,'Regular','2019-06-11 09:31:44.000'),
('F14FBCCD-CB70-2918-DBA1-5B87D806C553', 'Paid', 130.68, '2019-10-20 09:00:30.000', 'BCC439CD-104B-96C6-F733-C741A922C2A3', 0,'Regular','2019-10-20 09:00:30.000'),
('D8FA360B-534C-BF99-10F5-057F81724FDE', 'Paid', 244.81, '2018-07-17 01:45:57.000', '66DAE1C6-A7B9-972C-58CD-131595FB381C', 0,'First','2018-07-17 01:45:57.000'),
('089FEC2C-FBF2-FD7B-741B-61969C0D1A25', 'Paid', 494.15, '2019-07-03 09:39:28.000', '9A33688F-8ABA-8E6F-2C16-0FC79B6B1946', 0,'Regular','2019-07-03 09:39:28.000'),
('8B0CF93A-B632-0727-4C2C-E73A9D3F33EE', 'Paid', 158.12, '2019-04-01 08:39:16.000', '0620E34E-1737-2882-D4AF-A2C4A6E87B82', 0,'Regular','2019-04-01 15:39:49.000'),
('DEAC769B-74CD-5841-1F0F-2A80A7BA232E', 'Paid', 979.98, '2018-08-01 08:27:35.000', 'E282BE1D-FF52-5AED-161B-A62E10DA38DE', 0,'Regular','2018-08-01 08:27:35.000'),
('7332D6F2-C29B-AD26-5E2C-4025426AB738', 'Paid', 541.39, '2019-06-26 22:33:40.000', '32404FF1-9BE2-4AFC-0C4C-95EBF8FFD81D', 0,'Regular','2019-06-26 22:33:40.000'),
('255AFFCB-97E4-8967-89A8-D89846D50FAA', 'Paid', 397.24, '2018-07-17 12:27:30.000', '9AAD1C11-8FBE-5B5A-1056-CD64122C06E1', 0,'Regular','2018-07-22 15:29:42.000'),
('AC851BB0-06BF-08AD-9CFB-526B1B655F01', 'Paid', 447.74, '2019-06-29 14:02:00.000', '178C92CA-1C49-4D2A-A427-D5DFC0953326', 0,'First','2019-06-29 21:02:33.000'),
('2CEBA3DA-282F-C48C-1FCE-BAFA77FDC936', 'Paid', 851.2, '2018-11-15 11:53:12.000', 'EAF5CF20-808B-D769-4C58-39DC39A19850', 0,'Regular','2018-11-15 11:53:12.000'),
('B22C38FA-AADD-405C-1685-82A80F744E1F', 'Paid', 137.08, '2018-06-26 01:14:22.000', '1C7F206C-58E7-C919-68BD-68AFE66E98CC', 1,'First','2018-06-26 01:14:22.000'),
('65571A93-A83A-2666-D590-44D3D74E51D8', 'Paid', 1278.79, '2018-07-03 01:37:11.000', '42CEB705-FA1D-4EFD-03C8-9BD89414BB8F', 0,'First','2018-07-03 01:37:11.000'),
('0E406A97-0B58-E137-4488-09DD4B5D12E1', 'Paid', 1284.44, '2019-07-15 18:28:42.000', '06DF2FA9-172D-A020-7D3D-AA1E92F550F4', 0,'Regular','2019-07-15 18:28:42.000'),
('5C82310F-4A46-DDCF-DCE5-CCE87356EBB2', 'Paid', 890.52, '2019-03-18 06:57:30.000', '6ADA3882-CA98-EB4C-86FD-07478C34CBED', 0,'First','2019-03-18 13:58:03.000'),
('3743C1B5-451D-9C52-79F9-2AB6A3257AE4', 'Paid', 453.53, '2018-06-11 02:09:03.000', 'DED0F5C0-CE1E-EED8-EA83-8C1A91C61C0B', 0,'Regular','2018-06-11 02:09:03.000'),
('8D66A0CF-E23D-B504-B541-FA9E3129F00D', 'Paid', 1458, '2018-07-25 20:28:39.000', '5DC6C348-C240-6E2E-9E0C-FF6DF91386C3', 0,'Regular','2018-07-30 23:30:51.000'),
('D11A61F4-C477-5C20-77B3-5E07EEDAFBED', 'Paid', 1513.72, '2019-10-14 04:17:21.000', '9B477341-C7B2-0C66-55AF-22407518C9E1', 0,'Regular','2019-10-14 04:17:21.000'),
('7F2B5198-9E35-1C1A-280F-10B295B9EC67', 'Paid', 881.6, '2019-10-24 21:25:22.000', 'D0019997-EC6E-5E96-B07C-838B6DE35692', 0,'Regular','2019-10-24 21:25:22.000'),
('23AEAC81-43E2-57DB-9D81-76579C37A0E9', 'Paid', 1424.65, '2018-07-25 03:03:46.000', 'D9F5601F-AC32-8C5C-EB3D-215A8E81EB3E', 0,'First','2018-07-25 10:04:19.000'),
('330F3FCF-CC43-96CF-1918-EA8E7F943720', 'Paid', 1065.27, '2018-07-30 09:47:25.000', '60AD4114-871F-F777-11FC-FC4F3F75C3ED', 0,'Regular','2018-07-30 09:47:25.000'),
('B239684A-C574-7555-7B0C-2E7B0005D52B', 'Paid', 217.52, '2019-02-03 08:02:30.000', 'C997B0E7-19B0-7ABD-180E-00D1B3FAAED6', 0,'First','2019-02-03 08:02:30.000'),
('C7669625-3E4A-5837-5072-8E3B3D1DB5C6', 'Paid', 494.07, '2018-08-20 13:29:42.000', '1DD2E8B4-975B-EB83-FE44-58F0BB62BA8B', 0,'First','2018-08-20 20:30:15.000'),
('4330C824-7125-2F4F-9017-720346A52D8A', 'Paid', 217.52, '2019-03-03 08:02:30.000', 'C997B0E7-19B0-7ABD-180E-00D1B3FAAED6', 0,'Replacement','2019-03-03 15:03:03.000'),
('5DF99EA0-A9B4-1266-A705-6A2821369A13', 'Paid', 456.45, '2019-05-29 20:45:20.000', '9CAB0B55-2330-0F70-29A0-88D56B951877', 0,'Replacement','2019-05-29 20:45:20.000'),
('22FBE73B-7806-D885-40C7-78004356196B', 'Paid', 419, '2019-11-12 18:14:59.000', 'CD867D11-655C-623D-9F4C-9647C96BF455', 0,'Regular','2019-11-12 18:14:59.000'),
('EA52B697-B029-842F-CC7C-1708FCBE30FD', 'Paid', 416.01, '2019-08-11 20:17:42.000', 'F0D02C5E-215C-E93A-DCE4-D4AE11AE6D05', 0,'First','2019-08-11 20:17:42.000'),
('63040F3F-FF5D-2E83-BECA-88D114FB7E2C', 'Paid', 682.24, '2018-07-05 00:15:27.000', 'FF10996F-975F-D831-9A80-3530E03A1BD9', 0,'Regular','2018-07-05 00:15:27.000'),
('9DB7DA6C-A759-3748-37D6-AB8A4662D770', 'Failed', 556.32, '2018-11-12 06:58:59.000', 'E6959ACC-AFDC-6B4A-0D28-12304871C7C6', 0,'First','2018-11-12 06:58:59.000'),
('1690807B-D668-E23C-A339-EE11183ADBE3', 'Paid', 1513.72, '2019-09-14 04:17:21.000', '9B477341-C7B2-0C66-55AF-22407518C9E1', 0,'Regular','2019-09-14 11:17:54.000'),
('B24E7B47-AE87-5928-9209-AE7772421EED', 'Paid', 528.05, '2019-12-04 16:26:24.000', '5557CAA9-0B11-B81C-21D2-C3878742208B', 0,'Regular','2019-12-04 23:26:57.000'),
('7989C1CE-AE9B-5CD6-1544-415D7178CE26', 'Paid', 67.6, '2019-04-12 02:59:00.000', 'C6B63E38-78C9-1E72-2913-D0B20DDAC7EF', 0,'Regular','2019-06-11 09:31:44.000'),
('74EC218D-2C62-D81A-5C26-4EE303E34450', 'Paid', 99.28, '2019-04-15 12:06:03.000', '069094D3-97D2-D920-3E94-BF41C42179D3', 0,'First','2019-04-20 15:08:15.000'),
('45670638-DB89-08C0-5E43-A1DCCEEF9552', 'Paid', 851.2, '2018-10-15 11:53:12.000', 'EAF5CF20-808B-D769-4C58-39DC39A19850', 0,'First','2018-10-15 11:53:12.000'),
('E67D8F47-2F5B-B3A1-C624-A9D0BBC86315', 'Paid', 329.46, '2018-12-21 09:52:53.000', 'FE9A32E2-C930-7C48-4A85-26064C13A99D', 0,'Regular','2018-12-21 09:52:53.000'),
('E8740D86-55DA-ACC5-3AAD-87288F3F3AA9', 'Paid', 387.4, '2019-01-12 01:49:56.000', 'D476810E-DD53-CDC2-5AB6-1471B30A6112', 0,'Regular','2019-01-12 01:49:56.000'),
('22E13B94-471C-28BF-285F-2A3932277CEC', 'Paid', 285.67, '2019-01-22 16:17:56.000', 'AAEE799B-953E-C16D-8F9F-970DAEB0AF7D', 0,'First','2019-01-22 16:17:56.000'),
('E0FF60B4-3685-32E6-3109-F454A6605517', 'Paid', 389.15, '2018-08-18 14:00:42.000', '4C83314C-0998-82EF-9F5C-B990654EF3E4', 0,'Regular','2018-08-18 14:00:42.000'),
('44C40944-D8AB-A309-4597-C4D2FF32BA37', 'Paid', 1016.81, '2019-02-04 10:03:16.000', '82AD0F6D-6E24-1331-EB89-CDC550E43C46', 0,'Regular','2019-06-11 09:31:44.000'),
('49E0EB99-8814-4AC6-D9B3-F4C640037D3B', 'Paid', 1251.67, '2019-07-15 12:08:22.000', '22A53B69-1603-3799-8E91-6DAFA5D3C2D8', 0,'Replacement','2019-07-15 12:08:22.000'),
('EF0CA5E3-0B58-D013-051A-937560284931', 'Paid', 2111.16, '2017-01-21 15:39:20.000', 'DBC6BE91-CB4F-02E2-3F52-0338E8173DD7', 0,'First','2017-01-21 15:39:20.000'),
('8F90907F-234A-62FC-CC77-6F2CA80A4904', 'Paid', 2139.81, '2019-04-21 01:23:46.000', '17F41EC1-7AF2-F724-07C9-4A7755B17FA3', 0,'Regular','2019-04-26 04:25:58.000'),
('5B5A07CC-6E8C-9AF4-7ABD-10DE39F1B7B9', 'Paid', 790.33, '2019-09-22 05:49:54.000', '3162DD41-D398-D007-A65D-83DBEBABAA5D', 0,'First','2019-09-22 05:49:54.000'),
('9D682BCF-61DA-5A4F-417F-0D6AE0ABEAE4', 'Paid', 74.53, '2019-06-16 04:50:03.000', '3273F990-FD38-1CAF-912F-5FD1B3814A63', 0,'Regular','2019-06-16 11:50:36.000'),
('B82189D8-B6BF-A77C-F6E7-7C57145B73F2', 'Paid', 393.48, '2019-09-01 08:28:10.000', '3D20F34F-8ACB-2A2D-1A84-A1E01366BFC0', 0,'First','2019-09-01 08:28:10.000'),
('9AFB6777-FD0D-E187-EA9F-D56481EF577A', 'Paid', 557.48, '2019-04-29 22:59:47.000', '159350A4-87FD-D064-9100-752BD2023927', 0,'First','2019-06-11 09:31:44.000'),
('3BA8DD64-4BF8-8121-F136-F01E3D299D1A', 'Paid', 566.69, '2018-04-08 13:27:54.000', '527B7682-60DA-C685-F2CC-CAADFCAEA1CB', 0,'Regular','2018-04-08 13:27:54.000'),
('F9D9BBDC-3659-6435-53C7-2962E1DD5C46', 'Paid', 444.79, '2019-04-24 17:38:05.000', 'CAF5365A-40D8-7886-314B-2C4A97D7F1F4', 0,'Regular','2019-04-24 17:38:05.000'),
('63C8EF37-78B8-DD41-DF94-6E947B29FB8C', 'Paid', 494.15, '2019-06-03 09:39:28.000', '9A33688F-8ABA-8E6F-2C16-0FC79B6B1946', 0,'First','2019-06-03 09:39:28.000'),
('30247682-9EB8-DB84-F5F5-4566F51D4954', 'Paid', 2227.57, '2019-01-19 12:07:05.000', 'A37D36E3-6C2E-8D96-5D10-163C21A4082F', 0,'Regular','2019-01-19 12:07:05.000'),
('5BC4F0CB-D2F5-2B2D-064C-0E3B1F0D791D', 'Paid', 654.17, '2018-10-16 11:38:36.000', '2FB95E70-6B3D-40D8-33A2-8BDE48F9A588', 0,'First','2018-10-16 11:38:36.000'),
('1C07814B-66E2-8869-9456-5BB0A8AE731E', 'Paid', 99.28, '2019-06-15 12:06:03.000', '069094D3-97D2-D920-3E94-BF41C42179D3', 0,'Replacement','2019-06-15 12:06:03.000'),
('F2272CF2-7892-457C-F7D1-331C7BE83EFC', 'Paid', 137.08, '2018-07-26 01:14:22.000', '1C7F206C-58E7-C919-68BD-68AFE66E98CC', 0,'Regular','2018-07-26 08:14:55.000'),
('B0653FB2-A99D-8A4C-348E-21863F0AEE13', 'Paid', 928.88, '2018-10-30 16:27:59.000', 'DD802EF9-0C7E-77DE-D767-B83566478FC8', 0,'Regular','2018-10-30 16:27:59.000'),
('EBB9F7D2-CCB3-F4A1-ED60-EF0B45749BE0', 'Paid', 704.53, '2018-09-10 10:32:45.000', '0D331A11-2B2D-F666-9B1A-7C3ACEC477A2', 0,'Regular','2018-09-10 17:33:18.000'),
('E8D4AC27-D62E-5ECC-8A21-CC8E226E692F', 'Failed', 1491.18, '2019-01-07 09:34:45.000', '473A97A8-740E-A19F-0088-9AEAD5565E65', 0,'Regular','2019-01-12 12:36:57.000'),
('0DF05BCE-D8C4-F8C8-83E4-D22D70A3CA61', 'Paid', 525.72, '2019-01-12 10:32:17.000', 'B4208560-AFCA-307A-0746-02263621E8E8', 0,'Regular','2019-06-11 09:31:44.000'),
('A7EE28A2-F8A2-D499-824D-CD4837075D81', 'Paid', 1375.9, '2019-04-10 02:37:14.000', '1E4B1A35-7DC3-498C-3C60-C4733C354D36', 0,'First','2019-04-10 02:37:14.000'),
('4B69AF1B-F755-9E72-0ED6-CD3EB6512C76', 'Paid', 1714.94, '2019-10-08 00:30:50.000', 'FE814246-6B54-B767-6D7C-5CB294E6E025', 0,'First','2019-10-08 07:31:23.000'),
('DCB73ED2-AB8D-D9D6-C7D1-5935D521EE14', 'Paid', 1321.75, '2018-10-23 16:11:52.000', '0E5AD9C3-65CF-C270-A563-B0F3F36FC6A0', 0,'Regular','2018-10-23 16:11:52.000'),
('83730FC9-25E3-E629-359F-7EC1DA3662D2', 'Paid', 1011.06, '2019-10-26 12:20:06.000', 'C541B083-8975-A7C6-1A6B-B38C2DB09869', 0,'First','2019-10-31 15:22:18.000'),
('66E6079C-1805-8172-64D5-FC5F31EC7834', 'Paid', 732.97, '2018-08-11 12:38:19.000', '875D83BE-BEFA-D788-F78E-7E67DA2E2F10', 0,'First','2018-08-11 12:38:19.000'),
('4D96F264-76E8-A90B-2885-FCEF02313B92', 'Paid', 807.42, '2019-05-19 10:33:44.000', 'E1C2D783-F61B-2F08-2724-905624F18ABA', 0,'Replacement','2019-05-19 10:33:44.000'),
('4B1169B2-8373-F88F-A8A0-2DBFF577F613', 'Paid', 988.21, '2018-06-26 04:55:40.000', '982F4644-5F07-F9B4-1C5E-D0D057CCA820', 0,'Regular','2018-06-26 04:55:40.000'),
('6E40DD5A-A2E0-41D0-C66C-833875EF029C', 'Paid', 302.01, '2018-03-13 21:47:40.000', '6707B28B-84EA-A11E-1182-776D108AA2F6', 0,'Regular','2019-06-11 09:31:44.000'),
('49208040-EC3D-EF41-0C77-F8C4EA333196', 'Paid', 200.26, '2018-12-28 22:40:22.000', '9011AFD2-1C39-3141-9BE8-EDAA2F3FE3DE', 0,'Regular','2018-12-28 22:40:22.000'),
('6837BCCD-6C1E-7DFF-EC2D-5C3172F6003E', 'Paid', 392.51, '2018-08-20 19:34:02.000', '904E3092-17C7-B630-72D0-744E861C6EE6', 0,'First','2018-08-20 19:34:02.000'),
('C150222C-C73C-862B-66BF-8F6CC9BB4B90', 'Paid', 1288.54, '2018-08-21 21:59:49.000', 'F667039C-7B4B-4543-76B3-CD046F4245BF', 0,'Regular','2018-08-21 21:59:49.000'),
('1B0E7FD8-4419-8C51-3893-B6C6308DC2E2', 'Paid', 285.67, '2019-02-22 16:17:56.000', 'AAEE799B-953E-C16D-8F9F-970DAEB0AF7D', 0,'Regular','2019-02-22 23:18:29.000'),
('A5463D98-2D09-55B2-C880-55DC447D0B9C', 'Paid', 951.22, '2018-03-26 15:36:54.000', '7DF39475-E984-02F6-F00A-BD6BB6DF1D5E', 0,'First','2019-06-11 09:31:44.000'),
('EC1688FB-5CC3-B9E5-DFF4-C87BABC6737B', 'Paid', 1271.68, '2019-10-15 13:23:28.000', '87CE0771-D3CC-5F20-B2A8-EF8F332869AA', 0,'First','2019-10-15 20:24:01.000'),
('524213E5-AE08-D921-90F6-0E17ED77CD85', 'Paid', 1491.18, '2018-12-07 09:34:45.000', '473A97A8-740E-A19F-0088-9AEAD5565E65', 0,'First','2018-12-07 09:34:45.000'),
('49B775BF-47D4-78EE-8EA0-6013C8D24529', 'Paid', 2108.97, '2019-06-06 20:40:04.000', '1F3953BC-DF93-3BFC-A915-03B9F7DA4EF7', 0,'First','2019-06-11 23:42:16.000'),
('D738B82E-8382-79FC-AD7F-4227667CFE7D', 'Paid', 1052.77, '2018-06-03 18:28:14.000', '30F61B8C-9057-DEA2-A6FF-929FB7E09599', 0,'First','2018-06-04 01:28:47.000'),
('30A2D3A1-E982-F71C-1AE3-3BD51ECB6322', 'Paid', 1156.43, '2019-10-17 05:40:23.000', 'C621DA30-6B27-B712-77AA-22F2F12B1800', 0,'Replacement','2019-10-17 05:40:23.000'),
('087D0027-DFAB-114C-9768-6DB6D9AEFB40', 'Paid', 1050.76, '2019-09-14 16:49:36.000', '2F162A36-F4EA-09F2-B822-F80857E3AA64', 0,'Regular','2019-09-14 16:49:36.000'),
('9FDA08C9-BCEF-423C-16DF-264AD3A8DC6D', 'Paid', 907.44, '2019-03-17 18:39:49.000', 'F6225791-40E4-D2EB-255E-7AB467F53B6C', 0,'Regular','2019-03-22 21:42:01.000'),
('9B044B05-E7E2-0F6B-1786-7CD8F3B479C5', 'Paid', 798.24, '2018-11-14 03:38:28.000', '4B327C2E-55F7-480F-9478-780E96ECCBC1', 0,'First','2018-11-19 06:40:40.000'),
('37DE87F1-ACF9-1A50-1CE8-DAB9B0A25081', 'Paid', 1271.68, '2019-11-15 13:23:28.000', '87CE0771-D3CC-5F20-B2A8-EF8F332869AA', 0,'Regular','2019-11-15 13:23:28.000'),
('E2971DFC-9F59-BA2C-57CC-5BAFD4F7BA46', 'Paid', 988.76, '2019-06-20 16:25:21.000', 'AEB79D84-D2C4-4DAB-2C67-03DAC4276F7C', 0,'First','2019-06-20 16:25:21.000'),
('28278DA9-8E70-A969-0850-E63901BA47C6', 'Paid', 979.98, '2018-09-01 08:27:35.000', 'E282BE1D-FF52-5AED-161B-A62E10DA38DE', 0,'Regular','2018-09-01 15:28:08.000'),
('78D8FA9E-59FC-1542-7CC3-3D6F1AF8391D', 'Paid', 2112.67, '2019-03-22 22:21:16.000', 'A5D9FBE1-4276-B96A-EE8D-515B51D13EBE', 0,'Regular','2019-03-22 22:21:16.000'),
('037AADF7-C810-F011-DD2F-B07C44E0820A', 'Paid', 1458, '2018-06-25 20:28:39.000', '5DC6C348-C240-6E2E-9E0C-FF6DF91386C3', 0,'First','2018-06-30 23:30:51.000'),
('4B260CFC-441B-0BE0-F2DF-89D276A1953A', 'Paid', 447.74, '2019-07-29 14:02:00.000', '178C92CA-1C49-4D2A-A427-D5DFC0953326', 0,'Regular','2019-06-11 09:31:44.000'),
('1445AA15-1AD6-E030-C250-987164DCC20D', 'Paid', 1057.28, '2019-09-23 07:02:11.000', '187F22EF-A925-72C5-D9C3-7B150176AB93', 0,'First','2019-09-23 14:02:44.000'),
('7AAF82C5-BF22-6159-9873-B78985766643', 'Paid', 1789.77, '2019-10-08 16:04:31.000', '29F03814-7D4F-509A-781A-AADF2D904D17', 0,'First','2019-10-08 16:04:31.000'),
('FF202165-3DCA-5127-F0D0-5EE548819887', 'Paid', 673.9, '2018-11-13 12:37:54.000', 'A89777C1-E7EC-D8EF-637A-0BA5BFFB15E7', 0,'First','2018-11-13 12:37:54.000'),
('AE274A34-A14B-2266-F15F-C8127E944074', 'Paid', 2108.97, '2019-07-06 20:40:04.000', '1F3953BC-DF93-3BFC-A915-03B9F7DA4EF7', 0,'Regular','2019-07-11 23:42:16.000'),
('95D32900-2EDB-D8CC-A4BF-17CF2D937C67', 'Paid', 1321.75, '2018-09-23 16:11:52.000', '0E5AD9C3-65CF-C270-A563-B0F3F36FC6A0', 0,'Regular','2018-09-23 16:11:52.000'),
('21B41117-58DD-33F0-DA7B-001BC0FD1007', 'Paid', 567.34, '2019-03-20 07:56:37.000', 'D079C81C-DB59-C6F7-09D4-5A18BC325904', 0,'Regular','2019-06-11 09:31:44.000'),
('954B9842-33DE-2206-1E84-20CFC37A7CE8', 'Paid', 397.24, '2018-06-17 12:27:30.000', '9AAD1C11-8FBE-5B5A-1056-CD64122C06E1', 0,'First','2018-06-17 12:27:30.000'),
('AE42DCF1-7060-738B-98BB-08FBAF67ADF8', 'Paid', 906.85, '2018-10-07 12:40:48.000', '07E1C84E-3D8E-9C2E-67BB-F0E9128EB1E2', 0,'Replacement','2018-10-12 15:43:00.000'),
('562A2C2D-6A3B-99F4-0F1B-D02985E2ED8D', 'Paid', 456.45, '2019-04-29 20:45:20.000', '9CAB0B55-2330-0F70-29A0-88D56B951877', 0,'First','2019-04-29 20:45:20.000'),
('EE0748C3-E181-438F-E7E2-4412C44DA95A', 'Paid', 1210.28, '2018-11-04 13:43:16.000', 'E06685AE-A9D0-9490-1879-8871F441EA43', 0,'Regular','2018-11-09 16:45:28.000'),
('3478E11E-D717-37CB-0474-05FE9AF499FA', 'Paid', 607.61, '2018-04-04 03:39:29.000', '911E2242-B3BB-ECA3-3957-6950C298F9EB', 0,'Regular','2018-04-04 03:39:29.000'),
('B0FA35DF-471F-5EBE-F3B9-68680008DDF6', 'Paid', 137.08, '2018-08-26 01:14:22.000', '1C7F206C-58E7-C919-68BD-68AFE66E98CC', 0,'Replacement','2018-08-26 08:14:55.000'),
('F2A2CB03-F315-CDD6-4A9B-1EA95F350D51', 'Paid', 746.63, '2019-01-15 05:07:58.000', '54024915-0570-91F4-313B-68F9D7738060', 0,'First','2019-06-11 09:31:44.000'),
('A22C845E-65A3-254E-4C29-D011B6817B5A', 'Paid', 67.6, '2019-03-12 02:59:00.000', 'C6B63E38-78C9-1E72-2913-D0B20DDAC7EF', 0,'Regular','2019-03-12 09:59:33.000'),
('6CFB8590-7864-EBA9-A56F-CC4A57A9A8E8', 'Paid', 130.68, '2019-09-20 09:00:30.000', 'BCC439CD-104B-96C6-F733-C741A922C2A3', 0,'First','2019-09-20 16:01:03.000'),
('C5CAC214-B58B-C0E3-4F2B-FE58C8C25242', 'Paid', 389.15, '2018-09-18 14:00:42.000', '4C83314C-0998-82EF-9F5C-B990654EF3E4', 0,'Regular','2018-09-18 14:00:42.000'),
('9151B659-476C-E833-A44F-F5D84E7E8CD6', 'Paid', 393.28, '2019-07-11 13:21:09.000', '01A3F4BB-E7B3-A7B6-6D9B-7424B4C05F9F', 0,'First','2019-07-11 13:21:09.000'),
('F738FCC2-F131-840C-9C49-1CDE12F6F8D5', 'Paid', 386.78, '2019-06-28 11:09:39.000', '33053B8C-DAF6-201B-0E5A-8E4223CDC082', 0,'First','2019-06-28 11:09:39.000'),
('EEFB6F8F-4600-EFC3-0BD9-A5125DB8B908', 'Paid', 302.01, '2018-04-13 21:47:40.000', '6707B28B-84EA-A11E-1182-776D108AA2F6', 0,'Regular','2018-04-13 21:47:40.000'),
('6E04F3A7-26E6-243C-3DCA-7C547E5A295B', 'Paid', 1240.43, '2019-10-16 11:25:37.000', '5408558D-8D42-8F0C-1AC5-06AFAF545BF0', 0,'First','2019-06-11 09:31:44.000'),
('9EF9F4F5-3363-4FB2-4B8E-B53CEAAF5C4A', 'Paid', 494.07, '2018-09-20 13:29:42.000', '1DD2E8B4-975B-EB83-FE44-58F0BB62BA8B', 0,'Regular','2018-09-20 13:29:42.000'),
('E2A98B01-83DD-2232-3544-1B333C21D41D', 'Paid', 589.28, '2019-08-03 05:25:24.000', '5DF33EED-0C92-D12C-6AB0-EEDA12C3DB84', 0,'First','2019-08-03 05:25:24.000'),
('4395E2D5-2D1D-DD25-F80B-5161BD779DAB', 'Paid', 528.05, '2020-01-04 16:26:24.000', '5557CAA9-0B11-B81C-21D2-C3878742208B', 0,'Regular','2020-01-09 19:28:36.000'),
('442C732D-FCEC-3C5F-3B8E-165C20CE09AB', 'Paid', 686.35, '2019-04-18 04:08:16.000', '0FB9B0B2-E755-48AA-3D02-A88D322EF68C', 0,'Regular','2019-06-11 09:31:44.000'),
('4D20A495-AA7E-205E-9B95-38394B1E0887', 'Paid', 793.11, '2018-11-11 16:48:50.000', '8BEE5C04-0EEC-D701-FC11-CD800A2E5C92', 0,'Regular','2018-11-16 19:51:02.000'),
('45047DBF-1BAA-A545-7808-8C1CDF000514', 'Paid', 988.21, '2018-07-26 04:55:40.000', '982F4644-5F07-F9B4-1C5E-D0D057CCA820', 0,'Regular','2018-07-26 04:55:40.000'),
('EDFED13F-B30E-B2A7-586F-BC29832C7FA3', 'Paid', 1398.43, '2019-05-09 04:31:43.000', '096D6766-35C6-B162-F083-938176EECAB9', 0,'Regular','2019-05-09 04:31:43.000'),
('88365D47-D134-0307-19A0-80B2354516C7', 'Paid', 317.15, '2019-11-29 11:31:13.000', '2F5D0956-C5CF-B36E-AD7C-7AD82E994B4E', 0,'Regular','2019-06-11 09:31:44.000'),
('80E25103-D9BD-84B3-761C-2FAD2E3E0781', 'Paid', 434.17, '2018-07-20 15:32:58.000', '0642F3A2-43D0-912F-8800-BBBA4A1F4B17', 0,'First','2018-07-25 18:35:10.000'),
('74399594-EB0B-6F86-BB3E-3A2E5F6FB72D', 'Paid', 928.88, '2018-11-30 16:27:59.000', 'DD802EF9-0C7E-77DE-D767-B83566478FC8', 0,'Regular','2018-11-30 16:27:59.000'),
('5B461A0C-3AC0-5410-F5EF-EB9C2DCAC0FD', 'Paid', 965.54, '2019-05-13 04:07:48.000', 'BA4251DA-7AF7-E1BD-745E-9B3E1955C99F', 0,'Regular','2019-05-13 04:07:48.000'),
('552FA8DC-E55C-58E9-53F9-A0FAD6FE409B', 'Paid', 503.48, '2019-02-24 19:51:07.000', '84B1CC2D-00A2-0514-5E18-04A033E46D19', 0,'Regular','2019-02-24 19:51:07.000'),
('1BFB4356-AC66-C9F3-A226-3FC191113DC1', 'Paid', 525.72, '2018-12-12 10:32:17.000', 'B4208560-AFCA-307A-0746-02263621E8E8', 0,'First','2018-12-17 13:34:29.000'),
('ACC09D38-E417-0A2A-E2EA-408E6598B8EC', 'Paid', 703.78, '2018-10-08 02:45:33.000', '972FE97A-5C1C-1C77-F9FB-DA770E66EC53', 0,'First','2018-10-08 02:45:33.000'),
('9C507D9A-DB6B-1A6D-DDC6-065AB5C2D956', 'Paid', 686.35, '2019-03-18 04:08:16.000', '0FB9B0B2-E755-48AA-3D02-A88D322EF68C', 0,'Regular','2019-03-18 04:08:16.000'),
('0ED54C2A-9FD3-33E4-9F02-573779810E57', 'Paid', 393.48, '2019-10-01 08:28:10.000', '3D20F34F-8ACB-2A2D-1A84-A1E01366BFC0', 0,'Regular','2019-10-01 08:28:10.000'),
('F77DD123-ECF6-4549-35E0-E814AA834BBD', 'Paid', 101.95, '2019-02-01 00:52:23.000', '12240FF3-B520-6521-9CEE-C7350CDCC5A3', 0,'Regular','2019-02-01 07:52:56.000'),
('85A6C501-0097-E511-BC7D-005056B70024', 'Paid', 131.07, '2015-12-02 16:17:29.000', '8E49213C-0A79-E511-9E6E-005056992328', 0,'First','2015-12-02 16:17:29.000'),
('85A6C501-0097-E511-BC7D-005056B70025', 'Failed', 556.32, '2018-11-12 06:58:59.000', 'E6959ACC-AFDC-6B4A-0D28-12304871C7C6', 0,'First','2018-11-12 06:58:59.000'),
('01AA7B8C-A6AE-E511-BC7D-005056B70024', 'Paid', 131.07, '2016-01-02 16:17:29.000', '8E49213C-0A79-E511-9E6E-005056992328', 0,'Regular','2016-01-02 16:17:29.000'),
('694DD9D5-25C6-E511-BC7D-005056B70024', 'Paid', 131.07, '2016-02-02 16:17:29.000', '8E49213C-0A79-E511-9E6E-005056992328', 0,'Regular','2016-02-02 16:17:29.000'),
('27D430DF-5D99-E511-BC7D-005056B70024', 'Paid', 117.4, '2015-12-05 16:32:30.000', '6B42DB04-7D7C-E511-9E6E-005056992328', 0,'First','2015-12-10 19:34:42.000'),
('CD1203AD-5BAF-E511-BC7D-005056B70024', 'Paid', 117.4, '2016-01-05 16:32:30.000', '6B42DB04-7D7C-E511-9E6E-005056992328', 0,'Regular','2016-01-05 16:32:30.000'),
('7144FF30-13CA-E511-BC7D-005056B70024', 'Paid', 117.4, '2016-02-05 16:32:30.000', '6B42DB04-7D7C-E511-9E6E-005056992328', 0,'Regular','2016-02-05 23:33:03.000'),
('AE6E6F14-0097-E511-BC7D-005056B70024', 'Paid', 96.68, '2015-12-02 17:05:11.000', '5BCC2A59-5F7E-E511-9E6E-005056992328', 0,'First','2015-12-02 17:05:11.000'),
('C09439B1-A6AE-E511-BC7D-005056B70024', 'Failed', 96.68, '2016-01-02 17:05:11.000', '5BCC2A59-5F7E-E511-9E6E-005056992328', 0,'Regular','2016-01-07 20:07:23.000'),
('5C1FAA86-ABB3-E511-BC7D-005056B70024', 'Paid', 96.68, '2016-02-02 17:05:11.000', '5BCC2A59-5F7E-E511-9E6E-005056992328', 0,'Replacement','2016-02-02 17:05:11.000'),
('D0F8CAE1-25C6-E511-BC7D-005056B70024', 'Failed', 96.68, '2016-03-02 17:05:11.000', '5BCC2A59-5F7E-E511-9E6E-005056992328', 0,'Regular','2019-06-11 09:31:44.000'),
('4F780556-57CA-E511-BC7D-005056B70024', 'Paid', 96.68, '2016-04-02 17:05:11.000', '5BCC2A59-5F7E-E511-9E6E-005056992328', 0,'Replacement','2016-04-02 17:05:11.000'),
('024EBAF3-7DB2-E511-BC7D-005056B70024', 'Paid', 219.16, '2016-01-22 17:04:49.000', 'AE45089C-9D99-E511-9E6E-005056992328', 0,'First','2016-01-22 17:04:49.000'),
('BA4C9FA5-5CBA-E511-BC7D-005056B70024', 'Paid', 190.49, '2016-01-17 17:34:22.000', 'C8F73EBA-739A-E511-9E6E-005056992328', 0,'First','2016-01-22 20:36:34.000');
''')
# Save the database
conn.commit()


# Query 1 - total number of loans disbursed between 9th Dec 2015
# and 17th Oct 2017 (both dates included).
print('===========================================================')
print('QUERY REPORT')
print('===========================================================\n')
print('Query - 1')
print('==============')
cur.execute('''
SELECT COUNT(*)
FROM Borrowings
WHERE ((BRW_DisbursalDate >= '2015-12-09 00:00:00.000') AND
(BRW_DisbursalDate <= '2017-10-17 23:59:59.999'))
''')
loan_qry1 = cur.fetchall()
# no_loan = len(loan_qry1)
print('Total number of loans disbursed between 9th Dec 2015 and 17th Oct 2017:',loan_qry1)
print('\n')

# Query 2 - Which year / month had the most loans with state 'Withdrawn'
#  (list top three with highest number of disbursals).
print('Query - 2')
print('==============')
cur.execute('''
SELECT strftime('%Y',BRW_DisbursalDate) AS BRW_Disbursal_Year, COUNT (BRW_DisbursalDate) AS Loan_Withdrawn_Number
FROM Borrowings WHERE (BRW_State = 'Withdrawn') GROUP BY strftime('%Y',BRW_DisbursalDate) ORDER BY BRW_Disbursal_Year DESC LIMIT 3
''')
loan_qry2 = cur.fetchall()
print('Top Years with Highest number of disbursals:\n [YYYY, Number of disbursals]\n',loan_qry2)
print('\n')

# Querr 3 - Check for duplicate records
print('Query - 3')
print('==============')
cur.execute('''
SELECT REP_ID, COUNT(*)
FROM Repayments
Group BY REP_ID
HAVING COUNT(*) >1
''')
loan_qry3 = cur.fetchall()
print('Duplicate Repayment Records:',loan_qry3)
print('\n')

# Query 4 - For each term, return total number of loans that have failed
# repayments.
print('Query - 4')
print('==============')
cur.execute('''
SELECT BRW_Term, REP_State, COUNT(BRW_Term) AS Repayment_Fail_count FROM Borrowings, Repayments
WHERE Borrowings.BRW_ID = Repayments.REP_Borrowing AND REP_State = 'Failed' GROUP BY BRW_Term
''')
loan_qry4 = cur.fetchall()
print('Total number of loans that have failed repayments for each term:\n [BRW_Term, REP_State, Fail Count]\n',loan_qry4)
print('\n')

# Query 5 - Find all loans with state 'Withdrawn' that have no repayments.
print('Query - 5')
print('==============')
cur.execute('''
SELECT BRW_ID, BRW_State, REP_Amount, REP_State
FROM Borrowings, Repayments WHERE Borrowings.BRW_ID = Repayments.REP_Borrowing AND BRW_State = 'Withdrawn' AND REP_State = 'Failed'
''')
loan_qry5 = cur.fetchall()
print('Loans with state Withdrawn that have no repayments:\n [BRW_ID, BRW_State, REP_Amount, REP_State]\n',loan_qry5)
print('\n')

# Query 6 - Return the latest 3 repayment dates for each loan with state
# 'Withdrawn', all three dates should be on a single row.
print('Query - 5')
print('==============')
cur.execute('''
SELECT BRW_ID, group_concat(REP_RepaymentDate) AS Repayment_Dates
FROM Borrowings, Repayments
WHERE Borrowings.BRW_ID = Repayments.REP_Borrowing AND BRW_State = 'Withdrawn'
GROUP BY BRW_ID
ORDER BY group_concat(REP_RepaymentDate) DESC
''')
loan_qry6 = cur.fetchall()
print('Repayment dates for each loan:\n [BRW_ID, Repayment_Dates]\n', loan_qry6)
print('\n')

# Close connection to the db
cur.close()