No fonte NFESEFAZ faça esse teste
BeginSql Alias cAliasSD2
SELECT D2_FILIAL,D2_SERIE,D2_DOC,D2_CLIENTE,D2_LOJA,D2_COD,D2_TES,D2_NFORI,D2_SERIORI,D2_ITEMORI,D2_TIPO,D2_ITEM,D2_CF,
D2_QUANT,D2_TOTAL,D2_DESCON,D2_VALFRE,D2_SEGURO,D2_PEDIDO,D2_ITEMPV,D2_DESPESA,D2_VALBRUT,D2_VALISS,D2_PRUNIT,
D2_CLASFIS,D2_PRCVEN,D2_IDENTB6,D2_CODISS,D2_DESCZFR,D2_PREEMB,D2_DESCZFC,D2_DESCZFP,D2_LOTECTL,D2_NUMLOTE,D2_ICMSRET,D2_VALPS3,
D2_ORIGLAN,D2_VALCF3,D2_VALIPI,D2_VALACRS %Exp:cField%
FROM %Table:SD2% SD2
WHERE
SD2.D2_FILIAL = %xFilial:SD2% AND
SD2.D2_SERIE = %Exp:SF2->F2_SERIE% AND
SD2.D2_DOC = %Exp:SF2->F2_DOC% AND
SD2.D2_CLIENTE = %Exp:SF2->F2_CLIENTE% AND
SD2.D2_LOJA = %Exp:SF2->F2_LOJA% AND
SD2.%NotDel%
ORDER BY D2_FILIAL,D2_DOC,D2_SERIE,D2_CLIENTE,D2_LOJA,D2_COD
//,D2_ITEM
Fórum