[firebase-br] Calculo Juros...

[ibestvip]

eu uso com um campo calculado.

Veja se ajuda.


    VLRJUROS         COMPUTED BY (CASE
WHEN (PAGO='N') THEN
CAST((VALOR-TOTALPAGO)*JUROS*DIASATRASO/100/30 AS NUMERIC(15,2))
WHEN (PAGO='S')THEN
0
END),
    JUROSCOBRADO     COMPUTED BY (CAST((VALOR)*JUROS*DIASATRASO/100/30 AS 
NUMERIC(15,2))),
    SALDO            COMPUTED BY (CASE
WHEN (PAGO='N')  THEN
CAST(VALOR+VLRJUROS+DESPESAS_EXTRAS-(DESCONTO+TOTALPAGO) AS NUMERIC(15,2))
WHEN (PAGO='S')THEN
0
END)
);