CREATE OR REPLACE TRIGGER TRI_BEFORE_INSERT_BIS_ACC_DTL before INSERT ON BIS_ACC_DTL FOR EACH row BEGIN IF :NEW.BIF_CODE = '' THEN :NEW.VOUCHER_NO := :NEW.BANK_SERIAL_NO; END IF; END TRI_BEFORE_INSERT_BIS_ACC_DTL;