-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `refillDetail`
--

CREATE TABLE `refillDetail` (
  `id` bigint UNSIGNED NOT NULL,
  `bankId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `smsCount` int NOT NULL,
  `rechargeAmount` int NOT NULL,
  `contactPersonNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rechargeDate` date NOT NULL,
  `bill_attachment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dueDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refillDetail`
--

INSERT INTO `refillDetail` (`id`, `bankId`, `smsCount`, `rechargeAmount`, `contactPersonNumber`, `rechargeDate`, `bill_attachment`, `dueDate`, `created_at`, `updated_at`) VALUES
(1, '1', 3000, 1000, '9746544512', '2019-10-14', NULL, '2019-10-14 07:13:54', '2019-10-14 07:13:54', '2019-10-14 07:13:54'),
(2, '1', 5000, 2000, '9746544512', '2019-10-14', NULL, '2019-10-14 11:30:00', '2019-10-14 11:30:00', '2019-10-14 11:30:00'),
(3, '2', 5000, 3000, '9746544512', '2019-10-14', NULL, '2019-10-14 11:55:30', '2019-10-14 11:55:30', '2019-10-14 11:55:30'),
(4, '3', 4000, 2000, '9746544512', '2019-10-14', NULL, '2019-10-14 11:56:07', '2019-10-14 11:56:07', '2019-10-14 11:56:07'),
(5, '4', 5000, 2500, '9746544512', '2019-10-14', NULL, '2019-10-14 11:56:39', '2019-10-14 11:56:39', '2019-10-14 11:56:39'),
(6, '5', 10000, 5000, '9746544512', '2019-10-14', NULL, '2019-10-14 11:57:28', '2019-10-14 11:57:28', '2019-10-14 11:57:28'),
(7, '6', 100000, 10000, '9746544512', '2019-10-14', NULL, '2019-10-14 11:58:01', '2019-10-14 11:58:01', '2019-10-14 11:58:01'),
(8, '7', 25000, 10000, '9746544512', '2019-10-14', NULL, '2019-10-14 11:59:07', '2019-10-14 11:59:07', '2019-10-14 11:59:07'),
(9, '8', 100000, 25000, '9746544512', '2019-10-14', NULL, '2019-10-14 11:59:39', '2019-10-14 11:59:39', '2019-10-14 11:59:39'),
(10, '9', 90000, 30000, '9746544512', '2019-10-14', NULL, '2019-10-14 12:00:09', '2019-10-14 12:00:09', '2019-10-14 12:00:09'),
(11, '10', 12000, 6000, '9746544512', '2019-10-14', NULL, '2019-10-14 12:00:57', '2019-10-14 12:00:57', '2019-10-14 12:00:57'),
(12, '11', 10000, 5000, '9746544512', '2019-10-14', NULL, '2019-10-14 12:01:24', '2019-10-14 12:01:24', '2019-10-14 12:01:24'),
(13, '12', 12000, 4000, '9746544512', '2019-10-14', NULL, '2019-10-14 12:02:10', '2019-10-14 12:02:10', '2019-10-14 12:02:10'),
(14, '13', 100000, 10000, '9746544512', '2019-10-14', NULL, '2019-10-14 12:02:58', '2019-10-14 12:02:58', '2019-10-14 12:02:58'),
(15, '14', 20000, 5000, '9746544512', '2019-10-14', NULL, '2019-10-14 12:03:37', '2019-10-14 12:03:37', '2019-10-14 12:03:37'),
(16, '15', 15000, 2000, '9746544512', '2019-10-14', NULL, '2019-10-14 12:04:15', '2019-10-14 12:04:15', '2019-10-14 12:04:15'),
(17, '2', 1024, 5000, '9746544512', '2019-10-15', NULL, '2019-10-15 06:28:35', '2019-10-15 06:28:35', '2019-10-15 06:28:35'),
(18, '2', 3000, 2000, '9865665450', '2019-10-22', NULL, '2019-10-25 11:27:20', '2019-10-25 11:27:20', '2019-10-25 11:27:20'),
(19, '2', 3000, 2000, '9865665450', '2019-10-22', NULL, '2019-10-26 08:35:41', '2019-10-26 08:35:41', '2019-10-26 08:35:41'),
(20, '2', 3000, 2000, '9865665450', '2019-10-22', NULL, '2019-10-26 10:23:33', '2019-10-26 10:23:33', '2019-10-26 10:23:33'),
(21, '2', 3000, 2000, '9865665450', '2019-10-22', NULL, '2019-10-26 10:28:11', '2019-10-26 10:28:11', '2019-10-26 10:28:11'),
(22, '2', 3000, 2000, '9865665450', '2019-10-22', NULL, '2019-10-26 10:34:21', '2019-10-26 10:34:21', '2019-10-26 10:34:21'),
(23, '2', 3000, 2000, '9865665450', '2019-10-22', NULL, '2019-10-26 11:08:03', '2019-10-26 11:08:03', '2019-10-26 11:08:03'),
(24, '2', 3000, 2000, '9865665450', '2019-10-22', NULL, '2019-10-28 10:22:04', '2019-10-28 10:22:04', '2019-10-28 10:22:04'),
(25, '14', 2020, 2020, '9995530577', '2020-01-10', 'application_15650993561578628437.pdf', '2020-01-10 03:53:57', '2020-01-10 03:53:57', '2020-01-10 03:53:57'),
(26, '8', 2020, 2020, '7907437167', '2020-01-10', 'application_15650993561578628619.pdf', '2020-01-10 03:56:59', '2020-01-10 03:56:59', '2020-01-10 03:56:59'),
(27, '3', 2019, 2019, '9995530577', '2020-01-10', 'application_15650993561578629924.pdf', '2020-01-10 04:18:44', '2020-01-10 04:18:44', '2020-01-10 04:18:44'),
(28, '3', 2018, 2018, '7907437167', '2020-01-10', 'application_15650993561578630009.pdf', '2020-01-10 04:20:09', '2020-01-10 04:20:09', '2020-01-10 04:20:09'),
(29, '3', 2018, 2018, '7907437167', '2020-01-10', 'application_15650993561578630265.pdf', '2020-01-10 04:24:25', '2020-01-10 04:24:25', '2020-01-10 04:24:25'),
(30, '1', 100, 100, '7510346167', '2020-01-29', 'test-file.pdf', '2020-01-29 04:17:13', '2020-01-29 04:17:13', '2020-01-29 04:17:13'),
(31, '3', 100, 100, '7510346167', '2020-01-29', '1.pdf', '2020-01-29 04:24:15', '2020-01-29 04:24:15', '2020-01-29 04:24:15'),
(32, '1', 150, 100, '98555515112', '2020-01-30', '11.pdf', '2020-01-30 04:36:31', '2020-01-30 04:36:31', '2020-01-30 04:36:31'),
(33, '3', 250, 200, '46494323423', '2020-01-29', 'photo-1545048702-79362596cdc9.jpeg', '2020-01-30 06:36:44', '2020-01-30 06:36:44', '2020-01-30 06:36:44'),
(34, '12384887', 2560, 2560, '9995530577', '2020-01-01', NULL, '2020-01-30 06:57:51', '2020-01-30 06:57:51', '2020-01-30 06:57:51'),
(35, '12384888', 150, 100, '9865565541', '2020-01-01', 'Clipboard - January 20, 2020 11_44 AM.png', '2020-01-31 06:35:55', '2020-01-31 06:35:55', '2020-01-31 06:35:55'),
(36, '3', 200, 100, '9999999999', '2020-03-20', NULL, '2020-03-20 08:25:02', '2020-03-20 08:25:02', '2020-03-20 08:25:02');

-- --------------------------------------------------------

--
-- Table structure for table `smsDetail`
--

CREATE TABLE `smsDetail` (
  `id` bigint UNSIGNED NOT NULL,
  `bankId` int NOT NULL,
  `senderId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `agentId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customerName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customerMobNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `messageType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `moduleCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `accountNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kycID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smsDetail`
--

INSERT INTO `smsDetail` (`id`, `bankId`, `senderId`, `agentId`, `customerName`, `customerMobNumber`, `message`, `messageType`, `status`, `moduleCode`, `accountNumber`, `kycID`, `created_at`, `updated_at`) VALUES
(1, 2, 'RIOSIS', '20', 'Raju ', '9633416454', 'Hi Raju , Your account has been debited an amout of 40000On 13/9/2019   . if not done by you please call us at 9633416454 if you have any questions.', 'Debit', 'AWAITED-DLR', '3', '100000000007', '1', '2019-09-20 04:30:01', '2019-09-20 10:00:01'),
(2, 2, 'RIOSIS', '20', 'Vijao ', '9633416454', 'Hi Vijao , Your account has been debited an amout of 40000On 13/9/2019   . if not done by you please call us at 9633416454 if you have any questions.', 'Credit', 'AWAITED-DLR', '3', '100000000004', '1', '2019-09-20 04:30:34', '2019-09-20 10:00:34'),
(3, 2, 'RIOSIS', '20', 'Tijao ', '9633416454', 'Hi Tijao , Your account has been debited an amout of 40000On 13/9/2019   . if not done by you please call us at 9633416454 if you have any questions.', 'Credit', 'AWAITED-DLR', '1', '100000000004', '1', '2019-09-20 04:30:59', '2019-09-20 10:01:00'),
(4, 1, 'RIOSIS', '20', 'Tijao ', '9633416454', 'Hi Tijao , Your account has been debited an amout of 40000On 13/9/2019   . if not done by you please call us at 9633416454 if you have any questions.', 'Credit', 'AWAITED-DLR', '1', '100000000004', '1', '2019-09-20 04:34:44', '2019-09-20 10:04:44'),
(5, 2, 'RIOSIS', '20', 'Tijao ', '9633416454', 'Hi Tijao , Your account has been debited an amout of 40000On 13/9/2019   . if not done by you please call us at 9633416454 if you have any questions.', 'Credit', 'AWAITED-DLR', '1', '100000000004', '1', '2019-09-20 04:35:46', '2019-09-20 10:05:46'),
(6, 2, 'RIOSIS', '20', 'Kijao ', '9633416454', 'Hi Kijao , Your account has been debited an amout of 40000On 13/9/2019   . if not done by you please call us at 9633416454 if you have any questions.', 'Credit', 'AWAITED-DLR', '1', '100000000001', '1', '2019-09-20 04:36:03', '2019-09-20 10:06:03');

-- --------------------------------------------------------

--
-- Table structure for table `templateChild`
--

CREATE TABLE `templateChild` (
  `id` bigint UNSIGNED NOT NULL,
  `bankId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `templateMasterId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `templatType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `templatFormat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Approved',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `templateChild`
--

INSERT INTO `templateChild` (`id`, `bankId`, `templateMasterId`, `templatType`, `templatFormat`, `status`, `created_at`, `updated_at`) VALUES
(1, '3', '1', 'KYC_OTP_verification', 'Dear customers, your OTP to complete e-KYC is <OTP>. Please do not share this with anyone for security reasons.', 'Rejected', '2020-01-13 10:59:04', '2020-01-30 10:02:11'),
(2, '3', '2', 'KYC_Success', 'Welcome to <Name of Bank / Society> You have completed the KYC registration process. Please note your customer ID for future reference: <customerID>', 'Rejected', '2020-01-13 10:59:04', '2020-01-29 10:05:20'),
(3, '3', '42', 'OTHER_LOANS_Trans_Loan_Closure', 'Dear customer, your loan account - xxxx was closed on full-payment of the amount due. ', 'Approved', '2020-01-13 11:37:49', '2020-01-29 10:15:58'),
(4, '3', '43', 'OTHER_LOANS_Trans_Loan_Renewal', 'Dear customer, your loan a/c xxxx amounting to Rs.xxxx has been renewed  to loan a/c xxxx amounting to Rs. xxxx as per your request.', 'Approved', '2020-01-13 11:37:49', '2020-01-29 09:21:03'),
(6, '3', '6', 'SHARES_Application_Rejection', 'Sorry! Your application for <number of shares> shares has been rejected.\r\nMember Application No: <Member application number>\r\nPlease contact us for further info.', 'Approved', '2020-01-29 05:10:49', '2020-01-29 05:10:49'),
(7, '3', '9', 'SHARES_Rejection', 'Sorry! Your application for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been rejected.\r\nCurrent share balance: <Current share balance>\r\nPlease contact us for further info.', 'Approved', '2020-01-29 05:12:19', '2020-01-29 05:12:19'),
(8, '3', '10', 'SHARES_Approval', 'Greetings! \r\nYour request for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been approved. Current share balance: <Current share balance>\r\n', 'Rejected', '2020-01-29 05:23:04', '2020-01-29 10:55:19'),
(9, '3', '2', 'KYC_Success', 'Welcome to <Name of Bank / Society> You have successfully completed the KYC registration process. Please note your customer ID for future reference: <customerID>. Have a good day!', 'Pending', '2020-01-30 04:30:42', '2020-01-30 12:17:45'),
(10, '3', '1', 'KYC_OTP_verification', 'Dear customer, your one time password to complete e-KYC is <OTP>. Please do not share this with anyone for security reasons.', 'Approved', '2020-01-30 04:32:27', '2020-01-30 04:32:27'),
(11, '3', '3', 'KYC_Registered_Mobile_No', 'Dear customer, the registered mobile number at <Name of Bank / Society> has been successfully changed to <New mobile number>. Have a good day!', 'Rejected', '2020-01-30 06:46:05', '2020-01-30 12:17:05'),
(12, '12384887', '1', 'KYC_OTP_verification', 'Dear customer, your one time password to complete e-KYC is <OTP>. Please do not share this with anyone for security reasons.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(13, '12384887', '2', 'KYC_Success', 'Welcome to <Name of Bank / Society> You have successfully completed the KYC registration process. Please note your customer ID for future reference: <customerID>', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(14, '12384887', '3', 'KYC_Registered_Mobile_No', 'Dear customer, the registered mobile number at <Name of Bank / Society> has been successfully changed to <New mobile number>.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(15, '12384887', '4', 'KYC_Update', 'Dear customer, the changes in your KYC details at <Name of Bank / Society> have been successfully updated', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(16, '12384887', '5', 'SHARES_Application request ', 'Dear customer, your application for <number of shares> shares is under review. Please note your member application number for future reference:<customerID>', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(17, '12384887', '6', 'SHARES_Application_Rejection', 'Sorry! Your application for <number of shares> shares has been rejected.\r\nMember Application No: <Member application number>\r\nPlease contact us for further info.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(18, '12384887', '7', 'SHARES_Application_Approval', 'Greetings! \r\nYour request for <number of shares> shares has been approved.\r\nCurrent share balance: <current share balance>\r\nMember Application No: <Member application number>\r\n', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(19, '12384887', '8', 'SHARES_Application_Additional_Shares', 'Dear customer, your application for additional <Number of additional shares> shares for Member application no: <Member application number> is under review. \r\n', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(20, '12384887', '9', 'SHARES_Rejection', 'Sorry! Your application for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been rejected.\r\nCurrent share balance: <Current share balance>\r\nPlease contact us for further info.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(21, '12384887', '10', 'SHARES_Approval', 'Greetings! \r\nYour request for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been approved. Current share balance: <Current share balance>\r\n', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(22, '12384887', '11', 'SHARES_Withdrawal_Inform', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares is under review\r\n', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(23, '12384887', '12', 'SHARES_Closure_Info', 'Dear customer, your request for the closure of <Number of shares withdrawing> shares is under review\r\n', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(24, '12384887', '13', 'SHARES_Withdrawal_Approve', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares has been approved. Your new share balance is: <Current share balance>', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(25, '12384887', '14', 'SHARES_Closure _Approved ', 'Dear customer, your request for the closure of <Number of shares closing> shares has been approved. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(26, '12384887', '15', 'DEPOSIT_Approval', 'Greetings! Your deposit a/c with <bankName> has been successfully created. \r\nPlease note your deposit a/c no for future ref: <Deposit account number>\r\nYour current balance: Rs. <Current balance>', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(27, '12384887', '16', 'DEPOSIT_Withdrawal', 'Dear customer, Rs.<Withdrawal amount> has been withdrawn from your Deposit A/c <Deposit account number> on <dd/mm/yy> . \r\nYour current balance: Rs <Current share balance>', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(28, '12384887', '17', 'DEPOSIT_Payment_OTP', 'Dear customer, the OTP for payment of Rs. <Payment amount> to A/c <Account number> is <OTP>. Please do not share this with anyone for security reasons.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(29, '12384887', '18', 'DEPOSIT_Transfer ', 'Your payment to A/c <Account number> has been made on <dd/mm/yy> for an amount of Rs.<Payment amount>. Your balance now stands at Rs.<Balance amount>.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(30, '12384887', '19', 'DEPOSIT_Cancel_Transaction', 'Dear customer, the transaction <Transaction id> on <dd/mm/yy> has been cancelled as per your request. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(31, '12384887', '20', 'DEPOSIT_Receival', 'Dear customer, your A/c <Account number> is credited INR <receipt amount> on <dd/mm/yy> \r\nYour current balance: Rs <Balance amount>', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(32, '12384887', '21', 'DEPOSIT_Interest', 'Dear customer, your account is credited INR <Interest amount> with the interest accrued on your deposit a/c from <from date of calculating interest> to <to date of calculating interest>  ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(33, '12384887', '22', 'DEPOSIT_Closure', 'Dear customer, your deposit account <depostA/CNo> has been closed on <yy/mm/dd> as per your request.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(34, '12384887', '23', 'DEPOSIT_Renewal', 'Dear customer, your deposit a/c <deposit a/c no> amounting to Rs.xxxx was renewed to deposit a/c xxxx amounting to xxxx. The balance amount due is Rs. xxxx ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(35, '12384887', '24', 'DEPOSIT_Standing_Instruction_is_Registered', 'Dear customer, your standing instruction has been successfully registered against your deposit a/c xxxx.\r\nStanding instruction no for future ref: xxxx', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(36, '12384887', '25', 'GOLDLOAN_Approval', 'Dear customer, your application for a gold loan of Rs.xxxx under the xxxx scheme has been approved on xx/xx/xx. \r\nSave the gold loan no for future ref: xxxx', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(37, '12384887', '26', 'GOLD LOAN_Part_Payment ', 'EMI of Rs.xxxx is received against your gold loan a/c xxxx. \r\nPrincipal: xxxx\r\nInterest: xxxx\r\nService charges:xxxx', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(38, '12384887', '27', 'GOLDLOAN_Full_Payment', 'Dear customer, your gold loan account  <GoldLoanAccountNo>  has been closed on full-payment of the amount due. You may collect the pledged gold from the Branch', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(39, '12384887', '28', 'GOLDLOAN_Renewal', 'Dear customer, your gold loan a/c has been renewed from gold loan a/c xxxx to gold loan a/c xxxx. The balance amount due is Rs. xxxx ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(40, '12384887', '29', 'GOLDLOAN_Sell_Gold_Decision', 'Dear customer, the pledge against the gold loan a/c xxxx will be put on sale at auction on xx/xx/xx. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(41, '12384887', '30', 'GOLDLOAN_Sale_and_recovery_Report', 'Dear customer, the pledge against the gold loan a/c xxxx was sold for Rs.xxxx on xx/xx/xx at auction. For more details, contact us at (number/address) ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(42, '12384887', '31', 'GOLDLOAN_ Follow-up', 'There was a default in the emi payment of your gold loan a/c xxxx for the month/s xxxx. Please remit the overdue amount Rs. xxxx immediately.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(43, '12384887', '32', 'GOLDLOAN_Release ornaments-OTP', 'The OTP for the release of your pledge against the gold loan a/c xxxx is xxxx. Please do not share this with anyone.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(44, '12384887', '33', 'GOLDLOAN_Collect_Ornaments', 'Dear customer, you can now collect your pledge against the gold loan a/c xxxx from the office', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(45, '12384887', '34', ' OTHER_LOANS_Application_Received', 'Dear customer, your application for a loan under scheme has been received. Please wait while we verify the details.\r\nApplication No: xxxx', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(46, '12384887', '35', 'OTHER_LOANS_Application_Rejected', 'Dear customer, your loan application xxxx under scheme has been rejected. For more info, contact our xxx office.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(47, '12384887', '36', 'OTHER_LOANS_Application_Approved', 'Greetings! Your loan application xxxx under scheme has been approved. For more info, contact our xxx office.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(48, '12384887', '37', 'OTHER_LOANS_Trans_OTP_Verification ', 'Dear customer, the OTP for your loan disbursement is <OTP>. Please do not share the OTP with anyone.\r\nLoan application no: <LoanApplicationNo>', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(49, '12384887', '38', 'OTHER_LOANS_Trans_Loan_Disbursement_Full_Payment', 'Congratulations! Your loan INR xxxx has been disbursed to your  account xxx. \r\nLoan a/c no: xxxx\r\nRepay on time to avoid late payment charges. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(50, '12384887', '39', 'OTHER_LOANS_Trans_Loan_Disbursemet_Partial_Payment)', 'Greetings! The nth instalment in your loan a/c xxxx of Rs xxxx has been disbursed to  a/c xxxx. \r\nRepay on time to avoid late payment charges. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(51, '12384887', '40', 'OTHER_LOANS_Trans_Member_Liability_Removal/addition', 'Hello Name! You have been added as a surety to Mr.A\'s loan a/c xxxx amounting to Rs.xxxx. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(52, '12384887', '41', 'OTHER_LOANS_Trans_Close_Surety', 'Hello Name! You have been removed as a surety to Mr.A\'s loan a/c xxxx. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(53, '12384887', '42', 'OTHER_LOANS_Trans_Loan_Closure', 'Dear customer, your loan a/c xxxx was closed on full-payment of the amount due. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(54, '12384887', '43', 'OTHER_LOANS_Trans_Loan_Renewal', 'Dear customer, your loan a/c xxxx amounting to Rs.xxxx has been renewed  to loan a/c xxxx amounting to Rs. xxxx as per your request.', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(55, '12384887', '44', 'OTHER_LOANS_Trans_Repayment', 'Dear customer, we have received the EMI for month amounting to Rs. <Amount> against your loan a/c <LoanAccountNo>.\r\nPrincipal:  <PrincipalAmount>\r\nInterest: <InterestAmount>. \r\nBalance amount due: <BalanceAmountDue>. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(56, '12384887', '45', 'OTHER_LOANS_Trans_ARC/case', 'A case/ARC has been filed against your loan a/c xxxx on xx/xx/xx in the court for default in the payments. \r\nPlease note the case no for future reference: xxxx ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(57, '12384887', '46', 'OTHER_LOANS_Trans_NPA_Follow-up', 'A default in the EMI payments against loan a/c xxxx was observed for the month/s xxxx. Please remit the overdue amount of Rs. xxxx immediately. ', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(58, '12384887', '47', 'OTHER_LOANS_Trans_Overdue', 'Dear customer, you are eligible for rebate and subsidy amounting to Rs.xxxx on your loan a/c xxxx under the Ashua scheme. For more info, contact our office', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(59, '12384887', '48', 'test', 'test', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(60, '12384887', '49', 'tet', 'fdfsd', 'Approved', '2020-01-30 06:46:22', '2020-01-30 06:46:22'),
(61, '3', '3', 'KYC_Registered_Mobile_No', 'Dear customer, the registered mobile number at <Name of Bank / Society> has been successfully changed to <New mobile number>.', 'Approved', '2020-01-30 06:47:21', '2020-01-30 06:47:21'),
(62, 'tee', '1', 'KYC_OTP_verification', 'Dear customer, your one time password to complete e-KYC is <OTP>. Please do not share this with anyone for security reasons.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(63, 'tee', '2', 'KYC_Success', 'Welcome to <Name of Bank / Society> You have successfully completed the KYC registration process. Please note your customer ID for future reference: <customerID>', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(64, 'tee', '3', 'KYC_Registered_Mobile_No', 'Dear customer, the registered mobile number at <Name of Bank / Society> has been successfully changed to <New mobile number>.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(65, 'tee', '4', 'KYC_Update', 'Dear customer, the changes in your KYC details at <Name of Bank / Society> have been successfully updated', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(66, 'tee', '5', 'SHARES_Application request ', 'Dear customer, your application for <number of shares> shares is under review. Please note your member application number for future reference:<customerID>', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(67, 'tee', '6', 'SHARES_Application_Rejection', 'Sorry! Your application for <number of shares> shares has been rejected.\r\nMember Application No: <Member application number>\r\nPlease contact us for further info.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(68, 'tee', '7', 'SHARES_Application_Approval', 'Greetings! \r\nYour request for <number of shares> shares has been approved.\r\nCurrent share balance: <current share balance>\r\nMember Application No: <Member application number>\r\n', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(69, 'tee', '8', 'SHARES_Application_Additional_Shares', 'Dear customer, your application for additional <Number of additional shares> shares for Member application no: <Member application number> is under review. \r\n', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(70, 'tee', '9', 'SHARES_Rejection', 'Sorry! Your application for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been rejected.\r\nCurrent share balance: <Current share balance>\r\nPlease contact us for further info.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(71, 'tee', '10', 'SHARES_Approval', 'Greetings! \r\nYour request for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been approved. Current share balance: <Current share balance>\r\n', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(72, 'tee', '11', 'SHARES_Withdrawal_Inform', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares is under review\r\n', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(73, 'tee', '12', 'SHARES_Closure_Info', 'Dear customer, your request for the closure of <Number of shares withdrawing> shares is under review\r\n', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(74, 'tee', '13', 'SHARES_Withdrawal_Approve', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares has been approved. Your new share balance is: <Current share balance>', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(75, 'tee', '14', 'SHARES_Closure _Approved ', 'Dear customer, your request for the closure of <Number of shares closing> shares has been approved. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(76, 'tee', '15', 'DEPOSIT_Approval', 'Greetings! Your deposit a/c with <bankName> has been successfully created. \r\nPlease note your deposit a/c no for future ref: <Deposit account number>\r\nYour current balance: Rs. <Current balance>', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(77, 'tee', '16', 'DEPOSIT_Withdrawal', 'Dear customer, Rs.<Withdrawal amount> has been withdrawn from your Deposit A/c <Deposit account number> on <dd/mm/yy> . \r\nYour current balance: Rs <Current share balance>', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(78, 'tee', '17', 'DEPOSIT_Payment_OTP', 'Dear customer, the OTP for payment of Rs. <Payment amount> to A/c <Account number> is <OTP>. Please do not share this with anyone for security reasons.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(79, 'tee', '18', 'DEPOSIT_Transfer ', 'Your payment to A/c <Account number> has been made on <dd/mm/yy> for an amount of Rs.<Payment amount>. Your balance now stands at Rs.<Balance amount>.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(80, 'tee', '19', 'DEPOSIT_Cancel_Transaction', 'Dear customer, the transaction <Transaction id> on <dd/mm/yy> has been cancelled as per your request. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(81, 'tee', '20', 'DEPOSIT_Receival', 'Dear customer, your A/c <Account number> is credited INR <receipt amount> on <dd/mm/yy> \r\nYour current balance: Rs <Balance amount>', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(82, 'tee', '21', 'DEPOSIT_Interest', 'Dear customer, your account is credited INR <Interest amount> with the interest accrued on your deposit a/c from <from date of calculating interest> to <to date of calculating interest>  ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(83, 'tee', '22', 'DEPOSIT_Closure', 'Dear customer, your deposit account <depostA/CNo> has been closed on <yy/mm/dd> as per your request.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(84, 'tee', '23', 'DEPOSIT_Renewal', 'Dear customer, your deposit a/c <deposit a/c no> amounting to Rs.xxxx was renewed to deposit a/c xxxx amounting to xxxx. The balance amount due is Rs. xxxx ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(85, 'tee', '24', 'DEPOSIT_Standing_Instruction_is_Registered', 'Dear customer, your standing instruction has been successfully registered against your deposit a/c xxxx.\r\nStanding instruction no for future ref: xxxx', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(86, 'tee', '25', 'GOLDLOAN_Approval', 'Dear customer, your application for a gold loan of Rs.xxxx under the xxxx scheme has been approved on xx/xx/xx. \r\nSave the gold loan no for future ref: xxxx', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(87, 'tee', '26', 'GOLD LOAN_Part_Payment ', 'EMI of Rs.xxxx is received against your gold loan a/c xxxx. \r\nPrincipal: xxxx\r\nInterest: xxxx\r\nService charges:xxxx', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(88, 'tee', '27', 'GOLDLOAN_Full_Payment', 'Dear customer, your gold loan account  <GoldLoanAccountNo>  has been closed on full-payment of the amount due. You may collect the pledged gold from the Branch', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(89, 'tee', '28', 'GOLDLOAN_Renewal', 'Dear customer, your gold loan a/c has been renewed from gold loan a/c xxxx to gold loan a/c xxxx. The balance amount due is Rs. xxxx ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(90, 'tee', '29', 'GOLDLOAN_Sell_Gold_Decision', 'Dear customer, the pledge against the gold loan a/c xxxx will be put on sale at auction on xx/xx/xx. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(91, 'tee', '30', 'GOLDLOAN_Sale_and_recovery_Report', 'Dear customer, the pledge against the gold loan a/c xxxx was sold for Rs.xxxx on xx/xx/xx at auction. For more details, contact us at (number/address) ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(92, 'tee', '31', 'GOLDLOAN_ Follow-up', 'There was a default in the emi payment of your gold loan a/c xxxx for the month/s xxxx. Please remit the overdue amount Rs. xxxx immediately.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(93, 'tee', '32', 'GOLDLOAN_Release ornaments-OTP', 'The OTP for the release of your pledge against the gold loan a/c xxxx is xxxx. Please do not share this with anyone.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(94, 'tee', '33', 'GOLDLOAN_Collect_Ornaments', 'Dear customer, you can now collect your pledge against the gold loan a/c xxxx from the office', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(95, 'tee', '34', ' OTHER_LOANS_Application_Received', 'Dear customer, your application for a loan under scheme has been received. Please wait while we verify the details.\r\nApplication No: xxxx', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(96, 'tee', '35', 'OTHER_LOANS_Application_Rejected', 'Dear customer, your loan application xxxx under scheme has been rejected. For more info, contact our xxx office.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(97, 'tee', '36', 'OTHER_LOANS_Application_Approved', 'Greetings! Your loan application xxxx under scheme has been approved. For more info, contact our xxx office.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(98, 'tee', '37', 'OTHER_LOANS_Trans_OTP_Verification ', 'Dear customer, the OTP for your loan disbursement is <OTP>. Please do not share the OTP with anyone.\r\nLoan application no: <LoanApplicationNo>', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(99, 'tee', '38', 'OTHER_LOANS_Trans_Loan_Disbursement_Full_Payment', 'Congratulations! Your loan INR xxxx has been disbursed to your  account xxx. \r\nLoan a/c no: xxxx\r\nRepay on time to avoid late payment charges. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(100, 'tee', '39', 'OTHER_LOANS_Trans_Loan_Disbursemet_Partial_Payment)', 'Greetings! The nth instalment in your loan a/c xxxx of Rs xxxx has been disbursed to  a/c xxxx. \r\nRepay on time to avoid late payment charges. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(101, 'tee', '40', 'OTHER_LOANS_Trans_Member_Liability_Removal/addition', 'Hello Name! You have been added as a surety to Mr.A\'s loan a/c xxxx amounting to Rs.xxxx. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(102, 'tee', '41', 'OTHER_LOANS_Trans_Close_Surety', 'Hello Name! You have been removed as a surety to Mr.A\'s loan a/c xxxx. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(103, 'tee', '42', 'OTHER_LOANS_Trans_Loan_Closure', 'Dear customer, your loan a/c xxxx was closed on full-payment of the amount due. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(104, 'tee', '43', 'OTHER_LOANS_Trans_Loan_Renewal', 'Dear customer, your loan a/c xxxx amounting to Rs.xxxx has been renewed  to loan a/c xxxx amounting to Rs. xxxx as per your request.', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(105, 'tee', '44', 'OTHER_LOANS_Trans_Repayment', 'Dear customer, we have received the EMI for month amounting to Rs. <Amount> against your loan a/c <LoanAccountNo>.\r\nPrincipal:  <PrincipalAmount>\r\nInterest: <InterestAmount>. \r\nBalance amount due: <BalanceAmountDue>. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(106, 'tee', '45', 'OTHER_LOANS_Trans_ARC/case', 'A case/ARC has been filed against your loan a/c xxxx on xx/xx/xx in the court for default in the payments. \r\nPlease note the case no for future reference: xxxx ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(107, 'tee', '46', 'OTHER_LOANS_Trans_NPA_Follow-up', 'A default in the EMI payments against loan a/c xxxx was observed for the month/s xxxx. Please remit the overdue amount of Rs. xxxx immediately. ', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(108, 'tee', '47', 'OTHER_LOANS_Trans_Overdue', 'Dear customer, you are eligible for rebate and subsidy amounting to Rs.xxxx on your loan a/c xxxx under the Ashua scheme. For more info, contact our office', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(109, 'tee', '48', 'test', 'test', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(110, 'tee', '49', 'tet', 'fdfsd', 'Approved', '2020-01-31 06:33:15', '2020-01-31 06:33:15'),
(111, '3', '50', 'ffg', 'bgfhgfh bla bla bla', 'Approved', '2020-02-08 03:56:07', '2020-03-20 13:36:07'),
(112, '3', '51', 'Test', 'Testing the template adding', 'Approved', '2020-02-08 03:56:07', '2020-02-08 03:56:07'),
(113, '3', '47', 'OTHER_LOANS_Trans_Overdue', 'Dear customer, you are eligible for rebate and subsidy amounting to Rs.xxxx on your loan a/c xxxx under the Ashua scheme. For more info, contact our office', 'Approved', '2020-02-29 09:49:57', '2020-02-29 09:49:57'),
(114, '3', '48', 'test', 'test', 'Approved', '2020-02-29 09:49:57', '2020-02-29 09:49:57'),
(115, '3', '49', 'hjgh', 'ghjghjghj', 'Approved', '2020-02-29 09:49:57', '2020-02-29 09:49:57'),
(116, '3', '25', 'GOLDLOAN_Approval', 'Dear customer, your application for a gold loan of Rs.xxxx under the xxxx scheme has been approved on xx/xx/xx. \r\nSave the gold loan no for future ref: xxxx', 'Approved', '2020-03-20 06:46:24', '2020-03-20 06:46:24'),
(117, '3', '26', 'GOLD LOAN_Part_Payment ', 'EMI of Rs.xxxx is received against your gold loan a/c xxxx. \r\nPrincipal: xxxx\r\nInterest: xxxx\r\nService charges:xxxx', 'Approved', '2020-03-20 06:46:24', '2020-03-20 06:46:24'),
(118, '3', '46', 'OTHER_LOANS_Trans_NPA_Follow-up', 'A default in the EMI payments against loan a/c xxxx was observed for the month/s xxxx. Please remit the overdue amount of Rs. xxxx immediately. ', 'Approved', '2020-03-20 06:46:38', '2020-03-20 06:46:38'),
(119, '3', '33', 'GOLDLOAN_Collect_Ornaments', 'Dear customer, you can now collect your pledge against the gold loan a/c xxxx from the office', 'Approved', '2020-03-20 08:01:39', '2020-03-20 08:01:39'),
(120, '3', '34', ' OTHER_LOANS_Application_Received', 'Dear customer, your application for a loan under scheme has been received. Please wait while we verify the details.\r\nApplication No: xxxx', 'Approved', '2020-03-20 08:01:39', '2020-03-20 08:01:39'),
(121, '3', '23', 'DEPOSIT_Renewal', 'Dear customer, your deposit a/c <deposit a/c no> amounting to Rs.xxxx was renewed to deposit a/c xxxx amounting to xxxx. The balance amount due is Rs. xxxx ', 'Approved', '2020-03-20 08:02:16', '2020-03-20 08:02:16'),
(122, '3', '22', 'DEPOSIT_Closure', 'Dear customer, your deposit account <depostA/CNo> has been closed on <yy/mm/dd> as per your request.', 'Approved', '2020-03-20 08:02:33', '2020-03-20 08:02:33'),
(123, '3', '24', 'DEPOSIT_Standing_Instruction_is_Registered', 'Dear customer, your standing instruction has been successfully registered against your deposit a/c xxxx.\r\nStanding instruction no for future ref: xxxx', 'Approved', '2020-03-20 08:02:45', '2020-03-20 08:02:45'),
(124, '235', '1', 'KYC_OTP_verification', 'Dear customer, your one time password to complete e-KYC is <OTP>. Please do not share this with anyone for security reasons.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(125, '235', '2', 'KYC_Success', 'Welcome to <Name of Bank / Society> You have successfully completed the KYC registration process. Please note your customer ID for future reference: <customerID>', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(126, '235', '3', 'KYC_Registered_Mobile_No', 'Dear customer, the registered mobile number at <Name of Bank / Society> has been successfully changed to <New mobile number>.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(127, '235', '4', 'KYC_Update', 'Dear customer, the changes in your KYC details at <Name of Bank / Society> have been successfully updated', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(128, '235', '5', 'SHARES_Application request ', 'Dear customer, your application for <number of shares> shares is under review. Please note your member application number for future reference:<customerID>', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(129, '235', '6', 'SHARES_Application_Rejection', 'Sorry! Your application for <number of shares> shares has been rejected.\r\nMember Application No: <Member application number>\r\nPlease contact us for further info.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(130, '235', '7', 'SHARES_Application_Approval', 'Greetings! \r\nYour request for <number of shares> shares has been approved.\r\nCurrent share balance: <current share balance>\r\nMember Application No: <Member application number>\r\n', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(131, '235', '8', 'SHARES_Application_Additional_Shares', 'Dear customer, your application for additional <Number of additional shares> shares for Member application no: <Member application number> is under review. \r\n', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(132, '235', '9', 'SHARES_Rejection', 'Sorry! Your application for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been rejected.\r\nCurrent share balance: <Current share balance>\r\nPlease contact us for further info.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(133, '235', '10', 'SHARES_Approval', 'Greetings! \r\nYour request for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been approved. Current share balance: <Current share balance>\r\n', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(134, '235', '11', 'SHARES_Withdrawal_Inform', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares is under review\r\n', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(135, '235', '12', 'SHARES_Closure_Info', 'Dear customer, your request for the closure of <Number of shares withdrawing> shares is under review\r\n', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(136, '235', '13', 'SHARES_Withdrawal_Approve', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares has been approved. Your new share balance is: <Current share balance>', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(137, '235', '14', 'SHARES_Closure _Approved ', 'Dear customer, your request for the closure of <Number of shares closing> shares has been approved. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(138, '235', '15', 'DEPOSIT_Approval', 'Greetings! Your deposit a/c with <bankName> has been successfully created. \r\nPlease note your deposit a/c no for future ref: <Deposit account number>\r\nYour current balance: Rs. <Current balance>', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(139, '235', '16', 'DEPOSIT_Withdrawal', 'Dear customer, Rs.<Withdrawal amount> has been withdrawn from your Deposit A/c <Deposit account number> on <dd/mm/yy> . \r\nYour current balance: Rs <Current share balance>', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(140, '235', '17', 'DEPOSIT_Payment_OTP', 'Dear customer, the OTP for payment of Rs. <Payment amount> to A/c <Account number> is <OTP>. Please do not share this with anyone for security reasons.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(141, '235', '18', 'DEPOSIT_Transfer ', 'Your payment to A/c <Account number> has been made on <dd/mm/yy> for an amount of Rs.<Payment amount>. Your balance now stands at Rs.<Balance amount>.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(142, '235', '19', 'DEPOSIT_Cancel_Transaction', 'Dear customer, the transaction <Transaction id> on <dd/mm/yy> has been cancelled as per your request. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(143, '235', '20', 'DEPOSIT_Receival', 'Dear customer, your A/c <Account number> is credited INR <receipt amount> on <dd/mm/yy> \r\nYour current balance: Rs <Balance amount>', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(144, '235', '21', 'DEPOSIT_Interest', 'Dear customer, your account is credited INR <Interest amount> with the interest accrued on your deposit a/c from <from date of calculating interest> to <to date of calculating interest>  ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(145, '235', '22', 'DEPOSIT_Closure', 'Dear customer, your deposit account <depostA/CNo> has been closed on <yy/mm/dd> as per your request.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(146, '235', '23', 'DEPOSIT_Renewal', 'Dear customer, your deposit a/c <deposit a/c no> amounting to Rs.xxxx was renewed to deposit a/c xxxx amounting to xxxx. The balance amount due is Rs. xxxx ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(147, '235', '24', 'DEPOSIT_Standing_Instruction_is_Registered', 'Dear customer, your standing instruction has been successfully registered against your deposit a/c xxxx.\r\nStanding instruction no for future ref: xxxx', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(148, '235', '25', 'GOLDLOAN_Approval', 'Dear customer, your application for a gold loan of Rs.xxxx under the xxxx scheme has been approved on xx/xx/xx. \r\nSave the gold loan no for future ref: xxxx', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(149, '235', '26', 'GOLD LOAN_Part_Payment ', 'EMI of Rs.xxxx is received against your gold loan a/c xxxx. \r\nPrincipal: xxxx\r\nInterest: xxxx\r\nService charges:xxxx', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(150, '235', '27', 'GOLDLOAN_Full_Payment', 'Dear customer, your gold loan account  <GoldLoanAccountNo>  has been closed on full-payment of the amount due. You may collect the pledged gold from the Branch', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(151, '235', '28', 'GOLDLOAN_Renewal', 'Dear customer, your gold loan a/c has been renewed from gold loan a/c xxxx to gold loan a/c xxxx. The balance amount due is Rs. xxxx ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(152, '235', '29', 'GOLDLOAN_Sell_Gold_Decision', 'Dear customer, the pledge against the gold loan a/c xxxx will be put on sale at auction on xx/xx/xx. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(153, '235', '30', 'GOLDLOAN_Sale_and_recovery_Report', 'Dear customer, the pledge against the gold loan a/c xxxx was sold for Rs.xxxx on xx/xx/xx at auction. For more details, contact us at (number/address) ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(154, '235', '31', 'GOLDLOAN_ Follow-up', 'There was a default in the emi payment of your gold loan a/c xxxx for the month/s xxxx. Please remit the overdue amount Rs. xxxx immediately.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(155, '235', '32', 'GOLDLOAN_Release ornaments-OTP', 'The OTP for the release of your pledge against the gold loan a/c xxxx is xxxx. Please do not share this with anyone.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(156, '235', '33', 'GOLDLOAN_Collect_Ornaments', 'Dear customer, you can now collect your pledge against the gold loan a/c xxxx from the office', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(157, '235', '34', ' OTHER_LOANS_Application_Received', 'Dear customer, your application for a loan under scheme has been received. Please wait while we verify the details.\r\nApplication No: xxxx', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(158, '235', '35', 'OTHER_LOANS_Application_Rejected', 'Dear customer, your loan application xxxx under scheme has been rejected. For more info, contact our xxx office.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(159, '235', '36', 'OTHER_LOANS_Application_Approved', 'Greetings! Your loan application xxxx under scheme has been approved. For more info, contact our xxx office.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(160, '235', '37', 'OTHER_LOANS_Trans_OTP_Verification ', 'Dear customer, the OTP for your loan disbursement is <OTP>. Please do not share the OTP with anyone.\r\nLoan application no: <LoanApplicationNo>', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(161, '235', '38', 'OTHER_LOANS_Trans_Loan_Disbursement_Full_Payment', 'Congratulations! Your loan INR xxxx has been disbursed to your  account xxx. \r\nLoan a/c no: xxxx\r\nRepay on time to avoid late payment charges. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(162, '235', '39', 'OTHER_LOANS_Trans_Loan_Disbursemet_Partial_Payment)', 'Greetings! The nth instalment in your loan a/c xxxx of Rs xxxx has been disbursed to  a/c xxxx. \r\nRepay on time to avoid late payment charges. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(163, '235', '40', 'OTHER_LOANS_Trans_Member_Liability_Removal/addition', 'Hello Name! You have been added as a surety to Mr.A\'s loan a/c xxxx amounting to Rs.xxxx. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(164, '235', '41', 'OTHER_LOANS_Trans_Close_Surety', 'Hello Name! You have been removed as a surety to Mr.A\'s loan a/c xxxx. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(165, '235', '42', 'OTHER_LOANS_Trans_Loan_Closure', 'Dear customer, your loan a/c xxxx was closed on full-payment of the amount due. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(166, '235', '43', 'OTHER_LOANS_Trans_Loan_Renewal', 'Dear customer, your loan a/c xxxx amounting to Rs.xxxx has been renewed  to loan a/c xxxx amounting to Rs. xxxx as per your request.', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(167, '235', '44', 'OTHER_LOANS_Trans_Repayment', 'Dear customer, we have received the EMI for month amounting to Rs. <Amount> against your loan a/c <LoanAccountNo>.\r\nPrincipal:  <PrincipalAmount>\r\nInterest: <InterestAmount>. \r\nBalance amount due: <BalanceAmountDue>. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(168, '235', '45', 'OTHER_LOANS_Trans_ARC/case', 'A case/ARC has been filed against your loan a/c xxxx on xx/xx/xx in the court for default in the payments. \r\nPlease note the case no for future reference: xxxx ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(169, '235', '46', 'OTHER_LOANS_Trans_NPA_Follow-up', 'A default in the EMI payments against loan a/c xxxx was observed for the month/s xxxx. Please remit the overdue amount of Rs. xxxx immediately. ', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(170, '235', '47', 'OTHER_LOANS_Trans_Overdue', 'Dear customer, you are eligible for rebate and subsidy amounting to Rs.xxxx on your loan a/c xxxx under the Ashua scheme. For more info, contact our office', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(171, '235', '48', 'test', 'test', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(172, '235', '49', 'hjgh', 'ghjghjghj', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(173, '235', '50', 'ffg', 'bgfhgfh', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36'),
(174, '235', '51', 'Test', 'Testing the template adding', 'Approved', '2020-03-20 09:43:36', '2020-03-20 09:43:36');

-- --------------------------------------------------------

--
-- Table structure for table `templateDetail`
--

CREATE TABLE `templateDetail` (
  `id` bigint UNSIGNED NOT NULL,
  `templatType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `templatFormat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `templateDetail`
--

INSERT INTO `templateDetail` (`id`, `templatType`, `templatFormat`, `created_at`, `updated_at`) VALUES
(1, 'KYC_OTP_verification', 'Dear customer, your one time password to complete e-KYC is <OTP>. Please do not share this with anyone for security reasons.', '2019-10-14 06:59:28', '2020-01-30 12:28:45'),
(2, 'KYC_Success', 'Welcome to <Name of Bank / Society> You have successfully completed the KYC registration process. Please note your customer ID for future reference: <customerID>', '2019-10-14 07:00:20', '2020-01-30 12:28:50'),
(3, 'KYC_Registered_Mobile_No', 'Dear customer, the registered mobile number at <Name of Bank / Society> has been successfully changed to <New mobile number>.', '2019-10-14 07:00:50', '2019-10-14 07:00:50'),
(4, 'KYC_Update', 'Dear customer, the changes in your KYC details at <Name of Bank / Society> have been successfully updated', '2019-10-14 07:01:11', '2019-10-14 07:01:11'),
(5, 'SHARES_Application request ', 'Dear customer, your application for <number of shares> shares is under review. Please note your member application number for future reference:<customerID>', '2019-10-14 07:01:40', '2019-10-14 12:36:25'),
(6, 'SHARES_Application_Rejection', 'Sorry! Your application for <number of shares> shares has been rejected.\r\nMember Application No: <Member application number>\r\nPlease contact us for further info.', '2019-10-14 07:02:11', '2019-10-14 07:02:11'),
(7, 'SHARES_Application_Approval', 'Greetings! \r\nYour request for <number of shares> shares has been approved.\r\nCurrent share balance: <current share balance>\r\nMember Application No: <Member application number>\r\n', '2019-10-14 07:02:40', '2019-10-14 07:02:40'),
(8, 'SHARES_Application_Additional_Shares', 'Dear customer, your application for additional <Number of additional shares> shares for Member application no: <Member application number> is under review. \r\n', '2019-10-14 07:03:10', '2019-10-14 07:03:10'),
(9, 'SHARES_Rejection', 'Sorry! Your application for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been rejected.\r\nCurrent share balance: <Current share balance>\r\nPlease contact us for further info.', '2019-10-14 07:04:00', '2019-10-14 07:04:00'),
(10, 'SHARES_Approval', 'Greetings! \r\nYour request for additional <Number of additional shares> shares for the Member Application No: <Member application number> has been approved. Current share balance: <Current share balance>\r\n', '2019-10-14 07:04:20', '2019-10-14 07:04:20'),
(11, 'SHARES_Withdrawal_Inform', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares is under review\r\n', '2019-10-14 08:38:46', '2019-10-14 08:38:46'),
(12, 'SHARES_Closure_Info', 'Dear customer, your request for the closure of <Number of shares withdrawing> shares is under review\r\n', '2019-10-14 08:39:12', '2019-10-14 08:39:12'),
(13, 'SHARES_Withdrawal_Approve', 'Dear customer, your request for the withdrawal of <Number of shares withdrawing> shares has been approved. Your new share balance is: <Current share balance>', '2019-10-14 09:03:27', '2019-10-14 09:03:27'),
(14, 'SHARES_Closure _Approved ', 'Dear customer, your request for the closure of <Number of shares closing> shares has been approved. ', '2019-10-14 09:03:57', '2019-10-14 09:03:57'),
(15, 'DEPOSIT_Approval', 'Greetings! Your deposit a/c with <bankName> has been successfully created. \r\nPlease note your deposit a/c no for future ref: <Deposit account number>\r\nYour current balance: Rs. <Current balance>', '2019-10-14 09:04:47', '2019-10-14 09:04:47'),
(16, 'DEPOSIT_Withdrawal', 'Dear customer, Rs.<Withdrawal amount> has been withdrawn from your Deposit A/c <Deposit account number> on <dd/mm/yy> . \r\nYour current balance: Rs <Current share balance>', '2019-10-14 09:05:36', '2019-10-14 09:05:36'),
(17, 'DEPOSIT_Payment_OTP', 'Dear customer, the OTP for payment of Rs. <Payment amount> to A/c <Account number> is <OTP>. Please do not share this with anyone for security reasons.', '2019-10-14 09:06:10', '2019-10-14 09:06:10'),
(18, 'DEPOSIT_Transfer ', 'Your payment to A/c <Account number> has been made on <dd/mm/yy> for an amount of Rs.<Payment amount>. Your balance now stands at Rs.<Balance amount>.', '2019-10-14 09:06:43', '2019-10-14 09:06:43'),
(19, 'DEPOSIT_Cancel_Transaction', 'Dear customer, the transaction <Transaction id> on <dd/mm/yy> has been cancelled as per your request. ', '2019-10-14 09:07:45', '2019-10-14 14:49:17'),
(20, 'DEPOSIT_Receival', 'Dear customer, your A/c <Account number> is credited INR <receipt amount> on <dd/mm/yy> \r\nYour current balance: Rs <Balance amount>', '2019-10-14 09:09:17', '2019-10-14 15:21:40'),
(21, 'DEPOSIT_Interest', 'Dear customer, your account is credited INR <Interest amount> with the interest accrued on your deposit a/c from <from date of calculating interest> to <to date of calculating interest>  ', '2019-10-14 09:15:05', '2019-10-14 09:15:05'),
(22, 'DEPOSIT_Closure', 'Dear customer, your deposit account <depostA/CNo> has been closed on <yy/mm/dd> as per your request.', '2019-10-14 09:15:57', '2019-10-15 11:19:31'),
(23, 'DEPOSIT_Renewal', 'Dear customer, your deposit a/c <deposit a/c no> amounting to Rs.xxxx was renewed to deposit a/c xxxx amounting to xxxx. The balance amount due is Rs. xxxx ', '2019-10-14 09:23:24', '2019-10-14 09:23:24'),
(24, 'DEPOSIT_Standing_Instruction_is_Registered', 'Dear customer, your standing instruction has been successfully registered against your deposit a/c xxxx.\r\nStanding instruction no for future ref: xxxx', '2019-10-14 09:24:23', '2019-10-14 09:24:23'),
(25, 'GOLDLOAN_Approval', 'Dear customer, your application for a gold loan of Rs.xxxx under the xxxx scheme has been approved on xx/xx/xx. \r\nSave the gold loan no for future ref: xxxx', '2019-10-14 09:25:56', '2019-10-14 09:25:56'),
(26, 'GOLD LOAN_Part_Payment ', 'EMI of Rs.xxxx is received against your gold loan a/c xxxx. \r\nPrincipal: xxxx\r\nInterest: xxxx\r\nService charges:xxxx', '2019-10-14 09:26:44', '2019-10-14 09:26:44'),
(27, 'GOLDLOAN_Full_Payment', 'Dear customer, your gold loan account  <GoldLoanAccountNo>  has been closed on full-payment of the amount due. You may collect the pledged gold from the Branch', '2019-10-14 09:27:27', '2019-10-15 11:06:48'),
(28, 'GOLDLOAN_Renewal', 'Dear customer, your gold loan a/c has been renewed from gold loan a/c xxxx to gold loan a/c xxxx. The balance amount due is Rs. xxxx ', '2019-10-14 09:28:34', '2019-10-14 09:28:34'),
(29, 'GOLDLOAN_Sell_Gold_Decision', 'Dear customer, the pledge against the gold loan a/c xxxx will be put on sale at auction on xx/xx/xx. ', '2019-10-14 09:30:05', '2019-10-14 09:30:05'),
(30, 'GOLDLOAN_Sale_and_recovery_Report', 'Dear customer, the pledge against the gold loan a/c xxxx was sold for Rs.xxxx on xx/xx/xx at auction. For more details, contact us at (number/address) ', '2019-10-14 09:30:59', '2019-10-14 09:30:59'),
(31, 'GOLDLOAN_ Follow-up', 'There was a default in the emi payment of your gold loan a/c xxxx for the month/s xxxx. Please remit the overdue amount Rs. xxxx immediately.', '2019-10-14 09:31:58', '2019-10-14 09:31:58'),
(32, 'GOLDLOAN_Release ornaments-OTP', 'The OTP for the release of your pledge against the gold loan a/c xxxx is xxxx. Please do not share this with anyone.', '2019-10-14 09:32:52', '2019-10-14 09:32:52'),
(33, 'GOLDLOAN_Collect_Ornaments', 'Dear customer, you can now collect your pledge against the gold loan a/c xxxx from the office', '2019-10-14 09:33:29', '2019-10-14 09:33:29'),
(34, ' OTHER_LOANS_Application_Received', 'Dear customer, your application for a loan under scheme has been received. Please wait while we verify the details.\r\nApplication No: xxxx', '2019-10-14 09:34:03', '2019-10-14 09:34:03'),
(35, 'OTHER_LOANS_Application_Rejected', 'Dear customer, your loan application xxxx under scheme has been rejected. For more info, contact our xxx office.', '2019-10-14 09:34:33', '2019-10-14 09:34:33'),
(36, 'OTHER_LOANS_Application_Approved', 'Greetings! Your loan application xxxx under scheme has been approved. For more info, contact our xxx office.', '2019-10-14 09:35:10', '2019-10-14 09:35:10'),
(37, 'OTHER_LOANS_Trans_OTP_Verification ', 'Dear customer, the OTP for your loan disbursement is <OTP>. Please do not share the OTP with anyone.\r\nLoan application no: <LoanApplicationNo>', '2019-10-14 09:36:01', '2019-10-15 12:46:55'),
(38, 'OTHER_LOANS_Trans_Loan_Disbursement_Full_Payment', 'Congratulations! Your loan INR xxxx has been disbursed to your  account xxx. \r\nLoan a/c no: xxxx\r\nRepay on time to avoid late payment charges. ', '2019-10-14 09:36:36', '2019-10-14 09:36:36'),
(39, 'OTHER_LOANS_Trans_Loan_Disbursemet_Partial_Payment)', 'Greetings! The nth instalment in your loan a/c xxxx of Rs xxxx has been disbursed to  a/c xxxx. \r\nRepay on time to avoid late payment charges. ', '2019-10-14 09:37:12', '2019-10-14 09:37:12'),
(40, 'OTHER_LOANS_Trans_Member_Liability_Removal/addition', 'Hello Name! You have been added as a surety to Mr.A\'s loan a/c xxxx amounting to Rs.xxxx. ', '2019-10-14 09:37:54', '2019-10-14 09:37:54'),
(41, 'OTHER_LOANS_Trans_Close_Surety', 'Hello Name! You have been removed as a surety to Mr.A\'s loan a/c xxxx. ', '2019-10-14 09:38:44', '2019-10-14 09:38:44'),
(42, 'OTHER_LOANS_Trans_Loan_Closure', 'Dear customer, your loan a/c xxxx was closed on full-payment of the amount due. ', '2019-10-14 09:39:21', '2019-10-14 09:39:21'),
(43, 'OTHER_LOANS_Trans_Loan_Renewal', 'Dear customer, your loan a/c xxxx amounting to Rs.xxxx has been renewed  to loan a/c xxxx amounting to Rs. xxxx as per your request.', '2019-10-14 09:41:14', '2019-10-14 09:41:14'),
(44, 'OTHER_LOANS_Trans_Repayment', 'Dear customer, we have received the EMI for month amounting to Rs. <Amount> against your loan a/c <LoanAccountNo>.\r\nPrincipal:  <PrincipalAmount>\r\nInterest: <InterestAmount>. \r\nBalance amount due: <BalanceAmountDue>. ', '2019-10-14 09:42:34', '2019-10-15 14:36:19'),
(45, 'OTHER_LOANS_Trans_ARC/case', 'A case/ARC has been filed against your loan a/c xxxx on xx/xx/xx in the court for default in the payments. \r\nPlease note the case no for future reference: xxxx ', '2019-10-14 09:43:16', '2019-10-14 09:43:16'),
(46, 'OTHER_LOANS_Trans_NPA_Follow-up', 'A default in the EMI payments against loan a/c xxxx was observed for the month/s xxxx. Please remit the overdue amount of Rs. xxxx immediately. ', '2019-10-14 09:46:56', '2019-10-14 09:46:56'),
(47, 'OTHER_LOANS_Trans_Overdue', 'Dear customer, you are eligible for rebate and subsidy amounting to Rs.xxxx on your loan a/c xxxx under the Ashua scheme. For more info, contact our office', '2019-10-14 09:48:45', '2019-10-14 09:48:45'),
(48, 'test', 'test', '2020-01-30 06:42:30', '2020-01-30 12:12:45'),
(49, 'hjgh', 'ghjghjghj', '2020-01-30 06:43:25', '2020-01-31 12:08:04'),
(50, 'ffg', 'bgfhgfh', '2020-01-31 06:38:27', '2020-01-31 06:38:27'),
(51, 'Test', 'Testing the template adding', '2020-01-31 06:52:08', '2020-01-31 06:52:08');

--
-- Indexes for table `refillDetail`
--
ALTER TABLE `refillDetail`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smsDetail`
--
ALTER TABLE `smsDetail`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `templateChild`
--
ALTER TABLE `templateChild`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `templateDetail`
--
ALTER TABLE `templateDetail`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `refillDetail`
--
ALTER TABLE `refillDetail`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `smsDetail`
--
ALTER TABLE `smsDetail`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `templateChild`
--
ALTER TABLE `templateChild`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=175;

--
-- AUTO_INCREMENT for table `templateDetail`
--
ALTER TABLE `templateDetail`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
COMMIT;

