Error: 18456, Severity: 14, State: 8.

Error: 18456, Severity: 14, State: 8.

Error: 18456, Severity: 14, State: 8.

Error: 17832, Severity: 20, State: 11.

Error: 18456, Severity: 14, State: 5.

Error: 18452, Severity: 14, State: 1.

Error: 17806, Severity: 20, State: 14.

Error: 18452, Severity: 14, State: 1.

Error: 17806, Severity: 20, State: 14.

Error: 18452, Severity: 14, State: 1.

Error: 17806, Severity: 20, State: 14.

Error: 18452, Severity: 14, State: 1.

Error: 17806, Severity: 20, State: 14.

Login failed for user 'totvs.svs'. Reason: Failed to open the explicitly specified database 'DADOSADV12'. [CLIENT: 192.168.1.189]

Error: 18456, Severity: 14, State: 38.

The state of the local availability replica in availability group 'SDB_AG_NFE12' has changed from 'PRIMARY_PENDING' to 'PRIMARY_NORMAL'.  The state changed because the local replica has completed processing Online command from Windows Server Failover Clustering (WSFC).  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

The state of the local availability replica in availability group 'SDB_AG_ADV12' has changed from 'PRIMARY_PENDING' to 'PRIMARY_NORMAL'.  The state changed because the local replica has completed processing Online command from Windows Server Failover Clustering (WSFC).  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

The state of the local availability replica in availability group 'SDB_AG_NFE12' has changed from 'RESOLVING_NORMAL' to 'PRIMARY_PENDING'.  The state changed because the availability group is coming online.  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

The state of the local availability replica in availability group 'SDB_AG_ADV12' has changed from 'RESOLVING_NORMAL' to 'PRIMARY_PENDING'.  The state changed because the availability group is coming online.  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

Always On: The local replica of availability group 'SDB_AG_NFE12' is preparing to transition to the primary role in response to a request from the Windows Server Failover Clustering (WSFC) cluster. This is an informational message only. No user action is required.

Always On: The local replica of availability group 'SDB_AG_ADV12' is preparing to transition to the primary role in response to a request from the Windows Server Failover Clustering (WSFC) cluster. This is an informational message only. No user action is required.

The state of the local availability replica in availability group 'SDB_AG_TAF12' has changed from 'PRIMARY_PENDING' to 'PRIMARY_NORMAL'.  The state changed because the local replica has completed processing Online command from Windows Server Failover Clustering (WSFC).  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

The state of the local availability replica in availability group 'SDB_AG_TAF12' has changed from 'RESOLVING_NORMAL' to 'PRIMARY_PENDING'.  The state changed because the availability group is coming online.  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

Always On: The local replica of availability group 'SDB_AG_TAF12' is preparing to transition to the primary role in response to a request from the Windows Server Failover Clustering (WSFC) cluster. This is an informational message only. No user action is required.

The state of the local availability replica in availability group 'SDB_AG_ADV12' has changed from 'NOT_AVAILABLE' to 'RESOLVING_NORMAL'.  The state changed because the local instance of SQL Server is starting up.  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

The state of the local availability replica in availability group 'SDB_AG_NFE12' has changed from 'NOT_AVAILABLE' to 'RESOLVING_NORMAL'.  The state changed because the local instance of SQL Server is starting up.  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

The state of the local availability replica in availability group 'SDB_AG_TAF12' has changed from 'NOT_AVAILABLE' to 'RESOLVING_NORMAL'.  The state changed because the local instance of SQL Server is starting up.  For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log.

Always On Availability Groups: Local Windows Server Failover Clustering node is online. This is an informational message only. No user action is required.

The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SP-SDB01.ebba.local:50745 ] for the SQL Server service. Windows return code: 0xffffffff, state: 43. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SP-SDB01.ebba.local ] for the SQL Server service. Windows return code: 0xffffffff, state: 43. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.

Error: 35262, Severity: 17, State: 1.

Error: 35262, Severity: 17, State: 1.

Error: 35262, Severity: 17, State: 1.

Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to come online. This is an informational message only. No user action is required.

Always On Availability Groups: Local Windows Server Failover Clustering node started. This is an informational message only. No user action is required.

Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to start. This is an informational message only. No user action is required.

Always On Availability Groups: Local Windows Server Failover Clustering service started. This is an informational message only. No user action is required.

Always On Availability Groups: Waiting for local Windows Server Failover Clustering service to start. This is an informational message only. No user action is required.

INSERT INTO WAPEBBA.dbo.WAP_COMPPosicaoDiariaPedComCot

SELECT
     --C7_EMISSAO,
     @DATA AS DTPOSICAO,
     ISNULL(SUM(QTD_PED),0) AS QTD_PED
    ,ISNULL(SUM(QTD_QUALIF),0) AS QTD_QUALIF
    ,ISNULL(ROUND((CAST(SUM(QTD_QUALIF) AS FLOAT) / CAST(SUM(QTD_PED) AS FLOAT)) * 100,0),0) AS PERC_QUALIF
 , ROUND((CAST(SUM(SUM_QUALIF) AS FLOAT) / CAST(SUM(SUM_PED) AS FLOAT)) * 100,0) AS PERC_QUALIF_VALOR
--INTO WAPEBBA.dbo.WAP_COMPPosicaoDiariaPedComCot
FROM (
SELECT

--TOP 100

-- agora utilizando novas regras da tabela de/para intranet - 25/02/2019 - saulob

 ISNULL(  

 ( SELECT TOP 1 COMP_COD 
 FROM [WAPEBBA].[dbo].[COMPRAS_DEPARA_CC] DCC
 WHERE DCC.D_E_L_E_T_ = 'N'
    AND DCC.GP_MRC_COD = B1_GRPCOMP
    AND DCC.FILIAL = C7_FILIAL
 AND DCC.CCUSTO_COD = C7_CC
 AND DCC.EMPRESA = '06' ) ,
  
 
 ( SELECT TOP 1 LTRIM(RTRIM(ZZ1.ZZ1_COMPRA)) 
 FROM DADOSADV12.dbo.ZZ1060 ZZ1
 WHERE ZZ1.D_E_L_E_T_ = ''
    AND ZZ1.ZZ1_GRUPO = B1_GRPCOMP
    AND ZZ1.ZZ1_FILIAL = C7_FILIAL ) 
 
 ) AS COMP_COD,
 
 ISNULL ( 
 
 ( SELECT TOP 1 COMPRADOR 
 FROM [WAPEBBA].[dbo].[COMPRAS_DEPARA_CC] DCC
 WHERE DCC.D_E_L_E_T_ = 'N'
    AND DCC.GP_MRC_COD = B1_GRPCOMP
    AND DCC.FILIAL = C7_FILIAL
 AND DCC.CCUSTO_COD = C7_CC
 AND DCC.EMPRESA = '06' ) , 
 
 ( SELECT TOP 1 UPPER(LTRIM(RTRIM(ZZ1.ZZ1_COMNOM))) 
 FROM DADOSADV12.dbo.ZZ1060 ZZ1
 WHERE ZZ1.D_E_L_E_T_ = ''
    AND ZZ1.ZZ1_GRUPO = B1_GRPCOMP
    AND ZZ1.ZZ1_FILIAL = C7_FILIAL ) ) AS COMPRADOR 

 -- agora utilizando novas regras da tabela de/para intranet - 25/02/2019 - saulob
 /* -- desligado em 25/02/2019 , agora utilizando novas regras da tabela de/para intranet - saulob
CASE
    --WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN '139'
-- WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN '143' -- saulob, 10/08/2018
 --WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN '146' -- saulob, 26/09/2018
 WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN '148' -- saulob, 13/11/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '141'
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '144' -- saulob, 10/08/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '143' -- saulob, 26/09/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '147' -- saulob, 13/11/2018
 WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '151' -- saulob, 07/02/2019

    ELSE
        CASE
            WHEN LEFT(LTRIM(RTRIM(C7_CC)),1) = '3' THEN '104'
            ELSE (SELECT TOP 1 LTRIM(RTRIM(ZZ1.ZZ1_COMPRA)) FROM DADOSADV12.dbo.ZZ1060 ZZ1 WHERE ZZ1.D_E_L_E_T_ = '' AND ZZ1.ZZ1_GRUPO = B1.B1_GRPCOMP AND ZZ1.ZZ1_FILIAL = C7.C7_FILIAL)
        END
END AS COMP_COD

, CASE
    --WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN 'KEYTH CARVALHO'
 --WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN 'CRYS SANTIAGO' -- saulob, 10/08/2018
 --WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN 'KAREN MARQUES GUIMARAES' -- saulob, 26/09/2018
 WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16') AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') AND C7_CC = '200606' THEN 'BRUNO DANIEL GOMES DE SOUZA' -- saulob, 13/11/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'ADRIANA TORRES' 
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'MARCIO JUNIOR'  -- saulob, 10/08/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'CRYSLEINE THAINARA MARQUES SANTIAGO'  -- saulob, 26/09/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'BIANCA INGRID MENEZES ARAUJO'  -- saulob, 22/10/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'BRUNO DANIEL GOMES DE SOUZA'  -- saulob, 13/11/2018
 WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'ANA CAROLINA ALVES DE JESUS'  -- saulob, 07/02/2019
    
 ELSE
        CASE WHEN LEFT(LTRIM(RTRIM(C7_CC)),1) = '3' THEN 'MANUELA SOUZA'
        ELSE (SELECT TOP 1 UPPER(LTRIM(RTRIM(ZZ1.ZZ1_COMNOM))) FROM DADOSADV12.dbo.ZZ1060 ZZ1 WHERE ZZ1.D_E_L_E_T_ = '' AND ZZ1.ZZ1_GRUPO = B1.B1_GRPCOMP AND ZZ1.ZZ1_FILIAL = C7.C7_FILIAL)
    END
END AS COMPRADOR

*/

, C7_FILIAL
, C7_NUMCOT
, C7_PRODUTO
, COUNT(C7_NUM) AS QTD_PED

, SUM(C7_TOTAL) AS SUM_PED

, CASE
 WHEN

  C7_TIPO = 1 AND
  ( (SELECT COUNT(*) FROM DADOSADV12.dbo.SC8060 AS C8 WHERE C8.D_E_L_E_T_ = '' AND C8_FILIAL = C7_FILIAL
  AND C7_NUMCOT = C8_NUM AND C7_PRODUTO = C8_PRODUTO AND C8_TOTAL <> 0) >= 2 )

  THEN SUM(C7_TOTAL)

 WHEN C7_TIPO = 2 THEN SUM(C7_TOTAL)
 ELSE 0
  END AS SUM_QUALIF

, C7_EMISSAO
, CASE WHEN (SELECT COUNT(*) FROM DADOSADV12.dbo.SC8060 AS C8 WHERE C8.D_E_L_E_T_ = '' AND C8_FILIAL = C7_FILIAL AND C7_NUMCOT = C8_NUM AND C7_PRODUTO = C8_PRODUTO AND C8_TOTAL <> 0) >= 2 THEN 1 ELSE 0 END AS QTD_QUALIF

FROM DADOSADV12.dbo.SC7060 AS C7

INNER JOIN DADOSADV12.dbo.SB1060 AS B1 ON C7.D_E_L_E_T_ = B1.D_E_L_E_T_  AND B1_COD = C7_PRODUTO AND B1_GRPCOMP NOT IN ('0101', '2007', '0112')
INNER JOIN DADOSADV12.dbo.ZZ1060 AS Z1 ON Z1.D_E_L_E_T_ = C7.D_E_L_E_T_ AND ZZ1_GRUPO = B1_GRPCOMP AND ZZ1_FILIAL = C7_FILIAL

WHERE C7.D_E_L_E_T_ = ''

-- PEDIDO LIBERADO
AND C7_CONAPRO = 'L'

-- PEDIDOS COM SC
AND C7_NUMSC <> ''

-- PEDIDO COMPRA
AND C7_TIPO IN (1)

-- FILTRO POR DIARIO
AND C7_EMISSAO BETWEEN (LEFT(@DATA,6) + '01') AND @DATA

-- EXCLUI PEDIDOS ELIMINADOS
AND NOT (LTRIM(RTRIM(C7_RESIDUO)) IN ('S', 'R') AND C7_QUJE = 0)

AND C7_EXCLUSI = 'N'
AND C7_URGENTE = 'N'

AND Str(C7.R_E_C_N_O_, 12) IN (SELECT Str(C7.R_E_C_N_O_, 12) 
            FROM   DADOSADV12.dbo.SC7060 AS C7 
                    INNER JOIN DADOSADV12.dbo.SCR060 AS SCR 
                            ON C7.D_E_L_E_T_ = 
                            SCR.D_E_L_E_T_ 
                            AND C7_FILIAL = CR_FILIAL 
                            AND C7_NUM = CR_NUM 
            WHERE  C7.D_E_L_E_T_ = '' 
                    AND C7_CONAPRO = 'L' 
                     AND CR_DATALIB  BETWEEN (LEFT(@DATA,6) + '01') AND @DATA ) 

GROUP BY C7_FILIAL
, B1_GRPCOMP
, C7_CC
, C7_NUMCOT
, C7_PRODUTO
, C7_EMISSAO
, C7_TIPO
) TBL

