CREATE TABLE `pmr_mst_tcustomercategory` ( 

  `category_gid` varchar(64) NOT NULL, 

  `category_code` varchar(32) DEFAULT NULL, 

  `category_name` varchar(64) DEFAULT NULL, 

  `created_by` varchar(64) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  PRIMARY KEY (`category_gid`) 

); 

 

INSERT INTO `mootek`.`pmr_mst_tcustomercategory` (`category_gid`, `category_code`, `category_name`) VALUES ('CUS001', 'MP001', 'Manufacturing Process'); 

 

 

alter table crm_mst_tcustomer add column  `category_gid` varchar(64) DEFAULT NULL; 

alter table crm_mst_tcustomer add column  `category_name` varchar(64) DEFAULT NULL; 

alter table crm_mst_tcustomer add column  `subcategory_name` varchar(64) DEFAULT NULL; 

 

 

 

INSERT INTO `adm_mst_tmodule`(`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`,`icon_name`) 

VALUES ('SMRCMCC','SMRCMT','SMRCMCC',1400,'ems_crm/crm_trn_customercategorysummary.aspx',3,NULL,'Customer Category','1','','','','Customer Category','','','','N','N',NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL); 

 

INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SSQM2303317593','CCSN','Customer category name','4','1','N','N','N','N','N','N','','','','2024','N',NULL,NULL,NULL,NULL); 

 

CREATE TABLE `pmr_mst_tcustomersubcategory` ( 

  `subcategory_gid` varchar(64) NOT NULL, 

  `category_gid` varchar(64) NOT NULL, 

  `category_name` varchar(64) DEFAULT NULL, 

  `subcategory_name` varchar(64) DEFAULT NULL, 

  `worktask_description` text, 

  `created_by` varchar(64) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  PRIMARY KEY (`subcategory_gid`) 

); 

 

 

alter table crm_mst_tcustomer add column `subcategory_gid` varchar(64) NOT NULL; 

 

 

INSERT INTO `adm_mst_tmodule` (`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`,`icon_name`) 

VALUES ('SMRSMRCME','SMRSMR','SMRSMRCME',1504,'ems_crm/crm_trn_salesmyenquirysummary.aspx',3,NULL,'Customer MyEnquiry','1','../images/ico_new_emp_details_RS.png','','','Customer MyEnquiry','','','','N','N',NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL); 

 

 

alter table hrm_mst_temployee Add column `employee_skypeid` varchar(64) NOT NULL; 

alter table hrm_mst_temployee Add column `emergency__mobileno` varchar(64) NOT NULL; 

 

 

alter table rbl_trn_tinvoice add column `freighttax_gid` varchar(128) DEFAULT NULL; 

alter table rbl_trn_tinvoice  add column `freighttax_amount` varchar(128) DEFAULT NULL; 

alter table smr_trn_tsalesorder add column `freighttax_gid` varchar(128) DEFAULT NULL; 

alter table smr_trn_tsalesorder  add column `freighttax_amount` varchar(128) DEFAULT NULL; 

 

alter table rbl_trn_tinvoice  add column `technician_name` varchar(128) DEFAULT NULL; 

alter table rbl_trn_tinvoice  add column `salesperson_gid` varchar(128) DEFAULT NULL; 

alter table smr_trn_tsalesorder  add column `technician_name` varchar(128) DEFAULT NULL; 

alter table smr_trn_tsalesorder  add column `salesperson_gid` varchar(128) DEFAULT NULL; 

 

alter table smr_trn_tsalesenquiry  add column `source_name` varchar(128) DEFAULT NULL; 

alter table acp_trn_tenquiry  add column `source_name` varchar(128) DEFAULT NULL; 

 

alter table acp_mst_tvendor add column `vendorgst_number` varchar(64) DEFAULT NULL; 

 

----------------------18-04-2024------------------------------------------- 

 

Alter table  rbl_trn_tinvoice Add column `customerpo_date` date DEFAULT NULL; 

Alter table  smr_trn_tsalesorder Add column `customerpo_date` date DEFAULT NULL; 

Alter table  rbl_trn_tinvoice Add column `customerpo_no` varchar(128) DEFAULT NULL; 

Alter table  smr_trn_tsalesorder Add column `customerpo_no` varchar(128) DEFAULT NULL; 

 

