20241111@140916.5107 fi3s8s30bv3rovrp3timhfpiq6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67321141436732100c7a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67321845066732100c27' ,0,0 ,2,23.00,20000,?,?,?)
20241111@140916.5508 fi3s8s30bv3rovrp3timhfpiq6 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67321845066732100c27','2407382','wait',39,'adm09112754980.682000002')
20241111@140916.5739 fi3s8s30bv3rovrp3timhfpiq6 Query : use flama_phc
20241111@140916.5743 fi3s8s30bv3rovrp3timhfpiq6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241111@140916.5799 fi3s8s30bv3rovrp3timhfpiq6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3213';
20241111@140916.5843 fi3s8s30bv3rovrp3timhfpiq6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3213';
20241111@140916.5928 fi3s8s30bv3rovrp3timhfpiq6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3213';
20241111@140916.5981 fi3s8s30bv3rovrp3timhfpiq6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3213';
20241111@140916.6646 7v1l4preoc4jrreriut37amf7p Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241111@140916.6658 7v1l4preoc4jrreriut37amf7p Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241111@140916.6723 7v1l4preoc4jrreriut37amf7p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3214';
20241111@140916.6787 7v1l4preoc4jrreriut37amf7p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3214';
20241111@140916.6862 7v1l4preoc4jrreriut37amf7p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3214';
20241111@140916.7003 7v1l4preoc4jrreriut37amf7p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3214';
20241111@140916.7065 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7069 7v1l4preoc4jrreriut37amf7p Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241111@140916.7133 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7136 7v1l4preoc4jrreriut37amf7p Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241111@140916.7180 7v1l4preoc4jrreriut37amf7p Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241111@140916.7350 7v1l4preoc4jrreriut37amf7p Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407390 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241111@140916.7662 7v1l4preoc4jrreriut37amf7p Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241111@140916.7683 7v1l4preoc4jrreriut37amf7p Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407390 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241111@140916.7699 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7702 7v1l4preoc4jrreriut37amf7p Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241111@140916.7739 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7743 7v1l4preoc4jrreriut37amf7p Query : select top 1 1 valor from td where td.ndoc = 39
20241111@140916.7773 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7776 7v1l4preoc4jrreriut37amf7p Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241111@140916.7806 7v1l4preoc4jrreriut37amf7p Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241111@140916.7841 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7844 7v1l4preoc4jrreriut37amf7p Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241111@140916.7875 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7878 7v1l4preoc4jrreriut37amf7p Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241111@140916.7908 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7911 7v1l4preoc4jrreriut37amf7p Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241111@140916.7951 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.7954 7v1l4preoc4jrreriut37amf7p Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241111@140916.8000 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.8003 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from td where ndoc = 39
20241111@140916.8016 7v1l4preoc4jrreriut37amf7p Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241111@140916.8030 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140916.8048 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140916.8067 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140916.8084 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140916.8113 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140916.8128 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140916.8141 7v1l4preoc4jrreriut37amf7p Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140916.8216 7v1l4preoc4jrreriut37amf7p Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140916.8232 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140916.8248 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140916.8265 7v1l4preoc4jrreriut37amf7p Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67321399286732100cc6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241111@140916.8463 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140916.8484 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140916.8517 7v1l4preoc4jrreriut37amf7p Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241111@140916.8572 7v1l4preoc4jrreriut37amf7p Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241111@140916.8585 7v1l4preoc4jrreriut37amf7p Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241111@140916.8597 7v1l4preoc4jrreriut37amf7p Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241111@140916.8691 7v1l4preoc4jrreriut37amf7p Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241111@140916.8704 7v1l4preoc4jrreriut37amf7p Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241111@140916.8715 7v1l4preoc4jrreriut37amf7p Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67321399286732100cc6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241111@140916.8995 7v1l4preoc4jrreriut37amf7p Query : select top 1 fno valor from wsftdata order by fno desc
20241111@140916.9023 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140916.9040 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140916.9178 7v1l4preoc4jrreriut37amf7p Query : select 'normal' from dummy
20241111@140916.9195 7v1l4preoc4jrreriut37amf7p Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67321399286732100cc6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1775,102253,0,'2024-11-11',39,'euro',0,0,2024 ,?,?)
20241111@140916.9534 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140916.9538 7v1l4preoc4jrreriut37amf7p Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241111@140916.9693 7v1l4preoc4jrreriut37amf7p Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20241111@140916.9957 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140916.9975 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.1300 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.3000 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.3900 7v1l4preoc4jrreriut37amf7p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140917.5400 7v1l4preoc4jrreriut37amf7p Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241111@140917.7800 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.9400 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.2020 7v1l4preoc4jrreriut37amf7p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321300436732100d01','aut67321399286732100cc6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140917.2080 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.2270 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.2780 7v1l4preoc4jrreriut37amf7p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321300436732100d01',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67321399286732100cc6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241111@140917.5960 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6130 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.6400 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6550 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.6640 7v1l4preoc4jrreriut37amf7p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140917.6770 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6920 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.7060 7v1l4preoc4jrreriut37amf7p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321455166732100d10','aut67321399286732100cc6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140917.7120 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.7320 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.7770 7v1l4preoc4jrreriut37amf7p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67321455166732100d10',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67321399286732100cc6' ,0,0 ,2,23.00,20000,?,?,?)
20241111@140917.1143 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140917.1146 7v1l4preoc4jrreriut37amf7p Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241111@140917.1261 7v1l4preoc4jrreriut37amf7p Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20241111@140917.1275 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.1294 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.1319 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.1336 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.1345 7v1l4preoc4jrreriut37amf7p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140917.1357 7v1l4preoc4jrreriut37amf7p Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241111@140917.1370 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.1402 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.1415 7v1l4preoc4jrreriut37amf7p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321256646732100d21','aut67321399286732100cc6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140917.1420 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.1495 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.1525 7v1l4preoc4jrreriut37amf7p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321256646732100d21',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67321399286732100cc6' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241111@140917.1878 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.1896 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.1922 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.1940 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.1950 7v1l4preoc4jrreriut37amf7p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140917.1963 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.1981 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.1994 7v1l4preoc4jrreriut37amf7p Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321684306732100d2f','aut67321399286732100cc6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140917.1999 7v1l4preoc4jrreriut37amf7p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.2014 7v1l4preoc4jrreriut37amf7p Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.2045 7v1l4preoc4jrreriut37amf7p Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67321684306732100d2f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67321399286732100cc6' ,0,0 ,2,23.00,50000,?,?,?)
20241111@140917.2413 7v1l4preoc4jrreriut37amf7p Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67321399286732100cc6','2407390','wait',39,'adm09112754980.682000002')
20241111@140917.2553 7v1l4preoc4jrreriut37amf7p Query : use flama_phc
20241111@140917.2557 7v1l4preoc4jrreriut37amf7p Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241111@140917.2622 7v1l4preoc4jrreriut37amf7p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3214';
20241111@140917.2674 7v1l4preoc4jrreriut37amf7p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3214';
20241111@140917.2758 7v1l4preoc4jrreriut37amf7p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3214';
20241111@140917.2801 7v1l4preoc4jrreriut37amf7p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3214';
20241111@140917.3337 u3bbe5t8nuqeti6kr5mblfncfp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241111@140917.3352 u3bbe5t8nuqeti6kr5mblfncfp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241111@140917.3431 u3bbe5t8nuqeti6kr5mblfncfp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3215';
20241111@140917.3500 u3bbe5t8nuqeti6kr5mblfncfp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3215';
20241111@140917.3579 u3bbe5t8nuqeti6kr5mblfncfp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3215';
20241111@140917.3618 u3bbe5t8nuqeti6kr5mblfncfp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3215';
20241111@140917.3716 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.3719 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241111@140917.3811 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.3814 u3bbe5t8nuqeti6kr5mblfncfp Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241111@140917.3866 u3bbe5t8nuqeti6kr5mblfncfp 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'
20241111@140917.4065 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407391 and bi.ref ='324.1608.00.1' and bi.lordem =1
20241111@140917.4366 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.4370 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241111@140917.4412 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.4415 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 1 valor from td where td.ndoc = 39
20241111@140917.4453 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.4456 u3bbe5t8nuqeti6kr5mblfncfp Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241111@140917.4491 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241111@140917.4537 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.4540 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241111@140917.4739 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.4780 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241111@140917.6189 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.6231 u3bbe5t8nuqeti6kr5mblfncfp Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241111@140917.6328 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.6332 u3bbe5t8nuqeti6kr5mblfncfp Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241111@140917.6381 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.6385 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from td where ndoc = 39
20241111@140917.6398 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241111@140917.6413 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6431 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140917.6452 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6469 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140917.6499 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6515 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140917.6530 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140917.6591 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140917.6605 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6622 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140917.6638 u3bbe5t8nuqeti6kr5mblfncfp Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67321229946732100d9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241111@140917.6825 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.6978 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140917.7013 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241111@140917.7026 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241111@140917.7040 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241111@140917.7051 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241111@140917.7063 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241111@140917.7076 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241111@140917.7089 u3bbe5t8nuqeti6kr5mblfncfp Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67321229946732100d9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241111@140917.7391 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 fno valor from wsftdata order by fno desc
20241111@140917.7419 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.7437 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140917.7459 u3bbe5t8nuqeti6kr5mblfncfp Query : select 'normal' from dummy
20241111@140917.7474 u3bbe5t8nuqeti6kr5mblfncfp Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67321229946732100d9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1776,102253,0,'2024-11-11',39,'euro',0,0,2024 ,?,?)
20241111@140917.7794 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.7798 u3bbe5t8nuqeti6kr5mblfncfp Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20241111@140917.7820 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1608.00.1'
20241111@140917.7986 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.8004 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.8032 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.8049 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.8058 u3bbe5t8nuqeti6kr5mblfncfp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140917.8071 u3bbe5t8nuqeti6kr5mblfncfp Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2400237100a'
20241111@140917.8086 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.8102 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140917.8114 u3bbe5t8nuqeti6kr5mblfncfp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321193616732100dc5','aut67321229946732100d9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140917.8118 u3bbe5t8nuqeti6kr5mblfncfp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140917.8136 u3bbe5t8nuqeti6kr5mblfncfp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140917.8166 u3bbe5t8nuqeti6kr5mblfncfp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321193616732100dc5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67321229946732100d9f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241111@140917.8452 u3bbe5t8nuqeti6kr5mblfncfp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67321229946732100d9f','2407391','wait',39,'adm09112754980.682000002')
20241111@140917.8534 u3bbe5t8nuqeti6kr5mblfncfp Query : use flama_phc
20241111@140917.8537 u3bbe5t8nuqeti6kr5mblfncfp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241111@140917.8568 u3bbe5t8nuqeti6kr5mblfncfp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3215';
20241111@140917.8605 u3bbe5t8nuqeti6kr5mblfncfp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3215';
20241111@140917.8655 u3bbe5t8nuqeti6kr5mblfncfp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3215';
20241111@140917.8683 u3bbe5t8nuqeti6kr5mblfncfp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3215';
20241111@140917.9538 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241111@140917.9549 2c2dfvo7qbupd6lrhdcbf655vg Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241111@140917.9613 2c2dfvo7qbupd6lrhdcbf655vg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3216';
20241111@140917.9682 2c2dfvo7qbupd6lrhdcbf655vg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3216';
20241111@140917.9744 2c2dfvo7qbupd6lrhdcbf655vg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3216';
20241111@140917.9778 2c2dfvo7qbupd6lrhdcbf655vg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3216';
20241111@140917.9838 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140917.9842 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241111@140917.9907 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140917.9910 2c2dfvo7qbupd6lrhdcbf655vg Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241111@140917.9954 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20241111@140918.1320 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407392 and bi.ref ='324.4970.00.1' and bi.lordem =1
20241111@140918.4720 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20241111@140918.6410 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407392 and bi.ref ='324.4960.00.1' and bi.lordem =2
20241111@140918.9650 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.9690 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241111@140918.1001 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.1004 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 1 valor from td where td.ndoc = 39
20241111@140918.1033 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.1037 2c2dfvo7qbupd6lrhdcbf655vg Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241111@140918.1063 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241111@140918.1097 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.1102 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241111@140918.1132 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.1135 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241111@140918.1166 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.1168 2c2dfvo7qbupd6lrhdcbf655vg Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241111@140918.1342 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.1346 2c2dfvo7qbupd6lrhdcbf655vg Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241111@140918.1391 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.1394 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from td where ndoc = 39
20241111@140918.1406 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241111@140918.1564 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.1582 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140918.1604 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.1761 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140918.1794 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.1809 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140918.1821 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140918.1885 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140918.1898 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.1915 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140918.1931 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67321856736732100e2c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241111@140918.2120 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.2139 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140918.2172 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241111@140918.2184 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241111@140918.2196 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241111@140918.2207 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241111@140918.2218 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241111@140918.2230 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241111@140918.2240 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67321856736732100e2c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241111@140918.2511 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 fno valor from wsftdata order by fno desc
20241111@140918.2541 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.2559 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140918.2582 2c2dfvo7qbupd6lrhdcbf655vg Query : select 'normal' from dummy
20241111@140918.2598 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67321856736732100e2c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1777,102253,0,'2024-11-11',39,'euro',0,0,2024 ,?,?)
20241111@140918.2929 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.2932 2c2dfvo7qbupd6lrhdcbf655vg Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20241111@140918.2955 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20241111@140918.3319 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.3340 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140918.3363 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.3378 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140918.3386 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140918.3397 2c2dfvo7qbupd6lrhdcbf655vg Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400492200a'
20241111@140918.3417 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.3431 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140918.3442 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321633896732100e53','aut67321856736732100e2c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140918.3446 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.3481 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140918.3509 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321633896732100e53',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut67321856736732100e2c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241111@140918.3814 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.3858 2c2dfvo7qbupd6lrhdcbf655vg Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20241111@140918.4110 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20241111@140918.4271 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.4289 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140918.4316 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.4334 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140918.4344 2c2dfvo7qbupd6lrhdcbf655vg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140918.4359 2c2dfvo7qbupd6lrhdcbf655vg Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20241111@140918.4374 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.4390 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140918.4403 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321255856732100e6a','aut67321856736732100e2c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140918.4407 2c2dfvo7qbupd6lrhdcbf655vg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.4429 2c2dfvo7qbupd6lrhdcbf655vg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140918.4459 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321255856732100e6a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut67321856736732100e2c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241111@140918.4785 2c2dfvo7qbupd6lrhdcbf655vg Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67321856736732100e2c','2407392','wait',39,'adm09112754980.682000002')
20241111@140918.4932 2c2dfvo7qbupd6lrhdcbf655vg Query : use flama_phc
20241111@140918.4937 2c2dfvo7qbupd6lrhdcbf655vg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241111@140918.4990 2c2dfvo7qbupd6lrhdcbf655vg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3216';
20241111@140918.5037 2c2dfvo7qbupd6lrhdcbf655vg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3216';
20241111@140918.5124 2c2dfvo7qbupd6lrhdcbf655vg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3216';
20241111@140918.5170 2c2dfvo7qbupd6lrhdcbf655vg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3216';
20241111@140918.5775 el163dv2fid60bomds2rfraeil Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241111@140918.5796 el163dv2fid60bomds2rfraeil Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241111@140918.5909 el163dv2fid60bomds2rfraeil Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3217';
20241111@140918.5999 el163dv2fid60bomds2rfraeil Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3217';
20241111@140918.6107 el163dv2fid60bomds2rfraeil Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3217';
20241111@140918.6153 el163dv2fid60bomds2rfraeil Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3217';
20241111@140918.6263 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.6267 el163dv2fid60bomds2rfraeil Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241111@140918.6382 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.6386 el163dv2fid60bomds2rfraeil Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241111@140918.6440 el163dv2fid60bomds2rfraeil 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'
20241111@140918.6627 el163dv2fid60bomds2rfraeil Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407393 and bi.ref ='304.4320.00.1' and bi.lordem =1
20241111@140918.7105 el163dv2fid60bomds2rfraeil 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'
20241111@140918.7131 el163dv2fid60bomds2rfraeil Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407393 and bi.ref ='304.4320.00.1' and bi.lordem =1
20241111@140918.7151 el163dv2fid60bomds2rfraeil 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'
20241111@140918.7326 el163dv2fid60bomds2rfraeil Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407393 and bi.ref ='324.4751.00.1' and bi.lordem =2
20241111@140918.7618 el163dv2fid60bomds2rfraeil Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20241111@140918.7644 el163dv2fid60bomds2rfraeil Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407393 and bi.ref ='324.4970.00.1' and bi.lordem =3
20241111@140918.7948 el163dv2fid60bomds2rfraeil Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4902.00.1'
20241111@140918.7974 el163dv2fid60bomds2rfraeil Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407393 and bi.ref ='324.4902.00.1' and bi.lordem =4
20241111@140918.8287 el163dv2fid60bomds2rfraeil Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20241111@140918.8312 el163dv2fid60bomds2rfraeil Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407393 and bi.ref ='324.4960.00.1' and bi.lordem =5
20241111@140918.8639 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.8644 el163dv2fid60bomds2rfraeil Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241111@140918.8686 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.8689 el163dv2fid60bomds2rfraeil Query : select top 1 1 valor from td where td.ndoc = 39
20241111@140918.8730 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.8733 el163dv2fid60bomds2rfraeil Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241111@140918.8765 el163dv2fid60bomds2rfraeil Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241111@140918.8816 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.8819 el163dv2fid60bomds2rfraeil Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241111@140918.8859 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.8862 el163dv2fid60bomds2rfraeil Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241111@140918.8903 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.8906 el163dv2fid60bomds2rfraeil Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241111@140918.8959 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.8962 el163dv2fid60bomds2rfraeil Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241111@140918.9015 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140918.9018 el163dv2fid60bomds2rfraeil Query : select 1 valor from td where ndoc = 39
20241111@140918.9031 el163dv2fid60bomds2rfraeil Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241111@140918.9044 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.9062 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140918.9081 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.9098 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140918.9126 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.9141 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140918.9153 el163dv2fid60bomds2rfraeil Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140918.9215 el163dv2fid60bomds2rfraeil Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241111@140918.9228 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.9243 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241111@140918.9259 el163dv2fid60bomds2rfraeil Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241111@140918.9443 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.9462 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241111@140918.9499 el163dv2fid60bomds2rfraeil Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241111@140918.9510 el163dv2fid60bomds2rfraeil Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241111@140918.9522 el163dv2fid60bomds2rfraeil Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241111@140918.9534 el163dv2fid60bomds2rfraeil Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241111@140918.9545 el163dv2fid60bomds2rfraeil Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241111@140918.9556 el163dv2fid60bomds2rfraeil Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241111@140918.9567 el163dv2fid60bomds2rfraeil Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67321831796732100edf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241111@140918.9836 el163dv2fid60bomds2rfraeil Query : select top 1 fno valor from wsftdata order by fno desc
20241111@140918.9863 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140918.9882 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241111@140918.9903 el163dv2fid60bomds2rfraeil Query : select 'normal' from dummy
20241111@140918.9920 el163dv2fid60bomds2rfraeil Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67321831796732100edf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1778,102253,0,'2024-11-11',39,'euro',0,0,2024 ,?,?)
20241111@140919.2550 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140919.2850 el163dv2fid60bomds2rfraeil Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241111@140919.3120 el163dv2fid60bomds2rfraeil Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241111@140919.6380 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.6560 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.7670 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.7840 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.7920 el163dv2fid60bomds2rfraeil Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140919.8260 el163dv2fid60bomds2rfraeil Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241183'
20241111@140919.8570 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.9690 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.9990 el163dv2fid60bomds2rfraeil Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321651196732100f14','aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140919.1003 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.1019 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.1046 el163dv2fid60bomds2rfraeil Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321651196732100f14',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut67321831796732100edf' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241111@140919.1330 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140919.1334 el163dv2fid60bomds2rfraeil Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20241111@140919.1354 el163dv2fid60bomds2rfraeil Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20241111@140919.1367 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.1383 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.1410 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.1424 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.1432 el163dv2fid60bomds2rfraeil Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140919.1445 el163dv2fid60bomds2rfraeil Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '241183'
20241111@140919.1457 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.1471 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.1484 el163dv2fid60bomds2rfraeil Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321512226732100f23','aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140919.1489 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.1503 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.1593 el163dv2fid60bomds2rfraeil Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321512226732100f23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67321831796732100edf' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241111@140919.1875 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140919.1879 el163dv2fid60bomds2rfraeil Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20241111@140919.1900 el163dv2fid60bomds2rfraeil Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4751.00.1'
20241111@140919.2065 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2091 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.2117 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2145 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.2153 el163dv2fid60bomds2rfraeil Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140919.2167 el163dv2fid60bomds2rfraeil Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2400049200a'
20241111@140919.2180 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2194 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.2217 el163dv2fid60bomds2rfraeil Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321899846732100f35','aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140919.2222 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2237 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.2262 el163dv2fid60bomds2rfraeil Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321899846732100f35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut67321831796732100edf' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241111@140919.2528 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140919.2532 el163dv2fid60bomds2rfraeil Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20241111@140919.2551 el163dv2fid60bomds2rfraeil Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20241111@140919.2564 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2579 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.2603 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2617 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.2628 el163dv2fid60bomds2rfraeil Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140919.2639 el163dv2fid60bomds2rfraeil Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400492200a'
20241111@140919.2651 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2667 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.2679 el163dv2fid60bomds2rfraeil Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321168436732100f40','aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140919.2684 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.2698 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.2727 el163dv2fid60bomds2rfraeil Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321168436732100f40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut67321831796732100edf' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241111@140919.3112 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140919.3115 el163dv2fid60bomds2rfraeil Query : select st.usalote valor from st where st.ref = '324.4902.00.1'
20241111@140919.3145 el163dv2fid60bomds2rfraeil Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4902.00.1'
20241111@140919.3159 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3173 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.3196 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3209 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.3217 el163dv2fid60bomds2rfraeil Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140919.3232 el163dv2fid60bomds2rfraeil Query : select sestamp valor from se where ref ='324.4902.00.1' and lote = 'r2400145200a'
20241111@140919.3292 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3306 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.3319 el163dv2fid60bomds2rfraeil Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321912626732100f50','aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140919.3323 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3337 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.3365 el163dv2fid60bomds2rfraeil Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321912626732100f50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67321831796732100edf' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241111@140919.3652 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3668 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.3721 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3736 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.3744 el163dv2fid60bomds2rfraeil Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140919.3755 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3771 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.3782 el163dv2fid60bomds2rfraeil Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321910136732100f5b','aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140919.3787 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.3801 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.3830 el163dv2fid60bomds2rfraeil Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67321910136732100f5b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67321831796732100edf' ,0,0 ,2,23.00,60000,?,?,?)
20241111@140919.4103 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140919.4106 el163dv2fid60bomds2rfraeil Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20241111@140919.4125 el163dv2fid60bomds2rfraeil Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20241111@140919.4139 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.4156 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.4184 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.4198 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.4206 el163dv2fid60bomds2rfraeil Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241111@140919.4217 el163dv2fid60bomds2rfraeil Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20241111@140919.4241 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.4256 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241111@140919.4268 el163dv2fid60bomds2rfraeil Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67321444526732100f67','aut67321831796732100edf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241111@140919.4273 el163dv2fid60bomds2rfraeil Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.4287 el163dv2fid60bomds2rfraeil Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241111@140919.4316 el163dv2fid60bomds2rfraeil Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67321444526732100f67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67321831796732100edf' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241111@140919.4609 el163dv2fid60bomds2rfraeil Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67321831796732100edf','2407393','wait',39,'adm09112754980.682000002')
20241111@140919.4685 el163dv2fid60bomds2rfraeil Query : use flama_phc
20241111@140919.4688 el163dv2fid60bomds2rfraeil Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241111@140919.4741 el163dv2fid60bomds2rfraeil Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3217';
20241111@140919.4776 el163dv2fid60bomds2rfraeil Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3217';
20241111@140919.4986 el163dv2fid60bomds2rfraeil Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3217';
20241111@140919.5024 el163dv2fid60bomds2rfraeil Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3217';
20241111@140919.5848 m6a5tlnbacj90ct0jt67vtpfed Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241111@140919.5861 m6a5tlnbacj90ct0jt67vtpfed Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241111@140919.5926 m6a5tlnbacj90ct0jt67vtpfed Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3218';
20241111@140919.5996 m6a5tlnbacj90ct0jt67vtpfed Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3218';
20241111@140919.6059 m6a5tlnbacj90ct0jt67vtpfed Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3218';
20241111@140919.6095 m6a5tlnbacj90ct0jt67vtpfed Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3218';
20241111@140919.6154 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.6157 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241111@140919.6369 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.6373 m6a5tlnbacj90ct0jt67vtpfed Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241111@140919.6459 m6a5tlnbacj90ct0jt67vtpfed 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'
20241111@140919.6566 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407394 and bi.ref ='324.4751.00.1' and bi.lordem =1
20241111@140919.7181 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4902.00.1'
20241111@140919.7202 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2073 and bo.obrano = 2407394 and bi.ref ='324.4902.00.1' and bi.lordem =2
20241111@140919.7552 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7555 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241111@140919.7587 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7590 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 1 valor from td where td.ndoc = 39
20241111@140919.7620 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7624 m6a5tlnbacj90ct0jt67vtpfed Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241111@140919.7654 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241111@140919.7688 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7690 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241111@140919.7719 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7722 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241111@140919.7753 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7755 m6a5tlnbacj90ct0jt67vtpfed Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241111@140919.7794 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7797 m6a5tlnbacj90ct0jt67vtpfed Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241111@140919.7839 m6a5tlnbacj90ct0jt67vtpfed Query : use flama_phc
20241111@140919.7842 m6a5tlnbacj90ct0jt67vtpfed Query : select 1 valor from td where ndoc = 39
20241111@140919.7854 m6a5tlnbacj90ct0jt67vtpfed Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241111@140919.7869 m6a5tlnbacj90ct0jt67vtpfed Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241111@140919.7885 m6a5tlnbacj90ct0jt67vtpfed Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
