(625364,'Contacts',622853,'DeliveryNotes'),
(625364,'Contacts',622854,'DeliveryNotes'),
(625364,'Contacts',622855,'DeliveryNotes'),
(625364,'Contacts',622856,'DeliveryNotes'),
(625364,'Contacts',622857,'DeliveryNotes'),
(625364,'Contacts',622858,'DeliveryNotes'),
(625364,'Contacts',622859,'DeliveryNotes'),
(625364,'Contacts',622860,'DeliveryNotes'),
(625364,'Contacts',622861,'DeliveryNotes'),
(625364,'Contacts',622862,'DeliveryNotes'),
(625364,'Contacts',622863,'DeliveryNotes'),
(625364,'Contacts',622864,'DeliveryNotes'),
(625364,'Contacts',622865,'DeliveryNotes'),
(625364,'Contacts',622866,'DeliveryNotes'),
(625364,'Contacts',622867,'DeliveryNotes'),
(625364,'Contacts',622868,'DeliveryNotes'),
(625364,'Contacts',622869,'DeliveryNotes'),
(625364,'Contacts',622870,'DeliveryNotes'),
(626826,'HelpDesk',626828,'ServiceReports'),
(610047,'ServiceEngineer',626897,'ModelAndAggregates'),
(609332,'ServiceEngineer',626898,'ModelAndAggregates'),
(626927,'HelpDesk',626928,'ServiceReports'),
(626930,'HelpDesk',626931,'ServiceReports'),
(626933,'HelpDesk',626934,'ServiceReports'),
(626844,'HelpDesk',626936,'ServiceReports'),
(626844,'HelpDesk',626938,'ServiceReports'),
(626844,'HelpDesk',626941,'ServiceReports'),
(626942,'HelpDesk',626943,'ServiceReports'),
(626944,'HelpDesk',626945,'ServiceReports'),
(626947,'HelpDesk',626948,'ServiceReports'),
(0,'HelpDesk',626952,'StockTransferOrders'),
(626954,'HelpDesk',626955,'ServiceReports'),
(626970,'HelpDesk',626972,'ServiceReports'),
(626973,'HelpDesk',626974,'ServiceReports'),
(626982,'HelpDesk',626983,'ServiceReports'),
(626985,'HelpDesk',626986,'ServiceReports'),
(626989,'HelpDesk',626990,'ServiceReports'),
(626992,'HelpDesk',626993,'ServiceReports'),
(626996,'HelpDesk',626997,'ServiceReports'),
(627000,'HelpDesk',627001,'ServiceReports'),
(627015,'HelpDesk',627016,'ServiceReports'),
(627023,'HelpDesk',627024,'ServiceReports'),
(627028,'HelpDesk',627029,'ServiceReports'),
(627037,'HelpDesk',627038,'ServiceReports'),
(627046,'HelpDesk',627047,'ServiceReports'),
(627058,'HelpDesk',627059,'ServiceReports'),
(627066,'HelpDesk',627068,'ServiceReports'),
(627077,'HelpDesk',627078,'ServiceReports'),
(627082,'HelpDesk',627083,'ServiceReports'),
(627086,'HelpDesk',627087,'ServiceReports'),
(627090,'HelpDesk',627091,'ServiceReports'),
(626971,'Leads',627092,'Emails'),
(626971,'Leads',627093,'Emails'),
(626971,'Leads',627095,'Emails'),
(627094,'Leads',627095,'Emails'),
(626971,'Leads',627096,'Emails'),
(627094,'Leads',627096,'Emails'),
(627097,'Leads',627098,'Emails'),
(627094,'Leads',627098,'Emails'),
(626971,'Leads',627098,'Emails'),
(627097,'Leads',627099,'Emails'),
(627103,'HelpDesk',627104,'ServiceReports'),
(627112,'HelpDesk',627113,'ServiceReports'),
(627115,'HelpDesk',627116,'ServiceReports'),
(627119,'HelpDesk',627120,'ServiceReports'),
(627121,'HelpDesk',627123,'ServiceReports'),
(627126,'HelpDesk',627127,'ServiceReports'),
(626971,'Leads',627131,'Emails'),
(627094,'Leads',627131,'Emails'),
(627097,'Leads',627131,'Emails'),
(626971,'Leads',627132,'Emails'),
(627094,'Leads',627132,'Emails'),
(627097,'Leads',627132,'Emails'),
(627094,'Leads',627133,'Emails'),
(626971,'Leads',627133,'Emails'),
(627097,'Leads',627133,'Emails'),
(627094,'Leads',627134,'Emails'),
(626971,'Leads',627134,'Emails'),
(627097,'Leads',627134,'Emails'),
(627094,'Leads',627135,'Emails'),
(626971,'Leads',627135,'Emails'),
(627097,'Leads',627135,'Emails'),
(627094,'Leads',627136,'Emails'),
(626971,'Leads',627136,'Emails'),
(627097,'Leads',627136,'Emails'),
(627094,'Leads',627137,'Emails'),
(626971,'Leads',627137,'Emails'),
(627097,'Leads',627137,'Emails'),
(627094,'Leads',627138,'Emails'),
(626971,'Leads',627138,'Emails'),
(627097,'Leads',627138,'Emails'),
(627094,'Leads',627139,'Emails'),
(626971,'Leads',627139,'Emails'),
(627097,'Leads',627139,'Emails'),
(627094,'Leads',627140,'Emails'),
(626971,'Leads',627140,'Emails'),
(627097,'Leads',627140,'Emails'),
(627094,'Leads',627141,'Emails'),
(626971,'Leads',627141,'Emails'),
(627097,'Leads',627141,'Emails'),
(627094,'Leads',627142,'Emails'),
(626971,'Leads',627142,'Emails'),
(627097,'Leads',627142,'Emails'),
(627094,'Leads',627143,'Emails'),
(626971,'Leads',627143,'Emails'),
(627097,'Leads',627143,'Emails'),
(627094,'Leads',627144,'Emails'),
(626971,'Leads',627144,'Emails'),
(627097,'Leads',627144,'Emails'),
(627094,'Leads',627145,'Emails'),
(626971,'Leads',627145,'Emails'),
(627097,'Leads',627145,'Emails'),
(627094,'Leads',627146,'Emails'),
(626971,'Leads',627146,'Emails'),
(627097,'Leads',627146,'Emails'),
(627094,'Leads',627147,'Emails'),
(626971,'Leads',627147,'Emails'),
(627097,'Leads',627147,'Emails'),
(627094,'Leads',627148,'Emails'),
(626971,'Leads',627148,'Emails'),
(627097,'Leads',627148,'Emails'),
(627094,'Leads',627149,'Emails'),
(626971,'Leads',627149,'Emails'),
(627097,'Leads',627149,'Emails'),
(627094,'Leads',627150,'Emails'),
(626971,'Leads',627150,'Emails'),
(627097,'Leads',627150,'Emails'),
(627094,'Leads',627151,'Emails'),
(626971,'Leads',627151,'Emails'),
(627097,'Leads',627151,'Emails'),
(627094,'Leads',627152,'Emails'),
(626971,'Leads',627152,'Emails'),
(627097,'Leads',627152,'Emails'),
(626971,'Leads',627153,'Emails'),
(626971,'Leads',627154,'Emails'),
(626971,'Leads',627155,'Emails'),
(626971,'Leads',627156,'Emails'),
(626971,'Leads',627157,'Emails'),
(626971,'Leads',627158,'Emails'),
(626971,'Leads',627159,'Emails'),
(626971,'Leads',627160,'Emails'),
(627094,'Leads',627160,'Emails'),
(627097,'Leads',627160,'Emails'),
(627094,'Leads',627161,'Emails'),
(626971,'Leads',627161,'Emails'),
(627097,'Leads',627161,'Emails'),
(629539,'Leads',629558,'Calendar'),
(629560,'Accounts',629558,'Calendar'),
(629563,'Potentials',629564,'Quotes'),
(629568,'Leads',629569,'Calendar'),
(629571,'Accounts',629569,'Calendar'),
(629573,'Potentials',629575,'Quotes'),
(629545,'Leads',629584,'Calendar'),
(629586,'Contacts',629584,'Calendar'),
(629629,'Leads',629631,'Calendar'),
(629629,'Leads',629632,'Calendar'),
(629634,'Contacts',629631,'Calendar'),
(629634,'Contacts',629632,'Calendar'),
(629635,'Potentials',629636,'Quotes'),
(626971,'Leads',629638,'Emails'),
(629641,'Contacts',627092,'Emails'),
(629641,'Contacts',627093,'Emails'),
(629641,'Contacts',627095,'Emails'),
(629641,'Contacts',627096,'Emails'),
(629641,'Contacts',627098,'Emails'),
(629641,'Contacts',627131,'Emails'),
(629641,'Contacts',627132,'Emails'),
(629641,'Contacts',627133,'Emails'),
(629641,'Contacts',627134,'Emails'),
(629641,'Contacts',627135,'Emails'),
(629641,'Contacts',627136,'Emails'),
(629641,'Contacts',627137,'Emails'),
(629641,'Contacts',627138,'Emails'),
(629641,'Contacts',627139,'Emails'),
(629641,'Contacts',627140,'Emails'),
(629641,'Contacts',627141,'Emails'),
(629641,'Contacts',627142,'Emails'),
(629641,'Contacts',627143,'Emails'),
(629641,'Contacts',627144,'Emails'),
(629641,'Contacts',627145,'Emails'),
(629641,'Contacts',627146,'Emails'),
(629641,'Contacts',627147,'Emails'),
(629641,'Contacts',627148,'Emails'),
(629641,'Contacts',627149,'Emails'),
(629641,'Contacts',627150,'Emails'),
(629641,'Contacts',627151,'Emails'),
(629641,'Contacts',627152,'Emails'),
(629641,'Contacts',627153,'Emails'),
(629641,'Contacts',627154,'Emails'),
(629641,'Contacts',627155,'Emails'),
(629641,'Contacts',627156,'Emails'),
(629641,'Contacts',627157,'Emails'),
(629641,'Contacts',627158,'Emails'),
(629641,'Contacts',627159,'Emails'),
(629641,'Contacts',627160,'Emails'),
(629641,'Contacts',627161,'Emails'),
(629641,'Contacts',629638,'Emails'),
(629642,'Potentials',629643,'Quotes'),
(629646,'Accounts',629647,'Contacts'),
(629646,'Accounts',629648,'Contacts'),
(629646,'Accounts',629649,'Potentials'),
(629649,'Potentials',629650,'Quotes'),
(629650,'Quotes',629651,'Calendar'),
(629646,'Accounts',629656,'Invoice'),
(629675,'Leads',629702,'Calendar'),
(629704,'Contacts',629702,'Calendar'),
(629705,'Potentials',629706,'Quotes'),
(629733,'Project',629734,'ProjectTask'),
(629733,'Project',629736,'ProjectTask'),
(629753,'Potentials',629754,'Quotes'),
(629757,'Potentials',629758,'Quotes'),
(629674,'Leads',629761,'Calendar'),
(629775,'Leads',629776,'Calendar'),
(629777,'Leads',629779,'Calendar'),
(629839,'Potentials',629841,'Quotes'),
(629853,'Project',629854,'ProjectTask'),
(629853,'Project',629856,'Calendar'),
(629853,'Project',629856,'ProjectTask'),
(629669,'Leads',629858,'Calendar'),
(629860,'Contacts',629858,'Calendar'),
(629861,'Potentials',629862,'Quotes'),
(629671,'Leads',629866,'Calendar'),
(629867,'Accounts',629866,'Calendar'),
(629869,'Potentials',629870,'Quotes'),
(629777,'Leads',629878,'Emails'),
(629777,'Leads',629881,'Emails'),
(629879,'Leads',629881,'Emails'),
(629882,'Leads',629883,'Calendar'),
(629884,'Accounts',629883,'Calendar'),
(629884,'Accounts',629886,'Potentials'),
(629886,'Potentials',629887,'Quotes'),
(629853,'Project',629934,'ProjectTask'),
(629853,'Project',629962,'Calendar'),
(629853,'Project',629963,'Calendar'),
(629964,'HelpDesk',629991,'Emails'),
(629964,'HelpDesk',629992,'Emails'),
(629999,'HelpDesk',630000,'Emails'),
(630001,'HelpDesk',630002,'Emails'),
(630004,'HelpDesk',630006,'Emails'),
(630005,'HelpDesk',630007,'Emails'),
(630021,'ServiceEngineer',630022,'Emails'),
(630021,'ServiceEngineer',630023,'Emails'),
(630024,'ServiceEngineer',630025,'Emails'),
(630024,'ServiceEngineer',630026,'Emails'),
(630031,'ServiceEngineer',630033,'Emails'),
(630031,'ServiceEngineer',630034,'Emails'),
(630035,'ServiceEngineer',630037,'Emails'),
(630035,'ServiceEngineer',630038,'Emails'),
(630039,'ServiceEngineer',630041,'Emails'),
(630039,'ServiceEngineer',630042,'Emails'),
(630043,'ServiceEngineer',630045,'Emails'),
(630043,'ServiceEngineer',630046,'Emails'),
(630047,'ServiceEngineer',630049,'Emails'),
(630047,'ServiceEngineer',630050,'Emails'),
(630051,'ServiceEngineer',630053,'Emails'),
(630051,'ServiceEngineer',630054,'Emails'),
(630056,'ServiceEngineer',630058,'Emails'),
(630056,'ServiceEngineer',630059,'Emails'),
(630061,'ServiceEngineer',630063,'Emails'),
(630061,'ServiceEngineer',630064,'Emails'),
(630066,'ServiceEngineer',630068,'Emails'),
(630066,'ServiceEngineer',630069,'Emails'),
(630071,'ServiceEngineer',630073,'Emails'),
(630071,'ServiceEngineer',630074,'Emails'),
(630076,'ServiceEngineer',630078,'Emails'),
(630076,'ServiceEngineer',630079,'Emails'),
(630081,'ServiceEngineer',630083,'Emails'),
(630081,'ServiceEngineer',630084,'Emails'),
(630087,'ServiceEngineer',630089,'Emails'),
(630087,'ServiceEngineer',630090,'Emails'),
(630092,'ServiceEngineer',630094,'Emails'),
(630092,'ServiceEngineer',630095,'Emails'),
(630097,'ServiceEngineer',630099,'Emails'),
(630097,'ServiceEngineer',630100,'Emails'),
(630102,'ServiceEngineer',630103,'Emails'),
(630102,'ServiceEngineer',630104,'Emails'),
(630106,'ServiceEngineer',630107,'Emails'),
(630106,'ServiceEngineer',630108,'Emails'),
(630110,'ServiceEngineer',630111,'Emails'),
(630113,'ServiceEngineer',630114,'Emails'),
(630116,'ServiceEngineer',630117,'Emails'),
(630119,'ServiceEngineer',630120,'Emails'),
(630130,'ServiceEngineer',630131,'Emails'),
(630133,'ServiceEngineer',630134,'Emails'),
(630136,'ServiceEngineer',630138,'Emails'),
(630141,'ServiceEngineer',630143,'Emails'),
(630145,'ServiceEngineer',630147,'Emails'),
(630149,'ServiceEngineer',630150,'Emails'),
(630152,'ServiceEngineer',630153,'Emails'),
(630155,'ServiceEngineer',630156,'Emails'),
(630155,'ServiceEngineer',630158,'Emails'),
(630159,'ServiceEngineer',630160,'Emails'),
(630159,'ServiceEngineer',630162,'Emails'),
(630163,'ServiceEngineer',630164,'Emails'),
(630163,'ServiceEngineer',630166,'Emails'),
(630167,'ServiceEngineer',630168,'Emails'),
(630167,'ServiceEngineer',630170,'Emails'),
(630171,'ServiceEngineer',630172,'Emails'),
(630171,'ServiceEngineer',630174,'Emails'),
(630175,'ServiceEngineer',630176,'Emails'),
(630175,'ServiceEngineer',630178,'Emails'),
(630179,'ServiceEngineer',630180,'Emails'),
(630179,'ServiceEngineer',630182,'Emails'),
(630183,'ServiceEngineer',630185,'Emails'),
(630183,'ServiceEngineer',630187,'Emails'),
(630189,'ServiceEngineer',630191,'Emails'),
(630193,'ServiceEngineer',630195,'Emails'),
(630193,'ServiceEngineer',630197,'Emails'),
(630201,'ServiceEngineer',630202,'Emails'),
(630204,'ServiceEngineer',630205,'Emails'),
(630207,'ServiceEngineer',630208,'Emails'),
(630210,'ServiceEngineer',630211,'Emails'),
(630213,'ServiceEngineer',630214,'Emails'),
(630216,'ServiceEngineer',630217,'Emails'),
(630222,'ServiceEngineer',630223,'Emails'),
(630225,'ServiceEngineer',630226,'Emails'),
(630228,'ServiceEngineer',630229,'Emails'),
(630231,'ServiceEngineer',630232,'Emails'),
(630234,'ServiceEngineer',630235,'Emails'),
(630237,'ServiceEngineer',630238,'Emails'),
(630240,'ServiceEngineer',630241,'Emails'),
(630244,'ServiceEngineer',630245,'Emails'),
(630247,'ServiceEngineer',630248,'Emails'),
(630250,'ServiceEngineer',630251,'Emails'),
(630253,'ServiceEngineer',630254,'Emails'),
(630256,'ServiceEngineer',630257,'Emails'),
(630259,'ServiceEngineer',630260,'Emails'),
(630262,'ServiceEngineer',630263,'Emails'),
(630265,'ServiceEngineer',630266,'Emails'),
(630268,'ServiceEngineer',630270,'Emails'),
(630272,'ServiceEngineer',630273,'Emails'),
(630275,'ServiceEngineer',630276,'Emails'),
(630278,'ServiceEngineer',630279,'Emails'),
(630281,'ServiceEngineer',630282,'Emails'),
(630284,'ServiceEngineer',630285,'Emails'),
(630287,'ServiceEngineer',630288,'Emails'),
(630290,'ServiceEngineer',630291,'Emails'),
(630293,'ServiceEngineer',630294,'Emails'),
(630296,'ServiceEngineer',630297,'Emails'),
(630300,'ServiceEngineer',630302,'Emails'),
(630306,'ServiceEngineer',630307,'Emails'),
(630309,'ServiceEngineer',630310,'Emails'),
(630312,'ServiceEngineer',630313,'Emails'),
(629922,'Leads',630315,'Emails'),
(629922,'Leads',630316,'Emails'),
(630317,'ServiceEngineer',630318,'Emails'),
(630320,'ServiceEngineer',630321,'Emails'),
(630323,'ServiceEngineer',630324,'Emails'),
(630347,'ServiceEngineer',630348,'Emails'),
(630350,'ServiceEngineer',630351,'Emails'),
(630353,'ServiceEngineer',630354,'Emails'),
(630937,'ServiceEngineer',630938,'Emails'),
(630940,'ServiceEngineer',630941,'Emails'),
(630940,'ServiceEngineer',630943,'Emails'),
(630945,'ServiceEngineer',630946,'Emails'),
(630945,'ServiceEngineer',630947,'Emails'),
(630948,'ServiceEngineer',630949,'Emails'),
(630948,'ServiceEngineer',630951,'Emails'),
(630953,'ServiceEngineer',630955,'Emails'),
(630953,'ServiceEngineer',630956,'Emails'),
(630967,'ServiceEngineer',630968,'Emails'),
(630967,'ServiceEngineer',630970,'Emails'),
(630967,'ServiceEngineer',630972,'Emails'),
(630989,'ServiceEngineer',630990,'Emails'),
(630989,'ServiceEngineer',630992,'Emails'),
(631020,'ServiceEngineer',631021,'Emails'),
(631020,'ServiceEngineer',631022,'Emails'),
(631024,'ServiceEngineer',631025,'Emails'),
(631024,'ServiceEngineer',631026,'Emails'),
(631028,'ServiceEngineer',631031,'Emails'),
(631028,'ServiceEngineer',631032,'Emails'),
(631028,'ServiceEngineer',631034,'Emails'),
(631037,'ServiceEngineer',631040,'Emails'),
(631037,'ServiceEngineer',631041,'Emails'),
(631051,'ServiceEngineer',631052,'Emails'),
(631051,'ServiceEngineer',631053,'Emails'),
(631054,'ServiceEngineer',631055,'Emails'),
(631054,'ServiceEngineer',631056,'Emails'),
(631189,'ServiceEngineer',631192,'Emails'),
(631189,'ServiceEngineer',631193,'Emails'),
(631203,'ServiceEngineer',631204,'Emails'),
(631203,'ServiceEngineer',631205,'Emails'),
(631203,'ServiceEngineer',631207,'Emails'),
(631210,'ServiceEngineer',631211,'Emails'),
(631214,'ServiceEngineer',631215,'Emails'),
(631214,'ServiceEngineer',631216,'Emails'),
(631218,'ServiceEngineer',631219,'Emails'),
(631218,'ServiceEngineer',631220,'Emails'),
(631240,'ServiceEngineer',631241,'Emails'),
(631240,'ServiceEngineer',631242,'Emails'),
(631244,'ServiceEngineer',631245,'Emails'),
(631244,'ServiceEngineer',631246,'Emails'),
(631248,'ServiceEngineer',631249,'Emails'),
(631248,'ServiceEngineer',631250,'Emails'),
(631252,'ServiceEngineer',631253,'Emails'),
(631252,'ServiceEngineer',631254,'Emails'),
(631272,'ServiceEngineer',631273,'Emails'),
(631275,'ServiceEngineer',631276,'Emails'),
(631275,'ServiceEngineer',631277,'Emails'),
(631278,'ServiceEngineer',631279,'Emails'),
(631278,'ServiceEngineer',631280,'Emails'),
(631281,'ServiceEngineer',631282,'Emails'),
(631281,'ServiceEngineer',631283,'Emails'),
(631284,'ServiceEngineer',631285,'Emails'),
(631284,'ServiceEngineer',631286,'Emails'),
(631287,'ServiceEngineer',631288,'Emails'),
(631287,'ServiceEngineer',631289,'Emails'),
(631291,'ServiceEngineer',631292,'Emails'),
(631291,'ServiceEngineer',631293,'Emails'),
(631294,'ServiceEngineer',631295,'Emails'),
(631294,'ServiceEngineer',631296,'Emails'),
(631297,'ServiceEngineer',631298,'Emails'),
(631297,'ServiceEngineer',631299,'Emails'),
(631302,'ServiceEngineer',631303,'Emails'),
(631302,'ServiceEngineer',631304,'Emails'),
(631307,'ServiceEngineer',631308,'Emails'),
(631307,'ServiceEngineer',631309,'Emails'),
(631311,'ServiceEngineer',631312,'Emails'),
(631311,'ServiceEngineer',631313,'Emails'),
(631314,'ServiceEngineer',631315,'Emails'),
(631314,'ServiceEngineer',631316,'Emails'),
(631319,'ServiceEngineer',631320,'Emails'),
(631319,'ServiceEngineer',631321,'Emails'),
(631328,'ServiceEngineer',631329,'Emails'),
(631328,'ServiceEngineer',631330,'Emails'),
(631351,'ServiceEngineer',631352,'Emails'),
(631351,'ServiceEngineer',631353,'Emails'),
(631355,'ServiceEngineer',631358,'Emails'),
(631355,'ServiceEngineer',631359,'Emails'),
(631355,'ServiceEngineer',631361,'Emails'),
(631369,'ServiceEngineer',631370,'Emails'),
(631369,'ServiceEngineer',631371,'Emails'),
(631374,'ServiceEngineer',631377,'Emails'),
(631374,'ServiceEngineer',631378,'Emails'),
(631399,'ServiceEngineer',631400,'Emails'),
(631399,'ServiceEngineer',631401,'Emails'),
(631403,'ServiceEngineer',631406,'Emails'),
(631403,'ServiceEngineer',631407,'Emails'),
(631427,'ServiceEngineer',631428,'Emails'),
(631427,'ServiceEngineer',631429,'Emails'),
(631430,'ServiceEngineer',631431,'Emails'),
(631430,'ServiceEngineer',631432,'Emails'),
(631434,'ServiceEngineer',631435,'Emails'),
(631434,'ServiceEngineer',631436,'Emails'),
(631438,'ServiceEngineer',631439,'Emails'),
(631438,'ServiceEngineer',631440,'Emails'),
(631441,'ServiceEngineer',631442,'Emails'),
(631441,'ServiceEngineer',631443,'Emails'),
(631444,'ServiceEngineer',631445,'Emails'),
(631444,'ServiceEngineer',631446,'Emails'),
(631447,'ServiceEngineer',631448,'Emails'),
(631449,'ServiceEngineer',631450,'Emails'),
(631449,'ServiceEngineer',631451,'Emails'),
(631453,'ServiceEngineer',631454,'Emails'),
(631453,'ServiceEngineer',631455,'Emails'),
(631453,'ServiceEngineer',631456,'Emails'),
(631457,'ServiceEngineer',631458,'Emails'),
(631457,'ServiceEngineer',631459,'Emails'),
(631457,'ServiceEngineer',631460,'Emails'),
(631461,'ServiceEngineer',631462,'Emails'),
(631461,'ServiceEngineer',631463,'Emails'),
(631469,'ServiceEngineer',631470,'Emails'),
(631469,'ServiceEngineer',631471,'Emails'),
(631473,'ServiceEngineer',631474,'Emails'),
(631473,'ServiceEngineer',631475,'Emails'),
(631479,'ServiceEngineer',631480,'Emails'),
(631479,'ServiceEngineer',631481,'Emails'),
(631483,'ServiceEngineer',631484,'Emails'),
(631483,'ServiceEngineer',631485,'Emails'),
(631486,'ServiceEngineer',631487,'Emails'),
(631486,'ServiceEngineer',631488,'Emails'),
(631492,'ServiceEngineer',631493,'Emails'),
(631492,'ServiceEngineer',631494,'Emails'),
(631495,'ServiceEngineer',631496,'Emails'),
(631495,'ServiceEngineer',631497,'Emails'),
(631495,'ServiceEngineer',631499,'Emails'),
(631500,'ServiceEngineer',631501,'Emails'),
(631500,'ServiceEngineer',631502,'Emails'),
(631503,'ServiceEngineer',631504,'Emails'),
(631503,'ServiceEngineer',631505,'Emails'),
(631509,'ServiceEngineer',631510,'Emails'),
(631509,'ServiceEngineer',631511,'Emails'),
(631512,'ServiceEngineer',631513,'Emails'),
(631512,'ServiceEngineer',631514,'Emails'),
(631515,'ServiceEngineer',631516,'Emails'),
(631515,'ServiceEngineer',631517,'Emails'),
(631518,'ServiceEngineer',631519,'Emails'),
(631518,'ServiceEngineer',631520,'Emails'),
(631522,'ServiceEngineer',631523,'Emails'),
(631522,'ServiceEngineer',631524,'Emails'),
(631527,'ServiceEngineer',631528,'Emails'),
(631527,'ServiceEngineer',631529,'Emails'),
(631530,'ServiceEngineer',631531,'Emails'),
(631530,'ServiceEngineer',631532,'Emails'),
(631533,'ServiceEngineer',631534,'Emails'),
(631533,'ServiceEngineer',631535,'Emails'),
(631536,'ServiceEngineer',631537,'Emails'),
(631536,'ServiceEngineer',631538,'Emails'),
(631539,'ServiceEngineer',631540,'Emails'),
(631539,'ServiceEngineer',631541,'Emails'),
(631542,'ServiceEngineer',631543,'Emails'),
(631542,'ServiceEngineer',631544,'Emails'),
(631545,'ServiceEngineer',631546,'Emails'),
(631545,'ServiceEngineer',631547,'Emails'),
(631548,'ServiceEngineer',631549,'Emails'),
(631548,'ServiceEngineer',631550,'Emails'),
(631551,'ServiceEngineer',631552,'Emails'),
(631551,'ServiceEngineer',631553,'Emails'),
(631554,'ServiceEngineer',631555,'Emails'),
(631554,'ServiceEngineer',631556,'Emails'),
(631539,'ServiceEngineer',631559,'Emails'),
(631536,'ServiceEngineer',631562,'Emails'),
(631568,'ServiceEngineer',631569,'Emails'),
(631571,'ServiceEngineer',631572,'Emails'),
(631573,'ServiceEngineer',631574,'Emails'),
(631575,'ServiceEngineer',631576,'Emails'),
(631575,'ServiceEngineer',631577,'Emails'),
(631578,'ServiceEngineer',631579,'Emails'),
(631580,'ServiceEngineer',631581,'Emails'),
(631582,'ServiceEngineer',631583,'Emails'),
(631582,'ServiceEngineer',631584,'Emails'),
(631585,'ServiceEngineer',631586,'Emails'),
(631588,'ServiceEngineer',631589,'Emails'),
(631590,'ServiceEngineer',631591,'Emails'),
(631592,'ServiceEngineer',631593,'Emails'),
(631594,'ServiceEngineer',631595,'Emails'),
(631596,'ServiceEngineer',631597,'Emails'),
(631599,'ServiceEngineer',631600,'Emails'),
(631601,'ServiceEngineer',631602,'Emails'),
(631605,'ServiceEngineer',631606,'Emails'),
(631608,'ServiceEngineer',631609,'Emails'),
(631611,'ServiceEngineer',631612,'Emails'),
(631614,'ServiceEngineer',631615,'Emails'),
(631619,'ServiceEngineer',631620,'Emails'),
(631621,'ServiceEngineer',631622,'Emails'),
(631623,'ServiceEngineer',631624,'Emails'),
(631625,'ServiceEngineer',631626,'Emails'),
(631627,'ServiceEngineer',631628,'Emails'),
(631629,'ServiceEngineer',631630,'Emails'),
(631631,'ServiceEngineer',631632,'Emails'),
(631633,'ServiceEngineer',631636,'Emails'),
(631633,'ServiceEngineer',631637,'Emails'),
(631643,'ServiceEngineer',631644,'Emails'),
(631643,'ServiceEngineer',631645,'Emails'),
(631647,'ServiceEngineer',631648,'Emails'),
(631649,'ServiceEngineer',631650,'Emails'),
(631651,'ServiceEngineer',631652,'Emails'),
(631658,'ServiceEngineer',631659,'Emails'),
(631660,'ServiceEngineer',631661,'Emails'),
(631660,'ServiceEngineer',631662,'Emails'),
(631663,'ServiceEngineer',631664,'Emails'),
(631663,'ServiceEngineer',631665,'Emails'),
(631670,'ServiceEngineer',631671,'Emails'),
(631670,'ServiceEngineer',631672,'Emails'),
(631677,'ServiceEngineer',631678,'Emails'),
(631677,'ServiceEngineer',631679,'Emails'),
(631684,'ServiceEngineer',631685,'Emails'),
(631684,'ServiceEngineer',631686,'Emails'),
(631687,'ServiceEngineer',631688,'Emails'),
(631693,'ServiceEngineer',631694,'Emails'),
(631693,'ServiceEngineer',631695,'Emails'),
(631693,'ServiceEngineer',631696,'Emails'),
(631697,'ServiceEngineer',631698,'Emails'),
(631701,'ServiceEngineer',631702,'Emails'),
(631701,'ServiceEngineer',631703,'Emails'),
(631701,'ServiceEngineer',631704,'Emails'),
(631710,'ServiceEngineer',631711,'Emails'),
(631710,'ServiceEngineer',631712,'Emails'),
(631716,'ServiceEngineer',631717,'Emails'),
(631716,'ServiceEngineer',631718,'Emails'),
(631732,'ServiceEngineer',631733,'Emails'),
(631734,'ServiceEngineer',631735,'Emails'),
(631739,'ServiceEngineer',631740,'Emails'),
(631742,'ServiceEngineer',631743,'Emails'),
(631742,'ServiceEngineer',631744,'Emails'),
(631742,'ServiceEngineer',631746,'Emails'),
(631750,'ServiceEngineer',631751,'Emails'),
(631750,'ServiceEngineer',631752,'Emails'),
(631759,'ServiceEngineer',631760,'Emails'),
(631759,'ServiceEngineer',631761,'Emails'),
(631762,'ServiceEngineer',631763,'Emails'),
(631765,'ServiceEngineer',631766,'Emails'),
(631767,'ServiceEngineer',631768,'Emails'),
(631772,'ServiceEngineer',631773,'Emails'),
(631774,'ServiceEngineer',631775,'Emails'),
(631777,'ServiceEngineer',631778,'Emails'),
(631780,'ServiceEngineer',631781,'Emails'),
(631794,'ServiceEngineer',631795,'Emails'),
(631808,'ServiceEngineer',631809,'Emails'),
(631808,'ServiceEngineer',631810,'Emails'),
(631825,'ServiceEngineer',631826,'Emails'),
(631825,'ServiceEngineer',631827,'Emails'),
(631832,'ServiceEngineer',631833,'Emails'),
(631832,'ServiceEngineer',631834,'Emails'),
(631836,'ServiceEngineer',631837,'Emails'),
(631836,'ServiceEngineer',631838,'Emails'),
(631860,'ServiceEngineer',631861,'Emails'),
(631860,'ServiceEngineer',631862,'Emails'),
(631866,'ServiceEngineer',631867,'Emails'),
(631866,'ServiceEngineer',631868,'Emails'),
(631871,'ServiceEngineer',631872,'Emails'),
(631871,'ServiceEngineer',631873,'Emails'),
(631874,'ServiceEngineer',631875,'Emails'),
(631874,'ServiceEngineer',631876,'Emails'),
(631877,'ServiceEngineer',631878,'Emails'),
(631877,'ServiceEngineer',631879,'Emails'),
(631881,'ServiceEngineer',631882,'Emails'),
(631881,'ServiceEngineer',631883,'Emails'),
(631887,'ServiceEngineer',631888,'Emails'),
(631887,'ServiceEngineer',631889,'Emails'),
(631893,'ServiceEngineer',631894,'Emails'),
(631891,'ServiceEngineer',631892,'Emails'),
(631893,'ServiceEngineer',631895,'Emails'),
(631891,'ServiceEngineer',631896,'Emails'),
(631901,'ServiceEngineer',631902,'Emails'),
(631901,'ServiceEngineer',631903,'Emails'),
(631905,'ServiceEngineer',631906,'Emails'),
(631905,'ServiceEngineer',631907,'Emails'),
(631909,'ServiceEngineer',631912,'Emails'),
(631909,'ServiceEngineer',631913,'Emails'),
(631909,'ServiceEngineer',631915,'Emails'),
(631916,'ServiceEngineer',631917,'Emails'),
(631916,'ServiceEngineer',631918,'Emails'),
(631921,'ServiceEngineer',631922,'Emails'),
(631921,'ServiceEngineer',631923,'Emails'),
(631938,'ServiceEngineer',631939,'Emails'),
(631938,'ServiceEngineer',631940,'Emails'),
(631938,'ServiceEngineer',631942,'Emails'),
(631943,'ServiceEngineer',631946,'Emails'),
(631943,'ServiceEngineer',631947,'Emails'),
(631949,'ServiceEngineer',631952,'Emails'),
(631949,'ServiceEngineer',631953,'Emails'),
(631955,'ServiceEngineer',631958,'Emails'),
(631955,'ServiceEngineer',631959,'Emails'),
(631997,'ServiceEngineer',631998,'Emails'),
(631997,'ServiceEngineer',631999,'Emails'),
(632001,'ServiceEngineer',632002,'Emails'),
(632001,'ServiceEngineer',632003,'Emails'),
(632005,'ServiceEngineer',632006,'Emails'),
(632005,'ServiceEngineer',632007,'Emails'),
(632042,'ServiceEngineer',632045,'Emails'),
(632042,'ServiceEngineer',632046,'Emails'),
(632056,'ServiceEngineer',632057,'Emails'),
(632056,'ServiceEngineer',632058,'Emails'),
(632073,'ServiceEngineer',632074,'Emails'),
(632073,'ServiceEngineer',632075,'Emails'),
(632076,'ServiceEngineer',632077,'Emails'),
(632076,'ServiceEngineer',632078,'Emails'),
(632079,'ServiceEngineer',632080,'Emails'),
(632079,'ServiceEngineer',632081,'Emails'),
(632082,'ServiceEngineer',632083,'Emails'),
(632082,'ServiceEngineer',632084,'Emails'),
(632076,'ServiceEngineer',632086,'Emails'),
(632088,'ServiceEngineer',632089,'Emails'),
(632088,'ServiceEngineer',632090,'Emails'),
(632092,'ServiceEngineer',632093,'Emails'),
(632092,'ServiceEngineer',632094,'Emails'),
(632096,'ServiceEngineer',632097,'Emails'),
(632096,'ServiceEngineer',632098,'Emails'),
(632102,'ServiceEngineer',632103,'Emails'),
(632102,'ServiceEngineer',632104,'Emails'),
(632105,'ServiceEngineer',632106,'Emails'),
(632105,'ServiceEngineer',632107,'Emails'),
(632112,'ServiceEngineer',632113,'Emails'),
(632112,'ServiceEngineer',632114,'Emails'),
(632115,'ServiceEngineer',632116,'Emails'),
(632115,'ServiceEngineer',632117,'Emails'),
(632120,'ServiceEngineer',632121,'Emails'),
(632120,'ServiceEngineer',632122,'Emails'),
(632123,'ServiceEngineer',632124,'Emails'),
(632123,'ServiceEngineer',632125,'Emails'),
(632127,'ServiceEngineer',632128,'Emails'),
(632127,'ServiceEngineer',632129,'Emails'),
(632132,'ServiceEngineer',632133,'Emails'),
(632132,'ServiceEngineer',632134,'Emails'),
(632138,'ServiceEngineer',632139,'Emails'),
(632138,'ServiceEngineer',632140,'Emails'),
(632148,'ServiceEngineer',632149,'Emails'),
(632148,'ServiceEngineer',632150,'Emails'),
(632148,'ServiceEngineer',632151,'Emails'),
(632153,'ServiceEngineer',632154,'Emails'),
(632153,'ServiceEngineer',632155,'Emails'),
(632157,'ServiceEngineer',632158,'Emails'),
(632157,'ServiceEngineer',632159,'Emails'),
(632161,'ServiceEngineer',632162,'Emails'),
(632161,'ServiceEngineer',632163,'Emails'),
(632164,'ServiceEngineer',632165,'Emails'),
(632164,'ServiceEngineer',632166,'Emails'),
(632164,'ServiceEngineer',632167,'Emails'),
(632173,'ServiceEngineer',632174,'Emails'),
(632173,'ServiceEngineer',632175,'Emails'),
(632173,'ServiceEngineer',632177,'Emails'),
(632178,'ServiceEngineer',632179,'Emails'),
(632178,'ServiceEngineer',632180,'Emails'),
(632178,'ServiceEngineer',632184,'Emails'),
(632190,'ServiceEngineer',632191,'Emails'),
(632190,'ServiceEngineer',632192,'Emails'),
(632195,'ServiceEngineer',632196,'Emails'),
(632195,'ServiceEngineer',632197,'Emails'),
(632195,'ServiceEngineer',632200,'Emails'),
(632203,'ServiceEngineer',632204,'Emails'),
(632203,'ServiceEngineer',632205,'Emails'),
(632207,'ServiceEngineer',632208,'Emails'),
(632207,'ServiceEngineer',632209,'Emails'),
(632211,'ServiceEngineer',632212,'Emails'),
(632211,'ServiceEngineer',632213,'Emails'),
(632215,'ServiceEngineer',632216,'Emails'),
(632215,'ServiceEngineer',632217,'Emails'),
(632220,'ServiceEngineer',632221,'Emails'),
(632220,'ServiceEngineer',632222,'Emails'),
(632225,'ServiceEngineer',632226,'Emails'),
(632225,'ServiceEngineer',632227,'Emails'),
(632230,'ServiceEngineer',632233,'Emails'),
(632230,'ServiceEngineer',632234,'Emails'),
(632239,'ServiceEngineer',632242,'Emails'),
(632239,'ServiceEngineer',632243,'Emails'),
(632239,'ServiceEngineer',632245,'Emails'),
(632246,'ServiceEngineer',632249,'Emails'),
(632246,'ServiceEngineer',632250,'Emails'),
(632255,'ServiceEngineer',632256,'Emails'),
(632255,'ServiceEngineer',632257,'Emails'),
(632255,'ServiceEngineer',632260,'Emails'),
(632261,'ServiceEngineer',632262,'Emails'),
(632261,'ServiceEngineer',632263,'Emails'),
(632261,'ServiceEngineer',632266,'Emails'),
(632267,'ServiceEngineer',632270,'Emails'),
(632267,'ServiceEngineer',632271,'Emails'),
(632273,'ServiceEngineer',632276,'Emails'),
(632273,'ServiceEngineer',632277,'Emails'),
(632279,'ServiceEngineer',632282,'Emails'),
(632279,'ServiceEngineer',632283,'Emails'),
(632279,'ServiceEngineer',632285,'Emails'),
(632298,'ServiceEngineer',632301,'Emails'),
(632298,'ServiceEngineer',632302,'Emails'),
(632298,'ServiceEngineer',632304,'Emails'),
(632322,'ServiceEngineer',632325,'Emails'),
(632322,'ServiceEngineer',632326,'Emails'),
(632322,'ServiceEngineer',632328,'Emails'),
(632329,'ServiceEngineer',632330,'Emails'),
(632329,'ServiceEngineer',632331,'Emails'),
(632334,'HelpDesk',632335,'Emails'),
(632336,'HelpDesk',632337,'Emails'),
(632349,'HelpDesk',632350,'Emails'),
(632351,'HelpDesk',632352,'Emails'),
(632361,'HelpDesk',632364,'Emails'),
(632379,'ServiceEngineer',632380,'Emails'),
(632379,'ServiceEngineer',632381,'Emails'),
(632379,'ServiceEngineer',632384,'Emails'),
(632388,'ServiceEngineer',632389,'Emails'),
(632388,'ServiceEngineer',632390,'Emails'),
(632414,'HelpDesk',632415,'Emails'),
(632430,'ServiceEngineer',632431,'Emails'),
(632430,'ServiceEngineer',632432,'Emails'),
(632437,'ServiceEngineer',632438,'Emails'),
(632437,'ServiceEngineer',632439,'Emails'),
(632442,'ServiceEngineer',632444,'Emails'),
(632442,'ServiceEngineer',632445,'Emails'),
(632442,'ServiceEngineer',632447,'Emails'),
(632451,'ServiceEngineer',632452,'Emails'),
(632451,'ServiceEngineer',632453,'Emails'),
(632454,'ServiceEngineer',632455,'Emails'),
(632454,'ServiceEngineer',632456,'Emails'),
(632458,'ServiceEngineer',632461,'Emails'),
(632458,'ServiceEngineer',632462,'Emails'),
(632468,'ServiceEngineer',632469,'Emails'),
(632468,'ServiceEngineer',632470,'Emails'),
(632475,'ServiceEngineer',632478,'Emails'),
(632475,'ServiceEngineer',632479,'Emails'),
(632475,'ServiceEngineer',632481,'Emails'),
(632484,'ServiceEngineer',632485,'Emails'),
(632484,'ServiceEngineer',632486,'Emails'),
(632495,'ServiceEngineer',632496,'Emails'),
(632495,'ServiceEngineer',632497,'Emails'),
(632501,'ServiceEngineer',632502,'Emails'),
(632501,'ServiceEngineer',632503,'Emails'),
(632504,'ServiceEngineer',632505,'Emails'),
(632504,'ServiceEngineer',632506,'Emails'),
(632511,'ServiceEngineer',632512,'Emails'),
(632511,'ServiceEngineer',632513,'Emails'),
(632520,'ServiceEngineer',632521,'Emails'),
(632520,'ServiceEngineer',632522,'Emails'),
(632524,'ServiceEngineer',632525,'Emails'),
(632524,'ServiceEngineer',632527,'Emails'),
(632529,'ServiceEngineer',632530,'Emails'),
(632529,'ServiceEngineer',632531,'Emails'),
(632529,'ServiceEngineer',632533,'Emails'),
(632534,'ServiceEngineer',632535,'Emails'),
(632534,'ServiceEngineer',632536,'Emails'),
(632534,'ServiceEngineer',632538,'Emails'),
(632539,'ServiceEngineer',632540,'Emails'),
(632539,'ServiceEngineer',632541,'Emails'),
(632539,'ServiceEngineer',632543,'Emails'),
(632544,'ServiceEngineer',632545,'Emails'),
(632544,'ServiceEngineer',632546,'Emails'),
(632548,'ServiceEngineer',632549,'Emails'),
(632548,'ServiceEngineer',632550,'Emails'),
(632554,'ServiceEngineer',632555,'Emails'),
(632554,'ServiceEngineer',632556,'Emails'),
(632570,'ServiceEngineer',632573,'Emails'),
(632570,'ServiceEngineer',632574,'Emails'),
(632570,'ServiceEngineer',632576,'Emails'),
(632579,'ServiceEngineer',632580,'Emails'),
(632579,'ServiceEngineer',632581,'Emails'),
(632583,'ServiceEngineer',632584,'Emails'),
(632583,'ServiceEngineer',632585,'Emails'),
(632593,'ServiceEngineer',632594,'Emails'),
(632593,'ServiceEngineer',632595,'Emails'),
(632598,'ServiceEngineer',632601,'Emails'),
(632598,'ServiceEngineer',632602,'Emails'),
(632605,'HelpDesk',632608,'Emails'),
(632609,'ServiceEngineer',632610,'Emails'),
(632609,'ServiceEngineer',632611,'Emails'),
(632613,'ServiceEngineer',632614,'Emails'),
(632613,'ServiceEngineer',632615,'Emails'),
(632623,'ServiceEngineer',632624,'Emails'),
(632623,'ServiceEngineer',632625,'Emails'),
(632626,'ServiceEngineer',632627,'Emails'),
(632626,'ServiceEngineer',632629,'Emails'),
(632653,'ServiceEngineer',632654,'Emails'),
(632653,'ServiceEngineer',632655,'Emails'),
(632662,'ServiceEngineer',632663,'Emails'),
(632662,'ServiceEngineer',632664,'Emails'),
(632669,'ServiceEngineer',632670,'Emails'),
(632669,'ServiceEngineer',632671,'Emails'),
(632675,'ServiceEngineer',632676,'Emails'),
(632675,'ServiceEngineer',632677,'Emails'),
(632681,'ServiceEngineer',632682,'Emails'),
(632681,'ServiceEngineer',632683,'Emails'),
(632688,'ServiceEngineer',632689,'Emails'),
(632688,'ServiceEngineer',632690,'Emails'),
(632697,'ServiceEngineer',632698,'Emails'),
(632697,'ServiceEngineer',632699,'Emails'),
(632701,'ServiceEngineer',632702,'Emails'),
(632701,'ServiceEngineer',632703,'Emails'),
(632715,'ServiceEngineer',632716,'Emails'),
(632715,'ServiceEngineer',632717,'Emails'),
(632719,'Owner',632720,'Resident'),
(632725,'ServiceEngineer',632726,'Emails'),
(632725,'ServiceEngineer',632727,'Emails'),
(632729,'ServiceEngineer',632732,'Emails'),
(632729,'ServiceEngineer',632733,'Emails'),
(632729,'ServiceEngineer',632735,'Emails'),
(632736,'ServiceEngineer',632739,'Emails'),
(632736,'ServiceEngineer',632740,'Emails'),
(632736,'ServiceEngineer',632742,'Emails'),
(632743,'Owner',632744,'Resident'),
(632745,'HelpDesk',632746,'Emails'),
(632749,'HelpDesk',632752,'Emails'),
(632754,'HelpDesk',632757,'Emails'),
(632758,'HelpDesk',632761,'Emails'),
(632764,'HelpDesk',632767,'Emails'),
(632809,'HelpDesk',632812,'Emails'),
(632813,'HelpDesk',632816,'Emails'),
(632817,'HelpDesk',632820,'Emails'),
(632837,'HelpDesk',632838,'Emails'),
(632843,'HelpDesk',632844,'Emails'),
(632846,'HelpDesk',632849,'Emails'),
(632850,'HelpDesk',632851,'Emails'),
(632861,'HelpDesk',632862,'Emails'),
(632865,'Owner',632866,'Resident'),
(632868,'ServiceEngineer',632869,'Emails'),
(632868,'ServiceEngineer',632870,'Emails'),
(632872,'ServiceEngineer',632873,'Emails'),
(632872,'ServiceEngineer',632874,'Emails'),
(632872,'ServiceEngineer',632878,'Emails'),
(632888,'ServiceEngineer',632889,'Emails'),
(632888,'ServiceEngineer',632890,'Emails'),
(632888,'ServiceEngineer',632894,'Emails'),
(632929,'HelpDesk',632930,'Emails'),
(632931,'HelpDesk',632934,'Emails'),
(632949,'HelpDesk',632950,'Emails'),
(632968,'HelpDesk',632969,'Emails'),
(632988,'ServiceEngineer',632989,'Emails'),
(632988,'ServiceEngineer',632990,'Emails'),
(633003,'ServiceEngineer',633004,'Emails'),
(633003,'ServiceEngineer',633005,'Emails'),
(633008,'ServiceEngineer',633009,'Emails'),
(633008,'ServiceEngineer',633010,'Emails'),
(633028,'ServiceEngineer',633029,'Emails'),
(633028,'ServiceEngineer',633030,'Emails'),
(633036,'DomesticHelp',633039,'GatePass'),
(633033,'DomesticHelp',633041,'GatePass'),
(633046,'HelpDesk',633047,'Emails'),
(629946,'Contacts',633046,'HelpDesk'),
(633048,'Owner',633049,'Resident'),
(632992,'Plat',633048,'Owner'),
(633062,'HelpDesk',633066,'Emails'),
(633112,'HelpDesk',633113,'Emails'),
(633147,'ServiceEngineer',633148,'Emails'),
(633147,'ServiceEngineer',633149,'Emails'),
(633152,'ServiceEngineer',633153,'Emails'),
(633152,'ServiceEngineer',633154,'Emails'),
(633157,'ServiceEngineer',633158,'Emails'),
(633157,'ServiceEngineer',633159,'Emails'),
(633155,'Accounts',633163,'SocBlocks'),
(633164,'ServiceEngineer',633165,'Emails'),
(633164,'ServiceEngineer',633166,'Emails'),
(633168,'ServiceEngineer',633169,'Emails'),
(633168,'ServiceEngineer',633170,'Emails'),
(633172,'ServiceEngineer',633173,'Emails'),
(633172,'ServiceEngineer',633174,'Emails'),
(633176,'ServiceEngineer',633177,'Emails'),
(633176,'ServiceEngineer',633178,'Emails'),
(633176,'ServiceEngineer',633179,'Emails'),
(633182,'ServiceEngineer',633183,'Emails'),
(633182,'ServiceEngineer',633184,'Emails'),
(633185,'Accounts',633186,'SocBlocks'),
(633185,'Accounts',633190,'SocBlocks'),
(633185,'Accounts',633192,'Plat'),
(633185,'Accounts',633193,'Plat'),
(633185,'Accounts',633194,'Plat'),
(633195,'ServiceEngineer',633196,'Emails'),
(633195,'ServiceEngineer',633197,'Emails'),
(633195,'ServiceEngineer',633198,'Emails'),
(633200,'ServiceEngineer',633201,'Emails'),
(633200,'ServiceEngineer',633202,'Emails'),
(633200,'ServiceEngineer',633203,'Emails'),
(633205,'ServiceEngineer',633206,'Emails'),
(633205,'ServiceEngineer',633207,'Emails'),
(633212,'ServiceEngineer',633213,'Emails'),
(633212,'ServiceEngineer',633214,'Emails'),
(633212,'ServiceEngineer',633215,'Emails'),
(633217,'ServiceEngineer',633218,'Emails'),
(633217,'ServiceEngineer',633219,'Emails'),
(633217,'ServiceEngineer',633220,'Emails'),
(633185,'Accounts',633229,'SocBlocks'),
(633185,'Accounts',633230,'SocBlocks'),
(633185,'Accounts',633231,'Plat'),
(633233,'ServiceEngineer',633234,'Emails'),
(633233,'ServiceEngineer',633235,'Emails'),
(633233,'ServiceEngineer',633236,'Emails'),
(633242,'ServiceEngineer',633243,'Emails'),
(633242,'ServiceEngineer',633244,'Emails'),
(633237,'Accounts',633248,'SocBlocks'),
(633237,'Accounts',633249,'Plat'),
(633237,'Accounts',633251,'SocBlocks'),
(633254,'ServiceEngineer',633255,'Emails'),
(633254,'ServiceEngineer',633256,'Emails'),
(633254,'ServiceEngineer',633257,'Emails'),
(633259,'ServiceEngineer',633260,'Emails'),
(633259,'ServiceEngineer',633261,'Emails'),
(633259,'ServiceEngineer',633262,'Emails'),
(633263,'Accounts',633269,'SocBlocks'),
(632059,'Accounts',633270,'SocBlocks'),
(633263,'Accounts',633273,'SocBlocks'),
(633276,'Owner',633277,'Resident'),
(633283,'ServiceEngineer',633284,'Emails'),
(633283,'ServiceEngineer',633285,'Emails'),
(633283,'ServiceEngineer',633286,'Emails'),
(633287,'Accounts',633288,'SocBlocks'),
(633287,'Accounts',633289,'Plat'),
(633295,'ServiceEngineer',633296,'Emails'),
(633295,'ServiceEngineer',633297,'Emails'),
(633295,'ServiceEngineer',633298,'Emails'),
(633299,'Accounts',633300,'SocBlocks'),
(633299,'Accounts',633301,'Plat'),
(633302,'Owner',633303,'Resident'),
(633305,'ServiceEngineer',633306,'Emails'),
(633305,'ServiceEngineer',633307,'Emails'),
(633305,'ServiceEngineer',633308,'Emails'),
(633309,'Accounts',633310,'SocBlocks'),
(633309,'Accounts',633311,'SocBlocks'),
(633309,'Accounts',633312,'SocBlocks'),
(633309,'Accounts',633313,'Plat'),
(633309,'Accounts',633314,'Plat'),
(633309,'Accounts',633315,'Plat'),
(633316,'Owner',633317,'Resident'),
(633322,'ServiceEngineer',633323,'Emails'),
(633322,'ServiceEngineer',633324,'Emails'),
(633343,'ServiceEngineer',633344,'Emails'),
(633343,'ServiceEngineer',633345,'Emails'),
(633343,'ServiceEngineer',633346,'Emails'),
(633347,'Accounts',633348,'SocBlocks'),
(633347,'Accounts',633349,'SocBlocks'),
(633347,'Accounts',633350,'Plat'),
(633347,'Accounts',633356,'Plat'),
(0,'Owner',633371,'Resident'),
(633356,'Owner',633374,'Resident'),
(633314,'Owner',633377,'Resident'),
(633384,'ServiceEngineer',633385,'Emails'),
(633384,'ServiceEngineer',633386,'Emails'),
(633384,'ServiceEngineer',633387,'Emails'),
(633389,'ServiceEngineer',633390,'Emails'),
(633389,'ServiceEngineer',633391,'Emails'),
(0,'Owner',633398,'Resident'),
(0,'Owner',633435,'Resident'),
(0,'Owner',633438,'Resident'),
(0,'Owner',633505,'Resident'),
(633517,'ServiceEngineer',633518,'Emails'),
(633517,'ServiceEngineer',633519,'Emails'),
(633517,'ServiceEngineer',633520,'Emails'),
(633525,'ServiceEngineer',633526,'Emails'),
(633525,'ServiceEngineer',633527,'Emails'),
(633525,'ServiceEngineer',633528,'Emails'),
(0,'Owner',633551,'Resident'),
(633301,'Owner',633618,'Resident'),
(0,'Owner',633621,'Resident'),
(0,'Owner',633624,'Resident'),
(0,'Owner',633631,'Resident'),
(0,'Owner',633633,'Resident'),
(633634,'ServiceEngineer',633635,'Emails'),
(633634,'ServiceEngineer',633636,'Emails'),
(633634,'ServiceEngineer',633637,'GuardDir'),
(633634,'ServiceEngineer',633639,'GuardDir'),
(0,'Owner',633642,'Resident'),
(0,'Owner',633646,'Resident'),
(0,'Owner',633649,'Resident'),
(633645,'Owner',633650,'Emails'),
(633350,'Owner',633652,'Resident'),
(633356,'Owner',633655,'Resident'),
(633657,'ServiceEngineer',633658,'Emails'),
(633657,'ServiceEngineer',633659,'Emails'),
(633657,'ServiceEngineer',633660,'Emails'),
(633313,'Owner',633663,'Resident'),
(633662,'Owner',633664,'Emails'),
(633289,'Owner',633667,'Resident'),
(633231,'Owner',633670,'Resident'),
(0,'Owner',633673,'Resident'),
(633672,'Owner',633674,'Emails'),
(0,'Owner',633677,'Resident'),
(633676,'Owner',633678,'Emails'),
(0,'Owner',633681,'Resident'),
(0,'Owner',633684,'Resident'),
(0,'Owner',633686,'Resident'),
(0,'Owner',633688,'Resident'),
(0,'Owner',633690,'Resident'),
(0,'Owner',633693,'Resident'),
(0,'Owner',633695,'Resident'),
(0,'Owner',633697,'Resident'),
(633356,'Owner',633699,'Resident'),
(0,'Owner',633701,'Resident'),
(0,'Owner',633704,'Resident'),
(633703,'Owner',633705,'Emails'),
(633350,'Owner',633708,'Resident'),
(0,'Owner',633711,'Resident'),
(0,'Owner',633713,'Resident'),
(633582,'DomesticHelp',633714,'Inout'),
(0,'Owner',633737,'Resident'),
(0,'Owner',633741,'Resident'),
(0,'Owner',633745,'Resident'),
(633740,'Owner',633746,'Emails'),
(0,'Owner',633750,'Resident'),
(0,'Owner',633753,'Resident'),
(0,'Owner',633759,'Resident'),
(633758,'Owner',633761,'Emails'),
(0,'Owner',633762,'Resident'),
(633758,'Owner',633763,'Emails'),
(633314,'Owner',633767,'Resident'),
(633315,'Owner',633776,'Resident'),
(0,'Owner',633782,'Resident'),
(0,'Owner',633796,'Resident'),
(633803,'ServiceEngineer',633804,'Emails'),
(633803,'ServiceEngineer',633805,'Emails'),
(633803,'ServiceEngineer',633806,'Emails'),
(633810,'ServiceEngineer',633811,'Emails'),
(633810,'ServiceEngineer',633812,'Emails'),
(633810,'ServiceEngineer',633813,'Emails'),
(633817,'ServiceEngineer',633820,'Emails'),
(633817,'ServiceEngineer',633821,'Emails'),
(633817,'ServiceEngineer',633822,'Emails'),
(633824,'ServiceEngineer',633826,'Emails'),
(633824,'ServiceEngineer',633827,'Emails'),
(633824,'ServiceEngineer',633828,'Emails'),
(633830,'ServiceEngineer',633832,'Emails'),
(633830,'ServiceEngineer',633833,'Emails'),
(633830,'ServiceEngineer',633834,'Emails'),
(633838,'ServiceEngineer',633839,'Emails'),
(633838,'ServiceEngineer',633840,'Emails'),
(633838,'ServiceEngineer',633841,'Emails'),
(633845,'ServiceEngineer',633846,'Emails'),
(633845,'ServiceEngineer',633847,'Emails'),
(633845,'ServiceEngineer',633848,'Emails'),
(633851,'ServiceEngineer',633852,'Emails'),
(633851,'ServiceEngineer',633853,'Emails'),
(633851,'ServiceEngineer',633854,'Emails'),
(633860,'ServiceEngineer',633861,'Emails'),
(633860,'ServiceEngineer',633862,'Emails'),
(633860,'ServiceEngineer',633863,'Emails'),
(0,'Owner',633872,'Resident'),
(633874,'ServiceEngineer',633875,'Emails'),
(633874,'ServiceEngineer',633876,'Emails'),
(633904,'ServiceEngineer',633905,'Emails'),
(633904,'ServiceEngineer',633906,'Emails'),
(0,'Owner',633914,'Resident'),
(633925,'ServiceEngineer',633926,'Emails'),
(633925,'ServiceEngineer',633927,'Emails'),
(0,'Owner',633937,'Resident'),
(0,'Owner',633938,'Resident'),
(0,'Owner',633939,'Resident'),
(633313,'Owner',633940,'Resident'),
(0,'Owner',633952,'Resident'),
(0,'Owner',633962,'Resident'),
(0,'Owner',633964,'Resident'),
(0,'Owner',633966,'Resident'),
(0,'Owner',633969,'Resident'),
(0,'Owner',633972,'Resident'),
(0,'Owner',633974,'Resident'),
(0,'Owner',633976,'Resident'),
(0,'Owner',633978,'Resident'),
(0,'Owner',633980,'Resident'),
(633314,'Owner',633982,'Resident'),
(633314,'Owner',633984,'Resident'),
(633313,'Owner',633987,'Resident'),
(633313,'Owner',634005,'Resident'),
(633313,'Owner',634009,'Resident'),
(633313,'Owner',634012,'Resident'),
(0,'Owner',634014,'Resident'),
(633313,'Owner',634016,'Resident'),
(0,'Owner',634029,'Resident'),
(0,'Owner',634032,'Resident'),
(0,'Owner',634034,'Resident'),
(0,'Owner',634038,'Resident'),
(633314,'Owner',634041,'Resident'),
(633191,'Owner',634044,'Resident'),
(633191,'Owner',634046,'Resident'),
(0,'Owner',634061,'Resident'),
(0,'Owner',634067,'Resident'),
(633191,'Owner',634070,'Resident'),
(633191,'Owner',634072,'Resident'),
(633191,'Owner',634076,'Resident'),
(634100,'ServiceEngineer',634101,'Emails'),
(634100,'ServiceEngineer',634103,'Emails'),
(634106,'ServiceEngineer',634107,'Emails'),
(634108,'ServiceEngineer',634109,'Emails'),
(634112,'ServiceEngineer',634113,'Emails'),
(634114,'ServiceEngineer',634115,'Emails'),
(634116,'ServiceEngineer',634117,'Emails'),
(634119,'ServiceEngineer',634120,'Emails'),
(634124,'ServiceEngineer',634126,'Emails'),
(634124,'ServiceEngineer',634127,'Emails'),
(634129,'ServiceEngineer',634130,'Emails'),
(634141,'ServiceEngineer',634142,'Emails'),
(633191,'Owner',634198,'Resident'),
(634236,'ServiceEngineer',634237,'Emails'),
(634236,'ServiceEngineer',634238,'Emails'),
(634241,'ServiceEngineer',634243,'Emails'),
(634241,'ServiceEngineer',634244,'Emails'),
(634250,'ServiceEngineer',634251,'Emails'),
(634254,'ServiceEngineer',634255,'Emails'),
(634254,'ServiceEngineer',634256,'Emails'),
(634260,'ServiceEngineer',634261,'Emails'),
(634260,'ServiceEngineer',634262,'Emails'),
(634268,'ServiceEngineer',634269,'Emails'),
(634268,'ServiceEngineer',634270,'Emails'),
(633191,'Owner',634277,'Resident'),
(633258,'Accounts',634288,'SocBlocks'),
(633258,'Accounts',634289,'Plat'),
(633191,'Owner',634297,'Resident'),
(634302,'ServiceEngineer',634303,'Emails'),
(634302,'ServiceEngineer',634304,'Emails'),
(634309,'ServiceEngineer',634310,'Emails'),
(634309,'ServiceEngineer',634311,'Emails'),
(634313,'ServiceEngineer',634314,'Emails'),
(634325,'HelpDesk',634326,'Emails'),
(634327,'HelpDesk',634328,'Emails'),
(633191,'Owner',634339,'Resident'),
(633191,'Owner',634341,'Resident'),
(633191,'Owner',634343,'Resident'),
(634350,'ServiceEngineer',634352,'Emails'),
(634350,'ServiceEngineer',634353,'Emails'),
(634350,'ServiceEngineer',634354,'GuardDir'),
(634350,'ServiceEngineer',634356,'GuardDir'),
(634350,'ServiceEngineer',634357,'GuardDir'),
(633191,'Owner',634372,'Resident'),
(634373,'ServiceEngineer',634376,'Emails'),
(634373,'ServiceEngineer',634377,'Emails'),
(634379,'ServiceEngineer',634382,'Emails'),
(634379,'ServiceEngineer',634383,'Emails'),
(634386,'ServiceEngineer',634389,'Emails'),
(634386,'ServiceEngineer',634390,'Emails'),
(633634,'ServiceEngineer',634393,'GuardDir'),
(634396,'ServiceEngineer',634399,'Emails'),
(634396,'ServiceEngineer',634400,'Emails'),
(634406,'ServiceEngineer',634407,'Emails'),
(634406,'ServiceEngineer',634408,'Emails'),
(634406,'ServiceEngineer',634409,'Emails'),
(634411,'ServiceEngineer',634414,'Emails'),
(634411,'ServiceEngineer',634415,'Emails'),
(634418,'ServiceEngineer',634419,'Emails'),
(634418,'ServiceEngineer',634420,'Emails'),
(634418,'ServiceEngineer',634421,'Emails'),
(634422,'ServiceEngineer',634423,'Emails'),
(634422,'ServiceEngineer',634424,'Emails'),
(634422,'ServiceEngineer',634425,'Emails'),
(634427,'ServiceEngineer',634428,'Emails'),
(634427,'ServiceEngineer',634429,'Emails'),
(634433,'ServiceEngineer',634434,'Emails'),
(634433,'ServiceEngineer',634435,'Emails'),
(634462,'HelpDesk',634464,'Emails'),
(634525,'HelpDesk',634526,'Emails'),
(634535,'ServiceEngineer',634536,'Emails'),
(634535,'ServiceEngineer',634537,'Emails'),
(634548,'ServiceEngineer',634549,'Emails'),
(634548,'ServiceEngineer',634550,'Emails'),
(634554,'ServiceEngineer',634555,'Emails'),
(634554,'ServiceEngineer',634556,'Emails'),
(634567,'ServiceEngineer',634568,'Emails'),
(634567,'ServiceEngineer',634569,'Emails'),
(634573,'ServiceEngineer',634574,'Emails'),
(634573,'ServiceEngineer',634575,'Emails'),
(634590,'ServiceEngineer',634591,'Emails'),
(634590,'ServiceEngineer',634592,'Emails'),
(634612,'ServiceEngineer',634613,'Emails'),
(634612,'ServiceEngineer',634614,'Emails'),
(632475,'ServiceEngineer',634631,'GuardDir'),
(634664,'ServiceEngineer',634665,'Emails'),
(634664,'ServiceEngineer',634666,'Emails'),
(634664,'ServiceEngineer',634667,'Emails'),
(634668,'Accounts',634669,'SocBlocks'),
(634668,'Accounts',634670,'SocBlocks'),
(634668,'Accounts',634671,'Plat'),
(634668,'Accounts',634672,'Plat'),
(633191,'Owner',634674,'Resident'),
(634681,'ServiceEngineer',634682,'Emails'),
(634681,'ServiceEngineer',634683,'GuardDir'),
(634681,'ServiceEngineer',634686,'GuardDir'),
(634681,'ServiceEngineer',634687,'GuardDir'),
(634690,'ServiceEngineer',634691,'Emails'),
(634690,'ServiceEngineer',634692,'Emails'),
(634668,'Accounts',634734,'Plat'),
(633529,'Accounts',634736,'Plat'),
(633529,'Accounts',634737,'SocBlocks'),
(634738,'ServiceEngineer',634739,'Emails'),
(634738,'ServiceEngineer',634740,'Emails'),
(634738,'ServiceEngineer',634741,'Emails'),
(634736,'Owner',634747,'Resident'),
(634791,'ServiceEngineer',634792,'Emails'),
(634791,'ServiceEngineer',634793,'Emails'),
(634807,'ServiceEngineer',634808,'Emails'),
(634809,'ServiceEngineer',634810,'Emails'),
(634809,'ServiceEngineer',634811,'Emails'),
(634812,'ServiceEngineer',634813,'Emails'),
(634812,'ServiceEngineer',634814,'Emails'),
(634812,'ServiceEngineer',634815,'GuardDir'),
(0,'Owner',634824,'Resident'),
(0,'Owner',634827,'Resident'),
(634855,'ServiceEngineer',634856,'Emails'),
(634858,'ServiceEngineer',634859,'Emails'),
(634858,'ServiceEngineer',634860,'Emails'),
(634865,'ServiceEngineer',634866,'Emails'),
(634865,'ServiceEngineer',634867,'Emails'),
(634865,'ServiceEngineer',634868,'Emails'),
(634870,'ServiceEngineer',634871,'Emails'),
(634870,'ServiceEngineer',634872,'Emails'),
(634870,'ServiceEngineer',634873,'Emails'),
(634875,'ServiceEngineer',634876,'Emails'),
(634875,'ServiceEngineer',634877,'Emails'),
(634875,'ServiceEngineer',634878,'Emails'),
(634879,'Accounts',634880,'SocBlocks'),
(634879,'Accounts',634881,'SocBlocks'),
(634879,'Accounts',634882,'SocBlocks'),
(634879,'Accounts',634883,'Plat'),
(634879,'Accounts',634884,'Plat'),
(634879,'Accounts',634885,'Plat'),
(634879,'Accounts',634886,'Plat'),
(634888,'ServiceEngineer',634889,'Emails'),
(634888,'ServiceEngineer',634890,'Emails'),
(634888,'ServiceEngineer',634891,'Emails'),
(634892,'Accounts',634894,'SocBlocks'),
(634892,'Accounts',634896,'SocBlocks'),
(634892,'Accounts',634897,'Plat'),
(634892,'Accounts',634898,'Plat'),
(634899,'ServiceEngineer',634900,'Emails'),
(634899,'ServiceEngineer',634901,'Emails'),
(634899,'ServiceEngineer',634902,'GuardDir'),
(634892,'Accounts',634903,'Plat'),
(634892,'Accounts',634904,'Plat'),
(633191,'Owner',634906,'Resident'),
(634907,'ServiceEngineer',634908,'Emails'),
(634907,'ServiceEngineer',634909,'Emails'),
(634907,'ServiceEngineer',634910,'Emails'),
(634912,'ServiceEngineer',634913,'Emails'),
(634912,'ServiceEngineer',634914,'Emails'),
(634912,'ServiceEngineer',634915,'Emails'),
(634918,'ServiceEngineer',634919,'Emails'),
(634918,'ServiceEngineer',634920,'Emails'),
(634918,'ServiceEngineer',634921,'Emails'),
(634922,'Accounts',634923,'SocBlocks'),
(634922,'Accounts',634924,'SocBlocks'),
(634922,'Accounts',634925,'Plat'),
(634922,'Accounts',634926,'Plat'),
(634922,'Accounts',634927,'Plat'),
(634922,'Accounts',634928,'Plat'),
(634931,'ServiceEngineer',634932,'Emails'),
(634931,'ServiceEngineer',634933,'Emails'),
(634931,'ServiceEngineer',634934,'Emails'),
(634935,'Accounts',634937,'SocBlocks'),
(634935,'Accounts',634938,'SocBlocks'),
(634935,'Accounts',634939,'SocBlocks'),
(634935,'Accounts',634941,'Plat'),
(634935,'Accounts',634942,'Plat'),
(634935,'Accounts',634943,'Plat'),
(634935,'Accounts',634944,'Plat'),
(634935,'Accounts',634945,'Plat'),
(634935,'Accounts',634946,'Plat'),
(634948,'ServiceEngineer',634949,'Emails'),
(634948,'ServiceEngineer',634950,'Emails'),
(634948,'ServiceEngineer',634951,'Emails'),
(634969,'ServiceEngineer',634970,'Emails'),
(634969,'ServiceEngineer',634971,'Emails'),
(634969,'ServiceEngineer',634972,'Emails'),
(634944,'Owner',634979,'Resident'),
(634980,'ServiceEngineer',634981,'Emails'),
(634980,'ServiceEngineer',634982,'Emails'),
(634980,'ServiceEngineer',634983,'Emails'),
(634986,'ServiceEngineer',634987,'Emails'),
(634986,'ServiceEngineer',634988,'Emails'),
(634986,'ServiceEngineer',634989,'Emails'),
(634946,'Owner',634994,'Resident'),
(634996,'ServiceEngineer',634997,'Emails'),
(634996,'ServiceEngineer',634998,'Emails'),
(634996,'ServiceEngineer',635000,'Emails'),
(635005,'ServiceEngineer',635006,'Emails'),
(635005,'ServiceEngineer',635007,'Emails'),
(635005,'ServiceEngineer',635008,'Emails'),
(635011,'ServiceEngineer',635012,'Emails'),
(635011,'ServiceEngineer',635013,'Emails'),
(635011,'ServiceEngineer',635014,'Emails'),
(635016,'ServiceEngineer',635017,'Emails'),
(635016,'ServiceEngineer',635018,'Emails'),
(635016,'ServiceEngineer',635019,'Emails'),
(635024,'ServiceEngineer',635025,'Emails'),
(635024,'ServiceEngineer',635026,'Emails'),
(635024,'ServiceEngineer',635027,'Emails'),
(635029,'ServiceEngineer',635030,'Emails'),
(635029,'ServiceEngineer',635031,'Emails'),
(635038,'ServiceEngineer',635039,'Emails'),
(635038,'ServiceEngineer',635040,'Emails'),
(635038,'ServiceEngineer',635041,'Emails'),
(635043,'ServiceEngineer',635044,'Emails'),
(635043,'ServiceEngineer',635045,'Emails'),
(635043,'ServiceEngineer',635046,'Emails'),
(635048,'ServiceEngineer',635049,'Emails'),
(635048,'ServiceEngineer',635050,'Emails'),
(635048,'ServiceEngineer',635051,'Emails'),
(635057,'ServiceEngineer',635058,'Emails'),
(635057,'ServiceEngineer',635059,'Emails'),
(635057,'ServiceEngineer',635060,'Emails'),
(635064,'ServiceEngineer',635065,'Emails'),
(635064,'ServiceEngineer',635066,'Emails'),
(635064,'ServiceEngineer',635067,'Emails'),
(635070,'ServiceEngineer',635071,'Emails'),
(635070,'ServiceEngineer',635072,'Emails'),
(635070,'ServiceEngineer',635073,'Emails'),
(635076,'ServiceEngineer',635077,'Emails'),
(635076,'ServiceEngineer',635078,'Emails'),
(635076,'ServiceEngineer',635079,'Emails'),
(635081,'ServiceEngineer',635082,'Emails'),
(635081,'ServiceEngineer',635083,'Emails'),
(635081,'ServiceEngineer',635084,'Emails'),
(635085,'ServiceEngineer',635086,'Emails'),
(635085,'ServiceEngineer',635087,'Emails'),
(635085,'ServiceEngineer',635088,'Emails'),
(635093,'ServiceEngineer',635094,'Emails'),
(635093,'ServiceEngineer',635095,'Emails'),
(635093,'ServiceEngineer',635096,'Emails'),
(635100,'ServiceEngineer',635101,'Emails'),
(635100,'ServiceEngineer',635102,'Emails'),
(635100,'ServiceEngineer',635103,'Emails'),
(635105,'ServiceEngineer',635106,'Emails'),
(635105,'ServiceEngineer',635107,'Emails'),
(635105,'ServiceEngineer',635108,'Emails'),
(635116,'ServiceEngineer',635117,'Emails'),
(635116,'ServiceEngineer',635118,'Emails'),
(635116,'ServiceEngineer',635119,'Emails'),
(0,'Owner',635137,'Resident'),
(635138,'ServiceEngineer',635141,'Emails'),
(635139,'ServiceEngineer',635142,'Emails'),
(635140,'ServiceEngineer',635143,'Emails'),
(635140,'ServiceEngineer',635144,'Emails'),
(635139,'ServiceEngineer',635145,'Emails'),
(635138,'ServiceEngineer',635146,'Emails'),
(633191,'Owner',635148,'Resident'),
(635584,'ServiceEngineer',635585,'Emails'),
(635584,'ServiceEngineer',635648,'Emails'),
(638845,'ServiceEngineer',638847,'Emails'),
(638845,'ServiceEngineer',638848,'Emails'),
(638845,'ServiceEngineer',638849,'GuardDir'),
(638845,'ServiceEngineer',638851,'GuardDir'),
(638853,'ServiceEngineer',638854,'Emails'),
(638853,'ServiceEngineer',638855,'Emails'),
(638868,'ServiceEngineer',638869,'Emails'),
(638868,'ServiceEngineer',638870,'Emails'),
(638868,'ServiceEngineer',638871,'Emails'),
(638873,'ServiceEngineer',638874,'Emails'),
(638873,'ServiceEngineer',638875,'Emails'),
(638873,'ServiceEngineer',638876,'Emails'),
(638878,'ServiceEngineer',638879,'Emails'),
(638878,'ServiceEngineer',638880,'Emails'),
(638878,'ServiceEngineer',638881,'Emails'),
(638883,'ServiceEngineer',638884,'Emails'),
(638883,'ServiceEngineer',638885,'Emails'),
(638882,'Accounts',638887,'SocBlocks'),
(638882,'Accounts',638888,'SocBlocks'),
(638882,'Accounts',638889,'Plat'),
(638882,'Accounts',638890,'Plat'),
(638882,'Accounts',638891,'Plat'),
(638882,'Accounts',638892,'Plat'),
(638889,'Owner',638894,'Resident'),
(638895,'ServiceEngineer',638896,'Emails'),
(638895,'ServiceEngineer',638897,'Emails'),
(638895,'ServiceEngineer',638898,'GuardDir'),
(638895,'ServiceEngineer',638900,'GuardDir'),
(638895,'ServiceEngineer',638901,'GuardDir'),
(638902,'ServiceEngineer',638903,'Emails'),
(638902,'ServiceEngineer',638904,'Emails'),
(638954,'ServiceEngineer',638955,'Emails'),
(638954,'ServiceEngineer',638956,'Emails'),
(638957,'ServiceEngineer',638958,'Emails'),
(638957,'ServiceEngineer',638959,'Emails'),
(638963,'ServiceEngineer',638964,'Emails'),
(638963,'ServiceEngineer',638965,'Emails'),
(638981,'ServiceEngineer',638982,'Emails'),
(638981,'ServiceEngineer',638983,'Emails'),
(638987,'ServiceEngineer',638988,'Emails'),
(638987,'ServiceEngineer',638989,'Emails'),
(638991,'ServiceEngineer',638992,'Emails'),
(638991,'ServiceEngineer',638993,'Emails'),
(638997,'ServiceEngineer',638998,'Emails'),
(638997,'ServiceEngineer',638999,'Emails'),
(638997,'ServiceEngineer',639000,'GuardDir'),
(638997,'ServiceEngineer',639002,'GuardDir'),
(639011,'ServiceEngineer',639012,'Emails'),
(639011,'ServiceEngineer',639013,'Emails'),
(639044,'ServiceEngineer',639046,'Emails'),
(639044,'ServiceEngineer',639047,'Emails'),
(639044,'ServiceEngineer',639048,'GuardDir'),
(639044,'ServiceEngineer',639050,'GuardDir'),
(639056,'ServiceEngineer',639057,'Emails'),
(639056,'ServiceEngineer',639058,'Emails'),
(639056,'ServiceEngineer',639059,'GuardDir'),
(639056,'ServiceEngineer',639061,'GuardDir'),
(639124,'ServiceEngineer',639125,'Emails'),
(639124,'ServiceEngineer',639126,'Emails'),
(639133,'ServiceEngineer',639134,'Emails'),
(639133,'ServiceEngineer',639135,'Emails'),
(639141,'ServiceEngineer',639142,'Emails'),
(639141,'ServiceEngineer',639143,'Emails'),
(639147,'ServiceEngineer',639148,'Emails'),
(639147,'ServiceEngineer',639149,'Emails'),
(639147,'ServiceEngineer',639150,'GuardDir'),
(639152,'ServiceEngineer',639153,'Emails'),
(639152,'ServiceEngineer',639154,'Emails'),
(639147,'ServiceEngineer',639157,'GuardDir'),
(639160,'ServiceEngineer',639161,'Emails'),
(639160,'ServiceEngineer',639162,'Emails'),
(639160,'ServiceEngineer',639163,'GuardDir'),
(639160,'ServiceEngineer',639165,'GuardDir'),
(639168,'ServiceEngineer',639169,'Emails'),
(639168,'ServiceEngineer',639170,'Emails'),
(639172,'ServiceEngineer',639173,'Emails'),
(639172,'ServiceEngineer',639174,'Emails'),
(639187,'ServiceEngineer',639188,'Emails'),
(639187,'ServiceEngineer',639189,'Emails'),
(639332,'ServiceEngineer',639333,'Emails'),
(639332,'ServiceEngineer',639334,'Emails'),
(639369,'ServiceEngineer',639370,'Emails'),
(638889,'Owner',639416,'Resident'),
(638892,'Owner',639484,'Resident'),
(639848,'ServiceEngineer',639849,'Emails'),
(639972,'ServiceEngineer',639973,'Emails'),
(639972,'ServiceEngineer',639974,'Emails'),
(639972,'ServiceEngineer',639975,'Emails'),
(639977,'ServiceEngineer',639978,'Emails'),
(639977,'ServiceEngineer',639979,'Emails'),
(639977,'ServiceEngineer',639980,'Emails'),
(639983,'ServiceEngineer',639984,'Emails'),
(639983,'ServiceEngineer',639985,'Emails'),
(639983,'ServiceEngineer',639986,'Emails'),
(639990,'ServiceEngineer',639991,'Emails'),
(639990,'ServiceEngineer',639992,'Emails'),
(639990,'ServiceEngineer',639993,'Emails'),
(639996,'ServiceEngineer',639997,'Emails'),
(639996,'ServiceEngineer',639998,'Emails'),
(639996,'ServiceEngineer',639999,'Emails'),
(640000,'Accounts',640001,'SocBlocks'),
(640000,'Accounts',640002,'SocBlocks'),
(640000,'Accounts',640003,'Plat'),
(640000,'Accounts',640004,'Plat'),
(640000,'Accounts',640005,'Plat'),
(640000,'Accounts',640006,'Plat'),
(640003,'Owner',640008,'Resident'),
(640010,'ServiceEngineer',640011,'Emails'),
(640010,'ServiceEngineer',640012,'Emails'),
(640010,'ServiceEngineer',640013,'Emails'),
(640016,'ServiceEngineer',640017,'Emails'),
(640016,'ServiceEngineer',640018,'Emails'),
(640016,'ServiceEngineer',640019,'Emails'),
(640028,'ServiceEngineer',640029,'Emails'),
(640028,'ServiceEngineer',640030,'Emails'),
(640028,'ServiceEngineer',640031,'Emails'),
(640034,'ServiceEngineer',640035,'Emails'),
(640034,'ServiceEngineer',640036,'Emails'),
(640034,'ServiceEngineer',640037,'Emails'),
(640040,'ServiceEngineer',640041,'Emails'),
(640040,'ServiceEngineer',640042,'Emails'),
(640040,'ServiceEngineer',640043,'Emails'),
(640046,'ServiceEngineer',640047,'Emails'),
(640046,'ServiceEngineer',640048,'Emails'),
(640046,'ServiceEngineer',640049,'Emails'),
(640052,'ServiceEngineer',640053,'Emails'),
(640052,'ServiceEngineer',640054,'Emails'),
(640052,'ServiceEngineer',640055,'Emails'),
(640061,'ServiceEngineer',640062,'Emails'),
(640061,'ServiceEngineer',640063,'Emails'),
(640061,'ServiceEngineer',640064,'Emails'),
(640068,'ServiceEngineer',640069,'Emails'),
(640068,'ServiceEngineer',640070,'Emails'),
(640068,'ServiceEngineer',640071,'Emails'),
(640073,'ServiceEngineer',640074,'Emails'),
(640073,'ServiceEngineer',640075,'Emails'),
(640073,'ServiceEngineer',640076,'Emails'),
(640086,'ServiceEngineer',640087,'Emails'),
(640086,'ServiceEngineer',640088,'Emails'),
(640086,'ServiceEngineer',640089,'Emails'),
(640091,'ServiceEngineer',640092,'Emails'),
(640091,'ServiceEngineer',640093,'Emails'),
(640091,'ServiceEngineer',640094,'Emails'),
(640095,'ServiceEngineer',640096,'Emails'),
(640095,'ServiceEngineer',640097,'Emails'),
(640095,'ServiceEngineer',640098,'Emails'),
(640100,'ServiceEngineer',640101,'Emails'),
(640100,'ServiceEngineer',640102,'Emails'),
(640100,'ServiceEngineer',640103,'Emails'),
(640106,'ServiceEngineer',640107,'Emails'),
(640106,'ServiceEngineer',640108,'Emails'),
(640106,'ServiceEngineer',640109,'Emails'),
(640132,'ServiceEngineer',640133,'Emails'),
(640132,'ServiceEngineer',640134,'Emails'),
(640132,'ServiceEngineer',640135,'Emails'),
(640139,'ServiceEngineer',640140,'Emails'),
(640139,'ServiceEngineer',640141,'Emails'),
(640139,'ServiceEngineer',640142,'Emails'),
(640155,'ServiceEngineer',640156,'Emails'),
(640155,'ServiceEngineer',640157,'Emails'),
(640155,'ServiceEngineer',640158,'Emails'),
(640164,'ServiceEngineer',640165,'Emails'),
(640164,'ServiceEngineer',640166,'Emails'),
(640164,'ServiceEngineer',640167,'Emails'),
(640171,'ServiceEngineer',640172,'Emails'),
(640171,'ServiceEngineer',640173,'Emails'),
(640171,'ServiceEngineer',640174,'Emails'),
(640177,'ServiceEngineer',640178,'Emails'),
(640177,'ServiceEngineer',640179,'Emails'),
(640177,'ServiceEngineer',640180,'Emails'),
(640183,'ServiceEngineer',640184,'Emails'),
(640183,'ServiceEngineer',640185,'Emails'),
(640183,'ServiceEngineer',640186,'Emails'),
(640190,'ServiceEngineer',640191,'Emails'),
(640190,'ServiceEngineer',640192,'Emails'),
(640190,'ServiceEngineer',640193,'Emails'),
(640195,'ServiceEngineer',640196,'Emails'),
(640195,'ServiceEngineer',640197,'Emails'),
(640195,'ServiceEngineer',640198,'Emails'),
(640199,'ServiceEngineer',640200,'Emails'),
(640199,'ServiceEngineer',640201,'Emails'),
(640199,'ServiceEngineer',640202,'Emails'),
(640203,'ServiceEngineer',640204,'Emails'),
(640203,'ServiceEngineer',640205,'Emails'),
(640203,'ServiceEngineer',640206,'Emails'),
(640209,'ServiceEngineer',640210,'Emails'),
(640209,'ServiceEngineer',640211,'Emails'),
(640209,'ServiceEngineer',640212,'Emails'),
(640247,'ServiceEngineer',640248,'Emails'),
(640247,'ServiceEngineer',640249,'Emails'),
(640247,'ServiceEngineer',640250,'Emails'),
(640251,'Accounts',640254,'SocBlocks'),
(640251,'Accounts',640255,'Plat'),
(640257,'ServiceEngineer',640258,'Emails'),
(640257,'ServiceEngineer',640259,'Emails'),
(640257,'ServiceEngineer',640260,'Emails'),
(640263,'ServiceEngineer',640264,'Emails'),
(640263,'ServiceEngineer',640265,'Emails'),
(640263,'ServiceEngineer',640266,'Emails'),
(640347,'ServiceEngineer',640348,'Emails'),
(640347,'ServiceEngineer',640349,'Emails'),
(640347,'ServiceEngineer',640350,'Emails'),
(640377,'ServiceEngineer',640378,'Emails'),
(640377,'ServiceEngineer',640379,'Emails'),
(640377,'ServiceEngineer',640380,'Emails'),
(640384,'ServiceEngineer',640385,'Emails'),
(640384,'ServiceEngineer',640386,'Emails'),
(640384,'ServiceEngineer',640387,'Emails'),
(640390,'ServiceEngineer',640391,'Emails'),
(640390,'ServiceEngineer',640392,'Emails'),
(640390,'ServiceEngineer',640393,'Emails'),
(640396,'ServiceEngineer',640397,'Emails'),
(640396,'ServiceEngineer',640398,'Emails'),
(640396,'ServiceEngineer',640399,'Emails'),
(640402,'ServiceEngineer',640403,'Emails'),
(640402,'ServiceEngineer',640404,'Emails'),
(640402,'ServiceEngineer',640405,'Emails'),
(640407,'ServiceEngineer',640408,'Emails'),
(640407,'ServiceEngineer',640409,'Emails'),
(640407,'ServiceEngineer',640410,'Emails'),
(640412,'ServiceEngineer',640413,'Emails'),
(640412,'ServiceEngineer',640414,'Emails'),
(640412,'ServiceEngineer',640415,'Emails'),
(640418,'ServiceEngineer',640419,'Emails'),
(640418,'ServiceEngineer',640420,'Emails'),
(640418,'ServiceEngineer',640421,'Emails'),
(640424,'ServiceEngineer',640425,'Emails'),
(640424,'ServiceEngineer',640426,'Emails'),
(640424,'ServiceEngineer',640427,'Emails'),
(640439,'ServiceEngineer',640440,'Emails'),
(640439,'ServiceEngineer',640441,'Emails'),
(640439,'ServiceEngineer',640442,'Emails'),
(640462,'Owner',640464,'Resident'),
(640462,'Owner',640472,'Resident'),
(640462,'Owner',640473,'Resident'),
(640475,'Owner',640477,'Resident'),
(640486,'ServiceEngineer',640487,'Emails'),
(640486,'ServiceEngineer',640488,'Emails'),
(640486,'ServiceEngineer',640489,'Emails'),
(640518,'ServiceEngineer',640519,'Emails'),
(640518,'ServiceEngineer',640520,'Emails'),
(640518,'ServiceEngineer',640521,'Emails'),
(640529,'ServiceEngineer',640530,'Emails'),
(640529,'ServiceEngineer',640531,'Emails'),
(640529,'ServiceEngineer',640532,'Emails'),
(640539,'ServiceEngineer',640540,'Emails'),
(640539,'ServiceEngineer',640541,'Emails'),
(640577,'ServiceEngineer',640578,'Emails'),
(640577,'ServiceEngineer',640579,'Emails'),
(640577,'ServiceEngineer',640580,'Emails'),
(640596,'Owner',640599,'Resident'),
(640603,'Owner',640607,'Resident'),
(638889,'Owner',640613,'Resident'),
(640475,'Owner',640614,'Resident'),
(640475,'Owner',640615,'Resident'),
(640603,'Owner',640616,'Resident'),
(640620,'Owner',640622,'Resident'),
(640625,'Owner',640627,'Resident'),
(640629,'Owner',640631,'Resident'),
(640633,'Owner',640635,'Resident'),
(640641,'Owner',640643,'Resident'),
(640646,'Owner',640648,'Resident'),
(640655,'Owner',640657,'Resident'),
(0,'Owner',640674,'Resident'),
(640683,'Owner',640685,'Resident'),
(640690,'Owner',640692,'Resident'),
(640725,'ServiceEngineer',640726,'Emails'),
(640725,'ServiceEngineer',640727,'Emails'),
(640725,'ServiceEngineer',640728,'Emails'),
(640787,'ServiceEngineer',640788,'Emails'),
(640787,'ServiceEngineer',640789,'Emails'),
(640790,'ServiceEngineer',640791,'Emails'),
(640790,'ServiceEngineer',640792,'Emails'),
(640793,'ServiceEngineer',640794,'Emails'),
(640793,'ServiceEngineer',640795,'Emails'),
(640798,'ServiceEngineer',640799,'Emails'),
(640798,'ServiceEngineer',640800,'Emails'),
(640798,'ServiceEngineer',640801,'Emails'),
(640803,'ServiceEngineer',640804,'Emails'),
(640803,'ServiceEngineer',640805,'Emails'),
(640809,'ServiceEngineer',640810,'Emails'),
(640809,'ServiceEngineer',640811,'Emails'),
(640812,'ServiceEngineer',640813,'Emails'),
(640812,'ServiceEngineer',640814,'Emails'),
(640815,'ServiceEngineer',640816,'Emails'),
(640815,'ServiceEngineer',640817,'Emails'),
(640819,'ServiceEngineer',640820,'Emails'),
(640819,'ServiceEngineer',640821,'Emails'),
(640822,'ServiceEngineer',640823,'Emails'),
(640822,'ServiceEngineer',640824,'Emails'),
(640826,'ServiceEngineer',640827,'Emails'),
(640826,'ServiceEngineer',640828,'Emails'),
(640829,'ServiceEngineer',640830,'Emails'),
(640829,'ServiceEngineer',640831,'Emails'),
(640832,'ServiceEngineer',640833,'Emails'),
(640832,'ServiceEngineer',640834,'Emails'),
(640836,'ServiceEngineer',640837,'Emails'),
(640836,'ServiceEngineer',640838,'Emails'),
(640844,'ServiceEngineer',640845,'Emails'),
(640844,'ServiceEngineer',640846,'Emails'),
(640852,'ServiceEngineer',640853,'Emails'),
(640852,'ServiceEngineer',640854,'Emails'),
(640856,'ServiceEngineer',640857,'Emails'),
(640856,'ServiceEngineer',640858,'Emails'),
(640860,'ServiceEngineer',640861,'Emails'),
(640860,'ServiceEngineer',640862,'Emails'),
(640864,'ServiceEngineer',640865,'Emails'),
(640864,'ServiceEngineer',640866,'Emails'),
(640869,'ServiceEngineer',640870,'Emails'),
(640869,'ServiceEngineer',640871,'Emails'),
(640869,'ServiceEngineer',640872,'GuardDir'),
(640873,'ServiceEngineer',640874,'Emails'),
(640873,'ServiceEngineer',640875,'Emails'),
(640873,'ServiceEngineer',640876,'GuardDir'),
(640878,'ServiceEngineer',640879,'Emails'),
(640878,'ServiceEngineer',640880,'Emails'),
(640881,'ServiceEngineer',640882,'Emails'),
(640881,'ServiceEngineer',640883,'Emails'),
(640885,'ServiceEngineer',640886,'Emails'),
(640885,'ServiceEngineer',640887,'Emails'),
(640889,'ServiceEngineer',640890,'Emails'),
(640889,'ServiceEngineer',640891,'Emails'),
(640910,'ServiceEngineer',640911,'Emails'),
(640910,'ServiceEngineer',640912,'Emails'),
(640910,'ServiceEngineer',640913,'Emails'),
(640914,'ServiceEngineer',640915,'Emails'),
(640914,'ServiceEngineer',640917,'Emails'),
(640919,'ServiceEngineer',640920,'Emails'),
(640919,'ServiceEngineer',640921,'Emails'),
(640956,'ServiceEngineer',640957,'Emails'),
(640956,'ServiceEngineer',640958,'Emails'),
(640956,'ServiceEngineer',640959,'Emails'),
(640962,'ServiceEngineer',640963,'Emails'),
(640962,'ServiceEngineer',640964,'Emails'),
(640962,'ServiceEngineer',640965,'Emails'),
(640969,'ServiceEngineer',640970,'Emails'),
(640969,'ServiceEngineer',640971,'Emails'),
(640969,'ServiceEngineer',640972,'Emails'),
(640976,'ServiceEngineer',640977,'Emails'),
(640976,'ServiceEngineer',640978,'Emails'),
(640976,'ServiceEngineer',640979,'Emails'),
(640982,'ServiceEngineer',640983,'Emails'),
(640982,'ServiceEngineer',640984,'Emails'),
(640982,'ServiceEngineer',640985,'Emails'),
(640988,'ServiceEngineer',640989,'Emails'),
(640988,'ServiceEngineer',640990,'Emails'),
(640988,'ServiceEngineer',640991,'Emails'),
(640993,'ServiceEngineer',640994,'Emails'),
(640993,'ServiceEngineer',640995,'Emails'),
(640993,'ServiceEngineer',640996,'Emails'),
(640997,'ServiceEngineer',640998,'Emails'),
(640997,'ServiceEngineer',640999,'Emails'),
(640997,'ServiceEngineer',641000,'Emails'),
(641002,'ServiceEngineer',641003,'Emails'),
(641002,'ServiceEngineer',641004,'Emails'),
(641002,'ServiceEngineer',641005,'Emails'),
(641008,'ServiceEngineer',641009,'Emails'),
(641008,'ServiceEngineer',641010,'Emails'),
(641008,'ServiceEngineer',641011,'Emails'),
(641014,'ServiceEngineer',641015,'Emails'),
(641014,'ServiceEngineer',641016,'Emails'),
(641014,'ServiceEngineer',641017,'Emails'),
(641020,'ServiceEngineer',641021,'Emails'),
(641020,'ServiceEngineer',641022,'Emails'),
(641020,'ServiceEngineer',641023,'Emails'),
(641025,'ServiceEngineer',641026,'Emails'),
(641025,'ServiceEngineer',641027,'Emails'),
(641025,'ServiceEngineer',641028,'Emails'),
(641031,'ServiceEngineer',641032,'Emails'),
(641031,'ServiceEngineer',641033,'Emails'),
(641031,'ServiceEngineer',641034,'Emails'),
(641037,'ServiceEngineer',641038,'Emails'),
(641037,'ServiceEngineer',641039,'Emails'),
(641037,'ServiceEngineer',641040,'Emails'),
(641043,'ServiceEngineer',641044,'Emails'),
(641043,'ServiceEngineer',641045,'Emails'),
(641043,'ServiceEngineer',641046,'Emails'),
(641049,'ServiceEngineer',641050,'Emails'),
(641049,'ServiceEngineer',641051,'Emails'),
(641049,'ServiceEngineer',641052,'Emails'),
(641055,'ServiceEngineer',641056,'Emails'),
(641055,'ServiceEngineer',641057,'Emails'),
(641055,'ServiceEngineer',641058,'Emails'),
(641061,'ServiceEngineer',641062,'Emails'),
(641061,'ServiceEngineer',641063,'Emails'),
(641061,'ServiceEngineer',641064,'Emails'),
(641067,'ServiceEngineer',641068,'Emails'),
(641067,'ServiceEngineer',641069,'Emails'),
(641067,'ServiceEngineer',641070,'Emails'),
(641073,'ServiceEngineer',641074,'Emails'),
(641073,'ServiceEngineer',641075,'Emails'),
(641073,'ServiceEngineer',641076,'Emails'),
(641079,'ServiceEngineer',641080,'Emails'),
(641079,'ServiceEngineer',641081,'Emails'),
(641079,'ServiceEngineer',641082,'Emails'),
(641087,'ServiceEngineer',641088,'Emails'),
(641087,'ServiceEngineer',641089,'Emails'),
(641087,'ServiceEngineer',641090,'Emails'),
(641091,'ServiceEngineer',641092,'Emails'),
(641091,'ServiceEngineer',641093,'Emails'),
(641091,'ServiceEngineer',641094,'Emails'),
(641095,'ServiceEngineer',641096,'Emails'),
(641095,'ServiceEngineer',641097,'Emails'),
(641095,'ServiceEngineer',641098,'Emails'),
(641099,'ServiceEngineer',641100,'Emails'),
(641099,'ServiceEngineer',641101,'Emails'),
(641099,'ServiceEngineer',641102,'Emails'),
(641103,'ServiceEngineer',641104,'Emails'),
(641103,'ServiceEngineer',641105,'Emails'),
(641103,'ServiceEngineer',641106,'Emails'),
(641107,'ServiceEngineer',641108,'Emails'),
(641107,'ServiceEngineer',641109,'Emails'),
(641107,'ServiceEngineer',641110,'Emails'),
(641111,'ServiceEngineer',641112,'Emails'),
(641111,'ServiceEngineer',641113,'Emails'),
(641111,'ServiceEngineer',641114,'Emails'),
(641115,'ServiceEngineer',641116,'Emails'),
(641115,'ServiceEngineer',641117,'Emails'),
(641115,'ServiceEngineer',641118,'Emails'),
(641119,'ServiceEngineer',641120,'Emails'),
(641119,'ServiceEngineer',641121,'Emails'),
(641119,'ServiceEngineer',641122,'Emails'),
(641123,'ServiceEngineer',641124,'Emails'),
(641123,'ServiceEngineer',641125,'Emails'),
(641123,'ServiceEngineer',641126,'Emails'),
(641127,'ServiceEngineer',641128,'Emails'),
(641127,'ServiceEngineer',641129,'Emails'),
(641127,'ServiceEngineer',641130,'Emails'),
(641131,'ServiceEngineer',641132,'Emails'),
(641131,'ServiceEngineer',641133,'Emails'),
(641131,'ServiceEngineer',641134,'Emails'),
(641135,'ServiceEngineer',641136,'Emails'),
(641135,'ServiceEngineer',641137,'Emails'),
(641135,'ServiceEngineer',641138,'Emails'),
(641139,'ServiceEngineer',641140,'Emails'),
(641139,'ServiceEngineer',641141,'Emails'),
(641139,'ServiceEngineer',641142,'Emails'),
(641143,'ServiceEngineer',641144,'Emails'),
(641143,'ServiceEngineer',641145,'Emails'),
(641143,'ServiceEngineer',641146,'Emails'),
(641151,'ServiceEngineer',641152,'Emails'),
(641151,'ServiceEngineer',641153,'Emails'),
(641151,'ServiceEngineer',641154,'Emails'),
(641155,'ServiceEngineer',641156,'Emails'),
(641155,'ServiceEngineer',641157,'Emails'),
(641155,'ServiceEngineer',641158,'Emails'),
(641159,'ServiceEngineer',641160,'Emails'),
(641159,'ServiceEngineer',641161,'Emails'),
(641159,'ServiceEngineer',641162,'Emails'),
(641163,'ServiceEngineer',641164,'Emails'),
(641163,'ServiceEngineer',641165,'Emails'),
(641163,'ServiceEngineer',641166,'Emails'),
(641167,'ServiceEngineer',641168,'Emails'),
(641167,'ServiceEngineer',641169,'Emails'),
(641167,'ServiceEngineer',641170,'Emails'),
(641171,'ServiceEngineer',641172,'Emails'),
(641171,'ServiceEngineer',641173,'Emails'),
(641171,'ServiceEngineer',641175,'Emails'),
(641178,'ServiceEngineer',641179,'Emails'),
(641178,'ServiceEngineer',641180,'Emails'),
(641178,'ServiceEngineer',641181,'Emails'),
(641182,'ServiceEngineer',641183,'Emails'),
(641182,'ServiceEngineer',641184,'Emails'),
(641182,'ServiceEngineer',641185,'Emails'),
(641208,'ServiceEngineer',641209,'Emails'),
(641208,'ServiceEngineer',641210,'Emails'),
(641208,'ServiceEngineer',641211,'Emails'),
(641213,'ServiceEngineer',641214,'Emails'),
(641213,'ServiceEngineer',641215,'Emails'),
(641213,'ServiceEngineer',641216,'Emails'),
(641217,'ServiceEngineer',641218,'Emails'),
(641217,'ServiceEngineer',641219,'Emails'),
(641217,'ServiceEngineer',641220,'Emails'),
(641230,'ServiceEngineer',641231,'Emails'),
(641230,'ServiceEngineer',641232,'Emails'),
(641230,'ServiceEngineer',641233,'Emails'),
(641238,'ServiceEngineer',641239,'Emails'),
(641238,'ServiceEngineer',641240,'Emails'),
(641238,'ServiceEngineer',641241,'Emails'),
(641248,'ServiceEngineer',641249,'Emails'),
(641253,'ServiceEngineer',641254,'Emails'),
(641256,'ServiceEngineer',641257,'Emails'),
(641256,'ServiceEngineer',641258,'Emails'),
(641256,'ServiceEngineer',641259,'Emails'),
(641263,'ServiceEngineer',641264,'Emails'),
(641263,'ServiceEngineer',641265,'Emails'),
(641263,'ServiceEngineer',641266,'Emails'),
(641268,'ServiceEngineer',641269,'Emails'),
(641268,'ServiceEngineer',641270,'Emails'),
(641268,'ServiceEngineer',641271,'Emails'),
(641277,'ServiceEngineer',641278,'Emails'),
(641277,'ServiceEngineer',641279,'Emails'),
(641277,'ServiceEngineer',641280,'Emails'),
(641282,'ServiceEngineer',641283,'Emails'),
(641282,'ServiceEngineer',641284,'Emails'),
(641282,'ServiceEngineer',641285,'Emails'),
(641290,'ServiceEngineer',641291,'Emails'),
(641290,'ServiceEngineer',641292,'Emails'),
(641290,'ServiceEngineer',641293,'Emails'),
(641302,'ServiceEngineer',641303,'Emails'),
(641302,'ServiceEngineer',641304,'Emails'),
(641302,'ServiceEngineer',641305,'Emails'),
(641307,'ServiceEngineer',641308,'Emails'),
(641307,'ServiceEngineer',641309,'Emails'),
(641307,'ServiceEngineer',641310,'Emails'),
(641312,'ServiceEngineer',641313,'Emails'),
(641312,'ServiceEngineer',641314,'Emails'),
(641312,'ServiceEngineer',641315,'Emails'),
(641317,'ServiceEngineer',641318,'Emails'),
(641317,'ServiceEngineer',641319,'Emails'),
(641317,'ServiceEngineer',641320,'Emails'),
(641325,'ServiceEngineer',641326,'Emails'),
(641325,'ServiceEngineer',641327,'Emails'),
(641325,'ServiceEngineer',641328,'Emails'),
(641329,'ServiceEngineer',641330,'Emails'),
(641329,'ServiceEngineer',641331,'Emails'),
(641329,'ServiceEngineer',641332,'Emails'),
(641333,'ServiceEngineer',641334,'Emails'),
(641333,'ServiceEngineer',641335,'Emails'),
(641333,'ServiceEngineer',641336,'Emails'),
(641337,'ServiceEngineer',641338,'Emails'),
(641337,'ServiceEngineer',641339,'Emails'),
(641337,'ServiceEngineer',641340,'Emails'),
(641341,'ServiceEngineer',641342,'Emails'),
(641341,'ServiceEngineer',641343,'Emails'),
(641341,'ServiceEngineer',641344,'Emails'),
(641345,'ServiceEngineer',641346,'Emails'),
(641351,'ServiceEngineer',641352,'Emails'),
(641351,'ServiceEngineer',641353,'Emails'),
(641351,'ServiceEngineer',641354,'Emails'),
(641356,'ServiceEngineer',641357,'Emails'),
(641356,'ServiceEngineer',641358,'Emails'),
(641356,'ServiceEngineer',641359,'Emails'),
(641361,'ServiceEngineer',641362,'Emails'),
(641365,'ServiceEngineer',641366,'Emails'),
(641373,'ServiceEngineer',641374,'Emails'),
(641373,'ServiceEngineer',641375,'Emails'),
(641373,'ServiceEngineer',641376,'Emails'),
(641379,'ServiceEngineer',641380,'Emails'),
(641379,'ServiceEngineer',641381,'Emails'),
(641379,'ServiceEngineer',641382,'Emails'),
(641383,'ServiceEngineer',641384,'Emails'),
(641383,'ServiceEngineer',641385,'Emails'),
(641383,'ServiceEngineer',641386,'Emails'),
(641387,'ServiceEngineer',641388,'Emails'),
(641387,'ServiceEngineer',641389,'Emails'),
(641387,'ServiceEngineer',641390,'Emails'),
(641392,'ServiceEngineer',641393,'Emails'),
(641392,'ServiceEngineer',641394,'Emails'),
(641392,'ServiceEngineer',641395,'Emails'),
(641398,'ServiceEngineer',641399,'Emails'),
(641398,'ServiceEngineer',641400,'Emails'),
(641398,'ServiceEngineer',641401,'Emails'),
(641402,'ServiceEngineer',641403,'Emails'),
(641402,'ServiceEngineer',641404,'Emails'),
(641402,'ServiceEngineer',641405,'Emails'),
(641406,'ServiceEngineer',641407,'Emails'),
(641406,'ServiceEngineer',641408,'Emails'),
(641406,'ServiceEngineer',641409,'Emails'),
(641413,'ServiceEngineer',641414,'Emails'),
(641413,'ServiceEngineer',641415,'Emails'),
(641413,'ServiceEngineer',641416,'Emails'),
(641417,'ServiceEngineer',641418,'Emails'),
(641417,'ServiceEngineer',641419,'Emails'),
(641417,'ServiceEngineer',641420,'Emails'),
(641421,'ServiceEngineer',641422,'Emails'),
(641421,'ServiceEngineer',641423,'Emails'),
(641421,'ServiceEngineer',641424,'Emails'),
(641425,'ServiceEngineer',641426,'Emails'),
(641425,'ServiceEngineer',641427,'Emails'),
(641425,'ServiceEngineer',641428,'Emails'),
(641429,'ServiceEngineer',641430,'Emails'),
(641429,'ServiceEngineer',641431,'Emails'),
(641429,'ServiceEngineer',641432,'Emails'),
(641435,'ServiceEngineer',641436,'Emails'),
(641435,'ServiceEngineer',641437,'Emails'),
(641435,'ServiceEngineer',641438,'Emails'),
(641440,'ServiceEngineer',641441,'Emails'),
(641440,'ServiceEngineer',641442,'Emails'),
(641440,'ServiceEngineer',641443,'Emails'),
(641447,'ServiceEngineer',641448,'Emails'),
(641449,'ServiceEngineer',641450,'Emails'),
(641451,'ServiceEngineer',641452,'Emails'),
(641456,'ServiceEngineer',641457,'Emails'),
(641456,'ServiceEngineer',641458,'Emails'),
(641456,'ServiceEngineer',641459,'Emails'),
(641460,'ServiceEngineer',641461,'Emails'),
(641462,'ServiceEngineer',641463,'Emails'),
(641464,'ServiceEngineer',641465,'Emails'),
(641464,'ServiceEngineer',641466,'Emails'),
(641464,'ServiceEngineer',641467,'Emails'),
(641468,'ServiceEngineer',641469,'Emails'),
(641475,'ServiceEngineer',641476,'Emails'),
(641475,'ServiceEngineer',641477,'Emails'),
(641475,'ServiceEngineer',641478,'Emails'),
(641480,'ServiceEngineer',641481,'Emails'),
(641480,'ServiceEngineer',641482,'Emails'),
(641480,'ServiceEngineer',641483,'Emails'),
(641485,'ServiceEngineer',641486,'Emails'),
(641485,'ServiceEngineer',641487,'Emails'),
(641485,'ServiceEngineer',641488,'Emails'),
(641489,'ServiceEngineer',641490,'Emails'),
(641489,'ServiceEngineer',641491,'Emails'),
(641489,'ServiceEngineer',641492,'Emails'),
(641493,'ServiceEngineer',641494,'Emails'),
(641493,'ServiceEngineer',641495,'Emails'),
(641493,'ServiceEngineer',641496,'Emails'),
(641508,'ServiceEngineer',641509,'Emails'),
(641508,'ServiceEngineer',641510,'Emails'),
(641508,'ServiceEngineer',641511,'Emails'),
(641519,'ServiceEngineer',641520,'Emails'),
(641519,'ServiceEngineer',641521,'Emails'),
(641519,'ServiceEngineer',641522,'Emails'),
(641529,'ServiceEngineer',641530,'Emails'),
(641529,'ServiceEngineer',641531,'Emails'),
(641529,'ServiceEngineer',641532,'Emails'),
(641540,'ServiceEngineer',641541,'Emails'),
(641540,'ServiceEngineer',641542,'Emails'),
(641540,'ServiceEngineer',641543,'Emails'),
(641544,'ServiceEngineer',641545,'Emails'),
(641544,'ServiceEngineer',641546,'Emails'),
(641544,'ServiceEngineer',641547,'Emails'),
(641551,'ServiceEngineer',641552,'Emails'),
(641551,'ServiceEngineer',641553,'Emails'),
(641551,'ServiceEngineer',641554,'Emails'),
(641555,'ServiceEngineer',641556,'Emails'),
(641555,'ServiceEngineer',641557,'Emails'),
(641555,'ServiceEngineer',641558,'Emails'),
(641560,'ServiceEngineer',641561,'Emails'),
(641560,'ServiceEngineer',641562,'Emails'),
(641560,'ServiceEngineer',641563,'Emails'),
(641586,'ServiceEngineer',641587,'Emails'),
(641586,'ServiceEngineer',641588,'Emails'),
(641586,'ServiceEngineer',641589,'Emails'),
(641655,'Accounts',641658,'SocBlocks'),
(641655,'Accounts',641659,'Plat'),
(641671,'Accounts',641674,'SocBlocks'),
(641671,'Accounts',641675,'SocBlocks'),
(641671,'Accounts',641676,'Plat'),
(641671,'Accounts',641677,'Plat'),
(641667,'Accounts',641678,'SocBlocks'),
(641667,'Accounts',641679,'SocBlocks'),
(641667,'Accounts',641680,'Plat'),
(641667,'Accounts',641681,'Plat'),
(641663,'Accounts',641682,'SocBlocks'),
(641663,'Accounts',641683,'SocBlocks'),
(641663,'Accounts',641684,'Plat'),
(641663,'Accounts',641685,'Plat'),
(641663,'Accounts',641686,'QRCode'),
(641667,'Accounts',641688,'QRCode'),
(641671,'Accounts',641690,'QRCode'),
(641680,'Owner',641693,'Resident'),
(641684,'Owner',641695,'Resident'),
(641684,'Owner',641698,'Resident'),
(641681,'Owner',641700,'Resident'),
(641723,'Accounts',641726,'SocBlocks'),
(641723,'Accounts',641727,'SocBlocks'),
(641723,'Accounts',641728,'Plat'),
(641723,'Accounts',641729,'Plat'),
(641769,'ServiceEngineer',641770,'Emails'),
(641769,'ServiceEngineer',641771,'Emails'),
(641779,'ServiceEngineer',641780,'Emails'),
(641779,'ServiceEngineer',641781,'Emails'),
(641788,'ServiceEngineer',641791,'Emails'),
(641728,'Owner',641840,'Resident'),
(641931,'Accounts',641932,'SocBlocks'),
(641931,'Accounts',641933,'SocBlocks'),
(641931,'Accounts',641934,'Plat'),
(641931,'Accounts',641935,'Plat'),
(641931,'Accounts',641936,'QRCode'),
(641681,'Owner',641979,'Resident'),
(642040,'ServiceEngineer',642043,'Emails'),
(642040,'ServiceEngineer',642044,'Emails'),
(642040,'ServiceEngineer',642045,'Emails'),
(642064,'ServiceEngineer',642065,'Emails'),
(642064,'ServiceEngineer',642066,'Emails'),
(641620,'Amenities',642074,'Booking'),
(642083,'ServiceEngineer',642084,'Emails'),
(642083,'ServiceEngineer',642085,'Emails'),
(642196,'ServiceEngineer',642199,'Emails'),
(642196,'ServiceEngineer',642200,'Emails'),
(642196,'ServiceEngineer',642201,'Emails'),
(642207,'ServiceEngineer',642210,'Emails'),
(642207,'ServiceEngineer',642211,'Emails'),
(641620,'Amenities',642354,'Booking'),
(642361,'Accounts',642362,'QRCode'),
(642361,'Accounts',642364,'SocBlocks'),
(642365,'ServiceEngineer',642366,'Emails'),
(642365,'ServiceEngineer',642367,'Emails'),
(642464,'ServiceEngineer',642465,'Emails'),
(642464,'ServiceEngineer',642466,'Emails'),
(642464,'ServiceEngineer',642467,'Attendance'),
(642449,'Accounts',642470,'SocBlocks'),
(642449,'Accounts',642471,'Plat');

