InterpretationdatabasexbKBK1h3qYHbKGh0x0Csj9pslUzfV6ro+mHZ/WNtueeYaI/C6ANDTWtCfZRyyfNe49i7aNh90+zyKO3c+QSzp9FgjQnEBdhI6hVd8NME4yfxso2l/1bYEWJtfYD72G2qmSAT71ZsS8XiAG296tyi68UqaQndXUOR4hV5XHEhMovi4tuMawXT7WlEIe16iLkv9T6bjc5Xo93xWyGAcm1qqtPQ4U7JWZkRe0z9THE9Mqf8OI0tYWx6iekSoaVNyWEK9GjVKEhP04FyGe0AR7SlC4s0t4j/eUvZ6V/lgPXYua/gdJtOXXbYhXwo1UlNHGI/xsbZoGt5woDxFX109PjgP9N6y81Ibvr920qhgOqAIS+Y4PcCYQ==databaseremwebremwebR_RAZAO_SETORCD_CONTABIL,System.StringCD_CONTA_AUXILIAR,System.DoubleCD_LCTO_CONTABIL,System.DoubleCD_LCTO_MOVIMENTO,System.DoubleCD_LOTE,System.DoubleCD_MULTI_EMP_LANCAMENTO,System.DoubleCD_REDUZIDO,System.StringDATA,System.DateTimeDS_CONTA,System.StringDS_HISTORICO_COMPLEMENTO,System.StringDS_PROCESSO,System.StringDT_LCTO,System.StringDT_LCTO_MES_ANO,System.StringESTRUTURAL_PROCESSO,System.StringSALDO_ATUAL,System.DoubleSD_ATUALIZADO,System.DoubleVL_CREDITO,System.DoubleVL_DEBITO,System.DoubleVL_SALDO_MES,System.DoubleColuna,Coluna,System.Int32,Line150databaseR_RAZAO_SETORdatabaseP_DT_FIM,Data_x002e_To,4,0P_DT_INI,Data_x002e_From,4,0SELECT dt_lcto data ,to_char(dt_lcto, 'DD/MM/YYYY') dt_lcto ,to_char(dt_lcto, 'MM/YYYY') dt_lcto_mes_ano ,cd_lote ,cd_lcto_contabil ,cd_lcto_movimento ,geral.cd_reduzido ,cd_conta_auxiliar ,cd_contabil ,ds_conta ,cd_multi_emp_lancamento ,Nvl(dbamv.converte_moeda_valor({cdMultiEmpresa}, 'R$', To_Date(@P_DT_INI,'dd.mm.rrrr') , vl_debito, NULL, NULL), 0) vl_debito ,Nvl(dbamv.converte_moeda_valor({cdMultiEmpresa}, 'R$', To_Date(@P_DT_INI,'dd.mm.rrrr') , vl_credito, NULL, NULL), 0) vl_credito ,Nvl(dbamv.converte_moeda_valor({cdMultiEmpresa}, 'R$', To_Date(@P_DT_INI,'dd.mm.rrrr') , saldo_atual, NULL, NULL), 0) saldo_atual ,saldo_ant.vl_saldo_mes ,saldo_ant.vl_saldo_mes + saldo_atual sd_atualizado ,Decode(Concat('S', 'S'), 'SS' ,Decode(Nvl(ds_historico_padrao, ''), Nvl(ds_complemento, ''),ds_historico_padrao, ds_historico_padrao||' '||ds_complemento) ,'SN', ds_historico_padrao ,'NS', ds_complemento ) DS_HISTORICO_COMPLEMENTO ,ds_processo ,estrutural_processo FROM ( SELECT Trunc(lc.dt_lcto) dt_lcto ,lc.cd_lote ,lc.cd_lcto_contabil ,lc.cd_lcto_movimento ,lc.cd_multi_empresa cd_multi_emp_lancamento ,pe.cd_reduzido ,lc.cd_auxiliar_deb cd_conta_auxiliar ,pe.cd_contabil ,pe.ds_conta ,Sum(lc.vl_lancado) vl_debito ,Sum(0) vl_credito ,(0 + Sum(lc.vl_lancado) * Decode('D', 'D', 1, -1)) saldo_atual ,lc.ds_complemento ,hp.ds_historico_padrao ,null ds_processo ,null estrutural_processo FROM dbamv.lcto_contabil lc JOIN dbamv.plano_estr pe ON pe.cd_plano = '0001' JOIN dbamv.plano_contabil depara ON depara.cd_reduzido = lc.cd_reduzido_debito AND depara.cd_plano_estr = pe.cd_plano_estr LEFT JOIN dbamv.lote ON lc.cd_lote = lote.cd_lote LEFT JOIN dbamv.historico_padrao hp ON lc.cd_historico_padrao = hp.cd_historico_padrao WHERE /**pe.cd_reduzido = $PCD_REDUZIDO comentado**/ lc.cd_reduzido_debito IS NOT NULL AND lc.cd_multi_empresa IN ({cdMultiEmpresa}) AND lc.dt_lcto BETWEEN To_Date(@P_DT_INI,'dd.mm.rrrr') AND To_Date(@P_DT_FIM,'dd.mm.rrrr') AND NVL(lc.sn_transitoria, 'N') IN ('N', Nvl('N', 'N')) AND (lc.cd_lanc_agrup IS NULL AND 'N' = 'S' OR 'N' = 'N') /**CF_COND_PROCESSO**/ /**CF_COND_CONTA_AUXILIAR_DEB**/ /**CF_COND_ORIGEM_LOTE**/ /**CF_COND_LOTE**/ GROUP BY Trunc(lc.dt_lcto) ,lc.cd_lote ,lc.cd_lcto_contabil ,lc.cd_lcto_movimento ,lc.cd_multi_empresa ,pe.cd_reduzido ,lc.cd_auxiliar_deb ,pe.cd_contabil ,pe.ds_conta ,lc.ds_complemento ,hp.ds_historico_padrao UNION ALL SELECT Trunc(lc.dt_lcto) ,lc.cd_lote ,lc.cd_lcto_contabil ,lc.cd_lcto_movimento ,lc.cd_multi_empresa ,pe.cd_reduzido ,lc.cd_auxiliar_crd ,pe.cd_contabil ,pe.ds_conta ,Sum(0) vl_debito ,Sum(lc.vl_lancado) vl_credito ,(0 + Sum(lc.vl_lancado) * Decode('D', 'D', -1, 1)) saldo_atual ,lc.ds_complemento ,hp.ds_historico_padrao ,null ds_processo ,null estrutural_processo FROM dbamv.lcto_contabil lc JOIN dbamv.plano_estr pe ON pe.cd_plano = '0001' JOIN dbamv.plano_contabil depara ON depara.cd_reduzido = lc.cd_reduzido_credito AND depara.cd_plano_estr = pe.cd_plano_estr LEFT JOIN dbamv.lote ON lc.cd_lote = lote.cd_lote LEFT JOIN dbamv.historico_padrao hp ON lc.cd_historico_padrao = hp.cd_historico_padrao WHERE lc.cd_reduzido_credito IS NOT NULL AND lc.cd_multi_empresa IN ({cdMultiEmpresa}) AND NVL(lc.sn_transitoria, 'N') IN ('N', Nvl('N', 'N')) AND (lc.cd_lanc_agrup IS NULL AND 'N' = 'S' OR 'N' = 'N') AND lc.dt_lcto BETWEEN To_Date(@P_DT_INI,'dd.mm.rrrr') AND To_Date(@P_DT_FIM,'dd.mm.rrrr') GROUP BY Trunc(lc.dt_lcto) ,lc.cd_lote ,lc.cd_lcto_contabil ,lc.cd_lcto_movimento ,lc.cd_multi_empresa ,pe.cd_reduzido ,lc.cd_auxiliar_crd ,pe.cd_contabil ,pe.ds_conta ,lc.ds_complemento ,hp.ds_historico_padrao UNION ALL SELECT null ,null ,null ,null ,null ,pe.cd_reduzido ,null ,pe.cd_contabil ,pe.ds_conta ,null ,null ,null ,null ,null ,null ds_processo ,null estrutural_processo FROM dbamv.plano_estr pe WHERE pe.cd_plano = '0001' AND NOT EXISTS ( SELECT 'X' FROM dbamv.lcto_contabil lc ,dbamv.plano_contabil depara WHERE depara.cd_reduzido = lc.cd_reduzido_debito AND depara.cd_plano_estr = pe.cd_plano_estr AND lc.cd_reduzido_debito IS NOT NULL AND lc.cd_multi_empresa IN ({cdMultiEmpresa}) ) AND NOT EXISTS ( SELECT 'X' FROM dbamv.lcto_contabil lc ,dbamv.plano_contabil depara WHERE depara.cd_reduzido = lc.cd_reduzido_credito AND depara.cd_plano_estr = pe.cd_plano_estr AND lc.cd_reduzido_credito IS NOT NULL AND lc.cd_multi_empresa IN ({cdMultiEmpresa}) ) AND 'S' = 'S' UNION ALL SELECT Trunc(lc.dt_lcto) ,lc.cd_lote ,Min(lc.cd_lcto_contabil) cd_lcto_contabil ,Min(lc.cd_lcto_movimento) cd_lcto_movimento ,lc.cd_multi_empresa ,pe.cd_reduzido ,lc.cd_auxiliar_deb ,pe.cd_contabil ,pe.ds_conta ,Sum(lc.vl_lancado) vl_debito ,Sum(0) vl_credito ,(0 + Sum(lc.vl_lancado) * Decode('D', 'D', 1, -1)) saldo_atual ,'DEPOSITO AGRUPADO' ds_complemento ,hp.ds_historico_padrao ,null ds_processo ,null estrutural_processo FROM dbamv.lcto_contabil lc JOIN dbamv.plano_estr pe ON pe.cd_plano = '0001' JOIN dbamv.plano_contabil depara ON depara.cd_reduzido = lc.cd_reduzido_debito AND depara.cd_plano_estr = pe.cd_plano_estr LEFT JOIN dbamv.lote ON lc.cd_lote = lote.cd_lote LEFT JOIN dbamv.historico_padrao hp ON lc.cd_historico_padrao = hp.cd_historico_padrao WHERE lc.cd_reduzido_debito IS NOT NULL AND lc.cd_multi_empresa IN ({cdMultiEmpresa}) AND lc.cd_lanc_agrup IS NOT NULL AND NVL(lc.sn_transitoria, 'N') IN ('N', Nvl('N', 'N')) AND 'N' = 'S' AND lc.dt_lcto BETWEEN To_Date(@P_DT_INI,'dd.mm.rrrr') AND To_Date(@P_DT_FIM,'dd.mm.rrrr') GROUP BY Trunc(lc.dt_lcto) ,lc.cd_lote ,lc.cd_multi_empresa ,pe.cd_reduzido ,lc.cd_auxiliar_deb ,pe.cd_contabil ,pe.ds_conta ,hp.ds_historico_padrao ,lc.cd_lanc_agrup ,lc.sn_transitoria UNION ALL SELECT Trunc(lc.dt_lcto) dt_lcto ,lc.cd_lote ,Min(lc.cd_lcto_contabil) cd_lcto_contabil ,Min(lc.cd_lcto_movimento) cd_lcto_movimento ,lc.cd_multi_empresa ,pe.cd_reduzido ,lc.cd_auxiliar_crd ,pe.cd_contabil ,pe.ds_conta ,Sum(0) vl_debito ,Sum(lc.vl_lancado) vl_credito ,(0 + Sum(lc.vl_lancado) * Decode('D', 'D', -1, 1)) saldo_atual ,'DEPOSITO AGRUPADO' ds_complemento ,hp.ds_historico_padrao ,null ds_processo ,null estrutural_processo FROM dbamv.lcto_contabil lc JOIN dbamv.plano_estr pe ON pe.cd_plano = '0001' JOIN dbamv.plano_contabil depara ON depara.cd_reduzido = lc.cd_reduzido_credito AND depara.cd_plano_estr = pe.cd_plano_estr LEFT JOIN dbamv.lote ON lc.cd_lote = lote.cd_lote LEFT JOIN dbamv.historico_padrao hp ON lc.cd_historico_padrao = hp.cd_historico_padrao WHERE --pe.cd_reduzido = CD_REDUZIDO lc.cd_reduzido_credito IS NOT NULL AND lc.cd_multi_empresa IN ({cdMultiEmpresa}) AND lc.dt_lcto BETWEEN To_Date(@P_DT_INI,'dd.mm.rrrr') AND To_Date(@P_DT_FIM,'dd.mm.rrrr') AND lc.cd_lanc_agrup IS NOT NULL AND NVL(lc.sn_transitoria, 'N') IN ('N', Nvl('N', 'N')) AND 'N' = 'S' ----CF_COND_PROCESSO ----CF_COND_CONTA_AUXILIAR_CRE ----CF_COND_ORIGEM_LOTE ----CF_COND_LOTE GROUP BY Trunc(lc.dt_lcto) ,lc.cd_lote ,lc.cd_multi_empresa ,pe.cd_reduzido ,lc.cd_auxiliar_crd ,pe.cd_contabil ,pe.ds_conta ,hp.ds_historico_padrao ,lc.cd_lanc_agrup ,lc.sn_transitoria ORDER BY cd_lcto_contabil desc )geral, (SELECT cd_reduzido, vl_saldo_mes FROM ( SELECT saldo_mensal.cd_reduzido cd_reduzido ,vl_saldo_mes FROM dbamv.saldo_mensal--,LCTO_CONTABIL WHERE --saldo_mensal.cd_reduzido = LCTO_CONTABIL.cd_reduzido_credito dt_saldo_mes = Add_Months(To_Date(@P_DT_INI,'dd.mm.rrrr'),-1 ) -- AND saldo_mensal.cd_reduzido = 1147 ))saldo_ant WHERE geral.cd_reduzido = saldo_ant.cd_reduzido AND geral.cd_reduzido between {CD_REDUZIDO1} AND {CD_REDUZIDO2} ORDER BY cd_reduzido,DATa,cd_lcto_contabil TableAux_Cd_reduzidoCD_REDUZIDO,System.Int32DS_CONTA,System.String30databaseAux_Cd_reduzidodatabase SELECT cd_reduzido,cd_reduzido|| '-' ||ds_conta ds_conta FROM plano_estr WHERE cd_reduzido BETWEEN 1001 AND 1182 ORDER BY 1 Table,Data,Data_x002a_,,Stimulsoft.Report.DateTimeRange,,False,False,True,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x0020_standalone_x003d__x0022_no_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesBinding_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,v_saldo,v_saldo,,System.Double,_x0030__x002e_0,True,False,False,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x0020_standalone_x003d__x0022_no_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesBinding_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,CD_REDUZIDO1,Conta_x0020_Inicial_x002a_,,System.Int32,_x0030_,False,False,True,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x0020_standalone_x003d__x0022_no_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_ItemsInitializationType_x003e_Columns_x003c__x002f_ItemsInitializationType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_KeysColumn_x003e_Aux_Cd_reduzido_x002e_CD_REDUZIDO_x003c__x002f_KeysColumn_x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesBinding_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesColumn_x003e_Aux_Cd_reduzido_x002e_DS_CONTA_x003c__x002f_ValuesColumn_x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,CD_REDUZIDO2,Conta_x0020_Final_x002a_,,System.Int32,_x0030_,False,False,True,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x0020_standalone_x003d__x0022_no_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_ItemsInitializationType_x003e_Columns_x003c__x002f_ItemsInitializationType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_KeysColumn_x003e_Aux_Cd_reduzido_x002e_CD_REDUZIDO_x003c__x002f_KeysColumn_x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesBinding_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesColumn_x003e_Aux_Cd_reduzido_x002e_DS_CONTA_x003c__x002f_ValuesColumn_x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,cdMultiEmpresa,Empresa,,System.Int32,_x0031_,True,False,False,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x0020_standalone_x003d__x0022_no_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesBinding_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariableEngineV2FalseFalsereportId,_x0034_66None;Black;2.0;Solid;False;4.0;BlackTransparentTransparent0,0.4,27.7,2TransparentTrue0.2,1,4,0.8Arial,80,0,0,0DataR_RAZAO_SETOR_DATA{R_RAZAO_SETOR.DATA}BlackHotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,CenterTransparent9.4,1,3,0.8R_RAZAO_SETOR_x002e_Coluna,NotEqualTo,_x0031_,,Numeric,[255:0:0],Transparent,Arial_x002c_8,True,True,v_saldo_x0020__x003d__x0020__x0028_v_saldo_x0020__x002b__x0020_R_RAZAO_SETOR_x002e_VL_DEBITO_x0029__x002d_R_RAZAO_SETOR_x002e_VL_CREDITO,,NoneArial,80,0,0,0Text1{v_saldo}Black2,.300NoneR$FalseTransparent9.4,0.2,1.6,0.6Arial,80,0,0,0Text2condição 2:BlackExpressionTransparent5.6,0.2,1.6,0.6Arial,80,0,0,0Text3Condição 1:BlackExpressionTransparent5.4,1,3,0.6R_RAZAO_SETOR_x002e_Coluna,EqualTo,_x0031_,,Numeric,[255:0:0],Transparent,Arial_x002c_8,True,True,v_saldo_x0020__x003d__x0020__x0020__x0028_R_RAZAO_SETOR_x002e_VL_SALDO_MES_x0020__x002b_R_RAZAO_SETOR_x002e_VL_DEBITO_x0029__x0020__x002d__x0020_R_RAZAO_SETOR_x002e_VL_CREDITO,,NoneArial,80,0,0,0Text4{v_saldo}Black2,.300NoneR$FalseR_RAZAO_SETORNoneDataR_RAZAO_SETOR724ec900403940faa4acb671ae6e23831,1,1,1FalsePage1Landscape2129.7Arial,100[50:0:0:0]System.DllSystem.Drawing.DllSystem.Windows.Forms.DllSystem.Data.DllSystem.Xml.DllStimulsoft.Controls.DllStimulsoft.Base.DllStimulsoft.Report.Dll0Relatório10/14/2020 10:40:50 AM02/17/2020 11:32:38 AMR_RAZAO manue8974b2e0a2c741ada7a09dec99b2bd7dRelatórioCentimeters2019.2.2-SNAPSHOT from 18 Fevereiro 2019, JavaTrueCSharp