![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
THE following trigger can be used for RAAK-TRANS-DETAIL CREATE OR REPLACE TRIGGER "RAAK-TRANS-DETAIL-BI" BEFORE
INSERT OR UPDATE on "RAAK-TRANS-DETAIL" for each row
begin
if :NEW,"RECORD-ID" IS NULL THEN
:NEW,"RECORD-ID" := RECORD-ID-SEQ,NExTVAL ; END IF;
end;
The following trigger will be created for balance-sheet table.
CREATE OR REPLACE TRIGGER "BI-BALANCE-SHEET" before insert on "BALANCE-SHEET"
for each row
begin
if :NEW."RECORD-ID" is null then
select "RECORD-ID-SEQ".nextval into :NEW."REC-ID" from dual;
end if;
end;
Trigger for Profit-loss table: