20240619@123613.6255 ekht2cn886htbs7a5n1tc0p7cp Query : use flama_phc
20240619@123613.6261 ekht2cn886htbs7a5n1tc0p7cp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@123613.6294 ekht2cn886htbs7a5n1tc0p7cp Query : use flama_phc
20240619@123613.6298 ekht2cn886htbs7a5n1tc0p7cp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@131912.7949 l0ppnm1q5fifkijpff5a0dva2v Query : use flama_phc
20240619@131912.7954 l0ppnm1q5fifkijpff5a0dva2v Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@131912.7971 l0ppnm1q5fifkijpff5a0dva2v Query : use flama_phc
20240619@131912.7975 l0ppnm1q5fifkijpff5a0dva2v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@133612.8788 uca12rk2cccm6gnb2f0kj8nstb Query : use flama_phc
20240619@133612.8794 uca12rk2cccm6gnb2f0kj8nstb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@133612.8815 uca12rk2cccm6gnb2f0kj8nstb Query : use flama_phc
20240619@133612.8818 uca12rk2cccm6gnb2f0kj8nstb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@141919.1552 i2ji235qolhg620rp19tic0m3g Query : use flama_phc
20240619@141919.1557 i2ji235qolhg620rp19tic0m3g Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@141919.1575 i2ji235qolhg620rp19tic0m3g Query : use flama_phc
20240619@141919.1578 i2ji235qolhg620rp19tic0m3g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@143618.7806 k86a53muq7po1jj5ohcrcdehbp Query : use flama_phc
20240619@143618.7817 k86a53muq7po1jj5ohcrcdehbp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@143618.7836 k86a53muq7po1jj5ohcrcdehbp Query : use flama_phc
20240619@143618.7840 k86a53muq7po1jj5ohcrcdehbp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@151914.7896 hgjcf4a819jkcs1thkb6doe9q1 Query : use flama_phc
20240619@151914.7949 hgjcf4a819jkcs1thkb6doe9q1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@151914.8489 hgjcf4a819jkcs1thkb6doe9q1 Query : use flama_phc
20240619@151914.8527 hgjcf4a819jkcs1thkb6doe9q1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@153615.6560 0j2njpb47f794n4o90io0fksn5 Query : use flama_phc
20240619@153615.6620 0j2njpb47f794n4o90io0fksn5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@153615.7110 0j2njpb47f794n4o90io0fksn5 Query : use flama_phc
20240619@153615.7140 0j2njpb47f794n4o90io0fksn5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@161913.4601 t8vaunbp6r3m8hqj4u6k24ah1n Query : use flama_phc
20240619@161913.4607 t8vaunbp6r3m8hqj4u6k24ah1n Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@161913.4630 t8vaunbp6r3m8hqj4u6k24ah1n Query : use flama_phc
20240619@161913.4633 t8vaunbp6r3m8hqj4u6k24ah1n Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@163612.9910 5s5tem1uin135i6la497iigumi Query : use flama_phc
20240619@163612.9915 5s5tem1uin135i6la497iigumi Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@163612.9980 5s5tem1uin135i6la497iigumi Query : use flama_phc
20240619@163612.9983 5s5tem1uin135i6la497iigumi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@170638.6700 2he1l1abrtph6qojrgmfbhja6g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@170638.6736 2he1l1abrtph6qojrgmfbhja6g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@170638.6813 2he1l1abrtph6qojrgmfbhja6g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='475';
20240619@170638.6858 2he1l1abrtph6qojrgmfbhja6g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='475';
20240619@170638.6886 2he1l1abrtph6qojrgmfbhja6g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='475';
20240619@170638.6901 2he1l1abrtph6qojrgmfbhja6g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='475';
20240619@170638.6917 2he1l1abrtph6qojrgmfbhja6g Query : use flama_phc
20240619@170638.6920 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@170638.6984 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.945.00.01'
20240619@170638.7107 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400091 and bi.ref ='324.945.00.01' and bi.lordem =10000
20240619@170638.7480 2he1l1abrtph6qojrgmfbhja6g Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24012643824,476000003 ' 
20240619@170638.7823 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2907.00.1'
20240619@170638.7961 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400091 and bi.ref ='324.2907.00.1' and bi.lordem =20000
20240619@170638.8317 2he1l1abrtph6qojrgmfbhja6g Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24012643824,106000002 ' 
20240619@170638.8889 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.945.00.01'
20240619@170638.8902 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400091 and bi.ref ='324.945.00.01' and bi.lordem =10000
20240619@170638.8915 2he1l1abrtph6qojrgmfbhja6g Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24012643824,476000003 ' 
20240619@170638.8930 2he1l1abrtph6qojrgmfbhja6g Query : use flama_phc
20240619@170638.8934 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 1 valor from ts where ts.ndos = 5
20240619@170638.9030 2he1l1abrtph6qojrgmfbhja6g Query : use flama_phc
20240619@170638.9034 2he1l1abrtph6qojrgmfbhja6g Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@170638.9121 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240619@170638.9294 2he1l1abrtph6qojrgmfbhja6g Query : use flama_phc
20240619@170638.9298 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 ~inactivo valor from fl where no = '202190' and estab = 00 order by inactivo desc
20240619@170638.9408 2he1l1abrtph6qojrgmfbhja6g Query : use flama_phc
20240619@170638.9412 2he1l1abrtph6qojrgmfbhja6g Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -410
20240619@170638.9477 2he1l1abrtph6qojrgmfbhja6g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='475';
20240619@170638.9498 2he1l1abrtph6qojrgmfbhja6g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='475';
20240619@170639.5700 6rud2b11jumgf68uh19d0bjocf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@170639.7600 6rud2b11jumgf68uh19d0bjocf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@170639.9600 6rud2b11jumgf68uh19d0bjocf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='476';
20240619@170639.1430 6rud2b11jumgf68uh19d0bjocf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='476';
20240619@170639.1590 6rud2b11jumgf68uh19d0bjocf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='476';
20240619@170639.1760 6rud2b11jumgf68uh19d0bjocf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='476';
20240619@170639.1880 6rud2b11jumgf68uh19d0bjocf Query : use flama_phc
20240619@170639.1920 6rud2b11jumgf68uh19d0bjocf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@170639.2100 6rud2b11jumgf68uh19d0bjocf Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5500.00.1'
20240619@170639.3410 6rud2b11jumgf68uh19d0bjocf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400095 and bi.ref ='324.5500.00.1' and bi.lordem =60000
20240619@170639.7240 6rud2b11jumgf68uh19d0bjocf Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24012946789,196000002 ' 
20240619@170639.1100 6rud2b11jumgf68uh19d0bjocf Query : use flama_phc
20240619@170639.1103 6rud2b11jumgf68uh19d0bjocf Query : select top 1 1 valor from ts where ts.ndos = 5
20240619@170639.1116 6rud2b11jumgf68uh19d0bjocf Query : use flama_phc
20240619@170639.1119 6rud2b11jumgf68uh19d0bjocf Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@170639.1140 6rud2b11jumgf68uh19d0bjocf Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240619@170639.1157 6rud2b11jumgf68uh19d0bjocf Query : use flama_phc
20240619@170639.1160 6rud2b11jumgf68uh19d0bjocf Query : select top 1 ~inactivo valor from fl where no = '202544' and estab = 00 order by inactivo desc
20240619@170639.1255 6rud2b11jumgf68uh19d0bjocf Query : use flama_phc
20240619@170639.1258 6rud2b11jumgf68uh19d0bjocf Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -410
20240619@170639.1270 6rud2b11jumgf68uh19d0bjocf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='476';
20240619@170639.1286 6rud2b11jumgf68uh19d0bjocf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='476';
20240619@171914.1286 83hi106chk2ai4kur368j7ioim Query : use flama_phc
20240619@171914.1291 83hi106chk2ai4kur368j7ioim Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@171914.1312 83hi106chk2ai4kur368j7ioim Query : use flama_phc
20240619@171914.1315 83hi106chk2ai4kur368j7ioim Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@173614.2136 bsfparh4eimk6pu0447g8h3vvh Query : use flama_phc
20240619@173614.2143 bsfparh4eimk6pu0447g8h3vvh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@173614.2170 bsfparh4eimk6pu0447g8h3vvh Query : use flama_phc
20240619@173614.2173 bsfparh4eimk6pu0447g8h3vvh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@180716.4332 8j3akarro81lsfl47ptjtel8d9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180716.4359 8j3akarro81lsfl47ptjtel8d9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180716.4401 8j3akarro81lsfl47ptjtel8d9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='477';
20240619@180716.4435 8j3akarro81lsfl47ptjtel8d9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='477';
20240619@180716.4459 8j3akarro81lsfl47ptjtel8d9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='477';
20240619@180716.4472 8j3akarro81lsfl47ptjtel8d9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='477';
20240619@180716.4484 8j3akarro81lsfl47ptjtel8d9 Query : use flama_phc
20240619@180716.4487 8j3akarro81lsfl47ptjtel8d9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180716.4534 8j3akarro81lsfl47ptjtel8d9 Query : use flama_phc
20240619@180716.4537 8j3akarro81lsfl47ptjtel8d9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20240619@180716.4607 8j3akarro81lsfl47ptjtel8d9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240619@180716.4751 8j3akarro81lsfl47ptjtel8d9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20240619@180716.4888 8j3akarro81lsfl47ptjtel8d9 Query : use flama_phc
20240619@180716.4891 8j3akarro81lsfl47ptjtel8d9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180716.5062 8j3akarro81lsfl47ptjtel8d9 Query : use flama_phc
20240619@180716.5065 8j3akarro81lsfl47ptjtel8d9 Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180716.5141 8j3akarro81lsfl47ptjtel8d9 Query : use flama_phc
20240619@180716.5144 8j3akarro81lsfl47ptjtel8d9 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180716.5980 kgvjkogq1d0bgtdnn6pedpupk4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180716.5993 kgvjkogq1d0bgtdnn6pedpupk4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180716.6012 kgvjkogq1d0bgtdnn6pedpupk4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='478';
20240619@180716.6052 kgvjkogq1d0bgtdnn6pedpupk4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='478';
20240619@180716.6064 kgvjkogq1d0bgtdnn6pedpupk4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='478';
20240619@180716.6076 kgvjkogq1d0bgtdnn6pedpupk4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='478';
20240619@180716.6087 kgvjkogq1d0bgtdnn6pedpupk4 Query : use flama_phc
20240619@180716.6090 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180716.6104 kgvjkogq1d0bgtdnn6pedpupk4 Query : use flama_phc
20240619@180716.6107 kgvjkogq1d0bgtdnn6pedpupk4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20240619@180716.6136 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6280 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6289 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6300 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6311 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6322 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6333 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6344 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6354 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6364 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180716.6374 kgvjkogq1d0bgtdnn6pedpupk4 Query : use flama_phc
20240619@180716.6377 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180716.6391 kgvjkogq1d0bgtdnn6pedpupk4 Query : use flama_phc
20240619@180716.7511 kgvjkogq1d0bgtdnn6pedpupk4 Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180716.7523 kgvjkogq1d0bgtdnn6pedpupk4 Query : use flama_phc
20240619@180716.7526 kgvjkogq1d0bgtdnn6pedpupk4 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180716.8037 uo97584b9ubd9ugu0jf3ch87u7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180716.8052 uo97584b9ubd9ugu0jf3ch87u7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180716.8068 uo97584b9ubd9ugu0jf3ch87u7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='479';
20240619@180716.8105 uo97584b9ubd9ugu0jf3ch87u7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='479';
20240619@180716.8118 uo97584b9ubd9ugu0jf3ch87u7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='479';
20240619@180716.8131 uo97584b9ubd9ugu0jf3ch87u7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='479';
20240619@180716.8146 uo97584b9ubd9ugu0jf3ch87u7 Query : use flama_phc
20240619@180716.8149 uo97584b9ubd9ugu0jf3ch87u7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180716.8164 uo97584b9ubd9ugu0jf3ch87u7 Query : use flama_phc
20240619@180716.8167 uo97584b9ubd9ugu0jf3ch87u7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=5546
20240619@180716.8238 uo97584b9ubd9ugu0jf3ch87u7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2223.00.1'
20240619@180716.8463 uo97584b9ubd9ugu0jf3ch87u7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2223.00.1'
20240619@180716.8473 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8616 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8626 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8774 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8784 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8794 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8804 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8813 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8963 uo97584b9ubd9ugu0jf3ch87u7 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'
20240619@180716.8974 uo97584b9ubd9ugu0jf3ch87u7 Query : use flama_phc
20240619@180716.8977 uo97584b9ubd9ugu0jf3ch87u7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180716.8990 uo97584b9ubd9ugu0jf3ch87u7 Query : use flama_phc
20240619@180716.8993 uo97584b9ubd9ugu0jf3ch87u7 Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180716.9004 uo97584b9ubd9ugu0jf3ch87u7 Query : use flama_phc
20240619@180716.9007 uo97584b9ubd9ugu0jf3ch87u7 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180716.9502 poggaa5bbj6885n0goiv534qts Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180716.9516 poggaa5bbj6885n0goiv534qts Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180716.9540 poggaa5bbj6885n0goiv534qts Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='480';
20240619@180716.9588 poggaa5bbj6885n0goiv534qts Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='480';
20240619@180716.9602 poggaa5bbj6885n0goiv534qts Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='480';
20240619@180716.9616 poggaa5bbj6885n0goiv534qts Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='480';
20240619@180716.9628 poggaa5bbj6885n0goiv534qts Query : use flama_phc
20240619@180716.9631 poggaa5bbj6885n0goiv534qts Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180716.9646 poggaa5bbj6885n0goiv534qts Query : use flama_phc
20240619@180716.9649 poggaa5bbj6885n0goiv534qts Query : select no, estab,szadrsdesc from szadrs where u_coddest=4804
20240619@180716.9730 poggaa5bbj6885n0goiv534qts Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240619@180716.9951 poggaa5bbj6885n0goiv534qts Query : use flama_phc
20240619@180716.9955 poggaa5bbj6885n0goiv534qts Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180716.9969 poggaa5bbj6885n0goiv534qts Query : use flama_phc
20240619@180716.9972 poggaa5bbj6885n0goiv534qts Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180716.9984 poggaa5bbj6885n0goiv534qts Query : use flama_phc
20240619@180716.9987 poggaa5bbj6885n0goiv534qts Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180717.4940 g4f8cpfp0fpq3cgjjlr3thos4f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180717.5070 g4f8cpfp0fpq3cgjjlr3thos4f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180717.5230 g4f8cpfp0fpq3cgjjlr3thos4f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='481';
20240619@180717.5680 g4f8cpfp0fpq3cgjjlr3thos4f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='481';
20240619@180717.5810 g4f8cpfp0fpq3cgjjlr3thos4f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='481';
20240619@180717.5940 g4f8cpfp0fpq3cgjjlr3thos4f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='481';
20240619@180717.6070 g4f8cpfp0fpq3cgjjlr3thos4f Query : use flama_phc
20240619@180717.6110 g4f8cpfp0fpq3cgjjlr3thos4f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180717.6260 g4f8cpfp0fpq3cgjjlr3thos4f Query : use flama_phc
20240619@180717.6290 g4f8cpfp0fpq3cgjjlr3thos4f Query : select no, estab,szadrsdesc from szadrs where u_coddest=3674
20240619@180717.1808 g4f8cpfp0fpq3cgjjlr3thos4f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240619@180717.2069 g4f8cpfp0fpq3cgjjlr3thos4f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240619@180717.2082 g4f8cpfp0fpq3cgjjlr3thos4f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5501.00.1'
20240619@180717.2252 g4f8cpfp0fpq3cgjjlr3thos4f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5501.00.1'
20240619@180717.2263 g4f8cpfp0fpq3cgjjlr3thos4f Query : use flama_phc
20240619@180717.2266 g4f8cpfp0fpq3cgjjlr3thos4f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180717.2283 g4f8cpfp0fpq3cgjjlr3thos4f Query : use flama_phc
20240619@180717.2286 g4f8cpfp0fpq3cgjjlr3thos4f Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180717.2297 g4f8cpfp0fpq3cgjjlr3thos4f Query : use flama_phc
20240619@180717.2299 g4f8cpfp0fpq3cgjjlr3thos4f Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180717.2807 cfjm4ut214le6b5n4eu75qipm3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180717.2820 cfjm4ut214le6b5n4eu75qipm3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180717.2836 cfjm4ut214le6b5n4eu75qipm3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='482';
20240619@180717.2882 cfjm4ut214le6b5n4eu75qipm3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='482';
20240619@180717.2895 cfjm4ut214le6b5n4eu75qipm3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='482';
20240619@180717.2908 cfjm4ut214le6b5n4eu75qipm3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='482';
20240619@180717.2920 cfjm4ut214le6b5n4eu75qipm3 Query : use flama_phc
20240619@180717.2922 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180717.2936 cfjm4ut214le6b5n4eu75qipm3 Query : use flama_phc
20240619@180717.2939 cfjm4ut214le6b5n4eu75qipm3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4385
20240619@180717.3030 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20240619@180717.3182 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1405.00.1'
20240619@180717.3362 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240619@180717.3373 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1716.00.1'
20240619@180717.3519 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240619@180717.3655 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.367.09.00'
20240619@180717.3794 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240619@180717.3931 cfjm4ut214le6b5n4eu75qipm3 Query : use flama_phc
20240619@180717.3934 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180717.3948 cfjm4ut214le6b5n4eu75qipm3 Query : use flama_phc
20240619@180717.3951 cfjm4ut214le6b5n4eu75qipm3 Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180717.3963 cfjm4ut214le6b5n4eu75qipm3 Query : use flama_phc
20240619@180717.3965 cfjm4ut214le6b5n4eu75qipm3 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180717.4526 iu65kic3c5p9f3ir5js1n2e4q1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180717.4544 iu65kic3c5p9f3ir5js1n2e4q1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180717.4562 iu65kic3c5p9f3ir5js1n2e4q1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='483';
20240619@180717.4602 iu65kic3c5p9f3ir5js1n2e4q1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='483';
20240619@180717.4615 iu65kic3c5p9f3ir5js1n2e4q1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='483';
20240619@180717.4627 iu65kic3c5p9f3ir5js1n2e4q1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='483';
20240619@180717.4638 iu65kic3c5p9f3ir5js1n2e4q1 Query : use flama_phc
20240619@180717.4641 iu65kic3c5p9f3ir5js1n2e4q1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180717.4655 iu65kic3c5p9f3ir5js1n2e4q1 Query : use flama_phc
20240619@180717.4658 iu65kic3c5p9f3ir5js1n2e4q1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1403
20240619@180717.4734 iu65kic3c5p9f3ir5js1n2e4q1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20240619@180717.4878 iu65kic3c5p9f3ir5js1n2e4q1 Query : use flama_phc
20240619@180717.4881 iu65kic3c5p9f3ir5js1n2e4q1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180717.4894 iu65kic3c5p9f3ir5js1n2e4q1 Query : use flama_phc
20240619@180717.4897 iu65kic3c5p9f3ir5js1n2e4q1 Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180717.4908 iu65kic3c5p9f3ir5js1n2e4q1 Query : use flama_phc
20240619@180717.4911 iu65kic3c5p9f3ir5js1n2e4q1 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180717.5428 2dbk0bpdi7slmhc7lbktscna6v Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180717.5440 2dbk0bpdi7slmhc7lbktscna6v Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180717.5456 2dbk0bpdi7slmhc7lbktscna6v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='484';
20240619@180717.5494 2dbk0bpdi7slmhc7lbktscna6v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='484';
20240619@180717.5506 2dbk0bpdi7slmhc7lbktscna6v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='484';
20240619@180717.5518 2dbk0bpdi7slmhc7lbktscna6v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='484';
20240619@180717.5530 2dbk0bpdi7slmhc7lbktscna6v Query : use flama_phc
20240619@180717.5533 2dbk0bpdi7slmhc7lbktscna6v Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180717.5546 2dbk0bpdi7slmhc7lbktscna6v Query : use flama_phc
20240619@180717.5549 2dbk0bpdi7slmhc7lbktscna6v Query : select no, estab,szadrsdesc from szadrs where u_coddest=2270
20240619@180717.5623 2dbk0bpdi7slmhc7lbktscna6v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180717.5633 2dbk0bpdi7slmhc7lbktscna6v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240619@180717.5644 2dbk0bpdi7slmhc7lbktscna6v Query : use flama_phc
20240619@180717.5647 2dbk0bpdi7slmhc7lbktscna6v Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180717.5660 2dbk0bpdi7slmhc7lbktscna6v Query : use flama_phc
20240619@180717.5663 2dbk0bpdi7slmhc7lbktscna6v Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180717.5674 2dbk0bpdi7slmhc7lbktscna6v Query : use flama_phc
20240619@180717.5677 2dbk0bpdi7slmhc7lbktscna6v Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180717.6184 pqb43ivuqm40pcp175f0q6a6uo Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180717.6197 pqb43ivuqm40pcp175f0q6a6uo Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180717.6214 pqb43ivuqm40pcp175f0q6a6uo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='485';
20240619@180717.6254 pqb43ivuqm40pcp175f0q6a6uo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='485';
20240619@180717.6268 pqb43ivuqm40pcp175f0q6a6uo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='485';
20240619@180717.6279 pqb43ivuqm40pcp175f0q6a6uo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='485';
20240619@180717.6291 pqb43ivuqm40pcp175f0q6a6uo Query : use flama_phc
20240619@180717.6294 pqb43ivuqm40pcp175f0q6a6uo Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180717.6307 pqb43ivuqm40pcp175f0q6a6uo Query : use flama_phc
20240619@180717.6310 pqb43ivuqm40pcp175f0q6a6uo Query : select no, estab,szadrsdesc from szadrs where u_coddest=634
20240619@180717.6380 pqb43ivuqm40pcp175f0q6a6uo Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240619@180717.7631 pqb43ivuqm40pcp175f0q6a6uo Query : use flama_phc
20240619@180717.7636 pqb43ivuqm40pcp175f0q6a6uo Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180717.7650 pqb43ivuqm40pcp175f0q6a6uo Query : use flama_phc
20240619@180717.7653 pqb43ivuqm40pcp175f0q6a6uo Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180717.7663 pqb43ivuqm40pcp175f0q6a6uo Query : use flama_phc
20240619@180717.7665 pqb43ivuqm40pcp175f0q6a6uo Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180717.8654 c5tfr75ef02op6eihkgapv7ggr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180717.8667 c5tfr75ef02op6eihkgapv7ggr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180717.8684 c5tfr75ef02op6eihkgapv7ggr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='486';
20240619@180717.8735 c5tfr75ef02op6eihkgapv7ggr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='486';
20240619@180717.8749 c5tfr75ef02op6eihkgapv7ggr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='486';
20240619@180717.8761 c5tfr75ef02op6eihkgapv7ggr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='486';
20240619@180717.8773 c5tfr75ef02op6eihkgapv7ggr Query : use flama_phc
20240619@180717.8776 c5tfr75ef02op6eihkgapv7ggr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180717.8791 c5tfr75ef02op6eihkgapv7ggr Query : use flama_phc
20240619@180717.8794 c5tfr75ef02op6eihkgapv7ggr Query : select no, estab,szadrsdesc from szadrs where u_coddest=908
20240619@180717.8866 c5tfr75ef02op6eihkgapv7ggr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240619@180717.8877 c5tfr75ef02op6eihkgapv7ggr Query : use flama_phc
20240619@180717.8880 c5tfr75ef02op6eihkgapv7ggr Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180717.8893 c5tfr75ef02op6eihkgapv7ggr Query : use flama_phc
20240619@180717.8896 c5tfr75ef02op6eihkgapv7ggr Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180717.8906 c5tfr75ef02op6eihkgapv7ggr Query : use flama_phc
20240619@180717.8909 c5tfr75ef02op6eihkgapv7ggr Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180717.9416 a5ppml52jhbrqdrpqa8e93qb2c Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180717.9429 a5ppml52jhbrqdrpqa8e93qb2c Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180717.9447 a5ppml52jhbrqdrpqa8e93qb2c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='487';
20240619@180717.9487 a5ppml52jhbrqdrpqa8e93qb2c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='487';
20240619@180717.9500 a5ppml52jhbrqdrpqa8e93qb2c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='487';
20240619@180717.9512 a5ppml52jhbrqdrpqa8e93qb2c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='487';
20240619@180717.9524 a5ppml52jhbrqdrpqa8e93qb2c Query : use flama_phc
20240619@180717.9527 a5ppml52jhbrqdrpqa8e93qb2c Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180717.9544 a5ppml52jhbrqdrpqa8e93qb2c Query : use flama_phc
20240619@180717.9547 a5ppml52jhbrqdrpqa8e93qb2c Query : select no, estab,szadrsdesc from szadrs where u_coddest=3674
20240619@180717.9579 a5ppml52jhbrqdrpqa8e93qb2c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20240619@180717.9730 a5ppml52jhbrqdrpqa8e93qb2c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20240619@180717.9740 a5ppml52jhbrqdrpqa8e93qb2c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4724.00.1'
20240619@180717.9884 a5ppml52jhbrqdrpqa8e93qb2c Query : use flama_phc
20240619@180717.9887 a5ppml52jhbrqdrpqa8e93qb2c Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180717.9904 a5ppml52jhbrqdrpqa8e93qb2c Query : use flama_phc
20240619@180717.9907 a5ppml52jhbrqdrpqa8e93qb2c Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180717.9918 a5ppml52jhbrqdrpqa8e93qb2c Query : use flama_phc
20240619@180717.9920 a5ppml52jhbrqdrpqa8e93qb2c Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180718.2089 1vep5jcks2qkdqleddil61rkcm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180718.2102 1vep5jcks2qkdqleddil61rkcm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180718.2119 1vep5jcks2qkdqleddil61rkcm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='488';
20240619@180718.2158 1vep5jcks2qkdqleddil61rkcm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='488';
20240619@180718.2171 1vep5jcks2qkdqleddil61rkcm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='488';
20240619@180718.2184 1vep5jcks2qkdqleddil61rkcm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='488';
20240619@180718.2195 1vep5jcks2qkdqleddil61rkcm Query : use flama_phc
20240619@180718.2198 1vep5jcks2qkdqleddil61rkcm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180718.2212 1vep5jcks2qkdqleddil61rkcm Query : use flama_phc
20240619@180718.2215 1vep5jcks2qkdqleddil61rkcm Query : select no, estab,szadrsdesc from szadrs where u_coddest=201
20240619@180718.2289 1vep5jcks2qkdqleddil61rkcm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240619@180718.2300 1vep5jcks2qkdqleddil61rkcm Query : use flama_phc
20240619@180718.2303 1vep5jcks2qkdqleddil61rkcm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180718.2315 1vep5jcks2qkdqleddil61rkcm Query : use flama_phc
20240619@180718.2318 1vep5jcks2qkdqleddil61rkcm Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180718.2329 1vep5jcks2qkdqleddil61rkcm Query : use flama_phc
20240619@180718.2331 1vep5jcks2qkdqleddil61rkcm Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180718.2888 828sgv7ijusqv9o5nr8ddobagn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180718.2902 828sgv7ijusqv9o5nr8ddobagn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180718.2935 828sgv7ijusqv9o5nr8ddobagn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='489';
20240619@180718.2979 828sgv7ijusqv9o5nr8ddobagn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='489';
20240619@180718.2992 828sgv7ijusqv9o5nr8ddobagn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='489';
20240619@180718.3005 828sgv7ijusqv9o5nr8ddobagn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='489';
20240619@180718.3017 828sgv7ijusqv9o5nr8ddobagn Query : use flama_phc
20240619@180718.3020 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180718.3034 828sgv7ijusqv9o5nr8ddobagn Query : use flama_phc
20240619@180718.3037 828sgv7ijusqv9o5nr8ddobagn Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20240619@180718.3110 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240619@180718.4351 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.2185.00.1'
20240619@180718.5180 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.2187.00.1'
20240619@180718.5627 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20240619@180718.5818 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.658.00.01'
20240619@180718.5966 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.658.00.01'
20240619@180718.5976 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.658.00.01'
20240619@180718.5986 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.658.00.01'
20240619@180718.5997 828sgv7ijusqv9o5nr8ddobagn Query : use flama_phc
20240619@180718.6000 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180718.6013 828sgv7ijusqv9o5nr8ddobagn Query : use flama_phc
20240619@180718.6016 828sgv7ijusqv9o5nr8ddobagn Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180718.6026 828sgv7ijusqv9o5nr8ddobagn Query : use flama_phc
20240619@180718.6029 828sgv7ijusqv9o5nr8ddobagn Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180718.6529 8bj4tdnmtq65gcnfj1t74qjhku Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180718.6542 8bj4tdnmtq65gcnfj1t74qjhku Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180718.6558 8bj4tdnmtq65gcnfj1t74qjhku Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='490';
20240619@180718.6599 8bj4tdnmtq65gcnfj1t74qjhku Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='490';
20240619@180718.6612 8bj4tdnmtq65gcnfj1t74qjhku Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='490';
20240619@180718.6626 8bj4tdnmtq65gcnfj1t74qjhku Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='490';
20240619@180718.6640 8bj4tdnmtq65gcnfj1t74qjhku Query : use flama_phc
20240619@180718.6643 8bj4tdnmtq65gcnfj1t74qjhku Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180718.6658 8bj4tdnmtq65gcnfj1t74qjhku Query : use flama_phc
20240619@180718.6661 8bj4tdnmtq65gcnfj1t74qjhku Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240619@180718.6733 8bj4tdnmtq65gcnfj1t74qjhku Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9326.00.1'
20240619@180718.6883 8bj4tdnmtq65gcnfj1t74qjhku Query : use flama_phc
20240619@180718.6886 8bj4tdnmtq65gcnfj1t74qjhku Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180718.6899 8bj4tdnmtq65gcnfj1t74qjhku Query : use flama_phc
20240619@180718.6902 8bj4tdnmtq65gcnfj1t74qjhku Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180718.6913 8bj4tdnmtq65gcnfj1t74qjhku Query : use flama_phc
20240619@180718.6916 8bj4tdnmtq65gcnfj1t74qjhku Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180718.7387 oslcbg083cuhocl3jcmp72i1no Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180718.7403 oslcbg083cuhocl3jcmp72i1no Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180718.7420 oslcbg083cuhocl3jcmp72i1no Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='491';
20240619@180718.9365 oslcbg083cuhocl3jcmp72i1no Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='491';
20240619@180718.9381 oslcbg083cuhocl3jcmp72i1no Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='491';
20240619@180718.9395 oslcbg083cuhocl3jcmp72i1no Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='491';
20240619@180718.9407 oslcbg083cuhocl3jcmp72i1no Query : use flama_phc
20240619@180718.9410 oslcbg083cuhocl3jcmp72i1no Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180718.9424 oslcbg083cuhocl3jcmp72i1no Query : use flama_phc
20240619@180718.9427 oslcbg083cuhocl3jcmp72i1no Query : select no, estab,szadrsdesc from szadrs where u_coddest=2461
20240619@180718.9500 oslcbg083cuhocl3jcmp72i1no Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240619@180718.9510 oslcbg083cuhocl3jcmp72i1no Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240619@180718.9519 oslcbg083cuhocl3jcmp72i1no Query : use flama_phc
20240619@180718.9522 oslcbg083cuhocl3jcmp72i1no Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180718.9537 oslcbg083cuhocl3jcmp72i1no Query : use flama_phc
20240619@180718.9539 oslcbg083cuhocl3jcmp72i1no Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180718.9550 oslcbg083cuhocl3jcmp72i1no Query : use flama_phc
20240619@180718.9552 oslcbg083cuhocl3jcmp72i1no Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180719.5300 d95kc4qog4homnt2rmn8hd7678 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180719.6500 d95kc4qog4homnt2rmn8hd7678 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180719.8100 d95kc4qog4homnt2rmn8hd7678 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='492';
20240619@180719.1190 d95kc4qog4homnt2rmn8hd7678 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='492';
20240619@180719.1320 d95kc4qog4homnt2rmn8hd7678 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='492';
20240619@180719.1430 d95kc4qog4homnt2rmn8hd7678 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='492';
20240619@180719.1550 d95kc4qog4homnt2rmn8hd7678 Query : use flama_phc
20240619@180719.1580 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180719.1730 d95kc4qog4homnt2rmn8hd7678 Query : use flama_phc
20240619@180719.1760 d95kc4qog4homnt2rmn8hd7678 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20240619@180719.2060 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.3530 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.3640 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.3740 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.3840 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.3930 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.4020 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.4120 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.4420 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.4520 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.4620 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240619@180719.4720 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.6340 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.6430 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.6520 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.6630 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.6730 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.6820 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.6910 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.7000 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240619@180719.7100 d95kc4qog4homnt2rmn8hd7678 Query : use flama_phc
20240619@180719.7130 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180719.7250 d95kc4qog4homnt2rmn8hd7678 Query : use flama_phc
20240619@180719.7280 d95kc4qog4homnt2rmn8hd7678 Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180719.7400 d95kc4qog4homnt2rmn8hd7678 Query : use flama_phc
20240619@180719.7430 d95kc4qog4homnt2rmn8hd7678 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@180719.2056 skbn12ik06n9288mqefd31ntnn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@180719.2071 skbn12ik06n9288mqefd31ntnn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@180719.2088 skbn12ik06n9288mqefd31ntnn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='493';
20240619@180719.2127 skbn12ik06n9288mqefd31ntnn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='493';
20240619@180719.2140 skbn12ik06n9288mqefd31ntnn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='493';
20240619@180719.2152 skbn12ik06n9288mqefd31ntnn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='493';
20240619@180719.2164 skbn12ik06n9288mqefd31ntnn Query : use flama_phc
20240619@180719.2168 skbn12ik06n9288mqefd31ntnn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@180719.2183 skbn12ik06n9288mqefd31ntnn Query : use flama_phc
20240619@180719.2186 skbn12ik06n9288mqefd31ntnn Query : select no, estab,szadrsdesc from szadrs where u_coddest=2881
20240619@180719.2256 skbn12ik06n9288mqefd31ntnn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240619@180719.2268 skbn12ik06n9288mqefd31ntnn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240619@180719.2278 skbn12ik06n9288mqefd31ntnn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20240619@180719.2427 skbn12ik06n9288mqefd31ntnn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20240619@180719.2439 skbn12ik06n9288mqefd31ntnn Query : use flama_phc
20240619@180719.2442 skbn12ik06n9288mqefd31ntnn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240619@180719.2456 skbn12ik06n9288mqefd31ntnn Query : use flama_phc
20240619@180719.2459 skbn12ik06n9288mqefd31ntnn Query : select top 1 1 valor from td where td.ndoc = 39
20240619@180719.2471 skbn12ik06n9288mqefd31ntnn Query : use flama_phc
20240619@180719.2474 skbn12ik06n9288mqefd31ntnn Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@181915.1596 0jgk8p00mi1aibsmln2e3ocrrs Query : use flama_phc
20240619@181915.1601 0jgk8p00mi1aibsmln2e3ocrrs Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@181915.1622 0jgk8p00mi1aibsmln2e3ocrrs Query : use flama_phc
20240619@181915.1627 0jgk8p00mi1aibsmln2e3ocrrs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@182153.9750 97q06pjqtok1eb48f3qie2hbs1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240619@182153.9765 97q06pjqtok1eb48f3qie2hbs1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240619@182153.9783 97q06pjqtok1eb48f3qie2hbs1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='494';
20240619@182153.9822 97q06pjqtok1eb48f3qie2hbs1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='494';
20240619@182153.9836 97q06pjqtok1eb48f3qie2hbs1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='494';
20240619@182153.9848 97q06pjqtok1eb48f3qie2hbs1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='494';
20240619@182153.9861 97q06pjqtok1eb48f3qie2hbs1 Query : use flama_phc
20240619@182153.9864 97q06pjqtok1eb48f3qie2hbs1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240619@182153.9880 97q06pjqtok1eb48f3qie2hbs1 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.682.00.01'
20240619@182153.9992 97q06pjqtok1eb48f3qie2hbs1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400060 and bi.ref ='324.682.00.01' and bi.lordem =20000
20240619@182154.3290 97q06pjqtok1eb48f3qie2hbs1 Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24011556048,411000002 ' 
20240619@182154.7010 97q06pjqtok1eb48f3qie2hbs1 Query : use flama_phc
20240619@182154.7040 97q06pjqtok1eb48f3qie2hbs1 Query : select top 1 1 valor from ts where ts.ndos = 5
20240619@182154.7780 97q06pjqtok1eb48f3qie2hbs1 Query : use flama_phc
20240619@182154.7810 97q06pjqtok1eb48f3qie2hbs1 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240619@182154.8000 97q06pjqtok1eb48f3qie2hbs1 Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240619@182154.9350 97q06pjqtok1eb48f3qie2hbs1 Query : use flama_phc
20240619@182154.9380 97q06pjqtok1eb48f3qie2hbs1 Query : select top 1 ~inactivo valor from fl where no = '202090' and estab = 00 order by inactivo desc
20240619@182154.1030 97q06pjqtok1eb48f3qie2hbs1 Query : use flama_phc
20240619@182154.1033 97q06pjqtok1eb48f3qie2hbs1 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -410
20240619@182154.1068 97q06pjqtok1eb48f3qie2hbs1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='494';
20240619@182154.1082 97q06pjqtok1eb48f3qie2hbs1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='494';
20240619@183615.6964 alt7037lvc5442prrdtqaj1lg9 Query : use flama_phc
20240619@183615.6969 alt7037lvc5442prrdtqaj1lg9 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@183615.7023 alt7037lvc5442prrdtqaj1lg9 Query : use flama_phc
20240619@183615.7026 alt7037lvc5442prrdtqaj1lg9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@191922.3589 jf6gnp1jb6pjhkrpbe0lvglf2e Query : use flama_phc
20240619@191922.3593 jf6gnp1jb6pjhkrpbe0lvglf2e Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@191922.3611 jf6gnp1jb6pjhkrpbe0lvglf2e Query : use flama_phc
20240619@191922.3614 jf6gnp1jb6pjhkrpbe0lvglf2e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@193621.9716 of217jlashcbtu8bcr887lap0i Query : use flama_phc
20240619@193621.9720 of217jlashcbtu8bcr887lap0i Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@193621.9737 of217jlashcbtu8bcr887lap0i Query : use flama_phc
20240619@193621.9740 of217jlashcbtu8bcr887lap0i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@201918.9628 sb6pqq4lde2qljbcpgvbsp9sd1 Query : use flama_phc
20240619@201918.9632 sb6pqq4lde2qljbcpgvbsp9sd1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@201918.9649 sb6pqq4lde2qljbcpgvbsp9sd1 Query : use flama_phc
20240619@201918.9652 sb6pqq4lde2qljbcpgvbsp9sd1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@203618.6139 45481gqqr9obbumqafc68lmmtu Query : use flama_phc
20240619@203618.6145 45481gqqr9obbumqafc68lmmtu Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@203618.6165 45481gqqr9obbumqafc68lmmtu Query : use flama_phc
20240619@203618.6170 45481gqqr9obbumqafc68lmmtu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@211916.6033 17padnfeohi4aov29ivotgltgm Query : use flama_phc
20240619@211916.6038 17padnfeohi4aov29ivotgltgm Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@211916.6056 17padnfeohi4aov29ivotgltgm Query : use flama_phc
20240619@211916.6060 17padnfeohi4aov29ivotgltgm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@213616.6421 cjev2gjiheq9fe837900qtm1ef Query : use flama_phc
20240619@213616.6425 cjev2gjiheq9fe837900qtm1ef Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@213616.6443 cjev2gjiheq9fe837900qtm1ef Query : use flama_phc
20240619@213616.6445 cjev2gjiheq9fe837900qtm1ef Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@221914.2263 76bfl9ra4232a07fmbkk9ueqre Query : use flama_phc
20240619@221914.2267 76bfl9ra4232a07fmbkk9ueqre Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@221914.2286 76bfl9ra4232a07fmbkk9ueqre Query : use flama_phc
20240619@221914.2289 76bfl9ra4232a07fmbkk9ueqre Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@223614.4773 kc90g5kl0f95rcuv3rfrnim69p Query : use flama_phc
20240619@223614.4778 kc90g5kl0f95rcuv3rfrnim69p Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@223614.4796 kc90g5kl0f95rcuv3rfrnim69p Query : use flama_phc
20240619@223614.4799 kc90g5kl0f95rcuv3rfrnim69p Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@231921.6525 cck9sp46hc4il4tst00h7vrl61 Query : use flama_phc
20240619@231921.6530 cck9sp46hc4il4tst00h7vrl61 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@231921.6555 cck9sp46hc4il4tst00h7vrl61 Query : use flama_phc
20240619@231921.6557 cck9sp46hc4il4tst00h7vrl61 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240619@233621.3244 7fameuic92llipu7a7k6lj9v37 Query : use flama_phc
20240619@233621.3250 7fameuic92llipu7a7k6lj9v37 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240619@233621.3269 7fameuic92llipu7a7k6lj9v37 Query : use flama_phc
20240619@233621.3272 7fameuic92llipu7a7k6lj9v37 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@071915.6857 jncvco98etnpvetm4vaaum4l86 Query : use flama_phc
20240620@071915.6868 jncvco98etnpvetm4vaaum4l86 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@071915.7000 jncvco98etnpvetm4vaaum4l86 Query : use flama_phc
20240620@071915.7003 jncvco98etnpvetm4vaaum4l86 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@073615.2721 r5pq9a8nigj4927s58lfc4d3ib Query : use flama_phc
20240620@073615.2729 r5pq9a8nigj4927s58lfc4d3ib Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@073615.2803 r5pq9a8nigj4927s58lfc4d3ib Query : use flama_phc
20240620@073615.2806 r5pq9a8nigj4927s58lfc4d3ib Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@081913.7269 m1s678hlbb86i01t1612k2q6t6 Query : use flama_phc
20240620@081913.7280 m1s678hlbb86i01t1612k2q6t6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@081913.7342 m1s678hlbb86i01t1612k2q6t6 Query : use flama_phc
20240620@081913.7345 m1s678hlbb86i01t1612k2q6t6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@083614.7950 tts925oi3p4hnoesvbv6bu7sqd Query : use flama_phc
20240620@083614.8000 tts925oi3p4hnoesvbv6bu7sqd Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@083614.8190 tts925oi3p4hnoesvbv6bu7sqd Query : use flama_phc
20240620@083614.8220 tts925oi3p4hnoesvbv6bu7sqd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@091916.3814 5kb2k0gpd0s2c2jt26na6chtca Query : use flama_phc
20240620@091916.3821 5kb2k0gpd0s2c2jt26na6chtca Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@091916.3887 5kb2k0gpd0s2c2jt26na6chtca Query : use flama_phc
20240620@091916.3891 5kb2k0gpd0s2c2jt26na6chtca Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@093616.6015 t0ll1feik59lsbftgh8r0kvqco Query : use flama_phc
20240620@093616.6020 t0ll1feik59lsbftgh8r0kvqco Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@093616.6089 t0ll1feik59lsbftgh8r0kvqco Query : use flama_phc
20240620@093616.6092 t0ll1feik59lsbftgh8r0kvqco Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@101913.6080 5rbae700nm4rbbr2pnvll3ktvv Query : use flama_phc
20240620@101913.6125 5rbae700nm4rbbr2pnvll3ktvv Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@101913.6216 5rbae700nm4rbbr2pnvll3ktvv Query : use flama_phc
20240620@101913.6219 5rbae700nm4rbbr2pnvll3ktvv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@103613.8887 ppaliflr9es0umo3hdlhvbm7pr Query : use flama_phc
20240620@103613.8891 ppaliflr9es0umo3hdlhvbm7pr Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@103613.8908 ppaliflr9es0umo3hdlhvbm7pr Query : use flama_phc
20240620@103613.8911 ppaliflr9es0umo3hdlhvbm7pr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@105303.1310 tvk46gvh82238tkf0i69l9gi32 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240620@105303.1900 tvk46gvh82238tkf0i69l9gi32 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240620@105303.4310 tvk46gvh82238tkf0i69l9gi32 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='495';
20240620@105303.5030 tvk46gvh82238tkf0i69l9gi32 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='495';
20240620@105303.5880 tvk46gvh82238tkf0i69l9gi32 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='495';
20240620@105303.6050 tvk46gvh82238tkf0i69l9gi32 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='495';
20240620@105303.2107 ihh5npjs2bg591p2njeojsh8kr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240620@105303.2123 ihh5npjs2bg591p2njeojsh8kr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240620@105303.2139 ihh5npjs2bg591p2njeojsh8kr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='496';
20240620@105303.2178 ihh5npjs2bg591p2njeojsh8kr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='496';
20240620@105303.2191 ihh5npjs2bg591p2njeojsh8kr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='496';
20240620@105303.2203 ihh5npjs2bg591p2njeojsh8kr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='496';
20240620@105303.2216 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.2219 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240620@105303.2266 ihh5npjs2bg591p2njeojsh8kr Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20240620@105303.2334 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.682.00.01'
20240620@105303.2437 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2907.00.1'
20240620@105303.2545 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5500.00.1'
20240620@105303.2627 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5500.00.1'
20240620@105303.2637 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.681.00.01'
20240620@105303.2727 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.945.00.01'
20240620@105303.2813 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.681.00.01'
20240620@105303.2824 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.2827 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 1 valor from ts where ts.ndos = 5
20240620@105303.2959 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.2963 ihh5npjs2bg591p2njeojsh8kr Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240620@105303.3315 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240620@105303.3456 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.3459 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20240620@105303.3534 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.3537 ihh5npjs2bg591p2njeojsh8kr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240620@105303.3575 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.3578 ihh5npjs2bg591p2njeojsh8kr Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20240620@105303.3594 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.3597 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from ts where ndos = 5
20240620@105303.3664 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.4166 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20240620@105303.4253 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.4267 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20240620@105303.4273 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.4285 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20240620@105303.4293 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20240620@105303.4414 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240620@105303.4524 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240620@105303.4619 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.4622 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20240620@105303.4705 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.4719 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20240620@105303.4749 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6673f071996673fbff70',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240620@105303.4813 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.4828 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20240620@105303.4835 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut6673f071996673fbff70','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20240620','11:23',?,?)
20240620@105303.5183 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.5197 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20240620@105303.5210 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut6673f071996673fbff70','trf entre armazéns a','2024-06-20',5,333,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20240620@105303.5787 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.5791 ihh5npjs2bg591p2njeojsh8kr Query : select st.usalote valor from st where st.ref = '324.682.00.01'
20240620@105303.5898 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.5901 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.682.00.01'
20240620@105303.7146 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.7150 ihh5npjs2bg591p2njeojsh8kr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.682.00.01' and sa.armazem = 133 
20240620@105303.7211 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.7214 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.682.00.01'
20240620@105303.7230 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.682.00.01'
20240620@105303.7604 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.7619 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105303.7631 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.7644 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105303.7653 ihh5npjs2bg591p2njeojsh8kr Query : select sestamp valor from se where ref ='324.682.00.01' and lote = 'r2400060200a'
20240620@105303.7713 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240620@105303.7777 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.7855 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105303.7910 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6673f519036673fbffbd','aut6673f071996673fbff70',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105303.8206 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.8222 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105303.8234 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6673f519036673fbffbd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*6.000,0*6.000*200.48 ,22.624000,22.624000*200.48 ,22.624000,22.624000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*6.000,0*6.000*200.48,0,0*6.000,0,0*6.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105303.8623 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.8627 ihh5npjs2bg591p2njeojsh8kr Query : select st.usalote valor from st where st.ref = '324.2907.00.1'
20240620@105303.8640 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.8643 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.2907.00.1'
20240620@105303.8672 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.8675 ihh5npjs2bg591p2njeojsh8kr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.2907.00.1' and sa.armazem = 133 
20240620@105303.8731 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.8735 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.2907.00.1'
20240620@105303.8746 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2907.00.1'
20240620@105303.8887 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.8901 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105303.8912 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.8924 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105303.8931 ihh5npjs2bg591p2njeojsh8kr Query : select sestamp valor from se where ref ='324.2907.00.1' and lote = 'r2400091200a'
20240620@105303.8942 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240620@105303.8953 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.8966 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105303.8973 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6673f658716673fbffda','aut6673f071996673fbff70',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105303.9099 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.9113 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105303.9124 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6673f658716673fbffda',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 24.000, 24.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*24.000,0*24.000*200.48 ,3.450000,3.450000*200.48 ,3.450000,3.450000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*24.000,0*24.000*200.48,0,0*24.000,0,0*24.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105303.9379 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.9383 ihh5npjs2bg591p2njeojsh8kr Query : select st.usalote valor from st where st.ref = '324.5500.00.1'
20240620@105303.9396 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.9399 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.5500.00.1'
20240620@105303.9411 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.9413 ihh5npjs2bg591p2njeojsh8kr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.5500.00.1' and sa.armazem = 133 
20240620@105303.9471 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105303.9474 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.5500.00.1'
20240620@105303.9484 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5500.00.1'
20240620@105303.9697 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.9730 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105303.9741 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.9754 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105303.9761 ihh5npjs2bg591p2njeojsh8kr Query : select sestamp valor from se where ref ='324.5500.00.1' and lote = 'r2400095600a'
20240620@105303.9773 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240620@105303.9783 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.9796 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105303.9803 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6673f169016673fbffee','aut6673f071996673fbff70',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105303.9930 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105303.9944 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105303.9956 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6673f169016673fbffee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 5.000, 5.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,30000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*5.000,0*5.000*200.48 ,22.033000,22.033000*200.48 ,22.033000,22.033000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*5.000,0*5.000*200.48,0,0*5.000,0,0*5.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.2190 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2230 ihh5npjs2bg591p2njeojsh8kr Query : select st.usalote valor from st where st.ref = '324.5500.00.1'
20240620@105304.2340 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2370 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.5500.00.1'
20240620@105304.2480 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2510 ihh5npjs2bg591p2njeojsh8kr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.5500.00.1' and sa.armazem = 133 
20240620@105304.2650 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2680 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.5500.00.1'
20240620@105304.2780 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5500.00.1'
20240620@105304.2900 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.3050 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.3160 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.3290 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.3350 ihh5npjs2bg591p2njeojsh8kr Query : select sestamp valor from se where ref ='324.5500.00.1' and lote = 'r2400095600a'
20240620@105304.3460 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240620@105304.3560 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.3880 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.3950 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6673f033406673fc0008','aut6673f071996673fbff70',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.5220 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.5360 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.5480 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6673f033406673fc0008',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 1.000, 1.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,40000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*1.000,0*1.000*200.48 ,22.033000,22.033000*200.48 ,22.033000,22.033000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*1.000,0*1.000*200.48,0,0*1.000,0,0*1.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.8650 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.8690 ihh5npjs2bg591p2njeojsh8kr Query : select st.usalote valor from st where st.ref = '324.681.00.01'
20240620@105304.8810 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.8840 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.681.00.01'
20240620@105304.8960 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.8990 ihh5npjs2bg591p2njeojsh8kr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.681.00.01' and sa.armazem = 133 
20240620@105304.1154 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.1229 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.681.00.01'
20240620@105304.1307 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.681.00.01'
20240620@105304.1457 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.1471 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.1482 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.1494 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.1501 ihh5npjs2bg591p2njeojsh8kr Query : select sestamp valor from se where ref ='324.681.00.01' and lote = 'r2400058200a'
20240620@105304.1511 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240620@105304.1523 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.1536 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.1544 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6673f098516673fc0025','aut6673f071996673fbff70',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.1714 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.1732 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.1743 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6673f098516673fc0025',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 5.000, 5.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,50000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*5.000,0*5.000*200.48 ,21.056000,21.056000*200.48 ,21.056000,21.056000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*5.000,0*5.000*200.48,0,0*5.000,0,0*5.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.2015 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2018 ihh5npjs2bg591p2njeojsh8kr Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240620@105304.2033 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2035 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.945.00.01'
20240620@105304.2046 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2049 ihh5npjs2bg591p2njeojsh8kr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.945.00.01' and sa.armazem = 133 
20240620@105304.2105 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2108 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.945.00.01'
20240620@105304.2117 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.945.00.01'
20240620@105304.2257 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.2270 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.2280 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.2291 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.2297 ihh5npjs2bg591p2njeojsh8kr Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20240620@105304.2308 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240620@105304.2318 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.2329 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.2335 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6673f952336673fc0038','aut6673f071996673fbff70',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.2460 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.2473 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.2486 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6673f952336673fc0038',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 24.000, 24.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,60000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*24.000,0*24.000*200.48 ,5.862000,5.862000*200.48 ,5.862000,5.862000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*24.000,0*24.000*200.48,0,0*24.000,0,0*24.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.2783 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2787 ihh5npjs2bg591p2njeojsh8kr Query : select st.usalote valor from st where st.ref = '324.681.00.01'
20240620@105304.2967 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2970 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.681.00.01'
20240620@105304.2981 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.2984 ihh5npjs2bg591p2njeojsh8kr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.681.00.01' and sa.armazem = 133 
20240620@105304.2997 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.3001 ihh5npjs2bg591p2njeojsh8kr Query : select st.stns valor from st where st.ref = '324.681.00.01'
20240620@105304.3011 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.681.00.01'
20240620@105304.3023 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.3037 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.3048 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.3061 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.3067 ihh5npjs2bg591p2njeojsh8kr Query : select sestamp valor from se where ref ='324.681.00.01' and lote = 'r2400058200a'
20240620@105304.3077 ihh5npjs2bg591p2njeojsh8kr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240620@105304.3087 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.3102 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240620@105304.3108 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6673f581596673fc004b','aut6673f071996673fbff70',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.3312 ihh5npjs2bg591p2njeojsh8kr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@105304.3327 ihh5npjs2bg591p2njeojsh8kr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240620@105304.3338 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6673f581596673fc004b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 1.000, 1.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,70000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*1.000,0*1.000*200.48 ,21.056000,21.056000*200.48 ,21.056000,21.056000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*1.000,0*1.000*200.48,0,0*1.000,0,0*1.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6673f071996673fbff70'
20240620@105304.3797 ihh5npjs2bg591p2njeojsh8kr Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut6673f071996673fbff70','','wait',5,'adm12071144683,938000003','')
20240620@105304.3838 ihh5npjs2bg591p2njeojsh8kr Query : use flama_phc
20240620@105304.3841 ihh5npjs2bg591p2njeojsh8kr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@105304.3854 ihh5npjs2bg591p2njeojsh8kr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='496';
20240620@105304.3869 ihh5npjs2bg591p2njeojsh8kr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='496';
20240620@111915.1382 6a4o9hgu798t9650hh0426699e Query : use flama_phc
20240620@111915.1389 6a4o9hgu798t9650hh0426699e Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@111915.1409 6a4o9hgu798t9650hh0426699e Query : use flama_phc
20240620@111915.1412 6a4o9hgu798t9650hh0426699e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@113615.6510 n3f8cu5cdqm80be3a71pnmvc46 Query : use flama_phc
20240620@113615.6580 n3f8cu5cdqm80be3a71pnmvc46 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@113615.6780 n3f8cu5cdqm80be3a71pnmvc46 Query : use flama_phc
20240620@113615.6810 n3f8cu5cdqm80be3a71pnmvc46 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@121920.3841 jveq2dojhtoiebpmfb17e034al Query : use flama_phc
20240620@121920.3847 jveq2dojhtoiebpmfb17e034al Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@121920.3866 jveq2dojhtoiebpmfb17e034al Query : use flama_phc
20240620@121920.3870 jveq2dojhtoiebpmfb17e034al Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@123620.2570 nbbf7d6p8p05iogc57skp1oo0v Query : use flama_phc
20240620@123620.2575 nbbf7d6p8p05iogc57skp1oo0v Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@123620.2596 nbbf7d6p8p05iogc57skp1oo0v Query : use flama_phc
20240620@123620.2599 nbbf7d6p8p05iogc57skp1oo0v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@131911.3812 lie28mbja92urg08e6kboa35fk Query : use flama_phc
20240620@131911.3817 lie28mbja92urg08e6kboa35fk Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@131911.3834 lie28mbja92urg08e6kboa35fk Query : use flama_phc
20240620@131911.3837 lie28mbja92urg08e6kboa35fk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@133611.7515 6u1lakprdm43gn3c4ktf4uf4it Query : use flama_phc
20240620@133611.7520 6u1lakprdm43gn3c4ktf4uf4it Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@133611.7538 6u1lakprdm43gn3c4ktf4uf4it Query : use flama_phc
20240620@133611.7542 6u1lakprdm43gn3c4ktf4uf4it Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@141911.8468 p54lthg83q9grvjdke9ab6732v Query : use flama_phc
20240620@141911.8473 p54lthg83q9grvjdke9ab6732v Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@141911.8491 p54lthg83q9grvjdke9ab6732v Query : use flama_phc
20240620@141911.8494 p54lthg83q9grvjdke9ab6732v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@143611.6608 0o98o09u34euq6ht5rp4jgcshj Query : use flama_phc
20240620@143611.6614 0o98o09u34euq6ht5rp4jgcshj Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@143611.6631 0o98o09u34euq6ht5rp4jgcshj Query : use flama_phc
20240620@143611.6634 0o98o09u34euq6ht5rp4jgcshj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@151917.1999 21io3escudrgpjrlg16auj2ieq Query : use flama_phc
20240620@151917.2004 21io3escudrgpjrlg16auj2ieq Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@151917.2023 21io3escudrgpjrlg16auj2ieq Query : use flama_phc
20240620@151917.2036 21io3escudrgpjrlg16auj2ieq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@153616.9820 mt746n2kafdl285d0hopls085j Query : use flama_phc
20240620@153616.9825 mt746n2kafdl285d0hopls085j Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@153616.9894 mt746n2kafdl285d0hopls085j Query : use flama_phc
20240620@153616.9897 mt746n2kafdl285d0hopls085j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@161913.6803 ps2g8kbjj3vqg0ve9921jlidm2 Query : use flama_phc
20240620@161913.6808 ps2g8kbjj3vqg0ve9921jlidm2 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@161913.6832 ps2g8kbjj3vqg0ve9921jlidm2 Query : use flama_phc
20240620@161913.6835 ps2g8kbjj3vqg0ve9921jlidm2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@163613.7822 mqqledv6ql0fj3vilnv1svvtm7 Query : use flama_phc
20240620@163613.7828 mqqledv6ql0fj3vilnv1svvtm7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@163613.7850 mqqledv6ql0fj3vilnv1svvtm7 Query : use flama_phc
20240620@163613.7853 mqqledv6ql0fj3vilnv1svvtm7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@171914.9027 ie6q9mlit4jr5tc2r8go0kss5i Query : use flama_phc
20240620@171914.9033 ie6q9mlit4jr5tc2r8go0kss5i Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@171914.9097 ie6q9mlit4jr5tc2r8go0kss5i Query : use flama_phc
20240620@171914.9100 ie6q9mlit4jr5tc2r8go0kss5i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@173614.9796 nihq0v8q9jf4vus1tbq2398801 Query : use flama_phc
20240620@173614.9801 nihq0v8q9jf4vus1tbq2398801 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240620@173614.9818 nihq0v8q9jf4vus1tbq2398801 Query : use flama_phc
20240620@173614.9821 nihq0v8q9jf4vus1tbq2398801 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240620@180106.5749 go2ebs966ifs0s128c49lbuqno Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240620@180106.5785 go2ebs966ifs0s128c49lbuqno Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240620@180106.5857 go2ebs966ifs0s128c49lbuqno Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='497';
20240620@180106.5893 go2ebs966ifs0s128c49lbuqno Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='497';
20240620@180106.5920 go2ebs966ifs0s128c49lbuqno Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='497';
20240620@180106.5933 go2ebs966ifs0s128c49lbuqno Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='497';
20240620@180106.5946 go2ebs966ifs0s128c49lbuqno Query : use flama_phc
20240620@180106.5949 go2ebs966ifs0s128c49lbuqno Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240620@180106.5998 go2ebs966ifs0s128c49lbuqno Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.938.00.01'
20240620@180106.6128 go2ebs966ifs0s128c49lbuqno Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400003 and bi.ref ='324.938.00.01' and bi.lordem =20000
20240620@180106.6586 go2ebs966ifs0s128c49lbuqno Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24010431678,947000002 ' 
20240620@180106.6939 go2ebs966ifs0s128c49lbuqno Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.938.00.01'
20240620@180106.6950 go2ebs966ifs0s128c49lbuqno Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400003 and bi.ref ='324.938.00.01' and bi.lordem =20000
20240620@180106.6963 go2ebs966ifs0s128c49lbuqno Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24010431678,947000002 ' 
20240620@180106.6975 go2ebs966ifs0s128c49lbuqno Query : use flama_phc
20240620@180106.6978 go2ebs966ifs0s128c49lbuqno Query : select top 1 1 valor from ts where ts.ndos = 61
20240620@180106.7587 go2ebs966ifs0s128c49lbuqno Query : use flama_phc
20240620@180106.7790 go2ebs966ifs0s128c49lbuqno Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240620@180106.8664 go2ebs966ifs0s128c49lbuqno Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =61
20240620@180106.8822 go2ebs966ifs0s128c49lbuqno Query : use flama_phc
20240620@180106.8825 go2ebs966ifs0s128c49lbuqno Query : select top 1 ~inactivo valor from fl where no = '202300' and estab = 00 order by inactivo desc
20240620@180106.8907 go2ebs966ifs0s128c49lbuqno Query : use flama_phc
20240620@180106.8910 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from ts where ndos = 61
20240620@180106.8986 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180106.9300 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20240620@180106.9368 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180106.9381 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20240620@180106.9390 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180106.9402 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20240620@180106.9409 go2ebs966ifs0s128c49lbuqno Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 61
20240620@180106.9786 go2ebs966ifs0s128c49lbuqno Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240620@180106.9925 go2ebs966ifs0s128c49lbuqno Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240620@180106.9942 go2ebs966ifs0s128c49lbuqno Query : use flama_phc
20240620@180106.9946 go2ebs966ifs0s128c49lbuqno Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202300' and estab=00
20240620@180107.4900 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180107.6500 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20240620@180107.9800 go2ebs966ifs0s128c49lbuqno Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut667467295166746052f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240620@180107.1690 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180107.1830 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20240620@180107.1900 go2ebs966ifs0s128c49lbuqno Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut667467295166746052f2','--','bo',7.4202496532593619972 ,1,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240620@180107.3930 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180107.4080 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20240620@180107.4160 go2ebs966ifs0s128c49lbuqno Query : insert into bo (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut667467295166746052f2','guia r. fornecedor','2024-06-20',61,2401775,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240620@180110.8747 go2ebs966ifs0s128c49lbuqno Query : use flama_phc
20240620@180110.8751 go2ebs966ifs0s128c49lbuqno Query : select st.usalote valor from st where st.ref = '324.938.00.01'
20240620@180110.9034 go2ebs966ifs0s128c49lbuqno Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.938.00.01'
20240620@180110.9306 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180110.9322 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20240620@180110.9336 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180110.9353 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20240620@180110.9360 go2ebs966ifs0s128c49lbuqno Query : select sestamp valor from se where ref ='324.938.00.01' and lote = 'r2400003200a'
20240620@180110.9440 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180110.9455 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20240620@180110.9463 go2ebs966ifs0s128c49lbuqno Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240620@180110.9475 go2ebs966ifs0s128c49lbuqno Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20240620@180110.9483 go2ebs966ifs0s128c49lbuqno Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut667464741966746056e7',?,?,'20240620',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20240620@180111.5650 go2ebs966ifs0s128c49lbuqno Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