UPDATE SA1060 
                 WITH (ROWLOCK) 
                  SET A1_SALDUP  = @nA1_SALDUP , A1_SALDUPM  = @nA1_SALDUPM , A1_VACUM  = @nA1_VACUM , A1_MAIDUPL  = @nA1_MAIDUPL 
                 , A1_ATR  = @nA1_ATR , A1_NROPAG  = @nA1_NROPAG , A1_PAGATR  = @nA1_PAGATR , A1_PRICOM  = @cA1_PRICOM , 
                      A1_ULTCOM  = @cA1_ULTCOM , A1_SALFIN  = @nA1_SALFIN , A1_SALFINM  = @nA1_SALFINM , A1_MSALDO  = @nA1_MSALDO 
                 , A1_MATR  = @nA1_MATR , A1_METR  = @nA1_METR , A1_MCOMPRA  = @nA1_MCOMPRA , A1_NROCOM  = @nA1_NROCOM 
                WHERE A1_FILIAL  = @cFilial_A1  and A1_COD  = @cCliente  and A1_LOJA  = @cLoja  and D_E_L_E_T_  = ' '

UPDATE SA1060 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

INSERT INTO #TEMPDILPDCAETT12
 
 SELECT (CASE WHEN C7_TIPO = '1' THEN 'PDC' ELSE 'ATE' END) AS TIPO,

C7_FILIAL AS FILIAL_COD,

(CASE WHEN C7_FILIAL='02' THEN 'ARACATI'
WHEN C7_FILIAL='01' THEN 'RECIFE'
WHEN C7_FILIAL='11' THEN 'ARAGURARI'
WHEN C7_FILIAL='12' THEN 'S.PAULO FL'
WHEN C7_FILIAL='14' THEN 'CONTAGEM'
WHEN C7_FILIAL='15' THEN 'S.PAULO'
WHEN C7_FILIAL='16' THEN 'MAG-ARG'
WHEN C7_FILIAL='17' THEN 'MAG-ARC'
WHEN C7_FILIAL='18' THEN 'ESPLANADA-ARG'
WHEN C7_FILIAL='19' THEN 'PLENA-ARG'
WHEN C7_FILIAL='20' THEN 'DEP.RECIFE'
WHEN C7_FILIAL='21' THEN 'DEP.S.PAULO'
WHEN C7_FILIAL='22' THEN 'MINAS MIX-ARG'
ELSE 'N/A' END) AS FILIAL,
--C1_NUM AS SC,
--C1_ITEM AS SC_ITEM,
--SUBSTRING(C1_EMISSAO,7,2)+'/'+SUBSTRING(C1_EMISSAO,5,2)+'/'+SUBSTRING(C1_EMISSAO,1,4) AS DATA_SC,


--LTRIM(RTRIM( (CASE WHEN C1_XDTAN5 <> '' THEN CONVERT(CHAR(12), CONVERT(DATETIME, C1_XDTAN5), 103)
--    WHEN C1_XDTAN4 <> '' THEN CONVERT(CHAR(12), CONVERT(DATETIME, C1_XDTAN4), 103)
--    WHEN C1_XDTAN3 <> '' THEN CONVERT(CHAR(12), CONVERT(DATETIME, C1_XDTAN3), 103)
--    WHEN C1_XDTAN2 <> '' THEN CONVERT(CHAR(12), CONVERT(DATETIME, C1_XDTAN2), 103)
--    WHEN C1_XDTAN1 <> '' THEN CONVERT(CHAR(12), CONVERT(DATETIME, C1_XDTAN1), 103)
--    WHEN C1_DATAPRO <> '' THEN CONVERT(CHAR(12), CONVERT(DATETIME, C1_DATAPRO), 103)
--    ELSE '' END) )) AS DT_LIB_SC,

--LTRIM(RTRIM(C1_SOLICIT)) AS SOLICIT,
B1_GRPCOMP AS GP_MRC_COD,
LTRIM(RTRIM(BM_DESC))  AS GRP_MERC, 
LTRIM(RTRIM(B1_COD)) AS PRDUTO_COD, 
LTRIM(RTRIM(B1_DESC)) AS PRODUTO, 
C7_QUANT AS QUANTIDADE,
C7_UM AS UND_MEDIDA,
C7_USER AS COMPP_COD,
UPPER(LTRIM(RTRIM(C7_USERNOM))) AS COMPRAD_P,
--C1_APROV AS STATUS,
C7_NUM AS PEDIDO,
C7_ITEM AS PC_ITEM,
SUBSTRING(C7_EMISSAO,7,2)+'/'+SUBSTRING(C7_EMISSAO,5,2)+'/'+SUBSTRING(C7_EMISSAO,1,4) AS DT_PEDIDO,
C7_QUANT AS QTD_PC,
C7_QUJE AS QTD_ENT,
ISNULL((SELECT SUM(B2_QATU) FROM DADOSADV12.dbo.SB2060 SB2 WHERE SB2.D_E_L_E_T_=' ' 
AND SB2.B2_FILIAL=SC7.C7_FILIAL AND SB2.B2_COD=SC7.C7_PRODUTO AND SB2.B2_LOCAL<>'DI'),0) AS SLD_AT_EST,
C7_PRECO AS PC_UNIT,
C7_PRECO+(C7_VALIPI/C7_QUANT) AS PC_UNIT_IPI,    
C7_TOTAL+C7_VALIPI AS VAL_TT,
SUBSTRING(C7_DATPRF,7,2)+'/'+SUBSTRING(C7_DATPRF,5,2)+'/'+SUBSTRING(C7_DATPRF,1,4) AS DT_ENTREGA,

DATEDIFF(DAY, C7_EMISSAO, C7_DATPRF) AS PRAZO_ESTM,
A2_COD  AS FORN_COD,
A2_LOJA AS LOJA,
A2_CGC AS CNPJ,
LTRIM(RTRIM(A2_NOME)) AS RZ_SOCIAL,
B1_TIPO AS TP_COMPRA, 
C7_CC AS CC_COD,
LTRIM(RTRIM((SELECT I3_DESC FROM DADOSADV12.dbo.SI3060 SI3A WHERE SI3A.I3_CUSTO=C7_CC AND I3_DESC<>' ' AND SI3A.D_E_L_E_T_=' '))) AS CC_DESC,
C7_RESIDUO AS ELIMINACAO,
C7_QTDACLA AS QTD_CLASSF,

(CASE WHEN C7_CONAPRO='L' THEN 'LIBERADO' ELSE (CASE WHEN C7_ENCER='E' THEN 'BLOQUEADO' ELSE 
(CASE WHEN ISNULL((SELECT TOP(1)CR_STATUS FROM DADOSADV12.dbo.SCR060 SCR WHERE SCR.D_E_L_E_T_='' 
AND CR_FILIAL=C7_FILIAL AND CR_NUM=C7_NUM AND CR_STATUS='04'),'02')='04' THEN 'BLOQUEADO' ELSE 'AGUARDANDO LIBERACAO' 
END) END) END) AS SITUACAO,

    -- adicionado campo OBS_APROV a pedido de bruna chamado xmon 051732 (saulo benigno)
 ISNULL((SELECT TOP 1 LEFT(SCR.CR_OBS, 255) FROM DADOSADV12.dbo.SCR060 SCR
 WHERE SCR.CR_NUM = C7_NUM
 AND SCR.D_E_L_E_T_ = ''
 AND SCR.CR_OBS <> ''), '') AS OBS_APROV,
 -- adicionado campo OBS_APROV a pedido de bruna chamado xmon 051732 (saulo benigno)

C7_OBS AS PC_OBS,

ISNULL((SELECT ROUND((SUM(SD1.D1_QUANT) / 6),0) FROM DADOSADV12.dbo.SD1060 SD1 
WHERE SD1.D_E_L_E_T_='' AND SD1.D1_FILIAL=SC7.C7_FILIAL AND SD1.D1_COD=SC7.C7_PRODUTO 
AND SD1.D1_DTDIGIT>=CONVERT(CHAR , GETDATE()-180, 112)),0) AS CONSMMES,

--C1_VALESTI VL_ORC_UNI,
--C1_TOTESTI VL_ORC_TT,
C7_ENVMAIL EBBA_PRINT,
  
(SELECT SUBSTRING(MAX(STR(R_E_C_N_O_,12)+SUBSTRING(CR_DATALIB,7,2)+'/'+SUBSTRING(CR_DATALIB,5,2)+'/'+SUBSTRING(CR_DATALIB,1,4)),13,10) 
 FROM DADOSADV12.dbo.SCR060 SCR
   WHERE SCR.D_E_L_E_T_='' AND SCR.CR_FILIAL=SC7.C7_FILIAL AND 
 SCR.CR_NUM=SC7.C7_NUM AND 
 SCR.CR_TIPO='PC')   AS DT_LIB_PC,

--C1_URGENTE AS URGENCIA,

DATEDIFF(DAY, C7_EMISSAO, GETDATE()) AS DIAS_ABERT,

 -- agora utilizando novas regras da tabela de/para intranet - 25/02/2019 - saulob

 ISNULL(  

 ( SELECT TOP 1 COMP_COD 
 FROM [WAPEBBA].[dbo].[COMPRAS_DEPARA_CC] DCC
 WHERE DCC.D_E_L_E_T_ = 'N'
    AND DCC.GP_MRC_COD = SB1.B1_GRPCOMP
    AND DCC.FILIAL = SC7.C7_FILIAL
 AND DCC.CCUSTO_COD = C7_CC
 AND DCC.EMPRESA = '06' 
 ORDER BY DATA_CADASTRO DESC) ,
  
 
 ( SELECT TOP 1 LTRIM(RTRIM(ZZ1.ZZ1_COMPRA)) 
 FROM DADOSADV12.dbo.ZZ1060 ZZ1
 WHERE ZZ1.D_E_L_E_T_ = ''
    AND ZZ1.ZZ1_GRUPO = SB1.B1_GRPCOMP
    AND ZZ1.ZZ1_FILIAL = SC7.C7_FILIAL ) 
 
 ) AS COMP_COD,
 
 ISNULL ( 
 
 ( SELECT TOP 1 COMPRADOR 
 FROM [WAPEBBA].[dbo].[COMPRAS_DEPARA_CC] DCC
 WHERE DCC.D_E_L_E_T_ = 'N'
    AND DCC.GP_MRC_COD = SB1.B1_GRPCOMP
    AND DCC.FILIAL = SC7.C7_FILIAL
 AND DCC.CCUSTO_COD = C7_CC
 AND DCC.EMPRESA = '06' 
 ORDER BY DATA_CADASTRO DESC) , 
 
 ( SELECT TOP 1 UPPER(LTRIM(RTRIM(ZZ1.ZZ1_COMNOM))) 
 FROM DADOSADV12.dbo.ZZ1060 ZZ1
 WHERE ZZ1.D_E_L_E_T_ = ''
    AND ZZ1.ZZ1_GRUPO = SB1.B1_GRPCOMP
    AND ZZ1.ZZ1_FILIAL = SC7.C7_FILIAL ) ) AS COMPRADOR, 


 -- agora utilizando novas regras da tabela de/para intranet - 25/02/2019 - saulob

