Histórico da Página

...

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

CT2_FILIAL	CT2_DTLP	CT2_DATA	CT2_LOTE	CT2_DOC	CT2_DEBITO	CT2_CREDIT	CT2_CCD	CT2_CCC	CT2_VALOR
X CT101		20150110	000001	00001	1.01.01.01.02	3.01.01			1000
X CT101		20150110	000001	00001	4.01.01	1.01.01.01.02			2000
X CT101	20150131	20150131	AP1501	00010	5.01	5.03			1000
X CT101	20150131	20150131	AP1501	00011	5.03	5.02			2000

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

CQ0_FILIAL	CQ0_CONTA	CQ0_DATA	CQ0_DEBITO	CQ0_CREDIT	CQ0_LP	CQ0_DTLP	CQ0_STATUS	CQ0_SLBASE
X CT101	1.01.01.01.02	20150131	1000	2000	N		1
X CT101	3.01.01	20150131	0	1000	N		1
X CT101	4.01.01	20150131	2000	0	N		1
X CT101	5.01	20150131	1000	0	Z	20150131	1
X CT101	5.02	20150131	0	2000	Z	20150131	1
X CT101	5.03	20150131	2000	1000	Z	20150131	1

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

CQ1_FILIAL	CQ1_CONTA	CQ1_DATA	CQ1_DEBITO	CQ1_CREDIT	CQ1_LP	CQ1_DTLP	CQ1_STATUS	CQ1_SLBASE
X CT101	1.01.01.01.02	20150110	1000	2000	N		1
X CT101	3.01.01	20150110	0	1000	N		1
X CT101	4.01.01	20150110	2000	0	N		1
X CT101	5.01	20150131	1000	0	Z	20150131	1
X CT101	5.02	20150131	0	2000	Z	20150131	1
X CT101	5.03	20150131	2000	1000	Z	20150131	1

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

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
AP1501	001	000010	001	001	01	1	1000	0	3.01.01				T1	X CT101
AP1501	001	000011	001	001	01	1	0	2000	4.01.01				T1	X CT101

03. TELA XXXXX

Outras Ações / Ações relacionadas

...

Árvore de páginas

Versões comparadas

Versão antiga 10

Nova versão 11

Chave

03. TELA XXXXX