Histórico da Página

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_ = ' '

CW0_FILIAL	CW0_TABELA	CW0_CHAVE	CW0_DESC01
        	LP	T1X CT101      	20150131011P     

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