⬅ Back SUMITRA CREATION 2-12-2022.sql
use T23S001

UPDATE FINISHED_ITEM_MASTER SET ITEMPER='P' WHERE ITEMPER='PCS'
UPDATE FINISHED_ITEM_MASTER SET ITEMPER='P' WHERE ITEMPER='PKT'
UPDATE FINISHED_ITEM_MASTER SET ITEMPER='M' WHERE ITEMPER='MTS'
UPDATE FINISHED_ITEM_MASTER SET ITEMPER='M' WHERE ITEMPER='MTR'
UPDATE FINISHED_ITEM_MASTER SET ITEMPER='M' WHERE ITEMPER='LTR'
UPDATE FINISHED_ITEM_MASTER SET ITEMPER='P' WHERE ITEMPER=''




USE COMMON

UPDATE account_master SET COMPSCHEME='NO' WHERE COMPSCHEME=''