create or replace trigger "AL_ITEM_UI" AFTER INSERT OR UPDATE on AL FOR EACH ROW BEGIN IF INSERTING THEN INSERT INTO ITEM ( itemid, itype, named, price, puom, suom, puomdes, suomdes, sources, component, supplier, parentid, section, inactive, notes, rcp_recalc, conratio, rtsb, currency, suom_convert, cost_method ) VALUES ( :NEW.ID , :NEW.itype , :NEW.NAME , :NEW.PRICE , :NEW.PUOM , :NEW.SUOM , :NEW.PUOMDES , :NEW.SUOMDES , :NEW.SOURCER , :NEW.COMPONENT , :NEW.SUPPLIER , :NEW.FROMID , :NEW.SECTIONC , :NEW.INACTIVE , :NEW.NOTES , :NEW.RCP_RECALC , :NEW.CONRATIO , :NEW.RTSB , :NEW.CURRENCY , :NEW.SUOMCONV , :NEW.COST_METHOD ); ELSIF UPDATING THEN UPDATE ITEM SET itype= :NEW.itype, named= :NEW.NAME, price= :NEW.PRICE, puom= :NEW.PUOM, suom= :NEW.SUOM, puomdes= :NEW.PUOMDES, suomdes= :NEW.SUOMDES, sources= :NEW.SOURCER, component= :NEW.COMPONENT, supplier= :NEW.SUPPLIER, parentid= :NEW.FROMID, section= :NEW.SECTIONC, inactive= :NEW.INACTIVE, notes= :NEW.NOTES, rcp_recalc= :NEW.RCP_RECALC, conratio = :NEW.CONRATIO, rtsb = :NEW.RTSB, currency= :NEW.CURRENCY, cost_method=:NEW.COST_METHOD ; END IF; END;