/*
 (CASE WHEN LEFT(LTRIM(RTRIM(C1_CC)),1) = '3' THEN '104'
    ELSE LTRIM(RTRIM(ZZ1.ZZ1_COMPRA)) END) AS COMP_COD,

(CASE WHEN LEFT(LTRIM(RTRIM(C1_CC)),1) = '3' THEN 'CAROLINE MELO'
    ELSE UPPER(LTRIM(RTRIM(ZZ1.ZZ1_COMNOM))) END) AS COMPRADOR, 
 */
 /* -- desligado em 25/02/2019 , agora utilizando novas regras da tabela de/para intranet - saulob
    (CASE WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16')
 --AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') 
 --AND C7_CC = '200606' THEN '139' -- KEYTH CARVALHO' ,  saulo benigno, 07/06/2018, xmon 71312
 --AND C7_CC = '200606' THEN '143'  -- CRYS SANTIAGO ,  saulo benigno, 10/08/2018
 --AND C7_CC = '200606' THEN '146'  -- KAREN ,  saulo benigno, 26/09/2018
 AND C7_CC = '200606' THEN '148'  -- BRUNO SOUZA ,  saulo benigno, 13/11/2018

 ELSE 
 
 (CASE WHEN LEFT(LTRIM(RTRIM(C7_CC)),1) = '3' THEN '119' -- era 104 CAROLINE MELO atualizado para Manuela 119, xmon 063207
 
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '141' -- ADRIANA TORRES ,  saulo benigno, 07/06/2018, xmon 71312
 -- KEYTH CARVALHO' ,  saulo benigno, 04/04/2018, xmon 67683
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '144' -- MARCIO JUNIOR ,  saulo benigno, 10/08/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '143' -- CRYS SANTIAGO ,  saulo benigno, 26/09/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '148' -- BRUNO SOUZA ,  saulo benigno, 13/11/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '147' -- BIANCA INGRID MENEZES ARAUJO ,  saulo benigno, 22/10/2018
 WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN '151' -- ANA CAROLINA ALVES DE JESUS ,  saulo benigno, 07/02/2019

 
 ELSE ( SELECT TOP 1 LTRIM(RTRIM(ZZ1.ZZ1_COMPRA)) 
 FROM DADOSADV12.dbo.ZZ1060 ZZ1
 WHERE ZZ1.D_E_L_E_T_ = ''
    AND ZZ1.ZZ1_GRUPO = SB1.B1_GRPCOMP
    AND ZZ1.ZZ1_FILIAL = SC7.C7_FILIAL ) END ) END) AS COMP_COD,

 (CASE WHEN (C7_FILIAL = '11' OR C7_FILIAL = '16')
 --AND (B1_GRPCOMP = '1101' OR B1_GRPCOMP = '1102') 
 --AND C7_CC = '200606' THEN 'KEYTH CARVALHO' -- KEYTH CARVALHO' ,  saulo benigno, 07/06/2018, xmon 71312
 --AND C7_CC = '200606' THEN 'CRYS SANTIAGO'  -- CRYS SANTIAGO ,  saulo benigno, 10/08/2018
 --AND C7_CC = '200606' THEN 'KAREN MARQUES GUIMARAES'  -- KAREN MARQUES ,  saulo benigno, 26/09/2018
 AND C7_CC = '200606' THEN 'BRUNO DANIEL GOMES DE SOUZA'  -- BRUNO SOUZA ,  saulo benigno, 13/11/2018

 ELSE

 (CASE WHEN LEFT(LTRIM(RTRIM(C7_CC)),1) = '3' THEN 'MANUELA SOUZA' -- era CAROLINE MELO atualizado para Manuela, xmon 063207
 
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'ADRIANA TORRES' -- ADRIANA TORRES ,  saulo benigno, 07/06/2018, xmon 71313
 -- saulo benigno, 04/04/2018, xmon 67683 
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'MARCIO JUNIOR' -- MARCIO JUNIOR ,  saulo benigno, 10/08/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'CRYSLEINE THAINARA MARQUES SANTIAGO' -- CRYS SANTIAGO ,  saulo benigno, 26/09/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'BRUNO DANIEL GOMES DE SOUZA' -- BRUNO SOUZA ,  saulo benigno, 13/11/2018
 --WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'BIANCA INGRID MENEZES ARAUJO' -- BIANCA INGRID MENEZES ARAUJO ,  saulo benigno, 22/10/2018
 WHEN (LTRIM(RTRIM(C7_CC)) = '200606' AND (C7_FILIAL = '02' OR C7_FILIAL = '17')) THEN 'ANA CAROLINA ALVES DE JESUS' -- ANA CAROLINA ALVES DE JESUS ,  saulo benigno, 07/02/2019

 ELSE ( SELECT TOP 1 UPPER(LTRIM(RTRIM(ZZ1.ZZ1_COMNOM))) 
 FROM DADOSADV12.dbo.ZZ1060 ZZ1
 WHERE ZZ1.D_E_L_E_T_ = ''
    AND ZZ1.ZZ1_GRUPO = SB1.B1_GRPCOMP
    AND ZZ1.ZZ1_FILIAL = SC7.C7_FILIAL ) END) END) AS COMPRADOR,

 */

     (CASE WHEN C7_DATPRF > CONVERT(VARCHAR(12),GETDATE(),112) THEN '0'
    ELSE DATEDIFF(DAY, C7_DATPRF, GETDATE()) END) AS DIAS_ATRSD,


   (CASE WHEN C7_DATPRF >= CONVERT(VARCHAR(12),GETDATE(),112) THEN 'DENTRO DO PRAZO'
    WHEN C7_DATPRF <=  C7_EMISSAO THEN 'ERRADA'
 ELSE 'ATRASADO' END) AS STATUS_PC,


--(CASE WHEN C1_COTACAO='XXXXXX' THEN ' ' ELSE C1_COTACAO END) AS NUM_COT,
--(CASE WHEN C1_COTACAO='XXXXXX' THEN ' ' WHEN C1_COTACAO='' THEN ' ' ELSE 
--(CASE WHEN ISNULL((SELECT SUM(C8_PRECO) FROM DADOSADV12.dbo.SC8060 SC8 
--WHERE SC8.D_E_L_E_T_=' ' AND SC8.C8_FILIAL=C1_FILIAL AND SC8.C8_NUM=C1_COTACAO 
--AND SC8.C8_PRODUTO=C1_PRODUTO),0.0000)=0.0000 THEN 'N' ELSE 'R' END) END) AS ST_COTACAO,


--DATEDIFF(DAY, 

--(CASE WHEN C1_XDTAN5 <> '' THEN C1_XDTAN5
--    WHEN C1_XDTAN4 <> '' THEN C1_XDTAN4
--    WHEN C1_XDTAN3 <> '' THEN C1_XDTAN3
--    WHEN C1_XDTAN2 <> '' THEN C1_XDTAN2
--    WHEN C1_XDTAN1 <> '' THEN C1_XDTAN1
--    WHEN C1_DATAPRO <> '' THEN C1_DATAPRO
--    ELSE '' END) 

--, C7_EMISSAO) AS TMP_ATD_SC,

CONVERT(VARCHAR(12),GETDATE(),103) + ' - ' + CONVERT(VARCHAR(5),GETDATE(),114) AS ULT_ATUALZ

,C7_EMISSAO AS DATA_INDICE

--INTO WAPEBBA.dbo.SRE_COMPRAS_DILPDCAE

 FROM DADOSADV12.dbo.SC7060 SC7,
 DADOSADV12.dbo.SA2060 SA2,
 --DADOSADV12.dbo.SC1060 SC1,
 DADOSADV12.dbo.SB1060 SB1 LEFT JOIN 
 DADOSADV12.dbo.SBM060 SBM ON SBM.D_E_L_E_T_=' ' AND SBM.BM_GRUPO=SB1.B1_GRPCOMP
 --, DADOSADV12.dbo.ZZ1060 ZZ1

WHERE SC7.D_E_L_E_T_=' ' AND
 C7_TIPO IN ('1','2') AND
 --C7_QUJE<C7_QUANT AND   
 --C7_QUANT<>0 AND
 SB1.D_E_L_E_T_=' ' AND
 SB1.B1_COD=C7_PRODUTO AND
 SA2.D_E_L_E_T_=' ' AND
 SA2.A2_COD=C7_FORNECE AND
 SA2.A2_LOJA=C7_LOJA AND
 --SC1.D_E_L_E_T_=' ' AND
 --SC1.C1_FILIAL = C7_FILIAL AND
 --SC1.C1_NUM = C7_NUMSC AND
 --SC1.C1_ITEM = C7_ITEMSC AND
 --YEAR(C1_EMISSAO)>=2012 AND
 YEAR(C7_EMISSAO) >= 2012 
 

  -- FILTROS UTILIZADOS (POR SAULO)
 AND NOT (LTRIM(RTRIM(C7_RESIDUO)) IN ('S') AND C7_QUJE = 0)
 AND LTRIM(RTRIM(C7_CONAPRO)) = 'L'
    --AND C7_ENCER <> 'E'

 -- PEDIDOS COM SC
 AND C7_NUMSC <> ''

INSERT INTO
                        WAPEBBA.dbo.WAP_IntranetDW_v5
                    (
                        DATA_INDICE,
                        ANO_INDICE,
                        MES_INDICE,
                        COD_DR,
                        NOME_DR,
                        GEREN,
                        NOMEGEREN,
                        REGION,
                        NOMEREGION,
                        SUPER,
                        NOMESUPER,
                        CODVEN,
                        NOMEVEN,
                        FILIALPEDIDO,
                        NUMPEDIDO,
                        PEDTRIN,
                        NUMITEM,
                        STATUSITEM,
                        STATUSPED,
                        CODPROD,
                        PRODDESC,
                        CATR1,
                        R1,
                        R1S,
                        CODCLI,
                        LOJACLI,
                        CLIENTE,
                        REDVEN,
                        REDVEN_DESC,
                        ESTADO,
                        CANAL,
                        ESPECIAIS_NOME,
                        ESPECIAIS_INDICE,
                        FATDIA,
                        CARTDIA,
                        CARTEIRA,
                        VENDIDO,
                        VALVEN,
                        VALENT,
                        PEDDIA,
                        QUANTFATDIA,
                        QUANTCARTDIA,
                        QUANTCARTEIRA,
                        QUANTVENDIDO,
                        QTDVEN,
                        QTDENT,
                        QUANTPEDDIA,
                        ORIGEM,
                        EMPRESA,
                        DATA_JOB,
                        DW_C5_EMISSAO,
                        DW_CARTEIRA
                    )

                    SELECT
                        CAST(D1_DTDIGIT AS DATE)                                              AS DATA_INDICE,
                        CAST(LEFT(D1_DTDIGIT, 4) AS INTEGER)                                  AS ANO_INDICE,
                        CAST(SUBSTRING(D1_DTDIGIT, 5, 2) AS INTEGER)                          AS MES_INDICE,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.COD_N5))                              AS COD_DR,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.NOME_N5))                             AS NOME_DR,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.COD_N4))                              AS GEREN,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.NOME_N4))                             AS NOMEGEREN,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.COD_N3))                              AS REGION,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.NOME_N3))                             AS NOMEREGION,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.COD_N2))                              AS SUPER,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.NOME_N2))                             AS NOMESUPER,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.COD_N1))                              AS CODVEN,
                        RTRIM(LTRIM(ESTRUTURA_COMERCIAL.NOME_N1))                             AS NOMEVEN,
                        D1_FILIAL                                                             AS FILIALPEDIDO,
                        C5_NUM                                                                AS NUMPEDIDO,
                        ''                                                                    AS PEDTRIN,
                        D1_ITEM                                                               AS NUMITEM,
                        NULL                                                                  AS STATUSITEM,
                        NULL                                                                  AS STATUSPED,
                        RTRIM(LTRIM(D1_COD))                                                  AS CODPROD,
                        RTRIM(LTRIM(B1_DESC))                                                 AS PRODDESC,
                        RTRIM(LTRIM(B1_ZCATR1))                                               AS CATR1,
                        ''                                                                    AS R1,
                        ''                                                                    AS R1S,
                        RTRIM(LTRIM(D1_FORNECE))                                              AS CODCLI,
                        RTRIM(LTRIM(D1_LOJA))                                                 AS LOJACLI,
                        RTRIM(LTRIM(A1_NOME))                                                 AS CLIENTE,
                        RTRIM(LTRIM(MAIN.A1_REDVEN))                                          AS REDVEN,
                        RTRIM(LTRIM(MAIN.AC0_DESCRI))                                         AS REDVEN_DESC,
                        RTRIM(LTRIM(MAIN.A1_EST))                                             AS ESTADO,
                        RTRIM(LTRIM(MAIN.Z6_DESCRI))                                          AS CANAL,
                        ''                                                                    AS ESPECIAIS_NOME,
                        ''                                                                    AS ESPECIAIS_INDICE,
                        D1_TOTAL * -1                                                         AS FATDIA,
                        0                                                                     AS CARTDIA,
                        0                                                                     AS CARTEIRA,
                        0                                                                     AS VENDIDO,
                        0                                                                     AS VALVEN,
                        0                                                                     AS VALENT,
                        D1_TOTAL * -1                                                         AS PEDDIA,
                        D1_QUANT * -1                                                         AS QUANTFATDIA,
                        0                                                                     AS QUANTCARTDIA,
                        0                                                                     AS QUANTCARTEIRA,
                        D1_QUANT * -1                                                         AS QUANTVENDIDO,
                        D1_QUANT * -1                                                         AS QTDVEN,
                        0                                                                     AS QTDENT,
                        D1_QUANT * -1                                                         AS QUANTPEDDIA,
                        IIF(UD_ASSUNTO IS NOT NULL AND D1_FORMUL = 'S', 'TROCA', 'DEVOLUCAO') AS ORIGEM,
                        EMPRESAS.CODIGO_ALFANUMERICO                                          AS EMPRESA,
                        GETDATE()                                                             AS DATA_JOB,
                        NULL                                                                  AS DW_C5_EMISSAO,
                        NULL                                                                  AS DW_CARTEIRA
                    FROM #TempMain AS MAIN
                    JOIN PORTALEBBAPROTHEUS.dbo.EMPRESAS
                        ON
                            EMPRESAS.EMPRESA_ID COLLATE DATABASE_DEFAULT = MAIN.EMPRESA_ID COLLATE DATABASE_DEFAULT
                    LEFT JOIN (
                        SELECT
                            D2_DOC, D2_LOJA, D2_CLIENTE, D2_PEDIDO, EMPRESA_ID, D2_FILIAL
                        FROM
                            PORTALEBBAPROTHEUS.dbo.SD2
                        WHERE
                            SD2.D_E_L_E_T_ = ''
                        GROUP BY
                            D2_DOC, D2_LOJA, D2_CLIENTE, D2_PEDIDO, EMPRESA_ID, D2_FILIAL
                        ) AS SD2
                        ON
                            D2_CLIENTE = D1_FORNECE AND
                            D2_LOJA = D1_LOJA AND
                            D2_DOC = D1_NFORI AND
                            CASE
                                WHEN SD2.EMPRESA_ID = '10' AND D2_FILIAL = '01' THEN '27'
                                WHEN SD2.EMPRESA_ID = '10' AND D2_FILIAL = '02' THEN '28'
                                WHEN SD2.EMPRESA_ID = '10' AND D2_FILIAL = '03' THEN '29'
                                WHEN SD2.EMPRESA_ID = '10' AND D2_FILIAL = '04' THEN '30'
                                WHEN SD2.EMPRESA_ID = '11' AND D2_FILIAL = '01' THEN '31'
                                WHEN SD2.EMPRESA_ID = '11' AND D2_FILIAL = '02' THEN '21'
                                ELSE D2_FILIAL
                            END = D1_FILIAL AND
                            CASE
                                WHEN SD2.EMPRESA_ID = '10' THEN '06'
                                WHEN SD2.EMPRESA_ID = '11' THEN '06'
                                ELSE '06'
                            END = MAIN.EMPRESA_ID
                    JOIN PORTALEBBAPROTHEUS.dbo.SC5 AS SC5
                        ON
                            C5_NUM = D2_PEDIDO AND
                            CASE
                                WHEN SC5.EMPRESA_ID = '10' AND C5_FILIAL = '01' THEN '27'
                                WHEN SC5.EMPRESA_ID = '10' AND C5_FILIAL = '02' THEN '28'
                                WHEN SC5.EMPRESA_ID = '10' AND C5_FILIAL = '03' THEN '29'
                                WHEN SC5.EMPRESA_ID = '10' AND C5_FILIAL = '04' THEN '30'
                                WHEN SC5.EMPRESA_ID = '11' AND C5_FILIAL = '01' THEN '31'
                                WHEN SC5.EMPRESA_ID = '11' AND C5_FILIAL = '02' THEN '21'
                                ELSE C5_FILIAL
                            END = D2_FILIAL AND
                            C5_LOJACLI = D2_LOJA AND
                            C5_CLIENTE = D2_CLIENTE AND
                            CASE
                                WHEN SC5.EMPRESA_ID = '10' THEN '06'
                                WHEN SC5.EMPRESA_ID = '11' THEN '06'
                                ELSE '06'
                            END = SD2.EMPRESA_ID AND
                            SC5.D_E_L_E_T_ = '' AND
                            (SC5.C5_EMISSAO BETWEEN
                                CONCAT(CAST(LEFT(@data_ini, 4) AS INTEGER) - 6,RIGHT(@data_ini,4)) AND @data_fim)
                    JOIN PORTALEBBAPROTHEUS.dbo.ESTRUTURA_COMERCIAL
                        ON
                            ESTRUTURA_COMERCIAL.COD_N1 COLLATE DATABASE_DEFAULT = IIF(SC5.C5_VN1_VN2 = '2' AND A1_VEND2 <> '', A1_VEND2, A1_VEND)
                    LEFT JOIN (
                        SELECT
                            DISTINCT UC_NUMNF, UC_FILIAL, SUC.EMPRESA_ID AS EMPRESA_ID, UD_ASSUNTO
                        FROM
                            PORTALEBBAPROTHEUS.dbo.SUC
                        JOIN PORTALEBBAPROTHEUS.dbo.SUD
                            ON
                                UD_FILIAL = UC_FILIAL AND
                                UD_CODIGO = UC_CODIGO AND
                                SUD.EMPRESA_ID  = SUC.EMPRESA_ID  AND
                                UD_ASSUNTO = '000013'
                        WHERE
                            SUC.D_E_L_E_T_ = '' AND
                            SUD.D_E_L_E_T_ = '' AND
                            UC_CODCANC = ''
                        ) AS CALLCENTER
                        ON
                            UC_NUMNF = D1_NFORI AND
                            UC_FILIAL = D1_FILIAL AND
                            CALLCENTER.EMPRESA_ID COLLATE DATABASE_DEFAULT = MAIN.EMPRESA_ID COLLATE DATABASE_DEFAULT AND
                            (D1_DTDIGIT BETWEEN @data_ini AND @data_fim)

