-
Notifications
You must be signed in to change notification settings - Fork 6
/
defaultCoaD9.sql
220 lines (201 loc) · 69.7 KB
/
defaultCoaD9.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
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 `acc_gl_account` (`id`, `name`, `parent_id`, `hierarchy`, `gl_code`, `disabled`, `manual_journal_entries_allowed`, `account_usage`, `classification_enum`, `tag_id`, `description`) VALUES (35, 'Liability account -Standard', NULL, '.', '501', 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 (36, 'Expense account -Standard', NULL, '.', '502', 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 (37, 'Liability account -SubStandard', NULL, '.', '503', 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 (38, 'Expense account -SubStandard', NULL, '.', '504', 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 (39, 'Liability account -Doubtful', NULL, '.', '505', 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 (40, 'Expense account -Doubtful', NULL, '.', '506', 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 (41, 'Liability account -Loss', NULL, '.', '507', 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 (42, 'Expense account -Loss', NULL, '.', '508', 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 (43, 'Share reference', NULL, '.', '401', 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 (44, 'Share Suspense control', NULL, '.', '402', 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 (46, 'Share Equity', NULL, '.', '403', 0, 1, 1, 3, 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 (47, 'Share Income', NULL, '.', '404', 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 (48, 'Asset Teller', NULL, '.', '512', 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 (49, 'Asset Teller 2', NULL, '.', '513', 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_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 (61, 'Saving Charge-Saving Activation-Flat', 'USD', 2, 3, 1, NULL, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, 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`, `tax_group_id`) VALUES (62, 'Saving Charge-Specified due date-Flat', 'USD', 2, 2, 1, NULL, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, 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`, `tax_group_id`) VALUES (63, 'Saving Charge-Monthly Fee-Flat', 'USD', 2, 7, 1, NULL, 100.000000, 1, 1, 1, 0, 1, 0, NULL, 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`, `tax_group_id`) VALUES (64, 'Share Activation Charge', 'USD', 4, 13, 1, NULL, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, 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`, `tax_group_id`) VALUES (65, 'share-purchase-flat', 'USD', 4, 14, 1, NULL, 100.000000, NULL, NULL, NULL, 0, 1, 0, NULL, 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`, `tax_group_id`) VALUES (66, 'share-redeem-flat', 'USD', 4, 15, 1, NULL, 10.000000, NULL, NULL, NULL, 0, 1, 0, NULL, NULL, NULL, NULL, 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_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (23, 'personal', 'a', 1, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (27, 'Karnataka', '', 0, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (27, 'Kerala', '', 0, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (28, 'India', '', 0, NULL, 1);
INSERT INTO `m_code_value` (`code_id`, `code_value`, `code_description`, `order_position`, `code_score`, `is_active`) VALUES (28, 'Nepal', '', 0, 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_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 `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 (2, '4707-SUBMITSAVINGS01JAN2015-APPROVEON01JAN2015-ACTIVATEON01JAN2015', '4707', '4707-SUBMITSAVINGS01JAN2015-APPROVEON01JAN2015-ACTIVATEON01JAN2015', 100, 'USD', 2, 100, 12.000000, 1, 4, 2, 365, 500.000000, NULL, NULL, 1, NULL, NULL, 0, 0, 0.000000, 0.000000, 0.000000, 500.000000, 0, NULL, 0, NULL, 0, NULL, NULL, 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 (3, '4718-SUBMITSAVINGSON01JAN2015-APPROVEON01JAN2015-ACTIVATEON01JAN2015-WITHDRAW500on01FEB2015', '4718', '4718-SUBMITSAVINGSON01JAN2015-APPROVEON01JAN2015-ACTIVATEON01JAN2015-WITHDRAW500on01FEB2015', 100, 'USD', 2, 100, 12.000000, 1, 4, 2, 365, 100.000000, NULL, NULL, 1, NULL, NULL, 0, 1, 300.000000, 12.000000, 100.000000, 100.000000, 0, NULL, 0, NULL, 0, NULL, NULL, 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 (4, '4726-SUBMIT01JAN2015-DEPOSIT200on15JAN2015-WITHDRAW100on01FEB2015-POSTINTEREST-VIEWJRNALENTRY', '4726', '4726-SUBMIT01JAN2015-DEPOSIT200on15JAN2015-WITHDRAW100on01FEB2015-POSTINTEREST-VIEWJRNALENTRY', 100, 'USD', 2, 100, 12.000000, 1, 4, 2, 365, 100.000000, NULL, NULL, 2, NULL, NULL, 0, 0, 0.000000, 0.000000, 0.000000, 100.000000, 0, NULL, 0, NULL, 0, NULL, NULL, 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 (5, '4737-SUBMITFD01JAN2015(AMT5000-PERIOD12MNTH)-APRACT05JAN2015', '4737', '4737-SUBMITFD01JAN2015(AMT5000-PERIOD12MNTH)-APRACT05JAN2015', 200, 'USD', 2, 100, 0.000000, 1, 4, 2, 365, NULL, 6.000000, 2, 1, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 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 (6, '4757-SUBMITRD01JAN2015(AMT5000-PRD06MNTH)-APRACT01FEB2015', '4757', '4757-SUBMITRD01JAN2015(AMT5000-PRD06MNTH)-APRACT01FEB2015', 300, 'USD', 2, 1, 0.000000, 1, 4, 1, 365, NULL, 3.000000, 2, 1, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 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 (7, '4780-SUBMITRD01JAN2015(AMT5000-PRD02MNTH)-APRACT01JAN2015-DPT01JAN2015-PrematureCloseOn01FEB2015', '4780', '4780-SUBMITRD01JAN2015(AMT5000-PRD02MNTH)-APRACT01JAN2015-DPT01JAN2015-PrematureCloseOn01FEB2015', 300, 'USD', 2, 1, 0.000000, 1, 4, 1, 365, NULL, 3.000000, 2, 2, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, NULL);
INSERT INTO `m_share_product` (`id`, `name`, `short_name`, `external_id`, `description`, `start_date`, `end_date`, `currency_code`, `currency_digits`, `currency_multiplesof`, `total_shares`, `issued_shares`, `totalsubscribed_shares`, `unit_price`, `capital_amount`, `minimum_client_shares`, `nominal_client_shares`, `maximum_client_shares`, `minimum_active_period_frequency`, `minimum_active_period_frequency_enum`, `lockin_period_frequency`, `lockin_period_frequency_enum`, `allow_dividends_inactive_clients`, `createdby_id`, `created_date`, `lastmodifiedby_id`, `lastmodified_date`, `accounting_type`) VALUES (1, '4787-SUBMITSA01JAN2015(MINACTPRD-30DAYS&LCKINPRD-15DAYS)-APRACT01JAN2015', '4787', NULL, '4787-SUBMITSA01JAN2015(MINACTPRD-30DAYS&LCKINPRD-15DAYS)-APRACT01JAN2015', '2015-04-01 00:00:00', '2015-04-01 00:00:00', 'USD', 2, 1, 10000, 4000, NULL, 10.00, 400.00, NULL, 10, NULL, 30.000000, 0, NULL, 4, NULL, 1, '2015-04-01 11:20:37', 1, '2015-04-01 11:20:37', 2);
INSERT INTO `m_interest_rate_chart` (`id`, `name`, `description`, `from_date`, `end_date`, `is_primary_grouping_by_amount`) VALUES (3, NULL, NULL, '2014-01-01', NULL, 0);
INSERT INTO `m_interest_rate_chart` (`id`, `name`, `description`, `from_date`, `end_date`, `is_primary_grouping_by_amount`) VALUES (1, NULL, NULL, '2014-01-01', NULL, 0);
INSERT INTO `m_interest_rate_chart` (`id`, `name`, `description`, `from_date`, `end_date`, `is_primary_grouping_by_amount`) VALUES (2, NULL, NULL, '2014-01-01', NULL, 0);
INSERT INTO `m_deposit_product_term_and_preclosure` (`id`, `savings_product_id`, `min_deposit_term`, `max_deposit_term`, `min_deposit_term_type_enum`, `max_deposit_term_type_enum`, `in_multiples_of_deposit_term`, `in_multiples_of_deposit_term_type_enum`, `pre_closure_penal_applicable`, `pre_closure_penal_interest`, `pre_closure_penal_interest_on_enum`, `min_deposit_amount`, `max_deposit_amount`, `deposit_amount`) VALUES (2, 6, 1, 12, 2, 2, NULL, NULL, 0, NULL, NULL, 1000.000000, 10000.000000, 5000.000000);
INSERT INTO `m_deposit_product_term_and_preclosure` (`id`, `savings_product_id`, `min_deposit_term`, `max_deposit_term`, `min_deposit_term_type_enum`, `max_deposit_term_type_enum`, `in_multiples_of_deposit_term`, `in_multiples_of_deposit_term_type_enum`, `pre_closure_penal_applicable`, `pre_closure_penal_interest`, `pre_closure_penal_interest_on_enum`, `min_deposit_amount`, `max_deposit_amount`, `deposit_amount`) VALUES (1, 5, 1, 12, 2, 2, NULL, NULL, 0, NULL, NULL, 1000.000000, 10000.000000, 5000.000000);
INSERT INTO `m_deposit_product_term_and_preclosure` (`id`, `savings_product_id`, `min_deposit_term`, `max_deposit_term`, `min_deposit_term_type_enum`, `max_deposit_term_type_enum`, `in_multiples_of_deposit_term`, `in_multiples_of_deposit_term_type_enum`, `pre_closure_penal_applicable`, `pre_closure_penal_interest`, `pre_closure_penal_interest_on_enum`, `min_deposit_amount`, `max_deposit_amount`, `deposit_amount`) VALUES (3, 7, 1, 12, 2, 2, NULL, NULL, 1, 1.000000, 1, 1000.000000, 10000.000000, 5000.000000);
INSERT INTO `m_deposit_product_interest_rate_chart` (`deposit_product_id`, `interest_rate_chart_id`) VALUES (5, 1);
INSERT INTO `m_deposit_product_interest_rate_chart` (`deposit_product_id`, `interest_rate_chart_id`) VALUES (6, 2);
INSERT INTO `m_deposit_product_interest_rate_chart` (`deposit_product_id`, `interest_rate_chart_id`) VALUES (7, 3);
INSERT INTO `m_deposit_product_recurring_detail` (`id`, `savings_product_id`, `is_mandatory`, `allow_withdrawal`, `adjust_advance_towards_future_payments`) VALUES (1, 6, 0, 0, 0);
INSERT INTO `m_deposit_product_recurring_detail` (`id`, `savings_product_id`, `is_mandatory`, `allow_withdrawal`, `adjust_advance_towards_future_payments`) VALUES (2, 7, 0, 0, 0);
INSERT INTO `m_share_product_market_price` (`id`, `product_id`, `from_date`, `share_value`) VALUES (1, 1, '2015-03-01', 15.00);
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (1, 1, NULL, 2, 7, NULL, 5001.000000, NULL, 4.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (2, 1, NULL, 2, 1, 6, 5001.000000, NULL, 2.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (3, 1, NULL, 2, 7, NULL, 1.000000, 5000.000000, 3.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (4, 1, NULL, 2, 1, 6, 1.000000, 5000.000000, 1.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (5, 2, NULL, 2, 7, NULL, 1.000000, 5000.000000, 3.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (6, 2, NULL, 2, 1, 6, 5001.000000, NULL, 2.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (7, 2, NULL, 2, 7, NULL, 5001.000000, NULL, 4.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (8, 2, NULL, 2, 1, 6, 1.000000, 5000.000000, 1.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (9, 3, NULL, 2, 7, NULL, 1.000000, 5000.000000, 3.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (10, 3, NULL, 2, 1, 6, 5001.000000, NULL, 2.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (11, 3, NULL, 2, 7, NULL, 5001.000000, NULL, 4.000000, 'USD');
INSERT INTO `m_interest_rate_slab` (`id`, `interest_rate_chart_id`, `description`, `period_type_enum`, `from_period`, `to_period`, `amount_range_from`, `amount_range_to`, `annual_interest_rate`, `currency_code`) VALUES (12, 3, NULL, 2, 1, 6, 1.000000, 5000.000000, 1.000000, 'USD');
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, '4629', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, '4629-EI-DB-DL-DISB-01JAN2015-FC-15JAN2015', '4629-EI-DB-DL-DISB-01JAN2015-FC-15JAN2015', NULL, b'0', b'0', 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, 0, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, 0, 0.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, 'LP1', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, 'LP1', 'LP1', NULL, b'0', b'0', 12.000000, NULL, NULL, 3, 12.000000, 0, 1, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 4, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, 0, 0.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, 'LP2', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, 'LP2', 'LP2', NULL, b'0', b'0', 12.000000, NULL, NULL, 3, 12.000000, 0, 1, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 4, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, 0, 0.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, 'LP3', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, 'LP3', 'LP3', NULL, b'0', b'0', 12.000000, NULL, NULL, 3, 12.000000, 0, 0, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 4, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, 0, 0.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, 'LP4', 'USD', 2, 0, 10000.000000, NULL, NULL, NULL, 'LP4', 'LP4', NULL, b'0', b'0', 12.000000, NULL, NULL, 3, 12.000000, 0, 1, 0, 1, 2, 12, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 4, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 1, 0, NULL, 0, 0.00, 0, 0, NULL, 0, 0);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (10, 20, 7, 2, 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, 8, 7, 2, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (12, 10, 7, 2, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (13, 24, 7, 2, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (14, 22, 7, 2, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (15, 23, 7, 2, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (1, 20, 4, 2, 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, 21, 4, 2, NULL, NULL, 11);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (3, 26, 4, 2, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (4, 27, 4, 2, NULL, NULL, 5);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (5, 28, 4, 2, NULL, NULL, 12);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (6, 24, 4, 2, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (7, 25, 4, 2, NULL, NULL, 13);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (8, 22, 4, 2, NULL, NULL, 2);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (9, 23, 4, 2, NULL, NULL, 10);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (16, 43, 1, 4, NULL, NULL, 1);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (17, 47, 1, 4, NULL, NULL, 3);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (18, 46, 1, 4, NULL, NULL, 4);
INSERT INTO `acc_product_mapping` (`id`, `gl_account_id`, `product_id`, `product_type`, `payment_type`, `charge_id`, `financial_account_type`) VALUES (19, 44, 1, 4, NULL, NULL, 2);
INSERT INTO `acc_gl_financial_activity_account` (`id`, `gl_account_id`, `financial_activity_type`) VALUES (1, 1, 103);
INSERT INTO `acc_gl_financial_activity_account` (`id`, `gl_account_id`, `financial_activity_type`) VALUES (2, 6, 100);
INSERT INTO `acc_gl_financial_activity_account` (`id`, `gl_account_id`, `financial_activity_type`) VALUES (3, 23, 200);
INSERT INTO `acc_gl_financial_activity_account` (`id`, `gl_account_id`, `financial_activity_type`) VALUES (4, 48, 101);
INSERT INTO `acc_gl_financial_activity_account` (`id`, `gl_account_id`, `financial_activity_type`) VALUES (5, 49, 102);
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);