Triggers

COMOVI_AD99

Description

(There is no description for trigger COMOVI_AD99)

Definition

CREATE TRIGGER COMOVI_AD99 FOR COMOVI
ACTIVE AFTER DELETE POSITION 99
AS
BEGIN
  INSERT INTO log_comovi (
    tipo,
    prefijo,
    numero,
    renglon,
    debito,
    credito,
    base,
    nota,
    validacion,
    codcuenta,
    codtercero,
    codcentro,
    codactivo,
    codpersonal,
    codconciliacion,
    conciliado,
    tiporef,
    prefijoref,
    numeroref,
    codusuario,
    fecha,
    accion)
  VALUES (
    OLD.tipo,
    OLD.prefijo,
    OLD.numero,
    OLD.renglon,
    OLD.debito,
    OLD.credito,
    OLD.base,
    OLD.nota,
    OLD.validacion,
    OLD.codcuenta,
    OLD.codtercero,
    OLD.codcentro,
    OLD.codactivo,
    OLD.codpersonal,
    OLD.codconciliacion,
    OLD.conciliado,
    OLD.tiporef,
    OLD.prefijoref,
    OLD.numeroref,
    OLD.codusuario,
    'NOW',
    'BORRADO');
END