FETCH curSE1 
                INTO @nValor , @nSaldo , @nValLiq , @nVlcruz , @cCliente , @cLoja , @nMoeda , @cEmissao , @cTipo , @cVencto , 
                      @cVencReal , @cBaixa , @cPrefixo , @cNum , @cParcela , @cOrigem , @cFatura , @cMsFil , @cPedido , @cSerie 
            

SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1

UPDATE controladoria.margem SET estdest = LTRIM(RTRIM(X5_DESCRI))
            FROM controladoria.margem MAR
                     LEFT JOIN DADOSADV12.dbo.SA1060 SA1 ON SA1.D_E_L_E_T_ = '' AND SA1.A1_COD = MAR.codcli COLLATE SQL_Latin1_General_CP437_BIN AND SA1.A1_LOJA = MAR.lojacli COLLATE SQL_Latin1_General_CP437_BIN
                     LEFT JOIN DADOSADV12.dbo.SA2060 SA2 ON SA2.D_E_L_E_T_ = '' AND SA2.A2_COD = MAR.codcli COLLATE SQL_Latin1_General_CP437_BIN AND SA2.A2_LOJA = MAR.lojacli COLLATE SQL_Latin1_General_CP437_BIN
                     LEFT JOIN DADOSADV12.dbo.SX5060 EST ON EST.D_E_L_E_T_ = '' AND EST.X5_TABELA = '12' AND EST.X5_CHAVE = ISNULL(A1_EST, A2_EST)
            WHERE MAR.estdest <> X5_DESCRI COLLATE SQL_Latin1_General_CP437_BIN

UPDATE SA2060 
                    WITH (ROWLOCK) 
                     SET A2_SALDUP  = @nA2_SALDUP , A2_SALDUPM  = @nA2_SALDUPM , A2_PRICOM  = @cA2_PRICOM , A2_ULTCOM  = @cA2_ULTCOM 
                    , A2_MCOMPRA  = @nA2_MCOMPRA , A2_MNOTA  = @nA2_MNOTA , A2_NROCOM  = @nA2_NROCOM , A2_MSALDO  = @nA2_MSALDO 
                    
                   WHERE A2_FILIAL  = @cFilial_A2  and A2_COD  = @cFornece  and A2_LOJA  = @cLoja  and D_E_L_E_T_  = ' '

INSERT INTO dre_distrital_consolidado
            (chave, mes, valor, grupo_distrital_id, tipo_relatorio, origem, created_at)
            SELECT
                dre.chave,
                '202603' AS mes,
                SUM(CT2_VALOR) AS valor,
                COALESCE(
                    grupo_distritais_chave_exclusiva.grupo_distrital_id,
                    grupo_distritais_centro_custo.grupo_distrital_id
                ) AS grupo_distrital_id,
                '0' AS tipo_relatorio,
                'ct2' AS origem,
                GETDATE() AS created_at
            FROM (
            -- D�BITO
            SELECT
                CT2_CCD AS CHAVE_CC,
                CT2_DEBITO AS CHAVE_CONTA,
                CT2_VALOR * -1 AS CT2_VALOR
            FROM PORTALEBBAPROTHEUS.dbo.CT2
            WHERE
                CT2.D_E_L_E_T_ = ''
                AND CT2_VALOR <> 0
                AND LEFT(CT2_DATA, 6) = '202603'

            UNION ALL

            -- CR�DITO
            SELECT
                CT2_CCC AS CHAVE_CC,
                CT2_CREDIT AS CHAVE_CONTA,
                CT2_VALOR
            FROM PORTALEBBAPROTHEUS.dbo.CT2
            WHERE
                CT2.D_E_L_E_T_ = ''
                AND CT2_VALOR <> 0
                AND LEFT(CT2_DATA, 6) = '202603'
        ) AS CT2_UNION
             LEFT JOIN dre_grupo_distritais_centro_custo AS grupo_distritais_centro_custo
                ON grupo_distritais_centro_custo.codigo_centro_custo = LTRIM(RTRIM(CHAVE_CC)) COLLATE DATABASE_DEFAULT 
            -- CHAVES DRE - CC ignorado quando vazio na movimenta��o ou igual a 999999 no agrupamento do DRE
            OUTER APPLY(
                SELECT TOP 1 dre_c.chave
                FROM PORTALEBBA.dbo.dre_chaves as dre_c
                INNER JOIN PORTALEBBA.dbo.dre_agrupamentos dre_a ON
                    dre_c.id = dre_a.dre_chave_id
                    AND LTRIM(RTRIM(dre_a.conta)) = LTRIM(RTRIM(CT2_UNION.CHAVE_CONTA)) COLLATE DATABASE_DEFAULT
                    AND LTRIM(RTRIM(dre_a.centro_custo)) = IIF(
                        LTRIM(RTRIM(CT2_UNION.CHAVE_CC)) = '' OR LTRIM(RTRIM(dre_a.centro_custo)) = '999999',
                        LTRIM(RTRIM(dre_a.centro_custo)),
                        LTRIM(RTRIM(CT2_UNION.CHAVE_CC)) COLLATE DATABASE_DEFAULT
                    )
            ) AS dre
            LEFT JOIN
                dre_grupo_distritais_chave_exclusiva AS grupo_distritais_chave_exclusiva ON
                grupo_distritais_chave_exclusiva.chave = dre.chave
            WHERE
                dre.chave != ''
            GROUP BY
                dre.chave,
                COALESCE(
                    grupo_distritais_chave_exclusiva.grupo_distrital_id,
                    grupo_distritais_centro_custo.grupo_distrital_id
                )

ALTER INDEX [RU60601] ON [dbo].[RU6060] REBUILD

ALTER INDEX [FWTSFWSCHDSMART_EXECUTE1] ON [dbo].[FWTSFWSCHDSMART_EXECUTE] REBUILD

ALTER INDEX [V8B0601] ON [dbo].[V8B060] REBUILD

ALTER INDEX [RFT0601] ON [dbo].[RFT060] REBUILD

ALTER INDEX [RFT060_UNQ] ON [dbo].[RFT060] REBUILD

ALTER INDEX [CJ3060_UNQ] ON [dbo].[CJ3060] REBUILD

ALTER INDEX [SC5060_TTAT_LOG2] ON [dbo].[SC5060_TTAT_LOG] REBUILD

ALTER INDEX [SC6060_TTAT_LOG5] ON [dbo].[SC6060_TTAT_LOG] REBUILD

ALTER INDEX [CC6060_PK] ON [dbo].[CC6060] REBUILD

ALTER INDEX [SC9060_TTAT_LOG2] ON [dbo].[SC9060_TTAT_LOG] REBUILD

ALTER INDEX [SC5060_TTAT_LOG5] ON [dbo].[SC5060_TTAT_LOG] REBUILD

ALTER INDEX [SC5060_TTAT_LOG1] ON [dbo].[SC5060_TTAT_LOG] REBUILD

ALTER INDEX [SC6060_TTAT_LOG2] ON [dbo].[SC6060_TTAT_LOG] REBUILD

ALTER INDEX [SC9060_TTAT_LOG5] ON [dbo].[SC9060_TTAT_LOG] REBUILD

ALTER INDEX [C9Q0603] ON [dbo].[C9Q060] REBUILD

ALTER INDEX [CJ30602] ON [dbo].[CJ3060] REBUILD

ALTER INDEX [F2D0601] ON [dbo].[F2D060] REBUILD

ALTER INDEX [F2D060_UNQ] ON [dbo].[F2D060] REBUILD

ALTER INDEX [AC8060_PK] ON [dbo].[AC8060] REBUILD

ALTER INDEX [SBJ0601] ON [dbo].[SBJ060] REBUILD

ALTER INDEX [SC9060_TTAT_LOG1] ON [dbo].[SC9060_TTAT_LOG] REBUILD

ALTER INDEX [SBJ0602] ON [dbo].[SBJ060] REBUILD

ALTER INDEX [SC6060_TTAT_LOG1] ON [dbo].[SC6060_TTAT_LOG] REBUILD

ALTER INDEX [CXN100_PK] ON [dbo].[CXN100] REBUILD

ALTER INDEX [F2D0606] ON [dbo].[F2D060] REBUILD

ALTER INDEX [SBJ060_UNQ] ON [dbo].[SBJ060] REBUILD

ALTER INDEX [CJ30601] ON [dbo].[CJ3060] REBUILD

ALTER INDEX [SC8060_PK] ON [dbo].[SC8060] REBUILD

