-- 28-Sep-2021 Gautam : parameter table variable add-- INSERT INTO `parameter` (`id`, `module`, `name`, `value`, `remark`, `customer_access`, `input_type`, `options`) VALUES (NULL, 'Pharmacy', 'ph_is_credit_for_only_cashless', 'N', 'if set to Y considered credit bill only available for insurance patient', 'N', '', ''); -- 28-Sep-2021 Gautam : parameter table variable update-- UPDATE `parameter` SET `name` = 'PH_IS_CREDIT_BILL_FOR_ONLY_CASHLESS' WHERE `parameter`.`name` = 'ph_is_credit_bill_for_only_cashless';