>
> select N.DTEMISSAONOTA as DATA,
>        'DINHEIRO' as MEIO_PAGAMENTO1,
>        cast('DINHEIRO' as char(10)) as MEIO_PAGAMENTO2,
>        '000000' as MEIO_PAGAMENTO,
>        N.VLRTOTALNOTA as VALOR,
>        0 as AUTENT_01,
>        0 as AUTENT_01_CALC,
>        N.AUTENTICACAO_NOTA as AUTENT_02,
>        3 as TIPO
> from NOTA N
> where (N.EMPRESANOTA = 1)
>   and (N.DTEMISSAONOTA between '05/11/2018' and '04/11/2018')
>   and (N.MODELONOTA = '55')
> order by 1, 2