20250213@165212.1609 0b69p506rd02dj3b5aaq2na09k Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165212.1631 0b69p506rd02dj3b5aaq2na09k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5309';
20250213@165212.1681 0b69p506rd02dj3b5aaq2na09k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5309';
20250213@165212.2234 hoh9m0i322nl526pn6spt0n293 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165212.2246 hoh9m0i322nl526pn6spt0n293 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165212.2328 hoh9m0i322nl526pn6spt0n293 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5310';
20250213@165212.2408 hoh9m0i322nl526pn6spt0n293 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5310';
20250213@165212.2592 hoh9m0i322nl526pn6spt0n293 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5310';
20250213@165212.2641 hoh9m0i322nl526pn6spt0n293 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5310';
20250213@165212.2722 hoh9m0i322nl526pn6spt0n293 Query : use flama_phc
20250213@165212.2725 hoh9m0i322nl526pn6spt0n293 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165212.2790 hoh9m0i322nl526pn6spt0n293 Query : use flama_phc
20250213@165212.2798 hoh9m0i322nl526pn6spt0n293 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2632
20250213@165212.2893 hoh9m0i322nl526pn6spt0n293 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501144 
20250213@165212.3333 hoh9m0i322nl526pn6spt0n293 Query : use flama_phc
20250213@165212.3336 hoh9m0i322nl526pn6spt0n293 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165212.3367 hoh9m0i322nl526pn6spt0n293 Query : use flama_phc
20250213@165212.3370 hoh9m0i322nl526pn6spt0n293 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165212.3387 hoh9m0i322nl526pn6spt0n293 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165212.3409 hoh9m0i322nl526pn6spt0n293 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5310';
20250213@165212.3456 hoh9m0i322nl526pn6spt0n293 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5310';
20250213@165212.4034 08p4agv3usauskd08r6bi5cd3l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165212.4320 08p4agv3usauskd08r6bi5cd3l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165212.4423 08p4agv3usauskd08r6bi5cd3l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5311';
20250213@165212.4501 08p4agv3usauskd08r6bi5cd3l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5311';
20250213@165212.4573 08p4agv3usauskd08r6bi5cd3l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5311';
20250213@165212.4633 08p4agv3usauskd08r6bi5cd3l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5311';
20250213@165212.4706 08p4agv3usauskd08r6bi5cd3l Query : use flama_phc
20250213@165212.4710 08p4agv3usauskd08r6bi5cd3l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165212.4822 08p4agv3usauskd08r6bi5cd3l Query : use flama_phc
20250213@165212.4825 08p4agv3usauskd08r6bi5cd3l Query : select no, estab,szadrsdesc from szadrs where u_coddest=8923
20250213@165212.4924 08p4agv3usauskd08r6bi5cd3l Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501145 
20250213@165212.5342 08p4agv3usauskd08r6bi5cd3l Query : use flama_phc
20250213@165212.5345 08p4agv3usauskd08r6bi5cd3l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165212.5376 08p4agv3usauskd08r6bi5cd3l Query : use flama_phc
20250213@165212.5379 08p4agv3usauskd08r6bi5cd3l Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165212.6589 08p4agv3usauskd08r6bi5cd3l Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165212.6616 08p4agv3usauskd08r6bi5cd3l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5311';
20250213@165212.6668 08p4agv3usauskd08r6bi5cd3l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5311';
20250213@165212.7205 43nk8f23dopmkrf7ojg0ulfsg3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165212.7216 43nk8f23dopmkrf7ojg0ulfsg3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165212.7295 43nk8f23dopmkrf7ojg0ulfsg3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5312';
20250213@165212.7366 43nk8f23dopmkrf7ojg0ulfsg3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5312';
20250213@165212.7435 43nk8f23dopmkrf7ojg0ulfsg3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5312';
20250213@165212.7470 43nk8f23dopmkrf7ojg0ulfsg3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5312';
20250213@165212.7533 43nk8f23dopmkrf7ojg0ulfsg3 Query : use flama_phc
20250213@165212.7536 43nk8f23dopmkrf7ojg0ulfsg3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165212.7611 43nk8f23dopmkrf7ojg0ulfsg3 Query : use flama_phc
20250213@165212.7615 43nk8f23dopmkrf7ojg0ulfsg3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1498
20250213@165212.7713 43nk8f23dopmkrf7ojg0ulfsg3 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501146 
20250213@165212.8134 43nk8f23dopmkrf7ojg0ulfsg3 Query : use flama_phc
20250213@165212.8137 43nk8f23dopmkrf7ojg0ulfsg3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165212.8169 43nk8f23dopmkrf7ojg0ulfsg3 Query : use flama_phc
20250213@165212.8173 43nk8f23dopmkrf7ojg0ulfsg3 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165212.8189 43nk8f23dopmkrf7ojg0ulfsg3 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165212.8211 43nk8f23dopmkrf7ojg0ulfsg3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5312';
20250213@165212.8259 43nk8f23dopmkrf7ojg0ulfsg3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5312';
20250213@165212.8803 980mc665cg97bddu81acibgm6b Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165212.8818 980mc665cg97bddu81acibgm6b Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165212.8905 980mc665cg97bddu81acibgm6b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5313';
20250213@165212.8983 980mc665cg97bddu81acibgm6b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5313';
20250213@165212.9058 980mc665cg97bddu81acibgm6b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5313';
20250213@165212.9100 980mc665cg97bddu81acibgm6b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5313';
20250213@165212.9162 980mc665cg97bddu81acibgm6b Query : use flama_phc
20250213@165212.9166 980mc665cg97bddu81acibgm6b Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165212.9232 980mc665cg97bddu81acibgm6b Query : use flama_phc
20250213@165212.9234 980mc665cg97bddu81acibgm6b Query : select no, estab,szadrsdesc from szadrs where u_coddest=634
20250213@165212.9333 980mc665cg97bddu81acibgm6b Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501147 
20250213@165212.9761 980mc665cg97bddu81acibgm6b Query : use flama_phc
20250213@165212.9764 980mc665cg97bddu81acibgm6b Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165212.9793 980mc665cg97bddu81acibgm6b Query : use flama_phc
20250213@165212.9797 980mc665cg97bddu81acibgm6b Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165212.9814 980mc665cg97bddu81acibgm6b Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165212.9834 980mc665cg97bddu81acibgm6b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5313';
20250213@165212.9888 980mc665cg97bddu81acibgm6b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5313';
20250213@165213.4500 pm4egskepj76fdm0um9e4e2kkj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165213.4620 pm4egskepj76fdm0um9e4e2kkj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165213.5410 pm4egskepj76fdm0um9e4e2kkj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5314';
20250213@165213.6380 pm4egskepj76fdm0um9e4e2kkj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5314';
20250213@165213.7600 pm4egskepj76fdm0um9e4e2kkj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5314';
20250213@165213.8090 pm4egskepj76fdm0um9e4e2kkj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5314';
20250213@165213.8830 pm4egskepj76fdm0um9e4e2kkj Query : use flama_phc
20250213@165213.8870 pm4egskepj76fdm0um9e4e2kkj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165213.9520 pm4egskepj76fdm0um9e4e2kkj Query : use flama_phc
20250213@165213.9560 pm4egskepj76fdm0um9e4e2kkj Query : select no, estab,szadrsdesc from szadrs where u_coddest=9388
20250213@165213.1059 pm4egskepj76fdm0um9e4e2kkj Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501149 
20250213@165213.1474 pm4egskepj76fdm0um9e4e2kkj Query : use flama_phc
20250213@165213.1477 pm4egskepj76fdm0um9e4e2kkj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165213.1508 pm4egskepj76fdm0um9e4e2kkj Query : use flama_phc
20250213@165213.1511 pm4egskepj76fdm0um9e4e2kkj Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165213.1621 pm4egskepj76fdm0um9e4e2kkj Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165213.1710 pm4egskepj76fdm0um9e4e2kkj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5314';
20250213@165213.1782 pm4egskepj76fdm0um9e4e2kkj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5314';
20250213@165213.2413 3t8ns7iteemob56sact3j1jpl5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165213.2427 3t8ns7iteemob56sact3j1jpl5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165213.2532 3t8ns7iteemob56sact3j1jpl5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5315';
20250213@165213.2610 3t8ns7iteemob56sact3j1jpl5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5315';
20250213@165213.5193 3t8ns7iteemob56sact3j1jpl5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5315';
20250213@165213.5268 3t8ns7iteemob56sact3j1jpl5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5315';
20250213@165213.5340 3t8ns7iteemob56sact3j1jpl5 Query : use flama_phc
20250213@165213.5344 3t8ns7iteemob56sact3j1jpl5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165213.5424 3t8ns7iteemob56sact3j1jpl5 Query : use flama_phc
20250213@165213.5427 3t8ns7iteemob56sact3j1jpl5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=909
20250213@165213.5526 3t8ns7iteemob56sact3j1jpl5 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501150 
20250213@165213.5939 3t8ns7iteemob56sact3j1jpl5 Query : use flama_phc
20250213@165213.5942 3t8ns7iteemob56sact3j1jpl5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165213.5974 3t8ns7iteemob56sact3j1jpl5 Query : use flama_phc
20250213@165213.5977 3t8ns7iteemob56sact3j1jpl5 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165213.5995 3t8ns7iteemob56sact3j1jpl5 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165213.6019 3t8ns7iteemob56sact3j1jpl5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5315';
20250213@165213.6070 3t8ns7iteemob56sact3j1jpl5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5315';
20250213@165213.6685 l1g12822e3obvelba70eh1qf7u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165213.6696 l1g12822e3obvelba70eh1qf7u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165213.6774 l1g12822e3obvelba70eh1qf7u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5316';
20250213@165213.6847 l1g12822e3obvelba70eh1qf7u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5316';
20250213@165213.6923 l1g12822e3obvelba70eh1qf7u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5316';
20250213@165213.6964 l1g12822e3obvelba70eh1qf7u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5316';
20250213@165213.7023 l1g12822e3obvelba70eh1qf7u Query : use flama_phc
20250213@165213.7026 l1g12822e3obvelba70eh1qf7u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165213.7089 l1g12822e3obvelba70eh1qf7u Query : use flama_phc
20250213@165213.7093 l1g12822e3obvelba70eh1qf7u Query : select no, estab,szadrsdesc from szadrs where u_coddest=2374
20250213@165213.7198 l1g12822e3obvelba70eh1qf7u Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501151 
20250213@165213.7620 l1g12822e3obvelba70eh1qf7u Query : use flama_phc
20250213@165213.7623 l1g12822e3obvelba70eh1qf7u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165213.7655 l1g12822e3obvelba70eh1qf7u Query : use flama_phc
20250213@165213.7658 l1g12822e3obvelba70eh1qf7u Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165213.7674 l1g12822e3obvelba70eh1qf7u Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165213.7700 l1g12822e3obvelba70eh1qf7u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5316';
20250213@165213.7750 l1g12822e3obvelba70eh1qf7u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5316';
20250213@165213.8320 5kd408oeqi9vn2a9acv73t63ki Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@165213.8331 5kd408oeqi9vn2a9acv73t63ki Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@165213.8408 5kd408oeqi9vn2a9acv73t63ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5317';
20250213@165213.8484 5kd408oeqi9vn2a9acv73t63ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5317';
20250213@165213.8562 5kd408oeqi9vn2a9acv73t63ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5317';
20250213@165213.8602 5kd408oeqi9vn2a9acv73t63ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5317';
20250213@165213.8681 5kd408oeqi9vn2a9acv73t63ki Query : use flama_phc
20250213@165213.8684 5kd408oeqi9vn2a9acv73t63ki Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@165213.8753 5kd408oeqi9vn2a9acv73t63ki Query : use flama_phc
20250213@165213.8757 5kd408oeqi9vn2a9acv73t63ki Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20250213@165213.8851 5kd408oeqi9vn2a9acv73t63ki Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501152 
20250213@165213.9271 5kd408oeqi9vn2a9acv73t63ki Query : use flama_phc
20250213@165213.9274 5kd408oeqi9vn2a9acv73t63ki Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@165213.9306 5kd408oeqi9vn2a9acv73t63ki Query : use flama_phc
20250213@165213.9309 5kd408oeqi9vn2a9acv73t63ki Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@165213.9328 5kd408oeqi9vn2a9acv73t63ki Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@165213.9348 5kd408oeqi9vn2a9acv73t63ki Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5317';
20250213@165213.9400 5kd408oeqi9vn2a9acv73t63ki Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5317';
20250213@171911.4028 crmc22jpbh0jjvs83a7vs7504k Query : use flama_phc
20250213@171911.4032 crmc22jpbh0jjvs83a7vs7504k Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@171911.4114 crmc22jpbh0jjvs83a7vs7504k Query : use flama_phc
20250213@171911.4117 crmc22jpbh0jjvs83a7vs7504k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@173611.7914 dbil30fd847n3saqvmutmoni8h Query : use flama_phc
20250213@173611.7919 dbil30fd847n3saqvmutmoni8h Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@173611.8030 dbil30fd847n3saqvmutmoni8h Query : use flama_phc
20250213@173611.8034 dbil30fd847n3saqvmutmoni8h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@175235.3180 pc5qmb1ntfo65j84rja9qb8ud3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@175235.3203 pc5qmb1ntfo65j84rja9qb8ud3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@175235.3379 pc5qmb1ntfo65j84rja9qb8ud3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5318';
20250213@175235.3456 pc5qmb1ntfo65j84rja9qb8ud3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5318';
20250213@175235.3550 pc5qmb1ntfo65j84rja9qb8ud3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5318';
20250213@175235.3601 pc5qmb1ntfo65j84rja9qb8ud3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5318';
20250213@175235.3669 pc5qmb1ntfo65j84rja9qb8ud3 Query : use flama_phc
20250213@175235.3672 pc5qmb1ntfo65j84rja9qb8ud3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@175235.3775 pc5qmb1ntfo65j84rja9qb8ud3 Query : use flama_phc
20250213@175235.3779 pc5qmb1ntfo65j84rja9qb8ud3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=7737
20250213@175235.3830 pc5qmb1ntfo65j84rja9qb8ud3 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501153 
20250213@175235.5070 pc5qmb1ntfo65j84rja9qb8ud3 Query : use flama_phc
20250213@175235.5074 pc5qmb1ntfo65j84rja9qb8ud3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@175235.5134 pc5qmb1ntfo65j84rja9qb8ud3 Query : use flama_phc
20250213@175235.5138 pc5qmb1ntfo65j84rja9qb8ud3 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@175235.5171 pc5qmb1ntfo65j84rja9qb8ud3 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@175235.5443 pc5qmb1ntfo65j84rja9qb8ud3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5318';
20250213@175235.5535 pc5qmb1ntfo65j84rja9qb8ud3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5318';
20250213@175235.6194 5eatulbd636jkjde7p26ae7tqr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@175235.6243 5eatulbd636jkjde7p26ae7tqr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@175235.6389 5eatulbd636jkjde7p26ae7tqr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5319';
20250213@175235.6582 5eatulbd636jkjde7p26ae7tqr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5319';
20250213@175235.6757 5eatulbd636jkjde7p26ae7tqr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5319';
20250213@175235.6913 5eatulbd636jkjde7p26ae7tqr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5319';
20250213@175235.7082 5eatulbd636jkjde7p26ae7tqr Query : use flama_phc
20250213@175235.7085 5eatulbd636jkjde7p26ae7tqr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@175235.7251 5eatulbd636jkjde7p26ae7tqr Query : use flama_phc
20250213@175235.7255 5eatulbd636jkjde7p26ae7tqr Query : select no, estab,szadrsdesc from szadrs where u_coddest=233
20250213@175235.7408 5eatulbd636jkjde7p26ae7tqr Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501155 
20250213@175235.8081 5eatulbd636jkjde7p26ae7tqr Query : use flama_phc
20250213@175235.8084 5eatulbd636jkjde7p26ae7tqr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@175235.8217 5eatulbd636jkjde7p26ae7tqr Query : use flama_phc
20250213@175235.8220 5eatulbd636jkjde7p26ae7tqr Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@175235.8240 5eatulbd636jkjde7p26ae7tqr Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@175235.8297 5eatulbd636jkjde7p26ae7tqr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5319';
20250213@175235.8411 5eatulbd636jkjde7p26ae7tqr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5319';
20250213@175235.9177 ui6uu0pi939ts80c88i9rv5l8j Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@175235.9261 ui6uu0pi939ts80c88i9rv5l8j Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@175235.9439 ui6uu0pi939ts80c88i9rv5l8j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5320';
20250213@175235.9674 ui6uu0pi939ts80c88i9rv5l8j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5320';
20250213@175235.9853 ui6uu0pi939ts80c88i9rv5l8j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5320';
20250213@175236.2200 ui6uu0pi939ts80c88i9rv5l8j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5320';
20250213@175236.1850 ui6uu0pi939ts80c88i9rv5l8j Query : use flama_phc
20250213@175236.1880 ui6uu0pi939ts80c88i9rv5l8j Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@175236.6610 ui6uu0pi939ts80c88i9rv5l8j Query : use flama_phc
20250213@175236.6650 ui6uu0pi939ts80c88i9rv5l8j Query : select no, estab,szadrsdesc from szadrs where u_coddest=4537
20250213@175236.8920 ui6uu0pi939ts80c88i9rv5l8j Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501161 
20250213@175236.1689 ui6uu0pi939ts80c88i9rv5l8j Query : use flama_phc
20250213@175236.1693 ui6uu0pi939ts80c88i9rv5l8j Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@175236.1833 ui6uu0pi939ts80c88i9rv5l8j Query : use flama_phc
20250213@175236.1836 ui6uu0pi939ts80c88i9rv5l8j Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@175236.1852 ui6uu0pi939ts80c88i9rv5l8j Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@175236.1974 ui6uu0pi939ts80c88i9rv5l8j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5320';
20250213@175236.2131 ui6uu0pi939ts80c88i9rv5l8j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5320';
20250213@175236.2744 3gbek205s95br8simaaufg1utr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@175236.2755 3gbek205s95br8simaaufg1utr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@175236.2838 3gbek205s95br8simaaufg1utr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5321';
20250213@175236.2909 3gbek205s95br8simaaufg1utr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5321';
20250213@175236.2983 3gbek205s95br8simaaufg1utr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5321';
20250213@175236.3027 3gbek205s95br8simaaufg1utr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5321';
20250213@175236.3095 3gbek205s95br8simaaufg1utr Query : use flama_phc
20250213@175236.3099 3gbek205s95br8simaaufg1utr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@175236.3160 3gbek205s95br8simaaufg1utr Query : use flama_phc
20250213@175236.3164 3gbek205s95br8simaaufg1utr Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20250213@175236.3259 3gbek205s95br8simaaufg1utr Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501169 
20250213@175236.3670 3gbek205s95br8simaaufg1utr Query : use flama_phc
20250213@175236.3673 3gbek205s95br8simaaufg1utr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@175236.3707 3gbek205s95br8simaaufg1utr Query : use flama_phc
20250213@175236.3711 3gbek205s95br8simaaufg1utr Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@175236.3736 3gbek205s95br8simaaufg1utr Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@175236.3757 3gbek205s95br8simaaufg1utr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5321';
20250213@175236.3804 3gbek205s95br8simaaufg1utr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5321';
20250213@180745.4864 ta4p5kmhekn5jt21vfv8tnlqqs Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@180745.4877 ta4p5kmhekn5jt21vfv8tnlqqs Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@180745.4979 ta4p5kmhekn5jt21vfv8tnlqqs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5322';
20250213@180745.5051 ta4p5kmhekn5jt21vfv8tnlqqs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5322';
20250213@180745.5129 ta4p5kmhekn5jt21vfv8tnlqqs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5322';
20250213@180745.5169 ta4p5kmhekn5jt21vfv8tnlqqs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5322';
20250213@180745.5237 ta4p5kmhekn5jt21vfv8tnlqqs Query : use flama_phc
20250213@180745.5241 ta4p5kmhekn5jt21vfv8tnlqqs Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@180745.5309 ta4p5kmhekn5jt21vfv8tnlqqs Query : use flama_phc
20250213@180745.5312 ta4p5kmhekn5jt21vfv8tnlqqs Query : select no, estab,szadrsdesc from szadrs where u_coddest=4500
20250213@180745.5442 ta4p5kmhekn5jt21vfv8tnlqqs Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501135 
20250213@180745.5992 ta4p5kmhekn5jt21vfv8tnlqqs Query : use flama_phc
20250213@180745.5997 ta4p5kmhekn5jt21vfv8tnlqqs Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@180745.6045 ta4p5kmhekn5jt21vfv8tnlqqs Query : use flama_phc
20250213@180745.6049 ta4p5kmhekn5jt21vfv8tnlqqs Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@180745.6069 ta4p5kmhekn5jt21vfv8tnlqqs Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@180745.6101 ta4p5kmhekn5jt21vfv8tnlqqs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5322';
20250213@180745.6147 ta4p5kmhekn5jt21vfv8tnlqqs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5322';
20250213@180745.6701 9pkad1483t6pk0vsg88hrurggo Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@180745.6717 9pkad1483t6pk0vsg88hrurggo Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@180745.6796 9pkad1483t6pk0vsg88hrurggo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5323';
20250213@180745.6870 9pkad1483t6pk0vsg88hrurggo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5323';
20250213@180745.6945 9pkad1483t6pk0vsg88hrurggo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5323';
20250213@180745.6991 9pkad1483t6pk0vsg88hrurggo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5323';
20250213@180745.7073 9pkad1483t6pk0vsg88hrurggo Query : use flama_phc
20250213@180745.7079 9pkad1483t6pk0vsg88hrurggo Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@180745.7157 9pkad1483t6pk0vsg88hrurggo Query : use flama_phc
20250213@180745.7161 9pkad1483t6pk0vsg88hrurggo Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20250213@180745.7324 9pkad1483t6pk0vsg88hrurggo Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501136 
20250213@180745.7898 9pkad1483t6pk0vsg88hrurggo Query : use flama_phc
20250213@180745.7903 9pkad1483t6pk0vsg88hrurggo Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@180745.7995 9pkad1483t6pk0vsg88hrurggo Query : use flama_phc
20250213@180745.7998 9pkad1483t6pk0vsg88hrurggo Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@180745.8017 9pkad1483t6pk0vsg88hrurggo Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@180745.8111 9pkad1483t6pk0vsg88hrurggo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5323';
20250213@180745.8171 9pkad1483t6pk0vsg88hrurggo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5323';
20250213@180745.8696 e6dv4b1081i0dg2h4ptcasrl8j Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@180745.8714 e6dv4b1081i0dg2h4ptcasrl8j Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@180745.8803 e6dv4b1081i0dg2h4ptcasrl8j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5324';
20250213@180745.8877 e6dv4b1081i0dg2h4ptcasrl8j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5324';
20250213@180745.8954 e6dv4b1081i0dg2h4ptcasrl8j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5324';
20250213@180745.8994 e6dv4b1081i0dg2h4ptcasrl8j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5324';
20250213@180745.9060 e6dv4b1081i0dg2h4ptcasrl8j Query : use flama_phc
20250213@180745.9063 e6dv4b1081i0dg2h4ptcasrl8j Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@180745.9152 e6dv4b1081i0dg2h4ptcasrl8j Query : use flama_phc
20250213@180745.9156 e6dv4b1081i0dg2h4ptcasrl8j Query : select no, estab,szadrsdesc from szadrs where u_coddest=323
20250213@180745.9262 e6dv4b1081i0dg2h4ptcasrl8j Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501138 
20250213@180745.9717 e6dv4b1081i0dg2h4ptcasrl8j Query : use flama_phc
20250213@180745.9721 e6dv4b1081i0dg2h4ptcasrl8j Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@180745.9758 e6dv4b1081i0dg2h4ptcasrl8j Query : use flama_phc
20250213@180745.9761 e6dv4b1081i0dg2h4ptcasrl8j Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@180745.9781 e6dv4b1081i0dg2h4ptcasrl8j Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@180745.9807 e6dv4b1081i0dg2h4ptcasrl8j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5324';
20250213@180745.9867 e6dv4b1081i0dg2h4ptcasrl8j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5324';
20250213@180746.1352 2ra5junp2lp0d5khkbe0itiv9i Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@180746.1551 2ra5junp2lp0d5khkbe0itiv9i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@180746.1657 2ra5junp2lp0d5khkbe0itiv9i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5325';
20250213@180746.1754 2ra5junp2lp0d5khkbe0itiv9i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5325';
20250213@180746.1840 2ra5junp2lp0d5khkbe0itiv9i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5325';
20250213@180746.1893 2ra5junp2lp0d5khkbe0itiv9i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5325';
20250213@180746.1981 2ra5junp2lp0d5khkbe0itiv9i Query : use flama_phc
20250213@180746.1986 2ra5junp2lp0d5khkbe0itiv9i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@180746.2081 2ra5junp2lp0d5khkbe0itiv9i Query : use flama_phc
20250213@180746.2086 2ra5junp2lp0d5khkbe0itiv9i Query : select no, estab,szadrsdesc from szadrs where u_coddest=1453
20250213@180746.2195 2ra5junp2lp0d5khkbe0itiv9i Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501148 
20250213@180746.2646 2ra5junp2lp0d5khkbe0itiv9i Query : use flama_phc
20250213@180746.2652 2ra5junp2lp0d5khkbe0itiv9i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@180746.2704 2ra5junp2lp0d5khkbe0itiv9i Query : use flama_phc
20250213@180746.2708 2ra5junp2lp0d5khkbe0itiv9i Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@180746.2734 2ra5junp2lp0d5khkbe0itiv9i Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@180746.2759 2ra5junp2lp0d5khkbe0itiv9i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5325';
20250213@180746.2811 2ra5junp2lp0d5khkbe0itiv9i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5325';
20250213@180746.3361 s19tvk2b6n43pn6s9uhtap7sv3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250213@180746.3374 s19tvk2b6n43pn6s9uhtap7sv3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250213@180746.3470 s19tvk2b6n43pn6s9uhtap7sv3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5326';
20250213@180746.3554 s19tvk2b6n43pn6s9uhtap7sv3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5326';
20250213@180746.3635 s19tvk2b6n43pn6s9uhtap7sv3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5326';
20250213@180746.3683 s19tvk2b6n43pn6s9uhtap7sv3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5326';
20250213@180746.3758 s19tvk2b6n43pn6s9uhtap7sv3 Query : use flama_phc
20250213@180746.3761 s19tvk2b6n43pn6s9uhtap7sv3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250213@180746.3845 s19tvk2b6n43pn6s9uhtap7sv3 Query : use flama_phc
20250213@180746.3850 s19tvk2b6n43pn6s9uhtap7sv3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=908
20250213@180746.4037 s19tvk2b6n43pn6s9uhtap7sv3 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501154 
20250213@180746.4661 s19tvk2b6n43pn6s9uhtap7sv3 Query : use flama_phc
20250213@180746.4665 s19tvk2b6n43pn6s9uhtap7sv3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250213@180746.4705 s19tvk2b6n43pn6s9uhtap7sv3 Query : use flama_phc
20250213@180746.4709 s19tvk2b6n43pn6s9uhtap7sv3 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250213@180746.4731 s19tvk2b6n43pn6s9uhtap7sv3 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250213@180746.4755 s19tvk2b6n43pn6s9uhtap7sv3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5326';
20250213@180746.4821 s19tvk2b6n43pn6s9uhtap7sv3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5326';
20250213@181910.8844 b0nv5vkd9q0v21lpn8g9ddam25 Query : use flama_phc
20250213@181910.8849 b0nv5vkd9q0v21lpn8g9ddam25 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@181910.8973 b0nv5vkd9q0v21lpn8g9ddam25 Query : use flama_phc
20250213@181910.8976 b0nv5vkd9q0v21lpn8g9ddam25 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@183611.3571 n1fv8cep3m1unkdnuoabki9k1s Query : use flama_phc
20250213@183611.3576 n1fv8cep3m1unkdnuoabki9k1s Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@183611.3694 n1fv8cep3m1unkdnuoabki9k1s Query : use flama_phc
20250213@183611.3705 n1fv8cep3m1unkdnuoabki9k1s Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@191914.5112 4a70gvqctqmkjhlvu8ei1ie672 Query : use flama_phc
20250213@191914.5116 4a70gvqctqmkjhlvu8ei1ie672 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@191914.5204 4a70gvqctqmkjhlvu8ei1ie672 Query : use flama_phc
20250213@191914.5207 4a70gvqctqmkjhlvu8ei1ie672 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@193614.2344 d5hm3leejgs4j52qqdkeevfkqt Query : use flama_phc
20250213@193614.2349 d5hm3leejgs4j52qqdkeevfkqt Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@193614.2445 d5hm3leejgs4j52qqdkeevfkqt Query : use flama_phc
20250213@193614.2449 d5hm3leejgs4j52qqdkeevfkqt Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@201909.7982 r9o6lp6n8e01nc0tf90gse9q25 Query : use flama_phc
20250213@201909.7986 r9o6lp6n8e01nc0tf90gse9q25 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@201909.8102 r9o6lp6n8e01nc0tf90gse9q25 Query : use flama_phc
20250213@201909.8125 r9o6lp6n8e01nc0tf90gse9q25 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@203609.7701 2k9l1f0533hgc763le9drueb7n Query : use flama_phc
20250213@203609.7706 2k9l1f0533hgc763le9drueb7n Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@203609.7961 2k9l1f0533hgc763le9drueb7n Query : use flama_phc
20250213@203609.7965 2k9l1f0533hgc763le9drueb7n Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@211909.7056 p9h55pc6po05hloqsp30d3e427 Query : use flama_phc
20250213@211909.7060 p9h55pc6po05hloqsp30d3e427 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@211909.7158 p9h55pc6po05hloqsp30d3e427 Query : use flama_phc
20250213@211909.7163 p9h55pc6po05hloqsp30d3e427 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@213609.7357 clnl8bd2jc20bfvp1kqb69ns05 Query : use flama_phc
20250213@213609.7362 clnl8bd2jc20bfvp1kqb69ns05 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@213609.7471 clnl8bd2jc20bfvp1kqb69ns05 Query : use flama_phc
20250213@213609.7476 clnl8bd2jc20bfvp1kqb69ns05 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@221911.9697 sh61h6trhca55r5hn0eds9jgpn Query : use flama_phc
20250213@221911.9702 sh61h6trhca55r5hn0eds9jgpn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@221912.2700 sh61h6trhca55r5hn0eds9jgpn Query : use flama_phc
20250213@221912.8920 sh61h6trhca55r5hn0eds9jgpn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@223612.4000 5j4p667nl6vdn3mcb84e2pp99e Query : use flama_phc
20250213@223612.4040 5j4p667nl6vdn3mcb84e2pp99e Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@223612.5040 5j4p667nl6vdn3mcb84e2pp99e Query : use flama_phc
20250213@223612.5080 5j4p667nl6vdn3mcb84e2pp99e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@231910.4577 lhk1qfefl46oqmmn6o58ignggt Query : use flama_phc
20250213@231910.4583 lhk1qfefl46oqmmn6o58ignggt Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@231910.4702 lhk1qfefl46oqmmn6o58ignggt Query : use flama_phc
20250213@231910.4705 lhk1qfefl46oqmmn6o58ignggt Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250213@233610.2186 dolijevocqche4ogktl4gpe20h Query : use flama_phc
20250213@233610.2191 dolijevocqche4ogktl4gpe20h Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250213@233610.2287 dolijevocqche4ogktl4gpe20h Query : use flama_phc
20250213@233610.2290 dolijevocqche4ogktl4gpe20h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@071912.6663 p2fhptharm4vk0trnq59ekr425 Query : use flama_phc
20250214@071912.6667 p2fhptharm4vk0trnq59ekr425 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@071912.6804 p2fhptharm4vk0trnq59ekr425 Query : use flama_phc
20250214@071912.6807 p2fhptharm4vk0trnq59ekr425 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@073630.7087 nbagas1bhq12nn0f54m54104mk Query : use flama_phc
20250214@073630.7094 nbagas1bhq12nn0f54m54104mk Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@073630.7211 nbagas1bhq12nn0f54m54104mk Query : use flama_phc
20250214@073630.7216 nbagas1bhq12nn0f54m54104mk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@081504.8228 jv8sfrilrdmhoplsvlfm8ukk0r Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@081504.8333 jv8sfrilrdmhoplsvlfm8ukk0r Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@081505.8930 jv8sfrilrdmhoplsvlfm8ukk0r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5332';
20250214@081505.9850 jv8sfrilrdmhoplsvlfm8ukk0r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5332';
20250214@081505.1070 jv8sfrilrdmhoplsvlfm8ukk0r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5332';
20250214@081505.1119 jv8sfrilrdmhoplsvlfm8ukk0r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5332';
20250214@081505.1177 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081505.1180 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@081505.1282 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.646.00.01'
20250214@081505.1402 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2401265 and bi.ref ='324.646.00.01' and bi.lordem =30000
20250214@081505.1777 jv8sfrilrdmhoplsvlfm8ukk0r Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24110179156,673000003 ' 
20250214@081505.2167 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081505.2170 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 1 valor from ts where ts.ndos = 61
20250214@081505.2287 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081505.2298 jv8sfrilrdmhoplsvlfm8ukk0r Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20250214@081505.2845 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =61
20250214@081505.3010 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081505.3013 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 ~inactivo valor from fl where no = '202090' and estab = 00 order by inactivo desc
20250214@081505.3145 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081505.3148 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from ts where ndos = 61
20250214@081505.3232 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081505.3612 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20250214@081505.3700 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081505.3720 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20250214@081505.3750 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081505.3772 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20250214@081505.3785 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 61
20250214@081505.3940 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250214@081505.4105 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250214@081505.4126 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081505.4133 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202090' and estab=00
20250214@081505.4257 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081505.4300 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20250214@081505.4350 jv8sfrilrdmhoplsvlfm8ukk0r Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67aef4270167aefb8964',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250214@081505.4460 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081505.4489 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20250214@081505.4505 jv8sfrilrdmhoplsvlfm8ukk0r Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67aef4270167aefb8964','--','bo',7.8579586009992862241 ,1,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250214@081505.4814 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081505.5230 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20250214@081505.5295 jv8sfrilrdmhoplsvlfm8ukk0r Query : insert into bo (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67aef4270167aefb8964','guia r. fornecedor','2025-02-14',61,2500587,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250214@081510.5322 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081510.5326 jv8sfrilrdmhoplsvlfm8ukk0r Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20250214@081510.5456 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.646.00.01'
20250214@081510.5635 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081510.5653 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20250214@081510.5668 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081510.5684 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20250214@081510.5693 jv8sfrilrdmhoplsvlfm8ukk0r Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2401265300a'
20250214@081510.5790 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081510.5807 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20250214@081510.5818 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081510.5833 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20250214@081510.5848 jv8sfrilrdmhoplsvlfm8ukk0r Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67aef6218567aefb8e8e',?,?,'20250214',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20250214@081510.6546 jv8sfrilrdmhoplsvlfm8ukk0r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250214@081510.6597 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081510.6615 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 61
20250214@081510.6633 jv8sfrilrdmhoplsvlfm8ukk0r Query : insert into bi2 (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67aef6779667aefb8ea1','aut67aef4270167aefb8964',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from bo bo where bo.bostamp = 'aut67aef4270167aefb8964'
20250214@081510.6872 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250214@081510.6894 jv8sfrilrdmhoplsvlfm8ukk0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 61
20250214@081510.6918 jv8sfrilrdmhoplsvlfm8ukk0r Query : insert into bi (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,obistamp ,stipo) select 'aut67aef6779667aefb8ea1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 1428, 1428*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,14.01,14.01*200.48,14.01,14.01*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,14.01*1428,14.01*1428*200.48 ,18.288000,18.288000*200.48 ,18.288000,18.288000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,14.01,14.01*200.48,14.01*1428,14.01*1428*200.48,'cps24110179156,673000003 ',110.09,110.09*1428,110.09,110.09*1428,?,?,?,4 from bo bo where bo.bostamp = 'aut67aef4270167aefb8964'
20250214@081529.1665 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081529.1673 jv8sfrilrdmhoplsvlfm8ukk0r Query : declare @bostamp varchar(25) = 'aut67aef4270167aefb8964' ,@bistamp varchar(25) = '' update bi set tecoval = qtt * ecoval ,etecoval = qtt * eecoval ,tecoval2 = qtt * ecoval2 ,etecoval2 = qtt * eecoval2 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end -- se tiver classificação e não for normal, não calcula nada update bi set ttdeb = 0 ,ettdeb = 0 ,ttmoeda = 0 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and bi.classifc <> '' and bi.classifc <> 'normal' -- no caso normal com moeda euro if exists ( select 1 from bo cross apply ( select valor moeda from para1 where descricao = 'ge_pteoueuro' ) par where bo.bostamp = @bostamp and bo.moeda = par.moeda ) begin -- sem ecovalores update bi set ettdeb = round(bi.qtt * ((bi.edebito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttdeb = round(bi.qtt * ((bi.debito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 1 -- com ecovalores update bi set ettdeb = round(bi.qtt * ( ( bi.edebito + ( iif(p.st_econotdesc = 1, - bi.eecoval2, bi.eecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.eecoval + bi.eecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttdeb = round(bi.qtt * ( ( bi.debito + ( iif(p.st_econotdesc = 1, - bi.ecoval2, bi.ecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.ecoval + bi.ecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp left join st on bi.ref = st.ref left join taxasiva tiva on bi.tabiva = tiva.codigo cross apply ( select max(valor) st_econotdesc from ( select case when valor = 's' then 1 else 0 end valor from para1 where descricao = 'st_econotdesc' union all select 0 ) a ) p where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 0 --acrescenta os descontos em valor, caso existam: update bi set ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 2) ,ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ttmoeda = 0 from bi where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end else begin update bi set ttmoeda = round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2) ,ettdeb = case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ,edebito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end ,debito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end * 200.482 from bi inner join bo2 on bi.bostamp = bo2.bo2stamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) update bi set ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 0) ,debito = round(bi.debito - (bi.qtt * bi.valdesc), 2) ,edebito = round(bi.edebito - (bi.qtt * bi.evaldesc), 2) where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end 
20250214@081543.5517 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081543.5521 jv8sfrilrdmhoplsvlfm8ukk0r Query : select 1 valor from bo where bo.bostamp = 'aut67aef4270167aefb8964'
20250214@081543.6801 jv8sfrilrdmhoplsvlfm8ukk0r Query : declare @errno int ,@errmsg varchar(255) ,@prod bit ,@nrdec numeric(10, 0) ,@totaldeb numeric(18, 5) ,@etotaldeb numeric(19, 6) ,@total numeric(18, 5) ,@etotal numeric(19, 6) ,@custo numeric(18, 5) ,@ecusto numeric(19, 6) ,@bo_1iliq numeric(19, 6) ,@bo_2iliq numeric(19, 6) ,@base1 numeric(19, 6) ,@base2 numeric(19, 6) ,@moetotal numeric(13, 3) ,@smoe1 numeric(13, 3) ,@smoe2 numeric(13, 3) ,@smoe3 numeric(13, 3) ,@smoe4 numeric(13, 3) ,@bo11_bins numeric(18, 5) ,@bo21_bins numeric(18, 5) ,@bo31_bins numeric(18, 5) ,@bo41_bins numeric(18, 5) ,@bo51_bins numeric(18, 5) ,@bo61_bins numeric(18, 5) ,@bo71_bins numeric(18, 5) ,@bo81_bins numeric(18, 5) ,@bo91_bins numeric(18, 5) ,@bo12_bins numeric(18, 5) ,@bo22_bins numeric(18, 5) ,@bo32_bins numeric(18, 5) ,@bo42_bins numeric(18, 5) ,@bo52_bins numeric(18, 5) ,@bo62_bins numeric(18, 5) ,@bo72_bins numeric(18, 5) ,@bo82_bins numeric(18, 5) ,@bo92_bins numeric(18, 5) ,@ebo11_bins numeric(19, 6) ,@ebo21_bins numeric(19, 6) ,@ebo31_bins numeric(19, 6) ,@ebo41_bins numeric(19, 6) ,@ebo51_bins numeric(19, 6) ,@ebo61_bins numeric(19, 6) ,@ebo71_bins numeric(18, 5) ,@ebo81_bins numeric(18, 5) ,@ebo91_bins numeric(18, 5) ,@ebo12_bins numeric(19, 6) ,@ebo22_bins numeric(19, 6) ,@ebo32_bins numeric(19, 6) ,@ebo42_bins numeric(19, 6) ,@ebo52_bins numeric(19, 6) ,@ebo62_bins numeric(19, 6) ,@ebo72_bins numeric(18, 5) ,@ebo82_bins numeric(18, 5) ,@ebo92_bins numeric(18, 5) ,@bo11_iva numeric(18, 5) ,@bo21_iva numeric(18, 5) ,@bo31_iva numeric(18, 5) ,@bo41_iva numeric(18, 5) ,@bo51_iva numeric(18, 5) ,@bo61_iva numeric(18, 5) ,@bo71_iva numeric(18, 5) ,@bo81_iva numeric(18, 5) ,@bo91_iva numeric(18, 5) ,@bo12_iva numeric(18, 5) ,@bo22_iva numeric(18, 5) ,@bo32_iva numeric(18, 5) ,@bo42_iva numeric(18, 5) ,@bo52_iva numeric(18, 5) ,@bo62_iva numeric(18, 5) ,@bo72_iva numeric(18, 5) ,@bo82_iva numeric(18, 5) ,@bo92_iva numeric(18, 5) ,@ebo11_iva numeric(19, 6) ,@ebo21_iva numeric(19, 6) ,@ebo31_iva numeric(19, 6) ,@ebo41_iva numeric(19, 6) ,@ebo51_iva numeric(19, 6) ,@ebo61_iva numeric(19, 6) ,@ebo71_iva numeric(18, 5) ,@ebo81_iva numeric(18, 5) ,@ebo91_iva numeric(18, 5) ,@ebo12_iva numeric(19, 6) ,@ebo22_iva numeric(19, 6) ,@ebo32_iva numeric(19, 6) ,@ebo42_iva numeric(19, 6) ,@ebo52_iva numeric(19, 6) ,@ebo62_iva numeric(19, 6) ,@ebo72_iva numeric(18, 5) ,@ebo82_iva numeric(18, 5) ,@ebo92_iva numeric(18, 5) ,@esdeb1 numeric(19, 6) ,@esdeb2 numeric(19, 6) ,@esdeb3 numeric(19, 6) ,@esdeb4 numeric(19, 6) ,@sdeb1 numeric(18, 5) ,@sdeb2 numeric(18, 5) ,@sdeb3 numeric(18, 5) ,@sdeb4 numeric(18, 5) ,@estot1 numeric(19, 6) ,@estot2 numeric(19, 6) ,@estot3 numeric(19, 6) ,@estot4 numeric(19, 6) ,@stot1 numeric(18, 5) ,@stot2 numeric(18, 5) ,@stot3 numeric(18, 5) ,@stot4 numeric(18, 5) ,@ebo_1tvall numeric(19, 6) ,@ebo_2tvall numeric(19, 6) ,@bo_1tvall numeric(18, 5) ,@bo_2tvall numeric(18, 5) ,@ebo_totp1 numeric(19, 6) ,@ebo_totp2 numeric(19, 6) ,@bo_totp1 numeric(18, 5) ,@bo_totp2 numeric(18, 5) ,@sqtt11 numeric(13, 3) ,@sqtt21 numeric(13, 3) ,@sqtt12 numeric(13, 3) ,@sqtt22 numeric(13, 3) ,@sqtt13 numeric(13, 3) ,@sqtt23 numeric(13, 3) ,@sqtt14 numeric(13, 3) ,@sqtt24 numeric(13, 3) ,@userinis varchar (30) ,@mybostamp char(25) = 'aut67aef4270167aefb8964' declare @totaisiva table ( bostamp varchar (25), codigo numeric(1), taxa numeric (5,2), ebaseinc numeric (19,6), baseinc numeric (18,5), evalor numeric (19,6), valor numeric (18,5) ) set @prod = ( select ts.producao from bo(nolock) inner join ts(nolock) on bo.ndos = ts.ndos and bo.bostamp = @mybostamp ) set @nrdec = ( select convert(numeric(10, 0), valor) from para1(nolock) where descricao = 'de_euro' ) --set @prod = 0 --set @nrdec = 2 select @ecusto = sum(bi.epcusto * bi.qtt) ,@custo = sum(bi.pcusto * bi.qtt) ,@bo11_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo21_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo31_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo41_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo51_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo61_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo71_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo81_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo91_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo12_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo22_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo32_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo42_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo52_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo62_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo72_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo82_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo92_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo11_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo21_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo31_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo41_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo51_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo61_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo71_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo81_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo91_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo12_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo22_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo32_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo42_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo52_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo62_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo72_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo82_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo92_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo_1iliq = round(sum(bi.qtt * bi.epu), @nrdec) ,@bo_2iliq = round(sum(bi.ettdeb), @nrdec) ,@bo11_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo12_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo21_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo22_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo31_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo32_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo41_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo42_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo51_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo52_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo61_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo62_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo71_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo72_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo81_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo82_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo91_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo92_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo11_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo12_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo21_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo22_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo31_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo32_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo41_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo42_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo51_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo52_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo61_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo62_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo71_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo72_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo81_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo82_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo91_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else bi.ettdeb - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo92_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@esdeb1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) * bi.iva / 100, @nrdec) end else 0 end) ,@sdeb1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) * bi.iva / 100, @nrdec) end else 0 end) ,@smoe1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@total = @stot1 + @stot2 + @stot3 + @stot4 ,@etotal = @estot1 + @estot2 + @estot3 + @estot4 ,@totaldeb = @sdeb1 + @sdeb2 + @sdeb3 + @sdeb4 ,@etotaldeb = @esdeb1 + @esdeb2 + @esdeb3 + @esdeb4 ,@moetotal = @smoe1 + @smoe2 + @smoe3 + @smoe4 ,@ebo_1tvall = @ebo11_bins + @ebo21_bins + @ebo31_bins + @ebo41_bins + @ebo51_bins + @ebo61_bins + @ebo71_bins + @ebo81_bins + @ebo91_bins ,@ebo_2tvall = @ebo12_bins + @ebo22_bins + @ebo32_bins + @ebo42_bins + @ebo52_bins + @ebo62_bins + @ebo72_bins + @ebo82_bins + @ebo92_bins ,@bo_1tvall = @bo11_bins + @bo21_bins + @bo31_bins + @bo41_bins + @bo51_bins + @bo61_bins + @bo71_bins + @bo81_bins + @bo91_bins ,@bo_2tvall = @bo12_bins + @bo22_bins + @bo32_bins + @bo42_bins + @bo52_bins + @bo62_bins + @bo72_bins + @bo82_bins + @bo92_bins ,@ebo_totp1 = sum(case when bi.ivaincl = 0 then (bi.epu * bi.qtt) else round((bi.epu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@ebo_totp2 = sum(case when bi.ivaincl = 0 then (bi.edebito * bi.qtt) else round((bi.edebito * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@bo_totp1 = sum(case when bi.ivaincl = 0 then (bi.pu * bi.qtt) else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@bo_totp2 = sum(case when bi.ivaincl = 0 then (bi.debito * bi.qtt) else round((bi.debito * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@sqtt11 = sum(case when bi.stipo = 1 then bi.qtt else 0 end) ,@sqtt21 = sum(case when bi.stipo = 1 then bi.qtt else 0 end) ,@sqtt12 = sum(case when bi.stipo = 2 then bi.qtt else 0 end) ,@sqtt22 = sum(case when bi.stipo = 2 then bi.qtt else 0 end) ,@sqtt13 = sum(case when bi.stipo = 3 then bi.qtt else 0 end) ,@sqtt23 = sum(case when bi.stipo = 3 then bi.qtt else 0 end) ,@sqtt14 = sum(case when bi.stipo = 4 then bi.qtt else 0 end) ,@sqtt24 = sum(case when bi.stipo = 5 then bi.qtt else 0 end) from bi(nolock) where bi.bostamp = @mybostamp and bi.producao = case when @prod = 1 then 1 else bi.producao end and bi.composto = 0 and bi.qtt <> 0 update bo set bo.totaldeb = isnull(@totaldeb, 0) ,bo.total = isnull(@total, 0) ,bo.etotaldeb = isnull(@etotaldeb, 0) ,bo.moetotal = isnull(@moetotal, 0) ,bo.etotal = isnull(@etotal, 0) ,bo.ecusto = isnull(@ecusto, 0) ,bo.custo = isnull(@custo, 0) ,bo.bo11_bins = isnull(@bo11_bins, 0) ,bo.bo12_bins = isnull(@bo12_bins, 0) ,bo.bo21_bins = isnull(@bo21_bins, 0) ,bo.bo22_bins = isnull(@bo22_bins, 0) ,bo.bo31_bins = isnull(@bo31_bins, 0) ,bo.bo32_bins = isnull(@bo32_bins, 0) ,bo.bo41_bins = isnull(@bo41_bins, 0) ,bo.bo42_bins = isnull(@bo42_bins, 0) ,bo.bo51_bins = isnull(@bo51_bins, 0) ,bo.bo52_bins = isnull(@bo52_bins, 0) ,bo.bo61_bins = isnull(@bo61_bins, 0) ,bo.bo62_bins = isnull(@bo62_bins, 0) ,bo.ebo11_bins = isnull(@ebo11_bins, 0) ,bo.ebo12_bins = isnull(@ebo12_bins, 0) ,bo.ebo21_bins = isnull(@ebo21_bins, 0) ,bo.ebo22_bins = isnull(@ebo22_bins, 0) ,bo.ebo31_bins = isnull(@ebo31_bins, 0) ,bo.ebo32_bins = isnull(@ebo32_bins, 0) ,bo.ebo41_bins = isnull(@ebo41_bins, 0) ,bo.ebo42_bins = isnull(@ebo42_bins, 0) ,bo.ebo51_bins = isnull(@ebo51_bins, 0) ,bo.ebo52_bins = isnull(@ebo52_bins, 0) ,bo.ebo61_bins = isnull(@ebo61_bins, 0) ,bo.ebo62_bins = isnull(@ebo62_bins, 0) ,bo.bo11_iva = isnull(@bo11_iva, 0) ,bo.bo12_iva = isnull(@bo12_iva, 0) ,bo.bo21_iva = isnull(@bo21_iva, 0) ,bo.bo22_iva = isnull(@bo22_iva, 0) ,bo.bo31_iva = isnull(@bo31_iva, 0) ,bo.bo32_iva = isnull(@bo32_iva, 0) ,bo.bo41_iva = isnull(@bo41_iva, 0) ,bo.bo42_iva = isnull(@bo42_iva, 0) ,bo.bo51_iva = isnull(@bo51_iva, 0) ,bo.bo52_iva = isnull(@bo52_iva, 0) ,bo.bo61_iva = isnull(@bo61_iva, 0) ,bo.bo62_iva = isnull(@bo62_iva, 0) ,bo.ebo11_iva = isnull(@ebo11_iva, 0) ,bo.ebo12_iva = isnull(@ebo12_iva, 0) ,bo.ebo21_iva = isnull(@ebo21_iva, 0) ,bo.ebo22_iva = isnull(@ebo22_iva, 0) ,bo.ebo31_iva = isnull(@ebo31_iva, 0) ,bo.ebo32_iva = isnull(@ebo32_iva, 0) ,bo.ebo41_iva = isnull(@ebo41_iva, 0) ,bo.ebo42_iva = isnull(@ebo42_iva, 0) ,bo.ebo51_iva = isnull(@ebo51_iva, 0) ,bo.ebo52_iva = isnull(@ebo52_iva, 0) ,bo.ebo61_iva = isnull(@ebo61_iva, 0) ,bo.ebo62_iva = isnull(@ebo62_iva, 0) ,bo.esdeb1 = isnull(@esdeb1, 0) ,bo.esdeb2 = isnull(@esdeb2, 0) ,bo.esdeb3 = isnull(@esdeb3, 0) ,bo.esdeb4 = isnull(@esdeb4, 0) ,bo.sdeb1 = isnull(@sdeb1, 0) ,bo.sdeb2 = isnull(@sdeb2, 0) ,bo.sdeb3 = isnull(@sdeb3, 0) ,bo.sdeb4 = isnull(@sdeb4, 0) ,bo.smoe1 = isnull(@smoe1, 0) ,bo.smoe2 = isnull(@smoe2, 0) ,bo.smoe3 = isnull(@smoe3, 0) ,bo.smoe4 = isnull(@smoe4, 0) ,bo.estot1 = isnull(@estot1, 0) ,bo.estot2 = isnull(@estot2, 0) ,bo.estot3 = isnull(@estot3, 0) ,bo.estot4 = isnull(@estot4, 0) ,bo.stot1 = isnull(@stot1, 0) ,bo.stot2 = isnull(@stot2, 0) ,bo.stot3 = isnull(@stot3, 0) ,bo.stot4 = isnull(@stot4, 0) ,bo.ebo_1tvall = isnull(@ebo_1tvall, 0) ,bo.ebo_2tvall = isnull(@ebo_2tvall, 0) ,bo.bo_1tvall = isnull(@bo_1tvall, 0) ,bo.bo_2tvall = isnull(@bo_2tvall, 0) ,bo.ebo_totp1 = isnull(@ebo_totp1, 0) ,bo.ebo_totp2 = isnull(@ebo_totp2, 0) ,bo.bo_totp1 = isnull(@bo_totp1, 0) ,bo.bo_totp2 = isnull(@bo_totp2, 0) ,bo.sqtt11 = isnull(@sqtt11, 0) ,bo.sqtt21 = isnull(@sqtt21, 0) ,bo.sqtt12 = isnull(@sqtt12, 0) ,bo.sqtt22 = isnull(@sqtt22, 0) ,bo.sqtt13 = isnull(@sqtt13, 0) ,bo.sqtt23 = isnull(@sqtt23, 0) ,bo.sqtt14 = isnull(@sqtt14, 0) ,bo.sqtt24 = isnull(@sqtt24, 0) where bostamp = @mybostamp update bo2 set bo2.bo71_bins = isnull(@bo71_bins, 0) ,bo2.bo72_bins = isnull(@bo72_bins, 0) ,bo2.bo81_bins = isnull(@bo81_bins, 0) ,bo2.bo82_bins = isnull(@bo82_bins, 0) ,bo2.bo91_bins = isnull(@bo91_bins, 0) ,bo2.bo92_bins = isnull(@bo92_bins, 0) ,bo2.ebo71_bins = isnull(@ebo71_bins, 0) ,bo2.ebo72_bins = isnull(@ebo72_bins, 0) ,bo2.ebo81_bins = isnull(@ebo81_bins, 0) ,bo2.ebo82_bins = isnull(@ebo82_bins, 0) ,bo2.ebo91_bins = isnull(@ebo91_bins, 0) ,bo2.ebo92_bins = isnull(@ebo92_bins, 0) ,bo2.bo71_iva = isnull(@bo71_iva, 0) ,bo2.bo72_iva = isnull(@bo72_iva, 0) ,bo2.bo81_iva = isnull(@bo81_iva, 0) ,bo2.bo82_iva = isnull(@bo82_iva, 0) ,bo2.bo91_iva = isnull(@bo91_iva, 0) ,bo2.bo92_iva = isnull(@bo92_iva, 0) ,bo2.ebo71_iva = isnull(@ebo71_iva, 0) ,bo2.ebo72_iva = isnull(@ebo72_iva, 0) ,bo2.ebo81_iva = isnull(@ebo81_iva, 0) ,bo2.ebo82_iva = isnull(@ebo82_iva, 0) ,bo2.ebo91_iva = isnull(@ebo91_iva, 0) ,bo2.ebo92_iva = isnull(@ebo92_iva, 0) ,bo2.etotalciva = isnull(@etotaldeb, 0) + isnull(@ebo12_iva, 0) +isnull(@ebo22_iva, 0) +isnull(@ebo32_iva, 0) +isnull(@ebo42_iva, 0) +isnull(@ebo52_iva, 0) +isnull(@ebo62_iva, 0) +isnull(@ebo72_iva, 0) +isnull(@ebo82_iva, 0) +isnull(@ebo92_iva, 0) --,bo2.mtotalciva =isnull(@moetotal, 0) where bo2stamp = @mybostamp -- trata os bot select @userinis = usrinis from bo where bo.bostamp=@mybostamp insert into @totaisiva ( bostamp, codigo, taxa, ebaseinc, baseinc, evalor, valor ) select @mybostamp,codigo,taxa ,case when (@ebo11_bins <>0) then @ebo11_bins else @ebo12_bins end ,case when (@ebo11_bins <>0) then @bo11_bins else @bo12_bins end ,case when (@ebo11_bins <>0) then @ebo11_iva else @ebo12_iva end ,case when (@ebo11_bins <>0) then @bo11_iva else @bo12_iva end from taxasiva where codigo = 1 union all select @mybostamp,codigo,taxa ,case when (@ebo21_bins <>0) then @ebo21_bins else @ebo22_bins end ,case when (@ebo21_bins <>0) then @bo21_bins else @bo22_bins end ,case when (@ebo21_bins <>0) then @ebo21_iva else @ebo22_iva end ,case when (@ebo21_bins <>0) then @bo21_iva else @bo22_iva end from taxasiva where codigo = 2 union all select @mybostamp,codigo,taxa ,case when (@ebo31_bins <>0) then @ebo31_bins else @ebo32_bins end ,case when (@ebo31_bins <>0) then @bo31_bins else @bo32_bins end ,case when (@ebo31_bins <>0) then @ebo31_iva else @ebo32_iva end ,case when (@ebo31_bins <>0) then @bo31_iva else @bo32_iva end from taxasiva where codigo = 3 union all select @mybostamp,codigo,taxa ,case when (@ebo41_bins <>0) then @ebo41_bins else @ebo42_bins end ,case when (@ebo41_bins <>0) then @bo41_bins else @bo42_bins end ,case when (@ebo41_bins <>0) then @ebo41_iva else @ebo42_iva end ,case when (@ebo41_bins <>0) then @bo41_iva else @bo42_iva end from taxasiva where codigo = 4 union all select @mybostamp,codigo,taxa ,case when (@ebo51_bins <>0) then @ebo51_bins else @ebo52_bins end ,case when (@ebo51_bins <>0) then @bo51_bins else @bo52_bins end ,case when (@ebo51_bins <>0) then @ebo51_iva else @ebo52_iva end ,case when (@ebo51_bins <>0) then @bo51_iva else @bo52_iva end from taxasiva where codigo = 5 union all select @mybostamp,codigo,taxa ,case when (@ebo61_bins <>0) then @ebo61_bins else @ebo62_bins end ,case when (@ebo61_bins <>0) then @bo61_bins else @bo62_bins end ,case when (@ebo61_bins <>0) then @ebo61_iva else @ebo62_iva end ,case when (@ebo61_bins <>0) then @bo61_iva else @bo62_iva end from taxasiva where codigo = 6 union all select @mybostamp,codigo,taxa ,case when (@ebo71_bins <>0) then @ebo71_bins else @ebo72_bins end ,case when (@ebo71_bins <>0) then @bo71_bins else @bo72_bins end ,case when (@ebo71_bins <>0) then @ebo71_iva else @ebo72_iva end ,case when (@ebo71_bins <>0) then @bo71_iva else @bo72_iva end from taxasiva where codigo = 7 union all select @mybostamp,codigo,taxa ,case when (@ebo81_bins <>0) then @ebo81_bins else @ebo82_bins end ,case when (@ebo81_bins <>0) then @bo81_bins else @bo82_bins end ,case when (@ebo81_bins <>0) then @ebo81_iva else @ebo82_iva end ,case when (@ebo81_bins <>0) then @bo81_iva else @bo82_iva end from taxasiva where codigo = 8 union all select @mybostamp,codigo,taxa ,case when (@ebo91_bins <>0) then @ebo91_bins else @ebo92_bins end ,case when (@ebo91_bins <>0) then @bo91_bins else @bo92_bins end ,case when (@ebo91_bins <>0) then @ebo91_iva else @ebo92_iva end ,case when (@ebo91_bins <>0) then @bo91_iva else @bo92_iva end from taxasiva where codigo = 9 update bot set ebaseinc = totiva.ebaseinc, baseinc = totiva.baseinc, evalor = totiva.evalor, valor = totiva.valor, usrinis = @userinis, usrdata = convert (date,getdate()), usrhora = convert (time,getdate()) from @totaisiva totiva inner join bot on totiva.bostamp = bot.bostamp and totiva.codigo = bot.codigo insert into bot ( botstamp ,bostamp ,codigo ,taxa ,ebaseinc ,baseinc ,evalor ,valor ,ousrinis ,ousrdata ,ousrhora ,usrinis ,usrdata ,usrhora ) select ( left(@userinis,3) + 'tt' + left(newid(),5) + right(newid(),5) + left(newid(),5) + right(newid(),5)) stamp ,@mybostamp stampbo ,totiva.codigo ,totiva.taxa ,totiva.ebaseinc ,totiva.baseinc ,totiva.evalor ,totiva.valor ,@userinis ,convert (date,getdate()) ,convert (time,getdate()) ,@userinis ,convert (date,getdate()) ,convert (time,getdate()) from @totaisiva totiva left join bot on totiva.bostamp = bot.bostamp and totiva.codigo = bot.codigo where bot.botstamp is null -- atualiza os campo bi.series e bi.series2, caso tenha equipamentos update bi set series = s1, series2=s2 from bi inner join ( select distinct bistamp,ser.s1, ser.s2 from boma cross apply (select stuff ( ( select ',' + rtrim(serie) from boma myboma where myboma.bistamp = boma.bistamp order by serie for xml path('') ), 1, 1, '' ) s1 , stuff ( ( select ',' + rtrim(serie2) from boma myboma where myboma.bistamp = boma.bistamp order by serie for xml path('') ), 1, 1, '' ) s2 ) ser where boma.bostamp = @mybostamp ) myboma on bi.bistamp = myboma.bistamp where bi.bostamp = @mybostamp 
20250214@081546.6290 jv8sfrilrdmhoplsvlfm8ukk0r Query : use flama_phc
20250214@081546.6330 jv8sfrilrdmhoplsvlfm8ukk0r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@081546.7130 jv8sfrilrdmhoplsvlfm8ukk0r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5332';
20250214@081546.7640 jv8sfrilrdmhoplsvlfm8ukk0r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5332';
20250214@081910.2717 fag5cbm8l2565br5c89h067e3h Query : use flama_phc
20250214@081910.2786 fag5cbm8l2565br5c89h067e3h Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@081910.2896 fag5cbm8l2565br5c89h067e3h Query : use flama_phc
20250214@081910.2899 fag5cbm8l2565br5c89h067e3h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@083610.6390 kem62t0dkaturjqapqo8so6hsv Query : use flama_phc
20250214@083610.6395 kem62t0dkaturjqapqo8so6hsv Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@083610.6486 kem62t0dkaturjqapqo8so6hsv Query : use flama_phc
20250214@083610.6491 kem62t0dkaturjqapqo8so6hsv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@091909.6601 j6li8lqs5b3nc62f0e8dijbj04 Query : use flama_phc
20250214@091909.6608 j6li8lqs5b3nc62f0e8dijbj04 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@091909.6828 j6li8lqs5b3nc62f0e8dijbj04 Query : use flama_phc
20250214@091909.6831 j6li8lqs5b3nc62f0e8dijbj04 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@093609.6465 94m8corufcebe6u4kav5fq6a3q Query : use flama_phc
20250214@093609.6469 94m8corufcebe6u4kav5fq6a3q Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@093609.6567 94m8corufcebe6u4kav5fq6a3q Query : use flama_phc
20250214@093609.6570 94m8corufcebe6u4kav5fq6a3q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@101911.9383 vbi4n33p9bkgnfnd1rikf0ul7n Query : use flama_phc
20250214@101911.9387 vbi4n33p9bkgnfnd1rikf0ul7n Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@101911.9483 vbi4n33p9bkgnfnd1rikf0ul7n Query : use flama_phc
20250214@101911.9486 vbi4n33p9bkgnfnd1rikf0ul7n Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@103612.2051 jkgbspb6c586jnnrq5o3i0sj0j Query : use flama_phc
20250214@103612.2055 jkgbspb6c586jnnrq5o3i0sj0j Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@103612.2170 jkgbspb6c586jnnrq5o3i0sj0j Query : use flama_phc
20250214@103612.2173 jkgbspb6c586jnnrq5o3i0sj0j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@110746.4411 524tg3dc2307a20nc9tmmt6th3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@110746.4441 524tg3dc2307a20nc9tmmt6th3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@110746.4770 524tg3dc2307a20nc9tmmt6th3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5333';
20250214@110746.4856 524tg3dc2307a20nc9tmmt6th3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5333';
20250214@110746.4939 524tg3dc2307a20nc9tmmt6th3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5333';
20250214@110746.4979 524tg3dc2307a20nc9tmmt6th3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5333';
20250214@110746.5087 524tg3dc2307a20nc9tmmt6th3 Query : use flama_phc
20250214@110746.5091 524tg3dc2307a20nc9tmmt6th3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@110746.5432 524tg3dc2307a20nc9tmmt6th3 Query : use flama_phc
20250214@110746.5437 524tg3dc2307a20nc9tmmt6th3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250214@110746.5707 524tg3dc2307a20nc9tmmt6th3 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2025 and bo.obrano = 2502593 
20250214@110746.6211 524tg3dc2307a20nc9tmmt6th3 Query : use flama_phc
20250214@110746.6215 524tg3dc2307a20nc9tmmt6th3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250214@110746.6306 524tg3dc2307a20nc9tmmt6th3 Query : use flama_phc
20250214@110746.6309 524tg3dc2307a20nc9tmmt6th3 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250214@110746.6373 524tg3dc2307a20nc9tmmt6th3 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250214@110746.6418 524tg3dc2307a20nc9tmmt6th3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5333';
20250214@110746.6464 524tg3dc2307a20nc9tmmt6th3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5333';
20250214@111910.2383 3tu4488b2ddo8s414lre5mk404 Query : use flama_phc
20250214@111910.2387 3tu4488b2ddo8s414lre5mk404 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@111910.2491 3tu4488b2ddo8s414lre5mk404 Query : use flama_phc
20250214@111910.2495 3tu4488b2ddo8s414lre5mk404 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@113610.1570 krpiv9amb514pk1jlq908mvki7 Query : use flama_phc
20250214@113610.1620 krpiv9amb514pk1jlq908mvki7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@113610.2650 krpiv9amb514pk1jlq908mvki7 Query : use flama_phc
20250214@113610.2680 krpiv9amb514pk1jlq908mvki7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@121910.7810 4bca8poqvqra80dfqcih15j27o Query : use flama_phc
20250214@121910.7850 4bca8poqvqra80dfqcih15j27o Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@121910.8890 4bca8poqvqra80dfqcih15j27o Query : use flama_phc
20250214@121910.8930 4bca8poqvqra80dfqcih15j27o Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@123609.7432 v6huah521avtih4ofuldditbd5 Query : use flama_phc
20250214@123609.7437 v6huah521avtih4ofuldditbd5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@123609.7524 v6huah521avtih4ofuldditbd5 Query : use flama_phc
20250214@123609.7527 v6huah521avtih4ofuldditbd5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@131913.6968 ldcvi68i65pe5cgltoj0d7vuh9 Query : use flama_phc
20250214@131913.6972 ldcvi68i65pe5cgltoj0d7vuh9 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@131913.7066 ldcvi68i65pe5cgltoj0d7vuh9 Query : use flama_phc
20250214@131913.7069 ldcvi68i65pe5cgltoj0d7vuh9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@133613.8512 4ev9i7nc4dadvf11gtoe08oqnj Query : use flama_phc
20250214@133613.8516 4ev9i7nc4dadvf11gtoe08oqnj Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@133613.8599 4ev9i7nc4dadvf11gtoe08oqnj Query : use flama_phc
20250214@133613.8602 4ev9i7nc4dadvf11gtoe08oqnj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@135444.1540 9tm6vldr6iujge9n2maf9rkut5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@135444.1730 9tm6vldr6iujge9n2maf9rkut5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@135444.4610 9tm6vldr6iujge9n2maf9rkut5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5334';
20250214@135444.5500 9tm6vldr6iujge9n2maf9rkut5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5334';
20250214@135444.6280 9tm6vldr6iujge9n2maf9rkut5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5334';
20250214@135444.6680 9tm6vldr6iujge9n2maf9rkut5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5334';
20250214@135444.7240 9tm6vldr6iujge9n2maf9rkut5 Query : use flama_phc
20250214@135444.7280 9tm6vldr6iujge9n2maf9rkut5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@135444.8160 9tm6vldr6iujge9n2maf9rkut5 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1817.00.1'
20250214@135444.9450 9tm6vldr6iujge9n2maf9rkut5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =gt2 and bo.boano =2002 and bo.obrano = 25/1030 and bi.ref ='324.1817.00.1' and bi.lordem =1
20250214@135444.1069 9tm6vldr6iujge9n2maf9rkut5 Query : use flama_phc
20250214@135444.1072 9tm6vldr6iujge9n2maf9rkut5 Query : select top 1 1 valor from ts where ts.ndos = 61
20250214@135444.1174 9tm6vldr6iujge9n2maf9rkut5 Query : use flama_phc
20250214@135444.1178 9tm6vldr6iujge9n2maf9rkut5 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20250214@135444.1252 9tm6vldr6iujge9n2maf9rkut5 Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =61
20250214@135444.1555 9tm6vldr6iujge9n2maf9rkut5 Query : use flama_phc
20250214@135444.1558 9tm6vldr6iujge9n2maf9rkut5 Query : select top 1 ~inactivo valor from fl where no = '1626' and estab = 26 order by inactivo desc
20250214@135444.1722 9tm6vldr6iujge9n2maf9rkut5 Query : use flama_phc
20250214@135444.1725 9tm6vldr6iujge9n2maf9rkut5 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20250214@135444.1829 9tm6vldr6iujge9n2maf9rkut5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5334';
20250214@135444.1873 9tm6vldr6iujge9n2maf9rkut5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5334';
20250214@141910.9800 9p104har14rroluubdogoc3ces Query : use flama_phc
20250214@141910.9840 9p104har14rroluubdogoc3ces Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@141910.1082 9p104har14rroluubdogoc3ces Query : use flama_phc
20250214@141910.1086 9p104har14rroluubdogoc3ces Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@143610.1423 m11546r9rm163vomp79s67dklh Query : use flama_phc
20250214@143610.1428 m11546r9rm163vomp79s67dklh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@143610.1574 m11546r9rm163vomp79s67dklh Query : use flama_phc
20250214@143610.1578 m11546r9rm163vomp79s67dklh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@151911.8949 gh4tcc7sf4u91lsmqiqu7g25vm Query : use flama_phc
20250214@151911.8954 gh4tcc7sf4u91lsmqiqu7g25vm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@151911.9050 gh4tcc7sf4u91lsmqiqu7g25vm Query : use flama_phc
20250214@151911.9053 gh4tcc7sf4u91lsmqiqu7g25vm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@153611.8547 t7econsq8h85kc8sdu7r81dc1n Query : use flama_phc
20250214@153611.8552 t7econsq8h85kc8sdu7r81dc1n Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250214@153611.8906 t7econsq8h85kc8sdu7r81dc1n Query : use flama_phc
20250214@153611.8909 t7econsq8h85kc8sdu7r81dc1n Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250214@160048.2474 6tfl1j4tlqc93l0nf5uk0vmsga Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@160048.2600 6tfl1j4tlqc93l0nf5uk0vmsga Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@160048.3680 6tfl1j4tlqc93l0nf5uk0vmsga Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5335';
20250214@160048.4071 6tfl1j4tlqc93l0nf5uk0vmsga Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5335';
20250214@160048.4434 6tfl1j4tlqc93l0nf5uk0vmsga Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5335';
20250214@160048.4752 6tfl1j4tlqc93l0nf5uk0vmsga Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5335';
20250214@160048.5239 6tfl1j4tlqc93l0nf5uk0vmsga Query : use flama_phc
20250214@160048.5282 6tfl1j4tlqc93l0nf5uk0vmsga Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@160048.5950 6tfl1j4tlqc93l0nf5uk0vmsga Query : use flama_phc
20250214@160048.5990 6tfl1j4tlqc93l0nf5uk0vmsga Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20250214@160048.6525 6tfl1j4tlqc93l0nf5uk0vmsga Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501172 
20250214@160048.7570 6tfl1j4tlqc93l0nf5uk0vmsga Query : use flama_phc
20250214@160048.7612 6tfl1j4tlqc93l0nf5uk0vmsga Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250214@160048.8035 6tfl1j4tlqc93l0nf5uk0vmsga Query : use flama_phc
20250214@160048.8077 6tfl1j4tlqc93l0nf5uk0vmsga Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250214@160048.8409 6tfl1j4tlqc93l0nf5uk0vmsga Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250214@160048.8715 6tfl1j4tlqc93l0nf5uk0vmsga Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5335';
20250214@160048.9033 6tfl1j4tlqc93l0nf5uk0vmsga Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5335';
20250214@160049.5030 tr45bbbh2d4rtafdum2ttl01c6 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@160049.5870 tr45bbbh2d4rtafdum2ttl01c6 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@160049.1160 tr45bbbh2d4rtafdum2ttl01c6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5336';
20250214@160049.1536 tr45bbbh2d4rtafdum2ttl01c6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5336';
20250214@160049.1877 tr45bbbh2d4rtafdum2ttl01c6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5336';
20250214@160049.2339 tr45bbbh2d4rtafdum2ttl01c6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5336';
20250214@160049.2698 tr45bbbh2d4rtafdum2ttl01c6 Query : use flama_phc
20250214@160049.2741 tr45bbbh2d4rtafdum2ttl01c6 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@160049.3592 tr45bbbh2d4rtafdum2ttl01c6 Query : use flama_phc
20250214@160049.3688 tr45bbbh2d4rtafdum2ttl01c6 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20250214@160049.4287 tr45bbbh2d4rtafdum2ttl01c6 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501173 
20250214@160049.6057 tr45bbbh2d4rtafdum2ttl01c6 Query : use flama_phc
20250214@160049.6099 tr45bbbh2d4rtafdum2ttl01c6 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250214@160049.6463 tr45bbbh2d4rtafdum2ttl01c6 Query : use flama_phc
20250214@160049.6505 tr45bbbh2d4rtafdum2ttl01c6 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250214@160049.6833 tr45bbbh2d4rtafdum2ttl01c6 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250214@160049.7049 tr45bbbh2d4rtafdum2ttl01c6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5336';
20250214@160049.7422 tr45bbbh2d4rtafdum2ttl01c6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5336';
20250214@160049.8890 t124ql3r3tc38vcsek2tfqas44 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@160049.8973 t124ql3r3tc38vcsek2tfqas44 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@160049.9465 t124ql3r3tc38vcsek2tfqas44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5337';
20250214@160049.9854 t124ql3r3tc38vcsek2tfqas44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5337';
20250214@160050.2170 t124ql3r3tc38vcsek2tfqas44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5337';
20250214@160050.5340 t124ql3r3tc38vcsek2tfqas44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5337';
20250214@160050.9810 t124ql3r3tc38vcsek2tfqas44 Query : use flama_phc
20250214@160050.1024 t124ql3r3tc38vcsek2tfqas44 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@160050.1831 t124ql3r3tc38vcsek2tfqas44 Query : use flama_phc
20250214@160050.1875 t124ql3r3tc38vcsek2tfqas44 Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20250214@160050.2477 t124ql3r3tc38vcsek2tfqas44 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501174 
20250214@160050.3521 t124ql3r3tc38vcsek2tfqas44 Query : use flama_phc
20250214@160050.3564 t124ql3r3tc38vcsek2tfqas44 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250214@160050.3953 t124ql3r3tc38vcsek2tfqas44 Query : use flama_phc
20250214@160050.3997 t124ql3r3tc38vcsek2tfqas44 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250214@160050.4207 t124ql3r3tc38vcsek2tfqas44 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250214@160050.4421 t124ql3r3tc38vcsek2tfqas44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5337';
20250214@160050.4899 t124ql3r3tc38vcsek2tfqas44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5337';
20250214@160050.6801 k44fei4cabhjtjd8vtdludvs93 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@160050.7036 k44fei4cabhjtjd8vtdludvs93 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@160050.7750 k44fei4cabhjtjd8vtdludvs93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5338';
20250214@160050.8481 k44fei4cabhjtjd8vtdludvs93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5338';
20250214@160050.9091 k44fei4cabhjtjd8vtdludvs93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5338';
20250214@160050.9799 k44fei4cabhjtjd8vtdludvs93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5338';
20250214@160051.2530 k44fei4cabhjtjd8vtdludvs93 Query : use flama_phc
20250214@160051.2990 k44fei4cabhjtjd8vtdludvs93 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@160051.1277 k44fei4cabhjtjd8vtdludvs93 Query : use flama_phc
20250214@160051.1361 k44fei4cabhjtjd8vtdludvs93 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250214@160051.1973 k44fei4cabhjtjd8vtdludvs93 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501175 
20250214@160051.3277 k44fei4cabhjtjd8vtdludvs93 Query : use flama_phc
20250214@160051.3331 k44fei4cabhjtjd8vtdludvs93 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250214@160051.3912 k44fei4cabhjtjd8vtdludvs93 Query : use flama_phc
20250214@160051.3954 k44fei4cabhjtjd8vtdludvs93 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250214@160051.4350 k44fei4cabhjtjd8vtdludvs93 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250214@160051.4546 k44fei4cabhjtjd8vtdludvs93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5338';
20250214@160051.5040 k44fei4cabhjtjd8vtdludvs93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5338';
20250214@160051.6844 qealuos53n3g9l9h0lk78nrt87 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@160051.6869 qealuos53n3g9l9h0lk78nrt87 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@160051.7025 qealuos53n3g9l9h0lk78nrt87 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5339';
20250214@160051.7122 qealuos53n3g9l9h0lk78nrt87 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5339';
20250214@160051.7198 qealuos53n3g9l9h0lk78nrt87 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5339';
20250214@160051.7269 qealuos53n3g9l9h0lk78nrt87 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5339';
20250214@160051.7345 qealuos53n3g9l9h0lk78nrt87 Query : use flama_phc
20250214@160051.7349 qealuos53n3g9l9h0lk78nrt87 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@160051.7469 qealuos53n3g9l9h0lk78nrt87 Query : use flama_phc
20250214@160051.7473 qealuos53n3g9l9h0lk78nrt87 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20250214@160051.7566 qealuos53n3g9l9h0lk78nrt87 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501176 
20250214@160051.7934 qealuos53n3g9l9h0lk78nrt87 Query : use flama_phc
20250214@160051.7982 qealuos53n3g9l9h0lk78nrt87 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250214@160051.8043 qealuos53n3g9l9h0lk78nrt87 Query : use flama_phc
20250214@160051.8046 qealuos53n3g9l9h0lk78nrt87 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250214@160051.8062 qealuos53n3g9l9h0lk78nrt87 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250214@160051.8083 qealuos53n3g9l9h0lk78nrt87 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5339';
20250214@160051.8199 qealuos53n3g9l9h0lk78nrt87 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5339';
20250214@160051.9687 8ls8t774jpg3irsnn7gk26qhfr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@160051.9810 8ls8t774jpg3irsnn7gk26qhfr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@160052.4270 8ls8t774jpg3irsnn7gk26qhfr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5340';
20250214@160052.3393 8ls8t774jpg3irsnn7gk26qhfr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5340';
20250214@160052.3907 8ls8t774jpg3irsnn7gk26qhfr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5340';
20250214@160052.4339 8ls8t774jpg3irsnn7gk26qhfr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5340';
20250214@160052.4988 8ls8t774jpg3irsnn7gk26qhfr Query : use flama_phc
20250214@160052.5030 8ls8t774jpg3irsnn7gk26qhfr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250214@160052.5749 8ls8t774jpg3irsnn7gk26qhfr Query : use flama_phc
20250214@160052.5790 8ls8t774jpg3irsnn7gk26qhfr Query : select no, estab,szadrsdesc from szadrs where u_coddest=4804
20250214@160052.6334 8ls8t774jpg3irsnn7gk26qhfr Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2011 and bo.obrano = 2501178 
20250214@160052.7520 8ls8t774jpg3irsnn7gk26qhfr Query : use flama_phc
20250214@160052.7562 8ls8t774jpg3irsnn7gk26qhfr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250214@160052.8131 8ls8t774jpg3irsnn7gk26qhfr Query : use flama_phc
20250214@160052.8174 8ls8t774jpg3irsnn7gk26qhfr Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250214@160052.8528 8ls8t774jpg3irsnn7gk26qhfr Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250214@160052.8709 8ls8t774jpg3irsnn7gk26qhfr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5340';
20250214@160052.9144 8ls8t774jpg3irsnn7gk26qhfr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5340';
20250214@160052.9898 54i2812ldee2lkgisa2bf3ef4l Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250214@160052.9908 54i2812ldee2lkgisa2bf3ef4l Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250214@160053.1800 54i2812ldee2lkgisa2bf3ef4l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5341';
20250214@160053.2110 54i2812ldee2lkgisa2bf3ef4l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5341';
20250214@160053.3110 54i2812ldee2lkgisa2bf3ef4l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5341';
20250214@160053.3560 54i2812ldee2lkgisa2bf3ef4l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5341';
20250214@160053.4220 54i2812ldee2lkgisa2bf3ef4l Query : use flama_phc
20250214@160053.4270 54i2812ldee2lkgisa2bf3ef4l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
