INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSET','IMS','IMSSET',1101,'ems_inventory/inventory_transaction.aspx#',2,NULL,'Settings','1','../images/Settings.gif','SETTINGS','','Settings','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTKRLS','IMSROL','IMSSTKRLS',1101,'ems_inventory/ims_mst_rolsummary.aspx',3,NULL,'ROL Settings ','1','../images/grade_summary_icon_RS.png','STOCK','','ROL Settings','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnRolsettings',NULL,NULL,NULL,NULL);
UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'IMSSET' WHERE (`module_gid` = 'IMSSTKRLS');
UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1100' WHERE (`module_gid` = 'IMSSET');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSMST','IMS','IMSMST',1101,'ems_inventory/inventory_transaction.aspx#',2,NULL,'Master','1','','MASTER','','Master','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSMSTBIN','IMSMST','IMSMSTBIN',1105,'ems_inventory/ims_mst_assignproduct.aspx',3,NULL,'Bin ','','','MASTER','','Bin','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsMstProductSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSMSTLOC','IMSMST','IMSMSTLOC',1104,'ems_inventory/ims_mst_locationsummary.aspx',3,NULL,'Location','1','','MASTER','','Location','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsMstLocation',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSMSTPDT','IMSMST','IMSMSTPDT',1103,'ems_inventory/ims_mst_productsummary.aspx',3,NULL,'Product','1','','MASTER','','Product','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsMstProductSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSMSTPGP','IMSMST','IMSMSTPGP',1101,'ems_inventory/ims_mst_productgroupsummary.aspx',3,NULL,'Product Group','1','','MASTER','','Product Group','','','','N','N',NULL,NULL,NULL,NULL,'Y','/pmr/PmrMstProductGroup',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSMSTPUS','IMSMST','IMSMSTPUS',1102,'ems_inventory/ims_mst_productuomsummary.aspx',3,NULL,'Product Units','1','','MASTER','','Product Units','','','','N','N',NULL,NULL,NULL,NULL,'Y','/pmr/PmrMstProductunit',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTKOPS','IMSMST','IMSSTKOPS',1106,'ems_inventory/ims_trn_openingstocksummary.aspx',3,NULL,'Opening Stock','1','../images/ico_opening_stock_RS.png','STOCK','','Opening Stock','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnOpeningstockSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRN','IMS','IMSTRN',1102,'ems_inventory/inventory_transaction.aspx#',2,NULL,'Material Management','1','../images/ico_qc_dg.gif','MATERIAL MANAGEMENT','','Material Management','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRNMRA','IMSTRN','IMSTRNMRA',1102,'ems_inventory/ims_trn_materialrequisitionapprovesummary.aspx',3,NULL,'Indent Approval','1','../images/ico_stock_report_RS.png','MATERIALS','','Indent Approval','Y','','Parallel','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRNMTR','IMSTRN','IMSTRNMTR',1101,'ems_inventory/ims_trn_materialrequisitionsummary.aspx',3,NULL,'Material Indent ','1','../images/ICO_RAISE_PR_RS.png','MATERIALS','','Material Indent ','','','','N','N',NULL,NULL,NULL,NULL,'Y','ims/ImsTrnMaterialindent',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRNMRP','IMSTRN','IMSTRNMRP',1103,'ems_inventory/ims_trn_mrpriceassign.aspx',3,NULL,'Indent Price Estimation','1','../images/ICO_RAISE_PR_RS.png','MATERIALS','','Indent Price Estimation','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRNISM','IMSTRN','IMSTRNISM',1104,'ems_inventory/ims_trn_materialissuesummary.aspx',3,NULL,'Issue Materials','1','../images/ico_stock_report_RS.png','MATERIALS','','Issue Materials','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnIssuematerialSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRNPMI','IMSTRN','IMSTRNPMI',1105,'ems_inventory/ims_trn_pendingmaterialissue.aspx',3,NULL,'Pending Issue','1','../images/ico_stock_report_RS.png','MATERIALS','','Pending Issue','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTR','IMS','IMSSTR',1103,'ems_inventory/inventory_transaction.aspx#',2,NULL,'Stores Management','1','../images/ico_qc_dg.gif','STORE','','Stores Management','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTKSTR','IMSSTR','IMSSTKSTR',1101,'ems_inventory/ims_trn_storerequisitionsummary.aspx',3,NULL,'Stores Requisition','1','','','','Stores Requisition','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTKSTM','IMSSTR','IMSSTKSTM',1102,'ems_inventory/ims_trn_stocksummary.aspx',3,NULL,'Stock Manager','1','../images/ico_product_manager_RS.png','STOCK','','Stock Manager','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnStocksummary',NULL,NULL,NULL,NULL);
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Stock Management', `breadcrumb_name` = 'Stock Management' WHERE (`module_gid` = 'IMSSTKSTM');
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTKSTA','IMSSTR','IMSSTKSTA',1103,'ems_inventory/ims_trn_loosestocksummary.aspx',3,NULL,'Stock Regularisation','1','../images/stock_adjustment_icon_RS.png','STOCK','','Stock Regularisation','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSGRN','IMS','IMSGRN',1104,'ems_inventory/inventory_transaction.aspx#',2,NULL,'GRN','1','../images/ico_qc_dg.gif','GRN','','GRN','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRNGIW','IMSGRN','IMSTRNGIW',1101,'ems_pmr/pmr_trn_grninward.aspx',3,NULL,'GRN Inward','1','../images/ICO_REC_GRN_RS.png','MATERIALS','','GRN Inward','','','','N','N',NULL,NULL,NULL,NULL,'Y','/pmr/PmrTrnGrninward',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSTRNGCK','IMSGRN','IMSTRNGCK',1102,'ems_pmr/pmr_trn_grncheckersummary.aspx',3,NULL,'GRN QC','1','../images/ICO_QC_RS.png','MATERIALS','','GRN QC','','','','N','N',NULL,NULL,NULL,NULL,'Y','/pmr/PmrTrnGrncheckerSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTPRT','IMSGRN','IMSSTPRT',1103,'ems_pmr/pmr_trn_purchasereturnsummary.aspx',3,NULL,'Purchase Return','1','../images/ico_purchase_returns_RS.png','PURCHASE','','Purchase Return','','','','N','N',NULL,NULL,NULL,NULL,'Y','ims/ImsTrnPurchaseReturns',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSDEL','IMS','IMSDEL',1105,'ems_crm/crm_transaction.aspx#',2,NULL,'Delivery Order','1','../images/ico_qc_dg.gif','','','Delivery','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSDELDEL','IMSDEL','IMSDELDEL',1101,'ems_crm/crm_trn_directordersummary.aspx',3,NULL,'Delivery Order','1','','','','Delivery Order','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnDeliveryorder',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSDELACK','IMSDEL','IMSDELACK',1102,'ems_crm/crm_trn_deliveryacknowledgementsummary.aspx',3,NULL,'Delivery Acknowledgement','1','','','','Delivery Acknowledgement','','','','N','N',NULL,NULL,NULL,NULL,'Y','ims/ImsTrnDeliveryOrderAcknowlegement',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSDELODC','IMSDEL','IMSDELODC',1103,'ems_crm/crm_trn_opendcsummary.aspx',3,NULL,'Open Delivery Challan','1','','','','Open Delivery Order','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnOpendcsummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSDELSAR','IMSDEL','IMSDELSAR',1104,'ems_crm/crm_trn_salesreturnsummary.aspx',3,NULL,'Sales Return','1','','','','Sales Return','','','','N','N',NULL,NULL,NULL,NULL,'Y','ims/ImsTrnSalesReturnSummary',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSST','IMS','IMSST',1106,'ems_crm/crm_transaction.aspx#',2,NULL,'Stock Transfer','1','../images/ico_qc_dg.gif','','','Stock Transfer','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTKST','IMSST','IMSSTKST',1101,'',3,NULL,'Stock Transfer','1','','Stock','','Stock Transfer','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnStockTransfer',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTKSTAK','IMSST','IMSSTKSTAK',1102,'',3,NULL,'Stock Transfer Acknowlegement','1','','Stock','','Stock Transfer Acknowlegement','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnStockTransferAcknowledgementSummary',NULL,NULL,NULL,NULL);
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/ims/ImsTrnStockRegularization' WHERE (`module_gid` = 'IMSSTKSTA');
UPDATE `adm_mst_tmoduleangular` SET `sref` = 'ims/ImsTrnMIapproval' WHERE (`module_gid` = 'IMSTRNMRA');
UPDATE `adm_mst_tmoduleangular` SET `sref` = 'ims/ImsTrnIndentPriceEstimation' WHERE (`module_gid` = 'IMSTRNMRP');
DELETE FROM `adm_mst_tmoduleangular` WHERE (`module_gid` = 'IMSSTK');
UPDATE `vcidex`.`adm_mst_tmoduleangular` SET `sref` = '/ims/ImsMstAssignproduct' WHERE (`module_gid` = 'IMSMSTBIN');


