API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 17th, 2018
215
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 91.82 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (1, 0, -1, 'SYSTEM', '2017-02-21 22:36:47', -1, 'SYSTEM', '2018-03-02 15:59:17', 1, 1, 'ENTREG_REG', null, '<p>Thank you for registering for the Correspondent Services module. You will receive a confirmation email once your request is approved.</p><p>Your reference number is ${entity.ccrmBizEntityRefNo}.</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Your Registration Request', 0, 'Received Entity Registration Template');
  2. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (2, 0, -1, 'SYSTEM', '2017-02-21 22:36:47', -1, 'SYSTEM', '2018-03-02 15:59:17', 1, 1, 'ENTREG_APPROVAL', null, '<p>${entity.firstName} ${entity.lastName}, from ${entity.fullLegalName}, with reference number ${entity.ccrmBizEntityRefNo} has registered for the Correspondent Services module and pending for your approval.</p><p></p>', 'CCRManager: Your Registration Request', 0, 'Entity Registration Approval Template');
  3. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (3, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'ENTREG_REJECTED', null, '<p>Your request for ${entity.fullLegalName} to become a Member of the Correspondent Services module has been declined.</p><p></p>$if{entity.remarks != ''''}<p>Remarks: ${entity.remarks}</p>$end{}<p></p><p>Please contact us at contact@ccrmanager.com for clarification.</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Your registration with reference number ${entity.ccrmBizEntityRefNo} has been declined', 0, 'Entity Registration Rejected Template');
  4. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (4, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'ENTREG_APPROVED', null, '<p>Your request for ${entity.fullLegalName} to become a Member on the Correspondent Services module has been approved.</p><p></p><p>Please login to the system as an Administrator using User Name and Password below:</p><p></p><p>User Name: <br/> <b>${entity.userName}</b></p><p>Password: <br/> <b>${entity.loginPass}</b></p><p></p><p>You will be required to change your password upon first login. Please contact us at contact@ccrmanager.com for any assistance.</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Your registration with reference number ${entity.ccrmBizEntityRefNo} has been Approved', 0, 'Entity Registration Approved Template');
  5. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (5, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'ENT_CREATE', null, '<p>${entity.fullLegalName} is now a Member on CCRManager.</p> <p></p> <p>Please login to the system as an Administrator using User Name and Password below:</p> <p></p> <p>User Name: <br/> <b>${entity.userName}</b></p> <p>Password: <br/> <b>${entity.loginPass}</b></p> <p></p> <p>You will be required to change your password upon first login. Please contact us at contact@ccrmanager.com for any assistance.</p> <p></p> <p>Regards,</p> <p>CCRManager</p>', 'CCRManager: You have been registered with reference number ${entity.ccrmBizEntityRefNo}', 0, 'Entity Creation Template');
  6. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (6, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'CCRMENTEG_WELCOME', null, '<p>Thank you for completing the user registration. You can now login to CCRM using User Name and Password mentioned below.</p>
  7. <p></p>
  8. <p>Regards,</p>
  9. <p>CCRM Administrator</p>', 'Welcome to CCRM', 0, 'User Registration Welcome Template');
  10. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (7, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'RESET_PWD', null, '<p>Your password was reset successfully. You can now login to the Correspondent Services module using the new password:</p><p></p><p><b>${entity.loginPass}</b></p><p></p><p>You will be required to change your password upon login. Please contact us at contact@ccrmanager.com for any assistance.</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Password Reset', 0, 'Reset Password Template');
  11. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (8, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'OTP', null, '<p>Use CCRManager One-Time Password (OTP) ${otp} within five minutes before it expires.</p><p>Password will expire on ${otpexpiry}</p>
  12. <p></p>
  13. <p>Regards,</p>
  14. <p>CCRManager</p>', 'CCRManager : One-Time Password (OTP)', 0, 'One-time Password Template');
  15. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (9, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'DOC_DOWNLOAD', null, '<p>Please find attached your requested document.</p>
  16. <p>The document is password protected. The default password is your attachment password in DDMMYYYY format.</p>
  17. <p></p>
  18. <p>Regards,</p>
  19. <p>CCRManager</p>', 'CCRManager: Requested Document', 0, 'Document Download Template');
  20. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (10, 0, -1, null, '2017-02-17 12:47:27', -1, null, '2017-02-17 12:47:27', 0, 1, 'ASSET_XLS_UPLD_LOG', null, '<p>The asset upload process is complete.</p><p>Upload Ref Number: ${refNum}</p><p>Successful upload count: ${uploadCount}</p><p>Unsuccessful upload count: ${failedUploadCount}</p><p>${log}</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Asset upload completed', 0, 'Asset excel upload log template');
  21. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (11, 0, -1, null, '2017-02-20 15:10:22', -1, null, '2017-02-20 15:10:22', 0, 1, 'INVITE_CONTACT', null, '${Message_Body}', 'CCRManager: New transaction from ${Full_Legal_Entity_Name}', 0, 'Participation Invitation Template');
  22. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (12, 0, -1, null, '2017-03-29 18:23:26', -1, null, '2017-03-29 18:23:26', 0, 1, 'INVITATION', null, '<p>Greetings</p> <p>${entity.firstName} ${entity.lastName} from ${entity.fullLegalName} has invited you to <a target="_blank" href="${registrationUrl}">register</a> on CCRManager. CCRManager (<a target="_blank" href="http://www.ccrmanager.com">www.ccrmanager.com</a>) is a digital platform for connecting Letters of Credit Issuing and Confirming Banks. ${entity.fullLegalName} is one of the members of CCRManager.</p>
  23. <p>Regards,</p> <p>CCRManager</p><p></p><p>Tel No: +65 62091450</p><p>Email: joietay@ccrmanager.com</p><p>Email: derekong@ccrmanager.com</p>', 'CCRManager: Invitation to become a Member of Correspondent Services Module', 0, 'Invitation Template');
  24. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (13, 0, -1, null, '2017-03-26 15:10:22', -1, null, '2017-03-26 15:10:22', 0, 1, 'CCRMUSER_CREATION', null, '<p>Your Administrator assigned the following role(s) on the Correspondent Services module:</p><p></p><p>Role(s): ${entity.userRolesForDisplay}</p><p></p><p>Please login to the system using User Name and Password below:</p><p></p><p>User Name:<br /><b>${entity.userName}</b></p><p>Password:<br /><b>${entity.loginPass}</b></p><p></p><p>You will be required to change your password upon first login. Please contact your Administrator(${entity.beAdminEmail}) for any assistance. If you require further assistance, please contact us at contact@ccrmanager.com.</p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Your Administrator has created an account for you', 0, 'User Creation Template');
  25. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (14, 0, -1, null, '2017-05-25 10:40:17', -1, null, '2017-05-25 16:11:30', 1, 1, 'PASSWORD_REMINDER', null, '<p>Your Password for the Correspondent Services module will expire in ${messageDays}. Please login to the system and change your password.<p>If you require further assistance, please contact us at contact@ccrmanager.com.</p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Your password will expire ${messageDays}', 0, 'Password Expiry Reminder');
  26. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (15, 0, -1, null, '2017-05-25 10:40:17', -1, null, '2017-05-25 16:11:30', 2, 1, 'PASSWORD_EXPIRED', null, '<p>Your Password for the Correspondent Services module has expired.<p>Please contact your Administrator to reset your password. If you require further assistance, please contact us at contact@ccrmanager.com.</p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Your password has expired', 0, 'Password Expired');
  27. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (16, 0, -1, null, '2017-06-09 11:12:10', -1, null, '2017-06-09 11:12:10', 0, 1, 'HISTORICAL_UPLD', null, '<p>The historical upload process is complete.</p> <p>Please find attached error log.</p> <p>The document is password protected. The default password is your date of birth in DDMMYYYY format unless otherwise set by you.</p> <p></p> <p>Regards,</p> <p>CCRManager</p>', 'CCRManager: Historical Upload Completed', 0, 'Historical Upload Template');
  28. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (17, 0, -1, null, '2017-06-09 11:12:10', -1, null, '2017-06-09 11:12:10', 0, 1, 'HIS_UPLD_EXPIRED', null, '<p>The historical pre-upload data is discarded as no action for ${expdays} days.</p> <p>Please re-upload again.</p> <p></p> <p>Regards,</p> <p>CCRManager</p>', 'CCRManager: Historical Pre-Upload Expired', 0, 'Historical Pre-Upload Expired');
  29. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (18, 0, -1, 'KPMG KPMG', '2017-08-02 16:51:28', 8, 'ccrmadm7 ccrmadm7', '2017-08-30 17:23:46', 8, 1, 'TS_REVIEW', null, '<p>You have received a Term Sheet for your action. Please log in to <a href="${ccrmUrl}" target="_blank">${ccrmUrl}</a> and review the transaction.</p>', 'CCRManager: Review the TS received [${distributionReferenceNo}]', 0, 'TS Review');
  30. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (19, 0, -1, 'Gerrard Slip', '2017-08-02 16:51:28', 279, 'Gerrard Slip', '2017-08-29 16:55:45', 1, 1, 'TS_APPROVE', null, '<p>You have received a Term Sheet for your action. Please log in to <a href="${ccrmUrl}" target="_blank">${ccrmUrl}</a> and approve the transaction.</p>', 'CCRManager: Approve the TS received [${distributionReferenceNo}]', 0, 'TS Approve');
  31. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (20, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'TS_CHECKER_RETURN', null, '<p>You have received a Term Sheet for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: TS returned by Checker [${distributionReferenceNo}]', 0, 'TS Returned by Checker');
  32. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (21, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'TS_APPROVER_RETURN', null, '<p>You have received a Term Sheet for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: TS returned by Approver [${distributionReferenceNo}]', 0, 'TS Returned by Approver');
  33. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (22, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'TSO_RESPONSE', null, '<p>You have received a response for Term Sheet [${distributionReferenceNo}] from ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the transaction.</p>', 'CCRManager: Negotiate terms of TS [${distributionReferenceNo}]', 0, 'TSO Response');
  34. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (23, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'TS_REJECT', null, '<p>Term Sheet for [${distributionReferenceNo}] has been rejected by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: TS rejected by ${businessEntityName} [${distributionReferenceNo}]', 0, 'TS Reject');
  35. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (24, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'TS_MOVE_TO_PC', null, '<p>Term Sheet for [${distributionReferenceNo}] is ready to move to PC. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: TS accepted is ready to move to PC [${distributionReferenceNo}]', 0, 'TS Move to PC');
  36. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (25, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'TSO_NEW_OFFER', null, '<p>You have received a new Term Sheet from ${grantorBizEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> to respond to the offer.</p>', 'CCRManager: TS received from ${grantorBizEntityName} [${distributionReferenceNo}]', 0, 'TSO New Offer');
  37. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (26, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_DRAFT', null, '<p>You have a draft Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete the Participation Certificate.</p>', 'CCRManager: Create PC [${distributionReferenceNo}]', 0, 'Draft PC');
  38. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (27, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_REVIEW', null, '<p>You have received a Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and review the transaction.</p>', 'CCRManager: Review the PC received [${distributionReferenceNo}]', 0, 'PC Review');
  39. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (28, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_APPROVE', null, '<p>You have received a Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and approve the transaction.</p>', 'CCRManager: Approve the PC received [${distributionReferenceNo}]', 0, 'PC Approve');
  40. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (29, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_CHECKER_RETURN', null, '<p>You have received a Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: PC returned by Checker [${distributionReferenceNo}]', 0, 'PC Returned by Checker');
  41. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (30, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_APPROVER_RETURN', null, '<p>You have received a Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: PC returned by Approver [${distributionReferenceNo}]', 0, 'PC Returned by Approver');
  42. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (31, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_RESPONSE', null, '<p>You have received a response for Participation Certificate [${distributionReferenceNo}]. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the offer.</p>', 'CCRManager: Please negotiate terms of PC [${distributionReferenceNo}]', 0, 'PC Response');
  43. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (32, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_REJECT', null, '<p>Your Participation Certification has been rejected by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: PC rejected by ${businessEntityName} [${distributionReferenceNo}]', 0, 'PC Reject');
  44. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (33, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'PC_NEW_OFFER', null, '<p>You have received a new PC from ${grantorBizEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the offer.</p>', 'CCRManager: PC received from ${grantorBizEntityName} [${distributionReferenceNo}]', 0, 'PC New Offer');
  45. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (34, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'FIXDTINIT', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fix Date Initial');
  46. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (35, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'FIXDTNEGO', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fix Date Negotiation');
  47. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (36, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'FIXRTINIT', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fix Rate Initial');
  48. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (37, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'FIXRTNEGO', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fix Rate Negotiation');
  49. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (38, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'FCFRM', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Funding Confirmation');
  50. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (39, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'FACKN', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Funding Acknowledgment');
  51. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (40, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'CPMF', null, '<p>You have a pending task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Payment on Maturity Confirmation');
  52. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (41, 0, -1, null, '2017-08-02 16:51:28', -1, null, '2017-08-02 16:51:28', 0, 1, 'APRMF', null, '<p>You have a pending task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Payment on Maturity Acknowledgment');
  53. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (42, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'FPC', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fee Payment Confirmation');
  54. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (43, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'FPA', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fee Payment Acknowledgment');
  55. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (44, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'DDINIT', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Drawdown Initial');
  56. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (45, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'DDNEGO', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Drawdown Negotiation');
  57. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (46, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'FXDRINT', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fixing Date/Rate for Rate Tenor Initial');
  58. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (47, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'FXDRNGO', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Fixing Date/Rate for Rate Tenor Negotiation');
  59. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (48, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'ACK_CPMF', null, '<p>${businessEntityName} has paid ${currency} ${amount} for ${distributionReferenceNo}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and verify.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Grantor payment confirmation on maturity');
  60. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (49, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'ACK_FCFRM', null, '<p>${businessEntityName} has paid ${currency} ${amount} for ${distributionReferenceNo}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and verify.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Participant payment confirmation on maturity');
  61. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (50, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'ACK_FPC', null, '<p>${businessEntityName} has paid ${currency} ${amount} for ${distributionReferenceNo}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and verify.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Grantor fee payment confirmation');
  62. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (51, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'DM_COMP_TEMPLATE', null, '<p>CCRManager has uploaded your Participation Certificate template. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and acknowledge the template.</p>', 'CCRManager: Acknowledge PC template', 0, 'Doc Mgmt Complete Template');
  63. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (52, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'DM_UPLOAD', null, '<p>You have linked up with ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> to upload a Participation Certificate template.</p>', 'CCRManager: Upload PC template', 0, 'Doc Mgmt Upload');
  64. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (53, 0, -1, null, '2017-08-02 16:51:29', -1, null, '2017-08-02 16:51:29', 0, 1, 'PC_TRADE_CONFIRM', null, '<p>Your PC [${distributionReferenceNo}] has been executed ${onlineOffline}. Please log in <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> to for more information.</p>', 'CCRManager: PC has been executed [${distributionReferenceNo}]', 0, 'Trade Confirmation');
  65. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (54, 0, -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', 0, 1, 'DM_UPLOAD_TEMPLATE', 'Upload Template', '<p>${businessEntityName} has uploaded a Participation Certificate template. Please log in to create and upload the template.</p>', 'CCRManager: Upload schedule for ${businessEntityName}', 0, 'Upload Template');
  66. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (55, 0, -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', 0, 1, 'DM_RTRN_TEMPLATE', 'Return Template', '<p>${businessEntityName} has made a change to Participation Certificate template. Please log in to create and upload the new template.</p>', 'CCRManager: Change schedule for ${businessEntityName}', 0, 'Return Template');
  67. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (56, 0, -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', 0, 1, 'DM_ACK_TEMPLATE', 'Acknowledge Template', '<p>${businessEntityName} has acknowledged a Participation Certificate template. </p>', 'CCRManager: Acknowledged schedule for ${businessEntityName}', 0, 'Acknowledge Template');
  68. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (57, 0, -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', 0, 1, 'DM_RECV_NEGO', 'Document Upload', '<p>You have received a document from ${businessEntityName}. Please log in to <a href="${ccrmUrl}" target="_blank">${ccrmUrl}</a> and respond.</p>', 'CCRManager: Start document negotiation', 0, 'Document Upload');
  69. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (58, 0, -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', 0, 1, 'DM_ACC_NEGO', 'Document Accepted', '<p>${businessEntityName} has accepted your document. Please log in to <a href="${ccrmUrl}" target="_blank">${ccrmUrl}</a> for more information.</p>', 'CCRManager: Document accepted', 0, 'Document Accepted');
  70. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (59, 0, -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', 0, 1, 'DM_REJ_NEGO', 'Document Rejected', '<p>${businessEntityName} has rejected your document. Please log in to <a href="${ccrmUrl}" target="_blank">${ccrmUrl}</a> for more information.</p>', 'CCRManager: Document rejected', 0, 'Document Rejected');
  71. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (60, 0, -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', -1, 'ccrmadm1 ccrmadm1', '2017-10-02 18:56:38', 0, 1, 'DM_RTRN_NEGO', 'Document Negotiation', '<p>You have received a response on a document from ${businessEntityName}. Please log in to <a href="${ccrmUrl}" target="_blank">${ccrmUrl}</a> and respond.</p>', 'CCRManager: Document negotiation', 0, 'Document Negotiation');
  72. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (61, 0, -1, null, '2017-10-16 17:49:13', -1, null, '2017-10-16 17:49:13', 0, 1, 'AMD_TS_REVIEW', null, '<p>You have received an amended Term Sheet for your action. Please log in to ${ccrmUrl} and review the transaction.</p>', 'CCRManager: Review the amended TS received [${distributionReferenceNo}]', 0, 'Amended TS Review');
  73. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (62, 0, -1, null, '2017-10-16 17:49:13', -1, null, '2017-10-16 17:49:13', 0, 1, 'AMD_TS_APPROVE', null, '<p>You have received an amended Term Sheet for your action. Please log in to ${ccrmUrl} and approve the transaction.</p>', 'CCRManager: Approve the amended TS received [${distributionReferenceNo}]', 0, 'Amended TS Approval');
  74. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (63, 0, -1, null, '2017-10-16 17:49:13', -1, null, '2017-10-16 17:49:13', 0, 1, 'AMD_TS_CHECKER_RETN', null, '<p>You have received an amended Term Sheet for your action. Please log in to ${ccrmUrl} and edit the transaction.</p>', 'CCRManager: Amended TS returned by Checker [${distributionReferenceNo}]', 0, 'Amended TS Return by Checker');
  75. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (64, 0, -1, null, '2017-10-16 17:49:13', -1, null, '2017-10-16 17:49:13', 0, 1, 'AMD_TS_APPROVER_RETN', null, '<p>You have received an amended Term Sheet for your action. Please log in to ${ccrmUrl} and edit the transaction.</p>', 'CCRManager: Amended TS returned by Approver [${distributionReferenceNo}]', 0, 'Amended TS Return by Approver');
  76. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (65, 0, -1, null, '2017-10-16 17:49:13', -1, null, '2017-10-16 17:49:13', 0, 1, 'AMD_TS_REJECT', null, '<p>Your amended TS has been rejected by ${approverName}. Please log in to ${ccrmUrl} for more information.</p>', 'CCRManager: Amended TS rejected by Approver [${distributionReferenceNo}]', 0, 'Amended TS Rejected by Approver');
  77. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (66, 0, -1, null, '2017-10-16 17:49:13', -1, null, '2017-10-16 17:49:13', 0, 1, 'AMD_TSO_NEW_OFFER', null, '<p>You have received a new amended Term Sheet from ${grantorBizEntityName}. Please log in to ${ccrmUrl} and respond to the transaction.</p>', 'CCRManager: Amended TS received from [${grantorBizEntityName}]', 0, 'Amended TS Offer');
  78. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (67, 0, -1, null, '2017-10-16 17:49:13', -1, null, '2017-10-16 17:49:13', 0, 1, 'AMD_TSO_RESPONSE', null, '<p>You have received an amended response for Term Sheet [${distributionReferenceNo}] from ${grantorBizEntityName}. Please log in to ${ccrmUrl} for more information.</p>', 'CCRManager: Negotiate amended terms of TS [${distributionReferenceNo}]', 0, 'Amended TS Response');
  79. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (68, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_REV', null, '<p>You have received an amended Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and review the transaction.</p>', 'CCRManager: Review the amended PC received [${distributionReferenceNo}]', 0, 'Amended PC Review');
  80. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (69, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_APP', null, '<p>You have received an amended Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and approve the transaction.</p>', 'CCRManager: Approve the amended PC received [${distributionReferenceNo}]', 0, 'Amended PC Approval');
  81. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (70, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_CHKER_RET', null, '<p>You have received an amended Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: Amended PC returned by Checker [${distributionReferenceNo}]', 0, 'Amended PC Return by Checker');
  82. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (71, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_APP_RET', null, '<p>You have received an amended Participation Certificate for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: Amended PC returned by Approver [${distributionReferenceNo}]', 0, 'Amended PC Return by Approver');
  83. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (72, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_APP_REJ', null, '<p>Your amended Participation Certificate has been rejected by ${approverName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: Amended PC rejected by Approver [${distributionReferenceNo}]', 0, 'Amended PC Rejected by Approver');
  84. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (73, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD', null, '<p>You have received an amended Participation Certificate from ${bizEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> to respond to the offer.</p>', 'CCRManager: Amended PC received from ${bizEntityName} [${distributionReferenceNo}]', 0, 'Amended PC');
  85. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (74, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_RES', null, '<p>You have received an amended response for Participation Certificate [${distributionReferenceNo}] from ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the transaction.</p>', 'CCRManager: Negotiate amended terms of PC [${distributionReferenceNo}]', 0, 'Amended PC Response');
  86. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (75, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_REJ', null, '<p>Your amended Participation Certification has been rejected by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: Amended PC rejected by ${businessEntityName} [${distributionReferenceNo}]', 0, 'Amended PC Reject');
  87. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (76, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_ACP', null, '<p>${businessEntityName} has accepted your Participation Certificate. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: Participation Certificate accepted by ${businessEntityName}[${distributionReferenceNo}]', 0, 'PC Acceptance');
  88. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (77, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_ACP', null, '<p>${businessEntityName} has accepted your amended Participation Certificate. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager:Amended Participation Certificate accepted by ${businessEntityName}[${distributionReferenceNo}]', 0, 'Amended PC Acceptance');
  89. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (78, 0, -1, null, '2017-11-01 17:43:07', -1, null, '2017-11-01 17:43:07', 0, 1, 'PC_AMD_CONF_FUND', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Confirmation of Funding for Amended PC');
  90. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (79, 0, -1, null, '2017-11-01 17:43:08', -1, null, '2017-11-01 17:43:08', 0, 1, 'PC_AMD_ACK_FUND', null, '<p>You have a ${taskType} task on your dashboard. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete your task.</p>', 'CCRManager: ${taskType} [${distributionReferenceNo}]', 0, 'Acknowledgement of Funding for Amended PC');
  91. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (80, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_REVIEW', null, '<p>You have received a Term Sheet for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and review the transaction.</p>', 'CCRManager: Review the TS received [${distributionReferenceNo}]', 0, 'Corporate TS Review');
  92. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (81, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_APPROVE', null, '<p>You have received an Term Sheet for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and approve the transaction.</p>', 'CCRManager: Approve the TS received [${distributionReferenceNo}]', 0, 'Corporate TS Approval');
  93. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (82, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_CHECKER_RETN', null, '<p>You have received an Term Sheet for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: TS returned by Checker [${distributionReferenceNo}]', 0, 'Corporate TS Return by Checker');
  94. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (83, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_APPROVER_RETN', null, '<p>You have received an Term Sheet for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: TS returned by Approver [${distributionReferenceNo}]', 0, 'Corporate TS Return by Approver');
  95. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (84, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_REJECT', null, '<p>Term Sheet for [${distributionReferenceNo}] has been rejected by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: TS rejected by ${businessEntityName} [${distributionReferenceNo}]', 0, 'Corporate TS Rejected');
  96. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (85, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTSO_NEW_OFFER', null, '<p>You have received a new Term Sheet from ${grantorBizEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the transaction.</p>', 'CCRManager: TS received from ${grantorBizEntityName} [${distributionReferenceNo}]', 0, 'Corportae TS Offer');
  97. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (86, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTSO_RESPONSE', null, '<p>You have received a response for Term Sheet [${distributionReferenceNo}] from ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the transaction.</p>', 'CCRManager: Negotiate terms of TS [${distributionReferenceNo}]', 0, 'Corporate TS Response');
  98. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (87, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_MOVE_TO_RPA', null, '<p>Term Sheet for [${distributionReferenceNo}] is ready to move to RPA. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: TS is ready to move to RPA [${distributionReferenceNo}]', 0, 'Corporate TS Move to RPA');
  99. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (88, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_NEW_PUB', null, '<p>You have received new Enhanced Due Diligence information for TS [${distributionReferenceNo}]. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: EDD information received from ${grantorBizEntityName} for TS [${distributionReferenceNo}]', 0, 'New EDD by grantor');
  100. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (89, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_REP_PRI', null, '<p>You have received a response on Enhanced Due Diligence for TS [${distributionReferenceNo}]. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: EDD response received from ${grantorBizEntityName} for TS [${distributionReferenceNo}]', 0, 'EDD response by grantor');
  101. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (90, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_REP_PUB', null, '<p>You have received new Enhanced Due Diligence information for TS [${distributionReferenceNo}]. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: EDD information received from ${grantorBizEntityName} for TS [${distributionReferenceNo}]', 0, 'EDD public response grantor');
  102. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (91, 0, -1, null, '2017-12-15 17:48:32', -1, null, '2017-12-15 17:48:32', 0, 1, 'CTS_NEW_Q', null, '<p>You have received a question on Enhanced Due Diligence for TS [${distributionReferenceNo}]. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: EDD question received from ${ParticipantBizEntityName} for TS [${distributionReferenceNo}]', 0, 'EDD question by participant');
  103. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (92, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_DRAFT', null, '<p>You have a draft Risk Participation Agreement for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and complete the Risk Participation Agreement.</p>', 'CCRManager: Draft RPA received [${distributionReferenceNo}]', 0, 'Draft RPA');
  104. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (93, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_REVIEW', null, '<p>You have received a Risk Participation Agreement for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and review the transaction.</p>', 'CCRManager: Review RPA received [${distributionReferenceNo}]', 0, 'RPA Review');
  105. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (94, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_APPROVE', null, '<p>You have received a Risk Participation Agreement for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and approve the transaction.</p>', 'CCRManager: Approve the RPA received [${distributionReferenceNo}]', 0, 'RPA Approve');
  106. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (95, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_CHECKER_RETURN', null, '<p>You have received a Risk Participation Agreement for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: RPA returned by Checker [${distributionReferenceNo}]', 0, 'RPA Returned by Checker');
  107. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (96, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_APPROVER_RETURN', null, '<p>You have received a Risk Participation Agreement for your action. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and edit the transaction.</p>', 'CCRManager: RPA returned by Approver [${distributionReferenceNo}]', 0, 'RPA Returned by Approver');
  108. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (97, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_APPROVER_REJECT', null, '<p>Your Risk Participation Agreement has been rejected internally. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: RPA rejected internally [${distributionReferenceNo}]', 0, 'RPA Rejected by Approver');
  109. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (98, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_NEW_OFFER', null, '<p>You have received a new RPA from ${grantorBizEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the offer.</p>', 'CCRManager: RPA received from ${grantorBizEntityName} [${distributionReferenceNo}]', 0, 'RPA New Offer');
  110. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (99, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_RESPONSE', null, '<p>You have received a response for Risk Participation Agreement [${distributionReferenceNo}]. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the offer.</p>', 'CCRManager: Please negotiate terms of RPA [${distributionReferenceNo}]', 0, 'RPA Response');
  111. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (100, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_REJECT', null, '<p>Your Risk Participation Agreement has been rejected by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: RPA rejected by ${businessEntityName} [${distributionReferenceNo}]', 0, 'RPA Reject');
  112. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (101, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_ACCEPT', null, '<p>Your RPA [${distributionReferenceNo}] has been accepted. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: RPA accepted by ${businessEntityName} [${distributionReferenceNo}]', 0, 'RPA Accept');
  113. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (102, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RPA_TRADE_CONFIRM', null, '<p>Your RPA [${distributionReferenceNo}] has been executed ${onlineOffline}. Please log in <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> to for more information.</p>', 'CCRManager: RPA has been executed [${distributionReferenceNo}]', 0, 'RPA Trade Confirmation');
  114. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (103, 0, -1, null, '2017-12-21 20:47:27', -1, null, '2017-12-21 20:47:27', 0, 1, 'CORP_ASSET_UPLD_LOG', null, '<p>Status of Asset Upload (Corporate Risk): </p><p>Successful Upload Count: ${uploadCount}</p><p>Unsuccessful Upload Count: ${failedUploadCount}</p><p>${log}</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Status of Asset Upload (Corporate Risk)', 0, 'Corp Asset excel upload log template');
  115. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (104, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-08 18:41:42', -1, 'ccrmadm1 ccrmadm1', '2018-01-08 18:41:42', 0, 1, 'DM_DELETE_SCHEDULE', 'Delete Schedule', '<p>Schedule Template ${scheduleName} has been deleted by Business Entity. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information</p>', 'CCRManager: Schedule Uploaded deleted [${scheduleName}]', 0, 'Schedule Deleted');
  116. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (105, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-08 18:41:42', -1, 'ccrmadm1 ccrmadm1', '2018-01-08 18:41:42', 0, 1, 'DM_UPLOAD_SYS_TEMP', 'Upload System Template', '<p>Schedule Template ${scheduleName} has been uploaded by CCRManager. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information</p>', 'CCRManager: System Template [${scheduleName}] Uploaded', 0, 'System Template Uploaded');
  117. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (106, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-08 18:41:42', -1, 'ccrmadm1 ccrmadm1', '2018-01-08 18:41:42', 0, 1, 'DM_UPDATE_SYS_TEMP', 'Update System Template', '<p>Schedule Template ${scheduleName} has been updated by CCRManager. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information</p>', 'CCRManager: System Template [${scheduleName}] Updated', 0, 'System Template Updated');
  118. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (107, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'GUESTUSER_CREATION', 'Guest User Creation', '<p>You have been assigned a Guest User role on CCRManager:</p><p>Please login to the system using User Name and Password below:</p><p></p><p>User Name:<br /><b>${entity.userName}</b></p><p>Password:<br /><b>${entity.loginPass}</b></p><p></p><p>You will be required to change your password upon first login. If you require further assistance, please contact us at contact@ccrmanager.com.</p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Guest user creation', 0, 'Guest User Creation');
  119. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (108, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'GUESTUSER_DECLINE', 'Guest User Rejection', '<p>Your request for ${firstName} ${lastName} (${emailAddress}) to be a Guest Member on CCRManager has been declined. For more information please log in to the system. For any assistance or feedback, please contact us at contact@ccrmanager.com.</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Guest user access rejection', 0, 'Guest User Rejection');
  120. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (109, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'GUESTUSER_APPROVE', 'Guest User Approval', '<p>Your request for ${firstName} ${lastName} (${emailAddress}) to be a Guest Member on CCRManager has been approved. The user will informed through the registered email on his/her username and first time login password. Thank you for using CCRManager. For any assistance or feedback, please contact us at contact@ccrmanager.com.</p><p></p><p>Regards,</p><p>CCRManager</p>', 'CCRManager: Guest user access approved', 0, 'Guest User Approval');
  121. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (110, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'GUESTUSER_SUBMIT', 'Guest User Submission', '<p>A guest user request has been sent from ${BizEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.</p>', 'CCRManager: New guest user request', 0, 'Guest User Submission');
  122. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (111, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'AST_UPLOAD_TEMPLATE', 'Upload Asset Template', '<p>${businessEntityName} has uploaded an asset template. Please log in to create and upload the template.</p>', 'CCRManager: Customise asset template for ${businessEntityName}', 0, 'Upload Asset Template');
  123. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (112, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'AST_COMP_TEMPLATE', 'Complete Asset Template', '<p>CCRManager has finished customising your asset template. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and acknowledge the template.</p>', 'CCRManager: Acknowledge asset template', 0, 'Completed Asset Template Mapping');
  124. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (113, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'AST_ACK_TEMPLATE', 'Acknowledge Asset Template', '<p>${businessEntityName} has acknowledged an asset template.</p>', 'CCRManager: Acknowledged template for ${businessEntityName}', 0, 'Acknowledge Asset Template');
  125. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (114, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'AST_RTRN_TEMPLATE', 'Return Asset Template', '<p>${businessEntityName} has returned the template. Please log in to change the customised template.</p>', 'CCRManager: Change the customised template for ${businessEntityName}', 0, 'Return Asset Template');
  126. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (115, 0, -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', -1, 'ccrmadm1 ccrmadm1', '2018-01-22 20:54:01', 0, 1, 'AST_DELETE_TEMPLATE', 'Delete Asset Template', '<p>${businessEntityName} deleted an asset template.</p>', 'CCRManager: Deleted asset template', 0, 'Delete Asset Template');
  127. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (116, 0, -1, null, '2017-03-29 18:23:26', -1, null, '2017-03-29 18:23:26', 0, 1, 'DECLINE_RFQ_OFFER', 'RFQ Offer Decline Email Template', '<p>Thank you for your quote under RFQ [${rfqReferenceNo}] of ${issuingBizEntityName}. However, your quote was not successful. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and view the details of the RFQ.
  128.  
  129. <p>-- This is an automatically generated email, please do not reply. --</p>', '${issuingBizEntityName}: RFQ Reference Number ${rfqReferenceNo} - Declined', 0, 'RFQ Decline Template');
  130. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (117, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RFQ_NEW_OFFER', 'RFQ New Offer Email Template', 'You have received a new Request for Quote(RFQ) from ${issuingBizEntityName} Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> to respond to the RFQ.', 'CCRManager: RFQ received from ${issuingBizEntityName} [${rfqReferenceNo}]', 0, 'RFQ New Offer Template');
  131. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (118, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RFQ_RESPONSE', 'RFQ Response Email Template', 'You have received a response to your RFQ [${rfqReferenceNo}] from ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and respond to the quote.', 'CCRManager: Negotiate RFQ [${rfqReferenceNo}]', 0, 'RFQ Response Template');
  132. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (119, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RFQ_REQUOTE', 'RFQ Requote Email Template', 'You have received a request to requote for RFQ [${rfqReferenceNo}] from ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> and give a new quote to the RFQ.', 'CCRManager: Requote RFQ [${rfqReferenceNo}]', 0, 'RFQ Requote Template');
  133. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (120, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RFQ_ACCEPT', 'RFQ Accept Email Template', 'Your quote for [${rfqReferenceNo}] has been accepted by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.', 'CCRManager: Quote accepted by ${businessEntityName} [${rfqReferenceNo}]', 0, 'RFQ Accept Template');
  134. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (121, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RFQ_QUOTE_CANCEL', 'RFQ Quote Cancel Email Template', 'Your previously accepted quote for [${rfqReferenceNo}] has been cancelled by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.', 'CCRManager: Quote cancelled by ${businessEntityName} [${rfqReferenceNo}]', 0, 'RFQ Quote Cancel Template');
  135. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (122, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'RFQ_CANCEL', 'RFQ Cancel Email Template', 'RFQ for [${rfqReferenceNo}] has been cancelled by ${businessEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">${ccrmUrl}</a> for more information.', 'CCRManager: RFQ cancelled by ${businessEntityName} [${rfqReferenceNo}]', 0, 'RFQ Cancel Template');
  136. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (123, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'CONTACT_DOWNLOAD', 'Contact Upload Template Download', '<p>Please use attached template to upload your Contacts.</p>
  137. <p>The document is password protected. The default password is your attachment password in DDMMYYYY format.</p>
  138. <p></p>
  139. <p>Regards,</p>
  140. <p>CCRManager</p>', 'CCRManager: Requested Contact Template', 0, 'Contact Upload Template Download');
  141. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (124, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'TERMS_ACCEPTED', 'Personal Data Consent', '<p>${entity.firstName} ${entity.lastName} from ${entity.fullLegalName} has responded ${consentResponse} to the personal data consent for the Correspondent Services Module.</p>', 'CCRManager: Personal Data Consent Response', 0, 'Personal Data Consent');
  142. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (125, 0, -1, null, '2017-03-29 18:23:26', -1, null, '2017-03-29 18:23:26', 0, 1, 'IB_INVITE_CONTACT', null, '<p></p><p>Greetings from CCRManager!</p><p></p><p>${entity.firstName} ${entity.lastName} from ${entity.fullLegalName} has invited you to <a href="${registrationUrl}" target="_blank">register</a> on CCRManager (<a target="_blank" href="https://www.ccrmanager.com/">www.ccrmanager.com</a>). As a Confirming Bank, you will be receiving requests via CCRManager from Issuing Banks for providing confirmation & discounting quotes.</p><p>The benefits of you joining CCRManager as a Confirming Bank are:</p><ul><li>No cost to sign up</li><li>Opportunity to respond to pricing request from our network of Issuing Banks</li><li>Proactively solicit additional business</li></ul>
  143. <p>If you wish to, you can also register as an Issuing Bank and request for confirmation and discounting quotes for letters of credit issued by you.</p>
  144. <p>To find out more, please contact us.</p><br/>
  145. <p>Regards,</p><p>Joie Tay & Derek Ong</p><p>CCRManager</p><p>Tel No: +65 62091450</p><p>Email: joietay@ccrmanager.com</p><p>Email: derekong@ccrmanager.com</p>', '${entity.fullLegalName} invites you to join CCRManager.', 0, 'Contact Invitation Template By Issuing Bank');
  146. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (126, 0, -1, null, '2017-03-29 18:23:26', -1, null, '2017-03-29 18:23:26', 0, 1, 'CB_INVITE_CONTACT', null, '<p></p><p>Greetings from CCRManager!</p><p></p><p>${entity.firstName} ${entity.lastName} from ${entity.fullLegalName} has invited you to <a href="${registrationUrl}" target="_blank">register</a> on CCRManager (<a target="_blank" href="https://www.ccrmanager.com/">www.ccrmanager.com</a>). As an Issuing Bank, you are able to seek confirmation & discounting quotes from ${entity.fullLegalName} and your other correspondents.</p><p> If you wish to, you can also register as a Confirming Bank and respond to pricing requests from other Issuing Banks.</p><p>To join CCRManager or for more information on the benefits of an Issuing & Confirming bank, please contact us.</p><p>Regards,</p><p>Joie Tay & Derek Ong</p><p>CCRManager</p><p>Tel No: +65 62091450</p><p>Email: joietay@ccrmanager.com</p><p>Email: derekong@ccrmanager.com</p>', '${entity.fullLegalName} invites you to join CCRManager.', 0, 'Contact Invitation Template By Confirming Bank');
  147. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (127, 0, -1, 'SYSTEM', '2018-06-29 10:28:09', -1, 'SYSTEM', '2018-06-29 10:28:09', 0, 1, 'USER_DELETE', null, '<p>The account of ${username} has been deleted on the CCRManager platform.</p><p>Account deleted by: ${ccrmadmin}</p>', 'CCRManager: User has been deleted', 0, 'User Delete Template');
  148. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (128, 0, -1, 'SYSTEM', '2018-06-29 10:28:24', -1, 'SYSTEM', '2018-06-29 10:28:24', 0, 1, 'GDPR_RESPONSE', 'Personal Data Consent', '<p>${entity.firstName} ${entity.lastName} from ${fullLegalName} has responded <b>${consentResponse}</b> to the personal data consent for the Correspondent Services Module.</p>
  149. $if{!checklist.isEmpty()}
  150. <p>Below are the list of items they checked:<br/>${checklist}</p>
  151. $end{}', 'CCRManager: Personal Data Consent Response', 0, 'Personal Data Consent');
  152. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (129, 0, -1, 'SYSTEM', '2018-07-13 08:54:35', -1, 'SYSTEM', '2018-07-13 08:54:35', 0, 1, 'WHITELIST_ENABLED', null, '<p>The below whitelisted IP addresses have been Enabled.</p><br />
  153. ${ipAddresses}
  154. <p>CCRManager Platform can only be accessed through the above IP addresses.</p>', 'CCRManager: IP Whitelisting Enabled', 0, 'IP Whitelisting Enabled Template');
  155. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (130, 0, -1, 'SYSTEM', '2018-07-13 08:54:41', -1, 'SYSTEM', '2018-07-13 08:54:41', 0, 1, 'WHITELIST_DISABLED', null, '<p>The IP Whitelisting has been Disabled.</p>', 'CCRManager: IP Whitelisting Disabled', 0, 'IP Whitelisting Disabled Template');
  156. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (131, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'BANKS_DOWNLOAD', 'Issuing Banks Template Download', '<p>Please use attached template to upload your Issuing Banks.</p>
  157. <p>The document is password protected. The default password is your attachment password in DDMMYYYY format.</p>
  158. <p></p>
  159. <p>Regards,</p>
  160. <p>CCRManager</p>', 'CCRManager: Requested Issuing Bank Template Download', 0, 'Issuing Bank Template Download');
  161. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (132, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'BANKS_DOWNLOAD', 'Issuing Banks Template Download', '<p>Please use attached template to upload your Issuing Banks.</p>
  162. <p>The document is password protected. The default password is your attachment password in DDMMYYYY format.</p>
  163. <p></p>
  164. <p>Regards,</p>
  165. <p>CCRManager</p>', 'CCRManager: Requested Issuing Bank Template Download', 0, 'Issuing Bank Template Download');
  166. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (133, 0, -1, null, '2018-09-06 10:19:53', -1, null, '2018-09-06 10:19:53', 0, 1, 'BANK_PROFILE_UPDATE', 'Update Bank Profile Email Template', 'Solicit Bank Profile for [${rfqReferenceNo}] has been updated by ${loginUserName}. Please log in to CCRM platform for more information.', 'CCRManager: Solicit Bank Profile Updated by ${loginUserName}', 0, 'Solicit Bank Profile Update Template');
  167. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (134, 0, -1, null, '2018-09-06 10:19:53', -1, null, '2018-09-06 10:19:53', 0, 1, 'BANK_PROFILE_UPDATE', 'Update Bank Profile Email Template', 'Solicit Bank Profile for [${rfqReferenceNo}] has been updated by ${loginUserName}. Please log in to CCRM platform for more information.', 'CCRManager: Solicit Bank Profile Updated by ${loginUserName}', 0, 'Solicit Bank Profile Update Template');
  168. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (135, 0, -1, null, '2017-02-21 22:36:47', -1, null, '2017-02-21 22:36:47', 0, 1, 'KEYWORDS_DOWNLOAD', 'Beneficiary Keywords Template Download', '<p>Please use attached template to upload your Beneficiary Keywords.</p>
  169.  
  170. <p>The document is password protected. The default password is your attachment password in DDMMYYYY format.</p>
  171.  
  172. <p></p>
  173.  
  174. <p>Regards,</p>
  175.  
  176. <p>CCRManager</p>', 'CCRManager: Requested Beneficiary Keywords Template', 0, 'Beneficiary Keywords Template Download');
  177. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (136, 0, -1, null, '2017-12-15 17:48:33', -1, null, '2017-12-15 17:48:33', 0, 1, 'CLIENT_TEAM_DRAFT', 'RFQ New Draft Email Template', '<p>A new RFQ has been created. Details of the RFQ are as follows: <br /> <br /> <table border="1"><th colspan="2">${rfqReferenceNo} ${lcType}</th><th colspan="2">${lcCurrency} ${lcValue}</th><th colspan="2">Applicant: ${applicantName}</th><th colspan="2">Beneficiary Country: ${beneficiaryCountry}</th><th colspan="2">Created By: ${createdBy}</th></table> <br /> <br />Please log in to <a target="_blank" href="${ccrmUrl}">Login</a> to take action on the RFQ.</p>', 'CCRM Manager: New RFQ ${rfqReferenceNo} has been created |Beneficiary Country : ${beneficiaryCountry}', 0, 'RFQ New Draft Template');
  178. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (137, 0, -1, null, '2018-10-02 07:16:02', -1, null, '2018-10-02 07:15:58', 0, 1, 'CLIENT_TEAM_SELECT', '', 'A preferred RFQ Offer has been selected by ${confirmingBizEntityName}. Please log in to <a target="_blank" href="${ccrmUrl}">Login</a> to take action on the RFQ.', 'CCRManager: Preferred RFQ Offer for ${rfqReferenceNo} has been selected', 0, 'RFQ Client Selected');
  179. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (139, 0, -1, null, '2018-10-02 07:17:09', -1, null, '2018-10-02 07:17:08', 0, 1, 'CLIENT_TEAM_CANCEL', null, 'A preferred RFQ Offer has been deselected by ${confirmingBizEntityName}.<br /> Please log in to <a target="_blank" href="${ccrmUrl}">Login</a> to take action on the RFQ.', 'CCRManager: Preferred RFQ Offer for ${rfqReferenceNo} has been deselected', 0, 'RFQ Client Canceled');
  180. INSERT INTO `ccrm-cb`.cb_notification_message_template (id, entity_state_id, created_by, created_by_user_name, created_date, updated_by, updated_by_user_name, updated_date, version, tenant_id, code, description, message_body, message_title, message_type, name) VALUES (140, 0, -1, null, '2018-10-02 07:17:55', -1, null, '2018-10-02 07:17:51', 0, 1, 'FI_TEAM_ACCEPT', null, 'RFQ Offer has been accepted by ${confirmingBizEntityName}. <br /> Please log in to <a target="_blank" href="${ccrmUrl}">Login</a> for details.', 'CCRManager: RFQ Offer ${rfqReferenceNo} has been selected', 0, 'RFQ Client Accepted');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!