Skip to content

Instantly share code, notes, and snippets.

@AndyDaSilva52
Last active July 23, 2019 23:05
Show Gist options
  • Save AndyDaSilva52/88d874acd49b0dfc9b2ded3020890dff to your computer and use it in GitHub Desktop.
Save AndyDaSilva52/88d874acd49b0dfc9b2ded3020890dff to your computer and use it in GitHub Desktop.
MGTRF (Nota Fiscal Autorizada) vs MGVEN (Nota Fiscal Cancelada/Inutilizada)
SELECT
a.fil_in_codigo,
a.not_in_numero,
a.ser_st_codigo,
a.not_dt_emissao,
a.not_ch_situacaonfe,
b.mds_bo_cancelado,
b.mds_ch_situacaonota,
a.acaom_in_sequencia
FROM
mgven.ven_notafiscal a,
mgtrf.trf_movdocfis_s b,
mgglo.glo_acaomovimento m
WHERE
a.acaom_in_sequencia = b.acaom_in_sequencia
AND a.acaom_in_sequencia = m.acaom_in_sequencia
AND a.not_ch_situacaonfe IN ('CC', 'II')
AND (b.mds_bo_cancelado <> 'S' OR a.not_ch_situacaonfe <> b.mds_ch_situacaonota)
AND (m.acaom_re_valorfiscal = m.acaom_re_valorfiscalreal)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment