20240313@185211.4309 eggv4al8pv4lm5023savkcgtss Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240313@185211.4313 eggv4al8pv4lm5023savkcgtss Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f1f6818865f1f5db61','aut65f1f8406865f1f5db44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240313@185211.4319 eggv4al8pv4lm5023savkcgtss Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240313@185211.4334 eggv4al8pv4lm5023savkcgtss Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240313@185211.4365 eggv4al8pv4lm5023savkcgtss Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240313@185211.4378 eggv4al8pv4lm5023savkcgtss Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240313@185211.4383 eggv4al8pv4lm5023savkcgtss Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240313@185211.4392 eggv4al8pv4lm5023savkcgtss Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240313@185211.4404 eggv4al8pv4lm5023savkcgtss Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240313@185211.4425 eggv4al8pv4lm5023savkcgtss Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f1f1216265f1f5db6b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f1f8406865f1f5db44' ,0,0 ,2,23.00,20000,?,?,?)
20240313@185211.4697 eggv4al8pv4lm5023savkcgtss Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240313@185211.4711 eggv4al8pv4lm5023savkcgtss Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240313@185211.4716 eggv4al8pv4lm5023savkcgtss Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f1f1216265f1f5db6b','aut65f1f8406865f1f5db44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240313@185211.4720 eggv4al8pv4lm5023savkcgtss Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f1f8406865f1f5db44','2402123','wait',39,'ari17112337378,753000005')
20240313@185211.4734 eggv4al8pv4lm5023savkcgtss Query : use flama_phc
20240313@185211.4737 eggv4al8pv4lm5023savkcgtss Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@185211.4747 eggv4al8pv4lm5023savkcgtss Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='622';
20240313@185211.4763 eggv4al8pv4lm5023savkcgtss Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='622';
20240313@185211.4777 eggv4al8pv4lm5023savkcgtss Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='622';
20240313@185211.4789 eggv4al8pv4lm5023savkcgtss Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='622';
20240313@191919.8290 n251jmtj04dfbs6lervmovd46s Query : use flama_phc
20240313@191919.8295 n251jmtj04dfbs6lervmovd46s Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@191919.8310 n251jmtj04dfbs6lervmovd46s Query : use flama_phc
20240313@191919.8313 n251jmtj04dfbs6lervmovd46s Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@193620.1136 d3l0ku47ttj758022jv21f5o57 Query : use flama_phc
20240313@193620.1141 d3l0ku47ttj758022jv21f5o57 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@193620.1160 d3l0ku47ttj758022jv21f5o57 Query : use flama_phc
20240313@193620.1164 d3l0ku47ttj758022jv21f5o57 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@201913.9692 jbrq5b84b1iq68ufgp8dugq2s8 Query : use flama_phc
20240313@201913.9697 jbrq5b84b1iq68ufgp8dugq2s8 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@201913.9806 jbrq5b84b1iq68ufgp8dugq2s8 Query : use flama_phc
20240313@201914.1570 jbrq5b84b1iq68ufgp8dugq2s8 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@203614.3350 8ihuo2neuhjnjiotjti2n8mrdn Query : use flama_phc
20240313@203614.3355 8ihuo2neuhjnjiotjti2n8mrdn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@203614.3373 8ihuo2neuhjnjiotjti2n8mrdn Query : use flama_phc
20240313@203614.3413 8ihuo2neuhjnjiotjti2n8mrdn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@211914.1029 d1utdgm6323cnql93rd3vhtf1c Query : use flama_phc
20240313@211914.1034 d1utdgm6323cnql93rd3vhtf1c Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@211914.1053 d1utdgm6323cnql93rd3vhtf1c Query : use flama_phc
20240313@211914.1055 d1utdgm6323cnql93rd3vhtf1c Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@213614.1129 rs2jpgrp0vdgdsickvip595rqm Query : use flama_phc
20240313@213614.1133 rs2jpgrp0vdgdsickvip595rqm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@213614.1150 rs2jpgrp0vdgdsickvip595rqm Query : use flama_phc
20240313@213614.1153 rs2jpgrp0vdgdsickvip595rqm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@221909.6298 g3vp2gdb7s75dp6ddknkqvk0am Query : use flama_phc
20240313@221909.6304 g3vp2gdb7s75dp6ddknkqvk0am Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@221909.6319 g3vp2gdb7s75dp6ddknkqvk0am Query : use flama_phc
20240313@221909.6321 g3vp2gdb7s75dp6ddknkqvk0am Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@223609.3819 f5bh9lajr3i82p0cnvkpm9pi6c Query : use flama_phc
20240313@223609.3824 f5bh9lajr3i82p0cnvkpm9pi6c Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@223609.3841 f5bh9lajr3i82p0cnvkpm9pi6c Query : use flama_phc
20240313@223609.3844 f5bh9lajr3i82p0cnvkpm9pi6c Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@231913.3660 8u7gvj9jdrckl3rsapp8j90ir4 Query : use flama_phc
20240313@231913.3720 8u7gvj9jdrckl3rsapp8j90ir4 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@231913.3870 8u7gvj9jdrckl3rsapp8j90ir4 Query : use flama_phc
20240313@231913.3900 8u7gvj9jdrckl3rsapp8j90ir4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240313@233612.5860 uhtt4r50o58ltag9iilgbbn38q Query : use flama_phc
20240313@233612.5864 uhtt4r50o58ltag9iilgbbn38q Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240313@233612.5881 uhtt4r50o58ltag9iilgbbn38q Query : use flama_phc
20240313@233612.5884 uhtt4r50o58ltag9iilgbbn38q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@071937.9970 iksrs8rb6ocslbn6si89ho9ehp Query : use flama_phc
20240314@071937.1002 iksrs8rb6ocslbn6si89ho9ehp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@071937.1082 iksrs8rb6ocslbn6si89ho9ehp Query : use flama_phc
20240314@071937.1085 iksrs8rb6ocslbn6si89ho9ehp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@073606.1000 7n8t027gskofb04t3f0v5upf2m Query : use flama_phc
20240314@073606.1076 7n8t027gskofb04t3f0v5upf2m Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@073606.2173 7n8t027gskofb04t3f0v5upf2m Query : use flama_phc
20240314@073606.2177 7n8t027gskofb04t3f0v5upf2m Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@081915.7020 0pjjijjnnbv27roafljlss0i5j Query : use flama_phc
20240314@081915.7054 0pjjijjnnbv27roafljlss0i5j Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@081915.7181 0pjjijjnnbv27roafljlss0i5j Query : use flama_phc
20240314@081915.7184 0pjjijjnnbv27roafljlss0i5j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@083616.5030 i1hutpsuvk8n1htai1bqspe664 Query : use flama_phc
20240314@083616.5080 i1hutpsuvk8n1htai1bqspe664 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@083616.5260 i1hutpsuvk8n1htai1bqspe664 Query : use flama_phc
20240314@083616.5290 i1hutpsuvk8n1htai1bqspe664 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@091912.2241 u7ti4a7flvtr23gkucfqj1jrcv Query : use flama_phc
20240314@091912.2245 u7ti4a7flvtr23gkucfqj1jrcv Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@091912.2311 u7ti4a7flvtr23gkucfqj1jrcv Query : use flama_phc
20240314@091912.2314 u7ti4a7flvtr23gkucfqj1jrcv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@093612.1561 s7il9qhbeskk1ik0snd4jl9p82 Query : use flama_phc
20240314@093612.1565 s7il9qhbeskk1ik0snd4jl9p82 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@093612.1624 s7il9qhbeskk1ik0snd4jl9p82 Query : use flama_phc
20240314@093612.1627 s7il9qhbeskk1ik0snd4jl9p82 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@101915.5969 4q132j61nibnp744b4sjnvub6v Query : use flama_phc
20240314@101915.5974 4q132j61nibnp744b4sjnvub6v Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@101915.6037 4q132j61nibnp744b4sjnvub6v Query : use flama_phc
20240314@101915.6040 4q132j61nibnp744b4sjnvub6v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@103615.3090 hjgv30oedhc9b82bs2jrs26f4i Query : use flama_phc
20240314@103615.3096 hjgv30oedhc9b82bs2jrs26f4i Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@103615.3117 hjgv30oedhc9b82bs2jrs26f4i Query : use flama_phc
20240314@103615.3120 hjgv30oedhc9b82bs2jrs26f4i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@105018.3593 cnsvrepdo05d0ropceeakkiaq0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@105018.3639 cnsvrepdo05d0ropceeakkiaq0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@105018.3791 cnsvrepdo05d0ropceeakkiaq0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='623';
20240314@105018.3846 cnsvrepdo05d0ropceeakkiaq0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='623';
20240314@105018.3884 cnsvrepdo05d0ropceeakkiaq0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='623';
20240314@105018.3899 cnsvrepdo05d0ropceeakkiaq0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='623';
20240314@105018.3916 cnsvrepdo05d0ropceeakkiaq0 Query : use flama_phc
20240314@105018.3920 cnsvrepdo05d0ropceeakkiaq0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@105018.3972 cnsvrepdo05d0ropceeakkiaq0 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1831.00.2'
20240314@105018.4111 cnsvrepdo05d0ropceeakkiaq0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =trh and bo.boano =20u8 and bo.obrano = 4 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240314@111914.2497 eoft6ueb3r8n09farps62a5lje Query : use flama_phc
20240314@111914.2503 eoft6ueb3r8n09farps62a5lje Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@111914.2523 eoft6ueb3r8n09farps62a5lje Query : use flama_phc
20240314@111914.2526 eoft6ueb3r8n09farps62a5lje Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@113614.1830 1vahr5ab65r8m4hf4ht292g017 Query : use flama_phc
20240314@113614.1847 1vahr5ab65r8m4hf4ht292g017 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@113614.2061 1vahr5ab65r8m4hf4ht292g017 Query : use flama_phc
20240314@113614.2103 1vahr5ab65r8m4hf4ht292g017 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@121911.4855 9isdc0kqla0td2n3sprt9jqk0u Query : use flama_phc
20240314@121911.4860 9isdc0kqla0td2n3sprt9jqk0u Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@121911.4880 9isdc0kqla0td2n3sprt9jqk0u Query : use flama_phc
20240314@121911.4884 9isdc0kqla0td2n3sprt9jqk0u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@123611.2870 6m1aidspf3r3aa72m3f9u4vt55 Query : use flama_phc
20240314@123611.2874 6m1aidspf3r3aa72m3f9u4vt55 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@123611.2890 6m1aidspf3r3aa72m3f9u4vt55 Query : use flama_phc
20240314@123611.2893 6m1aidspf3r3aa72m3f9u4vt55 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@131917.5773 esvmcrmda6a7e06uf1sdnsep5h Query : use flama_phc
20240314@131917.5778 esvmcrmda6a7e06uf1sdnsep5h Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@131917.5794 esvmcrmda6a7e06uf1sdnsep5h Query : use flama_phc
20240314@131917.5797 esvmcrmda6a7e06uf1sdnsep5h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@133617.4645 faj77mc8307n2iigpun34733k5 Query : use flama_phc
20240314@133617.4649 faj77mc8307n2iigpun34733k5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@133617.4665 faj77mc8307n2iigpun34733k5 Query : use flama_phc
20240314@133617.4668 faj77mc8307n2iigpun34733k5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@141911.6884 5aokukmd77jkdabia79qrk8l7k Query : use flama_phc
20240314@141911.6890 5aokukmd77jkdabia79qrk8l7k Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@141911.6950 5aokukmd77jkdabia79qrk8l7k Query : use flama_phc
20240314@141911.6953 5aokukmd77jkdabia79qrk8l7k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@143611.6409 eb3sv3hgtomc69407fn4u9s06i Query : use flama_phc
20240314@143611.6416 eb3sv3hgtomc69407fn4u9s06i Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@143611.6444 eb3sv3hgtomc69407fn4u9s06i Query : use flama_phc
20240314@143611.6447 eb3sv3hgtomc69407fn4u9s06i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@151911.1952 idalqsrhdjc6nd8v5eb84hf60f Query : use flama_phc
20240314@151911.1964 idalqsrhdjc6nd8v5eb84hf60f Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@151911.2035 idalqsrhdjc6nd8v5eb84hf60f Query : use flama_phc
20240314@151911.2039 idalqsrhdjc6nd8v5eb84hf60f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@153611.3177 re705afqf6phug2jtbdjru5f5f Query : use flama_phc
20240314@153611.3190 re705afqf6phug2jtbdjru5f5f Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@153611.3205 re705afqf6phug2jtbdjru5f5f Query : use flama_phc
20240314@153611.3245 re705afqf6phug2jtbdjru5f5f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@161932.8267 u87q4ehq7c7ftb9adrmomrrub1 Query : use flama_phc
20240314@161932.8308 u87q4ehq7c7ftb9adrmomrrub1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@161932.8724 u87q4ehq7c7ftb9adrmomrrub1 Query : use flama_phc
20240314@161932.8803 u87q4ehq7c7ftb9adrmomrrub1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@163621.3269 652gi60ureoc2eurpk38ue5rt1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@163621.3340 652gi60ureoc2eurpk38ue5rt1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@163621.3568 652gi60ureoc2eurpk38ue5rt1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='624';
20240314@163621.3686 652gi60ureoc2eurpk38ue5rt1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='624';
20240314@163621.3728 652gi60ureoc2eurpk38ue5rt1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='624';
20240314@163621.3795 652gi60ureoc2eurpk38ue5rt1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='624';
20240314@163621.3823 652gi60ureoc2eurpk38ue5rt1 Query : use flama_phc
20240314@163621.3837 652gi60ureoc2eurpk38ue5rt1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@163621.3919 652gi60ureoc2eurpk38ue5rt1 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1832.00.2'
20240314@163621.4148 652gi60ureoc2eurpk38ue5rt1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =ffa and bo.boano =20u2 and bo.obrano = 0 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240314@163632.1486 5io161fqe2ltbe6vdg676ap5e5 Query : use flama_phc
20240314@163632.1528 5io161fqe2ltbe6vdg676ap5e5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@163632.1657 5io161fqe2ltbe6vdg676ap5e5 Query : use flama_phc
20240314@163632.1663 5io161fqe2ltbe6vdg676ap5e5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@171912.2866 ba3io7i7lgk0bk6v2tubiir2jh Query : use flama_phc
20240314@171912.2871 ba3io7i7lgk0bk6v2tubiir2jh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@171912.2888 ba3io7i7lgk0bk6v2tubiir2jh Query : use flama_phc
20240314@171912.2891 ba3io7i7lgk0bk6v2tubiir2jh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@173612.6160 75cqor7dpqug1sqkvg909l88ff Query : use flama_phc
20240314@173612.6167 75cqor7dpqug1sqkvg909l88ff Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@173612.6192 75cqor7dpqug1sqkvg909l88ff Query : use flama_phc
20240314@173612.6196 75cqor7dpqug1sqkvg909l88ff Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@181914.5654 acda3sm77n5lsfd7rci6k762qa Query : use flama_phc
20240314@181914.5659 acda3sm77n5lsfd7rci6k762qa Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@181914.5677 acda3sm77n5lsfd7rci6k762qa Query : use flama_phc
20240314@181914.5681 acda3sm77n5lsfd7rci6k762qa Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183614.7771 il48339asv9ir5kt16casplchp Query : use flama_phc
20240314@183614.7780 il48339asv9ir5kt16casplchp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240314@183614.8040 il48339asv9ir5kt16casplchp Query : use flama_phc
20240314@183614.8075 il48339asv9ir5kt16casplchp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183622.5763 ot561bst1l9enej224ckmoe650 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183622.5804 ot561bst1l9enej224ckmoe650 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183622.5978 ot561bst1l9enej224ckmoe650 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='625';
20240314@183622.6040 ot561bst1l9enej224ckmoe650 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='625';
20240314@183622.6089 ot561bst1l9enej224ckmoe650 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='625';
20240314@183622.6118 ot561bst1l9enej224ckmoe650 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='625';
20240314@183622.6143 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183622.6147 ot561bst1l9enej224ckmoe650 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183622.6278 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183622.6283 ot561bst1l9enej224ckmoe650 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2498
20240314@183622.6884 ot561bst1l9enej224ckmoe650 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20240314@183622.7070 ot561bst1l9enej224ckmoe650 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402126 and bi.ref ='324.945.00.01' and bi.lordem =1
20240314@183622.7473 ot561bst1l9enej224ckmoe650 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240314@183622.7650 ot561bst1l9enej224ckmoe650 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402126 and bi.ref ='324.958.00.01' and bi.lordem =2
20240314@183622.8030 ot561bst1l9enej224ckmoe650 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2041.00.1'
20240314@183622.8221 ot561bst1l9enej224ckmoe650 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402126 and bi.ref ='324.2041.00.1' and bi.lordem =3
20240314@183622.8612 ot561bst1l9enej224ckmoe650 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20240314@183622.8783 ot561bst1l9enej224ckmoe650 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402126 and bi.ref ='324.497.00.01' and bi.lordem =4
20240314@183622.9144 ot561bst1l9enej224ckmoe650 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9205.00.1'
20240314@183622.9318 ot561bst1l9enej224ckmoe650 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402126 and bi.ref ='328.9205.00.1' and bi.lordem =5
20240314@183622.9727 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183622.9731 ot561bst1l9enej224ckmoe650 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183622.9919 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183622.9923 ot561bst1l9enej224ckmoe650 Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183623.7000 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183623.2000 ot561bst1l9enej224ckmoe650 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183623.7900 ot561bst1l9enej224ckmoe650 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183623.2180 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183623.2220 ot561bst1l9enej224ckmoe650 Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20240314@183623.3480 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183623.3510 ot561bst1l9enej224ckmoe650 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240314@183623.4420 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183623.4480 ot561bst1l9enej224ckmoe650 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240314@183623.4900 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183623.4930 ot561bst1l9enej224ckmoe650 Query : select szadrsstamp valor from szadrs where szadrsdesc='comercial benajes sl'
20240314@183623.5070 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183623.5100 ot561bst1l9enej224ckmoe650 Query : select 1 valor from td where ndoc = 39
20240314@183623.5990 ot561bst1l9enej224ckmoe650 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240314@183623.6980 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183623.1079 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240314@183623.2249 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183623.2577 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240314@183623.2694 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183623.3043 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240314@183623.3089 ot561bst1l9enej224ckmoe650 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183623.3351 ot561bst1l9enej224ckmoe650 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183623.3604 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183623.3632 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240314@183623.3666 ot561bst1l9enej224ckmoe650 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f348480565f343a74b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240314@183623.4515 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183623.4535 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240314@183623.4614 ot561bst1l9enej224ckmoe650 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240314@183623.4716 ot561bst1l9enej224ckmoe650 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240314@183623.4796 ot561bst1l9enej224ckmoe650 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240314@183623.4880 ot561bst1l9enej224ckmoe650 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240314@183623.4988 ot561bst1l9enej224ckmoe650 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240314@183623.5083 ot561bst1l9enej224ckmoe650 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240314@183623.5164 ot561bst1l9enej224ckmoe650 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f348480565f343a74b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240314@183623.5844 ot561bst1l9enej224ckmoe650 Query : select top 1 fno valor from wsft039data order by fno desc
20240314@183623.5941 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183623.5956 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240314@183623.6034 ot561bst1l9enej224ckmoe650 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65f348480565f343a74b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',460,200500,0,'2024-03-14',39,'euro',0,0,2024 ,'20240314','1906',?,?,?,?)
20240314@183623.7153 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183623.7157 ot561bst1l9enej224ckmoe650 Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240314@183623.7298 ot561bst1l9enej224ckmoe650 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.945.00.01'
20240314@183623.7485 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183623.9518 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183623.9596 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183623.9902 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183623.9926 ot561bst1l9enej224ckmoe650 Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240314@183623.9999 ot561bst1l9enej224ckmoe650 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183624.4100 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.5500 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183624.1241 ot561bst1l9enej224ckmoe650 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f344368765f343a801',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65f348480565f343a74b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240314@183624.1943 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.1976 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183624.2001 ot561bst1l9enej224ckmoe650 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f344368765f343a801','aut65f348480565f343a74b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183624.2101 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183624.2106 ot561bst1l9enej224ckmoe650 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240314@183624.2129 ot561bst1l9enej224ckmoe650 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20240314@183624.2289 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.2304 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183624.2338 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.2398 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183624.2403 ot561bst1l9enej224ckmoe650 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2301081100a'
20240314@183624.2415 ot561bst1l9enej224ckmoe650 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183624.2426 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.2441 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183624.2466 ot561bst1l9enej224ckmoe650 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f343087565f343a83b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut65f348480565f343a74b' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240314@183624.2757 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.2772 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183624.2778 ot561bst1l9enej224ckmoe650 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f343087565f343a83b','aut65f348480565f343a74b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183624.2782 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183624.2785 ot561bst1l9enej224ckmoe650 Query : select st.usalote valor from st where st.ref = '324.2041.00.1'
20240314@183624.2797 ot561bst1l9enej224ckmoe650 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2041.00.1'
20240314@183624.2991 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.3005 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183624.3032 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.3048 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183624.3053 ot561bst1l9enej224ckmoe650 Query : select sestamp valor from se where ref ='324.2041.00.1' and lote = 'r2100232100a'
20240314@183624.3087 ot561bst1l9enej224ckmoe650 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183624.3098 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.3129 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183624.3156 ot561bst1l9enej224ckmoe650 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f347472765f343a84b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f348480565f343a74b' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240314@183624.3427 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.3449 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183624.3453 ot561bst1l9enej224ckmoe650 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f347472765f343a84b','aut65f348480565f343a74b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183624.3458 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.3473 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183624.3517 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.3529 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183624.3534 ot561bst1l9enej224ckmoe650 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183624.3544 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.3558 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183624.3585 ot561bst1l9enej224ckmoe650 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f342168965f343a856',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f348480565f343a74b' ,0,0 ,2,23.00,40000,?,?,?)
20240314@183624.3896 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.3917 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183624.3923 ot561bst1l9enej224ckmoe650 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f342168965f343a856','aut65f348480565f343a74b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183624.3928 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183624.3932 ot561bst1l9enej224ckmoe650 Query : select st.usalote valor from st where st.ref = '324.497.00.01'
20240314@183624.3961 ot561bst1l9enej224ckmoe650 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.497.00.01'
20240314@183624.4123 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.4147 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183624.4255 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.4272 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183624.4278 ot561bst1l9enej224ckmoe650 Query : select sestamp valor from se where ref ='324.497.00.01' and lote = 'r2300022100a'
20240314@183624.4302 ot561bst1l9enej224ckmoe650 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183624.4314 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.4331 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183624.4360 ot561bst1l9enej224ckmoe650 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f348680565f343a869',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut65f348480565f343a74b' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240314@183624.4686 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.4709 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183624.4714 ot561bst1l9enej224ckmoe650 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f348680565f343a869','aut65f348480565f343a74b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183624.4720 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183624.4724 ot561bst1l9enej224ckmoe650 Query : select st.usalote valor from st where st.ref = '328.9205.00.1'
20240314@183624.4738 ot561bst1l9enej224ckmoe650 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9205.00.1'
20240314@183624.5048 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.5135 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183624.5443 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.5540 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183624.5546 ot561bst1l9enej224ckmoe650 Query : select sestamp valor from se where ref ='328.9205.00.1' and lote = 'r2001612100a'
20240314@183624.5572 ot561bst1l9enej224ckmoe650 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183624.5594 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183624.5816 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183624.5847 ot561bst1l9enej224ckmoe650 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f341411065f343a888',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f348480565f343a74b' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240314@183624.6168 ot561bst1l9enej224ckmoe650 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183624.6302 ot561bst1l9enej224ckmoe650 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183624.6372 ot561bst1l9enej224ckmoe650 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f341411065f343a888','aut65f348480565f343a74b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183624.6416 ot561bst1l9enej224ckmoe650 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f348480565f343a74b','2402126','wait',39,'ari17112337378,753000005')
20240314@183624.6500 ot561bst1l9enej224ckmoe650 Query : use flama_phc
20240314@183624.6503 ot561bst1l9enej224ckmoe650 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183624.6516 ot561bst1l9enej224ckmoe650 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='625';
20240314@183624.6552 ot561bst1l9enej224ckmoe650 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='625';
20240314@183624.6570 ot561bst1l9enej224ckmoe650 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='625';
20240314@183624.6584 ot561bst1l9enej224ckmoe650 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='625';
20240314@183624.7429 hknu5d9l849cus534ufhjijajo Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183624.7446 hknu5d9l849cus534ufhjijajo Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183624.7463 hknu5d9l849cus534ufhjijajo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='626';
20240314@183624.7512 hknu5d9l849cus534ufhjijajo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='626';
20240314@183624.7526 hknu5d9l849cus534ufhjijajo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='626';
20240314@183624.7542 hknu5d9l849cus534ufhjijajo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='626';
20240314@183624.7557 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.7561 hknu5d9l849cus534ufhjijajo Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183624.7591 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.7594 hknu5d9l849cus534ufhjijajo Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240314@183624.7681 hknu5d9l849cus534ufhjijajo Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240314@183624.7848 hknu5d9l849cus534ufhjijajo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402127 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240314@183624.8207 hknu5d9l849cus534ufhjijajo Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240314@183624.8219 hknu5d9l849cus534ufhjijajo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402127 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240314@183624.8224 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8227 hknu5d9l849cus534ufhjijajo Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183624.8240 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8242 hknu5d9l849cus534ufhjijajo Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183624.8269 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8272 hknu5d9l849cus534ufhjijajo Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183624.8283 hknu5d9l849cus534ufhjijajo Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183624.8298 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8301 hknu5d9l849cus534ufhjijajo Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240314@183624.8404 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8408 hknu5d9l849cus534ufhjijajo Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240314@183624.8427 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8431 hknu5d9l849cus534ufhjijajo Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240314@183624.8443 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8446 hknu5d9l849cus534ufhjijajo Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240314@183624.8460 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183624.8464 hknu5d9l849cus534ufhjijajo Query : select 1 valor from td where ndoc = 39
20240314@183624.8475 hknu5d9l849cus534ufhjijajo Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240314@183624.8487 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183624.8582 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240314@183624.8599 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183624.8648 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240314@183624.8924 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183624.8989 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240314@183624.9001 hknu5d9l849cus534ufhjijajo Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183624.9123 hknu5d9l849cus534ufhjijajo Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183624.9133 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183624.9162 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240314@183624.9172 hknu5d9l849cus534ufhjijajo Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f340977365f343a8db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240314@183624.9382 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183624.9403 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240314@183624.9436 hknu5d9l849cus534ufhjijajo Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240314@183624.9443 hknu5d9l849cus534ufhjijajo Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240314@183624.9449 hknu5d9l849cus534ufhjijajo Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240314@183624.9471 hknu5d9l849cus534ufhjijajo Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240314@183624.9477 hknu5d9l849cus534ufhjijajo Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240314@183624.9484 hknu5d9l849cus534ufhjijajo Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240314@183624.9490 hknu5d9l849cus534ufhjijajo Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f340977365f343a8db',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240314@183624.9790 hknu5d9l849cus534ufhjijajo Query : select top 1 fno valor from wsft039data order by fno desc
20240314@183624.9809 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183624.9825 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240314@183624.9847 hknu5d9l849cus534ufhjijajo Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65f340977365f343a8db',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',461,100810,0,'2024-03-14',39,'euro',0,0,2024 ,'20240314','1906',?,?,?,?)
20240314@183625.2020 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183625.2060 hknu5d9l849cus534ufhjijajo Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240314@183625.2200 hknu5d9l849cus534ufhjijajo Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240314@183625.3930 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.4110 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183625.4590 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.4730 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183625.4780 hknu5d9l849cus534ufhjijajo Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '230741'
20240314@183625.5080 hknu5d9l849cus534ufhjijajo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183625.5200 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.5360 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183625.5730 hknu5d9l849cus534ufhjijajo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f342134765f343a90c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut65f340977365f343a8db' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240314@183625.8780 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.8940 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183625.8980 hknu5d9l849cus534ufhjijajo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f342134765f343a90c','aut65f340977365f343a8db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183625.9030 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183625.9060 hknu5d9l849cus534ufhjijajo Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240314@183625.9170 hknu5d9l849cus534ufhjijajo Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240314@183625.9270 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.9410 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183625.9620 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.9750 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183625.9870 hknu5d9l849cus534ufhjijajo Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '230741'
20240314@183625.9970 hknu5d9l849cus534ufhjijajo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183625.1006 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.1045 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183625.1068 hknu5d9l849cus534ufhjijajo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f348663865f343a918',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut65f340977365f343a8db' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240314@183625.1398 hknu5d9l849cus534ufhjijajo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.1428 hknu5d9l849cus534ufhjijajo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183625.1434 hknu5d9l849cus534ufhjijajo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f348663865f343a918','aut65f340977365f343a8db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183625.1439 hknu5d9l849cus534ufhjijajo Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f340977365f343a8db','2402127','wait',39,'ari17112337378,753000005')
20240314@183625.1456 hknu5d9l849cus534ufhjijajo Query : use flama_phc
20240314@183625.1461 hknu5d9l849cus534ufhjijajo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183625.1473 hknu5d9l849cus534ufhjijajo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='626';
20240314@183625.1491 hknu5d9l849cus534ufhjijajo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='626';
20240314@183625.2546 hknu5d9l849cus534ufhjijajo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='626';
20240314@183625.2623 hknu5d9l849cus534ufhjijajo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='626';
20240314@183625.3076 86e9p4rjfj82q1i03a0ko6s5me Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183625.3091 86e9p4rjfj82q1i03a0ko6s5me Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183625.3108 86e9p4rjfj82q1i03a0ko6s5me Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='627';
20240314@183625.3150 86e9p4rjfj82q1i03a0ko6s5me Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='627';
20240314@183625.3165 86e9p4rjfj82q1i03a0ko6s5me Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='627';
20240314@183625.3178 86e9p4rjfj82q1i03a0ko6s5me Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='627';
20240314@183625.3195 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3198 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183625.3212 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3216 86e9p4rjfj82q1i03a0ko6s5me Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240314@183625.3273 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20240314@183625.3430 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402128 and bi.ref ='324.2221.00.1' and bi.lordem =1
20240314@183625.3765 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3770 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183625.3784 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3787 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183625.3798 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3801 86e9p4rjfj82q1i03a0ko6s5me Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183625.3813 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183625.3829 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3833 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240314@183625.3844 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3848 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240314@183625.3859 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3862 86e9p4rjfj82q1i03a0ko6s5me Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240314@183625.3874 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3877 86e9p4rjfj82q1i03a0ko6s5me Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240314@183625.3890 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.3894 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from td where ndoc = 39
20240314@183625.3905 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240314@183625.3917 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183625.3933 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240314@183625.3972 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183625.3987 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240314@183625.4014 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183625.4026 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240314@183625.4037 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183625.4143 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183625.4154 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183625.4176 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240314@183625.4190 86e9p4rjfj82q1i03a0ko6s5me Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f347894765f343a962' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240314@183625.4417 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183625.4435 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240314@183625.4466 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240314@183625.4478 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240314@183625.4483 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240314@183625.4488 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240314@183625.4493 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240314@183625.4499 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240314@183625.4504 86e9p4rjfj82q1i03a0ko6s5me Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f347894765f343a962',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240314@183625.4799 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 fno valor from wsft039data order by fno desc
20240314@183625.4823 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183625.4837 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240314@183625.4857 86e9p4rjfj82q1i03a0ko6s5me Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65f347894765f343a962',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',462,100810,0,'2024-03-14',39,'euro',0,0,2024 ,'20240314','1906',?,?,?,?)
20240314@183625.5219 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.5227 86e9p4rjfj82q1i03a0ko6s5me Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240314@183625.5242 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2221.00.1'
20240314@183625.5448 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.5463 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183625.5489 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.5503 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183625.5508 86e9p4rjfj82q1i03a0ko6s5me Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20240314@183625.5526 86e9p4rjfj82q1i03a0ko6s5me Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183625.5537 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.5559 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183625.5584 86e9p4rjfj82q1i03a0ko6s5me Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f349796965f343a987',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut65f347894765f343a962' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240314@183625.5927 86e9p4rjfj82q1i03a0ko6s5me Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.5943 86e9p4rjfj82q1i03a0ko6s5me Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183625.5947 86e9p4rjfj82q1i03a0ko6s5me Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f349796965f343a987','aut65f347894765f343a962' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183625.5952 86e9p4rjfj82q1i03a0ko6s5me Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f347894765f343a962','2402128','wait',39,'ari17112337378,753000005')
20240314@183625.5970 86e9p4rjfj82q1i03a0ko6s5me Query : use flama_phc
20240314@183625.5973 86e9p4rjfj82q1i03a0ko6s5me Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183625.5985 86e9p4rjfj82q1i03a0ko6s5me Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='627';
20240314@183625.6003 86e9p4rjfj82q1i03a0ko6s5me Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='627';
20240314@183625.6021 86e9p4rjfj82q1i03a0ko6s5me Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='627';
20240314@183625.6036 86e9p4rjfj82q1i03a0ko6s5me Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='627';
20240314@183625.6415 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183625.6432 7q5n3m8tisn7i0vcir81jv87b8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183625.6451 7q5n3m8tisn7i0vcir81jv87b8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='628';
20240314@183625.6494 7q5n3m8tisn7i0vcir81jv87b8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='628';
20240314@183625.6508 7q5n3m8tisn7i0vcir81jv87b8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='628';
20240314@183625.6532 7q5n3m8tisn7i0vcir81jv87b8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='628';
20240314@183625.6544 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.6548 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183625.6562 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.6565 7q5n3m8tisn7i0vcir81jv87b8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240314@183625.6635 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20240314@183625.6821 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402129 and bi.ref ='324.2222.00.1' and bi.lordem =1
20240314@183625.7176 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20240314@183625.7189 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402129 and bi.ref ='324.2222.00.1' and bi.lordem =1
20240314@183625.7196 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7200 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183625.7213 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7216 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183625.7227 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7230 7q5n3m8tisn7i0vcir81jv87b8 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183625.7241 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183625.7256 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7259 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240314@183625.7269 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7272 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240314@183625.7284 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7287 7q5n3m8tisn7i0vcir81jv87b8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240314@183625.7298 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7300 7q5n3m8tisn7i0vcir81jv87b8 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240314@183625.7312 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.7314 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from td where ndoc = 39
20240314@183625.7324 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240314@183625.7335 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183625.7348 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240314@183625.7364 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183625.7376 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240314@183625.7403 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183625.7416 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240314@183625.7426 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183625.7540 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183625.7550 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183625.7564 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240314@183625.7574 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f345902565f343a9b5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240314@183625.7768 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183625.7790 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240314@183625.7821 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240314@183625.7826 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240314@183625.7832 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240314@183625.7851 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240314@183625.7856 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240314@183625.7860 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240314@183625.7865 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f345902565f343a9b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240314@183625.8146 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 fno valor from wsft039data order by fno desc
20240314@183625.8167 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183625.8183 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240314@183625.8205 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65f345902565f343a9b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',463,100810,0,'2024-03-14',39,'euro',0,0,2024 ,'20240314','1906',?,?,?,?)
20240314@183625.8545 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.8554 7q5n3m8tisn7i0vcir81jv87b8 Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20240314@183625.8569 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2222.00.1'
20240314@183625.8819 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.8834 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183625.8859 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.8873 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183625.8879 7q5n3m8tisn7i0vcir81jv87b8 Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301280100a'
20240314@183625.8912 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183625.8922 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.8937 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183625.8961 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f349886665f343a9d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65f345902565f343a9b5' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240314@183625.9245 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183625.9266 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183625.9270 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f349886665f343a9d9','aut65f345902565f343a9b5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183625.9275 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183625.9278 7q5n3m8tisn7i0vcir81jv87b8 Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20240314@183625.9289 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2222.00.1'
20240314@183625.9301 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183625.9313 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183625.9420 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183626.5280 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183626.5350 7q5n3m8tisn7i0vcir81jv87b8 Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2300829100a'
20240314@183626.5470 7q5n3m8tisn7i0vcir81jv87b8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183626.5570 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183626.5710 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183626.5940 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f344059565f343aa0d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',36.000 ,'aut65f345902565f343a9b5' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240314@183626.8850 7q5n3m8tisn7i0vcir81jv87b8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183626.9170 7q5n3m8tisn7i0vcir81jv87b8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183626.9210 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f344059565f343aa0d','aut65f345902565f343a9b5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183626.9260 7q5n3m8tisn7i0vcir81jv87b8 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f345902565f343a9b5','2402129','wait',39,'ari17112337378,753000005')
20240314@183626.9430 7q5n3m8tisn7i0vcir81jv87b8 Query : use flama_phc
20240314@183626.9460 7q5n3m8tisn7i0vcir81jv87b8 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183626.9580 7q5n3m8tisn7i0vcir81jv87b8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='628';
20240314@183626.9740 7q5n3m8tisn7i0vcir81jv87b8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='628';
20240314@183626.9900 7q5n3m8tisn7i0vcir81jv87b8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='628';
20240314@183626.1003 7q5n3m8tisn7i0vcir81jv87b8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='628';
20240314@183626.1396 bt7lv4taqnckcareh28ddhsep4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183626.1415 bt7lv4taqnckcareh28ddhsep4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183626.1436 bt7lv4taqnckcareh28ddhsep4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='629';
20240314@183626.1499 bt7lv4taqnckcareh28ddhsep4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='629';
20240314@183626.1519 bt7lv4taqnckcareh28ddhsep4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='629';
20240314@183626.1534 bt7lv4taqnckcareh28ddhsep4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='629';
20240314@183626.1546 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.1550 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183626.1563 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.1566 bt7lv4taqnckcareh28ddhsep4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240314@183626.1607 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1406.00.1'
20240314@183626.1775 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402130 and bi.ref ='324.1406.00.1' and bi.lordem =1
20240314@183626.2139 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1406.00.1'
20240314@183626.2153 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402130 and bi.ref ='324.1406.00.1' and bi.lordem =1
20240314@183626.2158 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2162 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183626.2175 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2178 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183626.2189 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2205 bt7lv4taqnckcareh28ddhsep4 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183626.2216 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183626.2230 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2233 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240314@183626.2244 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2247 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240314@183626.2258 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2268 bt7lv4taqnckcareh28ddhsep4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240314@183626.2279 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2282 bt7lv4taqnckcareh28ddhsep4 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240314@183626.2294 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.2297 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from td where ndoc = 39
20240314@183626.2309 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240314@183626.2321 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183626.2338 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240314@183626.2399 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183626.2413 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240314@183626.2441 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183626.2454 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240314@183626.2464 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183626.2562 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183626.2572 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183626.2588 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240314@183626.2607 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f343109565f343aa3c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240314@183626.2838 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183626.2872 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240314@183626.2903 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240314@183626.2908 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240314@183626.2913 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240314@183626.2918 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240314@183626.2922 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240314@183626.2927 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240314@183626.2932 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f343109565f343aa3c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240314@183626.3216 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 fno valor from wsft039data order by fno desc
20240314@183626.3238 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183626.3255 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240314@183626.3274 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65f343109565f343aa3c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',464,100810,0,'2024-03-14',39,'euro',0,0,2024 ,'20240314','1906',?,?,?,?)
20240314@183626.3617 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.3627 bt7lv4taqnckcareh28ddhsep4 Query : select st.usalote valor from st where st.ref = '324.1406.00.1'
20240314@183626.3643 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1406.00.1'
20240314@183626.3854 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183626.3868 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183626.3916 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183626.3929 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183626.3935 bt7lv4taqnckcareh28ddhsep4 Query : select sestamp valor from se where ref ='324.1406.00.1' and lote = '10/20'
20240314@183626.3963 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183626.3973 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183626.3988 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183626.4022 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f341497365f343aa61',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',30.000 ,'aut65f343109565f343aa3c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240314@183626.4333 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183626.4349 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183626.4353 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f341497365f343aa61','aut65f343109565f343aa3c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183626.4364 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.4368 bt7lv4taqnckcareh28ddhsep4 Query : select st.usalote valor from st where st.ref = '324.1406.00.1'
20240314@183626.4379 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1406.00.1'
20240314@183626.4392 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183626.4407 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183626.4432 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183626.4447 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183626.4452 bt7lv4taqnckcareh28ddhsep4 Query : select sestamp valor from se where ref ='324.1406.00.1' and lote = '10/20'
20240314@183626.4488 bt7lv4taqnckcareh28ddhsep4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183626.4498 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183626.4511 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183626.4537 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f341713965f343aa6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut65f343109565f343aa3c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240314@183626.4845 bt7lv4taqnckcareh28ddhsep4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183626.4866 bt7lv4taqnckcareh28ddhsep4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183626.4870 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f341713965f343aa6d','aut65f343109565f343aa3c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183626.4874 bt7lv4taqnckcareh28ddhsep4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f343109565f343aa3c','2402130','wait',39,'ari17112337378,753000005')
20240314@183626.4891 bt7lv4taqnckcareh28ddhsep4 Query : use flama_phc
20240314@183626.4894 bt7lv4taqnckcareh28ddhsep4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183626.4905 bt7lv4taqnckcareh28ddhsep4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='629';
20240314@183626.4921 bt7lv4taqnckcareh28ddhsep4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='629';
20240314@183626.4934 bt7lv4taqnckcareh28ddhsep4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='629';
20240314@183626.4968 bt7lv4taqnckcareh28ddhsep4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='629';
20240314@183626.5328 chcjcdg84sp3qjodidetu1cflh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183626.5345 chcjcdg84sp3qjodidetu1cflh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183626.5477 chcjcdg84sp3qjodidetu1cflh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='630';
20240314@183626.5525 chcjcdg84sp3qjodidetu1cflh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='630';
20240314@183626.5541 chcjcdg84sp3qjodidetu1cflh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='630';
20240314@183626.5593 chcjcdg84sp3qjodidetu1cflh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='630';
20240314@183626.6039 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.6083 chcjcdg84sp3qjodidetu1cflh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183626.6261 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.6265 chcjcdg84sp3qjodidetu1cflh Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240314@183626.6330 chcjcdg84sp3qjodidetu1cflh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20240314@183626.6958 chcjcdg84sp3qjodidetu1cflh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402131 and bi.ref ='324.2224.00.1' and bi.lordem =1
20240314@183626.7319 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7323 chcjcdg84sp3qjodidetu1cflh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183626.7337 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7340 chcjcdg84sp3qjodidetu1cflh Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183626.7349 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7352 chcjcdg84sp3qjodidetu1cflh Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183626.7372 chcjcdg84sp3qjodidetu1cflh Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183626.7385 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7388 chcjcdg84sp3qjodidetu1cflh Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240314@183626.7398 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7401 chcjcdg84sp3qjodidetu1cflh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240314@183626.7411 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7413 chcjcdg84sp3qjodidetu1cflh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240314@183626.7424 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7426 chcjcdg84sp3qjodidetu1cflh Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240314@183626.7438 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.7441 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from td where ndoc = 39
20240314@183626.7452 chcjcdg84sp3qjodidetu1cflh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240314@183626.8594 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183626.8609 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240314@183626.8626 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183626.8639 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240314@183626.8663 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183626.8676 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240314@183626.8686 chcjcdg84sp3qjodidetu1cflh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183626.8824 chcjcdg84sp3qjodidetu1cflh Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183626.8834 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183626.8848 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240314@183626.8858 chcjcdg84sp3qjodidetu1cflh Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f340534865f343aad4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240314@183626.9073 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183626.9089 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240314@183626.9117 chcjcdg84sp3qjodidetu1cflh Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240314@183626.9122 chcjcdg84sp3qjodidetu1cflh Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240314@183626.9128 chcjcdg84sp3qjodidetu1cflh Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240314@183626.9133 chcjcdg84sp3qjodidetu1cflh Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240314@183626.9145 chcjcdg84sp3qjodidetu1cflh Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240314@183626.9150 chcjcdg84sp3qjodidetu1cflh Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240314@183626.9154 chcjcdg84sp3qjodidetu1cflh Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f340534865f343aad4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240314@183626.9439 chcjcdg84sp3qjodidetu1cflh Query : select top 1 fno valor from wsft039data order by fno desc
20240314@183626.9455 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183626.9471 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240314@183626.9491 chcjcdg84sp3qjodidetu1cflh Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65f340534865f343aad4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',465,100810,0,'2024-03-14',39,'euro',0,0,2024 ,'20240314','1906',?,?,?,?)
20240314@183626.9840 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183626.9852 chcjcdg84sp3qjodidetu1cflh Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240314@183626.9867 chcjcdg84sp3qjodidetu1cflh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2224.00.1'
20240314@183627.2400 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183627.3800 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183627.6200 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183627.7400 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183627.7900 chcjcdg84sp3qjodidetu1cflh Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20240314@183627.9500 chcjcdg84sp3qjodidetu1cflh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183627.1050 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183627.1180 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183627.1630 chcjcdg84sp3qjodidetu1cflh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f341865765f343ab02',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut65f340534865f343aad4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240314@183627.4430 chcjcdg84sp3qjodidetu1cflh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183627.4650 chcjcdg84sp3qjodidetu1cflh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183627.4690 chcjcdg84sp3qjodidetu1cflh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f341865765f343ab02','aut65f340534865f343aad4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183627.4730 chcjcdg84sp3qjodidetu1cflh Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f340534865f343aad4','2402131','wait',39,'ari17112337378,753000005')
20240314@183627.4930 chcjcdg84sp3qjodidetu1cflh Query : use flama_phc
20240314@183627.4960 chcjcdg84sp3qjodidetu1cflh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183627.5100 chcjcdg84sp3qjodidetu1cflh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='630';
20240314@183627.5460 chcjcdg84sp3qjodidetu1cflh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='630';
20240314@183627.5590 chcjcdg84sp3qjodidetu1cflh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='630';
20240314@183627.5710 chcjcdg84sp3qjodidetu1cflh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='630';
20240314@183627.1085 kg2456fdt14rudikb4mgrmmlq4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183627.1106 kg2456fdt14rudikb4mgrmmlq4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183627.1123 kg2456fdt14rudikb4mgrmmlq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='631';
20240314@183627.1163 kg2456fdt14rudikb4mgrmmlq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='631';
20240314@183627.1177 kg2456fdt14rudikb4mgrmmlq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='631';
20240314@183627.1192 kg2456fdt14rudikb4mgrmmlq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='631';
20240314@183627.1206 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1210 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183627.1222 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1226 kg2456fdt14rudikb4mgrmmlq4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240314@183627.1267 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20240314@183627.1483 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402132 and bi.ref ='324.4751.00.1' and bi.lordem =1
20240314@183627.1829 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20240314@183627.1843 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402132 and bi.ref ='324.4751.00.1' and bi.lordem =1
20240314@183627.1849 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1854 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183627.1867 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1870 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183627.1880 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1883 kg2456fdt14rudikb4mgrmmlq4 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183627.1893 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183627.1907 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1910 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240314@183627.1952 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1955 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240314@183627.1973 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1976 kg2456fdt14rudikb4mgrmmlq4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240314@183627.1986 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.1990 kg2456fdt14rudikb4mgrmmlq4 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240314@183627.2001 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.2004 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from td where ndoc = 39
20240314@183627.2014 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240314@183627.2026 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183627.2052 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240314@183627.2073 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183627.2099 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240314@183627.2208 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183627.2229 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240314@183627.2263 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183627.2382 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240314@183627.2402 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240314@183627.2432 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240314@183627.2444 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f349501165f343ab37' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240314@183627.2665 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240314@183627.2688 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240314@183627.2744 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240314@183627.2750 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240314@183627.2766 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240314@183627.2771 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240314@183627.2785 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240314@183627.2806 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240314@183627.2811 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f349501165f343ab37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240314@183627.3125 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 fno valor from wsft039data order by fno desc
20240314@183627.3144 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240314@183627.3158 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240314@183627.3205 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65f349501165f343ab37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',466,100810,0,'2024-03-14',39,'euro',0,0,2024 ,'20240314','1906',?,?,?,?)
20240314@183627.3557 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.3561 kg2456fdt14rudikb4mgrmmlq4 Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20240314@183627.3575 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4751.00.1'
20240314@183627.3757 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183627.3771 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183627.3807 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183627.3835 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183627.3840 kg2456fdt14rudikb4mgrmmlq4 Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2100594300a'
20240314@183627.3861 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183627.3871 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183627.3888 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183627.3920 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f349428165f343ab5e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65f349501165f343ab37' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240314@183627.4225 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183627.4242 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183627.4247 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f349428165f343ab5e','aut65f349501165f343ab37' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183627.4251 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.4254 kg2456fdt14rudikb4mgrmmlq4 Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20240314@183627.4280 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4751.00.1'
20240314@183627.4299 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183627.4313 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240314@183627.4336 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183627.4349 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240314@183627.4520 kg2456fdt14rudikb4mgrmmlq4 Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2100594300a'
20240314@183627.4642 kg2456fdt14rudikb4mgrmmlq4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240314@183627.4676 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240314@183627.4727 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240314@183627.4754 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f348082665f343ab72',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut65f349501165f343ab37' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240314@183627.5048 kg2456fdt14rudikb4mgrmmlq4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240314@183627.5066 kg2456fdt14rudikb4mgrmmlq4 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240314@183627.5071 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f348082665f343ab72','aut65f349501165f343ab37' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240314@183627.5076 kg2456fdt14rudikb4mgrmmlq4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f349501165f343ab37','2402132','wait',39,'ari17112337378,753000005')
20240314@183627.5111 kg2456fdt14rudikb4mgrmmlq4 Query : use flama_phc
20240314@183627.5122 kg2456fdt14rudikb4mgrmmlq4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240314@183627.5133 kg2456fdt14rudikb4mgrmmlq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='631';
20240314@183627.5159 kg2456fdt14rudikb4mgrmmlq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='631';
20240314@183627.5172 kg2456fdt14rudikb4mgrmmlq4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='631';
20240314@183627.5192 kg2456fdt14rudikb4mgrmmlq4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='631';
20240314@183627.5584 m2aqkt2mnab5npd84viopgmebs Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240314@183627.5599 m2aqkt2mnab5npd84viopgmebs Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240314@183627.5617 m2aqkt2mnab5npd84viopgmebs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='632';
20240314@183627.5660 m2aqkt2mnab5npd84viopgmebs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='632';
20240314@183627.5675 m2aqkt2mnab5npd84viopgmebs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='632';
20240314@183627.5697 m2aqkt2mnab5npd84viopgmebs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='632';
20240314@183627.5710 m2aqkt2mnab5npd84viopgmebs Query : use flama_phc
20240314@183627.5713 m2aqkt2mnab5npd84viopgmebs Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240314@183627.5735 m2aqkt2mnab5npd84viopgmebs Query : use flama_phc
20240314@183627.5738 m2aqkt2mnab5npd84viopgmebs Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240314@183627.5779 m2aqkt2mnab5npd84viopgmebs Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20240314@183627.5789 m2aqkt2mnab5npd84viopgmebs Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402133 and bi.ref ='324.497.00.01' and bi.lordem =1
20240314@183627.6147 m2aqkt2mnab5npd84viopgmebs Query : use flama_phc
20240314@183627.6150 m2aqkt2mnab5npd84viopgmebs Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240314@183627.6164 m2aqkt2mnab5npd84viopgmebs Query : use flama_phc
20240314@183627.6167 m2aqkt2mnab5npd84viopgmebs Query : select top 1 1 valor from td where td.ndoc = 39
20240314@183627.6193 m2aqkt2mnab5npd84viopgmebs Query : use flama_phc
20240314@183627.6207 m2aqkt2mnab5npd84viopgmebs Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240314@183627.6220 m2aqkt2mnab5npd84viopgmebs Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240314@183627.6241 m2aqkt2mnab5npd84viopgmebs Query : use flama_phc
20240314@183627.6263 m2aqkt2mnab5npd84viopgmebs Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240314@183627.6274 m2aqkt2mnab5npd84viopgmebs Query : use flama_phc
20240314@183627.6276 m2aqkt2mnab5npd84viopgmebs Query : select top 1 tipodoc,regrd from td where ndoc = 39
