Tabela CZ4 no Protheus

SELECT
    CZ4_FILIAL,
    CZ4_DTRE,
    CZ4_HRRE,
    CZ4_CDES,
    CZ4_CDARPO,
    CZ4_CDCETR,
    CZ4_CDMQ,
    CZ4_LGDIEX,
    CZ4_LGPNRF,
    CZ4_LGSPEF,
    CZ4_LGSUEF,
    CZ4_CDTN,
    CZ4_NRMH,
    CZ4_NRWK,
    CZ4_CDUNVM,
    CZ4_QTRPRY,
    CZ4_QTRFPL,
    CZ4_VLRFPL,
    CZ4_VLRFRY,
    CZ4_VLPNRF,
    CZ4_QTRTPL,
    CZ4_VLRTPL,
    CZ4_QTRFRY,
    CZ4_VLRTRY,
    CZ4_VLPNRT,
    CZ4_NRSP,
    CZ4_QTSPPL,
    CZ4_QTSPRY,
    CZ4_QTSPAI,
    CZ4_QTPL,
    CZ4_QTPLAI,
    CZ4_QTSPTT,
    CZ4_VLPL,
    CZ4_VLAI,
    CZ4_NRTTRP,
    CZ4_QTSUPA,
    CZ4_QTATPA,
    CZ4_QTSURY,
    CZ4_QTATRY,
    CZ4_QTTEUT,
    CZ4_QTTEEX,
    CZ4_VLQL,
    CZ4_VLQLRY,
    CZ4_QTRPPL,
    CZ4_VLEF,
    CZ4_QTVMPL,
    CZ4_QTVMEV,
    CZ4_QTVMRY,
    CZ4_VLDIPL,
    CZ4_VLDIRY,
    CZ4_VLUT,
    CZ4_QTTELZ,
    CZ4_QTTESP,
    CZ4_VLSP,
    CZ4_VLOEE,
    CZ4_VLTEEP,
    CZ4_QTME,
    CZ4_QTMIX,
    CZ4_QTRTRY,
    CZ4_QTSQ,
    CZ4_QTTEME,
    CZ4_VLBTSM,
    CZ4_VLBTSS,
    CZ4_VLBTSV,
    CZ4_VLNEE,
    CZ4_VLTK,
    CZ4_QTVM,
    CZ4_VLBTS,
    CZ4_IDMEPO,
    CZ4_DTBGME,
    CZ4_DTEDME,
    CZ4_DTVF,
    CZ4_HRVF,
    CZ4_NRSPAI,
    CZ4_NRSPPL,
    CZ4_NRSPRY,
    CZ4_QTPLRY,
    CZ4_QTRP,
    CZ4_QTSPEF,
    CZ4_QTSPSU,
    CZ4_QTTERP,
    CZ4_QTTESU,
    CZ4_VLLZ,
    CZ4_VLSPEX,
    CZ4_VLSPUT
FROM CZ4
WHERE
    D_E_L_E_T_ = ' '
    AND CZ4_FILIAL = 'VALOR'
    AND CZ4_DTRE BETWEEN '20260401' AND '20260430'
    AND CZ4_HRRE = 'VALOR'
    AND CZ4_CDES = 'VALOR'
    AND CZ4_CDARPO = 'VALOR'
    AND CZ4_CDCETR = 'VALOR'
    AND CZ4_CDMQ = 'VALOR'
    AND CZ4_CDTN = 'VALOR'
    AND CZ4_NRMH = 'VALOR'
    AND CZ4_NRWK = 'VALOR'
    AND CZ4_CDUNVM = 'VALOR'
    AND CZ4_QTRPRY = 0
    AND CZ4_QTRFPL = 0
    AND CZ4_VLRFPL = 0
    AND CZ4_VLRFRY = 0
    AND CZ4_VLPNRF = 0
    AND CZ4_QTRTPL = 0
    AND CZ4_VLRTPL = 0
    AND CZ4_QTRFRY = 0
    AND CZ4_VLRTRY = 0
    AND CZ4_VLPNRT = 0
    AND CZ4_NRSP = 0
    AND CZ4_QTSPPL = 0
    AND CZ4_QTSPRY = 0
    AND CZ4_QTSPAI = 0
    AND CZ4_QTPL = 0
    AND CZ4_QTPLAI = 0
    AND CZ4_QTSPTT = 0
    AND CZ4_VLPL = 0
    AND CZ4_VLAI = 0
    AND CZ4_NRTTRP = 0
    AND CZ4_QTSUPA = 0
    AND CZ4_QTATPA = 0
    AND CZ4_QTSURY = 0
    AND CZ4_QTATRY = 0
    AND CZ4_QTTEUT = 0
    AND CZ4_QTTEEX = 0
    AND CZ4_VLQL = 0
    AND CZ4_VLQLRY = 0
    AND CZ4_QTRPPL = 0
    AND CZ4_VLEF = 0
    AND CZ4_QTVMPL = 0
    AND CZ4_QTVMEV = 0
    AND CZ4_QTVMRY = 0
    AND CZ4_VLDIPL = 0
    AND CZ4_VLDIRY = 0
    AND CZ4_VLUT = 0
    AND CZ4_QTTELZ = 0
    AND CZ4_QTTESP = 0
    AND CZ4_VLSP = 0
    AND CZ4_VLOEE = 0
    AND CZ4_VLTEEP = 0
    AND CZ4_QTME = 0
    AND CZ4_QTMIX = 0
    AND CZ4_QTRTRY = 0
    AND CZ4_QTSQ = 0
    AND CZ4_QTTEME = 0
    AND CZ4_VLBTSM = 0
    AND CZ4_VLBTSS = 0
    AND CZ4_VLBTSV = 0
    AND CZ4_VLNEE = 0
    AND CZ4_VLTK = 0
    AND CZ4_QTVM = 0
    AND CZ4_VLBTS = 0
    AND CZ4_IDMEPO = 'VALOR'
    AND CZ4_DTBGME BETWEEN '20260401' AND '20260430'
    AND CZ4_DTEDME BETWEEN '20260401' AND '20260430'
    AND CZ4_DTVF BETWEEN '20260401' AND '20260430'
    AND CZ4_HRVF = 'VALOR'
    AND CZ4_NRSPAI = 0
    AND CZ4_NRSPPL = 0
    AND CZ4_NRSPRY = 0
    AND CZ4_QTPLRY = 0
    AND CZ4_QTRP = 0
    AND CZ4_QTSPEF = 0
    AND CZ4_QTSPSU = 0
    AND CZ4_QTTERP = 0
    AND CZ4_QTTESU = 0
    AND CZ4_VLLZ = 0
    AND CZ4_VLSPEX = 0
    AND CZ4_VLSPUT = 0