--                       =============== Inventory  ===================================

alter table ims_trn_tstock add column financial_year varchar(64) default null;
alter table ims_trn_topeningstockedit add column financial_year varchar(64) default 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','IMSSTK','IMSSTKST',1103,'',3,NULL,'Stock Transfer','1','','Stock','','Stock Transfer','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnStockTransfer',NULL,NULL,NULL,NULL);
alter table ims_tmp_tstock add column location_gid varchar(64);
alter table ims_tmp_tstocktransferdtl add column display_field longtext;
alter table ims_trn_tstocktransferdtl add column display_field longtext;


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)
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
);

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)
values
('IMSSTPRT', 'IMSGRN', 'IMSSTPRT', '1107', '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
);

CREATE TABLE `ims_tmp_topendc` (
  `tmpdc_gid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_gid` varchar(64) DEFAULT NULL,
  `qty_requested` double DEFAULT '0',
  `product_remarks` longtext,
  `user_gid` varchar(64) DEFAULT NULL,
  `qty_issued` double DEFAULT '0',
  `productuom_gid` varchar(64) DEFAULT NULL,
  `display_field` longtext,
  `production_gid` varchar(64) DEFAULT NULL,
  `unitpackage_gid` varchar(64) DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `productgroup_gid` varchar(45) DEFAULT NULL,
  `productgroup_name` varchar(128) DEFAULT NULL,
  `product_code` varchar(64) DEFAULT NULL,
  `productuom_name` varchar(64) DEFAULT NULL,
  `product_name` longtext,
  PRIMARY KEY (`tmpdc_gid`),
  KEY `idn_productgid` (`product_gid`),
  KEY `idn_usergid` (`user_gid`),
  KEY `idn_productuomgid` (`productuom_gid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

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`) VALUES ('IMSTRNODC','IMSGRN','IMSTRNODC',1105,'ems_pmr/pmr_trn_opendc.aspx',3,NULL,'Open Dc','1','../images/ICO_REC_GRN_RS.png','MATERIALS','','Open DC','','','','N','N',NULL,NULL,NULL,NULL,'Y','/ims/ImsTrnOpendc',NULL,NULL,NULL);

alter table ims_trn_tdeliveryorder add column  `branch_gid` varchar(45) DEFAULT NULL;
alter table ims_trn_tdeliveryorder add column  `branch_name` varchar(45) DEFAULT NULL;

CREATE TABLE `ims_trn_tdeliveryorder` (
  `directorder_gid` varchar(64) NOT NULL,
  `directorder_date` date DEFAULT NULL,
  `directorder_refno` varchar(64) DEFAULT NULL,
  `directorder_remarks` longtext,
  `directorder_status` varchar(32) DEFAULT NULL,
  `created_name` varchar(128) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `sender_name` varchar(128) DEFAULT NULL,
  `sender_designation` varchar(128) DEFAULT NULL,
  `sender_contactnumber` varchar(128) DEFAULT NULL,
  `product_grandtotal` double DEFAULT '0',
  `addon_amount` double DEFAULT '0',
  `addon_discount` double DEFAULT '0',
  `grandtotal_amount` double DEFAULT '0',
  `Landline_no` varchar(45) DEFAULT NULL,
  `discount` varchar(45) DEFAULT NULL,
  `chargeamount` varchar(45) DEFAULT NULL,
  `delivery_status` varchar(45) DEFAULT 'Delivery Pending',
  `delivered_to` varchar(128) DEFAULT NULL,
  `delivered_date` datetime DEFAULT NULL,
  `invoice_status` varchar(45) DEFAULT 'Invoice Pending',
  `delivered_by` varchar(128) DEFAULT NULL,
  `delivered_remarks` text,
  `shipping_to` text,
  `dc_type` varchar(45) DEFAULT 'Actual DC',
  `created_by` varchar(64) DEFAULT NULL,
  `dc_no` varchar(45) DEFAULT NULL,
  `mode_of_despatch` varchar(45) DEFAULT NULL,
  `tracker_id` varchar(45) DEFAULT NULL,
  `invoice_gid` varchar(64) DEFAULT NULL,
  `dc_note` varchar(256) DEFAULT NULL,
  `no_of_boxs` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`directorder_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 
 
 
CREATE TABLE `ims_trn_tdeliveryorderdtl` (
  `directorderdtl_gid` varchar(64) NOT NULL,
  `directorder_gid` varchar(64) NOT NULL,
  `productgroup_gid` varchar(64) DEFAULT NULL,
  `productgroup_name` varchar(512) DEFAULT NULL,
  `product_gid` varchar(64) DEFAULT NULL,
  `product_name` varchar(512) DEFAULT NULL,
  `product_uom_gid` varchar(64) DEFAULT NULL,
  `productuom_name` varchar(45) DEFAULT NULL,
  `product_qty` int(11) DEFAULT '0',
  `product_description` longtext,
  `product_price` decimal(18,2) DEFAULT NULL,
  `discount_percentage` double DEFAULT '0',
  `discount_amount` double DEFAULT '0',
  `tax_name` varchar(128) DEFAULT NULL,
  `tax_name2` varchar(45) DEFAULT NULL,
  `tax_name3` varchar(45) DEFAULT NULL,
  `tax_percentage` double DEFAULT '0',
  `tax_percentage2` double DEFAULT '0',
  `tax_percentage3` double DEFAULT '0',
  `tax_amount` double DEFAULT '0',
  `tax_amount2` double DEFAULT '0',
  `tax_amount3` double DEFAULT '0',
  `product_total` double DEFAULT '0',
  `total_amount` double DEFAULT '0',
  `product_qtydelivered` int(11) DEFAULT '0',
  `dc_no` varchar(45) DEFAULT NULL,
  `mode_of_despatch` varchar(45) DEFAULT NULL,
  `tracker_id` varchar(45) DEFAULT NULL,
  `qty_returned` double(13,2) DEFAULT '0.00',
  `tax1_gid` varchar(45) DEFAULT NULL,
  `tax2_gid` varchar(45) DEFAULT NULL,
  `tax3_gid` varchar(45) DEFAULT NULL,
  `product_remarks` text,
  `warranty_date` date DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `product_code` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`directorderdtl_gid`),
  KEY `Index_2` (`directorder_gid`,`productgroup_gid`,`product_gid`,`product_uom_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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)
  values
  ('IMSEXTR', 'IMSSTK', 'IMSEXTR', '1105', 'ems_inventory/expiretracker.aspx', '3', NULL, 'Expire Tracker', '1', '../images/ICO_RAISE_PR_RS.png', 'Expire Tracker', NULL, 'Expire Tracker', NULL, NULL, NULL, 'N', 'N', NULL, NULL, NULL, NULL, 'Y', 'ims/ImsTrnExpiretracker', NULL, NULL, NULL
);

alter table ims_trn_tmaterialissued Add Column location_gid varchar(64) default null;
alter table ims_trn_tmaterialrequisitiondtl add column requested_by varchar(65) default null;
alter table ims_trn_tmaterialissued Add Column location_gid varchar(64) default null;
INSERT INTO `` (`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`) 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);
 
