⬅ Back DELETE MULTI TYPES IN MODULE.txt
-------------------------------PURCHASE RETURN
delete from FINISHED_RETURN_ACCOUNT_TYPES
INSERT INTO FINISHED_RETURN_ACCOUNT_TYPES VALUES('FRTNA/C')
UPDATE FINISHED_PURCHASE_RETURN_GOODS_DETAIL SET PurRtnType='FRTNA/C'

DELETE FROM GREY_RETURN_ACCOUNT_TYPES 
INSERT INTO GREY_RETURN_ACCOUNT_TYPES VALUES('GRTNA/C')
UPDATE GREY_PURCHASE_RETURN_GOODS_DETAIL SET PurRtnType='GRTNA/C'
-------------------------------PURCHASE
DELETE FROM FINISHED_PURCHASE_ACCOUNT_TYPES
INSERT INTO FINISHED_PURCHASE_ACCOUNT_TYPES VALUES('FPURA/C')
UPDATE FINISHED_PURCHASE SET PurType='FPURA/C'

DELETE FROM GREY_PURCHASE_ACCOUNT_TYPES
INSERT INTO GREY_PURCHASE_ACCOUNT_TYPES VALUES('GPURA/C')
UPDATE GREY_PURCHASE SET PurType='GPURA/C'