Mostrando postagens com marcador TGFITE_EXC. Mostrar todas as postagens
Mostrando postagens com marcador TGFITE_EXC. Mostrar todas as postagens

terça-feira, 3 de abril de 2018

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