20230504@180631.7524 8is9191ssqf3lfe13d2ctgv6e7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180631.7528 8is9191ssqf3lfe13d2ctgv6e7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e358766453e617b0','aut6453e898036453e6177b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180631.7533 8is9191ssqf3lfe13d2ctgv6e7 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e898036453e6177b','','wait',39,'ari17112337378,753000005')
20230504@180631.7557 8is9191ssqf3lfe13d2ctgv6e7 Query : use flama_phc
20230504@180631.7561 8is9191ssqf3lfe13d2ctgv6e7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180631.7573 8is9191ssqf3lfe13d2ctgv6e7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='163';
20230504@180631.7586 8is9191ssqf3lfe13d2ctgv6e7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='163';
20230504@180631.7598 8is9191ssqf3lfe13d2ctgv6e7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='163';
20230504@180631.7608 8is9191ssqf3lfe13d2ctgv6e7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='163';
20230504@180631.8086 lpme32r7r7p189tv9aj3h26b64 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180631.8100 lpme32r7r7p189tv9aj3h26b64 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180631.8115 lpme32r7r7p189tv9aj3h26b64 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='164';
20230504@180631.8163 lpme32r7r7p189tv9aj3h26b64 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='164';
20230504@180631.8177 lpme32r7r7p189tv9aj3h26b64 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='164';
20230504@180631.8188 lpme32r7r7p189tv9aj3h26b64 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='164';
20230504@180631.8203 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8207 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180631.8220 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8223 lpme32r7r7p189tv9aj3h26b64 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4786
20230504@180631.8258 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180631.8269 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 5 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180631.8748 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180631.8761 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 5 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180631.8767 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8770 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180631.8784 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8787 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180631.8798 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8802 lpme32r7r7p189tv9aj3h26b64 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180631.8813 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180631.8827 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8830 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 ~inactivo valor from cl where no = '101847' and estab = 0 order by inactivo desc
20230504@180631.8840 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8843 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180631.8854 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8857 lpme32r7r7p189tv9aj3h26b64 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180631.8868 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8871 lpme32r7r7p189tv9aj3h26b64 Query : select szadrsstamp valor from szadrs where szadrsdesc='101847 - media markt aveiro-prod.inf.e elect.,lda'
20230504@180631.8883 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.8886 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from td where ndoc = 39
20230504@180631.8896 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180631.8908 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180631.8922 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180631.8939 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180631.8952 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180631.8957 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180631.8969 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180631.8980 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180631.9021 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180631.9031 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180631.9043 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180631.9054 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e352506453e617db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180631.9264 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180631.9383 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180631.9433 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e352506453e617db',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180631.9439 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180631.9453 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180631.9468 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180631.9487 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e352506453e617db',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',92,101847,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180631.9925 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180631.9929 lpme32r7r7p189tv9aj3h26b64 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180631.9941 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180631.9969 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180631.9982 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180631.9991 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.6000 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.1000 lpme32r7r7p189tv9aj3h26b64 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180632.2000 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.2900 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.4100 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.5000 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e809176453e61800',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6453e352506453e617db' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180632.3180 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.3330 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.3370 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e809176453e61800','aut6453e352506453e617db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.3420 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.3550 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.3650 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.3770 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.3810 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.3910 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.4030 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.4130 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e826996453e61809',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e352506453e617db' ,0,0 ,2,23.00,20000,?,?,?)
20230504@180632.7520 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.7680 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.7720 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e826996453e61809','aut6453e352506453e617db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.7760 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180632.7790 lpme32r7r7p189tv9aj3h26b64 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180632.7890 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180632.8000 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8130 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.8220 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.8340 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.8380 lpme32r7r7p189tv9aj3h26b64 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180632.8480 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.8570 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8690 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.8830 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e489616453e61814',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6453e352506453e617db' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20230504@180632.1304 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.1321 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.1326 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e489616453e61814','aut6453e352506453e617db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.1332 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.1346 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.1356 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.1369 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.1373 lpme32r7r7p189tv9aj3h26b64 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.1383 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.1396 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.1407 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e433396453e61821',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e352506453e617db' ,0,0 ,2,23.00,50000,?,?,?)
20230504@180632.1683 lpme32r7r7p189tv9aj3h26b64 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.1699 lpme32r7r7p189tv9aj3h26b64 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.1705 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e433396453e61821','aut6453e352506453e617db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.1710 lpme32r7r7p189tv9aj3h26b64 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e352506453e617db','','wait',39,'ari17112337378,753000005')
20230504@180632.1739 lpme32r7r7p189tv9aj3h26b64 Query : use flama_phc
20230504@180632.1742 lpme32r7r7p189tv9aj3h26b64 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180632.1768 lpme32r7r7p189tv9aj3h26b64 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='164';
20230504@180632.1784 lpme32r7r7p189tv9aj3h26b64 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='164';
20230504@180632.1809 lpme32r7r7p189tv9aj3h26b64 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='164';
20230504@180632.1925 lpme32r7r7p189tv9aj3h26b64 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='164';
20230504@180632.2609 48tpafk8l1qud36rs01lp8ibqk Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180632.2625 48tpafk8l1qud36rs01lp8ibqk Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180632.2638 48tpafk8l1qud36rs01lp8ibqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='165';
20230504@180632.2677 48tpafk8l1qud36rs01lp8ibqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='165';
20230504@180632.2691 48tpafk8l1qud36rs01lp8ibqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='165';
20230504@180632.2700 48tpafk8l1qud36rs01lp8ibqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='165';
20230504@180632.2714 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.2717 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180632.2728 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.2732 48tpafk8l1qud36rs01lp8ibqk Query : select no, estab,szadrsdesc from szadrs where u_coddest=4782
20230504@180632.3719 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180632.3730 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 6 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180632.4039 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4044 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180632.4070 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4073 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180632.4082 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4085 48tpafk8l1qud36rs01lp8ibqk Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180632.4095 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180632.4108 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4111 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 ~inactivo valor from cl where no = '101848' and estab = 0 order by inactivo desc
20230504@180632.4203 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4207 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180632.4218 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4221 48tpafk8l1qud36rs01lp8ibqk Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180632.4230 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4233 48tpafk8l1qud36rs01lp8ibqk Query : select szadrsstamp valor from szadrs where szadrsdesc='101848 - media markt braga-prod.inf.e eelect.,lda'
20230504@180632.4245 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4248 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from td where ndoc = 39
20230504@180632.4258 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180632.4269 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180632.4282 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180632.4298 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180632.4310 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180632.4315 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180632.4327 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180632.4336 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180632.4376 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180632.4385 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180632.4397 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180632.4406 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e254456453e61869' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180632.4574 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180632.4588 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180632.4592 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e254456453e61869',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.4597 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180632.4608 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180632.4620 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180632.4637 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e254456453e61869',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',93,101848,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180632.4926 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.4931 48tpafk8l1qud36rs01lp8ibqk Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180632.4943 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180632.4955 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.4969 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.4978 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.4990 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.4994 48tpafk8l1qud36rs01lp8ibqk Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180632.5004 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.5013 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.5024 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.5033 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e594296453e6187a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6453e254456453e61869' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180632.5285 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.5299 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.5304 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e594296453e6187a','aut6453e254456453e61869' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.5309 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.5322 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.5332 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.5343 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.5347 48tpafk8l1qud36rs01lp8ibqk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.5356 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.5367 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.5376 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e712746453e61882',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e254456453e61869' ,0,0 ,2,23.00,20000,?,?,?)
20230504@180632.5639 48tpafk8l1qud36rs01lp8ibqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.5654 48tpafk8l1qud36rs01lp8ibqk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.5659 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e712746453e61882','aut6453e254456453e61869' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.5663 48tpafk8l1qud36rs01lp8ibqk Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e254456453e61869','','wait',39,'ari17112337378,753000005')
20230504@180632.5680 48tpafk8l1qud36rs01lp8ibqk Query : use flama_phc
20230504@180632.5683 48tpafk8l1qud36rs01lp8ibqk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180632.5695 48tpafk8l1qud36rs01lp8ibqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='165';
20230504@180632.5708 48tpafk8l1qud36rs01lp8ibqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='165';
20230504@180632.5724 48tpafk8l1qud36rs01lp8ibqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='165';
20230504@180632.5809 48tpafk8l1qud36rs01lp8ibqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='165';
20230504@180632.6122 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180632.6137 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180632.6151 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='166';
20230504@180632.6192 4bhsl8g2jfrnd4gk8a1cssomp0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='166';
20230504@180632.6207 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='166';
20230504@180632.6217 4bhsl8g2jfrnd4gk8a1cssomp0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='166';
20230504@180632.6228 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6231 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180632.6243 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6263 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4783
20230504@180632.6338 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180632.6349 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 7 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180632.6668 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180632.6680 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 7 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180632.6686 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6689 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180632.6702 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6705 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180632.6715 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6718 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180632.6729 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180632.6743 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6746 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 ~inactivo valor from cl where no = '102011' and estab = 0 order by inactivo desc
20230504@180632.6896 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6900 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180632.6912 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6915 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180632.6926 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6929 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select szadrsstamp valor from szadrs where szadrsdesc='102011 - media markt alfragide, lda.'
20230504@180632.6942 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.6945 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from td where ndoc = 39
20230504@180632.6956 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180632.6968 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180632.6981 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180632.6997 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180632.7010 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180632.7015 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180632.7027 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180632.7039 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180632.7079 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180632.7089 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180632.7101 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180632.7110 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e736436453e618ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180632.7284 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180632.7299 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180632.7303 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e736436453e618ab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.7308 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180632.7319 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180632.7332 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180632.7349 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e736436453e618ab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',94,102011,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180632.7635 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.7639 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180632.7651 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180632.7662 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.7675 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.7685 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.7697 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.7702 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180632.7712 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.7721 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.7733 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.7742 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e155806453e618bc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6453e736436453e618ab' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180632.8032 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.8048 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.8053 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e155806453e618bc','aut6453e736436453e618ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.8058 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8071 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.8081 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.8093 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.8097 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.8107 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8118 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.8128 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e402856453e618c5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e736436453e618ab' ,0,0 ,2,23.00,20000,?,?,?)
20230504@180632.8381 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.8396 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.8401 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e402856453e618c5','aut6453e736436453e618ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.8405 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.8408 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180632.8418 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180632.8429 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8442 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.8452 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.8465 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.8469 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180632.8479 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.8488 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8500 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.8510 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e685626453e618cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6453e736436453e618ab' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20230504@180632.8768 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.8784 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.8789 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e685626453e618cf','aut6453e736436453e618ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.8794 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8807 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180632.8816 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.8827 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180632.8831 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180632.8842 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180632.8853 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180632.8862 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e010476453e618d7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e736436453e618ab' ,0,0 ,2,23.00,50000,?,?,?)
20230504@180632.9119 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180632.9135 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180632.9140 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e010476453e618d7','aut6453e736436453e618ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180632.9145 4bhsl8g2jfrnd4gk8a1cssomp0 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e736436453e618ab','','wait',39,'ari17112337378,753000005')
20230504@180632.9163 4bhsl8g2jfrnd4gk8a1cssomp0 Query : use flama_phc
20230504@180632.9166 4bhsl8g2jfrnd4gk8a1cssomp0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180632.9178 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='166';
20230504@180632.9190 4bhsl8g2jfrnd4gk8a1cssomp0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='166';
20230504@180632.9206 4bhsl8g2jfrnd4gk8a1cssomp0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='166';
20230504@180632.9216 4bhsl8g2jfrnd4gk8a1cssomp0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='166';
20230504@180632.9521 k06ripmsl15iuf08chh90n1ucd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180632.9542 k06ripmsl15iuf08chh90n1ucd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180632.9556 k06ripmsl15iuf08chh90n1ucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='167';
20230504@180632.9677 k06ripmsl15iuf08chh90n1ucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='167';
20230504@180632.9692 k06ripmsl15iuf08chh90n1ucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='167';
20230504@180632.9704 k06ripmsl15iuf08chh90n1ucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='167';
20230504@180632.9717 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9720 k06ripmsl15iuf08chh90n1ucd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180632.9733 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9736 k06ripmsl15iuf08chh90n1ucd Query : select no, estab,szadrsdesc from szadrs where u_coddest=4785
20230504@180632.9770 k06ripmsl15iuf08chh90n1ucd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180632.9781 k06ripmsl15iuf08chh90n1ucd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180632.9787 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9791 k06ripmsl15iuf08chh90n1ucd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180632.9803 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9806 k06ripmsl15iuf08chh90n1ucd Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180632.9815 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9818 k06ripmsl15iuf08chh90n1ucd Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180632.9829 k06ripmsl15iuf08chh90n1ucd Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180632.9843 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9846 k06ripmsl15iuf08chh90n1ucd Query : select top 1 ~inactivo valor from cl where no = '102199' and estab = 0 order by inactivo desc
20230504@180632.9856 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9858 k06ripmsl15iuf08chh90n1ucd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180632.9871 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180632.9874 k06ripmsl15iuf08chh90n1ucd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180632.9997 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180633.3900 k06ripmsl15iuf08chh90n1ucd Query : select szadrsstamp valor from szadrs where szadrsdesc='102199 - media markt setÚbal, lda.'
20230504@180633.8090 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180633.8140 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from td where ndoc = 39
20230504@180633.8250 k06ripmsl15iuf08chh90n1ucd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180633.8390 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180633.8570 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180633.8760 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180633.8910 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180633.8960 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180633.9100 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180633.9210 k06ripmsl15iuf08chh90n1ucd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180633.1002 k06ripmsl15iuf08chh90n1ucd Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180633.1012 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180633.1028 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180633.1038 k06ripmsl15iuf08chh90n1ucd Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e897716453e61916' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180633.1214 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180633.1229 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180633.1234 k06ripmsl15iuf08chh90n1ucd Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e897716453e61916',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.1239 k06ripmsl15iuf08chh90n1ucd Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180633.1250 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180633.1264 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180633.1281 k06ripmsl15iuf08chh90n1ucd Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e897716453e61916',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',95,102199,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180633.1576 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180633.1581 k06ripmsl15iuf08chh90n1ucd Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180633.1592 k06ripmsl15iuf08chh90n1ucd Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180633.1603 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.1616 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.1626 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.1638 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.1642 k06ripmsl15iuf08chh90n1ucd Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180633.1652 k06ripmsl15iuf08chh90n1ucd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.1662 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.1673 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.1683 k06ripmsl15iuf08chh90n1ucd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e328606453e61928',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6453e897716453e61916' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180633.1947 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.1963 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180633.1967 k06ripmsl15iuf08chh90n1ucd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e328606453e61928','aut6453e897716453e61916' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.1972 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.1984 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.1994 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.2006 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.2010 k06ripmsl15iuf08chh90n1ucd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.2019 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.2030 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.2040 k06ripmsl15iuf08chh90n1ucd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e085486453e61931',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e897716453e61916' ,0,0 ,2,23.00,20000,?,?,?)
20230504@180633.2307 k06ripmsl15iuf08chh90n1ucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.2323 k06ripmsl15iuf08chh90n1ucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180633.2328 k06ripmsl15iuf08chh90n1ucd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e085486453e61931','aut6453e897716453e61916' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.2333 k06ripmsl15iuf08chh90n1ucd Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e897716453e61916','','wait',39,'ari17112337378,753000005')
20230504@180633.2353 k06ripmsl15iuf08chh90n1ucd Query : use flama_phc
20230504@180633.2357 k06ripmsl15iuf08chh90n1ucd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180633.2370 k06ripmsl15iuf08chh90n1ucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='167';
20230504@180633.2381 k06ripmsl15iuf08chh90n1ucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='167';
20230504@180633.2406 k06ripmsl15iuf08chh90n1ucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='167';
20230504@180633.2416 k06ripmsl15iuf08chh90n1ucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='167';
20230504@180633.2776 8q5f7bojse1g84u4m03acp9627 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180633.2790 8q5f7bojse1g84u4m03acp9627 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180633.2804 8q5f7bojse1g84u4m03acp9627 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='168';
20230504@180633.2848 8q5f7bojse1g84u4m03acp9627 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='168';
20230504@180633.2863 8q5f7bojse1g84u4m03acp9627 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='168';
20230504@180633.2873 8q5f7bojse1g84u4m03acp9627 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='168';
20230504@180633.2886 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.2889 8q5f7bojse1g84u4m03acp9627 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180633.2902 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.2905 8q5f7bojse1g84u4m03acp9627 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4784
20230504@180633.2975 8q5f7bojse1g84u4m03acp9627 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180633.2985 8q5f7bojse1g84u4m03acp9627 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 1 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180633.3297 8q5f7bojse1g84u4m03acp9627 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20230504@180633.3308 8q5f7bojse1g84u4m03acp9627 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 1 and bi.ref ='324.1879.00.1' and bi.lordem =20000
20230504@180633.3313 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3316 8q5f7bojse1g84u4m03acp9627 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180633.3327 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3330 8q5f7bojse1g84u4m03acp9627 Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180633.3340 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3343 8q5f7bojse1g84u4m03acp9627 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180633.3354 8q5f7bojse1g84u4m03acp9627 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180633.3369 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3371 8q5f7bojse1g84u4m03acp9627 Query : select top 1 ~inactivo valor from cl where no = '102410' and estab = 0 order by inactivo desc
20230504@180633.3466 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3469 8q5f7bojse1g84u4m03acp9627 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180633.3479 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3482 8q5f7bojse1g84u4m03acp9627 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180633.3492 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3495 8q5f7bojse1g84u4m03acp9627 Query : select szadrsstamp valor from szadrs where szadrsdesc='102410 - media markt matosinhos - prod inform e el'
20230504@180633.3508 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.3510 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from td where ndoc = 39
20230504@180633.3520 8q5f7bojse1g84u4m03acp9627 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180633.3532 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180633.3551 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180633.3569 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180633.3583 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180633.3587 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180633.3602 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180633.3616 8q5f7bojse1g84u4m03acp9627 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180633.3658 8q5f7bojse1g84u4m03acp9627 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180633.3668 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180633.3682 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180633.3693 8q5f7bojse1g84u4m03acp9627 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e932416453e61958' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180633.3869 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180633.3884 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180633.3888 8q5f7bojse1g84u4m03acp9627 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e932416453e61958',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.3893 8q5f7bojse1g84u4m03acp9627 Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180633.3904 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180633.3917 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180633.3935 8q5f7bojse1g84u4m03acp9627 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e932416453e61958',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96,102410,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180633.4245 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.4249 8q5f7bojse1g84u4m03acp9627 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180633.4262 8q5f7bojse1g84u4m03acp9627 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180633.4274 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.4287 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.4297 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.4309 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.4314 8q5f7bojse1g84u4m03acp9627 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180633.4324 8q5f7bojse1g84u4m03acp9627 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.4334 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.4345 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.4356 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e003686453e61969',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6453e932416453e61958' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180633.4614 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.4629 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180633.4633 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e003686453e61969','aut6453e932416453e61958' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.4638 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.4651 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.4661 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.4672 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.4677 8q5f7bojse1g84u4m03acp9627 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.4687 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.4699 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.4709 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e729126453e61972',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e932416453e61958' ,0,0 ,2,23.00,20000,?,?,?)
20230504@180633.4983 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.4999 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180633.5005 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e729126453e61972','aut6453e932416453e61958' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.5010 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.5013 8q5f7bojse1g84u4m03acp9627 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230504@180633.5024 8q5f7bojse1g84u4m03acp9627 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20230504@180633.5036 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.5050 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.5060 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.5072 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.5077 8q5f7bojse1g84u4m03acp9627 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230504@180633.5088 8q5f7bojse1g84u4m03acp9627 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.5097 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.5110 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.5121 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e538596453e6197c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6453e932416453e61958' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20230504@180633.5393 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.5421 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180633.5425 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e538596453e6197c','aut6453e932416453e61958' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.5430 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.5445 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.5455 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.5468 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.5472 8q5f7bojse1g84u4m03acp9627 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.5482 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.5495 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.5505 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e035686453e61985',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e932416453e61958' ,0,0 ,2,23.00,50000,?,?,?)
20230504@180633.5764 8q5f7bojse1g84u4m03acp9627 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.5778 8q5f7bojse1g84u4m03acp9627 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180633.5783 8q5f7bojse1g84u4m03acp9627 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e035686453e61985','aut6453e932416453e61958' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.5787 8q5f7bojse1g84u4m03acp9627 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e932416453e61958','','wait',39,'ari17112337378,753000005')
20230504@180633.5812 8q5f7bojse1g84u4m03acp9627 Query : use flama_phc
20230504@180633.5815 8q5f7bojse1g84u4m03acp9627 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180633.5827 8q5f7bojse1g84u4m03acp9627 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='168';
20230504@180633.5839 8q5f7bojse1g84u4m03acp9627 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='168';
20230504@180633.5850 8q5f7bojse1g84u4m03acp9627 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='168';
20230504@180633.5863 8q5f7bojse1g84u4m03acp9627 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='168';
20230504@180633.6180 lohb8f6akb5h1n0ath55dssv8h Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180633.6194 lohb8f6akb5h1n0ath55dssv8h Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180633.6207 lohb8f6akb5h1n0ath55dssv8h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='169';
20230504@180633.6246 lohb8f6akb5h1n0ath55dssv8h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='169';
20230504@180633.6259 lohb8f6akb5h1n0ath55dssv8h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='169';
20230504@180633.6270 lohb8f6akb5h1n0ath55dssv8h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='169';
20230504@180633.6281 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.6287 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180633.6299 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.6302 lohb8f6akb5h1n0ath55dssv8h Query : select no, estab,szadrsdesc from szadrs where u_coddest=1911
20230504@180633.6377 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20230504@180633.6505 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 2 and bi.ref ='324.1816.00.1' and bi.lordem =20000
20230504@180633.6973 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20230504@180633.7899 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 2 and bi.ref ='324.958.00.01' and bi.lordem =30000
20230504@180633.8203 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8206 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180633.8219 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8222 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180633.8231 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8234 lohb8f6akb5h1n0ath55dssv8h Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180633.8245 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180633.8258 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8261 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 ~inactivo valor from cl where no = '100312' and estab = 0 order by inactivo desc
20230504@180633.8353 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8356 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180633.8368 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8371 lohb8f6akb5h1n0ath55dssv8h Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180633.8381 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8384 lohb8f6akb5h1n0ath55dssv8h Query : select szadrsstamp valor from szadrs where szadrsdesc='morada cliente 2560-326 torres vedras'
20230504@180633.8407 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.8410 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from td where ndoc = 39
20230504@180633.8420 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180633.8431 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180633.8445 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180633.8461 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180633.8474 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180633.8478 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180633.8490 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180633.8500 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180633.8542 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180633.8551 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180633.8583 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180633.8593 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e204136453e619cf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180633.8770 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180633.8784 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180633.8788 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e204136453e619cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.8794 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180633.8805 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180633.8818 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180633.8834 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e204136453e619cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',97,100312,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180633.9115 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180633.9119 lohb8f6akb5h1n0ath55dssv8h Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20230504@180633.9131 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20230504@180633.9259 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.9272 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.9281 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.9293 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.9297 lohb8f6akb5h1n0ath55dssv8h Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2200647200a'
20230504@180633.9308 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.9318 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.9329 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.9340 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e631556453e619e3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6453e204136453e619cf' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180633.9629 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.9645 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180633.9649 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e631556453e619e3','aut6453e204136453e619cf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180633.9654 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.9667 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180633.9676 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.9688 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180633.9692 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180633.9701 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180633.9712 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180633.9721 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6453e207806453e619ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6453e204136453e619cf' ,0,0 ,2,23.00,20000,?,?,?)
20230504@180633.9983 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180633.9998 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.2000 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e207806453e619ec','aut6453e204136453e619cf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.7000 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180634.1000 lohb8f6akb5h1n0ath55dssv8h Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20230504@180634.2000 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20230504@180634.1530 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.1670 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.1760 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.1890 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.1930 lohb8f6akb5h1n0ath55dssv8h Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2200700200a'
20230504@180634.2040 lohb8f6akb5h1n0ath55dssv8h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180634.2140 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.2260 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180634.2360 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e238056453e61a05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6453e204136453e619cf' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20230504@180634.5090 lohb8f6akb5h1n0ath55dssv8h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.5240 lohb8f6akb5h1n0ath55dssv8h Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.5290 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e238056453e61a05','aut6453e204136453e619cf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.5350 lohb8f6akb5h1n0ath55dssv8h Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e204136453e619cf','','wait',39,'ari17112337378,753000005')
20230504@180634.5520 lohb8f6akb5h1n0ath55dssv8h Query : use flama_phc
20230504@180634.5550 lohb8f6akb5h1n0ath55dssv8h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180634.5760 lohb8f6akb5h1n0ath55dssv8h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='169';
20230504@180634.5890 lohb8f6akb5h1n0ath55dssv8h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='169';
20230504@180634.6000 lohb8f6akb5h1n0ath55dssv8h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='169';
20230504@180634.6110 lohb8f6akb5h1n0ath55dssv8h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='169';
20230504@180634.9570 pm6kge7hrctfk6fremp4al99tu Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180634.9740 pm6kge7hrctfk6fremp4al99tu Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180634.9880 pm6kge7hrctfk6fremp4al99tu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='170';
20230504@180634.1030 pm6kge7hrctfk6fremp4al99tu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='170';
20230504@180634.1047 pm6kge7hrctfk6fremp4al99tu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='170';
20230504@180634.1058 pm6kge7hrctfk6fremp4al99tu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='170';
20230504@180634.1072 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.1076 pm6kge7hrctfk6fremp4al99tu Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180634.1089 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.1093 pm6kge7hrctfk6fremp4al99tu Query : select no, estab,szadrsdesc from szadrs where u_coddest=4787
20230504@180634.1129 pm6kge7hrctfk6fremp4al99tu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20230504@180634.1140 pm6kge7hrctfk6fremp4al99tu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 3 and bi.ref ='324.4751.00.1' and bi.lordem =20000
20230504@180634.1457 pm6kge7hrctfk6fremp4al99tu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20230504@180634.1469 pm6kge7hrctfk6fremp4al99tu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 3 and bi.ref ='324.4751.00.1' and bi.lordem =20000
20230504@180634.1476 pm6kge7hrctfk6fremp4al99tu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20230504@180634.1487 pm6kge7hrctfk6fremp4al99tu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 3 and bi.ref ='304.4320.00.1' and bi.lordem =30000
20230504@180634.1801 pm6kge7hrctfk6fremp4al99tu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20230504@180634.1813 pm6kge7hrctfk6fremp4al99tu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 3 and bi.ref ='304.4320.00.1' and bi.lordem =30000
20230504@180634.1819 pm6kge7hrctfk6fremp4al99tu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20230504@180634.1830 pm6kge7hrctfk6fremp4al99tu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 3 and bi.ref ='304.422.00.07' and bi.lordem =40000
20230504@180634.2142 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2146 pm6kge7hrctfk6fremp4al99tu Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180634.2160 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2163 pm6kge7hrctfk6fremp4al99tu Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180634.2174 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2177 pm6kge7hrctfk6fremp4al99tu Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180634.2189 pm6kge7hrctfk6fremp4al99tu Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180634.2204 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2208 pm6kge7hrctfk6fremp4al99tu Query : select top 1 ~inactivo valor from cl where no = '101846' and estab = 0 order by inactivo desc
20230504@180634.2218 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2222 pm6kge7hrctfk6fremp4al99tu Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180634.2232 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2235 pm6kge7hrctfk6fremp4al99tu Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180634.2324 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2328 pm6kge7hrctfk6fremp4al99tu Query : select szadrsstamp valor from szadrs where szadrsdesc='101846 - media markt sintra-prod.inf.e elect. lda'
20230504@180634.2341 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.2344 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from td where ndoc = 39
20230504@180634.2355 pm6kge7hrctfk6fremp4al99tu Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180634.2370 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180634.2386 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180634.2404 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180634.2417 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180634.2422 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180634.2434 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180634.2445 pm6kge7hrctfk6fremp4al99tu Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180634.2485 pm6kge7hrctfk6fremp4al99tu Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180634.2496 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180634.2508 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180634.2520 pm6kge7hrctfk6fremp4al99tu Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e294876453e61a3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180634.2693 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180634.2708 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180634.2713 pm6kge7hrctfk6fremp4al99tu Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e294876453e61a3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.2718 pm6kge7hrctfk6fremp4al99tu Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180634.2729 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180634.2742 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180634.2761 pm6kge7hrctfk6fremp4al99tu Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e294876453e61a3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',98,101846,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180634.3050 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.3054 pm6kge7hrctfk6fremp4al99tu Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20230504@180634.3067 pm6kge7hrctfk6fremp4al99tu Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4751.00.1'
20230504@180634.3078 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.3092 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.3102 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.3115 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.3119 pm6kge7hrctfk6fremp4al99tu Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2100445100a'
20230504@180634.3129 pm6kge7hrctfk6fremp4al99tu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180634.3139 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.3152 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180634.3162 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e513426453e61a4c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6453e294876453e61a3b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180634.3419 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.3434 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.3438 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e513426453e61a4c','aut6453e294876453e61a3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.3443 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.3446 pm6kge7hrctfk6fremp4al99tu Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20230504@180634.3468 pm6kge7hrctfk6fremp4al99tu Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4751.00.1'
20230504@180634.3479 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.3493 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.3503 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.3515 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.3519 pm6kge7hrctfk6fremp4al99tu Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2100445100a'
20230504@180634.3530 pm6kge7hrctfk6fremp4al99tu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180634.3540 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.3553 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180634.3564 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e897056453e61a56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6453e294876453e61a3b' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20230504@180634.3827 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.3843 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.3848 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e897056453e61a56','aut6453e294876453e61a3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.3853 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.3856 pm6kge7hrctfk6fremp4al99tu Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20230504@180634.3867 pm6kge7hrctfk6fremp4al99tu Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20230504@180634.3878 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.3891 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.3901 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.3914 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.3918 pm6kge7hrctfk6fremp4al99tu Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '230547'
20230504@180634.3928 pm6kge7hrctfk6fremp4al99tu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180634.3938 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.3950 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180634.3961 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e924806453e61a60',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6453e294876453e61a3b' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20230504@180634.4229 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.4245 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.4249 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e924806453e61a60','aut6453e294876453e61a3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.4254 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.4257 pm6kge7hrctfk6fremp4al99tu Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20230504@180634.4267 pm6kge7hrctfk6fremp4al99tu Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20230504@180634.4279 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.4294 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.4304 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.4317 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.4321 pm6kge7hrctfk6fremp4al99tu Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '230435'
20230504@180634.4338 pm6kge7hrctfk6fremp4al99tu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180634.4348 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.4360 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180634.4370 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e627766453e61a6a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6453e294876453e61a3b' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20230504@180634.4636 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.4652 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.4657 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e627766453e61a6a','aut6453e294876453e61a3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.4661 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.4664 pm6kge7hrctfk6fremp4al99tu Query : select st.usalote valor from st where st.ref = '304.422.00.07'
20230504@180634.4675 pm6kge7hrctfk6fremp4al99tu Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.422.00.07'
20230504@180634.4686 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.4700 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.4710 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.4722 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.4727 pm6kge7hrctfk6fremp4al99tu Query : select sestamp valor from se where ref ='304.422.00.07' and lote = '230222'
20230504@180634.4749 pm6kge7hrctfk6fremp4al99tu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180634.4759 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.4771 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180634.4781 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e529786453e61a74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6453e294876453e61a3b' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20230504@180634.5060 pm6kge7hrctfk6fremp4al99tu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.5075 pm6kge7hrctfk6fremp4al99tu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.5079 pm6kge7hrctfk6fremp4al99tu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e529786453e61a74','aut6453e294876453e61a3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.5084 pm6kge7hrctfk6fremp4al99tu Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6453e294876453e61a3b','','wait',39,'ari17112337378,753000005')
20230504@180634.5103 pm6kge7hrctfk6fremp4al99tu Query : use flama_phc
20230504@180634.5106 pm6kge7hrctfk6fremp4al99tu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230504@180634.5123 pm6kge7hrctfk6fremp4al99tu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='170';
20230504@180634.5136 pm6kge7hrctfk6fremp4al99tu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='170';
20230504@180634.5156 pm6kge7hrctfk6fremp4al99tu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='170';
20230504@180634.5167 pm6kge7hrctfk6fremp4al99tu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='170';
20230504@180634.5491 iop6rp3j5ph1drhl39i245rl5q Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230504@180634.5511 iop6rp3j5ph1drhl39i245rl5q Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230504@180634.5526 iop6rp3j5ph1drhl39i245rl5q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='171';
20230504@180634.5567 iop6rp3j5ph1drhl39i245rl5q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='171';
20230504@180634.5583 iop6rp3j5ph1drhl39i245rl5q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='171';
20230504@180634.5593 iop6rp3j5ph1drhl39i245rl5q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='171';
20230504@180634.5604 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.5608 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230504@180634.5619 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.5622 iop6rp3j5ph1drhl39i245rl5q Query : select no, estab,szadrsdesc from szadrs where u_coddest=4782
20230504@180634.5654 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20230504@180634.5665 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 4 and bi.ref ='304.422.00.07' and bi.lordem =20000
20230504@180634.5979 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20230504@180634.5990 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 4 and bi.ref ='324.4751.00.1' and bi.lordem =30000
20230504@180634.6324 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20230504@180634.6335 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 4 and bi.ref ='304.4320.00.1' and bi.lordem =40000
20230504@180634.6642 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6646 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230504@180634.6658 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6661 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 1 valor from td where td.ndoc = 39
20230504@180634.6671 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6674 iop6rp3j5ph1drhl39i245rl5q Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230504@180634.6685 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20230504@180634.6699 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6702 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 ~inactivo valor from cl where no = '101848' and estab = 0 order by inactivo desc
20230504@180634.6712 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6715 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230504@180634.6725 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6728 iop6rp3j5ph1drhl39i245rl5q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230504@180634.6739 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6742 iop6rp3j5ph1drhl39i245rl5q Query : select szadrsstamp valor from szadrs where szadrsdesc='101848 - media markt braga-prod.inf.e eelect.,lda'
20230504@180634.6753 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.6756 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from td where ndoc = 39
20230504@180634.6766 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230504@180634.6777 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180634.6792 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230504@180634.6809 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180634.6822 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230504@180634.6827 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180634.6839 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230504@180634.6849 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180634.6889 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230504@180634.6898 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230504@180634.6911 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230504@180634.6921 iop6rp3j5ph1drhl39i245rl5q Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6453e509836453e61aa7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230504@180634.7087 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230504@180634.7101 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230504@180634.7105 iop6rp3j5ph1drhl39i245rl5q Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e509836453e61aa7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.7110 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 fno valor from wsft039data order by fno desc
20230504@180634.7121 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230504@180634.7133 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230504@180634.7150 iop6rp3j5ph1drhl39i245rl5q Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6453e509836453e61aa7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',99,101848,0,'2023-05-04',39,'euro',0,0,2023 ,'20230504','1836',?,?,?,?,?)
20230504@180634.7435 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.7439 iop6rp3j5ph1drhl39i245rl5q Query : select st.usalote valor from st where st.ref = '304.422.00.07'
20230504@180634.7451 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.422.00.07'
20230504@180634.7462 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.7475 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.7485 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.7498 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.7502 iop6rp3j5ph1drhl39i245rl5q Query : select sestamp valor from se where ref ='304.422.00.07' and lote = '230222'
20230504@180634.7512 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230504@180634.7522 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.7534 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230504@180634.7544 iop6rp3j5ph1drhl39i245rl5q Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6453e177406453e61ab7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6453e509836453e61aa7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20230504@180634.7799 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.7821 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230504@180634.7826 iop6rp3j5ph1drhl39i245rl5q Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6453e177406453e61ab7','aut6453e509836453e61aa7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230504@180634.7830 iop6rp3j5ph1drhl39i245rl5q Query : use flama_phc
20230504@180634.7833 iop6rp3j5ph1drhl39i245rl5q Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20230504@180634.7844 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4751.00.1'
20230504@180634.7855 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230504@180634.7868 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230504@180634.7877 iop6rp3j5ph1drhl39i245rl5q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230504@180634.7889 iop6rp3j5ph1drhl39i245rl5q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230504@180634.7893 iop6rp3j5ph1drhl39i245rl5q Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2100445100a'
20230504@180634.7903 iop6rp3j5ph1drhl39i245rl5q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
