IF EXISTS
(
    SELECT 1
    FROM SYS.VIEWS
    WHERE NAME = 'V_RC_MDL_VENDA_TENTACLE'
)
    BEGIN
        DROP VIEW V_RC_MDL_VENDA_TENTACLE;
    END;
GO
CREATE VIEW V_RC_MDL_VENDA_TENTACLE
AS
     SELECT CD_EMP,
            CD_MDL_VD,
            DS_MDL_VD,
            STS_MDL_VD,
            TIPO_MDL_VD,
            VLR_MIN_PARC,
            TP_VENCTO,
            DIA_VENCTO,
			DIA_FECHA,
            QTDE_MAX_PARC_VD,
            TP_FECHA,
            FLAG_SOMENTE_DESC_CONTRATO,
            DIAS_CAREN_ATRASO,
            PERC_JUROS_MULTA,
            PERC_JUROS_ATRASO,
            PERC_DESC_PONTUAL,
            TP_PERC_DESC
     FROM RC_MDL_VENDA;