select numord, * from nfsaidacad where numnota = '000047'
select * from DADOSITEMNFE where NUMORD=157594
select * from dadoscobrancanfe where NUMORD=157594
select * from DADOSTRANSPORTENFE where NUMORD=157594
select XLGRD, NROD, XCPLD, * from DADOSNOTANFE where NUMORD=157594
select * from INCONSISTENCIANFE where NUMORD=157594
select * from HISTORICONFE where NUMORD=157594
select * from COMPLEMENTONFSAIDA where NUMORD=157594
select * from FILANFE where NUMORD=157594
select * from FILARETORNONFE where NUMORD=157594

select numord, * from nfentracad where numnota = '001903'