Tmodule Scripts for Inventory:
update adm_mst_tmodule set lw_flag='N' where module_gid like 'IMS%';
update adm_mst_tmodule set lw_flag='Y',sref='/ims/ImsTrnDeliveryorder' where module_gid='IMSDEL';
update adm_mst_tmodule set lw_flag='Y',sref='ims/ImsTrnDeliveryOrderAcknowlegement' where module_gid='IMSDELACK';
update adm_mst_tmodule set lw_flag='Y',sref='/ims/ImsTrnDeliveryorder' where module_gid='IMSDELDEL';
update adm_mst_tmodule set lw_flag='Y',sref='/ims/ImsTrnOpendcsummary' where module_gid='IMSDELODC';
update adm_mst_tmodule set lw_flag='Y',sref='/ims/ImsTrnOpeningstockSummary' where module_gid='IMSSTKOPS';
update adm_mst_tmodule set lw_flag='Y',sref=' /pmr/PmrTrnGrncheckerSummary' where module_gid='IMSTRNGCK';
update adm_mst_tmodule set lw_flag='Y',sref='/pmr/PmrTrnGrninward' where module_gid='IMSTRNGIW';
update adm_mst_tmodule set lw_flag='Y',sref='/ims/ImsTrnIssuematerialSummary' where module_gid='IMSTRNISM';

24/09/2024--Arun 

alter table  ims_tmp_tstocktransferdtl add column stock_quantity varchar(100) default null  ;
  alter table  ims_trn_tstocktransferdtl add column created_by varchar(64) default null  ;

24/09/2024--Sridhar
  alter table  ims_trn_tstocktransferdtl add column created_date varchar(64) default null  ;