-- REPORTS --

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPT','IMS','IMSRPT',1111,'ems_inventory/inventory_transaction.aspx#',2,NULL,'Reports','1','../images/Settings.gif','','','Reports','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);
UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1107' WHERE (`module_gid` = 'IMSRPT');
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTCSR','IMSRPT','IMSRPTCSR',1108,NULL,3,NULL,'Closing Stock Report','1',NULL,'REPORT',NULL,'Closing Stock Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptClosingStockReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTGRNDR','IMSRPT','IMSRPTGRNDR',1110,NULL,3,NULL,'GRN Detail Report','1',NULL,'REPORT',NULL,'GRN Detail Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptGRNDetailReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTGRNR','IMSRPT','IMSRPTGRNR',1109,NULL,3,NULL,'GRN Report','1',NULL,'REPORT',NULL,'GRN Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptGRNReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTHC','IMSRPT','IMSRPTHC',1109,NULL,3,NULL,'High Cost Report','1',NULL,'REPORT',NULL,'High Cost Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptHighcost',NULL,NULL,NULL,NULL);INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTMT','IMSRPT','IMSRPTMT',1105,NULL,3,NULL,'Material Tracker','1',NULL,'REPORT',NULL,'Material Tracker',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptMaterialTracker',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTPIR','IMSRPT','IMSRPTPIR',1106,NULL,3,NULL,'Product Issued Report','1',NULL,'REPORT',NULL,'Product Issued Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptProductIssueReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTSAR','IMSRPT','IMSRPTSAR',1103,NULL,3,NULL,'Stock Age Report','1',NULL,'REPORT',NULL,'Stock Age Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptStockAgeReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTSCR','IMSRPT','IMSRPTSCR',1104,NULL,3,NULL,'Stock Consumption Report','1',NULL,'REPORT',NULL,'Stock Consumption Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnStockConsumptionReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTSKR','IMSRPT','IMSRPTSKR',1101,'ems_inventory/ims_rpt_stockreport.aspx',3,NULL,'Stock Report','1','../images/ico_stock_report_RS.png','REPORT','','Stock Report','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptStockreport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTSSR','IMSRPT','IMSRPTSSR',1107,NULL,3,NULL,'Stock Status Report','1',NULL,'REPORT',NULL,'Stock Status Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptStockStatusReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSRPTSTRT','IMSRPT','IMSRPTSTRT',1102,NULL,3,NULL,'Stock Transfer Report','1',NULL,'REPORT',NULL,'Stock Transfer Report',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsRptStockTransferReport',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`,`k_sref`) VALUES ('IMSSTK','IMS','IMSSTK',1104,'ems_inventory/inventory_transaction.aspx#',2,NULL,'Stock Management','1','../images/ico_qc_dg.gif','STOCK','','Stock Management','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL,NULL);