-
Notifications
You must be signed in to change notification settings - Fork 6
/
defaultCoaD4.sql
547 lines (533 loc) · 183 KB
/
defaultCoaD4.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (34, 'Penalty to AXIS 2', NULL, '.', '33', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (33, 'Penalty to AXIS 1', NULL, '.', '32', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (32, 'Fees to SBI 2', NULL, '.', '31', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (31, 'Fees to SBI 1', NULL, '.', '30', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (30, 'From Canara', NULL, '.', '29', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (29, 'From HDFC', NULL, '.', '28', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (28, 'Overdraft Interest Income', NULL, '.', '27', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (27, 'Savings income from penalties', NULL, '.', '26', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (26, 'Savings Income from fees', NULL, '.', '25', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (25, 'Savings Writeoff', NULL, '.', '24', 0, 1, 1, 5, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (24, 'Interest On Savings', NULL, '.', '23', 0, 1, 1, 5, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (23, 'Savings Transfer in Suspence', NULL, '.', '22', 0, 1, 1, 2, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (22, 'Saving Control', NULL, '.', '21', 0, 1, 1, 2, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (21, 'Overdraft Portfolio', NULL, '.', '20', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (20, 'Savings Reference', NULL, '.', '19', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (19, '3 Penalty', NULL, '.', '18', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (18, '2 Penalty', NULL, '.', '17', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (17, '1 penalty', NULL, '.', '16', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (16, '3 income', NULL, '.', '15', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (15, '2 Income', NULL, '.', '14', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (14, '1 Income', NULL, '.', '13', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (13, 'Overpayment Liability', NULL, '.', '12', 0, 1, 1, 2, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (12, 'Losses Writtenoff', NULL, '.', '11', 0, 1, 1, 5, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (11, 'Income from recovery repayments', NULL, '.', '10', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (10, 'Income from penalties', NULL, '.', '9', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (8, 'Income from fees', NULL, '.', '8', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (7, 'Income from interest', NULL, '.', '7', 0, 1, 1, 4, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (6, 'Transfer in Suspence', NULL, '.', '6', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (5, 'Penalties Receivable', NULL, '.', '5', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (4, 'Fees Receivable', NULL, '.', '4', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (3, 'Interest Receivable', NULL, '.', '3', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (2, 'Loan portfolio', NULL, '.', '2', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (1, 'Cash', NULL, '.', '1', 0, 1, 1, 1, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (29, 'TrancheDisbursementCharge-%Disbursementamount', 'USD', 1, 12, 5, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (30, 'TrancheDisbursementCharge-%Interest', 'USD', 1, 12, 4, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (31, 'TrancheDisbursementCharge-%LoanAmount+Interest', 'USD', 1, 12, 3, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (32, 'TrancheDisbursementCharge-%ApprovedAmount', 'USD', 1, 12, 2, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (33, 'TrancheDisbursementCharge-Flat', 'USD', 1, 12, 1, 0, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (34, 'OveerdueFees-%Disbursement amount', 'USD', 1, 9, 5, 0, 1.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (35, 'Installmentfees-%Disbursementamount', 'USD', 1, 8, 5, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (36, 'Specifieddudatefees-%Disbursementamount', 'USD', 1, 2, 5, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (37, 'DisbursementFees-%Disbursementamount', 'USD', 1, 1, 5, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (38, 'OverdueFees-%Interest', 'USD', 1, 9, 4, 0, 1.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (39, 'OveerdueFees-%LoanAmount+Interest', 'USD', 1, 9, 3, 0, 1.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (40, 'OverdueFees-%ApprovedAmount', 'USD', 1, 9, 2, 0, 1.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (41, 'OverdueFees-Flat', 'USD', 1, 9, 1, 0, 100.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (42, 'InstallmentFees-%Interest', 'USD', 1, 8, 4, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (43, 'InstallmentFees-%LoanAmount+Interest', 'USD', 1, 8, 3, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (44, 'InstallmentFees-%ApprovedAmount', 'USD', 1, 8, 2, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (45, 'InstallmentFees-Flat', 'USD', 1, 8, 1, 0, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (46, 'SpecifiedDueDateFees-%Interest', 'USD', 1, 2, 4, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (47, 'SpecifiedDueDateFees-%LoanAmount+Interest', 'USD', 1, 2, 3, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (48, 'SpecifiedDueDateFees-%Approved Amount', 'USD', 1, 2, 2, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (49, 'SpecifiedDueDateFees-Flat', 'USD', 1, 2, 1, 0, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (50, 'DisbursementFees-%Interest', 'USD', 1, 1, 4, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (51, 'DisbursementFees-%LoanAmount+Interest', 'USD', 1, 1, 3, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (52, 'DisbursementFees-%ApprovedAmount', 'USD', 1, 1, 2, 0, 1.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (53, 'DisbursementFees-Flat', 'USD', 1, 1, 1, 0, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (54, 'OVEERDUE Fees-2', 'USD', 1, 9, 1, 0, 100.000000, NULL, 1, NULL, 1, 1, 0, NULL, NULL, 0, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (55, 'SpecifiedDueDatePenalty-Flat', 'USD', 1, 2, 1, 0, 100.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (56, 'OverdueFees-Penalty-Flat', 'USD', 1, 9, 1, 0, 100.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (57, 'InstallmentFees-Penalty-Flat', 'USD', 1, 8, 1, 0, 100.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`) VALUES (58, 'OverdueFees-Penalty-Flat-fre-1', 'USD', 1, 9, 1, 0, 100.000000, NULL, 1, NULL, 1, 1, 0, NULL, NULL, 0, NULL);
INSERT INTO `m_payment_type` (`id`, `value`, `description`, `is_cash_payment`, `order_position`) VALUES (1, 'Wire transfer', '1', 0, 1);
INSERT INTO `m_payment_type` (`id`, `value`, `description`, `is_cash_payment`, `order_position`) VALUES (2, 'Cheque', '2', 0, 2);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`, `tax_group_id`) VALUES (59, 'Client charge-specified due date', 'USD', 3, 2, 1, 0, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, 8, NULL);
INSERT INTO `m_charge` (`id`, `name`, `currency_code`, `charge_applies_to_enum`, `charge_time_enum`, `charge_calculation_enum`, `charge_payment_mode_enum`, `amount`, `fee_on_day`, `fee_interval`, `fee_on_month`, `is_penalty`, `is_active`, `is_deleted`, `min_cap`, `max_cap`, `fee_frequency`, `income_or_liability_account_id`, `tax_group_id`) VALUES (60, 'Client charge-specified due date-Penalty', 'USD', 3, 2, 1, 0, 100.000000, NULL, NULL, NULL, 1, 1, 0, NULL, NULL, NULL, 11, NULL);
INSERT INTO `m_floating_rates` (`id`, `name`, `is_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (1, 'Base Lending Rate', b'1', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates` (`id`, `name`, `is_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (2, 'Differential Lending Rate', b'0', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (1, 1, '2015-04-01 00:00:00', 4.000000, b'0', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (2, 1, '2015-03-01 00:00:00', 3.000000, b'0', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (3, 1, '2015-02-01 00:00:00', 2.000000, b'0', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (4, 1, '2015-01-01 00:00:00', 1.000000, b'0', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (5, 2, '2015-04-01 00:00:00', 4.000000, b'1', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (6, 2, '2015-03-01 00:00:00', 3.000000, b'1', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (7, 2, '2015-02-01 00:00:00', 2.000000, b'1', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_floating_rates_periods` (`id`, `floating_rates_id`, `from_date`, `interest_rate`, `is_differential_to_base_lending_rate`, `is_active`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`) VALUES (8, 2, '2015-01-01 00:00:00', 1.000000, b'1', b'1', 1, '2015-02-05 00:00:00', 1, '2015-02-05 00:00:00');
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (17, 'General', '1', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (17, 'Special', '2', 2, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (16, 'Married', '3', 3, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (16, 'Un Married', '4', 4, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (4, 'Male', '5', 5, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (4, 'Female', '6', 6, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (14, 'Out of MFI', '7', 7, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (14, 'Inactive', '8', 8, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (19, 'Invalid applicant', '9', 9, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (19, 'Out of Branch', '10', 10, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (20, 'Non Performing MFI', '11', 11, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (20, 'Not interested to Join', '12', 12, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (22, 'Inactive Center', '1', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (22, 'Moved Center', '2', 2, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (24, 'Bangalore', '1', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (24, 'Mysore', '1', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (15, 'No Clients under this Group', '1', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (15, 'Group desolved', '2', 2, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (25, 'IT Industry', '1', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (25, 'Non IT', '2', 2, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (5, 'Yes', '1', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (5, 'No', '1', 1, NULL, 1);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (35, 1, 1, 'Wilson', 'Nail', 'Nail, Wilson', NULL, NULL, NULL, NULL, 1, NULL, NULL);
INSERT INTO `m_office` (`id`, `parent_id`, `hierarchy`, `external_id`, `name`, `opening_date`) VALUES (2, 1, '.2.', NULL, 'Branch Office', '2014-04-01');
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (36, 1, 2, 'Joseph', 'D', 'D, Joseph', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (37, 1, 1, 'Staff', '1', '1, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (38, 1, 1, 'Staff', '4524', '4524, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (39, 1, 1, 'Staff', '4526', '4526, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (40, 1, 1, 'Staff', '4526a', '4526a, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (41, 1, 1, 'Staff', '4527', '4527, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (42, 1, 1, 'Staff', '4528', '4528, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (43, 1, 1, 'Staff', '4529', '4529, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (44, 1, 1, 'Staff', '4530', '4530, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (45, 1, 1, 'Staff', '4531', '4531, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (46, 1, 1, 'Staff', '4532', '4532, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (47, 1, 1, 'Staff', '4534', '4534, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (48, 1, 1, 'Staff', '4536', '4536, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (49, 1, 1, 'Staff', '4537', '4537, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (50, 1, 1, 'Staff', '4538', '4538, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (51, 1, 1, 'Staff', '4539', '4539, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (52, 1, 1, 'Staff', '4540', '4540, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (53, 1, 1, 'Staff', '4541', '4541, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (54, 1, 1, 'Staff', '4542', '4542, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (55, 1, 1, 'Staff', '4543', '4543, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (56, 1, 1, 'Staff', '4544', '4544, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (57, 1, 1, 'Staff', '4549', '4549, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (58, 1, 1, 'Staff', '4551', '4551, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (59, 1, 1, 'Staff', '4551a', '4551a, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (60, 1, 1, 'Staff', '4552', '4552, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (61, 1, 1, 'Staff', '4553', '4553, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (62, 1, 1, 'Staff', '4554', '4554, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (63, 1, 1, 'Staff', '4555', '4555, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (64, 1, 1, 'Staff', '4556', '4556, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (65, 1, 1, 'Staff', '4557', '4557, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (66, 1, 1, 'Staff', '4559', '4559, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (67, 1, 1, 'Staff', '4561', '4561, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (68, 1, 1, 'Staff', '4562', '4562, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (69, 1, 1, 'Staff', '4563', '4563, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (70, 1, 1, 'Staff', '4564', '4564, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (71, 1, 1, 'Staff', '4565', '4565, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (72, 1, 1, 'Staff', '4566', '4566, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (73, 1, 1, 'Staff', '4567', '4567, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (74, 1, 1, 'Staff', '4568', '4568, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (75, 1, 1, 'Staff', '4569', '4569, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (76, 1, 1, 'Staff', '4570', '4570, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (77, 1, 1, 'Staff', '4571', '4571, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (78, 1, 1, 'Staff', '4572', '4572, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (79, 1, 1, 'Staff', '4573', '4573, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (80, 1, 1, 'Staff', '4574', '4574, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (81, 1, 1, 'Staff', '4575', '4575, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (82, 1, 1, 'Staff', '4576', '4576, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (83, 1, 1, 'Staff', '4577', '4577, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (84, 1, 1, 'Staff', '4578', '4578, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (85, 1, 1, 'Staff', '4579', '4579, Staff', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (86, 1, 1, 'collectionSheet', '4480', '4480, collectionSheet', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (87, 1, 1, 'collectionSheet', '4481', '4481, collectionSheet', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_staff` (`id`, `is_loan_officer`, `office_id`, `firstname`, `lastname`, `display_name`, `mobile_no`, `external_id`, `organisational_role_enum`, `organisational_role_parent_staff_id`, `is_active`, `joining_date`, `image_id`) VALUES (88, 1, 1, 'collectionSheet', '4482', '4482, collectionSheet', NULL, NULL, NULL, NULL, 1, '2015-01-01', NULL);
INSERT INTO `m_savings_product` (`id`, `name`, `short_name`, `description`, `deposit_type_enum`, `currency_code`, `currency_digits`, `currency_multiplesof`, `nominal_annual_interest_rate`, `interest_compounding_period_enum`, `interest_posting_period_enum`, `interest_calculation_type_enum`, `interest_calculation_days_in_year_type_enum`, `min_required_opening_balance`, `lockin_period_frequency`, `lockin_period_frequency_enum`, `accounting_type`, `withdrawal_fee_amount`, `withdrawal_fee_type_enum`, `withdrawal_fee_for_transfer`, `allow_overdraft`, `overdraft_limit`, `nominal_annual_interest_rate_overdraft`, `min_overdraft_for_interest_calculation`, `min_required_balance`, `enforce_min_required_balance`, `min_balance_for_interest_calculation`, `withhold_tax`, `tax_group_id`, `is_dormancy_tracking_active`, `days_to_inactive`, `days_to_dormancy`, `days_to_escheat`) VALUES (1, 'Simple Savings', 'SS', 'SS', 100, 'USD', 2, 100, 8.000000, 1, 4, 1, 365, NULL, NULL, NULL, 1, NULL, NULL, 0, 0, 0.000000, 0.000000, 0.000000, 0.000000, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `acc_gl_financial_activity_account` (`id`, `gl_account_id`, `financial_activity_type`) VALUES (1, 1, 103);
update c_configuration set enabled = 1 WHERE name = 'reschedule-repayments-on-holidays';
INSERT INTO `m_holiday` (`id`, `name`, `from_date`, `to_date`, `repayments_rescheduled_to`, `status_enum`, `processed`, `description`) VALUES (1, '15 January 2013', '2013-01-15 00:00:00', '2013-01-15 00:00:00', '2013-01-20 00:00:00', 300, 0, '');
INSERT INTO `m_holiday_office` (`holiday_id`, `office_id`) VALUES (1, 1);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (1, '2525', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2525-MS-EPP-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-1-DATE-VAR-INST', '2525', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, NULL, 0, 0, NULL, NULL, 1, 1, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (2, '2530', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2530-MS-EPP-DB-DL-REC-NOCOM-RNI-CTPD-SAR-MD-TR-1-DATE-VAR-INST', '2530', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, NULL, 0, 0, NULL, NULL, 1, 1, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (3, '2535', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2535-MS-EPP-DB-SAR-REC-NOCOM-RNI-CTPD-DL-MD-TR-1-DATE-VAR-INST', '2535', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 1, 1, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, NULL, 0, 0, NULL, NULL, 1, 1, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (4, '2540', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2540-MS-EPP-DB-SAR-REC-NOCOM-RNI-CTPD-SAR-MD-TR-1-DATE-VAR-INST', '2540', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 1, 1, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, NULL, 0, 0, NULL, NULL, 1, 1, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (5, '2545', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2545-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-NONE', '2545', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (6, '2550', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2550-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-SAR-MD-TR-2-DATE-VAR-INST-CASH', '2550', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (7, '2555', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2555-MS-EI-DB-SAR-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-PERIODIC', '2555', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 1, 1, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (8, '2560', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2560-MS-EI-DB-SAR-REC-NOCOM-RNI-CTPD-SAR-MD-TR-2-DATE-VAR-INST-UPFRONT', '2560', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 1, 1, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 4, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (9, '2565', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2565-MS-EPP-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-NONE', '2565', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (10, '2570', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2570-MS-EPP-DB-DL-REC-NOCOM-RNI-CTPD-SAR-MD-TR-2-DATE-VAR-INST-CASH', '2570', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (11, '2575', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2575-MS-EPP-DB-SAR-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-PERIODIC', '2575', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 1, 1, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (12, '2580', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2580-MS-EPP-DB-SAR-REC-NOCOM-RNI-CTPD-SAR-MD-TR-2-DATE-VAR-INST-UPFRONT', '2580', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 1, 1, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 0, 4, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (13, '2585', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2585-RBI-EI-DB-DL-REC-NON-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-MIS', '2585', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (14, '2587', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2587-RBI-EI-DB-DL-REC-NON-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-DISBURSE-FEE-FLAT', '2587', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (15, '2589', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2589-RBI-EI-DB-DL-REC-NON-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-FEE-%INT-MORE-AMT', '2589', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (16, '2590', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2590-RBI-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-OVERDUE-FEE-%INT-LESS-AMT', '2590', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (17, '2595', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2595-RBI-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-DISBURSE-FEE-%INT', '2595', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (18, '2596', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2596-RBI-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-OVERDUE-FEE-%LOANAMT+INT-MORE-AMT', '2596', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (19, '2597', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2597-RBI-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-AMT-VAR-INST-FIX-INST-AMT-MORE', '2597', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 1, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (20, '2601', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2601-RBI-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-VALIDATE-RANGE', '2601', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (21, '2609', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2609-RBI-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-ADD-VAR-INST-OVERDUE-FEE-FLAT', '2609', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 4, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (22, '2615', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2615-MS-EI-DB-DL-REC-NON-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-MIS', '2615', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (23, '2617', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2617-MS-EI-DB-DL-REC-NON-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-DISBURSE-FEE-FLAT', '2617', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (24, '2619', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2619-MS-EI-DB-DL-REC-NON-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-FEE-%INT-MORE-AMT', '2619', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (25, '2620', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2620-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-OVERDUE-FEE-%INT-LESS-AMT', '2620', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (26, '2625', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2625-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-DISBURSE-FEE-%INT', '2625', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (27, '2626', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2626-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-OVERDUE-FEE-%LOANAMT+INT-MORE-AMT', '2626', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (28, '2627', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2627-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-AMT-VAR-INST-FIX-INST-AMT-MORE', '2627', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 1, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (29, '2631', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2631-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-DATE-VAR-INST-VALIDATE-RANGE', '2631', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan` (`id`, `short_name`, `currency_code`, `currency_digits`, `currency_multiplesof`, `principal_amount`, `min_principal_amount`, `max_principal_amount`, `arrearstolerance_amount`, `name`, `description`, `fund_id`, `is_linked_to_floating_interest_rates`, `allow_variabe_installments`, `nominal_interest_rate_per_period`, `min_nominal_interest_rate_per_period`, `max_nominal_interest_rate_per_period`, `interest_period_frequency_enum`, `annual_nominal_interest_rate`, `interest_method_enum`, `interest_calculated_in_period_enum`, `allow_partial_period_interest_calcualtion`, `repay_every`, `repayment_period_frequency_enum`, `number_of_repayments`, `min_number_of_repayments`, `max_number_of_repayments`, `grace_on_principal_periods`, `recurring_moratorium_principal_periods`, `grace_on_interest_periods`, `grace_interest_free_periods`, `amortization_method_enum`, `accounting_type`, `loan_transaction_strategy_id`, `external_id`, `include_in_borrower_cycle`, `use_borrower_cycle`, `start_date`, `close_date`, `allow_multiple_disbursals`, `max_disbursals`, `max_outstanding_loan_balance`, `grace_on_arrears_ageing`, `overdue_days_for_npa`, `days_in_month_enum`, `days_in_year_enum`, `interest_recalculation_enabled`, `min_days_between_disbursal_and_first_repayment`, `hold_guarantee_funds`, `principal_threshold_for_last_installment`, `account_moves_out_of_npa_only_on_arrears_completion`, `can_define_fixed_emi_amount`, `instalment_amount_in_multiples_of`, `can_use_for_topup`, `sync_expected_with_disbursement_date`) VALUES (30, '2639', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '2639-MS-EI-DB-DL-REC-NOCOM-RNI-CTPD-DL-MD-TR-2-ADD-VAR-INST-OVERDUE-FEE-FLAT', '2639', NULL, b'0', b'1', 1.000000, NULL, NULL, 2, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, 0, 0, NULL, NULL, 1, 2, 10000.000000, NULL, NULL, 1, 1, 1, NULL, 0, 50.00, 0, 0, NULL, 0, 0);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (16, 38);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (18, 39);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (21, 41);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (23, 53);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (24, 42);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (25, 38);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (27, 39);
INSERT INTO `m_product_loan_charge` (`product_loan_id`, `charge_id`) VALUES (30, 41);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (1, 1, 6, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (2, 2, 6, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (3, 6, 6, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (4, 7, 6, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (5, 8, 6, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (6, 10, 6, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (7, 11, 6, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (8, 12, 6, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (9, 13, 6, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (10, 1, 7, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (11, 2, 7, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (12, 6, 7, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (13, 3, 7, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (14, 4, 7, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (15, 5, 7, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (16, 7, 7, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (17, 8, 7, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (18, 10, 7, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (19, 11, 7, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (20, 12, 7, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (21, 13, 7, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (22, 1, 8, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (23, 2, 8, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (24, 6, 8, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (25, 3, 8, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (26, 4, 8, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (27, 5, 8, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (28, 7, 8, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (29, 8, 8, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (30, 10, 8, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (31, 11, 8, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (32, 12, 8, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (33, 13, 8, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (34, 1, 10, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (35, 2, 10, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (36, 6, 10, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (37, 7, 10, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (38, 8, 10, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (39, 10, 10, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (40, 11, 10, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (41, 12, 10, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (42, 13, 10, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (43, 1, 11, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (44, 2, 11, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (45, 6, 11, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (46, 3, 11, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (47, 4, 11, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (48, 5, 11, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (49, 7, 11, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (50, 8, 11, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (51, 10, 11, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (52, 11, 11, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (53, 12, 11, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (54, 13, 11, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (55, 1, 12, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (56, 2, 12, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (57, 6, 12, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (58, 3, 12, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (59, 4, 12, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (60, 5, 12, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (61, 7, 12, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (62, 8, 12, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (63, 10, 12, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (64, 11, 12, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (65, 12, 12, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (66, 13, 12, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (67, 1, 13, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (68, 2, 13, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (69, 6, 13, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (70, 3, 13, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (71, 4, 13, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (72, 5, 13, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (73, 7, 13, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (74, 8, 13, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (75, 10, 13, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (76, 11, 13, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (77, 12, 13, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (78, 13, 13, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (79, 1, 15, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (80, 2, 15, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (81, 6, 15, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (82, 3, 15, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (83, 4, 15, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (84, 5, 15, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (85, 7, 15, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (86, 8, 15, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (87, 10, 15, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (88, 11, 15, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (89, 12, 15, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (90, 13, 15, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (91, 1, 16, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (92, 2, 16, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (93, 6, 16, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (94, 3, 16, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (95, 4, 16, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (96, 5, 16, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (97, 7, 16, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (98, 8, 16, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (99, 10, 16, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (100, 11, 16, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (101, 12, 16, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (102, 13, 16, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (103, 1, 17, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (104, 2, 17, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (105, 6, 17, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (106, 3, 17, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (107, 4, 17, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (108, 5, 17, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (109, 7, 17, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (110, 8, 17, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (111, 10, 17, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (112, 11, 17, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (113, 12, 17, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (114, 13, 17, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (115, 1, 18, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (116, 2, 18, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (117, 6, 18, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (118, 3, 18, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (119, 4, 18, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (120, 5, 18, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (121, 7, 18, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (122, 8, 18, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (123, 10, 18, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (124, 11, 18, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (125, 12, 18, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (126, 13, 18, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (127, 1, 19, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (128, 2, 19, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (129, 6, 19, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (130, 3, 19, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (131, 4, 19, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (132, 5, 19, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (133, 7, 19, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (134, 8, 19, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (135, 10, 19, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (136, 11, 19, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (137, 12, 19, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (138, 13, 19, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (139, 1, 20, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (140, 2, 20, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (141, 6, 20, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (142, 3, 20, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (143, 4, 20, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (144, 5, 20, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (145, 7, 20, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (146, 8, 20, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (147, 10, 20, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (148, 11, 20, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (149, 12, 20, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (150, 13, 20, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (151, 1, 21, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (152, 2, 21, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (153, 6, 21, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (154, 3, 21, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (155, 4, 21, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (156, 5, 21, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (157, 7, 21, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (158, 8, 21, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (159, 10, 21, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (160, 11, 21, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (161, 12, 21, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (162, 13, 21, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (163, 1, 22, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (164, 2, 22, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (165, 6, 22, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (166, 3, 22, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (167, 4, 22, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (168, 5, 22, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (169, 7, 22, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (170, 8, 22, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (171, 10, 22, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (172, 11, 22, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (173, 12, 22, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (174, 13, 22, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (175, 1, 24, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (176, 2, 24, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (177, 6, 24, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (178, 3, 24, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (179, 4, 24, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (180, 5, 24, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (181, 7, 24, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (182, 8, 24, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (183, 10, 24, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (184, 11, 24, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (185, 12, 24, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (186, 13, 24, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (187, 1, 25, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (188, 2, 25, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (189, 6, 25, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (190, 3, 25, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (191, 4, 25, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (192, 5, 25, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (193, 7, 25, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (194, 8, 25, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (195, 10, 25, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (196, 11, 25, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (197, 12, 25, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (198, 13, 25, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (199, 1, 26, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (200, 2, 26, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (201, 6, 26, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (202, 3, 26, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (203, 4, 26, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (204, 5, 26, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (205, 7, 26, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (206, 8, 26, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (207, 10, 26, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (208, 11, 26, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (209, 12, 26, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (210, 13, 26, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (211, 1, 27, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (212, 2, 27, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (213, 6, 27, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (214, 3, 27, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (215, 4, 27, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (216, 5, 27, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (217, 7, 27, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (218, 8, 27, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (219, 10, 27, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (220, 11, 27, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (221, 12, 27, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (222, 13, 27, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (223, 1, 28, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (224, 2, 28, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (225, 6, 28, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (226, 3, 28, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (227, 4, 28, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (228, 5, 28, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (229, 7, 28, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (230, 8, 28, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (231, 10, 28, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (232, 11, 28, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (233, 12, 28, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (234, 13, 28, 1, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (235, 1, 30, 1, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (236, 2, 30, 1, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (237, 6, 30, 1, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (238, 3, 30, 1, NULL, NULL, 7);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (239, 4, 30, 1, NULL, NULL, 8);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (240, 5, 30, 1, NULL, NULL, 9);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (241, 7, 30, 1, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (242, 8, 30, 1, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (243, 10, 30, 1, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (244, 11, 30, 1, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (245, 12, 30, 1, NULL, NULL, 6);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (246, 13, 30, 1, NULL, NULL, 11);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (2, 2, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (3, 3, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (4, 4, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (5, 5, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (6, 6, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (7, 7, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (8, 8, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (9, 9, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (10, 10, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (11, 11, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (12, 12, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (13, 13, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (14, 14, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (15, 15, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (16, 16, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (17, 17, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (18, 18, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (19, 19, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (20, 20, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (21, 21, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (22, 22, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (23, 23, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (24, 24, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (25, 25, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (26, 26, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (27, 27, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (28, 28, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (29, 29, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_configurable_attributes` (`id`, `loan_product_id`, `amortization_method_enum`, `interest_method_enum`, `loan_transaction_strategy_id`, `interest_calculated_in_period_enum`, `arrearstolerance_amount`, `repay_every`, `moratorium`, `grace_on_arrears_ageing`) VALUES (30, 30, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (1, 1, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (2, 2, 0, 2, 1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (3, 3, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (4, 4, 0, 2, 1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (5, 5, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (6, 6, 0, 2, 1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (7, 7, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (8, 8, 0, 2, 1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (9, 9, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (10, 10, 0, 2, 1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (11, 11, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (12, 12, 0, 2, 1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (13, 13, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (14, 14, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (15, 15, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (16, 16, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (17, 17, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (18, 18, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (19, 19, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (20, 20, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (21, 21, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (22, 22, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (23, 23, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (24, 24, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (25, 25, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (26, 26, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (27, 27, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (28, 28, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (29, 29, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_recalculation_details` (`id`, `product_id`, `compound_type_enum`, `reschedule_strategy_enum`, `rest_frequency_type_enum`, `rest_frequency_interval`, `arrears_based_on_original_schedule`, `pre_close_interest_calculation_strategy`, `compounding_frequency_type_enum`, `compounding_frequency_interval`, `rest_frequency_nth_day_enum`, `rest_frequency_on_day`, `rest_frequency_weekday_enum`, `compounding_frequency_nth_day_enum`, `compounding_frequency_on_day`, `compounding_frequency_weekday_enum`, `is_compounding_to_be_posted_as_transaction`, `allow_compounding_on_eod`) VALUES (30, 30, 0, 2, 2, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (1, 1, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (2, 2, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (3, 3, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (4, 4, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (5, 5, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (6, 6, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (7, 7, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (8, 8, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (9, 9, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (10, 10, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (11, 11, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (12, 12, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (13, 13, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (14, 14, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (15, 15, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (16, 16, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (17, 17, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (18, 18, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (19, 19, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (20, 20, 1, 10);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (21, 21, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (22, 22, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (23, 23, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (24, 24, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (25, 25, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (26, 26, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (27, 27, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (28, 28, 1, 365);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (29, 29, 1, 30);
INSERT INTO `m_product_loan_variable_installment_config` (`id`, `loan_product_id`, `minimum_gap`, `maximum_gap`) VALUES (30, 30, 1, 365);