ALTER INDEX [CC6100_PK] ON [dbo].[CC6100] REBUILD

ALTER INDEX [CNB100_PK] ON [dbo].[CNB100] REBUILD

ALTER INDEX [CXN110_PK] ON [dbo].[CXN110] REBUILD

ALTER INDEX [CJ30603] ON [dbo].[CJ3060] REBUILD

ALTER INDEX [SRC0605] ON [dbo].[SRC060] REBUILD

ALTER INDEX [SB90601] ON [dbo].[SB9060] REBUILD

ALTER INDEX [F2D0603] ON [dbo].[F2D060] REBUILD

ALTER INDEX [SA1060_TTAT_LOG4] ON [dbo].[SA1060_TTAT_LOG] REBUILD

ALTER INDEX [SA1060_TTAT_LOG2] ON [dbo].[SA1060_TTAT_LOG] REBUILD

ALTER INDEX [CM6060_UNQ] ON [dbo].[CM6060] REBUILD

ALTER INDEX [FK5100_PK] ON [dbo].[FK5100] REBUILD

ALTER INDEX [CNB060_PK] ON [dbo].[CNB060] REBUILD

ALTER INDEX [F2D0602] ON [dbo].[F2D060] REBUILD

ALTER INDEX [SCR060_PK] ON [dbo].[SCR060] REBUILD

ALTER INDEX [RFT0602] ON [dbo].[RFT060] REBUILD

ALTER INDEX [SB9060_UNQ] ON [dbo].[SB9060] REBUILD

ALTER INDEX [RJO0602] ON [dbo].[RJO060] REBUILD

ALTER INDEX [CNA060_PK] ON [dbo].[CNA060] REBUILD

ALTER INDEX [V8B0603] ON [dbo].[V8B060] REBUILD

ALTER INDEX [CNB110_PK] ON [dbo].[CNB110] REBUILD

ALTER INDEX [SB3060_PK] ON [dbo].[SB3060] REBUILD

ALTER INDEX [SA1060_TTAT_LOG3] ON [dbo].[SA1060_TTAT_LOG] REBUILD

UPDATE STATISTICS [dbo].[SA1060] [_WA_Sys_00000044_5C23696B] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060] [_WA_Sys_00000039_5C23696B] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060] [_WA_Sys_00000051_5C23696B] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060] [_WA_Sys_0000003B_5C23696B] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060] [_WA_Sys_0000003C_5C23696B] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [SC9060_TTAT_LOG3] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [SC9060_TTAT_LOG4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [SC9060_TTAT_LOG5] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [SC9060_TTAT_LOG6] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [SC9060_TTAT_LOG7] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [SC9060_TTAT_LOG1] WITH FULLSCAN

UPDATE STATISTICS [dbo].[C35060] [_WA_Sys_00000006_1581FB69] WITH FULLSCAN

UPDATE STATISTICS [dbo].[C35060] [_WA_Sys_00000007_1581FB69] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [SC9060_TTAT_LOG2] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [_WA_Sys_0000000C_3E9741C8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [_WA_Sys_00000003_3E9741C8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [_WA_Sys_00000002_3E9741C8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC9060_TTAT_LOG] [_WA_Sys_00000005_3E9741C8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SB2060] [_WA_Sys_00000018_17EF1F95] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SB2060] [_WA_Sys_00000014_17EF1F95] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [SC6060_TTAT_LOG1] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [SC6060_TTAT_LOG2] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [SC6060_TTAT_LOG3] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [SC6060_TTAT_LOG4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [SC6060_TTAT_LOG5] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [SC6060_TTAT_LOG6] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [SC6060_TTAT_LOG7] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [_WA_Sys_0000000C_7DBDA2A4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [_WA_Sys_00000003_7DBDA2A4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC6060_TTAT_LOG] [_WA_Sys_00000002_7DBDA2A4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [SA1060_TTAT_LOG1] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [SA1060_TTAT_LOG2] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [SA1060_TTAT_LOG3] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [SA1060_TTAT_LOG4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [SA1060_TTAT_LOG5] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [SA1060_TTAT_LOG6] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [SA1060_TTAT_LOG7] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [_WA_Sys_0000000C_2E60D9FF] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [_WA_Sys_00000003_2E60D9FF] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA1060_TTAT_LOG] [_WA_Sys_00000002_2E60D9FF] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_00000031_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_0000002F_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_0000002B_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_00000027_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_0000005B_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CSB060] [_WA_Sys_00000005_59B2A7C2] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_00000029_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_0000002A_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SA2060] [_WA_Sys_0000002C_51A5DAF8] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SC2060] [_WA_Sys_0000007F_5A55F926] WITH FULLSCAN

UPDATE SFT060 SET D_E_L_E_T_ = ' ' WHERE R_E_C_N_O_ IN (  SELECT SFT.R_E_C_N_O_ FROM V5R060 V5R  (NOLOCK)  LEFT JOIN SFT060 SFT  (NOLOCK)  ON SFT.FT_FILIAL = V5R.V5R_CODFIL  AND SFT.FT_TIPOMOV = RTRIM( ( CASE WHEN SUBSTRING( V5R.V5R_ERPKEY , 1 , 1 ) = '0' THEN 'E' ELSE 'S' END ) )  AND SFT.FT_ENTRADA = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 3 , 8 ) )  AND SFT.FT_SERIE = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 12 , 20 ) )  AND SFT.FT_NFISCAL = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 33 , 60 ) )  AND SFT.FT_CLIEFOR = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 94 , 6 ) )  AND SFT.FT_LOJA = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 101 , 2 ) )  AND SFT.D_E_L_E_T_ = ' '  WHERE  V5R.V5R_FILIAL = '  '  AND V5R.V5R_DATA < '20260325'  AND V5R.V5R_ALIAS = 'C20'  AND V5R.D_E_L_E_T_ = ' '  )

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE SFT060 SET D_E_L_E_T_ = ' ' WHERE R_E_C_N_O_ IN (  SELECT SFT.R_E_C_N_O_ FROM V5R060 V5R  (NOLOCK)  LEFT JOIN SFT060 SFT  (NOLOCK)  ON SFT.FT_FILIAL = V5R.V5R_CODFIL  AND SFT.FT_TIPOMOV = RTRIM( ( CASE WHEN SUBSTRING( V5R.V5R_ERPKEY , 1 , 1 ) = '0' THEN 'E' ELSE 'S' END ) )  AND SFT.FT_ENTRADA = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 3 , 8 ) )  AND SFT.FT_SERIE = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 12 , 20 ) )  AND SFT.FT_NFISCAL = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 33 , 60 ) )  AND SFT.FT_CLIEFOR = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 94 , 6 ) )  AND SFT.FT_LOJA = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 101 , 2 ) )  AND SFT.D_E_L_E_T_ = ' '  WHERE  V5R.V5R_FILIAL = '  '  AND V5R.V5R_DATA &lt; '20260325'  AND V5R.V5R_ALIAS = 'C20'  AND V5R.D_E_L_E_T_ = ' '  )" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="true" StatementSubTreeCost="235.121" StatementEstRows="51727.9" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xDA5C2476F937FE1F" QueryPlanHash="0xC7274458864F890F" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="1040" CompileTime="124" CompileCPU="111" CompileMemory="6496"><ThreadStat Branches="3"/><MissingIndexes><MissingIndexGroup Impact="10.2141"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[V5R060]"><ColumnGroup Usage="EQUALITY"><Column Name="[V5R_FILIAL]" ColumnId="1"/><Column Name="[V5R_ALIAS]" ColumnId="3"/><Column Name="[D_E_L_E_T_]" ColumnId="10"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[V5R_DATA]" ColumnId="6"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[V5R_CODFIL]" ColumnId="2"/><Column Name="[V5R_ERPKEY]" ColumnId="9"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="3584" SerialDesiredMemory="62880"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110435328"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="1" PhysicalOp="Sequence" LogicalOp="Sequence" EstimateRows="3544.36" EstimateIO="0" EstimateCPU="0.0708872" AvgRowSize="9" EstimatedTotalSubtreeCost="235.121" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList/><Sequence><RelOp NodeId="2" PhysicalOp="Index Update" LogicalOp="Update" EstimateRows="3544.36" EstimateIO="0.106625" EstimateCPU="0.00354436" AvgRowSize="9" EstimatedTotalSubtreeCost="11.6941" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList/><Update WithOrderedPrefetch="1" DMLRequestSort="1"><Object Database="[DADOSADV12]" Schema="[dbo]" Table="[SFT060]" Index="[SFT0602]" IndexKind="NonClustered" Storage="RowStore"/><SetPredicate><ScalarOperator ScalarString="[R_E_C_N_O_1059] = [DADOSADV12].[dbo].[SFT060].[R_E_C_N_O_],[FT_FILIAL1060] = [DADOSADV12].[dbo].[SFT060].[FT_FILIAL],[FT_ENTRADA1061] = [DADOSADV12].[dbo].[SFT060].[FT_ENTRADA],[FT_NFISCAL1062] = [DADOSADV12].[dbo].[SFT060].[FT_NFISCAL],[FT_SERIE1063] = [DADOSADV12].[dbo].[SFT060].[FT_SERIE],[FT_CLIEFOR1064] = [DADOSADV12].[dbo].[SFT060].[FT_CLIEFOR],[FT_LOJA1065] = [DADOSADV12].[dbo].[SFT060].[FT_LOJA],[FT_PRODUTO1066] = [DADOSADV12].[dbo].[SFT060].[FT_PRODUTO],[FT_TIPOMOV1067] = [DADOSADV12].[dbo].[SFT060].[FT_TIPOMOV],[FT_ITEM1068] = [DADOSADV12].[dbo].[SFT060].[FT_ITEM],[D_E_L_E_T_1069] = [DADOSADV12].[dbo].[SFT060].[D_E_L_E_T_]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Column="R_E_C_N_O_1059... [PLANO TRUNCADO - Consulte via SSMS]

