Sem Classificação no custo-saídas

SELECT * FROM (SELECT FILIAL,ANOMES,DOC,CODOPER,D2_COD,TES,CF,COMPL,TIPO,SUM(CUSTO) CUSTO FROM ( SELECT D2_FILIAL FILIAL,D2_DOC DOC,D2_CODOPER CODOPER,D2_COD,D2_TES TES,SUBSTR(D2_EMISSAO,1,6) ANOMES,SUM(-D2_CUSTO1) CUSTO,PA1_CLACUS CF, CASE WHEN B1_TIPO IN ('MP','PI') THEN 'MP' WHEN B1_TIPO IN ('EB','EQ','ME') THEN 'EB' WHEN B1_TIPO IN ('MO') THEN 'MO' WHEN B1_TIPO IN ('BN','MC') THEN 'OU' WHEN B1_TIPO IN ('PA') THEN 'PA' ELSE 'NC' END TIPO,' ' COMPL FROM SD2010 SD2, PA1010 PA1, SB1010 SB1, SF4010 SF4 WHERE D2_FILIAL = '01' AND D2_EMISSAO BETWEEN '20200701' AND '20200831' AND D2_LOCAL IN ('01','04','05','06','80','90','91','92','93','94') AND SD2.D_E_L_E_T_ <> '*' AND PA1_FILIAL = D2_FILIAL AND PA1_TIPO = D2_CODOPER AND PA1.D_E_L_E_T_ <> '*' AND B1_FILIAL = D2_FILIAL AND B1_COD = D2_COD AND SB1.D_E_L_E_T_ <> '*' --AND D2_CODOPER = '56' AND D2_TES = F4_CODIGO AND D2_FILIAL = F4_FILIAL AND F4_ESTOQUE = 'S'AND SF4.D_E_L_E_T_ <> '*' GROUP BY D2_FILIAL,D2_DOC,D2_CODOPER,D2_COD,D2_TES,PA1_CLACUS,SUBSTR(D2_EMISSAO,1,6),B1_TIPO ) GROUP BY FILIAL,ANOMES,DOC,CODOPER,D2_COD,TES,CF,TIPO,COMPL)WHERE CF = ' ';

Page updated

Report abuse