SELECT
'0' || a.usrempresa as empresa,
strzero(A.USRID,7) as codigo,
C.ID as numerodunfe,
d.numero as notanfe,
d.numero as notafiscal
/*$$IBEC$$ A.ID as Nfe_TBNfes_ID,
A.Gid as Nfe_TBNfes_GID,
B.SERIE AS SERIE,
B.Numero AS NOTANFE,
C.ID AS NUMERODANFE,
A.* $$IBEC$$*/
FROM NFE_TBITEMSCONCLUIDOS A
INNER JOIN Nfe_Tbnfeside B ON A.Id = B.Gid
INNER JOIN Nfe_Tbnfes C ON C.GId = A.Id
inner join nfe_tbnfeside d on(d.gid = a.id)
WHERE A.USREMPRESA = '01'
--AND A.USRID = '0006978' // numero do pedido
AND A.Tipoitem = 1
and a.usrid < '900000000'