UPDATE SF3060 SET D_E_L_E_T_ = ' ' WHERE R_E_C_N_O_ IN (  SELECT SF3.R_E_C_N_O_ FROM V5R060 V5R  (NOLOCK)  LEFT JOIN SF3060 SF3  (NOLOCK)  ON SF3.F3_FILIAL = V5R.V5R_CODFIL  AND SF3.F3_ENTRADA = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 3 , 8 ) )  AND RTRIM(SF3.F3_SERIE) = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 12 , 20 ) )  AND RTRIM(SF3.F3_NFISCAL) = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 33 , 60 ) )  AND RTRIM(SF3.F3_CLIEFOR) = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 94 , 6 ) )  AND RTRIM(SF3.F3_LOJA) = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 101 , 2 ) )  AND (  (RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 1 , 1 ) ) = '0' AND SF3.F3_CFO <= '4000' )  OR  (RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 1 , 1 ) ) = '1' AND SF3.F3_CFO > '5000' )  )  AND SF3.D_E_L_E_T_ = ' '  WHERE  V5R.V5R_FILIAL = '  '  AND V5R.V5R_DATA < '20260325'  AND V5R.V5R_ALIAS = 'C20'  AND V5R.D_E_L_E_T_ = ' '  )

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE SF3060 SET D_E_L_E_T_ = ' ' WHERE R_E_C_N_O_ IN (  SELECT SF3.R_E_C_N_O_ FROM V5R060 V5R  (NOLOCK)  LEFT JOIN SF3060 SF3  (NOLOCK)  ON SF3.F3_FILIAL = V5R.V5R_CODFIL  AND SF3.F3_ENTRADA = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 3 , 8 ) )  AND RTRIM(SF3.F3_SERIE) = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 12 , 20 ) )  AND RTRIM(SF3.F3_NFISCAL) = RTRIM( SUBSTRING( V5R.V5R_ERPKEY , 33 , 60 ) )  AND RTRIM(SF3.F3_CLIEFOR) = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 94 , 6 ) )  AND RTRIM(SF3.F3_LOJA) = RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 101 , 2 ) )  AND (  (RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 1 , 1 ) ) = '0' AND SF3.F3_CFO &lt;= '4000' )  OR  (RTRIM(SUBSTRING( V5R.V5R_ERPKEY , 1 , 1 ) ) = '1' AND SF3.F3_CFO &gt; '5000' )  )  AND SF3.D_E_L_E_T_ = ' '  WHERE  V5R.V5R_FILIAL = '  '  AND V5R.V5R_DATA &lt; '20260325'  AND V5R.V5R_ALIAS = 'C20'  AND V5R.D_E_L_E_T_ = ' '  )" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="true" StatementSubTreeCost="51.1246" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xC4AC2E85DEABA861" QueryPlanHash="0x9952D974B2DE9A31" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="208" CompileTime="111" CompileCPU="107" CompileMemory="4224"><ThreadStat Branches="2"/><MissingIndexes><MissingIndexGroup Impact="47.0506"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[V5R060]"><ColumnGroup Usage="EQUALITY"><Column Name="[V5R_FILIAL]" ColumnId="1"/><Column Name="[V5R_ALIAS]" ColumnId="3"/><Column Name="[D_E_L_E_T_]" ColumnId="10"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[V5R_DATA]" ColumnId="6"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[V5R_CODFIL]" ColumnId="2"/><Column Name="[V5R_ERPKEY]" ColumnId="9"/></ColumnGroup></MissingIndex></MissingIndexGroup><MissingIndexGroup Impact="44.5614"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[SF3060]"><ColumnGroup Usage="EQUALITY"><Column Name="[F3_ENTRADA]" ColumnId="2"/><Column Name="[F3_FILIAL]" ColumnId="63"/><Column Name="[D_E_L_E_T_]" ColumnId="102"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[F3_CFO]" ColumnId="7"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[F3_NFISCAL]" ColumnId="3"/><Column Name="[F3_SERIE]" ColumnId="4"/><Column Name="[F3_CLIEFOR]" ColumnId="5"/><Column Name="[F3_LOJA]" ColumnId="6"/><Column Name="[R_E_C_N_O_]" ColumnId="103"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="35416"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110435328"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="1" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="1" EstimateIO="0.13" EstimateCPU="1.3e-005" AvgRowSize="9" EstimatedTotalSubtreeCost="51.1246" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList/><Update DMLRequestSort="0"><Object Database="[DADOSADV12]" Schema="[dbo]" Table="[SF3060]" Index="[SF3060_PK]" IndexKind="Clustered" Storage="RowStore"/><Object Database="[DADOSADV12]" Schema="[dbo]" Table="[SF3060]" Index="[SF30602]" IndexKind="NonClustered" Storage="RowStore"/><Object Database="[DADOSADV12]" Schema="[dbo]" Table="[SF3060]" Index="[SF30603]" IndexKind="NonClustered" Storage="RowStore"/><Object Database="[DADOSADV12]" Schema="[dbo]" Table="[SF3060]" Index="[SF30604]" IndexKind="NonClustered" S... [PLANO TRUNCADO - Consulte via SSMS]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '16' AND C2_NUM  < '240990' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC 

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '16' AND C2_NUM  &lt; '240990' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="88.6867" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4DECAA4BD5210ABC" QueryPlanHash="0xBDBAE5B2DB1678BF" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="32" CompileTime="9" CompileCPU="9" CompileMemory="760"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.9507"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]"><ColumnGroup Usage="EQUALITY"><Column Name="[C2_FILIAL]" ColumnId="1"/><Column Name="[C2_DATPRI]" ColumnId="11"/><Column Name="[D_E_L_E_T_]" ColumnId="452"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[C2_NUM]" ColumnId="2"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[C2_ITEM]" ColumnId="3"/><Column Name="[C2_SEQUEN]" ColumnId="4"/><Column Name="[C2_ITEMGRD]" ColumnId="98"/><Column Name="[R_E_C_N_O_]" ColumnId="453"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110184920"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100043" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6867" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OutputList><MemoryFractions Input="1" Output="1"/><TopSort Distinct="0" Rows="250"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285065" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6753" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"... [PLANO TRUNCADO - Consulte via SSMS]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  < '16' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC 

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  &lt; '16' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="88.6777" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x422F4A980C823716" QueryPlanHash="0xCBB1BC717A98449E" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="32" CompileTime="9" CompileCPU="9" CompileMemory="728"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.9507"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]"><ColumnGroup Usage="EQUALITY"><Column Name="[C2_DATPRI]" ColumnId="11"/><Column Name="[D_E_L_E_T_]" ColumnId="452"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[C2_FILIAL]" ColumnId="1"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[C2_NUM]" ColumnId="2"/><Column Name="[C2_ITEM]" ColumnId="3"/><Column Name="[C2_SEQUEN]" ColumnId="4"/><Column Name="[C2_ITEMGRD]" ColumnId="98"/><Column Name="[R_E_C_N_O_]" ColumnId="453"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110184920"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100043" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6777" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OutputList><MemoryFractions Input="1" Output="1"/><TopSort Distinct="0" Rows="250"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285065" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6664" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecuti... [PLANO TRUNCADO - Consulte via SSMS]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  < '16' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC 

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  &lt; '16' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="88.6785" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x422F4A980C823716" QueryPlanHash="0xCBB1BC717A98449E" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="32" CompileTime="8" CompileCPU="8" CompileMemory="728"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.9507"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]"><ColumnGroup Usage="EQUALITY"><Column Name="[C2_DATPRI]" ColumnId="11"/><Column Name="[D_E_L_E_T_]" ColumnId="452"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[C2_FILIAL]" ColumnId="1"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[C2_NUM]" ColumnId="2"/><Column Name="[C2_ITEM]" ColumnId="3"/><Column Name="[C2_SEQUEN]" ColumnId="4"/><Column Name="[C2_ITEMGRD]" ColumnId="98"/><Column Name="[R_E_C_N_O_]" ColumnId="453"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110047216"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100043" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6785" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OutputList><MemoryFractions Input="1" Output="1"/><TopSort Distinct="0" Rows="250"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285065" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6671" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecuti... [PLANO TRUNCADO - Consulte via SSMS]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '16' AND C2_NUM  < '241058' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC 

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '16' AND C2_NUM  &lt; '241058' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="88.6874" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4DECAA4BD5210ABC" QueryPlanHash="0xBDBAE5B2DB1678BF" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="32" CompileTime="5" CompileCPU="5" CompileMemory="760"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.9507"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]"><ColumnGroup Usage="EQUALITY"><Column Name="[C2_FILIAL]" ColumnId="1"/><Column Name="[C2_DATPRI]" ColumnId="11"/><Column Name="[D_E_L_E_T_]" ColumnId="452"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[C2_NUM]" ColumnId="2"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[C2_ITEM]" ColumnId="3"/><Column Name="[C2_SEQUEN]" ColumnId="4"/><Column Name="[C2_ITEMGRD]" ColumnId="98"/><Column Name="[R_E_C_N_O_]" ColumnId="453"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110047216"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100043" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6874" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OutputList><MemoryFractions Input="1" Output="1"/><TopSort Distinct="0" Rows="250"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285065" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6761" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"... [PLANO TRUNCADO - Consulte via SSMS]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  > '02' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL,C2_NUM,C2_ITEM,C2_SEQUEN,C2_ITEMGRD,R_E_C_N_O_

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  &gt; '02' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL,C2_NUM,C2_ITEM,C2_SEQUEN,C2_ITEMGRD,R_E_C_N_O_" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="88.6777" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3BBC0C1B19837EB7" QueryPlanHash="0x0C33DF084B7861E5" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="32" CompileTime="7" CompileCPU="7" CompileMemory="728"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.9507"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]"><ColumnGroup Usage="EQUALITY"><Column Name="[C2_DATPRI]" ColumnId="11"/><Column Name="[D_E_L_E_T_]" ColumnId="452"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[C2_FILIAL]" ColumnId="1"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[C2_NUM]" ColumnId="2"/><Column Name="[C2_ITEM]" ColumnId="3"/><Column Name="[C2_SEQUEN]" ColumnId="4"/><Column Name="[C2_ITEMGRD]" ColumnId="98"/><Column Name="[R_E_C_N_O_]" ColumnId="453"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110163272"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100043" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6777" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OutputList><MemoryFractions Input="1" Output="1"/><TopSort Distinct="0" Rows="250"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285065" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6664" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnRef... [PLANO TRUNCADO - Consulte via SSMS]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  > '02' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL,C2_NUM,C2_ITEM,C2_SEQUEN,C2_ITEMGRD,R_E_C_N_O_

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  &gt; '02' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL,C2_NUM,C2_ITEM,C2_SEQUEN,C2_ITEMGRD,R_E_C_N_O_" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="88.6785" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3BBC0C1B19837EB7" QueryPlanHash="0x0C33DF084B7861E5" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="32" CompileTime="5" CompileCPU="5" CompileMemory="728"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.9507"><MissingIndex Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]"><ColumnGroup Usage="EQUALITY"><Column Name="[C2_DATPRI]" ColumnId="11"/><Column Name="[D_E_L_E_T_]" ColumnId="452"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[C2_FILIAL]" ColumnId="1"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[C2_NUM]" ColumnId="2"/><Column Name="[C2_ITEM]" ColumnId="3"/><Column Name="[C2_SEQUEN]" ColumnId="4"/><Column Name="[C2_ITEMGRD]" ColumnId="98"/><Column Name="[R_E_C_N_O_]" ColumnId="453"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110044808"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100043" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6785" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OutputList><MemoryFractions Input="1" Output="1"/><TopSort Distinct="0" Rows="250"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_FILIAL"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_NUM"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEM"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_SEQUEN"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="C2_ITEMGRD"/></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SC2060]" Column="R_E_C_N_O_"/></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285065" AvgRowSize="43" EstimatedTotalSubtreeCost="88.6671" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnRef... [PLANO TRUNCADO - Consulte via SSMS]

 SELECT COUNT(*) COUNT FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '1' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '1' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '4' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '4' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '9' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '9' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '2' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '2' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '6' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '6' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 TAB1 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '1' AND ZE0_SIT = '2' AND (EXISTS (SELECT 1 FROM ZE2000 TAB3 WHERE TAB3.ZE2_FILIAL = '  ' AND TAB3.ZE2_TIPO = '2' AND TAB3.ZE2_CHAVE = TAB1.ZE0_CHAVE AND TAB3.ZE2_RELAC = '1' AND TAB3.ZE2_SEQ = '001' AND TAB3.D_E_L_E_T_ = ' ')) AND TAB1.D_E_L_E_T_ = ' ' UNION ALL SELECT SUM(0) FROM ZE2000 WHERE 1 = 1 UNION ALL SELECT COUNT(*) FROM ZE0060 TAB1 WHERE ZE0_FILI... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText=" SELECT COUNT(*) COUNT FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '1' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '1' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '4' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '4' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '9' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '9' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '2' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '2' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '6' AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '6' AND ZE0_SIT IN ('1','3') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 TAB1 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '1' AND ZE0_SIT = '2' AND (EXISTS (SELECT 1 FROM ZE2000 TAB3 WHERE TAB3.ZE2_FILIAL = '  ' AND TAB3.ZE2_TIPO = '2' AND TAB3.ZE2_CHAVE = TAB1.ZE0_CHAVE AND TAB3.ZE2_RELAC = '1' AND TAB3.ZE2_SEQ = '001' AND TAB3.D_E_L_E_T_ = ' ')) AND TAB1.D_E_L_E_T_ = ' ' UNION ALL SELECT SUM(0) FROM ZE2000 WHERE 1 = 1 UNION ALL SELECT COUNT(*) FROM ZE0060 TAB1 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '4' AND ZE0_SIT = '2' AND (EXISTS (SELECT 1 FROM ZE2000 TAB3 WHERE TAB3.ZE2_FILIAL = '  ' AND TAB3.ZE2_TIPO = '2' AND TAB3.ZE2_CHAVE = TAB1.ZE0_ARQUIV AND TAB3.ZE2_RELAC = '4' AND TAB3.ZE2_SEQ = '001' AND TAB3.D_E_L_E_T_ = ' ')) AND TAB1.D_E_L_E_T_ = ' ' UNION ALL SELECT SUM(0) FROM ZE2000 WHERE 1 = 1 UNION ALL SELECT COUNT(*) FROM ZE0060 TAB1 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '2' AND ZE0_SIT = '2' AND (EXISTS (SELECT 1 FROM ZE2000 TAB3 WHERE TAB3.ZE2_FILIAL = '  ' AND TAB3.ZE2_TIPO = '2' AND TAB3.ZE2_CHAVE = TAB1.ZE0_CHAVE AND TAB3.ZE2_RELAC = '2' AND TAB3.ZE2_SEQ = '001' AND TAB3.D_E_L_E_T_ = ' ')) AND TAB1.D_E_L_E_T_ = ' ' UNION ALL SELECT SUM(0) FROM ZE2000 WHERE 1 = 1 UNION ALL SELECT COUNT(*) FROM ZE0060 TAB1 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO = '6' AND ZE0_SIT = '2' AND (EXISTS (SELECT 1 FROM ZE2000 TAB3 WHERE TAB3.ZE2_FILIAL = '  ' AND TAB3.ZE2_TIPO = '2' AND TAB3.ZE2_CHAVE = TAB1.ZE0_CHAVE AND TAB3.ZE2_RELAC = '6' AND TAB3.ZE2_SEQ = '001' AND TAB3.D_E_L_E_T_ = ' ')) AND TAB1.D_E_L_E_T_ = ' ' UNION ALL SELECT SUM(0) FROM ZE2000 WHERE 1 = 1 UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('6','7') AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('6','7') AND ZE0_TIPERR = '1' AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('6','7') AND ZE0_TIPERR = '2' AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1','2','4','6','9') AND ZE0_SIT IN ('6','7') AND ZE0_TIPERR = '3' AND D_E_L_E_T_ = ' ' UNION ALL SELECT COUNT(*) FROM ZE0060 WHERE ZE0_FILIAL = '16' AND ZE0_TIPO IN ('1',... [PLANO TRUNCADO - Consulte via SSMS]

