20250204@172711.3016 akq1e9o39vvhu7t4eeigiemdr2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5130';
20250204@172711.3376 akq1e9o39vvhu7t4eeigiemdr2 Query : use flama_phc
20250204@172711.3418 akq1e9o39vvhu7t4eeigiemdr2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250204@172711.4039 akq1e9o39vvhu7t4eeigiemdr2 Query : use flama_phc
20250204@172711.4081 akq1e9o39vvhu7t4eeigiemdr2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=171
20250204@172711.4485 akq1e9o39vvhu7t4eeigiemdr2 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 = 2009 and bo.obrano = 2500925 
20250204@172711.5611 akq1e9o39vvhu7t4eeigiemdr2 Query : use flama_phc
20250204@172711.5694 akq1e9o39vvhu7t4eeigiemdr2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250204@172711.6191 akq1e9o39vvhu7t4eeigiemdr2 Query : use flama_phc
20250204@172711.6232 akq1e9o39vvhu7t4eeigiemdr2 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250204@172711.6438 akq1e9o39vvhu7t4eeigiemdr2 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250204@172711.6644 akq1e9o39vvhu7t4eeigiemdr2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5130';
20250204@172711.6962 akq1e9o39vvhu7t4eeigiemdr2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5130';
20250204@172711.7648 kgqk4k8t25fpu5t87rdkdg775t Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250204@172711.7660 kgqk4k8t25fpu5t87rdkdg775t Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250204@172711.7737 kgqk4k8t25fpu5t87rdkdg775t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5131';
20250204@172711.7810 kgqk4k8t25fpu5t87rdkdg775t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5131';
20250204@172711.7882 kgqk4k8t25fpu5t87rdkdg775t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5131';
20250204@172711.7927 kgqk4k8t25fpu5t87rdkdg775t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5131';
20250204@172711.7993 kgqk4k8t25fpu5t87rdkdg775t Query : use flama_phc
20250204@172711.7998 kgqk4k8t25fpu5t87rdkdg775t Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250204@172711.8068 kgqk4k8t25fpu5t87rdkdg775t Query : use flama_phc
20250204@172711.8071 kgqk4k8t25fpu5t87rdkdg775t Query : select no, estab,szadrsdesc from szadrs where u_coddest=1760
20250204@172711.8128 kgqk4k8t25fpu5t87rdkdg775t 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 = 2009 and bo.obrano = 2500926 
20250204@172711.8560 kgqk4k8t25fpu5t87rdkdg775t Query : use flama_phc
20250204@172711.8565 kgqk4k8t25fpu5t87rdkdg775t Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250204@172711.8599 kgqk4k8t25fpu5t87rdkdg775t Query : use flama_phc
20250204@172711.8603 kgqk4k8t25fpu5t87rdkdg775t Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250204@172711.8621 kgqk4k8t25fpu5t87rdkdg775t Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250204@172711.8649 kgqk4k8t25fpu5t87rdkdg775t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5131';
20250204@172711.8698 kgqk4k8t25fpu5t87rdkdg775t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5131';
20250204@172711.9965 6ufnrq1535oscchavfgj2tlk8p Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250204@172712.4900 6ufnrq1535oscchavfgj2tlk8p Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250204@172712.8650 6ufnrq1535oscchavfgj2tlk8p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5132';
20250204@172712.1250 6ufnrq1535oscchavfgj2tlk8p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5132';
20250204@172712.1612 6ufnrq1535oscchavfgj2tlk8p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5132';
20250204@172712.1931 6ufnrq1535oscchavfgj2tlk8p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5132';
20250204@172712.2284 6ufnrq1535oscchavfgj2tlk8p Query : use flama_phc
20250204@172712.2326 6ufnrq1535oscchavfgj2tlk8p Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250204@172712.4110 6ufnrq1535oscchavfgj2tlk8p Query : use flama_phc
20250204@172712.4150 6ufnrq1535oscchavfgj2tlk8p Query : select no, estab,szadrsdesc from szadrs where u_coddest=8923
20250204@172712.4549 6ufnrq1535oscchavfgj2tlk8p 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 = 2009 and bo.obrano = 2500927 
20250204@172712.5566 6ufnrq1535oscchavfgj2tlk8p Query : use flama_phc
20250204@172712.5608 6ufnrq1535oscchavfgj2tlk8p Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250204@172712.5981 6ufnrq1535oscchavfgj2tlk8p Query : use flama_phc
20250204@172712.6063 6ufnrq1535oscchavfgj2tlk8p Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250204@172712.6377 6ufnrq1535oscchavfgj2tlk8p Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250204@172712.6543 6ufnrq1535oscchavfgj2tlk8p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5132';
20250204@172712.6858 6ufnrq1535oscchavfgj2tlk8p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5132';
20250204@172712.7566 t2tbtqka6406f6m4qqskipuemi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250204@172712.7578 t2tbtqka6406f6m4qqskipuemi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250204@172712.7678 t2tbtqka6406f6m4qqskipuemi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5133';
20250204@172712.7781 t2tbtqka6406f6m4qqskipuemi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5133';
20250204@172712.7870 t2tbtqka6406f6m4qqskipuemi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5133';
20250204@172712.7926 t2tbtqka6406f6m4qqskipuemi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5133';
20250204@172712.8012 t2tbtqka6406f6m4qqskipuemi Query : use flama_phc
20250204@172712.8016 t2tbtqka6406f6m4qqskipuemi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250204@172712.8085 t2tbtqka6406f6m4qqskipuemi Query : use flama_phc
20250204@172712.8089 t2tbtqka6406f6m4qqskipuemi Query : select no, estab,szadrsdesc from szadrs where u_coddest=1328
20250204@172712.8211 t2tbtqka6406f6m4qqskipuemi 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 = 2009 and bo.obrano = 2500928 
20250204@172712.8799 t2tbtqka6406f6m4qqskipuemi Query : use flama_phc
20250204@172712.8803 t2tbtqka6406f6m4qqskipuemi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250204@172712.8838 t2tbtqka6406f6m4qqskipuemi Query : use flama_phc
20250204@172712.8841 t2tbtqka6406f6m4qqskipuemi Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250204@172712.8859 t2tbtqka6406f6m4qqskipuemi Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250204@172712.8883 t2tbtqka6406f6m4qqskipuemi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5133';
20250204@172712.8928 t2tbtqka6406f6m4qqskipuemi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5133';
20250204@172712.9695 vo02rus1d7sqqi7vkcqfnhlnsi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250204@172712.9778 vo02rus1d7sqqi7vkcqfnhlnsi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250204@172713.2650 vo02rus1d7sqqi7vkcqfnhlnsi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5134';
20250204@172713.6700 vo02rus1d7sqqi7vkcqfnhlnsi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5134';
20250204@172713.1387 vo02rus1d7sqqi7vkcqfnhlnsi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5134';
20250204@172713.2081 vo02rus1d7sqqi7vkcqfnhlnsi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5134';
20250204@172713.2441 vo02rus1d7sqqi7vkcqfnhlnsi Query : use flama_phc
20250204@172713.2483 vo02rus1d7sqqi7vkcqfnhlnsi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250204@172713.3104 vo02rus1d7sqqi7vkcqfnhlnsi Query : use flama_phc
20250204@172713.3145 vo02rus1d7sqqi7vkcqfnhlnsi Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20250204@172713.3467 vo02rus1d7sqqi7vkcqfnhlnsi 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 = 2009 and bo.obrano = 2500929 
20250204@172713.5775 vo02rus1d7sqqi7vkcqfnhlnsi Query : use flama_phc
20250204@172713.5817 vo02rus1d7sqqi7vkcqfnhlnsi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250204@172713.6190 vo02rus1d7sqqi7vkcqfnhlnsi Query : use flama_phc
20250204@172713.6231 vo02rus1d7sqqi7vkcqfnhlnsi Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250204@172713.6521 vo02rus1d7sqqi7vkcqfnhlnsi Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250204@172713.6768 vo02rus1d7sqqi7vkcqfnhlnsi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5134';
20250204@172713.7084 vo02rus1d7sqqi7vkcqfnhlnsi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5134';
20250204@173610.3993 qdbo240gitn1duevdhk1c3dq7i Query : use flama_phc
20250204@173610.3997 qdbo240gitn1duevdhk1c3dq7i Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@173610.4082 qdbo240gitn1duevdhk1c3dq7i Query : use flama_phc
20250204@173610.4085 qdbo240gitn1duevdhk1c3dq7i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@181908.3200 8395erqs17r6tvqfaceq3769c1 Query : use flama_phc
20250204@181908.3204 8395erqs17r6tvqfaceq3769c1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@181908.3475 8395erqs17r6tvqfaceq3769c1 Query : use flama_phc
20250204@181908.3479 8395erqs17r6tvqfaceq3769c1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@183608.5163 ob0pp678suh03to358q7a8nn15 Query : use flama_phc
20250204@183608.5167 ob0pp678suh03to358q7a8nn15 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@183608.5253 ob0pp678suh03to358q7a8nn15 Query : use flama_phc
20250204@183608.5256 ob0pp678suh03to358q7a8nn15 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@191909.6593 5lrvmnh0jpnjacrglam9b46ddg Query : use flama_phc
20250204@191909.6597 5lrvmnh0jpnjacrglam9b46ddg Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@191909.7890 5lrvmnh0jpnjacrglam9b46ddg Query : use flama_phc
20250204@191909.7894 5lrvmnh0jpnjacrglam9b46ddg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@193609.3834 pfbtg6vsa3tvqish2uf5qgaqo5 Query : use flama_phc
20250204@193609.3838 pfbtg6vsa3tvqish2uf5qgaqo5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@193609.3940 pfbtg6vsa3tvqish2uf5qgaqo5 Query : use flama_phc
20250204@193609.3973 pfbtg6vsa3tvqish2uf5qgaqo5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@201909.7925 mne20b09j80tiuf0c03lv0931r Query : use flama_phc
20250204@201909.7929 mne20b09j80tiuf0c03lv0931r Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@201909.8014 mne20b09j80tiuf0c03lv0931r Query : use flama_phc
20250204@201909.8018 mne20b09j80tiuf0c03lv0931r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@203609.7030 e0hp1aoeujm595ofu2r41pn9kc Query : use flama_phc
20250204@203609.7035 e0hp1aoeujm595ofu2r41pn9kc Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@203609.7228 e0hp1aoeujm595ofu2r41pn9kc Query : use flama_phc
20250204@203609.7232 e0hp1aoeujm595ofu2r41pn9kc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@211909.2273 6no9j1i7ivo76776hvoat5q3ta Query : use flama_phc
20250204@211909.2279 6no9j1i7ivo76776hvoat5q3ta Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@211909.2372 6no9j1i7ivo76776hvoat5q3ta Query : use flama_phc
20250204@211909.2375 6no9j1i7ivo76776hvoat5q3ta Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@213609.5226 q1j2qu3qmjkkv9cdq4en897aa5 Query : use flama_phc
20250204@213609.5230 q1j2qu3qmjkkv9cdq4en897aa5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@213609.5325 q1j2qu3qmjkkv9cdq4en897aa5 Query : use flama_phc
20250204@213609.5329 q1j2qu3qmjkkv9cdq4en897aa5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@221908.7544 386b37aqteqd7g0u3a2rb49mt6 Query : use flama_phc
20250204@221908.7548 386b37aqteqd7g0u3a2rb49mt6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@221908.7702 386b37aqteqd7g0u3a2rb49mt6 Query : use flama_phc
20250204@221908.7706 386b37aqteqd7g0u3a2rb49mt6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@223608.6526 7e89np18nibr5hgoiqfs82ebsc Query : use flama_phc
20250204@223608.6530 7e89np18nibr5hgoiqfs82ebsc Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@223608.6628 7e89np18nibr5hgoiqfs82ebsc Query : use flama_phc
20250204@223608.6632 7e89np18nibr5hgoiqfs82ebsc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@231908.8599 2t3q25a4ggi2jtr579a815c83q Query : use flama_phc
20250204@231908.8603 2t3q25a4ggi2jtr579a815c83q Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@231909.7900 2t3q25a4ggi2jtr579a815c83q Query : use flama_phc
20250204@231909.7950 2t3q25a4ggi2jtr579a815c83q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250204@233608.5880 e39osgp11jk2pit8ouuq631581 Query : use flama_phc
20250204@233608.5885 e39osgp11jk2pit8ouuq631581 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250204@233608.6354 e39osgp11jk2pit8ouuq631581 Query : use flama_phc
20250204@233608.6360 e39osgp11jk2pit8ouuq631581 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@071908.6723 75at2n9bgcqvo4cs0lqodpo6mm Query : use flama_phc
20250205@071908.6729 75at2n9bgcqvo4cs0lqodpo6mm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@071908.6903 75at2n9bgcqvo4cs0lqodpo6mm Query : use flama_phc
20250205@071908.6906 75at2n9bgcqvo4cs0lqodpo6mm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@073659.9792 hevteo57ujt5tii7secbpk1lpk Query : use flama_phc
20250205@073659.9814 hevteo57ujt5tii7secbpk1lpk Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@073700.5300 hevteo57ujt5tii7secbpk1lpk Query : use flama_phc
20250205@073700.5600 hevteo57ujt5tii7secbpk1lpk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@081909.2120 svuu0b9hrrcii4e1lkm7d077e9 Query : use flama_phc
20250205@081909.2170 svuu0b9hrrcii4e1lkm7d077e9 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@081909.3170 svuu0b9hrrcii4e1lkm7d077e9 Query : use flama_phc
20250205@081909.3210 svuu0b9hrrcii4e1lkm7d077e9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@083608.9753 d5cov9lnsqm8b0skblro33fk6j Query : use flama_phc
20250205@083608.9770 d5cov9lnsqm8b0skblro33fk6j Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@083609.3900 d5cov9lnsqm8b0skblro33fk6j Query : use flama_phc
20250205@083609.1180 d5cov9lnsqm8b0skblro33fk6j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@091909.7024 511hfjjufh26opaei26a4t75b2 Query : use flama_phc
20250205@091909.7029 511hfjjufh26opaei26a4t75b2 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@091909.7126 511hfjjufh26opaei26a4t75b2 Query : use flama_phc
20250205@091909.7130 511hfjjufh26opaei26a4t75b2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@093609.7479 if2uhd6j4isi80ndetjtj70p9a Query : use flama_phc
20250205@093609.7485 if2uhd6j4isi80ndetjtj70p9a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@093609.7574 if2uhd6j4isi80ndetjtj70p9a Query : use flama_phc
20250205@093609.7578 if2uhd6j4isi80ndetjtj70p9a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@101910.1140 21spvdva6mp40usmmobh3h36mi Query : use flama_phc
20250205@101910.1190 21spvdva6mp40usmmobh3h36mi Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@101910.2100 21spvdva6mp40usmmobh3h36mi Query : use flama_phc
20250205@101910.2150 21spvdva6mp40usmmobh3h36mi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@103610.6144 3oivjs7ofb4fvilvqeana8svch Query : use flama_phc
20250205@103610.6149 3oivjs7ofb4fvilvqeana8svch Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@103610.6259 3oivjs7ofb4fvilvqeana8svch Query : use flama_phc
20250205@103610.6262 3oivjs7ofb4fvilvqeana8svch Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@111910.8747 kod6q98bag2dg4fh69honnoaq1 Query : use flama_phc
20250205@111910.8754 kod6q98bag2dg4fh69honnoaq1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@111910.8869 kod6q98bag2dg4fh69honnoaq1 Query : use flama_phc
20250205@111910.8874 kod6q98bag2dg4fh69honnoaq1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@113610.9539 5n4vm8epe9021r0maptkkk1ljq Query : use flama_phc
20250205@113610.9622 5n4vm8epe9021r0maptkkk1ljq Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@113611.1557 5n4vm8epe9021r0maptkkk1ljq Query : use flama_phc
20250205@113611.1640 5n4vm8epe9021r0maptkkk1ljq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@115717.9931 f8qcrg90pjtioreieefjpo8i0h Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250205@115718.7000 f8qcrg90pjtioreieefjpo8i0h Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250205@115718.1799 f8qcrg90pjtioreieefjpo8i0h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5135';
20250205@115718.2179 f8qcrg90pjtioreieefjpo8i0h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5135';
20250205@115718.2559 f8qcrg90pjtioreieefjpo8i0h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5135';
20250205@115718.2788 f8qcrg90pjtioreieefjpo8i0h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5135';
20250205@115718.3079 f8qcrg90pjtioreieefjpo8i0h Query : use flama_phc
20250205@115718.3084 f8qcrg90pjtioreieefjpo8i0h Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250205@115718.3705 f8qcrg90pjtioreieefjpo8i0h Query : use flama_phc
20250205@115718.3745 f8qcrg90pjtioreieefjpo8i0h Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250205@115718.4239 f8qcrg90pjtioreieefjpo8i0h 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 = 2009 and bo.obrano = 2500934 
20250205@115718.5345 f8qcrg90pjtioreieefjpo8i0h Query : use flama_phc
20250205@115718.5423 f8qcrg90pjtioreieefjpo8i0h Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250205@115718.5833 f8qcrg90pjtioreieefjpo8i0h Query : use flama_phc
20250205@115718.5879 f8qcrg90pjtioreieefjpo8i0h Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250205@115718.6280 f8qcrg90pjtioreieefjpo8i0h Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250205@115718.6494 f8qcrg90pjtioreieefjpo8i0h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5135';
20250205@115718.6812 f8qcrg90pjtioreieefjpo8i0h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5135';
20250205@121226.1416 vh94pucgjcquggd9g1rie6jmqk Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250205@121226.1593 vh94pucgjcquggd9g1rie6jmqk Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250205@121226.2368 vh94pucgjcquggd9g1rie6jmqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5136';
20250205@121226.2862 vh94pucgjcquggd9g1rie6jmqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5136';
20250205@121226.3219 vh94pucgjcquggd9g1rie6jmqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5136';
20250205@121226.3535 vh94pucgjcquggd9g1rie6jmqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5136';
20250205@121226.5189 vh94pucgjcquggd9g1rie6jmqk Query : use flama_phc
20250205@121226.5231 vh94pucgjcquggd9g1rie6jmqk Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250205@121226.5852 vh94pucgjcquggd9g1rie6jmqk Query : use flama_phc
20250205@121226.5893 vh94pucgjcquggd9g1rie6jmqk Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20250205@121226.6222 vh94pucgjcquggd9g1rie6jmqk 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 = 2009 and bo.obrano = 2500941 
20250205@121226.8730 vh94pucgjcquggd9g1rie6jmqk Query : use flama_phc
20250205@121226.8772 vh94pucgjcquggd9g1rie6jmqk Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250205@121226.9144 vh94pucgjcquggd9g1rie6jmqk Query : use flama_phc
20250205@121226.9184 vh94pucgjcquggd9g1rie6jmqk Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250205@121226.9392 vh94pucgjcquggd9g1rie6jmqk Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250205@121226.9725 vh94pucgjcquggd9g1rie6jmqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5136';
20250205@121227.2890 vh94pucgjcquggd9g1rie6jmqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5136';
20250205@121910.1856 h6vk6245fitmfdc2inetc9rk7o Query : use flama_phc
20250205@121910.1861 h6vk6245fitmfdc2inetc9rk7o Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@121910.1953 h6vk6245fitmfdc2inetc9rk7o Query : use flama_phc
20250205@121910.1958 h6vk6245fitmfdc2inetc9rk7o Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@123610.1494 f3odmq2ska0aef96rm8htpr2sf Query : use flama_phc
20250205@123610.1498 f3odmq2ska0aef96rm8htpr2sf Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@123610.1641 f3odmq2ska0aef96rm8htpr2sf Query : use flama_phc
20250205@123610.1645 f3odmq2ska0aef96rm8htpr2sf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@131910.2520 fruepj9lntfglcf3vt6p3ces1e Query : use flama_phc
20250205@131910.2525 fruepj9lntfglcf3vt6p3ces1e Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@131910.2628 fruepj9lntfglcf3vt6p3ces1e Query : use flama_phc
20250205@131910.2631 fruepj9lntfglcf3vt6p3ces1e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@133609.9691 su510nuekn9hfh64up55pb74cq Query : use flama_phc
20250205@133609.9695 su510nuekn9hfh64up55pb74cq Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@133609.9785 su510nuekn9hfh64up55pb74cq Query : use flama_phc
20250205@133609.9788 su510nuekn9hfh64up55pb74cq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@141910.9900 n3dd04k95gseas0t3chamj4jpm Query : use flama_phc
20250205@141910.1410 n3dd04k95gseas0t3chamj4jpm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@141910.9230 n3dd04k95gseas0t3chamj4jpm Query : use flama_phc
20250205@141910.9650 n3dd04k95gseas0t3chamj4jpm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@143609.9243 304ro63qkna44hb51cp8hr4n3v Query : use flama_phc
20250205@143609.9247 304ro63qkna44hb51cp8hr4n3v Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@143609.9339 304ro63qkna44hb51cp8hr4n3v Query : use flama_phc
20250205@143609.9343 304ro63qkna44hb51cp8hr4n3v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@144843.7139 3rdc8jge959oa60458fd9cb3mg Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250205@144843.7152 3rdc8jge959oa60458fd9cb3mg Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250205@144843.7235 3rdc8jge959oa60458fd9cb3mg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5137';
20250205@144843.7312 3rdc8jge959oa60458fd9cb3mg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5137';
20250205@144843.7385 3rdc8jge959oa60458fd9cb3mg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5137';
20250205@144843.7429 3rdc8jge959oa60458fd9cb3mg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5137';
20250205@144843.7483 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144843.7487 3rdc8jge959oa60458fd9cb3mg Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250205@144843.7568 3rdc8jge959oa60458fd9cb3mg Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.682.00.01'
20250205@144843.7708 3rdc8jge959oa60458fd9cb3mg 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 = 2400959 and bi.ref ='324.682.00.01' and bi.lordem =20000
20250205@144843.8090 3rdc8jge959oa60458fd9cb3mg 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 = 'cps24080536214,422000002 ' 
20250205@144843.8451 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144843.8454 3rdc8jge959oa60458fd9cb3mg Query : select top 1 1 valor from ts where ts.ndos = 61
20250205@144843.8563 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144843.8566 3rdc8jge959oa60458fd9cb3mg 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')
20250205@144843.8645 3rdc8jge959oa60458fd9cb3mg 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
20250205@144843.8826 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144843.8830 3rdc8jge959oa60458fd9cb3mg Query : select top 1 ~inactivo valor from fl where no = '202090' and estab = 00 order by inactivo desc
20250205@144843.8969 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144843.8973 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from ts where ndos = 61
20250205@144843.9064 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144843.9380 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20250205@144843.9451 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144843.9470 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20250205@144843.9482 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144843.9499 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20250205@144843.9510 3rdc8jge959oa60458fd9cb3mg 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
20250205@144843.9658 3rdc8jge959oa60458fd9cb3mg Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250205@144843.9766 3rdc8jge959oa60458fd9cb3mg Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250205@144843.9790 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144843.9797 3rdc8jge959oa60458fd9cb3mg Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202090' and estab=00
20250205@144843.9891 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144843.9911 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20250205@144843.9965 3rdc8jge959oa60458fd9cb3mg Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67a371160867a37a4bef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250205@144844.5800 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144844.7900 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20250205@144844.9600 3rdc8jge959oa60458fd9cb3mg Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67a371160867a37a4bef','--','bo',7.9156433529097704217 ,1,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250205@144844.2990 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144844.3200 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20250205@144844.3350 3rdc8jge959oa60458fd9cb3mg 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 ('aut67a371160867a37a4bef','guia r. fornecedor','2025-02-05',61,2500430,?,?,?,?,?,?,?,?,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')
20250205@144847.5987 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144847.5991 3rdc8jge959oa60458fd9cb3mg Query : select st.usalote valor from st where st.ref = '324.682.00.01'
20250205@144847.6128 3rdc8jge959oa60458fd9cb3mg 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.682.00.01'
20250205@144847.6275 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144847.6291 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20250205@144847.6305 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144847.6319 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20250205@144847.6328 3rdc8jge959oa60458fd9cb3mg Query : select sestamp valor from se where ref ='324.682.00.01' and lote = 'r2400959200a'
20250205@144847.6383 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144847.6400 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20250205@144847.6409 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144847.6424 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20250205@144847.6436 3rdc8jge959oa60458fd9cb3mg Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67a374250067a37a4f9c',?,?,'20250205',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20250205@144847.6971 3rdc8jge959oa60458fd9cb3mg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250205@144847.7010 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144847.7026 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 61
20250205@144847.7043 3rdc8jge959oa60458fd9cb3mg Query : insert into bi2 (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67a375575067a37a4fab','aut67a371160867a37a4bef',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 = 'aut67a371160867a37a4bef'
20250205@144847.7232 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250205@144847.7253 3rdc8jge959oa60458fd9cb3mg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 61
20250205@144847.7277 3rdc8jge959oa60458fd9cb3mg 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 'aut67a375575067a37a4fab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 1030, 1030*.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 ,18.73,18.73*200.48,18.73,18.73*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,18.73*1030,18.73*1030*200.48 ,22.761000,22.761000*200.48 ,22.761000,22.761000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,18.73,18.73*200.48,18.73*1030,18.73*1030*200.48,'cps24080536214,422000002 ',148.26,148.26*1030,148.26,148.26*1030,?,?,?,4 from bo bo where bo.bostamp = 'aut67a371160867a37a4bef'
20250205@144901.7136 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144901.7147 3rdc8jge959oa60458fd9cb3mg Query : declare @bostamp varchar(25) = 'aut67a371160867a37a4bef' ,@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 
20250205@144923.4402 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144923.4406 3rdc8jge959oa60458fd9cb3mg Query : select 1 valor from bo where bo.bostamp = 'aut67a371160867a37a4bef'
20250205@144923.4507 3rdc8jge959oa60458fd9cb3mg 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) = 'aut67a371160867a37a4bef' 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 
20250205@144924.4309 3rdc8jge959oa60458fd9cb3mg Query : use flama_phc
20250205@144924.4314 3rdc8jge959oa60458fd9cb3mg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@144924.4404 3rdc8jge959oa60458fd9cb3mg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5137';
20250205@144924.4457 3rdc8jge959oa60458fd9cb3mg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5137';
20250205@151912.9620 53ejpn8rmp1lobr6nui61h76g4 Query : use flama_phc
20250205@151912.9625 53ejpn8rmp1lobr6nui61h76g4 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@151912.9752 53ejpn8rmp1lobr6nui61h76g4 Query : use flama_phc
20250205@151912.9756 53ejpn8rmp1lobr6nui61h76g4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@153612.7640 2dcjm3f6vttshdo5vcjtptrrrj Query : use flama_phc
20250205@153612.7647 2dcjm3f6vttshdo5vcjtptrrrj Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@153612.8524 2dcjm3f6vttshdo5vcjtptrrrj Query : use flama_phc
20250205@153612.8567 2dcjm3f6vttshdo5vcjtptrrrj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@161910.9317 4p12p2jmsta8uub7fmhsq0a5mr Query : use flama_phc
20250205@161910.9322 4p12p2jmsta8uub7fmhsq0a5mr Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@161910.9417 4p12p2jmsta8uub7fmhsq0a5mr Query : use flama_phc
20250205@161910.9422 4p12p2jmsta8uub7fmhsq0a5mr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@163611.3000 m0s8ca4dk7nn3asjh9ugvf67g4 Query : use flama_phc
20250205@163611.3130 m0s8ca4dk7nn3asjh9ugvf67g4 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@163611.4070 m0s8ca4dk7nn3asjh9ugvf67g4 Query : use flama_phc
20250205@163611.4120 m0s8ca4dk7nn3asjh9ugvf67g4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@171910.9652 8jo3tpip63c7jaghhm60ciaqrh Query : use flama_phc
20250205@171910.9657 8jo3tpip63c7jaghhm60ciaqrh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@171910.9756 8jo3tpip63c7jaghhm60ciaqrh Query : use flama_phc
20250205@171910.9759 8jo3tpip63c7jaghhm60ciaqrh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@173610.4112 6qis05hrdr53eb8fdf2l04q7sn Query : use flama_phc
20250205@173610.4116 6qis05hrdr53eb8fdf2l04q7sn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@173610.4541 6qis05hrdr53eb8fdf2l04q7sn Query : use flama_phc
20250205@173610.4545 6qis05hrdr53eb8fdf2l04q7sn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@181911.1108 k6rdd7ore00kb4i2r03u1pr4j5 Query : use flama_phc
20250205@181911.1151 k6rdd7ore00kb4i2r03u1pr4j5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@181911.2091 k6rdd7ore00kb4i2r03u1pr4j5 Query : use flama_phc
20250205@181911.2137 k6rdd7ore00kb4i2r03u1pr4j5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@183610.8178 5bja81ej7a0ks6g73l1hvrg61s Query : use flama_phc
20250205@183610.8222 5bja81ej7a0ks6g73l1hvrg61s Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@183610.8977 5bja81ej7a0ks6g73l1hvrg61s Query : use flama_phc
20250205@183610.8981 5bja81ej7a0ks6g73l1hvrg61s Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@191912.4740 cak7jmmq3c325eoisuhkkg1q03 Query : use flama_phc
20250205@191912.4790 cak7jmmq3c325eoisuhkkg1q03 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@191912.5980 cak7jmmq3c325eoisuhkkg1q03 Query : use flama_phc
20250205@191912.6020 cak7jmmq3c325eoisuhkkg1q03 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@193611.9269 3lb5iig2autcs29jvd7823r7hn Query : use flama_phc
20250205@193611.9273 3lb5iig2autcs29jvd7823r7hn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@193611.9391 3lb5iig2autcs29jvd7823r7hn Query : use flama_phc
20250205@193611.9395 3lb5iig2autcs29jvd7823r7hn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@201910.9570 sta6o5oehjfud5tqhcq1f2dqn1 Query : use flama_phc
20250205@201910.9620 sta6o5oehjfud5tqhcq1f2dqn1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@201910.1055 sta6o5oehjfud5tqhcq1f2dqn1 Query : use flama_phc
20250205@201910.1060 sta6o5oehjfud5tqhcq1f2dqn1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@203609.7104 l2h8jc5cm1iqfghumpce90difh Query : use flama_phc
20250205@203609.7109 l2h8jc5cm1iqfghumpce90difh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@203609.7323 l2h8jc5cm1iqfghumpce90difh Query : use flama_phc
20250205@203609.7327 l2h8jc5cm1iqfghumpce90difh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@211909.5944 keq75pkqvlni7sg7h22pgoe6en Query : use flama_phc
20250205@211909.5949 keq75pkqvlni7sg7h22pgoe6en Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@211909.6037 keq75pkqvlni7sg7h22pgoe6en Query : use flama_phc
20250205@211909.6041 keq75pkqvlni7sg7h22pgoe6en Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@213609.8757 97elsknhjq5sviqd0sb8j29kva Query : use flama_phc
20250205@213609.8761 97elsknhjq5sviqd0sb8j29kva Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@213609.8852 97elsknhjq5sviqd0sb8j29kva Query : use flama_phc
20250205@213609.8856 97elsknhjq5sviqd0sb8j29kva Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@221911.8190 l6ct675i61khdsn0lmj9kks4of Query : use flama_phc
20250205@221911.8197 l6ct675i61khdsn0lmj9kks4of Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@221911.8330 l6ct675i61khdsn0lmj9kks4of Query : use flama_phc
20250205@221911.8335 l6ct675i61khdsn0lmj9kks4of Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@223611.7369 4fmm0t0mfuppovhsmnprnth4kh Query : use flama_phc
20250205@223611.7373 4fmm0t0mfuppovhsmnprnth4kh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@223611.7471 4fmm0t0mfuppovhsmnprnth4kh Query : use flama_phc
20250205@223611.7474 4fmm0t0mfuppovhsmnprnth4kh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@231910.9973 fnkrbjs4sik7unvo3j5i1flcoj Query : use flama_phc
20250205@231911.8000 fnkrbjs4sik7unvo3j5i1flcoj Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@231911.8080 fnkrbjs4sik7unvo3j5i1flcoj Query : use flama_phc
20250205@231911.8510 fnkrbjs4sik7unvo3j5i1flcoj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250205@233610.8478 v9qb6urhu82fj87rj99i6qdk9q Query : use flama_phc
20250205@233610.8483 v9qb6urhu82fj87rj99i6qdk9q Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250205@233610.8568 v9qb6urhu82fj87rj99i6qdk9q Query : use flama_phc
20250205@233610.8571 v9qb6urhu82fj87rj99i6qdk9q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250206@071910.1236 pkfdv33lif69a9cjtqgljvhpbr Query : use flama_phc
20250206@071910.1241 pkfdv33lif69a9cjtqgljvhpbr Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250206@071910.1401 pkfdv33lif69a9cjtqgljvhpbr Query : use flama_phc
20250206@071910.1405 pkfdv33lif69a9cjtqgljvhpbr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250206@073653.4341 phpdf2oj5suonu55voq0rpnds6 Query : use flama_phc
20250206@073653.4345 phpdf2oj5suonu55voq0rpnds6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250206@073653.4464 phpdf2oj5suonu55voq0rpnds6 Query : use flama_phc
20250206@073653.4467 phpdf2oj5suonu55voq0rpnds6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250206@074614.2546 cj3dh0umruoc13tm4cedr4flap Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@074614.2582 cj3dh0umruoc13tm4cedr4flap Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@074614.3272 cj3dh0umruoc13tm4cedr4flap Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5138';
20250206@074614.3358 cj3dh0umruoc13tm4cedr4flap Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5138';
20250206@074614.3451 cj3dh0umruoc13tm4cedr4flap Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5138';
20250206@074614.3499 cj3dh0umruoc13tm4cedr4flap Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5138';
20250206@074614.3581 cj3dh0umruoc13tm4cedr4flap Query : use flama_phc
20250206@074614.3585 cj3dh0umruoc13tm4cedr4flap Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@074614.3699 cj3dh0umruoc13tm4cedr4flap Query : use flama_phc
20250206@074614.3703 cj3dh0umruoc13tm4cedr4flap Query : select no, estab,szadrsdesc from szadrs where u_coddest=2427
20250206@074614.3821 cj3dh0umruoc13tm4cedr4flap 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 = 2008 and bo.obrano = 2500828 
20250206@074614.4386 cj3dh0umruoc13tm4cedr4flap Query : use flama_phc
20250206@074614.4390 cj3dh0umruoc13tm4cedr4flap Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@074614.5057 cj3dh0umruoc13tm4cedr4flap Query : use flama_phc
20250206@074614.5099 cj3dh0umruoc13tm4cedr4flap Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250206@074614.5828 cj3dh0umruoc13tm4cedr4flap Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250206@074614.5884 cj3dh0umruoc13tm4cedr4flap Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5138';
20250206@074614.5933 cj3dh0umruoc13tm4cedr4flap Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5138';
20250206@074614.6509 09pcqu7ecbijhsa2sgadq97g27 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@074614.6521 09pcqu7ecbijhsa2sgadq97g27 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@074614.6613 09pcqu7ecbijhsa2sgadq97g27 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5139';
20250206@074614.6695 09pcqu7ecbijhsa2sgadq97g27 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5139';
20250206@074614.6767 09pcqu7ecbijhsa2sgadq97g27 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5139';
20250206@074614.6812 09pcqu7ecbijhsa2sgadq97g27 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5139';
20250206@074614.6884 09pcqu7ecbijhsa2sgadq97g27 Query : use flama_phc
20250206@074614.6888 09pcqu7ecbijhsa2sgadq97g27 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@074614.6962 09pcqu7ecbijhsa2sgadq97g27 Query : use flama_phc
20250206@074614.6965 09pcqu7ecbijhsa2sgadq97g27 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250206@074614.7072 09pcqu7ecbijhsa2sgadq97g27 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 = 2009 and bo.obrano = 2500933 
20250206@074614.7534 09pcqu7ecbijhsa2sgadq97g27 Query : use flama_phc
20250206@074614.7538 09pcqu7ecbijhsa2sgadq97g27 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@074614.7571 09pcqu7ecbijhsa2sgadq97g27 Query : use flama_phc
20250206@074614.7574 09pcqu7ecbijhsa2sgadq97g27 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250206@074614.7591 09pcqu7ecbijhsa2sgadq97g27 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250206@074614.7616 09pcqu7ecbijhsa2sgadq97g27 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5139';
20250206@074614.7662 09pcqu7ecbijhsa2sgadq97g27 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5139';
20250206@074614.8771 j4f0838tqfctvsafbc0e5kt6pd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@074614.8783 j4f0838tqfctvsafbc0e5kt6pd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@074614.8859 j4f0838tqfctvsafbc0e5kt6pd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5140';
20250206@074614.8934 j4f0838tqfctvsafbc0e5kt6pd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5140';
20250206@074614.9013 j4f0838tqfctvsafbc0e5kt6pd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5140';
20250206@074614.9059 j4f0838tqfctvsafbc0e5kt6pd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5140';
20250206@074614.9142 j4f0838tqfctvsafbc0e5kt6pd Query : use flama_phc
20250206@074614.9146 j4f0838tqfctvsafbc0e5kt6pd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@074614.9239 j4f0838tqfctvsafbc0e5kt6pd Query : use flama_phc
20250206@074614.9243 j4f0838tqfctvsafbc0e5kt6pd Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20250206@074614.9357 j4f0838tqfctvsafbc0e5kt6pd 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 = 2009 and bo.obrano = 2500937 
20250206@074614.9845 j4f0838tqfctvsafbc0e5kt6pd Query : use flama_phc
20250206@074614.9848 j4f0838tqfctvsafbc0e5kt6pd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@074614.9883 j4f0838tqfctvsafbc0e5kt6pd Query : use flama_phc
20250206@074614.9886 j4f0838tqfctvsafbc0e5kt6pd Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250206@074614.9905 j4f0838tqfctvsafbc0e5kt6pd Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250206@074614.9928 j4f0838tqfctvsafbc0e5kt6pd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5140';
20250206@074614.9977 j4f0838tqfctvsafbc0e5kt6pd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5140';
20250206@074615.1344 mmef7ge4bu645f9g192d7joduh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@074615.1517 mmef7ge4bu645f9g192d7joduh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@074615.1606 mmef7ge4bu645f9g192d7joduh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5141';
20250206@074615.1685 mmef7ge4bu645f9g192d7joduh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5141';
20250206@074615.1766 mmef7ge4bu645f9g192d7joduh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5141';
20250206@074615.1818 mmef7ge4bu645f9g192d7joduh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5141';
20250206@074615.1915 mmef7ge4bu645f9g192d7joduh Query : use flama_phc
20250206@074615.1920 mmef7ge4bu645f9g192d7joduh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@074615.1987 mmef7ge4bu645f9g192d7joduh Query : use flama_phc
20250206@074615.1990 mmef7ge4bu645f9g192d7joduh Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20250206@074615.2106 mmef7ge4bu645f9g192d7joduh 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 = 2009 and bo.obrano = 2500938 
20250206@074615.2560 mmef7ge4bu645f9g192d7joduh Query : use flama_phc
20250206@074615.2563 mmef7ge4bu645f9g192d7joduh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@074615.2600 mmef7ge4bu645f9g192d7joduh Query : use flama_phc
20250206@074615.2603 mmef7ge4bu645f9g192d7joduh Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250206@074615.2623 mmef7ge4bu645f9g192d7joduh Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250206@074615.2647 mmef7ge4bu645f9g192d7joduh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5141';
20250206@074615.2699 mmef7ge4bu645f9g192d7joduh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5141';
20250206@074615.3355 rfruvau1pssr9m6k8qa20tqp0k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@074615.3368 rfruvau1pssr9m6k8qa20tqp0k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@074615.3445 rfruvau1pssr9m6k8qa20tqp0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5142';
20250206@074615.3517 rfruvau1pssr9m6k8qa20tqp0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5142';
20250206@074615.3585 rfruvau1pssr9m6k8qa20tqp0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5142';
20250206@074615.3625 rfruvau1pssr9m6k8qa20tqp0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5142';
20250206@074615.3696 rfruvau1pssr9m6k8qa20tqp0k Query : use flama_phc
20250206@074615.3700 rfruvau1pssr9m6k8qa20tqp0k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@074615.3766 rfruvau1pssr9m6k8qa20tqp0k Query : use flama_phc
20250206@074615.3770 rfruvau1pssr9m6k8qa20tqp0k Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20250206@074615.3820 rfruvau1pssr9m6k8qa20tqp0k 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 = 2009 and bo.obrano = 2500939 
20250206@074615.4264 rfruvau1pssr9m6k8qa20tqp0k Query : use flama_phc
20250206@074615.4268 rfruvau1pssr9m6k8qa20tqp0k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@074615.4303 rfruvau1pssr9m6k8qa20tqp0k Query : use flama_phc
20250206@074615.4307 rfruvau1pssr9m6k8qa20tqp0k Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250206@074615.4324 rfruvau1pssr9m6k8qa20tqp0k Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250206@074615.4348 rfruvau1pssr9m6k8qa20tqp0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5142';
20250206@074615.4399 rfruvau1pssr9m6k8qa20tqp0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5142';
20250206@074615.4956 mube5dkkf099t503mdk510vnjm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@074615.4967 mube5dkkf099t503mdk510vnjm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@074615.5057 mube5dkkf099t503mdk510vnjm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5143';
20250206@074615.5134 mube5dkkf099t503mdk510vnjm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5143';
20250206@074615.5208 mube5dkkf099t503mdk510vnjm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5143';
20250206@074615.5261 mube5dkkf099t503mdk510vnjm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5143';
20250206@074615.5340 mube5dkkf099t503mdk510vnjm Query : use flama_phc
20250206@074615.5344 mube5dkkf099t503mdk510vnjm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@074615.5416 mube5dkkf099t503mdk510vnjm Query : use flama_phc
20250206@074615.5420 mube5dkkf099t503mdk510vnjm Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250206@074615.5490 mube5dkkf099t503mdk510vnjm 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 = 2009 and bo.obrano = 2500940 
20250206@074615.5966 mube5dkkf099t503mdk510vnjm Query : use flama_phc
20250206@074615.5969 mube5dkkf099t503mdk510vnjm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@074615.6007 mube5dkkf099t503mdk510vnjm Query : use flama_phc
20250206@074615.6012 mube5dkkf099t503mdk510vnjm Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250206@074615.6034 mube5dkkf099t503mdk510vnjm Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250206@074615.6059 mube5dkkf099t503mdk510vnjm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5143';
20250206@074615.6120 mube5dkkf099t503mdk510vnjm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5143';
20250206@074615.6702 rhuhvsar61q6g9cvecer1nkr42 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@074615.6714 rhuhvsar61q6g9cvecer1nkr42 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@074615.6793 rhuhvsar61q6g9cvecer1nkr42 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5144';
20250206@074615.6865 rhuhvsar61q6g9cvecer1nkr42 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5144';
20250206@074615.6943 rhuhvsar61q6g9cvecer1nkr42 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5144';
20250206@074615.7015 rhuhvsar61q6g9cvecer1nkr42 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5144';
20250206@074615.7085 rhuhvsar61q6g9cvecer1nkr42 Query : use flama_phc
20250206@074615.7090 rhuhvsar61q6g9cvecer1nkr42 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@074615.7211 rhuhvsar61q6g9cvecer1nkr42 Query : use flama_phc
20250206@074615.7243 rhuhvsar61q6g9cvecer1nkr42 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8817
20250206@074615.7380 rhuhvsar61q6g9cvecer1nkr42 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 = 2009 and bo.obrano = 2500943 
20250206@074615.7910 rhuhvsar61q6g9cvecer1nkr42 Query : use flama_phc
20250206@074615.7914 rhuhvsar61q6g9cvecer1nkr42 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@074615.7978 rhuhvsar61q6g9cvecer1nkr42 Query : use flama_phc
20250206@074615.7983 rhuhvsar61q6g9cvecer1nkr42 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250206@074615.8006 rhuhvsar61q6g9cvecer1nkr42 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250206@074615.8069 rhuhvsar61q6g9cvecer1nkr42 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5144';
20250206@074615.8181 rhuhvsar61q6g9cvecer1nkr42 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5144';
20250206@080245.8433 266dasopov79cl8cu9q7d5uc20 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@080245.8510 266dasopov79cl8cu9q7d5uc20 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@080245.8644 266dasopov79cl8cu9q7d5uc20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5145';
20250206@080245.8718 266dasopov79cl8cu9q7d5uc20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5145';
20250206@080245.8792 266dasopov79cl8cu9q7d5uc20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5145';
20250206@080245.8854 266dasopov79cl8cu9q7d5uc20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5145';
20250206@080246.1610 ufago1b31cs35tf4s7ifclv43a Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250206@080246.1730 ufago1b31cs35tf4s7ifclv43a Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250206@080246.4930 ufago1b31cs35tf4s7ifclv43a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5146';
20250206@080246.5710 ufago1b31cs35tf4s7ifclv43a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5146';
20250206@080246.7050 ufago1b31cs35tf4s7ifclv43a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5146';
20250206@080246.7550 ufago1b31cs35tf4s7ifclv43a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5146';
20250206@080246.8190 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080246.8250 ufago1b31cs35tf4s7ifclv43a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250206@080246.8980 ufago1b31cs35tf4s7ifclv43a Query : select no, estab,szadrsdesc from szadrs where u_coddest=23
20250206@080246.1119 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1293.00.1'
20250206@080246.1274 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.1293.00.1' and bi.lordem =10000
20250206@080246.3445 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020556431,470000001 ' 
20250206@080246.4781 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1824.00.1'
20250206@080246.5393 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.1824.00.1' and bi.lordem =20000
20250206@080246.6340 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020556465,211000002 ' 
20250206@080246.7433 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4970.00.1'
20250206@080246.7997 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.4970.00.1' and bi.lordem =30000
20250206@080246.9234 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020556537,890000003 ' 
20250206@080247.1028 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2335.00.1'
20250206@080247.1468 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.2335.00.1' and bi.lordem =40000
20250206@080247.2582 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020556637,439000004 ' 
20250206@080247.3307 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2335.00.1'
20250206@080247.3366 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.2335.00.1' and bi.lordem =40000
20250206@080247.3627 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020556637,439000004 ' 
20250206@080247.3952 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2386.00.1'
20250206@080247.4533 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.2386.00.1' and bi.lordem =50000
20250206@080247.5808 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020556669,385000005 ' 
20250206@080247.6876 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2387.00.1'
20250206@080247.7409 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.2387.00.1' and bi.lordem =60000
20250206@080247.8504 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020556874,149000006 ' 
20250206@080247.9911 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2388.00.1'
20250206@080248.5280 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.2388.00.1' and bi.lordem =70000
20250206@080248.1561 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020558441,140000007 ' 
20250206@080248.2495 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.692.00.01'
20250206@080248.3099 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.692.00.01' and bi.lordem =90000
20250206@080248.4312 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020558508,708000009 ' 
20250206@080248.5565 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.692.00.01'
20250206@080248.5792 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.692.00.01' and bi.lordem =90000
20250206@080248.6130 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020558508,708000009 ' 
20250206@080248.6233 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1685.00.1'
20250206@080248.6794 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.1685.00.1' and bi.lordem =100000
20250206@080248.8613 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020558581,661000010 ' 
20250206@080249.1720 ufago1b31cs35tf4s7ifclv43a Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1685.00.1'
20250206@080249.1464 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2025 and bo.obrano = 0000007 and bi.ref ='324.1685.00.1' and bi.lordem =100000
20250206@080249.2418 ufago1b31cs35tf4s7ifclv43a 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 = 'pll25020558581,661000010 ' 
20250206@080249.2907 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080249.2911 ufago1b31cs35tf4s7ifclv43a Query : select top 1 1 valor from ts where ts.ndos = 5
20250206@080249.3176 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080249.3317 ufago1b31cs35tf4s7ifclv43a 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')
20250206@080249.4130 ufago1b31cs35tf4s7ifclv43a 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 =5
20250206@080249.5067 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080249.5177 ufago1b31cs35tf4s7ifclv43a Query : select top 1 ~inactivo valor from fl where no = '100999' and estab = 0 order by inactivo desc
20250206@080249.5914 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080249.5964 ufago1b31cs35tf4s7ifclv43a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250206@080249.6262 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080249.6267 ufago1b31cs35tf4s7ifclv43a Query : select szadrsstamp valor from szadrs where szadrsdesc='flama-fab.louÇas e electrodomesticos,sa'
20250206@080249.6514 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080249.6562 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from ts where ndos = 5
20250206@080249.6983 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080249.8070 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20250206@080249.8599 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080249.9057 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20250206@080249.9413 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080250.5700 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20250206@080250.4900 ufago1b31cs35tf4s7ifclv43a 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 = 5
20250206@080250.1683 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250206@080250.2728 ufago1b31cs35tf4s7ifclv43a Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250206@080250.3551 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080250.3672 ufago1b31cs35tf4s7ifclv43a Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100999' and estab=0
20250206@080250.4286 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080250.4607 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20250206@080250.4875 ufago1b31cs35tf4s7ifclv43a Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67a467240667a46caa56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250206@080250.5150 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080250.5336 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20250206@080250.5363 ufago1b31cs35tf4s7ifclv43a Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut67a467240667a46caa56','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20250206','08:32',?,?)
20250206@080250.7545 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080250.7685 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20250206@080250.7941 ufago1b31cs35tf4s7ifclv43a Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut67a467240667a46caa56','trf entre armazéns a','2025-02-06',5,44,?,?,?,?,?,?,?,?,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',?)
20250206@080251.3850 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080251.3890 ufago1b31cs35tf4s7ifclv43a Query : select st.usalote valor from st where st.ref = '324.1293.00.1'
20250206@080251.5980 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080251.6030 ufago1b31cs35tf4s7ifclv43a Query : select st.stns valor from st where st.ref = '324.1293.00.1'
20250206@080251.1132 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080251.1186 ufago1b31cs35tf4s7ifclv43a Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1293.00.1' and sa.armazem = 133 
20250206@080251.1724 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080251.1774 ufago1b31cs35tf4s7ifclv43a Query : select st.stns valor from st where st.ref = '324.1293.00.1'
20250206@080251.2157 ufago1b31cs35tf4s7ifclv43a 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.1293.00.1'
20250206@080251.2751 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080251.3065 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250206@080251.3364 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080251.3688 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250206@080251.3819 ufago1b31cs35tf4s7ifclv43a Query : select sestamp valor from se where ref ='324.1293.00.1' and lote = 'r2101042200a'
20250206@080251.4278 ufago1b31cs35tf4s7ifclv43a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250206@080251.4598 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080251.4889 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250206@080251.5131 ufago1b31cs35tf4s7ifclv43a Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67a469966867a46cab70','aut67a467240667a46caa56',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67a467240667a46caa56'
20250206@080251.8059 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080251.8375 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250206@080251.8750 ufago1b31cs35tf4s7ifclv43a Query : insert into wsbidata (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,ar2mazem,obistamp ,stipo) select 'aut67a469966867a46cab70',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.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 ,399.99,399.99*200.48,399.99,399.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,399.99*4.000,399.99*4.000*200.48 ,154.657000,154.657000*200.48 ,154.657000,154.657000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,399.99,399.99*200.48,399.99*4.000,399.99*4.000*200.48,'pll25020556431,470000001 ',399.99,399.99*4.000,399.99,399.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67a467240667a46caa56'
20250206@080252.1694 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080252.1786 ufago1b31cs35tf4s7ifclv43a Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20250206@080252.2253 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080252.2301 ufago1b31cs35tf4s7ifclv43a Query : select st.stns valor from st where st.ref = '324.1824.00.1'
20250206@080252.2643 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080252.2688 ufago1b31cs35tf4s7ifclv43a Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1824.00.1' and sa.armazem = 133 
20250206@080252.3313 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080252.3358 ufago1b31cs35tf4s7ifclv43a Query : select st.stns valor from st where st.ref = '324.1824.00.1'
20250206@080252.3749 ufago1b31cs35tf4s7ifclv43a 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.1824.00.1'
20250206@080252.4329 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080252.4636 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250206@080252.4931 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080252.5216 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250206@080252.5401 ufago1b31cs35tf4s7ifclv43a Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400217200a'
20250206@080252.5755 ufago1b31cs35tf4s7ifclv43a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250206@080252.6041 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080252.6435 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250206@080252.6701 ufago1b31cs35tf4s7ifclv43a Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67a462003567a46cac93','aut67a467240667a46caa56',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67a467240667a46caa56'
20250206@080252.7087 ufago1b31cs35tf4s7ifclv43a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250206@080252.7392 ufago1b31cs35tf4s7ifclv43a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250206@080252.7848 ufago1b31cs35tf4s7ifclv43a Query : insert into wsbidata (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,ar2mazem,obistamp ,stipo) select 'aut67a462003567a46cac93',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 10.000, 10.000*.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,20000 ,69.99,69.99*200.48,69.99,69.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,69.99*10.000,69.99*10.000*200.48 ,27.295000,27.295000*200.48 ,27.295000,27.295000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,69.99,69.99*200.48,69.99*10.000,69.99*10.000*200.48,'pll25020556465,211000002 ',69.99,69.99*10.000,69.99,69.99*10.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67a467240667a46caa56'
20250206@080252.8978 ufago1b31cs35tf4s7ifclv43a Query : use flama_phc
20250206@080252.9043 ufago1b31cs35tf4s7ifclv43a Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
