--
-- Host: localhost    Database: admin_820demo
-- ------------------------------------------------------


--
-- Table structure for table `com_vtiger_workflow_activatedonce`
--

CREATE TABLE `com_vtiger_workflow_activatedonce` (
  `workflow_id` int(11) NOT NULL,
  `entity_id` int(11) NOT NULL,
  PRIMARY KEY (`workflow_id`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflow_activatedonce`
--


--
-- Table structure for table `com_vtiger_workflow_tasktypes`
--

CREATE TABLE `com_vtiger_workflow_tasktypes` (
  `id` int(11) NOT NULL,
  `tasktypename` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `classname` varchar(255) DEFAULT NULL,
  `classpath` varchar(255) DEFAULT NULL,
  `templatepath` varchar(255) DEFAULT NULL,
  `modules` varchar(500) DEFAULT NULL,
  `sourcemodule` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflow_tasktypes`
--

INSERT INTO `com_vtiger_workflow_tasktypes` VALUES (1,'VTEmailTask','Send Mail','VTEmailTask','modules/com_vtiger_workflow/tasks/VTEmailTask.inc','modules/Settings/Workflows/Tasks/VTEmailTask.tpl','{\"include\":[],\"exclude\":[]}',''),(2,'VTEntityMethodTask','Invoke Custom Function','VTEntityMethodTask','modules/com_vtiger_workflow/tasks/VTEntityMethodTask.inc','modules/Settings/Workflows/Tasks/VTEntityMethodTask.tpl','{\"include\":[],\"exclude\":[]}',''),(3,'VTCreateTodoTask','Create Todo','VTCreateTodoTask','modules/com_vtiger_workflow/tasks/VTCreateTodoTask.inc','modules/Settings/Workflows/Tasks/VTCreateTodoTask.tpl','{\"include\":[\"Leads\",\"Accounts\",\"Potentials\",\"Contacts\",\"HelpDesk\",\"Campaigns\",\"Quotes\",\"PurchaseOrder\",\"SalesOrder\",\"Invoice\",\"Project\"],\"exclude\":[\"Calendar\",\"FAQ\",\"Events\"]}',''),(4,'VTCreateEventTask','Create Event','VTCreateEventTask','modules/com_vtiger_workflow/tasks/VTCreateEventTask.inc','modules/Settings/Workflows/Tasks/VTCreateEventTask.tpl','{\"include\":[\"Leads\",\"Accounts\",\"Potentials\",\"Contacts\",\"HelpDesk\",\"Campaigns\",\"Project\"],\"exclude\":[\"Calendar\",\"FAQ\",\"Events\"]}',''),(5,'VTUpdateFieldsTask','Update Fields','VTUpdateFieldsTask','modules/com_vtiger_workflow/tasks/VTUpdateFieldsTask.inc','modules/Settings/Workflows/Tasks/VTUpdateFieldsTask.tpl','{\"include\":[],\"exclude\":[]}',''),(6,'VTCreateEntityTask','Create Entity','VTCreateEntityTask','modules/com_vtiger_workflow/tasks/VTCreateEntityTask.inc','modules/Settings/Workflows/Tasks/VTCreateEntityTask.tpl','{\"include\":[],\"exclude\":[]}',''),(7,'VTSMSTask','SMS Task','VTSMSTask','modules/com_vtiger_workflow/tasks/VTSMSTask.inc','modules/Settings/Workflows/Tasks/VTSMSTask.tpl','{\"include\":[],\"exclude\":[]}','SMSNotifier'),(8,'VTPushNotification','CRMTiger Mobile - Push Notification','VTPushNotification','modules/com_vtiger_workflow/tasks/VTPushNotification.inc','modules/Settings/Workflows/Tasks/VTPushNotification.tpl','{\"include\":[],\"exclude\":[]}','CTPushNotification'),(9,'SendWhatsAppMsg','Send Message on WhatsApp','SendWhatsAppMsg','modules/CTWhatsApp/workflow/SendWhatsAppMsg.inc','modules/CTWhatsApp/taskforms/SendWhatsAppMsg.tpl','{\"include\":[],\"exclude\":[]}','CTWhatsApp');

--
-- Table structure for table `com_vtiger_workflow_tasktypes_seq`
--

CREATE TABLE `com_vtiger_workflow_tasktypes_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflow_tasktypes_seq`
--

INSERT INTO `com_vtiger_workflow_tasktypes_seq` VALUES (9);

--
-- Table structure for table `com_vtiger_workflows`
--

CREATE TABLE `com_vtiger_workflows` (
  `workflow_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(100) DEFAULT NULL,
  `summary` varchar(400) NOT NULL,
  `test` text NOT NULL,
  `execution_condition` int(11) NOT NULL,
  `defaultworkflow` int(1) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `filtersavedinnew` int(1) DEFAULT NULL,
  `schtypeid` int(10) DEFAULT NULL,
  `schdayofmonth` varchar(100) DEFAULT NULL,
  `schdayofweek` varchar(100) DEFAULT NULL,
  `schannualdates` varchar(500) DEFAULT NULL,
  `schtime` varchar(50) DEFAULT NULL,
  `nexttrigger_time` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `workflowname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`workflow_id`),
  UNIQUE KEY `com_vtiger_workflows_idx` (`workflow_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflows`
--

INSERT INTO `com_vtiger_workflows` VALUES (1,'Invoice','UpdateInventoryProducts On Every Save','[{\"fieldname\":\"subject\",\"operation\":\"does not contain\",\"value\":\"`!`\"}]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'UpdateInventoryProducts On Every Save'),(2,'Accounts','Send Email to user when Notifyowner is True','[{\"fieldname\":\"notify_owner\",\"operation\":\"is\",\"value\":\"true:boolean\"}]',2,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to user when Notifyowner is True'),(3,'Contacts','Send Email to user when Notifyowner is True','[{\"fieldname\":\"notify_owner\",\"operation\":\"is\",\"value\":\"true:boolean\"}]',2,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to user when Notifyowner is True'),(4,'Contacts','Send Email to user when Portal User is True','[{\"fieldname\":\"portal\",\"operation\":\"is\",\"value\":\"1\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"email\",\"operation\":\"is not empty\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to user when Portal User is True'),(5,'Potentials','Send Email to users on Potential creation','[]',1,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to users on Potential creation'),(6,'Contacts','Workflow for Contact Creation or Modification','[]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Workflow for Contact Creation or Modification'),(7,'HelpDesk','Ticket Creation From Portal : Send Email to Record Owner and Contact','[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":1,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0}]',1,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Ticket Creation From Portal : Send Email to Record Owner and Contact'),(9,'HelpDesk','Send Email to Contact on Ticket Update','[{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":0,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0},{\"fieldname\":\"ticketstatus\",\"operation\":\"has changed to\",\"value\":\"Closed\",\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"solution\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"description\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to Contact on Ticket Update'),(10,'Events','Workflow for Events when Send Notification is True','[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Workflow for Events when Send Notification is True'),(11,'Calendar','Workflow for Calendar Todos when Send Notification is True','[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Workflow for Calendar Todos when Send Notification is True'),(12,'Potentials','Calculate or Update forecast amount','[]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Calculate or Update forecast amount'),(13,'Events','Workflow for Events when Send Notification is True','[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Workflow for Events when Send Notification is True'),(14,'Calendar','Workflow for Calendar Todos when Send Notification is True','[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Workflow for Calendar Todos when Send Notification is True'),(15,'HelpDesk','Comment Added From CRM : Send Email to Organization','[{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"(parent_id : (Accounts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Comment Added From CRM : Send Email to Organization'),(16,'PurchaseOrder','Update Inventory Products On Every Save','[]',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Update Inventory Products On Every Save'),(17,'HelpDesk','Comment Added From Portal : Send Email to Record Owner','[{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"1\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Comment Added From Portal : Send Email to Record Owner'),(18,'HelpDesk','Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User','[{\"fieldname\":\"(contact_id : (Contacts) portal)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User'),(19,'HelpDesk','Comment Added From CRM : Send Email to Contact, where Contact is Portal User','[{\"fieldname\":\"(contact_id : (Contacts) portal)\",\"operation\":\"is\",\"value\":\"1\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Comment Added From CRM : Send Email to Contact, where Contact is Portal User'),(20,'HelpDesk','Send Email to Record Owner on Ticket Update','[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":0,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0},{\"fieldname\":\"ticketstatus\",\"operation\":\"has changed to\",\"value\":\"Closed\",\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"solution\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"assigned_user_id\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"description\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to Record Owner on Ticket Update'),(21,'HelpDesk','Ticket Creation From CRM : Send Email to Record Owner','[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',1,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Ticket Creation From CRM : Send Email to Record Owner'),(22,'HelpDesk','Send Email to Organization on Ticket Update','[{\"fieldname\":\"(parent_id : (Accounts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":0,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0},{\"fieldname\":\"ticketstatus\",\"operation\":\"has changed to\",\"value\":\"Closed\",\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"solution\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"description\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to Organization on Ticket Update'),(23,'HelpDesk','Ticket Creation From CRM : Send Email to Organization','[{\"fieldname\":\"(parent_id : (Accounts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',1,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Ticket Creation From CRM : Send Email to Organization'),(24,'HelpDesk','Ticket Creation From CRM : Send Email to Contact','[{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',1,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Ticket Creation From CRM : Send Email to Contact'),(25,'Leads','create latlong','[]',3,0,'basic',6,0,'0','0','0','0','0000-00-00 00:00:00',1,'CTLatLong for Leads Module'),(26,'Contacts','create latlong','[]',3,0,'basic',6,0,'0','0','0','0','0000-00-00 00:00:00',1,'CTLatLong for Contacts Module'),(27,'Accounts','create latlong','[]',3,0,'basic',6,0,'0','0','0','0','0000-00-00 00:00:00',1,'CTLatLong for Organization Module'),(28,'Calendar','create latlong','[]',3,0,'basic',6,0,'0','0','0','0','0000-00-00 00:00:00',1,'CTLatLong for Calendar Module'),(29,'Events','create latlong','[]',3,0,'basic',6,0,'0','0','0','0','0000-00-00 00:00:00',1,'CTLatLong for Events Module'),(30,'Cobranzas','','[]',3,NULL,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Calcula dias de atraso');

--
-- Table structure for table `com_vtiger_workflows_seq`
--

CREATE TABLE `com_vtiger_workflows_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflows_seq`
--

INSERT INTO `com_vtiger_workflows_seq` VALUES (30);

--
-- Table structure for table `com_vtiger_workflowtask_queue`
--

CREATE TABLE `com_vtiger_workflowtask_queue` (
  `task_id` int(11) DEFAULT NULL,
  `entity_id` varchar(100) DEFAULT NULL,
  `do_after` int(11) DEFAULT NULL,
  `relatedinfo` varchar(255) DEFAULT NULL,
  `task_contents` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtask_queue`
--


--
-- Table structure for table `com_vtiger_workflowtasks`
--

CREATE TABLE `com_vtiger_workflowtasks` (
  `task_id` int(11) NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) DEFAULT NULL,
  `summary` varchar(400) NOT NULL,
  `task` text NOT NULL,
  PRIMARY KEY (`task_id`),
  UNIQUE KEY `com_vtiger_workflowtasks_idx` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks`
--

INSERT INTO `com_vtiger_workflowtasks` VALUES (1,1,'','O:18:\"VTEntityMethodTask\":6:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";i:1;s:7:\"summary\";s:0:\"\";s:6:\"active\";b:1;s:10:\"methodName\";s:15:\"UpdateInventory\";s:2:\"id\";i:1;}'),(2,2,'An account has been created ','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"2\";s:7:\"summary\";s:28:\"An account has been created \";s:6:\"active\";s:1:\"1\";s:10:\"methodName\";s:11:\"NotifyOwner\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:26:\"Regarding Account Creation\";s:7:\"content\";s:301:\"An Account has been assigned to you on vtigerCRM<br>Details of account are :<br><br>AccountId:<b>$account_no</b><br>AccountName:<b>$accountname</b><br>Rating:<b>$rating</b><br>Industry:<b>$industry</b><br>AccountType:<b>$accounttype</b><br>Description:<b>$description</b><br><br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"2\";}'),(3,3,'An contact has been created ','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"3\";s:7:\"summary\";s:28:\"An contact has been created \";s:6:\"active\";s:1:\"1\";s:10:\"methodName\";s:11:\"NotifyOwner\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:26:\"Regarding Contact Creation\";s:7:\"content\";s:305:\"An Contact has been assigned to you on vtigerCRM<br>Details of Contact are :<br><br>Contact Id:<b>$contact_no</b><br>LastName:<b>$lastname</b><br>FirstName:<b>$firstname</b><br>Lead Source:<b>$leadsource</b><br>Department:<b>$department</b><br>Description:<b>$description</b><br><br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"3\";}'),(4,4,'Email Customer Portal Login Details','O:18:\"VTEntityMethodTask\":6:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";i:4;s:7:\"summary\";s:35:\"Email Customer Portal Login Details\";s:6:\"active\";b:1;s:10:\"methodName\";s:22:\"SendPortalLoginDetails\";s:2:\"id\";i:4;}'),(5,5,'An Potential has been created ','O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"5\";s:7:\"summary\";s:30:\"An Potential has been created \";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:30:\"Regarding Potential Assignment\";s:7:\"content\";s:342:\"An Potential has been assigned to you on vtigerCRM<br>Details of Potential are :<br><br>Potential No:<b>$potential_no</b><br>Potential Name:<b>$potentialname</b><br>Amount:<b>$amount</b><br>Expected Close Date:<b>$closingdate ($_DATE_FORMAT_)</b><br>Type:<b>$opportunity_type</b><br><br><br>Description :$description<br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"5\";}'),(6,6,'An contact has been created ','O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"6\";s:7:\"summary\";s:28:\"An contact has been created \";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:28:\"Regarding Contact Assignment\";s:7:\"content\";s:384:\"An Contact has been assigned to you on vtigerCRM<br>Details of Contact are :<br><br>Contact Id:<b>$contact_no</b><br>LastName:<b>$lastname</b><br>FirstName:<b>$firstname</b><br>Lead Source:<b>$leadsource</b><br>Department:<b>$department</b><br>Description:<b>$description</b><br><br><br>And <b>CustomerPortal Login Details</b> is sent to the EmailID :-$email<br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"6\";}'),(7,7,'Notify Related Contact when Ticket is created from Portal','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:57:\"Notify Related Contact when Ticket is created from Portal\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:1:\"7\";s:10:\"workflowId\";s:1:\"7\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:93:\"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:158:\"Ticket No : $ticket_no<br>\n							  Ticket ID : $(general : (__VtigerMeta__) recordId)<br>\n							  Ticket Title : $ticket_title<br><br>\n							  $description\";}'),(10,9,'Send Email to Contact on Ticket Update','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:38:\"Send Email to Contact on Ticket Update\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"10\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:624:\"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";s:10:\"workflowId\";s:1:\"9\";}'),(13,12,'update forecast amount','O:18:\"VTUpdateFieldsTask\":7:{s:18:\"executeImmediately\";b:1;s:43:\"\0VTUpdateFieldsTask\0referenceFieldFocusList\";a:0:{}s:10:\"workflowId\";i:12;s:7:\"summary\";s:22:\"update forecast amount\";s:6:\"active\";b:1;s:19:\"field_value_mapping\";s:96:\"[{\"fieldname\":\"forecast_amount\",\"valuetype\":\"expression\",\"value\":\"amount * probability \\/ 100\"}]\";s:2:\"id\";i:13;}'),(14,13,'Send Notification Email to Record Owner','O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:2:\"13\";s:7:\"summary\";s:39:\"Send Notification Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:17:\"Event :  $subject\";s:7:\"content\";s:771:\"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) ,<br/><b>Activity Notification Details:</b><br/>Subject             : $subject<br/>Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))<br/>End date and time   : $due_date ($(general : (__VtigerMeta__) usertimezone)) <br/>Status              : $eventstatus <br/>Priority            : $taskpriority <br/>Related To          : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname) <br/>Contacts List       : $contact_id <br/>Location            : $location <br/>Description         : $description\";s:2:\"id\";s:2:\"14\";}'),(15,14,'Send Notification Email to Record Owner','O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:2:\"14\";s:7:\"summary\";s:39:\"Send Notification Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:16:\"Task :  $subject\";s:7:\"content\";s:689:\"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) ,<br/><b>Task Notification Details:</b><br/>Subject : $subject<br/>Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))<br/>End date and time   : $due_date ($_DATE_FORMAT_) <br/>Status              : $taskstatus <br/>Priority            : $taskpriority <br/>Related To          : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname) <br/>Contacts List       : $contact_id <br/>Description         : $description\";s:2:\"id\";s:2:\"15\";}'),(18,16,'Update Inventory Products','O:18:\"VTEntityMethodTask\":6:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";i:16;s:7:\"summary\";s:25:\"Update Inventory Products\";s:6:\"active\";b:1;s:10:\"methodName\";s:15:\"UpdateInventory\";s:2:\"id\";i:18;}'),(19,17,'Comment Added From Portal : Send Email to Record Owner','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:54:\"Comment Added From Portal : Send Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"19\";s:10:\"workflowId\";s:2:\"17\";s:9:\"fromEmail\";s:112:\"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)&lt;$(contact_id : (Contacts) email)&gt;\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:92:\"Respond to Ticket ID## $(general : (__VtigerMeta__) recordId) ## in Customer Portal - URGENT\";s:7:\"content\";s:325:\"Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br><br>\n								Customer has provided the following additional information to your reply:<br><br>\n								<b>$lastComment</b><br><br>\n								Kindly respond to above ticket at the earliest.<br><br>\n								Regards<br>Support Administrator\";}'),(20,18,'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:82:\"Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"20\";s:10:\"workflowId\";s:2:\"18\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:514:\"Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n							The Ticket is replied the details are :<br><br>\n							Ticket No : $ticket_no<br>\n							Status : $ticketstatus<br>\n							Category : $ticketcategories<br>\n							Severity : $ticketseverities<br>\n							Priority : $ticketpriorities<br><br>\n							Description : <br>$description<br><br>\n							Solution : <br>$solution<br>\n							The comments are : <br>\n							$allComments<br><br>\n							Regards<br>Support Administrator\";}'),(21,19,'Comment Added From CRM : Send Email to Contact, where Contact is Portal User','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:76:\"Comment Added From CRM : Send Email to Contact, where Contact is Portal User\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"21\";s:10:\"workflowId\";s:2:\"19\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:547:\"Ticket No : $ticket_no<br>\n										Ticket Id : $(general : (__VtigerMeta__) recordId)<br>\n										Subject : $ticket_title<br><br>\n										Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n										There is a reply to <b>$ticket_title</b> in the \"Customer Portal\" at VTiger.\n										You can use the following link to view the replies made:<br>\n										<a href=\"$(general : (__VtigerMeta__) portaldetailviewurl)\">Ticket Details</a><br><br>\n										Thanks<br>$(general : (__VtigerMeta__) supportName)\";}'),(22,15,'Comment Added From CRM : Send Email to Organization','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:51:\"Comment Added From CRM : Send Email to Organization\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"22\";s:10:\"workflowId\";s:2:\"15\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:34:\",$(parent_id : (Accounts) email1),\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:589:\"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(parent_id : (Accounts) accountname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";}'),(23,7,'Notify Record Owner when Ticket is created from Portal','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:54:\"Notify Record Owner when Ticket is created from Portal\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"23\";s:10:\"workflowId\";s:1:\"7\";s:9:\"fromEmail\";s:124:\"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:93:\"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:158:\"Ticket No : $ticket_no<br>\n							  Ticket ID : $(general : (__VtigerMeta__) recordId)<br>\n							  Ticket Title : $ticket_title<br><br>\n							  $description\";}'),(24,20,'Send Email to Record Owner on Ticket Update','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:43:\"Send Email to Record Owner on Ticket Update\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"24\";s:10:\"workflowId\";s:2:\"20\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:40:\"Ticket Number : $ticket_no $ticket_title\";s:7:\"content\";s:596:\"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution\n								$allComments<br><br>\n								Regards<br>Support Administrator\";}'),(25,21,'Ticket Creation From CRM : Send Email to Record Owner','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:53:\"Ticket Creation From CRM : Send Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"25\";s:10:\"workflowId\";s:2:\"21\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:40:\"Ticket Number : $ticket_no $ticket_title\";s:7:\"content\";s:596:\"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution\n								$allComments<br><br>\n								Regards<br>Support Administrator\";}'),(26,22,'Send Email to Organization on Ticket Update','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:43:\"Send Email to Organization on Ticket Update\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"26\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:33:\",$(parent_id : (Accounts) email1)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:589:\"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(parent_id : (Accounts) accountname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";s:10:\"workflowId\";s:2:\"22\";}'),(27,23,'Ticket Creation From CRM : Send Email to Organization','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:53:\"Ticket Creation From CRM : Send Email to Organization\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"27\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:33:\",$(parent_id : (Accounts) email1)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:589:\"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(parent_id : (Accounts) accountname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";s:10:\"workflowId\";s:2:\"23\";}'),(28,24,'Ticket Creation From CRM : Send Email to Contact','O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:48:\"Ticket Creation From CRM : Send Email to Contact\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"28\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:624:\"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";s:10:\"workflowId\";s:2:\"24\";}'),(29,25,'add lat long','O:18:\"VTEntityMethodTask\":7:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"25\";s:7:\"summary\";s:12:\"add lat long\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:16:\"AddRecordLatLong\";s:2:\"id\";i:29;}'),(30,26,'add lat long','O:18:\"VTEntityMethodTask\":7:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"26\";s:7:\"summary\";s:12:\"add lat long\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:16:\"AddRecordLatLong\";s:2:\"id\";i:30;}'),(31,27,'add lat long','O:18:\"VTEntityMethodTask\":7:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"27\";s:7:\"summary\";s:12:\"add lat long\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:16:\"AddRecordLatLong\";s:2:\"id\";i:31;}'),(32,28,'add lat long','O:18:\"VTEntityMethodTask\":7:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"28\";s:7:\"summary\";s:12:\"add lat long\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:16:\"AddRecordLatLong\";s:2:\"id\";i:32;}'),(33,29,'add lat long','O:18:\"VTEntityMethodTask\":7:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"29\";s:7:\"summary\";s:12:\"add lat long\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:16:\"AddRecordLatLong\";s:2:\"id\";i:33;}'),(34,30,'Calcula campos dias ','O:18:\"VTUpdateFieldsTask\":8:{s:18:\"executeImmediately\";b:1;s:43:\"\0VTUpdateFieldsTask\0referenceFieldFocusList\";a:0:{}s:10:\"workflowId\";s:2:\"30\";s:7:\"summary\";s:20:\"Calcula campos dias \";s:6:\"active\";b:1;s:7:\"trigger\";N;s:19:\"field_value_mapping\";s:124:\"[{\"fieldname\":\"lb_diasvencidos\",\"value\":\"time_diffdays(get_date(\'today\'), lb_fechadevencimiento)\",\"valuetype\":\"expression\"}]\";s:2:\"id\";i:34;}');

--
-- Table structure for table `com_vtiger_workflowtasks_entitymethod`
--

CREATE TABLE `com_vtiger_workflowtasks_entitymethod` (
  `workflowtasks_entitymethod_id` int(11) NOT NULL,
  `module_name` varchar(100) DEFAULT NULL,
  `method_name` varchar(100) DEFAULT NULL,
  `function_path` varchar(400) DEFAULT NULL,
  `function_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`workflowtasks_entitymethod_id`),
  UNIQUE KEY `com_vtiger_workflowtasks_entitymethod_idx` (`workflowtasks_entitymethod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks_entitymethod`
--

INSERT INTO `com_vtiger_workflowtasks_entitymethod` VALUES (1,'SalesOrder','UpdateInventory','include/InventoryHandler.php','handleInventoryProductRel'),(2,'Invoice','UpdateInventory','include/InventoryHandler.php','handleInventoryProductRel'),(3,'Contacts','SendPortalLoginDetails','modules/Contacts/ContactsHandler.php','Contacts_sendCustomerPortalLoginDetails'),(4,'HelpDesk','NotifyOnPortalTicketCreation','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_nofifyOnPortalTicketCreation'),(5,'HelpDesk','NotifyOnPortalTicketComment','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_notifyOnPortalTicketComment'),(6,'HelpDesk','NotifyOwnerOnTicketChange','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_notifyOwnerOnTicketChange'),(7,'HelpDesk','NotifyParentOnTicketChange','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_notifyParentOnTicketChange'),(8,'ModComments','CustomerCommentFromPortal','modules/ModComments/ModCommentsHandler.php','CustomerCommentFromPortal'),(9,'ModComments','TicketOwnerComments','modules/ModComments/ModCommentsHandler.php','TicketOwnerComments'),(10,'PurchaseOrder','UpdateInventory','include/InventoryHandler.php','handleInventoryProductRel'),(11,'Leads','AddRecordLatLong','modules/CTUserFilterView/AddRecordLatLong.php','AddRecordLatLong'),(12,'Contacts','AddRecordLatLong','modules/CTUserFilterView/AddRecordLatLong.php','AddRecordLatLong'),(13,'Accounts','AddRecordLatLong','modules/CTUserFilterView/AddRecordLatLong.php','AddRecordLatLong'),(14,'Calendar','AddRecordLatLong','modules/CTUserFilterView/AddRecordLatLong.php','AddRecordLatLong'),(15,'Events','AddRecordLatLong','modules/CTUserFilterView/AddRecordLatLong.php','AddRecordLatLong');

--
-- Table structure for table `com_vtiger_workflowtasks_entitymethod_seq`
--

CREATE TABLE `com_vtiger_workflowtasks_entitymethod_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks_entitymethod_seq`
--

INSERT INTO `com_vtiger_workflowtasks_entitymethod_seq` VALUES (15);

--
-- Table structure for table `com_vtiger_workflowtasks_seq`
--

CREATE TABLE `com_vtiger_workflowtasks_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks_seq`
--

INSERT INTO `com_vtiger_workflowtasks_seq` VALUES (34);

--
-- Table structure for table `com_vtiger_workflowtemplates`
--

CREATE TABLE `com_vtiger_workflowtemplates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(100) DEFAULT NULL,
  `title` varchar(400) DEFAULT NULL,
  `template` text DEFAULT NULL,
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtemplates`
--


--
-- Table structure for table `ct_address_lat_long`
--

CREATE TABLE `ct_address_lat_long` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recordid` int(11) NOT NULL,
  `moduleid` int(11) NOT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ct_address_lat_long`
--


--
-- Table structure for table `cte_modules`
--

CREATE TABLE `cte_modules` (
  `module` varchar(50) NOT NULL,
  `valid` int(1) DEFAULT NULL,
  PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cte_modules`
--


--
-- Table structure for table `ctmobile_access_users`
--

CREATE TABLE `ctmobile_access_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_access_users`
--

INSERT INTO `ctmobile_access_users` VALUES (1,'1'),(2,'5'),(3,'6'),(4,'7'),(5,'8');

--
-- Table structure for table `ctmobile_address_autofields`
--

CREATE TABLE `ctmobile_address_autofields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL,
  `auto_search` varchar(50) NOT NULL,
  `street` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `postalCode` varchar(50) NOT NULL,
  `country` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_address_autofields`
--


--
-- Table structure for table `ctmobile_address_fields`
--

CREATE TABLE `ctmobile_address_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) DEFAULT NULL,
  `fieldname` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctmobile_address_fields`
--

INSERT INTO `ctmobile_address_fields` VALUES (60,'Contacts','vtiger_contactaddress:mailingstreet:mailingstreet:Contacts_Mailing_Street:V'),(61,'Contacts','vtiger_contactaddress:mailingcity:mailingcity:Contacts_Mailing_City:V'),(62,'Contacts','vtiger_contactaddress:mailingstate:mailingstate:Contacts_Mailing_State:V'),(63,'Contacts','vtiger_contactaddress:mailingcountry:mailingcountry:Contacts_Mailing_Country:V'),(64,'Contacts','vtiger_contactaddress:mailingzip:mailingzip:Contacts_Mailing_Zip:V'),(65,'Accounts','vtiger_accountshipads:ship_street:ship_street:Accounts_Shipping_Address:V'),(66,'Accounts','vtiger_accountshipads:ship_city:ship_city:Accounts_Shipping_City:V'),(67,'Accounts','vtiger_accountshipads:ship_state:ship_state:Accounts_Shipping_State:V'),(68,'Accounts','vtiger_accountshipads:ship_country:ship_country:Accounts_Shipping_Country:V'),(69,'Accounts','vtiger_accountshipads:ship_code:ship_code:Accounts_Shipping_Code:V'),(70,'Leads','vtiger_leadaddress:lane:lane:Leads_Street:V'),(71,'Leads','vtiger_leadaddress:city:city:Leads_City:V'),(72,'Leads','vtiger_leadaddress:state:state:Leads_State:V'),(73,'Leads','vtiger_leadaddress:country:country:Leads_Country:V'),(74,'Leads','vtiger_leadaddress:code:code:Leads_Postal_Code:V'),(75,'Calendar','vtiger_activity:location:location:Events_Location:V');

--
-- Table structure for table `ctmobile_address_modules`
--

CREATE TABLE `ctmobile_address_modules` (
  `module` varchar(250) NOT NULL DEFAULT '',
  `active` int(1) DEFAULT NULL,
  `sequence` int(3) DEFAULT NULL,
  PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctmobile_address_modules`
--

INSERT INTO `ctmobile_address_modules` VALUES ('Accounts',1,NULL),('Assets',1,NULL),('Calendar',1,NULL),('Campaigns',1,NULL),('Contacts',1,NULL),('Documents',1,NULL),('Faq',1,NULL),('HelpDesk',1,NULL),('Invoice',1,NULL),('Leads',1,NULL),('ModComments',1,NULL),('PBXManager',1,NULL),('Potentials',1,NULL),('PriceBooks',1,NULL),('Products',1,NULL),('Project',1,NULL),('ProjectMilestone',1,NULL),('ProjectTask',1,NULL),('PurchaseOrder',1,NULL),('Quotes',1,NULL),('SalesOrder',1,NULL),('ServiceContracts',1,NULL),('Services',1,NULL),('SMSNotifier',1,NULL),('Vendors',1,NULL);

--
-- Table structure for table `ctmobile_apilogs`
--

CREATE TABLE `ctmobile_apilogs` (
  `apilogid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `apirequest` longtext DEFAULT NULL,
  `apiresponse` longtext DEFAULT NULL,
  PRIMARY KEY (`apilogid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_apilogs`
--


--
-- Table structure for table `ctmobile_asset_field`
--

CREATE TABLE `ctmobile_asset_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) DEFAULT NULL,
  `fieldname` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_asset_field`
--

INSERT INTO `ctmobile_asset_field` VALUES (1,'Assets','vtiger_assets:asset_no:asset_no:Assets_Asset_No:V');

--
-- Table structure for table `ctmobile_barcode_fields`
--

CREATE TABLE `ctmobile_barcode_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) DEFAULT NULL,
  `fieldname` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_barcode_fields`
--

INSERT INTO `ctmobile_barcode_fields` VALUES (1,'Products','vtiger_products:product_no:product_no:Products_Product_No:V');

--
-- Table structure for table `ctmobile_calllog_activity`
--

CREATE TABLE `ctmobile_calllog_activity` (
  `calllogid` int(11) NOT NULL AUTO_INCREMENT,
  `activityid` int(11) NOT NULL,
  `attachmentsid` int(11) NOT NULL,
  PRIMARY KEY (`calllogid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_calllog_activity`
--


--
-- Table structure for table `ctmobile_calllog_autoactivity`
--

CREATE TABLE `ctmobile_calllog_autoactivity` (
  `isAutoActivityCreate` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_calllog_autoactivity`
--


--
-- Table structure for table `ctmobile_calllog_users`
--

CREATE TABLE `ctmobile_calllog_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_calllog_users`
--


--
-- Table structure for table `ctmobile_dashboard_sequence`
--

CREATE TABLE `ctmobile_dashboard_sequence` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `type` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_dashboard_sequence`
--


--
-- Table structure for table `ctmobile_display_fields`
--

CREATE TABLE `ctmobile_display_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `module` varchar(255) NOT NULL,
  `fieldname` varchar(255) NOT NULL,
  `fieldtype` enum('First Field','Second Field','Third Field') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_display_fields`
--


--
-- Table structure for table `ctmobile_filter_shortcut`
--

CREATE TABLE `ctmobile_filter_shortcut` (
  `shortcutid` int(11) NOT NULL AUTO_INCREMENT,
  `shortcutname` varchar(255) NOT NULL,
  `filterid` int(11) NOT NULL,
  `fieldname` varchar(100) NOT NULL,
  `search_value` varchar(255) NOT NULL,
  `userid` int(11) NOT NULL,
  `module` varchar(100) NOT NULL,
  `createdtime` datetime NOT NULL,
  PRIMARY KEY (`shortcutid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_filter_shortcut`
--


--
-- Table structure for table `ctmobile_language_keyword`
--

CREATE TABLE `ctmobile_language_keyword` (
  `keyword_id` int(11) NOT NULL AUTO_INCREMENT,
  `keyword` longtext NOT NULL,
  `keyword_name` longtext NOT NULL,
  `keyword_lang` varchar(10) NOT NULL,
  `language_keyword` longtext NOT NULL,
  `sectionid` int(11) NOT NULL,
  PRIMARY KEY (`keyword_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14431 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_language_keyword`
--




--
-- Table structure for table `ctmobile_language_section`
--

CREATE TABLE `ctmobile_language_section` (
  `section_id` int(11) NOT NULL,
  `section_name` varchar(255) NOT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_language_section`
--

INSERT INTO `ctmobile_language_section` VALUES (1,'Common Message'),(2,'Login Screen'),(3,'Forgot Password Screen'),(4,'Email Screen'),(5,'Add/Edit Record'),(6,'CoverLead Screen'),(7,'Calender screen'),(8,'Setting Screen'),(9,'Module Setting screen'),(10,'Line item Screen'),(11,'Detail Screen'),(12,'Summary Details screen'),(13,'NearBy screen'),(14,'Email Detail Screen'),(15,'Home Screen'),(16,'FeedBack Screen'),(17,'EmailTemplate Screen'),(18,'UserFilterView Screen'),(19,'Activity Setting'),(20,'SMS Send Screen'),(21,'Global Search screen'),(22,'App Introduction screen'),(23,'Drive Record screen'),(24,'ReportBug screen'),(25,'Shortcut screen'),(26,'Check URL screen'),(27,'List Screen'),(28,'Card Scanner Screen'),(29,'Other Message'),(30,'Route Planning Screen'),(31,'Time Tracking Screen'),(32,'CTMobile Messages'),(33,'Notification Settings');

--
-- Table structure for table `ctmobile_license_settings`
--

CREATE TABLE `ctmobile_license_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `license_key` varchar(255) DEFAULT NULL,
  `status` tinyint(3) DEFAULT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `expirydate` date NOT NULL,
  `user_type` enum('free','premium') NOT NULL DEFAULT 'free',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_license_settings`
--

INSERT INTO `ctmobile_license_settings` VALUES (1,'94140431f1418835bfd57f0bb839b395',1,'https://820.creantis.dev/820demo/','2024-07-06','free');

--
-- Table structure for table `ctmobile_livetracking_users`
--

CREATE TABLE `ctmobile_livetracking_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_livetracking_users`
--


--
-- Table structure for table `ctmobile_loginhistory`
--

CREATE TABLE `ctmobile_loginhistory` (
  `login_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) DEFAULT NULL,
  `user_ip` varchar(25) NOT NULL,
  `logout_time` datetime DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `status` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`login_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_loginhistory`
--

INSERT INTO `ctmobile_loginhistory` VALUES (1,'admin','201.230.249.79','2024-06-05 15:35:02','2024-06-05 15:35:02','Signed in');

--
-- Table structure for table `ctmobile_modules_management`
--

CREATE TABLE `ctmobile_modules_management` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_modules_management`
--

INSERT INTO `ctmobile_modules_management` VALUES (1,'selectAll');

--
-- Table structure for table `ctmobile_notification_module_settings`
--

CREATE TABLE `ctmobile_notification_module_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modulename` varchar(255) NOT NULL,
  `notification_id` int(11) NOT NULL,
  `workflow_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_notification_module_settings`
--


--
-- Table structure for table `ctmobile_notification_restriction`
--

CREATE TABLE `ctmobile_notification_restriction` (
  `restriction_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `notification_id` int(11) NOT NULL,
  PRIMARY KEY (`restriction_id`),
  KEY `user_setting_id` (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_notification_restriction`
--


--
-- Table structure for table `ctmobile_notification_settings`
--

CREATE TABLE `ctmobile_notification_settings` (
  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
  `notification_type` varchar(255) NOT NULL,
  `notification_enabled` enum('1','0') NOT NULL DEFAULT '1',
  `workflow_id` int(11) NOT NULL DEFAULT 0,
  `reminder_time` int(11) NOT NULL DEFAULT 0,
  `notification_title` varchar(255) DEFAULT NULL,
  `notification_message` text DEFAULT NULL,
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_notification_settings`
--

INSERT INTO `ctmobile_notification_settings` VALUES (1,'event_invitation','0',0,0,'You’ve event Invitation','Event invitation from -smownerid:first_name$ -smownerid:last_name$ On -date_start$ -time_start$'),(2,'event_reminder','0',0,0,'Event starts shortly...','Event -subject$ due on -date_start$'),(3,'record_assigned','0',0,0,'Record assigned to you','You’ve been assigned to record, click to see more information'),(4,'comment_mentioned','0',0,0,'You’re mentioned in comments','-commentcontent$'),(5,'comment_assigned','0',0,0,'Comment added to your assigned Record','Comment has been added to your assigned record, click to see more information'),(6,'task_reminder','0',0,0,'Task starts shortly...','Task -subject$  due on -date_start$'),(7,'follow_record','0',0,0,'Record you followed has been updated','Someone update record you’re following, click to see more information');

--
-- Table structure for table `ctmobile_premium_feature`
--

CREATE TABLE `ctmobile_premium_feature` (
  `feature_id` int(11) NOT NULL AUTO_INCREMENT,
  `feature_name` varchar(255) NOT NULL,
  `feature_enabled` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`feature_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_premium_feature`
--

INSERT INTO `ctmobile_premium_feature` VALUES (1,'meeting_checkin','1'),(2,'attendance_checkin','1'),(3,'qr_code_scanner','1'),(4,'business_card_scanner','1'),(5,'asset_tracking','1'),(6,'nearby_customer','1'),(7,'record_map_view','1'),(8,'address_autofinder','1'),(9,'call_from_app','1'),(10,'email_from_app','1'),(11,'sms_from_app','1'),(12,'whatsapp_from_app','1');

--
-- Table structure for table `ctmobile_qrscanning`
--

CREATE TABLE `ctmobile_qrscanning` (
  `qrscanningid` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(255) NOT NULL,
  `modulefield` varchar(255) NOT NULL,
  PRIMARY KEY (`qrscanningid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_qrscanning`
--


--
-- Table structure for table `ctmobile_qrscanning_fields`
--

CREATE TABLE `ctmobile_qrscanning_fields` (
  `id` int(11) NOT NULL,
  `module` varchar(50) DEFAULT NULL,
  `fieldname` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_qrscanning_fields`
--


--
-- Table structure for table `ctmobile_qrscanning_modules`
--

CREATE TABLE `ctmobile_qrscanning_modules` (
  `module` varchar(250) NOT NULL DEFAULT '',
  `active` int(1) DEFAULT NULL,
  `sequence` int(3) DEFAULT NULL,
  PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_qrscanning_modules`
--


--
-- Table structure for table `ctmobile_record_shortcut`
--

CREATE TABLE `ctmobile_record_shortcut` (
  `shortcutid` int(11) NOT NULL AUTO_INCREMENT,
  `shortcutname` varchar(255) NOT NULL,
  `recordid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `module` varchar(100) NOT NULL,
  `createdtime` datetime NOT NULL,
  PRIMARY KEY (`shortcutid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_record_shortcut`
--


--
-- Table structure for table `ctmobile_routegeneralsettings`
--

CREATE TABLE `ctmobile_routegeneralsettings` (
  `routegeneralsettings_id` int(11) NOT NULL AUTO_INCREMENT,
  `route_users` text NOT NULL,
  `route_distance_unit` varchar(100) NOT NULL,
  PRIMARY KEY (`routegeneralsettings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_routegeneralsettings`
--


--
-- Table structure for table `ctmobile_routestatus`
--

CREATE TABLE `ctmobile_routestatus` (
  `routestatusid` int(11) NOT NULL AUTO_INCREMENT,
  `routestatusname` varchar(255) NOT NULL,
  `routestatuslabel` varchar(255) NOT NULL,
  PRIMARY KEY (`routestatusid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_routestatus`
--

INSERT INTO `ctmobile_routestatus` VALUES (1,'In Progress','In Progress'),(2,'On Hold','On Hold'),(3,'Completed','Completed'),(4,'Not Available','Not Available');

--
-- Table structure for table `ctmobile_search_field`
--

CREATE TABLE `ctmobile_search_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL,
  `fieldname` varchar(255) NOT NULL,
  `userid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_search_field`
--


--
-- Table structure for table `ctmobile_session_expire`
--

CREATE TABLE `ctmobile_session_expire` (
  `session_expire_id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `sessionid` varchar(255) NOT NULL,
  PRIMARY KEY (`session_expire_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_session_expire`
--


--
-- Table structure for table `ctmobile_signature_fields`
--

CREATE TABLE `ctmobile_signature_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL,
  `fieldname` varchar(250) NOT NULL,
  `doc_type` enum('Signature','Documents') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_signature_fields`
--


--
-- Table structure for table `ctmobile_timetracking_modules`
--

CREATE TABLE `ctmobile_timetracking_modules` (
  `timetrackerid` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`timetrackerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_timetracking_modules`
--


--
-- Table structure for table `ctmobile_user_settings`
--

CREATE TABLE `ctmobile_user_settings` (
  `user_setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_setting_type` varchar(255) NOT NULL,
  `user_setting_value` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`user_setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_user_settings`
--

INSERT INTO `ctmobile_user_settings` VALUES (1,'access_user','1'),(2,'location_tracking','1'),(3,'route_planner','1'),(4,'time_tracker','1'),(5,'call_logging','0'),(6,'api_logs','0');

--
-- Table structure for table `ctmobile_userderoute`
--

CREATE TABLE `ctmobile_userderoute` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `devicetoken` longtext NOT NULL,
  `latitude` longtext NOT NULL,
  `longitude` longtext NOT NULL,
  `record` varchar(200) NOT NULL,
  `action` varchar(200) NOT NULL,
  `createdtime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctmobile_userderoute`
--


--
-- Table structure for table `ctmobile_vcard_fields`
--

CREATE TABLE `ctmobile_vcard_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) DEFAULT NULL,
  `fieldname` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `ctmobile_vcard_fields`
--

INSERT INTO `ctmobile_vcard_fields` VALUES (1,'Vendors','vtiger_vendor:vendorname:vendorname:Vendors_Vendor_Name:V'),(2,'Leads','vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),(3,'Leads','vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),(4,'Contacts','vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V'),(5,'Contacts','vtiger_contactdetails:lastname:lastname:Contacts_Last_Name:V');

--
-- Table structure for table `ctwhatsapp_bot_configuration`
--

CREATE TABLE `ctwhatsapp_bot_configuration` (
  `whatsappno` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `authtoken` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `whatsappbotstatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsapp_bot_configuration`
--


--
-- Table structure for table `ctwhatsapp_bots`
--

CREATE TABLE `ctwhatsapp_bots` (
  `botid` int(11) NOT NULL AUTO_INCREMENT,
  `botjson` longtext CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `botname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `scanwhatsapp_number` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `remove` int(11) DEFAULT 0,
  `assignuserid` int(11) DEFAULT NULL,
  PRIMARY KEY (`botid`)
) ENGINE=InnoDB AUTO_INCREMENT=1118 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsapp_bots`
--


--
-- Table structure for table `ctwhatsappbot_condition_assign`
--

CREATE TABLE `ctwhatsappbot_condition_assign` (
  `que_id` int(11) NOT NULL,
  `status` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `next_que_id1` int(30) NOT NULL,
  `next_que_id2` int(30) NOT NULL,
  `variablename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `conditions` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `variablevalue` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsappbot_condition_assign`
--


--
-- Table structure for table `ctwhatsappbot_crmaction_fieldmapping`
--

CREATE TABLE `ctwhatsappbot_crmaction_fieldmapping` (
  `mappingid` int(11) NOT NULL AUTO_INCREMENT,
  `crmaction_id` int(11) NOT NULL,
  `vtigerfield` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `flowbuilderfield` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `maptype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'request',
  `defaultvalue` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`mappingid`),
  KEY `crmaction_id` (`crmaction_id`),
  CONSTRAINT `ctwhatsappbot_crmaction_fieldmapping_ibfk_1` FOREIGN KEY (`crmaction_id`) REFERENCES `ctwhatsappbot_crmaction_master` (`crmaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4563 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsappbot_crmaction_fieldmapping`
--


--
-- Table structure for table `ctwhatsappbot_crmaction_master`
--

CREATE TABLE `ctwhatsappbot_crmaction_master` (
  `crmaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `tabid` bigint(11) NOT NULL,
  `action` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `que_id` int(11) NOT NULL,
  `related_tabid` int(11) NOT NULL,
  PRIMARY KEY (`crmaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1579 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsappbot_crmaction_master`
--


--
-- Table structure for table `ctwhatsappbot_opt_master`
--

CREATE TABLE `ctwhatsappbot_opt_master` (
  `opt_id` int(11) NOT NULL AUTO_INCREMENT,
  `opt_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `opt_seq` int(11) DEFAULT NULL,
  `botid` int(11) DEFAULT NULL,
  `seq_option` int(11) DEFAULT NULL,
  PRIMARY KEY (`opt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8183 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsappbot_opt_master`
--


--
-- Table structure for table `ctwhatsappbot_que_master`
--

CREATE TABLE `ctwhatsappbot_que_master` (
  `que_id` int(11) NOT NULL AUTO_INCREMENT,
  `messagetype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `que_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `que_type_id` int(11) DEFAULT NULL,
  `search_module` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `search_column` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `botid` int(11) DEFAULT NULL,
  `que_sequence` int(11) DEFAULT NULL,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `next_sequence` int(11) DEFAULT NULL,
  `varmessagetype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `copy_from` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `copy_to` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `responseimg` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`que_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13611 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsappbot_que_master`
--


--
-- Table structure for table `ctwhatsappbot_que_opt_assign`
--

CREATE TABLE `ctwhatsappbot_que_opt_assign` (
  `que_id` int(11) DEFAULT NULL,
  `opt_id` int(11) DEFAULT NULL,
  `next_que_id` int(11) DEFAULT NULL,
  `botid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctwhatsappbot_que_opt_assign`
--


--
-- Table structure for table `flowbuilderfields`
--

CREATE TABLE `flowbuilderfields` (
  `fieldId` int(11) NOT NULL AUTO_INCREMENT,
  `fieldname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `question` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `iconclass` varchar(122) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `slug` varchar(122) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`fieldId`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `flowbuilderfields`
--


--
-- Table structure for table `log_fieldallmodule`
--

CREATE TABLE `log_fieldallmodule` (
  `id_log_field_all_module` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `tabla` varchar(255) NOT NULL,
  `bloque_name` varchar(255) NOT NULL,
  `bloque_sequence` int(11) NOT NULL,
  `uitype` text NOT NULL,
  `displaytype` text NOT NULL,
  `label_view` text NOT NULL,
  `columna_database` text NOT NULL,
  `columna_sequence` int(11) NOT NULL,
  `defaultvalue` text NOT NULL,
  `quickcreate` int(11) NOT NULL,
  `quickcreatesequence` text DEFAULT NULL,
  `masseditable` int(11) NOT NULL,
  `summaryfield` int(11) NOT NULL,
  `headerfield` int(11) NOT NULL,
  `columntype_database` text DEFAULT NULL,
  `module` text DEFAULT NULL,
  `picklist` text DEFAULT NULL,
  `mandatory` int(11) DEFAULT NULL,
  `migrated` int(11) DEFAULT NULL,
  `column_type` varchar(30) DEFAULT NULL,
  `typeofdata` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id_log_field_all_module`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `log_fieldallmodule`
--

INSERT INTO `log_fieldallmodule` VALUES (1,'vtiger_cobranzas','Encabezado de Factura',1,'1','1','Razon Social','lb_razonsocial',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(2,'vtiger_cobranzas','Encabezado de Factura',1,'1','1','Numero de Factura','lb_numerofactura',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(3,'vtiger_cobranzas','Encabezado de Factura',1,'5','1','Fecha de Emisión','lb_fechaemision',1,'',0,'',1,0,0,'DATE','60','',0,0,'DATE','D~O'),(4,'vtiger_cobranzas','Encabezado de Factura',1,'5','1','Fecha de Vencimiento','lb_fechadevencimiento',1,'',0,'',1,0,0,'DATE','60','',0,0,'DATE','D~O'),(5,'vtiger_cobranzas','Encabezado de Factura',1,'71','1','Monto Total','lb_montototal',1,'',0,'',1,0,0,'DECIMAL(25,8)','60','',0,0,'DECIMAL(25,8)','N~O'),(6,'vtiger_cobranzas','Encabezado de Factura',1,'1','1','Días Vencidos','lb_diasvencidos',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(7,'vtiger_cobranzas','Encabezado de Factura',1,'56','1','Con Reclamos','lb_conreclamos',1,'',0,'',1,0,0,'INT(1)','60','',0,0,'INT(1)','V~O'),(8,'vtiger_cobranzas','Encabezado de Factura',1,'16','1','Estado','lb_estado',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(9,'vtiger_cobranzas','Encabezado de Factura',1,'16','1','Etapa','lb_etapa',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(10,'vtiger_cobranzas','Encabezado de Factura',1,'71','1','Monto Final Acordado','lb_montofinalacordado',1,'',0,'',1,0,0,'DECIMAL(25,8)','60','',0,0,'DECIMAL(25,8)','N~O'),(11,'vtiger_cobranzas','Encabezado de Factura',1,'5','1','Fecha de Compromiso de Pago	','lb_fechacompromisopa',1,'',0,'',1,0,0,'DATE','60','',0,0,'DATE','D~O'),(12,'vtiger_cobranzas','Encabezado de Factura',1,'71','1','Pagado','lb_pagado',1,'',0,'',1,0,0,'DECIMAL(25,8)','60','',0,0,'DECIMAL(25,8)','N~O'),(13,'vtiger_cobranzas','Encabezado de Factura',1,'16','1','Tipo de Pago','lb_tipodepago',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(14,'vtiger_cobranzas','Encabezado de Factura',1,'16','1','Motivo de Pago Parcial','lb_motivopagoparcial',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(15,'vtiger_cobranzas','Encabezado de Factura',1,'19','1','Acuerdo de Pago Parcial','lb_cuerdodeagoarcial',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(16,'vtiger_cobranzas','Encabezado de Factura',1,'56','1','Reportado a Infocorp','lb_reportadoanfocorp',1,'',0,'',1,0,0,'INT(1)','60','',0,0,'INT(1)','V~O'),(17,'vtiger_cobranzas','Encabezado de Factura',1,'71','1','Saldo','lb_saldopag',1,'',0,'',1,0,0,'DECIMAL(25,8)','60','',0,0,'DECIMAL(25,8)','N~O'),(18,'vtiger_cobranzas','Encabezado de Factura',1,'19','1','Requisito de Pago','lb_requisitodepago',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(19,'vtiger_cobranzas','Encabezado de Factura',1,'1','1','Días de Pago','lb_diasdepago',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(20,'vtiger_cobranzas','Encabezado de Factura',1,'2','1','Horario','lb_horarioss',1,'',0,'',1,0,0,'TIME','60','',0,0,'TIME','T~O'),(21,'vtiger_cobranzas','Encabezado de Factura',1,'1','1','Contacto','lb_contactopag',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(22,'vtiger_cobranzas','Encabezado de Factura',1,'13','1','Email','lb_emailcxobra',1,'',0,'',1,0,0,'VARCHAR(100)','60','',0,0,'VARCHAR(100)','E~O'),(23,'vtiger_cobranzas','Encabezado de Factura',1,'1','1','Telefono','lb_telefonocobran',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(24,'vtiger_pagosparciales','Detalles del Pago',1,'1','1','Cobranza','lb_cobranzapag',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(25,'vtiger_pagosparciales','Detalles del Pago',1,'16','1','Estado de Pago','lb_estadodeago',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(26,'vtiger_pagosparciales','Detalles del Pago',1,'1','1','Numero de Pago','lb_numeropagopagpar',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(27,'vtiger_pagosparciales','Detalles del Pago',1,'71','1','Monto','lb_moentopagpar',1,'',0,'',1,0,0,'DECIMAL(25,8)','61','',0,0,'DECIMAL(25,8)','N~O'),(28,'vtiger_pagosparciales','Detalles del Pago',1,'16','1','Forma de Pago','lb_formapagopagpar',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(29,'vtiger_pagosparciales','Detalles del Pago',1,'5','1','Fecha de Pago','lb_fechapagopagpar',1,'',0,'',1,0,0,'DATE','61','',0,0,'DATE','D~O'),(30,'vtiger_troubletickets','LBL_TICKET_INFORMATION',1,'16','1','Clasificación de Contacto','lb_clasificaciondecontacto',1,'',0,'',1,0,0,'TEXT','13','',0,0,'TEXT','V~O'),(31,'vtiger_troubletickets','LBL_TICKET_INFORMATION',1,'16','1','Responsable de Proxima Accion','lb_responsablecaso',1,'',0,'',1,0,0,'TEXT','13','',0,0,'TEXT','V~O'),(32,'vtiger_troubletickets','LBL_TICKET_INFORMATION',1,'16','1','Proxima Accion','lb_proxima_accion',1,'',0,'',1,0,0,'TEXT','13','',0,0,'TEXT','V~O'),(33,'vtiger_troubletickets','LBL_TICKET_INFORMATION',1,'16','1','El caso fue resuelto','lb_elcasofueresuelto',1,'',0,'',1,0,0,'TEXT','13','',0,0,'TEXT','V~O'),(34,'vtiger_troubletickets','LBL_TICKET_INFORMATION',1,'16','1','El tiempo de atención fue optimo','lb_tiempodeatencion',1,'',0,'',1,0,0,'TEXT','13','',0,0,'TEXT','V~O'),(35,'vtiger_troubletickets','LBL_TICKET_INFORMATION',1,'16','1','Fue atentido amablemente','lb_atentidoamablemente',1,'',0,'',1,0,0,'TEXT','13','',0,0,'TEXT','V~O'),(36,'vtiger_troubletickets','LBL_TICKET_INFORMATION',1,'16','1','Calificacion General','lb_calificaciongeneral',1,'',0,'',1,0,0,'TEXT','13','',0,0,'TEXT','V~O'),(37,'vtiger_campaign','LBL_CAMPAIGN_INFORMATION',1,'1','1','Mailchimp List ID ','lb_mailchimplistid',1,'',0,'',1,0,0,'TEXT','26','',0,0,'TEXT','V~O'),(38,'vtiger_campaign','LBL_CAMPAIGN_INFORMATION',1,'1','1','Mailchimp Campaign ID','lb_mailchimpcampaignid',1,'',0,'',1,0,0,'TEXT','26','',0,0,'TEXT','V~O'),(39,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'1','1','WhatsApp','lb_whatsappcontact',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(40,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'1','1','DNI','lb_dnicontact',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(41,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'1','1','Skype','lb_skypecontact',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(42,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'1','1','Departamento','lb_departmentcontact',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(43,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'71','1','Ticket Promedio','lb_ticketpromediocontact',1,'',0,'',1,0,0,'DECIMAL(25,8)','4','',0,0,'DECIMAL(25,8)','N~O'),(44,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'71','1','Compra Acumulada','lb_compraacumuladacontact',1,'',0,'',1,0,0,'DECIMAL(25,8)','4','',0,0,'DECIMAL(25,8)','N~O'),(45,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'5','1','Ultima Compra','lb_ultimacompracontact',1,'',0,'',1,0,0,'DATE','4','',0,0,'DATE','D~O'),(46,'vtiger_contactdetails','LBL_CONTACT_INFORMATION',1,'1','1','Frecuencia de Compra','lb_frecuenciadecompracontact',1,'',0,'',1,0,0,'INT(50)','4','',0,0,'INT(50)','I~O'),(47,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1','Sexo','lb_sexocontact',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(48,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1','Origen de Prospecto','lb_origendeprospectocontact',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(49,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1',' Kenjinkai del Padre','lb_kenjinkai',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(50,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1','Estado Civil','lb_estadocivil',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(51,'vtiger_contactdetails','Informacion de Segmentacion',2,'1','1','Edad ','lb_edadcontact',1,'',0,'',1,0,0,'INT(50)','4','',0,0,'INT(50)','I~O'),(52,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1','Kenjikai de la Madre','lb_kenjikaidelamadre',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(53,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1','Perfil','lb_perfilcontact',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(54,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1','Acepto Tratamiento de Datos Personales','lb_aceptodatoper',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(55,'vtiger_contactdetails','Informacion de Segmentacion',2,'16','1','Medio de Aceptacion o Denegacion','lb_mediodeaceptacion',1,'',0,'',1,0,0,'TEXT','4','',0,0,'TEXT','V~O'),(56,'vtiger_contactdetails','Informacion de Segmentacion',2,'5','1',' Fecha de Aceptacion o Denegacion','lb_fechadeaceptacion',1,'',0,'',1,0,0,'DATE','4','',0,0,'DATE','D~O'),(57,'vtiger_contactdetails','Informacion de Segmentacion',2,'5','1',' Fecha de Aceptacion o Denegacion','lb_fechadeaceptacion',1,'',0,'',1,0,0,'DATE','4','',0,0,'DATE','D~O'),(58,'vtiger_potential','LBL_LEAD_INFORMATION',5,'5','1','Fecha de Siguiente Paso','lb_fechadesiguientepaso',1,'',0,'',1,0,0,'DATE','2','',0,0,'DATE','D~O'),(59,'vtiger_potential','LBL_LEAD_INFORMATION',5,'16','1','Probabilidad de Exito ','lb_probabilidaddeexito',1,'',0,'',1,0,0,'TEXT','2','',0,0,'TEXT','V~O'),(60,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'16','1','Asesor','lb_asesor',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(61,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'16','1','Supervisor','lb_supervisor',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(62,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'19','1','Problemas u Oportunidades','lb_problemasuoportunidades',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(63,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'19','1','Proyectos o Iniciativas','lb_proyectosoiniciativas',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(64,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'19','1','Producto a ofrecer','lb_productoaofrecer',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(65,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'19','1','Estrategia y Objetivos ','lb_estrategiayobjetivos',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(66,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'19','1','Perfil de','lb_perfilde',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(67,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'71','1','Compra Acumulada','lb_compraacumulada',1,'',0,'',1,0,0,'DECIMAL(25,8)','6','',0,0,'DECIMAL(25,8)','N~O'),(68,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'16','1','Region','lb_region',1,'',0,'',1,0,0,'TEXT','6','',0,0,'TEXT','V~O'),(69,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'1','1','Frecuencia de Visitas Mensual','lb_frecuenciadevisitames',1,'',0,'',1,0,0,'INT(50)','6','',0,0,'INT(50)','I~O'),(70,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'1','1','Frecuencia de Compras Mensual','lb_frecuenciadecomprames',1,'',0,'',1,0,0,'INT(50)','6','',0,0,'INT(50)','I~O'),(71,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'5','1','Proxima Visita','lb_proximavisita',1,'',0,'',1,0,0,'DATE','6','',0,0,'DATE','D~O'),(72,'vtiger_account','LBL_ACCOUNT_INFORMATION',1,'5','1','Proxima Compra','lb_proximacompra',1,'',0,'',1,0,0,'DATE','6','',0,0,'DATE','D~O'),(73,'vtiger_pagos','Informacion general',1,'1','1','Cobranza','lb_cobranzapagosparciales',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(74,'vtiger_pagos','Informacion general',1,'16','1','Estado de Pago','lb_estadopagosparciales',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(75,'vtiger_pagos','Informacion general',1,'1','1','Número de Pago','lb_numeropagosparciales',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(76,'vtiger_pagos','Informacion general',1,'71','1','Monto','lb_montopagosparciales',1,'',0,'',1,0,0,'DECIMAL(25,8)','61','',0,0,'DECIMAL(25,8)','N~O'),(77,'vtiger_pagos','Informacion general',1,'16','1','Forma de Pago','lb_formapagosparciales',1,'',0,'',1,0,0,'TEXT','61','',0,0,'TEXT','V~O'),(78,'vtiger_pagos','Informacion general',1,'5','1','Fecha de Pago','lb_fechapagosparciales',1,'',0,'',1,0,0,'DATE','61','',0,0,'DATE','D~O'),(79,'vtiger_cobranzas','Detalles de Cobranza',2,'16','1','Actividad Realizada ','lb_activitirealizadacobran',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(80,'vtiger_cobranzas','Detalles de Cobranza',2,'16','1','Acción de Cobranza','lb_accionvocobran',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O'),(81,'vtiger_cobranzas','Detalles de Cobranza',2,'19','1','Detalle de Cobranza','lb_detalleccobran',1,'',0,'',1,0,0,'TEXT','60','',0,0,'TEXT','V~O');

--
-- Temporary table structure for view `vs_oportunidades`
--

/*!50001 DROP VIEW IF EXISTS `vs_oportunidades`*/;
/*!50001 CREATE VIEW `vs_oportunidades` AS SELECT
 1 AS `potentialid`,
  1 AS `first_name`,
  1 AS `last_name`,
  1 AS `user_name`,
  1 AS `potentialname`,
  1 AS `amount`,
  1 AS `sales_stage`,
  1 AS `closingdate`,
  1 AS `probability` */;

--
-- Table structure for table `vt_field_input`
--

CREATE TABLE `vt_field_input` (
  `idvt_field_input` int(11) NOT NULL AUTO_INCREMENT,
  `classfield` text DEFAULT NULL,
  `fieldid` int(11) NOT NULL,
  PRIMARY KEY (`idvt_field_input`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vt_field_input`
--


--
-- Table structure for table `vtiger_account`
--

CREATE TABLE `vtiger_account` (
  `accountid` int(19) NOT NULL DEFAULT 0,
  `account_no` varchar(100) NOT NULL,
  `accountname` varchar(100) NOT NULL,
  `parentid` int(19) DEFAULT 0,
  `account_type` varchar(200) DEFAULT NULL,
  `industry` varchar(200) DEFAULT NULL,
  `annualrevenue` decimal(25,8) DEFAULT NULL,
  `rating` varchar(200) DEFAULT NULL,
  `ownership` varchar(50) DEFAULT NULL,
  `siccode` varchar(50) DEFAULT NULL,
  `tickersymbol` varchar(30) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `otherphone` varchar(30) DEFAULT NULL,
  `email1` varchar(100) DEFAULT NULL,
  `email2` varchar(100) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `fax` varchar(30) DEFAULT NULL,
  `employees` int(10) DEFAULT 0,
  `emailoptout` varchar(3) DEFAULT '0',
  `notify_owner` varchar(3) DEFAULT '0',
  `isconvertedfromlead` varchar(3) DEFAULT '0',
  `tags` varchar(1) DEFAULT NULL,
  `lb_asesor` text DEFAULT NULL,
  `lb_supervisor` text DEFAULT NULL,
  `lb_problemasuoportunidades` text DEFAULT NULL,
  `lb_proyectosoiniciativas` text DEFAULT NULL,
  `lb_productoaofrecer` text DEFAULT NULL,
  `lb_estrategiayobjetivos` text DEFAULT NULL,
  `lb_perfilde` text DEFAULT NULL,
  `lb_compraacumulada` decimal(25,8) DEFAULT NULL,
  `lb_region` text DEFAULT NULL,
  `lb_frecuenciadevisitames` int(50) DEFAULT NULL,
  `lb_frecuenciadecomprames` int(50) DEFAULT NULL,
  `lb_proximavisita` date DEFAULT NULL,
  `lb_proximacompra` date DEFAULT NULL,
  PRIMARY KEY (`accountid`),
  KEY `account_account_type_idx` (`account_type`),
  KEY `email_idx` (`email1`,`email2`),
  CONSTRAINT `fk_1_vtiger_account` FOREIGN KEY (`accountid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_account`
--

INSERT INTO `vtiger_account` VALUES (2,'ACC1','PETROLEOS DEL PERU PETROPERU S.A.',0,'Cliente','',0.00000000,'','','20100128218','','(1)6145000','','servcliente@petroperu.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'ACC2','REFINERIA LA PAMPILLA S.A.A',0,'Cliente','',0.00000000,'','','20259829594','','(1)2156225','','repsolypf@repsolypf.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'ACC3','SOUTHERN PERU COPPER CORPORATION SUC. DEL PERU',0,'Cliente','',0.00000000,'','','20100147514','','(1)5120440','','spcc@southernperu.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'ACC4','MINERA YANACOCHA S.R.L.',0,'Cliente','',0.00000000,'','','20137291313','','(1)2152600','','info@hocplc.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'ACC5','CIA. MINERA ANTAMINA S.A.',0,'Cliente','',0.00000000,'','','20330262428','','(1)2173000','','comcorp@antamina.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'ACC6','SOCIEDAD MINERA CERRO VERDE S.A.A.',0,'Cliente','',0.00000000,'','','20170072465','','(54)283363','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'ACC7','BANCO DE CREDITO DEL PERU SA',0,'Cliente','',0.00000000,'','','20100047218','','(1)3132000','','viabcp@viabcp.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'ACC8','SEGURO SOCIAL DE SALUD - ESSALUD',0,'Cliente','',0.00000000,'','','20131257750','','(1)2656000','','essalud@essalud.gob.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'ACC9','TELEFONICA DEL PERU S.A.A.',0,'Cliente','',0.00000000,'','','20100017491','','(1)2101342','','rvaron@tp.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'ACC10','CONSORCIO MINERO S.A.',0,'Cliente','',0.00000000,'','','20100140340','','(1)2159900','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'ACC11','BANCO CENTRAL DE RESERVA DEL PERU',0,'Cliente','',0.00000000,'','','20122476309','','(1)6132000','','webmaster@bcrp.gob.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'ACC12','BANCO CONTINENTAL',0,'Cliente','',0.00000000,'','','20100130204','','(1)2111000','','planeamiento@grupobbva.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'ACC13','TELEFONICA MOVILES S.A.',0,'Cliente','',0.00000000,'','','20100177774','','(1)2157400','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'ACC14','PERUPETRO S.A.',0,'Cliente','',0.00000000,'','','20196785044','','(1)6171800','','admweb@perupetro.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'ACC15','ALICORP S.A.A.',0,'Cliente','',0.00000000,'','','20100055237','','(1)3150800','','atencionclientes@alicorp.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'ACC16','UNION DE CERVECERIAS PERUANAS BACKUS Y JOHNSTON S.A.A.',0,'Cliente','',0.00000000,'','','20100113610','','(1)3113000','','cobackus@backus.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'ACC17','REPSOL COMERCIAL S.A.C.',0,'Cliente','',0.00000000,'','','20503840121','','(1)2156225','','ecastagnettoc@repsolypf.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'ACC18','PERUANA DE COMBUSTIBLES S.A.',0,'Cliente','',0.00000000,'','','20259033072','','(1)4114600','','sac@pecsa.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'ACC19','PRIMAX S.A.',0,'Cliente','',0.00000000,'','','20100082714','','(1)2033100','','contactenos@primax.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'ACC20','INTERBANK',0,'Cliente','',0.00000000,'','','20100053455','','(1)2192000','','netactiva24@intercorp.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'ACC21','SCOTIABANK PERU S.A.A.',0,'Cliente','',0.00000000,'','','20100043140','','(1)2116000','','mariaalejandra.rada@scotiabank.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'ACC22','AMERICA MOVIL PERU S.A.C.',0,'Cliente','',0.00000000,'','','20467534026','','(1)6131000','','samoros@claro.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'ACC23','HIPERMERCADOS METRO S.A.',0,'Cliente','',0.00000000,'','','20109072177','','(1)6260000','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'ACC24','PROCESADORA SUDAMERICANA S.R.L.',0,'Cliente','',0.00000000,'','','20100277485','','(1)3261414','','psa@psa.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'ACC25','SUPERMERCADOS PERUANOS S.A.',0,'Cliente','',0.00000000,'','','20100070970','','(1)6188000','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'ACC26','GLORIA S.A.',0,'Cliente','',0.00000000,'','','20100190797','','(1)4707170','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'ACC27','RIMAC INTERNACIONAL CIA. DE SEGUROS Y REASEGUROS',0,'Cliente','',0.00000000,'','','20100041953','','(1)4113000','','atencionalcliente@rimac.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'ACC28','PLUSPETROL PERU CORPORATION S.A.',0,'Cliente','',0.00000000,'','','20304177552','','(1)4117100','','nbenito@pluspetrol.com.ar','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'ACC29','FERREYROS S.A.A.',0,'Cliente','',0.00000000,'','','20100027292','','(1)6264000','','clientes@ferreyros.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'ACC30','A. Y S. S.A.',0,'Cliente','',0.00000000,'','','20259150117','','(1)2178060','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'ACC31','CORPORACION ACEROS AREQUIPA S.A.',0,'Cliente','',0.00000000,'','','20370146994','','(1)5171800','','mktng@acerosarequipa.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'ACC32','LUZ DEL SUR S.A.A.',0,'Cliente','',0.00000000,'','','20331898008','','(1)2719090','','central@luzdelsur.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'ACC33','EMPRESA DE DISTRIBUCION ELECTRICA DE LIMA NORTE S.A.A.',0,'Cliente','',0.00000000,'','','20269985900','','(1)5612001','','enlinea@edelnor.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'ACC34','SAVIA PERU S.A. (EX PETRO-TECH PERUANA S.A.)',0,'Cliente','',0.00000000,'','','20203058781','','(1)5137500','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'ACC35','SAGA FALABELLA S.A.',0,'Cliente','',0.00000000,'','','20100128056','','(1)6161000','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'ACC36','UNIVERSAL METAL TRADING S.A.C.',0,'Cliente','',0.00000000,'','','20421226378','','(1)2260031','','umtsac@terra.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'ACC37','VOLCAN CIA. MINERA S.A.A.',0,'Cliente','',0.00000000,'','','20383045267','','(1)2194000','','contac@volcan.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'ACC38','BANCO DE LA NACION',0,'Cliente','',0.00000000,'','','20100030595','','(1)5192000','','presidencia@bn.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'ACC39','MINSUR S.A.',0,'Cliente','',0.00000000,'','','20100136741','','(1)2158330','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'ACC40','G. Y M. S.A.',0,'Cliente','',0.00000000,'','','20100154057','','(1)2130444','','mmiloslavich@gym.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'ACC41','CORPORACION JOSE R. LINDLEY S.A.',0,'Cliente','',0.00000000,'','','20101024645','','(1)4812070','','jrlindley@incakola.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'ACC42','SUPERINTENDENCIA NACIONAL DE ADMINISTRACION TRIBUTARIA',0,'Cliente','',0.00000000,'','','20131312955','','(1)3153306','','webmaster@sunat.gob.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'ACC43','SAN FERNANDO S.A.',0,'Cliente','',0.00000000,'','','20100154308','','(1)2417555','','informes@san-fernando.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'ACC44','TECNOLOGICA DE ALIMENTOS S.A.',0,'Cliente','',0.00000000,'','','20100971772','','(1)6111400','','sales@tasa.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'ACC45','CIA. DE MINAS BUENAVENTURA S.A.A.',0,'Cliente','',0.00000000,'','','20100079501','','(1)4192500','','recursos@buenaventura.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'ACC46','TIENDAS POR DEPARTAMENTO RIPLEY S.A.',0,'Cliente','',0.00000000,'','','20337564373','','(1)6115700','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'ACC47','EMPRESA SIDERURGICA DEL PERU S.A.A.',0,'Cliente','',0.00000000,'','','20402885549','','(1)6186868','','marketing@sider.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'ACC48','HIPERMERCADOS TOTTUS S.A.',0,'Cliente','',0.00000000,'','','20508565934','','(1)5139400','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'ACC49','EMPRESA ELECTRICIDAD DEL PERU - ELECTROPERU S.A.',0,'Cliente','',0.00000000,'','','20100027705','','(1)7154600','','postmast@electroperu.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'ACC50','E. WONG S.A.',0,'Cliente','',0.00000000,'','','20100106915','','(1)6260000','','ewong@ewong.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'ACC51','HUNT OIL COMPANY OF PERU LLC SUC. DEL PERU',0,'Cliente','',0.00000000,'','','20467685661','','(1)7074000','','jmoya@huntoil.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'ACC52','PERUANA DE PETROLEO S.A.C.',0,'Cliente','',0.00000000,'','','20100132754','','(1)4114600','','sac@pecsa.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'ACC53','QUIMICA SUIZA S.A.',0,'Cliente','',0.00000000,'','','20100085225','','(1)2114000','','mail@quimicasuiza.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'ACC54','ENERSUR S.A.',0,'Cliente','',0.00000000,'','','20333363900','','(1)6167979','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'ACC55','ORICA CHEMICALS PERU S.A.C.',0,'Cliente','',0.00000000,'','','20260733916','','(1)6113500','','central@orica.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'ACC56','SERVICIO DE AGUA POTABLE Y ALCANTARILLADO DE LIMA - SEDAPAL S.A.',0,'Cliente','',0.00000000,'','','20100152356','','(1)3173000','','sedanet@sedapal.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'ACC57','TOYOTA DEL PERU S.A.',0,'Cliente','',0.00000000,'','','20100132592','','(1)2159090','','toyota@toyotaperu.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'ACC58','DOE RUN PERU S.R.L.',0,'Cliente','',0.00000000,'','','20376303811','','(1)2151200','','ebrande@doerun.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'ACC59','NESTLE PERU S.A.',0,'Cliente','',0.00000000,'','','20263322496','','(1)4364040','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'ACC60','EL PACIFICO PERUANO SUIZA CIA. DE SEGUROS Y REASEGUROS',0,'Cliente','',0.00000000,'','','20100035392','','(1)5184000','','info@pacifico.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'ACC61','CONIRSA S.A.',0,'Cliente','',0.00000000,'','','20511835411','','(1)2172800','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'ACC62','PLUSPETROL NORTE S.A.',0,'Cliente','',0.00000000,'','','20504311342','','(1)4117100','','gbarchi@pluspetrol.net','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'ACC63','DEPRODECA S.A.C.',0,'Cliente','',0.00000000,'','','20467539842','','(1)3172500','','contactenos@gloria.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'ACC64','EDEGEL S.A.A.',0,'Cliente','',0.00000000,'','','20330791412','','(1)2156300','','postmaster@edegel.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'ACC65','LAN PERU S.A.',0,'Cliente','',0.00000000,'','','20341841357','','(1)2138300','','corporateperu@lan.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'ACC66','GOLD FIELDS LA CIMA S.A.',0,'Cliente','',0.00000000,'','','20507828915','','(1)7060400','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'ACC67','KORI PERU S.A.C.',0,'Cliente','',0.00000000,'','','20504358659','','(1)2212596','','perumineras@hotmail.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'ACC68','PROCTER & GAMBLE PERU S.R.L.',0,'Cliente','',0.00000000,'','','20100127165','','(1)2153300','','muniz.g@pg.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'ACC69','ECKERD PERU S.A.',0,'Cliente','',0.00000000,'','','20331066703','','(1)3159000','','lgarcia@inkafarma.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'ACC70','TECHINT S.A.C.',0,'Cliente','',0.00000000,'','','20433763221','','(1)2135555','','tpeanl@techint.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'ACC71','PETROBRAS ENERGIA PERU S.A.',0,'Cliente','',0.00000000,'','','20356476434','','(1)7062000','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'ACC72','CIA. MINERA ARES S.A.C.',0,'Cliente','',0.00000000,'','','20192779333','','(1)3172000','','info@hocplc.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'ACC73','CEMENTOS LIMA S.A.',0,'Cliente','',0.00000000,'','','20100137390','','(1)2170200','','postmaster@cementoslima.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'ACC74','SHOUGANG HIERRO PERU S.A.A.',0,'Cliente','',0.00000000,'','','20100142989','','(1)7145200','','comercial@shp.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'ACC75','CBI PERUANA S.A.C.',0,'Cliente','',0.00000000,'','','20514075558','','(1)7059100','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'ACC76','MIBANCO BANCO DE LA MICRO EMPRESA S.A.',0,'Cliente','',0.00000000,'','','20382036655','','(1)5138000','','servicios@mibanco.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'ACC77','REPSOL YPF COMERCIAL DEL PERU S.A.',0,'Cliente','',0.00000000,'','','20100176450','','(1)2157300','','agutierrez@repsolypf.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'ACC78','TRANSPORTADORA DE GAS DEL PERU S.A.',0,'Cliente','',0.00000000,'','','20499432021','','(1)6177777','','informes@tgp.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'ACC79','FONDO NACIONAL DE FINANCIAMIENTO DE LA ACTIVIDAD EMPRESARIAL DEL ESTADO - FONAFE',0,'Cliente','',0.00000000,'','','20458605662','','(1)4404222','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'ACC80','NEXTEL DEL PERU S.A.',0,'Cliente','',0.00000000,'','','20106897914','','(1)6111111','','milagros.avendano@nextel.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'ACC81','CIA. MINERA MILPO S.A.A.',0,'Cliente','',0.00000000,'','','20100110513','','(1)7105500','','comunicaciones@milpo.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'ACC82','MANU PERU HOLDING S.A.',0,'Cliente','',0.00000000,'','','20508615460','','(1)6128383','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'ACC83','L. G. ELECTRONIC PERU S.A.',0,'Cliente','',0.00000000,'','','20375755344','','(1)4150000','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'ACC84','CORPORACION PESQUERA INCA S.A.',0,'Cliente','',0.00000000,'','','20224748711','','(1)2134000','','sales@copeinca.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'ACC85','CREDISCOTIA FINANCIERA S.A.',0,'Cliente','',0.00000000,'','','20255993225','','(1)2119900','','postmaster@crediscotia.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'ACC86','CETCO S.A.',0,'Cliente','',0.00000000,'','','20100123763','','(1)2113300','','escribenos.pe@ebelinternational.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'ACC87','SOCIEDAD MINERA EL BROCAL S.A.A.',0,'Prospecto','',0.00000000,'','','20100017572','','(1)6113900','','k_laserna@elbrocal.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'ACC88','INVERSIONES MINERAS KOPAKABANA S.C.R.L.',0,'Prospecto','',0.00000000,'','','20447759056','','','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'ACC89','AUSTRAL GROUP S.A.A.',0,'Prospecto','',0.00000000,'','','20338054115','','(1)7107000','','sales@austral.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'ACC90','XSTRATA TINTAYA S.A.',0,'Prospecto','',0.00000000,'','','20114915026','','(1)3722233','','mbernaola@xstratacopper.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'ACC91','MAESTRO HOME CENTER S.A.',0,'Prospecto','',0.00000000,'','','20112273922','','(1)6111900','','maestro@maestro.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'ACC92','PLUSPETROL CAMISEA S.A.',0,'Prospecto','',0.00000000,'','','20510889135','','(1)4117100','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'ACC93','SODIMAC PERU S.A.',0,'Prospecto','',0.00000000,'','','20389230724','','(1)6110400','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'ACC94','UNIQUE S.A.',0,'Prospecto','',0.00000000,'','','20100102413','','(1)5134000','','gravago@unique-yanbal.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'ACC95','KIMBERLY CLARK PERU S.A.',0,'Prospecto','',0.00000000,'','','20262648398','','(1)6181800','','instituciones@kcc.com','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'ACC96','PESQUERA DIAMANTE S.A.',0,'Prospecto','',0.00000000,'','','20159473148','','(1)5132000','','pesquera@diamante.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'ACC97','CREDIBOLSA SOCIEDAD AGENTE DE BOLSA S.A.',0,'Prospecto','',0.00000000,'','','20101031340','','(1)3132916','','credibolsa@bcp.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'ACC98','EL PACIFICO VIDA CIA. DE SEGUROS Y REASEGUROS S.A.',0,'Prospecto','',0.00000000,'','','20332970411','','(1)5184500','','pacifico@vida.com.pe','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'ACC99','CEMENTOS PACASMAYO S.A.A.',0,'Prospecto','',0.00000000,'','','20419387658','','(1)3176000','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,'ACC100','Pacasmayo Unidad Ica',0,'Prospecto','',0.00000000,'','','10083179550','','2345678','23435679','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,NULL,NULL),(102,'ACC101','ABC SA',0,'Prospecto','',0.00000000,'','','10083179550','','2430000','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'ACC102','LIMBA SERVICES S.A.C.',0,'Prospecto','',0.00000000,'','','20605524126','','','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'ACC103','SOCIEDAD ELECTRICA DEL SUR OESTE SA',0,'Prospecto','',0.00000000,'','','20100188628','','','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'ACC104','AJEPER S. A.',0,'Prospecto','',0.00000000,'','','20331061655','','','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'ACC105','UNIVERSIDAD TECNOLOGICA DEL PERU S.A.C.',0,'Prospecto','',0.00000000,'','','20462509236','','','','','','','',0,'0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `vtiger_accountbillads`
--

CREATE TABLE `vtiger_accountbillads` (
  `accountaddressid` int(19) NOT NULL DEFAULT 0,
  `bill_city` varchar(30) DEFAULT NULL,
  `bill_code` varchar(30) DEFAULT NULL,
  `bill_country` varchar(30) DEFAULT NULL,
  `bill_state` varchar(30) DEFAULT NULL,
  `bill_street` varchar(250) DEFAULT NULL,
  `bill_pobox` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`accountaddressid`),
  CONSTRAINT `fk_1_vtiger_accountbillads` FOREIGN KEY (`accountaddressid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_accountbillads`
--

INSERT INTO `vtiger_accountbillads` VALUES (2,'','','','','',''),(3,'','','','','',''),(4,'','','','','',''),(5,'','','','','',''),(6,'','','','','',''),(7,'','','','','',''),(8,'','','','','',''),(9,'','','','','',''),(10,'','','','','',''),(11,'','','','','',''),(12,'','','','','',''),(13,'','','','','',''),(14,'','','','','',''),(15,'','','','','',''),(16,'','','','','',''),(17,'','','','','',''),(18,'','','','','',''),(19,'','','','','',''),(20,'','','','','',''),(21,'','','','','',''),(22,'','','','','',''),(23,'','','','','',''),(24,'','','','','',''),(25,'','','','','',''),(26,'','','','','',''),(27,'','','','','',''),(28,'','','','','',''),(29,'','','','','',''),(30,'','','','','',''),(31,'','','','','',''),(32,'','','','','',''),(33,'','','','','',''),(34,'','','','','',''),(35,'','','','','',''),(36,'','','','','',''),(37,'','','','','',''),(38,'','','','','',''),(39,'','','','','',''),(40,'','','','','',''),(41,'','','','','',''),(42,'','','','','',''),(43,'','','','','',''),(44,'','','','','',''),(45,'','','','','',''),(46,'','','','','',''),(47,'','','','','',''),(48,'','','','','',''),(49,'','','','','',''),(50,'','','','','',''),(51,'','','','','',''),(52,'','','','','',''),(53,'','','','','',''),(54,'','','','','',''),(55,'','','','','',''),(56,'','','','','',''),(57,'','','','','',''),(58,'','','','','',''),(59,'','','','','',''),(60,'','','','','',''),(61,'','','','','',''),(62,'','','','','',''),(63,'','','','','',''),(64,'','','','','',''),(65,'','','','','',''),(66,'','','','','',''),(67,'','','','','',''),(68,'','','','','',''),(69,'','','','','',''),(70,'','','','','',''),(71,'','','','','',''),(72,'','','','','',''),(73,'','','','','',''),(74,'','','','','',''),(75,'','','','','',''),(76,'','','','','',''),(77,'','','','','',''),(78,'','','','','',''),(79,'','','','','',''),(80,'','','','','',''),(81,'','','','','',''),(82,'','','','','',''),(83,'','','','','',''),(84,'','','','','',''),(85,'','','','','',''),(86,'','','','','',''),(87,'','','','','',''),(88,'','','','','',''),(89,'','','','','',''),(90,'','','','','',''),(91,'','','','','',''),(92,'','','','','',''),(93,'','','','','',''),(94,'','','','','',''),(95,'','','','','',''),(96,'','','','','',''),(97,'','','','','',''),(98,'','','','','',''),(99,'','','','','',''),(100,'','','','','',''),(101,'','','','','',''),(102,'','','','','',''),(103,'','','','','',''),(104,'','','','','',''),(105,'','','','','',''),(106,'','','','','','');

--
-- Table structure for table `vtiger_accountrating`
--

CREATE TABLE `vtiger_accountrating` (
  `accountratingid` int(19) NOT NULL AUTO_INCREMENT,
  `rating` varchar(200) NOT NULL,
  `sortorderid` int(19) NOT NULL DEFAULT 0,
  `presence` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`accountratingid`),
  UNIQUE KEY `accountrating_rating_idx` (`rating`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_accountrating`
--


--
-- Table structure for table `vtiger_accountscf`
--

CREATE TABLE `vtiger_accountscf` (
  `accountid` int(19) NOT NULL DEFAULT 0,
  PRIMARY KEY (`accountid`),
  CONSTRAINT `fk_1_vtiger_accountscf` FOREIGN KEY (`accountid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_accountscf`
--

INSERT INTO `vtiger_accountscf` VALUES (2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),(41),(42),(43),(44),(45),(46),(47),(48),(49),(50),(51),(52),(53),(54),(55),(56),(57),(58),(59),(60),(61),(62),(63),(64),(65),(66),(67),(68),(69),(70),(71),(72),(73),(74),(75),(76),(77),(78),(79),(80),(81),(82),(83),(84),(85),(86),(87),(88),(89),(90),(91),(92),(93),(94),(95),(96),(97),(98),(99),(100),(101),(102),(103),(104),(105),(106);

--
-- Table structure for table `vtiger_accountshipads`
--

CREATE TABLE `vtiger_accountshipads` (
  `accountaddressid` int(19) NOT NULL DEFAULT 0,
  `ship_city` varchar(30) DEFAULT NULL,
  `ship_code` varchar(30) DEFAULT NULL,
  `ship_country` varchar(30) DEFAULT NULL,
  `ship_state` varchar(30) DEFAULT NULL,
  `ship_pobox` varchar(30) DEFAULT NULL,
  `ship_street` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`accountaddressid`),
  CONSTRAINT `fk_1_vtiger_accountshipads` FOREIGN KEY (`accountaddressid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_accountshipads`
--

INSERT INTO `vtiger_accountshipads` VALUES (2,'','','','','',''),(3,'','','','','',''),(4,'','','','','',''),(5,'','','','','',''),(6,'','','','','',''),(7,'','','','','',''),(8,'','','','','',''),(9,'','','','','',''),(10,'','','','','',''),(11,'','','','','',''),(12,'','','','','',''),(13,'','','','','',''),(14,'','','','','',''),(15,'','','','','',''),(16,'','','','','',''),(17,'','','','','',''),(18,'','','','','',''),(19,'','','','','',''),(20,'','','','','',''),(21,'','','','','',''),(22,'','','','','',''),(23,'','','','','',''),(24,'','','','','',''),(25,'','','','','',''),(26,'','','','','',''),(27,'','','','','',''),(28,'','','','','',''),(29,'','','','','',''),(30,'','','','','',''),(31,'','','','','',''),(32,'','','','','',''),(33,'','','','','',''),(34,'','','','','',''),(35,'','','','','',''),(36,'','','','','',''),(37,'','','','','',''),(38,'','','','','',''),(39,'','','','','',''),(40,'','','','','',''),(41,'','','','','',''),(42,'','','','','',''),(43,'','','','','',''),(44,'','','','','',''),(45,'','','','','',''),(46,'','','','','',''),(47,'','','','','',''),(48,'','','','','',''),(49,'','','','','',''),(50,'','','','','',''),(51,'','','','','',''),(52,'','','','','',''),(53,'','','','','',''),(54,'','','','','',''),(55,'','','','','',''),(56,'','','','','',''),(57,'','','','','',''),(58,'','','','','',''),(59,'','','','','',''),(60,'','','','','',''),(61,'','','','','',''),(62,'','','','','',''),(63,'','','','','',''),(64,'','','','','',''),(65,'','','','','',''),(66,'','','','','',''),(67,'','','','','',''),(68,'','','','','',''),(69,'','','','','',''),(70,'','','','','',''),(71,'','','','','',''),(72,'','','','','',''),(73,'','','','','',''),(74,'','','','','',''),(75,'','','','','',''),(76,'','','','','',''),(77,'','','','','',''),(78,'','','','','',''),(79,'','','','','',''),(80,'','','','','',''),(81,'','','','','',''),(82,'','','','','',''),(83,'','','','','',''),(84,'','','','','',''),(85,'','','','','',''),(86,'','','','','',''),(87,'','','','','',''),(88,'','','','','',''),(89,'','','','','',''),(90,'','','','','',''),(91,'','','','','',''),(92,'','','','','',''),(93,'','','','','',''),(94,'','','','','',''),(95,'','','','','',''),(96,'','','','','',''),(97,'','','','','',''),(98,'','','','','',''),(99,'','','','','',''),(100,'','','','','',''),(101,'','','','','',''),(102,'','','','','',''),(103,'','','','','',''),(104,'','','','','',''),(105,'','','','','',''),(106,'','','','','','');

--
-- Table structure for table `vtiger_accounttype`
--

CREATE TABLE `vtiger_accounttype` (
  `accounttypeid` int(19) NOT NULL AUTO_INCREMENT,
  `accounttype` varchar(200) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT 1,
  `picklist_valueid` int(19) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`accounttypeid`),
  UNIQUE KEY `accounttype_accounttype_idx` (`accounttype`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_accounttype`
--

INSERT INTO `vtiger_accounttype` VALUES (2,'Analyst',1,2,1,NULL),(3,'Competitor',1,3,6,NULL),(4,'Customer',1,4,8,NULL),(5,'Integrator',1,5,5,NULL),(6,'Investor',1,6,10,NULL),(7,'Partner',1,7,11,NULL),(8,'Press',1,8,9,NULL),(9,'-Ninguno-',1,9,3,'#ffffff'),(10,'Reseller',1,10,2,NULL),(11,'Other',1,11,12,NULL),(12,'Cliente',1,305,7,NULL),(13,'Prospecto',1,306,4,NULL);

--
-- Table structure for table `vtiger_accounttype_seq`
--

CREATE TABLE `vtiger_accounttype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_accounttype_seq`
--

INSERT INTO `vtiger_accounttype_seq` VALUES (13);

--
-- Table structure for table `vtiger_actionmapping`
--

CREATE TABLE `vtiger_actionmapping` (
  `actionid` int(19) NOT NULL,
  `actionname` varchar(200) NOT NULL,
  `securitycheck` int(19) DEFAULT NULL,
  PRIMARY KEY (`actionid`,`actionname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_actionmapping`
--

INSERT INTO `vtiger_actionmapping` VALUES (0,'Save',0),(0,'SavePriceBook',1),(0,'SaveVendor',1),(1,'DetailViewAjax',1),(1,'EditView',0),(1,'PriceBookEditView',1),(1,'QuickCreate',1),(1,'VendorEditView',1),(2,'Delete',0),(2,'DeletePriceBook',1),(2,'DeleteVendor',1),(3,'index',0),(3,'Popup',1),(4,'DetailView',0),(4,'PriceBookDetailView',1),(4,'TagCloud',1),(4,'VendorDetailView',1),(5,'Import',0),(6,'Export',0),(7,'CreateView',0),(8,'Merge',0),(9,'ConvertLead',0),(10,'DuplicatesHandling',0),(11,'ReceiveIncomingCalls',0),(12,'MakeOutgoingCalls',0),(13,'Print',0);

--
-- Table structure for table `vtiger_activity`
--

CREATE TABLE `vtiger_activity` (
  `activityid` int(19) NOT NULL DEFAULT 0,
  `subject` varchar(255) DEFAULT NULL,
  `semodule` varchar(20) DEFAULT NULL,
  `activitytype` varchar(200) NOT NULL,
  `date_start` date NOT NULL,
  `due_date` date DEFAULT NULL,
  `time_start` varchar(50) DEFAULT NULL,
  `time_end` varchar(50) DEFAULT NULL,
  `sendnotification` varchar(3) NOT NULL DEFAULT '0',
  `duration_hours` varchar(200) DEFAULT NULL,
  `duration_minutes` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `eventstatus` varchar(200) DEFAULT NULL,
  `priority` varchar(200) DEFAULT NULL,
  `location` varchar(150) DEFAULT NULL,
  `notime` varchar(3) NOT NULL DEFAULT '0',
  `visibility` varchar(50) NOT NULL DEFAULT 'all',
  `recurringtype` varchar(200) DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`activityid`),
  KEY `activity_activityid_subject_idx` (`activityid`,`subject`),
  KEY `activity_activitytype_date_start_idx` (`activitytype`,`date_start`),
  KEY `activity_date_start_due_date_idx` (`date_start`,`due_date`),
  KEY `activity_date_start_time_start_idx` (`date_start`,`time_start`),
  KEY `activity_eventstatus_idx` (`eventstatus`),
  KEY `activity_status_idx` (`status`),
  CONSTRAINT `fk_1_vtiger_activity` FOREIGN KEY (`activityid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activity`
--

INSERT INTO `vtiger_activity` VALUES (673,'Fwd: TEST','','Emails','2024-07-06',NULL,'06:46',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(723,'hola',NULL,'Call','2024-07-12','2024-07-12','17:00:00','19:00:00','0','2','0',NULL,'Planned','','','0','Public','',''),(724,'chamo',NULL,'Call','2024-07-12','2024-07-12','05:00:00','05:05:00','0','0','5',NULL,'Planned','','','0','Public','',''),(725,'chamo 2',NULL,'Call','2024-07-12','2024-07-12','16:23:00','18:00:00','0','1','37',NULL,'Planned','','','0','Public','',''),(726,'chamo 3',NULL,'Call','2024-07-12','2024-07-12','16:25:00','16:30:00','0','0','5',NULL,'Planned','','','0','Public','',''),(727,'chamo 5',NULL,'Call','2024-07-12','2024-07-13','21:00:00','01:53:00','0','4','53',NULL,'Planned','','','0','Public','',''),(751,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(752,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(753,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(754,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(755,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(756,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:03',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(757,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(758,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(759,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(760,'Regarding Contact Assignment','','Emails','2024-07-18',NULL,'17:10:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(768,'Regarding Potential Assignment','','Emails','2024-07-30',NULL,'21:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(769,'Regarding Contact Assignment','','Emails','2024-07-30',NULL,'21:30:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(770,'Regarding Contact Assignment','','Emails','2024-07-30',NULL,'21:30:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(771,'Regarding Contact Assignment','','Emails','2024-07-30',NULL,'21:30:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(773,'Llamada de seguimiento para saber su compromiso de pago',NULL,'Call','2024-08-09','2024-08-09','16:00:00','16:30:00','0','0','30',NULL,'Planned','','','0','Public','',''),(775,'Regarding Contact Assignment','','Emails','2024-08-09',NULL,'14:30:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(776,'Visita Guiada al Colegio',NULL,'Meeting','2024-08-14','2024-08-14','15:00:00','15:30:00','0','0','30',NULL,'Planned','','','0','Public','',''),(778,'Regarding Potential Assignment','','Emails','2024-08-14',NULL,'14:46:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(780,'Seguimiento a matricula',NULL,'Call','2024-08-15','2024-08-15','14:49:00','14:54:00','0','0','5',NULL,'Planned','','','0','Public','',''),(787,'Ticket Number : TT1 Introducing Our Enhanced CRMTiger Mobile App for vTiger Version 8.x','','Emails','2024-08-21',NULL,'16:40:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,'');

--
-- Table structure for table `vtiger_activity_recurring_info`
--

CREATE TABLE `vtiger_activity_recurring_info` (
  `activityid` int(19) NOT NULL,
  `recurrenceid` int(19) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activity_recurring_info`
--


--
-- Table structure for table `vtiger_activity_reminder`
--

CREATE TABLE `vtiger_activity_reminder` (
  `activity_id` int(11) NOT NULL,
  `reminder_time` int(11) NOT NULL,
  `reminder_sent` int(2) NOT NULL,
  `recurringid` int(19) NOT NULL,
  PRIMARY KEY (`activity_id`,`recurringid`),
  CONSTRAINT `fk_activityid_vtiger_activity_reminder` FOREIGN KEY (`activity_id`) REFERENCES `vtiger_activity` (`activityid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activity_reminder`
--

INSERT INTO `vtiger_activity_reminder` VALUES (723,0,0,0),(724,0,0,0),(725,0,0,0),(726,0,0,0),(727,0,0,0),(773,0,0,0),(776,0,0,0),(780,0,0,0);

--
-- Table structure for table `vtiger_activity_reminder_popup`
--

CREATE TABLE `vtiger_activity_reminder_popup` (
  `reminderid` int(19) NOT NULL AUTO_INCREMENT,
  `semodule` varchar(100) NOT NULL,
  `recordid` int(19) NOT NULL,
  `date_start` date NOT NULL,
  `time_start` varchar(100) NOT NULL,
  `status` int(2) NOT NULL,
  PRIMARY KEY (`reminderid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activity_reminder_popup`
--

INSERT INTO `vtiger_activity_reminder_popup` VALUES (1,'Events',723,'2024-07-12','17:00:00',0),(2,'Events',727,'2024-07-12','21:00:00',1),(3,'Events',773,'2024-08-09','16:00:00',1),(4,'Events',776,'2024-08-14','15:00:00',1),(5,'Events',780,'2024-08-15','14:49:00',0);

--
-- Table structure for table `vtiger_activity_view`
--

CREATE TABLE `vtiger_activity_view` (
  `activity_viewid` int(19) NOT NULL AUTO_INCREMENT,
  `activity_view` varchar(200) NOT NULL,
  `sortorderid` int(19) NOT NULL DEFAULT 0,
  `presence` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`activity_viewid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activity_view`
--

INSERT INTO `vtiger_activity_view` VALUES (1,'Today',0,1),(2,'This Week',1,1),(3,'This Month',2,1),(4,'This Year',3,1),(5,'Agenda',4,1);

--
-- Table structure for table `vtiger_activity_view_seq`
--

CREATE TABLE `vtiger_activity_view_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activity_view_seq`
--

INSERT INTO `vtiger_activity_view_seq` VALUES (5);

--
-- Table structure for table `vtiger_activitycf`
--

CREATE TABLE `vtiger_activitycf` (
  `activityid` int(19) NOT NULL DEFAULT 0,
  PRIMARY KEY (`activityid`),
  CONSTRAINT `fk_activityid_vtiger_activitycf` FOREIGN KEY (`activityid`) REFERENCES `vtiger_activity` (`activityid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activitycf`
--

INSERT INTO `vtiger_activitycf` VALUES (723),(724),(725),(726),(727),(773),(776),(780);

--
-- Table structure for table `vtiger_activityproductrel`
--

CREATE TABLE `vtiger_activityproductrel` (
  `activityid` int(19) NOT NULL DEFAULT 0,
  `productid` int(19) NOT NULL DEFAULT 0,
  PRIMARY KEY (`activityid`,`productid`),
  KEY `activityproductrel_activityid_idx` (`activityid`),
  KEY `activityproductrel_productid_idx` (`productid`),
  CONSTRAINT `fk_2_vtiger_activityproductrel` FOREIGN KEY (`productid`) REFERENCES `vtiger_products` (`productid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activityproductrel`
--


--
-- Table structure for table `vtiger_activitytype`
--

CREATE TABLE `vtiger_activitytype` (
  `activitytypeid` int(19) NOT NULL AUTO_INCREMENT,
  `activitytype` varchar(200) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT 1,
  `picklist_valueid` int(19) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`activitytypeid`),
  UNIQUE KEY `activitytype_activitytype_idx` (`activitytype`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activitytype`
--

INSERT INTO `vtiger_activitytype` VALUES (1,'Call',0,12,0,NULL),(2,'Meeting',0,13,1,NULL),(3,'Mobile Call',0,295,1,NULL);

--
-- Table structure for table `vtiger_activitytype_seq`
--

CREATE TABLE `vtiger_activitytype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activitytype_seq`
--

INSERT INTO `vtiger_activitytype_seq` VALUES (3);

--
-- Table structure for table `vtiger_announcement`
--

CREATE TABLE `vtiger_announcement` (
  `creatorid` int(19) NOT NULL,
  `announcement` text DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`creatorid`),
  KEY `announcement_creatorid_idx` (`creatorid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_announcement`
--


--
-- Table structure for table `vtiger_app2tab`
--

CREATE TABLE `vtiger_app2tab` (
  `tabid` int(11) DEFAULT NULL,
  `appname` varchar(20) DEFAULT NULL,
  `sequence` int(19) DEFAULT NULL,
  `visible` int(3) DEFAULT 1,
  KEY `vtiger_app2tab_fk_tab` (`tabid`),
  CONSTRAINT `vtiger_app2tab_fk_tab` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_app2tab`
--

INSERT INTO `vtiger_app2tab` VALUES (31,'SUPPORT',3,1),(32,'INVENTORY',2,1),(37,'TOOLS',5,1),(39,'TOOLS',4,1),(45,'TOOLS',1,1),(49,'SETTINGS',1,1),(2,'SALES',1,1),(20,'SALES',2,1),(4,'SALES',6,1),(6,'SALES',7,1),(14,'SALES',3,1),(32,'SALES',4,1),(4,'MARKETING',3,1),(6,'MARKETING',4,1),(7,'MARKETING',2,1),(26,'MARKETING',1,1),(4,'INVENTORY',8,1),(6,'INVENTORY',9,1),(22,'INVENTORY',5,1),(23,'INVENTORY',4,1),(14,'INVENTORY',1,1),(18,'INVENTORY',7,1),(19,'INVENTORY',3,1),(21,'INVENTORY',6,1),(4,'SUPPORT',6,1),(6,'SUPPORT',7,1),(13,'SUPPORT',1,1),(15,'SUPPORT',2,1),(46,'SUPPORT',4,1),(44,'PROJECT',1,1),(43,'PROJECT',2,1),(42,'PROJECT',3,1),(4,'PROJECT',4,1),(6,'PROJECT',5,1),(47,'SALES',5,1),(47,'SUPPORT',5,1),(24,'TOOLS',2,1),(27,'TOOLS',3,1),(58,'TOOLS',6,1),(60,'COBRANZAS',3,1),(4,'COBRANZAS',2,1),(6,'COBRANZAS',1,1),(61,'COBRANZAS',4,1),(62,'SALES',8,1),(64,'SALES',9,1);

--
-- Table structure for table `vtiger_assets`
--

CREATE TABLE `vtiger_assets` (
  `assetsid` int(11) NOT NULL,
  `asset_no` varchar(30) NOT NULL,
  `account` int(19) DEFAULT NULL,
  `product` int(19) NOT NULL,
  `serialnumber` varchar(200) DEFAULT NULL,
  `datesold` date DEFAULT NULL,
  `dateinservice` date DEFAULT NULL,
  `assetstatus` varchar(200) DEFAULT 'In Service',
  `tagnumber` varchar(300) DEFAULT NULL,
  `invoiceid` int(19) DEFAULT NULL,
  `shippingmethod` varchar(200) DEFAULT NULL,
  `shippingtrackingnumber` varchar(200) DEFAULT NULL,
  `assetname` varchar(100) DEFAULT NULL,
  `contact` int(19) DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`assetsid`),
  CONSTRAINT `fk_1_vtiger_assets` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_assets`
--


--
-- Table structure for table `vtiger_assetscf`
--

CREATE TABLE `vtiger_assetscf` (
  `assetsid` int(19) NOT NULL,
  PRIMARY KEY (`assetsid`),
  CONSTRAINT `fk_assetsid_vtiger_assetscf` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_assets` (`assetsid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_assetscf`
--


--
-- Table structure for table `vtiger_assetstatus`
--

CREATE TABLE `vtiger_assetstatus` (
  `assetstatusid` int(11) NOT NULL AUTO_INCREMENT,
  `assetstatus` varchar(200) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`assetstatusid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_assetstatus`
--

INSERT INTO `vtiger_assetstatus` VALUES (1,'In Service',1,286,1,NULL),(2,'Out-of-service',1,287,2,NULL);

--
-- Table structure for table `vtiger_assetstatus_seq`
--

CREATE TABLE `vtiger_assetstatus_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_assetstatus_seq`
--

INSERT INTO `vtiger_assetstatus_seq` VALUES (2);

--
-- Table structure for table `vtiger_asterisk`
--

CREATE TABLE `vtiger_asterisk` (
  `server` varchar(30) DEFAULT NULL,
  `port` varchar(30) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `version` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_asterisk`
--


--
-- Table structure for table `vtiger_asteriskextensions`
--

CREATE TABLE `vtiger_asteriskextensions` (
  `userid` int(11) DEFAULT NULL,
  `asterisk_extension` varchar(50) DEFAULT NULL,
  `use_asterisk` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_asteriskextensions`
--

INSERT INTO `vtiger_asteriskextensions` VALUES (1,NULL,NULL),(5,NULL,NULL),(6,NULL,NULL),(7,NULL,NULL),(8,NULL,NULL),(9,NULL,NULL);

--
-- Table structure for table `vtiger_asteriskincomingcalls`
--

CREATE TABLE `vtiger_asteriskincomingcalls` (
  `from_number` varchar(50) DEFAULT NULL,
  `from_name` varchar(50) DEFAULT NULL,
  `to_number` varchar(50) DEFAULT NULL,
  `callertype` varchar(30) DEFAULT NULL,
  `flag` int(19) DEFAULT NULL,
  `timer` int(19) DEFAULT NULL,
  `refuid` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_asteriskincomingcalls`
--


--
-- Table structure for table `vtiger_asteriskincomingevents`
--

CREATE TABLE `vtiger_asteriskincomingevents` (
  `uid` varchar(255) NOT NULL,
  `channel` varchar(100) DEFAULT NULL,
  `from_number` bigint(20) DEFAULT NULL,
  `from_name` varchar(100) DEFAULT NULL,
  `to_number` bigint(20) DEFAULT NULL,
  `callertype` varchar(100) DEFAULT NULL,
  `timer` int(20) DEFAULT NULL,
  `flag` varchar(3) DEFAULT NULL,
  `pbxrecordid` int(19) DEFAULT NULL,
  `relcrmid` int(19) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_asteriskincomingevents`
--


--
-- Table structure for table `vtiger_attachments`
--

CREATE TABLE `vtiger_attachments` (
  `attachmentsid` int(19) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `path` text DEFAULT NULL,
  `storedname` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`attachmentsid`),
  KEY `attachments_attachmentsid_idx` (`attachmentsid`),
  CONSTRAINT `fk_1_vtiger_attachments` FOREIGN KEY (`attachmentsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_attachments`
--

INSERT INTO `vtiger_attachments` VALUES (451,'Max-R_Headshot_(1).jpg','','image/jpeg','storage/2024/June/week1/','a14cc4ce13945821ef025b509ea5027d.jpg',NULL),(658,'image001.png','image001.png','image/png','storage/2024/July/week1/',NULL,NULL),(659,'image002.png','image002.png','image/png','storage/2024/July/week1/',NULL,NULL),(660,'image003.jpg','image003.jpg','image/jpeg','storage/2024/July/week1/',NULL,NULL),(661,'image002.png','image002.png','image/png','storage/2024/July/week1/',NULL,NULL),(662,'logo.jpg','logo.jpg','image/jpeg','storage/2024/July/week1/',NULL,NULL),(663,'logo.jpg','logo.jpg','image/jpeg','storage/2024/July/week1/',NULL,NULL),(664,'logo.jpg','logo.jpg','image/jpeg','storage/2024/July/week1/',NULL,NULL),(665,'image001.jpg','image001.jpg','image/jpeg','storage/2024/July/week1/',NULL,NULL),(666,'image002.png','image002.png','image/png','storage/2024/July/week1/',NULL,NULL),(667,'image003.png','image003.png','image/png','storage/2024/July/week1/',NULL,NULL),(668,'image004.png','image004.png','image/png','storage/2024/July/week1/',NULL,NULL),(669,'image005.png','image005.png','image/png','storage/2024/July/week1/',NULL,NULL),(670,'image006.png','image006.png','image/png','storage/2024/July/week1/',NULL,NULL),(671,'image007.png','image007.png','image/png','storage/2024/July/week1/',NULL,NULL),(672,'image008.png','image008.png','image/png','storage/2024/July/week1/',NULL,NULL),(674,'image001.jpg','image001.jpg','image/jpeg','storage/2024/July/week1/',NULL,NULL),(676,'image002.png','image002.png','image/png','storage/2024/July/week1/',NULL,NULL),(678,'image003.png','image003.png','image/png','storage/2024/July/week1/',NULL,NULL),(680,'image004.png','image004.png','image/png','storage/2024/July/week1/',NULL,NULL),(682,'image005.png','image005.png','image/png','storage/2024/July/week1/',NULL,NULL),(684,'image006.png','image006.png','image/png','storage/2024/July/week1/',NULL,NULL),(686,'image007.png','image007.png','image/png','storage/2024/July/week1/',NULL,NULL),(688,'image008.png','image008.png','image/png','storage/2024/July/week1/',NULL,NULL),(764,'logo.jpg','logo.jpg','image/jpeg','storage/2024/July/week5/',NULL,NULL),(765,'logo.jpg','logo.jpg','image/jpeg','storage/2024/July/week5/',NULL,NULL),(766,'logo.jpg','logo.jpg','image/jpeg','storage/2024/July/week5/',NULL,NULL),(767,'logo.jpg','logo.jpg','image/jpeg','storage/2024/July/week5/',NULL,NULL),(781,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(782,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(783,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(784,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(785,'3683299876000.zip','3683299876000.zip','application/zip','storage/2024/August/week3/',NULL,NULL),(788,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(789,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(790,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(791,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week3/',NULL,NULL),(792,'3683299876000.zip','3683299876000.zip','application/zip','storage/2024/August/week3/',NULL,NULL),(793,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week4/',NULL,NULL),(794,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week4/',NULL,NULL),(795,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week4/',NULL,NULL),(796,'logo.jpg','logo.jpg','image/jpeg','storage/2024/August/week4/',NULL,NULL),(797,'3683299876000.zip','3683299876000.zip','application/zip','storage/2024/August/week4/',NULL,NULL);

--
-- Table structure for table `vtiger_attachmentsfolder`
--

CREATE TABLE `vtiger_attachmentsfolder` (
  `folderid` int(19) NOT NULL AUTO_INCREMENT,
  `foldername` varchar(200) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `createdby` int(19) NOT NULL,
  `sequence` int(19) DEFAULT NULL,
  PRIMARY KEY (`folderid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_attachmentsfolder`
--

INSERT INTO `vtiger_attachmentsfolder` VALUES (1,'Default','This is a Default Folder',1,1);

--
-- Table structure for table `vtiger_attachmentsfolder_seq`
--

CREATE TABLE `vtiger_attachmentsfolder_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_attachmentsfolder_seq`
--

INSERT INTO `vtiger_attachmentsfolder_seq` VALUES (1);

--
-- Table structure for table `vtiger_attendance_status`
--

CREATE TABLE `vtiger_attendance_status` (
  `attendance_statusid` int(11) NOT NULL AUTO_INCREMENT,
  `attendance_status` varchar(200) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`attendance_statusid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_attendance_status`
--

INSERT INTO `vtiger_attendance_status` VALUES (1,'check_in',1,326,1,NULL),(2,'check_out',1,327,2,NULL);

--
-- Table structure for table `vtiger_attendance_status_seq`
--

CREATE TABLE `vtiger_attendance_status_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_attendance_status_seq`
--

INSERT INTO `vtiger_attendance_status_seq` VALUES (2);

--
-- Table structure for table `vtiger_audit_trial`
--

CREATE TABLE `vtiger_audit_trial` (
  `auditid` int(19) NOT NULL,
  `userid` int(19) DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `recordid` varchar(20) DEFAULT NULL,
  `actiondate` datetime DEFAULT NULL,
  PRIMARY KEY (`auditid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_audit_trial`
--


--
-- Table structure for table `vtiger_blocks`
--

CREATE TABLE `vtiger_blocks` (
  `blockid` int(19) NOT NULL,
  `tabid` int(19) NOT NULL,
  `blocklabel` varchar(100) NOT NULL,
  `sequence` int(10) DEFAULT NULL,
  `show_title` int(2) DEFAULT NULL,
  `visible` int(2) NOT NULL DEFAULT 0,
  `create_view` int(2) NOT NULL DEFAULT 0,
  `edit_view` int(2) NOT NULL DEFAULT 0,
  `detail_view` int(2) NOT NULL DEFAULT 0,
  `display_status` int(1) NOT NULL DEFAULT 1,
  `iscustom` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`blockid`),
  UNIQUE KEY `name_block` (`tabid`,`blocklabel`),
  KEY `block_tabid_idx` (`tabid`),
  CONSTRAINT `fk_1_vtiger_blocks` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_blocks`
--

INSERT INTO `vtiger_blocks` VALUES (1,2,'LBL_OPPORTUNITY_INFORMATION',1,0,0,0,0,0,1,0),(2,2,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(3,2,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(4,4,'LBL_CONTACT_INFORMATION',1,0,0,0,0,0,1,0),(5,4,'LBL_CUSTOM_INFORMATION',6,0,0,0,0,0,1,0),(6,4,'LBL_CUSTOMER_PORTAL_INFORMATION',4,0,0,0,0,0,1,0),(7,4,'LBL_ADDRESS_INFORMATION',5,0,0,0,0,0,1,0),(8,4,'LBL_DESCRIPTION_INFORMATION',7,0,0,0,0,0,1,0),(9,6,'LBL_ACCOUNT_INFORMATION',1,0,0,0,0,0,1,0),(10,6,'LBL_CUSTOM_INFORMATION',5,0,0,0,0,0,1,0),(11,6,'LBL_ADDRESS_INFORMATION',6,0,0,0,0,0,1,0),(12,6,'LBL_DESCRIPTION_INFORMATION',7,0,0,0,0,0,1,0),(13,7,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(14,7,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(15,7,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(16,7,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(17,8,'LBL_NOTE_INFORMATION',1,0,0,0,0,0,1,0),(18,8,'LBL_FILE_INFORMATION',3,1,0,0,0,0,1,0),(19,9,'LBL_TASK_INFORMATION',1,0,0,0,0,0,1,0),(20,9,'LBL_DESCRIPTION_INFORMATION',3,1,0,0,0,0,1,0),(21,10,'LBL_EMAIL_INFORMATION',1,0,0,0,0,0,1,0),(22,10,'Emails_Block1',2,1,0,0,0,0,1,0),(23,10,'Emails_Block2',3,1,0,0,0,0,1,0),(24,10,'Emails_Block3',4,1,0,0,0,0,1,0),(25,13,'LBL_TICKET_INFORMATION',1,0,0,0,0,0,1,0),(26,13,'',4,1,0,0,0,0,1,0),(27,13,'LBL_CUSTOM_INFORMATION',4,0,0,0,0,0,1,0),(28,13,'LBL_DESCRIPTION_INFORMATION',2,0,0,0,0,0,1,0),(29,13,'LBL_TICKET_RESOLUTION',5,0,0,1,0,0,1,0),(30,13,'LBL_COMMENTS',8,0,0,1,0,0,1,0),(31,14,'LBL_PRODUCT_INFORMATION',1,0,0,0,0,0,1,0),(32,14,'LBL_PRICING_INFORMATION',2,0,0,0,0,0,1,0),(33,14,'LBL_STOCK_INFORMATION',3,0,0,0,0,0,1,0),(34,14,'LBL_CUSTOM_INFORMATION',4,0,0,0,0,0,1,0),(35,14,'LBL_IMAGE_INFORMATION',5,0,0,0,0,0,1,0),(36,14,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(37,15,'LBL_FAQ_INFORMATION',1,0,0,0,0,0,1,0),(38,15,'LBL_COMMENT_INFORMATION',4,0,0,1,0,0,1,0),(39,16,'LBL_EVENT_INFORMATION',1,0,0,0,0,0,1,0),(40,16,'LBL_REMINDER_INFORMATION',2,0,0,0,0,0,1,0),(41,16,'LBL_DESCRIPTION_INFORMATION',5,0,0,0,0,0,1,0),(42,18,'LBL_VENDOR_INFORMATION',1,0,0,0,0,0,1,0),(43,18,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(44,18,'LBL_VENDOR_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(45,18,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(46,19,'LBL_PRICEBOOK_INFORMATION',1,0,0,0,0,0,1,0),(47,19,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(48,19,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(49,20,'LBL_QUOTE_INFORMATION',1,0,0,0,0,0,1,0),(50,20,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(51,20,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(52,20,'LBL_RELATED_PRODUCTS',4,0,0,0,0,0,1,0),(53,20,'LBL_TERMS_INFORMATION',5,0,0,0,0,0,1,0),(54,20,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(55,21,'LBL_PO_INFORMATION',1,0,0,0,0,0,1,0),(56,21,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(57,21,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(58,21,'LBL_RELATED_PRODUCTS',4,0,0,0,0,0,1,0),(59,21,'LBL_TERMS_INFORMATION',5,0,0,0,0,0,1,0),(60,21,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(61,22,'LBL_SO_INFORMATION',1,0,0,0,0,0,1,0),(62,22,'LBL_CUSTOM_INFORMATION',3,0,0,0,0,0,1,0),(63,22,'LBL_ADDRESS_INFORMATION',4,0,0,0,0,0,1,0),(64,22,'LBL_RELATED_PRODUCTS',5,0,0,0,0,0,1,0),(65,22,'LBL_TERMS_INFORMATION',6,0,0,0,0,0,1,0),(66,22,'LBL_DESCRIPTION_INFORMATION',7,0,0,0,0,0,1,0),(67,23,'LBL_INVOICE_INFORMATION',1,0,0,0,0,0,1,0),(68,23,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(69,23,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(70,23,'LBL_RELATED_PRODUCTS',4,0,0,0,0,0,1,0),(71,23,'LBL_TERMS_INFORMATION',5,0,0,0,0,0,1,0),(72,23,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(73,4,'LBL_IMAGE_INFORMATION',8,0,0,0,0,0,1,0),(74,26,'LBL_CAMPAIGN_INFORMATION',1,0,0,0,0,0,1,0),(75,26,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(76,26,'LBL_EXPECTATIONS_AND_ACTUALS',3,0,0,0,0,0,1,0),(77,29,'LBL_USERLOGIN_ROLE',1,0,0,0,0,0,1,0),(78,29,'LBL_CURRENCY_CONFIGURATION',3,0,0,0,0,0,1,0),(79,29,'LBL_MORE_INFORMATION',4,0,0,0,0,0,1,0),(80,29,'LBL_ADDRESS_INFORMATION',5,0,0,0,0,0,1,0),(81,26,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(82,29,'LBL_USER_IMAGE_INFORMATION',5,0,0,0,0,0,1,0),(83,29,'LBL_USER_ADV_OPTIONS',6,0,0,0,0,0,1,0),(84,8,'LBL_DESCRIPTION',2,0,0,0,0,0,1,0),(85,22,'Recurring Invoice Information',2,0,0,0,0,0,1,0),(86,9,'LBL_CUSTOM_INFORMATION',4,0,0,0,0,0,1,0),(87,16,'LBL_CUSTOM_INFORMATION',6,0,0,0,0,0,1,0),(88,31,'LBL_SERVICE_CONTRACT_INFORMATION',1,0,0,0,0,0,1,0),(89,31,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(90,32,'LBL_SERVICE_INFORMATION',1,0,0,0,0,0,1,0),(91,32,'LBL_PRICING_INFORMATION',2,0,0,0,0,0,1,0),(92,32,'LBL_CUSTOM_INFORMATION',3,0,0,0,0,0,1,0),(93,32,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(94,37,'LBL_PBXMANAGER_INFORMATION',1,0,0,0,0,0,1,0),(95,38,'LBL_MODCOMMENTS_INFORMATION',1,0,0,0,0,0,1,0),(96,38,'LBL_OTHER_INFORMATION',2,0,0,0,0,0,1,0),(97,38,'LBL_CUSTOM_INFORMATION',3,0,0,0,0,0,1,0),(98,42,'LBL_PROJECT_MILESTONE_INFORMATION',1,0,0,0,0,0,1,0),(99,42,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(100,42,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(101,43,'LBL_PROJECT_TASK_INFORMATION',1,0,0,0,0,0,1,0),(102,43,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(103,43,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(104,44,'LBL_PROJECT_INFORMATION',1,0,0,0,0,0,1,0),(105,44,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(106,44,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(107,46,'LBL_ASSET_INFORMATION',1,0,0,0,0,0,1,0),(108,46,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(109,46,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(110,47,'LBL_SMSNOTIFIER_INFORMATION',1,0,0,0,0,0,1,0),(111,47,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(112,47,'StatusInformation',3,0,0,0,0,0,1,0),(113,23,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(114,22,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(115,21,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(116,20,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(117,16,'LBL_RECURRENCE_INFORMATION',3,0,0,0,0,0,1,0),(118,29,'LBL_CALENDAR_SETTINGS',2,0,0,0,0,0,1,0),(119,16,'LBL_RELATED_TO',4,0,0,0,0,0,1,0),(120,9,'LBL_REMINDER_INFORMATION',2,0,0,0,0,0,1,0),(121,2,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(122,3,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(123,4,'LBL_LEAD_INFORMATION',9,0,0,0,0,0,1,0),(124,6,'LBL_LEAD_INFORMATION',9,0,0,0,0,0,1,0),(126,8,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(127,9,'LBL_LEAD_INFORMATION',6,0,0,0,0,0,1,0),(128,10,'LBL_LEAD_INFORMATION',6,0,0,0,0,0,1,0),(129,13,'LBL_LEAD_INFORMATION',7,0,0,0,0,0,1,0),(130,14,'LBL_LEAD_INFORMATION',8,0,0,0,0,0,1,0),(131,15,'LBL_LEAD_INFORMATION',6,0,0,0,0,0,1,0),(132,16,'LBL_LEAD_INFORMATION',8,0,0,0,0,0,1,0),(133,18,'LBL_LEAD_INFORMATION',6,0,0,0,0,0,1,0),(134,19,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(135,20,'LBL_LEAD_INFORMATION',8,0,0,0,0,0,1,0),(136,21,'LBL_LEAD_INFORMATION',8,0,0,0,0,0,1,0),(137,22,'LBL_LEAD_INFORMATION',9,0,0,0,0,0,1,0),(138,23,'LBL_LEAD_INFORMATION',8,0,0,0,0,0,1,0),(139,24,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(140,25,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(141,26,'LBL_LEAD_INFORMATION',6,0,0,0,0,0,1,0),(142,27,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(143,28,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(144,29,'LBL_LEAD_INFORMATION',8,0,0,0,0,0,1,0),(145,30,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(146,31,'LBL_LEAD_INFORMATION',4,0,0,0,0,0,1,0),(147,32,'LBL_LEAD_INFORMATION',6,0,0,0,0,0,1,0),(148,33,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(149,34,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(150,35,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(151,36,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(152,37,'LBL_LEAD_INFORMATION',3,0,0,0,0,0,1,0),(153,38,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(154,39,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(155,40,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(156,41,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(157,42,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(158,43,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(159,44,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(160,45,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(161,46,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(162,47,'LBL_LEAD_INFORMATION',5,0,0,0,0,0,1,0),(163,48,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(164,49,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(166,52,'CTMobile Time Tracker Information',1,0,0,0,0,0,1,0),(167,53,'CTMobile Time Control Information',1,0,0,0,0,0,1,0),(168,54,'CTMobile RoutePlanning Information',1,0,0,0,0,0,1,0),(169,55,'CTMobile Attendance Information',1,0,0,0,0,0,1,0),(170,56,'CTMobile Attendance Information',1,0,0,0,0,0,1,0),(171,57,'CTMobile User Filter View Information',1,0,0,0,0,0,1,0),(172,58,'CTMobile Message Template',1,0,0,0,0,0,1,0),(173,59,'CTMobile Push Notification Information',1,0,0,0,0,0,1,0),(174,59,'Description',2,0,0,0,0,0,1,0),(221,50,'LBL_LEAD_INFORMATION',1,0,0,0,0,0,1,0),(222,51,'LBL_LEAD_INFORMATION',1,0,0,0,0,0,1,0),(223,52,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(224,53,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(225,54,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(226,55,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(227,56,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(228,57,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(229,58,'LBL_LEAD_INFORMATION',2,0,0,0,0,0,1,0),(230,59,'LBL_LEAD_INFORMATION',3,0,0,0,0,0,1,0),(235,60,'Encabezado de Factura',1,0,0,0,0,0,1,0),(237,60,'Detalles de Cobranza',3,0,0,0,0,0,1,1),(238,60,'Requisitos de Cobranza',5,0,0,0,0,0,1,1),(239,60,'Contacto de Cobranza',6,0,0,0,0,0,1,1),(240,60,'Información de Sistema',7,0,0,0,0,0,1,1),(242,13,'Atencion de Incidencia',3,0,0,0,0,0,1,1),(243,13,'Calidad de Servicio',6,0,0,0,0,0,1,1),(244,26,'Mailchimp',5,0,0,0,0,0,1,1),(245,4,'Informacion Laboral',3,0,0,0,0,0,1,1),(246,4,'Informacion de Segmentacion',2,0,0,0,0,0,1,1),(247,6,'Informacion de Segmentacion',4,0,0,0,0,0,1,1),(248,6,'Informacion Estrategica',3,0,0,0,0,0,1,1),(249,6,'Indicadores de Fidelizacion',2,0,0,0,0,0,1,1),(250,61,'Informacion general',1,0,0,0,0,0,1,0),(251,61,'Información de Sistema',3,0,0,0,0,0,1,1),(252,61,'Detalle del Pago',2,0,0,0,0,0,1,1),(253,62,'WhatsApp Msg Detail',1,0,0,0,0,0,1,0),(254,63,'WhatsApp Templates Information',1,0,0,0,0,0,1,0),(255,64,'WhatsAppLog Detail',1,0,0,0,0,0,1,0),(256,60,'Pagos Parciales',4,0,0,0,0,0,1,1),(257,60,'Gestión de la Cobranza',2,0,0,0,0,0,1,1);

--
-- Table structure for table `vtiger_blocks_seq`
--

CREATE TABLE `vtiger_blocks_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_blocks_seq`
--

INSERT INTO `vtiger_blocks_seq` VALUES (257);

--
-- Table structure for table `vtiger_calendar_default_activitytypes`
--

CREATE TABLE `vtiger_calendar_default_activitytypes` (
  `id` int(19) NOT NULL,
  `module` varchar(50) DEFAULT NULL,
  `fieldname` varchar(50) DEFAULT NULL,
  `defaultcolor` varchar(50) DEFAULT NULL,
  `isdefault` int(11) DEFAULT 1,
  `conditions` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_calendar_default_activitytypes`
--

INSERT INTO `vtiger_calendar_default_activitytypes` VALUES (1,'Events','[\"date_start\",\"due_date\"]','#17309A',1,''),(2,'Calendar','[\"date_start\",\"due_date\"]','#3A87AD',1,''),(3,'Potentials','[\"closingdate\"]','#AA6705',1,''),(4,'Contacts','[\"support_end_date\"]','#953B39',1,''),(5,'Contacts','[\"birthday\"]','#545252',1,''),(6,'Invoice','[\"duedate\"]','#87865D',1,''),(7,'Project','[\"startdate\",\"targetenddate\"]','#C71585',1,''),(8,'ProjectTask','[\"startdate\",\"enddate\"]','#006400',1,'');

--
-- Table structure for table `vtiger_calendar_default_activitytypes_seq`
--

CREATE TABLE `vtiger_calendar_default_activitytypes_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_calendar_default_activitytypes_seq`
--

INSERT INTO `vtiger_calendar_default_activitytypes_seq` VALUES (8);

--
-- Table structure for table `vtiger_calendar_user_activitytypes`
--

CREATE TABLE `vtiger_calendar_user_activitytypes` (
  `id` int(19) NOT NULL,
  `defaultid` int(19) DEFAULT NULL,
  `userid` int(19) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `visible` int(19) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_calendar_user_activitytypes`
--

INSERT INTO `vtiger_calendar_user_activitytypes` VALUES (1,1,1,'#17309A',1),(2,2,1,'#3A87AD',1),(3,3,1,'#AA6705',1),(4,4,1,'#953B39',1),(5,5,1,'#545252',1),(6,6,1,'#87865D',1),(7,7,1,'#C71585',1),(8,8,1,'#006400',1),(9,1,5,'#17309A',1),(10,2,5,'#3A87AD',1),(11,3,5,'#AA6705',1),(12,4,5,'#953B39',1),(13,5,5,'#545252',1),(14,6,5,'#87865D',1),(15,7,5,'#C71585',1),(16,8,5,'#006400',1),(17,1,6,'#17309A',1),(18,2,6,'#3A87AD',1),(19,3,6,'#AA6705',1),(20,4,6,'#953B39',1),(21,5,6,'#545252',1),(22,6,6,'#87865D',1),(23,7,6,'#C71585',1),(24,8,6,'#006400',1),(25,1,7,'#17309A',1),(26,2,7,'#3A87AD',1),(27,3,7,'#AA6705',1),(28,4,7,'#953B39',1),(29,5,7,'#545252',1),(30,6,7,'#87865D',1),(31,7,7,'#C71585',1),(32,8,7,'#006400',1),(33,1,8,'#17309A',1),(34,2,8,'#3A87AD',1),(35,3,8,'#AA6705',1),(36,4,8,'#953B39',1),(37,5,8,'#545252',1),(38,6,8,'#87865D',1),(39,7,8,'#C71585',1),(40,8,8,'#006400',1),(41,1,9,'#17309A',1),(42,2,9,'#3A87AD',1),(43,3,9,'#AA6705',1),(44,4,9,'#953B39',1),(45,5,9,'#545252',1),(46,6,9,'#87865D',1),(47,7,9,'#C71585',1),(48,8,9,'#006400',1);

--
-- Table structure for table `vtiger_calendar_user_activitytypes_seq`
--

CREATE TABLE `vtiger_calendar_user_activitytypes_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_calendar_user_activitytypes_seq`
--

INSERT INTO `vtiger_calendar_user_activitytypes_seq` VALUES (48);

--
-- Table structure for table `vtiger_calendarsharedtype`
--

CREATE TABLE `vtiger_calendarsharedtype` (
  `calendarsharedtypeid` int(11) NOT NULL AUTO_INCREMENT,
  `calendarsharedtype` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`calendarsharedtypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_calendarsharedtype`
--

INSERT INTO `vtiger_calendarsharedtype` VALUES (1,'public',0,1),(2,'private',1,1),(3,'seletedusers',2,1);

--
-- Table structure for table `vtiger_calendarsharedtype_seq`
--

CREATE TABLE `vtiger_calendarsharedtype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_calendarsharedtype_seq`
--

INSERT INTO `vtiger_calendarsharedtype_seq` VALUES (3);

--
-- Table structure for table `vtiger_callduration`
--

CREATE TABLE `vtiger_callduration` (
  `calldurationid` int(11) NOT NULL AUTO_INCREMENT,
  `callduration` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`calldurationid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_callduration`
--

INSERT INTO `vtiger_callduration` VALUES (1,'5',0,1),(2,'10',1,1),(3,'30',2,1),(4,'60',3,1),(5,'120',4,1);

--
-- Table structure for table `vtiger_callduration_seq`
--

CREATE TABLE `vtiger_callduration_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_callduration_seq`
--

INSERT INTO `vtiger_callduration_seq` VALUES (5);

--
-- Table structure for table `vtiger_campaign`
--

CREATE TABLE `vtiger_campaign` (
  `campaign_no` varchar(100) NOT NULL,
  `campaignname` varchar(255) DEFAULT NULL,
  `campaigntype` varchar(200) DEFAULT NULL,
  `campaignstatus` varchar(200) DEFAULT NULL,
  `expectedrevenue` decimal(25,8) DEFAULT NULL,
  `budgetcost` decimal(25,8) DEFAULT NULL,
  `actualcost` decimal(25,8) DEFAULT NULL,
  `expectedresponse` varchar(200) DEFAULT NULL,
  `numsent` decimal(11,0) DEFAULT NULL,
  `product_id` int(19) DEFAULT NULL,
  `sponsor` varchar(255) DEFAULT NULL,
  `targetaudience` varchar(255) DEFAULT NULL,
  `targetsize` int(19) DEFAULT NULL,
  `expectedresponsecount` int(19) DEFAULT NULL,
  `expectedsalescount` int(19) DEFAULT NULL,
  `expectedroi` decimal(25,8) DEFAULT NULL,
  `actualresponsecount` int(19) DEFAULT NULL,
  `actualsalescount` int(19) DEFAULT NULL,
  `actualroi` decimal(25,8) DEFAULT NULL,
  `campaignid` int(19) NOT NULL,
  `closingdate` date DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  `lb_mailchimplistid` text DEFAULT NULL,
  `lb_mailchimpcampaignid` text DEFAULT NULL,
  PRIMARY KEY (`campaignid`),
  KEY `campaign_campaignstatus_idx` (`campaignstatus`),
  KEY `campaign_campaignname_idx` (`campaignname`),
  KEY `campaign_campaignid_idx` (`campaignid`),
  CONSTRAINT `fk_crmid_vtiger_campaign` FOREIGN KEY (`campaignid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaign`
--

INSERT INTO `vtiger_campaign` VALUES ('CAM1','Difusion Computacion 2015 Cono Norte','Conferencia','Completed',0.00000000,0.00000000,0.00000000,'',0,0,'','Jovenes...',0,0,0,0.00000000,0,0,0.00000000,583,'2015-05-15','','',''),('CAM2','Difusion Administracion 2015 Cono Norte','Conferencia','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','Jovenes...',0,0,0,0.00000000,0,0,0.00000000,584,'2015-05-15','','',''),('CAM3','La chinita empresarial','Feria comercial','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','microempresas informales',0,0,0,0.00000000,0,0,0.00000000,585,'2015-05-29','','',''),('CAM4','Lanzamiento nueva linea','Mailing','Activo',0.00000000,0.00000000,0.00000000,'Excelente',3,0,'','Papas con niños de 2 años',100,0,12000,0.00000000,0,15000,0.00000000,586,'2015-05-29','','',''),('CAM5','Black cumple en el mes','Correo','Activo',0.00000000,0.00000000,0.00000000,'',0,0,'','blakc ....',0,0,0,0.00000000,0,0,0.00000000,587,'2015-06-30','','',''),('CAM6','Nueva linea de edredones','Mailing','Planeada',0.00000000,0.00000000,0.00000000,'Excelente',0,588,'','',100,0,0,0.00000000,0,0,0.00000000,589,'2015-08-28','','',''),('CAM7','Campaña DSV','Publicidad','Planeada',0.00000000,0.00000000,0.00000000,'',0,588,'','',0,0,0,0.00000000,0,0,0.00000000,590,'2015-12-03','','',''),('CAM8','LANZAMIENTO SEGURO INTER JR','Mailing','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','BLACK Y PLATINO',0,0,0,0.00000000,0,0,0.00000000,591,'2015-12-15','','',''),('CAM9','Lanzamiento Segmento Int','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,592,'2015-12-17','','',''),('CAM10','Lanzamiento Seguro Internacional CR','','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','Black y Platinum',0,0,0,0.00000000,0,0,0.00000000,593,'2015-12-03','','',''),('CAM11','Black Friday Seguros','Publicidad','',0.00000000,0.00000000,0.00000000,'Pobre',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,594,'2015-12-23','','',''),('CAM12','Lanzamiento Seguro Internacional ECAM','Publicidad','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','black y Platinum',0,0,0,0.00000000,0,0,0.00000000,595,'2015-12-10','','',''),('CAM13','Lanzamiento de segmento internacional','','',0.00000000,0.00000000,0.00000000,'',0,0,'','Black yPlatino',0,0,0,0.00000000,0,0,0.00000000,596,'2015-12-31','','',''),('CAM14','Lanzamiento seguro internacional KG','Publicidad','Planeada',0.00000000,0.00000000,0.00000000,'',0,597,'','Black y Platinium',0,0,0,0.00000000,0,0,0.00000000,598,'2016-01-29','','',''),('CAM15','segmento seguro internacional','Correo','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,599,'2015-12-03','','',''),('CAM16','lanzamiento segmento internacional','Correo','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,600,'2015-12-15','','',''),('CAM17','Conferencia sobre Tributacion NIIF','Conferencia','Planeada',0.00000000,0.00000000,0.00000000,'Excelente',0,0,'','gerentes de finanzas',20,0,120000,0.00000000,0,0,0.00000000,601,'2016-09-16','','',''),('CAM18','Lanzamiento de nueva version Contabilidad','Conferencia','Planeada',0.00000000,0.00000000,0.00000000,'Excelente',0,0,'','estudios contables',100,0,0,0.00000000,0,0,0.00000000,602,'2016-10-20','','',''),('CAM19','Gestion','','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,603,'2016-10-13','','',''),('CAM20','Visita a Norte Chico','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,12000,0.00000000,0,0,0.00000000,604,'2017-02-15','','',''),('CAM21','Lanzamiento de nueva linea de estufas','Correo','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,605,'2017-02-27','','',''),('CAM22','Diplomado Calidad 2017','Mailing','Planeada',0.00000000,0.00000000,0.00000000,'',0,606,'','Campaña Trimestre I',0,0,0,0.00000000,0,0,0.00000000,607,'2017-03-31','','',''),('CAM23','Vcacines de JUlio','','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,608,'2017-04-20','','',''),('CAM24','Motorshow 2017','','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','Clientes con antiguedad de 4 años',1000,350,300000,0.00000000,0,0,0.00000000,609,'2017-07-19','','',''),('CAM25','28 julio','Correo','Planeada',0.00000000,0.00000000,0.00000000,'Excelente',0,0,'','Fidelizacion de Black',0,0,0,0.00000000,0,0,0.00000000,610,'2017-07-19','','',''),('CAM26','Combo de paneles','Mailing','',0.00000000,0.00000000,0.00000000,'Buena',0,0,'propia','empresas de tecnologia',0,20,50000,0.00000000,0,0,0.00000000,611,'2018-06-30','','',''),('CAM27','Discos de almacenamiento','Telemarketing','',0.00000000,0.00000000,0.00000000,'Buena',0,0,'','empresas de tecnologia',0,0,60,0.00000000,0,0,0.00000000,612,'2018-06-30','','',''),('CAM28','Teclados inalambricos','Telemarketing','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,613,'2018-06-30','','',''),('CAM29','Campaña Black 630demo01','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,614,'2018-05-25','','ae5611e81c',''),('CAM30','Campaña venta Notebooks','Mailing','Activo',0.00000000,0.00000000,0.00000000,'Buena',20,0,'','empresas de tecnologia',0,16,12,0.00000000,0,0,0.00000000,615,'2018-06-30','','aec1524',''),('CAM31','pantallas led','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,616,'2018-05-31','','730504784b',''),('CAM32','Proyectores tamaño A','Mailing','',0.00000000,0.00000000,0.00000000,'Normal',0,617,'','empresas de comunicaciones',0,0,1000000,0.00000000,0,0,0.00000000,618,'2018-07-31','','',''),('CAM33','Lanzamiento Paneles Solares Tipo  A','Mailing','Activo',0.00000000,0.00000000,0.00000000,'Normal',0,619,'','todas las empresas que usen energia',0,0,200000,0.00000000,0,0,0.00000000,620,'2018-06-09','','contacto campaña paneles solares',''),('CAM34','celulares Z','Mailing','Activo',0.00000000,0.00000000,0.00000000,'',0,621,'','jovenes millenials',0,0,0,0.00000000,0,0,0.00000000,622,'2018-06-30','','',''),('CAM35','instalacion ISSO 090','Mailing','Activo',0.00000000,0.00000000,0.00000000,'Normal',20,623,'','pequeñas y medianas empresas',20,15,15,0.00000000,0,0,0.00000000,624,'2018-06-22','','',''),('CAM36','PRueba de Integracion demo630','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,625,'2018-06-20','','ef1f99068b',''),('CAM37','Prueba 2018-10-03','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,626,'2018-10-03','','798914f92b',''),('CAM38','Campaña de Halloween','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,627,'2018-10-11','','c24677bada',''),('CAM39','Promocion Pilot Sport','Programa de referidos','Planeada',0.00000000,0.00000000,0.00000000,'',0,628,'','Black',0,0,150000,0.00000000,0,130000,0.00000000,629,'2022-09-02','','',''),('CAM40','Lanzamiento de Centrifugas','Correo','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','Mineras',0,0,0,0.00000000,0,0,0.00000000,630,'2020-12-11','','',''),('CAM41','Regalo Black','','Completed',0.00000000,0.00000000,0.00000000,'',0,0,'','Segmento Black: activos',30,0,0,0.00000000,0,0,0.00000000,631,'2022-11-07','','aec1524',''),('CAM42','Feria Peru Digital','Feria comercial','Planeada',0.00000000,0.00000000,0.00000000,'Normal',0,0,'','Micro empresarios',300,0,15000,0.00000000,0,0,0.00000000,632,'2019-08-21','','',''),('CAM43','Leasing Vehiculos Set 2020','Banners','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,633,'2020-09-24','','',''),('CAM44','CAMPAÑA DE PRUEBA 02.06.2021','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,634,'2021-06-02','','926e475569',''),('CAM45','LISTA PUREBE','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,635,'2021-06-02','','5e93025adc',''),('CAM46','CAMPAÑA DE PRUEBA 03.06.2021','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,636,'2021-06-03','','a074378a08',''),('CAM47','CAMPAÑA DE PRUEBA 23.07.2021','','',0.00000000,0.00000000,0.00000000,'',0,0,'','',0,0,0,0.00000000,0,0,0.00000000,637,'2021-07-23','','0091615b0a',''),('CAM48','LT Gerentes Comerciales','Webinar','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','',300,100,0,0.00000000,0,0,0.00000000,638,'2022-03-25','','',''),('CAM49','Recuperacion de clientes segmento Black','Mailing','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','Clientes de alto valor que no compra ....',0,0,0,0.00000000,0,0,0.00000000,639,'2023-03-17','','',''),('CAM50','Promoción de puntas','Mailing','Planeada',0.00000000,0.00000000,0.00000000,'',0,0,'','Clientes actuales del sector minero',0,0,12000,0.00000000,0,0,0.00000000,640,'2023-04-30','','','');

--
-- Table structure for table `vtiger_campaignaccountrel`
--

CREATE TABLE `vtiger_campaignaccountrel` (
  `campaignid` int(19) DEFAULT NULL,
  `accountid` int(19) DEFAULT NULL,
  `campaignrelstatusid` int(19) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaignaccountrel`
--


--
-- Table structure for table `vtiger_campaigncontrel`
--

CREATE TABLE `vtiger_campaigncontrel` (
  `campaignid` int(19) NOT NULL DEFAULT 0,
  `contactid` int(19) NOT NULL DEFAULT 0,
  `campaignrelstatusid` int(19) NOT NULL DEFAULT 0,
  PRIMARY KEY (`campaignid`,`contactid`,`campaignrelstatusid`),
  KEY `campaigncontrel_contractid_idx` (`contactid`),
  CONSTRAINT `fk_2_vtiger_campaigncontrel` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaigncontrel`
--


--
-- Table structure for table `vtiger_campaignleadrel`
--

CREATE TABLE `vtiger_campaignleadrel` (
  `campaignid` int(19) NOT NULL DEFAULT 0,
  `leadid` int(19) NOT NULL DEFAULT 0,
  `campaignrelstatusid` int(19) NOT NULL DEFAULT 0,
  PRIMARY KEY (`campaignid`,`leadid`,`campaignrelstatusid`),
  KEY `campaignleadrel_leadid_campaignid_idx` (`leadid`,`campaignid`),
  CONSTRAINT `fk_2_vtiger_campaignleadrel` FOREIGN KEY (`leadid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaignleadrel`
--


--
-- Table structure for table `vtiger_campaignrelstatus`
--

CREATE TABLE `vtiger_campaignrelstatus` (
  `campaignrelstatusid` int(19) DEFAULT NULL,
  `campaignrelstatus` varchar(256) DEFAULT NULL,
  `sortorderid` int(19) DEFAULT NULL,
  `presence` int(19) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaignrelstatus`
--

INSERT INTO `vtiger_campaignrelstatus` VALUES (2,'Contacted - Successful',1,1,NULL),(3,'Contacted - Unsuccessful',2,1,NULL),(4,'Contacted - Never Contact Again',3,1,NULL);

--
-- Table structure for table `vtiger_campaignrelstatus_seq`
--

CREATE TABLE `vtiger_campaignrelstatus_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaignrelstatus_seq`
--

INSERT INTO `vtiger_campaignrelstatus_seq` VALUES (4);

--
-- Table structure for table `vtiger_campaignscf`
--

CREATE TABLE `vtiger_campaignscf` (
  `campaignid` int(19) NOT NULL DEFAULT 0,
  PRIMARY KEY (`campaignid`),
  CONSTRAINT `fk_1_vtiger_campaignscf` FOREIGN KEY (`campaignid`) REFERENCES `vtiger_campaign` (`campaignid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaignscf`
--

INSERT INTO `vtiger_campaignscf` VALUES (583),(584),(585),(586),(587),(589),(590),(591),(592),(593),(594),(595),(596),(598),(599),(600),(601),(602),(603),(604),(605),(607),(608),(609),(610),(611),(612),(613),(614),(615),(616),(618),(620),(622),(624),(625),(626),(627),(629),(630),(631),(632),(633),(634),(635),(636),(637),(638),(639),(640);

--
-- Table structure for table `vtiger_campaignstatus`
--

CREATE TABLE `vtiger_campaignstatus` (
  `campaignstatusid` int(19) NOT NULL AUTO_INCREMENT,
  `campaignstatus` varchar(200) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT 1,
  `picklist_valueid` int(19) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`campaignstatusid`),
  KEY `campaignstatus_campaignstatus_idx` (`campaignstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaignstatus`
--

INSERT INTO `vtiger_campaignstatus` VALUES (2,'Planning',1,15,1,NULL),(3,'Active',1,16,2,NULL),(4,'Inactive',1,17,3,NULL),(5,'Completed',1,18,4,NULL),(6,'Cancelled',1,19,5,NULL),(7,'Planeada',1,485,1,NULL),(8,'Activo',1,487,1,NULL);

--
-- Table structure for table `vtiger_campaignstatus_seq`
--

CREATE TABLE `vtiger_campaignstatus_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaignstatus_seq`
--

INSERT INTO `vtiger_campaignstatus_seq` VALUES (8);

--
-- Table structure for table `vtiger_campaigntype`
--

CREATE TABLE `vtiger_campaigntype` (
  `campaigntypeid` int(19) NOT NULL AUTO_INCREMENT,
  `campaigntype` varchar(200) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT 1,
  `picklist_valueid` int(19) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`campaigntypeid`),
  UNIQUE KEY `campaigntype_campaigntype_idx` (`campaigntype`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaigntype`
--

INSERT INTO `vtiger_campaigntype` VALUES (2,'Conference',1,21,1,NULL),(3,'Webinar',1,22,2,NULL),(4,'Trade Show',1,23,3,NULL),(5,'Public Relations',1,24,4,NULL),(6,'Partners',1,25,5,NULL),(7,'Referral Program',1,26,6,NULL),(8,'Advertisement',1,27,7,NULL),(9,'Banner Ads',1,28,8,NULL),(10,'Direct Mail',1,29,9,NULL),(11,'Email',1,30,10,NULL),(12,'Telemarketing',1,31,11,NULL),(13,'Others',1,32,12,NULL),(14,'Conferencia',1,484,1,NULL),(15,'Feria comercial',1,486,1,NULL),(16,'Mailing',1,488,1,NULL),(17,'Correo',1,490,1,NULL),(18,'Publicidad',1,491,1,NULL),(19,'Programa de referidos',1,495,1,NULL),(20,'Banners',1,496,1,NULL);

--
-- Table structure for table `vtiger_campaigntype_seq`
--

CREATE TABLE `vtiger_campaigntype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_campaigntype_seq`
--

INSERT INTO `vtiger_campaigntype_seq` VALUES (20);

--
-- Table structure for table `vtiger_carrier`
--

CREATE TABLE `vtiger_carrier` (
  `carrierid` int(19) NOT NULL AUTO_INCREMENT,
  `carrier` varchar(200) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT 1,
  `picklist_valueid` int(19) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`carrierid`),
  UNIQUE KEY `carrier_carrier_idx` (`carrier`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_carrier`
--

INSERT INTO `vtiger_carrier` VALUES (1,'FedEx',1,33,0,NULL),(2,'UPS',1,34,1,NULL),(3,'USPS',1,35,2,NULL),(4,'DHL',1,36,3,NULL),(5,'BlueDart',1,37,4,NULL);

--
-- Table structure for table `vtiger_carrier_seq`
--

CREATE TABLE `vtiger_carrier_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_carrier_seq`
--

INSERT INTO `vtiger_carrier_seq` VALUES (5);

--
-- Table structure for table `vtiger_cf_953`
--

CREATE TABLE `vtiger_cf_953` (
  `cf_953id` int(11) NOT NULL AUTO_INCREMENT,
  `cf_953` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`cf_953id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cf_953`
--

INSERT INTO `vtiger_cf_953` VALUES (1,'Gold',4,1,'#ffe600'),(2,'Silver',5,1,NULL),(3,'Platinum',3,1,'#e6e6e6'),(4,'Black',2,1,'#000000'),(5,'Ninguna',1,1,'#ffffff');

--
-- Table structure for table `vtiger_cf_953_seq`
--

CREATE TABLE `vtiger_cf_953_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cf_953_seq`
--

INSERT INTO `vtiger_cf_953_seq` VALUES (5);

--
-- Table structure for table `vtiger_cntactivityrel`
--

CREATE TABLE `vtiger_cntactivityrel` (
  `contactid` int(19) NOT NULL DEFAULT 0,
  `activityid` int(19) NOT NULL DEFAULT 0,
  PRIMARY KEY (`contactid`,`activityid`),
  KEY `cntactivityrel_contactid_idx` (`contactid`),
  KEY `cntactivityrel_activityid_idx` (`activityid`),
  CONSTRAINT `fk_2_vtiger_cntactivityrel` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cntactivityrel`
--

INSERT INTO `vtiger_cntactivityrel` VALUES (170,776);

--
-- Table structure for table `vtiger_cobranzas`
--

CREATE TABLE `vtiger_cobranzas` (
  `cobranzasid` int(11) NOT NULL,
  `cobranzasno` varchar(100) DEFAULT NULL,
  `cobranzas_tks_dummy` varchar(50) DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  `lb_razonsocial` text DEFAULT NULL,
  `lb_numerofactura` text DEFAULT NULL,
  `lb_fechaemision` date DEFAULT NULL,
  `lb_fechadevencimiento` date DEFAULT NULL,
  `lb_montototal` decimal(25,8) DEFAULT NULL,
  `lb_diasvencidos` text DEFAULT NULL,
  `lb_conreclamos` int(1) DEFAULT NULL,
  `lb_estado` text DEFAULT NULL,
  `lb_etapa` text DEFAULT NULL,
  `lb_montofinalacordado` decimal(25,8) DEFAULT NULL,
  `lb_fechacompromisopa` date DEFAULT NULL,
  `lb_pagado` decimal(25,8) DEFAULT NULL,
  `lb_tipodepago` text DEFAULT NULL,
  `lb_motivopagoparcial` text DEFAULT NULL,
  `lb_cuerdodeagoarcial` text DEFAULT NULL,
  `lb_reportadoanfocorp` int(1) DEFAULT NULL,
  `lb_saldopag` decimal(25,8) DEFAULT NULL,
  `lb_requisitodepago` text DEFAULT NULL,
  `lb_diasdepago` text DEFAULT NULL,
  `lb_horarioss` time DEFAULT NULL,
  `lb_contactopag` text DEFAULT NULL,
  `lb_emailcxobra` varchar(100) DEFAULT NULL,
  `lb_telefonocobran` text DEFAULT NULL,
  `lb_activitirealizadacobran` text DEFAULT NULL,
  `lb_accionvocobran` text DEFAULT NULL,
  `lb_detalleccobran` text DEFAULT NULL,
  PRIMARY KEY (`cobranzasid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cobranzas`
--

INSERT INTO `vtiger_cobranzas` VALUES (452,'CO0000002','n01','',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(454,'CO0000001',NULL,'','104','N01','2024-06-12',NULL,0.00000000,'',0,'','',0.00000000,NULL,0.00000000,'','','',0,0.00000000,'','','00:00:00','','','',NULL,NULL,NULL),(456,'CO0000003',NULL,'','2','F3410019026','2024-01-29','2024-02-28',750.00000000,'128',0,'Pagado','',750.00000000,'2024-02-28',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','03:00:00','107','gventas@zapler.com','999999001',NULL,NULL,NULL),(457,'CO0000004',NULL,'','3','F3410019027','2024-02-12','2024-03-13',1344.00000000,'117',0,'En Seguimiento','',1344.00000000,'2024-03-13',0.00000000,'Efectivo','','',0,0.00000000,'-','Viernes, Sabado','05:00:00','108','osanchez@refineriala.com.pe','999999002',NULL,NULL,NULL),(458,'CO0000005',NULL,'','4','F3410019028','2024-05-08','2024-06-07',836.00000000,'0',0,'Pagado','',836.00000000,'2024-06-07',836.00000000,'Efectivo','','',0,0.00000000,'-','Viernes, Sabado','04:00:00','109','jrodriguez@southernper.com.pe','999999003',NULL,NULL,NULL),(459,'CO0000006',NULL,'','5','F3410019029','2024-04-12','2024-05-12',1262.00000000,'54',0,'Pagado','',1262.00000000,'2024-05-12',0.00000000,'Efectivo','','',0,0.00000000,'-','Lunes, Martes, Sabado','03:00:00','110','hperez@minerayanac.com.pe','999999004',NULL,NULL,NULL),(460,'CO0000007',NULL,'','6','F3410019030','2024-01-09','2024-02-08',1254.00000000,'148',0,'Pagado','',1254.00000000,'2024-02-08',1254.00000000,'Parcial','','',0,0.00000000,'-','Lunes, Martes, Sabado','05:00:00','111','fdiaz@cia.minera.com.pe','999999005',NULL,NULL,NULL),(461,'CO0000008',NULL,'','7','F3410019031','2024-03-01','2024-03-31',771.00000000,'0',0,'Pagado','',771.00000000,'2024-03-31',771.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','112','dpolo@sociedadmin.com.pe','999999006',NULL,NULL,NULL),(462,'CO0000009',NULL,'','8','F3140030904','2024-05-05','2024-06-04',1124.00000000,'0',0,'Pagado','',1124.00000000,'2024-06-04',1124.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','113','mmanzanares@bancodecre.com.pe','999999007',NULL,NULL,NULL),(463,'CO0000010',NULL,'','9','F4570001512','2024-01-04','2024-02-03',925.00000000,'0',0,'Pagado','',925.00000000,'2024-02-03',925.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','05:00:00','114','jrodriguez@segurosocia.com.pe','999999008',NULL,NULL,NULL),(464,'CO0000011',NULL,'','10','F3240039886','2024-03-22','2024-04-21',1406.00000000,'0',0,'Pagado','',1406.00000000,'2024-04-21',1406.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','04:00:00','115','jrojas@telefonicad.com.pe','999999009',NULL,NULL,NULL),(465,'CO0000012',NULL,'','11','F3430024209','2024-05-14','2024-06-13',1040.00000000,'0',0,'Pagado','',1040.00000000,'2024-06-13',1040.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','03:00:00','116','smendez@minerabarri.com.pe','999999010',NULL,NULL,NULL),(466,'CO0000013',NULL,'','12','F4280013135','2024-02-25','2024-03-26',1245.00000000,'104',0,'En Seguimiento','',1245.00000000,'2024-03-26',1245.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','05:00:00','117','epacheco@consorciomi.com.pe','999999011',NULL,NULL,NULL),(467,'CO0000014',NULL,'','13','F3860022202','2024-01-26','2024-02-25',527.00000000,'0',0,'Pagado','',527.00000000,'2024-02-25',527.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','04:00:00','118','cdelacruz@bancocentra.com.pe','999999012',NULL,NULL,NULL),(468,'CO0000015',NULL,'','14','F3520034550','2024-02-05','2024-03-06',1287.00000000,'0',0,'Pagado','',1287.00000000,'2024-03-06',1287.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','03:00:00','119','mhernandez@bancocontin.com.pe','999999013',NULL,NULL,NULL),(469,'CO0000016',NULL,'','15','F3720023957','2024-01-11','2024-02-10',962.00000000,'0',0,'Pagado','',962.00000000,'2024-02-10',962.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','05:00:00','120','acorrales@telefonicam.com.pe','999999014',NULL,NULL,NULL),(470,'CO0000017',NULL,'','16','F3210051080','2024-04-21','2024-05-21',605.00000000,'0',0,'Pagado','',605.00000000,'2024-05-21',605.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','04:00:00','121','bdiaz@perupetros..com.pe','999999015',NULL,NULL,NULL),(471,'CO0000018',NULL,'','17','F3310039549','2024-01-23','2024-02-22',1465.00000000,'0',0,'Pagado','',1465.00000000,'2024-02-22',1465.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','03:00:00','122','cmarcenaro@alicorps.a..com.pe','999999016',NULL,NULL,NULL),(472,'CO0000019',NULL,'','18','F3510042061','2024-07-08','2024-08-08',546.00000000,'0',0,'Registrada','',546.00000000,'2024-06-04',546.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','05:00:00','123','dsolis@uniondecer.com.pe','999999017',NULL,NULL,NULL),(473,'CO0000020',NULL,'','19','F3530013017','2024-05-21','2024-06-20',1055.00000000,'0',0,'Pagado','',1055.00000000,'2024-06-20',1055.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','04:00:00','124','ffoppiano@repsolcomer.com.pe','999999018',NULL,NULL,NULL),(474,'CO0000021',NULL,'','20','F3870020694','2024-05-23','2024-06-22',587.00000000,'0',0,'Pagado','',587.00000000,'2024-06-22',587.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','03:00:00','125','grojas@peruanadec.com.pe','999999019',NULL,NULL,NULL),(475,'CO0000022',NULL,'','21','F4290014621','2024-04-22','2024-05-22',1135.00000000,'0',0,'Pagado','',1135.00000000,'2024-05-22',1135.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','126','hcampos@primaxs.a..com.pe','999999020',NULL,NULL,NULL),(476,'CO0000023',NULL,'','22','F3320035145','2024-04-17','2024-05-17',921.00000000,'0',0,'Pagado','',921.00000000,'2024-05-17',921.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','127','jallemant@bancointern.com.pe','999999021',NULL,NULL,NULL),(477,'CO0000024',NULL,'','23','F3130027103','2024-01-02','2024-02-01',638.00000000,'0',0,'Pagado','',638.00000000,'2024-02-01',638.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','128','kvillanes@scotiabankp.com.pe','999999022',NULL,NULL,NULL),(478,'CO0000025',NULL,'','24','F3230048777','2024-03-23','2024-04-22',1105.00000000,'77',0,'Anulada','',1105.00000000,'2024-04-22',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','129','lgalvez@americamovi.com.pe','999999023',NULL,NULL,NULL),(479,'CO0000026',NULL,'','25','F3230048779','2024-04-30','2024-05-30',555.00000000,'0',0,'Pagado','',555.00000000,'2024-05-30',555.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','130','mquezada@hipermercado.com.pe','999999024',NULL,NULL,NULL),(480,'CO0000027',NULL,'','26','F4560004129','2024-05-14','2024-06-13',1214.00000000,'0',0,'Pagado','',1214.00000000,'2024-06-13',1214.00000000,'Parcial','Negociación','',0,0.00000000,'','Viernes, Sabado','03:00:00','131','npardo@procesadora.com.pe','999999025',NULL,NULL,NULL),(481,'CO0000028',NULL,'','27','F3710019317','2024-04-27','2024-05-27',725.00000000,'0',0,'Pagado','',725.00000000,'2024-05-27',725.00000000,'Parcial','Negociación','',0,0.00000000,'','Viernes, Sabado','05:00:00','132','ovillanueva@supermercado.com.pe','999999026',NULL,NULL,NULL),(482,'CO0000029',NULL,'','28','F3960021889','2024-03-28','2024-04-27',1212.00000000,'0',0,'Pagado','',1212.00000000,'2024-04-27',1212.00000000,'Parcial','Negociación','',0,0.00000000,'','Viernes, Sabado','04:00:00','133','pnaranjo@glorias.a..com.pe','999999027',NULL,NULL,NULL),(483,'CO0000030',NULL,'','29','F3040030375','2024-03-18','2024-04-17',1019.00000000,'0',0,'Pagado','',1019.00000000,'2024-04-17',1019.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','134','jcruz@rimacintern.com.pe','999999028',NULL,NULL,NULL),(484,'CO0000031',NULL,'','30','F4560004143','2024-03-11','2024-04-10',522.00000000,'0',0,'Pagado','',522.00000000,'2024-04-10',522.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','135','rescobedo@pluspetrolp.com.pe','999999029',NULL,NULL,NULL),(485,'CO0000032',NULL,'','31','F4250001014','2024-03-23','2024-04-22',501.00000000,'77',0,'En Seguimiento','',501.00000000,'2024-04-22',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','136','oscarsc@hotmail.com','999999030',NULL,NULL,NULL),(486,'CO0000033',NULL,'','32','F3140030896','2024-01-06','2024-02-05',1421.00000000,'0',0,'Pagado','',1421.00000000,'2024-02-05',1421.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','137','vgutierrez@a.ys.s.a..com.pe','999999031',NULL,NULL,NULL),(487,'CO0000034',NULL,'','33','F3180012742','2024-01-05','2024-02-04',1117.00000000,'0',0,'Pagado','',1117.00000000,'2024-02-04',1117.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','05:00:00','138','wzapata@corporacion.com.pe','999999032',NULL,NULL,NULL),(488,'CO0000035',NULL,'','34','F3210051110','2024-04-23','2024-05-23',770.00000000,'0',0,'Pagado','',770.00000000,'2024-05-23',770.00000000,'Parcial','Negociación','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','04:00:00','139','xbarrantes@luzdelsur.com.pe','999999033',NULL,NULL,NULL),(489,'CO0000036',NULL,'','35','F4280013134','2024-05-02','2024-06-01',937.00000000,'34',0,'Pagado','',937.00000000,'2024-06-01',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','03:00:00','140','ibarron@empresaded.com.pe','999999034',NULL,NULL,NULL),(490,'CO0000037',NULL,'','36','F4280013138','2024-05-12','2024-06-11',1465.00000000,'0',0,'Pagado','',1465.00000000,'2024-06-11',1465.00000000,'Parcial','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','05:00:00','141','afernandez@saviaperus.com.pe','999999035',NULL,NULL,NULL),(491,'CO0000038',NULL,'','37','F3880009809','2024-05-16','2024-06-15',1422.00000000,'20',0,'Pagado','',1422.00000000,'2024-06-15',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','04:00:00','142','carellano@sagafalabel.com.pe','999999036',NULL,NULL,NULL),(492,'CO0000039',NULL,'','38','F3720023955','2024-05-09','2024-06-08',982.00000000,'30',0,'En Seguimiento','',982.00000000,'2024-06-08',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','03:00:00','143','dhurtado@universalme.com.pe','999999037',NULL,NULL,NULL),(493,'CO0000040',NULL,'','39','F3130027079','2024-03-30','2024-04-29',713.00000000,'67',0,'Pagado','',713.00000000,'2024-04-29',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','05:00:00','144','fpaez@volcancia..com.pe','999999038',NULL,NULL,NULL),(494,'CO0000041',NULL,'','40','F3170027812','2024-02-15','2024-03-16',693.00000000,'114',0,'En Seguimiento','',693.00000000,'2024-03-16',0.00000000,'Parcial','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','04:00:00','145','gzevallos@bancodela.com.pe','999999039',NULL,NULL,NULL),(495,'CO0000042',NULL,'','41','F3170027824','2024-03-11','2024-04-10',972.00000000,'86',0,'Pagado','',972.00000000,'2024-04-10',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Lunes, Martes, Sabado','03:00:00','146','hbenavente@minsurs.a..com.pe','999999040',NULL,NULL,NULL),(496,'CO0000043',NULL,'','42','F3860022201','2024-05-19','2024-06-18',760.00000000,'20',0,'En Seguimiento','',760.00000000,'2024-06-18',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','05:00:00','147','osantacruz@g.ym.s.a..com.pe','999999041',NULL,NULL,NULL),(497,'CO0000044',NULL,'','43','F3130027102','2024-01-08','2024-02-07',773.00000000,'149',0,'Pagado','',773.00000000,'2024-02-07',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','04:00:00','148','dlituma@corporacion.com.pe','999999042',NULL,NULL,NULL),(498,'CO0000045',NULL,'','44','F3240039885','2024-04-10','2024-05-10',1206.00000000,'56',0,'Pagado','',1206.00000000,'2024-05-10',0.00000000,'Efectivo','','',0,0.00000000,'Presentar orden de compra y 3 copias de la factura','Viernes, Sabado','03:00:00','149','acevasco@superintende.com.pe','999999043',NULL,NULL,NULL),(499,'CO0000046',NULL,'','45','F3510042054','2024-07-08','2024-08-08',960.00000000,'0',0,'Registrada','',960.00000000,'2024-04-30',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','150','alima@sanfernando.com.pe','999999044',NULL,NULL,NULL),(500,'CO0000047',NULL,'','46','F4070019914','2024-03-20','2024-04-19',901.00000000,'77',0,'Pagado','',901.00000000,'2024-04-19',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','151','aramos@tecnologica.com.pe','999999045',NULL,NULL,NULL),(501,'CO0000048',NULL,'','47','F3520034547','2024-04-25','2024-05-25',651.00000000,'41',0,'Pagado','',651.00000000,'2024-05-25',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','152','avelasquez@cia.demina.com.pe','999999046',NULL,NULL,NULL),(502,'CO0000049',NULL,'','48','F3860022203','2024-04-18','2024-05-18',1470.00000000,'48',0,'Pagado','',1470.00000000,'2024-05-18',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','153','mcuenca@tiendaspor.com.pe','999999047',NULL,NULL,NULL),(503,'CO0000050',NULL,'','49','F3710019323','2024-03-23','2024-04-22',835.00000000,'77',0,'En Seguimiento','',835.00000000,'2024-04-22',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','154','pramirez@empresaside.com.pe','999999048',NULL,NULL,NULL),(504,'CO0000051',NULL,'','50','F3510042071','2024-02-16','2024-03-17',828.00000000,'113',0,'Con Compromiso de Pago','',828.00000000,'2024-03-17',0.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','155','aabad@hipermercado.com.pe','999999049',NULL,NULL,NULL),(505,'CO0000052',NULL,'','51','F3130027091','2024-05-03','2024-06-02',1370.00000000,'33',0,'Pagado','',1370.00000000,'2024-06-02',0.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','156','ginurritegui@empresaelec.com.pe','999999050',NULL,NULL,NULL),(506,'CO0000053',NULL,'','52','F4070019899','2024-03-12','2024-04-11',1040.00000000,'88',0,'En Seguimiento','',1040.00000000,'2024-04-11',0.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','157','cmachado@e.wongs.a..com.pe','999999051',NULL,NULL,NULL),(507,'CO0000054',NULL,'','53','F3220044894','2024-03-23','2024-04-22',1196.00000000,'74',0,'Pagado','',1196.00000000,'2024-04-22',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','158','scanales@huntoilcom.com.pe','999999052',NULL,NULL,NULL),(508,'CO0000055',NULL,'','54','F3340035195','2024-01-01','2024-01-31',945.00000000,'159',0,'En Seguimiento','',945.00000000,'2024-01-31',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','159','pleon@peruanadep.com.pe','999999053',NULL,NULL,NULL),(509,'CO0000056',NULL,'','55','F3030034507','2024-05-27','2024-06-26',1265.00000000,'9',0,'Pagado','',1265.00000000,'2024-06-26',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','160','sjayo@quimicasuiz.com.pe','999999054',NULL,NULL,NULL),(510,'CO0000057',NULL,'','56','F3720023954','2024-02-17','2024-03-18',821.00000000,'109',0,'Pagado','',821.00000000,'2024-03-18',821.00000000,'Parcial','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','161','lmiyagi@enersurs.a..com.pe','999999055',NULL,NULL,NULL),(511,'CO0000058',NULL,'','57','F3350034877','2024-02-05','2024-03-06',1402.00000000,'121',0,'Pagado','',1402.00000000,'2024-03-06',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','162','hmedina@oricachemic.com.pe','999999056',NULL,NULL,NULL),(512,'CO0000059',NULL,'','58','F4320001715','2024-02-16','2024-03-17',905.00000000,'145',0,'Con Compromiso de Pago','',905.00000000,'2024-08-09',905.00000000,'Parcial','Negociación','',0,0.00000000,'','Viernes, Sabado','04:00:00','163','gdelatorre@serviciode.com.pe','999999057',NULL,NULL,NULL),(513,'CO0000060',NULL,'','59','F3860022204','2024-07-01','2024-08-01',1387.00000000,'0',0,'Registrada','',1387.00000000,'2024-04-19',1387.00000000,'Parcial','Negociación','',0,0.00000000,'','Viernes, Sabado','03:00:00','164','sperez@toyotadelp.com.pe','999999058',NULL,NULL,NULL),(514,'CO0000061',NULL,'','60','F3180012729','2024-01-20','2024-02-19',1130.00000000,'0',0,'Pagado','',1130.00000000,'2024-02-19',1130.00000000,'Parcial','Negociación','',0,0.00000000,'','Viernes, Sabado','05:00:00','165','psanchez@doerunperu.com.pe','999999059',NULL,NULL,NULL),(515,'CO0000062',NULL,'','61','F4250001017','2024-04-02','2024-05-02',1400.00000000,'64',0,'Pagado','',1400.00000000,'2024-05-02',1400.00000000,'Parcial','Negociación','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','166','srodriguez@nestleperu.com.pe','999999060',NULL,NULL,NULL),(516,'CO0000063',NULL,'','62','F3860022205','2024-02-20','2024-03-21',1361.00000000,'109',0,'Con Compromiso de Pago','',1361.00000000,'2024-03-21',1361.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','167','lperez@elpacifico.com.pe','999999061',NULL,NULL,NULL),(517,'CO0000064',NULL,'','63','F3030034501','2024-04-28','2024-05-28',1183.00000000,'0',0,'Pagado','',1183.00000000,'2024-05-28',1183.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','168','hdiaz@conirsas.a..com.pe','999999062',NULL,NULL,NULL),(518,'CO0000065',NULL,'','64','F3630009775','2024-01-26','2024-02-25',1090.00000000,'0',0,'Pagado','',1090.00000000,'2024-02-25',1090.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','169','gpolo@pluspetroln.com.pe','999999063',NULL,NULL,NULL),(519,'CO0000066',NULL,'','65','F3510042039','2024-07-08','2024-08-08',804.00000000,'1',0,'Con Compromiso de Pago','48 horas',804.00000000,'2024-08-16',804.00000000,'Efectivo','','Mande whatsapp y no me ha contestado',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','170','abarrantes@deprodecas.com.pe','51924985856',NULL,NULL,NULL),(520,'CO0000067',NULL,'','66','F4320001722','2024-04-24','2024-05-24',949.00000000,'0',0,'Pagado','',949.00000000,'2024-05-24',949.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','171','mbarron@edegels.a.a.com.pe','999999065',NULL,NULL,NULL),(521,'CO0000068',NULL,'','67','F3410027460','2024-04-07','2024-05-07',1056.00000000,'0',0,'Pagado','',1056.00000000,'2024-05-07',1056.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','172','pfernandez@lanperus.a.com.pe','999999066',NULL,NULL,NULL),(522,'CO0000069',NULL,'','68','F3040030363','2024-03-09','2024-04-08',1415.00000000,'0',0,'Pagado','',1415.00000000,'2024-04-08',1415.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','173','aarellano@goldfields.com.pe','999999067',NULL,NULL,NULL),(523,'CO0000070',NULL,'','69','F4280013148','2024-01-09','2024-02-08',857.00000000,'151',0,'En Seguimiento','',857.00000000,'2024-02-08',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','174','ghurtado@koriperus..com.pe','999999068',NULL,NULL,NULL),(524,'CO0000071',NULL,'','70','F4280013150','2024-05-03','2024-06-02',1316.00000000,'33',0,'Pagado','',1316.00000000,'2024-06-02',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','175','cpaez@procter&ga.com.pe','999999069',NULL,NULL,NULL),(525,'CO0000072',NULL,'','71','F4280013153','2024-05-03','2024-06-02',738.00000000,'33',0,'Pagado','',738.00000000,'2024-06-02',0.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','176','hdelacruz@eckerdperu.com.pe','999999070',NULL,NULL,NULL),(526,'CO0000073',NULL,'','72','F3870020702','2024-04-12','2024-05-12',1292.00000000,'0',0,'Pagado','',1292.00000000,'2024-05-12',1292.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','177','ohernandez@techints.a..com.pe','999999071',NULL,NULL,NULL),(527,'CO0000074',NULL,'','73','F3160034342','2024-03-24','2024-04-23',1171.00000000,'0',0,'Pagado','',1171.00000000,'2024-04-23',1171.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','178','dcorrales@petrobrasen.com.pe','999999072',NULL,NULL,NULL),(528,'CO0000075',NULL,'','74','F3040030371','2024-04-20','2024-05-20',1283.00000000,'0',0,'Pagado','',1283.00000000,'2024-05-20',1283.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','179','adiaz@cia.minera.com.pe','999999073',NULL,NULL,NULL),(529,'CO0000076',NULL,'','75','F4280013133','2024-01-11','2024-02-10',630.00000000,'149',0,'En Seguimiento','',630.00000000,'2024-07-08',0.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','180','amarcenaro@cementoslim.com.pe','999999074',NULL,NULL,NULL),(530,'CO0000077',NULL,'','76','F4290014631','2024-02-20','2024-03-21',1089.00000000,'0',0,'Pagado','',1089.00000000,'2024-03-21',1089.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','181','asolis@shouganghie.com.pe','999999075',NULL,NULL,NULL),(531,'CO0000078',NULL,'','77','F3910026883','2024-05-09','2024-06-08',557.00000000,'0',0,'Pagado','',557.00000000,'2024-06-08',557.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','182','iaservi@cbiperuana.com.pe','999999076',NULL,NULL,NULL),(532,'CO0000079',NULL,'','78','F4070019892','2024-03-02','2024-04-01',1195.00000000,'0',0,'Pagado','',1195.00000000,'2024-04-01',1195.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','183','aregalado@mibancobanc.com.pe','999999077',NULL,NULL,NULL),(533,'CO0000080',NULL,'','79','F3120027136','2024-01-21','2024-02-20',1460.00000000,'0',0,'Pagado','',1460.00000000,'2024-02-20',1460.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','184','csalazar@repsolypfc.com.pe','999999078',NULL,NULL,NULL),(534,'CO0000081',NULL,'','80','F3340035150','2024-05-16','2024-06-15',1086.00000000,'0',0,'Pagado','',1086.00000000,'2024-06-15',1086.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','185','dzuniga@transportado.com.pe','999999079',NULL,NULL,NULL),(535,'CO0000082',NULL,'','81','F3150028752','2024-04-06','2024-05-06',1174.00000000,'0',0,'Pagado','',1174.00000000,'2024-05-06',1174.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','186','fpachas@fondonacion.com.pe','999999080',NULL,NULL,NULL),(536,'CO0000083',NULL,'','82','F4570001529','2024-03-30','2024-04-29',638.00000000,'0',0,'Pagado','',638.00000000,'2024-04-29',638.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','187','gmontes@nexteldelp.com.pe','999999081',NULL,NULL,NULL),(537,'CO0000084',NULL,'','83','F3710019318','2024-01-30','2024-02-29',1391.00000000,'0',0,'Pagado','',1391.00000000,'2024-02-29',1391.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','188','jsegura@cia.minera.com.pe','999999082',NULL,NULL,NULL),(538,'CO0000085',NULL,'','84','F3030034502','2024-03-29','2024-04-28',1349.00000000,'0',0,'Pagado','',1349.00000000,'2024-04-28',1349.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','189','rreyna@manuperuho.com.pe','999999083',NULL,NULL,NULL),(539,'CO0000086',NULL,'','85','F3510042045','2024-07-08','2024-08-08',999.00000000,'0',0,'Registrada','',999.00000000,'2024-06-02',999.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','190','sruiz@l.g.electr.com.pe','999999084',NULL,NULL,NULL),(540,'CO0000087',NULL,'','86','F3870020690','2024-03-11','2024-04-10',929.00000000,'0',0,'Pagado','',929.00000000,'2024-04-10',929.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','191','vcastilla@corporacion.com.pe','999999085',NULL,NULL,NULL),(541,'CO0000088',NULL,'','87','F3420025536','2024-01-19','2024-02-18',1122.00000000,'0',0,'Pagado','',1122.00000000,'2024-02-18',1122.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','192','wpizarro@crediscotia.com.pe','999999086',NULL,NULL,NULL),(542,'CO0000089',NULL,'','88','F4280013147','2024-05-17','2024-06-16',785.00000000,'22',0,'En Seguimiento','',785.00000000,'2024-06-16',785.00000000,'Parcial','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','193','xcorcuera@cetcos.a..com.pe','999999087',NULL,NULL,NULL),(543,'CO0000090',NULL,'','89','F3130027077','2024-02-06','2024-03-07',1330.00000000,'123',0,'En Seguimiento','',1330.00000000,'2024-03-07',1330.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','194','kzambrano@sociedadmin.com.pe','999999088',NULL,NULL,NULL),(544,'CO0000091',NULL,'','90','F3340035166','2024-05-27','2024-06-26',720.00000000,'0',0,'Pagado','',720.00000000,'2024-06-26',720.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','195','lcarrera@inversiones.com.pe','999999089',NULL,NULL,NULL),(545,'CO0000092',NULL,'','91','F3340035167','2024-05-21','2024-06-20',625.00000000,'0',0,'Pagado','',625.00000000,'2024-06-20',625.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','196','mvillar@australgrou.com.pe','999999090',NULL,NULL,NULL),(546,'CO0000093',NULL,'','92','F4210031083','2024-04-25','2024-05-25',1167.00000000,'41',0,'Pagado','',1167.00000000,'2024-05-25',1167.00000000,'Parcial','','',0,0.00000000,'','Viernes, Sabado','03:00:00','197','nsevillano@xstratatint.com.pe','999999091',NULL,NULL,NULL),(547,'CO0000094',NULL,'','93','F3420025548','2024-01-16','2024-02-15',1451.00000000,'0',0,'Pagado','',1451.00000000,'2024-02-15',1451.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','198','oparedes@maestrohome.com.pe','999999092',NULL,NULL,NULL),(548,'CO0000095',NULL,'','94','F4560004142','2024-04-13','2024-05-13',1203.00000000,'88',0,'Con Compromiso de Pago','',1203.00000000,'2024-08-09',1203.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','199','pmontes@pluspetrolc.com.pe','999999093',NULL,NULL,NULL),(549,'CO0000096',NULL,'','95','F3630009780','2024-03-27','2024-04-26',685.00000000,'0',0,'Pagado','',685.00000000,'2024-04-26',685.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','200','csegura@sodimacperu.com.pe','999999094',NULL,NULL,NULL),(550,'CO0000097',NULL,'','96','F4510003329','2024-02-26','2024-03-27',1320.00000000,'103',0,'Con Compromiso de Pago','',1320.00000000,'2024-03-27',1320.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','201','dreyna@uniques.a..com.pe','999999095',NULL,NULL,NULL),(551,'CO0000098',NULL,'','97','F3160034344','2024-03-27','2024-04-26',821.00000000,'0',0,'Pagado','',821.00000000,'2024-04-26',821.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','202','fruiz@kimberlycla.com.pe','999999096',NULL,NULL,NULL),(552,'CO0000099',NULL,'','98','F3520034546','2024-03-19','2024-04-18',640.00000000,'81',0,'Con Compromiso de Pago','',640.00000000,'2024-04-18',640.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','203','gcastilla@pesqueradia.com.pe','999999097',NULL,NULL,NULL),(553,'CO0000100',NULL,'','99','F3530013014','2024-02-17','2024-03-18',1431.00000000,'0',0,'Pagado','',1431.00000000,'2024-03-18',1431.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','204','hpizarro@credibolsas.com.pe','999999098',NULL,NULL,NULL),(554,'CO0000101',NULL,'','100','F4290014630','2024-04-10','2024-05-10',870.00000000,'59',0,'Con Compromiso de Pago','',870.00000000,'2024-05-10',870.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','205','jraez@elpacifico.com.pe','999999099',NULL,NULL,NULL),(555,'CO0000102',NULL,'','101','F4070019910','2024-01-31','2024-03-01',1164.00000000,'129',0,'Con Compromiso de Pago','',1164.00000000,'2024-03-01',1164.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','206','oaltamirano@cementospac.com.pe','999999100',NULL,NULL,NULL),(556,'CO0000103',NULL,'','102','F3120027149','2024-01-04','2024-02-03',1135.00000000,'156',0,'Con Compromiso de Pago','',1135.00000000,'2024-02-03',1135.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','107','jperez@petroleosde.com.pe','999999001',NULL,NULL,NULL),(557,'CO0000104',NULL,'','103','F3510042042','2024-07-08','2024-08-08',1402.00000000,'0',0,'Registrada','',1402.00000000,'2024-04-14',1402.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','208','oscar@creantis.com','999999002',NULL,NULL,NULL),(558,'CO0000105',NULL,'','104','F3960021888','2024-05-23','2024-06-22',773.00000000,'48',0,'Con Compromiso de Pago','',773.00000000,'2024-08-09',773.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','147','osantacruz@creantis.net','999999003',NULL,NULL,NULL),(559,'CO0000106',NULL,'','105','F3220044907','2024-05-27','2024-06-26',1237.00000000,'12',0,'Con Compromiso de Pago','',1237.00000000,'2024-06-26',1237.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','107','jperez@pacasmayo.com','999999004',NULL,NULL,NULL),(560,'CO0000107',NULL,'','106','F4460002691','2024-03-19','2024-04-18',1488.00000000,'81',0,'Pagado','',1488.00000000,'2024-07-08',1488.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','211','carlos@losvelasquez.net','999999005',NULL,NULL,NULL),(561,'CO0000108',NULL,'','100','F4440009818','2024-01-24','2024-02-23',878.00000000,'0',0,'Pagado','',878.00000000,'2024-02-23',878.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','205','jraez@elpacifico.com.pe','999999099',NULL,NULL,NULL),(562,'CO0000109',NULL,'','101','F3520034519','2024-04-24','2024-05-24',1280.00000000,'45',0,'Con Compromiso de Pago','',1280.00000000,'2024-05-24',1280.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','206','oaltamirano@cementospac.com.pe','999999100',NULL,NULL,NULL),(563,'CO0000110',NULL,'','102','F4070020407','2024-02-18','2024-03-19',1142.00000000,'111',0,'Con Compromiso de Pago','',1142.00000000,'2024-07-08',1142.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','107','jperez@petroleosde.com.pe','999999001',NULL,NULL,NULL),(564,'CO0000111',NULL,'','103','F3020034562','2024-05-17','2024-06-16',763.00000000,'22',0,'Con Compromiso de Pago','',763.00000000,'2024-06-16',763.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','208','oscar@creantis.com','999999002',NULL,NULL,NULL),(565,'CO0000112',NULL,'','104','F3720024542','2024-05-19','2024-06-18',913.00000000,'0',0,'Pagado','',913.00000000,'2024-06-18',913.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','147','osantacruz@creantis.net','999999003',NULL,NULL,NULL),(566,'CO0000113',NULL,'','105','F3010027625','2024-03-13','2024-04-12',583.00000000,'0',0,'Pagado','',583.00000000,'2024-04-12',583.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','107','jperez@pacasmayo.com','999999004',NULL,NULL,NULL),(567,'CO0000114',NULL,'','106','F3240041069','2024-05-27','2024-06-26',729.00000000,'0',0,'Pagado','',729.00000000,'2024-06-26',729.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','211','carlos@losvelasquez.net','999999005',NULL,NULL,NULL),(568,'CO0000115',NULL,'','','F3010027626','2024-07-01','2024-08-01',1331.00000000,'0',0,'Registrada','',1331.00000000,'2024-04-23',1331.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','','jose.zavaleta@kcc.com','999999006',NULL,NULL,NULL),(569,'CO0000116',NULL,'','106','F3230049910','2024-05-24','2024-06-23',760.00000000,'15',0,'Con Compromiso de Pago','',760.00000000,'2024-06-23',760.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','211','carlos@losvelasquez.net','999999005',NULL,NULL,NULL),(570,'CO0000117',NULL,'','100','F3860022760','2024-07-01','2024-08-01',1395.00000000,'0',0,'Registrada','',1395.00000000,'2024-03-20',1395.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','205','jraez@elpacifico.com.pe','999999099',NULL,NULL,NULL),(571,'CO0000118',NULL,'','101','F3160035352','2024-04-03','2024-05-03',1175.00000000,'0',0,'Pagado','',1175.00000000,'2024-05-03',1175.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','206','oaltamirano@cementospac.com.pe','999999100',NULL,NULL,NULL),(572,'CO0000119',NULL,'','102','F3310040587','2024-07-01','2024-08-01',1395.00000000,'0',0,'Registrada','',1395.00000000,'2024-02-05',1395.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','107','jperez@petroleosde.com.pe','999999001',NULL,NULL,NULL),(573,'CO0000120',NULL,'','103','F4340001411','2024-05-25','2024-06-24',621.00000000,'14',0,'Con Compromiso de Pago','',621.00000000,'2024-06-24',621.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','208','oscar@creantis.com','999999002',NULL,NULL,NULL),(574,'CO0000121',NULL,'','104','F3310040588','2024-07-01','2024-08-01',1278.00000000,'0',0,'Registrada','',1278.00000000,'2024-02-12',1278.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','05:00:00','147','osantacruz@creantis.net','999999003',NULL,NULL,NULL),(575,'CO0000122',NULL,'','105','F3160035344','2024-03-05','2024-04-04',1313.00000000,'0',0,'Pagado','',1313.00000000,'2024-04-04',1313.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','04:00:00','107','jperez@pacasmayo.com','999999004',NULL,NULL,NULL),(576,'CO0000123',NULL,'','106','F3210052285','2024-06-08','2024-07-08',1398.00000000,'0',0,'Registrada','',1398.00000000,'2024-03-14',1398.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','03:00:00','211','carlos@losvelasquez.net','999999005',NULL,NULL,NULL),(577,'CO0000124',NULL,'','106','F3220045827','2024-04-04','2024-05-04',1278.00000000,'65',0,'Con Compromiso de Pago','',1278.00000000,'2024-05-04',1278.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','05:00:00','211','carlos@losvelasquez.net','999999005',NULL,NULL,NULL),(578,'CO0000125',NULL,'','100','F3410028252','2024-06-08','2024-07-08',774.00000000,'0',0,'Registrada','',774.00000000,'2024-06-05',774.00000000,'Efectivo','','',0,0.00000000,'','Viernes, Sabado','04:00:00','205','jraez@elpacifico.com.pe','999999099',NULL,NULL,NULL),(579,'CO0000126',NULL,'','101','F3160035350','2024-04-23','2024-05-23',1284.00000000,'0',0,'Pagado','',1284.00000000,'2024-05-23',1284.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','206','oaltamirano@cementospac.com.pe','999999100',NULL,NULL,NULL),(580,'CO0000127',NULL,'','102','F3160035351','2024-06-08','2024-07-08',583.00000000,'0',0,'Registrada','',583.00000000,'2024-03-16',583.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','107','jperez@petroleosde.com.pe','999999001',NULL,NULL,NULL),(581,'CO0000128',NULL,'','103','F3720024535','2024-05-21','2024-06-20',901.00000000,'18',0,'Con Compromiso de Pago','',901.00000000,'2024-06-20',901.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','208','oscar@creantis.com','999999002',NULL,NULL,NULL),(582,'CO0000129',NULL,'','104','F3160035353','2024-06-08','2024-07-08',781.00000000,'0',0,'Registrada','',781.00000000,'2024-04-23',781.00000000,'Efectivo','','',0,0.00000000,'','Lunes, Martes, Sabado','03:00:00','147','osantacruz@creantis.net','999999003',NULL,NULL,NULL);

--