--
-- Table structure for table `vtiger_crmsetup`
--

CREATE TABLE `vtiger_crmsetup` (
  `userid` int(11) DEFAULT NULL,
  `setup_status` int(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_crmsetup`
--

INSERT INTO `vtiger_crmsetup` VALUES
(258,1),
(258,1),
(288,1),
(258,1),
(274,1),
(274,1),
(251,1),
(251,1),
(0,1),
(335,1),
(340,1),
(542,1),
(541,1),
(283,1),
(283,1),
(283,1),
(752,1),
(752,1),
(308,1),
(308,1),
(308,1),
(308,1),
(308,1),
(308,1),
(753,1),
(754,1),
(765,1),
(0,1),
(0,1),
(0,1),
(0,1),
(1037,1),
(1093,1),
(0,1),
(0,1),
(0,1),
(1217,1),
(0,1),
(0,1),
(1220,1),
(1220,1);

--
-- Table structure for table `vtiger_cron_task`
--

CREATE TABLE `vtiger_cron_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `handler_file` varchar(100) DEFAULT NULL,
  `frequency` int(11) DEFAULT NULL,
  `laststart` int(11) unsigned DEFAULT NULL,
  `lastend` int(11) unsigned DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `module` varchar(100) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `handler_file` (`handler_file`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cron_task`
--

INSERT INTO `vtiger_cron_task` VALUES
(1,'Workflow','cron/modules/com_vtiger_workflow/com_vtiger_workflow.service',900,1717564503,1717564503,1,'com_vtiger_workflow',1,'Recommended frequency for Workflow is 15 mins'),
(2,'RecurringInvoice','cron/modules/SalesOrder/RecurringInvoice.service',43200,1717564503,1717564503,1,'SalesOrder',2,'Recommended frequency for RecurringInvoice is 12 hours'),
(3,'SendReminder','cron/SendReminder.service',900,1717564503,1717564503,1,'Calendar',3,'Recommended frequency for SendReminder is 15 mins'),
(5,'MailScanner','cron/MailScanner.service',900,1717564503,1717564503,1,'Settings',5,'Recommended frequency for MailScanner is 15 mins'),
(6,'Scheduled Import','cron/modules/Import/ScheduledImport.service',900,NULL,NULL,0,'Import',6,'Recommended frequency for MailScanner is 15 mins'),
(7,'ScheduleReports','cron/modules/Reports/ScheduleReports.service',900,1717564503,1717564503,1,'Reports',7,'Recommended frequency for ScheduleReports is 15 mins'),
(9,'Schedule Reports4You','modules/ITS4YouReports/ScheduleReports4You.service',900,1644394684,1644394684,0,'ITS4YouReports',9,'Recommended frequency for ScheduleReports4You is 15 mins');

--
-- Table structure for table `vtiger_currencies`
--

CREATE TABLE `vtiger_currencies` (
  `currencyid` int(19) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(200) DEFAULT NULL,
  `currency_code` varchar(50) DEFAULT NULL,
  `currency_symbol` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`currencyid`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currencies`
--

INSERT INTO `vtiger_currencies` VALUES
(1,'Albania, Leke','ALL','Lek'),
(2,'Argentina, Pesos','ARS','$'),
(3,'Aruba, Guilders','AWG','ƒ'),
(4,'Australia, Dollars','AUD','$'),
(5,'Azerbaijan, New Manats','AZN','ман'),
(6,'Bahamas, Dollars','BSD','$'),
(7,'Bahrain, Dinar','BHD','BD'),
(8,'Barbados, Dollars','BBD','$'),
(9,'Belarus, Rubles','BYR','p.'),
(10,'Belize, Dollars','BZD','BZ$'),
(11,'Bermuda, Dollars','BMD','$'),
(12,'Bolivia, Bolivianos','BOB','$b'),
(13,'China, Yuan Renminbi','CNY','¥'),
(14,'Convertible Marka','BAM','KM'),
(15,'Botswana, Pulas','BWP','P'),
(16,'Bulgaria, Leva','BGN','лв'),
(17,'Brazil, Reais','BRL','R$'),
(18,'Great Britain Pounds','GBP','£'),
(19,'Brunei Darussalam, Dollars','BND','$'),
(20,'Canada, Dollars','CAD','$'),
(21,'Cayman Islands, Dollars','KYD','$'),
(22,'Chile, Pesos','CLP','$'),
(23,'Colombia, Pesos','COP','$'),
(24,'Costa Rica, Colón','CRC','₡'),
(25,'Croatia, Kuna','HRK','kn'),
(26,'Cuba, Pesos','CUP','₱'),
(27,'Czech Republic, Koruny','CZK','Kč'),
(28,'Cyprus, Pounds','CYP','£'),
(29,'Denmark, Kroner','DKK','kr'),
(30,'Dominican Republic, Pesos','DOP','RD$'),
(31,'East Caribbean, Dollars','XCD','$'),
(32,'Egypt, Pounds','EGP','E£'),
(33,'El Salvador, Colón','SVC','₡'),
(34,'England, Pounds','GBP','£'),
(35,'Estonia, Krooni','EEK','kr'),
(36,'Euro','EUR','€'),
(37,'Falkland Islands, Pounds','FKP','£'),
(38,'Fiji, Dollars','FJD','$'),
(39,'Ghana, Cedis','GHC','¢'),
(40,'Gibraltar, Pounds','GIP','£'),
(41,'Guatemala, Quetzales','GTQ','Q'),
(42,'Guernsey, Pounds','GGP','£'),
(43,'Guyana, Dollars','GYD','$'),
(44,'Honduras, Lempiras','HNL','L'),
(45,'Hong Kong, Dollars','HKD','HK$'),
(46,'Hungary, Forint','HUF','Ft'),
(47,'Iceland, Krona','ISK','kr'),
(48,'India, Rupees','INR','₹'),
(49,'Indonesia, Rupiahs','IDR','Rp'),
(50,'Iran, Rials','IRR','﷼'),
(51,'Isle of Man, Pounds','IMP','£'),
(52,'Israel, New Shekels','ILS','₪'),
(53,'Jamaica, Dollars','JMD','J$'),
(54,'Japan, Yen','JPY','¥'),
(55,'Jersey, Pounds','JEP','£'),
(56,'Jordan, Dinar','JOD','JOD'),
(57,'Kazakhstan, Tenge','KZT','〒'),
(58,'Kenya, Shilling','KES','KES'),
(59,'Korea (North), Won','KPW','₩'),
(60,'Korea (South), Won','KRW','₩'),
(61,'Kuwait, Dinar','KWD','KWD'),
(62,'Kyrgyzstan, Soms','KGS','лв'),
(63,'Laos, Kips','LAK','₭'),
(64,'Latvia, Lati','LVL','Ls'),
(65,'Lebanon, Pounds','LBP','£'),
(66,'Liberia, Dollars','LRD','$'),
(67,'Switzerland Francs','CHF','CHF'),
(68,'Lithuania, Litai','LTL','Lt'),
(69,'MADAGASCAR, Malagasy Ariary','MGA','MGA'),
(70,'Macedonia, Denars','MKD','ден'),
(71,'Malaysia, Ringgits','MYR','RM'),
(72,'Malta, Liri','MTL','₤'),
(73,'Mauritius, Rupees','MUR','₨'),
(74,'Mexico, Pesos','MXN','$'),
(75,'Mongolia, Tugriks','MNT','₮'),
(76,'Mozambique, Meticais','MZN','MT'),
(77,'Namibia, Dollars','NAD','$'),
(78,'Nepal, Rupees','NPR','₨'),
(79,'Netherlands Antilles, Guilders','ANG','ƒ'),
(80,'New Zealand, Dollars','NZD','$'),
(81,'Nicaragua, Cordobas','NIO','C$'),
(82,'Nigeria, Nairas','NGN','₦'),
(83,'North Korea, Won','KPW','₩'),
(84,'Norway, Krone','NOK','kr'),
(85,'Oman, Rials','OMR','﷼'),
(86,'Pakistan, Rupees','PKR','₨'),
(87,'Panama, Balboa','PAB','B/.'),
(88,'Paraguay, Guarani','PYG','Gs'),
(89,'Peru, Nuevos Soles','PEN','S/.'),
(90,'Philippines, Pesos','PHP','Php'),
(91,'Poland, Zlotych','PLN','zł'),
(92,'Qatar, Rials','QAR','﷼'),
(93,'Romania, New Lei','RON','lei'),
(94,'Russia, Rubles','RUB','руб'),
(95,'Saint Helena, Pounds','SHP','£'),
(96,'Saudi Arabia, Riyals','SAR','﷼'),
(97,'Serbia, Dinars','RSD','Дин.'),
(98,'Seychelles, Rupees','SCR','₨'),
(99,'Singapore, Dollars','SGD','$'),
(100,'Solomon Islands, Dollars','SBD','$'),
(101,'Somalia, Shillings','SOS','S'),
(102,'South Africa, Rand','ZAR','R'),
(103,'South Korea, Won','KRW','₩'),
(104,'Sri Lanka, Rupees','LKR','₨'),
(105,'Sweden, Kronor','SEK','kr'),
(106,'Switzerland, Francs','CHF','CHF'),
(107,'Suriname, Dollars','SRD','$'),
(108,'Syria, Pounds','SYP','£'),
(109,'Taiwan, New Dollars','TWD','NT$'),
(110,'Thailand, Baht','THB','฿'),
(111,'Trinidad and Tobago, Dollars','TTD','TT$'),
(112,'Turkey, New Lira','TRY','YTL'),
(113,'Turkey, Liras','TRL','₤'),
(114,'Tuvalu, Dollars','TVD','$'),
(115,'Ukraine, Hryvnia','UAH','₴'),
(116,'United Arab Emirates, Dirham','AED','AED'),
(117,'United Kingdom, Pounds','GBP','£'),
(118,'United Republic of Tanzania, Shilling','TZS','TZS'),
(119,'USA, Dollars','USD','$'),
(120,'Uruguay, Pesos','UYU','$U'),
(121,'Uzbekistan, Sums','UZS','лв'),
(122,'Venezuela, Bolivares Fuertes','VEF','Bs'),
(123,'Vietnam, Dong','VND','₫'),
(124,'Zambia, Kwacha','ZMK','ZMK'),
(125,'Yemen, Rials','YER','﷼'),
(126,'Zimbabwe Dollars','ZWD','Z$'),
(127,'Malawi, Kwacha','MWK','MK'),
(128,'Tunisian, Dinar','TD','TD'),
(129,'Moroccan, Dirham','MAD','DH'),
(130,'Iraqi Dinar','IQD','ID'),
(131,'Maldivian Ruffiya','MVR','MVR'),
(132,'Ugandan Shilling','UGX','Sh'),
(133,'Sudanese Pound','SDG','£'),
(134,'CFA Franc BCEAO','XOF','CFA'),
(135,'CFA Franc BEAC','XAF','CFA'),
(136,'Haiti, Gourde','HTG','G'),
(137,'Libya, Dinar','LYD','LYD'),
(138,'CFP Franc','XPF','F');

--
-- Table structure for table `vtiger_currencies_seq`
--

CREATE TABLE `vtiger_currencies_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currencies_seq`
--

INSERT INTO `vtiger_currencies_seq` VALUES
(138);

--
-- Table structure for table `vtiger_currency`
--

CREATE TABLE `vtiger_currency` (
  `currencyid` int(19) NOT NULL AUTO_INCREMENT,
  `currency` varchar(200) NOT NULL,
  `sortorderid` int(19) NOT NULL DEFAULT 0,
  `presence` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currencyid`),
  UNIQUE KEY `currency_currency_idx` (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency`
--


--
-- Table structure for table `vtiger_currency_decimal_separator`
--

CREATE TABLE `vtiger_currency_decimal_separator` (
  `currency_decimal_separatorid` int(19) NOT NULL AUTO_INCREMENT,
  `currency_decimal_separator` varchar(2) NOT NULL,
  `sortorderid` int(19) NOT NULL DEFAULT 0,
  `presence` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_decimal_separatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_decimal_separator`
--

INSERT INTO `vtiger_currency_decimal_separator` VALUES
(1,'.',0,1),
(2,',',1,1),
(3,'\'',2,1),
(4,' ',3,1),
(5,'$',4,1);

--
-- Table structure for table `vtiger_currency_decimal_separator_seq`
--

CREATE TABLE `vtiger_currency_decimal_separator_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_decimal_separator_seq`
--

INSERT INTO `vtiger_currency_decimal_separator_seq` VALUES
(5);

--
-- Table structure for table `vtiger_currency_grouping_pattern`
--

CREATE TABLE `vtiger_currency_grouping_pattern` (
  `currency_grouping_patternid` int(19) NOT NULL AUTO_INCREMENT,
  `currency_grouping_pattern` varchar(200) NOT NULL,
  `sortorderid` int(19) NOT NULL DEFAULT 0,
  `presence` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_grouping_patternid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_pattern`
--

INSERT INTO `vtiger_currency_grouping_pattern` VALUES
(1,'123,456,789',0,1),
(2,'123456789',1,1),
(3,'123456,789',2,1),
(4,'12,34,56,789',3,1);

--
-- Table structure for table `vtiger_currency_grouping_pattern_seq`
--

CREATE TABLE `vtiger_currency_grouping_pattern_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_pattern_seq`
--

INSERT INTO `vtiger_currency_grouping_pattern_seq` VALUES
(4);

--
-- Table structure for table `vtiger_currency_grouping_separator`
--

CREATE TABLE `vtiger_currency_grouping_separator` (
  `currency_grouping_separatorid` int(19) NOT NULL AUTO_INCREMENT,
  `currency_grouping_separator` varchar(2) NOT NULL,
  `sortorderid` int(19) NOT NULL DEFAULT 0,
  `presence` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_grouping_separatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_separator`
--

INSERT INTO `vtiger_currency_grouping_separator` VALUES
(1,',',0,1),
(2,'.',1,1),
(3,'\'',2,1),
(4,' ',3,1),
(5,'$',4,1);

--
-- Table structure for table `vtiger_currency_grouping_separator_seq`
--

CREATE TABLE `vtiger_currency_grouping_separator_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_separator_seq`
--

INSERT INTO `vtiger_currency_grouping_separator_seq` VALUES
(5);

--
-- Table structure for table `vtiger_currency_info`
--

CREATE TABLE `vtiger_currency_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(100) DEFAULT NULL,
  `currency_code` varchar(100) DEFAULT NULL,
  `currency_symbol` varchar(30) DEFAULT NULL,
  `conversion_rate` decimal(12,5) DEFAULT NULL,
  `currency_status` varchar(25) DEFAULT NULL,
  `defaultid` varchar(10) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_info`
--

INSERT INTO `vtiger_currency_info` VALUES
(1,'Australia, Dollars','USD','$',1.00000,'Active','0',1),
(2,'India, Rupees','INR','₹',1.00000,'Active','-11',0),
(3,'USA, Dollars','USD','$',1.00000,'Active','0',0),
(4,'Albania, Leke','ALL','Lek',1.00000,'Active','0',1);

--
-- Table structure for table `vtiger_currency_info_seq`
--

CREATE TABLE `vtiger_currency_info_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_info_seq`
--

INSERT INTO `vtiger_currency_info_seq` VALUES
(4);

--
-- Table structure for table `vtiger_currency_symbol_placement`
--

CREATE TABLE `vtiger_currency_symbol_placement` (
  `currency_symbol_placementid` int(19) NOT NULL AUTO_INCREMENT,
  `currency_symbol_placement` varchar(30) NOT NULL,
  `sortorderid` int(19) NOT NULL DEFAULT 0,
  `presence` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_symbol_placementid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_symbol_placement`
--

INSERT INTO `vtiger_currency_symbol_placement` VALUES
(1,'$1.0',0,1),
(2,'1.0$',1,1);

--
-- Table structure for table `vtiger_currency_symbol_placement_seq`
--

CREATE TABLE `vtiger_currency_symbol_placement_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_currency_symbol_placement_seq`
--

INSERT INTO `vtiger_currency_symbol_placement_seq` VALUES
(2);

--
-- Table structure for table `vtiger_current_eqpt_status`
--

CREATE TABLE `vtiger_current_eqpt_status` (
  `current_eqpt_statusid` int(11) NOT NULL AUTO_INCREMENT,
  `current_eqpt_status` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`current_eqpt_statusid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_current_eqpt_status`
--

INSERT INTO `vtiger_current_eqpt_status` VALUES
(1,'ON ROAD',0,1,NULL);

--
-- Table structure for table `vtiger_current_eqpt_status_seq`
--

CREATE TABLE `vtiger_current_eqpt_status_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_current_eqpt_status_seq`
--

INSERT INTO `vtiger_current_eqpt_status_seq` VALUES
(1);

--
-- Table structure for table `vtiger_current_service_status`
--

CREATE TABLE `vtiger_current_service_status` (
  `current_service_statusid` int(11) NOT NULL AUTO_INCREMENT,
  `current_service_status` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`current_service_statusid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_current_service_status`
--

INSERT INTO `vtiger_current_service_status` VALUES
(1,'WAITING FOR REPLACEMENT PARTS',0,1,NULL);

--
-- Table structure for table `vtiger_current_service_status_seq`
--

CREATE TABLE `vtiger_current_service_status_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_current_service_status_seq`
--

INSERT INTO `vtiger_current_service_status_seq` VALUES
(1);

--
-- Table structure for table `vtiger_cust_maint_hour_cons`
--

CREATE TABLE `vtiger_cust_maint_hour_cons` (
  `cust_maint_hour_consid` int(11) NOT NULL AUTO_INCREMENT,
  `cust_maint_hour_cons` 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 (`cust_maint_hour_consid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cust_maint_hour_cons`
--

INSERT INTO `vtiger_cust_maint_hour_cons` VALUES
(1,'Yes',1,130990,1,NULL),
(2,'No',1,130991,2,NULL);

--
-- Table structure for table `vtiger_cust_maint_hour_cons_seq`
--

CREATE TABLE `vtiger_cust_maint_hour_cons_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cust_maint_hour_cons_seq`
--

INSERT INTO `vtiger_cust_maint_hour_cons_seq` VALUES
(2);

--
-- Table structure for table `vtiger_cust_role`
--

CREATE TABLE `vtiger_cust_role` (
  `cust_roleid` int(11) NOT NULL AUTO_INCREMENT,
  `cust_role` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`cust_roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cust_role`
--

INSERT INTO `vtiger_cust_role` VALUES
(5,'Service Engineer',4,1,NULL);

--
-- Table structure for table `vtiger_cust_role_seq`
--

CREATE TABLE `vtiger_cust_role_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `vtiger_cust_role_seq`
--

INSERT INTO `vtiger_cust_role_seq` VALUES
(5);

--
-- Table structure for table `vtiger_customaction`
--

CREATE TABLE `vtiger_customaction` (
  `cvid` int(19) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `module` varchar(50) NOT NULL,
  `content` text DEFAULT NULL,
  KEY `customaction_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_customaction` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customaction`
--


--
-- Table structure for table `vtiger_customer_type`
--

CREATE TABLE `vtiger_customer_type` (
  `customer_typeid` int(11) NOT NULL AUTO_INCREMENT,
  `customer_type` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`customer_typeid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customer_type`
--

INSERT INTO `vtiger_customer_type` VALUES
(2,'Public Sector Undertaking (PSU)',4,1,'#ffffff'),
(3,'State Government',5,1,'#ffffff'),
(4,'Central Government',1,1,'#ffffff'),
(5,'Private Industry/Company',3,1,'#ffffff'),
(6,'Others',6,1,'#ffffff'),
(7,'Overseas Company',2,1,'#ffffff');

--
-- Table structure for table `vtiger_customer_type_seq`
--

CREATE TABLE `vtiger_customer_type_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customer_type_seq`
--

INSERT INTO `vtiger_customer_type_seq` VALUES
(7);

--
-- Table structure for table `vtiger_customercare`
--

CREATE TABLE `vtiger_customercare` (
  `customercareid` int(19) NOT NULL,
  `customcare_no` varchar(255) DEFAULT NULL,
  `customercare_name` varchar(255) DEFAULT NULL,
  `customercare_mobile` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`customercareid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customercare`
--

INSERT INTO `vtiger_customercare` VALUES
(633516,'','Priya','9900883345'),
(633523,'','Priya','9008902546'),
(633524,'IN01','Priya','9008902596'),
(639439,'IN02','Priya','9008902506'),
(639440,'IN03','Priya','9008902506'),
(641854,'IN04','Yashil','8660600881');

--
-- Table structure for table `vtiger_customercarecf`
--

CREATE TABLE `vtiger_customercarecf` (
  `customercareid` int(19) NOT NULL,
  PRIMARY KEY (`customercareid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customercarecf`
--

INSERT INTO `vtiger_customercarecf` VALUES
(633516),
(633523),
(633524),
(639439),
(639440),
(641854);

--
-- Table structure for table `vtiger_customerdetails`
--

CREATE TABLE `vtiger_customerdetails` (
  `customerid` int(19) NOT NULL,
  `portal` varchar(3) DEFAULT NULL,
  `support_start_date` date DEFAULT NULL,
  `support_end_date` date DEFAULT NULL,
  PRIMARY KEY (`customerid`),
  CONSTRAINT `fk_1_vtiger_customerdetails` FOREIGN KEY (`customerid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customerdetails`
--

INSERT INTO `vtiger_customerdetails` VALUES
(642391,'0','2025-06-06','2026-06-06');

--
-- Table structure for table `vtiger_customerportal_fields`
--

CREATE TABLE `vtiger_customerportal_fields` (
  `tabid` int(19) NOT NULL,
  `fieldinfo` text DEFAULT NULL,
  `records_visible` int(1) DEFAULT NULL,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customerportal_fields`
--

INSERT INTO `vtiger_customerportal_fields` VALUES
(4,'{\"firstname\":0,\"email\":0,\"manual_company\":0,\"customer_type\":0,\"other_customer_type\":0,\"business_sector\":0,\"other_business_sector\":0,\"office_type\":0,\"other_office_type\":0,\"mailingstreet\":0,\"otherstreet\":0,\"mailingcity\":0,\"mailingstate\":0,\"mailingzip\":0,\"nearest_office\":0,\"user_password\":0,\"confirm_password\":0,\"mobile\":0}',1),
(6,'{\"accountname\":1,\"assigned_user_id\":1}',1),
(8,'{\"notes_title\":1,\"assigned_user_id\":0,\"filename\":0}',1),
(13,'{\"ticket_title\":1,\"assigned_user_id\":0,\"ticketpriorities\":1,\"ticket_type\":1,\"purpose\":0,\"equipment_id\":0,\"manual_equ_ser\":0,\"hmr\":0,\"kilometer_reading\":0,\"equip_status\":0,\"date_of_failure\":0,\"system_affected\":0,\"description\":1,\"opp_name\":0,\"phone\":0,\"imagename\":1,\"date_of_delivery\":0,\"pre_address\":0,\"pincode\":0,\"city\":0,\"state\":0,\"nearest_railway\":0,\"func_loc_id\":0,\"chg_func_loc\":0,\"manual_loc\":0,\"cf_1214\":0,\"sr_dep_system\":0,\"ticketstatus\":1,\"sr_equip_model\":0,\"equip_id_da\":0,\"det_of_sub_asmbl\":0,\"district\":0,\"purchase_ref\":0,\"sub_assembly\":0,\"system_pros_mod\":0,\"war_claim_dte\":0,\"external_app_num\":0,\"ticket_date\":0}',1),
(14,'{\"productname\":1,\"assigned_user_id\":0}',0),
(15,'{\"faqstatus\":1,\"question\":1,\"faq_answer\":1}',1),
(20,'{\"subject\":1,\"account_id\":1,\"assigned_user_id\":0,\"source\":0,\"modifiedtime\":0,\"potential_id\":0,\"shipping\":0,\"ship_city\":0,\"quotestage\":0}',1),
(23,'{\"subject\":1,\"account_id\":1,\"assigned_user_id\":0,\"bill_street\":1,\"ship_street\":1}',1),
(35,'{\"subject\":1,\"assigned_user_id\":0}',1),
(36,'{\"servicename\":1}',1),
(38,'{\"product\":1,\"serialnumber\":1,\"assigned_user_id\":1,\"datesold\":1,\"dateinservice\":1,\"assetstatus\":1,\"assetname\":1,\"account\":1}',1),
(43,'{\"projectmilestonename\":1,\"projectid\":1,\"assigned_user_id\":1}',1),
(44,'{\"projecttaskname\":1,\"projectid\":1,\"assigned_user_id\":0}',1),
(45,'{\"projectname\":1,\"assigned_user_id\":0}',1),
(50,'{\"badge_no\":0,\"business_vertical\":0,\"service_engineer_name\":0,\"date_of_birth\":0,\"date_of_joining\":0,\"email\":0,\"office\":0,\"cust_role\":0,\"sub_service_manager_role\":0,\"designaion\":0,\"user_password\":0,\"confirm_password\":0,\"phone\":0,\"district_office\":0,\"service_center\":0,\"product_division\":0,\"activity_center\":0,\"regional_office\":0,\"service_centre\":0,\"production_division\":0,\"activity_centre\":0}',1),
(52,'{\"equipment_sl_no\":0,\"eq_valid_from\":0,\"eq_valid_to\":0,\"equip_model\":0,\"cf_933\":0,\"cf_937\":0,\"cf_939\":0,\"cf_945\":0,\"cf_943\":0,\"cf_931\":0,\"cf_941\":0,\"cf_951\":0,\"equi_desc\":0,\"maintain_plant\":0,\"eq_equip_status\":0,\"account_id\":0,\"assigned_user_id\":0,\"source\":0,\"cf_935\":0,\"functional_loc\":0,\"createdtime\":0,\"modifiedtime\":0,\"eq_contra_app\":0,\"total_year_cont\":0,\"cont_start_date\":0,\"cont_end_date\":0,\"run_year_cont\":0,\"eq_type_of_conrt\":0,\"eq_available\":0,\"eq_run_war_st\":0,\"eq_available_for\":0,\"maint_h_app_for_ac\":0,\"eq_mon_available\":0,\"eq_war_app_cp\":0,\"eq_war_app_wp\":0,\"shift_hours\":0,\"start_day_of_avail_calc\":0,\"awp_commited_avl_y\":0,\"afbwcpas_commited_avl_y\":0,\"afbwcpas_commited_avl_m\":0,\"saatocp_commited_avl_m_w\":0,\"saatocp_commited_avl_y_c\":0,\"daadcp_commited_avl_y_w\":0,\"cust_begin_guar\":0,\"cust_war_end\":0}',0),
(64,'{\"functionallocation_name\":0,\"ftl_loc_desc\":0,\"cf_1216\":0}',1),
(67,'{\"reason_for_modification\":0,\"eq_last_hmr\":0,\"eq_present_km\":0,\"genchk_oil_pressure\":0,\"genchk_transmission\":0,\"ticket_id\":0,\"account_id\":0,\"equip_id_da_sr\":0,\"equipment_id\":0}',0),
(71,'{\"assigned_user_id\":0,\"createdtime\":0,\"modifiedtime\":0,\"source\":0,\"phone\":0,\"service_engineerid\":0,\"call_equip_expirence_in\":0,\"eq_sr_equip_model\":0}',NULL),
(77,'{\"assigned_user_id\":0,\"modifiedtime\":0,\"delivery_date\":0,\"equipment_id\":0,\"account_id\":0,\"createdtime\":0,\"manual_equ_ser\":0,\"source\":0,\"deliveynotessapref\":0,\"rec_created_dt\":0,\"recieving_plant\":0}',1);

--
-- Table structure for table `vtiger_customerportal_prefs`
--

CREATE TABLE `vtiger_customerportal_prefs` (
  `tabid` int(19) NOT NULL,
  `prefkey` varchar(100) NOT NULL,
  `prefvalue` int(20) DEFAULT NULL,
  PRIMARY KEY (`tabid`,`prefkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customerportal_prefs`
--

INSERT INTO `vtiger_customerportal_prefs` VALUES
(0,'defaultassignee',1),
(0,'userid',1),
(4,'showrelatedinfo',1),
(6,'showrelatedinfo',1),
(8,'showrelatedinfo',1),
(13,'showrelatedinfo',1),
(14,'showrelatedinfo',1),
(15,'showrelatedinfo',1),
(20,'showrelatedinfo',1),
(23,'showrelatedinfo',1),
(36,'showrelatedinfo',1),
(38,'showrelatedinfo',1),
(43,'showrelatedinfo',1),
(44,'showrelatedinfo',1),
(45,'showrelatedinfo',1),
(67,'showrelatedinfo',1),
(71,'showrelatedinfo',NULL),
(77,'showrelatedinfo',NULL);

--
-- Table structure for table `vtiger_customerportal_relatedmoduleinfo`
--

CREATE TABLE `vtiger_customerportal_relatedmoduleinfo` (
  `tabid` int(19) NOT NULL,
  `relatedmodules` text DEFAULT NULL,
  PRIMARY KEY (`tabid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customerportal_relatedmoduleinfo`
--

INSERT INTO `vtiger_customerportal_relatedmoduleinfo` VALUES
(13,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1},{\"name\":\"Documents\",\"value\":1}]'),
(23,'[{\"name\":\"History\",\"value\":1}]'),
(20,'[{\"name\":\"History\",\"value\":1}]'),
(14,'[{\"name\":\"History\",\"value\":1}]'),
(36,'[{\"name\":\"History\",\"value\":1}]'),
(8,'[{\"name\":\"History\",\"value\":1}]'),
(38,'[{\"name\":\"History\",\"value\":1}]'),
(43,'[{\"name\":\"History\",\"value\":1}]'),
(44,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1}]'),
(45,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1},{\"name\":\"ProjectTask\",\"value\":1},{\"name\":\"ProjectMilestone\",\"value\":1},{\"name\":\"Documents\",\"value\":1}]'),
(35,'[{\"name\":\"History\",\"value\":1}]'),
(4,'null'),
(15,'null'),
(29,'null'),
(50,'null'),
(52,'null'),
(64,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1},{\"name\":\"Equipment\",\"value\":1}]'),
(67,'null'),
(77,'null');

--
-- Table structure for table `vtiger_customerportal_settings`
--

CREATE TABLE `vtiger_customerportal_settings` (
  `id` int(11) DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `default_assignee` int(11) DEFAULT NULL,
  `support_notification` int(11) DEFAULT NULL,
  `announcement` text DEFAULT NULL,
  `shortcuts` text DEFAULT NULL,
  `widgets` text DEFAULT NULL,
  `charts` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customerportal_settings`
--

INSERT INTO `vtiger_customerportal_settings` VALUES
(1,NULL,1,0,'','{\"Documents\":{\"LBL_ADD_DOCUMENT\":1},\"HelpDesk\":{\"LBL_CREATE_TICKET\":1,\"LBL_OPEN_TICKETS\":1}}','{\"widgets\":{\"HelpDesk\":\"1\",\"Faq\":\"1\",\"Documents\":\"1\"}}','{\"charts\":{\"OpenTicketsByPriority\":1,\"TicketsClosureTimeByPriority\":1}}');

--
-- Table structure for table `vtiger_customerportal_tabs`
--

CREATE TABLE `vtiger_customerportal_tabs` (
  `tabid` int(19) NOT NULL,
  `visible` int(1) DEFAULT 1,
  `sequence` int(1) DEFAULT NULL,
  `createrecord` tinyint(1) NOT NULL DEFAULT 0,
  `editrecord` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customerportal_tabs`
--

INSERT INTO `vtiger_customerportal_tabs` VALUES
(4,1,6,0,0),
(6,0,10,0,1),
(8,0,6,1,0),
(10,0,10,0,0),
(13,1,4,1,0),
(14,0,3,0,0),
(15,1,5,0,0),
(20,0,9,0,0),
(23,0,5,0,0),
(35,0,11,0,0),
(36,0,7,0,0),
(38,0,8,0,1),
(43,0,12,0,0),
(44,1,8,0,0),
(45,1,11,0,0),
(50,1,8,1,1),
(52,1,2,0,0),
(67,1,9,0,0),
(71,1,13,0,0),
(77,1,12,0,0);

--
-- Table structure for table `vtiger_customview`
--

CREATE TABLE `vtiger_customview` (
  `cvid` int(19) NOT NULL,
  `viewname` varchar(100) NOT NULL,
  `setdefault` int(1) DEFAULT 0,
  `setmetrics` int(1) DEFAULT 0,
  `entitytype` varchar(25) NOT NULL,
  `status` int(1) DEFAULT 1,
  `userid` int(19) DEFAULT 1,
  PRIMARY KEY (`cvid`),
  KEY `customview_entitytype_idx` (`entitytype`),
  CONSTRAINT `fk_1_vtiger_customview` FOREIGN KEY (`entitytype`) REFERENCES `vtiger_tab` (`name`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customview`
--

INSERT INTO `vtiger_customview` VALUES
(1,'All',1,0,'Leads',0,1),
(2,'Hot Leads',0,1,'Leads',3,1),
(3,'This Month Leads',0,0,'Leads',3,1),
(4,'All',1,0,'Accounts',0,1),
(6,'New This Week',0,0,'Accounts',3,1),
(7,'All',1,0,'Contacts',0,1),
(8,'Contacts Address',0,0,'Contacts',3,1),
(10,'All',1,0,'Potentials',0,1),
(11,'Potentials Won',0,1,'Potentials',3,1),
(12,'Prospecting',0,0,'Potentials',3,1),
(13,'All',1,0,'HelpDesk',0,1),
(16,'All',1,0,'Quotes',0,1),
(19,'All',1,0,'Calendar',0,1),
(20,'All',1,0,'Emails',0,1),
(21,'All',1,0,'Invoice',0,1),
(22,'All',1,0,'Documents',0,1),
(23,'All',1,0,'PriceBooks',0,1),
(24,'All',1,0,'Products',0,1),
(25,'All',1,0,'PurchaseOrder',0,1),
(26,'All',1,0,'SalesOrder',0,1),
(27,'All',1,0,'Vendors',0,1),
(28,'All',1,0,'Faq',0,1),
(29,'All',1,0,'Campaigns',0,1),
(30,'All',1,0,'Webmails',0,1),
(31,'Drafted FAQ',0,0,'Faq',3,1),
(32,'Published FAQ',0,0,'Faq',3,1),
(33,'Open Purchase Orders',0,0,'PurchaseOrder',3,1),
(34,'Received Purchase Orders',0,0,'PurchaseOrder',3,1),
(35,'Open Invoices',0,0,'Invoice',3,1),
(36,'Paid Invoices',0,0,'Invoice',3,1),
(37,'Pending Sales Orders',0,0,'SalesOrder',3,1),
(38,'All',1,0,'PBXManager',0,1),
(39,'All',1,0,'ServiceContracts',0,1),
(40,'All',1,0,'Services',0,1),
(41,'All',1,0,'Assets',0,1),
(42,'All',0,0,'ModComments',0,1),
(46,'All',0,0,'SMSNotifier',0,1),
(47,'All',1,0,'ProjectMilestone',0,1),
(48,'All',1,0,'ProjectTask',0,1),
(49,'All',1,0,'Project',0,1),
(50,'upcoming repeating  jobs',1,0,'Project',1,1),
(51,'All',1,0,'ServiceEngineer',0,1),
(52,'All',1,0,'BankGuarantee',0,1),
(53,'All',1,0,'Equipment',0,1),
(57,'Last Seven days',0,0,'Contacts',1,1),
(58,'All',1,0,'FunctionalLocations',0,1),
(64,'All',1,0,'ServiceReports',0,1),
(65,'All',1,0,'SalesPlanEquipment',0,1),
(69,'All',1,0,'StockTransferOrders',0,1),
(70,'All',1,0,'MaintenancePlant',0,1),
(71,'BG That Has Validity  Date ',1,0,'BankGuarantee',1,1),
(72,'Not Approved Employee',1,0,'ServiceEngineer',1,1),
(73,'All',1,0,'CallAssistance',0,1),
(75,'All',1,0,'HMREntries',0,1),
(77,'All',1,0,'ServiceOrders',0,1),
(79,'Not completed Tasks',0,0,'Calendar',1,1),
(87,'All',1,0,'FailedParts',0,1),
(88,'All',1,0,'EquipmentAvailability',0,1),
(90,'All',1,0,'DiscussionBlog',0,1),
(91,'Recommissioning Reports - Beml - Breakdown',0,0,'ServiceReports',1,1),
(97,'All',1,0,'DeliveryNotes',0,1),
(98,'Equipment Number Is Empty',1,0,'DeliveryNotes',1,1),
(101,'All',1,0,'RecommissioningReports',0,1),
(104,'All',1,0,'ModelAggregateConfig',0,1),
(106,'From BEML Account',1,0,'RecommissioningReports',3,1),
(107,'From Customer Account',0,0,'RecommissioningReports',3,1),
(108,'All-Mobile-Field-List',0,0,'RecommissioningReports',1,1),
(109,'From Vendor Account',0,0,'RecommissioningReports',3,1),
(110,'Accepted Users',0,0,'ServiceEngineer',3,1),
(113,'All',1,0,'WarrantyDetails',0,1),
(114,'All-Mobile-Field-List',1,0,'ServiceOrders',1,1),
(115,'All-Mobile-Field-List',1,0,'StockTransferOrders',1,1),
(116,'Actual Equipment',0,0,'DeliveryNotes',1,1),
(117,'All',1,0,'ReturnSaleOrders',0,1),
(118,'All-Mobile-Field-List',1,0,'ReturnSaleOrders',3,1),
(119,'Live',0,0,'BankGuarantee',1,1),
(120,'STO Synced To SAP',0,0,'StockTransferOrders',1,1),
(121,'Customer Is Not Empty',0,0,'BankGuarantee',1,1),
(122,'All-Mobile-Field-List',0,0,'BankGuarantee',1,1),
(123,'Extended',0,0,'BankGuarantee',1,1),
(124,'Intial Validity Period Expired',0,0,'BankGuarantee',1,1),
(125,'Extended Validity Period Expired',0,0,'BankGuarantee',1,1),
(126,'Extended Claim Period expired',0,0,'BankGuarantee',1,1),
(127,'Initial Claim Period Expired',0,0,'BankGuarantee',1,1),
(129,'All',1,0,'ModelAndAggregates',0,1),
(132,'All-Mobile-Field-List',1,0,'EquipmentAvailability',1,1),
(133,'All-Mobile-Field-List',1,0,'ServiceReports',1,1),
(134,'Not Defined Warranty Details',1,0,'WarrantyDetails',1,1),
(136,'All-Mobile-Field-List',1,0,'CallAssistance',1,1),
(137,'All-Mobile-Field-List',1,0,'Documents',1,1),
(138,'All-Mobile-Field-List',1,0,'HelpDesk',1,1),
(139,'Todays Closed Tickets',0,0,'HelpDesk',1,1),
(143,'Fire Safety Service Requests',0,0,'HelpDesk',1,1),
(145,'All',1,0,'LabelManager',0,1),
(146,'All',1,0,'Companies',0,1),
(147,'All',1,0,'Onboarding',0,1),
(149,'All',1,0,'Visitors',0,1),
(150,'All',1,0,'Attendance',0,1),
(151,'All',1,0,'Attendance',0,1),
(152,'All',1,0,'Guard',0,1),
(153,'All',1,0,'Owner',0,1),
(154,'All',1,0,'Notice',0,1),
(155,'All',1,0,'WaterTank',0,1),
(156,'All',1,0,'WaterTank',0,1),
(157,'All',1,0,'WaterTank',0,1),
(158,'All',1,0,'WaterTank',0,1),
(169,'All',1,0,'SocietyRegistrationForm',0,1),
(170,'All',1,0,'Resident',0,1),
(172,'All',1,0,'GuardDir',0,1),
(173,'All',1,0,'EmergencyDir',0,1),
(176,'All',1,0,'DomesticHelp',0,1),
(179,'All',1,0,'Inout',0,1),
(180,'All',1,0,'SocBlocks',0,1),
(181,'All',1,0,'Plat',0,1),
(182,'All',1,0,'GuestApproval',0,1),
(183,'All',1,0,'GuestApproval',0,1),
(184,'All',1,0,'GuestApproval',0,1),
(185,'All',1,0,'Resident',0,1),
(192,'All',1,0,'GatePass',0,1),
(193,'All',1,0,'ADVNotice',0,1),
(194,'All',1,0,'DeliveryApproval',0,1),
(196,'All',1,0,'CustomerCare',0,1),
(197,'PAST',0,0,'Visitors',1,1),
(198,'PAST',0,0,'Visitors',1,876),
(199,'DENIED',0,1,'Visitors',1,1),
(200,'DENIED',1,0,'Visitors',1,876),
(201,'All Employee',1,0,'ServiceEngineer',1,880),
(202,'DENY',0,0,'Visitors',1,876),
(205,'My services',0,0,'DomesticHelp',1,876),
(206,'My service',0,0,'DomesticHelp',1,888),
(207,'All services',0,0,'DomesticHelp',1,888),
(208,'All',1,0,'PaymentDetail',0,1),
(209,'All',1,0,'QRCode',0,1),
(210,'DUE',0,0,'PaymentDetail',1,1),
(211,'PAID',0,0,'PaymentDetail',1,1),
(212,'PAST',0,0,'Visitors',1,888),
(213,'DENIED',0,0,'Visitors',1,888),
(216,'All',1,0,'Poll',0,1),
(218,'All-Mobile-Field-List',1,0,'Visitors',1,1040),
(219,'All-Mobile-Field-List',0,0,'Visitors',1,1),
(220,'All',1,0,'BuyAndSell',0,1),
(231,'All',1,0,'Amenities',0,1),
(232,'All',1,0,'Amenities',0,1),
(233,'All',1,0,'Amenities',0,1),
(234,'All',1,0,'Amenities',0,1),
(239,'All',1,0,'Announcements',0,1),
(240,'Active ',1,0,'Announcements',1,1),
(241,'All',1,0,'Booking',0,1),
(243,'All',1,0,'InfraEmployee',0,1);

--
-- Table structure for table `vtiger_customview_seq`
--

CREATE TABLE `vtiger_customview_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_customview_seq`
--

INSERT INTO `vtiger_customview_seq` VALUES
(243);

--
-- Table structure for table `vtiger_cv2group`
--

CREATE TABLE `vtiger_cv2group` (
  `cvid` int(25) NOT NULL,
  `groupid` int(25) NOT NULL,
  KEY `vtiger_cv2group_ibfk_1` (`cvid`),
  KEY `vtiger_groups_ibfk_1` (`groupid`),
  CONSTRAINT `vtiger_customview_ibfk_2` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_groups_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cv2group`
--


--
-- Table structure for table `vtiger_cv2role`
--

CREATE TABLE `vtiger_cv2role` (
  `cvid` int(25) NOT NULL,
  `roleid` varchar(255) NOT NULL,
  KEY `vtiger_cv2role_ibfk_1` (`cvid`),
  KEY `vtiger_role_ibfk_1` (`roleid`),
  CONSTRAINT `vtiger_customview_ibfk_3` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_role_ibfk_1` FOREIGN KEY (`roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cv2role`
--


--
-- Table structure for table `vtiger_cv2rs`
--

CREATE TABLE `vtiger_cv2rs` (
  `cvid` int(25) NOT NULL,
  `rsid` varchar(255) NOT NULL,
  KEY `vtiger_cv2role_ibfk_1` (`cvid`),
  KEY `vtiger_rolesd_ibfk_1` (`rsid`),
  CONSTRAINT `vtiger_customview_ibfk_4` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_rolesd_ibfk_1` FOREIGN KEY (`rsid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cv2rs`
--


--
-- Table structure for table `vtiger_cv2users`
--

CREATE TABLE `vtiger_cv2users` (
  `cvid` int(25) NOT NULL,
  `userid` int(25) NOT NULL,
  KEY `vtiger_cv2users_ibfk_1` (`cvid`),
  KEY `vtiger_users_ibfk_1` (`userid`),
  CONSTRAINT `vtiger_customview_ibfk_1` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_users_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cv2users`
--


--
-- Table structure for table `vtiger_cvadvfilter`
--

CREATE TABLE `vtiger_cvadvfilter` (
  `cvid` int(19) NOT NULL,
  `columnindex` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  `comparator` varchar(20) DEFAULT NULL,
  `value` varchar(512) DEFAULT NULL,
  `groupid` int(11) DEFAULT 1,
  `column_condition` varchar(255) DEFAULT 'and',
  PRIMARY KEY (`cvid`,`columnindex`),
  KEY `cvadvfilter_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvadvfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cvadvfilter`
--

INSERT INTO `vtiger_cvadvfilter` VALUES
(2,0,'vtiger_leaddetails:leadstatus:leadstatus:Leads_Lead_Status:V','e','Hot',1,'and'),
(11,0,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V','e','Closed Won',1,'and'),
(12,0,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V','e','Prospecting',1,'and'),
(31,0,'vtiger_faq:status:faqstatus:Faq_Status:V','e','Draft',1,'and'),
(32,0,'vtiger_faq:status:faqstatus:Faq_Status:V','e','Published',1,'and'),
(33,0,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V','e','Created, Approved, Delivered',1,'and'),
(34,0,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V','e','Received Shipment',1,'and'),
(35,0,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V','e','Created, Approved, Sent',1,'and'),
(36,0,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V','e','Paid',1,'and'),
(37,0,'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V','e','Created, Approved',1,'and'),
(50,0,'vtiger_projectcf:cf_854:cf_854:Project_Next_Recurring_Date:D','lessthandaysago','3',1,''),
(57,0,'vtiger_crmentity:createdtime:createdtime:Contacts_Created_Time:DT','last7days','2022-05-05 07:00:00,2022-05-11 07:00:00',1,''),
(71,0,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V','ny','',1,''),
(72,0,'vtiger_serviceengineer:approval_status:approval_status:ServiceEngineer_Approval_Status:V','c','Pending',2,'or'),
(72,1,'vtiger_serviceengineer:approval_status:approval_status:ServiceEngineer_Approval_Status:V','y','',2,''),
(79,0,'vtiger_activity:status:taskstatus:Calendar_Status:V','n','Completed',1,''),
(91,0,'vtiger_servicereportscf:eq_sta_aft_act_taken:eq_sta_aft_act_taken:ServiceReports_eq_sta_aft_act_taken:V','e','Off Road',1,'and'),
(91,1,'vtiger_servicereportscf:off_on_account_of:off_on_account_of:ServiceReports_Off_Road_on_Account_of:V','e','BEML',1,'and'),
(91,2,'vtiger_servicereports:sr_ticket_type:sr_ticket_type:ServiceReports_Type:V','e','BREAKDOWN',1,''),
(98,0,'vtiger_deliverynotes:equipment_id:equipment_id:DeliveryNotes_Equipment_Number:V','y','',1,''),
(106,0,'vtiger_inventoryproductrel:sr_replace_action:sr_replace_action:RecommissioningReports_Replacement_Action:V','e','From BEML Stock',1,''),
(107,0,'vtiger_inventoryproductrel:sr_replace_action:sr_replace_action:RecommissioningReports_Replacement_Action:V','e','From Customer Stock',1,''),
(109,0,'vtiger_inventoryproductrel:sr_replace_action:sr_replace_action:RecommissioningReports_Replacement_Action:V','e','From Vendor Stock',1,''),
(110,0,'vtiger_serviceengineer:approval_status:approval_status:ServiceEngineer_Approval_Status:V','e','Accepted',1,''),
(116,0,'vtiger_deliverynotes:equipment_id:equipment_id:DeliveryNotes_Equipment_Number:V','ny','',1,''),
(119,0,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V','e','Live',1,''),
(120,0,'vtiger_stocktransferorders:external_app_num:external_app_num:StockTransferOrders_SAP_Reference_Number:V','ny','',1,''),
(121,0,'vtiger_bankguarantee:account_id:account_id:BankGuarantee_Customer_Number:V','ny','',1,''),
(123,0,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V','e','Extended',1,''),
(124,0,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V','e','Intial Validity Period Expired',1,''),
(125,0,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V','e','Extended Validity Period expired',1,''),
(126,0,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V','e','Extended Claim Period expired',1,''),
(127,0,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V','e','Initial Claim Period expired',1,''),
(134,0,'vtiger_warrantydetails:wr_warranty_in_mon:wr_warranty_in_mon:WarrantyDetails_LBL_WR_WARRANTY_IN_MON:I','y','',2,'or'),
(134,1,'vtiger_warrantydetails:wr_waranty_hours:wr_waranty_hours:WarrantyDetails_LBL_WR_WARANTY_HOURS:I','y','',2,''),
(139,0,'vtiger_ticketcf:cf_2796:cf_2796:HelpDesk_Ticket_Closed_Date:D','today','2023-06-01',1,''),
(197,0,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C','e','1',1,''),
(198,0,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C','e','1',1,''),
(199,0,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C','e','0',1,''),
(200,0,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C','e','0',1,''),
(202,0,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C','e','0',1,''),
(205,0,'vtiger_domestichelp:addtoflat:addtoflat:DomesticHelp_Add_To_My_Flat:C','e','1',1,'and'),
(205,1,'vtiger_domestichelp:domhelp_approval_status:domhelp_approval_status:DomesticHelp_Approval_Status:V','e','Accepted',1,''),
(206,0,'vtiger_domestichelp:addtoflat:addtoflat:DomesticHelp_Add_To_My_Flat:C','e','1',1,'and'),
(206,1,'vtiger_domestichelp:domhelp_approval_status:domhelp_approval_status:DomesticHelp_Approval_Status:V','e','Accepted',1,''),
(207,0,'vtiger_domestichelp:domhelp_approval_status:domhelp_approval_status:DomesticHelp_Approval_Status:V','e','Accepted',1,''),
(210,0,'vtiger_paymentdetail:payment_status:payment_status:PaymentDetail_Status:V','e','NotPaid',1,''),
(211,0,'vtiger_paymentdetail:payment_status:payment_status:PaymentDetail_Status:V','e','Paid',1,''),
(212,0,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C','e','1',1,''),
(213,0,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C','e','0',1,''),
(240,0,'vtiger_announcements:annos_active:annos_active:Announcements_Announcement_Active:V','e','1',1,'');

--
-- Table structure for table `vtiger_cvadvfilter_grouping`
--

CREATE TABLE `vtiger_cvadvfilter_grouping` (
  `groupid` int(11) NOT NULL,
  `cvid` int(19) NOT NULL,
  `group_condition` varchar(255) DEFAULT NULL,
  `condition_expression` text DEFAULT NULL,
  PRIMARY KEY (`groupid`,`cvid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cvadvfilter_grouping`
--

INSERT INTO `vtiger_cvadvfilter_grouping` VALUES
(1,2,'',''),
(1,11,'',''),
(1,12,'',''),
(1,31,'',''),
(1,32,'',''),
(1,33,'',''),
(1,34,'',''),
(1,35,'',''),
(1,36,'',''),
(1,37,'',''),
(1,50,'and',' 0 '),
(1,57,'and',' 0 '),
(1,71,'and',' 0 '),
(1,79,'and',' 0 '),
(1,91,'and',' 0 and 1 and 2 '),
(1,98,'and',' 0 '),
(1,106,'and',' 0 '),
(1,107,'and',' 0 '),
(1,109,'and',' 0 '),
(1,110,'and',' 0 '),
(1,116,'and',' 0 '),
(1,119,'and',' 0 '),
(1,120,'and',' 0 '),
(1,121,'and',' 0 '),
(1,123,'and',' 0 '),
(1,124,'and',' 0 '),
(1,125,'and',' 0 '),
(1,126,'and',' 0 '),
(1,127,'and',' 0 '),
(1,139,'and',' 0 '),
(1,197,'and',' 0 '),
(1,198,'and',' 0 '),
(1,199,'and',' 0 '),
(1,200,'and',' 0 '),
(1,202,'and',' 0 '),
(1,205,'and',' 0 and 1 '),
(1,206,'and',' 0 and 1 '),
(1,207,'and',' 0 '),
(1,210,'and',' 0 '),
(1,211,'and',' 0 '),
(1,212,'and',' 0 '),
(1,213,'and',' 0 '),
(1,240,'and',' 0 '),
(2,72,NULL,' 0 or 1 '),
(2,134,NULL,' 0 or 1 ');

--
-- Table structure for table `vtiger_cvcolumnlist`
--

CREATE TABLE `vtiger_cvcolumnlist` (
  `cvid` int(19) NOT NULL,
  `columnindex` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  PRIMARY KEY (`cvid`,`columnindex`),
  KEY `cvcolumnlist_columnindex_idx` (`columnindex`),
  KEY `cvcolumnlist_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvcolumnlist` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cvcolumnlist`
--

INSERT INTO `vtiger_cvcolumnlist` VALUES
(1,0,'vtiger_leaddetails:company:company:Leads_Soceity_Name:V'),
(1,1,'vtiger_leaddetails:firstname:firstname:Leads_User_Name:V'),
(1,2,'vtiger_leadaddress:phone:phone:Leads_Contact_Number:V'),
(1,3,'vtiger_leadaddress:address:address:Leads_Address:V'),
(1,4,'vtiger_crmentity:smownerid:assigned_user_id:Leads_Assigned_To:V'),
(2,0,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),
(2,1,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),
(2,2,'vtiger_leaddetails:company:company:Leads_Company:V'),
(2,3,'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V'),
(2,4,'vtiger_leadsubdetails:website:website:Leads_Website:V'),
(2,5,'vtiger_leaddetails:email:email:Leads_Email:E'),
(3,0,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),
(3,1,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),
(3,2,'vtiger_leaddetails:company:company:Leads_Company:V'),
(3,3,'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V'),
(3,4,'vtiger_leadsubdetails:website:website:Leads_Website:V'),
(3,5,'vtiger_leaddetails:email:email:Leads_Email:E'),
(4,0,'vtiger_account:accountname:accountname:Accounts_Account_Name:V'),
(4,1,'vtiger_account:phone:phone:Accounts_Phone:V'),
(4,2,'vtiger_crmentity:smownerid:assigned_user_id:Accounts_Assigned_To:V'),
(4,3,'vtiger_account:soceity_accountname:soceity_accountname:Accounts_Soceity_Instance_Name:V'),
(6,0,'vtiger_account:accountname:accountname:Accounts_Account_Name:V'),
(6,1,'vtiger_account:phone:phone:Accounts_Phone:V'),
(6,2,'vtiger_account:website:website:Accounts_Website:V'),
(6,3,'vtiger_accountbillads:bill_city:bill_city:Accounts_City:V'),
(6,4,'vtiger_crmentity:smownerid:assigned_user_id:Accounts_Assigned_To:V'),
(7,0,'vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V'),
(7,1,'vtiger_contactdetails:manual_company:manual_company:Contacts_Company_Name:V'),
(7,2,'vtiger_contactdetails:email:email:Contacts_Email:V'),
(7,3,'vtiger_contactdetails:accountid:account_id:Contacts_Account_Name:V'),
(7,4,'vtiger_contactdetails:contact_no:contact_no:Contacts_Contact_Id:V'),
(7,5,'vtiger_crmentity:smownerid:assigned_user_id:Contacts_Assigned_To:V'),
(7,6,'vtiger_contactdetails:title:title:Contacts_Title:V'),
(8,0,'vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V'),
(8,1,'vtiger_contactdetails:lastname:lastname:Contacts_Last_Name:V'),
(8,2,'vtiger_contactaddress:mailingstreet:mailingstreet:Contacts_Mailing_Street:V'),
(8,3,'vtiger_contactaddress:mailingcity:mailingcity:Contacts_Mailing_City:V'),
(8,4,'vtiger_contactaddress:mailingstate:mailingstate:Contacts_Mailing_State:V'),
(8,5,'vtiger_contactaddress:mailingzip:mailingzip:Contacts_Mailing_Zip:V'),
(8,6,'vtiger_contactaddress:mailingcountry:mailingcountry:Contacts_Mailing_Country:V'),
(10,0,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),
(10,1,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),
(10,2,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),
(10,3,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V'),
(10,4,'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V'),
(10,5,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),
(10,6,'vtiger_potential:amount:amount:Potentials_Amount:N'),
(10,7,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),
(11,0,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),
(11,1,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),
(11,2,'vtiger_potential:amount:amount:Potentials_Amount:N'),
(11,3,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),
(11,4,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),
(11,5,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),
(12,0,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),
(12,1,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),
(12,2,'vtiger_potential:amount:amount:Potentials_Amount:N'),
(12,3,'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V'),
(12,4,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),
(12,5,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),
(12,6,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),
(12,7,'vtiger_account:product_subcategory:(related_to ; (Accounts) product_subcategory):Accounts_Organization_Name-Product_Subcategory:V'),
(12,8,'vtiger_account:serial_number:(related_to ; (Accounts) serial_number):Accounts_Organization_Name-Serial_Number:V'),
(13,0,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),
(13,1,'vtiger_troubletickets:tic_description:tic_description:HelpDesk_Description:V'),
(13,2,'vtiger_troubletickets:tic_type:tic_type:HelpDesk_Ticket_Type:V'),
(13,3,'vtiger_crmentity:smcreatorid:smcreatorid:HelpDesk_Creator:V'),
(13,4,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),
(13,5,'vtiger_crmentity:createdtime:createdtime:HelpDesk_Created_Time:DT'),
(13,6,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),
(13,7,'vtiger_troubletickets:tic_rating:tic_rating:HelpDesk_Rating:V'),
(13,8,'vtiger_troubletickets:tic_category:tic_category:HelpDesk_Category:V'),
(13,9,'vtiger_troubletickets:tic_pin_location:tic_pin_location:HelpDesk_Pin_Location:V'),
(16,0,'vtiger_quotes:subject:subject:Quotes_Subject:V'),
(16,1,'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'),
(16,2,'vtiger_quotes:validtill:validtill:Quotes_Valid_Till:D'),
(16,3,'vtiger_quotes:total:hdnGrandTotal:Quotes_Total:N'),
(19,0,'vtiger_activity:status:taskstatus:Calendar_Status:V'),
(19,1,'vtiger_activity:activitytype:activitytype:Calendar_Activity_Type:V'),
(19,2,'vtiger_activity:subject:subject:Calendar_Subject:V'),
(19,3,'vtiger_seactivityrel:crmid:parent_id:Calendar_Related_To:V'),
(19,4,'vtiger_activity:date_start:date_start:Calendar_Start_Date_&_Time:DT'),
(19,5,'vtiger_activity:due_date:due_date:Calendar_Due_Date:D'),
(19,6,'vtiger_crmentity:smownerid:assigned_user_id:Calendar_Assigned_To:V'),
(20,0,'vtiger_activity:subject:subject:Emails_Subject:V'),
(20,1,'vtiger_emaildetails:to_email:saved_toid:Emails_To:V'),
(20,2,'vtiger_activity:date_start:date_start:Emails_Date_&_Time_Sent:DT'),
(21,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),
(21,2,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:V'),
(21,3,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),
(21,4,'vtiger_invoice:total:hdnGrandTotal:Invoice_Total:N'),
(21,5,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),
(22,1,'vtiger_notes:title:notes_title:Documents_Title:V'),
(22,2,'vtiger_notes:filename:filename:Documents_File_Name:V'),
(22,3,'vtiger_crmentity:modifiedtime:modifiedtime:Documents_Modified_Time:DT'),
(22,4,'vtiger_crmentity:smownerid:assigned_user_id:Documents_Assigned_To:V'),
(23,1,'vtiger_pricebook:bookname:bookname:PriceBooks_Price_Book_Name:V'),
(23,2,'vtiger_pricebook:active:active:PriceBooks_Active:C'),
(23,3,'vtiger_pricebook:currency_id:currency_id:PriceBooks_Currency:V'),
(24,0,'vtiger_products:productname:productname:Products_Product_Name:V'),
(24,1,'vtiger_products:manufacturer:manufacturer:Products_Manufacturer:V'),
(24,2,'vtiger_productcf:cf_2794:cf_2794:Products_Part_Name:V'),
(24,3,'vtiger_products:unit_price:unit_price:Products_Unit_Price:N'),
(24,4,'vtiger_products:discontinued:discontinued:Products_Product_Active:C'),
(25,1,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),
(25,2,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:V'),
(25,3,'vtiger_purchaseorder:tracking_no:tracking_no:PurchaseOrder_Tracking_Number:V'),
(25,4,'vtiger_purchaseorder:total:hdnGrandTotal:PurchaseOrder_Total:N'),
(25,5,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),
(26,0,'vtiger_salesorder:external_app_num:external_app_num:SalesOrder_Sale_Order_Document_No:V'),
(26,1,'vtiger_salesorder:equipment_id:equipment_id:SalesOrder_Equipment_Serial_No.:V'),
(26,2,'vtiger_salesorder:project_name:project_name:SalesOrder_Project:V'),
(26,3,'vtiger_salesorder:ticket_id:ticket_id:SalesOrder_Ticket_Id:V'),
(26,4,'vtiger_salesorder:ship_to_party:ship_to_party:SalesOrder_Ship_to_Party:V'),
(27,0,'vtiger_vendor:vendorname:vendorname:Vendors_Vendor_Name:V'),
(27,1,'vtiger_vendor:vendor_no:vendor_no:Vendors_Vendor_No:V'),
(27,2,'vtiger_vendor:phone:phone:Vendors_Phone:V'),
(27,3,'vtiger_vendor:email:email:Vendors_Email:V'),
(27,4,'vtiger_crmentity:smownerid:assigned_user_id:Vendors_Assigned_To:V'),
(27,5,'vtiger_vendor:type_of_services:type_of_services:Vendors_Type_Of_Services:V'),
(27,6,'vtiger_vendor:idproof:idproof:Vendors_ID_Proof:V'),
(27,7,'vtiger_vendor:uploadidproof:uploadidproof:Vendors_Upload_ID_Proof:V'),
(27,8,'vtiger_crmentity:createdtime:createdtime:Vendors_Created_Time:DT'),
(27,9,'vtiger_vendor:postalcode:postalcode:Vendors_Postal_Code:V'),
(27,10,'vtiger_vendor:city:city:Vendors_City:V'),
(27,11,'vtiger_vendor:vendor_approval_status:vendor_approval_status:Vendors_Approval_Status:V'),
(27,12,'vtiger_vendor:state:state:Vendors_State:V'),
(27,13,'vtiger_vendor:address:address:Vendors_Address:V'),
(27,14,'vtiger_vendor:district:district:Vendors_District:V'),
(27,15,'vtiger_vendor:floorno:floorno:Vendors_Floor_Number:V'),
(27,16,'vtiger_vendor:shopno:shopno:Vendors_Shop_Number:V'),
(27,17,'vtiger_vendor:roadorstreetno:roadorstreetno:Vendors_Road/Street_Number:V'),
(27,18,'vtiger_crmentity:modifiedtime:modifiedtime:Vendors_Modified_Time:DT'),
(27,19,'vtiger_vendor:vendor_latitude:vendor_latitude:Vendors_Latitude:V'),
(27,20,'vtiger_vendor:vendor_longitude:vendor_longitude:Vendors_Longitude:V'),
(28,1,'vtiger_faq:question:question:Faq_Question:V'),
(28,2,'vtiger_faq:category:faqcategories:Faq_Category:V'),
(28,3,'vtiger_faq:product_id:product_id:Faq_Product_Name:V'),
(28,4,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),
(28,5,'vtiger_crmentity:modifiedtime:modifiedtime:Faq_Modified_Time:DT'),
(29,1,'vtiger_campaign:campaignname:campaignname:Campaigns_Campaign_Name:V'),
(29,2,'vtiger_campaign:campaigntype:campaigntype:Campaigns_Campaign_Type:V'),
(29,3,'vtiger_campaign:campaignstatus:campaignstatus:Campaigns_Campaign_Status:V'),
(29,4,'vtiger_campaign:expectedrevenue:expectedrevenue:Campaigns_Expected_Revenue:N'),
(29,5,'vtiger_campaign:closingdate:closingdate:Campaigns_Expected_Close_Date:D'),
(29,6,'vtiger_crmentity:smownerid:assigned_user_id:Campaigns_Assigned_To:V'),
(30,0,'subject:subject:subject:Subject:V'),
(30,1,'from:fromname:fromname:From:N'),
(30,2,'to:tpname:toname:To:N'),
(30,3,'body:body:body:Body:V'),
(31,0,'vtiger_faq:question:question:Faq_Question:V'),
(31,1,'vtiger_faq:status:faqstatus:Faq_Status:V'),
(31,2,'vtiger_faq:product_id:product_id:Faq_Product_Name:I'),
(31,3,'vtiger_faq:category:faqcategories:Faq_Category:V'),
(31,4,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),
(32,0,'vtiger_faq:question:question:Faq_Question:V'),
(32,1,'vtiger_faq:answer:faq_answer:Faq_Answer:V'),
(32,2,'vtiger_faq:status:faqstatus:Faq_Status:V'),
(32,3,'vtiger_faq:product_id:product_id:Faq_Product_Name:I'),
(32,4,'vtiger_faq:category:faqcategories:Faq_Category:V'),
(32,5,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),
(33,0,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),
(33,1,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V'),
(33,2,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I'),
(33,3,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),
(33,4,'vtiger_purchaseorder:duedate:duedate:PurchaseOrder_Due_Date:V'),
(34,0,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),
(34,1,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I'),
(34,2,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),
(34,3,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V'),
(34,4,'vtiger_purchaseorder:carrier:carrier:PurchaseOrder_Carrier:V'),
(34,5,'vtiger_poshipads:ship_street:ship_street:PurchaseOrder_Shipping_Address:V'),
(35,0,'vtiger_invoice:invoice_no:invoice_no:Invoice_Invoice_No:V'),
(35,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),
(35,2,'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I'),
(35,3,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I'),
(35,4,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),
(35,5,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),
(35,6,'vtiger_crmentity:createdtime:createdtime:Invoice_Created_Time:DT'),
(36,0,'vtiger_invoice:invoice_no:invoice_no:Invoice_Invoice_No:V'),
(36,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),
(36,2,'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I'),
(36,3,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I'),
(36,4,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),
(36,5,'vtiger_invoiceshipads:ship_street:ship_street:Invoice_Shipping_Address:V'),
(36,6,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),
(37,0,'vtiger_salesorder:subject:subject:SalesOrder_Subject:V'),
(37,1,'vtiger_salesorder:accountid:account_id:SalesOrder_Account_Name:I'),
(37,2,'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V'),
(37,3,'vtiger_crmentity:smownerid:assigned_user_id:SalesOrder_Assigned_To:V'),
(37,4,'vtiger_soshipads:ship_street:ship_street:SalesOrder_Shipping_Address:V'),
(37,5,'vtiger_salesorder:carrier:carrier:SalesOrder_Carrier:V'),
(38,0,'vtiger_pbxmanager:callstatus:callstatus:PBXManager_Call_Status:V'),
(38,1,'vtiger_pbxmanager:customernumber:customernumber:PBXManager_Customer_Number:V'),
(38,2,'vtiger_pbxmanager:customer:customer:PBXManager_Customer:V'),
(38,3,'vtiger_pbxmanager:user:user:PBXManager_User:V'),
(38,4,'vtiger_pbxmanager:recordingurl:recordingurl:PBXManager_Recording_URL:V'),
(38,5,'vtiger_pbxmanager:totalduration:totalduration:PBXManager_Total_Duration:I'),
(38,6,'vtiger_pbxmanager:starttime:starttime:PBXManager_Start_Time:DT'),
(39,1,'vtiger_servicecontracts:subject:subject:ServiceContracts_Subject:V'),
(39,2,'vtiger_servicecontracts:sc_related_to:sc_related_to:ServiceContracts_Related_to:V'),
(39,3,'vtiger_crmentity:smownerid:assigned_user_id:ServiceContracts_Assigned_To:V'),
(39,4,'vtiger_servicecontracts:start_date:start_date:ServiceContracts_Start_Date:D'),
(39,5,'vtiger_servicecontracts:due_date:due_date:ServiceContracts_Due_date:D'),
(39,7,'vtiger_servicecontracts:progress:progress:ServiceContracts_Progress:N'),
(39,8,'vtiger_servicecontracts:contract_status:contract_status:ServiceContracts_Status:V'),
(40,1,'vtiger_service:servicename:servicename:Services_Service_Name:V'),
(40,2,'vtiger_service:service_usageunit:service_usageunit:Services_Usage_Unit:V'),
(40,3,'vtiger_service:unit_price:unit_price:Services_Price:N'),
(40,4,'vtiger_service:qty_per_unit:qty_per_unit:Services_No_of_Units:N'),
(40,5,'vtiger_service:servicecategory:servicecategory:Services_Service_Category:V'),
(40,6,'vtiger_crmentity:smownerid:assigned_user_id:Services_Owner:I'),
(41,1,'vtiger_assets:assetname:assetname:Assets_Asset_Name:V'),
(41,2,'vtiger_assets:account:account:Assets_Customer_Name:V'),
(41,3,'vtiger_assets:product:product:Assets_Product_Name:V'),
(42,0,'vtiger_modcomments:commentcontent:commentcontent:ModComments_Comment:V'),
(42,1,'vtiger_modcomments:related_to:related_to:ModComments_Related_To:V'),
(42,2,'vtiger_crmentity:modifiedtime:modifiedtime:ModComments_Modified_Time:DT'),
(42,3,'vtiger_crmentity:smownerid:assigned_user_id:ModComments_Assigned_To:V'),
(46,0,'vtiger_smsnotifier:message:message:SMSNotifier_message:V'),
(46,2,'vtiger_crmentity:smownerid:assigned_user_id:SMSNotifier_Assigned_To:V'),
(46,3,'vtiger_crmentity:createdtime:createdtime:SMSNotifier_Created_Time:DT'),
(46,4,'vtiger_crmentity:modifiedtime:modifiedtime:SMSNotifier_Modified_Time:DT'),
(47,0,'vtiger_projectmilestone:projectmilestonename:projectmilestonename:ProjectMilestone_Project_Milestone_Name:V'),
(47,1,'vtiger_projectmilestone:projectmilestonedate:projectmilestonedate:ProjectMilestone_Milestone_Date:D'),
(47,3,'vtiger_crmentity:description:description:ProjectMilestone_description:V'),
(47,4,'vtiger_crmentity:createdtime:createdtime:ProjectMilestone_Created_Time:DT'),
(47,5,'vtiger_crmentity:modifiedtime:modifiedtime:ProjectMilestone_Modified_Time:DT'),
(48,0,'vtiger_projecttask:projecttaskname:projecttaskname:ProjectTask_Project_Task_Name:V'),
(48,1,'vtiger_projecttask:projectid:projectid:ProjectTask_Related_to:V'),
(48,2,'vtiger_projecttask:projecttaskpriority:projecttaskpriority:ProjectTask_Priority:V'),
(48,3,'vtiger_project:linktoaccountscontacts:(projectid ; (Project) linktoaccountscontacts):Project_Related_To-Client_Name:V'),
(48,4,'vtiger_projecttask:projecttaskstatus:projecttaskstatus:ProjectTask_Status:V'),
(48,5,'vtiger_projecttask:startdate:startdate:ProjectTask_Start_Date:D'),
(48,6,'vtiger_projecttask:enddate:enddate:ProjectTask_End_Date:D'),
(48,7,'vtiger_crmentity:smownerid:assigned_user_id:ProjectTask_Assigned_To:V'),
(49,0,'vtiger_project:projectname:projectname:Project_Project_Name:V'),
(49,1,'vtiger_projectcf:cf_854:cf_854:Project_Next_Recurring_Date:D'),
(49,2,'vtiger_projectcf:cf_856:cf_856:Project_Repeat:V'),
(49,3,'vtiger_project:startdate:startdate:Project_Start_Date:D'),
(49,4,'vtiger_project:targetenddate:targetenddate:Project_Target_End_Date:D'),
(49,5,'vtiger_project:actualenddate:actualenddate:Project_Actual_End_Date:D'),
(49,6,'vtiger_project:targetbudget:targetbudget:Project_Target_Budget:V'),
(49,7,'vtiger_project:progress:progress:Project_Progress:V'),
(49,8,'vtiger_project:projectstatus:projectstatus:Project_Status:V'),
(49,9,'vtiger_crmentity:smownerid:assigned_user_id:Project_Assigned_To:V'),
(50,0,'vtiger_project:projectname:projectname:Project_Project_Name:V'),
(50,1,'vtiger_project:linktoaccountscontacts:linktoaccountscontacts:Project_Related_to:V'),
(50,2,'vtiger_projectcf:cf_854:cf_854:Project_Next_Recurring_Date:D'),
(50,3,'vtiger_project:startdate:startdate:Project_Start_Date:D'),
(50,4,'vtiger_crmentity:smownerid:assigned_user_id:Project_Assigned_To:V'),
(50,5,'vtiger_project:targetenddate:targetenddate:Project_Target_End_Date:D'),
(50,6,'vtiger_project:projectstatus:projectstatus:Project_Status:V'),
(50,7,'vtiger_project:projecttype:projecttype:Project_Type:V'),
(50,8,'vtiger_project:projectype:projectype:Project_Project_Type:V'),
(51,0,'vtiger_serviceengineer:email:email:ServiceEngineer_Email_Id:E'),
(51,1,'vtiger_crmentity:smownerid:assigned_user_id:ServiceEngineer_Assigned_To:V'),
(51,2,'vtiger_serviceengineer:sub_service_manager_role:sub_service_manager_role:ServiceEngineer_Sub_Servie_Manager_Role:V'),
(51,3,'vtiger_serviceengineer:service_engineer_name:service_engineer_name:ServiceEngineer_LBL_SERVICE_ENGINEER_NAME:V'),
(51,4,'vtiger_serviceengineer:phone:phone:ServiceEngineer_Mobile_Number:V'),
(51,5,'vtiger_crmentity:createdtime:createdtime:ServiceEngineer_Created_Time:T'),
(51,6,'vtiger_serviceengineer:aadhar_no:aadhar_no:ServiceEngineer_Aadhaar_Number:V'),
(51,7,'vtiger_serviceengineer:emp_society:emp_society:ServiceEngineer_Society_Name_:V'),
(51,8,'vtiger_serviceengineer:badge_no:badge_no:ServiceEngineer_User_Number:V'),
(51,9,'vtiger_serviceengineer:emp_block:emp_block:ServiceEngineer_Block:V'),
(51,10,'vtiger_serviceengineer:emp_starttime:emp_starttime:ServiceEngineer_Start_Time_:T'),
(51,11,'vtiger_serviceengineer:emp_endtime:emp_endtime:ServiceEngineer_End_Time:T'),
(51,12,'vtiger_serviceengineer:emp_weakoff:emp_weakoff:ServiceEngineer_Week_Off_:V'),
(51,13,'vtiger_serviceengineer:emp_imagefile:emp_imagefile:ServiceEngineer_Upload_Image:V'),
(51,14,'vtiger_serviceengineer:approval_status:approval_status:ServiceEngineer_Approval_Status:V'),
(52,0,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V'),
(52,1,'vtiger_crmentity:smownerid:assigned_user_id:BankGuarantee_Assigned_To:V'),
(52,2,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(52,3,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(52,4,'vtiger_bankguarantee:manual_equ_ser:manual_equ_ser:BankGuarantee_Manual_Equipment_Sl.No.:V'),
(52,5,'vtiger_bankguarantee:equipment_model:equipment_model:BankGuarantee_LBL_EQUIPMENT_MODEL:V'),
(52,6,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(52,7,'vtiger_bankguarantee:account_id:account_id:BankGuarantee_Customer_Number:V'),
(52,8,'vtiger_bankguarantee:functional_loc:functional_loc:BankGuarantee_Functional_Location:V'),
(53,0,'vtiger_equipment:model_number:model_number:Equipment_Model_Number:V'),
(53,1,'vtiger_equipment:product_category:product_category:Equipment_Product_Category:V'),
(53,2,'vtiger_equipment:product_subcategory:product_subcategory:Equipment_Product_Subcategory:V'),
(53,3,'vtiger_equipment:product_brand:product_brand:Equipment_Manufacturer:V'),
(53,4,'vtiger_equipment:warrenty_period:warrenty_period:Equipment_Warranty_Period:I'),
(53,5,'vtiger_crmentity:smownerid:assigned_user_id:Equipment_Assigned_To:V'),
(53,6,'vtiger_equipment:final_amount:final_amount:Equipment_Amount:I'),
(53,7,'vtiger_crmentity:source:source:Equipment_Source:V'),
(53,8,'vtiger_crmentity:modifiedtime:modifiedtime:Equipment_Modified_Time:T'),
(53,9,'vtiger_crmentity:createdtime:createdtime:Equipment_Created_Time:T'),
(57,0,'vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V'),
(57,1,'vtiger_contactdetails:contact_no:contact_no:Contacts_Contact_Id:V'),
(57,2,'vtiger_contactdetails:accountid:account_id:Contacts_Account_Name:V'),
(57,3,'vtiger_contactdetails:email:email:Contacts_Email:V'),
(57,4,'vtiger_crmentity:smownerid:assigned_user_id:Contacts_Assigned_To:V'),
(57,5,'vtiger_contactdetails:title:title:Contacts_Title:V'),
(57,6,'vtiger_contactaddress:mailingcity:mailingcity:Contacts_Mailing_City:V'),
(58,0,'vtiger_crmentity:smownerid:assigned_user_id:FunctionalLocations_Assigned_To:V'),
(58,1,'vtiger_functionallocations:functionallocation_name:functionallocation_name:FunctionalLocations_LBL_FUNCTIONALLOCATION_NAME:V'),
(58,2,'vtiger_functionallocations:plant_code:plant_code:FunctionalLocations_Plant_Code:V'),
(58,3,'vtiger_functionallocations:ftl_loc_desc:ftl_loc_desc:FunctionalLocations_Description:V'),
(58,4,'vtiger_functionallocations:func_area_name:func_area_name:FunctionalLocations_Area_Name:V'),
(58,5,'vtiger_functionallocations:func_proj_name:func_proj_name:FunctionalLocations_Project_Name:V'),
(64,0,'vtiger_servicereports:is_submitted:is_submitted:ServiceReports_Is_Submitted:I'),
(64,1,'vtiger_crmentity:smownerid:assigned_user_id:ServiceReports_Assigned_To:V'),
(64,2,'vtiger_servicereports:creditnote_no:creditnote_no:ServiceReports_Report_Number:V'),
(64,3,'vtiger_servicereports:ticket_id:ticket_id:ServiceReports_Ticket_Id:V'),
(64,4,'vtiger_servicereports:sr_ticket_type:sr_ticket_type:ServiceReports_Type:V'),
(64,5,'vtiger_servicereports:hmr:hmr:ServiceReports_Meter_reading:I'),
(64,6,'vtiger_servicereports:ticket_date:ticket_date:ServiceReports_Ticket_Date:D'),
(64,7,'vtiger_servicereports:reported_by:reported_by:ServiceReports_Reported_By:V'),
(64,8,'vtiger_servicereports:account_id:account_id:ServiceReports_Organisation_Name:V'),
(64,9,'vtiger_servicereports:opp_name:opp_name:ServiceReports_Name:V'),
(65,1,'vtiger_crmentity:smownerid:assigned_user_id:SalesPlanEquipment_Assigned_To:V'),
(65,2,'vtiger_crmentity:createdtime:createdtime:SalesPlanEquipment_Created_Time:T'),
(65,3,'vtiger_salesplanequipment:equiment:equiment:SalesPlanEquipment_LBL_EQUIMENT:V'),
(65,4,'vtiger_salesplanequipment:region:region:SalesPlanEquipment_LBL_REGION:V'),
(69,0,'vtiger_stocktransferorders:plant_name:plant_name:StockTransferOrders_Supplying_Plant:V'),
(69,1,'vtiger_stocktransferorders:collective_no:collective_no:StockTransferOrders_Collective_No.:V'),
(69,2,'vtiger_stocktransferorders:your_ref:your_ref:StockTransferOrders_Your_Reference:V'),
(69,3,'vtiger_stocktransferorders:our_ref:our_ref:StockTransferOrders_Our_Reference:V'),
(69,4,'vtiger_stocktransferorders:external_app_num:external_app_num:StockTransferOrders_SAP_Reference_Number:V'),
(70,1,'vtiger_maintenanceplant:plant_code:plant_code:MaintenancePlant_LBL_PLANT_CODE:V'),
(70,2,'vtiger_maintenanceplant:plant_name:plant_name:MaintenancePlant_LBL_PLANT_NAME:V'),
(70,3,'vtiger_crmentity:smownerid:assigned_user_id:MaintenancePlant_Assigned_To:V'),
(70,4,'vtiger_crmentity:createdtime:createdtime:MaintenancePlant_Created_Time:T'),
(70,5,'vtiger_crmentity:modifiedtime:modifiedtime:MaintenancePlant_Modified_Time:T'),
(71,0,'vtiger_bankguarantee:equipment_model:equipment_model:BankGuarantee_LBL_EQUIPMENT_MODEL:V'),
(71,1,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(71,2,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(71,3,'vtiger_bankguarantee:bnk_pre_status:bnk_pre_status:BankGuarantee_Present_Status:V'),
(71,4,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(71,5,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(71,7,'vtiger_bankguarantee:account_id:account_id:BankGuarantee_Customer_Number:V'),
(72,0,'vtiger_serviceengineer:service_engineer_name:service_engineer_name:ServiceEngineer_LBL_SERVICE_ENGINEER_NAME:V'),
(72,1,'vtiger_serviceengineer:phone:phone:ServiceEngineer_Mobile_Number:V'),
(72,2,'vtiger_serviceengineer:sub_service_manager_role:sub_service_manager_role:ServiceEngineer_Sub_Servie_Manager_Role:V'),
(72,3,'vtiger_serviceengineer:email:email:ServiceEngineer_Email_Id:E'),
(72,4,'vtiger_serviceengineer:emp_imagefile:emp_imagefile:ServiceEngineer_Upload_Image:V'),
(72,5,'vtiger_serviceengineer:aadhar_no:aadhar_no:ServiceEngineer_Aadhaar_Number:V'),
(72,6,'vtiger_serviceengineer:emp_block:emp_block:ServiceEngineer_Block:V'),
(72,7,'vtiger_serviceengineer:emp_society:emp_society:ServiceEngineer_Society_Name_:V'),
(72,8,'vtiger_serviceengineer:emp_weakoff:emp_weakoff:ServiceEngineer_Week_Off_:V'),
(72,9,'vtiger_serviceengineer:badge_no:badge_no:ServiceEngineer_User_Number:V'),
(73,0,'vtiger_callassistance:phone:phone:CallAssistance_Mobile_Number:V'),
(73,1,'vtiger_callassistance:service_engineerid:service_engineerid:CallAssistance_Employee_Name:V'),
(73,2,'vtiger_callassistance:call_equip_expirence_in:call_equip_expirence_in:CallAssistance_Expirence_In:V'),
(73,3,'vtiger_callassistance:eq_sr_equip_model:eq_sr_equip_model:CallAssistance_Equipment_Model:V'),
(73,4,'vtiger_callassistance:call_equip_model:call_equip_model:CallAssistance_Equipment_Model:V'),
(75,1,'vtiger_crmentity:smownerid:assigned_user_id:HMREntries_Assigned_To:V'),
(75,2,'vtiger_crmentity:createdtime:createdtime:HMREntries_Created_Time:T'),
(75,3,'vtiger_crmentity:modifiedtime:modifiedtime:HMREntries_Modified_Time:T'),
(75,4,'vtiger_hmrentries:hmr_value:hmr_value:HMREntries_LBL_HMR_VALUE:I'),
(77,0,'vtiger_serviceorders:equipment_id:equipment_id:ServiceOrders_Equipment_Serial_No.:V'),
(77,1,'vtiger_serviceorders:account_id:account_id:ServiceOrders_Account_Name:V'),
(77,2,'vtiger_serviceorders:project_name:project_name:ServiceOrders_Project:V'),
(77,3,'vtiger_serviceorders:sr_ticket_type:sr_ticket_type:ServiceOrders_Notification_Type:V'),
(77,4,'vtiger_serviceorders:ext_app_num_noti:ext_app_num_noti:ServiceOrders_Notification_Number:V'),
(77,5,'vtiger_serviceorders:external_app_num:external_app_num:ServiceOrders_SAP_Reference_Number:V'),
(79,0,'vtiger_activity:status:taskstatus:Calendar_Status:V'),
(79,1,'vtiger_activity:subject:subject:Calendar_Subject:V'),
(79,2,'vtiger_crmentity:createdtime:createdtime:Calendar_Created_Time:DT'),
(87,0,'vtiger_failedparts:ticket_id:ticket_id:FailedParts_Ticket_Id:V'),
(87,1,'vtiger_failedparts:equipment_id:equipment_id:FailedParts_Equipment_Serial_No.:V'),
(87,2,'vtiger_failedparts:account_id:account_id:FailedParts_Account_Name:V'),
(87,3,'vtiger_failedparts:project_name:project_name:FailedParts_Project_Name:V'),
(87,4,'vtiger_crmentity:smownerid:assigned_user_id:FailedParts_Assigned_To:V'),
(88,0,'vtiger_equipmentavailability:equipment_id:equipment_id:EquipmentAvailability_Equipment_Serial_No.:V'),
(88,1,'vtiger_equipmentavailability:commited_avl_m_w:commited_avl_m_w:EquipmentAvailability_Commited_Monthly_Availability_%:N'),
(88,2,'vtiger_equipmentavailability:equi_avail_percent:equi_avail_percent:EquipmentAvailability_LBL_EQUI_AVAIL_PERCENT:V'),
(88,3,'vtiger_equipmentavailability:less_than_commi_ava:less_than_commi_ava:EquipmentAvailability_Less_Than_Committed_Availability:V'),
(88,4,'vtiger_equipmentavailability:mdy:mdy:EquipmentAvailability_mdY:V'),
(90,1,'vtiger_crmentity:smownerid:assigned_user_id:DiscussionBlog_Assigned_To:V'),
(90,2,'vtiger_crmentity:createdtime:createdtime:DiscussionBlog_Created_Time:T'),
(90,3,'vtiger_crmentity:modifiedtime:modifiedtime:DiscussionBlog_Modified_Time:T'),
(90,4,'vtiger_discussionblog:subject:subject:DiscussionBlog_LBL_SUBJECT:V'),
(91,0,'vtiger_servicereports:is_submitted:is_submitted:ServiceReports_Is_Submitted:I'),
(91,1,'vtiger_servicereports:ticket_id:ticket_id:ServiceReports_Ticket_Id:V'),
(91,2,'vtiger_servicereports:account_id:account_id:ServiceReports_Organisation_Name:V'),
(91,3,'vtiger_servicereports:trans_sl_no:trans_sl_no:ServiceReports_Transmission_Sl_No:V'),
(91,4,'vtiger_servicereports:vendor_id:vendor_id:ServiceReports_Vendor_Details:V'),
(91,5,'vtiger_crmentity:smownerid:assigned_user_id:ServiceReports_Assigned_To:V'),
(91,6,'vtiger_servicereports:creditnote_no:creditnote_no:ServiceReports_Report_Number:V'),
(97,0,'vtiger_crmentity:smownerid:assigned_user_id:DeliveryNotes_Assigned_To:V'),
(97,1,'vtiger_crmentity:createdtime:createdtime:DeliveryNotes_Created_Time:T'),
(97,2,'vtiger_crmentity:modifiedtime:modifiedtime:DeliveryNotes_Modified_Time:T'),
(97,3,'vtiger_deliverynotes:deliveynotessapref:deliveynotessapref:DeliveryNotes_LBL_DELIVEYNOTESSAPREF:V'),
(97,4,'vtiger_deliverynotes:account_id:account_id:DeliveryNotes_Ship-to_party:V'),
(97,5,'vtiger_deliverynotes:equipment_id:equipment_id:DeliveryNotes_Equipment_Number:V'),
(98,0,'vtiger_deliverynotes:equipment_id:equipment_id:DeliveryNotes_Equipment_Number:V'),
(98,1,'vtiger_deliverynotes:deliveynotessapref:deliveynotessapref:DeliveryNotes_LBL_DELIVEYNOTESSAPREF:V'),
(98,2,'vtiger_crmentity:smownerid:assigned_user_id:DeliveryNotes_Assigned_To:V'),
(98,3,'vtiger_deliverynotes:manual_equ_ser:manual_equ_ser:DeliveryNotes_Manual_Equipment_Sl.No.:V'),
(98,4,'vtiger_deliverynotes:delivery_date:delivery_date:DeliveryNotes_Delivery_Date:D'),
(98,5,'vtiger_deliverynotes:account_id:account_id:DeliveryNotes_Ship-to_party:V'),
(98,6,'vtiger_deliverynotes:recieving_plant:recieving_plant:DeliveryNotes_Reciving_Plant:V'),
(101,0,'vtiger_recommissioningreports:is_submitted:is_submitted:RecommissioningReports_Is_Submitted:I'),
(101,1,'vtiger_recommissioningreports:sr_ticket_type:sr_ticket_type:RecommissioningReports_Type:V'),
(101,2,'vtiger_recommissioningreports:equipment_id:equipment_id:RecommissioningReports_Equipment_Serial_No.:V'),
(104,0,'vtiger_crmentity:smownerid:assigned_user_id:ModelAggregateConfig_Assigned_To:V'),
(104,1,'vtiger_crmentity:createdtime:createdtime:ModelAggregateConfig_Created_Time:T'),
(104,2,'vtiger_crmentity:modifiedtime:modifiedtime:ModelAggregateConfig_Modified_Time:T'),
(104,3,'vtiger_modelaggregateconfig:eq_sr_equip_model:eq_sr_equip_model:ModelAggregateConfig_Equipment_Model:V'),
(106,0,'vtiger_recommissioningreports:creditnote_name:creditnote_name:RecommissioningReports_Name:V'),
(106,1,'vtiger_crmentity:smownerid:assigned_user_id:RecommissioningReports_Assigned_To:V'),
(106,2,'vtiger_recommissioningreports:ticket_id:ticket_id:RecommissioningReports_Ticket_Id:V'),
(106,3,'vtiger_recommissioningreports:project_name:project_name:RecommissioningReports_Project_Name:V'),
(106,4,'vtiger_recommissioningreportscf:saspd_po_detail:saspd_po_detail:RecommissioningReports_PO_details:V'),
(106,5,'vtiger_recommissioningreports:eng_sl_no:eng_sl_no:RecommissioningReports_Engine_Sl_No:V'),
(106,6,'vtiger_recommissioningreports:trans_sl_no:trans_sl_no:RecommissioningReports_Transmission_Sl_No:V'),
(106,7,'vtiger_recommissioningreports:motor_sl_no:motor_sl_no:RecommissioningReports_Motor_Sl_No:V'),
(106,8,'vtiger_recommissioningreports:hmr:hmr:RecommissioningReports_Meter_reading:I'),
(106,9,'vtiger_recommissioningreports:kilometer_reading:kilometer_reading:RecommissioningReports_Kilometer:I'),
(106,10,'vtiger_recommissioningreports:equipment_id:equipment_id:RecommissioningReports_Equipment_Serial_No.:V'),
(106,11,'vtiger_recommissioningreports:imagename:imagename:RecommissioningReports_Upload_Image:V'),
(106,12,'vtiger_recommissioningreports:manual_equ_ser:manual_equ_ser:RecommissioningReports_manual_equ_ser:V'),
(106,13,'vtiger_recommissioningreports:sad_det_of_subasmb:sad_det_of_subasmb:RecommissioningReports_sad_det_of_subasmb:V'),
(106,14,'vtiger_recommissioningreports:transmission_sl_no:transmission_sl_no:RecommissioningReports_Transmission_Sl.No:V'),
(107,0,'vtiger_recommissioningreports:is_submitted:is_submitted:RecommissioningReports_Is_Submitted:I'),
(107,1,'vtiger_recommissioningreports:creditnote_name:creditnote_name:RecommissioningReports_Name:V'),
(107,2,'vtiger_crmentity:smownerid:assigned_user_id:RecommissioningReports_Assigned_To:V'),
(107,3,'vtiger_recommissioningreports:ticket_id:ticket_id:RecommissioningReports_Ticket_Id:V'),
(107,4,'vtiger_recommissioningreports:project_name:project_name:RecommissioningReports_Project_Name:V'),
(107,5,'vtiger_recommissioningreportscf:saspd_po_detail:saspd_po_detail:RecommissioningReports_PO_details:V'),
(107,6,'vtiger_recommissioningreports:eng_sl_no:eng_sl_no:RecommissioningReports_Engine_Sl_No:V'),
(107,7,'vtiger_recommissioningreports:trans_sl_no:trans_sl_no:RecommissioningReports_Transmission_Sl_No:V'),
(107,8,'vtiger_recommissioningreports:motor_sl_no:motor_sl_no:RecommissioningReports_Motor_Sl_No:V'),
(107,9,'vtiger_recommissioningreports:kilometer_reading:kilometer_reading:RecommissioningReports_Kilometer:I'),
(107,10,'vtiger_recommissioningreports:hmr:hmr:RecommissioningReports_Meter_reading:I'),
(107,11,'vtiger_recommissioningreports:equipment_id:equipment_id:RecommissioningReports_Equipment_Serial_No.:V'),
(107,12,'vtiger_recommissioningreports:imagename:imagename:RecommissioningReports_Upload_Image:V'),
(107,13,'vtiger_recommissioningreports:manual_equ_ser:manual_equ_ser:RecommissioningReports_manual_equ_ser:V'),
(107,14,'vtiger_recommissioningreports:sad_det_of_subasmb:sad_det_of_subasmb:RecommissioningReports_sad_det_of_subasmb:V'),
(107,15,'vtiger_recommissioningreports:transmission_sl_no:transmission_sl_no:RecommissioningReports_Transmission_Sl.No:V'),
(108,0,'vtiger_recommissioningreports:creditnote_name:creditnote_name:RecommissioningReports_Name:V'),
(108,1,'vtiger_crmentity:smownerid:assigned_user_id:RecommissioningReports_Assigned_To:V'),
(108,2,'vtiger_recommissioningreports:ticket_id:ticket_id:RecommissioningReports_Ticket_Id:V'),
(108,3,'vtiger_troubletickets:status:(ticket_id ; (HelpDesk) ticketstatus):HelpDesk_Ticket_Id-Ticket_Status:V'),
(108,4,'vtiger_recommissioningreports:project_name:project_name:RecommissioningReports_Project_Name:V'),
(108,5,'vtiger_recommissioningreports:equipment_id:equipment_id:RecommissioningReports_Equipment_Serial_No.:V'),
(108,6,'vtiger_recommissioningreports:manual_equ_ser:manual_equ_ser:RecommissioningReports_manual_equ_ser:V'),
(108,7,'vtiger_inventoryproductrel:sr_replace_action:sr_replace_action:RecommissioningReports_Replacement_Action:V'),
(109,0,'vtiger_recommissioningreports:creditnote_name:creditnote_name:RecommissioningReports_Name:V'),
(109,1,'vtiger_crmentity:smownerid:assigned_user_id:RecommissioningReports_Assigned_To:V'),
(109,2,'vtiger_recommissioningreports:ticket_id:ticket_id:RecommissioningReports_Ticket_Id:V'),
(109,3,'vtiger_recommissioningreports:project_name:project_name:RecommissioningReports_Project_Name:V'),
(109,4,'vtiger_recommissioningreportscf:saspd_po_detail:saspd_po_detail:RecommissioningReports_PO_details:V'),
(109,5,'vtiger_recommissioningreports:eng_sl_no:eng_sl_no:RecommissioningReports_Engine_Sl_No:V'),
(109,6,'vtiger_recommissioningreports:trans_sl_no:trans_sl_no:RecommissioningReports_Transmission_Sl_No:V'),
(109,7,'vtiger_recommissioningreports:motor_sl_no:motor_sl_no:RecommissioningReports_Motor_Sl_No:V'),
(109,8,'vtiger_recommissioningreports:hmr:hmr:RecommissioningReports_Meter_reading:I'),
(109,9,'vtiger_recommissioningreports:kilometer_reading:kilometer_reading:RecommissioningReports_Kilometer:I'),
(109,10,'vtiger_recommissioningreports:equipment_id:equipment_id:RecommissioningReports_Equipment_Serial_No.:V'),
(109,11,'vtiger_recommissioningreports:imagename:imagename:RecommissioningReports_Upload_Image:V'),
(109,12,'vtiger_recommissioningreports:manual_equ_ser:manual_equ_ser:RecommissioningReports_manual_equ_ser:V'),
(109,13,'vtiger_recommissioningreports:sad_det_of_subasmb:sad_det_of_subasmb:RecommissioningReports_sad_det_of_subasmb:V'),
(109,14,'vtiger_recommissioningreports:transmission_sl_no:transmission_sl_no:RecommissioningReports_Transmission_Sl.No:V'),
(109,15,'vtiger_recommissioningreports:transmission_manufacturer:transmission_manufacturer:RecommissioningReports_Transmission_Manufacturer:V'),
(109,16,'vtiger_recommissioningreports:run_year_cont:run_year_cont:RecommissioningReports_Running_year_of_Contract:I'),
(109,17,'vtiger_recommissioningreports:sr_eq_warranty_terms:sr_eq_warranty_terms:RecommissioningReports_Equipment_Warranty_Terms:V'),
(109,18,'vtiger_recommissioningreports:sr_agg_warranty_terms:sr_agg_warranty_terms:RecommissioningReports_Aggregate_Warranty_Details:V'),
(109,19,'vtiger_recommissioningreports:sr_transmission:sr_transmission:RecommissioningReports_Transmission:V'),
(109,20,'vtiger_recommissioningreports:sr_engine:sr_engine:RecommissioningReports_Engine:V'),
(109,21,'vtiger_recommissioningreports:sr_final_drive:sr_final_drive:RecommissioningReports_Final_Drive:V'),
(109,22,'vtiger_recommissioningreports:sr_rear_axle:sr_rear_axle:RecommissioningReports_Rear_Axle:V'),
(109,23,'vtiger_recommissioningreports:sr_chassis:sr_chassis:RecommissioningReports_Chassis:V'),
(109,24,'vtiger_recommissioningreports:vendor_id:vendor_id:RecommissioningReports_Vendor_Details:V'),
(109,25,'vtiger_recommissioningreports:vis_chk_ext_dam_img:vis_chk_ext_dam_img:RecommissioningReports_Upload_Image:V'),
(109,26,'vtiger_recommissioningreports:vis_hyd_air_dam_img:vis_hyd_air_dam_img:RecommissioningReports_Upload_Image:V'),
(109,27,'vtiger_recommissioningreports:vis_hyd_wrk_los_img:vis_hyd_wrk_los_img:RecommissioningReports_Upload_Image:V'),
(109,28,'vtiger_recommissioningreports:vis_lub_los_img:vis_lub_los_img:RecommissioningReports_Upload_Image:V'),
(109,29,'vtiger_recommissioningreportscf:vis_oil_lev_img:vis_oil_lev_img:RecommissioningReports_Upload_Image:V'),
(110,0,'vtiger_serviceengineer:badge_no:badge_no:ServiceEngineer_User_Number:V'),
(110,1,'vtiger_serviceengineer:service_engineer_name:service_engineer_name:ServiceEngineer_LBL_SERVICE_ENGINEER_NAME:V'),
(110,2,'vtiger_serviceengineer:email:email:ServiceEngineer_Email_Id:E'),
(110,3,'vtiger_serviceengineer:sub_service_manager_role:sub_service_manager_role:ServiceEngineer_Sub_Servie_Manager_Role:V'),
(110,4,'vtiger_serviceengineer:phone:phone:ServiceEngineer_Mobile_Number:V'),
(110,5,'vtiger_serviceengineer:approval_status:approval_status:ServiceEngineer_Approval_Status:V'),
(110,6,'vtiger_serviceengineer:user_password:user_password:ServiceEngineer_Set_Password:P'),
(110,7,'vtiger_serviceengineer:emp_starttime:emp_starttime:ServiceEngineer_Start_Time_:T'),
(110,8,'vtiger_serviceengineer:emp_endtime:emp_endtime:ServiceEngineer_End_Time:T'),
(110,9,'vtiger_serviceengineer:emp_weakoff:emp_weakoff:ServiceEngineer_Week_Off_:V'),
(113,0,'vtiger_crmentity:createdtime:createdtime:WarrantyDetails_Created_Time:T'),
(113,1,'vtiger_warrantydetails:wr_warranty_description:wr_warranty_description:WarrantyDetails_LBL_WR_WARRANTY_DESCRIPTION:V'),
(113,2,'vtiger_warrantydetails:wr_warranty_code:wr_warranty_code:WarrantyDetails_LBL_WR_WARRANTY_CODE:I'),
(113,3,'vtiger_warrantydetails:wr_warranty_in_mon:wr_warranty_in_mon:WarrantyDetails_LBL_WR_WARRANTY_IN_MON:I'),
(113,4,'vtiger_warrantydetails:wr_waranty_hours:wr_waranty_hours:WarrantyDetails_LBL_WR_WARANTY_HOURS:I'),
(114,0,'vtiger_serviceorders:equipment_id:equipment_id:ServiceOrders_Equipment_Serial_No.:V'),
(114,1,'vtiger_serviceorders:account_id:account_id:ServiceOrders_Account_Name:V'),
(114,2,'vtiger_serviceorders:project_name:project_name:ServiceOrders_Project:V'),
(114,3,'vtiger_serviceorders:sr_ticket_type:sr_ticket_type:ServiceOrders_Notification_Type:V'),
(114,4,'vtiger_serviceorders:ext_app_num_noti:ext_app_num_noti:ServiceOrders_Notification_Number:V'),
(114,5,'vtiger_serviceorders:external_app_num:external_app_num:ServiceOrders_SAP_Reference_Number:V'),
(114,6,'vtiger_crmentity:smownerid:assigned_user_id:ServiceOrders_Assigned_To:V'),
(115,0,'vtiger_stocktransferorders:equipment_id:equipment_id:StockTransferOrders_Equipment_Serial_No.:V'),
(115,1,'vtiger_stocktransferorders:account_id:account_id:StockTransferOrders_Account_Name:V'),
(115,2,'vtiger_stocktransferorders:project_name:project_name:StockTransferOrders_Project:V'),
(115,3,'vtiger_stocktransferorders:sr_ticket_type:sr_ticket_type:StockTransferOrders_Notification_Type:V'),
(115,4,'vtiger_stocktransferorders:ext_app_num_so:ext_app_num_so:StockTransferOrders_Service_Order_No.:V'),
(115,5,'vtiger_stocktransferorders:external_app_num:external_app_num:StockTransferOrders_SAP_Reference_Number:V'),
(115,6,'vtiger_stocktransferorders:ext_app_num_noti:ext_app_num_noti:StockTransferOrders_Notification_Number:V'),
(115,7,'vtiger_crmentity:smownerid:assigned_user_id:StockTransferOrders_Assigned_To:V'),
(116,0,'vtiger_deliverynotes:manual_equ_ser:manual_equ_ser:DeliveryNotes_Manual_Equipment_Sl.No.:V'),
(116,1,'vtiger_deliverynotes:deliveynotessapref:deliveynotessapref:DeliveryNotes_LBL_DELIVEYNOTESSAPREF:V'),
(116,2,'vtiger_deliverynotes:equipment_id:equipment_id:DeliveryNotes_Equipment_Number:V'),
(116,3,'vtiger_deliverynotes:account_id:account_id:DeliveryNotes_Ship-to_party:V'),
(116,4,'vtiger_deliverynotes:recieving_plant:recieving_plant:DeliveryNotes_Reciving_Plant:V'),
(117,0,'vtiger_returnsaleorders:account_id:account_id:ReturnSaleOrders_Account_Name:V'),
(117,1,'vtiger_returnsaleorders:equipment_id:equipment_id:ReturnSaleOrders_Equipment_Serial_No.:V'),
(117,2,'vtiger_returnsaleorders:parent_line_itemid:parent_line_itemid:ReturnSaleOrders_Parent_Line_Item_Id:I'),
(117,3,'vtiger_returnsaleorders:ticket_id:ticket_id:ReturnSaleOrders_Ticket_Id:V'),
(117,4,'vtiger_returnsaleorders:ext_app_num_noti:ext_app_num_noti:ReturnSaleOrders_Notification_Number:V'),
(117,5,'vtiger_returnsaleorders:project_name:project_name:ReturnSaleOrders_Project:V'),
(117,6,'vtiger_returnsaleorders:ext_app_num_rso:ext_app_num_rso:ReturnSaleOrders_Return_Sale_Order_Document_No.:V'),
(118,0,'vtiger_returnsaleorders:ext_app_num_rso:ext_app_num_rso:ReturnSaleOrders_Return_Sale_Order_Document_No.:V'),
(118,1,'vtiger_returnsaleorders:ticket_id:ticket_id:ReturnSaleOrders_Ticket_Id:V'),
(118,2,'vtiger_returnsaleorders:equipment_id:equipment_id:ReturnSaleOrders_Equipment_Serial_No.:V'),
(118,3,'vtiger_returnsaleorders:ext_app_num_noti:ext_app_num_noti:ReturnSaleOrders_Notification_Number:V'),
(118,4,'vtiger_returnsaleorders:project_name:project_name:ReturnSaleOrders_Project:V'),
(118,5,'vtiger_crmentity:smownerid:assigned_user_id:ReturnSaleOrders_Assigned_To:V'),
(118,6,'vtiger_inventoryproductrel:div_or_ser_center:div_or_ser_center:ReturnSaleOrders_Division_/_Service_Centre:V'),
(119,0,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(119,1,'vtiger_bankguarantee:bg_initial_vl_en_date:bg_initial_vl_en_date:BankGuarantee_Initial_Validity_End_Date:D'),
(119,2,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(119,3,'vtiger_bankguarantee:bg_availabilty_status:bg_availabilty_status:BankGuarantee_Availabilty_Status:V'),
(119,4,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(119,5,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(119,6,'vtiger_bankguarantee:likely_date_of_col:likely_date_of_col:BankGuarantee_Likely_Date_Of_Collection:D'),
(120,0,'vtiger_stocktransferorders:plant_name:plant_name:StockTransferOrders_Supplying_Plant:V'),
(120,1,'vtiger_stocktransferorders:collective_no:collective_no:StockTransferOrders_Collective_No.:V'),
(120,2,'vtiger_stocktransferorders:your_ref:your_ref:StockTransferOrders_Your_Reference:V'),
(120,3,'vtiger_stocktransferorders:our_ref:our_ref:StockTransferOrders_Our_Reference:V'),
(120,4,'vtiger_crmentity:smownerid:assigned_user_id:StockTransferOrders_Assigned_To:V'),
(120,5,'vtiger_stocktransferorders:external_app_num:external_app_num:StockTransferOrders_SAP_Reference_Number:V'),
(120,6,'vtiger_stocktransferorders:rec_plant_name:rec_plant_name:StockTransferOrders_Receiving_Plant:V'),
(120,7,'vtiger_stocktransferorders:ticket_id:ticket_id:StockTransferOrders_Ticket_Id:V'),
(120,8,'vtiger_stocktransferorders:servicereport_id:servicereport_id:StockTransferOrders_Service_Report_Number:V'),
(121,0,'vtiger_bankguarantee:equipment_model:equipment_model:BankGuarantee_LBL_EQUIPMENT_MODEL:V'),
(121,1,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(121,2,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(121,4,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(121,5,'vtiger_bankguarantee:account_id:account_id:BankGuarantee_Customer_Number:V'),
(121,6,'vtiger_bankguarantee:no_times_exten:no_times_exten:BankGuarantee_No._of_times_of_extension:I'),
(122,0,'vtiger_bankguarantee:equipment_model:equipment_model:BankGuarantee_LBL_EQUIPMENT_MODEL:V'),
(122,1,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(122,2,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(122,4,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(122,5,'vtiger_bankguarantee:account_id:account_id:BankGuarantee_Customer_Number:V'),
(122,6,'vtiger_bankguarantee:no_times_exten:no_times_exten:BankGuarantee_No._of_times_of_extension:I'),
(123,0,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(123,1,'vtiger_bankguarantee:bg_initial_vl_en_date:bg_initial_vl_en_date:BankGuarantee_Initial_Validity_End_Date:D'),
(123,2,'vtiger_bankguarantee:ex_val_end_d:ex_val_end_d:BankGuarantee_Extended_Validity_end__Date:D'),
(123,3,'vtiger_bankguarantee:no_times_exten:no_times_exten:BankGuarantee_No._of_times_of_extension:I'),
(123,4,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(123,5,'vtiger_bankguarantee:bg_availabilty_status:bg_availabilty_status:BankGuarantee_Availabilty_Status:V'),
(123,6,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(123,7,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(123,8,'vtiger_bankguarantee:likely_date_of_col:likely_date_of_col:BankGuarantee_Likely_Date_Of_Collection:D'),
(123,9,'vtiger_crmentity:smownerid:assigned_user_id:BankGuarantee_Assigned_To:V'),
(124,0,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(124,1,'vtiger_bankguarantee:bg_initial_vl_en_date:bg_initial_vl_en_date:BankGuarantee_Initial_Validity_End_Date:D'),
(124,2,'vtiger_bankguarantee:bg_extended_cl_st_date:bg_extended_cl_st_date:BankGuarantee_Extended_claim_Start_Date:D'),
(124,3,'vtiger_bankguarantee:ex_val_end_d:ex_val_end_d:BankGuarantee_Extended_Validity_end__Date:D'),
(124,4,'vtiger_bankguarantee:no_times_exten:no_times_exten:BankGuarantee_No._of_times_of_extension:I'),
(124,5,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(124,6,'vtiger_bankguarantee:bg_availabilty_status:bg_availabilty_status:BankGuarantee_Availabilty_Status:V'),
(124,7,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(124,8,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(124,9,'vtiger_bankguarantee:likely_date_of_col:likely_date_of_col:BankGuarantee_Likely_Date_Of_Collection:D'),
(124,10,'vtiger_crmentity:smownerid:assigned_user_id:BankGuarantee_Assigned_To:V'),
(125,0,'vtiger_bankguarantee:ex_val_end_d:ex_val_end_d:BankGuarantee_Extended_Validity_end__Date:D'),
(125,1,'vtiger_bankguarantee:no_times_exten:no_times_exten:BankGuarantee_No._of_times_of_extension:I'),
(125,2,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(125,3,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(125,4,'vtiger_bankguarantee:bg_availabilty_status:bg_availabilty_status:BankGuarantee_Availabilty_Status:V'),
(125,5,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(125,6,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(125,7,'vtiger_bankguarantee:likely_date_of_col:likely_date_of_col:BankGuarantee_Likely_Date_Of_Collection:D'),
(125,8,'vtiger_crmentity:smownerid:assigned_user_id:BankGuarantee_Assigned_To:V'),
(126,0,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(126,1,'vtiger_bankguarantee:bg_extended_cl_end_date:bg_extended_cl_end_date:BankGuarantee_Extended_claim_End_Date:D'),
(126,2,'vtiger_bankguarantee:no_times_exten:no_times_exten:BankGuarantee_No._of_times_of_extension:I'),
(126,3,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(126,4,'vtiger_bankguarantee:bg_availabilty_status:bg_availabilty_status:BankGuarantee_Availabilty_Status:V'),
(126,5,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(126,6,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(126,7,'vtiger_bankguarantee:likely_date_of_col:likely_date_of_col:BankGuarantee_Likely_Date_Of_Collection:D'),
(126,8,'vtiger_crmentity:smownerid:assigned_user_id:BankGuarantee_Assigned_To:V'),
(127,0,'vtiger_bankguarantee:zbg_no:zbg_no:BankGuarantee_BG_NUmber:V'),
(127,1,'vtiger_bankguarantee:bg_initial_cl_end_date:bg_initial_cl_end_date:BankGuarantee_Intial_Claim_End_Date:D'),
(127,2,'vtiger_bankguarantee:no_times_exten:no_times_exten:BankGuarantee_No._of_times_of_extension:I'),
(127,3,'vtiger_bankguarantee:equipment_id:equipment_id:BankGuarantee_Equipment_Serial_No.:V'),
(127,4,'vtiger_bankguarantee:bg_availabilty_status:bg_availabilty_status:BankGuarantee_Availabilty_Status:V'),
(127,5,'vtiger_bankguarantee:plant_name:plant_name:BankGuarantee_REGION_/_PLANT:V'),
(127,6,'vtiger_bankguarantee:bg_val:bg_val:BankGuarantee_BankGuarantee_Value:NN'),
(127,7,'vtiger_bankguarantee:likely_date_of_col:likely_date_of_col:BankGuarantee_Likely_Date_Of_Collection:D'),
(127,8,'vtiger_crmentity:smownerid:assigned_user_id:BankGuarantee_Assigned_To:V'),
(129,1,'vtiger_crmentity:smownerid:assigned_user_id:ModelAndAggregates_Assigned_To:V'),
(129,2,'vtiger_crmentity:createdtime:createdtime:ModelAndAggregates_Created_Time:T'),
(129,3,'vtiger_modelandaggregates:eq_sr_equip_model:eq_sr_equip_model:ModelAndAggregates_LBL_EQ_SR_EQUIP_MODEL:V'),
(129,4,'vtiger_modelandaggregates:masn_aggrregate:masn_aggrregate:ModelAndAggregates_LBL_MASN_AGGRREGATE:V'),
(132,0,'vtiger_equipmentavailability:equipment_id:equipment_id:EquipmentAvailability_Equipment_Serial_No.:V'),
(132,1,'vtiger_equipmentavailability:equi_avail_percent:equi_avail_percent:EquipmentAvailability_LBL_EQUI_AVAIL_PERCENT:V'),
(132,2,'vtiger_equipmentavailability:commited_avl_m_w:commited_avl_m_w:EquipmentAvailability_Commited_Monthly_Availability_%:N'),
(132,3,'vtiger_equipmentavailability:less_than_commi_ava:less_than_commi_ava:EquipmentAvailability_Less_Than_Committed_Availability:V'),
(132,4,'vtiger_equipmentavailability:mdy:mdy:EquipmentAvailability_mdY:V'),
(133,0,'vtiger_servicereports:is_submitted:is_submitted:ServiceReports_Is_Submitted:I'),
(133,1,'vtiger_servicereports:creditnote_no:creditnote_no:ServiceReports_Report_Number:V'),
(133,2,'vtiger_crmentity:smownerid:assigned_user_id:ServiceReports_Assigned_To:V'),
(133,3,'vtiger_servicereports:account_id:account_id:ServiceReports_Organisation_Name:V'),
(133,4,'vtiger_servicereports:ticket_id:ticket_id:ServiceReports_Ticket_Id:V'),
(133,5,'vtiger_troubletickets:status:(ticket_id ; (HelpDesk) ticketstatus):HelpDesk_Ticket_Id-Ticket_Status:V'),
(133,6,'vtiger_servicereports:equip_id_da_sr:equip_id_da_sr:ServiceReports_equip_id_da_sr:V'),
(133,7,'vtiger_servicereports:equipment_id:equipment_id:ServiceReports_Equipment_Serial_No.:V'),
(134,0,'vtiger_warrantydetails:wr_warranty_description:wr_warranty_description:WarrantyDetails_LBL_WR_WARRANTY_DESCRIPTION:V'),
(134,1,'vtiger_warrantydetails:wr_warranty_code:wr_warranty_code:WarrantyDetails_LBL_WR_WARRANTY_CODE:I'),
(134,2,'vtiger_warrantydetails:wr_warranty_in_mon:wr_warranty_in_mon:WarrantyDetails_LBL_WR_WARRANTY_IN_MON:I'),
(134,3,'vtiger_warrantydetails:wr_waranty_hours:wr_waranty_hours:WarrantyDetails_LBL_WR_WARANTY_HOURS:I'),
(136,0,'vtiger_callassistance:service_engineerid:service_engineerid:CallAssistance_Employee_Name:V'),
(136,1,'vtiger_callassistance:phone:phone:CallAssistance_Mobile_Number:V'),
(136,2,'vtiger_callassistance:eq_sr_equip_model:eq_sr_equip_model:CallAssistance_Equipment_Model:V'),
(136,3,'vtiger_callassistance:call_equip_expirence_in:call_equip_expirence_in:CallAssistance_Expirence_In:V'),
(137,0,'vtiger_notes:title:notes_title:Documents_Title:V'),
(137,1,'vtiger_notes:folderid:folderid:Documents_Folder_Name:V'),
(137,2,'vtiger_crmentity:smownerid:assigned_user_id:Documents_Assigned_To:V'),
(137,3,'vtiger_crmentity:modifiedtime:modifiedtime:Documents_Modified_Time:DT'),
(137,4,'vtiger_notes:filename:filename:Documents_File_Name:V'),
(137,5,'vtiger_notes:note_no:note_no:Documents_Document_No:V'),
(137,6,'vtiger_crmentity:createdtime:createdtime:Documents_Created_Time:DT'),
(137,7,'vtiger_crmentity:modifiedby:modifiedby:Documents_Last_Modified_By:V'),
(137,8,'vtiger_crmentity:source:source:Documents_Source:V'),
(137,9,'vtiger_notes:notecontent:notecontent:Documents_Note:V'),
(137,10,'vtiger_notes:filelocationtype:filelocationtype:Documents_Download_Type:V'),
(137,11,'vtiger_notes:filesize:filesize:Documents_File_Size:I'),
(137,12,'vtiger_notes:filetype:filetype:Documents_File_Type:V'),
(137,13,'vtiger_notes:filedownloadcount:filedownloadcount:Documents_Download_Count:I'),
(137,14,'vtiger_notes:fileversion:fileversion:Documents_Version:V'),
(138,0,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),
(138,1,'vtiger_troubletickets:tic_type:tic_type:HelpDesk_Ticket_Type:V'),
(138,2,'vtiger_troubletickets:tic_pin_location:tic_pin_location:HelpDesk_Pin_Location:V'),
(138,3,'vtiger_troubletickets:tic_category:tic_category:HelpDesk_Category:V'),
(138,4,'vtiger_troubletickets:tic_description:tic_description:HelpDesk_Description:V'),
(138,5,'vtiger_troubletickets:tic_isemergency:tic_isemergency:HelpDesk_Emergency:C'),
(138,6,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),
(138,7,'vtiger_crmentity:smcreatorid:smcreatorid:HelpDesk_Creator:V'),
(138,8,'vtiger_crmentity:createdtime:createdtime:HelpDesk_Created_Time:DT'),
(138,9,'vtiger_troubletickets:tic_rating:tic_rating:HelpDesk_Rating:V'),
(139,0,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),
(139,1,'vtiger_troubletickets:mobile:mobile:HelpDesk_Mobile_Phone:V'),
(139,2,'vtiger_troubletickets:customer_name:customer_name:HelpDesk_Customer_Name:V'),
(139,3,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),
(139,4,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),
(139,5,'vtiger_crmentity:source:source:HelpDesk_Source:V'),
(139,6,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),
(139,7,'vtiger_troubletickets:total:hdnGrandTotal:HelpDesk_Total:N'),
(143,0,'vtiger_troubletickets:tic_type:tic_type:HelpDesk_Ticket_Type:V'),
(143,1,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),
(143,2,'vtiger_crmentity:smcreatorid:smcreatorid:HelpDesk_Creator:V'),
(143,3,'vtiger_troubletickets:tic_pin_location:tic_pin_location:HelpDesk_Pin_Location:V'),
(143,4,'vtiger_troubletickets:tic_description:tic_description:HelpDesk_Description:V'),
(143,5,'vtiger_troubletickets:tic_category:tic_category:HelpDesk_Category:V'),
(143,6,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),
(143,7,'vtiger_crmentity:createdtime:createdtime:HelpDesk_Created_Time:DT'),
(143,8,'vtiger_troubletickets:tic_rating:tic_rating:HelpDesk_Rating:V'),
(145,0,'vtiger_labelmanager:labelmanager_no:labelmanager_no:LabelManager_LabelManager_No:V'),
(145,1,'vtiger_crmentity:createdtime:createdtime:LabelManager_Created_Time:DT'),
(145,2,'vtiger_crmentity:modifiedtime:modifiedtime:LabelManager_Modified_Time:DT'),
(145,3,'vtiger_crmentity:smownerid:assigned_user_id:LabelManager_Assigned_To:V'),
(146,0,'vtiger_companies:company_name:company_name:Companies_Company_Name:V'),
(146,1,'vtiger_companies:company_website:company_website:Companies_Comapany_Website:V'),
(146,2,'vtiger_crmentity:description:description:Companies_Description:V'),
(146,3,'vtiger_crmentity:smownerid:assigned_user_id:Companies_Assigned_To:V'),
(146,4,'vtiger_crmentity:createdtime:createdtime:Companies_Created_Time:DT'),
(146,5,'vtiger_crmentity:modifiedtime:modifiedtime:Companies_Modified_Time:DT'),
(146,6,'vtiger_crmentity:source:source:Companies_Source:V'),
(147,0,'vtiger_onboarding:onboarding_text:onboarding_text:Onboarding_Text:V'),
(147,1,'vtiger_onboarding:onboarding_no:onboarding_no:Onboarding_Onboarding_No:V'),
(147,2,'vtiger_crmentity:modifiedtime:modifiedtime:Onboarding_Modified_Time:DT'),
(147,3,'vtiger_crmentity:createdtime:createdtime:Onboarding_Created_Time:DT'),
(147,4,'vtiger_crmentity:smownerid:assigned_user_id:Onboarding_Assigned_To:V'),
(149,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(149,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(149,2,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(149,3,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(149,4,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(149,5,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(149,6,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(149,7,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(149,8,'vtiger_crmentity:createdtime:createdtime:Visitors_Created_Time:DT'),
(149,9,'vtiger_crmentity:modifiedtime:modifiedtime:Visitors_Modified_Time:DT'),
(150,1,'vtiger_attendance:emp_name:emp_name:Attendance_Name:V'),
(150,2,'vtiger_attendance:atten_signin:atten_signindate:Attendance_Sign_In_Date:D'),
(150,3,'vtiger_attendance:atten_signintime:atten_signintime:Attendance_Sign_in_Time:T'),
(150,4,'vtiger_attendance:atten_breakintime:atten_breakintime:Attendance_Break_In_Time:T'),
(150,5,'vtiger_attendance:atten_breakouttime:atten_breakouttime:Attendance_Break_Out_Time:T'),
(150,6,'vtiger_attendance:atten_signoutdate:atten_signoutdate:Attendance_Sign_Out_Date:D'),
(150,7,'vtiger_attendance:atten_signouttime:atten_signouttime:Attendance_Sign_Out_Time:T'),
(150,8,'vtiger_attendance:atten_no:atten_no:Attendance_Attendance_No:V'),
(150,9,'vtiger_crmentity:smownerid:assigned_user_id:Attendance_Assigned_To:V'),
(151,1,'vtiger_attendance:emp_name:emp_name:Attendance_Name:V'),
(151,2,'vtiger_attendance:atten_signin:atten_signindate:Attendance_Sign_In_Date:D'),
(151,3,'vtiger_attendance:atten_signintime:atten_signintime:Attendance_Sign_in_Time:T'),
(151,4,'vtiger_attendance:atten_breakintime:atten_breakintime:Attendance_Break_In_Time:T'),
(151,5,'vtiger_attendance:atten_breakouttime:atten_breakouttime:Attendance_Break_Out_Time:T'),
(151,6,'vtiger_attendance:atten_signoutdate:atten_signoutdate:Attendance_Sign_Out_Date:D'),
(151,7,'vtiger_attendance:atten_signouttime:atten_signouttime:Attendance_Sign_Out_Time:T'),
(151,8,'vtiger_attendance:atten_no:atten_no:Attendance_Attendance_No:V'),
(151,9,'vtiger_crmentity:smownerid:assigned_user_id:Attendance_Assigned_To:V'),
(152,0,'vtiger_guard:guard_name:guard_name:Guard_Guard_Name:V'),
(152,1,'vtiger_crmentity:smownerid:assigned_user_id:Guard_Assigned_To:V'),
(152,2,'vtiger_guard:guard_mobile:guard_mobile:Guard_Phone_No:V'),
(152,3,'vtiger_guard:guard_img:guard_img:Guard_Image:D'),
(153,0,'vtiger_owner:owntenant_name:owntenant_name:Owner_Name:V'),
(153,1,'vtiger_owner:owntenant_mobile:owntenant_mobile:Owner_Mobile_Number:V'),
(153,2,'vtiger_owner:owntenant_email:owntenant_email:Owner_Email:V'),
(153,3,'vtiger_socblocks:blockname:(related_block ; (SocBlocks) blockname):SocBlocks_Block-Block_Name:V'),
(154,0,'vtiger_notice:notice_type:notice_type:Notice_Notice_Type:V'),
(154,1,'vtiger_notice:notice_sub:notice_sub:Notice_Subject:V'),
(154,2,'vtiger_notice:notice_description:notice_description:Notice_Notice_Description:V'),
(154,3,'vtiger_notice:notice_share:notice_share:Notice_Choose_Whom_To_Share_With:V'),
(154,4,'vtiger_notice:notice_produrl:notice_produrl:Notice_Product_URL:V'),
(154,5,'vtiger_notice:notice_advertisement:notice_advertisement:Notice_Image_URL:V'),
(154,6,'vtiger_notice:approval_status:approval_status:Notice_Approval_Status:V'),
(154,7,'vtiger_crmentity:smownerid:assigned_user_id:Notice_Assigned_To:V'),
(154,8,'vtiger_crmentity:createdtime:createdtime:Notice_Created_Time:D'),
(155,0,'vtiger_watertank:wtsuplier_name:wtsuplier_name:WaterTank_Name_of_The_Supplier:V'),
(155,1,'vtiger_watertank:wtcapacity:wtcapacity:WaterTank_Water_Tank_Capacity:V'),
(155,2,'vtiger_watertank:wtcontact_number:wtcontact_number:WaterTank_Contact_Number:V'),
(155,3,'vtiger_watertank:wtvehicle_number:wtvehicle_number:WaterTank_Vehicle_Number:V'),
(155,4,'vtiger_watertank:wtchoose_date:wtchoose_date:WaterTank_Choose_Date:D'),
(155,5,'vtiger_watertank:wtend_date:wtend_date:WaterTank_Choose_end_Date:D'),
(155,6,'vtiger_crmentity:createdtime:createdtime:WaterTank_Created_Time:D'),
(155,7,'vtiger_watertank:wt_statusinfo:wt_statusinfo:WaterTank_Status:V'),
(155,8,'vtiger_watertank:wt_approval_status:wt_approval_status:WaterTank_Approval_Status:V'),
(169,1,'vtiger_societyregistrationform:societyname:societyname:SocietyRegistrationForm_Society_Name:V'),
(169,2,'vtiger_societyregistrationform:username:username:SocietyRegistrationForm_User_Name:V'),
(169,3,'vtiger_societyregistrationform:designation:designation:SocietyRegistrationForm_Designation:V'),
(169,4,'vtiger_societyregistrationform:contactnumber:contactnumber:SocietyRegistrationForm_Contact_Number:V'),
(169,5,'vtiger_societyregistrationform:pincode:pincode:SocietyRegistrationForm_Pincode:V'),
(169,6,'vtiger_societyregistrationform:city:city:SocietyRegistrationForm_City:V'),
(169,7,'vtiger_societyregistrationform:district:district:SocietyRegistrationForm_District:V'),
(169,8,'vtiger_societyregistrationform:state:state:SocietyRegistrationForm_State:V'),
(170,0,'vtiger_resident:resident_name:resident_name:Resident_Name:V'),
(170,1,'vtiger_resident:mobile:mobile:Resident_Mobile_Number:V'),
(170,2,'vtiger_resident:select_block:select_block:Resident_Select_Block:V'),
(170,3,'vtiger_resident:society:society:Resident_Select_Society_No:V'),
(170,4,'vtiger_resident:type_resident:type_resident:Resident_Type_Of_Resident:V'),
(170,5,'vtiger_resident:resident_no:resident_no:Resident_Resident_No:V'),
(172,0,'vtiger_guarddir:guarddir_name:guarddir_name:GuardDir_Name:V'),
(172,1,'vtiger_guarddir:guarddir_mobile:guarddir_mobile:GuardDir_Mobile_Number:V'),
(172,2,'vtiger_guarddir:guarddir_img:guarddir_img:GuardDir_Image:V'),
(172,3,'vtiger_guarddir:guard_no:guard_no:GuardDir_Guard_No:V'),
(173,0,'vtiger_emergencydir:emergencydir_name:emergencydir_name:EmergencyDir_Name_Of_Emergency:V'),
(173,1,'vtiger_emergencydir:emergencydir_mobile:emergencydir_mobile:EmergencyDir_Mobile_Number:V'),
(173,2,'vtiger_emergencydir:emergency_no:emergency_no:EmergencyDir_Emergency_No:V'),
(176,0,'vtiger_domestichelp:domhelp_name:domhelp_name:DomesticHelp_Name:V'),
(176,1,'vtiger_domestichelp:domhelp_pic:domhelp_pic:DomesticHelp_Take_Photo_Of_Person:V'),
(176,2,'vtiger_domestichelp:domhelp_type:domhelp_type:DomesticHelp_Type_Of_Domestic:V'),
(176,3,'vtiger_domestichelp:domhelp_block:domhelp_block:DomesticHelp_Block:V'),
(176,4,'vtiger_domestichelp:domhelp_society:domhelp_society:DomesticHelp_Society_No:V'),
(176,5,'vtiger_domestichelp:domhelp_number:domhelp_number:DomesticHelp_Mobile_Number:V'),
(176,6,'vtiger_domestichelp:domhelp_approval_status:domhelp_approval_status:DomesticHelp_Approval_Status:V'),
(176,7,'vtiger_domestichelp:addtoflat:addtoflat:DomesticHelp_Add_To_My_Flat:C'),
(179,0,'vtiger_inout:inout_day:inout_day:Inout_Day:V'),
(179,1,'vtiger_inout:inout_date:inout_date:Inout_Date:D'),
(179,2,'vtiger_inout:inout_attendance_status:inout_attendance_status:Inout_Attendance_Status:V'),
(179,3,'vtiger_inout:inout_allow_in_time:inout_allow_in_time:Inout_Allow_In_Time:T'),
(179,4,'vtiger_inout:inout_allow_out_time:inout_allow_out_time:Inout_Allow_Out_Time:T'),
(179,5,'vtiger_inout:inout_duration:inout_duration:Inout_Duration:V'),
(180,1,'vtiger_crmentity:smownerid:assigned_user_id:SocBlocks_Assigned_To:V'),
(180,2,'vtiger_socblocks:blockname:blockname:SocBlocks_LBL_BLOCKNAME:V'),
(181,0,'vtiger_plat:platname:platname:Plat_LBL_PLATNAME:V'),
(181,1,'vtiger_crmentity:modifiedtime:modifiedtime:Plat_Modified_Time:T'),
(181,2,'vtiger_account:accountname:(related_society ; (Accounts) accountname):Accounts_Society-Soceity_Name:V'),
(182,0,'vtiger_guestapproval:guest_mobile:guest_mobile:GuestApproval_Mobile_Number:V'),
(182,1,'vtiger_guestapproval:guest_name:guest_name:GuestApproval_Visitor_Name:V'),
(182,2,'vtiger_guestapproval:guest_vehicle_no:guest_vehicle_no:GuestApproval_Vehicle_Number:V'),
(182,3,'vtiger_guestapproval:guest_date:guest_date:GuestApproval_Date:D'),
(182,4,'vtiger_guestapproval:guest_time:guest_time:GuestApproval_Time:T'),
(182,5,'vtiger_guestapproval:block:block:GuestApproval_Block:V'),
(182,6,'vtiger_guestapproval:society_no:society_no:GuestApproval_Society_No:V'),
(182,7,'vtiger_guestapproval:guest_take_photo:guest_take_photo:GuestApproval_Take_Photo:V'),
(182,8,'vtiger_guestapproval:guest_no:guest_no:GuestApproval_Get_Approval_No:V'),
(192,0,'vtiger_gatepass:gatepass_havegiven:gatepass_havegiven:GatePass_I_have_given_to_:V'),
(192,1,'vtiger_gatepass:gatepass_description:gatepass_description:GatePass_Description:V'),
(192,2,'vtiger_gatepass:gatepass_attachment:gatepass_attachment:GatePass_Upload_Attachment:V'),
(192,3,'vtiger_crmentity:smownerid:assigned_user_id:GatePass_Assigned_To:V'),
(192,4,'vtiger_gatepass:gatepass_isverify:gatepass_isverify:GatePass_Is_Verify:C'),
(192,5,'vtiger_gatepass:domestichelpid:domestichelpid:GatePass_Domestic_Helper_record:V'),
(192,6,'vtiger_crmentity:createdtime:createdtime:GatePass_Created_Time:D'),
(193,0,'vtiger_advnotice:advnotice_sub:advnotice_sub:ADVNotice_Subject:V'),
(193,1,'vtiger_crmentity:createdtime:createdtime:ADVNotice_Created_Time:D'),
(193,2,'vtiger_advnotice:posterapproval_status:posterapproval_status:ADVNotice_Approval_Status:V'),
(193,3,'vtiger_advnotice:adv_description:adv_description:ADVNotice_Description:V'),
(193,4,'vtiger_advnotice:advnotice_imageurl:advnotice_imageurl:ADVNotice_Upload_Image:V'),
(193,5,'vtiger_advnotice:advnotice_type:advnotice_type:ADVNotice_Notice_Type:V'),
(194,0,'vtiger_deliveryapproval:deliver_name:deliver_name:DeliveryApproval_Visitor_Name:V'),
(194,1,'vtiger_deliveryapproval:deliver_vehicleno:deliver_vehicleno:DeliveryApproval_Vehicle_Number:V'),
(194,2,'vtiger_deliveryapproval:deliver_mobile:deliver_mobile:DeliveryApproval_Mobile_Number:V'),
(194,3,'vtiger_deliveryapproval:deliver_date:deliver_date:DeliveryApproval_Date:D'),
(194,4,'vtiger_deliveryapproval:deliver_time:deliver_time:DeliveryApproval_Time:T'),
(194,5,'vtiger_deliveryapproval:approval_status:approval_status:DeliveryApproval_Approval_Status:V'),
(194,6,'vtiger_deliveryapproval:deliver_company:deliver_company:DeliveryApproval_Delivery_Company:V'),
(194,7,'vtiger_deliveryapproval:deliver_pic:deliver_pic:DeliveryApproval_Take_Photo_Of_Person:V'),
(196,0,'vtiger_customercare:customercare_name:CustomerCare_name:CustomerCare_Name_:V'),
(196,1,'vtiger_customercare:customercare_mobile:CustomerCare_mobile:CustomerCare_Phone_Number:V'),
(197,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(197,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(197,2,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(197,3,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(197,4,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(197,5,'vtiger_crmentity:createdtime:createdtime:Visitors_Created_Time:DT'),
(197,6,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(197,7,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(197,8,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(198,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(198,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(198,2,'vtiger_crmentity:modifiedtime:modifiedtime:Visitors_Modified_Time:DT'),
(198,3,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(198,4,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(198,5,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(198,6,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(198,7,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(199,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(199,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(199,2,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(199,3,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(199,4,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(199,5,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(199,6,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(199,7,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(200,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(200,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(200,2,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(200,3,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(200,4,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(200,5,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(200,6,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(200,7,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(201,0,'vtiger_serviceengineer:service_engineer_name:service_engineer_name:ServiceEngineer_LBL_SERVICE_ENGINEER_NAME:V'),
(201,1,'vtiger_serviceengineer:phone:phone:ServiceEngineer_Mobile_Number:V'),
(201,2,'vtiger_serviceengineer:email:email:ServiceEngineer_Email_Id:E'),
(201,3,'vtiger_serviceengineer:aadhar_no:aadhar_no:ServiceEngineer_Aadhaar_Number:V'),
(201,4,'vtiger_serviceengineer:emp_block:emp_block:ServiceEngineer_Block:V'),
(201,5,'vtiger_serviceengineer:emp_society:emp_society:ServiceEngineer_Society_Name_:V'),
(201,6,'vtiger_serviceengineer:badge_no:badge_no:ServiceEngineer_User_Number:V'),
(201,7,'vtiger_crmentity:smownerid:assigned_user_id:ServiceEngineer_Assigned_To:V'),
(201,8,'vtiger_serviceengineer:approval_status:approval_status:ServiceEngineer_Approval_Status:V'),
(201,9,'vtiger_serviceengineer:sub_service_manager_role:sub_service_manager_role:ServiceEngineer_Sub_Servie_Manager_Role:V'),
(202,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(202,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(202,2,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(202,3,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(202,4,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(202,5,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(202,6,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(202,7,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(205,0,'vtiger_domestichelp:domhelp_type:domhelp_type:DomesticHelp_Type_Of_Domestic:V'),
(205,1,'vtiger_domestichelp:domhelp_name:domhelp_name:DomesticHelp_Name:V'),
(205,2,'vtiger_domestichelp:domhelp_number:domhelp_number:DomesticHelp_Mobile_Number:V'),
(205,3,'vtiger_domestichelp:domhelp_society:domhelp_society:DomesticHelp_Society_No:V'),
(205,4,'vtiger_domestichelp:domhelp_timeslot:domhelp_timeslot:DomesticHelp_Time_Slot:V'),
(205,5,'vtiger_crmentity:smownerid:assigned_user_id:DomesticHelp_Assigned_To:V'),
(205,6,'vtiger_domestichelp:domhelp_pic:domhelp_pic:DomesticHelp_Take_Photo_Of_Person:V'),
(205,7,'vtiger_domestichelp:addtoflat:addtoflat:DomesticHelp_Add_To_My_Flat:C'),
(206,0,'vtiger_domestichelp:domhelp_type:domhelp_type:DomesticHelp_Type_Of_Domestic:V'),
(206,1,'vtiger_domestichelp:domhelp_name:domhelp_name:DomesticHelp_Name:V'),
(206,2,'vtiger_domestichelp:domhelp_number:domhelp_number:DomesticHelp_Mobile_Number:V'),
(206,3,'vtiger_domestichelp:domhelp_society:domhelp_society:DomesticHelp_Society_No:V'),
(206,4,'vtiger_domestichelp:domhelp_timeslot:domhelp_timeslot:DomesticHelp_Time_Slot:V'),
(206,5,'vtiger_crmentity:smownerid:assigned_user_id:DomesticHelp_Assigned_To:V'),
(206,6,'vtiger_domestichelp:domhelp_pic:domhelp_pic:DomesticHelp_Take_Photo_Of_Person:V'),
(206,7,'vtiger_domestichelp:addtoflat:addtoflat:DomesticHelp_Add_To_My_Flat:C'),
(207,0,'vtiger_domestichelp:domhelp_type:domhelp_type:DomesticHelp_Type_Of_Domestic:V'),
(207,1,'vtiger_domestichelp:domhelp_name:domhelp_name:DomesticHelp_Name:V'),
(207,2,'vtiger_domestichelp:domhelp_number:domhelp_number:DomesticHelp_Mobile_Number:V'),
(207,3,'vtiger_domestichelp:domhelp_society:domhelp_society:DomesticHelp_Society_No:V'),
(207,4,'vtiger_domestichelp:domhelp_timeslot:domhelp_timeslot:DomesticHelp_Time_Slot:V'),
(207,5,'vtiger_domestichelp:domhelp_block:domhelp_block:DomesticHelp_Block:V'),
(207,6,'vtiger_crmentity:smownerid:assigned_user_id:DomesticHelp_Assigned_To:V'),
(207,7,'vtiger_domestichelp:domhelp_rating:domhelp_rating:DomesticHelp_Rating:V'),
(207,8,'vtiger_domestichelp:domhelp_pic:domhelp_pic:DomesticHelp_Take_Photo_Of_Person:V'),
(207,9,'vtiger_domestichelp:domhelp_approval_status:domhelp_approval_status:DomesticHelp_Approval_Status:V'),
(207,10,'vtiger_domestichelp:addtoflat:addtoflat:DomesticHelp_Add_To_My_Flat:C'),
(208,0,'vtiger_paymentdetail:payfor_month:payfor_month:PaymentDetail_Month:V'),
(208,1,'vtiger_paymentdetail:payee_name:payee_name:PaymentDetail_Owner/Tenant_Name:V'),
(208,2,'vtiger_paymentdetail:related_soceity:related_soceity:PaymentDetail_Soceity_Name:V'),
(208,3,'vtiger_paymentdetail:related_block:related_block:PaymentDetail_Block:V'),
(208,4,'vtiger_paymentdetail:related_plat:related_plat:PaymentDetail_Soceity_Number:V'),
(208,5,'vtiger_paymentdetail:payment_amount:payment_amount:PaymentDetail_Amount:N'),
(208,6,'vtiger_paymentdetail:payment_status:payment_status:PaymentDetail_Status:V'),
(208,7,'vtiger_paymentdetail:transactionid:transactionid:PaymentDetail_Transaction_Id:V'),
(208,8,'vtiger_crmentity:createdtime:createdtime:PaymentDetail_Created_Time:D'),
(208,9,'vtiger_crmentity:modifiedtime:modifiedtime:PaymentDetail_Modified_Time:D'),
(208,10,'vtiger_paymentdetail:pay_uploadpic:pay_uploadpic:PaymentDetail_Upload_Document:V'),
(209,0,'vtiger_qrcode:qrcode_no:qrcode_no:QRCode_Qrcode_No:V'),
(209,1,'vtiger_qrcode:qrcode_pic:qrcode_pic:QRCode_Upload_QR:V'),
(209,2,'vtiger_qrcode:accountid:accountid:QRCode_Soceity:V'),
(209,3,'vtiger_crmentity:smownerid:assigned_user_id:QRCode_Assigned_To:V'),
(209,4,'vtiger_crmentity:createdtime:createdtime:QRCode_Created_Time:D'),
(210,0,'vtiger_paymentdetail:payfor_month:payfor_month:PaymentDetail_Month:V'),
(210,1,'vtiger_paymentdetail:payee_name:payee_name:PaymentDetail_Owner/Tenant_Name:V'),
(210,2,'vtiger_paymentdetail:payment_amount:payment_amount:PaymentDetail_Amount:N'),
(210,3,'vtiger_paymentdetail:pay_uploadpic:pay_uploadpic:PaymentDetail_Upload_Document:V'),
(210,4,'vtiger_paymentdetail:related_soceity:related_soceity:PaymentDetail_Soceity_Name:V'),
(210,5,'vtiger_paymentdetail:related_plat:related_plat:PaymentDetail_Soceity_Number:V'),
(210,6,'vtiger_paymentdetail:related_block:related_block:PaymentDetail_Block:V'),
(210,7,'vtiger_paymentdetail:payment_status:payment_status:PaymentDetail_Status:V'),
(210,8,'vtiger_crmentity:smownerid:assigned_user_id:PaymentDetail_Assigned_To:V'),
(210,9,'vtiger_crmentity:createdtime:createdtime:PaymentDetail_Created_Time:D'),
(211,0,'vtiger_paymentdetail:payfor_month:payfor_month:PaymentDetail_Month:V'),
(211,1,'vtiger_paymentdetail:paymentdetail_no:paymentdetail_no:PaymentDetail_Payment_Detail_No:V'),
(211,2,'vtiger_paymentdetail:payee_name:payee_name:PaymentDetail_Owner/Tenant_Name:V'),
(211,3,'vtiger_paymentdetail:payment_amount:payment_amount:PaymentDetail_Amount:N'),
(211,4,'vtiger_paymentdetail:related_soceity:related_soceity:PaymentDetail_Soceity_Name:V'),
(211,5,'vtiger_paymentdetail:related_block:related_block:PaymentDetail_Block:V'),
(211,6,'vtiger_paymentdetail:pay_uploadpic:pay_uploadpic:PaymentDetail_Upload_Document:V'),
(211,7,'vtiger_paymentdetail:related_plat:related_plat:PaymentDetail_Soceity_Number:V'),
(211,8,'vtiger_paymentdetail:payment_status:payment_status:PaymentDetail_Status:V'),
(211,9,'vtiger_crmentity:smownerid:assigned_user_id:PaymentDetail_Assigned_To:V'),
(211,10,'vtiger_crmentity:modifiedtime:modifiedtime:PaymentDetail_Modified_Time:D'),
(211,11,'vtiger_paymentdetail:transactionid:transactionid:PaymentDetail_Transaction_Id:V'),
(212,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(212,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(212,2,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(212,3,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(212,4,'vtiger_crmentity:createdtime:createdtime:Visitors_Created_Time:DT'),
(212,5,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(212,6,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(212,7,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(212,8,'vtiger_crmentity:modifiedtime:modifiedtime:Visitors_Modified_Time:DT'),
(212,9,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(213,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(213,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(213,2,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(213,3,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(213,4,'vtiger_crmentity:createdtime:createdtime:Visitors_Created_Time:DT'),
(213,5,'vtiger_crmentity:modifiedtime:modifiedtime:Visitors_Modified_Time:DT'),
(213,6,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(213,7,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(213,8,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(213,9,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(216,0,'vtiger_poll:poll_type:poll_type:Poll_Poll_Type:V'),
(216,1,'vtiger_poll:poll_topic:poll_topic:Poll_Poll_Topic:V'),
(216,2,'vtiger_poll:poll_status:poll_status:Poll_Poll_Status:V'),
(216,3,'vtiger_poll:poll_description:poll_description:Poll_Description:V'),
(216,4,'vtiger_poll:pollstart_date:pollstart_date:Poll_Choose_Start_Date:D'),
(216,5,'vtiger_poll:pollend_date:pollend_date:Poll_Choose_end_Date:D'),
(216,6,'vtiger_poll:poll_no:poll_no:Poll_Poll_Id:V'),
(216,7,'vtiger_poll:like_count:like_count:Poll_Like_Count:I'),
(218,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(218,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(218,2,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(218,3,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(218,4,'vtiger_crmentity:createdtime:createdtime:Visitors_Created_Time:DT'),
(218,5,'vtiger_crmentity:modifiedtime:modifiedtime:Visitors_Modified_Time:DT'),
(218,6,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(218,7,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(218,8,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(218,9,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(219,0,'vtiger_visitors:visitor_name:visitor_name:Visitors_Name:V'),
(219,1,'vtiger_visitors:visitor_mobile:visitor_mobile:Visitors_Mobile_No:V'),
(219,2,'vtiger_visitors:todays_date:todays_date:Visitors_Todays_Date:D'),
(219,3,'vtiger_visitors:visitor_no:visitor_no:Visitors_visitor_No:V'),
(219,4,'vtiger_crmentity:createdtime:createdtime:Visitors_Created_Time:DT'),
(219,5,'vtiger_crmentity:modifiedtime:modifiedtime:Visitors_Modified_Time:DT'),
(219,6,'vtiger_crmentity:smownerid:assigned_user_id:Visitors_Assigned_To:V'),
(219,7,'vtiger_visitors:visitor_startingtime:visitor_startingtime:Visitors_Starting_Time:T'),
(219,8,'vtiger_visitors:visitor_valid:visitor_valid:Visitors_Valid_For:V'),
(219,9,'vtiger_visitors:visitor_in:visitor_in:Visitors_Allow_In:C'),
(220,0,'vtiger_buyandsell:buysell_no:buysell_no:BuyAndSell_Buy_And_Sell_No:V'),
(220,1,'vtiger_buyandsell:buysell_category:buysell_category:BuyAndSell_List_Category:V'),
(220,2,'vtiger_buyandsell:buysell_title:buysell_title:BuyAndSell_Title:V'),
(220,3,'vtiger_buyandsell:buysell_specification:buysell_specification:BuyAndSell_Specification:V'),
(220,4,'vtiger_buyandsell:buysell_year:buysell_year:BuyAndSell_Purchase_Year:D'),
(220,5,'vtiger_buyandsell:buysell_purchase_price:buysell_purchase_price:BuyAndSell_Purchase_Price:v'),
(220,6,'vtiger_buyandsell:buysell_selltype:buysell_selltype:BuyAndSell_Type_of_Sell:V'),
(220,7,'vtiger_buyandsell:buysell_cost:buysell_cost:BuyAndSell_Selling_Price:N'),
(220,8,'vtiger_crmentity:smownerid:assigned_user_id:BuyAndSell_Assigned_To:V'),
(220,9,'vtiger_buyandsell:buysell_issold:buysell_issold:BuyAndSell_Mark_As_Sold:C'),
(231,0,'vtiger_amenities:amenities_title:amenities_title:Amenities_Amenities_Title:V'),
(231,1,'vtiger_amenities:amenetites_available_days:amenetites_available_days:Amenities_Amenities_Available_Days:V'),
(231,2,'vtiger_amenities:amenities_booking:amenities_booking:Amenities_Booking_Amount:NN'),
(231,3,'vtiger_amenities:amenetites_booking_status:amenetites_booking_status:Amenities_Booking_Status:V'),
(231,4,'vtiger_amenities:amenities_startingtime:amenities_startingtime:Amenities_Availability_of_Amenities_Start_Time:T'),
(231,5,'vtiger_amenities:amenities_endingtime:amenities_endingtime:Amenities_Availability_of_Amenities_End_Time:T'),
(239,0,'vtiger_announcements:annos_file:annos_file:Announcements_Upload_Image_and_Video:V'),
(239,1,'vtiger_announcements:annos_active:annos_active:Announcements_Announcement_Active:V'),
(239,2,'vtiger_announcements:announcements_no:announcements_no:Announcements_Announcements_No:V'),
(239,3,'vtiger_crmentity:createdtime:createdtime:Announcements_Created_Time:DT'),
(239,4,'vtiger_crmentity:modifiedtime:modifiedtime:Announcements_Modified_Time:DT'),
(239,5,'vtiger_crmentity:smownerid:assigned_user_id:Announcements_Assigned_To:V'),
(239,6,'vtiger_announcements:annos_youtubeurl:annos_youtubeurl:Announcements_You_Tube_URL:V'),
(239,7,'vtiger_announcements:announce_urllink:announce_urllink:Announcements_Advertisement_URL:V'),
(240,0,'vtiger_announcements:annos_file:annos_file:Announcements_Upload_Image_and_Video:V'),
(240,1,'vtiger_announcements:annos_active:annos_active:Announcements_Announcement_Active:V'),
(240,2,'vtiger_announcements:announcements_no:announcements_no:Announcements_Announcements_No:V'),
(240,3,'vtiger_crmentity:createdtime:createdtime:Announcements_Created_Time:DT'),
(240,4,'vtiger_crmentity:modifiedtime:modifiedtime:Announcements_Modified_Time:DT'),
(240,5,'vtiger_crmentity:smownerid:assigned_user_id:Announcements_Assigned_To:V'),
(240,6,'vtiger_crmentity:source:source:Announcements_Source:V'),
(240,7,'vtiger_announcements:annos_youtubeurl:annos_youtubeurl:Announcements_You_Tube_URL:V'),
(240,8,'vtiger_announcements:annostart_date:annostart_date:Announcements_Choose_Start_Date:D'),
(240,9,'vtiger_announcements:annosend_date:annosend_date:Announcements_Choose_End_Date:D'),
(241,0,'vtiger_booking:booking_no:booking_no:Booking_Booking_No:V'),
(241,1,'vtiger_booking:booking_date:booking_date:Booking_Booking_Date:D'),
(241,2,'vtiger_booking:booking_option:booking_option:Booking_Booking_Option:V'),
(241,3,'vtiger_booking:booking_timeslot:booking_timeslot:Booking_Booking_TimeSlot:V'),
(241,4,'vtiger_booking:booking_status:booking_status:Booking_Booking_Status:V'),
(241,5,'vtiger_booking:booking_paymentpic:booking_paymentpic:Booking_Payment_Upload_Image:V'),
(241,6,'vtiger_crmentity:smownerid:assigned_user_id:Booking_Assigned_To:V'),
(241,7,'vtiger_crmentity:modifiedtime:modifiedtime:Booking_Modified_Time:D'),
(241,8,'vtiger_crmentity:createdtime:createdtime:Booking_Created_Time:D'),
(241,9,'vtiger_booking:amenitiesid:amenitiesid:Booking_Amenities_Record:V'),
(241,10,'vtiger_booking:booking_comments:booking_comments:Booking_Comments:V'),
(241,11,'vtiger_booking:booking_approval_status:booking_approval_status:Booking_Approval_Status:V'),
(243,0,'vtiger_infraemployee:infraemp_no:infraemp_no:InfraEmployee_Infra_Emp_No:V'),
(243,1,'vtiger_infraemployee:infraemp_approval_status:infraemp_approval_status:InfraEmployee_Approval_Status:V'),
(243,2,'vtiger_infraemployee:infraemp_name:infraemp_name:InfraEmployee_Name:V'),
(243,3,'vtiger_infraemployee:infraemp_email:infraemp_email:InfraEmployee_Email:V'),
(243,4,'vtiger_infraemployee:infraemp_upload_id_proof:infraemp_upload_id_proof:InfraEmployee_Upload_Id_Proof:V'),
(243,5,'vtiger_infraemployee:infraemp_mobile:infraemp_mobile:InfraEmployee_Mobile_Number:V'),
(243,6,'vtiger_infraemployee:badge_no:badge_no:InfraEmployee_Employee_Id:V'),
(243,7,'vtiger_infraemployee:infraemp_starttime:infraemp_starttime:InfraEmployee_Start_Time_:T'),
(243,8,'vtiger_infraemployee:infraemp_endtime:infraemp_endtime:InfraEmployee_End_Time:T'),
(243,9,'vtiger_infraemployee:infraemp_week_off:infraemp_week_off:InfraEmployee_Week_Off:V'),
(243,10,'vtiger_infraemployee:infraemp_password:infraemp_password:InfraEmployee_Password:P'),
(243,11,'vtiger_crmentity:smownerid:assigned_user_id:InfraEmployee_Assigned_To:V'),
(243,12,'vtiger_infraemployee:infraemp_upload_profile:infraemp_upload_profile:InfraEmployee_Take_Photo_of_Person:V'),
(243,13,'vtiger_crmentity:createdtime:createdtime:InfraEmployee_Created_Time:D'),
(243,14,'vtiger_infraemployee:infraemp_pincode:infraemp_pincode:InfraEmployee_Pincode:V'),
(243,15,'vtiger_infraemployee:infraemp_district:infraemp_district:InfraEmployee_District:V'),
(243,16,'vtiger_infraemployee:infraemp_state:infraemp_state:InfraEmployee_State:V'),
(243,17,'vtiger_infraemployee:infraemp_city:infraemp_city:InfraEmployee_City:V'),
(243,18,'vtiger_infraemployee:infraemp_id_proof:infraemp_id_proof:InfraEmployee_Id_Proof:V'),
(243,19,'vtiger_crmentity:modifiedtime:modifiedtime:InfraEmployee_Modified_Time:D');

--
-- Table structure for table `vtiger_cvstdfilter`
--

CREATE TABLE `vtiger_cvstdfilter` (
  `cvid` int(19) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  `stdfilter` varchar(250) DEFAULT '',
  `startdate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  KEY `cvstdfilter_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvstdfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_cvstdfilter`
--

INSERT INTO `vtiger_cvstdfilter` VALUES
(3,'vtiger_crmentity:modifiedtime:modifiedtime:Leads_Modified_Time','thismonth','2005-06-01','2005-06-30'),
(6,'vtiger_crmentity:createdtime:createdtime:Accounts_Created_Time','thisweek','2005-06-19','2005-06-25');

--
-- Table structure for table `vtiger_damage`
--

CREATE TABLE `vtiger_damage` (
  `damageid` int(11) NOT NULL AUTO_INCREMENT,
  `damage` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`damageid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_damage`
--

INSERT INTO `vtiger_damage` VALUES
(1,'UJ ASSEMBLY',0,1,NULL);

--
-- Table structure for table `vtiger_damage_seq`
--

CREATE TABLE `vtiger_damage_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_damage_seq`
--

INSERT INTO `vtiger_damage_seq` VALUES
(1);

--
-- Table structure for table `vtiger_dashboard_tabs`
--

CREATE TABLE `vtiger_dashboard_tabs` (
  `id` int(19) NOT NULL AUTO_INCREMENT,
  `tabname` varchar(50) DEFAULT NULL,
  `isdefault` int(1) DEFAULT 0,
  `sequence` int(5) DEFAULT 2,
  `appname` varchar(20) DEFAULT NULL,
  `modulename` varchar(50) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tabname` (`tabname`,`userid`),
  KEY `vtiger_dashboard_tabs_ibfk_1` (`userid`),
  CONSTRAINT `vtiger_dashboard_tabs_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=763 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_dashboard_tabs`
--

INSERT INTO `vtiger_dashboard_tabs` VALUES
(2,'My Dashboard',1,1,'','',1),
(592,'My Dashboard',1,1,'','',1038),
(593,'My Dashboard',1,1,'','',1039),
(594,'My Dashboard',1,1,'','',1041),
(595,'My Dashboard',1,1,'','',1042),
(596,'My Dashboard',1,1,'','',1043),
(597,'My Dashboard',1,1,'','',1044),
(598,'My Dashboard',1,1,'','',1045),
(599,'My Dashboard',1,1,'','',1046),
(603,'My Dashboard',1,1,'','',1040),
(606,'My Dashboard',1,1,'','',1047),
(607,'My Dashboard',1,1,'','',1048),
(609,'My Dashboard',1,1,'','',1049),
(610,'My Dashboard',1,1,'','',1050),
(611,'My Dashboard',1,1,'','',1051),
(612,'My Dashboard',1,1,'','',1052),
(613,'My Dashboard',1,1,'','',1053),
(614,'My Dashboard',1,1,'','',1054),
(615,'My Dashboard',1,1,'','',1055),
(616,'My Dashboard',1,1,'','',1056),
(617,'My Dashboard',1,1,'','',1057),
(619,'My Dashboard',1,1,'','',1059),
(620,'My Dashboard',1,1,'','',1060),
(621,'My Dashboard',1,1,'','',1061),
(622,'My Dashboard',1,1,'','',1062),
(623,'My Dashboard',1,1,'','',1063),
(624,'My Dashboard',1,1,'','',1064),
(625,'My Dashboard',1,1,'','',1065),
(626,'My Dashboard',1,1,'','',1066),
(627,'My Dashboard',1,1,'','',1067),
(628,'My Dashboard',1,1,'','',1068),
(629,'My Dashboard',1,1,'','',1069),
(630,'My Dashboard',1,1,'','',1070),
(631,'My Dashboard',1,1,'','',1071),
(632,'My Dashboard',1,1,'','',1072),
(633,'My Dashboard',1,1,'','',1073),
(634,'My Dashboard',1,1,'','',1074),
(635,'My Dashboard',1,1,'','',1075),
(636,'My Dashboard',1,1,'','',1076),
(637,'My Dashboard',1,1,'','',1077),
(638,'My Dashboard',1,1,'','',1078),
(639,'My Dashboard',1,1,'','',1079),
(640,'My Dashboard',1,1,'','',1080),
(641,'My Dashboard',1,1,'','',1081),
(642,'My Dashboard',1,1,'','',1082),
(643,'My Dashboard',1,1,'','',1083),
(644,'My Dashboard',1,1,'','',1084),
(645,'My Dashboard',1,1,'','',1085),
(646,'My Dashboard',1,1,'','',1086),
(647,'My Dashboard',1,1,'','',1087),
(648,'My Dashboard',1,1,'','',1088),
(649,'My Dashboard',1,1,'','',1089),
(650,'My Dashboard',1,1,'','',1090),
(651,'My Dashboard',1,1,'','',1091),
(652,'My Dashboard',1,1,'','',1092),
(653,'My Dashboard',1,1,'','',1093),
(654,'My Dashboard',1,1,'','',1094),
(655,'My Dashboard',1,1,'','',1095),
(656,'My Dashboard',1,1,'','',1096),
(657,'My Dashboard',1,1,'','',1097),
(658,'My Dashboard',1,1,'','',1098),
(659,'My Dashboard',1,1,'','',1099),
(660,'My Dashboard',1,1,'','',1100),
(661,'My Dashboard',1,1,'','',1101),
(662,'My Dashboard',1,1,'','',1102),
(663,'My Dashboard',1,1,'','',1103),
(664,'My Dashboard',1,1,'','',1104),
(665,'My Dashboard',1,1,'','',1107),
(666,'My Dashboard',1,1,'','',1108),
(667,'My Dashboard',1,1,'','',1109),
(668,'My Dashboard',1,1,'','',1110),
(669,'My Dashboard',1,1,'','',1122),
(670,'My Dashboard',1,1,'','',1123),
(671,'My Dashboard',1,1,'','',1124),
(672,'My Dashboard',1,1,'','',1125),
(673,'My Dashboard',1,1,'','',1126),
(674,'My Dashboard',1,1,'','',1127),
(675,'My Dashboard',1,1,'','',1128),
(676,'My Dashboard',1,1,'','',1129),
(677,'My Dashboard',1,1,'','',1130),
(678,'My Dashboard',1,1,'','',1131),
(679,'My Dashboard',1,1,'','',1132),
(680,'My Dashboard',1,1,'','',1133),
(681,'My Dashboard',1,1,'','',1134),
(682,'My Dashboard',1,1,'','',1135),
(683,'My Dashboard',1,1,'','',1136),
(684,'My Dashboard',1,1,'','',1137),
(685,'My Dashboard',1,1,'','',1138),
(686,'My Dashboard',1,1,'','',1139),
(687,'My Dashboard',1,1,'','',1140),
(688,'My Dashboard',1,1,'','',1141),
(689,'My Dashboard',1,1,'','',1142),
(690,'My Dashboard',1,1,'','',1143),
(691,'My Dashboard',1,1,'','',1144),
(692,'My Dashboard',1,1,'','',1145),
(693,'My Dashboard',1,1,'','',1146),
(694,'My Dashboard',1,1,'','',1147),
(695,'My Dashboard',1,1,'','',1148),
(696,'My Dashboard',1,1,'','',1149),
(697,'My Dashboard',1,1,'','',1150),
(698,'My Dashboard',1,1,'','',1151),
(699,'My Dashboard',1,1,'','',1152),
(700,'My Dashboard',1,1,'','',1153),
(701,'My Dashboard',1,1,'','',1154),
(702,'My Dashboard',1,1,'','',1155),
(703,'My Dashboard',1,1,'','',1156),
(704,'My Dashboard',1,1,'','',1157),
(705,'My Dashboard',1,1,'','',1158),
(706,'My Dashboard',1,1,'','',1159),
(707,'My Dashboard',1,1,'','',1160),
(708,'My Dashboard',1,1,'','',1161),
(709,'My Dashboard',1,1,'','',1162),
(710,'My Dashboard',1,1,'','',1163),
(711,'My Dashboard',1,1,'','',1164),
(712,'My Dashboard',1,1,'','',1165),
(713,'My Dashboard',1,1,'','',1166),
(714,'My Dashboard',1,1,'','',1167),
(715,'My Dashboard',1,1,'','',1168),
(716,'My Dashboard',1,1,'','',1169),
(717,'My Dashboard',1,1,'','',1170),
(718,'My Dashboard',1,1,'','',1171),
(719,'My Dashboard',1,1,'','',1172),
(720,'My Dashboard',1,1,'','',1173),
(721,'My Dashboard',1,1,'','',1174),
(722,'My Dashboard',1,1,'','',1175),
(723,'My Dashboard',1,1,'','',1176),
(724,'My Dashboard',1,1,'','',1177),
(725,'My Dashboard',1,1,'','',1178),
(726,'My Dashboard',1,1,'','',1179),
(727,'My Dashboard',1,1,'','',1180),
(728,'My Dashboard',1,1,'','',1181),
(729,'My Dashboard',1,1,'','',1182),
(730,'My Dashboard',1,1,'','',1183),
(731,'My Dashboard',1,1,'','',1184),
(732,'My Dashboard',1,1,'','',1185),
(733,'My Dashboard',1,1,'','',1186),
(734,'My Dashboard',1,1,'','',1187),
(735,'My Dashboard',1,1,'','',1188),
(736,'My Dashboard',1,1,'','',1189),
(737,'My Dashboard',1,1,'','',1190),
(738,'My Dashboard',1,1,'','',1191),
(739,'My Dashboard',1,1,'','',1192),
(740,'My Dashboard',1,1,'','',1193),
(741,'My Dashboard',1,1,'','',1194),
(742,'My Dashboard',1,1,'','',1195),
(743,'My Dashboard',1,1,'','',1196),
(744,'My Dashboard',1,1,'','',1197),
(745,'My Dashboard',1,1,'','',1198),
(746,'My Dashboard',1,1,'','',1199),
(747,'My Dashboard',1,1,'','',1200),
(748,'My Dashboard',1,1,'','',1202),
(749,'My Dashboard',1,1,'','',1203),
(752,'My Dashboard',1,1,'','',1217),
(758,'My Dashboard',1,1,'','',1220),
(762,'My Dashboard',1,1,'','',1230);

--
-- Table structure for table `vtiger_datashare_grp2grp`
--

CREATE TABLE `vtiger_datashare_grp2grp` (
  `shareid` int(19) NOT NULL,
  `share_groupid` int(19) DEFAULT NULL,
  `to_groupid` int(19) DEFAULT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_grp2grp_share_groupid_idx` (`share_groupid`),
  KEY `datashare_grp2grp_to_groupid_idx` (`to_groupid`),
  CONSTRAINT `fk_3_vtiger_datashare_grp2grp` FOREIGN KEY (`to_groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_grp2grp`
--


--
-- Table structure for table `vtiger_datashare_grp2role`
--

CREATE TABLE `vtiger_datashare_grp2role` (
  `shareid` int(19) NOT NULL,
  `share_groupid` int(19) DEFAULT NULL,
  `to_roleid` varchar(255) DEFAULT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `idx_datashare_grp2role_share_groupid` (`share_groupid`),
  KEY `idx_datashare_grp2role_to_roleid` (`to_roleid`),
  CONSTRAINT `fk_3_vtiger_datashare_grp2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_grp2role`
--


--
-- Table structure for table `vtiger_datashare_grp2rs`
--

CREATE TABLE `vtiger_datashare_grp2rs` (
  `shareid` int(19) NOT NULL,
  `share_groupid` int(19) DEFAULT NULL,
  `to_roleandsubid` varchar(255) DEFAULT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_grp2rs_share_groupid_idx` (`share_groupid`),
  KEY `datashare_grp2rs_to_roleandsubid_idx` (`to_roleandsubid`),
  CONSTRAINT `fk_3_vtiger_datashare_grp2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_grp2rs`
--


--
-- Table structure for table `vtiger_datashare_module_rel`
--

CREATE TABLE `vtiger_datashare_module_rel` (
  `shareid` int(19) NOT NULL,
  `tabid` int(19) NOT NULL,
  `relationtype` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `idx_datashare_module_rel_tabid` (`tabid`),
  CONSTRAINT `fk_1_vtiger_datashare_module_rel` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_module_rel`
--

INSERT INTO `vtiger_datashare_module_rel` VALUES
(10,105,'ROLE::RS'),
(12,90,'ROLE::ROLE'),
(13,96,'ROLE::ROLE'),
(14,96,'ROLE::ROLE'),
(15,90,'ROLE::ROLE'),
(18,86,'RS::ROLE'),
(23,94,'RS::RS'),
(24,50,'ROLE::RS'),
(25,89,'ROLE::ROLE'),
(26,89,'RS::RS'),
(27,89,'ROLE::ROLE'),
(28,89,'ROLE::ROLE'),
(29,102,'ROLE::ROLE'),
(30,91,'ROLE::ROLE'),
(31,91,'ROLE::ROLE'),
(33,50,'ROLE::ROLE'),
(34,50,'ROLE::ROLE'),
(35,86,'ROLE::ROLE'),
(36,101,'ROLE::RS'),
(37,50,'ROLE::RS'),
(38,50,'RS::RS');

--
-- Table structure for table `vtiger_datashare_module_rel_seq`
--

CREATE TABLE `vtiger_datashare_module_rel_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_module_rel_seq`
--

INSERT INTO `vtiger_datashare_module_rel_seq` VALUES
(39);

--
-- Table structure for table `vtiger_datashare_relatedmodule_permission`
--

CREATE TABLE `vtiger_datashare_relatedmodule_permission` (
  `shareid` int(19) NOT NULL,
  `datashare_relatedmodule_id` int(19) NOT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`,`datashare_relatedmodule_id`),
  KEY `datashare_relatedmodule_permission_shareid_permissions_idx` (`shareid`,`permission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_relatedmodule_permission`
--


--
-- Table structure for table `vtiger_datashare_relatedmodules`
--

CREATE TABLE `vtiger_datashare_relatedmodules` (
  `datashare_relatedmodule_id` int(19) NOT NULL,
  `tabid` int(19) DEFAULT NULL,
  `relatedto_tabid` int(19) DEFAULT NULL,
  PRIMARY KEY (`datashare_relatedmodule_id`),
  KEY `datashare_relatedmodules_tabid_idx` (`tabid`),
  KEY `datashare_relatedmodules_relatedto_tabid_idx` (`relatedto_tabid`),
  CONSTRAINT `fk_2_vtiger_datashare_relatedmodules` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_relatedmodules`
--

INSERT INTO `vtiger_datashare_relatedmodules` VALUES
(1,6,2),
(2,6,13),
(3,6,20),
(4,6,22),
(5,6,23),
(6,2,20),
(7,2,22),
(8,20,22),
(9,22,23);

--
-- Table structure for table `vtiger_datashare_relatedmodules_seq`
--

CREATE TABLE `vtiger_datashare_relatedmodules_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_relatedmodules_seq`
--

INSERT INTO `vtiger_datashare_relatedmodules_seq` VALUES
(9);

--
-- Table structure for table `vtiger_datashare_role2group`
--

CREATE TABLE `vtiger_datashare_role2group` (
  `shareid` int(19) NOT NULL,
  `share_roleid` varchar(255) DEFAULT NULL,
  `to_groupid` int(19) DEFAULT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `idx_datashare_role2group_share_roleid` (`share_roleid`),
  KEY `idx_datashare_role2group_to_groupid` (`to_groupid`),
  CONSTRAINT `fk_3_vtiger_datashare_role2group` FOREIGN KEY (`share_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_role2group`
--


--
-- Table structure for table `vtiger_datashare_role2role`
--

CREATE TABLE `vtiger_datashare_role2role` (
  `shareid` int(19) NOT NULL,
  `share_roleid` varchar(255) DEFAULT NULL,
  `to_roleid` varchar(255) DEFAULT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_role2role_share_roleid_idx` (`share_roleid`),
  KEY `datashare_role2role_to_roleid_idx` (`to_roleid`),
  CONSTRAINT `fk_3_vtiger_datashare_role2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_role2role`
--

INSERT INTO `vtiger_datashare_role2role` VALUES
(12,'H356','H346',0),
(13,'H357','H346',1),
(14,'H357','H356',1),
(15,'H356','H353',1),
(25,'H346','H353',1),
(27,'H346','H356',1),
(28,'H347','H356',1),
(29,'H356','H353',1),
(30,'H357','H353',1),
(31,'H357','H356',1),
(33,'H353','H357',1),
(34,'H356','H353',1),
(35,'H2','H357',1);

--
-- Table structure for table `vtiger_datashare_role2rs`
--

CREATE TABLE `vtiger_datashare_role2rs` (
  `shareid` int(19) NOT NULL,
  `share_roleid` varchar(255) DEFAULT NULL,
  `to_roleandsubid` varchar(255) DEFAULT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_role2s_share_roleid_idx` (`share_roleid`),
  KEY `datashare_role2s_to_roleandsubid_idx` (`to_roleandsubid`),
  CONSTRAINT `fk_3_vtiger_datashare_role2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vtiger_datashare_role2rs`
--

INSERT INTO `vtiger_datashare_role2rs` VALUES
(10,'H2','H2',0),
(24,'H353','H353',1),
(36,'H346','H356',1),
(37,'H2','H356',1);

--
-- Table structure for table `vtiger_datashare_rs2grp`
--

CREATE TABLE `vtiger_datashare_rs2grp` (
  `shareid` int(19) NOT NULL,
  `share_roleandsubid` varchar(255) DEFAULT NULL,
  `to_groupid` int(19) DEFAULT NULL,
  `permission` int(19) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_rs2grp_share_roleandsubid_idx` (`share_roleandsubid`),
  KEY `datashare_rs2grp_to_groupid_idx` (`to_groupid`),
  CONSTRAINT `fk_3_vtiger_datashare_rs2grp` FOREIGN KEY (`share_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
