Wiki DataEvo

Restaurar a nota excluída para o portal novamente:

INSERT INTO TGFCAB (
NUNOTA, NUMNOTA, DTNEG,VLRNOTA, TIPMOV, CODPARC, CODVEND, CODEMP, CODCENCUS,
SERIENOTA,DTFATUR, DTENTSAI,DTMOV,HRMOV, CODEMPNEGOC, CODTIPOPER,DHTIPOPER,CODTIPVENDA,
DHTIPVENDA,VLRSEG, VLRDESTAQUE,VLRJURO, VLRDESCTOT, VLRDESCTOTITEM, VLRFRETE,ICMSFRETE, 
BASEICMSFRETE, TIPFRETE, CIF_FOB, CODPARCTRANSP, QTDVOL, PENDENTE, BASEICMS, VLRICMS, BASEIPI,
VLRIPI,ISSRETIDO,APROVADO,STATUSNOTA, DTALTER, VLRSUBST, BASESUBSTIT, CODNAT, CODUSU, DANFE,
CHAVENFE, NULOTENFE, STATUSNFE, TPAMBNFE, TPEMISNFE)
(
SELECT NUNOTA, NUMNOTA, DTNEG,VLRNOTA, TIPMOV, CODPARC, CODVEND, CODEMP, CODCENCUS,
SERIENOTA,DTFATUR, DTENTSAI,DTMOV,HRMOV, CODEMPNEGOC, CODTIPOPER,DHTIPOPER,CODTIPVENDA,
DHTIPVENDA,VLRSEG, VLRDESTAQUE,VLRJURO, VLRDESCTOT, VLRDESCTOTITEM, VLRFRETE,ICMSFRETE, 
BASEICMSFRETE, TIPFRETE, CIF_FOB, CODPARCTRANSP, QTDVOL, PENDENTE, BASEICMS, VLRICMS, BASEIPI,
VLRIPI,ISSRETIDO,APROVADO,STATUSNOTA, DTALTER, VLRSUBST, BASESUBSTIT, CODNAT, CODUSU, DANFE,
CHAVENFE, NULOTENFE, STATUSNFE, TPAMBNFE, TPEMISNFE
FROM TGFCAB_EXC WHERE NUNOTA=178434
)

Restaurar os ítens de uma nota excluída:

INSERT INTO TGFITE (
NUNOTA, SEQUENCIA,NUTAB, CODEMP,CODPROD, CODLOCALORIG, CONTROLE, 
USOPROD, CODCFO, QTDNEG,QTDENTREGUE, QTDCONFERIDA, VLRUNIT, VLRTOT, VLRCUS,
BASEIPI, VLRIPI, ALIQIPI, BASEICMS, ALIQICMS, VLRICMS, VLRDESC, BASESUBSTIT, 
VLRSUBST, PENDENTE,CODVOL, CODTRIB, ATUALESTOQUE, OBSERVACAO, RESERVA,
STATUSNOTA, CODVEND)
(SELECT NUNOTA, SEQUENCIA,NUTAB, CODEMP,CODPROD, CODLOCALORIG, CONTROLE, 
USOPROD, CODCFO, QTDNEG,QTDENTREGUE, QTDCONFERIDA, VLRUNIT, VLRTOT, VLRCUS,
BASEIPI, VLRIPI, ALIQIPI, BASEICMS, ALIQICMS, VLRICMS, VLRDESC, BASESUBSTIT, 
VLRSUBST, PENDENTE,CODVOL, CODTRIB, ATUALESTOQUE, OBSERVACAO, RESERVA,
STATUSNOTA, CODVEND
FROM TGFITE_EXC WHERE NUNOTA=178434
)



Fonte: Anderson Santos