20240416@074620.5601 ika67r5m7a65l46tcet5k0hqlg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1158';
20240416@074620.5645 ika67r5m7a65l46tcet5k0hqlg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1158';
20240416@074620.5662 ika67r5m7a65l46tcet5k0hqlg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1158';
20240416@074620.5677 ika67r5m7a65l46tcet5k0hqlg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1158';
20240416@074620.5691 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.5694 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240416@074620.5708 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.5711 ika67r5m7a65l46tcet5k0hqlg Query : select no, estab,szadrsdesc from szadrs where u_coddest=4785
20240416@074620.5802 ika67r5m7a65l46tcet5k0hqlg 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'
20240416@074620.5967 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402718 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240416@074620.6319 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240416@074620.6500 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402718 and bi.ref ='324.4990.00.1' and bi.lordem =2
20240416@074620.6863 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.6867 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240416@074620.6880 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.6883 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 1 valor from td where td.ndoc = 39
20240416@074620.6896 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.6898 ika67r5m7a65l46tcet5k0hqlg Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240416@074620.6909 ika67r5m7a65l46tcet5k0hqlg 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
20240416@074620.6923 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.6926 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 ~inactivo valor from cl where no = '102199' and estab = 0 order by inactivo desc
20240416@074620.7031 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.7034 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240416@074620.7045 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.7049 ika67r5m7a65l46tcet5k0hqlg Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240416@074620.7059 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.7062 ika67r5m7a65l46tcet5k0hqlg Query : select szadrsstamp valor from szadrs where szadrsdesc='102199 - media markt setÚbal, lda.'
20240416@074620.7078 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.7082 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from td where ndoc = 39
20240416@074620.7094 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240416@074620.7106 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074620.7120 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240416@074620.7140 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074620.7154 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240416@074620.7186 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074620.7201 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240416@074620.7241 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074620.7340 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074620.7351 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074620.7365 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240416@074620.7376 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661e144044661e1ebcb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240416@074620.7573 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074620.7593 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240416@074620.7629 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240416@074620.7637 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240416@074620.7643 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240416@074620.7649 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240416@074620.7655 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240416@074620.7661 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240416@074620.7670 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661e144044661e1ebcb0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240416@074620.7913 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 fno valor from wsft039data order by fno desc
20240416@074620.7932 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074620.7950 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240416@074620.7970 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut661e144044661e1ebcb0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',902,102199,0,'2024-04-16',39,'euro',0,0,2024 ,'20240416','0816',?,?,?,?)
20240416@074620.8302 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.8307 ika67r5m7a65l46tcet5k0hqlg Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240416@074620.8322 ika67r5m7a65l46tcet5k0hqlg 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'
20240416@074620.8477 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074620.8493 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240416@074620.8520 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074620.8534 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240416@074620.8539 ika67r5m7a65l46tcet5k0hqlg Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240350'
20240416@074620.8557 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240416@074620.8566 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074620.8579 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240416@074620.8604 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661e191847661e1ebcd1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut661e144044661e1ebcb0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240416@074620.8848 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074620.8889 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240416@074620.8894 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut661e191847661e1ebcd1','aut661e144044661e1ebcb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240416@074620.8899 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.8902 ika67r5m7a65l46tcet5k0hqlg Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20240416@074620.8915 ika67r5m7a65l46tcet5k0hqlg 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.4990.00.1'
20240416@074620.9084 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074620.9102 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240416@074620.9127 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074620.9142 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240416@074620.9147 ika67r5m7a65l46tcet5k0hqlg Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20240416@074620.9169 ika67r5m7a65l46tcet5k0hqlg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240416@074620.9179 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074620.9192 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240416@074620.9218 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661e196573661e1ebce0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut661e144044661e1ebcb0' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240416@074620.9461 ika67r5m7a65l46tcet5k0hqlg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074620.9477 ika67r5m7a65l46tcet5k0hqlg Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240416@074620.9482 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut661e196573661e1ebce0','aut661e144044661e1ebcb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240416@074620.9486 ika67r5m7a65l46tcet5k0hqlg Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut661e144044661e1ebcb0','2402718','wait',39,'ari17112337378,753000005')
20240416@074620.9502 ika67r5m7a65l46tcet5k0hqlg Query : use flama_phc
20240416@074620.9505 ika67r5m7a65l46tcet5k0hqlg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240416@074620.9516 ika67r5m7a65l46tcet5k0hqlg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1158';
20240416@074620.9535 ika67r5m7a65l46tcet5k0hqlg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1158';
20240416@074620.9550 ika67r5m7a65l46tcet5k0hqlg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1158';
20240416@074620.9564 ika67r5m7a65l46tcet5k0hqlg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1158';
20240416@074621.8000 hdclu2ma3m8l8fq3ofnpiusso2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240416@074621.2100 hdclu2ma3m8l8fq3ofnpiusso2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240416@074621.4400 hdclu2ma3m8l8fq3ofnpiusso2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1159';
20240416@074621.8600 hdclu2ma3m8l8fq3ofnpiusso2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1159';
20240416@074621.1060 hdclu2ma3m8l8fq3ofnpiusso2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1159';
20240416@074621.1210 hdclu2ma3m8l8fq3ofnpiusso2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1159';
20240416@074621.1400 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.1440 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240416@074621.1570 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.1600 hdclu2ma3m8l8fq3ofnpiusso2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4785
20240416@074621.2040 hdclu2ma3m8l8fq3ofnpiusso2 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'
20240416@074621.4030 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402719 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240416@074621.7770 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.7820 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240416@074621.7940 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.7980 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 1 valor from td where td.ndoc = 39
20240416@074621.8080 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.8110 hdclu2ma3m8l8fq3ofnpiusso2 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240416@074621.8480 hdclu2ma3m8l8fq3ofnpiusso2 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
20240416@074621.8620 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.8650 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 ~inactivo valor from cl where no = '102199' and estab = 0 order by inactivo desc
20240416@074621.8770 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.8800 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240416@074621.8900 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.8930 hdclu2ma3m8l8fq3ofnpiusso2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240416@074621.9040 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.9070 hdclu2ma3m8l8fq3ofnpiusso2 Query : select szadrsstamp valor from szadrs where szadrsdesc='102199 - media markt setÚbal, lda.'
20240416@074621.1965 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.2005 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from td where ndoc = 39
20240416@074621.2148 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240416@074621.2160 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074621.2175 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240416@074621.2192 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074621.2205 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240416@074621.2231 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074621.2246 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240416@074621.2256 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074621.2347 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074621.2358 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074621.2371 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240416@074621.2380 hdclu2ma3m8l8fq3ofnpiusso2 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661e191784661e1ebd37' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240416@074621.2580 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074621.2594 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240416@074621.2623 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240416@074621.2628 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240416@074621.2633 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240416@074621.2639 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240416@074621.2645 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240416@074621.2650 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240416@074621.2655 hdclu2ma3m8l8fq3ofnpiusso2 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661e191784661e1ebd37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240416@074621.2889 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 fno valor from wsft039data order by fno desc
20240416@074621.2911 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074621.2926 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240416@074621.2944 hdclu2ma3m8l8fq3ofnpiusso2 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut661e191784661e1ebd37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',903,102199,0,'2024-04-16',39,'euro',0,0,2024 ,'20240416','0816',?,?,?,?)
20240416@074621.3220 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.3224 hdclu2ma3m8l8fq3ofnpiusso2 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240416@074621.3237 hdclu2ma3m8l8fq3ofnpiusso2 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'
20240416@074621.3386 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074621.3401 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240416@074621.3426 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074621.3441 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240416@074621.3446 hdclu2ma3m8l8fq3ofnpiusso2 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301097100b'
20240416@074621.3472 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240416@074621.3483 hdclu2ma3m8l8fq3ofnpiusso2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074621.3498 hdclu2ma3m8l8fq3ofnpiusso2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240416@074621.3524 hdclu2ma3m8l8fq3ofnpiusso2 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661e117356661e1ebd55',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut661e191784661e1ebd37' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240416@074621.3780 hdclu2ma3m8l8fq3ofnpiusso2 Query : use flama_phc
20240416@074621.3785 hdclu2ma3m8l8fq3ofnpiusso2 Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240416@074621.3856 hdclu2ma3m8l8fq3ofnpiusso2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1159';
20240416@074621.3875 hdclu2ma3m8l8fq3ofnpiusso2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1159';
20240416@074621.4315 tf9rcvv2f92nln4jbbvm704spp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240416@074621.4329 tf9rcvv2f92nln4jbbvm704spp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240416@074621.4353 tf9rcvv2f92nln4jbbvm704spp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1160';
20240416@074621.4399 tf9rcvv2f92nln4jbbvm704spp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1160';
20240416@074621.4418 tf9rcvv2f92nln4jbbvm704spp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1160';
20240416@074621.4432 tf9rcvv2f92nln4jbbvm704spp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1160';
20240416@074621.4474 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.4479 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240416@074621.4492 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.4495 tf9rcvv2f92nln4jbbvm704spp Query : select no, estab,szadrsdesc from szadrs where u_coddest=4785
20240416@074621.4536 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20240416@074621.5292 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402720 and bi.ref ='324.1462.00.1' and bi.lordem =1
20240416@074621.6042 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.6085 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240416@074621.6732 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.7055 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 1 valor from td where td.ndoc = 39
20240416@074621.7072 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.7075 tf9rcvv2f92nln4jbbvm704spp Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240416@074621.7087 tf9rcvv2f92nln4jbbvm704spp 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
20240416@074621.7100 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.7103 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 ~inactivo valor from cl where no = '102199' and estab = 0 order by inactivo desc
20240416@074621.7112 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.7115 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240416@074621.7124 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.7127 tf9rcvv2f92nln4jbbvm704spp Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240416@074621.7137 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.7140 tf9rcvv2f92nln4jbbvm704spp Query : select szadrsstamp valor from szadrs where szadrsdesc='102199 - media markt setÚbal, lda.'
20240416@074621.7152 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.7156 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from td where ndoc = 39
20240416@074621.7166 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240416@074621.7176 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074621.7189 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240416@074621.7205 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074621.7217 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240416@074621.7263 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074621.7275 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240416@074621.7285 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074621.7376 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074621.7387 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074621.7399 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240416@074621.7409 tf9rcvv2f92nln4jbbvm704spp Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661e158147661e1ebdb1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240416@074621.7604 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074621.7619 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240416@074621.7648 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240416@074621.7653 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240416@074621.7657 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240416@074621.7662 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240416@074621.7667 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240416@074621.7672 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240416@074621.7676 tf9rcvv2f92nln4jbbvm704spp Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661e158147661e1ebdb1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240416@074621.7948 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 fno valor from wsft039data order by fno desc
20240416@074621.7967 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074621.7980 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240416@074621.7997 tf9rcvv2f92nln4jbbvm704spp Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut661e158147661e1ebdb1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',903,102199,0,'2024-04-16',39,'euro',0,0,2024 ,'20240416','0816',?,?,?,?)
20240416@074621.8260 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.8267 tf9rcvv2f92nln4jbbvm704spp Query : select st.usalote valor from st where st.ref = '324.1462.00.1'
20240416@074621.8279 tf9rcvv2f92nln4jbbvm704spp 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.1462.00.1'
20240416@074621.8433 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074621.8447 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240416@074621.8470 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074621.8483 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240416@074621.8488 tf9rcvv2f92nln4jbbvm704spp Query : select sestamp valor from se where ref ='324.1462.00.1' and lote = 'r2101096200a'
20240416@074621.8508 tf9rcvv2f92nln4jbbvm704spp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240416@074621.8519 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074621.8531 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240416@074621.8556 tf9rcvv2f92nln4jbbvm704spp Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661e129789661e1ebdcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut661e158147661e1ebdb1' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240416@074621.8824 tf9rcvv2f92nln4jbbvm704spp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074621.8841 tf9rcvv2f92nln4jbbvm704spp Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240416@074621.8846 tf9rcvv2f92nln4jbbvm704spp Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut661e129789661e1ebdcf','aut661e158147661e1ebdb1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240416@074621.8851 tf9rcvv2f92nln4jbbvm704spp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut661e158147661e1ebdb1','2402720','wait',39,'ari17112337378,753000005')
20240416@074621.8867 tf9rcvv2f92nln4jbbvm704spp Query : use flama_phc
20240416@074621.8871 tf9rcvv2f92nln4jbbvm704spp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240416@074621.8882 tf9rcvv2f92nln4jbbvm704spp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1160';
20240416@074621.8902 tf9rcvv2f92nln4jbbvm704spp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1160';
20240416@074621.8918 tf9rcvv2f92nln4jbbvm704spp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1160';
20240416@074621.8934 tf9rcvv2f92nln4jbbvm704spp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1160';
20240416@074621.9391 qe8gs99n801m3oik048p5jq3m9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240416@074621.9406 qe8gs99n801m3oik048p5jq3m9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240416@074621.9429 qe8gs99n801m3oik048p5jq3m9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1161';
20240416@074621.9489 qe8gs99n801m3oik048p5jq3m9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1161';
20240416@074621.9507 qe8gs99n801m3oik048p5jq3m9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1161';
20240416@074621.9528 qe8gs99n801m3oik048p5jq3m9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1161';
20240416@074621.9544 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074621.9548 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240416@074621.9562 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074621.9565 qe8gs99n801m3oik048p5jq3m9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4920
20240416@074621.9650 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240416@074621.9681 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402722 and bi.ref ='324.4990.00.1' and bi.lordem =1
20240416@074621.9983 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074621.9988 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240416@074622.6000 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.1000 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 1 valor from td where td.ndoc = 39
20240416@074622.2100 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.2400 qe8gs99n801m3oik048p5jq3m9 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240416@074622.3600 qe8gs99n801m3oik048p5jq3m9 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
20240416@074622.5300 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.5700 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 ~inactivo valor from cl where no = '101711' and estab = 0 order by inactivo desc
20240416@074622.1630 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.1660 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240416@074622.1780 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.1810 qe8gs99n801m3oik048p5jq3m9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240416@074622.2160 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.2180 qe8gs99n801m3oik048p5jq3m9 Query : select szadrsstamp valor from szadrs where szadrsdesc='101711 - media markt benfica -prod.inf.elect., lda'
20240416@074622.2320 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.2360 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from td where ndoc = 39
20240416@074622.2450 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240416@074622.2580 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074622.2720 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240416@074622.2900 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074622.3040 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240416@074622.3320 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074622.3500 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240416@074622.3590 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074622.4590 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074622.4700 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074622.5090 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240416@074622.5200 qe8gs99n801m3oik048p5jq3m9 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661e194824661e1ebe08' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240416@074622.8710 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074622.8920 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240416@074622.9690 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240416@074622.9820 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240416@074622.9880 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240416@074622.9920 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240416@074622.9970 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240416@074622.1004 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240416@074622.1008 qe8gs99n801m3oik048p5jq3m9 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661e194824661e1ebe08',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240416@074622.1282 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 fno valor from wsft039data order by fno desc
20240416@074622.1302 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074622.1317 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240416@074622.1336 qe8gs99n801m3oik048p5jq3m9 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut661e194824661e1ebe08',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',904,101711,0,'2024-04-16',39,'euro',0,0,2024 ,'20240416','0816',?,?,?,?)
20240416@074622.1731 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.1736 qe8gs99n801m3oik048p5jq3m9 Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20240416@074622.1748 qe8gs99n801m3oik048p5jq3m9 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.4990.00.1'
20240416@074622.1791 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074622.1806 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240416@074622.1864 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074622.1879 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240416@074622.1884 qe8gs99n801m3oik048p5jq3m9 Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20240416@074622.1912 qe8gs99n801m3oik048p5jq3m9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240416@074622.1922 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074622.1937 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240416@074622.1976 qe8gs99n801m3oik048p5jq3m9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661e147833661e1ebe2e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut661e194824661e1ebe08' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240416@074622.2257 qe8gs99n801m3oik048p5jq3m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074622.2272 qe8gs99n801m3oik048p5jq3m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240416@074622.2276 qe8gs99n801m3oik048p5jq3m9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut661e147833661e1ebe2e','aut661e194824661e1ebe08' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240416@074622.2280 qe8gs99n801m3oik048p5jq3m9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut661e194824661e1ebe08','2402722','wait',39,'ari17112337378,753000005')
20240416@074622.2307 qe8gs99n801m3oik048p5jq3m9 Query : use flama_phc
20240416@074622.2310 qe8gs99n801m3oik048p5jq3m9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240416@074622.2321 qe8gs99n801m3oik048p5jq3m9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1161';
20240416@074622.2341 qe8gs99n801m3oik048p5jq3m9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1161';
20240416@074622.2381 qe8gs99n801m3oik048p5jq3m9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1161';
20240416@074622.2400 qe8gs99n801m3oik048p5jq3m9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1161';
20240416@074622.3162 64su8afv9bpdge4pi0a7msaesd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240416@074622.3175 64su8afv9bpdge4pi0a7msaesd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240416@074622.3199 64su8afv9bpdge4pi0a7msaesd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1162';
20240416@074622.3244 64su8afv9bpdge4pi0a7msaesd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1162';
20240416@074622.3261 64su8afv9bpdge4pi0a7msaesd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1162';
20240416@074622.3276 64su8afv9bpdge4pi0a7msaesd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1162';
20240416@074622.3290 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3294 64su8afv9bpdge4pi0a7msaesd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240416@074622.3307 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3311 64su8afv9bpdge4pi0a7msaesd Query : select no, estab,szadrsdesc from szadrs where u_coddest=4782
20240416@074622.3395 64su8afv9bpdge4pi0a7msaesd 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'
20240416@074622.3406 64su8afv9bpdge4pi0a7msaesd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402733 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240416@074622.3751 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3755 64su8afv9bpdge4pi0a7msaesd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240416@074622.3772 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3776 64su8afv9bpdge4pi0a7msaesd Query : select top 1 1 valor from td where td.ndoc = 39
20240416@074622.3788 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3791 64su8afv9bpdge4pi0a7msaesd Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240416@074622.3805 64su8afv9bpdge4pi0a7msaesd 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
20240416@074622.3821 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3825 64su8afv9bpdge4pi0a7msaesd Query : select top 1 ~inactivo valor from cl where no = '101848' and estab = 0 order by inactivo desc
20240416@074622.3930 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3934 64su8afv9bpdge4pi0a7msaesd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240416@074622.3946 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3950 64su8afv9bpdge4pi0a7msaesd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240416@074622.3963 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3966 64su8afv9bpdge4pi0a7msaesd Query : select szadrsstamp valor from szadrs where szadrsdesc='101848 - media markt braga-prod.inf.e eelect.,lda'
20240416@074622.3980 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.3984 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from td where ndoc = 39
20240416@074622.3994 64su8afv9bpdge4pi0a7msaesd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240416@074622.4007 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074622.4028 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240416@074622.4051 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074622.4066 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240416@074622.4115 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074622.4128 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240416@074622.4140 64su8afv9bpdge4pi0a7msaesd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074622.4241 64su8afv9bpdge4pi0a7msaesd Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074622.4254 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074622.4271 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240416@074622.4286 64su8afv9bpdge4pi0a7msaesd Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661e107819661e1ebe65' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240416@074622.4477 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074622.4493 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240416@074622.4523 64su8afv9bpdge4pi0a7msaesd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240416@074622.4528 64su8afv9bpdge4pi0a7msaesd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240416@074622.4534 64su8afv9bpdge4pi0a7msaesd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240416@074622.4539 64su8afv9bpdge4pi0a7msaesd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240416@074622.4544 64su8afv9bpdge4pi0a7msaesd Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240416@074622.4549 64su8afv9bpdge4pi0a7msaesd Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240416@074622.4553 64su8afv9bpdge4pi0a7msaesd Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661e107819661e1ebe65',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240416@074622.4947 64su8afv9bpdge4pi0a7msaesd Query : select top 1 fno valor from wsft039data order by fno desc
20240416@074622.4967 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074622.4987 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240416@074622.5012 64su8afv9bpdge4pi0a7msaesd Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut661e107819661e1ebe65',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',905,101848,0,'2024-04-16',39,'euro',0,0,2024 ,'20240416','0816',?,?,?,?)
20240416@074622.5349 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.5355 64su8afv9bpdge4pi0a7msaesd Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240416@074622.5373 64su8afv9bpdge4pi0a7msaesd 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'
20240416@074622.5407 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074622.5423 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240416@074622.5452 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074622.5468 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240416@074622.5473 64su8afv9bpdge4pi0a7msaesd Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301097100b'
20240416@074622.5479 64su8afv9bpdge4pi0a7msaesd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240416@074622.5491 64su8afv9bpdge4pi0a7msaesd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074622.5508 64su8afv9bpdge4pi0a7msaesd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240416@074622.5542 64su8afv9bpdge4pi0a7msaesd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661e167726661e1ebe86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut661e107819661e1ebe65' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240416@074622.5865 64su8afv9bpdge4pi0a7msaesd Query : use flama_phc
20240416@074622.5870 64su8afv9bpdge4pi0a7msaesd Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240416@074622.5886 64su8afv9bpdge4pi0a7msaesd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1162';
20240416@074622.5909 64su8afv9bpdge4pi0a7msaesd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1162';
20240416@074622.6388 su1baf9elf6kb630f03pgq4jjd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240416@074622.6402 su1baf9elf6kb630f03pgq4jjd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240416@074622.6430 su1baf9elf6kb630f03pgq4jjd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1163';
20240416@074622.6478 su1baf9elf6kb630f03pgq4jjd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1163';
20240416@074622.6497 su1baf9elf6kb630f03pgq4jjd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1163';
20240416@074622.6514 su1baf9elf6kb630f03pgq4jjd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1163';
20240416@074622.6529 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.6533 su1baf9elf6kb630f03pgq4jjd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240416@074622.6548 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.6551 su1baf9elf6kb630f03pgq4jjd Query : select no, estab,szadrsdesc from szadrs where u_coddest=4781
20240416@074622.6636 su1baf9elf6kb630f03pgq4jjd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20240416@074622.6831 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402735 and bi.ref ='324.1608.00.1' and bi.lordem =1
20240416@074622.7158 su1baf9elf6kb630f03pgq4jjd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1470.00.1'
20240416@074622.7170 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402735 and bi.ref ='324.1470.00.1' and bi.lordem =2
20240416@074622.7494 su1baf9elf6kb630f03pgq4jjd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240416@074622.7505 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402735 and bi.ref ='324.4990.00.1' and bi.lordem =3
20240416@074622.7925 su1baf9elf6kb630f03pgq4jjd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20240416@074622.8080 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2027 and bo.obrano = 2402735 and bi.ref ='324.4421.00.1' and bi.lordem =4
20240416@074622.8437 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8441 su1baf9elf6kb630f03pgq4jjd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240416@074622.8457 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8460 su1baf9elf6kb630f03pgq4jjd Query : select top 1 1 valor from td where td.ndoc = 39
20240416@074622.8470 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8473 su1baf9elf6kb630f03pgq4jjd Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240416@074622.8484 su1baf9elf6kb630f03pgq4jjd 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
20240416@074622.8497 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8500 su1baf9elf6kb630f03pgq4jjd Query : select top 1 ~inactivo valor from cl where no = '102040' and estab = 0 order by inactivo desc
20240416@074622.8632 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8635 su1baf9elf6kb630f03pgq4jjd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240416@074622.8652 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8655 su1baf9elf6kb630f03pgq4jjd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240416@074622.8666 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8669 su1baf9elf6kb630f03pgq4jjd Query : select szadrsstamp valor from szadrs where szadrsdesc='102040 - media markt gaia-prod.inf.e electrÓnicos,lda.'
20240416@074622.8682 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.8685 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from td where ndoc = 39
20240416@074622.8695 su1baf9elf6kb630f03pgq4jjd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240416@074622.8707 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074622.8722 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240416@074622.8741 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074622.8757 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240416@074622.8789 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074622.8803 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240416@074622.8816 su1baf9elf6kb630f03pgq4jjd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074622.8907 su1baf9elf6kb630f03pgq4jjd Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240416@074622.8917 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240416@074622.8930 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240416@074622.8940 su1baf9elf6kb630f03pgq4jjd Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661e168245661e1ebed7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240416@074622.9118 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240416@074622.9135 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240416@074622.9167 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240416@074622.9173 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240416@074622.9178 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240416@074622.9183 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240416@074622.9189 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240416@074622.9194 su1baf9elf6kb630f03pgq4jjd Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240416@074622.9199 su1baf9elf6kb630f03pgq4jjd Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661e168245661e1ebed7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240416@074622.9494 su1baf9elf6kb630f03pgq4jjd Query : select top 1 fno valor from wsft039data order by fno desc
20240416@074622.9514 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240416@074622.9528 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240416@074622.9551 su1baf9elf6kb630f03pgq4jjd Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut661e168245661e1ebed7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',905,102040,0,'2024-04-16',39,'euro',0,0,2024 ,'20240416','0816',?,?,?,?)
20240416@074622.9834 su1baf9elf6kb630f03pgq4jjd Query : use flama_phc
20240416@074622.9870 su1baf9elf6kb630f03pgq4jjd Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20240416@074622.9914 su1baf9elf6kb630f03pgq4jjd 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.1608.00.1'
20240416@074623.1250 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074623.1440 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240416@074623.1780 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074623.1940 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240416@074623.1990 su1baf9elf6kb630f03pgq4jjd Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2200658200a'
20240416@074623.2200 su1baf9elf6kb630f03pgq4jjd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240416@074623.1115 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240416@074623.1639 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240416@074623.1672 su1baf9elf6kb630f03pgq4jjd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661e116895661e1ebf1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut661e168245661e1ebed7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240416@074623.1937 su1baf9elf6kb630f03pgq4jjd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240416@074623.1954 su1baf9elf6kb630f03pgq4jjd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240416@074623.1960 su1baf9elf6kb630f03pgq4jjd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut661e116895661e1ebf1b','aut661e168245661e1ebed7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
