select * from prevclicad


select  * from pediclicad where numped ='23408'

select cfo, * from nfsaidacad  where dtemis ='20071017'


select cfo , * from ITNFSAICAD where numnota ='000696'

select * from itemfilest where codpro in ('50605','50606','50735','50754','50611','00007')
 and filial  in ('01','02')


select * from nfentracad where numped


select * from itemclicad where numped ='23408'