-- Table structure for table `sunbird_tbl_shipment_companies`
--

CREATE TABLE `sunbird_tbl_shipment_companies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `contact_person_name` varchar(255) NOT NULL,
  `contact_person_phone_number` varchar(20) NOT NULL,
  `contact_person_email` varchar(255) NOT NULL,
  `contact_state_id` int DEFAULT NULL,
  `contact_country_id` int DEFAULT NULL,
  `contact_address_type` enum('postal_code','zip_code') NOT NULL,
  `contact_address` text,
  `contact_zipcode` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `contact_person_phone_number` (`contact_person_phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_companies`
--


--
-- Table structure for table `sunbird_tbl_shipment_fcl_packages`
--

CREATE TABLE `sunbird_tbl_shipment_fcl_packages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quantity` int NOT NULL,
  `description` varchar(255) NOT NULL,
  `fcl_option` varchar(255) NOT NULL,
  `shipment_id` int NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shipment_id` (`shipment_id`),
  CONSTRAINT `sunbird_tbl_shipment_fcl_packages_ibfk_1` FOREIGN KEY (`shipment_id`) REFERENCES `sunbird_tbl_shipments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_fcl_packages`
--


--
-- Table structure for table `sunbird_tbl_shipment_packages`
--

CREATE TABLE `sunbird_tbl_shipment_packages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quantity` int NOT NULL,
  `description` varchar(255) NOT NULL,
  `length` decimal(10,2) NOT NULL,
  `width` decimal(10,2) NOT NULL,
  `height` decimal(10,2) NOT NULL,
  `weight` decimal(10,2) NOT NULL,
  `weight_volume` decimal(10,2) NOT NULL,
  `chargeable_weight` decimal(10,2) NOT NULL,
  `shipment_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `shipment_id` (`shipment_id`),
  CONSTRAINT `sunbird_tbl_shipment_packages_ibfk_1` FOREIGN KEY (`shipment_id`) REFERENCES `sunbird_tbl_shipments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_packages`
--


--
-- Table structure for table `sunbird_tbl_shipment_recipients`
--

CREATE TABLE `sunbird_tbl_shipment_recipients` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text,
  `zipcode` varchar(20) NOT NULL,
  `address_type` enum('postal_code','zip_code') NOT NULL,
  `state_id` int DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `sunbird_tbl_shipment_recipients_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `sunbird_tblcountries` (`country_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_recipients`
--


--
-- Table structure for table `sunbird_tbl_shipment_senders`
--

CREATE TABLE `sunbird_tbl_shipment_senders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text,
  `zipcode` varchar(20) NOT NULL,
  `address_type` enum('postal_code','zip_code') NOT NULL,
  `state_id` int DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `sunbird_tbl_shipment_senders_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `sunbird_tblcountries` (`country_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_senders`
--


--
-- Table structure for table `sunbird_tbl_shipment_status_history`
--

CREATE TABLE `sunbird_tbl_shipment_status_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `shipment_id` int DEFAULT NULL,
  `status_id` int DEFAULT NULL,
  `changed_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_status_history`
--


--
-- Table structure for table `sunbird_tbl_shipment_statuses`
--

CREATE TABLE `sunbird_tbl_shipment_statuses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status_name` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_statuses`
--

INSERT INTO `sunbird_tbl_shipment_statuses` VALUES (1,'created','Created',1),(2,'picked_up','Picked up',1),(3,'received','Received',1),(4,'dispatched','Dispatched',1),(5,'in_transit','In Transit',1),(6,'arrived_destination','Arrived at Destination',1),(7,'out_for_delivery','Out For Delivery',1),(8,'delivered','Delivered',1);

--
-- Table structure for table `sunbird_tbl_shipment_stops`
--

CREATE TABLE `sunbird_tbl_shipment_stops` (
  `id` int NOT NULL AUTO_INCREMENT,
  `shipment_id` int DEFAULT NULL,
  `departure_point` varchar(255) NOT NULL,
  `destination_point` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipment_stops`
--


--
-- Table structure for table `sunbird_tbl_shipments`
--

CREATE TABLE `sunbird_tbl_shipments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `shipping_mode` varchar(255) NOT NULL,
  `shipping_category` enum('domestic','international') NOT NULL,
  `export` int NOT NULL DEFAULT '0',
  `import` int NOT NULL DEFAULT '0',
  `tracking_id` varchar(255) NOT NULL,
  `company_type` varchar(255) NOT NULL,
  `waybill_number` varchar(255) NOT NULL,
  `courier_company_id` int NOT NULL,
  `invoice_id` int NOT NULL DEFAULT '0',
  `status_id` int NOT NULL,
  `sender_id` int DEFAULT NULL,
  `recipient_id` int DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `recipient_company_id` int DEFAULT NULL,
  `fcl_shipment` int DEFAULT NULL,
  `staff_id` int NOT NULL,
  `packaging_charges` decimal(10,2) NOT NULL,
  `commercial_invoice_url` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `courier_company_id` (`courier_company_id`),
  KEY `status_id` (`status_id`),
  KEY `sender_id` (`sender_id`),
  KEY `recipient_id` (`recipient_id`),
  KEY `company_id` (`company_id`),
  CONSTRAINT `sunbird_tbl_shipments_ibfk_1` FOREIGN KEY (`courier_company_id`) REFERENCES `sunbird_tbl_courier_companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sunbird_tbl_shipments_ibfk_2` FOREIGN KEY (`status_id`) REFERENCES `sunbird_tbl_shipment_statuses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sunbird_tbl_shipments_ibfk_3` FOREIGN KEY (`sender_id`) REFERENCES `sunbird_tbl_shipment_senders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sunbird_tbl_shipments_ibfk_4` FOREIGN KEY (`recipient_id`) REFERENCES `sunbird_tbl_shipment_recipients` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sunbird_tbl_shipments_ibfk_5` FOREIGN KEY (`company_id`) REFERENCES `sunbird_tbl_shipment_companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_shipments`
--


--
-- Table structure for table `sunbird_tbl_speaker_details`
--

CREATE TABLE `sunbird_tbl_speaker_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fund_request_id` int NOT NULL,
  `speaker_name` varchar(255) NOT NULL,
  `rate_per_day` decimal(15,2) NOT NULL,
  `number_of_days` int NOT NULL,
  `total` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fund_request_id` (`fund_request_id`),
  CONSTRAINT `sunbird_tbl_speaker_details_ibfk_1` FOREIGN KEY (`fund_request_id`) REFERENCES `sunbird_tbl_fund_requests` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tbl_speaker_details`
--


--
-- Table structure for table `sunbird_tbl_third_party_shipments`
--

CREATE TABLE `sunbird_tbl_third_party_shipments` (
  `shipment_id` int NOT NULL,
  `tracking_id` varchar(255) NOT NULL,
  `courier_company_id` int NOT NULL,
  PRIMARY KEY (`shipment_id`),
  KEY `courier_company_id` (`courier_company_id`),
  CONSTRAINT `sunbird_tbl_third_party_shipments_ibfk_1` FOREIGN KEY (`shipment_id`) REFERENCES `sunbird_tbl_shipments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sunbird_tbl_third_party_shipments_ibfk_2` FOREIGN KEY (`courier_company_id`) REFERENCES `sunbird_tbl_courier_companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunbird_tbl_third_party_shipments`
--


--
-- Table structure for table `sunbird_tblacc_account_history`
--

CREATE TABLE `sunbird_tblacc_account_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account` int NOT NULL,
  `debit` decimal(15,2) NOT NULL DEFAULT '0.00',
  `credit` decimal(15,2) NOT NULL DEFAULT '0.00',
  `description` text,
  `rel_id` int DEFAULT NULL,
  `rel_type` varchar(45) DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `customer` int DEFAULT NULL,
  `reconcile` int NOT NULL DEFAULT '0',
  `split` int NOT NULL DEFAULT '0',
  `item` int DEFAULT NULL,
  `paid` int NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `tax` int DEFAULT NULL,
  `payslip_type` varchar(45) DEFAULT NULL,
  `vendor` int DEFAULT NULL,
  `itemable_id` int DEFAULT NULL,
  `cleared` int NOT NULL DEFAULT '0',
  `sub_type` varchar(45) DEFAULT NULL,
  `bill_item` int NOT NULL DEFAULT '0',
  `number` varchar(100) DEFAULT NULL,
  `issue` int NOT NULL DEFAULT '0',
  `added_from_reconcile` int NOT NULL DEFAULT '0',
  `bank_reconcile` int NOT NULL DEFAULT '0',
  `reference_no` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_account_history`
--


--
-- Table structure for table `sunbird_tblacc_account_type_details`
--

CREATE TABLE `sunbird_tblacc_account_type_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account_type_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `note` text,
  `statement_of_cash_flows` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_account_type_details`
--


--
-- Table structure for table `sunbird_tblacc_accounts`
--

CREATE TABLE `sunbird_tblacc_accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `key_name` varchar(255) DEFAULT NULL,
  `number` varchar(45) DEFAULT NULL,
  `parent_account` int DEFAULT NULL,
  `account_type_id` int NOT NULL,
  `account_detail_type_id` int NOT NULL,
  `balance` decimal(15,2) DEFAULT NULL,
  `balance_as_of` date DEFAULT NULL,
  `description` text,
  `default_account` int NOT NULL DEFAULT '0',
  `active` int NOT NULL DEFAULT '1',
  `access_token` text,
  `account_id` varchar(255) DEFAULT NULL,
  `plaid_status` tinyint NOT NULL DEFAULT '0' COMMENT '1=>verified, 0=>not verified',
  `plaid_account_name` varchar(255) DEFAULT NULL,
  `bank_account` text,
  `bank_routing` text,
  `address_line_1` text,
  `address_line_2` text,
  `bank_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_accounts`
--

INSERT INTO `sunbird_tblacc_accounts` VALUES (1,'','acc_accounts_receivable',NULL,NULL,1,1,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(2,'','acc_accrued_holiday_payable',NULL,NULL,9,61,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(3,'','acc_accrued_liabilities',NULL,NULL,8,44,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(4,'','acc_accrued_non_current_liabilities',NULL,NULL,9,62,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(5,'','acc_accumulated_depreciation_on_property_plant_and_equipment',NULL,NULL,4,22,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(6,'','acc_allowance_for_bad_debts',NULL,NULL,2,2,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(7,'','acc_amortisation_expense',NULL,NULL,14,106,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(8,'','acc_assets_held_for_sale',NULL,NULL,5,32,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(9,'','acc_available_for_sale_assets_short_term',NULL,NULL,2,3,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(10,'','acc_bad_debts',NULL,NULL,14,108,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(11,'','acc_bank_charges',NULL,NULL,14,109,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(12,'','acc_billable_expense_income',NULL,NULL,11,89,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(13,'','acc_cash_and_cash_equivalents',NULL,NULL,3,15,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(14,'','acc_change_in_inventory_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(15,'','acc_commissions_and_fees',NULL,NULL,14,111,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(16,'','acc_cost_of_sales',NULL,NULL,13,104,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(17,'','acc_deferred_tax_assets',NULL,NULL,5,33,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(18,'','acc_direct_labour_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(19,'','acc_discounts_given_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(20,'','acc_dividend_disbursed',NULL,NULL,10,69,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(21,'','acc_dividend_income',NULL,NULL,12,92,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(22,'','acc_dividends_payable',NULL,NULL,8,48,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(23,'','acc_dues_and_subscriptions',NULL,NULL,14,113,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(24,'','acc_equipment_rental',NULL,NULL,14,114,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(25,'','acc_equity_in_earnings_of_subsidiaries',NULL,NULL,10,70,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(26,'','acc_freight_and_delivery_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(27,'','acc_goodwill',NULL,NULL,5,34,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(28,'','acc_income_tax_expense',NULL,NULL,14,116,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(29,'','acc_income_tax_payable',NULL,NULL,8,50,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(30,'','acc_insurance_disability',NULL,NULL,14,117,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(31,'','acc_insurance_general',NULL,NULL,14,117,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(32,'','acc_insurance_liability',NULL,NULL,14,117,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(33,'','acc_intangibles',NULL,NULL,5,35,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(34,'','acc_interest_expense',NULL,NULL,14,118,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(35,'','acc_interest_income',NULL,NULL,12,93,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(36,'','acc_inventory',NULL,NULL,2,5,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(37,'','acc_inventory_asset',NULL,NULL,2,5,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(38,'','acc_legal_and_professional_fees',NULL,NULL,14,119,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(39,'','acc_liabilities_related_to_assets_held_for_sale',NULL,NULL,9,63,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(40,'','acc_long_term_debt',NULL,NULL,9,64,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(41,'','acc_long_term_investments',NULL,NULL,5,38,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(42,'','acc_loss_on_discontinued_operations_net_of_tax',NULL,NULL,14,120,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(43,'','acc_loss_on_disposal_of_assets',NULL,NULL,12,94,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(44,'','acc_management_compensation',NULL,NULL,14,121,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(45,'','acc_materials_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(46,'','acc_meals_and_entertainment',NULL,NULL,14,122,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(47,'','acc_office_expenses',NULL,NULL,14,123,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(48,'','acc_other_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(49,'','acc_other_comprehensive_income',NULL,NULL,10,73,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(50,'','acc_other_general_and_administrative_expenses',NULL,NULL,14,123,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(51,'','acc_other_operating_income_expenses',NULL,NULL,12,97,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(52,'','acc_other_selling_expenses',NULL,NULL,14,125,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(53,'','acc_other_type_of_expenses_advertising_expenses',NULL,NULL,14,105,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(54,'','acc_overhead_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(55,'','acc_payroll_clearing',NULL,NULL,8,55,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(56,'','acc_payroll_expenses',NULL,NULL,14,126,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(57,'','acc_payroll_liabilities',NULL,NULL,8,56,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(58,'','acc_prepaid_expenses',NULL,NULL,2,11,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(59,'','acc_property_plant_and_equipment',NULL,NULL,4,26,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(60,'','acc_purchases',NULL,NULL,14,130,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(61,'','acc_reconciliation_discrepancies',NULL,NULL,15,139,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(62,'','acc_rent_or_lease_payments',NULL,NULL,14,127,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(63,'','acc_repair_and_maintenance',NULL,NULL,14,128,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(64,'','acc_retained_earnings',NULL,NULL,10,80,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(65,'','acc_revenue_general',NULL,NULL,11,86,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(66,'','acc_sales',NULL,NULL,11,89,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(67,'','acc_sales_retail',NULL,NULL,11,87,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(68,'','acc_sales_wholesale',NULL,NULL,11,88,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(69,'','acc_sales_of_product_income',NULL,NULL,11,89,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(70,'','acc_share_capital',NULL,NULL,10,81,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(71,'','acc_shipping_and_delivery_expense',NULL,NULL,14,129,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(72,'','acc_short_term_debit',NULL,NULL,8,54,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(73,'','acc_stationery_and_printing',NULL,NULL,14,123,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(74,'','acc_subcontractors_cos',NULL,NULL,13,100,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(75,'','acc_supplies',NULL,NULL,14,130,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(76,'','acc_travel_expenses_general_and_admin_expenses',NULL,NULL,14,132,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(77,'','acc_travel_expenses_selling_expense',NULL,NULL,14,133,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(78,'','acc_unapplied_cash_payment_income',NULL,NULL,11,91,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(79,'','acc_uncategorised_asset',NULL,NULL,2,10,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(80,'','acc_uncategorised_expense',NULL,NULL,14,124,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(81,'','acc_uncategorised_income',NULL,NULL,11,89,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(82,'','acc_undeposited_funds',NULL,NULL,2,13,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(83,'','acc_unrealised_loss_on_securities_net_of_tax',NULL,NULL,12,99,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(84,'','acc_utilities',NULL,NULL,14,135,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(85,'','acc_wage_expenses',NULL,NULL,14,126,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(86,'','acc_credit_card',NULL,NULL,7,43,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(87,'','acc_accounts_payable',NULL,NULL,6,42,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(88,'','acc_opening_balance_equity',NULL,NULL,10,71,NULL,NULL,NULL,1,1,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `sunbird_tblacc_bank_reconciles`
--

CREATE TABLE `sunbird_tblacc_bank_reconciles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account` int NOT NULL,
  `opening_balance` decimal(15,2) NOT NULL DEFAULT '0.00',
  `beginning_balance` decimal(15,2) NOT NULL,
  `ending_balance` decimal(15,2) NOT NULL,
  `ending_date` date NOT NULL,
  `finish` int NOT NULL DEFAULT '0',
  `debits_for_period` decimal(15,2) NOT NULL,
  `credits_for_period` decimal(15,2) NOT NULL,
  `dateadded` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_bank_reconciles`
--


--
-- Table structure for table `sunbird_tblacc_banking_rule_details`
--

CREATE TABLE `sunbird_tblacc_banking_rule_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rule_id` int NOT NULL,
  `type` varchar(45) DEFAULT NULL,
  `subtype` varchar(45) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `subtype_amount` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_banking_rule_details`
--


--
-- Table structure for table `sunbird_tblacc_banking_rules`
--

CREATE TABLE `sunbird_tblacc_banking_rules` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `transaction` varchar(45) DEFAULT NULL,
  `following` varchar(45) DEFAULT NULL,
  `then` varchar(45) DEFAULT NULL,
  `payment_account` int DEFAULT NULL,
  `deposit_to` int DEFAULT NULL,
  `auto_add` int NOT NULL DEFAULT '0',
  `mapping_type` varchar(25) DEFAULT NULL,
  `account` int DEFAULT NULL,
  `split_percentage` text,
  `split_amount` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_banking_rules`
--


--
-- Table structure for table `sunbird_tblacc_bill_mappings`
--

CREATE TABLE `sunbird_tblacc_bill_mappings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bill_id` int DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  `account` int DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_bill_mappings`
--


--
-- Table structure for table `sunbird_tblacc_budget_details`
--

CREATE TABLE `sunbird_tblacc_budget_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `budget_id` int NOT NULL,
  `month` int NOT NULL,
  `year` int NOT NULL,
  `account` int DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_budget_details`
--


--
-- Table structure for table `sunbird_tblacc_budgets`
--

CREATE TABLE `sunbird_tblacc_budgets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` int NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `data_source` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_budgets`
--


--
-- Table structure for table `sunbird_tblacc_check_details`
--

CREATE TABLE `sunbird_tblacc_check_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_id` int DEFAULT NULL,
  `bill` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_check_details`
--


--
-- Table structure for table `sunbird_tblacc_checks`
--

CREATE TABLE `sunbird_tblacc_checks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int DEFAULT NULL,
  `rel_type` varchar(25) DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  `dateadded` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `address` text,
  `bank_account` int NOT NULL,
  `number` int NOT NULL,
  `signed` int NOT NULL DEFAULT '0',
  `include_company_name_address` int NOT NULL DEFAULT '1',
  `include_routing_account_numbers` int NOT NULL DEFAULT '1',
  `bill` int DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `zip` varchar(15) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `issue` int DEFAULT NULL,
  `include_check_number` int NOT NULL DEFAULT '1',
  `include_bank_name` int NOT NULL DEFAULT '1',
  `bank_name` varchar(255) DEFAULT NULL,
  `address_line_1` text,
  `address_line_2` text,
  `vendor_city` varchar(100) DEFAULT NULL,
  `vendor_zip` varchar(15) DEFAULT NULL,
  `vendor_state` varchar(50) DEFAULT NULL,
  `vendor_address` text,
  `reason_for_void` text,
  `bill_items` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_checks`
--


--
-- Table structure for table `sunbird_tblacc_checks_printed`
--

CREATE TABLE `sunbird_tblacc_checks_printed` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_id` int DEFAULT NULL,
  `bank_account` int DEFAULT NULL,
  `first_check_number` int DEFAULT NULL,
  `printed_at` datetime DEFAULT NULL,
  `printed_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_checks_printed`
--


--
-- Table structure for table `sunbird_tblacc_expense_category_mapping_details`
--

CREATE TABLE `sunbird_tblacc_expense_category_mapping_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_mapping_id` int NOT NULL,
  `payment_mode_id` int NOT NULL,
  `payment_account` int NOT NULL DEFAULT '0',
  `deposit_to` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_expense_category_mapping_details`
--


--
-- Table structure for table `sunbird_tblacc_expense_category_mappings`
--

CREATE TABLE `sunbird_tblacc_expense_category_mappings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL,
  `payment_account` int NOT NULL DEFAULT '0',
  `deposit_to` int NOT NULL DEFAULT '0',
  `preferred_payment_method` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_expense_category_mappings`
--


--
-- Table structure for table `sunbird_tblacc_income_statement_modifications`
--

CREATE TABLE `sunbird_tblacc_income_statement_modifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `account` int DEFAULT NULL,
  `active` int NOT NULL DEFAULT '1',
  `account_type` int DEFAULT NULL,
  `options` text,
  `dateadded` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `type` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_income_statement_modifications`
--


--
-- Table structure for table `sunbird_tblacc_item_automatics`
--

CREATE TABLE `sunbird_tblacc_item_automatics` (
  `id` int NOT NULL AUTO_INCREMENT,
  `item_id` int NOT NULL,
  `inventory_asset_account` int NOT NULL DEFAULT '0',
  `income_account` int NOT NULL DEFAULT '0',
  `expense_account` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_item_automatics`
--


--
-- Table structure for table `sunbird_tblacc_journal_entries`
--

CREATE TABLE `sunbird_tblacc_journal_entries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `number` varchar(45) DEFAULT NULL,
  `description` text,
  `journal_date` date DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_journal_entries`
--


--
-- Table structure for table `sunbird_tblacc_matched_transactions`
--

CREATE TABLE `sunbird_tblacc_matched_transactions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account_history_id` int DEFAULT NULL,
  `history_amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `rel_id` int DEFAULT NULL,
  `rel_type` varchar(255) DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `company` int DEFAULT NULL,
  `reconcile` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_matched_transactions`
--


--
-- Table structure for table `sunbird_tblacc_pay_bill_details`
--

CREATE TABLE `sunbird_tblacc_pay_bill_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pay_bill` int DEFAULT NULL,
  `bill_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_pay_bill_details`
--


--
-- Table structure for table `sunbird_tblacc_pay_bill_item_paid`
--

CREATE TABLE `sunbird_tblacc_pay_bill_item_paid` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pay_bill_id` int NOT NULL DEFAULT '0',
  `item_id` int DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `amount_paid` decimal(15,2) NOT NULL DEFAULT '0.00',
  `check_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_pay_bill_item_paid`
--


--
-- Table structure for table `sunbird_tblacc_pay_bills`
--

CREATE TABLE `sunbird_tblacc_pay_bills` (
  `id` int NOT NULL AUTO_INCREMENT,
  `expense` int DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  `reference_no` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `dateadded` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `company` int DEFAULT NULL,
  `account_debit` int DEFAULT NULL,
  `account_credit` int DEFAULT NULL,
  `bill` int NOT NULL DEFAULT '0',
  `vendor` int NOT NULL DEFAULT '0',
  `pay_number` int DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `bill_items` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_pay_bills`
--


--
-- Table structure for table `sunbird_tblacc_payment_mode_mappings`
--

CREATE TABLE `sunbird_tblacc_payment_mode_mappings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_mode_id` int NOT NULL,
  `payment_account` int NOT NULL DEFAULT '0',
  `deposit_to` int NOT NULL DEFAULT '0',
  `expense_payment_account` int NOT NULL DEFAULT '0',
  `expense_deposit_to` int NOT NULL DEFAULT '0',
  `credit_note_refund_payment_account` int NOT NULL DEFAULT '0',
  `credit_note_refund_deposit_to` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_payment_mode_mappings`
--


--
-- Table structure for table `sunbird_tblacc_plaid_transaction_logs`
--

CREATE TABLE `sunbird_tblacc_plaid_transaction_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bank_id` int DEFAULT NULL,
  `last_updated` date DEFAULT NULL,
  `transaction_count` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `addedFrom` int DEFAULT NULL,
  `company` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_plaid_transaction_logs`
--


--
-- Table structure for table `sunbird_tblacc_print_later`
--

CREATE TABLE `sunbird_tblacc_print_later` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int DEFAULT NULL,
  `rel_type` varchar(45) DEFAULT NULL,
  `account` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_print_later`
--


--
-- Table structure for table `sunbird_tblacc_reconciles`
--

CREATE TABLE `sunbird_tblacc_reconciles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account` int NOT NULL,
  `beginning_balance` decimal(15,2) NOT NULL,
  `ending_balance` decimal(15,2) NOT NULL,
  `ending_date` date NOT NULL,
  `expense_date` date DEFAULT NULL,
  `service_charge` decimal(15,2) DEFAULT NULL,
  `expense_account` int DEFAULT NULL,
  `income_date` date DEFAULT NULL,
  `interest_earned` decimal(15,2) DEFAULT NULL,
  `income_account` int DEFAULT NULL,
  `finish` int NOT NULL DEFAULT '0',
  `opening_balance` int NOT NULL DEFAULT '0',
  `debits_for_period` decimal(15,2) DEFAULT NULL,
  `credits_for_period` decimal(15,2) DEFAULT NULL,
  `dateadded` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_reconciles`
--


--
-- Table structure for table `sunbird_tblacc_tax_mappings`
--

CREATE TABLE `sunbird_tblacc_tax_mappings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tax_id` int NOT NULL,
  `payment_account` int NOT NULL DEFAULT '0',
  `deposit_to` int NOT NULL DEFAULT '0',
  `expense_payment_account` int NOT NULL DEFAULT '0',
  `expense_deposit_to` int NOT NULL DEFAULT '0',
  `purchase_payment_account` int NOT NULL DEFAULT '0',
  `purchase_deposit_to` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_tax_mappings`
--


--
-- Table structure for table `sunbird_tblacc_transaction_bankings`
--

CREATE TABLE `sunbird_tblacc_transaction_bankings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `withdrawals` decimal(15,2) NOT NULL DEFAULT '0.00',
  `deposits` decimal(15,2) NOT NULL DEFAULT '0.00',
  `payee` varchar(255) DEFAULT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `transaction_id` varchar(150) DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '1=>posted, 2=>pending',
  `matched` int NOT NULL DEFAULT '0',
  `reconcile` int NOT NULL DEFAULT '0',
  `adjusted` int NOT NULL DEFAULT '0',
  `is_imported` int NOT NULL DEFAULT '0',
  `banking_rule` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_transaction_bankings`
--


--
-- Table structure for table `sunbird_tblacc_transfers`
--

CREATE TABLE `sunbird_tblacc_transfers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `transfer_funds_from` int NOT NULL,
  `transfer_funds_to` int NOT NULL,
  `transfer_amount` decimal(15,2) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblacc_transfers`
--


--
-- Table structure for table `sunbird_tblactivity_log`
--

CREATE TABLE `sunbird_tblactivity_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `staffid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sunbird_staffid` (`staffid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblactivity_log`
--

INSERT INTO `sunbird_tblactivity_log` VALUES (1,'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 102.219.210.222]','2025-01-31 05:54:09','FREDRICK MLAY'),(2,'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 102.219.210.222]','2025-01-31 06:04:14','FREDRICK MLAY'),(3,'New Currency Added [ID: TZS]','2025-01-31 06:06:24','FREDRICK MLAY'),(4,'New Tax Added [ID: 1, Sales VAT]','2025-01-31 06:08:23','FREDRICK MLAY'),(5,'New Tax Added [ID: 2, Purchase VAT]','2025-01-31 06:09:26','FREDRICK MLAY'),(6,'Failed Login Attempt [Email: mlayfred@gmail.com, Is Staff Member: Yes, IP: 104.28.82.109]','2025-01-31 06:51:02',NULL),(7,'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 104.28.82.109]','2025-01-31 06:51:34','FREDRICK MLAY'),(8,'User Successfully Logged In [User Id: 1, Is Staff Member: Yes, IP: 102.219.210.222]','2025-01-31 17:41:57','FREDRICK MLAY');

--
-- Table structure for table `sunbird_tblaffiliate_m_affiliates`
--

CREATE TABLE `sunbird_tblaffiliate_m_affiliates` (
  `affiliate_id` int NOT NULL AUTO_INCREMENT,
  `affiliate_slug` varchar(255) NOT NULL,
  `group_id` varchar(255) DEFAULT NULL,
  `contact_id` int NOT NULL,
  `total_earnings` decimal(10,2) DEFAULT '0.00',
  `balance` decimal(10,2) DEFAULT '0.00',
  `status` varchar(255) DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`affiliate_id`),
  UNIQUE KEY `unique_sunbird_tbl_contact_id` (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblaffiliate_m_affiliates`
--


--
-- Table structure for table `sunbird_tblaffiliate_m_commissions`
--

CREATE TABLE `sunbird_tblaffiliate_m_commissions` (
  `commission_id` int NOT NULL AUTO_INCREMENT,
  `referral_id` int NOT NULL,
  `affiliate_id` int NOT NULL,
  `client_id` int NOT NULL,
  `payment_id` int DEFAULT NULL,
  `invoice_id` int DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `rule_info` varchar(255) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`commission_id`),
  KEY `fk_sunbird_tbl_commission_referral_id` (`referral_id`),
  KEY `fk_sunbird_tbl_commission_affiliate_id` (`affiliate_id`),
  CONSTRAINT `fk_sunbird_tbl_commission_affiliate_id` FOREIGN KEY (`affiliate_id`) REFERENCES `sunbird_tblaffiliate_m_affiliates` (`affiliate_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_sunbird_tbl_commission_referral_id` FOREIGN KEY (`referral_id`) REFERENCES `sunbird_tblaffiliate_m_referrals` (`referral_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblaffiliate_m_commissions`
--


--
-- Table structure for table `sunbird_tblaffiliate_m_payouts`
--

CREATE TABLE `sunbird_tblaffiliate_m_payouts` (
  `payout_id` int NOT NULL AUTO_INCREMENT,
  `affiliate_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `note_for_affiliate` text,
  `note_for_admin` text,
  `payout_method` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`payout_id`),
  KEY `fk_sunbird_tbl_afm_payout_affiliate_id` (`affiliate_id`),
  CONSTRAINT `fk_sunbird_tbl_afm_payout_affiliate_id` FOREIGN KEY (`affiliate_id`) REFERENCES `sunbird_tblaffiliate_m_affiliates` (`affiliate_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblaffiliate_m_payouts`
--


--
-- Table structure for table `sunbird_tblaffiliate_m_referrals`
--

CREATE TABLE `sunbird_tblaffiliate_m_referrals` (
  `referral_id` int NOT NULL AUTO_INCREMENT,
  `affiliate_id` int NOT NULL,
  `client_id` int NOT NULL,
  `ua` text,
  `ip` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`referral_id`),
  UNIQUE KEY `unique_sunbird_tbl_client_id` (`client_id`),
  KEY `fk_sunbird_tbl_referral_affiliate_id` (`affiliate_id`),
  CONSTRAINT `fk_sunbird_tbl_referral_affiliate_id` FOREIGN KEY (`affiliate_id`) REFERENCES `sunbird_tblaffiliate_m_affiliates` (`affiliate_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblaffiliate_m_referrals`
--


--
-- Table structure for table `sunbird_tblaffiliate_m_tracking`
--

CREATE TABLE `sunbird_tblaffiliate_m_tracking` (
  `tracking_id` int NOT NULL AUTO_INCREMENT,
  `affiliate_slug` varchar(255) NOT NULL,
  `rel_type` varchar(255) NOT NULL,
  `rel_id` int NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `metadata` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`tracking_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblaffiliate_m_tracking`
--


--
-- Table structure for table `sunbird_tblannouncements`
--

CREATE TABLE `sunbird_tblannouncements` (
  `announcementid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `showtousers` int NOT NULL,
  `showtostaff` int NOT NULL,
  `showname` int NOT NULL,
  `dateadded` datetime NOT NULL,
  `userid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`announcementid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblannouncements`
--


--
-- Table structure for table `sunbird_tblbonus_discipline`
--

CREATE TABLE `sunbird_tblbonus_discipline` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `id_criteria` varchar(200) DEFAULT NULL,
  `type` int NOT NULL,
  `apply_for` varchar(50) DEFAULT NULL,
  `from_time` datetime DEFAULT NULL,
  `lever_bonus` int DEFAULT NULL,
  `approver` int DEFAULT NULL,
  `url_file` longtext,
  `create_time` datetime DEFAULT NULL,
  `id_admin` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblbonus_discipline`
--


--
-- Table structure for table `sunbird_tblbonus_discipline_detail`
--

CREATE TABLE `sunbird_tblbonus_discipline_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `id_bonus_discipline` int NOT NULL,
  `from_time` datetime DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `department_id` longtext,
  `lever_bonus` int DEFAULT NULL,
  `formality` varchar(50) DEFAULT NULL,
  `formality_value` varchar(100) DEFAULT NULL,
  `description` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblbonus_discipline_detail`
--


--
-- Table structure for table `sunbird_tblchecklist`
--

CREATE TABLE `sunbird_tblchecklist` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `group_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblchecklist`
--


--
-- Table structure for table `sunbird_tblchecklist_allocation`
--

CREATE TABLE `sunbird_tblchecklist_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `group_id` int DEFAULT NULL,
  `staffid` int DEFAULT NULL,
  `status` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblchecklist_allocation`
--


--
-- Table structure for table `sunbird_tblclients`
--

CREATE TABLE `sunbird_tblclients` (
  `userid` int NOT NULL AUTO_INCREMENT,
  `company` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phonenumber` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` int NOT NULL DEFAULT '0',
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `active` int NOT NULL DEFAULT '1',
  `leadid` int DEFAULT NULL,
  `billing_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int DEFAULT '0',
  `shipping_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int DEFAULT '0',
  `longitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_language` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_currency` int NOT NULL DEFAULT '0',
  `show_primary_contact` int NOT NULL DEFAULT '0',
  `stripe_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_confirmed` int NOT NULL DEFAULT '1',
  `addedfrom` int NOT NULL DEFAULT '0',
  `balance` decimal(15,2) DEFAULT NULL,
  `balance_as_of` date DEFAULT NULL,
  PRIMARY KEY (`userid`),
  KEY `country` (`country`),
  KEY `leadid` (`leadid`),
  KEY `company` (`company`),
  KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblclients`
--


--
-- Table structure for table `sunbird_tblconsent_purposes`
--

CREATE TABLE `sunbird_tblconsent_purposes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_created` datetime NOT NULL,
  `last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblconsent_purposes`
--


--
-- Table structure for table `sunbird_tblconsents`
--

CREATE TABLE `sunbird_tblconsents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` int NOT NULL DEFAULT '0',
  `lead_id` int NOT NULL DEFAULT '0',
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `opt_in_purpose_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `purpose_id` int NOT NULL,
  `staff_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purpose_id` (`purpose_id`),
  KEY `contact_id` (`contact_id`),
  KEY `lead_id` (`lead_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblconsents`
--


--
-- Table structure for table `sunbird_tblcontact_permissions`
--

CREATE TABLE `sunbird_tblcontact_permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `permission_id` int NOT NULL,
  `userid` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcontact_permissions`
--


--
-- Table structure for table `sunbird_tblcontact_roles`
--

CREATE TABLE `sunbird_tblcontact_roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `permissions` text,
  `email_notifications` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblcontact_roles`
--


--
-- Table structure for table `sunbird_tblcontacts`
--

CREATE TABLE `sunbird_tblcontacts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` int NOT NULL,
  `is_primary` int NOT NULL DEFAULT '1',
  `firstname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phonenumber` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_pass_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_pass_key_requested` datetime DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `email_verification_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verification_sent_at` datetime DEFAULT NULL,
  `last_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_password_change` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `profile_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direction` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_emails` tinyint(1) NOT NULL DEFAULT '1',
  `estimate_emails` tinyint(1) NOT NULL DEFAULT '1',
  `credit_note_emails` tinyint(1) NOT NULL DEFAULT '1',
  `contract_emails` tinyint(1) NOT NULL DEFAULT '1',
  `task_emails` tinyint(1) NOT NULL DEFAULT '1',
  `project_emails` tinyint(1) NOT NULL DEFAULT '1',
  `ticket_emails` tinyint(1) NOT NULL DEFAULT '1',
  `contact_role_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `firstname` (`firstname`),
  KEY `lastname` (`lastname`),
  KEY `email` (`email`),
  KEY `is_primary` (`is_primary`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcontacts`
--


--
-- Table structure for table `sunbird_tblcontract_comments`
--

CREATE TABLE `sunbird_tblcontract_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contract_id` int NOT NULL,
  `staffid` int NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcontract_comments`
--


--
-- Table structure for table `sunbird_tblcontract_renewals`
--

CREATE TABLE `sunbird_tblcontract_renewals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contractid` int NOT NULL,
  `old_start_date` date NOT NULL,
  `new_start_date` date NOT NULL,
  `old_end_date` date DEFAULT NULL,
  `new_end_date` date DEFAULT NULL,
  `old_value` decimal(15,2) DEFAULT NULL,
  `new_value` decimal(15,2) DEFAULT NULL,
  `date_renewed` datetime NOT NULL,
  `renewed_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `renewed_by_staff_id` int NOT NULL DEFAULT '0',
  `is_on_old_expiry_notified` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcontract_renewals`
--


--
-- Table structure for table `sunbird_tblcontracts`
--

CREATE TABLE `sunbird_tblcontracts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client` int NOT NULL,
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `contract_type` int DEFAULT NULL,
  `project_id` int DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `dateadded` datetime NOT NULL,
  `isexpirynotified` int NOT NULL DEFAULT '0',
  `contract_value` decimal(15,2) DEFAULT NULL,
  `trash` tinyint(1) DEFAULT '0',
  `not_visible_to_client` tinyint(1) NOT NULL DEFAULT '0',
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signed` tinyint(1) NOT NULL DEFAULT '0',
  `signature` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marked_as_signed` tinyint(1) NOT NULL DEFAULT '0',
  `acceptance_firstname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_lastname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_date` datetime DEFAULT NULL,
  `acceptance_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_sent_at` datetime DEFAULT NULL,
  `contacts_sent_to` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_sign_reminder_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client` (`client`),
  KEY `contract_type` (`contract_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcontracts`
--


--
-- Table structure for table `sunbird_tblcontracts_types`
--

CREATE TABLE `sunbird_tblcontracts_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcontracts_types`
--


--
-- Table structure for table `sunbird_tblcountries`
--

CREATE TABLE `sunbird_tblcountries` (
  `country_id` int NOT NULL AUTO_INCREMENT,
  `iso2` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `long_name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `iso3` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `un_member` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `calling_code` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cctld` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcountries`
--

INSERT INTO `sunbird_tblcountries` VALUES (1,'AF','Afghanistan','Islamic Republic of Afghanistan','AFG','004','yes','93','.af'),(2,'AX','Aland Islands','&Aring;land Islands','ALA','248','no','358','.ax'),(3,'AL','Albania','Republic of Albania','ALB','008','yes','355','.al'),(4,'DZ','Algeria','People\'s Democratic Republic of Algeria','DZA','012','yes','213','.dz'),(5,'AS','American Samoa','American Samoa','ASM','016','no','1+684','.as'),(6,'AD','Andorra','Principality of Andorra','AND','020','yes','376','.ad'),(7,'AO','Angola','Republic of Angola','AGO','024','yes','244','.ao'),(8,'AI','Anguilla','Anguilla','AIA','660','no','1+264','.ai'),(9,'AQ','Antarctica','Antarctica','ATA','010','no','672','.aq'),(10,'AG','Antigua and Barbuda','Antigua and Barbuda','ATG','028','yes','1+268','.ag'),(11,'AR','Argentina','Argentine Republic','ARG','032','yes','54','.ar'),(12,'AM','Armenia','Republic of Armenia','ARM','051','yes','374','.am'),(13,'AW','Aruba','Aruba','ABW','533','no','297','.aw'),(14,'AU','Australia','Commonwealth of Australia','AUS','036','yes','61','.au'),(15,'AT','Austria','Republic of Austria','AUT','040','yes','43','.at'),(16,'AZ','Azerbaijan','Republic of Azerbaijan','AZE','031','yes','994','.az'),(17,'BS','Bahamas','Commonwealth of The Bahamas','BHS','044','yes','1+242','.bs'),(18,'BH','Bahrain','Kingdom of Bahrain','BHR','048','yes','973','.bh'),(19,'BD','Bangladesh','People\'s Republic of Bangladesh','BGD','050','yes','880','.bd'),(20,'BB','Barbados','Barbados','BRB','052','yes','1+246','.bb'),(21,'BY','Belarus','Republic of Belarus','BLR','112','yes','375','.by'),(22,'BE','Belgium','Kingdom of Belgium','BEL','056','yes','32','.be'),(23,'BZ','Belize','Belize','BLZ','084','yes','501','.bz'),(24,'BJ','Benin','Republic of Benin','BEN','204','yes','229','.bj'),(25,'BM','Bermuda','Bermuda Islands','BMU','060','no','1+441','.bm'),(26,'BT','Bhutan','Kingdom of Bhutan','BTN','064','yes','975','.bt'),(27,'BO','Bolivia','Plurinational State of Bolivia','BOL','068','yes','591','.bo'),(28,'BQ','Bonaire, Sint Eustatius and Saba','Bonaire, Sint Eustatius and Saba','BES','535','no','599','.bq'),(29,'BA','Bosnia and Herzegovina','Bosnia and Herzegovina','BIH','070','yes','387','.ba'),(30,'BW','Botswana','Republic of Botswana','BWA','072','yes','267','.bw'),(31,'BV','Bouvet Island','Bouvet Island','BVT','074','no','NONE','.bv'),(32,'BR','Brazil','Federative Republic of Brazil','BRA','076','yes','55','.br'),(33,'IO','British Indian Ocean Territory','British Indian Ocean Territory','IOT','086','no','246','.io'),(34,'BN','Brunei','Brunei Darussalam','BRN','096','yes','673','.bn'),(35,'BG','Bulgaria','Republic of Bulgaria','BGR','100','yes','359','.bg'),(36,'BF','Burkina Faso','Burkina Faso','BFA','854','yes','226','.bf'),(37,'BI','Burundi','Republic of Burundi','BDI','108','yes','257','.bi'),(38,'KH','Cambodia','Kingdom of Cambodia','KHM','116','yes','855','.kh'),(39,'CM','Cameroon','Republic of Cameroon','CMR','120','yes','237','.cm'),(40,'CA','Canada','Canada','CAN','124','yes','1','.ca'),(41,'CV','Cape Verde','Republic of Cape Verde','CPV','132','yes','238','.cv'),(42,'KY','Cayman Islands','The Cayman Islands','CYM','136','no','1+345','.ky'),(43,'CF','Central African Republic','Central African Republic','CAF','140','yes','236','.cf'),(44,'TD','Chad','Republic of Chad','TCD','148','yes','235','.td'),(45,'CL','Chile','Republic of Chile','CHL','152','yes','56','.cl'),(46,'CN','China','People\'s Republic of China','CHN','156','yes','86','.cn'),(47,'CX','Christmas Island','Christmas Island','CXR','162','no','61','.cx'),(48,'CC','Cocos (Keeling) Islands','Cocos (Keeling) Islands','CCK','166','no','61','.cc'),(49,'CO','Colombia','Republic of Colombia','COL','170','yes','57','.co'),(50,'KM','Comoros','Union of the Comoros','COM','174','yes','269','.km'),(51,'CG','Congo','Republic of the Congo','COG','178','yes','242','.cg'),(52,'CK','Cook Islands','Cook Islands','COK','184','some','682','.ck'),(53,'CR','Costa Rica','Republic of Costa Rica','CRI','188','yes','506','.cr'),(54,'CI','Cote d\'ivoire (Ivory Coast)','Republic of C&ocirc;te D\'Ivoire (Ivory Coast)','CIV','384','yes','225','.ci'),(55,'HR','Croatia','Republic of Croatia','HRV','191','yes','385','.hr'),(56,'CU','Cuba','Republic of Cuba','CUB','192','yes','53','.cu'),(57,'CW','Curacao','Cura&ccedil;ao','CUW','531','no','599','.cw'),(58,'CY','Cyprus','Republic of Cyprus','CYP','196','yes','357','.cy'),(59,'CZ','Czech Republic','Czech Republic','CZE','203','yes','420','.cz'),(60,'CD','Democratic Republic of the Congo','Democratic Republic of the Congo','COD','180','yes','243','.cd'),(61,'DK','Denmark','Kingdom of Denmark','DNK','208','yes','45','.dk'),(62,'DJ','Djibouti','Republic of Djibouti','DJI','262','yes','253','.dj'),(63,'DM','Dominica','Commonwealth of Dominica','DMA','212','yes','1+767','.dm'),(64,'DO','Dominican Republic','Dominican Republic','DOM','214','yes','1+809, 8','.do'),(65,'EC','Ecuador','Republic of Ecuador','ECU','218','yes','593','.ec'),(66,'EG','Egypt','Arab Republic of Egypt','EGY','818','yes','20','.eg'),(67,'SV','El Salvador','Republic of El Salvador','SLV','222','yes','503','.sv'),(68,'GQ','Equatorial Guinea','Republic of Equatorial Guinea','GNQ','226','yes','240','.gq'),(69,'ER','Eritrea','State of Eritrea','ERI','232','yes','291','.er'),(70,'EE','Estonia','Republic of Estonia','EST','233','yes','372','.ee'),(71,'ET','Ethiopia','Federal Democratic Republic of Ethiopia','ETH','231','yes','251','.et'),(72,'FK','Falkland Islands (Malvinas)','The Falkland Islands (Malvinas)','FLK','238','no','500','.fk'),(73,'FO','Faroe Islands','The Faroe Islands','FRO','234','no','298','.fo'),(74,'FJ','Fiji','Republic of Fiji','FJI','242','yes','679','.fj'),(75,'FI','Finland','Republic of Finland','FIN','246','yes','358','.fi'),(76,'FR','France','French Republic','FRA','250','yes','33','.fr'),(77,'GF','French Guiana','French Guiana','GUF','254','no','594','.gf'),(78,'PF','French Polynesia','French Polynesia','PYF','258','no','689','.pf'),(79,'TF','French Southern Territories','French Southern Territories','ATF','260','no',NULL,'.tf'),(80,'GA','Gabon','Gabonese Republic','GAB','266','yes','241','.ga'),(81,'GM','Gambia','Republic of The Gambia','GMB','270','yes','220','.gm'),(82,'GE','Georgia','Georgia','GEO','268','yes','995','.ge'),(83,'DE','Germany','Federal Republic of Germany','DEU','276','yes','49','.de'),(84,'GH','Ghana','Republic of Ghana','GHA','288','yes','233','.gh'),(85,'GI','Gibraltar','Gibraltar','GIB','292','no','350','.gi'),(86,'GR','Greece','Hellenic Republic','GRC','300','yes','30','.gr'),(87,'GL','Greenland','Greenland','GRL','304','no','299','.gl'),(88,'GD','Grenada','Grenada','GRD','308','yes','1+473','.gd'),(89,'GP','Guadaloupe','Guadeloupe','GLP','312','no','590','.gp'),(90,'GU','Guam','Guam','GUM','316','no','1+671','.gu'),(91,'GT','Guatemala','Republic of Guatemala','GTM','320','yes','502','.gt'),(92,'GG','Guernsey','Guernsey','GGY','831','no','44','.gg'),(93,'GN','Guinea','Republic of Guinea','GIN','324','yes','224','.gn'),(94,'GW','Guinea-Bissau','Republic of Guinea-Bissau','GNB','624','yes','245','.gw'),(95,'GY','Guyana','Co-operative Republic of Guyana','GUY','328','yes','592','.gy'),(96,'HT','Haiti','Republic of Haiti','HTI','332','yes','509','.ht'),(97,'HM','Heard Island and McDonald Islands','Heard Island and McDonald Islands','HMD','334','no','NONE','.hm'),(98,'HN','Honduras','Republic of Honduras','HND','340','yes','504','.hn'),(99,'HK','Hong Kong','Hong Kong','HKG','344','no','852','.hk'),(100,'HU','Hungary','Hungary','HUN','348','yes','36','.hu'),(101,'IS','Iceland','Republic of Iceland','ISL','352','yes','354','.is'),(102,'IN','India','Republic of India','IND','356','yes','91','.in'),(103,'ID','Indonesia','Republic of Indonesia','IDN','360','yes','62','.id'),(104,'IR','Iran','Islamic Republic of Iran','IRN','364','yes','98','.ir'),(105,'IQ','Iraq','Republic of Iraq','IRQ','368','yes','964','.iq'),(106,'IE','Ireland','Ireland','IRL','372','yes','353','.ie'),(107,'IM','Isle of Man','Isle of Man','IMN','833','no','44','.im'),(108,'IL','Israel','State of Israel','ISR','376','yes','972','.il'),(109,'IT','Italy','Italian Republic','ITA','380','yes','39','.jm'),(110,'JM','Jamaica','Jamaica','JAM','388','yes','1+876','.jm'),(111,'JP','Japan','Japan','JPN','392','yes','81','.jp'),(112,'JE','Jersey','The Bailiwick of Jersey','JEY','832','no','44','.je'),(113,'JO','Jordan','Hashemite Kingdom of Jordan','JOR','400','yes','962','.jo'),(114,'KZ','Kazakhstan','Republic of Kazakhstan','KAZ','398','yes','7','.kz'),(115,'KE','Kenya','Republic of Kenya','KEN','404','yes','254','.ke'),(116,'KI','Kiribati','Republic of Kiribati','KIR','296','yes','686','.ki'),(117,'XK','Kosovo','Republic of Kosovo','---','---','some','381',''),(118,'KW','Kuwait','State of Kuwait','KWT','414','yes','965','.kw'),(119,'KG','Kyrgyzstan','Kyrgyz Republic','KGZ','417','yes','996','.kg'),(120,'LA','Laos','Lao People\'s Democratic Republic','LAO','418','yes','856','.la'),(121,'LV','Latvia','Republic of Latvia','LVA','428','yes','371','.lv'),(122,'LB','Lebanon','Republic of Lebanon','LBN','422','yes','961','.lb'),(123,'LS','Lesotho','Kingdom of Lesotho','LSO','426','yes','266','.ls'),(124,'LR','Liberia','Republic of Liberia','LBR','430','yes','231','.lr'),(125,'LY','Libya','Libya','LBY','434','yes','218','.ly'),(126,'LI','Liechtenstein','Principality of Liechtenstein','LIE','438','yes','423','.li'),(127,'LT','Lithuania','Republic of Lithuania','LTU','440','yes','370','.lt'),(128,'LU','Luxembourg','Grand Duchy of Luxembourg','LUX','442','yes','352','.lu'),(129,'MO','Macao','The Macao Special Administrative Region','MAC','446','no','853','.mo'),(130,'MK','North Macedonia','Republic of North Macedonia','MKD','807','yes','389','.mk'),(131,'MG','Madagascar','Republic of Madagascar','MDG','450','yes','261','.mg'),(132,'MW','Malawi','Republic of Malawi','MWI','454','yes','265','.mw'),(133,'MY','Malaysia','Malaysia','MYS','458','yes','60','.my'),(134,'MV','Maldives','Republic of Maldives','MDV','462','yes','960','.mv'),(135,'ML','Mali','Republic of Mali','MLI','466','yes','223','.ml'),(136,'MT','Malta','Republic of Malta','MLT','470','yes','356','.mt'),(137,'MH','Marshall Islands','Republic of the Marshall Islands','MHL','584','yes','692','.mh'),(138,'MQ','Martinique','Martinique','MTQ','474','no','596','.mq'),(139,'MR','Mauritania','Islamic Republic of Mauritania','MRT','478','yes','222','.mr'),(140,'MU','Mauritius','Republic of Mauritius','MUS','480','yes','230','.mu'),(141,'YT','Mayotte','Mayotte','MYT','175','no','262','.yt'),(142,'MX','Mexico','United Mexican States','MEX','484','yes','52','.mx'),(143,'FM','Micronesia','Federated States of Micronesia','FSM','583','yes','691','.fm'),(144,'MD','Moldava','Republic of Moldova','MDA','498','yes','373','.md'),(145,'MC','Monaco','Principality of Monaco','MCO','492','yes','377','.mc'),(146,'MN','Mongolia','Mongolia','MNG','496','yes','976','.mn'),(147,'ME','Montenegro','Montenegro','MNE','499','yes','382','.me'),(148,'MS','Montserrat','Montserrat','MSR','500','no','1+664','.ms'),(149,'MA','Morocco','Kingdom of Morocco','MAR','504','yes','212','.ma'),(150,'MZ','Mozambique','Republic of Mozambique','MOZ','508','yes','258','.mz'),(151,'MM','Myanmar (Burma)','Republic of the Union of Myanmar','MMR','104','yes','95','.mm'),(152,'NA','Namibia','Republic of Namibia','NAM','516','yes','264','.na'),(153,'NR','Nauru','Republic of Nauru','NRU','520','yes','674','.nr'),(154,'NP','Nepal','Federal Democratic Republic of Nepal','NPL','524','yes','977','.np'),(155,'NL','Netherlands','Kingdom of the Netherlands','NLD','528','yes','31','.nl'),(156,'NC','New Caledonia','New Caledonia','NCL','540','no','687','.nc'),(157,'NZ','New Zealand','New Zealand','NZL','554','yes','64','.nz'),(158,'NI','Nicaragua','Republic of Nicaragua','NIC','558','yes','505','.ni'),(159,'NE','Niger','Republic of Niger','NER','562','yes','227','.ne'),(160,'NG','Nigeria','Federal Republic of Nigeria','NGA','566','yes','234','.ng'),(161,'NU','Niue','Niue','NIU','570','some','683','.nu'),(162,'NF','Norfolk Island','Norfolk Island','NFK','574','no','672','.nf'),(163,'KP','North Korea','Democratic People\'s Republic of Korea','PRK','408','yes','850','.kp'),(164,'MP','Northern Mariana Islands','Northern Mariana Islands','MNP','580','no','1+670','.mp'),(165,'NO','Norway','Kingdom of Norway','NOR','578','yes','47','.no'),(166,'OM','Oman','Sultanate of Oman','OMN','512','yes','968','.om'),(167,'PK','Pakistan','Islamic Republic of Pakistan','PAK','586','yes','92','.pk'),(168,'PW','Palau','Republic of Palau','PLW','585','yes','680','.pw'),(169,'PS','Palestine','State of Palestine (or Occupied Palestinian Territory)','PSE','275','some','970','.ps'),(170,'PA','Panama','Republic of Panama','PAN','591','yes','507','.pa'),(171,'PG','Papua New Guinea','Independent State of Papua New Guinea','PNG','598','yes','675','.pg'),(172,'PY','Paraguay','Republic of Paraguay','PRY','600','yes','595','.py'),(173,'PE','Peru','Republic of Peru','PER','604','yes','51','.pe'),(174,'PH','Philippines','Republic of the Philippines','PHL','608','yes','63','.ph'),(175,'PN','Pitcairn','Pitcairn','PCN','612','no','NONE','.pn'),(176,'PL','Poland','Republic of Poland','POL','616','yes','48','.pl'),(177,'PT','Portugal','Portuguese Republic','PRT','620','yes','351','.pt'),(178,'PR','Puerto Rico','Commonwealth of Puerto Rico','PRI','630','no','1+939','.pr'),(179,'QA','Qatar','State of Qatar','QAT','634','yes','974','.qa'),(180,'RE','Reunion','R&eacute;union','REU','638','no','262','.re'),(181,'RO','Romania','Romania','ROU','642','yes','40','.ro'),(182,'RU','Russia','Russian Federation','RUS','643','yes','7','.ru'),(183,'RW','Rwanda','Republic of Rwanda','RWA','646','yes','250','.rw'),(184,'BL','Saint Barthelemy','Saint Barth&eacute;lemy','BLM','652','no','590','.bl'),(185,'SH','Saint Helena','Saint Helena, Ascension and Tristan da Cunha','SHN','654','no','290','.sh'),(186,'KN','Saint Kitts and Nevis','Federation of Saint Christopher and Nevis','KNA','659','yes','1+869','.kn'),(187,'LC','Saint Lucia','Saint Lucia','LCA','662','yes','1+758','.lc'),(188,'MF','Saint Martin','Saint Martin','MAF','663','no','590','.mf'),(189,'PM','Saint Pierre and Miquelon','Saint Pierre and Miquelon','SPM','666','no','508','.pm'),(190,'VC','Saint Vincent and the Grenadines','Saint Vincent and the Grenadines','VCT','670','yes','1+784','.vc'),(191,'WS','Samoa','Independent State of Samoa','WSM','882','yes','685','.ws'),(192,'SM','San Marino','Republic of San Marino','SMR','674','yes','378','.sm'),(193,'ST','Sao Tome and Principe','Democratic Republic of S&atilde;o Tom&eacute; and Pr&iacute;ncipe','STP','678','yes','239','.st'),(194,'SA','Saudi Arabia','Kingdom of Saudi Arabia','SAU','682','yes','966','.sa'),(195,'SN','Senegal','Republic of Senegal','SEN','686','yes','221','.sn'),(196,'RS','Serbia','Republic of Serbia','SRB','688','yes','381','.rs'),(197,'SC','Seychelles','Republic of Seychelles','SYC','690','yes','248','.sc'),(198,'SL','Sierra Leone','Republic of Sierra Leone','SLE','694','yes','232','.sl'),(199,'SG','Singapore','Republic of Singapore','SGP','702','yes','65','.sg'),(200,'SX','Sint Maarten','Sint Maarten','SXM','534','no','1+721','.sx'),(201,'SK','Slovakia','Slovak Republic','SVK','703','yes','421','.sk'),(202,'SI','Slovenia','Republic of Slovenia','SVN','705','yes','386','.si'),(203,'SB','Solomon Islands','Solomon Islands','SLB','090','yes','677','.sb'),(204,'SO','Somalia','Somali Republic','SOM','706','yes','252','.so'),(205,'ZA','South Africa','Republic of South Africa','ZAF','710','yes','27','.za'),(206,'GS','South Georgia and the South Sandwich Islands','South Georgia and the South Sandwich Islands','SGS','239','no','500','.gs'),(207,'KR','South Korea','Republic of Korea','KOR','410','yes','82','.kr'),(208,'SS','South Sudan','Republic of South Sudan','SSD','728','yes','211','.ss'),(209,'ES','Spain','Kingdom of Spain','ESP','724','yes','34','.es'),(210,'LK','Sri Lanka','Democratic Socialist Republic of Sri Lanka','LKA','144','yes','94','.lk'),(211,'SD','Sudan','Republic of the Sudan','SDN','729','yes','249','.sd'),(212,'SR','Suriname','Republic of Suriname','SUR','740','yes','597','.sr'),(213,'SJ','Svalbard and Jan Mayen','Svalbard and Jan Mayen','SJM','744','no','47','.sj'),(214,'SZ','Swaziland','Kingdom of Swaziland','SWZ','748','yes','268','.sz'),(215,'SE','Sweden','Kingdom of Sweden','SWE','752','yes','46','.se'),(216,'CH','Switzerland','Swiss Confederation','CHE','756','yes','41','.ch'),(217,'SY','Syria','Syrian Arab Republic','SYR','760','yes','963','.sy'),(218,'TW','Taiwan','Republic of China (Taiwan)','TWN','158','former','886','.tw'),(219,'TJ','Tajikistan','Republic of Tajikistan','TJK','762','yes','992','.tj'),(220,'TZ','Tanzania','United Republic of Tanzania','TZA','834','yes','255','.tz'),(221,'TH','Thailand','Kingdom of Thailand','THA','764','yes','66','.th'),(222,'TL','Timor-Leste (East Timor)','Democratic Republic of Timor-Leste','TLS','626','yes','670','.tl'),(223,'TG','Togo','Togolese Republic','TGO','768','yes','228','.tg'),(224,'TK','Tokelau','Tokelau','TKL','772','no','690','.tk'),(225,'TO','Tonga','Kingdom of Tonga','TON','776','yes','676','.to'),(226,'TT','Trinidad and Tobago','Republic of Trinidad and Tobago','TTO','780','yes','1+868','.tt'),(227,'TN','Tunisia','Republic of Tunisia','TUN','788','yes','216','.tn'),(228,'TR','Turkey','Republic of Turkey','TUR','792','yes','90','.tr'),(229,'TM','Turkmenistan','Turkmenistan','TKM','795','yes','993','.tm'),(230,'TC','Turks and Caicos Islands','Turks and Caicos Islands','TCA','796','no','1+649','.tc'),(231,'TV','Tuvalu','Tuvalu','TUV','798','yes','688','.tv'),(232,'UG','Uganda','Republic of Uganda','UGA','800','yes','256','.ug'),(233,'UA','Ukraine','Ukraine','UKR','804','yes','380','.ua'),(234,'AE','United Arab Emirates','United Arab Emirates','ARE','784','yes','971','.ae'),(235,'GB','United Kingdom','United Kingdom of Great Britain and Nothern Ireland','GBR','826','yes','44','.uk'),(236,'US','United States','United States of America','USA','840','yes','1','.us'),(237,'UM','United States Minor Outlying Islands','United States Minor Outlying Islands','UMI','581','no','NONE','NONE'),(238,'UY','Uruguay','Eastern Republic of Uruguay','URY','858','yes','598','.uy'),(239,'UZ','Uzbekistan','Republic of Uzbekistan','UZB','860','yes','998','.uz'),(240,'VU','Vanuatu','Republic of Vanuatu','VUT','548','yes','678','.vu'),(241,'VA','Vatican City','State of the Vatican City','VAT','336','no','39','.va'),(242,'VE','Venezuela','Bolivarian Republic of Venezuela','VEN','862','yes','58','.ve'),(243,'VN','Vietnam','Socialist Republic of Vietnam','VNM','704','yes','84','.vn'),(244,'VG','Virgin Islands, British','British Virgin Islands','VGB','092','no','1+284','.vg'),(245,'VI','Virgin Islands, US','Virgin Islands of the United States','VIR','850','no','1+340','.vi'),(246,'WF','Wallis and Futuna','Wallis and Futuna','WLF','876','no','681','.wf'),(247,'EH','Western Sahara','Western Sahara','ESH','732','no','212','.eh'),(248,'YE','Yemen','Republic of Yemen','YEM','887','yes','967','.ye'),(249,'ZM','Zambia','Republic of Zambia','ZMB','894','yes','260','.zm'),(250,'ZW','Zimbabwe','Republic of Zimbabwe','ZWE','716','yes','263','.zw');

--
-- Table structure for table `sunbird_tblcreditnote_refunds`
--

CREATE TABLE `sunbird_tblcreditnote_refunds` (
  `id` int NOT NULL AUTO_INCREMENT,
  `credit_note_id` int NOT NULL,
  `staff_id` int NOT NULL,
  `refunded_on` date NOT NULL,
  `payment_mode` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `amount` decimal(15,2) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcreditnote_refunds`
--


--
-- Table structure for table `sunbird_tblcreditnotes`
--

CREATE TABLE `sunbird_tblcreditnotes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `clientid` int NOT NULL,
  `deleted_customer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` int NOT NULL,
  `prefix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_format` int NOT NULL DEFAULT '1',
  `formatted_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `adminnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `terms` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `clientnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `currency` int 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 DEFAULT NULL,
  `status` int DEFAULT '1',
  `project_id` int NOT NULL DEFAULT '0',
  `discount_percent` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `discount_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int DEFAULT NULL,
  `shipping_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_credit_note` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int NOT NULL DEFAULT '1',
  `reference_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `currency` (`currency`),
  KEY `clientid` (`clientid`),
  KEY `project_id` (`project_id`),
  KEY `formatted_number` (`formatted_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcreditnotes`
--


--
-- Table structure for table `sunbird_tblcredits`
--

CREATE TABLE `sunbird_tblcredits` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `credit_id` int NOT NULL,
  `staff_id` int NOT NULL,
  `date` date NOT NULL,
  `date_applied` datetime NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcredits`
--


--
-- Table structure for table `sunbird_tblcurrencies`
--

CREATE TABLE `sunbird_tblcurrencies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `symbol` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `decimal_separator` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thousand_separator` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placement` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isdefault` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcurrencies`
--

INSERT INTO `sunbird_tblcurrencies` VALUES (1,'$','USD','.',',','before',0),(2,'€','EUR',',','.','before',0),(3,'TSh','TZS','.',',','before',1);

--
-- Table structure for table `sunbird_tblcurrency_rate_logs`
--

CREATE TABLE `sunbird_tblcurrency_rate_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_currency_id` int DEFAULT NULL,
  `from_currency_name` varchar(100) DEFAULT NULL,
  `from_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `to_currency_id` int DEFAULT NULL,
  `to_currency_name` varchar(100) DEFAULT NULL,
  `to_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblcurrency_rate_logs`
--


--
-- Table structure for table `sunbird_tblcurrency_rates`
--

CREATE TABLE `sunbird_tblcurrency_rates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_currency_id` int DEFAULT NULL,
  `from_currency_name` varchar(100) DEFAULT NULL,
  `from_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `to_currency_id` int DEFAULT NULL,
  `to_currency_name` varchar(100) DEFAULT NULL,
  `to_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `date_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblcurrency_rates`
--


--
-- Table structure for table `sunbird_tblcustomer_admins`
--

CREATE TABLE `sunbird_tblcustomer_admins` (
  `staff_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `date_assigned` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `customer_id` (`customer_id`),
  KEY `sunbird_staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcustomer_admins`
--


--
-- Table structure for table `sunbird_tblcustomer_groups`
--

CREATE TABLE `sunbird_tblcustomer_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `groupid` int NOT NULL,
  `customer_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `groupid` (`groupid`),
  KEY `customer_id` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcustomer_groups`
--


--
-- Table structure for table `sunbird_tblcustomers_groups`
--

CREATE TABLE `sunbird_tblcustomers_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcustomers_groups`
--


--
-- Table structure for table `sunbird_tblcustomfields`
--

CREATE TABLE `sunbird_tblcustomfields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fieldto` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `display_inline` tinyint(1) NOT NULL DEFAULT '0',
  `field_order` int DEFAULT '0',
  `active` int NOT NULL DEFAULT '1',
  `show_on_pdf` int NOT NULL DEFAULT '0',
  `show_on_ticket_form` tinyint(1) NOT NULL DEFAULT '0',
  `only_admin` tinyint(1) NOT NULL DEFAULT '0',
  `show_on_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_on_client_portal` int NOT NULL DEFAULT '0',
  `disalow_client_to_edit` int NOT NULL DEFAULT '0',
  `bs_column` int NOT NULL DEFAULT '12',
  `default_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcustomfields`
--


--
-- Table structure for table `sunbird_tblcustomfieldsvalues`
--

CREATE TABLE `sunbird_tblcustomfieldsvalues` (
  `id` int NOT NULL AUTO_INCREMENT,
  `relid` int NOT NULL,
  `fieldid` int NOT NULL,
  `fieldto` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `relid` (`relid`),
  KEY `fieldto` (`fieldto`),
  KEY `fieldid` (`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblcustomfieldsvalues`
--


--
-- Table structure for table `sunbird_tbldepartments`
--

CREATE TABLE `sunbird_tbldepartments` (
  `departmentid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `imap_username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_from_header` tinyint(1) NOT NULL DEFAULT '0',
  `host` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `encryption` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INBOX',
  `delete_after_import` int NOT NULL DEFAULT '0',
  `calendar_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `hidefromclient` tinyint(1) NOT NULL DEFAULT '0',
  `manager_id` int DEFAULT '0',
  `parent_id` int DEFAULT '0',
  PRIMARY KEY (`departmentid`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbldepartments`
--


--
-- Table structure for table `sunbird_tbldismissed_announcements`
--

CREATE TABLE `sunbird_tbldismissed_announcements` (
  `dismissedannouncementid` int NOT NULL AUTO_INCREMENT,
  `announcementid` int NOT NULL,
  `staff` int NOT NULL,
  `userid` int NOT NULL,
  PRIMARY KEY (`dismissedannouncementid`),
  KEY `announcementid` (`announcementid`),
  KEY `sunbird_staff` (`staff`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbldismissed_announcements`
--


--
-- Table structure for table `sunbird_tblemaillists`
--

CREATE TABLE `sunbird_tblemaillists` (
  `listid` int NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `creator` varchar(100) NOT NULL,
  `datecreated` datetime NOT NULL,
  PRIMARY KEY (`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblemaillists`
--


--
-- Table structure for table `sunbird_tblemailtemplates`
--

CREATE TABLE `sunbird_tblemailtemplates` (
  `emailtemplateid` int NOT NULL AUTO_INCREMENT,
  `type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromname` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromemail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plaintext` int NOT NULL DEFAULT '0',
  `active` tinyint NOT NULL DEFAULT '0',
  `order` int NOT NULL,
  PRIMARY KEY (`emailtemplateid`)
) ENGINE=InnoDB AUTO_INCREMENT=444 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblemailtemplates`
--

INSERT INTO `sunbird_tblemailtemplates` VALUES (1,'client','new-client-created','english','New Contact Added/Registered (Welcome Email)','Welcome aboard','Dear {contact_firstname} {contact_lastname}<br /><br />Thank you for registering on the <strong>{companyname}</strong> CRM System.<br /><br />We just wanted to say welcome.<br /><br />Please contact us if you need any help.<br /><br />Click here to view your profile: <a href=\"{crm_url}\">{crm_url}</a><br /><br />Kind Regards, <br />{email_signature}<br /><br />(This is an automated email, so please don\'t reply to this email address)','{companyname} | CRM','',0,1,0),(2,'invoice','invoice-send-to-client','english','Send Invoice to Customer','Invoice with number {invoice_number} created','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">We have prepared the following invoice for you: <strong># {invoice_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Invoice status</strong>: {invoice_status}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(3,'ticket','new-ticket-opened-admin','english','New Ticket Opened (Opened by Staff, Sent to Customer)','New Support Ticket Opened','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">New support ticket has been opened.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department:</strong> {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {ticket_priority}<br /></span><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_public_url}\">#{ticket_id}</a><br /><br />Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(4,'ticket','ticket-reply','english','Ticket Reply (Sent to Customer)','New Ticket Reply','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">You have a new ticket reply to ticket <a href=\"{ticket_public_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket Subject:</strong> {ticket_subject}<br /></span><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_public_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(5,'ticket','ticket-autoresponse','english','New Ticket Opened - Autoresponse','New Support Ticket Opened','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Thank you for contacting our support team. A support ticket has now been opened for your request. You will be notified when a response is made by email.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_public_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(6,'invoice','invoice-payment-recorded','english','Invoice Payment Recorded (Sent to Customer)','Invoice Payment Recorded','<span style=\"font-size: 12pt;\">Hello {contact_firstname}&nbsp;{contact_lastname}<br /><br /></span>Thank you for the payment. Find the payment details below:<br /><br />-------------------------------------------------<br /><br />Amount:&nbsp;<strong>{payment_total}<br /></strong>Date:&nbsp;<strong>{payment_date}</strong><br />Invoice number:&nbsp;<span style=\"font-size: 12pt;\"><strong># {invoice_number}<br /><br /></strong></span>-------------------------------------------------<br /><br />You can always view the invoice for this payment at the following link:&nbsp;<a href=\"{invoice_link}\"><span style=\"font-size: 12pt;\">{invoice_number}</span></a><br /><br />We are looking forward working with you.<br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(7,'invoice','invoice-overdue-notice','english','Invoice Overdue Notice','Invoice Overdue Notice - {invoice_number}','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">This is an overdue notice for invoice <strong># {invoice_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\">This invoice was due: {invoice_duedate}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(8,'invoice','invoice-already-send','english','Invoice Already Sent to Customer','Invoice # {invoice_number} ','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">At your request, here is the invoice with number <strong># {invoice_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(9,'ticket','new-ticket-created-staff','english','New Ticket Created (Opened by Customer, Sent to Staff Members)','New Ticket Created','<p><span style=\"font-size: 12pt;\">A new support ticket has been opened.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject</strong>: {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority</strong>: {ticket_priority}<br /></span><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_url}\">#{ticket_id}</a></span><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(10,'estimate','estimate-send-to-client','english','Send Estimate to Customer','Estimate # {estimate_number} created','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Please find the attached estimate <strong># {estimate_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Estimate status:</strong> {estimate_status}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">We look forward to your communication.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}<br /></span>','{companyname} | CRM','',0,1,0),(11,'ticket','ticket-reply-to-admin','english','Ticket Reply (Sent to Staff)','New Support Ticket Reply','<span style=\"font-size: 12pt;\">A new support ticket reply from {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject</strong>: {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority</strong>: {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(12,'estimate','estimate-already-send','english','Estimate Already Sent to Customer','Estimate # {estimate_number} ','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /> <br /><span style=\"font-size: 12pt;\">Thank you for your estimate request.</span><br /> <br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(13,'contract','contract-expiration','english','Contract Expiration Reminder (Sent to Customer Contacts)','Contract Expiration Reminder','<span style=\"font-size: 12pt;\">Dear {client_company}</span><br /><br /><span style=\"font-size: 12pt;\">This is a reminder that the following contract will expire soon:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {contract_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Description:</strong> {contract_description}</span><br /><span style=\"font-size: 12pt;\"><strong>Date Start:</strong> {contract_datestart}</span><br /><span style=\"font-size: 12pt;\"><strong>Date End:</strong> {contract_dateend}</span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(14,'tasks','task-assigned','english','New Task Assigned (Sent to Staff)','New Task Assigned to You - {task_name}','<span style=\"font-size: 12pt;\">Dear {staff_firstname}</span><br /><br /><span style=\"font-size: 12pt;\">You have been assigned to a new task:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}<br /></span><strong>Start Date:</strong> {task_startdate}<br /><span style=\"font-size: 12pt;\"><strong>Due date:</strong> {task_duedate}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {task_priority}<br /><br /></span><span style=\"font-size: 12pt;\"><span>You can view the task on the following link</span>: <a href=\"{task_link}\">{task_name}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(15,'tasks','task-added-as-follower','english','Staff Member Added as Follower on Task (Sent to Staff)','You are added as follower on task - {task_name}','<span style=\"font-size: 12pt;\">Hi {staff_firstname}<br /></span><br /><span style=\"font-size: 12pt;\">You have been added as follower on the following task:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}</span><br /><span style=\"font-size: 12pt;\"><strong>Start date:</strong> {task_startdate}</span><br /><br /><span>You can view the task on the following link</span><span>: </span><a href=\"{task_link}\">{task_name}</a><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(16,'tasks','task-commented','english','New Comment on Task (Sent to Staff)','New Comment on Task - {task_name}','Dear {staff_firstname}<br /><br />A comment has been made on the following task:<br /><br /><strong>Name:</strong> {task_name}<br /><strong>Comment:</strong> {task_comment}<br /><br />You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a><br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(17,'tasks','task-added-attachment','english','New Attachment(s) on Task (Sent to Staff)','New Attachment on Task - {task_name}','Hi {staff_firstname}<br /><br /><strong>{task_user_take_action}</strong> added an attachment on the following task:<br /><br /><strong>Name:</strong> {task_name}<br /><br />You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a><br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(18,'estimate','estimate-declined-to-staff','english','Estimate Declined (Sent to Staff)','Customer Declined Estimate','<span style=\"font-size: 12pt;\">Hi</span><br /> <br /><span style=\"font-size: 12pt;\">Customer ({client_company}) declined estimate with number <strong># {estimate_number}</strong></span><br /> <br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(19,'estimate','estimate-accepted-to-staff','english','Estimate Accepted (Sent to Staff)','Customer Accepted Estimate','<span style=\"font-size: 12pt;\">Hi</span><br /> <br /><span style=\"font-size: 12pt;\">Customer ({client_company}) accepted estimate with number <strong># {estimate_number}</strong></span><br /> <br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(20,'proposals','proposal-client-accepted','english','Customer Action - Accepted (Sent to Staff)','Customer Accepted Proposal','<div>Hi<br /> <br />Client <strong>{proposal_proposal_to}</strong> accepted the following proposal:<br /> <br /><strong>Number:</strong> {proposal_number}<br /><strong>Subject</strong>: {proposal_subject}<br /><strong>Total</strong>: {proposal_total}<br /> <br />View the proposal on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /> <br />Kind Regards,<br />{email_signature}</div>\r\n<div>&nbsp;</div>\r\n<div>&nbsp;</div>\r\n<div>&nbsp;</div>','{companyname} | CRM','',0,1,0),(21,'proposals','proposal-send-to-customer','english','Send Proposal to Customer','Proposal With Number {proposal_number} Created','Dear {proposal_proposal_to}<br /><br />Please find our attached proposal.<br /><br />This proposal is valid until: {proposal_open_till}<br />You can view the proposal on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /><br />Please don\'t hesitate to comment online if you have any questions.<br /><br />We look forward to your communication.<br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(22,'proposals','proposal-client-declined','english','Customer Action - Declined (Sent to Staff)','Client Declined Proposal','Hi<br /> <br />Customer <strong>{proposal_proposal_to}</strong> declined the proposal <strong>{proposal_subject}</strong><br /> <br />View the proposal on the following link <a href=\"{proposal_link}\">{proposal_number}</a>&nbsp;or from the admin area.<br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(23,'proposals','proposal-client-thank-you','english','Thank You Email (Sent to Customer After Accept)','Thank for you accepting proposal','Dear {proposal_proposal_to}<br /> <br />Thank for for accepting the proposal.<br /> <br />We look forward to doing business with you.<br /> <br />We will contact you as soon as possible<br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(24,'proposals','proposal-comment-to-client','english','New Comment  (Sent to Customer/Lead)','New Proposal Comment','Dear {proposal_proposal_to}<br /> <br />A new comment has been made on the following proposal: <strong>{proposal_number}</strong><br /> <br />You can view and reply to the comment on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(25,'proposals','proposal-comment-to-admin','english','New Comment (Sent to Staff) ','New Proposal Comment','Hi<br /> <br />A new comment has been made to the proposal <strong>{proposal_subject}</strong><br /> <br />You can view and reply to the comment on the following link: <a href=\"{proposal_link}\">{proposal_number}</a>&nbsp;or from the admin area.<br /> <br />{email_signature}','{companyname} | CRM','',0,1,0),(26,'estimate','estimate-thank-you-to-customer','english','Thank You Email (Sent to Customer After Accept)','Thank for you accepting estimate','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /> <br /><span style=\"font-size: 12pt;\">Thank for for accepting the estimate.</span><br /> <br /><span style=\"font-size: 12pt;\">We look forward to doing business with you.</span><br /> <br /><span style=\"font-size: 12pt;\">We will contact you as soon as possible.</span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(27,'tasks','task-deadline-notification','english','Task Deadline Reminder - Sent to Assigned Members','Task Deadline Reminder','Hi {staff_firstname}&nbsp;{staff_lastname}<br /><br />This is an automated email from {companyname}.<br /><br />The task <strong>{task_name}</strong> deadline is on <strong>{task_duedate}</strong>. <br />This task is still not finished.<br /><br />You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a><br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(28,'contract','send-contract','english','Send Contract to Customer','Contract - {contract_subject}','<p><span style=\"font-size: 12pt;\">Hi&nbsp;{contact_firstname}&nbsp;{contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Please find the <a href=\"{contract_link}\">{contract_subject}</a> attached.<br /><br />Description: {contract_description}<br /><br /></span><span style=\"font-size: 12pt;\">Looking forward to hear from you.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(29,'invoice','invoice-payment-recorded-to-staff','english','Invoice Payment Recorded (Sent to Staff)','New Invoice Payment','<span style=\"font-size: 12pt;\">Hi</span><br /><br /><span style=\"font-size: 12pt;\">Customer recorded payment for invoice <strong># {invoice_number}</strong></span><br /> <br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(30,'ticket','auto-close-ticket','english','Auto Close Ticket','Ticket Auto Closed','<p><span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Ticket {ticket_subject} has been auto close due to inactivity.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket #</strong>: <a href=\"{ticket_public_url}\">{ticket_id}</a></span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(31,'project','new-project-discussion-created-to-staff','english','New Project Discussion (Sent to Project Members)','New Project Discussion Created - {project_name}','<p>Hi {staff_firstname}<br /><br />New project discussion created from <strong>{discussion_creator}</strong><br /><br /><strong>Subject:</strong> {discussion_subject}<br /><strong>Description:</strong> {discussion_description}<br /><br />You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(32,'project','new-project-discussion-created-to-customer','english','New Project Discussion (Sent to Customer Contacts)','New Project Discussion Created - {project_name}','<p>Hello {contact_firstname} {contact_lastname}<br /><br />New project discussion created from <strong>{discussion_creator}</strong><br /><br /><strong>Subject:</strong> {discussion_subject}<br /><strong>Description:</strong> {discussion_description}<br /><br />You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(33,'project','new-project-file-uploaded-to-customer','english','New Project File(s) Uploaded (Sent to Customer Contacts)','New Project File(s) Uploaded - {project_name}','<p>Hello {contact_firstname} {contact_lastname}<br /><br />New project file is uploaded on <strong>{project_name}</strong> from <strong>{file_creator}</strong><br /><br />You can view the project on the following link: <a href=\"{project_link}\">{project_name}</a><br /><br />To view the file in our CRM you can click on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(34,'project','new-project-file-uploaded-to-staff','english','New Project File(s) Uploaded (Sent to Project Members)','New Project File(s) Uploaded - {project_name}','<p>Hello&nbsp;{staff_firstname}</p>\r\n<p>New project&nbsp;file is uploaded on&nbsp;<strong>{project_name}</strong> from&nbsp;<strong>{file_creator}</strong></p>\r\n<p>You can view the project on the following link: <a href=\"{project_link}\">{project_name}<br /></a><br />To view&nbsp;the file you can click on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a></p>\r\n<p>Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(35,'project','new-project-discussion-comment-to-customer','english','New Discussion Comment  (Sent to Customer Contacts)','New Discussion Comment','<p><span style=\"font-size: 12pt;\">Hello {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">New discussion comment has been made on <strong>{discussion_subject}</strong> from <strong>{comment_creator}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Discussion subject:</strong> {discussion_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Comment</strong>: {discussion_comment}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(36,'project','new-project-discussion-comment-to-staff','english','New Discussion Comment (Sent to Project Members)','New Discussion Comment','<p>Hi {staff_firstname}<br /><br />New discussion comment has been made on <strong>{discussion_subject}</strong> from <strong>{comment_creator}</strong><br /><br /><strong>Discussion subject:</strong> {discussion_subject}<br /><strong>Comment:</strong> {discussion_comment}<br /><br />You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(37,'project','staff-added-as-project-member','english','Staff Added as Project Member','New project assigned to you','<p>Hi {staff_firstname}<br /><br />New project has been assigned to you.<br /><br />You can view the project on the following link <a href=\"{project_link}\">{project_name}</a><br /><br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(38,'estimate','estimate-expiry-reminder','english','Estimate Expiration Reminder','Estimate Expiration Reminder','<p><span style=\"font-size: 12pt;\">Hello {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">The estimate with <strong># {estimate_number}</strong> will expire on <strong>{estimate_expirydate}</strong></span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(39,'proposals','proposal-expiry-reminder','english','Proposal Expiration Reminder','Proposal Expiration Reminder','<p>Hello {proposal_proposal_to}<br /><br />The proposal {proposal_number}&nbsp;will expire on <strong>{proposal_open_till}</strong><br /><br />You can view the proposal on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(40,'staff','new-staff-created','english','New Staff Created (Welcome Email)','You are added as staff member','Hi {staff_firstname}<br /><br />You are added as member on our CRM.<br /><br />Please use the following logic credentials:<br /><br /><strong>Email:</strong> {staff_email}<br /><strong>Password:</strong> {password}<br /><br />Click <a href=\"{admin_url}\">here </a>to login in the dashboard.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(41,'client','contact-forgot-password','english','Forgot Password','Create New Password','<h2>Create a new password</h2>\r\nForgot 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','',0,1,0),(42,'client','contact-password-reseted','english','Password Reset - Confirmation','Your password has been changed','<strong><span style=\"font-size: 14pt;\">You have changed your password.</span><br /></strong><br /> Please, keep it in your records so you don\'t forget it.<br /> <br /> Your email address for login is: {contact_email}<br /><br />If this wasnt you, please contact us.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(43,'client','contact-set-password','english','Set New Password','Set new password on {companyname} ','<h2><span style=\"font-size: 14pt;\">Setup your new password on {companyname}</span></h2>\r\nPlease use the following link to set up your new password:<br /><br /><a href=\"{set_password_url}\">Set new password</a><br /><br />Keep it in your records so you don\'t forget it.<br /><br />Please set your new password in <strong>48 hours</strong>. After that, you won\'t be able to set your password because this link will expire.<br /><br />You can login at: <a href=\"{crm_url}\">{crm_url}</a><br />Your email address for login: {contact_email}<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(44,'staff','staff-forgot-password','english','Forgot Password','Create New Password','<h2><span style=\"font-size: 14pt;\">Create a new password</span></h2>\r\nForgot 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 <strong>{companyname}</strong>&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','',0,1,0),(45,'staff','staff-password-reseted','english','Password Reset - Confirmation','Your password has been changed','<span style=\"font-size: 14pt;\"><strong>You have changed your password.<br /></strong></span><br /> Please, keep it in your records so you don\'t forget it.<br /> <br /> Your email address for login is: {staff_email}<br /><br /> If this wasnt you, please contact us.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(46,'project','assigned-to-project','english','New Project Created (Sent to Customer Contacts)','New Project Created','<p>Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}</p>\r\n<p>New project is assigned to your company.<br /><br /><strong>Project Name:</strong>&nbsp;{project_name}<br /><strong>Project Start Date:</strong>&nbsp;{project_start_date}</p>\r\n<p>You can view the project on the following link:&nbsp;<a href=\"{project_link}\">{project_name}</a></p>\r\n<p>We are looking forward hearing from you.<br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(47,'tasks','task-added-attachment-to-contacts','english','New Attachment(s) on Task (Sent to Customer Contacts)','New Attachment on Task - {task_name}','<span>Hi {contact_firstname} {contact_lastname}</span><br /><br /><strong>{task_user_take_action}</strong><span> added an attachment on the following task:</span><br /><br /><strong>Name:</strong><span> {task_name}</span><br /><br /><span>You can view the task on the following link: </span><a href=\"{task_link}\">{task_name}</a><br /><br /><span>Kind Regards,</span><br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(48,'tasks','task-commented-to-contacts','english','New Comment on Task (Sent to Customer Contacts)','New Comment on Task - {task_name}','<span>Dear {contact_firstname} {contact_lastname}</span><br /><br /><span>A comment has been made on the following task:</span><br /><br /><strong>Name:</strong><span> {task_name}</span><br /><strong>Comment:</strong><span> {task_comment}</span><br /><br /><span>You can view the task on the following link: </span><a href=\"{task_link}\">{task_name}</a><br /><br /><span>Kind Regards,</span><br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(49,'leads','new-lead-assigned','english','New Lead Assigned to Staff Member','New lead assigned to you','<p>Hello {lead_assigned}<br /><br />New lead is assigned to you.<br /><br /><strong>Lead Name:</strong>&nbsp;{lead_name}<br /><strong>Lead Email:</strong>&nbsp;{lead_email}<br /><br />You can view the lead on the following link: <a href=\"{lead_link}\">{lead_name}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(50,'client','client-statement','english','Statement - Account Summary','Account Statement from {statement_from} to {statement_to}','Dear {contact_firstname} {contact_lastname}, <br /><br />Its been a great experience working with you.<br /><br />Attached with this email is a list of all transactions for the period between {statement_from} to {statement_to}<br /><br />For your information your account balance due is total:&nbsp;{statement_balance_due}<br /><br />Please contact us if you need more information.<br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(51,'ticket','ticket-assigned-to-admin','english','New Ticket Assigned (Sent to Staff)','New support ticket has been assigned to you','<p><span style=\"font-size: 12pt;\">Hi</span></p>\r\n<p><span style=\"font-size: 12pt;\">A new support ticket&nbsp;has been assigned to you.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject</strong>: {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority</strong>: {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(52,'client','new-client-registered-to-admin','english','New Customer Registration (Sent to admins)','New Customer Registration','Hello.<br /><br />New customer registration on your customer portal:<br /><br /><strong>Firstname:</strong>&nbsp;{contact_firstname}<br /><strong>Lastname:</strong>&nbsp;{contact_lastname}<br /><strong>Company:</strong>&nbsp;{client_company}<br /><strong>Email:</strong>&nbsp;{contact_email}<br /><br />Best Regards','{companyname} | CRM','',0,1,0),(53,'leads','new-web-to-lead-form-submitted','english','Web to lead form submitted - Sent to lead','{lead_name} - We Received Your Request','Hello {lead_name}.<br /><br /><strong>Your request has been received.</strong><br /><br />This email is to let you know that we received your request and we will get back to you as soon as possible with more information.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,0,0),(54,'staff','two-factor-authentication','english','Two Factor Authentication','Confirm Your Login','<p>Hi {staff_firstname}</p>\r\n<p style=\"text-align: left;\">You received this email because you have enabled two factor authentication in your account.<br />Use the following code to confirm your login:</p>\r\n<p style=\"text-align: left;\"><span style=\"font-size: 18pt;\"><strong>{two_factor_auth_code}<br /><br /></strong><span style=\"font-size: 12pt;\">{email_signature}</span><strong><br /><br /><br /><br /></strong></span></p>','{companyname} | CRM','',0,1,0),(55,'project','project-finished-to-customer','english','Project Marked as Finished (Sent to Customer Contacts)','Project Marked as Finished','<p>Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}</p>\r\n<p>You are receiving this email because project&nbsp;<strong>{project_name}</strong> has been marked as finished. This project is assigned under your company and we just wanted to keep you up to date.<br /><br />You can view the project on the following link:&nbsp;<a href=\"{project_link}\">{project_name}</a></p>\r\n<p>If you have any questions don\'t hesitate to contact us.<br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(56,'credit_note','credit-note-send-to-client','english','Send Credit Note To Email','Credit Note With Number #{credit_note_number} Created','Dear&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />We have attached the credit note with number <strong>#{credit_note_number} </strong>for your reference.<br /><br /><strong>Date:</strong>&nbsp;{credit_note_date}<br /><strong>Total Amount:</strong>&nbsp;{credit_note_total}<br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(57,'tasks','task-status-change-to-staff','english','Task Status Changed (Sent to Staff)','Task Status Changed','<span style=\"font-size: 12pt;\">Hi {staff_firstname}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>{task_user_take_action}</strong> marked task as <strong>{task_status}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}</span><br /><span style=\"font-size: 12pt;\"><strong>Due date:</strong> {task_duedate}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(58,'tasks','task-status-change-to-contacts','english','Task Status Changed (Sent to Customer Contacts)','Task Status Changed','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>{task_user_take_action}</strong> marked task as <strong>{task_status}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}</span><br /><span style=\"font-size: 12pt;\"><strong>Due date:</strong> {task_duedate}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(59,'staff','reminder-email-staff','english','Staff Reminder Email','You Have a New Reminder!','<p>Hello&nbsp;{staff_firstname}<br /><br /><strong>You have a new reminder&nbsp;linked to&nbsp;{staff_reminder_relation_name}!<br /><br />Reminder description:</strong><br />{staff_reminder_description}<br /><br />Click <a href=\"{staff_reminder_relation_link}\">here</a> to view&nbsp;<a href=\"{staff_reminder_relation_link}\">{staff_reminder_relation_name}</a><br /><br />Best Regards<br /><br /></p>','{companyname} | CRM','',0,1,0),(60,'contract','contract-comment-to-client','english','New Comment  (Sent to Customer Contacts)','New Contract Comment','Dear {contact_firstname} {contact_lastname}<br /> <br />A new comment has been made on the following contract: <strong>{contract_subject}</strong><br /> <br />You can view and reply to the comment on the following link: <a href=\"{contract_link}\">{contract_subject}</a><br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(61,'contract','contract-comment-to-admin','english','New Comment (Sent to Staff) ','New Contract Comment','Hi {staff_firstname}<br /><br />A new comment has been made to the contract&nbsp;<strong>{contract_subject}</strong><br /><br />You can view and reply to the comment on the following link: <a href=\"{contract_link}\">{contract_subject}</a>&nbsp;or from the admin area.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(62,'subscriptions','send-subscription','english','Send Subscription to Customer','Subscription Created','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />We have prepared the subscription&nbsp;<strong>{subscription_name}</strong> for your company.<br /><br />Click <a href=\"{subscription_link}\">here</a> to review the subscription and subscribe.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(63,'subscriptions','subscription-payment-failed','english','Subscription Payment Failed','Your most recent invoice payment failed','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br br=\"\" />Unfortunately, your most recent invoice payment for&nbsp;<strong>{subscription_name}</strong> was declined.<br /><br />This could be due to a change in your card number, your card expiring,<br />cancellation of your credit card, or the card issuer not recognizing the<br />payment and therefore taking action to prevent it.<br /><br />Please update your payment information as soon as possible by logging in here:<br /><a href=\"{crm_url}/login\">{crm_url}/login</a><br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(64,'subscriptions','subscription-canceled','english','Subscription Canceled (Sent to customer primary contact)','Your subscription has been canceled','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />Your subscription&nbsp;<strong>{subscription_name} </strong>has been canceled, if you have any questions don\'t hesitate to contact us.<br /><br />It was a pleasure doing business with you.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(65,'subscriptions','subscription-payment-succeeded','english','Subscription Payment Succeeded (Sent to customer primary contact)','Subscription  Payment Receipt - {subscription_name}','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />This email is to let you know that we received your payment for subscription&nbsp;<strong>{subscription_name}&nbsp;</strong>of&nbsp;<strong><span>{payment_total}<br /><br /></span></strong>The invoice associated with it is now with status&nbsp;<strong>{invoice_status}<br /></strong><br />Thank you for your confidence.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(66,'contract','contract-expiration-to-staff','english','Contract Expiration Reminder (Sent to Staff)','Contract Expiration Reminder','Hi {staff_firstname}<br /><br /><span style=\"font-size: 12pt;\">This is a reminder that the following contract will expire soon:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {contract_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Description:</strong> {contract_description}</span><br /><span style=\"font-size: 12pt;\"><strong>Date Start:</strong> {contract_datestart}</span><br /><span style=\"font-size: 12pt;\"><strong>Date End:</strong> {contract_dateend}</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(67,'gdpr','gdpr-removal-request','english','Removal Request From Contact (Sent to administrators)','Data Removal Request Received','Hello&nbsp;{staff_firstname}&nbsp;{staff_lastname}<br /><br />Data removal has been requested by&nbsp;{contact_firstname} {contact_lastname}<br /><br />You can review this request and take proper actions directly from the admin area.','{companyname} | CRM','',0,1,0),(68,'gdpr','gdpr-removal-request-lead','english','Removal Request From Lead (Sent to administrators)','Data Removal Request Received','Hello&nbsp;{staff_firstname}&nbsp;{staff_lastname}<br /><br />Data removal has been requested by {lead_name}<br /><br />You can review this request and take proper actions directly from the admin area.<br /><br />To view the lead inside the admin area click here:&nbsp;<a href=\"{lead_link}\">{lead_link}</a>','{companyname} | CRM','',0,1,0),(69,'client','client-registration-confirmed','english','Customer Registration Confirmed','Your registration is confirmed','<p>Dear {contact_firstname} {contact_lastname}<br /><br />We just wanted to let you know that your registration at&nbsp;{companyname} is successfully confirmed and your account is now active.<br /><br />You can login at&nbsp;<a href=\"{crm_url}\">{crm_url}</a> with the email and password you provided during registration.<br /><br />Please contact us if you need any help.<br /><br />Kind Regards, <br />{email_signature}</p>\r\n<p><br />(This is an automated email, so please don\'t reply to this email address)</p>','{companyname} | CRM','',0,1,0),(70,'contract','contract-signed-to-staff','english','Contract Signed (Sent to Staff)','Customer Signed a Contract','Hi {staff_firstname}<br /><br />A contract with subject&nbsp;<strong>{contract_subject} </strong>has been successfully signed by the customer.<br /><br />You can view the contract at the following link: <a href=\"{contract_link}\">{contract_subject}</a>&nbsp;or from the admin area.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(71,'subscriptions','customer-subscribed-to-staff','english','Customer Subscribed to a Subscription (Sent to administrators and subscription creator)','Customer Subscribed to a Subscription','The customer <strong>{client_company}</strong> subscribed to a subscription with name&nbsp;<strong>{subscription_name}</strong><br /><br /><strong>ID</strong>:&nbsp;{subscription_id}<br /><strong>Subscription name</strong>:&nbsp;{subscription_name}<br /><strong>Subscription description</strong>:&nbsp;{subscription_description}<br /><br />You can view the subscription by clicking <a href=\"{subscription_link}\">here</a><br />\r\n<div style=\"text-align: center;\"><span style=\"font-size: 10pt;\">&nbsp;</span></div>\r\nBest Regards,<br />{email_signature}<br /><br /><span style=\"font-size: 10pt;\"><span style=\"color: #999999;\">You are receiving this email because you are either administrator or you are creator of the subscription.</span></span>','{companyname} | CRM','',0,1,0),(72,'client','contact-verification-email','english','Email Verification (Sent to Contact After Registration)','Verify Email Address','<p>Hello&nbsp;{contact_firstname}<br /><br />Please click the button below to verify your email address.<br /><br /><a href=\"{email_verification_url}\">Verify Email Address</a><br /><br />If you did not create an account, no further action is required</p>\r\n<p><br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(73,'client','new-customer-profile-file-uploaded-to-staff','english','New Customer Profile File(s) Uploaded (Sent to Staff)','Customer Uploaded New File(s) in Profile','Hi!<br /><br />New file(s) is uploaded into the customer ({client_company}) profile by&nbsp;{contact_firstname}<br /><br />You can check the uploaded files into the admin area by clicking <a href=\"{customer_profile_files_admin_link}\">here</a> or at the following link:&nbsp;{customer_profile_files_admin_link}<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(74,'staff','event-notification-to-staff','english','Event Notification (Calendar)','Upcoming Event - {event_title}','Hi {staff_firstname}! <br /><br />This is a reminder for event <a href=\\\"{event_link}\\\">{event_title}</a> scheduled at {event_start_date}. <br /><br />Regards.','','',0,1,0),(75,'subscriptions','subscription-payment-requires-action','english','Credit Card Authorization Required - SCA','Important: Confirm your subscription {subscription_name} payment','<p>Hello {contact_firstname}</p>\r\n<p><strong>Your bank sometimes requires an additional step to make sure an online transaction was authorized.</strong><br /><br />Because of European regulation to protect consumers, many online payments now require two-factor authentication. Your bank ultimately decides when authentication is required to confirm a payment, but you may notice this step when you start paying for a service or when the cost changes.<br /><br />In order to pay the subscription <strong>{subscription_name}</strong>, you will need to&nbsp;confirm your payment by clicking on the follow link: <strong><a href=\"{subscription_authorize_payment_link}\">{subscription_authorize_payment_link}</a></strong><br /><br />To view the subscription, please click at the following link: <a href=\"{subscription_link}\"><span>{subscription_link}</span></a><br />or you can login in our dedicated area here: <a href=\"{crm_url}/login\">{crm_url}/login</a> in case you want to update your credit card or view the subscriptions you are subscribed.<br /><br />Best Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(76,'invoice','invoice-due-notice','english','Invoice Due Notice','Your {invoice_number} will be due soon','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}<br /><br /></span>You invoice <span style=\"font-size: 12pt;\"><strong># {invoice_number} </strong>will be due on <strong>{invoice_duedate}</strong></span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(77,'estimate_request','estimate-request-submitted-to-staff','english','Estimate Request Submitted (Sent to Staff)','New Estimate Request Submitted','<span> Hello,&nbsp;</span><br /><br />{estimate_request_email} submitted an estimate request via the {estimate_request_form_name} form.<br /><br />You can view the request at the following link: <a href=\"{estimate_request_link}\">{estimate_request_link}</a><br /><br />==<br /><br />{estimate_request_submitted_data}<br /><br />Kind Regards,<br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(78,'estimate_request','estimate-request-assigned','english','Estimate Request Assigned (Sent to Staff)','New Estimate Request Assigned','<span> Hello {estimate_request_assigned},&nbsp;</span><br /><br />Estimate request #{estimate_request_id} has been assigned to you.<br /><br />You can view the request at the following link: <a href=\"{estimate_request_link}\">{estimate_request_link}</a><br /><br />Kind Regards,<br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(79,'estimate_request','estimate-request-received-to-user','english','Estimate Request Received (Sent to User)','Estimate Request Received','Hello,<br /><br /><strong>Your request has been received.</strong><br /><br />This email is to let you know that we received your request and we will get back to you as soon as possible with more information.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,0,0),(80,'notifications','non-billed-tasks-reminder','english','Non-billed tasks reminder (sent to selected staff members)','Action required: Completed tasks are not billed','Hello {staff_firstname}<br><br>The following tasks are marked as complete but not yet billed:<br><br>{unbilled_tasks_list}<br><br>Kind Regards,<br><br>{email_signature}','{companyname} | CRM','',0,1,0),(81,'invoice','invoices-batch-payments','english','Invoices Payments Recorded in Batch (Sent to Customer)','We have received your payments','Hello {contact_firstname} {contact_lastname}<br><br>Thank you for the payments. Please find the payments details below:<br><br>{batch_payments_list}<br><br>We are looking forward working with you.<br><br>Kind Regards,<br><br>{email_signature}','{companyname} | CRM','',0,1,0),(82,'contract','contract-sign-reminder','english','Contract Sign Reminder (Sent to Customer)','Contract Sign Reminder','<p>Hello {contact_firstname} {contact_lastname}<br /><br />This is a reminder to review and sign the contract:<a href=\"{contract_link}\">{contract_subject}</a></p><p>You can view and sign by visiting: <a href=\"{contract_link}\">{contract_subject}</a></p><p><br />We are looking forward working with you.<br /><br />Kind Regards,<br /><br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(83,'client','affiliate_management_payout_updated','english','Affiliate Payout Request Update','An update regarding your payout request','Dear {contact_firstname},<br/><br/>\n    We hope this message finds you well.\n    <br/>\n    We wanted to inform you about the latest status of your payout request, identified by reference number <b>#{payout_id}</b>. \n    <br/><br/>\n    Amount: {payout_amount}<br/>\n    Status: {payout_status}<br/>\n    Note: {payout_note_for_affiliate}<br/>\n    Created: {payout_created_at}<br/>\n    <br/><br/>\n    If you have any questions or need further clarification, please do not hesitate to reach out. We are here to assist you in any way possible.<br/><br/>\n    \n    Best regards,<br/>\n    {email_signature}','{companyname} | CRM',NULL,0,1,0),(84,'client','affiliate_management_signup_through_affiliate_link','english','Successful Signup through Affiliate Link','Congratulations on a successful signup!','Dear {contact_firstname},<br/><br/>\n    We are delighted to inform you that someone has successfully signed up using your affiliate link.\n    <br/><br/>\n    Company/Contact: {referral_name}<br/>\n    Date: {referral_created_at}<br/>\n    <br/><br/>\n    While this signup may not have resulted in an immediate transaction, your efforts are highly valued. We appreciate your contribution to our community and anticipate further success in the future.\n    <br/><br/>\n    If you have any questions or need additional information, please feel free to reach out.\n    <br/><br/>\n    Best regards,<br/>\n    {email_signature}','{companyname} | CRM',NULL,0,1,0),(85,'client','affiliate_management_successful_referral_commission','english','Successful Referral Commission Notification','A referral commission received!','Dear {contact_firstname},<br/><br/>\n    We are thrilled to inform you that your referral has resulted in a successful transaction, earning you a commission.\n    <br/><br/>\n    Company/Contact: {referral_name}<br/>\n    Transaction Amount: {payment_amount}<br/>\n    Commission Earned: {commission_amount}<br/>\n    New Balance: {affiliate_balance}<br/>\n    Date: {commission_created_at}<br/>\n    <br/><br/>\n    We appreciate your efforts and look forward to more successful collaborations. Should you have any questions or require further information, feel free to reach out.\n    <br/><br/>\n    Best regards,<br/>\n    {email_signature}','{companyname} | CRM',NULL,0,1,0),(86,'staff','affiliate_management_new_payout_request_for_admin','english','Affiliate Payout Request','You have new affiliate payout request','Dear Admin,<br/><br/>\n    I wanted to inform you about a new payout request, identified by reference number <b>#{payout_id}</b>. \n    <br/><br/>\n    Affiliate: {affiliate_name}<br/>\n    Amount: {payout_amount}<br/>\n    Status: {payout_status}<br/>\n    Note: {payout_note_for_admin}<br/>\n    Created: {payout_created_at}<br/>\n    <br/><br/>    \n    Best regards,<br/>\n    {email_signature}','{companyname} | CRM',NULL,0,1,0),(87,'staff','affiliate_management_payout_updated_for_admin','english','Affiliate Payout Request Updated','You marked payout: #{payout_id} as {payout_status}','Dear Admin,<br/><br/>\n    I wanted to update you about the recent update to a payout request, identified by reference number <b>#{payout_id}</b>. \n    <br/><br/>\n    Affiliate: {affiliate_name}<br/>\n    Amount: {payout_amount}<br/>\n    Status: {payout_status}<br/><br/>\n    Admin Note: {payout_note_for_admin}<br/>\n    Note: {payout_note_for_affiliate}<br/>\n    Created: {payout_created_at}<br/>\n    <br/><br/>    \n    Best regards,<br/>\n    {email_signature}','{companyname} | CRM',NULL,0,1,0),(88,'staff','affiliate_management_new_affiliate_signup_for_admin','english','New Affiliate Signup','A new affiliate signup','Dear Admin,<br/><br/>\n    I wanted to inform you about a new affiliate signup, identified by reference number <b>#{affiliate_slug}</b>. \n    <br/><br/>\n    Affiliate: {affiliate_name}<br/>\n    Status: {affiliate_status}<br/>\n    Created: {affiliate_created_at}<br/>\n    <br/><br/>    \n    Best regards,<br/>\n    {email_signature}','{companyname} | CRM',NULL,0,1,0),(89,'client','affiliate_management_referral_commission_reversal','english','Referral Commission Reversal Notification','A referral commission was reversed!','Dear {contact_firstname},<br/><br/>\n    We regret to inform you that the commission previously awarded for your referral has been reversed due to reversal or removal of the rewarded payment.\n    <br/><br/>\n    Company/Contact: {referral_name}<br/>\n    Comission ID: {commission_id}<br/>\n    Amount Reversed: {commission_amount}<br/>\n    New Balance: {affiliate_balance}<br/>\n    Date of commission: {commission_created_at}<br/>\n    <br/><br/>\n    We appreciate your efforts and look forward to more successful collaborations. Should you have any questions or require further information, feel free to reach out.\n    <br/><br/>\n    Best regards,<br/>\n    {email_signature}','{companyname} | CRM',NULL,0,1,0),(90,'file_sharing','fs-share-staff','english','Shared to staff','File Sharing','<span></span><br /><br /><span>Have files that have just been shared with you: {share_link}.</span>','{companyname} | CRM',NULL,0,1,0),(91,'file_sharing','fs-share-client','english','Shared to client','File Sharing','<span></span><br /><br /><span>Have files that have just been shared with you: {share_link}.</span>','{companyname} | CRM',NULL,0,1,0),(92,'file_sharing','fs-share-public','english','Shared to public','File Sharing','<span></span><br /><br /><span>Have files that have just been shared with you: {share_link}.</span>','{companyname} | CRM',NULL,0,1,0),(93,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(94,'inventory_warning','inventory-warning-to-staff','english','Inventory warning (Sent to staff)','Inventory warning','Hi {staff_name}! <br /><br />This is a inventory warning<br />{<span 12pt=\"\">notification_content</span>}. <br /><br />Regards.','{companyname} | CRM',NULL,0,1,0),(95,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(96,'purchase_order','purchase-order-to-contact','english','Purchase Order (Sent to contact)','Purchase Order','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Order information with the number {po_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {public_link}\r\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(97,'purchase_order','purchase-request-to-contact','english','Purchase Request (Sent to contact)','Purchase Request','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Request information with the number {pr_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {public_link}<br/ >{additional_content}\r\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(98,'purchase_order','purchase-quotation-to-contact','english','Purchase Quotation (Sent to contact)','Purchase Quotation','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Quotation information with the number {pq_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {quotation_link}<br/ >{additional_content}\r\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(99,'purchase_order','debit-note-to-contact','english','Debit Note (Sent to contact)','Debit Note','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Debit Note information with the number {dn_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />{additional_content}\r\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(100,'purchase_order','purchase-statement-to-contact','english','Purchase Statement (Sent to contact)','Purchase Statement','<span style=\\\"font-size: 12pt;\\\"> Dear {contact_firstname} {contact_lastname} !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">Its been a great experience working with you. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Attached with this email is a list of all transactions for the period between {statement_from} to {statement_to}<br/ ><br/ >For your information your account balance due is total: {statement_balance_due}<br /><br/ > Please contact us if you need more information.<br/ > <br />{additional_content}\r\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(101,'purchase_order','vendor-registration-confirmed','english','Vendor Registration Confirmed','Your registration is confirmed','<p>Dear {contact_firstname} {contact_lastname}<br /><br />We just wanted to let you know that your registration at&nbsp;{companyname} is successfully confirmed and your account is now active.<br /><br />You can login at&nbsp;<a href=\"{vendor_portal_url}\">{vendor_portal_url}</a> with the email and password you provided during registration.<br /><br />Please contact us if you need any help.<br /><br />Kind Regards, <br />{email_signature}</p>\r\n <p><br />(This is an automated email, so please dont reply to this email address)</p>','{companyname} | CRM',NULL,0,1,0),(102,'purchase_order','purchase-contract-to-contact','english','Purchase Contract (Sent to contact)','Purchase Contract','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Contract information with the number {contract_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {contract_link}\r\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(103,'purchase_order','new-contact-created','english','New Contact Added/Registered (Welcome Email)','New Contact Added/Registered (Welcome Email)','<span style=\\\"font-size: 12pt;\\\"> Dear {contact_firstname} {contact_lastname}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> Welcome to our system </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Click here to login: {vendor_portal_link}</span><br /></span><br />','{companyname} | CRM',NULL,0,1,0),(104,'purchase_order','purchase-request-approval','english','Request approval','Request approval','<span style=\\\"font-size: 12pt;\\\"> Hello {staff_name}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> You receive an approval request: {link} from {from_staff_name}</span>','{companyname} | CRM',NULL,0,1,0),(105,'purchase_order','purchase-send-approved','english','Email send approved','Email send approved','<span style=\\\"font-size: 12pt;\\\"> Hello {staff_name}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\">{type} has been approved by {by_staff_name} </span><br /><span style=\\\"font-size: 12pt;\\\"><br />Click here to view detail: {link} </span><br /></span><br />','{companyname} | CRM',NULL,0,1,0),(106,'purchase_order','purchase-send-rejected','english','Email send rejected','Email send rejected','<span style=\\\"font-size: 12pt;\\\"> Hello {staff_name}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> {type} has been declined by {by_staff_name} </span><br /><span style=\\\"font-size: 12pt;\\\"><br />Click here to view detail: {link}  </span><br /></span><br />','{companyname} | CRM',NULL,0,1,0),(107,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(108,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(109,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(110,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(111,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(112,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(113,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(114,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(115,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(116,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(117,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(118,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(119,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(120,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(121,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(122,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(123,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(124,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(125,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(126,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(127,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(128,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(129,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(130,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(131,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(132,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(133,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(134,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(135,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(136,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(137,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(138,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(139,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(140,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(141,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(142,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(143,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(144,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(145,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(146,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(147,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(148,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(149,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(150,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(151,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(152,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(153,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(154,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(155,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(156,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(157,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(158,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(159,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(160,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(161,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(162,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(163,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(164,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(165,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(166,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(167,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(168,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(169,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(170,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(171,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(172,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(173,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(174,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(175,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(176,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(177,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(178,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(179,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(180,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(181,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(182,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(183,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(184,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(185,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(186,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(187,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(188,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(189,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(190,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(191,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(192,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(193,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(194,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(195,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(196,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(197,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(198,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(199,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(200,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(201,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(202,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(203,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(204,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(205,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(206,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(207,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(208,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(209,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(210,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(211,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(212,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(213,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(214,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(215,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(216,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(217,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(218,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(219,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(220,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(221,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(222,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(223,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(224,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(225,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(226,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(227,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(228,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(229,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(230,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(231,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(232,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(233,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(234,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(235,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(236,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(237,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(238,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(239,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(240,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(241,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(242,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(243,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(244,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(245,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(246,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(247,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(248,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(249,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(250,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(251,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(252,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(253,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(254,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(255,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(256,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(257,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(258,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(259,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(260,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(261,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(262,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(263,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(264,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(265,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(266,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(267,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(268,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(269,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(270,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(271,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(272,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(273,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(274,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(275,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(276,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(277,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(278,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(279,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(280,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(281,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(282,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(283,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(284,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(285,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(286,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(287,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(288,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(289,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(290,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(291,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(292,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(293,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(294,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(295,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(296,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(297,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(298,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(299,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(300,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(301,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(302,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(303,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(304,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(305,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(306,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(307,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(308,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(309,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(310,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(311,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(312,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(313,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(314,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(315,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(316,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(317,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(318,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(319,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(320,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(321,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(322,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(323,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(324,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(325,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(326,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(327,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(328,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(329,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(330,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(331,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(332,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(333,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(334,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(335,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(336,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(337,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(338,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(339,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(340,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(341,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(342,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(343,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(344,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(345,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(346,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(347,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(348,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(349,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(350,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(351,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(352,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(353,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(354,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(355,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(356,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(357,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(358,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(359,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(360,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(361,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(362,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(363,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(364,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(365,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(366,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(367,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(368,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(369,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(370,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(371,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(372,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(373,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(374,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(375,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(376,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(377,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(378,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(379,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(380,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(381,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(382,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(383,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(384,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(385,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(386,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(387,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(388,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(389,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(390,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(391,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(392,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(393,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(394,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(395,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(396,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(397,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(398,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(399,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(400,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(401,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(402,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(403,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(404,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(405,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(406,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(407,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(408,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(409,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(410,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(411,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(412,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(413,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(414,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(415,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(416,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(417,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(418,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(419,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(420,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(421,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(422,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(423,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(424,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(425,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(426,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(427,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(428,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(429,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(430,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(431,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(432,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(433,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(434,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(435,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(436,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(437,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(438,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(439,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(440,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(441,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(442,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0),(443,'notifications','fund-request-updated','english','Fund Request Updated (sent staff member)','Fund Request Status Updated','<p>Hello {staff_name},<br><br>We wanted to inform you that your Fund Request {fund_request_number} has been updated. New Status: {status}.<br><br>Login to see more details.</p>\r\n     <p>Kind Regards,<br><br></p>','{companyname} | CRM',NULL,0,1,0);

--
