Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 10.212.134.30]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.122]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.125]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.125]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.125]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 10.212.134.62]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 10.212.134.62]

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

Login failed for user 'svsdb'. Reason: Password did not match that for the login provided. [CLIENT: 192.168.100.13]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.75]

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

Login failed for user 'sa'. Reason: Failed to open the explicitly specified database 'TFCAR4_HML'. [CLIENT: 10.212.134.55]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.75]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.75]

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

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.134.47]

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

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.134.47]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 192.168.0.75]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 10.212.134.16]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 10.212.134.16]

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

Login failed for user 'powerbi'. Reason: The account is disabled. [CLIENT: 10.212.134.63]

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

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

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

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

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

INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )

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

SELECT [USR_ULTSPSW] FROM [dbo].[SYS_USR] WHERE [R_E_C_N_O_]=@1

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

UPDATE SB2010 
                       WITH (ROWLOCK) 
                        SET B2_QATU  = @nOUT_QSALDOATU , B2_VATU1  = @nOUT_CUSTOATU , B2_VATU2  = @nOUT_CUSTOATU2 , B2_VATU3  = @nOUT_CUSTOATU3 
                       , B2_VATU4  = @nOUT_CUSTOATU4 , B2_VATU5  = @nOUT_CUSTOATU5 , B2_CM1  = @nB2_CM1 , B2_CM2  = @nB2_CM2 
                       , B2_CM3  = @nB2_CM3 , B2_CM4  = @nB2_CM4 , B2_CM5  = @nB2_CM5 , B2_QTSEGUM  = @nOUT_QTSEGUM 
                      WHERE R_E_C_N_O_  between @nMinRecno and  (@nMinRecno  + 4095 )  and B2_FILIAL  = @cFil_SB2  and B2_COD  = @cProduto 
                        and B2_LOCAL  = @cLocal  and D_E_L_E_T_  = ' '

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

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 [CLK010_UNQ] ON [dbo].[CLK010] REBUILD

ALTER INDEX [Z75010_TTAT_LOG5] ON [dbo].[Z75010_TTAT_LOG] REBUILD

ALTER INDEX [MB8010_PK] ON [dbo].[MB8010] REBUILD

ALTER INDEX [Z87010_PK] ON [dbo].[Z87010] REBUILD

ALTER INDEX [F2D0304] ON [dbo].[F2D030] REBUILD

ALTER INDEX [CC2020_PK] ON [dbo].[CC2020] REBUILD

ALTER INDEX [CC2030_PK] ON [dbo].[CC2030] REBUILD

ALTER INDEX [Z74010_TTAT_LOG2] ON [dbo].[Z74010_TTAT_LOG] REBUILD

ALTER INDEX [Z70010_TTAT_LOG7] ON [dbo].[Z70010_TTAT_LOG] REBUILD

ALTER INDEX [F2D0302] ON [dbo].[F2D030] REBUILD

ALTER INDEX [SX5010_TTAT_LOG1] ON [dbo].[SX5010_TTAT_LOG] REBUILD

ALTER INDEX [SX1010_TTAT_LOG4] ON [dbo].[SX1010_TTAT_LOG] REBUILD

ALTER INDEX [CVA010_PK] ON [dbo].[CVA010] REBUILD

ALTER INDEX [CT2030_TTAT_LOG5] ON [dbo].[CT2030_TTAT_LOG] REBUILD

ALTER INDEX [Z66010_TTAT_LOG4] ON [dbo].[Z66010_TTAT_LOG] REBUILD

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

ALTER INDEX [Z70010_TTAT_LOG5] ON [dbo].[Z70010_TTAT_LOG] REBUILD

ALTER INDEX [Z75010_TTAT_LOG2] ON [dbo].[Z75010_TTAT_LOG] REBUILD

ALTER INDEX [SX3X3101_TTAT_LOG5] ON [dbo].[SX3X3101_TTAT_LOG] REBUILD

ALTER INDEX [V2K0103] ON [dbo].[V2K010] REBUILD

ALTER INDEX [A9E159D08F3771004_02_PK] ON [dbo].[A9E159D08F3771004_02] REBUILD

ALTER INDEX [SX6980_TTAT_LOG5] ON [dbo].[SX6980_TTAT_LOG] REBUILD

ALTER INDEX [Z74010_TTAT_LOG1] ON [dbo].[Z74010_TTAT_LOG] REBUILD

ALTER INDEX [SXU010_TTAT_LOG5] ON [dbo].[SXU010_TTAT_LOG] REBUILD

ALTER INDEX [SZA0301] ON [dbo].[SZA030] REBUILD

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

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

ALTER INDEX [Z56010_TTAT_LOG2] ON [dbo].[Z56010_TTAT_LOG] REBUILD

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

ALTER INDEX [F2D030_UNQ] ON [dbo].[F2D030] REBUILD

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

ALTER INDEX [SX5020_PK] ON [dbo].[SX5020] REBUILD

ALTER INDEX [Z75010_TTAT_LOG7] ON [dbo].[Z75010_TTAT_LOG] REBUILD

ALTER INDEX [V46010_UNQ] ON [dbo].[V46010] REBUILD

ALTER INDEX [Z70010_TTAT_LOG6] ON [dbo].[Z70010_TTAT_LOG] REBUILD

ALTER INDEX [CJ30303] ON [dbo].[CJ3030] REBUILD

ALTER INDEX [V8B030_UNQ] ON [dbo].[V8B030] REBUILD

ALTER INDEX [Z51010_TTAT_LOG5] ON [dbo].[Z51010_TTAT_LOG] REBUILD

ALTER INDEX [SXU980_TTAT_LOG4] ON [dbo].[SXU980_TTAT_LOG] REBUILD

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

ALTER INDEX [V8B0302] ON [dbo].[V8B030] REBUILD

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

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

ALTER INDEX [Z68010_TTAT_LOG4] ON [dbo].[Z68010_TTAT_LOG] REBUILD

ALTER INDEX [Z75010_TTAT_LOG6] ON [dbo].[Z75010_TTAT_LOG] REBUILD

ALTER INDEX [CT2010_TTAT_LOG3] ON [dbo].[CT2010_TTAT_LOG] REBUILD

ALTER INDEX [F2D0306] ON [dbo].[F2D030] REBUILD

ALTER INDEX [ZB50103] ON [dbo].[ZB5010] REBUILD

ALTER INDEX [SX6980_TTAT_LOG1] ON [dbo].[SX6980_TTAT_LOG] REBUILD

ALTER INDEX [RJ10103] ON [dbo].[RJ1010] REBUILD

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

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

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

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

UPDATE STATISTICS [dbo].[CVX010] [_WA_Sys_00000007_182CCCED] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CVX010] [_WA_Sys_00000006_182CCCED] WITH FULLSCAN

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

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

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

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

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

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

UPDATE STATISTICS [dbo].[SYS_APP_PARAM] [SYS_APP_PARAM_PK] WITH FULLSCAN

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

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

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

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

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

UPDATE STATISTICS [dbo].[SYS_USR_LOGIN_TTAT_LOG] [SYS_USR_LOGIN_TTAT_LOG4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[TOTVS_ADTDET] [_WA_Sys_00000006_7ED40F7D] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CQ5010] [_WA_Sys_00000001_1A5839DD] WITH FULLSCAN

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

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

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

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

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

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

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

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

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

UPDATE STATISTICS [dbo].[CD2010] [_WA_Sys_00000013_02DBDEF5] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CQ9010] [_WA_Sys_00000001_57091506] WITH FULLSCAN

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

UPDATE STATISTICS [dbo].[SP8010] [_WA_Sys_00000024_3A11A7AF] WITH FULLSCAN

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

UPDATE STATISTICS [dbo].[SP8010] [_WA_Sys_00000018_3A11A7AF] WITH FULLSCAN

UPDATE STATISTICS [dbo].[CT2980] [_WA_Sys_00000032_5726FD3B] WITH FULLSCAN

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

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

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

UPDATE STATISTICS [dbo].[TOTVS_AUDIT] [_WA_Sys_00000001_6E9DA7B4] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SD2010] [_WA_Sys_00000061_439B0DBA] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SL2010] [_WA_Sys_0000002F_1D70A4F7] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SP8010] [_WA_Sys_00000007_3A11A7AF] WITH FULLSCAN

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

UPDATE STATISTICS [dbo].[CQ3010] [_WA_Sys_00000001_4EDDE359] WITH FULLSCAN

UPDATE STATISTICS [dbo].[SD2010] [_WA_Sys_00000060_439B0DBA] WITH FULLSCAN

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

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

UPDATE STATISTICS [dbo].[CQ8010] [_WA_Sys_00000001_46D2AD3D] WITH FULLSCAN

-- Procedure creation 
CREATE PROCEDURE CTB190_06_03 (
    @IN_FILIAL Char( 4) , 
    @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( 4)
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( 14)
DECLARE @cCustoC Char( 14)
DECLARE @cItemD Char( 14)
DECLARE @cItemC Char( 14)
DECLARE @cClvlD Char( 14)
DECLARE @cClvlC Char( 14)
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_03 @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 TRW030_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.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB190_06_03 (&#x0A;    @IN_FILIAL Char( 4) , &#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( 4)&#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( 14)&#x0A;DECLARE @cCustoC Char( 14)&#x0A;DECLARE @cItemD Char( 14)&#x0A;DECLARE @cItemC Char( 14)&#x0A;DECLARE @cClvlD Char( 14)&#x0A;DECLARE @cClvlC Char( 14)&#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_03 @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 TRW030_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="88" CompileTime="345" CompileCPU="334" CompileMemory="592"><ThreadStat Branches="1"/><MissingIndexes><MissingIndexGroup Impact="99.9661"><MissingIndex Database="[TFCAR4_PRD]" Schema="[dbo]" Table="[TRW030_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="99"/></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[CT2_DC]" ColumnId="8"/><Column Name="[CT2_TPSALD]" ColumnId="29"/></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Nam... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE CTB002_03_98 (
    @IN_CALIAS Char( 03 ) , 
    @IN_MOEDAESP Char( 01 ) , 
    @IN_MOEDA Char( 2) , 
    @IN_TPSALDO Char( 1) , 
    @IN_FILIALDE Char( 4) , 
    @IN_FILIALATE Char( 4) , 
    @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( 4)
DECLARE @cFilial_CQ0 Char( 4)
DECLARE @cFilial_CQ1 Char( 4)
DECLARE @cFilial_CQ2 Char( 4)
DECLARE @cFilial_CQ3 Char( 4)
DECLARE @cFilial_CQ4 Char( 4)
DECLARE @cFilial_CQ5 Char( 4)
DECLARE @cFilial_CQ6 Char( 4)
DECLARE @cFilial_CQ7 Char( 4)
DECLARE @cFilial_CQ8 Char( 4)
DECLARE @cFilial_CQ9 Char( 4)
DECLARE @cFilial_CTC Char( 4)
DECLARE @cFilial_CQA Char( 4)
DECLARE @cCT2Fil Char( 4)
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_03_98 @IN_DATAATE , @cDataF output 
      SET @cAux  = 'CQ0' 
      EXEC XFILIAL_03_98 @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 CQ0980 
        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.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtCond StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB002_03_98 (&#x0A;    @IN_CALIAS Char( 03 ) , &#x0A;    @IN_MOEDAESP Char( 01 ) , &#x0A;    @IN_MOEDA Char( 2) , &#x0A;    @IN_TPSALDO Char( 1) , &#x0A;    @IN_FILIALDE Char( 4) , &#x0A;    @IN_FILIALATE Char( 4) , &#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( 4)&#x0A;DECLARE @cFilial_CQ0 Char( 4)&#x0A;DECLARE @cFilial_CQ1 Char( 4)&#x0A;DECLARE @cFilial_CQ2 Char( 4)&#x0A;DECLARE @cFilial_CQ3 Char( 4)&#x0A;DECLARE @cFilial_CQ4 Char( 4)&#x0A;DECLARE @cFilial_CQ5 Char( 4)&#x0A;DECLARE @cFilial_CQ6 Char( 4)&#x0A;DECLARE @cFilial_CQ7 Char( 4)&#x0A;DECLARE @cFilial_CQ8 Char( 4)&#x0A;DECLARE @cFilial_CQ9 Char( 4)&#x0A;DECLARE @cFilial_CTC Char( 4)&#x0A;DECLARE @cFilial_CQA Char( 4)&#x0A;DECLARE @cCT2Fil Char( 4)&#x0A;DECLARE @cAux Char( 03 )&#x0A;DECLARE @cDataI Char( 08 )&#x0A;DECLARE @cDataF Char( 08 )&#x0A;BEGIN&#x0A;   IF @IN_FILIALDE  = ' '" StatementId="1" StatementCompId="140" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cFilial_CT2  = ' ' &#x0A;   " StatementId="2" StatementCompId="141" 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="144" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Else></StmtCond><StmtCond StatementText="END &#x0A;   IF  (@IN_CALIAS  = 'CQ0' )" StatementId="4" StatementCompId="146" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cDataI  = SUBSTRING ( @IN_DATADE , 1 , 6 ) + '01' &#x0A;      " StatementId="5" StatementCompId="147" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC LASTDAY_03_98 @IN_DATAATE , @cDataF output" StatementId="6" StatementCompId="148" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;      SET @cAux  = 'CQ0' &#x0A;      " StatementId="7" StatementCompId="149" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_03_98 @cAux , @cFilial_CT2 , @cFilial_CQ0 output" StatementId="8" StatementCompId="150" 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 CQ0980 &#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="151" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00682277" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x79CE6503510DAA4D" QueryPlanHash="0x54E5B940206E31D3" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><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="512"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemo... [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( 4) , 
    @IN_FILIALATE Char( 4) , 
    @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( 4)
DECLARE @cFilial_CQ0 Char( 4)
DECLARE @cFilial_CQ1 Char( 4)
DECLARE @cFilial_CQ2 Char( 4)
DECLARE @cFilial_CQ3 Char( 4)
DECLARE @cFilial_CQ4 Char( 4)
DECLARE @cFilial_CQ5 Char( 4)
DECLARE @cFilial_CQ6 Char( 4)
DECLARE @cFilial_CQ7 Char( 4)
DECLARE @cFilial_CQ8 Char( 4)
DECLARE @cFilial_CQ9 Char( 4)
DECLARE @cFilial_CTC Char( 4)
DECLARE @cFilial_CQA Char( 4)
DECLARE @cCT2Fil Char( 4)
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.481" Build="14.0.3456.2"><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( 4) , &#x0A;    @IN_FILIALATE Char( 4) , &#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( 4)&#x0A;DECLARE @cFilial_CQ0 Char( 4)&#x0A;DECLARE @cFilial_CQ1 Char( 4)&#x0A;DECLARE @cFilial_CQ2 Char( 4)&#x0A;DECLARE @cFilial_CQ3 Char( 4)&#x0A;DECLARE @cFilial_CQ4 Char( 4)&#x0A;DECLARE @cFilial_CQ5 Char( 4)&#x0A;DECLARE @cFilial_CQ6 Char( 4)&#x0A;DECLARE @cFilial_CQ7 Char( 4)&#x0A;DECLARE @cFilial_CQ8 Char( 4)&#x0A;DECLARE @cFilial_CQ9 Char( 4)&#x0A;DECLARE @cFilial_CTC Char( 4)&#x0A;DECLARE @cFilial_CQA Char( 4)&#x0A;DECLARE @cCT2Fil Char( 4)&#x0A;DECLARE @cAux Char( 03 )&#x0A;DECLARE @cDataI Char( 08 )&#x0A;DECLARE @cDataF Char( 08 )&#x0A;BEGIN&#x0A;   IF @IN_FILIALDE  = ' '" StatementId="1" StatementCompId="233" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cFilial_CT2  = ' ' &#x0A;   " StatementId="2" StatementCompId="234" 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="237" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Else></StmtCond><StmtCond StatementText="END &#x0A;   IF  (@IN_CALIAS  = 'CQ0' )" StatementId="4" StatementCompId="239" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cDataI  = SUBSTRING ( @IN_DATADE , 1 , 6 ) + '01' &#x0A;      " StatementId="5" StatementCompId="240" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC LASTDAY_01_01 @IN_DATAATE , @cDataF output" StatementId="6" StatementCompId="241" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;      SET @cAux  = 'CQ0' &#x0A;      " StatementId="7" StatementCompId="242" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_01_01 @cAux , @cFilial_CT2 , @cFilial_CQ0 output" StatementId="8" StatementCompId="243" 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="244" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00671253" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xFA9196F7C8015FA7" QueryPlanHash="0x9D418EF67CE2AED9" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><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="560"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemo... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE CTB021_03_98 (
    @IN_FILIAL Char( 4) , 
    @IN_LCUSTO Char( 01 ) , 
    @IN_LITEM Char( 01 ) , 
    @IN_LCLVL Char( 01 ) , 
    @IN_FILIALATE Char( 4) , 
    @IN_DATADE Char( 08 ) , 
    @IN_DATAATE Char( 08 ) , 
    @IN_LMOEDAESP Char( 01 ) , 
    @IN_MOEDA Char( 2) , 
    @IN_TPSALDO Char( 1) , 
    @IN_EMPANT Char( 02 ) , 
    @IN_FILANT Char( 4) , 
    @IN_TRANSACTION Char( 01 ) , 
    @OUT_RESULTADO Char( 01 )  output ) AS
 
-- Declaration of variables
DECLARE @cFilial_CT2 Char( 4)
DECLARE @cCT2FilDe Char( 4)
DECLARE @cFILCT2 Char( 4)
DECLARE @cFilial_CQ0 Char( 4)
DECLARE @cFilial_CQ1 Char( 4)
DECLARE @cFilial_CQ2 Char( 4)
DECLARE @cFilial_CQ3 Char( 4)
DECLARE @cFilial_CQ4 Char( 4)
DECLARE @cFilial_CQ5 Char( 4)
DECLARE @cFilial_CQ6 Char( 4)
DECLARE @cFilial_CQ7 Char( 4)
DECLARE @cFilAux Char( 4)
DECLARE @cAux Char( 03 )
DECLARE @nDebMes Float
DECLARE @nCrdMes Float
DECLARE @cTabela Char( 03 )
DECLARE @iRecno Integer
DECLARE @nCTX_DEBITO Float
DECLARE @nCTX_CREDIT Float
DECLARE @cCTX_DTLP Char( 08 )
DECLARE @cCTX_LP Char( 1)
DECLARE @cCTX_STATUS Char( 1)
DECLARE @cCTX_SLBASE Char( 1)
DECLARE @cCT2_DTLP Char( 08 )
DECLARE @cTIPO Char( 01 )
DECLARE @cDATA Char( 08 )
DECLARE @cCONTA Char( 20)
DECLARE @cCUSTO Char( 14)
DECLARE @cITEM Char( 14)
DECLARE @cCLVL Char( 14)
DECLARE @cMOEDA Char( 2)
DECLARE @nVALOR Float
DECLARE @nVALORDeb Float
DECLARE @nVALORCred Float
DECLARE @cIdent VarChar( 03 )
DECLARE @cDataI Char( 08 )
DECLARE @cDataF Char( 08 )
DECLARE @cAnoMes Char( 06 )
DECLARE @lPrim Char( 01 )
DECLARE @iTranCount Integer
DECLARE @cDATACQ Char( 06 )
DECLARE @cDataAux Char( 06 )
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_FILIAL  = ' ' 
   BEGIN 
      SET @cCT2FilDe  = ' ' 
   END 
   ELSE 
   BEGIN 
      ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB021_03_98 (&#x0A;    @IN_FILIAL Char( 4) , &#x0A;    @IN_LCUSTO Char( 01 ) , &#x0A;    @IN_LITEM Char( 01 ) , &#x0A;    @IN_LCLVL Char( 01 ) , &#x0A;    @IN_FILIALATE Char( 4) , &#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_EMPANT Char( 02 ) , &#x0A;    @IN_FILANT Char( 4) , &#x0A;    @IN_TRANSACTION Char( 01 ) , &#x0A;    @OUT_RESULTADO Char( 01 )  output ) AS&#x0A; &#x0A;-- Declaration of variables&#x0A;DECLARE @cFilial_CT2 Char( 4)&#x0A;DECLARE @cCT2FilDe Char( 4)&#x0A;DECLARE @cFILCT2 Char( 4)&#x0A;DECLARE @cFilial_CQ0 Char( 4)&#x0A;DECLARE @cFilial_CQ1 Char( 4)&#x0A;DECLARE @cFilial_CQ2 Char( 4)&#x0A;DECLARE @cFilial_CQ3 Char( 4)&#x0A;DECLARE @cFilial_CQ4 Char( 4)&#x0A;DECLARE @cFilial_CQ5 Char( 4)&#x0A;DECLARE @cFilial_CQ6 Char( 4)&#x0A;DECLARE @cFilial_CQ7 Char( 4)&#x0A;DECLARE @cFilAux Char( 4)&#x0A;DECLARE @cAux Char( 03 )&#x0A;DECLARE @nDebMes Float&#x0A;DECLARE @nCrdMes Float&#x0A;DECLARE @cTabela Char( 03 )&#x0A;DECLARE @iRecno Integer&#x0A;DECLARE @nCTX_DEBITO Float&#x0A;DECLARE @nCTX_CREDIT Float&#x0A;DECLARE @cCTX_DTLP Char( 08 )&#x0A;DECLARE @cCTX_LP Char( 1)&#x0A;DECLARE @cCTX_STATUS Char( 1)&#x0A;DECLARE @cCTX_SLBASE Char( 1)&#x0A;DECLARE @cCT2_DTLP Char( 08 )&#x0A;DECLARE @cTIPO Char( 01 )&#x0A;DECLARE @cDATA Char( 08 )&#x0A;DECLARE @cCONTA Char( 20)&#x0A;DECLARE @cCUSTO Char( 14)&#x0A;DECLARE @cITEM Char( 14)&#x0A;DECLARE @cCLVL Char( 14)&#x0A;DECLARE @cMOEDA Char( 2)&#x0A;DECLARE @nVALOR Float&#x0A;DECLARE @nVALORDeb Float&#x0A;DECLARE @nVALORCred Float&#x0A;DECLARE @cIdent VarChar( 03 )&#x0A;DECLARE @cDataI Char( 08 )&#x0A;DECLARE @cDataF Char( 08 )&#x0A;DECLARE @cAnoMes Char( 06 )&#x0A;DECLARE @lPrim Char( 01 )&#x0A;DECLARE @iTranCount Integer&#x0A;DECLARE @cDATACQ Char( 06 )&#x0A;DECLARE @cDataAux Char( 06 )&#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="606" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtCond StatementText="IF @IN_FILIAL  = ' '" StatementId="2" StatementCompId="607" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cCT2FilDe  = ' ' &#x0A;   " StatementId="3" StatementCompId="608" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Then><Else><Statements><StmtSimple StatementText="END &#x0A;   ELSE &#x0A;   BEGIN &#x0A;      SET @cCT2FilDe  = @IN_FILIAL &#x0A;   " StatementId="4" StatementCompId="611" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Else></StmtCond><StmtSimple StatementText="END &#x0A;   SET @cAux  = 'CT2' &#x0A;   " StatementId="5" StatementCompId="613" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_03_98 @cAux , @cCT2FilDe , @cFilial_CT2 output" StatementId="6" StatementCompId="614" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtCursor StatementText=" &#x0A;    &#x0A;   -- Cursor declaration CUR_CTB190&#x0A;   DECLARE CUR_CTB190 insensitive  CURSOR FOR &#x0A;   SELECT CT2_FILIAL , CONTA , CT2_MOEDLC , CT2_DATA , CT2_DTLP , SUM(CT2_VALOR ), TIPO &#x0A;     FROM (&#x0A;   SELECT CT2_FILIAL , CT2_DEBITO  CONTA , CT2_MOEDLC , CT2_DATA , CT2_DTLP , CT2_VALOR , '1'  TIPO , CT2_LOTE , CT2_SBLOTE , &#x0A;          CT2_DOC , CT2_LINHA , CT2_TPSALD , CT2_EMPORI , CT2_FILORI &#x0A;     FROM CT2980 &#x0A;     WHERE CT2_FILIAL  between @cFilial_CT2 and @IN_FIL... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE CTB002_01_03 (
    @IN_CALIAS Char( 03 ) , 
    @IN_MOEDAESP Char( 01 ) , 
    @IN_MOEDA Char( 2) , 
    @IN_TPSALDO Char( 1) , 
    @IN_FILIALDE Char( 4) , 
    @IN_FILIALATE Char( 4) , 
    @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( 4)
DECLARE @cFilial_CQ0 Char( 4)
DECLARE @cFilial_CQ1 Char( 4)
DECLARE @cFilial_CQ2 Char( 4)
DECLARE @cFilial_CQ3 Char( 4)
DECLARE @cFilial_CQ4 Char( 4)
DECLARE @cFilial_CQ5 Char( 4)
DECLARE @cFilial_CQ6 Char( 4)
DECLARE @cFilial_CQ7 Char( 4)
DECLARE @cFilial_CQ8 Char( 4)
DECLARE @cFilial_CQ9 Char( 4)
DECLARE @cFilial_CTC Char( 4)
DECLARE @cFilial_CQA Char( 4)
DECLARE @cCT2Fil Char( 4)
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_03 @IN_DATAATE , @cDataF output 
      SET @cAux  = 'CQ0' 
      EXEC XFILIAL_01_03 @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 CQ0030 
        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.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtCond StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB002_01_03 (&#x0A;    @IN_CALIAS Char( 03 ) , &#x0A;    @IN_MOEDAESP Char( 01 ) , &#x0A;    @IN_MOEDA Char( 2) , &#x0A;    @IN_TPSALDO Char( 1) , &#x0A;    @IN_FILIALDE Char( 4) , &#x0A;    @IN_FILIALATE Char( 4) , &#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( 4)&#x0A;DECLARE @cFilial_CQ0 Char( 4)&#x0A;DECLARE @cFilial_CQ1 Char( 4)&#x0A;DECLARE @cFilial_CQ2 Char( 4)&#x0A;DECLARE @cFilial_CQ3 Char( 4)&#x0A;DECLARE @cFilial_CQ4 Char( 4)&#x0A;DECLARE @cFilial_CQ5 Char( 4)&#x0A;DECLARE @cFilial_CQ6 Char( 4)&#x0A;DECLARE @cFilial_CQ7 Char( 4)&#x0A;DECLARE @cFilial_CQ8 Char( 4)&#x0A;DECLARE @cFilial_CQ9 Char( 4)&#x0A;DECLARE @cFilial_CTC Char( 4)&#x0A;DECLARE @cFilial_CQA Char( 4)&#x0A;DECLARE @cCT2Fil Char( 4)&#x0A;DECLARE @cAux Char( 03 )&#x0A;DECLARE @cDataI Char( 08 )&#x0A;DECLARE @cDataF Char( 08 )&#x0A;BEGIN&#x0A;   IF @IN_FILIALDE  = ' '" StatementId="1" StatementCompId="233" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cFilial_CT2  = ' ' &#x0A;   " StatementId="2" StatementCompId="234" 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="237" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Else></StmtCond><StmtCond StatementText="END &#x0A;   IF  (@IN_CALIAS  = 'CQ0' )" StatementId="4" StatementCompId="239" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cDataI  = SUBSTRING ( @IN_DATADE , 1 , 6 ) + '01' &#x0A;      " StatementId="5" StatementCompId="240" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC LASTDAY_01_03 @IN_DATAATE , @cDataF output" StatementId="6" StatementCompId="241" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;      SET @cAux  = 'CQ0' &#x0A;      " StatementId="7" StatementCompId="242" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_01_03 @cAux , @cFilial_CT2 , @cFilial_CQ0 output" StatementId="8" StatementCompId="243" 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 CQ0030 &#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="244" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00684536" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3AA2B908B80137E2" QueryPlanHash="0x4A8A423620AF4F7E" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><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="416"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemo... [PLANO TRUNCADO - Consulte via SSMS]

DELETE FROM SCHDTSK WHERE UPPER(TSK_ROTINA) = 'FWTECHFINJOB' AND D_E_L_E_T_ = ' '

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="DELETE FROM SCHDTSK WHERE UPPER(TSK_ROTINA) = 'FWTECHFINJOB' AND D_E_L_E_T_ = ' '" StatementId="1" StatementCompId="1" StatementType="DELETE" RetrievedFromCache="true" StatementSubTreeCost="33.8302" StatementEstRows="26129.6" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x78227E46130F00CB" QueryPlanHash="0x0E479C607122638C" CardinalityEstimationModelVersion="140"><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="2" CompileCPU="2" CompileMemory="464"><ThreadStat Branches="1"/><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="6656"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="72419360"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-03-04T16:15:23.68" ModificationCount="6000" SamplingPercent="6.72671" Statistics="[_WA_Sys_00000005_7F4E069D]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T16:03:11.44" ModificationCount="6108" SamplingPercent="6.55688" Statistics="[_WA_Sys_00000002_7F4E069D]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T16:15:23.78" ModificationCount="5993" SamplingPercent="6.72539" Statistics="[_WA_Sys_00000009_7F4E069D]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T16:10:10.29" ModificationCount="6006" SamplingPercent="6.72679" Statistics="[_WA_Sys_00000004_7F4E069D]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T17:47:38.84" ModificationCount="15541" SamplingPercent="6.56234" Statistics="[SCHDTSK3]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T01:02:12.16" ModificationCount="13061" SamplingPercent="6.31803" Statistics="[_WA_Sys_00000008_7F4E069D]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T16:03:12.39" ModificationCount="6024" SamplingPercent="6.72683" Statistics="[_WA_Sys_00000003_7F4E069D]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T01:17:09.34" ModificationCount="13009" SamplingPercent="6.81389" Statistics="[SCHDTSK5]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T16:03:11.47" ModificationCount="6107" SamplingPercent="6.55687" Statistics="[SCHDTSK_PK]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-03T12:17:35.17" ModificationCount="19425" SamplingPercent="6.58349" Statistics="[_WA_Sys_00000011_7F4E069D]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T01:17:09.04" ModificationCount="13029" SamplingPercent="6.81421" Statistics="[SCHDTSK4]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T01:02:11.83" ModificationCount="13106" SamplingPercent="6.69526" Statistics="[SCHDTSK2]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T12:04:06.24" ModificationCount="8258" SamplingPercent="6.77728" Statistics="[SCHDTSK_UNQ]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-03T22:17:05.23" ModificationCount="14185" SamplingPercent="6.81267" Statistics="[SCHDTSK1]" Table="[SCHDTSK]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-03T08:33:02.31" ModificationCount="21505" SamplingPercent="8.36516" Statistics="[_WA_Sys_0000000F_7F4E069D]" Table="[SC... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE CTB153_06_03 (
    @IN_FILIAL Char( 4) , 
    @IN_DATA Char( 08 ) , 
    @IN_LOTE Char( 6) , 
    @IN_SBLOTE Char( 3) , 
    @IN_DOC Char( 6) , 
    @IN_TRANSACTION Char( 01 ) , 
    @OUT_RESULT Char( 01 )  output ) AS
 
-- Declaration of variables
DECLARE @cFilial_CT2 Char( 4)
DECLARE @cMoeda Char( 2)
DECLARE @cLinha Char( 3)
DECLARE @cDebito Char( 20)
DECLARE @cCredit Char( 20)
DECLARE @cCustoD Char( 14)
DECLARE @cCustoC Char( 14)
DECLARE @cItemD Char( 14)
DECLARE @cItemC Char( 14)
DECLARE @cClvlD Char( 14)
DECLARE @cClvlC Char( 14)
DECLARE @cAux VarChar( 03 )
DECLARE @cTpSaldo Char( 1)
DECLARE @cDc Char( 1)
DECLARE @cEmpOri Char( 2)
DECLARE @cFilOri Char( 4)
DECLARE @iRecno Integer
DECLARE @nValor Float
BEGIN
   SET @OUT_RESULT  = '0' 
   SET @cAux  = 'CT2' 
   EXEC XFILIAL_06_03 @cAux , @IN_FILIAL , @cFilial_CT2 output 
   IF @IN_TRANSACTION  = '0' 
   BEGIN 
      begin tran 
   END 
   DELETE FROM TRW030_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_  = ' ' 
   IF @IN_TRANSACTION  = '0' 
   BEGIN 
      commit tran 
   END 
    
   -- Cursor declaration CTB_CT2
   DECLARE CTB_CT2 insensitive  CURSOR FOR 
   SELECT CT2_MOEDLC , CT2_LINHA , CT2_TPSALD , CT2_DC , CT2_DEBITO , CT2_CREDIT , CT2_VALOR , CT2_CCD , CT2_CCC , CT2_ITEMD , 
          CT2_ITEMC , CT2_CLVLDB , CT2_CLVLCR , CT2_EMPORI , CT2_FILORI , R_E_C_N_O_ 
     FROM CT2030 
     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 CT2_TPSALD  <> '9'  and D_E_L_E_T_  = ' ' 
   FOR READ ONLY 
    
   OPEN CTB_CT2
   FETCH CTB_CT2 
    INTO @cMoeda , @cLinha , @cTpSaldo , @cDc , @cDebito , @cCredit , @nValor , @cCustoD , @cCustoC , @cItemD , @cItemC , 
          @cClvlD , @cClvlC , @cEmpOri , @cFilOri , @iRecno 
   ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB153_06_03 (&#x0A;    @IN_FILIAL Char( 4) , &#x0A;    @IN_DATA Char( 08 ) , &#x0A;    @IN_LOTE Char( 6) , &#x0A;    @IN_SBLOTE Char( 3) , &#x0A;    @IN_DOC Char( 6) , &#x0A;    @IN_TRANSACTION Char( 01 ) , &#x0A;    @OUT_RESULT Char( 01 )  output ) AS&#x0A; &#x0A;-- Declaration of variables&#x0A;DECLARE @cFilial_CT2 Char( 4)&#x0A;DECLARE @cMoeda Char( 2)&#x0A;DECLARE @cLinha Char( 3)&#x0A;DECLARE @cDebito Char( 20)&#x0A;DECLARE @cCredit Char( 20)&#x0A;DECLARE @cCustoD Char( 14)&#x0A;DECLARE @cCustoC Char( 14)&#x0A;DECLARE @cItemD Char( 14)&#x0A;DECLARE @cItemC Char( 14)&#x0A;DECLARE @cClvlD Char( 14)&#x0A;DECLARE @cClvlC Char( 14)&#x0A;DECLARE @cAux VarChar( 03 )&#x0A;DECLARE @cTpSaldo Char( 1)&#x0A;DECLARE @cDc Char( 1)&#x0A;DECLARE @cEmpOri Char( 2)&#x0A;DECLARE @cFilOri Char( 4)&#x0A;DECLARE @iRecno Integer&#x0A;DECLARE @nValor Float&#x0A;BEGIN&#x0A;   SET @OUT_RESULT  = '0' &#x0A;   " StatementId="1" StatementCompId="2" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cAux  = 'CT2' &#x0A;   " StatementId="2" StatementCompId="3" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_06_03 @cAux , @IN_FILIAL , @cFilial_CT2 output" StatementId="3" StatementCompId="4" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtCond StatementText=" &#x0A;   IF @IN_TRANSACTION  = '0'" StatementId="4" StatementCompId="5" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      begin tran &#x0A;   " StatementId="5" StatementCompId="6" StatementType="BEGIN TRANSACTION" RetrievedFromCache="true"/></Statements></Then></StmtCond><StmtSimple StatementText="END &#x0A;   DELETE FROM TRW030_SP  WHERE CT2_FILIAL  = @cFilial_CT2  and CT2_DATA  = @IN_DATA  and CT2_LOTE  = @IN_LOTE  and CT2_SBLOTE  = @IN_SBLOTE &#x0A;      and CT2_DOC  = @IN_DOC  and CT2_DC  != '4'  and D_E_L_E_T_  = ' '" StatementId="6" StatementCompId="8" StatementType="DELETE" RetrievedFromCache="true" StatementSubTreeCost="162.057" StatementEstRows="2.9301" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3E9A726B5B96EB49" QueryPlanHash="0xA56C0E32397C0EEE" CardinalityEstimationModelVersion="140"><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="24" CompileTime="54" CompileCPU="49" CompileMemory="512"><ThreadStat Branches="1"/><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="681574" EstimatedPagesCached="681574" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="70940064"/><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-03-04T10:49:23.34" ModificationCount="9490" SamplingPercent="4.83856" Statistics="[_WA_Sys_00000001_202B2788]" Table="[TRW030_SP]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T10:49:23.42" ModificationCount="9490" SamplingPercent="4.83856" Statistics="[_WA_Sys_00000008_202B2788]" Table="[TRW030_SP]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T11:08:47.39" ModificationCount="0" SamplingPercent="4.8384" Statistics="[_WA_Sys_00000005_202B2788]" Table="[TRW030_SP]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T10:49:23.63" ModificationCount="9490" SamplingPercent="4.83856" Statistics="[_WA_Sys_00000003_202B2788]" Table="[TRW030_SP]" Schema="[dbo]" Database="[TFCAR4_PRD]"/><StatisticsInfo LastUpdate="2026-03-04T10:49:23.46" ModificationCount="9490" SamplingPercent="4.83856" Statistics="[_WA_Sys_00000004_202B2788]" Table="[TRW0... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE CTB188_06_03 (
    @IN_FILIAL Char( 4) , 
    @IN_DATA Char( 08 ) , 
    @IN_LOTE Char( 6) , 
    @IN_SBLOTE Char( 3) , 
    @IN_DOC Char( 6) , 
    @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( 4)
DECLARE @cAux VarChar( 03 )
DECLARE @cDebito Char( 20)
DECLARE @cCredit Char( 20)
DECLARE @cCustoD Char( 14)
DECLARE @cCustoC Char( 14)
DECLARE @cItemD Char( 14)
DECLARE @cItemC Char( 14)
DECLARE @cClvlD Char( 14)
DECLARE @cClvlC Char( 14)
DECLARE @cTpSaldo Char( 1)
DECLARE @cDc Char( 1)
DECLARE @nValor Float
DECLARE @cMoedaN Char( 2)
DECLARE @cDebitoN Char( 20)
DECLARE @cCreditN Char( 20)
DECLARE @cCustoDN Char( 14)
DECLARE @cCustoCN Char( 14)
DECLARE @cItemDN Char( 14)
DECLARE @cItemCN Char( 14)
DECLARE @cClvlDN Char( 14)
DECLARE @cClvlCN Char( 14)
DECLARE @cTpSaldoN Char( 1)
DECLARE @cDcN Char( 1)
DECLARE @nValorN Float
DECLARE @nValorAux Float
DECLARE @cDataN Char( 08 )
DECLARE @cDtlpN Char( 08 )
DECLARE @cOper Char( 01 )
DECLARE @cResult Char( 01 )
DECLARE @iRecnoTRW Integer
DECLARE @iRecnoCT2 Integer
DECLARE @lExec Char( 01 )
DECLARE @cEC05DB_NEW Char( 01 )
DECLARE @cEC05CR_NEW Char( 01 )
DECLARE @cEC05DB_TRW Char( 01 )
DECLARE @cEC05CR_TRW Char( 01 )
BEGIN
   SET @OUT_RESULT  = '0' 
   SET @cResult  = '0' 
   SET @lExec  = '1' 
   SET @cMoedaN  = ' '   
   SET @cTpSaldo  = ' '   
   SET @cDc  = ' '   
   SET @nValor  = 0   
   SET @nValorAux  = 0 
   SET @cDebito  = ' '   
   SET @cCredit  = ' '   
   SET @cCustoD  = ' '   
   SET @cCustoC  = ' '   
   SET @cItemD  = ' ' 
   SET @cItemC  = ' '   
   SET @cClvlD  = ' '   
   SET @cClvlC  = ' '   
   SET @iRecnoTRW  = null 
   SET @cEC05DB_NEW  = ' '   
   SET @cEC05CR_NEW  = ' '   
   SET @cEC05DB_TRW  = ' '   
   SET @cEC05CR_TRW  = ' ' 
   SET @cAux  = 'CT2' 
   EXEC XFILIAL_06_03 @cAux , @IN_FILIAL , @cFilial_CT2 output 
    
   -- Cur... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE CTB188_06_03 (&#x0A;    @IN_FILIAL Char( 4) , &#x0A;    @IN_DATA Char( 08 ) , &#x0A;    @IN_LOTE Char( 6) , &#x0A;    @IN_SBLOTE Char( 3) , &#x0A;    @IN_DOC Char( 6) , &#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( 4)&#x0A;DECLARE @cAux VarChar( 03 )&#x0A;DECLARE @cDebito Char( 20)&#x0A;DECLARE @cCredit Char( 20)&#x0A;DECLARE @cCustoD Char( 14)&#x0A;DECLARE @cCustoC Char( 14)&#x0A;DECLARE @cItemD Char( 14)&#x0A;DECLARE @cItemC Char( 14)&#x0A;DECLARE @cClvlD Char( 14)&#x0A;DECLARE @cClvlC Char( 14)&#x0A;DECLARE @cTpSaldo Char( 1)&#x0A;DECLARE @cDc Char( 1)&#x0A;DECLARE @nValor Float&#x0A;DECLARE @cMoedaN Char( 2)&#x0A;DECLARE @cDebitoN Char( 20)&#x0A;DECLARE @cCreditN Char( 20)&#x0A;DECLARE @cCustoDN Char( 14)&#x0A;DECLARE @cCustoCN Char( 14)&#x0A;DECLARE @cItemDN Char( 14)&#x0A;DECLARE @cItemCN Char( 14)&#x0A;DECLARE @cClvlDN Char( 14)&#x0A;DECLARE @cClvlCN Char( 14)&#x0A;DECLARE @cTpSaldoN Char( 1)&#x0A;DECLARE @cDcN Char( 1)&#x0A;DECLARE @nValorN Float&#x0A;DECLARE @nValorAux Float&#x0A;DECLARE @cDataN Char( 08 )&#x0A;DECLARE @cDtlpN Char( 08 )&#x0A;DECLARE @cOper Char( 01 )&#x0A;DECLARE @cResult Char( 01 )&#x0A;DECLARE @iRecnoTRW Integer&#x0A;DECLARE @iRecnoCT2 Integer&#x0A;DECLARE @lExec Char( 01 )&#x0A;DECLARE @cEC05DB_NEW Char( 01 )&#x0A;DECLARE @cEC05CR_NEW Char( 01 )&#x0A;DECLARE @cEC05DB_TRW Char( 01 )&#x0A;DECLARE @cEC05CR_TRW Char( 01 )&#x0A;BEGIN&#x0A;   SET @OUT_RESULT  = '0' &#x0A;   " StatementId="1" StatementCompId="2" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cResult  = '0' &#x0A;   " StatementId="2" StatementCompId="3" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @lExec  = '1' &#x0A;   " StatementId="3" StatementCompId="4" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cMoedaN  = ' '   &#x0A;   " StatementId="4" StatementCompId="5" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cTpSaldo  = ' '   &#x0A;   " StatementId="5" StatementCompId="6" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cDc  = ' '   &#x0A;   " StatementId="6" StatementCompId="7" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @nValor  = 0   &#x0A;   " StatementId="7" StatementCompId="8" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @nValorAux  = 0 &#x0A;   " StatementId="8" StatementCompId="9" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cDebito  = ' '   &#x0A;   " StatementId="9" StatementCompId="10" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cCredit  = ' '   &#x0A;   " StatementId="10" StatementCompId="11" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cCustoD  = ' '   &#x0A;   " StatementId="11" StatementCompId="12" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cCustoC  = ' '   &#x0A;   " StatementId="12" StatementCompId="13" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cItemD  = ' ' &#x0A;   " StatementId="13" StatementCompId="14" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cItemC  = ' '   &#x0A;   " StatementId="14" StatementCompId="15" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cClvlD  = ' '   &#x0A;   " StatementId="15" StatementCompId="16" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cClvlC  = ' '   &#x0A... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE MAT054_19_01 (
    @IN_FILIALCOR Char( 4) , 
    @IN_CFILAUX Char( 4) , 
    @IN_DINICIO Char( 08 ) , 
    @IN_MV_MOEDACM Char( 05 ) , 
    @IN_MV_PAR1 Char( 08 ) , 
    @IN_MV_CUSFIFO Char( 01 ) , 
    @OUT_RESULTADO Char( 01 )  output ) AS
 
-- Declaration of variables
DECLARE @cFil_SBD Char( 4)
DECLARE @cFil_SD8 Char( 4)
DECLARE @cFil_SCC Char( 4)
DECLARE @cCC_DATA Char( 8)
DECLARE @cCC_PRODUTO Char( 15)
DECLARE @cCC_LOCAL Char( 2)
DECLARE @cCC_DTORIG Char( 8)
DECLARE @cCC_SEQ Char( 6)
DECLARE @cBD_PRODUTO Char( 15)
DECLARE @cBD_LOCAL Char( 2)
DECLARE @cBD_SEQ Char( 6)
DECLARE @cFILAUX Char( 4)
DECLARE @cFiltra Char( 01 )
DECLARE @cAux VarChar( 03 )
DECLARE @iPos Integer
DECLARE @iRecno Integer
DECLARE @iMaxRecno Integer
DECLARE @iRec Integer
DECLARE @iRecAnt Integer
DECLARE @vBD_CUSINI2 Decimal( 14,4)
DECLARE @vBD_CUSINI3 Decimal( 14,4)
DECLARE @vBD_CUSINI4 Decimal( 14,4)
DECLARE @vBD_CUSINI5 Decimal( 14,4)
DECLARE @vBD_CUSFIM2 Decimal( 14,4)
DECLARE @vBD_CUSFIM3 Decimal( 14,4)
DECLARE @vBD_CUSFIM4 Decimal( 14,4)
DECLARE @vBD_CUSFIM5 Decimal( 14,4)
DECLARE @vD8_CUSTO2 Decimal( 14,2)
DECLARE @vD8_CUSTO3 Decimal( 14,2)
DECLARE @vD8_CUSTO4 Decimal( 14,2)
DECLARE @vD8_CUSTO5 Decimal( 14,2)
DECLARE @vCC_QINI Decimal( 14,2)
DECLARE @vCC_QINI2UM Decimal( 14,2)
DECLARE @vCC_VINIFF1 Decimal( 14,2)
DECLARE @vCC_VINIFF2 Decimal( 14,2)
DECLARE @vCC_VINIFF3 Decimal( 14,2)
DECLARE @vCC_VINIFF4 Decimal( 14,2)
DECLARE @vCC_VINIFF5 Decimal( 14,2)
DECLARE @vCC_QFIM Decimal( 14,2)
DECLARE @vCC_VFIMFF1 Decimal( 14,2)
DECLARE @vCC_VFIMFF2 Decimal( 14,2)
DECLARE @vCC_VFIMFF3 Decimal( 14,2)
DECLARE @vCC_VFIMFF4 Decimal( 14,2)
DECLARE @vCC_VFIMFF5 Decimal( 14,2)
DECLARE @vCC_QFIM2UM Decimal( 14,2)
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' 
   ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE MAT054_19_01 (&#x0A;    @IN_FILIALCOR Char( 4) , &#x0A;    @IN_CFILAUX Char( 4) , &#x0A;    @IN_DINICIO Char( 08 ) , &#x0A;    @IN_MV_MOEDACM Char( 05 ) , &#x0A;    @IN_MV_PAR1 Char( 08 ) , &#x0A;    @IN_MV_CUSFIFO Char( 01 ) , &#x0A;    @OUT_RESULTADO Char( 01 )  output ) AS&#x0A; &#x0A;-- Declaration of variables&#x0A;DECLARE @cFil_SBD Char( 4)&#x0A;DECLARE @cFil_SD8 Char( 4)&#x0A;DECLARE @cFil_SCC Char( 4)&#x0A;DECLARE @cCC_DATA Char( 8)&#x0A;DECLARE @cCC_PRODUTO Char( 15)&#x0A;DECLARE @cCC_LOCAL Char( 2)&#x0A;DECLARE @cCC_DTORIG Char( 8)&#x0A;DECLARE @cCC_SEQ Char( 6)&#x0A;DECLARE @cBD_PRODUTO Char( 15)&#x0A;DECLARE @cBD_LOCAL Char( 2)&#x0A;DECLARE @cBD_SEQ Char( 6)&#x0A;DECLARE @cFILAUX Char( 4)&#x0A;DECLARE @cFiltra Char( 01 )&#x0A;DECLARE @cAux VarChar( 03 )&#x0A;DECLARE @iPos Integer&#x0A;DECLARE @iRecno Integer&#x0A;DECLARE @iMaxRecno Integer&#x0A;DECLARE @iRec Integer&#x0A;DECLARE @iRecAnt Integer&#x0A;DECLARE @vBD_CUSINI2 Decimal( 14,4)&#x0A;DECLARE @vBD_CUSINI3 Decimal( 14,4)&#x0A;DECLARE @vBD_CUSINI4 Decimal( 14,4)&#x0A;DECLARE @vBD_CUSINI5 Decimal( 14,4)&#x0A;DECLARE @vBD_CUSFIM2 Decimal( 14,4)&#x0A;DECLARE @vBD_CUSFIM3 Decimal( 14,4)&#x0A;DECLARE @vBD_CUSFIM4 Decimal( 14,4)&#x0A;DECLARE @vBD_CUSFIM5 Decimal( 14,4)&#x0A;DECLARE @vD8_CUSTO2 Decimal( 14,2)&#x0A;DECLARE @vD8_CUSTO3 Decimal( 14,2)&#x0A;DECLARE @vD8_CUSTO4 Decimal( 14,2)&#x0A;DECLARE @vD8_CUSTO5 Decimal( 14,2)&#x0A;DECLARE @vCC_QINI Decimal( 14,2)&#x0A;DECLARE @vCC_QINI2UM Decimal( 14,2)&#x0A;DECLARE @vCC_VINIFF1 Decimal( 14,2)&#x0A;DECLARE @vCC_VINIFF2 Decimal( 14,2)&#x0A;DECLARE @vCC_VINIFF3 Decimal( 14,2)&#x0A;DECLARE @vCC_VINIFF4 Decimal( 14,2)&#x0A;DECLARE @vCC_VINIFF5 Decimal( 14,2)&#x0A;DECLARE @vCC_QFIM Decimal( 14,2)&#x0A;DECLARE @vCC_VFIMFF1 Decimal( 14,2)&#x0A;DECLARE @vCC_VFIMFF2 Decimal( 14,2)&#x0A;DECLARE @vCC_VFIMFF3 Decimal( 14,2)&#x0A;DECLARE @vCC_VFIMFF4 Decimal( 14,2)&#x0A;DECLARE @vCC_VFIMFF5 Decimal( 14,2)&#x0A;DECLARE @vCC_QFIM2UM Decimal( 14,2)&#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="1433" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cFiltra  = '0' &#x0A;   " StatementId="2" StatementCompId="1434" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="SET @cFILAUX  = @IN_CFILAUX &#x0A;   " StatementId="3" StatementCompId="1435" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtCond StatementText="IF @cFILAUX is null" StatementId="4" StatementCompId="1436" StatementType="COND" RetrievedFromCache="true"><Condition/><Then><Statements><StmtSimple StatementText=" &#x0A;   BEGIN &#x0A;      SET @cFILAUX  = '  ' &#x0A;   " StatementId="5" StatementCompId="1437" StatementType="ASSIGN" RetrievedFromCache="true"/></Statements></Then></StmtCond><StmtSimple StatementText="END &#x0A;   SET @cAux  = 'SBD' &#x0A;   " StatementId="6" StatementCompId="1439" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_19_01 @cAux , @IN_FILIALCOR , @cFil_SBD output" StatementId="7" StatementCompId="1440" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;   SET @cAux  = 'SD8' &#x0A;   " StatementId="8" StatementCompId="1441" StatementType="ASSIGN" RetrievedFromCache="true"/><StmtSimple StatementText="EXEC XFILIAL_19_01 @cAux , @IN_FILIALCOR , @cFil_SD8 output" StatementId="9" StatementCompId="1442" StatementType="EXECUTE PROC" RetrievedFromCache="true"/><StmtSimple StatementText=" &#x0A;   SET @cAux  = 'SC... [PLANO TRUNCADO - Consulte via SSMS]

-- Procedure creation 
CREATE PROCEDURE MAT004_19_01 (
    @IN_FILIALCOR Char( 4) , 
    @IN_MV_NIVALT Char( 01 ) , 
    @IN_MV_LOCPROC Char( 2) , 
    @IN_MV_PAR1 Char( 08 ) , 
    @IN_MV_PAR09 Integer , 
    @IN_MV_PAR11 Integer , 
    @IN_MV_PAR14 Integer , 
    @IN_MV_CUSFIFO Char( 01 ) , 
    @IN_MV_RASTRO Char( 01 ) , 
    @IN_MV_LOCALIZ Char( 01 ) , 
    @IN_MV_CQ Char( 2) , 
    @IN_DINICIO Char( 08 ) , 
    @IN_TAM_TRB_DOC Integer , 
    @IN_COPCOES Char( 04 ) , 
    @IN_CUSUNIF Char( 01 ) , 
    @IN_MV_PRODPR0 Integer , 
    @IN_DDATABASE Char( 08 ) , 
    @IN_MV_NEGESTR Char( 01 ) , 
    @IN_RECNOSMO Integer , 
    @IN_MV_PAR18 Integer , 
    @IN_CPAISLOC Char( 03 ) , 
    @IN_FILSEQ Integer , 
    @IN_MV_PRODMNT Char( 15) , 
    @IN_MV_MOEDACM Char( 5 ) , 
    @IN_MV_D3SERVI Char( 01 ) , 
    @IN_INTDL Char( 01 ) , 
    @IN_MV_CUSREP Char( 01 ) , 
    @IN_MV_PAR15 Integer , 
    @IN_USAFILTRF Char( 01 ) , 
    @IN_SEQ500 Char( 01 ) , 
    @IN_MVULMES Char( 08 ) , 
    @IN_MV_WMSNEW Char( 01 ) , 
    @IN_MV_PRODMOD Char( 01 ) , 
    @IN_MV_SEQREBE Char( 03 ) , 
    @IN_MV_330JCM1 Char( 05 ) , 
    @IN_MV_PROCQE6 Char( 01 ) , 
    @IN_FILIALPROC Char( 4) , 
    @IN_SB2OUTR2 Char( 3 ) , 
    @OUT_RESULTADO Char( 01 )  output ) AS
 
-- Declaration of variables
DECLARE @cFil_AFN Char( 4)
DECLARE @cFil_SD1 Char( 4)
DECLARE @cFil_SD2 Char( 4)
DECLARE @cFil_SD3 Char( 4)
DECLARE @cFil_SF4 Char( 4)
DECLARE @cFil_SG1 Char( 4)
DECLARE @cFil_SB1 Char( 4)
DECLARE @cExecutou Char( 01 )
DECLARE @vContador Integer
DECLARE @vRecnoD1 Integer
DECLARE @vRecnoMNT Integer
DECLARE @cF4_PODER3 Char( 1)
DECLARE @cF4_ESTOQUE Char( 1)
DECLARE @cD1_COD Char( 15)
DECLARE @cD1_TIPO Char( 1)
DECLARE @cD1_OP Char( 14)
DECLARE @cD1_NUMSEQ Char( 6)
DECLARE @cD1_LOCAL Char( 2)
DECLARE @cD1_DOC Char( 9)
DECLARE @cD1_SERIE Char( 3)
DECLARE @cD1_FORNECE Char( 9)
DECLARE @cD1_LOJA Char( 4)
DECLARE @cD1_ITEM Char( 4)
DECLARE @cD1_TIPODOC Char( 2)
DECLARE @nD1_QUANT Float
DECLARE @vRecnoD2 Integ... [TRUNCADO]

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3456.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="-- Procedure creation &#x0A;CREATE PROCEDURE MAT004_19_01 (&#x0A;    @IN_FILIALCOR Char( 4) , &#x0A;    @IN_MV_NIVALT Char( 01 ) , &#x0A;    @IN_MV_LOCPROC Char( 2) , &#x0A;    @IN_MV_PAR1 Char( 08 ) , &#x0A;    @IN_MV_PAR09 Integer , &#x0A;    @IN_MV_PAR11 Integer , &#x0A;    @IN_MV_PAR14 Integer , &#x0A;    @IN_MV_CUSFIFO Char( 01 ) , &#x0A;    @IN_MV_RASTRO Char( 01 ) , &#x0A;    @IN_MV_LOCALIZ Char( 01 ) , &#x0A;    @IN_MV_CQ Char( 2) , &#x0A;    @IN_DINICIO Char( 08 ) , &#x0A;    @IN_TAM_TRB_DOC Integer , &#x0A;    @IN_COPCOES Char( 04 ) , &#x0A;    @IN_CUSUNIF Char( 01 ) , &#x0A;    @IN_MV_PRODPR0 Integer , &#x0A;    @IN_DDATABASE Char( 08 ) , &#x0A;    @IN_MV_NEGESTR Char( 01 ) , &#x0A;    @IN_RECNOSMO Integer , &#x0A;    @IN_MV_PAR18 Integer , &#x0A;    @IN_CPAISLOC Char( 03 ) , &#x0A;    @IN_FILSEQ Integer , &#x0A;    @IN_MV_PRODMNT Char( 15) , &#x0A;    @IN_MV_MOEDACM Char( 5 ) , &#x0A;    @IN_MV_D3SERVI Char( 01 ) , &#x0A;    @IN_INTDL Char( 01 ) , &#x0A;    @IN_MV_CUSREP Char( 01 ) , &#x0A;    @IN_MV_PAR15 Integer , &#x0A;    @IN_USAFILTRF Char( 01 ) , &#x0A;    @IN_SEQ500 Char( 01 ) , &#x0A;    @IN_MVULMES Char( 08 ) , &#x0A;    @IN_MV_WMSNEW Char( 01 ) , &#x0A;    @IN_MV_PRODMOD Char( 01 ) , &#x0A;    @IN_MV_SEQREBE Char( 03 ) , &#x0A;    @IN_MV_330JCM1 Char( 05 ) , &#x0A;    @IN_MV_PROCQE6 Char( 01 ) , &#x0A;    @IN_FILIALPROC Char( 4) , &#x0A;    @IN_SB2OUTR2 Char( 3 ) , &#x0A;    @OUT_RESULTADO Char( 01 )  output ) AS&#x0A; &#x0A;-- Declaration of variables&#x0A;DECLARE @cFil_AFN Char( 4)&#x0A;DECLARE @cFil_SD1 Char( 4)&#x0A;DECLARE @cFil_SD2 Char( 4)&#x0A;DECLARE @cFil_SD3 Char( 4)&#x0A;DECLARE @cFil_SF4 Char( 4)&#x0A;DECLARE @cFil_SG1 Char( 4)&#x0A;DECLARE @cFil_SB1 Char( 4)&#x0A;DECLARE @cExecutou Char( 01 )&#x0A;DECLARE @vContador Integer&#x0A;DECLARE @vRecnoD1 Integer&#x0A;DECLARE @vRecnoMNT Integer&#x0A;DECLARE @cF4_PODER3 Char( 1)&#x0A;DECLARE @cF4_ESTOQUE Char( 1)&#x0A;DECLARE @cD1_COD Char( 15)&#x0A;DECLARE @cD1_TIPO Char( 1)&#x0A;DECLARE @cD1_OP Char( 14)&#x0A;DECLARE @cD1_NUMSEQ Char( 6)&#x0A;DECLARE @cD1_LOCAL Char( 2)&#x0A;DECLARE @cD1_DOC Char( 9)&#x0A;DECLARE @cD1_SERIE Char( 3)&#x0A;DECLARE @cD1_FORNECE Char( 9)&#x0A;DECLARE @cD1_LOJA Char( 4)&#x0A;DECLARE @cD1_ITEM Char( 4)&#x0A;DECLARE @cD1_TIPODOC Char( 2)&#x0A;DECLARE @nD1_QUANT Float&#x0A;DECLARE @vRecnoD2 Integer&#x0A;DECLARE @cD2_COD Char( 15)&#x0A;DECLARE @cD2_LOCAL Char( 2)&#x0A;DECLARE @cD2_TIPO Char( 1)&#x0A;DECLARE @cD2_TIPODOC Char( 2)&#x0A;DECLARE @vRecnoD3 Integer&#x0A;DECLARE @vRecnoD7 Integer&#x0A;DECLARE @cD3_COD Char( 15)&#x0A;DECLARE @cD3_LOCAL Char( 2)&#x0A;DECLARE @cD3_CF Char( 3)&#x0A;DECLARE @cD3_NUMSEQ Char( 6)&#x0A;DECLARE @cD3_DOC Char( 9)&#x0A;DECLARE @cD3_ESTORNO Char( 1)&#x0A;DECLARE @cD3_LOTECTL Char( 10)&#x0A;DECLARE @cD3_NUMLOTE Char( 6)&#x0A;DECLARE @cD3_PROJPMS Char( 10)&#x0A;DECLARE @cD3_OP Char( 14)&#x0A;DECLARE @cD3_IDENT Char( 6)&#x0A;DECLARE @cD3_EMISSAO Char( 8)&#x0A;DECLARE @cD3_CHAVE Char( 2)&#x0A;DECLARE @nRecTRB Integer&#x0A;DECLARE @iRecCount Integer&#x0A;DECLARE @MV_PAR14 Integer&#x0A;DECLARE @cMDia Char( 01 )&#x0A;DECLARE @cAux VarChar( 3 )&#x0A;DECLARE @cAux1 VarChar( 3 )&#x0A;DECLARE @nAux Integer&#x0A;DECLARE @nAptmPMS Integer&#x0A;DECLARE @nAptmPMSTMP Integer&#x0A;DECLARE @iTRA_RECNO Integer&#x0A;DECLARE @cTransf Char( 01 )&#x0A;DECLARE @nRecnoSD3 Integer&#x0A;DECLARE @cD3_STATUS VarChar( 2 )&#x0A;DECLARE @fim_CUR Integer&#x0A;DECLARE @cMV_PAR1 Char( 08 )&#x0A;DECLARE @cDINICIO Char( 08 )&#x0A;DECLARE @cMV_PRODMNT Char( 15)&#x0A;DECLARE @cFILIALCOR Char( 4)&#x0A;DECLARE @cMV_CQ Char( 2)&#x0A;DECLARE @cB1_CCCUSTO Char( 14)&#x0A;DECLARE @nConSD3 Char( 01 )&#x0A;DECLARE @cAtuNiv Char( 01 )&#x0A;DECLARE @cTudoOk Char( 01 )&#x0A;BEGIN&#x0A;   SET @cMV_PAR1  = @IN_MV_PAR1 &#x0A;   " StatementId="1" StatementCompId="2" StatementT... [PLANO TRUNCADO - Consulte via SSMS]

[TFCAR4_PRD].[dbo].[SE1030]

[D_E_L_E_T_], [E1_CLIENTE], [E1_LOJA]

[E1_SALDO], [E1_TIPO]

[E1_EMISSAO], [E1_FILIAL], [E1_NUM], [E1_PARCELA], [E1_PREFIXO], [E1_VENCREA]

SELECT E1_VENCREA, E1_EMISSAO, E1_NUM, E1_PREFIXO, E1_PARCELA FROM SE1030 WHERE  D_E_L_E_T_ = ' ' AND  E1_CLIENTE = '17542691' AND  E1_LOJA = '0001' AND  E1_SALDO > 0 AND  SUBSTRING( E1_FILIAL, 1, 2 ) = '01' AND  E1_TIPO NOT IN ('RA ','NCC','AB-','CF-','CS-','FB-','FC-','FE-','FM-','FP-','FU-','I2-','IM-','IN-','IR-','IS-','MN-','PI-','FC-','FE-','PR ','COF','PIS') AND  DATEADD( day,  10, CONVERT(date, E1_VENCREA) ) < CONVERT(date, '20260305' )

[TFCAR4_PRD].[dbo].[SF2010]

[D_E_L_E_T_], [F2_CHVNFE], [F2_FILIAL]

[F2_CLIENTE], [F2_DOC], [F2_LOJA], [F2_SERIE]

SELECT DISTINCT SD2.D2_CF FROM SF2010 SF2 INNER JOIN SD2010 SD2 ON SD2.D2_FILIAL = '0203' AND SD2.D2_DOC = SF2.F2_DOC AND SD2.D2_SERIE = SF2.F2_SERIE AND SD2.D2_CLIENTE = SF2.F2_CLIENTE AND SD2.D2_LOJA = SF2.F2_LOJA AND SD2.D_E_L_E_T_= ' ' WHERE  SF2.F2_FILIAL = '0203' AND SF2.F2_CHVNFE = '35251054162377000176550020000769151282513784' AND SF2.D_E_L_E_T_= ' '

[TFCAR4_PRD].[dbo].[SF2010]

[D_E_L_E_T_], [F2_CHVNFE], [F2_FILIAL]

[F2_CLIENTE], [F2_DOC], [F2_LOJA], [F2_SERIE]

SELECT DISTINCT SD2.D2_CF FROM SF2010 SF2 INNER JOIN SD2010 SD2 ON SD2.D2_FILIAL = '0203' AND SD2.D2_DOC = SF2.F2_DOC AND SD2.D2_SERIE = SF2.F2_SERIE AND SD2.D2_CLIENTE = SF2.F2_CLIENTE AND SD2.D2_LOJA = SF2.F2_LOJA AND SD2.D_E_L_E_T_= ' ' WHERE  SF2.F2_FILIAL = '0203' AND SF2.F2_CHVNFE = '35260265671463000120550020001496311356064638' AND SF2.D_E_L_E_T_= ' '

[TFCAR4_PRD].[dbo].[SE1010]

[D_E_L_E_T_], [E1_CLIENTE], [E1_LOJA]

[E1_SALDO], [E1_TIPO]

 SELECT SUM(E1_SALDO) FIELDSUM  FROM SE1010 SE1  WHERE  SE1.D_E_L_E_T_ = ''  AND E1_SALDO > 0.01  AND SE1.E1_CLIENTE = '087449848' AND SE1.E1_LOJA = '0012' AND SE1.E1_SALDO <> 0 AND SE1.E1_TIPO IN ('PA', 'NCC')

[TFCAR4_PRD].[dbo].[SA1010]

[A1_FILIAL], [A1_MSEXP]

SELECT COUNT(*) TOTREC FROM SA1010 WHERE  A1_FILIAL = '    ' AND A1_MSEXP = '        '

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000031')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000016')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000027')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000017')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT MAX(ITEM_ORDER) NLAST FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000031')  and  Z68_LIVRE  =  ('N')  )   ) TRB

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000025')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000009')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000011')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000012')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000013')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000010')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000014')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000026')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT COUNT(*) NREGS FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000015')  and  Z68_LIVRE  =  ('N')  )   ) TRB WHERE ITEM_ORDER > 1

