Query Razão Contabil
"SELECT * FROM CT2000 WHERE  CT2_FILIAL IN ('00001000100','00001000800','00001001000','00001001100','00001001200','00001001700','00001001900','00001002000','00001002200','00001002300','00001002600','00001002700') AND CT2_DEBITO>='210105010101        'AND CT2_DEBITO<='210105010101        ' AND CT2_DATA >= '20171001' AND CT2_DATA <= '20171031' AND CT2_CCD>='         'AND CT2_CCD<='ZZZZZZZZZ'AND CT2_ITEMD>='         'AND CT2_ITEMD<='ZZZZZZZZZ'AND CT2_CLVLDB>='         'AND CT2_CLVLDB<='ZZZZZZZZZ' AND CT2_MOEDLC = '01' AND CT2_TPSALD = '1' AND (CT2_DC = '1' OR CT2_DC = '3') AND CT2_VALOR <> 0 AND D_E_L_E_T_ = ' '  ORDER BY  CT2_FILIAL, CT2_DEBITO, CT2_DATA "
"SELECT * FROM CT2000 WHERE  CT2_FILIAL IN ('00001000100','00001000800','00001001000','00001001100','00001001200','00001001700','00001001900','00001002000','00001002200','00001002300','00001002600','00001002700') AND CT2_CREDIT>='210105010101        'AND CT2_CREDIT<='210105010101        ' AND CT2_DATA >= '20171001' AND CT2_DATA <= '20171031' AND CT2_CCC>='         'AND CT2_CCC<='ZZZZZZZZZ'AND CT2_ITEMC>='         'AND CT2_ITEMC<='ZZZZZZZZZ'AND CT2_CLVLCR>='         'AND CT2_CLVLCR<='ZZZZZZZZZ' AND CT2_MOEDLC = '01' AND CT2_TPSALD = '1' AND (CT2_DC = '2' OR CT2_DC = '3') AND CT2_VALOR <> 0 AND D_E_L_E_T_ = ' '  ORDER BY  CT2_FILIAL, CT2_CREDIT, CT2_DATA "