UPDATE SE2060 SET E2_CCBCO = A2_CCBANC FROM SE2060 E2 INNER JOIN SA2060 A2 ON E2_FORNECE = A2_COD AND E2_LOJA = A2_LOJA AND A2_CCUSA = '1' AND A2.D_E_L_E_T_ = '' WHERE E2_FILIAL = '  ' AND E2_SALDO > 0 AND E2_CCBCO = '' AND E2.D_E_L_E_T_ = ''

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6475.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE SE2060 SET E2_CCBCO = A2_CCBANC FROM SE2060 E2 INNER JOIN SA2060 A2 ON E2_FORNECE = A2_COD AND E2_LOJA = A2_LOJA AND A2_CCUSA = '1' AND A2.D_E_L_E_T_ = '' WHERE E2_FILIAL = '  ' AND E2_SALDO &gt; 0 AND E2_CCBCO = '' AND E2.D_E_L_E_T_ = ''" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="true" StatementSubTreeCost="74.8488" StatementEstRows="26111.4" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x1AF7552CE0DFC851" QueryPlanHash="0xC2729E56033DD8C4" CardinalityEstimationModelVersion="70"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan CachedPlanSize="72" CompileTime="50" CompileCPU="49" CompileMemory="2800"><ThreadStat Branches="2"/><MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="27024"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="344328" EstimatedPagesCached="1032985" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="110957480"/><TraceFlags IsCompileTime="1"><TraceFlag Value="1117" Scope="Global"/><TraceFlag Value="1118" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="26111.4" EstimateIO="12.8403" EstimateCPU="0.0261114" AvgRowSize="9" EstimatedTotalSubtreeCost="74.8488" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList/><Update DMLRequestSort="0"><Object Database="[DADOSADV12]" Schema="[dbo]" Table="[SE2060]" Index="[SE2060_PK]" IndexKind="Clustered" Storage="RowStore"/><SetPredicate><ScalarOperator ScalarString="[DADOSADV12].[dbo].[SE2060].[E2_CCBCO] = [DADOSADV12].[dbo].[SA2060].[A2_CCBANC] as [A2].[A2_CCBANC]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SE2060]" Column="E2_CCBCO"/><ScalarOperator><Identifier><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SA2060]" Alias="[A2]" Column="A2_CCBANC"/></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="26111.4" EstimateIO="0" EstimateCPU="0.0373175" AvgRowSize="16" EstimatedTotalSubtreeCost="61.9824" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SE2060]" Alias="[E2]" Column="R_E_C_N_O_"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SA2060]" Alias="[A2]" Column="A2_CCBANC"/></OutputList><Parallelism><RelOp NodeId="2" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="26111.4" EstimateIO="0" EstimateCPU="0.0906759" AvgRowSize="16" EstimatedTotalSubtreeCost="61.945" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SE2060]" Alias="[E2]" Column="R_E_C_N_O_"/><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SA2060]" Alias="[A2]" Column="A2_CCBANC"/></OutputList><MemoryFractions Input="0.119272" Output="1"/><Hash><DefinedValues><DefinedValue><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SA2060]" Alias="[A2]" Column="A2_CCBANC"/><ScalarOperator ScalarString="ANY([DADOSADV12].[dbo].[SA2060].[A2_CCBANC] as [A2].[A2_CCBANC])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[DADOSADV12]" Schema="[dbo]" Table="[SA2060]" Alias="[A2]" Column="A2_CCBANC"/></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[... [PLANO TRUNCADO - Consulte via SSMS]

[DADOSADV12].[dbo].[ZE2000]

[D_E_L_E_T_], [ZE2_CHAVE], [ZE2_RELAC], [ZE2_SEQ], [ZE2_TIPO]

 SELECT 1 FROM ZE2000 WHERE ZE2_TIPO = '2' AND ZE2_CHAVE = '35260310795414000108570000003833371390599859' AND ZE2_RELAC = '2' AND ZE2_SEQ = '001' AND D_E_L_E_T_ = ' '

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [D_E_L_E_T_]

[C2_FILIAL]

[C2_ITEMGRD], [C2_ITEM], [C2_NUM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  > '02' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL,C2_NUM,C2_ITEM,C2_SEQUEN,C2_ITEMGRD,R_E_C_N_O_

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [C2_FILIAL], [D_E_L_E_T_]

[C2_NUM]

[C2_ITEMGRD], [C2_ITEM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '16' AND C2_NUM  < '240990' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [C2_FILIAL], [D_E_L_E_T_]

[C2_NUM]

[C2_ITEMGRD], [C2_ITEM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '02' AND C2_NUM  < '645848' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [D_E_L_E_T_]

[C2_FILIAL]

[C2_ITEMGRD], [C2_ITEM], [C2_NUM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  > '02' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL,C2_NUM,C2_ITEM,C2_SEQUEN,C2_ITEMGRD,R_E_C_N_O_

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [C2_FILIAL], [D_E_L_E_T_]

[C2_NUM]

[C2_ITEMGRD], [C2_ITEM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '02' AND C2_NUM  < '645846' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [C2_FILIAL], [D_E_L_E_T_]

[C2_NUM]

[C2_ITEMGRD], [C2_ITEM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '02' AND C2_NUM  < '645854' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [C2_FILIAL], [D_E_L_E_T_]

[C2_NUM]

[C2_ITEMGRD], [C2_ITEM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL = '16' AND C2_NUM  < '241058' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [D_E_L_E_T_]

[C2_FILIAL]

[C2_ITEMGRD], [C2_ITEM], [C2_NUM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  < '16' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260325') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SC2060]

[C2_DATPRI], [D_E_L_E_T_]

[C2_FILIAL]

[C2_ITEMGRD], [C2_ITEM], [C2_NUM], [C2_SEQUEN], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SC2060 WHERE  C2_FILIAL  < '16' AND D_E_L_E_T_ = ' ' AND (C2_DATPRI = '20260326') ORDER BY C2_FILIAL DESC ,C2_NUM DESC ,C2_ITEM DESC ,C2_SEQUEN DESC ,C2_ITEMGRD DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SE1060]

[D_E_L_E_T_], [E1_FILIAL], [E1_NUM]

[E1_CLIENTE], [E1_LOJA], [E1_PARCELA], [E1_PREFIXO], [E1_SALDO]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SE1060 WHERE D_E_L_E_T_ = ' ' AND (E1_FILIAL = '  ' AND E1_SALDO > 0 AND E1_PREFIXO >= '000' AND E1_PREFIXO <= 'ZZZ' AND E1_NUM = '001321846' AND E1_NUM = '001321846' AND E1_PARCELA >= '   ' AND E1_PARCELA <= 'zzz' AND E1_CLIENTE >= '      ' AND E1_CLIENTE <= 'ZZZZZZ' AND E1_LOJA >= '  ' AND E1_LOJA <= 'ZZ' AND  NOT ( ( CHARINDEX(CONVERT(CHAR(3),( E1_TIPO )),( 'AB-|CF-|CS-|FB-|FC-|FE-|FM-|FP-|FU-|GN-|I2-|IB-|IM-|IN-|IR-|IS-|IV-|MN-|PI-|FC-|FE-' ))>0  ) )) ORDER BY E1_FILIAL DESC ,E1_PREFIXO DESC ,E1_NUM DESC ,E1_PARCELA DESC ,E1_TIPO DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SE1060]

[D_E_L_E_T_], [E1_FILIAL], [E1_NUM]

[E1_CLIENTE], [E1_LOJA], [E1_PARCELA], [E1_PREFIXO], [E1_SALDO]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SE1060 WHERE D_E_L_E_T_ = ' ' AND (E1_FILIAL = '  ' AND E1_SALDO > 0 AND E1_PREFIXO >= '000' AND E1_PREFIXO <= 'ZZZ' AND E1_NUM = '001321846' AND E1_NUM = '001321846' AND E1_PARCELA >= '   ' AND E1_PARCELA <= 'zzz' AND E1_CLIENTE >= '      ' AND E1_CLIENTE <= 'ZZZZZZ' AND E1_LOJA >= '  ' AND E1_LOJA <= 'ZZ' AND  NOT ( ( CHARINDEX(CONVERT(CHAR(3),( E1_TIPO )),( 'AB-|CF-|CS-|FB-|FC-|FE-|FM-|FP-|FU-|GN-|I2-|IB-|IM-|IN-|IR-|IS-|IV-|MN-|PI-|FC-|FE-' ))>0  ) )) ORDER BY E1_FILIAL,E1_PREFIXO,E1_NUM,E1_PARCELA,E1_TIPO,R_E_C_N_O_

[DADOSADV12].[dbo].[SC5060]

[C5_COTACAO], [D_E_L_E_T_]

 SELECT COUNT(C5_NUM) QTD FROM SC5060 WHERE C5_COTACAO = '1170193'   AND D_E_L_E_T_ = ''

[DADOSADV12].[dbo].[SC5060]

[C5_COTACAO], [D_E_L_E_T_]

 SELECT COUNT(C5_NUM) QTD FROM SC5060 WHERE C5_COTACAO = '1170940'   AND D_E_L_E_T_ = ''

[DADOSADV12].[dbo].[SC5060]

[C5_COTACAO], [D_E_L_E_T_]

 SELECT COUNT(C5_NUM) QTD FROM SC5060 WHERE C5_COTACAO = '1170810'   AND D_E_L_E_T_ = ''

[DADOSADV12].[dbo].[SC5060]

[C5_COTACAO], [D_E_L_E_T_]

 SELECT COUNT(C5_NUM) QTD FROM SC5060 WHERE C5_COTACAO = '1170194'   AND D_E_L_E_T_ = ''

[DADOSADV12].[dbo].[SC5060]

[C5_COTACAO], [D_E_L_E_T_]

 SELECT COUNT(C5_NUM) QTD FROM SC5060 WHERE C5_COTACAO = '1170139'   AND D_E_L_E_T_ = ''

[DADOSADV12].[dbo].[ZE0060]

[D_E_L_E_T_], [ZE0_FILIAL], [ZE0_OK]

[ZE0_TIPO]

[R_E_C_N_O_]

SELECT A.R_E_C_N_O_ RECNOA FROM ZE0060 A WHERE A.ZE0_FILIAL = '31' AND A.ZE0_OK = '2r' AND A.ZE0_TIPO IN ('1','2','4','6','7','9') AND A.D_E_L_E_T_ = ' '

[DADOSADV12].[dbo].[SE2060]

[D_E_L_E_T_], [E2_FORNECE]

[E2_FILIAL], [E2_LOJA], [E2_NUM], [E2_PARCELA], [E2_PREFIXO], [E2_TIPO], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SE2060 WHERE D_E_L_E_T_ = ' ' AND (CHARINDEX(( '8230' ),CONVERT(CHAR(9),( E2_NUM )))>0 ) AND (E2_FORNECE= 'YHDIRM' ) ORDER BY E2_FILIAL DESC ,E2_PREFIXO DESC ,E2_NUM DESC ,E2_PARCELA DESC ,E2_TIPO DESC ,E2_FORNECE DESC ,E2_LOJA DESC ,R_E_C_N_O_ DESC

[DADOSADV12].[dbo].[SE2060]

[D_E_L_E_T_], [E2_FORNECE]

[E2_FILIAL], [E2_LOJA], [E2_NUM], [E2_PARCELA], [E2_PREFIXO], [E2_TIPO], [R_E_C_N_O_]

SELECT  TOP 250 R_E_C_N_O_ FROM dbo.SE2060 WHERE D_E_L_E_T_ = ' ' AND (CHARINDEX(( '8250' ),CONVERT(CHAR(9),( E2_NUM )))>0 ) AND (E2_FORNECE= 'YHDIRM' ) ORDER BY E2_FILIAL DESC ,E2_PREFIXO DESC ,E2_NUM DESC ,E2_PARCELA DESC ,E2_TIPO DESC ,E2_FORNECE DESC ,E2_LOJA DESC ,R_E_C_N_O_ DESC

SFT060

[FT_FILIAL], [D_E_L_E_T_]

[S_T_A_M_P_]

[FT_NFISCAL], [FT_SERIE], [FT_CLIEFOR], [FT_LOJA], [FT_TIPO], [FT_PRODUTO], [FT_TIPOMOV], [FT_ITEM]

CREATE INDEX [IX_SFT060_FT_FILIAL_D_E_L_E_T__S_T_A_M_P__4A902] ON [DADOSADV12].[dbo].[SFT060] ([FT_FILIAL], [D_E_L_E_T_],[S_T_A_M_P_]) INCLUDE ([FT_NFISCAL], [FT_SERIE], [FT_CLIEFOR], [FT_LOJA], [FT_TIPO], [FT_PRODUTO], [FT_TIPOMOV], [FT_ITEM])

FWTSFWSCHDSMART_EXECUTE

[D_E_L_E_T_]

[THREAD_ID]

CREATE INDEX [IX_FWTSFWSCHDSMART_EXECUTE_D_E_L_E_T__THREAD_ID_490F6] ON [DADOSADV12].[dbo].[FWTSFWSCHDSMART_EXECUTE] ([D_E_L_E_T_],[THREAD_ID])

SCR100

[CR_NUM], [D_E_L_E_T_]

CREATE INDEX [IX_SCR100_CR_NUM_D_E_L_E_T__7FB15] ON [DADOSADV12].[dbo].[SCR100] ([CR_NUM], [D_E_L_E_T_])

SF3060

[F3_FILIAL]

[F3_ESPECIE], [S_T_A_M_P_]

[F3_ENTRADA], [F3_NFISCAL], [F3_SERIE], [F3_CLIEFOR], [F3_LOJA], [F3_FORMUL], [F3_DTCANC], [F3_IDENTFT], [D_E_L_E_T_]

CREATE INDEX [IX_SF3060_F3_FILIAL_F3_ESPECIE_S_T_A_M_P__815A1] ON [DADOSADV12].[dbo].[SF3060] ([F3_FILIAL],[F3_ESPECIE], [S_T_A_M_P_]) INCLUDE ([F3_ENTRADA], [F3_NFISCAL], [F3_SERIE], [F3_CLIEFOR], [F3_LOJA], [F3_FORMUL], [F3_DTCANC], [F3_IDENTFT], [D_E_L_E_T_])

SFT060

[FT_FILIAL], [D_E_L_E_T_]

[S_T_A_M_P_]

[FT_PRODUTO]

CREATE INDEX [IX_SFT060_FT_FILIAL_D_E_L_E_T__S_T_A_M_P__DE9BB] ON [DADOSADV12].[dbo].[SFT060] ([FT_FILIAL], [D_E_L_E_T_],[S_T_A_M_P_]) INCLUDE ([FT_PRODUTO])

V5R060

[V5R_CODFIL], [V5R_ALIAS], [D_E_L_E_T_]

[V5R_DATA]

[R_E_C_N_O_], [R_E_C_D_E_L_]

CREATE INDEX [IX_V5R060_V5R_CODFIL_V5R_ALIAS_D_E_L_E_T__V5R_DATA_D5D11] ON [DADOSADV12].[dbo].[V5R060] ([V5R_CODFIL], [V5R_ALIAS], [D_E_L_E_T_],[V5R_DATA]) INCLUDE ([R_E_C_N_O_], [R_E_C_D_E_L_])

SC2060

[C2_DATPRI], [D_E_L_E_T_]

[C2_FILIAL]

[C2_NUM], [C2_ITEM], [C2_SEQUEN], [C2_ITEMGRD], [R_E_C_N_O_]

CREATE INDEX [IX_SC2060_C2_DATPRI_D_E_L_E_T__C2_FILIAL_306E7] ON [DADOSADV12].[dbo].[SC2060] ([C2_DATPRI], [D_E_L_E_T_],[C2_FILIAL]) INCLUDE ([C2_NUM], [C2_ITEM], [C2_SEQUEN], [C2_ITEMGRD], [R_E_C_N_O_])

SE2060

[E2_FILIAL], [D_E_L_E_T_]

[E2_SALDO]

[E2_PREFIXO], [E2_NUM], [E2_PARCELA], [E2_FORNECE], [E2_LOJA], [E2_TIPO], [E2_EMISSAO], [E2_VENCTO], [E2_VENCREA], [E2_VALOR], [E2_BAIXA], [E2_MULTA], [E2_VALJUR], [E2_PORCJUR], [E2_MOEDA], [E2_FLUXO], [E2_ORIGEM], [E2_TXMOEDA], [E2_SDACRES], [E2_SDDECRE], [E2_FILORIG], [E2_TXMDCOR], [R_E_C_N_O_]

CREATE INDEX [IX_SE2060_E2_FILIAL_D_E_L_E_T__E2_SALDO_D94C1] ON [DADOSADV12].[dbo].[SE2060] ([E2_FILIAL], [D_E_L_E_T_],[E2_SALDO]) INCLUDE ([E2_PREFIXO], [E2_NUM], [E2_PARCELA], [E2_FORNECE], [E2_LOJA], [E2_TIPO], [E2_EMISSAO], [E2_VENCTO], [E2_VENCREA], [E2_VALOR], [E2_BAIXA], [E2_MULTA], [E2_VALJUR], [E2_PORCJUR], [E2_MOEDA], [E2_FLUXO], [E2_ORIGEM], [E2_TXMOEDA], [E2_SDACRES], [E2_SDDECRE], [E2_FILORIG], [E2_TXMDCOR], [R_E_C_N_O_])

SE2060

[D_E_L_E_T_]

[E2_TIPO], [E2_SALDO]

[E2_FILIAL], [E2_PREFIXO], [E2_NUM], [E2_PARCELA], [E2_FORNECE], [E2_LOJA], [E2_EMISSAO], [E2_VENCTO], [E2_VENCREA], [E2_VALOR], [E2_BAIXA], [E2_MULTA], [E2_VALJUR], [E2_PORCJUR], [E2_MOEDA], [E2_FLUXO], [E2_ORIGEM], [E2_TXMOEDA], [E2_SDACRES], [E2_SDDECRE], [E2_FILORIG], [E2_TXMDCOR], [R_E_C_N_O_]

CREATE INDEX [IX_SE2060_D_E_L_E_T__E2_TIPO_E2_SALDO_52FC7] ON [DADOSADV12].[dbo].[SE2060] ([D_E_L_E_T_],[E2_TIPO], [E2_SALDO]) INCLUDE ([E2_FILIAL], [E2_PREFIXO], [E2_NUM], [E2_PARCELA], [E2_FORNECE], [E2_LOJA], [E2_EMISSAO], [E2_VENCTO], [E2_VENCREA], [E2_VALOR], [E2_BAIXA], [E2_MULTA], [E2_VALJUR], [E2_PORCJUR], [E2_MOEDA], [E2_FLUXO], [E2_ORIGEM], [E2_TXMOEDA], [E2_SDACRES], [E2_SDDECRE], [E2_FILORIG], [E2_TXMDCOR], [R_E_C_N_O_])

SE2060

[D_E_L_E_T_]

[E2_MOEDA]

[E2_FILIAL], [E2_PREFIXO], [E2_NUM], [E2_PARCELA], [E2_FORNECE], [E2_LOJA], [E2_TIPO], [E2_EMISSAO], [E2_VENCTO], [E2_VENCREA], [E2_VALOR], [E2_BAIXA], [E2_SALDO], [E2_MULTA], [E2_VALJUR], [E2_PORCJUR], [E2_FLUXO], [E2_ORIGEM], [E2_TXMOEDA], [E2_SDACRES], [E2_SDDECRE], [E2_FILORIG], [E2_TXMDCOR], [R_E_C_N_O_]

CREATE INDEX [IX_SE2060_D_E_L_E_T__E2_MOEDA_BF212] ON [DADOSADV12].[dbo].[SE2060] ([D_E_L_E_T_],[E2_MOEDA]) INCLUDE ([E2_FILIAL], [E2_PREFIXO], [E2_NUM], [E2_PARCELA], [E2_FORNECE], [E2_LOJA], [E2_TIPO], [E2_EMISSAO], [E2_VENCTO], [E2_VENCREA], [E2_VALOR], [E2_BAIXA], [E2_SALDO], [E2_MULTA], [E2_VALJUR], [E2_PORCJUR], [E2_FLUXO], [E2_ORIGEM], [E2_TXMOEDA], [E2_SDACRES], [E2_SDDECRE], [E2_FILORIG], [E2_TXMDCOR], [R_E_C_N_O_])

RGK060

[RGK_CODIGO], [D_E_L_E_T_]

CREATE INDEX [IX_RGK060_RGK_CODIGO_D_E_L_E_T__21D20] ON [DADOSADV12].[dbo].[RGK060] ([RGK_CODIGO], [D_E_L_E_T_])

RH3060

[RH3_STATUS], [RH3_FILAPR], [RH3_MATAPR], [D_E_L_E_T_]

CREATE INDEX [IX_RH3060_RH3_STATUS_RH3_FILAPR_RH3_MATAPR_D_E_L_E_T__EFEF1] ON [DADOSADV12].[dbo].[RH3060] ([RH3_STATUS], [RH3_FILAPR], [RH3_MATAPR], [D_E_L_E_T_])

SC7060

[C7_CONAPRO], [D_E_L_E_T_]

[C7_FILIAL], [C7_NUM], [R_E_C_N_O_]

CREATE INDEX [IX_SC7060_C7_CONAPRO_D_E_L_E_T__FDA02] ON [DADOSADV12].[dbo].[SC7060] ([C7_CONAPRO], [D_E_L_E_T_]) INCLUDE ([C7_FILIAL], [C7_NUM], [R_E_C_N_O_])

SFT060

[FT_FILIAL], [FT_PRODUTO], [D_E_L_E_T_]

[S_T_A_M_P_]

CREATE INDEX [IX_SFT060_FT_FILIAL_FT_PRODUTO_D_E_L_E_T__S_T_A_M_P__B9C6B] ON [DADOSADV12].[dbo].[SFT060] ([FT_FILIAL], [FT_PRODUTO], [D_E_L_E_T_],[S_T_A_M_P_])

SC7060

[C7_CC], [D_E_L_E_T_]

[C7_EMISSAO]

[C7_FILIAL], [C7_FORNECE], [C7_LOJA], [C7_COND], [C7_RESIDUO], [C7_QUJE]

CREATE INDEX [IX_SC7060_C7_CC_D_E_L_E_T__C7_EMISSAO_FCFFB] ON [DADOSADV12].[dbo].[SC7060] ([C7_CC], [D_E_L_E_T_],[C7_EMISSAO]) INCLUDE ([C7_FILIAL], [C7_FORNECE], [C7_LOJA], [C7_COND], [C7_RESIDUO], [C7_QUJE])

SC7060

[C7_CC], [D_E_L_E_T_]

[C7_EMISSAO]

[C7_FORNECE], [C7_LOJA], [C7_COND], [C7_RESIDUO], [C7_QUJE]

CREATE INDEX [IX_SC7060_C7_CC_D_E_L_E_T__C7_EMISSAO_B7D46] ON [DADOSADV12].[dbo].[SC7060] ([C7_CC], [D_E_L_E_T_],[C7_EMISSAO]) INCLUDE ([C7_FORNECE], [C7_LOJA], [C7_COND], [C7_RESIDUO], [C7_QUJE])

SC5060

[D_E_L_E_T_], [C5_MKPLACE]

[C5_FILIAL], [C5_NUM], [C5_EMISSAO], [C5_MKPEDNU]

CREATE INDEX [IX_SC5060_D_E_L_E_T__C5_MKPLACE_D82CF] ON [DADOSADV12].[dbo].[SC5060] ([D_E_L_E_T_], [C5_MKPLACE]) INCLUDE ([C5_FILIAL], [C5_NUM], [C5_EMISSAO], [C5_MKPEDNU])

ZZS060

[ZZS_FILIAL], [ZZS_CODIGO], [ZZS_IDINTE], [ZZS_STATUS], [D_E_L_E_T_]

[ZZS_DATA]

CREATE INDEX [IX_ZZS060_ZZS_FILIAL_ZZS_CODIGO_ZZS_IDINTE_ZZS_STATUS_D_E_L_E_T__A0292] ON [DADOSADV12].[dbo].[ZZS060] ([ZZS_FILIAL], [ZZS_CODIGO], [ZZS_IDINTE], [ZZS_STATUS], [D_E_L_E_T_]) INCLUDE ([ZZS_DATA])

SC2060

[C2_FILIAL], [C2_DATPRI], [D_E_L_E_T_]

[C2_NUM]

[C2_ITEM], [C2_SEQUEN], [C2_ITEMGRD], [R_E_C_N_O_]

CREATE INDEX [IX_SC2060_C2_FILIAL_C2_DATPRI_D_E_L_E_T__C2_NUM_66E26] ON [DADOSADV12].[dbo].[SC2060] ([C2_FILIAL], [C2_DATPRI], [D_E_L_E_T_],[C2_NUM]) INCLUDE ([C2_ITEM], [C2_SEQUEN], [C2_ITEMGRD], [R_E_C_N_O_])

CDA060

[CDA_FILIAL], [D_E_L_E_T_]

[CDA_NUMERO], [CDA_SERIE], [CDA_CLIFOR], [CDA_LOJA], [CDA_NUMITE], [CDA_IFCOMP]

CREATE INDEX [IX_CDA060_CDA_FILIAL_D_E_L_E_T__582AB] ON [DADOSADV12].[dbo].[CDA060] ([CDA_FILIAL], [D_E_L_E_T_]) INCLUDE ([CDA_NUMERO], [CDA_SERIE], [CDA_CLIFOR], [CDA_LOJA], [CDA_NUMITE], [CDA_IFCOMP])