Project

General

Profile

Tasks #5816 » payment_negbal.csv

PFA the modified document details for future reference - Mohamed Suhail, 04/18/2022 07:31 AM

 
1
created,c_payment_id,payamt,discountamt,paymentavailable
2
2014-12-29 16:18:36,1007393,1482.6400,0,-0.002
3
2015-02-15 10:43:09,1008066,2242.7300,0,-0.005
4
2015-02-15 12:13:02,1008072,3273.3400,0,-0.002
5
2016-04-13 12:18:49,1014026,3463.5000,0,-0.003
6
2017-05-03 16:01:56,1020524,3553.0000,0,-0.004
7
2017-05-17 10:38:42,1020703,13221.0000,0,-0.005
8
2017-08-29 09:22:12,1022517,4046.5800,0,-0.005
9
2017-09-10 10:36:28,1022716,4495.0000,0,-0.003
10
2017-10-22 08:53:38,1023546,5661.9500,0,-0.003
11
2018-01-10 08:10:52,1025382,3697.1000,0,-0.005
12
2018-01-14 10:47:51,1025421,10004.0000,0,-0.005
13
2018-01-28 08:52:03,1025806,6144.0000,0,-0.005
14
2018-01-29 16:26:15,1025866,9935.0000,27.0920,-0.005
15
2018-02-05 15:53:49,1026035,4205.0000,3.1500,-0.005
16
2018-02-11 09:32:46,1026100,5555.0000,0,-0.005
17
2018-03-19 09:59:41,1027024,30.0000,0,-0.005
18
2018-03-20 18:37:02,1027070,990.0000,0,-0.005
19
2018-04-09 11:03:07,1027497,6859.0000,0,-0.005
20
2018-04-17 18:41:01,1027723,320.0000,0.6630,-0.003
21
2018-04-22 12:08:20,1027808,602.0000,0,-0.004
22
2018-05-10 08:27:12,1028381,9395.0000,0,-0.005
23
2018-05-10 09:23:57,1028386,3926.0000,0,-0.002
24
2018-05-15 16:09:06,1028400,2577.5000,0,-0.001
25
2018-05-20 08:30:29,1028463,5175.5900,0,-0.002
26
2018-05-20 08:52:46,1028466,2982.9600,0,-0.002
27
2018-05-21 07:46:21,1028554,500.0000,0.0030,-0.003
28
2018-05-21 10:39:58,1028584,15826.0000,0.1500,-0.005
29
2018-05-30 09:24:23,1028754,4277.2600,0,-0.002
30
2018-06-12 10:13:08,1028928,6865.3000,0,-0.002
31
2018-06-12 10:19:14,1028930,1143.0000,0,-0.005
32
2018-06-19 09:42:21,1028998,2863.8400,0,-0.005
33
2018-06-25 11:07:52,1029067,1838.5500,0,-0.002
34
2018-07-23 10:25:22,1029543,3500.0000,0,-0.005
35
2018-07-29 09:52:18,1029769,11619.7800,0,-0.001
36
2018-07-29 10:46:26,1029772,1724.3000,0,-0.005
37
2018-07-29 18:19:32,1029812,2670.0000,0,-0.005
38
2018-07-30 12:30:31,1029826,300.0000,0,-0.005
39
2018-08-02 10:10:11,1029918,4743.1800,0,-0.003
40
2018-08-04 12:19:12,1029922,2826.1500,0,-0.005
41
2018-08-05 08:58:16,1029925,2035.0000,0,-0.001
42
2018-08-05 09:20:54,1029928,2451.5800,0,-0.003
43
2018-08-06 10:39:28,1029956,3881.4000,0,-0.005
44
2018-08-07 11:42:18,1030016,27949.0000,0,-0.003
45
2018-08-09 09:14:07,1030039,5871.5900,0,-0.005
46
2018-08-12 09:51:43,1030057,4354.6000,0,-0.002
47
2018-08-13 11:00:44,1030076,4443.4700,0,-0.001
48
2018-08-13 11:15:03,1030078,1258.4300,0,-0.004
49
2018-08-13 11:50:29,1030085,5336.0000,0,-0.001
50
2018-08-13 12:18:05,1030092,11384.1540,0,-0.003
51
2018-08-14 10:41:57,1030134,1022.0000,0,-0.004
52
2018-08-16 09:23:33,1030183,4795.8600,0,-0.004
53
2018-08-19 17:35:26,1030275,14690.0000,4.7510,-0.001
54
2018-08-20 11:41:17,1030287,661.7200,0,-0.005
55
2018-08-28 17:32:31,1030386,25286.8700,0,-0.005
56
2018-09-01 16:55:58,1030440,0.0005,0,-0.001
57
2018-09-01 16:58:02,1030441,0.0005,0,-0.001
58
2018-09-04 12:25:58,1030470,13050.0000,0,-0.003
59
2018-09-12 17:55:52,1030662,4470.1000,0,-0.005
60
2018-09-15 09:44:57,1030683,300.0000,0,-0.004
61
2018-09-19 14:06:12,1030819,971.4970,0,-0.003
62
2018-09-20 17:21:30,1030875,1692.6200,0,-0.005
63
2018-09-24 11:58:15,1030894,6139.8700,0,-0.005
64
2018-09-27 14:12:31,1031009,2500.0000,0,-0.005
65
2018-10-03 08:46:31,1031168,270.0000,0,-0.005
66
2018-10-04 11:08:07,1031216,4524.8300,0,-0.005
67
2018-10-08 09:45:35,1031321,100.0000,0,-0.002
68
2018-10-08 12:02:47,1031346,2056.4650,0,-0.003
69
2018-10-08 12:28:45,1031351,2748.1700,0,-0.005
70
2018-10-15 08:10:21,1031460,835.0000,0,-0.005
71
2018-10-20 10:31:08,1031593,515.0000,0,-0.002
72
2018-10-21 10:31:33,1031662,3837.3000,0,-0.005
73
2018-10-24 11:58:55,1031765,2719.0000,0,-0.005
74
2018-10-25 11:22:39,1031780,24100.0000,0,-0.004
75
2018-10-29 15:51:56,1031915,290.0000,0,-0.005
76
2018-10-29 17:43:42,1031927,3000.0000,0,-0.005
77
2018-10-29 18:10:16,1031929,28118.9000,0,-0.002
78
2018-11-03 17:50:27,1032015,5372.1900,0,-0.004
79
2018-11-04 15:50:38,1032073,14915.0000,0,-0.005
80
2018-11-12 11:52:29,1032336,1015.0000,0,-0.005
81
2018-11-12 15:47:38,1032364,200.0000,0,-0.002
82
2018-11-18 09:00:36,1032484,2767.1300,0,-0.003
83
2018-11-19 16:59:43,1032553,1722.5700,0,-0.005
84
2018-11-19 17:03:10,1032554,3312.0500,0,-0.005
85
2018-11-19 17:27:52,1032561,375.0000,3.0000,-0.002
86
2018-11-20 09:16:03,1032602,500.0000,0,-0.005
87
2018-11-20 10:13:12,1032617,2100.0000,0,-0.005
88
2018-11-22 16:25:08,1032658,3344.8170,0,-0.003
89
2018-11-25 10:27:36,1032716,5090.0000,0,-0.005
90
2018-11-25 12:06:30,1032780,765.0000,0,-0.005
91
2018-11-25 12:24:19,1032784,16734.0000,0,-0.003
92
2018-11-25 12:37:14,1032789,600.0000,4.8000,-0.001
93
2018-11-27 09:45:20,1032846,1719.0000,0,-0.005
94
2018-11-29 12:14:18,1032943,5000.0000,0,-0.003
95
2018-11-29 12:28:19,1032945,1573.4200,0,-0.005
96
2018-12-06 09:17:45,1033017,1500.0000,0,-0.005
97
2018-12-06 10:32:58,1033043,970.0000,0,-0.002
98
2018-12-09 10:00:09,1033100,891.5000,0,-0.001
99
2018-12-12 12:13:17,1033239,1687.0000,0,-0.005
100
2018-12-12 13:17:21,1033249,1485.0400,0,-0.004
101
2018-12-12 13:21:02,1033251,5321.0000,0,-0.003
102
2018-12-13 16:16:54,1033307,5020.0000,0,-0.005
103
2018-12-18 16:35:19,1033371,4654.1200,0,-0.005
104
2018-12-19 10:22:08,1033405,150.0000,0,-0.005
105
2018-12-23 08:03:11,1033487,1025.6380,0,-0.002
106
2018-12-23 08:08:41,1033491,800.0000,0,-0.003
107
2018-12-23 12:38:35,1033511,17350.4600,0,-0.003
108
2018-12-31 17:42:51,1033762,7024.5000,0,-0.001
109
2018-12-31 17:57:19,1033769,16117.6000,7.2520,-0.002
110
2019-01-03 15:14:11,1033894,705.0000,2.9750,-0.005
111
2019-01-03 15:18:18,1033898,500.0000,0,-0.005
112
2019-01-07 18:28:59,1034083,3125.0000,0,-0.005
113
2019-01-08 08:51:49,1034109,300.0000,0,-0.005
114
2019-01-08 09:18:18,1034124,485.0000,0,-0.003
115
2019-01-12 16:42:40,1034171,316.9450,0,-0.005
116
2019-01-16 17:48:44,1034262,5993.0000,0,-0.005
117
2019-01-17 16:07:32,1034319,4585.0000,1.4000,-0.002
118
2019-01-26 15:43:09,1034466,20.0000,0,-0.002
119
2019-01-27 08:28:17,1034479,4563.0900,0,-0.002
120
2019-01-29 11:14:59,1034686,1500.0000,0,-0.005
121
2019-01-31 16:29:04,1034698,2873.6100,0,-0.002
122
2019-02-03 12:12:46,1034758,1530.0000,4.0500,-0.001
123
2019-02-03 12:16:35,1034763,815.0000,0,-0.005
124
2019-02-03 15:39:41,1034783,30.0000,0,-0.005
125
2019-02-03 18:07:34,1034812,830.0000,0.0250,-0.004
126
2019-02-07 15:41:53,1034926,1585.0000,0,-0.005
127
2019-02-09 17:12:37,1034996,3350.0000,178.0000,-0.001
128
2019-02-11 10:03:14,1035042,1724.2700,0,-0.001
129
2019-02-12 10:42:21,1035053,5053.0800,0,-0.002
130
2019-02-12 10:49:47,1035054,1144.5400,0,-0.003
131
2019-02-18 15:40:23,1035287,4584.9900,0,-0.005
132
2019-02-19 09:09:33,1035294,3837.5000,0,-0.005
133
2019-02-20 17:04:38,1035339,7485.4500,0,-0.001
134
2019-02-24 10:10:55,1035471,2387.6500,0,-0.002
135
2019-02-26 11:34:22,1035528,4472.7380,0,-0.003
136
2019-02-26 16:13:12,1035562,8407.0000,0.8750,-0.005
137
2019-02-26 17:26:25,1035588,6310.1270,0,-0.002
138
2019-02-26 17:31:22,1035589,8809.9400,0,-0.002
139
2019-03-03 15:56:12,1035707,3265.0000,0,-0.005
140
2019-03-04 17:39:46,1035712,7400.0000,0,-0.005
141
2019-03-06 15:39:07,1035802,815.0000,0,-0.005
142
2019-03-06 16:00:15,1035817,435.0000,0,-0.005
143
2019-03-10 09:31:30,1035860,1210.0000,0,-0.005
144
2019-03-10 15:51:45,1035905,22300.0000,0,-0.004
145
2019-03-12 12:29:45,1035959,6012.9200,0,-0.005
146
2019-03-12 12:54:59,1035966,3643.3500,0,-0.004
147
2019-03-16 08:42:30,1035987,23000.0000,0,-0.002
148
2019-03-17 16:09:19,1036075,3000.0000,0,-0.005
149
2019-03-18 15:27:06,1036164,69333.9000,0,-0.005
150
2019-03-18 16:03:21,1036175,2242.9880,0,-0.001
151
2019-03-19 12:49:08,1036198,996.9750,0,-0.005
152
2019-03-20 09:04:09,1036208,540.0000,0.4900,-0.002
153
2019-03-20 11:52:52,1036223,21649.0000,0.9520,-0.002
154
2019-03-21 08:46:00,1036302,1400.7200,0,-0.004
155
2019-03-25 11:38:51,1036417,2800.0000,0,-0.005
156
2019-03-31 09:16:10,1036569,37945.8600,0,-0.004
157
2019-04-01 16:38:21,1036618,1750.0000,0,-0.005
158
2019-04-02 09:16:36,1036622,5226.5800,0,-0.003
159
2019-04-10 11:50:07,1036836,1055.0600,0,-0.001
160
2019-04-10 12:54:08,1036861,1000.0000,0,-0.003
161
2019-04-10 15:06:08,1036862,1000.6700,0,-0.004
162
2019-04-14 11:58:28,1036928,86686.0600,0,-0.005
163
2019-04-21 16:22:15,1037130,52500.0000,26.5130,-0.002
164
2019-04-29 15:54:15,1037349,500.0000,0,-0.005
165
2019-04-30 11:04:19,1037468,2320.0000,0,-0.005
166
2019-05-09 13:19:16,1037685,1984.1850,0,-0.001
167
2019-05-23 10:38:06,1037978,19693.2800,0,-0.005
168
2019-05-23 10:47:38,1037984,94996.5400,0,-0.005
169
2019-05-23 12:37:20,1037989,14582.0000,0,-0.005
170
2019-05-26 13:51:43,1038026,2410.0000,0,-0.003
171
2019-06-01 16:02:06,1038123,20760.0000,0,-0.003
172
2019-06-02 15:59:31,1038146,7574.7000,0,-0.005
173
2019-06-03 13:42:00,1038190,870.0000,0,-0.005
174
2019-06-09 14:55:07,1038248,43500.0000,0,-0.002
175
2019-06-09 14:57:50,1038249,60800.0000,0,-0.005
176
2019-06-13 08:52:51,1038280,10315.0000,0,-0.004
177
2019-06-16 16:15:33,1038309,640.2300,0,-0.003
178
2019-06-18 17:55:08,1038382,3751.2250,0,-0.005
179
2019-06-19 07:59:32,1038420,811.0000,0,-0.003
180
2019-06-22 10:30:25,1038465,29000.0000,0,-0.005
181
2019-06-27 12:03:09,1038535,2528.8200,0,-0.003
182
2019-06-27 12:14:45,1038539,24350.6660,0,-0.004
183
2019-06-27 12:46:12,1038553,2970.0000,0,-0.005
184
2019-06-30 11:16:11,1038614,38000.0000,0,-0.005
185
2019-07-01 09:39:33,1038688,18890.0000,0,-0.002
186
2019-07-09 08:38:33,1038878,1008.2200,0,-0.001
187
2019-07-10 08:38:32,1038896,695.0000,0,-0.005
188
2019-07-14 12:02:14,1038936,1269.0000,0,-0.005
189
2019-07-20 10:39:01,1038957,900.0000,0,-0.005
190
2019-07-20 10:54:57,1038964,1256.0000,0,-0.002
191
2019-07-21 18:16:34,1039019,6250.0000,0,-0.001
192
2019-07-22 10:58:19,1039042,6309.0000,0,-0.005
193
2019-07-29 16:08:35,1039142,11850.0000,0,-0.005
194
2019-07-29 16:32:28,1039150,27308.6950,0,-0.003
195
2019-08-01 15:55:56,1039226,5.0000,0,-0.005
196
2019-08-03 12:55:42,1039272,21000.0000,0,-0.001
197
2019-08-05 12:46:57,1039346,995.0200,0,-0.001
198
2019-08-07 08:48:10,1039416,12400.0000,0,-0.005
199
2019-08-07 16:32:36,1039457,2197.6480,0,-0.002
200
2019-08-22 14:36:36,1039685,983.0500,0,-0.003
201
2019-08-26 08:14:13,1039696,58049.6600,1795.3450,-0.002
202
2019-09-03 11:51:31,1039816,4572.0000,0,-0.002
203
2019-09-16 08:16:59,1040197,708.7470,0,-0.003
204
2019-09-23 09:07:02,1040352,9417.7100,0,-0.003
205
2019-10-19 19:05:04,1048091,7514.97,0.000,-0.005
206
2019-10-21 16:43:13,1048126,7484.14,0.000,-0.004
207
2019-10-22 17:26:40,1048145,519.487,0.000,-0.003
208
2019-10-24 18:22:48,1048207,2425,0.000,-0.005
209
2019-10-24 18:24:38,1048208,1000,0.000,-0.005
210
2019-10-26 09:50:31,1048294,3046.62,0.000,-0.002
211
2022-04-14 12:14:41,1062972,1340.2305,0.000,-0.001
212
2022-04-14 12:16:12,1062973,1234.0125,0.000,-0.001
(5-5/5)