Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 1. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

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

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

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

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. [CLIENT: 10.255.18.229]

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Error: 17828, Severity: 20, State: 1.

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

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

Error: 9642, Severity: 16, State: 3.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SB9010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SB9010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-05T12:22:28.697' AND (B9_DATA >= '20230101')

UPDATE [dbo].[FWTSFWSCHDSMART_EXECUTE] set [D_E_L_E_T_] = @1,[R_E_C_D_E_L_] = [R_E_C_N_O_]  WHERE [R_E_C_N_O_]=@2

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM CV3010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'CV3010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T07:31:25.467' AND (CV3_DTSEQ > '20230101' )

SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1

select * from [dbo].[SE1010]

SELECT COUNT(*) FROM sys.objects

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM F75010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'F75010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T08:16:04.990' AND (F75_VENCTO >= '20230101')

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SE5010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SE5010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T08:01:41.163' AND (E5_DATA >= '20230101')

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM F76010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'F76010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T03:33:27.450' AND (F76_BLQLIB = 1 AND F76_DATA >= '20230101')

The job succeeded.  The Job was invoked by Schedule 20 (backup_diff.Subplan_1).  The last step to run was step 1 (Subplan_1).

The job succeeded.  The Job was invoked by Schedule 22 (backup_full.Subplan_1).  The last step to run was step 1 (Subplan_1).

The job succeeded.  The Job was invoked by Schedule 21 (backup_log.Subplan_1).  The last step to run was step 1 (Subplan_1).

The job succeeded.  The Job was invoked by Schedule 8 (syspolicy_purge_history_schedule).  The last step to run was step 3 (Erase Phantom System Health Records.).

ALTER INDEX [SYS_USR_TTAT_LOG2] ON [dbo].[SYS_USR_TTAT_LOG] REBUILD

ALTER INDEX [SYS_USR_LOGIN_TTAT_LOG5] ON [dbo].[SYS_USR_LOGIN_TTAT_LOG] REBUILD

ALTER INDEX [I210106] ON [dbo].[I21010] REBUILD

ALTER INDEX [SYS_USR_LOGIN_TTAT_LOG2] ON [dbo].[SYS_USR_LOGIN_TTAT_LOG] REBUILD

ALTER INDEX [SYS_USR_TTAT_LOG5] ON [dbo].[SYS_USR_TTAT_LOG] REBUILD

ALTER INDEX [SYS_USR_TTAT_LOG1] ON [dbo].[SYS_USR_TTAT_LOG] REBUILD

ALTER INDEX [I210102] ON [dbo].[I21010] REBUILD

ALTER INDEX [QLI010_UNQ] ON [dbo].[QLI010] REBUILD

ALTER INDEX [SYS_USR_TTAT_LOG6] ON [dbo].[SYS_USR_TTAT_LOG] REBUILD

ALTER INDEX [QLI0101] ON [dbo].[QLI010] REBUILD

ALTER INDEX [SYS_USR_LOGIN_TTAT_LOG1] ON [dbo].[SYS_USR_LOGIN_TTAT_LOG] REBUILD

ALTER INDEX [SYS_USR_LOGIN_TTAT_LOG7] ON [dbo].[SYS_USR_LOGIN_TTAT_LOG] REBUILD

ALTER INDEX [MP_CUSTOM_METRICS_EXP2] ON [dbo].[MP_CUSTOM_METRICS_EXP] REBUILD

ALTER INDEX [SYS_USR_LOGIN_TTAT_LOG6] ON [dbo].[SYS_USR_LOGIN_TTAT_LOG] REBUILD

ALTER INDEX [F2D0106] ON [dbo].[F2D010] REBUILD

ALTER INDEX [MP_CUSTOM_METRICS_EXP1] ON [dbo].[MP_CUSTOM_METRICS_EXP] REBUILD

ALTER INDEX [SYS_USR_TTAT_LOG3] ON [dbo].[SYS_USR_TTAT_LOG] REBUILD

ALTER INDEX [F75010_UNQ] ON [dbo].[F75010] REBUILD

ALTER INDEX [SYS_USR_TTAT_LOG4] ON [dbo].[SYS_USR_TTAT_LOG] REBUILD

ALTER INDEX [I210103] ON [dbo].[I21010] REBUILD

ALTER INDEX [SYS_USR_TTAT_LOG7] ON [dbo].[SYS_USR_TTAT_LOG] REBUILD

ALTER INDEX [I14010_UNQ] ON [dbo].[I14010] REBUILD

ALTER INDEX [F2D0103] ON [dbo].[F2D010] REBUILD

ALTER INDEX [SYS_USR_LOGIN_TTAT_LOG4] ON [dbo].[SYS_USR_LOGIN_TTAT_LOG] REBUILD

ALTER INDEX [F750101] ON [dbo].[F75010] REBUILD

ALTER INDEX [SYS_USR_LOGIN_TTAT_LOG3] ON [dbo].[SYS_USR_LOGIN_TTAT_LOG] REBUILD

ALTER INDEX [ZAS0101] ON [dbo].[ZAS010] REBUILD

ALTER INDEX [I140101] ON [dbo].[I14010] REBUILD

ALTER INDEX [SB5010_ST] ON [dbo].[SB5010] REBUILD

ALTER INDEX [SB5010_STAMP] ON [dbo].[SB5010] REBUILD

ALTER INDEX [CJ30102] ON [dbo].[CJ3010] REBUILD

ALTER INDEX [DKD0101] ON [dbo].[DKD010] REBUILD

ALTER INDEX [DKE010_UNQ] ON [dbo].[DKE010] REBUILD

ALTER INDEX [CIY0101] ON [dbo].[CIY010] REBUILD

ALTER INDEX [DKD010_UNQ] ON [dbo].[DKD010] REBUILD

ALTER INDEX [SYS_USR_MODULE_TTAT_LOG1] ON [dbo].[SYS_USR_MODULE_TTAT_LOG] REBUILD

ALTER INDEX [F2D0101] ON [dbo].[F2D010] REBUILD

ALTER INDEX [SU50102] ON [dbo].[SU5010] REBUILD

ALTER INDEX [CJ30101] ON [dbo].[CJ3010] REBUILD

ALTER INDEX [CJ30103] ON [dbo].[CJ3010] REBUILD

ALTER INDEX [SYS_USR_ACCESS_TTAT_LOG5] ON [dbo].[SYS_USR_ACCESS_TTAT_LOG] REBUILD

ALTER INDEX [F2D010_UNQ] ON [dbo].[F2D010] REBUILD

ALTER INDEX [CJ3010_UNQ] ON [dbo].[CJ3010] REBUILD

ALTER INDEX [SYS_USR_ACCESS_TTAT_LOG1] ON [dbo].[SYS_USR_ACCESS_TTAT_LOG] REBUILD

ALTER INDEX [SYS_USR_ACCESS_TTAT_LOG7] ON [dbo].[SYS_USR_ACCESS_TTAT_LOG] REBUILD

ALTER INDEX [SYS_USR_MODULE_TTAT_LOG7] ON [dbo].[SYS_USR_MODULE_TTAT_LOG] REBUILD

ALTER INDEX [F2D0102] ON [dbo].[F2D010] REBUILD

ALTER INDEX [XX30107] ON [dbo].[XX3010] REBUILD

ALTER INDEX [TRB01SP05] ON [dbo].[TRB01SP] REBUILD

ALTER INDEX [SYS_USR_FILIAL_TTAT_LOG4] ON [dbo].[SYS_USR_FILIAL_TTAT_LOG] REBUILD

UPDATE STATISTICS [dbo].[CTC010] [_WA_Sys_00000006_778DEEC3] WITH FULLSCAN

