INSERT INTO `tblemailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
(1676, 'estimate_request', 'estimate-request-assigned', 'catalan', 'Estimate Request Assigned (Sent to Staff) [catalan]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1677, 'estimate_request', 'estimate-request-received-to-user', 'catalan', 'Estimate Request Received (Sent to User) [catalan]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(1678, 'notifications', 'non-billed-tasks-reminder', 'catalan', 'Non-billed tasks reminder (sent to selected staff members) [catalan]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(1679, 'invoice', 'invoices-batch-payments', 'catalan', 'Invoices Payments Recorded in Batch (Sent to Customer) [catalan]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(1680, 'contract', 'contract-sign-reminder', 'catalan', 'Contract Sign Reminder (Sent to Customer) [catalan]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1681, 'purchase_order', 'purchase-order-to-contact', 'catalan', 'Purchase Order (Sent to contact) [catalan]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1682, 'purchase_order', 'purchase-request-to-contact', 'catalan', 'Purchase Request (Sent to contact) [catalan]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1683, 'purchase_order', 'purchase-quotation-to-contact', 'catalan', 'Purchase Quotation (Sent to contact) [catalan]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1684, 'purchase_order', 'debit-note-to-contact', 'catalan', 'Debit Note (Sent to contact) [catalan]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1685, 'purchase_order', 'purchase-statement-to-contact', 'catalan', 'Purchase Statement (Sent to contact) [catalan]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1686, 'inventory_warning', 'inventory-warning-to-staff', 'catalan', 'Inventory warning (Sent to staff) [catalan]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1687, 'purchase_order', 'vendor-registration-confirmed', 'catalan', 'Vendor Registration Confirmed [catalan]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1688, 'purchase_order', 'purchase-contract-to-contact', 'catalan', 'Purchase Contract (Sent to contact) [catalan]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1689, 'purchase_order', 'new-contact-created', 'catalan', 'New Contact Added/Registered (Welcome Email) [catalan]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1690, 'purchase_order', 'purchase-request-approval', 'catalan', 'Request approval [catalan]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1691, 'purchase_order', 'purchase-send-approved', 'catalan', 'Email send approved [catalan]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1692, 'purchase_order', 'purchase-send-rejected', 'catalan', 'Email send rejected [catalan]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1693, 'client', 'new-client-created', 'portuguese_br', 'New Contact Added/Registered (Welcome Email) [portuguese_br]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1694, 'invoice', 'invoice-send-to-client', 'portuguese_br', 'Send Invoice to Customer [portuguese_br]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1695, 'ticket', 'new-ticket-opened-admin', 'portuguese_br', 'New Ticket Opened (Opened by Staff, Sent to Customer) [portuguese_br]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(1696, 'ticket', 'ticket-reply', 'portuguese_br', 'Ticket Reply (Sent to Customer) [portuguese_br]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(1697, 'ticket', 'ticket-autoresponse', 'portuguese_br', 'New Ticket Opened - Autoresponse [portuguese_br]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(1698, 'invoice', 'invoice-payment-recorded', 'portuguese_br', 'Invoice Payment Recorded (Sent to Customer) [portuguese_br]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(1699, 'invoice', 'invoice-overdue-notice', 'portuguese_br', 'Invoice Overdue Notice [portuguese_br]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(1700, 'invoice', 'invoice-already-send', 'portuguese_br', 'Invoice Already Sent to Customer [portuguese_br]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1701, 'ticket', 'new-ticket-created-staff', 'portuguese_br', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [portuguese_br]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(1702, 'estimate', 'estimate-send-to-client', 'portuguese_br', 'Send Estimate to Customer [portuguese_br]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1703, 'ticket', 'ticket-reply-to-admin', 'portuguese_br', 'Ticket Reply (Sent to Staff) [portuguese_br]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(1704, 'estimate', 'estimate-already-send', 'portuguese_br', 'Estimate Already Sent to Customer [portuguese_br]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1705, 'contract', 'contract-expiration', 'portuguese_br', 'Contract Expiration Reminder (Sent to Customer Contacts) [portuguese_br]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1706, 'tasks', 'task-assigned', 'portuguese_br', 'New Task Assigned (Sent to Staff) [portuguese_br]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1707, 'tasks', 'task-added-as-follower', 'portuguese_br', 'Staff Member Added as Follower on Task (Sent to Staff) [portuguese_br]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1708, 'tasks', 'task-commented', 'portuguese_br', 'New Comment on Task (Sent to Staff) [portuguese_br]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1709, 'tasks', 'task-added-attachment', 'portuguese_br', 'New Attachment(s) on Task (Sent to Staff) [portuguese_br]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1710, 'estimate', 'estimate-declined-to-staff', 'portuguese_br', 'Estimate Declined (Sent to Staff) [portuguese_br]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1711, 'estimate', 'estimate-accepted-to-staff', 'portuguese_br', 'Estimate Accepted (Sent to Staff) [portuguese_br]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1712, 'proposals', 'proposal-client-accepted', 'portuguese_br', 'Customer Action - Accepted (Sent to Staff) [portuguese_br]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1713, 'proposals', 'proposal-send-to-customer', 'portuguese_br', 'Send Proposal to Customer [portuguese_br]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1714, 'proposals', 'proposal-client-declined', 'portuguese_br', 'Customer Action - Declined (Sent to Staff) [portuguese_br]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1715, 'proposals', 'proposal-client-thank-you', 'portuguese_br', 'Thank You Email (Sent to Customer After Accept) [portuguese_br]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1716, 'proposals', 'proposal-comment-to-client', 'portuguese_br', 'New Comment  (Sent to Customer/Lead) [portuguese_br]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1717, 'proposals', 'proposal-comment-to-admin', 'portuguese_br', 'New Comment (Sent to Staff)  [portuguese_br]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1718, 'estimate', 'estimate-thank-you-to-customer', 'portuguese_br', 'Thank You Email (Sent to Customer After Accept) [portuguese_br]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1719, 'tasks', 'task-deadline-notification', 'portuguese_br', 'Task Deadline Reminder - Sent to Assigned Members [portuguese_br]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1720, 'contract', 'send-contract', 'portuguese_br', 'Send Contract to Customer [portuguese_br]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(1721, 'invoice', 'invoice-payment-recorded-to-staff', 'portuguese_br', 'Invoice Payment Recorded (Sent to Staff) [portuguese_br]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(1722, 'ticket', 'auto-close-ticket', 'portuguese_br', 'Auto Close Ticket [portuguese_br]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(1723, 'project', 'new-project-discussion-created-to-staff', 'portuguese_br', 'New Project Discussion (Sent to Project Members) [portuguese_br]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1724, 'project', 'new-project-discussion-created-to-customer', 'portuguese_br', 'New Project Discussion (Sent to Customer Contacts) [portuguese_br]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1725, 'project', 'new-project-file-uploaded-to-customer', 'portuguese_br', 'New Project File(s) Uploaded (Sent to Customer Contacts) [portuguese_br]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1726, 'project', 'new-project-file-uploaded-to-staff', 'portuguese_br', 'New Project File(s) Uploaded (Sent to Project Members) [portuguese_br]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1727, 'project', 'new-project-discussion-comment-to-customer', 'portuguese_br', 'New Discussion Comment  (Sent to Customer Contacts) [portuguese_br]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1728, 'project', 'new-project-discussion-comment-to-staff', 'portuguese_br', 'New Discussion Comment (Sent to Project Members) [portuguese_br]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1729, 'project', 'staff-added-as-project-member', 'portuguese_br', 'Staff Added as Project Member [portuguese_br]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1730, 'estimate', 'estimate-expiry-reminder', 'portuguese_br', 'Estimate Expiration Reminder [portuguese_br]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1731, 'proposals', 'proposal-expiry-reminder', 'portuguese_br', 'Proposal Expiration Reminder [portuguese_br]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1732, 'staff', 'new-staff-created', 'portuguese_br', 'New Staff Created (Welcome Email) [portuguese_br]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1733, 'client', 'contact-forgot-password', 'portuguese_br', 'Forgot Password [portuguese_br]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1734, 'client', 'contact-password-reseted', 'portuguese_br', 'Password Reset - Confirmation [portuguese_br]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1735, 'client', 'contact-set-password', 'portuguese_br', 'Set New Password [portuguese_br]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1736, 'staff', 'staff-forgot-password', 'portuguese_br', 'Forgot Password [portuguese_br]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1737, 'staff', 'staff-password-reseted', 'portuguese_br', 'Password Reset - Confirmation [portuguese_br]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1738, 'project', 'assigned-to-project', 'portuguese_br', 'New Project Created (Sent to Customer Contacts) [portuguese_br]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1739, 'tasks', 'task-added-attachment-to-contacts', 'portuguese_br', 'New Attachment(s) on Task (Sent to Customer Contacts) [portuguese_br]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1740, 'tasks', 'task-commented-to-contacts', 'portuguese_br', 'New Comment on Task (Sent to Customer Contacts) [portuguese_br]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1741, 'leads', 'new-lead-assigned', 'portuguese_br', 'New Lead Assigned to Staff Member [portuguese_br]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1742, 'client', 'client-statement', 'portuguese_br', 'Statement - Account Summary [portuguese_br]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1743, 'ticket', 'ticket-assigned-to-admin', 'portuguese_br', 'New Ticket Assigned (Sent to Staff) [portuguese_br]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(1744, 'client', 'new-client-registered-to-admin', 'portuguese_br', 'New Customer Registration (Sent to admins) [portuguese_br]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1745, 'leads', 'new-web-to-lead-form-submitted', 'portuguese_br', 'Web to lead form submitted - Sent to lead [portuguese_br]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(1746, 'staff', 'two-factor-authentication', 'portuguese_br', 'Two Factor Authentication [portuguese_br]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1747, 'project', 'project-finished-to-customer', 'portuguese_br', 'Project Marked as Finished (Sent to Customer Contacts) [portuguese_br]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1748, 'credit_note', 'credit-note-send-to-client', 'portuguese_br', 'Send Credit Note To Email [portuguese_br]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(1749, 'tasks', 'task-status-change-to-staff', 'portuguese_br', 'Task Status Changed (Sent to Staff) [portuguese_br]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(1750, 'tasks', 'task-status-change-to-contacts', 'portuguese_br', 'Task Status Changed (Sent to Customer Contacts) [portuguese_br]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(1751, 'staff', 'reminder-email-staff', 'portuguese_br', 'Staff Reminder Email [portuguese_br]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1752, 'contract', 'contract-comment-to-client', 'portuguese_br', 'New Comment  (Sent to Customer Contacts) [portuguese_br]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0),
(1753, 'contract', 'contract-comment-to-admin', 'portuguese_br', 'New Comment (Sent to Staff)  [portuguese_br]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(1754, 'subscriptions', 'send-subscription', 'portuguese_br', 'Send Subscription to Customer [portuguese_br]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(1755, 'subscriptions', 'subscription-payment-failed', 'portuguese_br', 'Subscription Payment Failed [portuguese_br]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(1756, 'subscriptions', 'subscription-canceled', 'portuguese_br', 'Subscription Canceled (Sent to customer primary contact) [portuguese_br]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(1757, 'subscriptions', 'subscription-payment-succeeded', 'portuguese_br', 'Subscription Payment Succeeded (Sent to customer primary contact) [portuguese_br]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1758, 'contract', 'contract-expiration-to-staff', 'portuguese_br', 'Contract Expiration Reminder (Sent to Staff) [portuguese_br]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1759, 'gdpr', 'gdpr-removal-request', 'portuguese_br', 'Removal Request From Contact (Sent to administrators) [portuguese_br]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1760, 'gdpr', 'gdpr-removal-request-lead', 'portuguese_br', 'Removal Request From Lead (Sent to administrators) [portuguese_br]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1761, 'client', 'client-registration-confirmed', 'portuguese_br', 'Customer Registration Confirmed [portuguese_br]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1762, 'contract', 'contract-signed-to-staff', 'portuguese_br', 'Contract Signed (Sent to Staff) [portuguese_br]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(1763, 'subscriptions', 'customer-subscribed-to-staff', 'portuguese_br', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [portuguese_br]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(1764, 'client', 'contact-verification-email', 'portuguese_br', 'Email Verification (Sent to Contact After Registration) [portuguese_br]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1765, 'client', 'new-customer-profile-file-uploaded-to-staff', 'portuguese_br', 'New Customer Profile File(s) Uploaded (Sent to Staff) [portuguese_br]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1766, 'staff', 'event-notification-to-staff', 'portuguese_br', 'Event Notification (Calendar) [portuguese_br]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(1767, 'subscriptions', 'subscription-payment-requires-action', 'portuguese_br', 'Credit Card Authorization Required - SCA [portuguese_br]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(1768, 'invoice', 'invoice-due-notice', 'portuguese_br', 'Invoice Due Notice [portuguese_br]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(1769, 'estimate_request', 'estimate-request-submitted-to-staff', 'portuguese_br', 'Estimate Request Submitted (Sent to Staff) [portuguese_br]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1770, 'estimate_request', 'estimate-request-assigned', 'portuguese_br', 'Estimate Request Assigned (Sent to Staff) [portuguese_br]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1771, 'estimate_request', 'estimate-request-received-to-user', 'portuguese_br', 'Estimate Request Received (Sent to User) [portuguese_br]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(1772, 'notifications', 'non-billed-tasks-reminder', 'portuguese_br', 'Non-billed tasks reminder (sent to selected staff members) [portuguese_br]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(1773, 'invoice', 'invoices-batch-payments', 'portuguese_br', 'Invoices Payments Recorded in Batch (Sent to Customer) [portuguese_br]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(1774, 'contract', 'contract-sign-reminder', 'portuguese_br', 'Contract Sign Reminder (Sent to Customer) [portuguese_br]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1775, 'purchase_order', 'purchase-order-to-contact', 'portuguese_br', 'Purchase Order (Sent to contact) [portuguese_br]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1776, 'purchase_order', 'purchase-request-to-contact', 'portuguese_br', 'Purchase Request (Sent to contact) [portuguese_br]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1777, 'purchase_order', 'purchase-quotation-to-contact', 'portuguese_br', 'Purchase Quotation (Sent to contact) [portuguese_br]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1778, 'purchase_order', 'debit-note-to-contact', 'portuguese_br', 'Debit Note (Sent to contact) [portuguese_br]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1779, 'purchase_order', 'purchase-statement-to-contact', 'portuguese_br', 'Purchase Statement (Sent to contact) [portuguese_br]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1780, 'inventory_warning', 'inventory-warning-to-staff', 'portuguese_br', 'Inventory warning (Sent to staff) [portuguese_br]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1781, 'purchase_order', 'vendor-registration-confirmed', 'portuguese_br', 'Vendor Registration Confirmed [portuguese_br]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1782, 'purchase_order', 'purchase-contract-to-contact', 'portuguese_br', 'Purchase Contract (Sent to contact) [portuguese_br]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1783, 'purchase_order', 'new-contact-created', 'portuguese_br', 'New Contact Added/Registered (Welcome Email) [portuguese_br]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1784, 'purchase_order', 'purchase-request-approval', 'portuguese_br', 'Request approval [portuguese_br]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1785, 'purchase_order', 'purchase-send-approved', 'portuguese_br', 'Email send approved [portuguese_br]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1786, 'purchase_order', 'purchase-send-rejected', 'portuguese_br', 'Email send rejected [portuguese_br]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1787, 'client', 'new-client-created', 'chinese', 'New Contact Added/Registered (Welcome Email) [chinese]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1788, 'invoice', 'invoice-send-to-client', 'chinese', 'Send Invoice to Customer [chinese]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1789, 'ticket', 'new-ticket-opened-admin', 'chinese', 'New Ticket Opened (Opened by Staff, Sent to Customer) [chinese]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(1790, 'ticket', 'ticket-reply', 'chinese', 'Ticket Reply (Sent to Customer) [chinese]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(1791, 'ticket', 'ticket-autoresponse', 'chinese', 'New Ticket Opened - Autoresponse [chinese]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(1792, 'invoice', 'invoice-payment-recorded', 'chinese', 'Invoice Payment Recorded (Sent to Customer) [chinese]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(1793, 'invoice', 'invoice-overdue-notice', 'chinese', 'Invoice Overdue Notice [chinese]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(1794, 'invoice', 'invoice-already-send', 'chinese', 'Invoice Already Sent to Customer [chinese]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1795, 'ticket', 'new-ticket-created-staff', 'chinese', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [chinese]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(1796, 'estimate', 'estimate-send-to-client', 'chinese', 'Send Estimate to Customer [chinese]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1797, 'ticket', 'ticket-reply-to-admin', 'chinese', 'Ticket Reply (Sent to Staff) [chinese]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(1798, 'estimate', 'estimate-already-send', 'chinese', 'Estimate Already Sent to Customer [chinese]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1799, 'contract', 'contract-expiration', 'chinese', 'Contract Expiration Reminder (Sent to Customer Contacts) [chinese]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1800, 'tasks', 'task-assigned', 'chinese', 'New Task Assigned (Sent to Staff) [chinese]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1801, 'tasks', 'task-added-as-follower', 'chinese', 'Staff Member Added as Follower on Task (Sent to Staff) [chinese]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1802, 'tasks', 'task-commented', 'chinese', 'New Comment on Task (Sent to Staff) [chinese]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1803, 'tasks', 'task-added-attachment', 'chinese', 'New Attachment(s) on Task (Sent to Staff) [chinese]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1804, 'estimate', 'estimate-declined-to-staff', 'chinese', 'Estimate Declined (Sent to Staff) [chinese]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1805, 'estimate', 'estimate-accepted-to-staff', 'chinese', 'Estimate Accepted (Sent to Staff) [chinese]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1806, 'proposals', 'proposal-client-accepted', 'chinese', 'Customer Action - Accepted (Sent to Staff) [chinese]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1807, 'proposals', 'proposal-send-to-customer', 'chinese', 'Send Proposal to Customer [chinese]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1808, 'proposals', 'proposal-client-declined', 'chinese', 'Customer Action - Declined (Sent to Staff) [chinese]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1809, 'proposals', 'proposal-client-thank-you', 'chinese', 'Thank You Email (Sent to Customer After Accept) [chinese]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1810, 'proposals', 'proposal-comment-to-client', 'chinese', 'New Comment  (Sent to Customer/Lead) [chinese]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1811, 'proposals', 'proposal-comment-to-admin', 'chinese', 'New Comment (Sent to Staff)  [chinese]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1812, 'estimate', 'estimate-thank-you-to-customer', 'chinese', 'Thank You Email (Sent to Customer After Accept) [chinese]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1813, 'tasks', 'task-deadline-notification', 'chinese', 'Task Deadline Reminder - Sent to Assigned Members [chinese]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1814, 'contract', 'send-contract', 'chinese', 'Send Contract to Customer [chinese]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(1815, 'invoice', 'invoice-payment-recorded-to-staff', 'chinese', 'Invoice Payment Recorded (Sent to Staff) [chinese]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(1816, 'ticket', 'auto-close-ticket', 'chinese', 'Auto Close Ticket [chinese]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(1817, 'project', 'new-project-discussion-created-to-staff', 'chinese', 'New Project Discussion (Sent to Project Members) [chinese]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1818, 'project', 'new-project-discussion-created-to-customer', 'chinese', 'New Project Discussion (Sent to Customer Contacts) [chinese]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1819, 'project', 'new-project-file-uploaded-to-customer', 'chinese', 'New Project File(s) Uploaded (Sent to Customer Contacts) [chinese]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1820, 'project', 'new-project-file-uploaded-to-staff', 'chinese', 'New Project File(s) Uploaded (Sent to Project Members) [chinese]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1821, 'project', 'new-project-discussion-comment-to-customer', 'chinese', 'New Discussion Comment  (Sent to Customer Contacts) [chinese]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1822, 'project', 'new-project-discussion-comment-to-staff', 'chinese', 'New Discussion Comment (Sent to Project Members) [chinese]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1823, 'project', 'staff-added-as-project-member', 'chinese', 'Staff Added as Project Member [chinese]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1824, 'estimate', 'estimate-expiry-reminder', 'chinese', 'Estimate Expiration Reminder [chinese]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1825, 'proposals', 'proposal-expiry-reminder', 'chinese', 'Proposal Expiration Reminder [chinese]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1826, 'staff', 'new-staff-created', 'chinese', 'New Staff Created (Welcome Email) [chinese]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1827, 'client', 'contact-forgot-password', 'chinese', 'Forgot Password [chinese]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1828, 'client', 'contact-password-reseted', 'chinese', 'Password Reset - Confirmation [chinese]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1829, 'client', 'contact-set-password', 'chinese', 'Set New Password [chinese]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1830, 'staff', 'staff-forgot-password', 'chinese', 'Forgot Password [chinese]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1831, 'staff', 'staff-password-reseted', 'chinese', 'Password Reset - Confirmation [chinese]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1832, 'project', 'assigned-to-project', 'chinese', 'New Project Created (Sent to Customer Contacts) [chinese]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1833, 'tasks', 'task-added-attachment-to-contacts', 'chinese', 'New Attachment(s) on Task (Sent to Customer Contacts) [chinese]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1834, 'tasks', 'task-commented-to-contacts', 'chinese', 'New Comment on Task (Sent to Customer Contacts) [chinese]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1835, 'leads', 'new-lead-assigned', 'chinese', 'New Lead Assigned to Staff Member [chinese]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1836, 'client', 'client-statement', 'chinese', 'Statement - Account Summary [chinese]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1837, 'ticket', 'ticket-assigned-to-admin', 'chinese', 'New Ticket Assigned (Sent to Staff) [chinese]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(1838, 'client', 'new-client-registered-to-admin', 'chinese', 'New Customer Registration (Sent to admins) [chinese]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1839, 'leads', 'new-web-to-lead-form-submitted', 'chinese', 'Web to lead form submitted - Sent to lead [chinese]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(1840, 'staff', 'two-factor-authentication', 'chinese', 'Two Factor Authentication [chinese]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1841, 'project', 'project-finished-to-customer', 'chinese', 'Project Marked as Finished (Sent to Customer Contacts) [chinese]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1842, 'credit_note', 'credit-note-send-to-client', 'chinese', 'Send Credit Note To Email [chinese]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(1843, 'tasks', 'task-status-change-to-staff', 'chinese', 'Task Status Changed (Sent to Staff) [chinese]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(1844, 'tasks', 'task-status-change-to-contacts', 'chinese', 'Task Status Changed (Sent to Customer Contacts) [chinese]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(1845, 'staff', 'reminder-email-staff', 'chinese', 'Staff Reminder Email [chinese]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1846, 'contract', 'contract-comment-to-client', 'chinese', 'New Comment  (Sent to Customer Contacts) [chinese]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0),
(1847, 'contract', 'contract-comment-to-admin', 'chinese', 'New Comment (Sent to Staff)  [chinese]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(1848, 'subscriptions', 'send-subscription', 'chinese', 'Send Subscription to Customer [chinese]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(1849, 'subscriptions', 'subscription-payment-failed', 'chinese', 'Subscription Payment Failed [chinese]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(1850, 'subscriptions', 'subscription-canceled', 'chinese', 'Subscription Canceled (Sent to customer primary contact) [chinese]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(1851, 'subscriptions', 'subscription-payment-succeeded', 'chinese', 'Subscription Payment Succeeded (Sent to customer primary contact) [chinese]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1852, 'contract', 'contract-expiration-to-staff', 'chinese', 'Contract Expiration Reminder (Sent to Staff) [chinese]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1853, 'gdpr', 'gdpr-removal-request', 'chinese', 'Removal Request From Contact (Sent to administrators) [chinese]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1854, 'gdpr', 'gdpr-removal-request-lead', 'chinese', 'Removal Request From Lead (Sent to administrators) [chinese]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1855, 'client', 'client-registration-confirmed', 'chinese', 'Customer Registration Confirmed [chinese]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1856, 'contract', 'contract-signed-to-staff', 'chinese', 'Contract Signed (Sent to Staff) [chinese]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(1857, 'subscriptions', 'customer-subscribed-to-staff', 'chinese', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [chinese]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(1858, 'client', 'contact-verification-email', 'chinese', 'Email Verification (Sent to Contact After Registration) [chinese]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1859, 'client', 'new-customer-profile-file-uploaded-to-staff', 'chinese', 'New Customer Profile File(s) Uploaded (Sent to Staff) [chinese]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1860, 'staff', 'event-notification-to-staff', 'chinese', 'Event Notification (Calendar) [chinese]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(1861, 'subscriptions', 'subscription-payment-requires-action', 'chinese', 'Credit Card Authorization Required - SCA [chinese]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(1862, 'invoice', 'invoice-due-notice', 'chinese', 'Invoice Due Notice [chinese]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(1863, 'estimate_request', 'estimate-request-submitted-to-staff', 'chinese', 'Estimate Request Submitted (Sent to Staff) [chinese]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1864, 'estimate_request', 'estimate-request-assigned', 'chinese', 'Estimate Request Assigned (Sent to Staff) [chinese]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1865, 'estimate_request', 'estimate-request-received-to-user', 'chinese', 'Estimate Request Received (Sent to User) [chinese]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(1866, 'notifications', 'non-billed-tasks-reminder', 'chinese', 'Non-billed tasks reminder (sent to selected staff members) [chinese]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(1867, 'invoice', 'invoices-batch-payments', 'chinese', 'Invoices Payments Recorded in Batch (Sent to Customer) [chinese]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(1868, 'contract', 'contract-sign-reminder', 'chinese', 'Contract Sign Reminder (Sent to Customer) [chinese]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1869, 'purchase_order', 'purchase-order-to-contact', 'chinese', 'Purchase Order (Sent to contact) [chinese]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1870, 'purchase_order', 'purchase-request-to-contact', 'chinese', 'Purchase Request (Sent to contact) [chinese]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1871, 'purchase_order', 'purchase-quotation-to-contact', 'chinese', 'Purchase Quotation (Sent to contact) [chinese]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1872, 'purchase_order', 'debit-note-to-contact', 'chinese', 'Debit Note (Sent to contact) [chinese]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1873, 'purchase_order', 'purchase-statement-to-contact', 'chinese', 'Purchase Statement (Sent to contact) [chinese]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1874, 'inventory_warning', 'inventory-warning-to-staff', 'chinese', 'Inventory warning (Sent to staff) [chinese]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1875, 'purchase_order', 'vendor-registration-confirmed', 'chinese', 'Vendor Registration Confirmed [chinese]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1876, 'purchase_order', 'purchase-contract-to-contact', 'chinese', 'Purchase Contract (Sent to contact) [chinese]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1877, 'purchase_order', 'new-contact-created', 'chinese', 'New Contact Added/Registered (Welcome Email) [chinese]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1878, 'purchase_order', 'purchase-request-approval', 'chinese', 'Request approval [chinese]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1879, 'purchase_order', 'purchase-send-approved', 'chinese', 'Email send approved [chinese]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1880, 'purchase_order', 'purchase-send-rejected', 'chinese', 'Email send rejected [chinese]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1881, 'client', 'new-client-created', 'finnish', 'New Contact Added/Registered (Welcome Email) [finnish]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1882, 'invoice', 'invoice-send-to-client', 'finnish', 'Send Invoice to Customer [finnish]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1883, 'ticket', 'new-ticket-opened-admin', 'finnish', 'New Ticket Opened (Opened by Staff, Sent to Customer) [finnish]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(1884, 'ticket', 'ticket-reply', 'finnish', 'Ticket Reply (Sent to Customer) [finnish]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(1885, 'ticket', 'ticket-autoresponse', 'finnish', 'New Ticket Opened - Autoresponse [finnish]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(1886, 'invoice', 'invoice-payment-recorded', 'finnish', 'Invoice Payment Recorded (Sent to Customer) [finnish]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(1887, 'invoice', 'invoice-overdue-notice', 'finnish', 'Invoice Overdue Notice [finnish]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(1888, 'invoice', 'invoice-already-send', 'finnish', 'Invoice Already Sent to Customer [finnish]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1889, 'ticket', 'new-ticket-created-staff', 'finnish', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [finnish]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(1890, 'estimate', 'estimate-send-to-client', 'finnish', 'Send Estimate to Customer [finnish]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1891, 'ticket', 'ticket-reply-to-admin', 'finnish', 'Ticket Reply (Sent to Staff) [finnish]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(1892, 'estimate', 'estimate-already-send', 'finnish', 'Estimate Already Sent to Customer [finnish]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1893, 'contract', 'contract-expiration', 'finnish', 'Contract Expiration Reminder (Sent to Customer Contacts) [finnish]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1894, 'tasks', 'task-assigned', 'finnish', 'New Task Assigned (Sent to Staff) [finnish]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1895, 'tasks', 'task-added-as-follower', 'finnish', 'Staff Member Added as Follower on Task (Sent to Staff) [finnish]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1896, 'tasks', 'task-commented', 'finnish', 'New Comment on Task (Sent to Staff) [finnish]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1897, 'tasks', 'task-added-attachment', 'finnish', 'New Attachment(s) on Task (Sent to Staff) [finnish]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1898, 'estimate', 'estimate-declined-to-staff', 'finnish', 'Estimate Declined (Sent to Staff) [finnish]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1899, 'estimate', 'estimate-accepted-to-staff', 'finnish', 'Estimate Accepted (Sent to Staff) [finnish]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1900, 'proposals', 'proposal-client-accepted', 'finnish', 'Customer Action - Accepted (Sent to Staff) [finnish]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1901, 'proposals', 'proposal-send-to-customer', 'finnish', 'Send Proposal to Customer [finnish]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1902, 'proposals', 'proposal-client-declined', 'finnish', 'Customer Action - Declined (Sent to Staff) [finnish]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1903, 'proposals', 'proposal-client-thank-you', 'finnish', 'Thank You Email (Sent to Customer After Accept) [finnish]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1904, 'proposals', 'proposal-comment-to-client', 'finnish', 'New Comment  (Sent to Customer/Lead) [finnish]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1905, 'proposals', 'proposal-comment-to-admin', 'finnish', 'New Comment (Sent to Staff)  [finnish]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1906, 'estimate', 'estimate-thank-you-to-customer', 'finnish', 'Thank You Email (Sent to Customer After Accept) [finnish]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1907, 'tasks', 'task-deadline-notification', 'finnish', 'Task Deadline Reminder - Sent to Assigned Members [finnish]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1908, 'contract', 'send-contract', 'finnish', 'Send Contract to Customer [finnish]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(1909, 'invoice', 'invoice-payment-recorded-to-staff', 'finnish', 'Invoice Payment Recorded (Sent to Staff) [finnish]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(1910, 'ticket', 'auto-close-ticket', 'finnish', 'Auto Close Ticket [finnish]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(1911, 'project', 'new-project-discussion-created-to-staff', 'finnish', 'New Project Discussion (Sent to Project Members) [finnish]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1912, 'project', 'new-project-discussion-created-to-customer', 'finnish', 'New Project Discussion (Sent to Customer Contacts) [finnish]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1913, 'project', 'new-project-file-uploaded-to-customer', 'finnish', 'New Project File(s) Uploaded (Sent to Customer Contacts) [finnish]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1914, 'project', 'new-project-file-uploaded-to-staff', 'finnish', 'New Project File(s) Uploaded (Sent to Project Members) [finnish]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1915, 'project', 'new-project-discussion-comment-to-customer', 'finnish', 'New Discussion Comment  (Sent to Customer Contacts) [finnish]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1916, 'project', 'new-project-discussion-comment-to-staff', 'finnish', 'New Discussion Comment (Sent to Project Members) [finnish]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1917, 'project', 'staff-added-as-project-member', 'finnish', 'Staff Added as Project Member [finnish]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1918, 'estimate', 'estimate-expiry-reminder', 'finnish', 'Estimate Expiration Reminder [finnish]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1919, 'proposals', 'proposal-expiry-reminder', 'finnish', 'Proposal Expiration Reminder [finnish]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1920, 'staff', 'new-staff-created', 'finnish', 'New Staff Created (Welcome Email) [finnish]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1921, 'client', 'contact-forgot-password', 'finnish', 'Forgot Password [finnish]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1922, 'client', 'contact-password-reseted', 'finnish', 'Password Reset - Confirmation [finnish]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1923, 'client', 'contact-set-password', 'finnish', 'Set New Password [finnish]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1924, 'staff', 'staff-forgot-password', 'finnish', 'Forgot Password [finnish]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1925, 'staff', 'staff-password-reseted', 'finnish', 'Password Reset - Confirmation [finnish]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1926, 'project', 'assigned-to-project', 'finnish', 'New Project Created (Sent to Customer Contacts) [finnish]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1927, 'tasks', 'task-added-attachment-to-contacts', 'finnish', 'New Attachment(s) on Task (Sent to Customer Contacts) [finnish]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1928, 'tasks', 'task-commented-to-contacts', 'finnish', 'New Comment on Task (Sent to Customer Contacts) [finnish]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1929, 'leads', 'new-lead-assigned', 'finnish', 'New Lead Assigned to Staff Member [finnish]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1930, 'client', 'client-statement', 'finnish', 'Statement - Account Summary [finnish]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1931, 'ticket', 'ticket-assigned-to-admin', 'finnish', 'New Ticket Assigned (Sent to Staff) [finnish]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(1932, 'client', 'new-client-registered-to-admin', 'finnish', 'New Customer Registration (Sent to admins) [finnish]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1933, 'leads', 'new-web-to-lead-form-submitted', 'finnish', 'Web to lead form submitted - Sent to lead [finnish]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(1934, 'staff', 'two-factor-authentication', 'finnish', 'Two Factor Authentication [finnish]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1935, 'project', 'project-finished-to-customer', 'finnish', 'Project Marked as Finished (Sent to Customer Contacts) [finnish]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1936, 'credit_note', 'credit-note-send-to-client', 'finnish', 'Send Credit Note To Email [finnish]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(1937, 'tasks', 'task-status-change-to-staff', 'finnish', 'Task Status Changed (Sent to Staff) [finnish]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(1938, 'tasks', 'task-status-change-to-contacts', 'finnish', 'Task Status Changed (Sent to Customer Contacts) [finnish]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(1939, 'staff', 'reminder-email-staff', 'finnish', 'Staff Reminder Email [finnish]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1940, 'contract', 'contract-comment-to-client', 'finnish', 'New Comment  (Sent to Customer Contacts) [finnish]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0);
INSERT INTO `tblemailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
(1941, 'contract', 'contract-comment-to-admin', 'finnish', 'New Comment (Sent to Staff)  [finnish]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(1942, 'subscriptions', 'send-subscription', 'finnish', 'Send Subscription to Customer [finnish]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(1943, 'subscriptions', 'subscription-payment-failed', 'finnish', 'Subscription Payment Failed [finnish]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(1944, 'subscriptions', 'subscription-canceled', 'finnish', 'Subscription Canceled (Sent to customer primary contact) [finnish]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(1945, 'subscriptions', 'subscription-payment-succeeded', 'finnish', 'Subscription Payment Succeeded (Sent to customer primary contact) [finnish]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1946, 'contract', 'contract-expiration-to-staff', 'finnish', 'Contract Expiration Reminder (Sent to Staff) [finnish]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1947, 'gdpr', 'gdpr-removal-request', 'finnish', 'Removal Request From Contact (Sent to administrators) [finnish]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1948, 'gdpr', 'gdpr-removal-request-lead', 'finnish', 'Removal Request From Lead (Sent to administrators) [finnish]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1949, 'client', 'client-registration-confirmed', 'finnish', 'Customer Registration Confirmed [finnish]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1950, 'contract', 'contract-signed-to-staff', 'finnish', 'Contract Signed (Sent to Staff) [finnish]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(1951, 'subscriptions', 'customer-subscribed-to-staff', 'finnish', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [finnish]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(1952, 'client', 'contact-verification-email', 'finnish', 'Email Verification (Sent to Contact After Registration) [finnish]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1953, 'client', 'new-customer-profile-file-uploaded-to-staff', 'finnish', 'New Customer Profile File(s) Uploaded (Sent to Staff) [finnish]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1954, 'staff', 'event-notification-to-staff', 'finnish', 'Event Notification (Calendar) [finnish]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(1955, 'subscriptions', 'subscription-payment-requires-action', 'finnish', 'Credit Card Authorization Required - SCA [finnish]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(1956, 'invoice', 'invoice-due-notice', 'finnish', 'Invoice Due Notice [finnish]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(1957, 'estimate_request', 'estimate-request-submitted-to-staff', 'finnish', 'Estimate Request Submitted (Sent to Staff) [finnish]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1958, 'estimate_request', 'estimate-request-assigned', 'finnish', 'Estimate Request Assigned (Sent to Staff) [finnish]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1959, 'estimate_request', 'estimate-request-received-to-user', 'finnish', 'Estimate Request Received (Sent to User) [finnish]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(1960, 'notifications', 'non-billed-tasks-reminder', 'finnish', 'Non-billed tasks reminder (sent to selected staff members) [finnish]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(1961, 'invoice', 'invoices-batch-payments', 'finnish', 'Invoices Payments Recorded in Batch (Sent to Customer) [finnish]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(1962, 'contract', 'contract-sign-reminder', 'finnish', 'Contract Sign Reminder (Sent to Customer) [finnish]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1963, 'purchase_order', 'purchase-order-to-contact', 'finnish', 'Purchase Order (Sent to contact) [finnish]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1964, 'purchase_order', 'purchase-request-to-contact', 'finnish', 'Purchase Request (Sent to contact) [finnish]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1965, 'purchase_order', 'purchase-quotation-to-contact', 'finnish', 'Purchase Quotation (Sent to contact) [finnish]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1966, 'purchase_order', 'debit-note-to-contact', 'finnish', 'Debit Note (Sent to contact) [finnish]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1967, 'purchase_order', 'purchase-statement-to-contact', 'finnish', 'Purchase Statement (Sent to contact) [finnish]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1968, 'inventory_warning', 'inventory-warning-to-staff', 'finnish', 'Inventory warning (Sent to staff) [finnish]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1969, 'purchase_order', 'vendor-registration-confirmed', 'finnish', 'Vendor Registration Confirmed [finnish]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1970, 'purchase_order', 'purchase-contract-to-contact', 'finnish', 'Purchase Contract (Sent to contact) [finnish]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1971, 'purchase_order', 'new-contact-created', 'finnish', 'New Contact Added/Registered (Welcome Email) [finnish]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1972, 'purchase_order', 'purchase-request-approval', 'finnish', 'Request approval [finnish]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1973, 'purchase_order', 'purchase-send-approved', 'finnish', 'Email send approved [finnish]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1974, 'purchase_order', 'purchase-send-rejected', 'finnish', 'Email send rejected [finnish]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1975, 'client', 'new-client-created', 'german', 'New Contact Added/Registered (Welcome Email) [german]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1976, 'invoice', 'invoice-send-to-client', 'german', 'Send Invoice to Customer [german]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1977, 'ticket', 'new-ticket-opened-admin', 'german', 'New Ticket Opened (Opened by Staff, Sent to Customer) [german]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(1978, 'ticket', 'ticket-reply', 'german', 'Ticket Reply (Sent to Customer) [german]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(1979, 'ticket', 'ticket-autoresponse', 'german', 'New Ticket Opened - Autoresponse [german]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(1980, 'invoice', 'invoice-payment-recorded', 'german', 'Invoice Payment Recorded (Sent to Customer) [german]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(1981, 'invoice', 'invoice-overdue-notice', 'german', 'Invoice Overdue Notice [german]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(1982, 'invoice', 'invoice-already-send', 'german', 'Invoice Already Sent to Customer [german]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1983, 'ticket', 'new-ticket-created-staff', 'german', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [german]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(1984, 'estimate', 'estimate-send-to-client', 'german', 'Send Estimate to Customer [german]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(1985, 'ticket', 'ticket-reply-to-admin', 'german', 'Ticket Reply (Sent to Staff) [german]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(1986, 'estimate', 'estimate-already-send', 'german', 'Estimate Already Sent to Customer [german]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(1987, 'contract', 'contract-expiration', 'german', 'Contract Expiration Reminder (Sent to Customer Contacts) [german]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(1988, 'tasks', 'task-assigned', 'german', 'New Task Assigned (Sent to Staff) [german]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1989, 'tasks', 'task-added-as-follower', 'german', 'Staff Member Added as Follower on Task (Sent to Staff) [german]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(1990, 'tasks', 'task-commented', 'german', 'New Comment on Task (Sent to Staff) [german]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1991, 'tasks', 'task-added-attachment', 'german', 'New Attachment(s) on Task (Sent to Staff) [german]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(1992, 'estimate', 'estimate-declined-to-staff', 'german', 'Estimate Declined (Sent to Staff) [german]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1993, 'estimate', 'estimate-accepted-to-staff', 'german', 'Estimate Accepted (Sent to Staff) [german]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(1994, 'proposals', 'proposal-client-accepted', 'german', 'Customer Action - Accepted (Sent to Staff) [german]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1995, 'proposals', 'proposal-send-to-customer', 'german', 'Send Proposal to Customer [german]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1996, 'proposals', 'proposal-client-declined', 'german', 'Customer Action - Declined (Sent to Staff) [german]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1997, 'proposals', 'proposal-client-thank-you', 'german', 'Thank You Email (Sent to Customer After Accept) [german]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1998, 'proposals', 'proposal-comment-to-client', 'german', 'New Comment  (Sent to Customer/Lead) [german]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(1999, 'proposals', 'proposal-comment-to-admin', 'german', 'New Comment (Sent to Staff)  [german]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2000, 'estimate', 'estimate-thank-you-to-customer', 'german', 'Thank You Email (Sent to Customer After Accept) [german]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2001, 'tasks', 'task-deadline-notification', 'german', 'Task Deadline Reminder - Sent to Assigned Members [german]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2002, 'contract', 'send-contract', 'german', 'Send Contract to Customer [german]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(2003, 'invoice', 'invoice-payment-recorded-to-staff', 'german', 'Invoice Payment Recorded (Sent to Staff) [german]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2004, 'ticket', 'auto-close-ticket', 'german', 'Auto Close Ticket [german]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(2005, 'project', 'new-project-discussion-created-to-staff', 'german', 'New Project Discussion (Sent to Project Members) [german]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2006, 'project', 'new-project-discussion-created-to-customer', 'german', 'New Project Discussion (Sent to Customer Contacts) [german]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2007, 'project', 'new-project-file-uploaded-to-customer', 'german', 'New Project File(s) Uploaded (Sent to Customer Contacts) [german]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2008, 'project', 'new-project-file-uploaded-to-staff', 'german', 'New Project File(s) Uploaded (Sent to Project Members) [german]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2009, 'project', 'new-project-discussion-comment-to-customer', 'german', 'New Discussion Comment  (Sent to Customer Contacts) [german]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2010, 'project', 'new-project-discussion-comment-to-staff', 'german', 'New Discussion Comment (Sent to Project Members) [german]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2011, 'project', 'staff-added-as-project-member', 'german', 'Staff Added as Project Member [german]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2012, 'estimate', 'estimate-expiry-reminder', 'german', 'Estimate Expiration Reminder [german]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2013, 'proposals', 'proposal-expiry-reminder', 'german', 'Proposal Expiration Reminder [german]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2014, 'staff', 'new-staff-created', 'german', 'New Staff Created (Welcome Email) [german]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2015, 'client', 'contact-forgot-password', 'german', 'Forgot Password [german]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2016, 'client', 'contact-password-reseted', 'german', 'Password Reset - Confirmation [german]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2017, 'client', 'contact-set-password', 'german', 'Set New Password [german]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2018, 'staff', 'staff-forgot-password', 'german', 'Forgot Password [german]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2019, 'staff', 'staff-password-reseted', 'german', 'Password Reset - Confirmation [german]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2020, 'project', 'assigned-to-project', 'german', 'New Project Created (Sent to Customer Contacts) [german]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2021, 'tasks', 'task-added-attachment-to-contacts', 'german', 'New Attachment(s) on Task (Sent to Customer Contacts) [german]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2022, 'tasks', 'task-commented-to-contacts', 'german', 'New Comment on Task (Sent to Customer Contacts) [german]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2023, 'leads', 'new-lead-assigned', 'german', 'New Lead Assigned to Staff Member [german]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2024, 'client', 'client-statement', 'german', 'Statement - Account Summary [german]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2025, 'ticket', 'ticket-assigned-to-admin', 'german', 'New Ticket Assigned (Sent to Staff) [german]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(2026, 'client', 'new-client-registered-to-admin', 'german', 'New Customer Registration (Sent to admins) [german]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2027, 'leads', 'new-web-to-lead-form-submitted', 'german', 'Web to lead form submitted - Sent to lead [german]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2028, 'staff', 'two-factor-authentication', 'german', 'Two Factor Authentication [german]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2029, 'project', 'project-finished-to-customer', 'german', 'Project Marked as Finished (Sent to Customer Contacts) [german]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2030, 'credit_note', 'credit-note-send-to-client', 'german', 'Send Credit Note To Email [german]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(2031, 'tasks', 'task-status-change-to-staff', 'german', 'Task Status Changed (Sent to Staff) [german]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(2032, 'tasks', 'task-status-change-to-contacts', 'german', 'Task Status Changed (Sent to Customer Contacts) [german]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(2033, 'staff', 'reminder-email-staff', 'german', 'Staff Reminder Email [german]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2034, 'contract', 'contract-comment-to-client', 'german', 'New Comment  (Sent to Customer Contacts) [german]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0),
(2035, 'contract', 'contract-comment-to-admin', 'german', 'New Comment (Sent to Staff)  [german]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(2036, 'subscriptions', 'send-subscription', 'german', 'Send Subscription to Customer [german]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2037, 'subscriptions', 'subscription-payment-failed', 'german', 'Subscription Payment Failed [german]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(2038, 'subscriptions', 'subscription-canceled', 'german', 'Subscription Canceled (Sent to customer primary contact) [german]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(2039, 'subscriptions', 'subscription-payment-succeeded', 'german', 'Subscription Payment Succeeded (Sent to customer primary contact) [german]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2040, 'contract', 'contract-expiration-to-staff', 'german', 'Contract Expiration Reminder (Sent to Staff) [german]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2041, 'gdpr', 'gdpr-removal-request', 'german', 'Removal Request From Contact (Sent to administrators) [german]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2042, 'gdpr', 'gdpr-removal-request-lead', 'german', 'Removal Request From Lead (Sent to administrators) [german]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2043, 'client', 'client-registration-confirmed', 'german', 'Customer Registration Confirmed [german]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2044, 'contract', 'contract-signed-to-staff', 'german', 'Contract Signed (Sent to Staff) [german]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(2045, 'subscriptions', 'customer-subscribed-to-staff', 'german', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [german]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(2046, 'client', 'contact-verification-email', 'german', 'Email Verification (Sent to Contact After Registration) [german]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2047, 'client', 'new-customer-profile-file-uploaded-to-staff', 'german', 'New Customer Profile File(s) Uploaded (Sent to Staff) [german]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2048, 'staff', 'event-notification-to-staff', 'german', 'Event Notification (Calendar) [german]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(2049, 'subscriptions', 'subscription-payment-requires-action', 'german', 'Credit Card Authorization Required - SCA [german]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2050, 'invoice', 'invoice-due-notice', 'german', 'Invoice Due Notice [german]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(2051, 'estimate_request', 'estimate-request-submitted-to-staff', 'german', 'Estimate Request Submitted (Sent to Staff) [german]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2052, 'estimate_request', 'estimate-request-assigned', 'german', 'Estimate Request Assigned (Sent to Staff) [german]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2053, 'estimate_request', 'estimate-request-received-to-user', 'german', 'Estimate Request Received (Sent to User) [german]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2054, 'notifications', 'non-billed-tasks-reminder', 'german', 'Non-billed tasks reminder (sent to selected staff members) [german]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(2055, 'invoice', 'invoices-batch-payments', 'german', 'Invoices Payments Recorded in Batch (Sent to Customer) [german]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(2056, 'contract', 'contract-sign-reminder', 'german', 'Contract Sign Reminder (Sent to Customer) [german]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2057, 'purchase_order', 'purchase-order-to-contact', 'german', 'Purchase Order (Sent to contact) [german]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2058, 'purchase_order', 'purchase-request-to-contact', 'german', 'Purchase Request (Sent to contact) [german]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2059, 'purchase_order', 'purchase-quotation-to-contact', 'german', 'Purchase Quotation (Sent to contact) [german]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2060, 'purchase_order', 'debit-note-to-contact', 'german', 'Debit Note (Sent to contact) [german]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2061, 'purchase_order', 'purchase-statement-to-contact', 'german', 'Purchase Statement (Sent to contact) [german]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2062, 'inventory_warning', 'inventory-warning-to-staff', 'german', 'Inventory warning (Sent to staff) [german]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2063, 'purchase_order', 'vendor-registration-confirmed', 'german', 'Vendor Registration Confirmed [german]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2064, 'purchase_order', 'purchase-contract-to-contact', 'german', 'Purchase Contract (Sent to contact) [german]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2065, 'purchase_order', 'new-contact-created', 'german', 'New Contact Added/Registered (Welcome Email) [german]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2066, 'purchase_order', 'purchase-request-approval', 'german', 'Request approval [german]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2067, 'purchase_order', 'purchase-send-approved', 'german', 'Email send approved [german]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2068, 'purchase_order', 'purchase-send-rejected', 'german', 'Email send rejected [german]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2069, 'client', 'new-client-created', 'vietnamese', 'New Contact Added/Registered (Welcome Email) [vietnamese]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2070, 'invoice', 'invoice-send-to-client', 'vietnamese', 'Send Invoice to Customer [vietnamese]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2071, 'ticket', 'new-ticket-opened-admin', 'vietnamese', 'New Ticket Opened (Opened by Staff, Sent to Customer) [vietnamese]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(2072, 'ticket', 'ticket-reply', 'vietnamese', 'Ticket Reply (Sent to Customer) [vietnamese]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(2073, 'ticket', 'ticket-autoresponse', 'vietnamese', 'New Ticket Opened - Autoresponse [vietnamese]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(2074, 'invoice', 'invoice-payment-recorded', 'vietnamese', 'Invoice Payment Recorded (Sent to Customer) [vietnamese]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(2075, 'invoice', 'invoice-overdue-notice', 'vietnamese', 'Invoice Overdue Notice [vietnamese]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(2076, 'invoice', 'invoice-already-send', 'vietnamese', 'Invoice Already Sent to Customer [vietnamese]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2077, 'ticket', 'new-ticket-created-staff', 'vietnamese', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [vietnamese]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2078, 'estimate', 'estimate-send-to-client', 'vietnamese', 'Send Estimate to Customer [vietnamese]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2079, 'ticket', 'ticket-reply-to-admin', 'vietnamese', 'Ticket Reply (Sent to Staff) [vietnamese]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(2080, 'estimate', 'estimate-already-send', 'vietnamese', 'Estimate Already Sent to Customer [vietnamese]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2081, 'contract', 'contract-expiration', 'vietnamese', 'Contract Expiration Reminder (Sent to Customer Contacts) [vietnamese]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2082, 'tasks', 'task-assigned', 'vietnamese', 'New Task Assigned (Sent to Staff) [vietnamese]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2083, 'tasks', 'task-added-as-follower', 'vietnamese', 'Staff Member Added as Follower on Task (Sent to Staff) [vietnamese]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2084, 'tasks', 'task-commented', 'vietnamese', 'New Comment on Task (Sent to Staff) [vietnamese]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2085, 'tasks', 'task-added-attachment', 'vietnamese', 'New Attachment(s) on Task (Sent to Staff) [vietnamese]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2086, 'estimate', 'estimate-declined-to-staff', 'vietnamese', 'Estimate Declined (Sent to Staff) [vietnamese]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2087, 'estimate', 'estimate-accepted-to-staff', 'vietnamese', 'Estimate Accepted (Sent to Staff) [vietnamese]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2088, 'proposals', 'proposal-client-accepted', 'vietnamese', 'Customer Action - Accepted (Sent to Staff) [vietnamese]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2089, 'proposals', 'proposal-send-to-customer', 'vietnamese', 'Send Proposal to Customer [vietnamese]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2090, 'proposals', 'proposal-client-declined', 'vietnamese', 'Customer Action - Declined (Sent to Staff) [vietnamese]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2091, 'proposals', 'proposal-client-thank-you', 'vietnamese', 'Thank You Email (Sent to Customer After Accept) [vietnamese]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2092, 'proposals', 'proposal-comment-to-client', 'vietnamese', 'New Comment  (Sent to Customer/Lead) [vietnamese]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2093, 'proposals', 'proposal-comment-to-admin', 'vietnamese', 'New Comment (Sent to Staff)  [vietnamese]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2094, 'estimate', 'estimate-thank-you-to-customer', 'vietnamese', 'Thank You Email (Sent to Customer After Accept) [vietnamese]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2095, 'tasks', 'task-deadline-notification', 'vietnamese', 'Task Deadline Reminder - Sent to Assigned Members [vietnamese]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2096, 'contract', 'send-contract', 'vietnamese', 'Send Contract to Customer [vietnamese]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(2097, 'invoice', 'invoice-payment-recorded-to-staff', 'vietnamese', 'Invoice Payment Recorded (Sent to Staff) [vietnamese]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2098, 'ticket', 'auto-close-ticket', 'vietnamese', 'Auto Close Ticket [vietnamese]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(2099, 'project', 'new-project-discussion-created-to-staff', 'vietnamese', 'New Project Discussion (Sent to Project Members) [vietnamese]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2100, 'project', 'new-project-discussion-created-to-customer', 'vietnamese', 'New Project Discussion (Sent to Customer Contacts) [vietnamese]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2101, 'project', 'new-project-file-uploaded-to-customer', 'vietnamese', 'New Project File(s) Uploaded (Sent to Customer Contacts) [vietnamese]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2102, 'project', 'new-project-file-uploaded-to-staff', 'vietnamese', 'New Project File(s) Uploaded (Sent to Project Members) [vietnamese]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2103, 'project', 'new-project-discussion-comment-to-customer', 'vietnamese', 'New Discussion Comment  (Sent to Customer Contacts) [vietnamese]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2104, 'project', 'new-project-discussion-comment-to-staff', 'vietnamese', 'New Discussion Comment (Sent to Project Members) [vietnamese]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2105, 'project', 'staff-added-as-project-member', 'vietnamese', 'Staff Added as Project Member [vietnamese]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2106, 'estimate', 'estimate-expiry-reminder', 'vietnamese', 'Estimate Expiration Reminder [vietnamese]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2107, 'proposals', 'proposal-expiry-reminder', 'vietnamese', 'Proposal Expiration Reminder [vietnamese]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2108, 'staff', 'new-staff-created', 'vietnamese', 'New Staff Created (Welcome Email) [vietnamese]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2109, 'client', 'contact-forgot-password', 'vietnamese', 'Forgot Password [vietnamese]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2110, 'client', 'contact-password-reseted', 'vietnamese', 'Password Reset - Confirmation [vietnamese]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2111, 'client', 'contact-set-password', 'vietnamese', 'Set New Password [vietnamese]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2112, 'staff', 'staff-forgot-password', 'vietnamese', 'Forgot Password [vietnamese]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2113, 'staff', 'staff-password-reseted', 'vietnamese', 'Password Reset - Confirmation [vietnamese]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2114, 'project', 'assigned-to-project', 'vietnamese', 'New Project Created (Sent to Customer Contacts) [vietnamese]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2115, 'tasks', 'task-added-attachment-to-contacts', 'vietnamese', 'New Attachment(s) on Task (Sent to Customer Contacts) [vietnamese]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2116, 'tasks', 'task-commented-to-contacts', 'vietnamese', 'New Comment on Task (Sent to Customer Contacts) [vietnamese]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2117, 'leads', 'new-lead-assigned', 'vietnamese', 'New Lead Assigned to Staff Member [vietnamese]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2118, 'client', 'client-statement', 'vietnamese', 'Statement - Account Summary [vietnamese]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2119, 'ticket', 'ticket-assigned-to-admin', 'vietnamese', 'New Ticket Assigned (Sent to Staff) [vietnamese]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(2120, 'client', 'new-client-registered-to-admin', 'vietnamese', 'New Customer Registration (Sent to admins) [vietnamese]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2121, 'leads', 'new-web-to-lead-form-submitted', 'vietnamese', 'Web to lead form submitted - Sent to lead [vietnamese]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2122, 'staff', 'two-factor-authentication', 'vietnamese', 'Two Factor Authentication [vietnamese]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2123, 'project', 'project-finished-to-customer', 'vietnamese', 'Project Marked as Finished (Sent to Customer Contacts) [vietnamese]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2124, 'credit_note', 'credit-note-send-to-client', 'vietnamese', 'Send Credit Note To Email [vietnamese]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(2125, 'tasks', 'task-status-change-to-staff', 'vietnamese', 'Task Status Changed (Sent to Staff) [vietnamese]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(2126, 'tasks', 'task-status-change-to-contacts', 'vietnamese', 'Task Status Changed (Sent to Customer Contacts) [vietnamese]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(2127, 'staff', 'reminder-email-staff', 'vietnamese', 'Staff Reminder Email [vietnamese]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2128, 'contract', 'contract-comment-to-client', 'vietnamese', 'New Comment  (Sent to Customer Contacts) [vietnamese]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0),
(2129, 'contract', 'contract-comment-to-admin', 'vietnamese', 'New Comment (Sent to Staff)  [vietnamese]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(2130, 'subscriptions', 'send-subscription', 'vietnamese', 'Send Subscription to Customer [vietnamese]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2131, 'subscriptions', 'subscription-payment-failed', 'vietnamese', 'Subscription Payment Failed [vietnamese]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(2132, 'subscriptions', 'subscription-canceled', 'vietnamese', 'Subscription Canceled (Sent to customer primary contact) [vietnamese]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(2133, 'subscriptions', 'subscription-payment-succeeded', 'vietnamese', 'Subscription Payment Succeeded (Sent to customer primary contact) [vietnamese]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2134, 'contract', 'contract-expiration-to-staff', 'vietnamese', 'Contract Expiration Reminder (Sent to Staff) [vietnamese]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2135, 'gdpr', 'gdpr-removal-request', 'vietnamese', 'Removal Request From Contact (Sent to administrators) [vietnamese]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2136, 'gdpr', 'gdpr-removal-request-lead', 'vietnamese', 'Removal Request From Lead (Sent to administrators) [vietnamese]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2137, 'client', 'client-registration-confirmed', 'vietnamese', 'Customer Registration Confirmed [vietnamese]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2138, 'contract', 'contract-signed-to-staff', 'vietnamese', 'Contract Signed (Sent to Staff) [vietnamese]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(2139, 'subscriptions', 'customer-subscribed-to-staff', 'vietnamese', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [vietnamese]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(2140, 'client', 'contact-verification-email', 'vietnamese', 'Email Verification (Sent to Contact After Registration) [vietnamese]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2141, 'client', 'new-customer-profile-file-uploaded-to-staff', 'vietnamese', 'New Customer Profile File(s) Uploaded (Sent to Staff) [vietnamese]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2142, 'staff', 'event-notification-to-staff', 'vietnamese', 'Event Notification (Calendar) [vietnamese]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(2143, 'subscriptions', 'subscription-payment-requires-action', 'vietnamese', 'Credit Card Authorization Required - SCA [vietnamese]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2144, 'invoice', 'invoice-due-notice', 'vietnamese', 'Invoice Due Notice [vietnamese]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(2145, 'estimate_request', 'estimate-request-submitted-to-staff', 'vietnamese', 'Estimate Request Submitted (Sent to Staff) [vietnamese]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2146, 'estimate_request', 'estimate-request-assigned', 'vietnamese', 'Estimate Request Assigned (Sent to Staff) [vietnamese]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2147, 'estimate_request', 'estimate-request-received-to-user', 'vietnamese', 'Estimate Request Received (Sent to User) [vietnamese]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2148, 'notifications', 'non-billed-tasks-reminder', 'vietnamese', 'Non-billed tasks reminder (sent to selected staff members) [vietnamese]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(2149, 'invoice', 'invoices-batch-payments', 'vietnamese', 'Invoices Payments Recorded in Batch (Sent to Customer) [vietnamese]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(2150, 'contract', 'contract-sign-reminder', 'vietnamese', 'Contract Sign Reminder (Sent to Customer) [vietnamese]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2151, 'purchase_order', 'purchase-order-to-contact', 'vietnamese', 'Purchase Order (Sent to contact) [vietnamese]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2152, 'purchase_order', 'purchase-request-to-contact', 'vietnamese', 'Purchase Request (Sent to contact) [vietnamese]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2153, 'purchase_order', 'purchase-quotation-to-contact', 'vietnamese', 'Purchase Quotation (Sent to contact) [vietnamese]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2154, 'purchase_order', 'debit-note-to-contact', 'vietnamese', 'Debit Note (Sent to contact) [vietnamese]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2155, 'purchase_order', 'purchase-statement-to-contact', 'vietnamese', 'Purchase Statement (Sent to contact) [vietnamese]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2156, 'inventory_warning', 'inventory-warning-to-staff', 'vietnamese', 'Inventory warning (Sent to staff) [vietnamese]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2157, 'purchase_order', 'vendor-registration-confirmed', 'vietnamese', 'Vendor Registration Confirmed [vietnamese]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2158, 'purchase_order', 'purchase-contract-to-contact', 'vietnamese', 'Purchase Contract (Sent to contact) [vietnamese]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2159, 'purchase_order', 'new-contact-created', 'vietnamese', 'New Contact Added/Registered (Welcome Email) [vietnamese]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2160, 'purchase_order', 'purchase-request-approval', 'vietnamese', 'Request approval [vietnamese]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2161, 'purchase_order', 'purchase-send-approved', 'vietnamese', 'Email send approved [vietnamese]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2162, 'purchase_order', 'purchase-send-rejected', 'vietnamese', 'Email send rejected [vietnamese]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2163, 'client', 'new-client-created', 'ukrainian', 'New Contact Added/Registered (Welcome Email) [ukrainian]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2164, 'invoice', 'invoice-send-to-client', 'ukrainian', 'Send Invoice to Customer [ukrainian]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2165, 'ticket', 'new-ticket-opened-admin', 'ukrainian', 'New Ticket Opened (Opened by Staff, Sent to Customer) [ukrainian]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(2166, 'ticket', 'ticket-reply', 'ukrainian', 'Ticket Reply (Sent to Customer) [ukrainian]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(2167, 'ticket', 'ticket-autoresponse', 'ukrainian', 'New Ticket Opened - Autoresponse [ukrainian]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(2168, 'invoice', 'invoice-payment-recorded', 'ukrainian', 'Invoice Payment Recorded (Sent to Customer) [ukrainian]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(2169, 'invoice', 'invoice-overdue-notice', 'ukrainian', 'Invoice Overdue Notice [ukrainian]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(2170, 'invoice', 'invoice-already-send', 'ukrainian', 'Invoice Already Sent to Customer [ukrainian]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2171, 'ticket', 'new-ticket-created-staff', 'ukrainian', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [ukrainian]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2172, 'estimate', 'estimate-send-to-client', 'ukrainian', 'Send Estimate to Customer [ukrainian]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2173, 'ticket', 'ticket-reply-to-admin', 'ukrainian', 'Ticket Reply (Sent to Staff) [ukrainian]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(2174, 'estimate', 'estimate-already-send', 'ukrainian', 'Estimate Already Sent to Customer [ukrainian]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2175, 'contract', 'contract-expiration', 'ukrainian', 'Contract Expiration Reminder (Sent to Customer Contacts) [ukrainian]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2176, 'tasks', 'task-assigned', 'ukrainian', 'New Task Assigned (Sent to Staff) [ukrainian]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2177, 'tasks', 'task-added-as-follower', 'ukrainian', 'Staff Member Added as Follower on Task (Sent to Staff) [ukrainian]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2178, 'tasks', 'task-commented', 'ukrainian', 'New Comment on Task (Sent to Staff) [ukrainian]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2179, 'tasks', 'task-added-attachment', 'ukrainian', 'New Attachment(s) on Task (Sent to Staff) [ukrainian]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2180, 'estimate', 'estimate-declined-to-staff', 'ukrainian', 'Estimate Declined (Sent to Staff) [ukrainian]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2181, 'estimate', 'estimate-accepted-to-staff', 'ukrainian', 'Estimate Accepted (Sent to Staff) [ukrainian]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2182, 'proposals', 'proposal-client-accepted', 'ukrainian', 'Customer Action - Accepted (Sent to Staff) [ukrainian]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2183, 'proposals', 'proposal-send-to-customer', 'ukrainian', 'Send Proposal to Customer [ukrainian]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2184, 'proposals', 'proposal-client-declined', 'ukrainian', 'Customer Action - Declined (Sent to Staff) [ukrainian]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2185, 'proposals', 'proposal-client-thank-you', 'ukrainian', 'Thank You Email (Sent to Customer After Accept) [ukrainian]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2186, 'proposals', 'proposal-comment-to-client', 'ukrainian', 'New Comment  (Sent to Customer/Lead) [ukrainian]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2187, 'proposals', 'proposal-comment-to-admin', 'ukrainian', 'New Comment (Sent to Staff)  [ukrainian]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2188, 'estimate', 'estimate-thank-you-to-customer', 'ukrainian', 'Thank You Email (Sent to Customer After Accept) [ukrainian]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2189, 'tasks', 'task-deadline-notification', 'ukrainian', 'Task Deadline Reminder - Sent to Assigned Members [ukrainian]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2190, 'contract', 'send-contract', 'ukrainian', 'Send Contract to Customer [ukrainian]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(2191, 'invoice', 'invoice-payment-recorded-to-staff', 'ukrainian', 'Invoice Payment Recorded (Sent to Staff) [ukrainian]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2192, 'ticket', 'auto-close-ticket', 'ukrainian', 'Auto Close Ticket [ukrainian]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(2193, 'project', 'new-project-discussion-created-to-staff', 'ukrainian', 'New Project Discussion (Sent to Project Members) [ukrainian]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2194, 'project', 'new-project-discussion-created-to-customer', 'ukrainian', 'New Project Discussion (Sent to Customer Contacts) [ukrainian]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2195, 'project', 'new-project-file-uploaded-to-customer', 'ukrainian', 'New Project File(s) Uploaded (Sent to Customer Contacts) [ukrainian]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2196, 'project', 'new-project-file-uploaded-to-staff', 'ukrainian', 'New Project File(s) Uploaded (Sent to Project Members) [ukrainian]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2197, 'project', 'new-project-discussion-comment-to-customer', 'ukrainian', 'New Discussion Comment  (Sent to Customer Contacts) [ukrainian]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2198, 'project', 'new-project-discussion-comment-to-staff', 'ukrainian', 'New Discussion Comment (Sent to Project Members) [ukrainian]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2199, 'project', 'staff-added-as-project-member', 'ukrainian', 'Staff Added as Project Member [ukrainian]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2200, 'estimate', 'estimate-expiry-reminder', 'ukrainian', 'Estimate Expiration Reminder [ukrainian]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2201, 'proposals', 'proposal-expiry-reminder', 'ukrainian', 'Proposal Expiration Reminder [ukrainian]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2202, 'staff', 'new-staff-created', 'ukrainian', 'New Staff Created (Welcome Email) [ukrainian]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2203, 'client', 'contact-forgot-password', 'ukrainian', 'Forgot Password [ukrainian]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2204, 'client', 'contact-password-reseted', 'ukrainian', 'Password Reset - Confirmation [ukrainian]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2205, 'client', 'contact-set-password', 'ukrainian', 'Set New Password [ukrainian]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2206, 'staff', 'staff-forgot-password', 'ukrainian', 'Forgot Password [ukrainian]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2207, 'staff', 'staff-password-reseted', 'ukrainian', 'Password Reset - Confirmation [ukrainian]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0);
INSERT INTO `tblemailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
(2208, 'project', 'assigned-to-project', 'ukrainian', 'New Project Created (Sent to Customer Contacts) [ukrainian]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2209, 'tasks', 'task-added-attachment-to-contacts', 'ukrainian', 'New Attachment(s) on Task (Sent to Customer Contacts) [ukrainian]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2210, 'tasks', 'task-commented-to-contacts', 'ukrainian', 'New Comment on Task (Sent to Customer Contacts) [ukrainian]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2211, 'leads', 'new-lead-assigned', 'ukrainian', 'New Lead Assigned to Staff Member [ukrainian]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2212, 'client', 'client-statement', 'ukrainian', 'Statement - Account Summary [ukrainian]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2213, 'ticket', 'ticket-assigned-to-admin', 'ukrainian', 'New Ticket Assigned (Sent to Staff) [ukrainian]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(2214, 'client', 'new-client-registered-to-admin', 'ukrainian', 'New Customer Registration (Sent to admins) [ukrainian]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2215, 'leads', 'new-web-to-lead-form-submitted', 'ukrainian', 'Web to lead form submitted - Sent to lead [ukrainian]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2216, 'staff', 'two-factor-authentication', 'ukrainian', 'Two Factor Authentication [ukrainian]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2217, 'project', 'project-finished-to-customer', 'ukrainian', 'Project Marked as Finished (Sent to Customer Contacts) [ukrainian]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2218, 'credit_note', 'credit-note-send-to-client', 'ukrainian', 'Send Credit Note To Email [ukrainian]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(2219, 'tasks', 'task-status-change-to-staff', 'ukrainian', 'Task Status Changed (Sent to Staff) [ukrainian]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(2220, 'tasks', 'task-status-change-to-contacts', 'ukrainian', 'Task Status Changed (Sent to Customer Contacts) [ukrainian]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(2221, 'staff', 'reminder-email-staff', 'ukrainian', 'Staff Reminder Email [ukrainian]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2222, 'contract', 'contract-comment-to-client', 'ukrainian', 'New Comment  (Sent to Customer Contacts) [ukrainian]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0),
(2223, 'contract', 'contract-comment-to-admin', 'ukrainian', 'New Comment (Sent to Staff)  [ukrainian]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(2224, 'subscriptions', 'send-subscription', 'ukrainian', 'Send Subscription to Customer [ukrainian]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2225, 'subscriptions', 'subscription-payment-failed', 'ukrainian', 'Subscription Payment Failed [ukrainian]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(2226, 'subscriptions', 'subscription-canceled', 'ukrainian', 'Subscription Canceled (Sent to customer primary contact) [ukrainian]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(2227, 'subscriptions', 'subscription-payment-succeeded', 'ukrainian', 'Subscription Payment Succeeded (Sent to customer primary contact) [ukrainian]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2228, 'contract', 'contract-expiration-to-staff', 'ukrainian', 'Contract Expiration Reminder (Sent to Staff) [ukrainian]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2229, 'gdpr', 'gdpr-removal-request', 'ukrainian', 'Removal Request From Contact (Sent to administrators) [ukrainian]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2230, 'gdpr', 'gdpr-removal-request-lead', 'ukrainian', 'Removal Request From Lead (Sent to administrators) [ukrainian]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2231, 'client', 'client-registration-confirmed', 'ukrainian', 'Customer Registration Confirmed [ukrainian]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2232, 'contract', 'contract-signed-to-staff', 'ukrainian', 'Contract Signed (Sent to Staff) [ukrainian]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(2233, 'subscriptions', 'customer-subscribed-to-staff', 'ukrainian', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [ukrainian]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(2234, 'client', 'contact-verification-email', 'ukrainian', 'Email Verification (Sent to Contact After Registration) [ukrainian]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2235, 'client', 'new-customer-profile-file-uploaded-to-staff', 'ukrainian', 'New Customer Profile File(s) Uploaded (Sent to Staff) [ukrainian]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2236, 'staff', 'event-notification-to-staff', 'ukrainian', 'Event Notification (Calendar) [ukrainian]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(2237, 'subscriptions', 'subscription-payment-requires-action', 'ukrainian', 'Credit Card Authorization Required - SCA [ukrainian]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2238, 'invoice', 'invoice-due-notice', 'ukrainian', 'Invoice Due Notice [ukrainian]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(2239, 'estimate_request', 'estimate-request-submitted-to-staff', 'ukrainian', 'Estimate Request Submitted (Sent to Staff) [ukrainian]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2240, 'estimate_request', 'estimate-request-assigned', 'ukrainian', 'Estimate Request Assigned (Sent to Staff) [ukrainian]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2241, 'estimate_request', 'estimate-request-received-to-user', 'ukrainian', 'Estimate Request Received (Sent to User) [ukrainian]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2242, 'notifications', 'non-billed-tasks-reminder', 'ukrainian', 'Non-billed tasks reminder (sent to selected staff members) [ukrainian]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(2243, 'invoice', 'invoices-batch-payments', 'ukrainian', 'Invoices Payments Recorded in Batch (Sent to Customer) [ukrainian]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(2244, 'contract', 'contract-sign-reminder', 'ukrainian', 'Contract Sign Reminder (Sent to Customer) [ukrainian]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2245, 'purchase_order', 'purchase-order-to-contact', 'ukrainian', 'Purchase Order (Sent to contact) [ukrainian]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2246, 'purchase_order', 'purchase-request-to-contact', 'ukrainian', 'Purchase Request (Sent to contact) [ukrainian]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2247, 'purchase_order', 'purchase-quotation-to-contact', 'ukrainian', 'Purchase Quotation (Sent to contact) [ukrainian]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2248, 'purchase_order', 'debit-note-to-contact', 'ukrainian', 'Debit Note (Sent to contact) [ukrainian]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2249, 'purchase_order', 'purchase-statement-to-contact', 'ukrainian', 'Purchase Statement (Sent to contact) [ukrainian]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2250, 'inventory_warning', 'inventory-warning-to-staff', 'ukrainian', 'Inventory warning (Sent to staff) [ukrainian]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2251, 'purchase_order', 'vendor-registration-confirmed', 'ukrainian', 'Vendor Registration Confirmed [ukrainian]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2252, 'purchase_order', 'purchase-contract-to-contact', 'ukrainian', 'Purchase Contract (Sent to contact) [ukrainian]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2253, 'purchase_order', 'new-contact-created', 'ukrainian', 'New Contact Added/Registered (Welcome Email) [ukrainian]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2254, 'purchase_order', 'purchase-request-approval', 'ukrainian', 'Request approval [ukrainian]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2255, 'purchase_order', 'purchase-send-approved', 'ukrainian', 'Email send approved [ukrainian]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2256, 'purchase_order', 'purchase-send-rejected', 'ukrainian', 'Email send rejected [ukrainian]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2257, 'client', 'new-client-created', 'norwegian', 'New Contact Added/Registered (Welcome Email) [norwegian]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2258, 'invoice', 'invoice-send-to-client', 'norwegian', 'Send Invoice to Customer [norwegian]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2259, 'ticket', 'new-ticket-opened-admin', 'norwegian', 'New Ticket Opened (Opened by Staff, Sent to Customer) [norwegian]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(2260, 'ticket', 'ticket-reply', 'norwegian', 'Ticket Reply (Sent to Customer) [norwegian]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(2261, 'ticket', 'ticket-autoresponse', 'norwegian', 'New Ticket Opened - Autoresponse [norwegian]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(2262, 'invoice', 'invoice-payment-recorded', 'norwegian', 'Invoice Payment Recorded (Sent to Customer) [norwegian]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(2263, 'invoice', 'invoice-overdue-notice', 'norwegian', 'Invoice Overdue Notice [norwegian]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(2264, 'invoice', 'invoice-already-send', 'norwegian', 'Invoice Already Sent to Customer [norwegian]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2265, 'ticket', 'new-ticket-created-staff', 'norwegian', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [norwegian]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2266, 'estimate', 'estimate-send-to-client', 'norwegian', 'Send Estimate to Customer [norwegian]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2267, 'ticket', 'ticket-reply-to-admin', 'norwegian', 'Ticket Reply (Sent to Staff) [norwegian]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(2268, 'estimate', 'estimate-already-send', 'norwegian', 'Estimate Already Sent to Customer [norwegian]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2269, 'contract', 'contract-expiration', 'norwegian', 'Contract Expiration Reminder (Sent to Customer Contacts) [norwegian]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2270, 'tasks', 'task-assigned', 'norwegian', 'New Task Assigned (Sent to Staff) [norwegian]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2271, 'tasks', 'task-added-as-follower', 'norwegian', 'Staff Member Added as Follower on Task (Sent to Staff) [norwegian]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2272, 'tasks', 'task-commented', 'norwegian', 'New Comment on Task (Sent to Staff) [norwegian]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2273, 'tasks', 'task-added-attachment', 'norwegian', 'New Attachment(s) on Task (Sent to Staff) [norwegian]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2274, 'estimate', 'estimate-declined-to-staff', 'norwegian', 'Estimate Declined (Sent to Staff) [norwegian]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2275, 'estimate', 'estimate-accepted-to-staff', 'norwegian', 'Estimate Accepted (Sent to Staff) [norwegian]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2276, 'proposals', 'proposal-client-accepted', 'norwegian', 'Customer Action - Accepted (Sent to Staff) [norwegian]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2277, 'proposals', 'proposal-send-to-customer', 'norwegian', 'Send Proposal to Customer [norwegian]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2278, 'proposals', 'proposal-client-declined', 'norwegian', 'Customer Action - Declined (Sent to Staff) [norwegian]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2279, 'proposals', 'proposal-client-thank-you', 'norwegian', 'Thank You Email (Sent to Customer After Accept) [norwegian]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2280, 'proposals', 'proposal-comment-to-client', 'norwegian', 'New Comment  (Sent to Customer/Lead) [norwegian]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2281, 'proposals', 'proposal-comment-to-admin', 'norwegian', 'New Comment (Sent to Staff)  [norwegian]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2282, 'estimate', 'estimate-thank-you-to-customer', 'norwegian', 'Thank You Email (Sent to Customer After Accept) [norwegian]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2283, 'tasks', 'task-deadline-notification', 'norwegian', 'Task Deadline Reminder - Sent to Assigned Members [norwegian]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2284, 'contract', 'send-contract', 'norwegian', 'Send Contract to Customer [norwegian]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(2285, 'invoice', 'invoice-payment-recorded-to-staff', 'norwegian', 'Invoice Payment Recorded (Sent to Staff) [norwegian]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2286, 'ticket', 'auto-close-ticket', 'norwegian', 'Auto Close Ticket [norwegian]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(2287, 'project', 'new-project-discussion-created-to-staff', 'norwegian', 'New Project Discussion (Sent to Project Members) [norwegian]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2288, 'project', 'new-project-discussion-created-to-customer', 'norwegian', 'New Project Discussion (Sent to Customer Contacts) [norwegian]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2289, 'project', 'new-project-file-uploaded-to-customer', 'norwegian', 'New Project File(s) Uploaded (Sent to Customer Contacts) [norwegian]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2290, 'project', 'new-project-file-uploaded-to-staff', 'norwegian', 'New Project File(s) Uploaded (Sent to Project Members) [norwegian]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2291, 'project', 'new-project-discussion-comment-to-customer', 'norwegian', 'New Discussion Comment  (Sent to Customer Contacts) [norwegian]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2292, 'project', 'new-project-discussion-comment-to-staff', 'norwegian', 'New Discussion Comment (Sent to Project Members) [norwegian]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2293, 'project', 'staff-added-as-project-member', 'norwegian', 'Staff Added as Project Member [norwegian]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2294, 'estimate', 'estimate-expiry-reminder', 'norwegian', 'Estimate Expiration Reminder [norwegian]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2295, 'proposals', 'proposal-expiry-reminder', 'norwegian', 'Proposal Expiration Reminder [norwegian]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2296, 'staff', 'new-staff-created', 'norwegian', 'New Staff Created (Welcome Email) [norwegian]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2297, 'client', 'contact-forgot-password', 'norwegian', 'Forgot Password [norwegian]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2298, 'client', 'contact-password-reseted', 'norwegian', 'Password Reset - Confirmation [norwegian]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2299, 'client', 'contact-set-password', 'norwegian', 'Set New Password [norwegian]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2300, 'staff', 'staff-forgot-password', 'norwegian', 'Forgot Password [norwegian]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2301, 'staff', 'staff-password-reseted', 'norwegian', 'Password Reset - Confirmation [norwegian]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2302, 'project', 'assigned-to-project', 'norwegian', 'New Project Created (Sent to Customer Contacts) [norwegian]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2303, 'tasks', 'task-added-attachment-to-contacts', 'norwegian', 'New Attachment(s) on Task (Sent to Customer Contacts) [norwegian]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2304, 'tasks', 'task-commented-to-contacts', 'norwegian', 'New Comment on Task (Sent to Customer Contacts) [norwegian]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2305, 'leads', 'new-lead-assigned', 'norwegian', 'New Lead Assigned to Staff Member [norwegian]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2306, 'client', 'client-statement', 'norwegian', 'Statement - Account Summary [norwegian]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2307, 'ticket', 'ticket-assigned-to-admin', 'norwegian', 'New Ticket Assigned (Sent to Staff) [norwegian]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(2308, 'client', 'new-client-registered-to-admin', 'norwegian', 'New Customer Registration (Sent to admins) [norwegian]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2309, 'leads', 'new-web-to-lead-form-submitted', 'norwegian', 'Web to lead form submitted - Sent to lead [norwegian]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2310, 'staff', 'two-factor-authentication', 'norwegian', 'Two Factor Authentication [norwegian]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2311, 'project', 'project-finished-to-customer', 'norwegian', 'Project Marked as Finished (Sent to Customer Contacts) [norwegian]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2312, 'credit_note', 'credit-note-send-to-client', 'norwegian', 'Send Credit Note To Email [norwegian]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(2313, 'tasks', 'task-status-change-to-staff', 'norwegian', 'Task Status Changed (Sent to Staff) [norwegian]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(2314, 'tasks', 'task-status-change-to-contacts', 'norwegian', 'Task Status Changed (Sent to Customer Contacts) [norwegian]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(2315, 'staff', 'reminder-email-staff', 'norwegian', 'Staff Reminder Email [norwegian]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2316, 'contract', 'contract-comment-to-client', 'norwegian', 'New Comment  (Sent to Customer Contacts) [norwegian]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0),
(2317, 'contract', 'contract-comment-to-admin', 'norwegian', 'New Comment (Sent to Staff)  [norwegian]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(2318, 'subscriptions', 'send-subscription', 'norwegian', 'Send Subscription to Customer [norwegian]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2319, 'subscriptions', 'subscription-payment-failed', 'norwegian', 'Subscription Payment Failed [norwegian]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(2320, 'subscriptions', 'subscription-canceled', 'norwegian', 'Subscription Canceled (Sent to customer primary contact) [norwegian]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(2321, 'subscriptions', 'subscription-payment-succeeded', 'norwegian', 'Subscription Payment Succeeded (Sent to customer primary contact) [norwegian]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2322, 'contract', 'contract-expiration-to-staff', 'norwegian', 'Contract Expiration Reminder (Sent to Staff) [norwegian]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2323, 'gdpr', 'gdpr-removal-request', 'norwegian', 'Removal Request From Contact (Sent to administrators) [norwegian]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2324, 'gdpr', 'gdpr-removal-request-lead', 'norwegian', 'Removal Request From Lead (Sent to administrators) [norwegian]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2325, 'client', 'client-registration-confirmed', 'norwegian', 'Customer Registration Confirmed [norwegian]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2326, 'contract', 'contract-signed-to-staff', 'norwegian', 'Contract Signed (Sent to Staff) [norwegian]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(2327, 'subscriptions', 'customer-subscribed-to-staff', 'norwegian', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [norwegian]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(2328, 'client', 'contact-verification-email', 'norwegian', 'Email Verification (Sent to Contact After Registration) [norwegian]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2329, 'client', 'new-customer-profile-file-uploaded-to-staff', 'norwegian', 'New Customer Profile File(s) Uploaded (Sent to Staff) [norwegian]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2330, 'staff', 'event-notification-to-staff', 'norwegian', 'Event Notification (Calendar) [norwegian]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(2331, 'subscriptions', 'subscription-payment-requires-action', 'norwegian', 'Credit Card Authorization Required - SCA [norwegian]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2332, 'invoice', 'invoice-due-notice', 'norwegian', 'Invoice Due Notice [norwegian]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(2333, 'estimate_request', 'estimate-request-submitted-to-staff', 'norwegian', 'Estimate Request Submitted (Sent to Staff) [norwegian]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2334, 'estimate_request', 'estimate-request-assigned', 'norwegian', 'Estimate Request Assigned (Sent to Staff) [norwegian]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2335, 'estimate_request', 'estimate-request-received-to-user', 'norwegian', 'Estimate Request Received (Sent to User) [norwegian]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2336, 'notifications', 'non-billed-tasks-reminder', 'norwegian', 'Non-billed tasks reminder (sent to selected staff members) [norwegian]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(2337, 'invoice', 'invoices-batch-payments', 'norwegian', 'Invoices Payments Recorded in Batch (Sent to Customer) [norwegian]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(2338, 'contract', 'contract-sign-reminder', 'norwegian', 'Contract Sign Reminder (Sent to Customer) [norwegian]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2339, 'purchase_order', 'purchase-order-to-contact', 'norwegian', 'Purchase Order (Sent to contact) [norwegian]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2340, 'purchase_order', 'purchase-request-to-contact', 'norwegian', 'Purchase Request (Sent to contact) [norwegian]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2341, 'purchase_order', 'purchase-quotation-to-contact', 'norwegian', 'Purchase Quotation (Sent to contact) [norwegian]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2342, 'purchase_order', 'debit-note-to-contact', 'norwegian', 'Debit Note (Sent to contact) [norwegian]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2343, 'purchase_order', 'purchase-statement-to-contact', 'norwegian', 'Purchase Statement (Sent to contact) [norwegian]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2344, 'inventory_warning', 'inventory-warning-to-staff', 'norwegian', 'Inventory warning (Sent to staff) [norwegian]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2345, 'purchase_order', 'vendor-registration-confirmed', 'norwegian', 'Vendor Registration Confirmed [norwegian]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2346, 'purchase_order', 'purchase-contract-to-contact', 'norwegian', 'Purchase Contract (Sent to contact) [norwegian]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2347, 'purchase_order', 'new-contact-created', 'norwegian', 'New Contact Added/Registered (Welcome Email) [norwegian]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2348, 'purchase_order', 'purchase-request-approval', 'norwegian', 'Request approval [norwegian]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2349, 'purchase_order', 'purchase-send-approved', 'norwegian', 'Email send approved [norwegian]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2350, 'purchase_order', 'purchase-send-rejected', 'norwegian', 'Email send rejected [norwegian]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2351, 'client', 'new-client-created', 'italian', 'New Contact Added/Registered (Welcome Email) [italian]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2352, 'invoice', 'invoice-send-to-client', 'italian', 'Send Invoice to Customer [italian]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2353, 'ticket', 'new-ticket-opened-admin', 'italian', 'New Ticket Opened (Opened by Staff, Sent to Customer) [italian]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 1, 0),
(2354, 'ticket', 'ticket-reply', 'italian', 'Ticket Reply (Sent to Customer) [italian]', 'New Ticket Reply', '', '{companyname} | MIS', '', 0, 1, 0),
(2355, 'ticket', 'ticket-autoresponse', 'italian', 'New Ticket Opened - Autoresponse [italian]', 'New Support Ticket Opened', '', '{companyname} | MIS', '', 0, 0, 0),
(2356, 'invoice', 'invoice-payment-recorded', 'italian', 'Invoice Payment Recorded (Sent to Customer) [italian]', 'Invoice Payment Recorded', '', '{companyname} | MIS', '', 0, 1, 0),
(2357, 'invoice', 'invoice-overdue-notice', 'italian', 'Invoice Overdue Notice [italian]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', '', 0, 1, 0),
(2358, 'invoice', 'invoice-already-send', 'italian', 'Invoice Already Sent to Customer [italian]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2359, 'ticket', 'new-ticket-created-staff', 'italian', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [italian]', 'New Ticket Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2360, 'estimate', 'estimate-send-to-client', 'italian', 'Send Estimate to Customer [italian]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', '', 0, 1, 0),
(2361, 'ticket', 'ticket-reply-to-admin', 'italian', 'Ticket Reply (Sent to Staff) [italian]', 'New Support Ticket Reply', '', '{companyname} | MIS', '', 0, 0, 0),
(2362, 'estimate', 'estimate-already-send', 'italian', 'Estimate Already Sent to Customer [italian]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', '', 0, 0, 0),
(2363, 'contract', 'contract-expiration', 'italian', 'Contract Expiration Reminder (Sent to Customer Contacts) [italian]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2364, 'tasks', 'task-assigned', 'italian', 'New Task Assigned (Sent to Staff) [italian]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2365, 'tasks', 'task-added-as-follower', 'italian', 'Staff Member Added as Follower on Task (Sent to Staff) [italian]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2366, 'tasks', 'task-commented', 'italian', 'New Comment on Task (Sent to Staff) [italian]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2367, 'tasks', 'task-added-attachment', 'italian', 'New Attachment(s) on Task (Sent to Staff) [italian]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2368, 'estimate', 'estimate-declined-to-staff', 'italian', 'Estimate Declined (Sent to Staff) [italian]', 'Customer Declined Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2369, 'estimate', 'estimate-accepted-to-staff', 'italian', 'Estimate Accepted (Sent to Staff) [italian]', 'Customer Accepted Estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2370, 'proposals', 'proposal-client-accepted', 'italian', 'Customer Action - Accepted (Sent to Staff) [italian]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2371, 'proposals', 'proposal-send-to-customer', 'italian', 'Send Proposal to Customer [italian]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2372, 'proposals', 'proposal-client-declined', 'italian', 'Customer Action - Declined (Sent to Staff) [italian]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2373, 'proposals', 'proposal-client-thank-you', 'italian', 'Thank You Email (Sent to Customer After Accept) [italian]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2374, 'proposals', 'proposal-comment-to-client', 'italian', 'New Comment  (Sent to Customer/Lead) [italian]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2375, 'proposals', 'proposal-comment-to-admin', 'italian', 'New Comment (Sent to Staff)  [italian]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2376, 'estimate', 'estimate-thank-you-to-customer', 'italian', 'Thank You Email (Sent to Customer After Accept) [italian]', 'Thank for you accepting estimate', '', '{companyname} | MIS', '', 0, 1, 0),
(2377, 'tasks', 'task-deadline-notification', 'italian', 'Task Deadline Reminder - Sent to Assigned Members [italian]', 'Task Deadline Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2378, 'contract', 'send-contract', 'italian', 'Send Contract to Customer [italian]', 'Contract - {contract_subject}', '', '{companyname} | MIS', '', 0, 1, 0),
(2379, 'invoice', 'invoice-payment-recorded-to-staff', 'italian', 'Invoice Payment Recorded (Sent to Staff) [italian]', 'New Invoice Payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2380, 'ticket', 'auto-close-ticket', 'italian', 'Auto Close Ticket [italian]', 'Ticket Auto Closed', '', '{companyname} | MIS', '', 0, 1, 0),
(2381, 'project', 'new-project-discussion-created-to-staff', 'italian', 'New Project Discussion (Sent to Project Members) [italian]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2382, 'project', 'new-project-discussion-created-to-customer', 'italian', 'New Project Discussion (Sent to Customer Contacts) [italian]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2383, 'project', 'new-project-file-uploaded-to-customer', 'italian', 'New Project File(s) Uploaded (Sent to Customer Contacts) [italian]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2384, 'project', 'new-project-file-uploaded-to-staff', 'italian', 'New Project File(s) Uploaded (Sent to Project Members) [italian]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2385, 'project', 'new-project-discussion-comment-to-customer', 'italian', 'New Discussion Comment  (Sent to Customer Contacts) [italian]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2386, 'project', 'new-project-discussion-comment-to-staff', 'italian', 'New Discussion Comment (Sent to Project Members) [italian]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2387, 'project', 'staff-added-as-project-member', 'italian', 'Staff Added as Project Member [italian]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2388, 'estimate', 'estimate-expiry-reminder', 'italian', 'Estimate Expiration Reminder [italian]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2389, 'proposals', 'proposal-expiry-reminder', 'italian', 'Proposal Expiration Reminder [italian]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2390, 'staff', 'new-staff-created', 'italian', 'New Staff Created (Welcome Email) [italian]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2391, 'client', 'contact-forgot-password', 'italian', 'Forgot Password [italian]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2392, 'client', 'contact-password-reseted', 'italian', 'Password Reset - Confirmation [italian]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2393, 'client', 'contact-set-password', 'italian', 'Set New Password [italian]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2394, 'staff', 'staff-forgot-password', 'italian', 'Forgot Password [italian]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2395, 'staff', 'staff-password-reseted', 'italian', 'Password Reset - Confirmation [italian]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2396, 'project', 'assigned-to-project', 'italian', 'New Project Created (Sent to Customer Contacts) [italian]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2397, 'tasks', 'task-added-attachment-to-contacts', 'italian', 'New Attachment(s) on Task (Sent to Customer Contacts) [italian]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2398, 'tasks', 'task-commented-to-contacts', 'italian', 'New Comment on Task (Sent to Customer Contacts) [italian]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', '', 0, 1, 0),
(2399, 'leads', 'new-lead-assigned', 'italian', 'New Lead Assigned to Staff Member [italian]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2400, 'client', 'client-statement', 'italian', 'Statement - Account Summary [italian]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2401, 'ticket', 'ticket-assigned-to-admin', 'italian', 'New Ticket Assigned (Sent to Staff) [italian]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', '', 0, 1, 0),
(2402, 'client', 'new-client-registered-to-admin', 'italian', 'New Customer Registration (Sent to admins) [italian]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2403, 'leads', 'new-web-to-lead-form-submitted', 'italian', 'Web to lead form submitted - Sent to lead [italian]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2404, 'staff', 'two-factor-authentication', 'italian', 'Two Factor Authentication [italian]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2405, 'project', 'project-finished-to-customer', 'italian', 'Project Marked as Finished (Sent to Customer Contacts) [italian]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2406, 'credit_note', 'credit-note-send-to-client', 'italian', 'Send Credit Note To Email [italian]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', '', 0, 1, 0),
(2407, 'tasks', 'task-status-change-to-staff', 'italian', 'Task Status Changed (Sent to Staff) [italian]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 0, 0),
(2408, 'tasks', 'task-status-change-to-contacts', 'italian', 'Task Status Changed (Sent to Customer Contacts) [italian]', 'Task Status Changed', '', '{companyname} | MIS', '', 0, 1, 0),
(2409, 'staff', 'reminder-email-staff', 'italian', 'Staff Reminder Email [italian]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2410, 'contract', 'contract-comment-to-client', 'italian', 'New Comment  (Sent to Customer Contacts) [italian]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 1, 0),
(2411, 'contract', 'contract-comment-to-admin', 'italian', 'New Comment (Sent to Staff)  [italian]', 'New Contract Comment', '', '{companyname} | MIS', '', 0, 0, 0),
(2412, 'subscriptions', 'send-subscription', 'italian', 'Send Subscription to Customer [italian]', 'Subscription Created', '', '{companyname} | MIS', '', 0, 0, 0),
(2413, 'subscriptions', 'subscription-payment-failed', 'italian', 'Subscription Payment Failed [italian]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', '', 0, 0, 0),
(2414, 'subscriptions', 'subscription-canceled', 'italian', 'Subscription Canceled (Sent to customer primary contact) [italian]', 'Your subscription has been canceled', '', '{companyname} | MIS', '', 0, 0, 0),
(2415, 'subscriptions', 'subscription-payment-succeeded', 'italian', 'Subscription Payment Succeeded (Sent to customer primary contact) [italian]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', '', 0, 0, 0),
(2416, 'contract', 'contract-expiration-to-staff', 'italian', 'Contract Expiration Reminder (Sent to Staff) [italian]', 'Contract Expiration Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2417, 'gdpr', 'gdpr-removal-request', 'italian', 'Removal Request From Contact (Sent to administrators) [italian]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2418, 'gdpr', 'gdpr-removal-request-lead', 'italian', 'Removal Request From Lead (Sent to administrators) [italian]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2419, 'client', 'client-registration-confirmed', 'italian', 'Customer Registration Confirmed [italian]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2420, 'contract', 'contract-signed-to-staff', 'italian', 'Contract Signed (Sent to Staff) [italian]', 'Customer Signed a Contract', '', '{companyname} | MIS', '', 0, 1, 0),
(2421, 'subscriptions', 'customer-subscribed-to-staff', 'italian', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [italian]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', '', 0, 0, 0),
(2422, 'client', 'contact-verification-email', 'italian', 'Email Verification (Sent to Contact After Registration) [italian]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2423, 'client', 'new-customer-profile-file-uploaded-to-staff', 'italian', 'New Customer Profile File(s) Uploaded (Sent to Staff) [italian]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2424, 'staff', 'event-notification-to-staff', 'italian', 'Event Notification (Calendar) [italian]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(2425, 'subscriptions', 'subscription-payment-requires-action', 'italian', 'Credit Card Authorization Required - SCA [italian]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', '', 0, 0, 0),
(2426, 'invoice', 'invoice-due-notice', 'italian', 'Invoice Due Notice [italian]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', '', 0, 1, 0),
(2427, 'estimate_request', 'estimate-request-submitted-to-staff', 'italian', 'Estimate Request Submitted (Sent to Staff) [italian]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2428, 'estimate_request', 'estimate-request-assigned', 'italian', 'Estimate Request Assigned (Sent to Staff) [italian]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2429, 'estimate_request', 'estimate-request-received-to-user', 'italian', 'Estimate Request Received (Sent to User) [italian]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2430, 'notifications', 'non-billed-tasks-reminder', 'italian', 'Non-billed tasks reminder (sent to selected staff members) [italian]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(2431, 'invoice', 'invoices-batch-payments', 'italian', 'Invoices Payments Recorded in Batch (Sent to Customer) [italian]', 'We have received your payments', '', '{companyname} | MIS', '', 0, 1, 0),
(2432, 'contract', 'contract-sign-reminder', 'italian', 'Contract Sign Reminder (Sent to Customer) [italian]', 'Contract Sign Reminder', '', '{companyname} | MIS', '', 0, 1, 0),
(2433, 'purchase_order', 'purchase-order-to-contact', 'italian', 'Purchase Order (Sent to contact) [italian]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2434, 'purchase_order', 'purchase-request-to-contact', 'italian', 'Purchase Request (Sent to contact) [italian]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2435, 'purchase_order', 'purchase-quotation-to-contact', 'italian', 'Purchase Quotation (Sent to contact) [italian]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2436, 'purchase_order', 'debit-note-to-contact', 'italian', 'Debit Note (Sent to contact) [italian]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2437, 'purchase_order', 'purchase-statement-to-contact', 'italian', 'Purchase Statement (Sent to contact) [italian]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2438, 'inventory_warning', 'inventory-warning-to-staff', 'italian', 'Inventory warning (Sent to staff) [italian]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2439, 'purchase_order', 'vendor-registration-confirmed', 'italian', 'Vendor Registration Confirmed [italian]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2440, 'purchase_order', 'purchase-contract-to-contact', 'italian', 'Purchase Contract (Sent to contact) [italian]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2441, 'purchase_order', 'new-contact-created', 'italian', 'New Contact Added/Registered (Welcome Email) [italian]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2442, 'purchase_order', 'purchase-request-approval', 'italian', 'Request approval [italian]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2443, 'purchase_order', 'purchase-send-approved', 'italian', 'Email send approved [italian]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2444, 'purchase_order', 'purchase-send-rejected', 'italian', 'Email send rejected [italian]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2445, 'timesheets_attendance_mgt', 'attendance_notice', 'english', 'Attendance notice', 'Timesheets - Attendance notice', '{staff_name} {type_check} at {date_time}', '{companyname} | CRM', NULL, 0, 1, 0),
(2446, 'timesheets_attendance_mgt', 'send_request_approval', 'english', 'Send request approval', 'Timesheets - Send request approval to approver', 'Hi {approver}! <br>-{staff_name} has created an apply for leave and requires your approval. Please go to this link for details and approval: {link}', '{companyname} | CRM', NULL, 0, 1, 0),
(2447, 'timesheets_attendance_mgt', 'remind_user_check_in', 'english', 'Remind user check in', 'Timesheets - Remind user check in', 'Remind you to check in today to record the start time of the shift {date_time}', '{companyname} | CRM', NULL, 0, 1, 0),
(2448, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'english', 'New application (Send to notification recipient)', 'Timesheets - New application - Send to notification recipient', '{staff_name} created a new application {link} at {date_time}', '{companyname} | CRM', NULL, 0, 1, 0),
(2449, 'purchase_order', 'purchase-order-discuss-to-vendor', 'english', 'Purchase Order Discuss (Sent to Vendor)', 'Purchase Order Discuss (Sent to Vendor)', '<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">The Purchase Order {po_number} has a new discussion.</span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {po_vendor_link}\r\n          </span><br /><br />', '{companyname} | CRM', NULL, 0, 1, 0),
(2450, 'purchase_order', 'purchase-order-discuss-to-staff', 'english', 'Purchase Order Discuss (Sent to Staff)', 'Purchase Order Discuss (Sent to staff)', '<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">The Purchase Order {po_number} has a new discussion.</span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {po_admin_link}\r\n          </span><br /><br />', '{companyname} | CRM', NULL, 0, 1, 0),
(2451, 'purchase_order', 'purchase-quotation-created-updated', 'english', 'Purchase Quotation Created/Updated (Sent to staff)', 'Purchase Quotation Created/Updated (Sent to staff)', '<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">The Purchase Quotation {pq_number} has a new change.</span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {admin_quotation_link}\r\n        </span><br /><br />', '{companyname} | CRM', NULL, 0, 1, 0),
(2452, 'purchase_order', 'purchase-invoice-created-updated', 'english', 'Purchase Invoice Created/Updated (Sent to staff)', 'Purchase Invoice Created/Updated (Sent to staff)', '<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">The Purchase Invoice {invoice_number} has a new change.</span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {invoice_link}\r\n        </span><br /><br />', '{companyname} | CRM', NULL, 0, 1, 0),
(2453, 'purchase_order', 'new-payment-approved', 'english', 'New Paymemt Approved(Sent to vendor)', 'New Paymemt Approved(Sent to vendor)', '<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">The Payment of Purchase Invoice {invoice_number} has been approved</span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {vendor_invoice_link}\r\n        </span><br /><br />', '{companyname} | CRM', NULL, 0, 1, 0),
(2454, 'purchase_order', 'vendor-contact-forgot-password', 'english', 'Create New Password', 'Forgot Password', '<h2>Create a new password</h2>\r\n     Forgot your password?<br /> To create a new password, just follow this link:<br /> <br /><a href=\"{reset_password_url}\">Reset Password</a><br /> <br /> You received this email, because it was requested by a {companyname}&nbsp;user. This is part of the procedure to create a new password on the system. If you DID NOT request a new password then please ignore this email and your password will remain the same. <br /><br /> {email_signature}', '{companyname} | CRM', NULL, 0, 1, 0),
(2455, 'purchase_order', 'vendor-contact-password-reseted', 'english', 'Your password has been changed', 'Password Reset - Confirmation', '<strong><span style=\"font-size: 14pt;\">You have changed your password.</span><br /></strong><br /> Please, keep it in your records so you dont forget it.<br /> <br /><br /><br />If this wasnt you, please contact us.<br /><br />{email_signature}', '{companyname} | CRM', NULL, 0, 1, 0),
(2456, 'purchase_order', 'purchase-order-confirmed', 'english', 'Purchase Order Confirmed(Sent to staff)', 'Purchase Order Confirmed(Sent to staff)', '<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">The Purchase Order {po_number} has been confirmed by vendor</span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {po_admin_link}\r\n  </span><br /><br />', '{companyname} | CRM', NULL, 0, 1, 0),
(2457, 'client', 'new-client-created', 'francais_canada', 'New Contact Added/Registered (Welcome Email) [francais_canada]', 'Welcome aboard', '', '{companyname} | CRM', NULL, 0, 1, 0);
INSERT INTO `tblemailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
(2458, 'invoice', 'invoice-send-to-client', 'francais_canada', 'Send Invoice to Customer [francais_canada]', 'Invoice with number {invoice_number} created', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2459, 'ticket', 'new-ticket-opened-admin', 'francais_canada', 'New Ticket Opened (Opened by Staff, Sent to Customer) [francais_canada]', 'New Support Ticket Opened', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2460, 'ticket', 'ticket-reply', 'francais_canada', 'Ticket Reply (Sent to Customer) [francais_canada]', 'New Ticket Reply', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2461, 'ticket', 'ticket-autoresponse', 'francais_canada', 'New Ticket Opened - Autoresponse [francais_canada]', 'New Support Ticket Opened', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2462, 'invoice', 'invoice-payment-recorded', 'francais_canada', 'Invoice Payment Recorded (Sent to Customer) [francais_canada]', 'Invoice Payment Recorded', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2463, 'invoice', 'invoice-overdue-notice', 'francais_canada', 'Invoice Overdue Notice [francais_canada]', 'Invoice Overdue Notice - {invoice_number}', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2464, 'invoice', 'invoice-already-send', 'francais_canada', 'Invoice Already Sent to Customer [francais_canada]', 'Invoice # {invoice_number} ', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2465, 'ticket', 'new-ticket-created-staff', 'francais_canada', 'New Ticket Created (Opened by Customer, Sent to Staff Members) [francais_canada]', 'New Ticket Created', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2466, 'estimate', 'estimate-send-to-client', 'francais_canada', 'Send Estimate to Customer [francais_canada]', 'Estimate # {estimate_number} created', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2467, 'ticket', 'ticket-reply-to-admin', 'francais_canada', 'Ticket Reply (Sent to Staff) [francais_canada]', 'New Support Ticket Reply', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2468, 'estimate', 'estimate-already-send', 'francais_canada', 'Estimate Already Sent to Customer [francais_canada]', 'Estimate # {estimate_number} ', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2469, 'contract', 'contract-expiration', 'francais_canada', 'Contract Expiration Reminder (Sent to Customer Contacts) [francais_canada]', 'Contract Expiration Reminder', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2470, 'tasks', 'task-assigned', 'francais_canada', 'New Task Assigned (Sent to Staff) [francais_canada]', 'New Task Assigned to You - {task_name}', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2471, 'tasks', 'task-added-as-follower', 'francais_canada', 'Staff Member Added as Follower on Task (Sent to Staff) [francais_canada]', 'You are added as follower on task - {task_name}', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2472, 'tasks', 'task-commented', 'francais_canada', 'New Comment on Task (Sent to Staff) [francais_canada]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2473, 'tasks', 'task-added-attachment', 'francais_canada', 'New Attachment(s) on Task (Sent to Staff) [francais_canada]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2474, 'estimate', 'estimate-declined-to-staff', 'francais_canada', 'Estimate Declined (Sent to Staff) [francais_canada]', 'Customer Declined Estimate', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2475, 'estimate', 'estimate-accepted-to-staff', 'francais_canada', 'Estimate Accepted (Sent to Staff) [francais_canada]', 'Customer Accepted Estimate', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2476, 'proposals', 'proposal-client-accepted', 'francais_canada', 'Customer Action - Accepted (Sent to Staff) [francais_canada]', 'Customer Accepted Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2477, 'proposals', 'proposal-send-to-customer', 'francais_canada', 'Send Proposal to Customer [francais_canada]', 'Proposal With Number {proposal_number} Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2478, 'proposals', 'proposal-client-declined', 'francais_canada', 'Customer Action - Declined (Sent to Staff) [francais_canada]', 'Client Declined Proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2479, 'proposals', 'proposal-client-thank-you', 'francais_canada', 'Thank You Email (Sent to Customer After Accept) [francais_canada]', 'Thank for you accepting proposal', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2480, 'proposals', 'proposal-comment-to-client', 'francais_canada', 'New Comment  (Sent to Customer/Lead) [francais_canada]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2481, 'proposals', 'proposal-comment-to-admin', 'francais_canada', 'New Comment (Sent to Staff)  [francais_canada]', 'New Proposal Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2482, 'estimate', 'estimate-thank-you-to-customer', 'francais_canada', 'Thank You Email (Sent to Customer After Accept) [francais_canada]', 'Thank for you accepting estimate', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2483, 'tasks', 'task-deadline-notification', 'francais_canada', 'Task Deadline Reminder - Sent to Assigned Members [francais_canada]', 'Task Deadline Reminder', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2484, 'contract', 'send-contract', 'francais_canada', 'Send Contract to Customer [francais_canada]', 'Contract - {contract_subject}', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2485, 'invoice', 'invoice-payment-recorded-to-staff', 'francais_canada', 'Invoice Payment Recorded (Sent to Staff) [francais_canada]', 'New Invoice Payment', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2486, 'ticket', 'auto-close-ticket', 'francais_canada', 'Auto Close Ticket [francais_canada]', 'Ticket Auto Closed', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2487, 'project', 'new-project-discussion-created-to-staff', 'francais_canada', 'New Project Discussion (Sent to Project Members) [francais_canada]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2488, 'project', 'new-project-discussion-created-to-customer', 'francais_canada', 'New Project Discussion (Sent to Customer Contacts) [francais_canada]', 'New Project Discussion Created - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2489, 'project', 'new-project-file-uploaded-to-customer', 'francais_canada', 'New Project File(s) Uploaded (Sent to Customer Contacts) [francais_canada]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2490, 'project', 'new-project-file-uploaded-to-staff', 'francais_canada', 'New Project File(s) Uploaded (Sent to Project Members) [francais_canada]', 'New Project File(s) Uploaded - {project_name}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2491, 'project', 'new-project-discussion-comment-to-customer', 'francais_canada', 'New Discussion Comment  (Sent to Customer Contacts) [francais_canada]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2492, 'project', 'new-project-discussion-comment-to-staff', 'francais_canada', 'New Discussion Comment (Sent to Project Members) [francais_canada]', 'New Discussion Comment', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2493, 'project', 'staff-added-as-project-member', 'francais_canada', 'Staff Added as Project Member [francais_canada]', 'New project assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2494, 'estimate', 'estimate-expiry-reminder', 'francais_canada', 'Estimate Expiration Reminder [francais_canada]', 'Estimate Expiration Reminder', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2495, 'proposals', 'proposal-expiry-reminder', 'francais_canada', 'Proposal Expiration Reminder [francais_canada]', 'Proposal Expiration Reminder', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2496, 'staff', 'new-staff-created', 'francais_canada', 'New Staff Created (Welcome Email) [francais_canada]', 'You are added as staff member', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2497, 'client', 'contact-forgot-password', 'francais_canada', 'Forgot Password [francais_canada]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2498, 'client', 'contact-password-reseted', 'francais_canada', 'Password Reset - Confirmation [francais_canada]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2499, 'client', 'contact-set-password', 'francais_canada', 'Set New Password [francais_canada]', 'Set new password on {companyname} ', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2500, 'staff', 'staff-forgot-password', 'francais_canada', 'Forgot Password [francais_canada]', 'Create New Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2501, 'staff', 'staff-password-reseted', 'francais_canada', 'Password Reset - Confirmation [francais_canada]', 'Your password has been changed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2502, 'project', 'assigned-to-project', 'francais_canada', 'New Project Created (Sent to Customer Contacts) [francais_canada]', 'New Project Created', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2503, 'tasks', 'task-added-attachment-to-contacts', 'francais_canada', 'New Attachment(s) on Task (Sent to Customer Contacts) [francais_canada]', 'New Attachment on Task - {task_name}', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2504, 'tasks', 'task-commented-to-contacts', 'francais_canada', 'New Comment on Task (Sent to Customer Contacts) [francais_canada]', 'New Comment on Task - {task_name}', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2505, 'leads', 'new-lead-assigned', 'francais_canada', 'New Lead Assigned to Staff Member [francais_canada]', 'New lead assigned to you', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2506, 'client', 'client-statement', 'francais_canada', 'Statement - Account Summary [francais_canada]', 'Account Statement from {statement_from} to {statement_to}', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2507, 'ticket', 'ticket-assigned-to-admin', 'francais_canada', 'New Ticket Assigned (Sent to Staff) [francais_canada]', 'New support ticket has been assigned to you', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2508, 'client', 'new-client-registered-to-admin', 'francais_canada', 'New Customer Registration (Sent to admins) [francais_canada]', 'New Customer Registration', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2509, 'leads', 'new-web-to-lead-form-submitted', 'francais_canada', 'Web to lead form submitted - Sent to lead [francais_canada]', '{lead_name} - We Received Your Request', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2510, 'staff', 'two-factor-authentication', 'francais_canada', 'Two Factor Authentication [francais_canada]', 'Confirm Your Login', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2511, 'project', 'project-finished-to-customer', 'francais_canada', 'Project Marked as Finished (Sent to Customer Contacts) [francais_canada]', 'Project Marked as Finished', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2512, 'credit_note', 'credit-note-send-to-client', 'francais_canada', 'Send Credit Note To Email [francais_canada]', 'Credit Note With Number #{credit_note_number} Created', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2513, 'tasks', 'task-status-change-to-staff', 'francais_canada', 'Task Status Changed (Sent to Staff) [francais_canada]', 'Task Status Changed', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2514, 'tasks', 'task-status-change-to-contacts', 'francais_canada', 'Task Status Changed (Sent to Customer Contacts) [francais_canada]', 'Task Status Changed', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2515, 'staff', 'reminder-email-staff', 'francais_canada', 'Staff Reminder Email [francais_canada]', 'You Have a New Reminder!', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2516, 'contract', 'contract-comment-to-client', 'francais_canada', 'New Comment  (Sent to Customer Contacts) [francais_canada]', 'New Contract Comment', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2517, 'contract', 'contract-comment-to-admin', 'francais_canada', 'New Comment (Sent to Staff)  [francais_canada]', 'New Contract Comment', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2518, 'subscriptions', 'send-subscription', 'francais_canada', 'Send Subscription to Customer [francais_canada]', 'Subscription Created', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2519, 'subscriptions', 'subscription-payment-failed', 'francais_canada', 'Subscription Payment Failed [francais_canada]', 'Your most recent invoice payment failed', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2520, 'subscriptions', 'subscription-canceled', 'francais_canada', 'Subscription Canceled (Sent to customer primary contact) [francais_canada]', 'Your subscription has been canceled', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2521, 'subscriptions', 'subscription-payment-succeeded', 'francais_canada', 'Subscription Payment Succeeded (Sent to customer primary contact) [francais_canada]', 'Subscription  Payment Receipt - {subscription_name}', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2522, 'contract', 'contract-expiration-to-staff', 'francais_canada', 'Contract Expiration Reminder (Sent to Staff) [francais_canada]', 'Contract Expiration Reminder', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2523, 'gdpr', 'gdpr-removal-request', 'francais_canada', 'Removal Request From Contact (Sent to administrators) [francais_canada]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2524, 'gdpr', 'gdpr-removal-request-lead', 'francais_canada', 'Removal Request From Lead (Sent to administrators) [francais_canada]', 'Data Removal Request Received', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2525, 'client', 'client-registration-confirmed', 'francais_canada', 'Customer Registration Confirmed [francais_canada]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2526, 'contract', 'contract-signed-to-staff', 'francais_canada', 'Contract Signed (Sent to Staff) [francais_canada]', 'Customer Signed a Contract', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2527, 'subscriptions', 'customer-subscribed-to-staff', 'francais_canada', 'Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [francais_canada]', 'Customer Subscribed to a Subscription', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2528, 'client', 'contact-verification-email', 'francais_canada', 'Email Verification (Sent to Contact After Registration) [francais_canada]', 'Verify Email Address', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2529, 'client', 'new-customer-profile-file-uploaded-to-staff', 'francais_canada', 'New Customer Profile File(s) Uploaded (Sent to Staff) [francais_canada]', 'Customer Uploaded New File(s) in Profile', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2530, 'staff', 'event-notification-to-staff', 'francais_canada', 'Event Notification (Calendar) [francais_canada]', 'Upcoming Event - {event_title}', '', '', NULL, 0, 1, 0),
(2531, 'subscriptions', 'subscription-payment-requires-action', 'francais_canada', 'Credit Card Authorization Required - SCA [francais_canada]', 'Important: Confirm your subscription {subscription_name} payment', '', '{companyname} | MIS', NULL, 0, 0, 0),
(2532, 'invoice', 'invoice-due-notice', 'francais_canada', 'Invoice Due Notice [francais_canada]', 'Your {invoice_number} will be due soon', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2533, 'estimate_request', 'estimate-request-submitted-to-staff', 'francais_canada', 'Estimate Request Submitted (Sent to Staff) [francais_canada]', 'New Estimate Request Submitted', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2534, 'estimate_request', 'estimate-request-assigned', 'francais_canada', 'Estimate Request Assigned (Sent to Staff) [francais_canada]', 'New Estimate Request Assigned', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2535, 'estimate_request', 'estimate-request-received-to-user', 'francais_canada', 'Estimate Request Received (Sent to User) [francais_canada]', 'Estimate Request Received', '', '{companyname} | CRM', NULL, 0, 0, 0),
(2536, 'notifications', 'non-billed-tasks-reminder', 'francais_canada', 'Non-billed tasks reminder (sent to selected staff members) [francais_canada]', 'Action required: Completed tasks are not billed', '', '{companyname} | MIS', '', 1, 1, 0),
(2537, 'invoice', 'invoices-batch-payments', 'francais_canada', 'Invoices Payments Recorded in Batch (Sent to Customer) [francais_canada]', 'We have received your payments', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2538, 'contract', 'contract-sign-reminder', 'francais_canada', 'Contract Sign Reminder (Sent to Customer) [francais_canada]', 'Contract Sign Reminder', '', '{companyname} | MIS', NULL, 0, 1, 0),
(2539, 'purchase_order', 'purchase-order-to-contact', 'francais_canada', 'Purchase Order (Sent to contact) [francais_canada]', 'Purchase Order', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2540, 'purchase_order', 'purchase-request-to-contact', 'francais_canada', 'Purchase Request (Sent to contact) [francais_canada]', 'Purchase Request', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2541, 'purchase_order', 'purchase-quotation-to-contact', 'francais_canada', 'Purchase Quotation (Sent to contact) [francais_canada]', 'Purchase Quotation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2542, 'purchase_order', 'debit-note-to-contact', 'francais_canada', 'Debit Note (Sent to contact) [francais_canada]', 'Debit Note', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2543, 'purchase_order', 'purchase-statement-to-contact', 'francais_canada', 'Purchase Statement (Sent to contact) [francais_canada]', 'Purchase Statement', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2544, 'inventory_warning', 'inventory-warning-to-staff', 'francais_canada', 'Inventory warning (Sent to staff) [francais_canada]', 'Inventory warning', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2545, 'purchase_order', 'vendor-registration-confirmed', 'francais_canada', 'Vendor Registration Confirmed [francais_canada]', 'Your registration is confirmed', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2546, 'purchase_order', 'purchase-contract-to-contact', 'francais_canada', 'Purchase Contract (Sent to contact) [francais_canada]', 'Purchase Contract', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2547, 'purchase_order', 'new-contact-created', 'francais_canada', 'New Contact Added/Registered (Welcome Email) [francais_canada]', 'New Contact Added/Registered (Welcome Email)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2548, 'purchase_order', 'purchase-request-approval', 'francais_canada', 'Request approval [francais_canada]', 'Request approval', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2549, 'purchase_order', 'purchase-send-approved', 'francais_canada', 'Email send approved [francais_canada]', 'Email send approved', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2550, 'purchase_order', 'purchase-send-rejected', 'francais_canada', 'Email send rejected [francais_canada]', 'Email send rejected', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2551, 'timesheets_attendance_mgt', 'attendance_notice', 'francais_canada', 'Attendance notice [francais_canada]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2552, 'timesheets_attendance_mgt', 'send_request_approval', 'francais_canada', 'Send request approval [francais_canada]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2553, 'timesheets_attendance_mgt', 'remind_user_check_in', 'francais_canada', 'Remind user check in [francais_canada]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2554, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'francais_canada', 'New application (Send to notification recipient) [francais_canada]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2555, 'purchase_order', 'purchase-order-discuss-to-vendor', 'francais_canada', 'Purchase Order Discuss (Sent to Vendor) [francais_canada]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2556, 'purchase_order', 'purchase-order-discuss-to-staff', 'francais_canada', 'Purchase Order Discuss (Sent to Staff) [francais_canada]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2557, 'purchase_order', 'purchase-quotation-created-updated', 'francais_canada', 'Purchase Quotation Created/Updated (Sent to staff) [francais_canada]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2558, 'purchase_order', 'purchase-invoice-created-updated', 'francais_canada', 'Purchase Invoice Created/Updated (Sent to staff) [francais_canada]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2559, 'purchase_order', 'new-payment-approved', 'francais_canada', 'New Paymemt Approved(Sent to vendor) [francais_canada]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2560, 'purchase_order', 'vendor-contact-forgot-password', 'francais_canada', 'Create New Password [francais_canada]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2561, 'purchase_order', 'vendor-contact-password-reseted', 'francais_canada', 'Your password has been changed [francais_canada]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2562, 'purchase_order', 'purchase-order-confirmed', 'francais_canada', 'Purchase Order Confirmed(Sent to staff) [francais_canada]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2563, 'timesheets_attendance_mgt', 'attendance_notice', 'japanese', 'Attendance notice [japanese]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2564, 'timesheets_attendance_mgt', 'send_request_approval', 'japanese', 'Send request approval [japanese]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2565, 'timesheets_attendance_mgt', 'remind_user_check_in', 'japanese', 'Remind user check in [japanese]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2566, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'japanese', 'New application (Send to notification recipient) [japanese]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2567, 'purchase_order', 'purchase-order-discuss-to-vendor', 'japanese', 'Purchase Order Discuss (Sent to Vendor) [japanese]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2568, 'purchase_order', 'purchase-order-discuss-to-staff', 'japanese', 'Purchase Order Discuss (Sent to Staff) [japanese]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2569, 'purchase_order', 'purchase-quotation-created-updated', 'japanese', 'Purchase Quotation Created/Updated (Sent to staff) [japanese]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2570, 'purchase_order', 'purchase-invoice-created-updated', 'japanese', 'Purchase Invoice Created/Updated (Sent to staff) [japanese]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2571, 'purchase_order', 'new-payment-approved', 'japanese', 'New Paymemt Approved(Sent to vendor) [japanese]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2572, 'purchase_order', 'vendor-contact-forgot-password', 'japanese', 'Create New Password [japanese]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2573, 'purchase_order', 'vendor-contact-password-reseted', 'japanese', 'Your password has been changed [japanese]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2574, 'purchase_order', 'purchase-order-confirmed', 'japanese', 'Purchase Order Confirmed(Sent to staff) [japanese]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2575, 'timesheets_attendance_mgt', 'attendance_notice', 'czech', 'Attendance notice [czech]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2576, 'timesheets_attendance_mgt', 'send_request_approval', 'czech', 'Send request approval [czech]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2577, 'timesheets_attendance_mgt', 'remind_user_check_in', 'czech', 'Remind user check in [czech]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2578, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'czech', 'New application (Send to notification recipient) [czech]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2579, 'purchase_order', 'purchase-order-discuss-to-vendor', 'czech', 'Purchase Order Discuss (Sent to Vendor) [czech]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2580, 'purchase_order', 'purchase-order-discuss-to-staff', 'czech', 'Purchase Order Discuss (Sent to Staff) [czech]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2581, 'purchase_order', 'purchase-quotation-created-updated', 'czech', 'Purchase Quotation Created/Updated (Sent to staff) [czech]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2582, 'purchase_order', 'purchase-invoice-created-updated', 'czech', 'Purchase Invoice Created/Updated (Sent to staff) [czech]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2583, 'purchase_order', 'new-payment-approved', 'czech', 'New Paymemt Approved(Sent to vendor) [czech]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2584, 'purchase_order', 'vendor-contact-forgot-password', 'czech', 'Create New Password [czech]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2585, 'purchase_order', 'vendor-contact-password-reseted', 'czech', 'Your password has been changed [czech]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2586, 'purchase_order', 'purchase-order-confirmed', 'czech', 'Purchase Order Confirmed(Sent to staff) [czech]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2587, 'timesheets_attendance_mgt', 'attendance_notice', 'polish', 'Attendance notice [polish]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2588, 'timesheets_attendance_mgt', 'send_request_approval', 'polish', 'Send request approval [polish]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2589, 'timesheets_attendance_mgt', 'remind_user_check_in', 'polish', 'Remind user check in [polish]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2590, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'polish', 'New application (Send to notification recipient) [polish]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2591, 'purchase_order', 'purchase-order-discuss-to-vendor', 'polish', 'Purchase Order Discuss (Sent to Vendor) [polish]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2592, 'purchase_order', 'purchase-order-discuss-to-staff', 'polish', 'Purchase Order Discuss (Sent to Staff) [polish]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2593, 'purchase_order', 'purchase-quotation-created-updated', 'polish', 'Purchase Quotation Created/Updated (Sent to staff) [polish]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2594, 'purchase_order', 'purchase-invoice-created-updated', 'polish', 'Purchase Invoice Created/Updated (Sent to staff) [polish]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2595, 'purchase_order', 'new-payment-approved', 'polish', 'New Paymemt Approved(Sent to vendor) [polish]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2596, 'purchase_order', 'vendor-contact-forgot-password', 'polish', 'Create New Password [polish]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2597, 'purchase_order', 'vendor-contact-password-reseted', 'polish', 'Your password has been changed [polish]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2598, 'purchase_order', 'purchase-order-confirmed', 'polish', 'Purchase Order Confirmed(Sent to staff) [polish]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2599, 'timesheets_attendance_mgt', 'attendance_notice', 'persian', 'Attendance notice [persian]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2600, 'timesheets_attendance_mgt', 'send_request_approval', 'persian', 'Send request approval [persian]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2601, 'timesheets_attendance_mgt', 'remind_user_check_in', 'persian', 'Remind user check in [persian]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2602, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'persian', 'New application (Send to notification recipient) [persian]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2603, 'purchase_order', 'purchase-order-discuss-to-vendor', 'persian', 'Purchase Order Discuss (Sent to Vendor) [persian]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2604, 'purchase_order', 'purchase-order-discuss-to-staff', 'persian', 'Purchase Order Discuss (Sent to Staff) [persian]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2605, 'purchase_order', 'purchase-quotation-created-updated', 'persian', 'Purchase Quotation Created/Updated (Sent to staff) [persian]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2606, 'purchase_order', 'purchase-invoice-created-updated', 'persian', 'Purchase Invoice Created/Updated (Sent to staff) [persian]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2607, 'purchase_order', 'new-payment-approved', 'persian', 'New Paymemt Approved(Sent to vendor) [persian]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2608, 'purchase_order', 'vendor-contact-forgot-password', 'persian', 'Create New Password [persian]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2609, 'purchase_order', 'vendor-contact-password-reseted', 'persian', 'Your password has been changed [persian]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2610, 'purchase_order', 'purchase-order-confirmed', 'persian', 'Purchase Order Confirmed(Sent to staff) [persian]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2611, 'timesheets_attendance_mgt', 'attendance_notice', 'norwegian', 'Attendance notice [norwegian]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2612, 'timesheets_attendance_mgt', 'send_request_approval', 'norwegian', 'Send request approval [norwegian]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2613, 'timesheets_attendance_mgt', 'remind_user_check_in', 'norwegian', 'Remind user check in [norwegian]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2614, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'norwegian', 'New application (Send to notification recipient) [norwegian]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2615, 'purchase_order', 'purchase-order-discuss-to-vendor', 'norwegian', 'Purchase Order Discuss (Sent to Vendor) [norwegian]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2616, 'purchase_order', 'purchase-order-discuss-to-staff', 'norwegian', 'Purchase Order Discuss (Sent to Staff) [norwegian]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2617, 'purchase_order', 'purchase-quotation-created-updated', 'norwegian', 'Purchase Quotation Created/Updated (Sent to staff) [norwegian]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2618, 'purchase_order', 'purchase-invoice-created-updated', 'norwegian', 'Purchase Invoice Created/Updated (Sent to staff) [norwegian]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2619, 'purchase_order', 'new-payment-approved', 'norwegian', 'New Paymemt Approved(Sent to vendor) [norwegian]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2620, 'purchase_order', 'vendor-contact-forgot-password', 'norwegian', 'Create New Password [norwegian]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2621, 'purchase_order', 'vendor-contact-password-reseted', 'norwegian', 'Your password has been changed [norwegian]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2622, 'purchase_order', 'purchase-order-confirmed', 'norwegian', 'Purchase Order Confirmed(Sent to staff) [norwegian]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2623, 'timesheets_attendance_mgt', 'attendance_notice', 'french', 'Attendance notice [french]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2624, 'timesheets_attendance_mgt', 'send_request_approval', 'french', 'Send request approval [french]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2625, 'timesheets_attendance_mgt', 'remind_user_check_in', 'french', 'Remind user check in [french]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2626, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'french', 'New application (Send to notification recipient) [french]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2627, 'purchase_order', 'purchase-order-discuss-to-vendor', 'french', 'Purchase Order Discuss (Sent to Vendor) [french]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2628, 'purchase_order', 'purchase-order-discuss-to-staff', 'french', 'Purchase Order Discuss (Sent to Staff) [french]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2629, 'purchase_order', 'purchase-quotation-created-updated', 'french', 'Purchase Quotation Created/Updated (Sent to staff) [french]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2630, 'purchase_order', 'purchase-invoice-created-updated', 'french', 'Purchase Invoice Created/Updated (Sent to staff) [french]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2631, 'purchase_order', 'new-payment-approved', 'french', 'New Paymemt Approved(Sent to vendor) [french]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2632, 'purchase_order', 'vendor-contact-forgot-password', 'french', 'Create New Password [french]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2633, 'purchase_order', 'vendor-contact-password-reseted', 'french', 'Your password has been changed [french]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2634, 'purchase_order', 'purchase-order-confirmed', 'french', 'Purchase Order Confirmed(Sent to staff) [french]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2635, 'timesheets_attendance_mgt', 'attendance_notice', 'ukrainian', 'Attendance notice [ukrainian]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2636, 'timesheets_attendance_mgt', 'send_request_approval', 'ukrainian', 'Send request approval [ukrainian]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2637, 'timesheets_attendance_mgt', 'remind_user_check_in', 'ukrainian', 'Remind user check in [ukrainian]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2638, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'ukrainian', 'New application (Send to notification recipient) [ukrainian]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2639, 'purchase_order', 'purchase-order-discuss-to-vendor', 'ukrainian', 'Purchase Order Discuss (Sent to Vendor) [ukrainian]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2640, 'purchase_order', 'purchase-order-discuss-to-staff', 'ukrainian', 'Purchase Order Discuss (Sent to Staff) [ukrainian]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2641, 'purchase_order', 'purchase-quotation-created-updated', 'ukrainian', 'Purchase Quotation Created/Updated (Sent to staff) [ukrainian]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2642, 'purchase_order', 'purchase-invoice-created-updated', 'ukrainian', 'Purchase Invoice Created/Updated (Sent to staff) [ukrainian]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2643, 'purchase_order', 'new-payment-approved', 'ukrainian', 'New Paymemt Approved(Sent to vendor) [ukrainian]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2644, 'purchase_order', 'vendor-contact-forgot-password', 'ukrainian', 'Create New Password [ukrainian]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2645, 'purchase_order', 'vendor-contact-password-reseted', 'ukrainian', 'Your password has been changed [ukrainian]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2646, 'purchase_order', 'purchase-order-confirmed', 'ukrainian', 'Purchase Order Confirmed(Sent to staff) [ukrainian]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2647, 'timesheets_attendance_mgt', 'attendance_notice', 'vietnamese', 'Attendance notice [vietnamese]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2648, 'timesheets_attendance_mgt', 'send_request_approval', 'vietnamese', 'Send request approval [vietnamese]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2649, 'timesheets_attendance_mgt', 'remind_user_check_in', 'vietnamese', 'Remind user check in [vietnamese]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2650, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'vietnamese', 'New application (Send to notification recipient) [vietnamese]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2651, 'purchase_order', 'purchase-order-discuss-to-vendor', 'vietnamese', 'Purchase Order Discuss (Sent to Vendor) [vietnamese]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2652, 'purchase_order', 'purchase-order-discuss-to-staff', 'vietnamese', 'Purchase Order Discuss (Sent to Staff) [vietnamese]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2653, 'purchase_order', 'purchase-quotation-created-updated', 'vietnamese', 'Purchase Quotation Created/Updated (Sent to staff) [vietnamese]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2654, 'purchase_order', 'purchase-invoice-created-updated', 'vietnamese', 'Purchase Invoice Created/Updated (Sent to staff) [vietnamese]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2655, 'purchase_order', 'new-payment-approved', 'vietnamese', 'New Paymemt Approved(Sent to vendor) [vietnamese]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2656, 'purchase_order', 'vendor-contact-forgot-password', 'vietnamese', 'Create New Password [vietnamese]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2657, 'purchase_order', 'vendor-contact-password-reseted', 'vietnamese', 'Your password has been changed [vietnamese]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2658, 'purchase_order', 'purchase-order-confirmed', 'vietnamese', 'Purchase Order Confirmed(Sent to staff) [vietnamese]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2659, 'timesheets_attendance_mgt', 'attendance_notice', 'turkish', 'Attendance notice [turkish]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2660, 'timesheets_attendance_mgt', 'send_request_approval', 'turkish', 'Send request approval [turkish]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2661, 'timesheets_attendance_mgt', 'remind_user_check_in', 'turkish', 'Remind user check in [turkish]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2662, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'turkish', 'New application (Send to notification recipient) [turkish]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2663, 'purchase_order', 'purchase-order-discuss-to-vendor', 'turkish', 'Purchase Order Discuss (Sent to Vendor) [turkish]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2664, 'purchase_order', 'purchase-order-discuss-to-staff', 'turkish', 'Purchase Order Discuss (Sent to Staff) [turkish]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2665, 'purchase_order', 'purchase-quotation-created-updated', 'turkish', 'Purchase Quotation Created/Updated (Sent to staff) [turkish]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2666, 'purchase_order', 'purchase-invoice-created-updated', 'turkish', 'Purchase Invoice Created/Updated (Sent to staff) [turkish]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2667, 'purchase_order', 'new-payment-approved', 'turkish', 'New Paymemt Approved(Sent to vendor) [turkish]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2668, 'purchase_order', 'vendor-contact-forgot-password', 'turkish', 'Create New Password [turkish]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2669, 'purchase_order', 'vendor-contact-password-reseted', 'turkish', 'Your password has been changed [turkish]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2670, 'purchase_order', 'purchase-order-confirmed', 'turkish', 'Purchase Order Confirmed(Sent to staff) [turkish]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2671, 'timesheets_attendance_mgt', 'attendance_notice', 'portuguese', 'Attendance notice [portuguese]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2672, 'timesheets_attendance_mgt', 'send_request_approval', 'portuguese', 'Send request approval [portuguese]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2673, 'timesheets_attendance_mgt', 'remind_user_check_in', 'portuguese', 'Remind user check in [portuguese]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2674, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'portuguese', 'New application (Send to notification recipient) [portuguese]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2675, 'purchase_order', 'purchase-order-discuss-to-vendor', 'portuguese', 'Purchase Order Discuss (Sent to Vendor) [portuguese]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2676, 'purchase_order', 'purchase-order-discuss-to-staff', 'portuguese', 'Purchase Order Discuss (Sent to Staff) [portuguese]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2677, 'purchase_order', 'purchase-quotation-created-updated', 'portuguese', 'Purchase Quotation Created/Updated (Sent to staff) [portuguese]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2678, 'purchase_order', 'purchase-invoice-created-updated', 'portuguese', 'Purchase Invoice Created/Updated (Sent to staff) [portuguese]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2679, 'purchase_order', 'new-payment-approved', 'portuguese', 'New Paymemt Approved(Sent to vendor) [portuguese]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2680, 'purchase_order', 'vendor-contact-forgot-password', 'portuguese', 'Create New Password [portuguese]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2681, 'purchase_order', 'vendor-contact-password-reseted', 'portuguese', 'Your password has been changed [portuguese]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2682, 'purchase_order', 'purchase-order-confirmed', 'portuguese', 'Purchase Order Confirmed(Sent to staff) [portuguese]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2683, 'timesheets_attendance_mgt', 'attendance_notice', 'finnish', 'Attendance notice [finnish]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2684, 'timesheets_attendance_mgt', 'send_request_approval', 'finnish', 'Send request approval [finnish]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2685, 'timesheets_attendance_mgt', 'remind_user_check_in', 'finnish', 'Remind user check in [finnish]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2686, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'finnish', 'New application (Send to notification recipient) [finnish]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2687, 'purchase_order', 'purchase-order-discuss-to-vendor', 'finnish', 'Purchase Order Discuss (Sent to Vendor) [finnish]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2688, 'purchase_order', 'purchase-order-discuss-to-staff', 'finnish', 'Purchase Order Discuss (Sent to Staff) [finnish]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2689, 'purchase_order', 'purchase-quotation-created-updated', 'finnish', 'Purchase Quotation Created/Updated (Sent to staff) [finnish]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2690, 'purchase_order', 'purchase-invoice-created-updated', 'finnish', 'Purchase Invoice Created/Updated (Sent to staff) [finnish]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2691, 'purchase_order', 'new-payment-approved', 'finnish', 'New Paymemt Approved(Sent to vendor) [finnish]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2692, 'purchase_order', 'vendor-contact-forgot-password', 'finnish', 'Create New Password [finnish]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2693, 'purchase_order', 'vendor-contact-password-reseted', 'finnish', 'Your password has been changed [finnish]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2694, 'purchase_order', 'purchase-order-confirmed', 'finnish', 'Purchase Order Confirmed(Sent to staff) [finnish]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2695, 'timesheets_attendance_mgt', 'attendance_notice', 'bulgarian', 'Attendance notice [bulgarian]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2696, 'timesheets_attendance_mgt', 'send_request_approval', 'bulgarian', 'Send request approval [bulgarian]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2697, 'timesheets_attendance_mgt', 'remind_user_check_in', 'bulgarian', 'Remind user check in [bulgarian]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2698, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'bulgarian', 'New application (Send to notification recipient) [bulgarian]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2699, 'purchase_order', 'purchase-order-discuss-to-vendor', 'bulgarian', 'Purchase Order Discuss (Sent to Vendor) [bulgarian]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2700, 'purchase_order', 'purchase-order-discuss-to-staff', 'bulgarian', 'Purchase Order Discuss (Sent to Staff) [bulgarian]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0);
INSERT INTO `tblemailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
(2701, 'purchase_order', 'purchase-quotation-created-updated', 'bulgarian', 'Purchase Quotation Created/Updated (Sent to staff) [bulgarian]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2702, 'purchase_order', 'purchase-invoice-created-updated', 'bulgarian', 'Purchase Invoice Created/Updated (Sent to staff) [bulgarian]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2703, 'purchase_order', 'new-payment-approved', 'bulgarian', 'New Paymemt Approved(Sent to vendor) [bulgarian]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2704, 'purchase_order', 'vendor-contact-forgot-password', 'bulgarian', 'Create New Password [bulgarian]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2705, 'purchase_order', 'vendor-contact-password-reseted', 'bulgarian', 'Your password has been changed [bulgarian]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2706, 'purchase_order', 'purchase-order-confirmed', 'bulgarian', 'Purchase Order Confirmed(Sent to staff) [bulgarian]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2707, 'timesheets_attendance_mgt', 'attendance_notice', 'indonesia', 'Attendance notice [indonesia]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2708, 'timesheets_attendance_mgt', 'send_request_approval', 'indonesia', 'Send request approval [indonesia]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2709, 'timesheets_attendance_mgt', 'remind_user_check_in', 'indonesia', 'Remind user check in [indonesia]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2710, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'indonesia', 'New application (Send to notification recipient) [indonesia]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2711, 'purchase_order', 'purchase-order-discuss-to-vendor', 'indonesia', 'Purchase Order Discuss (Sent to Vendor) [indonesia]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2712, 'purchase_order', 'purchase-order-discuss-to-staff', 'indonesia', 'Purchase Order Discuss (Sent to Staff) [indonesia]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2713, 'purchase_order', 'purchase-quotation-created-updated', 'indonesia', 'Purchase Quotation Created/Updated (Sent to staff) [indonesia]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2714, 'purchase_order', 'purchase-invoice-created-updated', 'indonesia', 'Purchase Invoice Created/Updated (Sent to staff) [indonesia]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2715, 'purchase_order', 'new-payment-approved', 'indonesia', 'New Paymemt Approved(Sent to vendor) [indonesia]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2716, 'purchase_order', 'vendor-contact-forgot-password', 'indonesia', 'Create New Password [indonesia]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2717, 'purchase_order', 'vendor-contact-password-reseted', 'indonesia', 'Your password has been changed [indonesia]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2718, 'purchase_order', 'purchase-order-confirmed', 'indonesia', 'Purchase Order Confirmed(Sent to staff) [indonesia]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2719, 'timesheets_attendance_mgt', 'attendance_notice', 'dutch', 'Attendance notice [dutch]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2720, 'timesheets_attendance_mgt', 'send_request_approval', 'dutch', 'Send request approval [dutch]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2721, 'timesheets_attendance_mgt', 'remind_user_check_in', 'dutch', 'Remind user check in [dutch]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2722, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'dutch', 'New application (Send to notification recipient) [dutch]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2723, 'purchase_order', 'purchase-order-discuss-to-vendor', 'dutch', 'Purchase Order Discuss (Sent to Vendor) [dutch]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2724, 'purchase_order', 'purchase-order-discuss-to-staff', 'dutch', 'Purchase Order Discuss (Sent to Staff) [dutch]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2725, 'purchase_order', 'purchase-quotation-created-updated', 'dutch', 'Purchase Quotation Created/Updated (Sent to staff) [dutch]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2726, 'purchase_order', 'purchase-invoice-created-updated', 'dutch', 'Purchase Invoice Created/Updated (Sent to staff) [dutch]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2727, 'purchase_order', 'new-payment-approved', 'dutch', 'New Paymemt Approved(Sent to vendor) [dutch]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2728, 'purchase_order', 'vendor-contact-forgot-password', 'dutch', 'Create New Password [dutch]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2729, 'purchase_order', 'vendor-contact-password-reseted', 'dutch', 'Your password has been changed [dutch]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2730, 'purchase_order', 'purchase-order-confirmed', 'dutch', 'Purchase Order Confirmed(Sent to staff) [dutch]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2731, 'timesheets_attendance_mgt', 'attendance_notice', 'catalan', 'Attendance notice [catalan]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2732, 'timesheets_attendance_mgt', 'send_request_approval', 'catalan', 'Send request approval [catalan]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2733, 'timesheets_attendance_mgt', 'remind_user_check_in', 'catalan', 'Remind user check in [catalan]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2734, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'catalan', 'New application (Send to notification recipient) [catalan]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2735, 'purchase_order', 'purchase-order-discuss-to-vendor', 'catalan', 'Purchase Order Discuss (Sent to Vendor) [catalan]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2736, 'purchase_order', 'purchase-order-discuss-to-staff', 'catalan', 'Purchase Order Discuss (Sent to Staff) [catalan]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2737, 'purchase_order', 'purchase-quotation-created-updated', 'catalan', 'Purchase Quotation Created/Updated (Sent to staff) [catalan]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2738, 'purchase_order', 'purchase-invoice-created-updated', 'catalan', 'Purchase Invoice Created/Updated (Sent to staff) [catalan]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2739, 'purchase_order', 'new-payment-approved', 'catalan', 'New Paymemt Approved(Sent to vendor) [catalan]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2740, 'purchase_order', 'vendor-contact-forgot-password', 'catalan', 'Create New Password [catalan]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2741, 'purchase_order', 'vendor-contact-password-reseted', 'catalan', 'Your password has been changed [catalan]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2742, 'purchase_order', 'purchase-order-confirmed', 'catalan', 'Purchase Order Confirmed(Sent to staff) [catalan]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2743, 'timesheets_attendance_mgt', 'attendance_notice', 'chinese', 'Attendance notice [chinese]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2744, 'timesheets_attendance_mgt', 'send_request_approval', 'chinese', 'Send request approval [chinese]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2745, 'timesheets_attendance_mgt', 'remind_user_check_in', 'chinese', 'Remind user check in [chinese]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2746, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'chinese', 'New application (Send to notification recipient) [chinese]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2747, 'purchase_order', 'purchase-order-discuss-to-vendor', 'chinese', 'Purchase Order Discuss (Sent to Vendor) [chinese]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2748, 'purchase_order', 'purchase-order-discuss-to-staff', 'chinese', 'Purchase Order Discuss (Sent to Staff) [chinese]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2749, 'purchase_order', 'purchase-quotation-created-updated', 'chinese', 'Purchase Quotation Created/Updated (Sent to staff) [chinese]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2750, 'purchase_order', 'purchase-invoice-created-updated', 'chinese', 'Purchase Invoice Created/Updated (Sent to staff) [chinese]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2751, 'purchase_order', 'new-payment-approved', 'chinese', 'New Paymemt Approved(Sent to vendor) [chinese]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2752, 'purchase_order', 'vendor-contact-forgot-password', 'chinese', 'Create New Password [chinese]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2753, 'purchase_order', 'vendor-contact-password-reseted', 'chinese', 'Your password has been changed [chinese]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2754, 'purchase_order', 'purchase-order-confirmed', 'chinese', 'Purchase Order Confirmed(Sent to staff) [chinese]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2755, 'timesheets_attendance_mgt', 'attendance_notice', 'russian', 'Attendance notice [russian]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2756, 'timesheets_attendance_mgt', 'send_request_approval', 'russian', 'Send request approval [russian]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2757, 'timesheets_attendance_mgt', 'remind_user_check_in', 'russian', 'Remind user check in [russian]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2758, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'russian', 'New application (Send to notification recipient) [russian]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2759, 'purchase_order', 'purchase-order-discuss-to-vendor', 'russian', 'Purchase Order Discuss (Sent to Vendor) [russian]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2760, 'purchase_order', 'purchase-order-discuss-to-staff', 'russian', 'Purchase Order Discuss (Sent to Staff) [russian]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2761, 'purchase_order', 'purchase-quotation-created-updated', 'russian', 'Purchase Quotation Created/Updated (Sent to staff) [russian]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2762, 'purchase_order', 'purchase-invoice-created-updated', 'russian', 'Purchase Invoice Created/Updated (Sent to staff) [russian]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2763, 'purchase_order', 'new-payment-approved', 'russian', 'New Paymemt Approved(Sent to vendor) [russian]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2764, 'purchase_order', 'vendor-contact-forgot-password', 'russian', 'Create New Password [russian]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2765, 'purchase_order', 'vendor-contact-password-reseted', 'russian', 'Your password has been changed [russian]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2766, 'purchase_order', 'purchase-order-confirmed', 'russian', 'Purchase Order Confirmed(Sent to staff) [russian]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2767, 'timesheets_attendance_mgt', 'attendance_notice', 'slovak', 'Attendance notice [slovak]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2768, 'timesheets_attendance_mgt', 'send_request_approval', 'slovak', 'Send request approval [slovak]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2769, 'timesheets_attendance_mgt', 'remind_user_check_in', 'slovak', 'Remind user check in [slovak]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2770, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'slovak', 'New application (Send to notification recipient) [slovak]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2771, 'purchase_order', 'purchase-order-discuss-to-vendor', 'slovak', 'Purchase Order Discuss (Sent to Vendor) [slovak]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2772, 'purchase_order', 'purchase-order-discuss-to-staff', 'slovak', 'Purchase Order Discuss (Sent to Staff) [slovak]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2773, 'purchase_order', 'purchase-quotation-created-updated', 'slovak', 'Purchase Quotation Created/Updated (Sent to staff) [slovak]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2774, 'purchase_order', 'purchase-invoice-created-updated', 'slovak', 'Purchase Invoice Created/Updated (Sent to staff) [slovak]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2775, 'purchase_order', 'new-payment-approved', 'slovak', 'New Paymemt Approved(Sent to vendor) [slovak]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2776, 'purchase_order', 'vendor-contact-forgot-password', 'slovak', 'Create New Password [slovak]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2777, 'purchase_order', 'vendor-contact-password-reseted', 'slovak', 'Your password has been changed [slovak]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2778, 'purchase_order', 'purchase-order-confirmed', 'slovak', 'Purchase Order Confirmed(Sent to staff) [slovak]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2779, 'timesheets_attendance_mgt', 'attendance_notice', 'spanish', 'Attendance notice [spanish]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2780, 'timesheets_attendance_mgt', 'send_request_approval', 'spanish', 'Send request approval [spanish]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2781, 'timesheets_attendance_mgt', 'remind_user_check_in', 'spanish', 'Remind user check in [spanish]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2782, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'spanish', 'New application (Send to notification recipient) [spanish]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2783, 'purchase_order', 'purchase-order-discuss-to-vendor', 'spanish', 'Purchase Order Discuss (Sent to Vendor) [spanish]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2784, 'purchase_order', 'purchase-order-discuss-to-staff', 'spanish', 'Purchase Order Discuss (Sent to Staff) [spanish]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2785, 'purchase_order', 'purchase-quotation-created-updated', 'spanish', 'Purchase Quotation Created/Updated (Sent to staff) [spanish]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2786, 'purchase_order', 'purchase-invoice-created-updated', 'spanish', 'Purchase Invoice Created/Updated (Sent to staff) [spanish]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2787, 'purchase_order', 'new-payment-approved', 'spanish', 'New Paymemt Approved(Sent to vendor) [spanish]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2788, 'purchase_order', 'vendor-contact-forgot-password', 'spanish', 'Create New Password [spanish]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2789, 'purchase_order', 'vendor-contact-password-reseted', 'spanish', 'Your password has been changed [spanish]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2790, 'purchase_order', 'purchase-order-confirmed', 'spanish', 'Purchase Order Confirmed(Sent to staff) [spanish]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2791, 'timesheets_attendance_mgt', 'attendance_notice', 'swedish', 'Attendance notice [swedish]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2792, 'timesheets_attendance_mgt', 'send_request_approval', 'swedish', 'Send request approval [swedish]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2793, 'timesheets_attendance_mgt', 'remind_user_check_in', 'swedish', 'Remind user check in [swedish]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2794, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'swedish', 'New application (Send to notification recipient) [swedish]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2795, 'purchase_order', 'purchase-order-discuss-to-vendor', 'swedish', 'Purchase Order Discuss (Sent to Vendor) [swedish]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2796, 'purchase_order', 'purchase-order-discuss-to-staff', 'swedish', 'Purchase Order Discuss (Sent to Staff) [swedish]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2797, 'purchase_order', 'purchase-quotation-created-updated', 'swedish', 'Purchase Quotation Created/Updated (Sent to staff) [swedish]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2798, 'purchase_order', 'purchase-invoice-created-updated', 'swedish', 'Purchase Invoice Created/Updated (Sent to staff) [swedish]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2799, 'purchase_order', 'new-payment-approved', 'swedish', 'New Paymemt Approved(Sent to vendor) [swedish]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2800, 'purchase_order', 'vendor-contact-forgot-password', 'swedish', 'Create New Password [swedish]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2801, 'purchase_order', 'vendor-contact-password-reseted', 'swedish', 'Your password has been changed [swedish]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2802, 'purchase_order', 'purchase-order-confirmed', 'swedish', 'Purchase Order Confirmed(Sent to staff) [swedish]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2803, 'timesheets_attendance_mgt', 'attendance_notice', 'greek', 'Attendance notice [greek]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2804, 'timesheets_attendance_mgt', 'send_request_approval', 'greek', 'Send request approval [greek]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2805, 'timesheets_attendance_mgt', 'remind_user_check_in', 'greek', 'Remind user check in [greek]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2806, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'greek', 'New application (Send to notification recipient) [greek]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2807, 'purchase_order', 'purchase-order-discuss-to-vendor', 'greek', 'Purchase Order Discuss (Sent to Vendor) [greek]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2808, 'purchase_order', 'purchase-order-discuss-to-staff', 'greek', 'Purchase Order Discuss (Sent to Staff) [greek]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2809, 'purchase_order', 'purchase-quotation-created-updated', 'greek', 'Purchase Quotation Created/Updated (Sent to staff) [greek]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2810, 'purchase_order', 'purchase-invoice-created-updated', 'greek', 'Purchase Invoice Created/Updated (Sent to staff) [greek]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2811, 'purchase_order', 'new-payment-approved', 'greek', 'New Paymemt Approved(Sent to vendor) [greek]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2812, 'purchase_order', 'vendor-contact-forgot-password', 'greek', 'Create New Password [greek]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2813, 'purchase_order', 'vendor-contact-password-reseted', 'greek', 'Your password has been changed [greek]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2814, 'purchase_order', 'purchase-order-confirmed', 'greek', 'Purchase Order Confirmed(Sent to staff) [greek]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2815, 'timesheets_attendance_mgt', 'attendance_notice', 'german', 'Attendance notice [german]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2816, 'timesheets_attendance_mgt', 'send_request_approval', 'german', 'Send request approval [german]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2817, 'timesheets_attendance_mgt', 'remind_user_check_in', 'german', 'Remind user check in [german]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2818, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'german', 'New application (Send to notification recipient) [german]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2819, 'purchase_order', 'purchase-order-discuss-to-vendor', 'german', 'Purchase Order Discuss (Sent to Vendor) [german]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2820, 'purchase_order', 'purchase-order-discuss-to-staff', 'german', 'Purchase Order Discuss (Sent to Staff) [german]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2821, 'purchase_order', 'purchase-quotation-created-updated', 'german', 'Purchase Quotation Created/Updated (Sent to staff) [german]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2822, 'purchase_order', 'purchase-invoice-created-updated', 'german', 'Purchase Invoice Created/Updated (Sent to staff) [german]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2823, 'purchase_order', 'new-payment-approved', 'german', 'New Paymemt Approved(Sent to vendor) [german]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2824, 'purchase_order', 'vendor-contact-forgot-password', 'german', 'Create New Password [german]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2825, 'purchase_order', 'vendor-contact-password-reseted', 'german', 'Your password has been changed [german]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2826, 'purchase_order', 'purchase-order-confirmed', 'german', 'Purchase Order Confirmed(Sent to staff) [german]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2827, 'timesheets_attendance_mgt', 'attendance_notice', 'romanian', 'Attendance notice [romanian]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2828, 'timesheets_attendance_mgt', 'send_request_approval', 'romanian', 'Send request approval [romanian]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2829, 'timesheets_attendance_mgt', 'remind_user_check_in', 'romanian', 'Remind user check in [romanian]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2830, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'romanian', 'New application (Send to notification recipient) [romanian]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2831, 'purchase_order', 'purchase-order-discuss-to-vendor', 'romanian', 'Purchase Order Discuss (Sent to Vendor) [romanian]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2832, 'purchase_order', 'purchase-order-discuss-to-staff', 'romanian', 'Purchase Order Discuss (Sent to Staff) [romanian]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2833, 'purchase_order', 'purchase-quotation-created-updated', 'romanian', 'Purchase Quotation Created/Updated (Sent to staff) [romanian]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2834, 'purchase_order', 'purchase-invoice-created-updated', 'romanian', 'Purchase Invoice Created/Updated (Sent to staff) [romanian]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2835, 'purchase_order', 'new-payment-approved', 'romanian', 'New Paymemt Approved(Sent to vendor) [romanian]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2836, 'purchase_order', 'vendor-contact-forgot-password', 'romanian', 'Create New Password [romanian]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2837, 'purchase_order', 'vendor-contact-password-reseted', 'romanian', 'Your password has been changed [romanian]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2838, 'purchase_order', 'purchase-order-confirmed', 'romanian', 'Purchase Order Confirmed(Sent to staff) [romanian]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2839, 'timesheets_attendance_mgt', 'attendance_notice', 'portuguese_br', 'Attendance notice [portuguese_br]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2840, 'timesheets_attendance_mgt', 'send_request_approval', 'portuguese_br', 'Send request approval [portuguese_br]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2841, 'timesheets_attendance_mgt', 'remind_user_check_in', 'portuguese_br', 'Remind user check in [portuguese_br]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2842, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'portuguese_br', 'New application (Send to notification recipient) [portuguese_br]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2843, 'purchase_order', 'purchase-order-discuss-to-vendor', 'portuguese_br', 'Purchase Order Discuss (Sent to Vendor) [portuguese_br]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2844, 'purchase_order', 'purchase-order-discuss-to-staff', 'portuguese_br', 'Purchase Order Discuss (Sent to Staff) [portuguese_br]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2845, 'purchase_order', 'purchase-quotation-created-updated', 'portuguese_br', 'Purchase Quotation Created/Updated (Sent to staff) [portuguese_br]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2846, 'purchase_order', 'purchase-invoice-created-updated', 'portuguese_br', 'Purchase Invoice Created/Updated (Sent to staff) [portuguese_br]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2847, 'purchase_order', 'new-payment-approved', 'portuguese_br', 'New Paymemt Approved(Sent to vendor) [portuguese_br]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2848, 'purchase_order', 'vendor-contact-forgot-password', 'portuguese_br', 'Create New Password [portuguese_br]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2849, 'purchase_order', 'vendor-contact-password-reseted', 'portuguese_br', 'Your password has been changed [portuguese_br]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2850, 'purchase_order', 'purchase-order-confirmed', 'portuguese_br', 'Purchase Order Confirmed(Sent to staff) [portuguese_br]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2851, 'timesheets_attendance_mgt', 'attendance_notice', 'italian', 'Attendance notice [italian]', 'Timesheets - Attendance notice', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2852, 'timesheets_attendance_mgt', 'send_request_approval', 'italian', 'Send request approval [italian]', 'Timesheets - Send request approval to approver', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2853, 'timesheets_attendance_mgt', 'remind_user_check_in', 'italian', 'Remind user check in [italian]', 'Timesheets - Remind user check in', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2854, 'timesheets_attendance_mgt', 'new_leave_application_send_to_notification_recipient', 'italian', 'New application (Send to notification recipient) [italian]', 'Timesheets - New application - Send to notification recipient', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2855, 'purchase_order', 'purchase-order-discuss-to-vendor', 'italian', 'Purchase Order Discuss (Sent to Vendor) [italian]', 'Purchase Order Discuss (Sent to Vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2856, 'purchase_order', 'purchase-order-discuss-to-staff', 'italian', 'Purchase Order Discuss (Sent to Staff) [italian]', 'Purchase Order Discuss (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2857, 'purchase_order', 'purchase-quotation-created-updated', 'italian', 'Purchase Quotation Created/Updated (Sent to staff) [italian]', 'Purchase Quotation Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2858, 'purchase_order', 'purchase-invoice-created-updated', 'italian', 'Purchase Invoice Created/Updated (Sent to staff) [italian]', 'Purchase Invoice Created/Updated (Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2859, 'purchase_order', 'new-payment-approved', 'italian', 'New Paymemt Approved(Sent to vendor) [italian]', 'New Paymemt Approved(Sent to vendor)', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2860, 'purchase_order', 'vendor-contact-forgot-password', 'italian', 'Create New Password [italian]', 'Forgot Password', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2861, 'purchase_order', 'vendor-contact-password-reseted', 'italian', 'Your password has been changed [italian]', 'Password Reset - Confirmation', '', '{companyname} | CRM', NULL, 0, 1, 0),
(2862, 'purchase_order', 'purchase-order-confirmed', 'italian', 'Purchase Order Confirmed(Sent to staff) [italian]', 'Purchase Order Confirmed(Sent to staff)', '', '{companyname} | CRM', NULL, 0, 1, 0);

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

--
-- Table structure for table `tblestimates`
--

CREATE TABLE `tblestimates` (
  `id` int(11) NOT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT 0,
  `datesend` datetime DEFAULT NULL,
  `clientid` int(11) NOT NULL,
  `deleted_customer_name` varchar(100) DEFAULT NULL,
  `project_id` int(11) NOT NULL DEFAULT 0,
  `number` int(11) NOT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `number_format` int(11) NOT NULL DEFAULT 0,
  `formatted_number` varchar(100) DEFAULT NULL,
  `hash` varchar(32) DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `expirydate` date DEFAULT NULL,
  `currency` int(11) NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `total_tax` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total` decimal(15,2) NOT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `addedfrom` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `clientnote` mediumtext DEFAULT NULL,
  `adminnote` mediumtext DEFAULT NULL,
  `discount_percent` decimal(15,2) DEFAULT 0.00,
  `discount_total` decimal(15,2) DEFAULT 0.00,
  `discount_type` varchar(30) DEFAULT NULL,
  `invoiceid` int(11) DEFAULT NULL,
  `invoiced_date` datetime DEFAULT NULL,
  `terms` mediumtext DEFAULT NULL,
  `reference_no` varchar(100) DEFAULT NULL,
  `sale_agent` int(11) NOT NULL DEFAULT 0,
  `billing_street` varchar(200) DEFAULT NULL,
  `billing_city` varchar(100) DEFAULT NULL,
  `billing_state` varchar(100) DEFAULT NULL,
  `billing_zip` varchar(100) DEFAULT NULL,
  `billing_country` int(11) DEFAULT NULL,
  `shipping_street` varchar(200) DEFAULT NULL,
  `shipping_city` varchar(100) DEFAULT NULL,
  `shipping_state` varchar(100) DEFAULT NULL,
  `shipping_zip` varchar(100) DEFAULT NULL,
  `shipping_country` int(11) DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_estimate` tinyint(1) NOT NULL DEFAULT 1,
  `show_quantity_as` int(11) NOT NULL DEFAULT 1,
  `pipeline_order` int(11) DEFAULT 1,
  `is_expiry_notified` int(11) NOT NULL DEFAULT 0,
  `acceptance_firstname` varchar(50) DEFAULT NULL,
  `acceptance_lastname` varchar(50) DEFAULT NULL,
  `acceptance_email` varchar(100) DEFAULT NULL,
  `acceptance_date` datetime DEFAULT NULL,
  `acceptance_ip` varchar(40) DEFAULT NULL,
  `signature` varchar(40) DEFAULT NULL,
  `short_link` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblestimate_requests`
--

CREATE TABLE `tblestimate_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(100) NOT NULL,
  `submission` longtext NOT NULL,
  `last_status_change` datetime DEFAULT NULL,
  `date_estimated` datetime DEFAULT NULL,
  `from_form_id` int(11) DEFAULT NULL,
  `assigned` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `default_language` int(11) NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblestimate_request_forms`
--

CREATE TABLE `tblestimate_request_forms` (
  `id` int(10) UNSIGNED NOT NULL,
  `form_key` varchar(32) NOT NULL,
  `type` varchar(100) NOT NULL,
  `name` varchar(191) NOT NULL,
  `form_data` longtext DEFAULT NULL,
  `recaptcha` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `submit_btn_name` varchar(100) DEFAULT NULL,
  `submit_btn_bg_color` varchar(10) DEFAULT '#84c529',
  `submit_btn_text_color` varchar(10) DEFAULT '#ffffff',
  `success_submit_msg` mediumtext DEFAULT NULL,
  `submit_action` int(11) DEFAULT 0,
  `submit_redirect_url` longtext DEFAULT NULL,
  `language` varchar(100) DEFAULT NULL,
  `dateadded` datetime DEFAULT NULL,
  `notify_type` varchar(100) DEFAULT NULL,
  `notify_ids` longtext DEFAULT NULL,
  `responsible` int(11) DEFAULT NULL,
  `notify_request_submitted` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblestimate_request_status`
--

CREATE TABLE `tblestimate_request_status` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `statusorder` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  `flag` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblestimate_request_status`
--

INSERT INTO `tblestimate_request_status` (`id`, `name`, `statusorder`, `color`, `flag`) VALUES
(1, 'Cancelled', 1, '#808080', 'cancelled'),
(2, 'Processing', 2, '#007bff', 'processing'),
(3, 'Completed', 3, '#28a745', 'completed');

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

--
-- Table structure for table `tblevents`
--

CREATE TABLE `tblevents` (
  `eventid` int(11) NOT NULL,
  `title` longtext NOT NULL,
  `description` mediumtext DEFAULT NULL,
  `userid` int(11) NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `public` int(11) NOT NULL DEFAULT 0,
  `color` varchar(10) DEFAULT NULL,
  `isstartnotified` tinyint(1) NOT NULL DEFAULT 0,
  `reminder_before` int(11) NOT NULL DEFAULT 0,
  `reminder_before_type` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tblexpenses`
--

CREATE TABLE `tblexpenses` (
  `id` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `currency` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `tax` int(11) DEFAULT NULL,
  `tax2` int(11) NOT NULL DEFAULT 0,
  `reference_no` varchar(100) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `expense_name` varchar(191) DEFAULT NULL,
  `clientid` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT 0,
  `billable` int(11) DEFAULT 0,
  `invoiceid` int(11) DEFAULT NULL,
  `paymentmode` varchar(50) DEFAULT NULL,
  `date` date NOT NULL,
  `recurring_type` varchar(10) DEFAULT NULL,
  `repeat_every` int(11) DEFAULT NULL,
  `recurring` int(11) NOT NULL DEFAULT 0,
  `cycles` int(11) NOT NULL DEFAULT 0,
  `total_cycles` int(11) NOT NULL DEFAULT 0,
  `custom_recurring` int(11) NOT NULL DEFAULT 0,
  `last_recurring_date` date DEFAULT NULL,
  `create_invoice_billable` tinyint(1) DEFAULT NULL,
  `send_invoice_to_customer` tinyint(1) NOT NULL,
  `recurring_from` int(11) DEFAULT NULL,
  `dateadded` datetime NOT NULL,
  `addedfrom` int(11) NOT NULL,
  `vendor` int(11) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `date_paid` date DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `is_bill` int(11) NOT NULL DEFAULT 0,
  `reason_for_void` text DEFAULT NULL,
  `voided` int(11) NOT NULL DEFAULT 0,
  `approved` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblexpenses`
--

INSERT INTO `tblexpenses` (`id`, `category`, `currency`, `amount`, `tax`, `tax2`, `reference_no`, `note`, `expense_name`, `clientid`, `project_id`, `billable`, `invoiceid`, `paymentmode`, `date`, `recurring_type`, `repeat_every`, `recurring`, `cycles`, `total_cycles`, `custom_recurring`, `last_recurring_date`, `create_invoice_billable`, `send_invoice_to_customer`, `recurring_from`, `dateadded`, `addedfrom`, `vendor`, `due_date`, `date_paid`, `status`, `is_bill`, `reason_for_void`, `voided`, `approved`) VALUES
(1, 6, 3, 2000000.00, 0, 0, '', '', 'Test Expense', 0, 0, 0, NULL, '1', '2024-07-30', NULL, 0, 0, 0, 0, 0, NULL, 0, 0, NULL, '2024-07-30 15:55:47', 3, 0, NULL, NULL, NULL, 0, NULL, 0, 0),
(2, 1, 3, -300000.00, 0, 0, '', 'Untuk balikin sisa biaya yg udah keluar', 'Test Biaya Minus', 0, 0, 0, NULL, '1', '2025-01-05', NULL, 0, 0, 0, 0, 0, NULL, 0, 0, NULL, '2025-01-05 23:12:22', 1, 0, NULL, NULL, NULL, 0, NULL, 0, 0);

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

--
-- Table structure for table `tblexpenses_categories`
--

CREATE TABLE `tblexpenses_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblexpenses_categories`
--

INSERT INTO `tblexpenses_categories` (`id`, `name`, `description`) VALUES
(1, 'Office Operation Expenses', ''),
(2, 'Exploration Expenses', ''),
(3, 'Mining Expenses', ''),
(4, 'Hauling Expenses', ''),
(5, 'Assets Maintenance Expenses', ''),
(6, 'Site Operation Expenses', ''),
(7, 'Jeti Operation Expenses', ''),
(8, 'Intermediate Operation Expenses', ''),
(9, 'Payroll Expenses', ''),
(10, 'Social Responsibility Expenses', '');

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

--
-- Table structure for table `tblfe_activity_log`
--

CREATE TABLE `tblfe_activity_log` (
  `id` int(11) NOT NULL,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `staffid` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `note` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `tblfe_approval_details`
--

CREATE TABLE `tblfe_approval_details` (
  `id` int(11) NOT NULL,
  `rel_id` int(11) NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `staffid` varchar(45) DEFAULT NULL,
  `approve` varchar(45) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `approve_action` varchar(255) DEFAULT NULL,
  `reject_action` varchar(255) DEFAULT NULL,
  `approve_value` varchar(255) DEFAULT NULL,
  `reject_value` varchar(255) DEFAULT NULL,
  `staff_approve` int(11) DEFAULT NULL,
  `action` varchar(45) DEFAULT NULL,
  `sender` int(11) DEFAULT NULL,
  `date_send` datetime DEFAULT NULL,
  `notification_recipient` longtext DEFAULT NULL,
  `approval_deadline` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tblfe_approval_setting`
--

CREATE TABLE `tblfe_approval_setting` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `related` varchar(255) NOT NULL,
  `setting` longtext NOT NULL,
  `choose_when_approving` int(11) NOT NULL DEFAULT 0,
  `notification_recipient` longtext DEFAULT NULL,
  `number_day_approval` int(11) DEFAULT NULL,
  `departments` text DEFAULT NULL,
  `job_positions` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tblfe_assets`
--

CREATE TABLE `tblfe_assets` (
  `id` int(11) NOT NULL,
  `assets_code` varchar(20) DEFAULT NULL,
  `assets_name` varchar(255) DEFAULT NULL,
  `series` varchar(200) DEFAULT NULL,
  `asset_group` int(11) DEFAULT NULL,
  `asset_location` int(11) DEFAULT NULL,
  `model_id` int(11) DEFAULT NULL,
  `date_buy` date DEFAULT NULL,
  `warranty_period` int(11) DEFAULT NULL,
  `unit_price` decimal(15,2) DEFAULT NULL,
  `depreciation` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `order_number` varchar(150) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `requestable` int(11) DEFAULT 0,
  `qr_code` varchar(300) DEFAULT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'asset',
  `status` int(11) NOT NULL DEFAULT 1,
  `checkin_out` int(11) NOT NULL DEFAULT 1,
  `date_creator` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `quantity` int(11) DEFAULT NULL,
  `min_quantity` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `product_key` text DEFAULT NULL,
  `seats` varchar(50) DEFAULT NULL,
  `model_no` varchar(80) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `manufacturer_id` int(11) DEFAULT NULL,
  `licensed_to_name` text DEFAULT NULL,
  `licensed_to_email` text DEFAULT NULL,
  `reassignable` int(11) NOT NULL DEFAULT 0,
  `termination_date` date DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `purchase_order_number` varchar(150) DEFAULT NULL,
  `maintained` int(11) NOT NULL DEFAULT 0,
  `item_no` varchar(80) DEFAULT NULL,
  `checkin_out_id` int(11) DEFAULT NULL,
  `active` int(11) NOT NULL DEFAULT 1,
  `selling_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `rental_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `for_rent` int(11) NOT NULL DEFAULT 0,
  `for_sell` int(11) NOT NULL DEFAULT 0,
  `renting_period` decimal(15,2) DEFAULT NULL,
  `renting_unit` varchar(10) DEFAULT NULL COMMENT 'hour day week month year',
  `warehouse_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblfe_assets`
--

INSERT INTO `tblfe_assets` (`id`, `assets_code`, `assets_name`, `series`, `asset_group`, `asset_location`, `model_id`, `date_buy`, `warranty_period`, `unit_price`, `depreciation`, `supplier_id`, `order_number`, `description`, `requestable`, `qr_code`, `type`, `status`, `checkin_out`, `date_creator`, `updated_at`, `quantity`, `min_quantity`, `category_id`, `product_key`, `seats`, `model_no`, `location_id`, `manufacturer_id`, `licensed_to_name`, `licensed_to_email`, `reassignable`, `termination_date`, `expiration_date`, `purchase_order_number`, `maintained`, `item_no`, `checkin_out_id`, `active`, `selling_price`, `rental_price`, `for_rent`, `for_sell`, `renting_period`, `renting_unit`, `warehouse_id`) VALUES
(1, NULL, 'Solar', NULL, NULL, 0, NULL, NULL, NULL, 10.00, NULL, NULL, '', NULL, 0, NULL, 'consumable', 1, 1, '2024-06-18 08:37:54', '2024-06-18 08:37:54', 200, 20, 1, NULL, NULL, '', NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, 0, '', NULL, 1, 15.00, 0.00, 0, 1, NULL, NULL, NULL),
(2, NULL, 'Solar', NULL, NULL, 0, NULL, '2024-06-17', NULL, 9000.00, NULL, NULL, '', NULL, 0, NULL, 'consumable', 1, 1, '2024-06-18 08:59:36', '2024-06-18 08:59:36', 100, 20, 1, NULL, NULL, '', NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, 0, '', NULL, 1, 15000.00, 0.00, 0, 1, NULL, NULL, NULL),
(3, NULL, 'LENOVO IDEAPAD PRO 5 I7', 'IT.H-2405-00001', NULL, 0, 1, '2024-05-13', 24, 18500000.00, NULL, 2, '', '', 0, '2d2b37072e06a01053d4a4d100061082', 'asset', 1, 2, '2024-06-20 06:55:28', '2024-06-20 06:55:28', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 3, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(4, NULL, 'KEYBOARD LENOVO IDEAPAD PRO 5 I7', '', NULL, 1, NULL, NULL, NULL, 0.00, NULL, NULL, '', NULL, 0, NULL, 'component', 1, 1, '2024-06-20 07:01:35', '2024-06-20 07:01:35', 5, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, 0, 0.00, 0.00, 0, 0, NULL, NULL, NULL),
(5, NULL, 'SAMSUNG GALAXY TAB S9 FE+ 12/256GB', 'IT.H-2503-00001', NULL, 0, 3, '2025-03-24', 0, 10724000.00, NULL, 4, '', '', 0, '853a9f5684a743b3a416682d24424fb4', 'asset', 1, 2, '2025-04-11 03:32:47', '2025-04-11 03:32:47', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 5, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(6, NULL, 'SAMSUNG GALAXY TAB S9 FE+ 12/256GB', 'IT.H-2503-00002', NULL, 0, 3, '2025-03-24', 0, 10724000.00, NULL, 4, '', '', 0, '739902602623ad02c2b557ca231010b2', 'asset', 1, 2, '2025-04-11 03:35:06', '2025-04-11 03:35:06', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 21, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(7, NULL, 'SAMSUNG GALAXY TAB S9 FE+ 12/256GB', 'IT.H-2503-00003', NULL, 0, 3, '2025-03-24', 0, 10724000.00, NULL, 4, '', '', 0, '7b88d42ecca88d852557d6bff9f7d5d1', 'asset', 1, 2, '2025-04-11 03:35:56', '2025-04-11 03:35:56', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 20, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(8, NULL, 'SAMSUNG GALAXY TAB S9 FE+ 12/256GB', 'IT.H-2503-00004', NULL, 0, 3, '2025-03-24', 0, 10724000.00, NULL, 4, '', '', 0, '2f222a9a20a32cdeca61a8858faf9e82', 'asset', 1, 2, '2025-04-11 03:36:39', '2025-04-11 03:36:39', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 19, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(9, NULL, 'SAMSUNG GALAXY TAB S9 FE+ 12/256GB', 'IT.H-2503-00005', NULL, 0, 3, '2025-03-24', 0, 10724000.00, NULL, 4, '', '', 0, '452d044bf23fbd0e43260cdbac4e0966', 'asset', 1, 2, '2025-04-11 03:37:16', '2025-04-11 03:37:16', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 18, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(10, NULL, 'SAMSUNG GALAXY TAB S10 ULTRA 5G 12/256GB', 'IT.H-2503-00006', NULL, 0, 4, '2025-03-24', 0, 21499000.00, NULL, 4, '', '', 0, 'c63be54f6cbe34126154bd650abad132', 'asset', 1, 2, '2025-04-11 03:38:40', '2025-04-11 03:38:40', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 17, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(11, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00007', NULL, 0, 2, '2025-03-18', 0, 3799000.00, NULL, 6, '', '', 0, '39cd26a758e3fbfa9b615b7e97a926c8', 'asset', 1, 2, '2025-04-11 03:47:56', '2025-04-11 03:47:56', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 7, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(12, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00008', NULL, 0, 2, '2025-03-18', 0, 3799000.00, NULL, 6, '', '', 0, '3a21f641715417073deef3f010c4baee', 'asset', 1, 2, '2025-04-11 03:54:07', '2025-04-11 03:54:07', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 8, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(13, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00009', NULL, 0, 2, '2025-03-24', 0, 3799000.00, NULL, 6, '', '', 0, '02f1ecca39ddd9abfc8200916cc1a8ac', 'asset', 1, 2, '2025-04-11 04:04:48', '2025-04-11 04:04:48', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 6, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(14, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00010', NULL, 0, 2, '2025-03-24', 0, 3799000.00, NULL, 6, '', '', 0, '9fc93b0ea8e9d970afb69ce1b7c98642', 'asset', 1, 2, '2025-04-11 04:06:21', '2025-04-11 04:06:21', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 13, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(15, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00011', NULL, 0, 2, '2025-03-24', 0, 3799000.00, NULL, 6, '', '', 0, 'c8bb53289807756846fc756e418d7c4d', 'asset', 1, 2, '2025-04-11 04:07:32', '2025-04-11 04:07:32', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 14, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(16, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00012', NULL, 0, 2, '2025-03-24', 0, 3799000.00, NULL, 6, '', '', 0, '68d544b6de8753d701a893b415b22bd4', 'asset', 1, 2, '2025-04-11 04:08:15', '2025-04-11 04:08:15', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 15, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(17, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00013', NULL, 0, 2, '2025-03-24', 0, 3799000.00, NULL, 6, '', '', 0, 'e0ac287351e694142f41245343455bf5', 'asset', 1, 2, '2025-04-11 04:09:00', '2025-04-11 04:09:00', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 16, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(18, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00014', NULL, 0, 2, '2025-03-18', 0, 3700000.00, NULL, 5, '', '', 0, 'c9bb45b63b61c6aca77d6096c00aab49', 'asset', 1, 2, '2025-04-11 04:15:49', '2025-04-11 04:15:49', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 12, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(19, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00015', NULL, 0, 2, '2025-03-18', 0, 3700000.00, NULL, 5, '', '', 0, 'cca07f09832664e6741230962217be48', 'asset', 1, 2, '2025-04-11 04:16:28', '2025-04-11 04:16:28', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 11, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(20, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00016', NULL, 0, 2, '2025-03-18', 0, 3700000.00, NULL, 5, '', '', 0, 'dc5612833c91d98eb71a5a0cae032b58', 'asset', 1, 2, '2025-04-11 04:17:26', '2025-04-11 04:17:26', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 10, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(21, NULL, 'SAMSUNG GALAXY TAB A9+ 5G 8GB/128GB', 'IT.H-2503-00017', NULL, 0, 2, '2025-03-18', 0, 3700000.00, NULL, 5, '', '', 0, 'afcbfaec94a533810441cfd7887fbb56', 'asset', 1, 2, '2025-04-11 04:17:56', '2025-04-11 04:17:56', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 9, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL),
(22, NULL, 'TOYOTA HILUX SILVER KT 8193 YM', 'OPS.M-2504-00001', NULL, 0, 6, NULL, 0, 0.00, NULL, 8, '', '', 0, '86f3f97f5d8f0416f46bbb1326f85eba', 'asset', 1, 2, '2025-04-11 06:41:44', '2025-04-11 06:41:44', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 22, 1, 0.00, 0.00, 0, 0, 0.00, '', NULL);

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

--
-- Table structure for table `tblfe_asset_maintenances`
--

CREATE TABLE `tblfe_asset_maintenances` (
  `id` int(11) NOT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `maintenance_type` varchar(30) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `completion_date` date DEFAULT NULL,
  `cost` decimal(15,2) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `date_creator` datetime NOT NULL DEFAULT current_timestamp(),
  `warranty_improvement` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblfe_asset_maintenances`
--

INSERT INTO `tblfe_asset_maintenances` (`id`, `asset_id`, `supplier_id`, `maintenance_type`, `title`, `start_date`, `completion_date`, `cost`, `notes`, `date_creator`, `warranty_improvement`) VALUES
(1, 22, 3, 'maintenance', '815/PO/SEAL-SITE/III/2025', '2025-03-18', '2025-03-21', 6465000.00, 'OLI TMO DISEL\r\nSCRAR COP\r\nJASA TURUN MESIN\r\nJASA KURAS RADIATOR\r\nSIL KAPER TUTUP KLEP HILUX \r\nFAKUM BOSTER HILUX\r\nJASA PASANG FAKUM BOSTER', '2025-04-11 07:11:51', 0),
(2, 22, 3, 'maintenance', '#PR-00067-2025-HR&GA', '2025-04-07', '2025-04-07', 1600000.00, 'Penggantian Drive Shaff', '2025-04-11 07:25:31', 0),
(3, 22, 3, 'maintenance', '623/PO/SEAL-KTG/I/2025', '2025-01-08', '2025-01-08', 1800000.00, 'Ban Rp 1.750.000\r\nPasang Rp 50.0000', '2025-04-15 02:37:44', 0),
(4, 22, 3, 'repair', '612/PO/SEAL-KTG/XII/2024 & 620/PO/SEAL-KTG/I/2025', '2024-12-30', '2024-12-31', 6325000.00, 'Ban Forceum : 2 X 1.750.000 = 3.500.000\r\nPemasangan Ban : 2 X 50.000 = 100.000\r\nKampas kopling : 1.800.000\r\nKampas Drok : 175.000\r\nJasa Service : 750.000\r\n\r\nBukti transfer PO 612/PO/SEAL-KTG/XII/2024 Rp 5.600.000\r\nBukti transfer PO 620/PO/SEAL-KTG/I/2025 Rp 725.000', '2025-04-15 02:53:01', 0),
(5, 22, 3, 'repair', '631/PO/SEAL-KTG/I/2025', '2025-01-11', '2025-01-12', 2730000.00, 'Ganti Kokel : 2.150.000\r\nGanti Kampas Rem Depan : 580.000', '2025-04-15 03:24:07', 0);

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

--
-- Table structure for table `tblfe_asset_manufacturers`
--

CREATE TABLE `tblfe_asset_manufacturers` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `url` text DEFAULT NULL,
  `support_url` text DEFAULT NULL,
  `support_phone` varchar(50) DEFAULT NULL,
  `support_email` varchar(100) DEFAULT NULL,
  `date_creator` datetime NOT NULL DEFAULT current_timestamp(),
  `creator_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tblfe_asset_manufacturers`
--

INSERT INTO `tblfe_asset_manufacturers` (`id`, `name`, `url`, `support_url`, `support_phone`, `support_email`, `date_creator`, `creator_id`) VALUES
(1, 'Lenovo', '', '', '', '', '2024-06-12 07:48:59', 3),
(2, 'SAMSUNG', '', '', '', '', '2025-04-11 02:56:17', 3),
(3, 'APPLE', '', '', '', '', '2025-04-11 03:25:25', 3),
(4, 'TOYOTA', '', '', '', '', '2025-04-11 03:40:27', 3);

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

--
-- Table structure for table `tblfe_assign_asset_predefined_kits`
--

CREATE TABLE `tblfe_assign_asset_predefined_kits` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `assign_data` text DEFAULT '',
  `parent_id` int(11) DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tblfe_audit_detail_requests`
--

CREATE TABLE `tblfe_audit_detail_requests` (
  `id` int(11) NOT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `asset_name` varchar(300) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `adjusted` int(11) DEFAULT NULL,
  `accept` int(11) NOT NULL DEFAULT 0,
  `audit_id` int(11) DEFAULT NULL,
  `date_creator` datetime NOT NULL DEFAULT current_timestamp(),
  `maintenance` int(11) NOT NULL DEFAULT 0,
  `maintenance_id` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tblfe_audit_requests`
--

CREATE TABLE `tblfe_audit_requests` (
  `id` int(11) NOT NULL,
  `title` varchar(300) DEFAULT NULL,
  `audit_date` datetime NOT NULL DEFAULT current_timestamp(),
  `auditor` int(11) DEFAULT NULL,
  `asset_location` int(11) DEFAULT NULL,
  `model_id` int(11) DEFAULT NULL,
  `asset_id` text DEFAULT NULL,
  `checkin_checkout_status` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `closed` int(11) NOT NULL DEFAULT 0,
  `date_creator` datetime NOT NULL DEFAULT current_timestamp(),
  `from_order` int(11) DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tblfe_cart`
--

CREATE TABLE `tblfe_cart` (
  `id` int(11) UNSIGNED NOT NULL,
  `id_contact` int(11) NOT NULL,
  `name` varchar(120) NOT NULL,
  `address` varchar(250) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `voucher` varchar(100) NOT NULL,
  `status` int(11) DEFAULT 0,
  `complete` int(11) DEFAULT 0,
  `order_number` varchar(100) DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `channel` varchar(150) DEFAULT NULL,
  `first_name` varchar(60) DEFAULT NULL,
  `last_name` varchar(60) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `hash` varchar(32) DEFAULT NULL,
  `tax_id` text DEFAULT NULL,
  `tax_rate` text DEFAULT NULL,
  `tax_name` text DEFAULT NULL,
  `unit_id` int(11) DEFAULT NULL,
  `unit_name` varchar(255) DEFAULT NULL,
  `add_discount` decimal(15,2) DEFAULT 0.00,
  `company` varchar(150) DEFAULT NULL,
  `phonenumber` varchar(15) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `billing_street` varchar(150) DEFAULT NULL,
  `billing_city` varchar(50) DEFAULT NULL,
  `billing_state` varchar(50) DEFAULT NULL,
  `billing_country` varchar(50) DEFAULT NULL,
  `billing_zip` varchar(50) DEFAULT NULL,
  `shipping_street` varchar(150) DEFAULT NULL,
  `shipping_city` varchar(50) DEFAULT NULL,
  `shipping_state` varchar(50) DEFAULT NULL,
  `shipping_country` varchar(50) DEFAULT NULL,
  `shipping_zip` varchar(50) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `reason` varchar(250) DEFAULT NULL,
  `admin_action` int(11) DEFAULT 0,
  `discount` varchar(250) DEFAULT NULL,
  `discount_type` int(11) DEFAULT 0,
  `total` varchar(250) DEFAULT NULL,
  `sub_total` varchar(250) DEFAULT NULL,
  `discount_total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `invoice` varchar(250) NOT NULL DEFAULT '',
  `number_invoice` varchar(250) NOT NULL DEFAULT '',
  `stock_export_number` varchar(250) NOT NULL DEFAULT '',
  `create_invoice` varchar(5) NOT NULL DEFAULT 'off',
  `stock_export` varchar(5) NOT NULL DEFAULT 'off',
  `customers_pay` decimal(15,2) NOT NULL DEFAULT 0.00,
  `amount_returned` decimal(15,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(15,2) NOT NULL DEFAULT 0.00,
  `seller` int(11) DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `payment_note` text DEFAULT NULL,
  `allowed_payment_modes` varchar(200) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `shipping` decimal(15,2) NOT NULL DEFAULT 0.00,
  `payment_method_title` varchar(250) DEFAULT NULL,
  `discount_type_str` text DEFAULT NULL,
  `discount_percent` decimal(15,2) DEFAULT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `currency` int(11) DEFAULT NULL,
  `terms` text DEFAULT NULL,
  `shipping_tax` decimal(15,2) DEFAULT NULL,
  `enable` int(11) NOT NULL DEFAULT 1,
  `duedate` date DEFAULT NULL,
  `shipping_tax_json` varchar(150) DEFAULT NULL,
  `discount_voucher` varchar(150) DEFAULT NULL,
  `original_order_id` int(11) DEFAULT NULL,
  `return_reason` longtext DEFAULT NULL,
  `approve_status` int(11) NOT NULL DEFAULT 0,
  `process_invoice` varchar(5) NOT NULL DEFAULT 'off',
  `stock_import_number` int(11) NOT NULL DEFAULT 0,
  `fee_for_return_order` decimal(15,2) DEFAULT NULL,
  `estimate_id` int(11) DEFAULT NULL,
  `shipping_form` varchar(50) DEFAULT 'fixed',
  `shipping_value` decimal(15,2) DEFAULT 0.00,
  `type` varchar(30) NOT NULL DEFAULT 'order',
  `datecreator` datetime NOT NULL DEFAULT current_timestamp(),
  `return_reason_type` varchar(50) DEFAULT NULL,
  `return_type` varchar(30) DEFAULT NULL,
  `audit_id` int(11) DEFAULT NULL,
  `maintenance_id` int(11) DEFAULT NULL,
  `credit_note_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
