25/09/2024--Praveen S

alter table rbl_trn_tinvoice add column Verify_flag varchar(64) default 'Y';

INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SERM202406020083','CRM_SUC_0281','Order Remove successfully ! ','SUCCESS',NULL,NULL,NULL,NULL);

alter table rbl_trn_tinvoice add column courier_flag varchar(64) default 'Y';



INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('SERM2024060200812','CRM_SUC_0291','Pending Order Cansel successfully! ','SUCCESS',NULL,NULL,NULL,NULL);

alter table cor_trn_tcourierorder add column dc_no varchar(64) default Null;
 alter table adm_mst_tcompany add column  purchasetoinvoiceflow_flag varchar(3) DEFAULT 'Y';
 alter table acp_trn_tinvoice add column  pblinvoice_type varchar(3) DEFAULT 'Y';

alter table pbl_trn_tserviceorder add column  vendorref_no varchar(64) default null;

25/09/2024--Pradeep

drop view hrm_trn_manualregulation_v;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `hrm_trn_manualregulation_v` AS (select `x`.`employee_gid` AS `employee_gid`,`x`.`shift_date` AS `shift_date`,(case when ((`x`.`attendance_type` = 'XA') and (`x`.`login_time` is not null) and isnull(`x`.`logout_time`) and (`x`.`halfdayabsent_flag` = 'Y')) then 'XA' when ((`x`.`attendance_type` = 'AX') and isnull(`x`.`login_time`) and (`x`.`logout_time` is not null) and (`x`.`halfdayabsent_flag` = 'Y')) then 'AX' when ((`x`.`attendance_type` = 'P') and (`x`.`login_time` is not null) and (`x`.`logout_time` is not null)) then 'XX' when (`x`.`attendance_type` = 'A') then 'AA' when (`x`.`attendance_type` = 'WH') then 'WH' when ((`x`.`attendance_type` = 'XL') or ((`x`.`login_time` is not null) and isnull(`x`.`logout_time`) and (`x`.`halfdayabsent_flag` = 'N'))) then 'XL' when ((`x`.`attendance_type` = 'LX') or (isnull(`x`.`login_time`) and (`x`.`logout_time` is not null) and (`x`.`halfdayabsent_flag` = 'N'))) then 'LX' when ((`x`.`attendance_type` = 'LA') and isnull(`x`.`login_time`) and isnull(`x`.`logout_time`) and (`x`.`halfdayabsent_flag` = 'Y')) then 'LA' when ((`x`.`attendance_type` = 'AL') and isnull(`x`.`login_time`) and isnull(`x`.`logout_time`) and (`x`.`halfdayabsent_flag` = 'Y')) then 'AL' when (`x`.`attendance_type` = 'OD') then 'OD' when (`x`.`attendance_type` = 'NH') then 'NH' when (`x`.`attendance_type` = 'FH') then 'FH' when (`x`.`attendance_type` = 'XD') then 'XD' when (`x`.`attendance_type` = 'DX') then 'DX' when (`x`.`attendance_type` = 'Maternity') then 'Maternity' end) AS `attendance` from `hrm_trn_tattendance` `x` order by `x`.`shift_date`,`x`.`employee_gid`)