alter table rbl_mst_tconfiguration add column `invoicem_rpt` varchar(64) NOT NULL; 

 

 

----------------------24-04-2024------------------------------------------- 

 

CREATE TABLE `rbl_trn_tpdfstage` ( 

  `stage_gid` varchar(64) NOT NULL, 

  `stage_code` varchar(32) DEFAULT NULL, 

  `stage_name` varchar(64) DEFAULT NULL, 

  `created_by` varchar(64) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  PRIMARY KEY (`stage_gid`) 

); 

 

alter table rbl_trn_tinvoice add column stage_gid varchar(128) DEFAULT NULL; 

alter table rbl_trn_tinvoice add column stage_name varchar(128) DEFAULT NULL; 

 

alter table  rbl_trn_tinvoice  add column `shipping_to` text; 

========================================================================================================================================== 

 

-------------Purchase scripts--------------------(29-04-2024) by Praveen ---(can't run the test server and live ) 

 

 

update hrm_mst_tbranch set mainbranch_flag='Y'; 

  

CREATE TABLE `pmr_trn_ttype` ( 

  `type_gid` varchar(64) NOT NULL, 

  `type_code` varchar(32) DEFAULT NULL, 

  `type_name` varchar(64) DEFAULT NULL, 

  `created_by` varchar(64) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  PRIMARY KEY (`type_gid`) 

); 

 

alter table pmr_trn_tpurchaseorder add column type_gid varchar(128) DEFAULT NULL; 

 

 

 

------------ production Scripts ---------------(27-04-2024) 

 

ALTER TABLE pdc_mst_tbom MODIFY COLUMN `qty_requested` varchar(128) DEFAULT NULL; 

 

INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES 

 ('SSQM2404270000','PTBOM','ProductBom','4','143','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL); 

 

ALTER TABLE pdc_trn_tbom MODIFY COLUMN `qty_requested` varchar(128) DEFAULT NULL; 

 

alter table pdc_trn_tbom add column productbom_gid varchar(128) DEFAULT NULL; 

 

CREATE TABLE `pdc_tmp_trawmaterial` ( 

  `bomtmp_gid` varchar(64) NOT NULL, 

  `product_gid` varchar(64) DEFAULT NULL, 

  `product_name` varchar(3064) DEFAULT NULL, 

  `product_code` varchar(128) DEFAULT NULL, 

  `uom_gid` varchar(64) DEFAULT NULL, 

  `uom_name` varchar(64) DEFAULT NULL, 

  `qty_requested` varchar(128) DEFAULT NULL, 

  `product_price` float(13,2) DEFAULT '0.00', 

  `display_field` longtext, 

  `created_by` varchar(64) DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  `productgroup_name` varchar(3064) DEFAULT NULL, 

  PRIMARY KEY (`bomtmp_gid`) 

) ; 

INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`)  

VALUES ('SERM202404020084','PDC_SUC_026','Product Bom Assgined successfully','SUCCESS',NULL,NULL,NULL,NULL); 

 

INSERT INTO `adm_mst_tmodule` (`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`,`icon_name`) 

VALUES ('PDCPDCPOM','PDCODM','PDCPDCPOM',1701,'ems_pdc/pdc_trn_productionordersummary.aspx',3,NULL,'Production Management','1','','','','Production Management','T','','','N','N',NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL); 

 

drop table pdc_trn_tbom ; 

 

CREATE TABLE `pdc_trn_tbom` ( 

  `productbom_gid` varchar(128) NOT NULL, 

  `salesorderdtl_gid` varchar(45) DEFAULT NULL, 

  `salesorder_gid` varchar(45) DEFAULT NULL, 

  `jobcard_gid` varchar(45) DEFAULT NULL, 

  `product_gid` varchar(64) DEFAULT NULL, 

  `product_name` varchar(3064) DEFAULT NULL, 

  `product_code` varchar(128) DEFAULT NULL, 

  `uom_gid` varchar(64) DEFAULT NULL, 

  `uom_name` varchar(64) DEFAULT NULL, 

  `qty_requested` varchar(128) DEFAULT NULL, 

  `product_price` float(13,2) DEFAULT '0.00', 

  `display_field` longtext, 

  `additional_qty` float(13,2) DEFAULT '0.00', 

  `subtract_qty` float(13,2) DEFAULT '0.00', 

  `created_by` varchar(64) DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  `productgroup_name` varchar(64) DEFAULT NULL, 

  `serial_no` varchar(64) DEFAULT NULL, 

  `bomserial_no` varchar(64) DEFAULT NULL, 

  PRIMARY KEY (`productbom_gid`) 

) ; 

 

CREATE TABLE `pdc_trn_tproductionorder` ( 

  `productionorder_gid` varchar(64) NOT NULL, 

  `branch_gid` varchar(64) DEFAULT NULL, 

  `account_gid` varchar(45) DEFAULT NULL, 

  `salesorder_date` datetime DEFAULT NULL, 

  `customer_gid` varchar(64) DEFAULT NULL, 

  `customer_contact_person` varchar(512) DEFAULT NULL, 

  `customer_address` text, 

  `jccompleted_flag` char(1) DEFAULT 'N', 

  `so_referencenumber` varchar(512) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, 

  `so_remarks` longtext, 

  `total_amount` float(13,2) DEFAULT '0.00', 

  `payment_days` varchar(16) DEFAULT NULL, 

  `delivery_days` varchar(16) DEFAULT NULL, 

  `salesorder_status` varchar(32) DEFAULT NULL, 

  `created_by` varchar(16) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  `termsandconditions` text, 

  `so_referenceno1` varchar(64) DEFAULT NULL, 

  `Grandtotal` varchar(45) DEFAULT NULL, 

  `customer_name` text, 

  `salesorder_advance` double(13,2) DEFAULT '0.00', 

  `so_type` varchar(45) DEFAULT NULL, 

  `executeorder_flag` varchar(45) DEFAULT 'EO Pending', 

  `invoice_flag` varchar(45) DEFAULT 'Invoice Pending', 

  `salesorder_remarks` longtext, 

  `salesorder_flag` varchar(45) DEFAULT 'EO Pending', 

  `addon_charge` float(13,2) DEFAULT '0.00', 

  `additional_discount` float(13,2) DEFAULT '0.00', 

  `despatch_status` varchar(45) DEFAULT 'Approved', 

  `updated_advance` double(13,2) DEFAULT '0.00', 

  `received_amount` double(13,2) DEFAULT '0.00', 

  `invoice_amount` double(13,2) DEFAULT '0.00', 

  `updated_addon_charge` float(13,2) DEFAULT '0.00', 

  `updated_additional_discount` float(13,2) DEFAULT '0.00', 

  `cst_number` varchar(260) DEFAULT NULL, 

  `addon_charge_l` double(13,2) DEFAULT '0.00', 

  `additional_discount_l` double(13,2) DEFAULT '0.00', 

  `grandtotal_l` double(13,2) DEFAULT '0.00', 

  `currency_code` varchar(45) DEFAULT NULL, 

  `exchange_rate` double(13,2) DEFAULT '0.00', 

  `currency_gid` varchar(64) DEFAULT NULL, 

  `approved_by` varchar(60) DEFAULT NULL, 

  `approved_date` datetime DEFAULT NULL, 

  `renewal_date` datetime DEFAULT NULL, 

  `renewal_description` text, 

  `customer_email` varchar(128) DEFAULT NULL, 

  `customer_mobile` varchar(45) DEFAULT NULL, 

  `renewal_gid` varchar(64) DEFAULT NULL, 

  `reference_gid` varchar(64) DEFAULT NULL, 

  `customer_contact_gid` varchar(64) DEFAULT NULL, 

  `renewal_status` varchar(64) DEFAULT NULL, 

  `pinvoice_amount` double(13,2) DEFAULT '0.00', 

  `approval_remarks` text, 

  `shipping_to` text, 

  `freight_terms` varchar(128) DEFAULT NULL, 

  `payment_terms` varchar(128) DEFAULT NULL, 

  `customerbranch_gid` varchar(64) DEFAULT NULL, 

  `commit_advance` double(13,2) DEFAULT '0.00', 

  `otp_password` varchar(45) DEFAULT NULL, 

  `advance_wht` double(13,2) DEFAULT '0.00', 

  `updated_advancewht` double(13,2) DEFAULT '0.00', 

  `advanceapproval_flag` char(1) DEFAULT 'N', 

  `campaign_gid` varchar(45) DEFAULT 'No Campaign', 

  `agreement_flag` varchar(45) NOT NULL DEFAULT 'N', 

  `marketingexecutive_gid` varchar(45) DEFAULT NULL, 

  `marketingexecutiveteam_gid` varchar(45) DEFAULT NULL, 

  `start_date` date DEFAULT NULL, 

  `end_date` date DEFAULT NULL, 

  `order_note` longtext, 

  `gst_amount` double DEFAULT '0', 

  `tax_name` varchar(45) DEFAULT NULL, 

  `tax_gid` varchar(45) DEFAULT NULL, 

  `total_price` double(13,2) DEFAULT NULL, 

  `vessel_gid` varchar(45) DEFAULT NULL, 

  `vessel_name` varchar(45) DEFAULT NULL, 

  `salesperson_gid` varchar(45) DEFAULT NULL, 

  `costcenter_gid` varchar(64) DEFAULT NULL, 

  `quotation_gid` varchar(64) DEFAULT NULL, 

  `roundoff` float(13,2) DEFAULT NULL, 

  `progressive_flag` varchar(45) DEFAULT 'N', 

  `advanceamount_bank` float(13,2) NOT NULL DEFAULT '0.00', 

  `advancewhtbase_currency` float(13,2) NOT NULL DEFAULT '0.00', 

  `freight_charges` float(13,2) DEFAULT '0.00', 

  `buyback_charges` float(13,2) DEFAULT '0.00', 

  `packing_charges` float(13,2) DEFAULT '0.00', 

  `insurance_charges` float(13,2) DEFAULT '0.00', 

  `mawb_no` varchar(64) DEFAULT NULL, 

  `hawb_no` varchar(64) DEFAULT NULL, 

  `invoice_no` varchar(64) DEFAULT NULL, 

  `sb_no` varchar(64) DEFAULT NULL, 

  `flight_no` varchar(64) DEFAULT NULL, 

  `pkgs` varchar(64) DEFAULT NULL, 

  `gr_wt` varchar(64) DEFAULT NULL, 

  `ch_wt` varchar(64) DEFAULT NULL, 

  `igm_no` varchar(64) DEFAULT NULL, 

  `igm_date` datetime DEFAULT NULL, 

  `assesable_amount` varchar(64) DEFAULT NULL, 

  `cbm` varchar(64) DEFAULT NULL, 

  `lfrom` varchar(64) DEFAULT NULL, 

  `lto` varchar(64) DEFAULT NULL, 

  `be_date` datetime DEFAULT NULL, 

  `dutyamount` varchar(64) DEFAULT NULL, 

  `mawb_date` datetime DEFAULT NULL, 

  `hawb_date` datetime DEFAULT NULL, 

  `businessunit_gid` varchar(64) DEFAULT NULL, 

  `customerref_no` varchar(256) DEFAULT NULL, 

  `supplier_name` varchar(512) DEFAULT NULL, 

  `supplier_address` text, 

  `buyer_name` text, 

  `buyer_address` text, 

  `buy_email` varchar(45) DEFAULT NULL, 

  `buy_mobile` varchar(45) DEFAULT NULL, 

  `airline_charges` varchar(45) DEFAULT NULL, 

  `agent_name` varchar(512) DEFAULT NULL, 

  `agent_email` varchar(45) DEFAULT NULL, 

  `agent_address` longtext, 

  `agent_iata` varchar(45) DEFAULT NULL, 

  `agent_mobile` varchar(45) DEFAULT NULL, 

  `agent_country` varchar(45) DEFAULT NULL, 

  `description` text, 

  `others` text, 

  `flight_date` datetime DEFAULT NULL, 

  `businessunit_name` varchar(45) DEFAULT NULL, 

  `consignee_to` varchar(128) DEFAULT NULL, 

  `branch_name` varchar(128) DEFAULT NULL, 

  `buyer_gid` varchar(45) DEFAULT NULL, 

  `supplier_gid` varchar(45) DEFAULT NULL, 

  `agent_gid` varchar(45) DEFAULT NULL, 

  `direct_shipment` char(2) DEFAULT 'Y', 

  `agent_charges` varchar(45) DEFAULT NULL, 

  `profit` double(13,2) DEFAULT '0.00', 

  `jc_flag` char(1) DEFAULT 'N', 

  `jcinprogress_flag` char(1) DEFAULT 'N', 

  `production_request` double DEFAULT '0', 

  `shipper_address` text, 

  `consignee_address` text, 

  `joborder_date` varchar(45) DEFAULT NULL, 

  `freighttax_gid` varchar(128) DEFAULT NULL, 

  `freighttax_amount` varchar(128) DEFAULT NULL, 

  `technician_name` varchar(128) DEFAULT NULL, 

  `customerpo_date` date DEFAULT NULL, 

  `customerpo_no` varchar(128) DEFAULT NULL, 

  PRIMARY KEY (`productionorder_gid`), 

  KEY `Index_2` (`branch_gid`,`customer_gid`), 

  KEY `Index_3` (`tax_gid`), 

  KEY `id_currency_gid` (`currency_gid`), 

  KEY `id_salesperson_gid` (`salesperson_gid`), 

  KEY `id_quotation_gid` (`quotation_gid`) 

) ; 

 

 

 

CREATE TABLE `pdc_trn_tproductionorderdtl` ( 

  `productionorderdtl_gid` varchar(64) NOT NULL, 

  `productionorder_gid` varchar(64) NOT NULL, 

  `product_gid` varchar(64) DEFAULT NULL, 

  `productgroup_gid` varchar(64) DEFAULT NULL, 

  `productgroup_name` varchar(512) DEFAULT NULL, 

  `product_name` varchar(3064) DEFAULT NULL, 

  `product_price` float(13,2) DEFAULT '0.00', 

  `qty_quoted` float(13,2) DEFAULT '0.00', 

  `discount_percentage` float(13,2) DEFAULT '0.00', 

  `discount_amount` float(13,2) DEFAULT '0.00', 

  `tax_percentage` float(13,2) DEFAULT '0.00', 

  `tax_amount` float(13,2) DEFAULT '0.00', 

  `product_remarks` longtext, 

  `uom_gid` varchar(64) DEFAULT NULL, 

  `uom_name` varchar(45) DEFAULT NULL, 

  `payment_days` int(10) unsigned DEFAULT '0', 

  `delivery_period` int(10) unsigned DEFAULT '0', 

  `price` float(13,2) DEFAULT '0.00', 

  `display_field` text, 

  `tax_name` varchar(45) DEFAULT NULL, 

  `tax_name2` varchar(45) DEFAULT NULL, 

  `tax_name3` varchar(45) DEFAULT NULL, 

  `tax_percentage2` float(13,2) DEFAULT '0.00', 

  `tax_percentage3` float(13,2) DEFAULT '0.00', 

  `tax_amount2` float(13,2) DEFAULT '0.00', 

  `tax_amount3` float(13,2) DEFAULT '0.00', 

  `salesorder_refno` varchar(65) DEFAULT NULL, 

  `product_delivered` int(10) unsigned DEFAULT '0', 

  `qty_executed` int(10) unsigned DEFAULT '0', 

  `tax_amount_l` double(13,2) DEFAULT '0.00', 

  `tax_amount2_l` double(13,2) DEFAULT '0.00', 

  `tax_amount3_l` double(13,2) DEFAULT '0.00', 

  `discount_amount_l` double(13,2) DEFAULT '0.00', 

  `product_price_l` double(13,2) DEFAULT '0.00', 

  `price_l` double(13,2) DEFAULT '0.00', 

  `tax1_gid` varchar(45) DEFAULT NULL, 

  `tax2_gid` varchar(45) DEFAULT NULL, 

  `tax3_gid` varchar(45) DEFAULT NULL, 

  `margin_percentage` float DEFAULT '0', 

  `margin_price` float DEFAULT '0', 

  `margin_amount` float(13,2) DEFAULT '0.00', 

  `selling_price` float(13,2) DEFAULT '0.00', 

  `vendor_gid` varchar(64) DEFAULT NULL, 

  `slno` int(11) DEFAULT NULL, 

  `againstpo_flag` char(1) DEFAULT 'N', 

  `vendor_price` varchar(45) DEFAULT NULL, 

  `product_requireddate` date DEFAULT NULL, 

  `type` varchar(45) DEFAULT NULL, 

  `gst_flag` varchar(6) DEFAULT NULL, 

  `delivery_quantity` float(13,2) DEFAULT '0.00', 

  `customerproduct_code` varchar(64) 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_requireddateremarks` longtext, 

  `currency_gid` varchar(45) DEFAULT NULL, 

  `mrp` double DEFAULT NULL, 

  `foreign_currency` varchar(45) DEFAULT NULL, 

  `foreign_amount` double DEFAULT NULL, 

  `exchange_rate` double DEFAULT NULL, 

  `product_code` varchar(45) DEFAULT NULL, 

  `jc_qty` float(13,2) DEFAULT '0.00', 

  `production_flag` char(1) DEFAULT 'N', 

  `order_type` varchar(64) DEFAULT NULL, 

  `production_request` double DEFAULT '0', 

  `production_complted` double DEFAULT '0', 

  PRIMARY KEY (`productionorderdtl_gid`), 

  KEY `Index_2` (`productionorder_gid`,`product_gid`,`productgroup_gid`,`uom_gid`), 

  KEY `id_tax1gid` (`tax1_gid`), 

  KEY `id_tax2gid` (`tax2_gid`), 

  KEY `id_tax3gid` (`tax3_gid`) 

) ; 

 

alter table pdc_trn_tbom add column  productgroup_name varchar(64) default null; 

 

INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES 

 ('SSQM2404290507','PDCD','Production Dtl','4','41','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL) 

INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES  

('SSQM2404290506','PDCM','Production ','4','41','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL); 

INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES 

 ('SSQM24042905001','PDCSO','sales Production ','4','41','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL); 

 

INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`)  

VALUES ('SERM20240429001','PDC_SUC_100','Production Order added successfully!','SUCCESS',NULL,NULL,NULL,NULL); 

 

alter table  pdc_trn_tjobcard add column productionorderdtl_gid varchar(64) NOT NULL; 

 

 

CREATE TABLE `pdc_trn_tproductionjob` ( 

  `productjob_gid` varchar(128) NOT NULL, 

  `productbom_gid` varchar(64) DEFAULT NULL, 

  `product_gid` varchar(64) DEFAULT NULL, 

  `product_name` varchar(3064) DEFAULT NULL, 

  `product_code` varchar(128) DEFAULT NULL, 

  `productionorderdtl_gid` varchar(128) DEFAULT NULL, 

  `productionorder_gid` varchar(128) DEFAULT NULL, 

  `uom_gid` varchar(64) DEFAULT NULL, 

  `uom_name` varchar(64) DEFAULT NULL, 

  `qty_requested` varchar(128) DEFAULT NULL, 

  `product_price` float(13,2) DEFAULT '0.00', 

  `display_field` longtext, 

  `additional_qty` float(13,2) DEFAULT '0.00', 

  `subtract_qty` float(13,2) DEFAULT '0.00', 

  `created_by` varchar(64) DEFAULT NULL, 

  `updated_by` varchar(64) DEFAULT NULL, 

  `created_date` datetime DEFAULT NULL, 

  `updated_date` datetime DEFAULT NULL, 

  `productgroup_name` varchar(64) DEFAULT NULL, 

  PRIMARY KEY (`productjob_gid`) 

) ; 

 

 

INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES 

('SSQM2404300507','PJOB','Productionjob','4','41','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL); 

 

INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`)  

VALUES ('SERM20240430001','PDC_SUC_1001','Product BOM Raised successfully!','SUCCESS',NULL,NULL,NULL,NULL); 

 

alter table pdc_tmp_trawmaterial add column bomserial_no varchar(64) default null; 

alter table pdc_trn_tbom add column bomserial_no varchar(64) default null; 

alter table pdc_trn_tproductionjob add column bomserial_no varchar(64) default null; 

alter table pdc_trn_tjobcard add column  productionorderdtl_gid varchar(64) DEFAULT NULL ; 

alter table pdc_trn_tjobcard add column  productionorder_gid varchar(64) DEFAULT NULL ; 

 

 

insert into adm_mst_tmodule (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, icon_name) 

 

values('PDCPDCJCD', 'PDCPDC', 'PDCPDCJCD', '1705', 'ems_pdc/pdc_trn_jobcardispatch.aspx', '3', NULL, 'Job Card Dispatch', '1', '', '', '', 'Job Card Dispatch', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL); 

 

alter table pdc_trn_tbom add column  productrawmaterial_gid varchar(64) default null; 

alter table pdc_tmp_trawmaterial add column  productrawmaterial_gid varchar(64) default null; 

alter table  pdc_trn_tproductionorderdtl add column `jobcardcompleted_flag` char(1) DEFAULT 'N'; 

alter table pdc_trn_tproductdispatch add column  productionorder_gid varchar(64) default null; 

alter table pdc_trn_tproductdispatch add column  productionorderdtl_gid varchar(64) default null; 

alter table  pdc_trn_tproductionorder add column `production_flag` char(1) DEFAULT 'N'; 

UPDATE `mootek`.`adm_mst_tcompany` SET `reseller_company` = 'Vcidex Solutions Pvt Ltd' WHERE (`company_gid` = '1'); 

 

 

alter table crm_mst_tcustomer add column source_gid varchar(255); 

 

 

insert into adm_mst_tmodule (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, icon_name 

) values ('SMRMSTSRC', 'SMRMST', 'SMRMSTSRC', '1202', 'ems_crm/crm_mst_sourcesummary.aspx', '3', NULL, 'Source', '1', '../images/ico_customer_RS.gif', 'MASTERS', '', 'Source', '', '', '', 'N', 'N', NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL 

); 

 

----------------------------------------- 

 

INSERT INTO `adm_mst_tmodule` (`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`,`icon_name`) VALUES  

('PDCORTPOR','PDCORT','PDCORTPOR',1116,'ems_pdc/pdc_rpt_productionorderreport.aspx',3,NULL,'Production Order Report','1','','REPORT','','Production Order Report','','','','N','N',NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL); 

 

 

`INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES 
('SSQM2405090507','PMOB','Productjob','4','41','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL); 

  

alter table pdc_trn_tproductionjob add column  productionbom_gid varchar(64) default null; 

  

alter table pdc_trn_tproductionorderdtl add column bom_flag varchar(10) default 'N'; 

 

INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('AMS20142024001','IMS_SUC_0181','Direct Material Issued successfully','SUCCESS',NULL,NULL,NULL,NULL); 

  

Alter table  smr_tmp_tsalesorderdtl Add column `productserial_no` varchar(128) DEFAULT NULL; 

Alter table  pdc_trn_tproductionorderdtl Add column `productserial_no` varchar(128) DEFAULT NULL; 

alter table ims_trn_tmaterialissued add column location_gid varchar(16) default null; 

  

  

  

CREATE TABLE `pmr_trn_ttype` ( 

  

  `type_gid` varchar(64) NOT NULL, 

  

  `type_code` varchar(32) DEFAULT NULL, 

  

  `type_name` varchar(64) DEFAULT NULL, 

  

  `created_by` varchar(64) DEFAULT NULL, 

  

  `created_date` datetime DEFAULT NULL, 

  

  `updated_by` varchar(64) DEFAULT NULL, 

  

  `updated_date` datetime DEFAULT NULL, 

  

  PRIMARY KEY (`type_gid`) 

  

); 

  

alter table pmr_trn_tpurchaseorder add column type_gid varchar(128) DEFAULT NULL; 

  

alter table acp_mst_tvendor add column `vendorgst_number` varchar(64) DEFAULT NULL; 

 

--------------------------------------------------------------------------------------------------------------------------- 

 

CREATE TABLE `pdc_tmp_trawmaterial` ( 

 

  `bomdtl_gid` varchar(64) NOT NULL, 

 

  `bomtmp_gid` varchar(64) NOT NULL, 

 

  `product_gid` varchar(64) DEFAULT NULL, 

 

  `product_name` varchar(3064) DEFAULT NULL, 

 

  `product_code` varchar(128) DEFAULT NULL, 

 

  `uom_gid` varchar(64) DEFAULT NULL, 

 

  `uom_name` varchar(64) DEFAULT NULL, 

 

  `qty_requested` varchar(128) DEFAULT NULL, 

 

  `product_price` float(13,2) DEFAULT '0.00', 

 

  `display_field` longtext, 

 

  `created_by` varchar(64) DEFAULT NULL, 

 

  `updated_by` varchar(64) DEFAULT NULL, 

 

  `created_date` datetime DEFAULT NULL, 

 

  `updated_date` datetime DEFAULT NULL, 

 

  `productgroup_name` varchar(3064) DEFAULT NULL, 

 

  `bomserial_no` varchar(64) DEFAULT NULL, 

 

  `productrawmaterial_gid` varchar(64) DEFAULT NULL, 

 

  PRIMARY KEY (`bomdtl_gid`) 

 

) ; 

 

 

INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`)  

VALUES ('DTLBOM2404270000','DTLBOM','ProductdtlBom','4','200','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL);