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;