Histórico da Página

...

|---------------> Data da Apuração

SELECT CW0_FILIAL, CW0_TABELA, CW0_CHAVE, CW0_DESC01 from CW0T10
WHERE CW0_FILIAL = '     '

AND CW0_TABELA = 'LP'
AND SUBSTRING (CW0_DESC01,1,

...

8) = '

...

20150131'

AND D_E_L_E_T_ = ' '

SELECT CT2_FILIAL, CT2_DTLP, CT2_DATA, CT2_LOTE, CT2_DOC, CT2_DEBITO, CT2_CREDIT, CT2_CCD, CT2_CCC, CT2_VALOR, CT2_ITEMD, CT2_ITEMC, CT2_CLVLDB, CT2_CLVLCR
FROM CT2T10
WHERE CT2_FILIAL = 'X CT101 '
AND CT2_DATA BETWEEN '20150101' AND '20151231' AND D_E_L_E_T_ = ' '
ORDER BY CT2_DATA

SELECT CQ0_FILIAL, CQ0_CONTA, CQ0_DATA, CQ0_DEBITO, CQ0_CREDIT, CQ0_LP, CQ0_DTLP, CQ0_STATUS, CQ0_SLBASE
FROM CQ0T10
WHERE D_E_L_E_T_ = ' ' AND CQ0_FILIAL = 'X CT101 ' AND CQ0_MOEDA = '01'
AND CQ0_DATA BETWEEN '20150101' AND '20150131'
ORDER BY CQ0_FILIAL, CQ0_CONTA, CQ0_DATA, CQ0_DTLP

SELECT CQ1_FILIAL, CQ1_CONTA, CQ1_DATA, CQ1_DEBITO, CQ1_CREDIT, CQ1_LP, CQ1_DTLP, CQ1_STATUS, CQ1_SLBASE
FROM CQ1T10
WHERE D_E_L_E_T_ = ' ' AND CQ1_FILIAL = 'X CT101 ' AND CQ1_MOEDA = '01'
AND CQ1_DATA BETWEEN '20150101' AND '20151231' AND D_E_L_E_T_ = ' '
ORDER BY CQ1_FILIAL, CQ1_CONTA, CQ1_DATA, CQ1_DTLP

SELECT CTZ_FILIAL, CTZ_DATA, CTZ_LOTE, CTZ_SBLOTE, CTZ_DOC, CTZ_LINHA, CTZ_SEQLIN, CTZ_MOEDLC, CTZ_TPSALD, CTZ_VLRDEB, CTZ_VLRCRD,CTZ_CONTA,CTZ_CUSTO, CTZ_ITEM, CTZ_CLVL, CTZ_EMPORI, CTZ_FILORI
FROM CTZT10
WHERE CTZ_FILIAL = 'X CT101 '
AND CTZ_DATA BETWEEN '20150101' AND '20151231'AND D_E_L_E_T_ = ' '
ORDER BY CTZ_DATA

03. TELA XXXXX

Outras Ações / Ações relacionadas

...