UPDATE STATISTICS [dbo].[TOP_PARAM] [TOP_PARAM2] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CQ4010] [_WA_Sys_0000000D_10B397B2] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [IDX_CT2010_DBA19] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CSB010] [_WA_Sys_00000005_28B39346] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CSB010] [_WA_Sys_00000016_28B39346] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CSB010] [_WA_Sys_00000015_28B39346] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CSB010] [_WA_Sys_00000014_28B39346] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000001D_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000000D_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000055_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000009_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000001F_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000002C_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000004D_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000004E_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000050_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000004F_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000002_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000040_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_0000000E_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000034_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000052_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000054_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000051_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000053_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[XX3010] [_WA_Sys_00000025_56B75986] WITH FULLSCAN

UPDATE STATISTICS [dbo].[XX3010] [_WA_Sys_00000009_56B75986] WITH FULLSCAN

UPDATE STATISTICS [dbo].[XX3010] [_WA_Sys_0000001C_56B75986] WITH FULLSCAN

UPDATE STATISTICS [dbo].[XX3010] [_WA_Sys_0000000E_56B75986] WITH FULLSCAN

UPDATE STATISTICS [dbo].[XX3010] [_WA_Sys_00000003_56B75986] WITH FULLSCAN

UPDATE STATISTICS [dbo].[XX3010] [_WA_Sys_00000017_56B75986] WITH FULLSCAN

UPDATE STATISTICS [dbo].[XX3010] [_WA_Sys_00000010_56B75986] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CTY010] [_WA_Sys_00000012_0AD5CD61] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000033_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CTY010] [_WA_Sys_0000000F_0AD5CD61] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CV3010] [_WA_Sys_00000011_632AFC16] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CV3010] [_WA_Sys_00000012_632AFC16] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CV3010] [_WA_Sys_0000000D_632AFC16] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CV3010] [_WA_Sys_0000000E_632AFC16] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CV3010] [_WA_Sys_0000000F_632AFC16] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CV3010] [_WA_Sys_00000010_632AFC16] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CV3010] [_WA_Sys_0000000B_632AFC16] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SB2010] [_WA_Sys_0000000D_65B3ED27] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CTK010] [_WA_Sys_00000024_04515656] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CTV010] [_WA_Sys_00000011_24959F64] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2010] [_WA_Sys_00000003_4342AD08] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CTV010] [_WA_Sys_00000010_24959F64] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CTK010] [_WA_Sys_00000044_04515656] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SB9010] [_WA_Sys_00000011_66835E52] WITH FULLSCAN

-- Procedure creation 
CREATE PROCEDURE CTB190_06_01 (
    @IN_FILIAL Char( 8) , 
    @IN_DATA Char( 08 ) , 
    @IN_LOTE Char( 6) , 
    @IN_SBLOTE Char( 3) , 
    @IN_DOC Char( 6) , 
    @IN_ATIVDE Char( 40) , 
    @IN_INTEGRID Char( 01 ) , 
    @IN_MVSOMA Char( 01 ) , 
    @IN_TRANSACTION Char( 01 ) , 
    @OUT_RESULT Char( 01 )  output ) AS
 