[TFCAR4_PRD].[dbo].[Z68010]

[D_E_L_E_T_], [Z68_CODARE], [Z68_FILIAL], [Z68_LIVRE]

[Z68_CODIGO]

 SELECT MAX(ITEM_ORDER) NLAST FROM (  SELECT Z68_FILIAL,Z68_CODIGO,Z68_DTINTE,Z68_DTALTA,Z68_VETRES,Z68_VTRPAL,Z68_ORIGEM,Z68_CODPET,Z68_CODPA,Z68_LIVRE,Z68_CODARE,Z68_PERTEN,Z68_VLMAX,Z68_OBITO,Z68_REANIM,Z68_RESP,Z68_TELCON,Z68_NOMCLI,Z68_ANAMN,Z68_SINTO,Z68_MOTALT,Z68_PASSAG  , ROW_NUMBER() OVER (  ORDER BY Z68_FILIAL,Z68_CODIGO ) ITEM_ORDER FROM Z68010 Z68 WHERE  Z68.D_E_L_E_T_ = '' AND Z68.Z68_FILIAL IN ('0209') AND (  Z68_CODARE  =  ('00000015')  and  Z68_LIVRE  =  ('N')  )   ) TRB

Z61010

[Z61_ORICRM], [Z61_ORIGUF], [Z61_DTFIM], [D_E_L_E_T_]

