Contabilidad SQL

--Trigger para entradas
DELIMITER $$
CREATE TRIGGER pepsinvent AFTER INSERT
ON products FOR EACH ROW
BEGIN
DECLARE tot varchar(200);
SET tot=(new.qty)*(new.price);
INSERT INTO peps VALUES(CURRENT_TIMESTAMP(),'Compra',new.qty,new.price,tot,NULL,NULL,NULL,NULL,NULL,NULL);
END;

qty  -> Cantidad_v
rate -> Precio_uni_v
amount -> Total_v

--Trigger para entradas
DELIMITER $$
CREATE TRIGGER pepsVenta AFTER INSERT
ON orders_item FOR EACH ROW
BEGIN
INSERT INTO peps VALUES(CURRENT_TIMESTAMP(),'Venta',NULL,NULL,NULL,new.qty,new.rate,new.amount,NULL,NULL,NULL);
END;