Triggers

TR_FINANCIERA_AD0

Description

(There is no description for trigger TR_FINANCIERA_AD0)

Definition

CREATE TRIGGER TR_FINANCIERA_AD0 FOR TR_FINANCIERA
ACTIVE AFTER DELETE POSITION 0
AS
DECLARE VARIABLE es_bloqueado CHAR (1);
BEGIN


  SELECT bloqueado
  FROM comprobantes
  WHERE tipo = OLD.tipo AND
        prefijo = OLD.prefijo AND
        numero = OLD.numero
  INTO :es_bloqueado;

  IF (es_bloqueado = 'R') THEN
    INSERT INTO log_financiera (tipo, prefijo, numero, renglon, codcentro, codbanco, codbanco_destino, codconciliacion, conciliado, monto, documento, nota, codusuario, fecha, accion)
    VALUES (OLD.tipo, OLD.prefijo, OLD.numero, OLD.renglon, OLD.codcentro, OLD.codbanco, OLD.codbanco_destino, OLD.codconciliacion, OLD.conciliado, OLD.monto, OLD.documento, OLD.nota, OLD.codusuario, 'NOW', 'BORRADO');

END