-- Declaration of variables
DECLARE @cFilial_CT2 Char( 8)
DECLARE @cAux VarChar( 03 )
DECLARE @cMoeda Char( 2)
DECLARE @cData Char( 08 )
DECLARE @cDtlp Char( 08 )
DECLARE @cDebito Char( 20)
DECLARE @cCredit Char( 20)
DECLARE @cCustoD Char( 20)
DECLARE @cCustoC Char( 20)
DECLARE @cItemD Char( 20)
DECLARE @cItemC Char( 20)
DECLARE @cClvlD Char( 20)
DECLARE @cClvlC Char( 20)
DECLARE @cTpSaldo Char( 1)
DECLARE @cDc Char( 1)
DECLARE @cAtiv Char( 40)
DECLARE @nValor Float
DECLARE @cOper Char( 01 )
DECLARE @cResult Char( 01 )
DECLARE @iRecnoTRW Integer
DECLARE @cEC05DB_TRW Char( 01 )
DECLARE @cEC05CR_TRW Char( 01 )
BEGIN
   SET @OUT_RESULT  = '0' 
   SET @cResult  = '0' 
   SET @cOper  = '+' 
   SET @cEC05DB_TRW  = ' ' 
   SET @cEC05CR_TRW  = ' ' 
   SET @cAux  = 'CT2' 
   EXEC XFILIAL_06_01 @cAux , @IN_FILIAL , @cFilial_CT2 output 
    
   -- Cursor declaration CTB_CT2
   DECLARE CTB_CT2 insensitive  CURSOR FOR 
   SELECT CT2_MOEDLC , CT2_DATA , CT2_TPSALD , CT2_DC , CT2_DEBITO , CT2_CREDIT , CT2_VALOR , CT2_CCD , CT2_CCC , CT2_ITEMD , 
          CT2_ITEMC , CT2_CLVLDB , CT2_CLVLCR , CT2_DTLP , CT2_ATIVDE , R_E_C_N_O_ 
     FROM TRW010_SP 
     WHERE CT2_FILIAL  = @cFilial_CT2  and CT2_DATA  = @IN_DATA  and CT2_LOTE  = @IN_LOTE  and CT2_SBLOTE  = @IN_SBLOTE  and CT2_ATIVDE  = @IN_ATIVDE 
      and CT2_DC  != '4'  and CT2_TPSALD  != '9'  and D_E_L_E_T_  = ' ' 
     ORDER BY R_E_C_N_O_ 
   FOR READ ONLY 
    
   OPEN CTB_CT2
   FETCH CTB_CT2 
    INTO @cMoeda , @cData , @cTpSaldo , @cDc , @cDebito , @cCredit , @nValor , @cCustoD , @cCustoC , @cItemD , @cItemC , 
          @cClvlD , @cClvlC , @cDtlp , @cAtiv , @iRecnoTRW 
   WHILE (... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB190_06_01 (&#x0A;    @IN_FILIAL Char( 8) , &#x0A;    @IN_DATA Char( 08 ) , &#x0A;    @IN_LOTE Char( 6) , &#x0A;    @IN_SBLOTE Char( 3) , &#x0A;    @IN_DOC Char( 6) , &#x0A;    @IN_ATIVDE Char( 40) , &#x0A;    @IN_INTEGRID Char( 01 ) , &#x0A;    @IN_MVSOMA Char( 01 ) , &#x0A;    @IN_TRANSACTION Char( 01 ) , &#x0A;    @OUT_RESULT Char( 01 )  output ) AS&#x0A; &#x0A;-- Declaration of variables&#x0A;DECLARE @cFilial_CT2 Char( 8)&#x0A;DECLARE @cAux VarChar( 03 )&#x0A;DECLARE @cMoeda Char( 2)&#x0A;DECLARE @cData Char( 08 )&#x0A;DECLARE @cDtlp Char( 08 )&#x0A;DECLARE @cDebito Char( 20)&#x0A;DECLARE @cCredit Char( 20)&#x0A;DECLARE @cCustoD Char( 20)&#x0A;DECLARE @cCustoC Char( 20)&#x0A;DECLARE @cItemD Char( 20)&#x0A;DECLARE @cItemC Char( 20)&#x0A;DECLARE @cClvlD Char( 20)&#x0A;DECLARE @cClvlC Char( 20)&#x0A;DECLARE @cTpSaldo Char( 1)&#x0A;DECLARE @cDc Char( 1)&#x0A;DECLARE @cAtiv Char( 40)&#x0A;DECLARE @nValor Float&#x0A;DECLARE @cOper Char( 01 )&#x0A;DECLARE @cResult Char( 01 )&#x0A;DECLARE @iRecnoTRW Integer&#x0A;DECLARE @cEC05DB_TRW Char( 01 )&#x0A;DECLARE @cEC05CR_TRW Char( 01 )&#x0A;BEGIN&#x0A;   SET @OUT_RESULT  = '0' &#x0A;   " StatementId="1" StatementCompId="15" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cResult  = '0' &#x0A;   " StatementId="2" StatementCompId="16" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cOper  = '+' &#x0A;   " StatementId="3" StatementCompId="17" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cEC05DB_TRW  = ' ' &#x0A;   " StatementId="4" StatementCompId="18" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cEC05CR_TRW  = ' ' &#x0A;   " StatementId="5" StatementCompId="19" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cAux  = 'CT2' &#x0A;   " StatementId="6" StatementCompId="20" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_06_01 @cAux , @IN_FILIAL , @cFilial_CT2 output" StatementId="7" StatementCompId="21" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtCursor StatementText=" &#x0A;    &#x0A;   -- Cursor declaration CTB_CT2&#x0A;   DECLARE CTB_CT2 insensitive  CURSOR FOR &#x0A;   SELECT CT2_MOEDLC , CT2_DATA , CT2_TPSALD , CT2_DC , CT2_DEBITO , CT2_CREDIT , CT2_VALOR , CT2_CCD , CT2_CCC , CT2_ITEMD , &#x0A;          CT2_ITEMC , CT2_CLVLDB , CT2_CLVLCR , CT2_DTLP , CT2_ATIVDE , R_E_C_N_O_ &#x0A;     FROM TRW010_SP &#x0A;     WHERE CT2_FILIAL  = @cFilial_CT2  and CT2_DATA  = @IN_DATA  and CT2_LOTE  = @IN_LOTE  and CT2_SBLOTE  = @IN_SBLOTE  and CT2_ATIVDE  = @IN_ATIVDE &#x0A;      and CT2_DC  != '4'  and CT2_TPSALD  != '9'  and D_E_L_E_T_  = ' ' &#x0A;     ORDER BY R_E_C_N_O_ &#x0A;   FOR READ ONLY" StatementId="8" StatementCompId="22" StatementType="DECLARE CURSOR" RetrievedFromCache="true"><CursorPlan CursorName="CTB_CT2" CursorActualType="SnapShot" CursorRequestedType="SnapShot" CursorConcurrency="Read Only" ForwardOnly="true"><Operation OperationType="PopulateQuery"><QueryPlan CachedPlanSize="80" CompileTime="34" CompileCPU="4" CompileMemory="776"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.8013"><MissingIndex Database="[SDBPRD]" Schema="[dbo]" Table="[TRW010_SP]"><ColumnGroup Usage="EQUALITY"><Column Name="[CT2_FILIAL]" ColumnId="1"/><Column Name="[CT2_DATA]" ColumnId="2"/><Column Name="[CT2_LOTE]" ColumnId="3"/><Column Name="[CT2_SBLOTE]" ColumnId="4"/><Column Name="[CT2_ATIVDE]" ColumnId="23"/><Column Name="[D_E_L_E_T_]" ColumnId="101"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[CT2_DC]" ColumnId="8"/><Column Name="[CT2_TPSALD]" ColumnId="15"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[C... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE CTB002_01_01 (
    @IN_CALIAS Char( 03 ) , 
    @IN_MOEDAESP Char( 01 ) , 
    @IN_MOEDA Char( 2) , 
    @IN_TPSALDO Char( 1) , 
    @IN_FILIALDE Char( 8) , 
    @IN_FILIALATE Char( 8) , 
    @IN_DATADE Char( 08 ) , 
    @IN_DATAATE Char( 08 ) , 
    @IN_SOALGUNS Char( 01 ) , 
    @IN_INTEGRIDADE Char( 01 ) , 
    @IN_MVCTB190D Char( 01 ) , 
    @IN_TRANSACTION Char( 01 ) , 
    @OUT_RESULTADO Char( 01 )  output ) AS
 
-- Declaration of variables
DECLARE @iMinRecno Integer
DECLARE @iMaxRecno Integer
DECLARE @cFilial_CT2 Char( 8)
DECLARE @cFilial_CQ0 Char( 8)
DECLARE @cFilial_CQ1 Char( 8)
DECLARE @cFilial_CQ2 Char( 8)
DECLARE @cFilial_CQ3 Char( 8)
DECLARE @cFilial_CQ4 Char( 8)
DECLARE @cFilial_CQ5 Char( 8)
DECLARE @cFilial_CQ6 Char( 8)
DECLARE @cFilial_CQ7 Char( 8)
DECLARE @cFilial_CQ8 Char( 8)
DECLARE @cFilial_CQ9 Char( 8)
DECLARE @cFilial_CTC Char( 8)
DECLARE @cFilial_CQA Char( 8)
DECLARE @cCT2Fil Char( 8)
DECLARE @cAux Char( 03 )
DECLARE @cDataI Char( 08 )
DECLARE @cDataF Char( 08 )
BEGIN
   IF @IN_FILIALDE  = ' ' 
   BEGIN 
      SET @cFilial_CT2  = ' ' 
   END 
   ELSE 
   BEGIN 
      SET @cFilial_CT2  = @IN_FILIALDE 
   END 
   IF  (@IN_CALIAS  = 'CQ0' ) 
   BEGIN 
      SET @cDataI  = SUBSTRING ( @IN_DATADE , 1 , 6 ) + '01' 
      EXEC LASTDAY_01_01 @IN_DATAATE , @cDataF output 
      SET @cAux  = 'CQ0' 
      EXEC XFILIAL_01_01 @cAux , @cFilial_CT2 , @cFilial_CQ0 output 
      SELECT @iMinRecno  = COALESCE ( MIN ( R_E_C_N_O_ ), 0 ), @iMaxRecno  = COALESCE ( MAX ( R_E_C_N_O_ ), 0 )
        FROM CQ0010 
        WHERE CQ0_FILIAL  between @cFilial_CQ0 and @IN_FILIALATE  and CQ0_DATA  between @cDataI and @cDataF  and CQ0_TPSALD  = @IN_TPSALDO 
         and  ( (CQ0_MOEDA  = @IN_MOEDA  and @IN_MOEDAESP  = '1' )  or @IN_MOEDAESP  = '0' ) 
      IF @iMinRecno  != 0 
      BEGIN 
         WHILE ( (@iMinRecno  <= @iMaxRecno ) )
         BEGIN
            IF @IN_TRANSACTION  = '0' 
            BEGIN 
               begin tran 
   ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtCond StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB002_01_01 (&#x0A;    @IN_CALIAS Char( 03 ) , &#x0A;    @IN_MOEDAESP Char( 01 ) , &#x0A;    @IN_MOEDA Char( 2) , &#x0A;    @IN_TPSALDO Char( 1) , &#x0A;    @IN_FILIALDE Char( 8) , &#x0A;    @IN_FILIALATE Char( 8) , &#x0A;    @IN_DATADE Char( 08 ) , &#x0A;    @IN_DATAATE Char( 08 ) , &#x0A;    @IN_SOALGUNS Char( 01 ) , &#x0A;    @IN_INTEGRIDADE Char( 01 ) , &#x0A;    @IN_MVCTB190D Char( 01 ) , &#x0A;    @IN_TRANSACTION Char( 01 ) , &#x0A;    @OUT_RESULTADO Char( 01 )  output ) AS&#x0A; &#x0A;-- Declaration of variables&#x0A;DECLARE @iMinRecno Integer&#x0A;DECLARE @iMaxRecno Integer&#x0A;DECLARE @cFilial_CT2 Char( 8)&#x0A;DECLARE @cFilial_CQ0 Char( 8)&#x0A;DECLARE @cFilial_CQ1 Char( 8)&#x0A;DECLARE @cFilial_CQ2 Char( 8)&#x0A;DECLARE @cFilial_CQ3 Char( 8)&#x0A;DECLARE @cFilial_CQ4 Char( 8)&#x0A;DECLARE @cFilial_CQ5 Char( 8)&#x0A;DECLARE @cFilial_CQ6 Char( 8)&#x0A;DECLARE @cFilial_CQ7 Char( 8)&#x0A;DECLARE @cFilial_CQ8 Char( 8)&#x0A;DECLARE @cFilial_CQ9 Char( 8)&#x0A;DECLARE @cFilial_CTC Char( 8)&#x0A;DECLARE @cFilial_CQA Char( 8)&#x0A;DECLARE @cCT2Fil Char( 8)&#x0A;DECLARE @cAux Char( 03 )&#x0A;DECLARE @cDataI Char( 08 )&#x0A;DECLARE @cDataF Char( 08 )&#x0A;BEGIN&#x0A;   IF @IN_FILIALDE  = ' '" StatementId="1" StatementCompId="58" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cFilial_CT2  = ' ' &#x0A;   " StatementId="2" StatementCompId="59" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Then><Else><Statements><StmtSimple StatementText="END &#x0A;   ELSE &#x0A;   BEGIN &#x0A;      SET @cFilial_CT2  = @IN_FILIALDE &#x0A;   " StatementId="3" StatementCompId="62" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Else></StmtCond><StmtCond StatementText="END &#x0A;   IF  (@IN_CALIAS  = 'CQ0' )" StatementId="4" StatementCompId="64" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cDataI  = SUBSTRING ( @IN_DATADE , 1 , 6 ) + '01' &#x0A;      " StatementId="5" StatementCompId="65" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC LASTDAY_01_01 @IN_DATAATE , @cDataF output" StatementId="6" StatementCompId="66" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;      SET @cAux  = 'CQ0' &#x0A;      " StatementId="7" StatementCompId="67" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_01_01 @cAux , @cFilial_CT2 , @cFilial_CQ0 output" StatementId="8" StatementCompId="68" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;      SELECT @iMinRecno  = COALESCE ( MIN ( R_E_C_N_O_ ), 0 ), @iMaxRecno  = COALESCE ( MAX ( R_E_C_N_O_ ), 0 )&#x0A;        FROM CQ0010 &#x0A;        WHERE CQ0_FILIAL  between @cFilial_CQ0 and @IN_FILIALATE  and CQ0_DATA  between @cDataI and @cDataF  and CQ0_TPSALD  = @IN_TPSALDO &#x0A;         and  ( (CQ0_MOEDA  = @IN_MOEDA  and @IN_MOEDAESP  = '1' )  or @IN_MOEDAESP  = '0' )" StatementId="9" StatementCompId="69" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00684427" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xFA9196F7C8015FA7" QueryPlanHash="0x9D418EF67CE2AED9" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120"><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="48" CompileTime="2" CompileCPU="2" CompileMemory="432"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"/>... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE CTB023_01_01 (
    @IN_FILIALCOR Char( 8) , 
    @IN_FILIALATE Char( 8) , 
    @IN_DATADE Char( 08 ) , 
    @IN_DATAATE Char( 08 ) , 
    @IN_LMOEDAESP Char( 01 ) , 
    @IN_MOEDA Char( 2) , 
    @IN_TPSALDO Char( 1) , 
    @IN_MVSOMA Char( 01 ) , 
    @IN_TRANSACTION Char( 01 ) , 
    @OUT_RESULTADO Char( 01 )  output ) AS
 
-- Declaration of variables
DECLARE @cFilial_CT2 Char( 8)
DECLARE @cCT2FilDe Char( 8)
DECLARE @cFilial_CTC Char( 8)
DECLARE @cFILCT2 Char( 8)
DECLARE @cFilAux Char( 8)
DECLARE @cAux Char( 03 )
DECLARE @cCT2_DC Char( 1)
DECLARE @cCT2_DATA Char( 08 )
DECLARE @cCT2_LOTE Char( 6)
DECLARE @cCT2_SBLOTE Char( 3)
DECLARE @cCT2_DOC Char( 6)
DECLARE @cCT2_MOEDLC Char( 2)
DECLARE @lPrim Char( 01 )
DECLARE @nCT2_VALOR Float
DECLARE @nCTC_DEBITO Float
DECLARE @nCTC_CREDIT Float
DECLARE @nCTC_DIG Float
DECLARE @nCTC_DEBITOX Float
DECLARE @nCTC_CREDITX Float
DECLARE @nCTC_DIGX Float
DECLARE @nCTC_INF Float
DECLARE @iRecno Integer
DECLARE @iTranCount Integer
DECLARE @unique_start Integer
DECLARE @unique_end Integer
DECLARE @iRecnoAux__ Integer
DECLARE @iLoop Integer
DECLARE @ins_error Integer
DECLARE @ins_ini Integer
DECLARE @ins_fim Integer
DECLARE @icoderror Integer
BEGIN
   SET @OUT_RESULTADO  = '0' 
   IF @IN_FILIALCOR  = ' ' 
   BEGIN 
      SET @cCT2FilDe  = ' ' 
   END 
   ELSE 
   BEGIN 
      SET @cCT2FilDe  = @IN_FILIALCOR 
   END 
   SET @cAux  = 'CT2' 
   EXEC XFILIAL_01_01 @cAux , @cCT2FilDe , @cFilial_CT2 output 
   SET @cFilial_CTC  = ' ' 
    
   -- Cursor declaration CUR_CT190DOC
   DECLARE CUR_CT190DOC insensitive  CURSOR FOR 
   SELECT CT2_FILIAL , CT2_DC , CT2_DATA , CT2_LOTE , CT2_SBLOTE , CT2_DOC , CT2_MOEDLC , SUM(CT2_VALOR )
     FROM (
   SELECT CT2_FILIAL , CT2_DC , CT2_DATA , CT2_LOTE , CT2_SBLOTE , CT2_DOC , CT2_MOEDLC , CT2_VALOR , CT2_LINHA , CT2_TPSALD , 
          CT2_EMPORI , CT2_FILORI 
     FROM CT2010 
     WHERE CT2_FILIAL  between @cFilial_CT2 and @IN_FILIALATE  and CT2_DATA  between... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB023_01_01 (&#x0A;    @IN_FILIALCOR Char( 8) , &#x0A;    @IN_FILIALATE Char( 8) , &#x0A;    @IN_DATADE Char( 08 ) , &#x0A;    @IN_DATAATE Char( 08 ) , &#x0A;    @IN_LMOEDAESP Char( 01 ) , &#x0A;    @IN_MOEDA Char( 2) , &#x0A;    @IN_TPSALDO Char( 1) , &#x0A;    @IN_MVSOMA Char( 01 ) , &#x0A;    @IN_TRANSACTION Char( 01 ) , &#x0A;    @OUT_RESULTADO Char( 01 )  output ) AS&#x0A; &#x0A;-- Declaration of variables&#x0A;DECLARE @cFilial_CT2 Char( 8)&#x0A;DECLARE @cCT2FilDe Char( 8)&#x0A;DECLARE @cFilial_CTC Char( 8)&#x0A;DECLARE @cFILCT2 Char( 8)&#x0A;DECLARE @cFilAux Char( 8)&#x0A;DECLARE @cAux Char( 03 )&#x0A;DECLARE @cCT2_DC Char( 1)&#x0A;DECLARE @cCT2_DATA Char( 08 )&#x0A;DECLARE @cCT2_LOTE Char( 6)&#x0A;DECLARE @cCT2_SBLOTE Char( 3)&#x0A;DECLARE @cCT2_DOC Char( 6)&#x0A;DECLARE @cCT2_MOEDLC Char( 2)&#x0A;DECLARE @lPrim Char( 01 )&#x0A;DECLARE @nCT2_VALOR Float&#x0A;DECLARE @nCTC_DEBITO Float&#x0A;DECLARE @nCTC_CREDIT Float&#x0A;DECLARE @nCTC_DIG Float&#x0A;DECLARE @nCTC_DEBITOX Float&#x0A;DECLARE @nCTC_CREDITX Float&#x0A;DECLARE @nCTC_DIGX Float&#x0A;DECLARE @nCTC_INF Float&#x0A;DECLARE @iRecno Integer&#x0A;DECLARE @iTranCount Integer&#x0A;DECLARE @unique_start Integer&#x0A;DECLARE @unique_end Integer&#x0A;DECLARE @iRecnoAux__ Integer&#x0A;DECLARE @iLoop Integer&#x0A;DECLARE @ins_error Integer&#x0A;DECLARE @ins_ini Integer&#x0A;DECLARE @ins_fim Integer&#x0A;DECLARE @icoderror Integer&#x0A;BEGIN&#x0A;   SET @OUT_RESULTADO  = '0' &#x0A;   " StatementId="1" StatementCompId="1908" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtCond StatementText="IF @IN_FILIALCOR  = ' '" StatementId="2" StatementCompId="1909" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cCT2FilDe  = ' ' &#x0A;   " StatementId="3" StatementCompId="1910" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Then><Else><Statements><StmtSimple StatementText="END &#x0A;   ELSE &#x0A;   BEGIN &#x0A;      SET @cCT2FilDe  = @IN_FILIALCOR &#x0A;   " StatementId="4" StatementCompId="1913" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Else></StmtCond><StmtSimple StatementText="END &#x0A;   SET @cAux  = 'CT2' &#x0A;   " StatementId="5" StatementCompId="1915" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_01_01 @cAux , @cCT2FilDe , @cFilial_CT2 output" StatementId="6" StatementCompId="1916" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;   SET @cFilial_CTC  = ' ' &#x0A;    &#x0A;   -- Cursor declaration CUR_CT190DOC&#x0A;   " StatementId="7" StatementCompId="1917" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtCursor StatementText="DECLARE CUR_CT190DOC insensitive  CURSOR FOR &#x0A;   SELECT CT2_FILIAL , CT2_DC , CT2_DATA , CT2_LOTE , CT2_SBLOTE , CT2_DOC , CT2_MOEDLC , SUM(CT2_VALOR )&#x0A;     FROM (&#x0A;   SELECT CT2_FILIAL , CT2_DC , CT2_DATA , CT2_LOTE , CT2_SBLOTE , CT2_DOC , CT2_MOEDLC , CT2_VALOR , CT2_LINHA , CT2_TPSALD , &#x0A;          CT2_EMPORI , CT2_FILORI &#x0A;     FROM CT2010 &#x0A;     WHERE CT2_FILIAL  between @cFilial_CT2 and @IN_FILIALATE  and CT2_DATA  between @IN_DATADE and @IN_DATAATE  and CT2_TPSALD  = @IN_TPSALDO &#x0A;      and CT2_DC  != '4'  and  ( (CT2_MOEDLC  = @IN_MOEDA  and @IN_LMOEDAESP  = '1' )  or @IN_LMOEDAESP  = '0' )  and D_E_L_E_T_  = ' ' &#x0A;     ) CT2TRB1&#x0A;     WHERE NOT EXISTS (&#x0A;   SELECT 1 &#x0A;     FROM CQA010 CQA&#x0A;     WHERE CQA_FILCT2  = CT2_FILIAL  and CQA_DATA  = CT2_DATA  and CQA_LOTE  = CT2_LOTE  and CQA_SBLOTE  = CT2_SBLOTE  and CQA_DOC  = CT2_DOC &#x0A;      and CQA_LINHA  = CT2_LINHA  and CQA_TPSALD  = CT2_TPSALD  and CQA_EMPORI  = CT2_EMPORI  and CQA_FILORI  = CT2_FILOR... [PLANO TRUNCADO - Consulte via SSMS]

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM F76010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'F76010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T03:33:27.450' AND (F76_BLQLIB = 1 AND F76_DATA >= '20230101')

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM F76010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'F76010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ &gt;= '2026-03-13T03:33:27.450' AND (F76_BLQLIB = 1 AND F76_DATA &gt;= '20230101')" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="44.0184" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xC42FC0C53F11B1A7" QueryPlanHash="0xF3E091EDC509EE3B" CardinalityEstimationModelVersion="120"><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="64" CompileTime="7" CompileCPU="7" CompileMemory="992"><ThreadStat Branches="2"/><MissingIndexes><MissingIndexGroup Impact="72.1876"><MissingIndex Database="[SDBPRD]" Schema="[dbo]" Table="[F76010]"><ColumnGroup Usage="EQUALITY"><Column Name="[F76_BLQLIB]" ColumnId="16"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[F76_DATA]" ColumnId="7"/><Column Name="[S_T_A_M_P_]" ColumnId="20"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[R_E_C_N_O_]" ColumnId="18"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="[TAB].[S_T_A_M_P_]=CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/></Warnings><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="16080"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70461208"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-03-10T00:39:31.40" ModificationCount="341735" SamplingPercent="3.58212" Statistics="[F76010_ST]" Table="[F76010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-12T00:38:40.85" ModificationCount="47721" SamplingPercent="3.62857" Statistics="[F76010_PK]" Table="[F76010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.28" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[FW_TECHFINCTR1]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.77" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[_WA_Sys_00000003_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-12T00:38:40.44" ModificationCount="47721" SamplingPercent="3.51176" Statistics="[F76010_UNQ]" Table="[F76010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-11T00:44:10.93" ModificationCount="94629" SamplingPercent="3.53199" Statistics="[_WA_Sys_00000007_539CB998]" Table="[F76010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-10T00:39:31.53" ModificationCount="341719" SamplingPercent="3.58212" Statistics="[F76010_STAMP]" Table="[F76010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.40" ModificationCount="28767" SamplingPercent="34.072" Statistics="[FW_TECHFINCTR_PK]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-12T00:38:40.12" ModificationCount="47721" SamplingPercent="3.51176" Statistics="[F760101]" Table="[F76010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.53" ModificationCount="28767" SamplingPercent="34.072" Statistics="[_WA_Sys_00000002_08A27695]" Table="[FW_TECHFINCTR]" Sche... [PLANO TRUNCADO - Consulte via SSMS]

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SB9010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SB9010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-05T12:22:28.697' AND (B9_DATA >= '20230101')

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SB9010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SB9010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ &gt;= '2026-03-05T12:22:28.697' AND (B9_DATA &gt;= '20230101')" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="155.893" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x6C81C8D735AC0065" QueryPlanHash="0x930357DEA510C9FB" CardinalityEstimationModelVersion="120"><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="96" CompileTime="9" CompileCPU="9" CompileMemory="992"><ThreadStat Branches="3"/><MissingIndexes><MissingIndexGroup Impact="62.9509"><MissingIndex Database="[SDBPRD]" Schema="[dbo]" Table="[SB9010]"><ColumnGroup Usage="INEQUALITY"><Column Name="[B9_DATA]" ColumnId="4"/><Column Name="[S_T_A_M_P_]" ColumnId="37"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[R_E_C_N_O_]" ColumnId="35"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="[TAB].[S_T_A_M_P_]=CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/></Warnings><MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="663280"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70555240"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-11-06T14:11:35.16" ModificationCount="7276628" SamplingPercent="0.985384" Statistics="[SB9010_PK]" Table="[SB9010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.28" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[FW_TECHFINCTR1]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.77" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[_WA_Sys_00000003_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-05T09:51:37.95" ModificationCount="84495" SamplingPercent="0.873904" Statistics="[_WA_Sys_00000004_66835E52]" Table="[SB9010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-01-10T14:29:09.31" ModificationCount="6412072" SamplingPercent="0.921059" Statistics="[SB9010_ST]" Table="[SB9010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.40" ModificationCount="28767" SamplingPercent="34.072" Statistics="[FW_TECHFINCTR_PK]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.53" ModificationCount="28767" SamplingPercent="34.072" Statistics="[_WA_Sys_00000002_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/></OptimizerStatsUsage><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="155.893" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"/><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1008],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1008"/></Identi... [PLANO TRUNCADO - Consulte via SSMS]

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SC9010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SC9010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-12T18:52:54.837' AND (C9_DATALIB >= '20230101')

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SC9010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SC9010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ &gt;= '2026-03-12T18:52:54.837' AND (C9_DATALIB &gt;= '20230101')" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="6.71724" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x450CAC807E92B508" QueryPlanHash="0x62BDCBF7F793FF88" CardinalityEstimationModelVersion="120"><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="56" CompileTime="8" CompileCPU="8" CompileMemory="1000"><ThreadStat Branches="4"/><MissingIndexes><MissingIndexGroup Impact="87.5491"><MissingIndex Database="[SDBPRD]" Schema="[dbo]" Table="[SC9010]"><ColumnGroup Usage="INEQUALITY"><Column Name="[C9_DATALIB]" ColumnId="11"/><Column Name="[S_T_A_M_P_]" ColumnId="70"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[R_E_C_N_O_]" ColumnId="59"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="[TAB].[S_T_A_M_P_]=CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/></Warnings><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1744"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70430552"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2025-07-17T08:39:48.24" ModificationCount="36745" SamplingPercent="18.6715" Statistics="[SC9010_PK]" Table="[SC9010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-11-13T08:27:16.21" ModificationCount="16464" SamplingPercent="16.3242" Statistics="[_WA_Sys_0000000B_2A8E6FDC]" Table="[SC9010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.28" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[FW_TECHFINCTR1]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.77" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[_WA_Sys_00000003_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.40" ModificationCount="28767" SamplingPercent="34.072" Statistics="[FW_TECHFINCTR_PK]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.53" ModificationCount="28767" SamplingPercent="34.072" Statistics="[_WA_Sys_00000002_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-10-28T09:13:13.38" ModificationCount="57141" SamplingPercent="16.4681" Statistics="[SC9010_STAMP]" Table="[SC9010]" Schema="[dbo]" Database="[SDBPRD]"/></OptimizerStatsUsage><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="6.71724" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"/><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1008],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1008"/></Iden... [PLANO TRUNCADO - Consulte via SSMS]

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM FK2010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'FK2010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T08:01:46.883' AND (FK2_DATA > '20230101' )

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM FK2010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'FK2010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ &gt;= '2026-03-13T08:01:46.883' AND (FK2_DATA &gt; '20230101' )" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="148.431" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x7831BDA6CDDDA877" QueryPlanHash="0x3E2CB3CFD25463E2" CardinalityEstimationModelVersion="120"><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="80" CompileTime="8" CompileCPU="8" CompileMemory="1016"><ThreadStat Branches="3"/><MissingIndexes><MissingIndexGroup Impact="95.9688"><MissingIndex Database="[SDBPRD]" Schema="[dbo]" Table="[FK2010]"><ColumnGroup Usage="INEQUALITY"><Column Name="[FK2_DATA]" ColumnId="3"/><Column Name="[S_T_A_M_P_]" ColumnId="38"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[R_E_C_N_O_]" ColumnId="33"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="[TAB].[S_T_A_M_P_]=CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/></Warnings><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1544"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70507272"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-11-23T11:52:49.13" ModificationCount="426424" SamplingPercent="100" Statistics="[FK20107]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-11-28T11:19:01.24" ModificationCount="94256" SamplingPercent="2.45124" Statistics="[FK2010_UNQ]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2024-09-16T11:18:24.04" ModificationCount="487470" SamplingPercent="2.51127" Statistics="[FK2010_PK]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-01-13T14:15:18.38" ModificationCount="51107" SamplingPercent="2.51503" Statistics="[FK20105]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-06-14T02:57:50.72" ModificationCount="257504" SamplingPercent="100" Statistics="[FK20108]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-11-26T16:44:19.76" ModificationCount="95852" SamplingPercent="2.45135" Statistics="[FK20101]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-09-19T12:25:17.16" ModificationCount="276100" SamplingPercent="2.4792" Statistics="[FK2010_ST]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-09-19T12:25:17.25" ModificationCount="276100" SamplingPercent="2.4792" Statistics="[FK2010_STAMP]" Table="[FK2010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.28" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[FW_TECHFINCTR1]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.77" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[_WA_Sys_00000003_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-12-08T09:14:29.74" ModificationCount="83769" SamplingPercent="2.44571" Statistics="[FK20103]" Table="[FK2... [PLANO TRUNCADO - Consulte via SSMS]

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM FK1010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'FK1010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T08:01:41.167' AND (FK1_DATA > '20230101' )

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM FK1010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'FK1010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ &gt;= '2026-03-13T08:01:41.167' AND (FK1_DATA &gt; '20230101' )" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="123.51" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x1AE4B8126D89BC54" QueryPlanHash="0xC52CE80A74037923" CardinalityEstimationModelVersion="120"><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="88" CompileTime="8" CompileCPU="8" CompileMemory="1040"><ThreadStat Branches="4"/><MissingIndexes><MissingIndexGroup Impact="88.425"><MissingIndex Database="[SDBPRD]" Schema="[dbo]" Table="[FK1010]"><ColumnGroup Usage="INEQUALITY"><Column Name="[FK1_DATA]" ColumnId="3"/><Column Name="[S_T_A_M_P_]" ColumnId="38"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[R_E_C_N_O_]" ColumnId="34"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="[TAB].[S_T_A_M_P_]=CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/></Warnings><MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="6408"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70511664"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-10-06T00:20:46.24" ModificationCount="1827341" SamplingPercent="100" Statistics="[FK10101]" Table="[FK1010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-05-23T09:55:03.59" ModificationCount="425637" SamplingPercent="1.19996" Statistics="[_WA_Sys_00000003_308DCC6C]" Table="[FK1010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-11-26T08:09:42.30" ModificationCount="135873" SamplingPercent="1.18306" Statistics="[FK10106]" Table="[FK1010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-12-31T02:05:39.95" ModificationCount="169378" SamplingPercent="1.17999" Statistics="[FK1010_STAMP]" Table="[FK1010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2022-11-22T00:28:09.41" ModificationCount="1758214" SamplingPercent="100" Statistics="[FK10103]" Table="[FK1010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.28" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[FW_TECHFINCTR1]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.77" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[_WA_Sys_00000003_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-11-26T08:09:41.94" ModificationCount="135873" SamplingPercent="1.18306" Statistics="[FK10104]" Table="[FK1010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-12-31T02:05:39.78" ModificationCount="169378" SamplingPercent="1.17999" Statistics="[FK1010_ST]" Table="[FK1010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.40" ModificationCount="28767" SamplingPercent="34.072" Statistics="[FW_TECHFINCTR_PK]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2022-10-21T00:24:05.99" ModificationCount="1801273" SamplingPercent="100" Stat... [PLANO TRUNCADO - Consulte via SSMS]

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM FK5010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'FK5010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T08:01:41.167' AND (FK5_DATA > '20230101' )

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM FK5010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'FK5010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ &gt;= '2026-03-13T08:01:41.167' AND (FK5_DATA &gt; '20230101' )" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="5.19678" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE59C157DF2E93AF9" QueryPlanHash="0xA17DB927A339EC46" CardinalityEstimationModelVersion="120"><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="112" CompileTime="9" CompileCPU="9" CompileMemory="1096"><ThreadStat Branches="4"/><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="[TAB].[S_T_A_M_P_]=CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/></Warnings><MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="16056"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70507272"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2025-07-15T23:12:02.42" ModificationCount="145949" SamplingPercent="100" Statistics="[FK5010_FK5_MSUIDT_UUID]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-08-28T07:47:02.43" ModificationCount="182271" SamplingPercent="2.58682" Statistics="[FK5010_ST]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-12-10T21:24:27.74" ModificationCount="40692" SamplingPercent="100" Statistics="[FK50102]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2024-11-23T11:52:53.52" ModificationCount="249738" SamplingPercent="100" Statistics="[FK50108]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-08-28T07:47:02.50" ModificationCount="182271" SamplingPercent="2.58682" Statistics="[FK5010_STAMP]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-06-18T07:38:14.77" ModificationCount="137516" SamplingPercent="2.61509" Statistics="[FK50103]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-09-16T12:38:40.77" ModificationCount="87167" SamplingPercent="2.65334" Statistics="[FK5010_PK]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2024-11-23T11:53:00.72" ModificationCount="238908" SamplingPercent="100" Statistics="[FK5010A]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-10-15T08:24:18.21" ModificationCount="72060" SamplingPercent="2.56125" Statistics="[FK5010_UNQ]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2024-11-23T11:52:49.95" ModificationCount="238908" SamplingPercent="100" Statistics="[FK50105]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-02-19T11:10:14.65" ModificationCount="11527" SamplingPercent="2.52231" Statistics="[FK50107]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.28" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[FW_TECHFINCTR1]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-01-06T10:46:09.49" ModificationCount="28452" SamplingPercent="2.53302" Statistics="[FK50106]" Table="[FK5010]" Schema="[dbo]" Database="[SDBPRD]"/... [PLANO TRUNCADO - Consulte via SSMS]

SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SE5010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SE5010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ >= '2026-03-13T08:01:41.163' AND (E5_DATA >= '20230101')

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5108.50"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(R_E_C_N_O_ ) TOTAL FROM SE5010 TAB WHERE  NOT EXISTS (SELECT 1 FROM FW_TECHFINCTR WHERE  TABLE_NAME = 'SE5010' AND TAB.S_T_A_M_P_ = STAMP_ORIG AND TAB.R_E_C_N_O_= RECNO_ORIG )  AND TAB.S_T_A_M_P_ &gt;= '2026-03-13T08:01:41.163' AND (E5_DATA &gt;= '20230101')" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="56.001" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x04B69ED1A5CA973D" QueryPlanHash="0x4B4264BC9EF7BC53" CardinalityEstimationModelVersion="120"><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="104" CompileTime="10" CompileCPU="10" CompileMemory="1176"><ThreadStat Branches="3"/><MissingIndexes><MissingIndexGroup Impact="61.1304"><MissingIndex Database="[SDBPRD]" Schema="[dbo]" Table="[SE5010]"><ColumnGroup Usage="INEQUALITY"><Column Name="[E5_DATA]" ColumnId="2"/><Column Name="[S_T_A_M_P_]" ColumnId="135"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[R_E_C_N_O_]" ColumnId="120"/></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="[TAB].[S_T_A_M_P_]=CONVERT_IMPLICIT(datetime,[SDBPRD].[dbo].[FW_TECHFINCTR].[STAMP_ORIG],0)"/></Warnings><MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="125992"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70498576"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-03-13T04:16:48.28" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[FW_TECHFINCTR1]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.77" ModificationCount="28767" SamplingPercent="35.2459" Statistics="[_WA_Sys_00000003_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2025-01-08T12:27:48.81" ModificationCount="2930583" SamplingPercent="0.890066" Statistics="[SE5010_STAMP]" Table="[SE5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.40" ModificationCount="28767" SamplingPercent="34.072" Statistics="[FW_TECHFINCTR_PK]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2026-03-13T04:16:48.53" ModificationCount="28767" SamplingPercent="34.072" Statistics="[_WA_Sys_00000002_08A27695]" Table="[FW_TECHFINCTR]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2023-10-23T10:26:01.24" ModificationCount="2482830" SamplingPercent="0.926656" Statistics="[_WA_Sys_00000002_40FD439F]" Table="[SE5010]" Schema="[dbo]" Database="[SDBPRD]"/><StatisticsInfo LastUpdate="2023-10-25T00:07:18.67" ModificationCount="2473716" SamplingPercent="0.889077" Statistics="[SE5010_PK]" Table="[SE5010]" Schema="[dbo]" Database="[SDBPRD]"/></OptimizerStatsUsage><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="56.001" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"/><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1008],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1008"/... [PLANO TRUNCADO - Consulte via SSMS]

[SDBPRD].[dbo].[TRW010_SP]

[CT2_DATA], [CT2_DOC], [CT2_FILIAL], [CT2_LOTE], [CT2_SBLOTE], [D_E_L_E_T_]

[CT2_DC]

[R_E_C_N_O_]

END 
   DELETE FROM TRW010_SP  WHERE CT2_FILIAL  = @cFilial_CT2  and CT2_DATA  = @IN_DATA  and CT2_LOTE  = @IN_LOTE  and CT2_SBLOTE  = @IN_SBLOTE 
      and CT2_DOC  = @IN_DOC  and CT2_DC  != '4'  and D_E_L_E_T_  = ' '

[SDBPRD].[dbo].[SX5020]

[D_E_L_E_T_], [X5_TABELA]

[X5_CHAVE]

(@P1 char(4),@P2 char(2),@P3 char(1))SELECT DISTINCT SX5.X5_CHAVE CHAVE FROM SX5020 SX5  WHERE SX5.X5_CHAVE LIKE @P1  AND SX5.X5_TABELA = @P2 AND SX5.D_E_L_E_T_ = @P3

[SDBPRD].[dbo].[TPH_UPD]

[D_E_L_E_T_], [UP_FILTER], [UP_ID], [UP_TYPE]

[UP_DATE], [UP_HOUR]

SELECT UP_DATE,UP_HOUR FROM TPH_UPD WHERE  UP_TYPE = 'ACCUMULATED' AND UP_ID = '000002' AND UP_FILTER = ' ' AND D_E_L_E_T_ = ' '

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'F75010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'SE2010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'DA1010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'CT2010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'F20010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'CV3010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'I21010'

[SDBPRD].[dbo].[SX5010]

[D_E_L_E_T_], [X5_TABELA]

[X5_CHAVE]

(@P1 char(4),@P2 char(2),@P3 char(1))SELECT DISTINCT SX5.X5_CHAVE CHAVE FROM SX5010 SX5  WHERE SX5.X5_CHAVE LIKE @P1  AND SX5.X5_TABELA = @P2 AND SX5.D_E_L_E_T_ = @P3

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'SEA010'

[SDBPRD].[dbo].[TPH_UPD]

[D_E_L_E_T_], [UP_FILTER], [UP_ID], [UP_TYPE]

[UP_DATE], [UP_HOUR]

SELECT UP_DATE,UP_HOUR FROM TPH_UPD WHERE  UP_TYPE = 'DET_REPLACED' AND UP_ID = '000001' AND UP_FILTER = '95' AND D_E_L_E_T_ = ' '

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'FK3010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'SD2010'

[SDBPRD].[dbo].[CN9010]

[CN9_SITUAC], [D_E_L_E_T_]

[CN9_DTFIM], [CN9_DTINIC], [CN9_FILIAL], [CN9_NUMERO], [CN9_REVISA], [CN9_TPCTO]

SELECT CN9.CN9_FILIAL,CN9.CN9_NUMERO,CN9.CN9_REVISA,CN9.CN9_DTINIC,CN9.CN9_DTFIM,CN9.CN9_TPCTO FROM CN9010 CN9 WHERE  CN9.CN9_SITUAC = '05' AND CN9.D_E_L_E_T_ = ' '

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'FK2010'

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'SE5010'

[SDBPRD].[dbo].[SC1010]

[C1_TOTAL], [D_E_L_E_T_]

[C1_FILIAL], [C1_QUANT], [C1_VUNIT]

[R_E_C_N_O_]

SELECT SC1.R_E_C_N_O_ SC1RECNO FROM SC1010 SC1 WHERE  SC1.D_E_L_E_T_= ' ' AND SC1.C1_FILIAL BETWEEN '    ' AND 'ZZZZZ' AND SC1.C1_TOTAL = 0 AND SC1.C1_QUANT > 0 AND SC1.C1_VUNIT > 0  ORDER BY  1

[SDBPRD].[dbo].[FW_TECHFINCTR]

[TABLE_NAME]

[STAMP_ORIG]

SELECT MIN(STAMP_ORIG) STMP FROM FW_TECHFINCTR WHERE TABLE_NAME = 'F76010'

FK2010

[FK2_DATA], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_FK2010__FK2_DATA_S_T_A_M_P__064A9] ON [SDBPRD].[dbo].[FK2010] ([FK2_DATA], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

FK1010

[FK1_DATA], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_FK1010__FK1_DATA_S_T_A_M_P__8670D] ON [SDBPRD].[dbo].[FK1010] ([FK1_DATA], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

SB9010

[B9_DATA], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_SB9010__B9_DATA_S_T_A_M_P__3A536] ON [SDBPRD].[dbo].[SB9010] ([B9_DATA], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

F75010

[F75_VENCTO], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_F75010__F75_VENCTO_S_T_A_M_P__EABE9] ON [SDBPRD].[dbo].[F75010] ([F75_VENCTO], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

SE5010

[E5_DATA], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_SE5010__E5_DATA_S_T_A_M_P__26DCD] ON [SDBPRD].[dbo].[SE5010] ([E5_DATA], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

SFT010

[FT_ENTRADA], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_SFT010__FT_ENTRADA_S_T_A_M_P__AA0D9] ON [SDBPRD].[dbo].[SFT010] ([FT_ENTRADA], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

FW_TECHFINCTR

[TABLE_NAME]

[STAMP_ORIG]

CREATE INDEX [IX_FW_TECHFINCTR_TABLE_NAME_A853E] ON [SDBPRD].[dbo].[FW_TECHFINCTR] ([TABLE_NAME]) INCLUDE ([STAMP_ORIG])

F76010

[F76_BLQLIB]

[F76_DATA], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_F76010_F76_BLQLIB_F76_DATA_S_T_A_M_P__6BC27] ON [SDBPRD].[dbo].[F76010] ([F76_BLQLIB],[F76_DATA], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

SEA010

[EA_DATABOR], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_SEA010__EA_DATABOR_S_T_A_M_P__AADCE] ON [SDBPRD].[dbo].[SEA010] ([EA_DATABOR], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

FW_TECHFINCTR

[TABLE_NAME]

[RECNO_ORIG], [STAMP_ORIG]

CREATE INDEX [IX_FW_TECHFINCTR_TABLE_NAME_0CAEA] ON [SDBPRD].[dbo].[FW_TECHFINCTR] ([TABLE_NAME]) INCLUDE ([RECNO_ORIG], [STAMP_ORIG])

SE1010

[E1_VALOR], [E1_BAIXA], [D_E_L_E_T_]

[E1_FILIAL], [E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_]

CREATE INDEX [IX_SE1010_E1_VALOR_E1_BAIXA_D_E_L_E_T__E29DA] ON [SDBPRD].[dbo].[SE1010] ([E1_VALOR], [E1_BAIXA], [D_E_L_E_T_]) INCLUDE ([E1_FILIAL], [E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_])

TRW010_SP

[CT2_FILIAL], [CT2_DATA], [CT2_LOTE], [CT2_SBLOTE], [CT2_ATIVDE], [D_E_L_E_T_]

[CT2_DC], [CT2_TPSALD]

[CT2_MOEDLC], [CT2_DEBITO], [CT2_CREDIT], [CT2_VALOR], [CT2_CCD], [CT2_CCC], [CT2_ITEMD], [CT2_ITEMC], [CT2_CLVLDB], [CT2_CLVLCR], [CT2_DTLP], [R_E_C_N_O_]

CREATE INDEX [IX_TRW010_SP_CT2_FILIAL_CT2_DATA_CT2_LOTE_CT2_SBLOTE_CT2_ATIVDE_D_E_L_E_T__CT2_DC_CT2_TPSALD_1652A] ON [SDBPRD].[dbo].[TRW010_SP] ([CT2_FILIAL], [CT2_DATA], [CT2_LOTE], [CT2_SBLOTE], [CT2_ATIVDE], [D_E_L_E_T_],[CT2_DC], [CT2_TPSALD]) INCLUDE ([CT2_MOEDLC], [CT2_DEBITO], [CT2_CREDIT], [CT2_VALOR], [CT2_CCD], [CT2_CCC], [CT2_ITEMD], [CT2_ITEMC], [CT2_CLVLDB], [CT2_CLVLCR], [CT2_DTLP], [R_E_C_N_O_])

CQ1010

[CQ1_DATA], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_CQ1010__CQ1_DATA_S_T_A_M_P__CC445] ON [SDBPRD].[dbo].[CQ1010] ([CQ1_DATA], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

SD1010

[D1_EMISSAO], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_SD1010__D1_EMISSAO_S_T_A_M_P__1B59C] ON [SDBPRD].[dbo].[SD1010] ([D1_EMISSAO], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

SE1010

[E1_VALOR], [E1_BAIXA], [D_E_L_E_T_]

[E1_FILIAL]

[E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_]

CREATE INDEX [IX_SE1010_E1_VALOR_E1_BAIXA_D_E_L_E_T__E1_FILIAL_21D8D] ON [SDBPRD].[dbo].[SE1010] ([E1_VALOR], [E1_BAIXA], [D_E_L_E_T_],[E1_FILIAL]) INCLUDE ([E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_])

SBZ010

[BZ_FILIAL]

[D_E_L_E_T_]

[BZ_COD], [BZ_LOCPAD], [R_E_C_N_O_]

CREATE INDEX [IX_SBZ010_BZ_FILIAL_D_E_L_E_T__2FD01] ON [SDBPRD].[dbo].[SBZ010] ([BZ_FILIAL],[D_E_L_E_T_]) INCLUDE ([BZ_COD], [BZ_LOCPAD], [R_E_C_N_O_])

SE1010

[E1_VALOR], [D_E_L_E_T_]

[E1_FILIAL]

[E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_]

CREATE INDEX [IX_SE1010_E1_VALOR_D_E_L_E_T__E1_FILIAL_315F8] ON [SDBPRD].[dbo].[SE1010] ([E1_VALOR], [D_E_L_E_T_],[E1_FILIAL]) INCLUDE ([E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_])

FKD010

[FKD_DTBAIX], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_FKD010__FKD_DTBAIX_S_T_A_M_P__6BEDC] ON [SDBPRD].[dbo].[FKD010] ([FKD_DTBAIX], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])

SE1010

[E1_VALOR], [D_E_L_E_T_]

[E1_FILIAL], [E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_]

CREATE INDEX [IX_SE1010_E1_VALOR_D_E_L_E_T__C21A0] ON [SDBPRD].[dbo].[SE1010] ([E1_VALOR], [D_E_L_E_T_]) INCLUDE ([E1_FILIAL], [E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [R_E_C_N_O_])

SC8010

[C8_EMISSAO], [S_T_A_M_P_]

[R_E_C_N_O_]

CREATE INDEX [IX_SC8010__C8_EMISSAO_S_T_A_M_P__F3A41] ON [SDBPRD].[dbo].[SC8010] ([C8_EMISSAO], [S_T_A_M_P_]) INCLUDE ([R_E_C_N_O_])