CREATE INDEX [IX_Z61010_Z61_ORICRM_Z61_ORIGUF_Z61_DTFIM_D_E_L_E_T__5DEEF] ON [TFCAR4_PRD].[dbo].[Z61010] ([Z61_ORICRM], [Z61_ORIGUF], [Z61_DTFIM], [D_E_L_E_T_])

P13030

[P13_FILIAL], [P13_DATA], [P13_CLI], [P13_LOJA]

[D_E_L_E_T_]

CREATE INDEX [IX_P13030_P13_FILIAL_P13_DATA_P13_CLI_P13_LOJA_D_E_L_E_T__03E8B] ON [TFCAR4_PRD].[dbo].[P13030] ([P13_FILIAL], [P13_DATA], [P13_CLI], [P13_LOJA],[D_E_L_E_T_])

P13030

[D_E_L_E_T_]

[P13_DATA]

[P13_FILIAL], [P13_CODIGO], [P13_STATUS]

CREATE INDEX [IX_P13030_D_E_L_E_T__P13_DATA_12E5A] ON [TFCAR4_PRD].[dbo].[P13030] ([D_E_L_E_T_],[P13_DATA]) INCLUDE ([P13_FILIAL], [P13_CODIGO], [P13_STATUS])

SE1010

[E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [E1_CLIENTE], [E1_LOJA], [E1_FILORIG], [D_E_L_E_T_]

CREATE INDEX [IX_SE1010_E1_PREFIXO_E1_NUM_E1_PARCELA_E1_TIPO_E1_CLIENTE_E1_LOJA_E1_FILORIG_D_E_L_E_T__B9672] ON [TFCAR4_PRD].[dbo].[SE1010] ([E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [E1_CLIENTE], [E1_LOJA], [E1_FILORIG], [D_E_L_E_T_])

SE1010

[D_E_L_E_T_]

[E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [E1_CLIENTE], [E1_LOJA], [E1_FILORIG]

CREATE INDEX [IX_SE1010_D_E_L_E_T__5445D] ON [TFCAR4_PRD].[dbo].[SE1010] ([D_E_L_E_T_]) INCLUDE ([E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_TIPO], [E1_CLIENTE], [E1_LOJA], [E1_FILORIG])

SD2010

[D2_FILIAL], [D2_COD], [D2_LOCAL], [D2_REMITO], [D_E_L_E_T_]

[D2_EMISSAO], [D2_ORIGLAN], [D2_TPDCENV]

[D2_QUANT], [D2_TES], [D2_CUSTO1], [D2_CUSTO2], [D2_CUSTO3], [D2_CUSTO4], [D2_CUSTO5], [D2_QTSEGUM], [D2_CUSRP1], [D2_CUSRP2], [D2_CUSRP3], [D2_CUSRP4], [D2_CUSRP5]

CREATE INDEX [IX_SD2010_D2_FILIAL_D2_COD_D2_LOCAL_D2_REMITO_D_E_L_E_T__D2_EMISSAO_D2_ORIGLAN_D2_TPDCENV_EC285] ON [TFCAR4_PRD].[dbo].[SD2010] ([D2_FILIAL], [D2_COD], [D2_LOCAL], [D2_REMITO], [D_E_L_E_T_],[D2_EMISSAO], [D2_ORIGLAN], [D2_TPDCENV]) INCLUDE ([D2_QUANT], [D2_TES], [D2_CUSTO1], [D2_CUSTO2], [D2_CUSTO3], [D2_CUSTO4], [D2_CUSTO5], [D2_QTSEGUM], [D2_CUSRP1], [D2_CUSRP2], [D2_CUSRP3], [D2_CUSRP4], [D2_CUSRP5])

P13030

[P13_FILIAL], [D_E_L_E_T_]

[P13_DATA]

[P13_CODIGO], [P13_STATUS]

CREATE INDEX [IX_P13030_P13_FILIAL_D_E_L_E_T__P13_DATA_B2943] ON [TFCAR4_PRD].[dbo].[P13030] ([P13_FILIAL], [D_E_L_E_T_],[P13_DATA]) INCLUDE ([P13_CODIGO], [P13_STATUS])

P13030

[D_E_L_E_T_]

[P13_DATA]

[P13_FILIAL], [P13_CODIGO], [P13_STATUS], [P13_IDCLIE]

CREATE INDEX [IX_P13030_D_E_L_E_T__P13_DATA_EFD87] ON [TFCAR4_PRD].[dbo].[P13030] ([D_E_L_E_T_],[P13_DATA]) INCLUDE ([P13_FILIAL], [P13_CODIGO], [P13_STATUS], [P13_IDCLIE])

P13030

[P13_FILIAL], [D_E_L_E_T_]

[P13_CODIGO], [P13_DATA]

[P13_STATUS]

CREATE INDEX [IX_P13030_P13_FILIAL_D_E_L_E_T__P13_CODIGO_P13_DATA_A363A] ON [TFCAR4_PRD].[dbo].[P13030] ([P13_FILIAL], [D_E_L_E_T_],[P13_CODIGO], [P13_DATA]) INCLUDE ([P13_STATUS])

Z56010

[Z56_FILIAL], [Z56_STATUS], [D_E_L_E_T_]

[Z56_NUMPA]

CREATE INDEX [IX_Z56010_Z56_FILIAL_Z56_STATUS_D_E_L_E_T__6C2DA] ON [TFCAR4_PRD].[dbo].[Z56010] ([Z56_FILIAL], [Z56_STATUS], [D_E_L_E_T_]) INCLUDE ([Z56_NUMPA])

CT2010

[CT2_FILIAL], [CT2_DATA], [CT2_LOTE], [CT2_SBLOTE], [CT2_DOC], [CT2_MOEDLC], [CT2_DC], [CT2_EMPORI], [CT2_FILORI], [CT2_SEQLAN], [D_E_L_E_T_]

[CT2_HIST], [CT2_SEQHIS]

CREATE INDEX [IX_CT2010_CT2_FILIAL_CT2_DATA_CT2_LOTE_CT2_SBLOTE_CT2_DOC_CT2_MOEDLC_CT2_DC_CT2_EMPORI_CT2_FILORI_CT2_SEQLAN_D_E_L_E_T__244C0] ON [TFCAR4_PRD].[dbo].[CT2010] ([CT2_FILIAL], [CT2_DATA], [CT2_LOTE], [CT2_SBLOTE], [CT2_DOC], [CT2_MOEDLC], [CT2_DC], [CT2_EMPORI], [CT2_FILORI], [CT2_SEQLAN], [D_E_L_E_T_]) INCLUDE ([CT2_HIST], [CT2_SEQHIS])

SE1030

[E1_CLIENTE], [E1_LOJA], [D_E_L_E_T_]

[E1_TIPO], [E1_SALDO]

[E1_FILIAL], [E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_EMISSAO], [E1_VENCREA]

CREATE INDEX [IX_SE1030_E1_CLIENTE_E1_LOJA_D_E_L_E_T__E1_TIPO_E1_SALDO_2FAA2] ON [TFCAR4_PRD].[dbo].[SE1030] ([E1_CLIENTE], [E1_LOJA], [D_E_L_E_T_],[E1_TIPO], [E1_SALDO]) INCLUDE ([E1_FILIAL], [E1_PREFIXO], [E1_NUM], [E1_PARCELA], [E1_EMISSAO], [E1_VENCREA])

Z68010

[Z68_FILIAL], [Z68_CODARE], [Z68_LIVRE], [D_E_L_E_T_]

[Z68_CODIGO]

CREATE INDEX [IX_Z68010_Z68_FILIAL_Z68_CODARE_Z68_LIVRE_D_E_L_E_T__3163D] ON [TFCAR4_PRD].[dbo].[Z68010] ([Z68_FILIAL], [Z68_CODARE], [Z68_LIVRE], [D_E_L_E_T_]) INCLUDE ([Z68_CODIGO])

SB1010

[B1_FILIAL], [D_E_L_E_T_]

[B1_XCATEGO]

[B1_XDESCAT]

CREATE INDEX [IX_SB1010_B1_FILIAL_D_E_L_E_T__B1_XCATEGO_0A868] ON [TFCAR4_PRD].[dbo].[SB1010] ([B1_FILIAL], [D_E_L_E_T_],[B1_XCATEGO]) INCLUDE ([B1_XDESCAT])

FK5010

[FK5_DATA], [S_T_A_M_P_]

CREATE INDEX [IX_FK5010__FK5_DATA_S_T_A_M_P__F6819] ON [TFCAR4_PRD].[dbo].[FK5010] ([FK5_DATA], [S_T_A_M_P_])

SE1010

[S_T_A_M_P_]

[E1_BAIXA], [E1_EMIS1], [E1_SALDO]

CREATE INDEX [IX_SE1010__S_T_A_M_P__D12A6] ON [TFCAR4_PRD].[dbo].[SE1010] ([S_T_A_M_P_]) INCLUDE ([E1_BAIXA], [E1_EMIS1], [E1_SALDO])

P13030

[P13_FILIAL], [D_E_L_E_T_]

[P13_DATA]

[P13_CODIGO], [P13_STATUS], [P13_IDCLIE]

CREATE INDEX [IX_P13030_P13_FILIAL_D_E_L_E_T__P13_DATA_32F3E] ON [TFCAR4_PRD].[dbo].[P13030] ([P13_FILIAL], [D_E_L_E_T_],[P13_DATA]) INCLUDE ([P13_CODIGO], [P13_STATUS], [P13_IDCLIE])

SA1010

[A1_FILIAL], [D_E_L_E_T_]

[A1_MSBLQL]

[A1_COD], [A1_LOJA], [A1_NOME], [A1_END], [A1_TEL], [A1_CGC], [A1_RG], [A1_DTCAD], [A1_XDTALT]

CREATE INDEX [IX_SA1010_A1_FILIAL_D_E_L_E_T__A1_MSBLQL_138C2] ON [TFCAR4_PRD].[dbo].[SA1010] ([A1_FILIAL], [D_E_L_E_T_],[A1_MSBLQL]) INCLUDE ([A1_COD], [A1_LOJA], [A1_NOME], [A1_END], [A1_TEL], [A1_CGC], [A1_RG], [A1_DTCAD], [A1_XDTALT])

P13030

[P13_STATUS], [P13_DATA], [D_E_L_E_T_]

[P13_FILIAL], [P13_CODIGO]

CREATE INDEX [IX_P13030_P13_STATUS_P13_DATA_D_E_L_E_T__E839D] ON [TFCAR4_PRD].[dbo].[P13030] ([P13_STATUS], [P13_DATA], [D_E_L_E_T_]) INCLUDE ([P13_FILIAL], [P13_CODIGO])

SL1010

[L1_CLIENTE], [L1_LOJA], [L1_DOC], [D_E_L_E_T_]

[L1_XNUMPA]

CREATE INDEX [IX_SL1010_L1_CLIENTE_L1_LOJA_L1_DOC_D_E_L_E_T__L1_XNUMPA_5EAB3] ON [TFCAR4_PRD].[dbo].[SL1010] ([L1_CLIENTE], [L1_LOJA], [L1_DOC], [D_E_L_E_T_],[L1_XNUMPA])