20241113@151616.1241 bcm5snv3blp7vh31b64updrqr4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3282';
20241113@151616.1279 bcm5snv3blp7vh31b64updrqr4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3282';
20241113@151616.1338 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.1342 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241113@151616.1400 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.1404 bcm5snv3blp7vh31b64updrqr4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20241113@151616.1530 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151616.1749 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407545 and bi.ref ='324.646.00.01' and bi.lordem =1
20241113@151616.2204 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151616.2227 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407545 and bi.ref ='324.646.00.01' and bi.lordem =2
20241113@151616.2566 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241113@151616.4307 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407545 and bi.ref ='324.5343.00.1' and bi.lordem =3
20241113@151616.4779 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.4783 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241113@151616.4815 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.4818 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 1 valor from td where td.ndoc = 39
20241113@151616.4846 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.4849 bcm5snv3blp7vh31b64updrqr4 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')
20241113@151616.4876 bcm5snv3blp7vh31b64updrqr4 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
20241113@151616.4910 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.4913 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241113@151616.5049 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.5053 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241113@151616.5084 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.5087 bcm5snv3blp7vh31b64updrqr4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241113@151616.5133 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.5136 bcm5snv3blp7vh31b64updrqr4 Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - caldas da rainha'
20241113@151616.5187 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.5190 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from td where ndoc = 39
20241113@151616.5201 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241113@151616.5214 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.5230 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151616.5247 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.5260 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151616.5284 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.5299 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151616.5310 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151616.5372 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151616.5384 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.5399 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151616.5413 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6734c120166734c2c081' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241113@151616.5603 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.5622 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151616.5661 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241113@151616.5673 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241113@151616.5685 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241113@151616.5701 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241113@151616.5715 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241113@151616.5728 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241113@151616.5749 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6734c120166734c2c081',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241113@151616.6122 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 fno valor from wsftdata order by fno desc
20241113@151616.6311 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.6329 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151616.6353 bcm5snv3blp7vh31b64updrqr4 Query : select 'normal' from dummy
20241113@151616.6369 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6734c120166734c2c081',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1840,101621,0,'2024-11-13',39,'euro',0,0,2024 ,?,?)
20241113@151616.6765 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.6768 bcm5snv3blp7vh31b64updrqr4 Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151616.6793 bcm5snv3blp7vh31b64updrqr4 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.646.00.01'
20241113@151616.6951 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.6967 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.6994 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7010 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.7019 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151616.7031 bcm5snv3blp7vh31b64updrqr4 Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151616.7046 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7061 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.7073 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c196536734c2c0ac','aut6734c120166734c2c081' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151616.7077 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7093 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.7119 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c196536734c2c0ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6734c120166734c2c081' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241113@151616.7468 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7485 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.7509 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7522 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.7537 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151616.7550 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7563 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.7580 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c669876734c2c0b8','aut6734c120166734c2c081' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151616.7585 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7606 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.7633 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c669876734c2c0b8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c120166734c2c081' ,0,0 ,2,23.00,20000,?,?,?)
20241113@151616.7931 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.7934 bcm5snv3blp7vh31b64updrqr4 Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151616.7952 bcm5snv3blp7vh31b64updrqr4 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.646.00.01'
20241113@151616.7966 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.7984 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.8008 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.8022 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.8030 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151616.8043 bcm5snv3blp7vh31b64updrqr4 Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151616.8056 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.8070 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.8081 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c884106734c2c0c4','aut6734c120166734c2c081' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151616.8085 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.8127 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.8154 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c884106734c2c0c4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6734c120166734c2c081' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241113@151616.8443 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.8461 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.8488 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.8504 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.8512 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151616.8525 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.8540 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.8554 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c992866734c2c0d0','aut6734c120166734c2c081' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151616.8558 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.8576 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.8605 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c992866734c2c0d0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c120166734c2c081' ,0,0 ,2,23.00,50000,?,?,?)
20241113@151616.8959 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151616.8962 bcm5snv3blp7vh31b64updrqr4 Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20241113@151616.8982 bcm5snv3blp7vh31b64updrqr4 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.5343.00.1'
20241113@151616.9150 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9165 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.9188 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9202 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.9210 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151616.9222 bcm5snv3blp7vh31b64updrqr4 Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20241113@151616.9243 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9258 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.9269 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c525196734c2c0e1','aut6734c120166734c2c081' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151616.9273 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9286 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.9315 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c525196734c2c0e1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6734c120166734c2c081' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241113@151616.9618 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9635 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.9660 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9675 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.9683 bcm5snv3blp7vh31b64updrqr4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151616.9696 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9710 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151616.9724 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c031356734c2c0ec','aut6734c120166734c2c081' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151616.9728 bcm5snv3blp7vh31b64updrqr4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151616.9743 bcm5snv3blp7vh31b64updrqr4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151616.9768 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c031356734c2c0ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c120166734c2c081' ,0,0 ,2,23.00,80000,?,?,?)
20241113@151617.2380 bcm5snv3blp7vh31b64updrqr4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6734c120166734c2c081','2407545','wait',39,'adm09112754980.682000002')
20241113@151617.3230 bcm5snv3blp7vh31b64updrqr4 Query : use flama_phc
20241113@151617.3270 bcm5snv3blp7vh31b64updrqr4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241113@151617.3560 bcm5snv3blp7vh31b64updrqr4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3282';
20241113@151617.3940 bcm5snv3blp7vh31b64updrqr4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3282';
20241113@151617.4400 bcm5snv3blp7vh31b64updrqr4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3282';
20241113@151617.4710 bcm5snv3blp7vh31b64updrqr4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3282';
20241113@151617.1110 r096bg99k302hhae5m7d5h221t Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241113@151617.1120 r096bg99k302hhae5m7d5h221t Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241113@151617.1185 r096bg99k302hhae5m7d5h221t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3283';
20241113@151617.1249 r096bg99k302hhae5m7d5h221t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3283';
20241113@151617.1305 r096bg99k302hhae5m7d5h221t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3283';
20241113@151617.1336 r096bg99k302hhae5m7d5h221t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3283';
20241113@151617.1388 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.1391 r096bg99k302hhae5m7d5h221t Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241113@151617.1452 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.1455 r096bg99k302hhae5m7d5h221t Query : select no, estab,szadrsdesc from szadrs where u_coddest=6855
20241113@151617.1546 r096bg99k302hhae5m7d5h221t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151617.1567 r096bg99k302hhae5m7d5h221t Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407546 and bi.ref ='324.646.00.01' and bi.lordem =1
20241113@151617.1919 r096bg99k302hhae5m7d5h221t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151617.1944 r096bg99k302hhae5m7d5h221t Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407546 and bi.ref ='324.646.00.01' and bi.lordem =2
20241113@151617.2297 r096bg99k302hhae5m7d5h221t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151617.2317 r096bg99k302hhae5m7d5h221t Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407546 and bi.ref ='324.646.00.01' and bi.lordem =3
20241113@151617.2661 r096bg99k302hhae5m7d5h221t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151617.2681 r096bg99k302hhae5m7d5h221t Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407546 and bi.ref ='324.646.00.01' and bi.lordem =4
20241113@151617.3023 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3026 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241113@151617.3064 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3067 r096bg99k302hhae5m7d5h221t Query : select top 1 1 valor from td where td.ndoc = 39
20241113@151617.3096 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3099 r096bg99k302hhae5m7d5h221t 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')
20241113@151617.3132 r096bg99k302hhae5m7d5h221t 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
20241113@151617.3167 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3170 r096bg99k302hhae5m7d5h221t Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241113@151617.3198 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3201 r096bg99k302hhae5m7d5h221t Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241113@151617.3229 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3232 r096bg99k302hhae5m7d5h221t Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241113@151617.3271 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3273 r096bg99k302hhae5m7d5h221t Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - montijo nova'
20241113@151617.3322 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.3325 r096bg99k302hhae5m7d5h221t Query : select 1 valor from td where ndoc = 39
20241113@151617.3339 r096bg99k302hhae5m7d5h221t Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241113@151617.3354 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.3373 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151617.3394 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.3410 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151617.3441 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.3456 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151617.3468 r096bg99k302hhae5m7d5h221t Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151617.3529 r096bg99k302hhae5m7d5h221t Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151617.3543 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.3559 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151617.3578 r096bg99k302hhae5m7d5h221t Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241113@151617.3795 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.3814 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151617.3856 r096bg99k302hhae5m7d5h221t Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241113@151617.3869 r096bg99k302hhae5m7d5h221t Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241113@151617.3882 r096bg99k302hhae5m7d5h221t Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241113@151617.3896 r096bg99k302hhae5m7d5h221t Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241113@151617.3908 r096bg99k302hhae5m7d5h221t Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241113@151617.3919 r096bg99k302hhae5m7d5h221t Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241113@151617.3929 r096bg99k302hhae5m7d5h221t Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6734c615606734c2c154',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241113@151617.4238 r096bg99k302hhae5m7d5h221t Query : select top 1 fno valor from wsftdata order by fno desc
20241113@151617.4270 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.4287 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151617.4312 r096bg99k302hhae5m7d5h221t Query : select 'normal' from dummy
20241113@151617.4328 r096bg99k302hhae5m7d5h221t Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6734c615606734c2c154',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1841,101621,0,'2024-11-13',39,'euro',0,0,2024 ,?,?)
20241113@151617.4679 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.4682 r096bg99k302hhae5m7d5h221t Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151617.4704 r096bg99k302hhae5m7d5h221t 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.646.00.01'
20241113@151617.4717 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.4733 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.4760 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.4774 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.4782 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.4795 r096bg99k302hhae5m7d5h221t Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151617.4807 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.4822 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.4833 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c601506734c2c175','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.4838 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.4868 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.4896 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c601506734c2c175',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241113@151617.5202 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5218 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.5243 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5257 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.5265 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.5278 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5292 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.5303 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c335886734c2c180','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.5308 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5325 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.5356 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c335886734c2c180',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,20000,?,?,?)
20241113@151617.5646 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.5649 r096bg99k302hhae5m7d5h221t Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151617.5667 r096bg99k302hhae5m7d5h221t 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.646.00.01'
20241113@151617.5681 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5718 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.5744 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5758 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.5766 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.5779 r096bg99k302hhae5m7d5h221t Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151617.5793 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5808 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.5819 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c972946734c2c18d','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.5823 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.5838 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.5867 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c972946734c2c18d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241113@151617.6178 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6195 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.6219 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6234 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.6243 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.6256 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6271 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.6285 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c146586734c2c198','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.6290 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6305 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.6333 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c146586734c2c198',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,50000,?,?,?)
20241113@151617.6677 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.6680 r096bg99k302hhae5m7d5h221t Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151617.6700 r096bg99k302hhae5m7d5h221t 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.646.00.01'
20241113@151617.6713 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6729 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.6754 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6768 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.6776 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.6789 r096bg99k302hhae5m7d5h221t Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151617.6803 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6819 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.6830 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c291336734c2c1a6','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.6835 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.6850 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.6885 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c291336734c2c1a6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241113@151617.7186 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7202 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.7231 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7248 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.7256 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.7269 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7283 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.7295 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c606496734c2c1b1','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.7300 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7318 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.7346 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c606496734c2c1b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,80000,?,?,?)
20241113@151617.7647 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.7650 r096bg99k302hhae5m7d5h221t Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151617.7669 r096bg99k302hhae5m7d5h221t 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.646.00.01'
20241113@151617.7683 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7699 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.7722 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7736 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.7747 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.7758 r096bg99k302hhae5m7d5h221t Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151617.7770 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7784 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.7797 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c150236734c2c1bd','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.7801 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.7816 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.7849 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c150236734c2c1bd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241113@151617.8159 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.8176 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.8202 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.8217 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.8225 r096bg99k302hhae5m7d5h221t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151617.8241 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.8255 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151617.8266 r096bg99k302hhae5m7d5h221t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c532096734c2c1c9','aut6734c615606734c2c154' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151617.8271 r096bg99k302hhae5m7d5h221t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151617.8285 r096bg99k302hhae5m7d5h221t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151617.8312 r096bg99k302hhae5m7d5h221t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c532096734c2c1c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c615606734c2c154' ,0,0 ,2,23.00,110000,?,?,?)
20241113@151617.8619 r096bg99k302hhae5m7d5h221t Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6734c615606734c2c154','2407546','wait',39,'adm09112754980.682000002')
20241113@151617.8689 r096bg99k302hhae5m7d5h221t Query : use flama_phc
20241113@151617.8693 r096bg99k302hhae5m7d5h221t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241113@151617.8725 r096bg99k302hhae5m7d5h221t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3283';
20241113@151617.8763 r096bg99k302hhae5m7d5h221t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3283';
20241113@151617.8826 r096bg99k302hhae5m7d5h221t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3283';
20241113@151617.8866 r096bg99k302hhae5m7d5h221t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3283';
20241113@151617.9545 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241113@151617.9557 etfcb2bb8nso1qomfsk0cd4a2j Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241113@151617.9622 etfcb2bb8nso1qomfsk0cd4a2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3284';
20241113@151617.9683 etfcb2bb8nso1qomfsk0cd4a2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3284';
20241113@151617.9739 etfcb2bb8nso1qomfsk0cd4a2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3284';
20241113@151617.9770 etfcb2bb8nso1qomfsk0cd4a2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3284';
20241113@151617.9859 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151617.9864 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241113@151617.9932 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151617.9938 etfcb2bb8nso1qomfsk0cd4a2j Query : select no, estab,szadrsdesc from szadrs where u_coddest=8923
20241113@151618.3900 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151618.6000 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407547 and bi.ref ='324.646.00.01' and bi.lordem =1
20241113@151618.4120 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151618.4370 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407547 and bi.ref ='324.646.00.01' and bi.lordem =2
20241113@151618.9130 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241113@151618.1065 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407547 and bi.ref ='324.5343.00.1' and bi.lordem =3
20241113@151618.1443 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1446 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241113@151618.1528 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1534 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 1 valor from td where td.ndoc = 39
20241113@151618.1571 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1574 etfcb2bb8nso1qomfsk0cd4a2j 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')
20241113@151618.1601 etfcb2bb8nso1qomfsk0cd4a2j 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
20241113@151618.1634 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1638 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241113@151618.1674 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1677 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241113@151618.1706 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1709 etfcb2bb8nso1qomfsk0cd4a2j Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241113@151618.1757 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1760 etfcb2bb8nso1qomfsk0cd4a2j Query : select szadrsstamp valor from szadrs where szadrsdesc='jom- gondomar'
20241113@151618.1806 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.1809 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from td where ndoc = 39
20241113@151618.1912 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241113@151618.2079 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.2097 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151618.2118 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.2132 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151618.2212 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.2229 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151618.2259 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151618.2319 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151618.2331 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.2348 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151618.2363 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6734c644796734c2c237' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241113@151618.2591 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.2610 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151618.2644 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241113@151618.2657 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241113@151618.2673 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241113@151618.2685 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241113@151618.2698 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241113@151618.2710 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241113@151618.2724 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6734c644796734c2c237',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241113@151618.3058 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 fno valor from wsftdata order by fno desc
20241113@151618.3087 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.3111 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151618.3133 etfcb2bb8nso1qomfsk0cd4a2j Query : select 'normal' from dummy
20241113@151618.3149 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6734c644796734c2c237',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1842,101621,0,'2024-11-13',39,'euro',0,0,2024 ,?,?)
20241113@151618.3502 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.3506 etfcb2bb8nso1qomfsk0cd4a2j Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151618.3527 etfcb2bb8nso1qomfsk0cd4a2j 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.646.00.01'
20241113@151618.3541 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.3557 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.3581 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.3599 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.3608 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151618.3620 etfcb2bb8nso1qomfsk0cd4a2j Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151618.3633 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.3815 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.4186 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c311576734c2c258','aut6734c644796734c2c237' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151618.4367 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.4858 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.4906 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c311576734c2c258',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6734c644796734c2c237' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241113@151618.5368 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.5386 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.5411 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.5427 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.5435 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151618.5449 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.5464 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.5475 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c853706734c2c285','aut6734c644796734c2c237' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151618.5480 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.5494 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.5521 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c853706734c2c285',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c644796734c2c237' ,0,0 ,2,23.00,20000,?,?,?)
20241113@151618.5830 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.5833 etfcb2bb8nso1qomfsk0cd4a2j Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151618.5853 etfcb2bb8nso1qomfsk0cd4a2j 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.646.00.01'
20241113@151618.5866 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.5882 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.5909 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.5927 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.5939 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151618.5953 etfcb2bb8nso1qomfsk0cd4a2j Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151618.5967 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.5982 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.5996 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c182556734c2c291','aut6734c644796734c2c237' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151618.6000 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6014 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.6041 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c182556734c2c291',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6734c644796734c2c237' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241113@151618.6349 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6365 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.6391 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6404 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.6413 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151618.6425 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6438 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.6449 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c750216734c2c29c','aut6734c644796734c2c237' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151618.6454 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6468 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.6494 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c750216734c2c29c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c644796734c2c237' ,0,0 ,2,23.00,50000,?,?,?)
20241113@151618.6805 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.6808 etfcb2bb8nso1qomfsk0cd4a2j Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20241113@151618.6833 etfcb2bb8nso1qomfsk0cd4a2j 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.5343.00.1'
20241113@151618.6848 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6864 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.6889 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6904 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.6912 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151618.6923 etfcb2bb8nso1qomfsk0cd4a2j Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20241113@151618.6935 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6949 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.6960 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c474316734c2c2a9','aut6734c644796734c2c237' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151618.6965 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.6979 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.7008 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c474316734c2c2a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6734c644796734c2c237' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241113@151618.7325 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.7343 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.7369 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.7384 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.7393 etfcb2bb8nso1qomfsk0cd4a2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151618.7406 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.7422 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151618.7434 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c231576734c2c2b4','aut6734c644796734c2c237' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151618.7440 etfcb2bb8nso1qomfsk0cd4a2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151618.7454 etfcb2bb8nso1qomfsk0cd4a2j Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151618.7481 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c231576734c2c2b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c644796734c2c237' ,0,0 ,2,23.00,80000,?,?,?)
20241113@151618.7804 etfcb2bb8nso1qomfsk0cd4a2j Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6734c644796734c2c237','2407547','wait',39,'adm09112754980.682000002')
20241113@151618.7897 etfcb2bb8nso1qomfsk0cd4a2j Query : use flama_phc
20241113@151618.7902 etfcb2bb8nso1qomfsk0cd4a2j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241113@151618.7932 etfcb2bb8nso1qomfsk0cd4a2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3284';
20241113@151618.7973 etfcb2bb8nso1qomfsk0cd4a2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3284';
20241113@151618.8022 etfcb2bb8nso1qomfsk0cd4a2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3284';
20241113@151618.8063 etfcb2bb8nso1qomfsk0cd4a2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3284';
20241113@151618.8768 2g55j8354q4e18akvlq9kp14kc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241113@151618.8804 2g55j8354q4e18akvlq9kp14kc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241113@151618.8926 2g55j8354q4e18akvlq9kp14kc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3285';
20241113@151618.9018 2g55j8354q4e18akvlq9kp14kc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3285';
20241113@151618.9114 2g55j8354q4e18akvlq9kp14kc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3285';
20241113@151618.9158 2g55j8354q4e18akvlq9kp14kc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3285';
20241113@151618.9251 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151618.9254 2g55j8354q4e18akvlq9kp14kc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241113@151618.9353 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151618.9357 2g55j8354q4e18akvlq9kp14kc Query : select no, estab,szadrsdesc from szadrs where u_coddest=1498
20241113@151618.9452 2g55j8354q4e18akvlq9kp14kc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151618.9512 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407548 and bi.ref ='324.646.00.01' and bi.lordem =1
20241113@151619.1140 2g55j8354q4e18akvlq9kp14kc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151619.1410 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407548 and bi.ref ='324.646.00.01' and bi.lordem =2
20241113@151619.5110 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.5150 2g55j8354q4e18akvlq9kp14kc Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241113@151619.5540 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.5580 2g55j8354q4e18akvlq9kp14kc Query : select top 1 1 valor from td where td.ndoc = 39
20241113@151619.5910 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.5940 2g55j8354q4e18akvlq9kp14kc 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')
20241113@151619.6210 2g55j8354q4e18akvlq9kp14kc 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
20241113@151619.6680 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.6720 2g55j8354q4e18akvlq9kp14kc Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241113@151619.7080 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.7110 2g55j8354q4e18akvlq9kp14kc Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241113@151619.7670 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.7720 2g55j8354q4e18akvlq9kp14kc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241113@151619.8280 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.8310 2g55j8354q4e18akvlq9kp14kc Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m - viseu'
20241113@151619.8800 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.8830 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from td where ndoc = 39
20241113@151619.9040 2g55j8354q4e18akvlq9kp14kc Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241113@151619.9170 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.9330 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151619.9520 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.9650 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151619.9940 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.1011 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151619.1023 2g55j8354q4e18akvlq9kp14kc Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151619.1089 2g55j8354q4e18akvlq9kp14kc Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151619.1101 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.1117 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151619.1188 2g55j8354q4e18akvlq9kp14kc Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6734c474896734c2c318' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241113@151619.1391 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.1412 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151619.1620 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241113@151619.1632 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241113@151619.1644 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241113@151619.1701 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241113@151619.1712 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241113@151619.1727 2g55j8354q4e18akvlq9kp14kc Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241113@151619.1742 2g55j8354q4e18akvlq9kp14kc Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6734c474896734c2c318',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241113@151619.2040 2g55j8354q4e18akvlq9kp14kc Query : select top 1 fno valor from wsftdata order by fno desc
20241113@151619.2089 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.2129 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151619.2156 2g55j8354q4e18akvlq9kp14kc Query : select 'normal' from dummy
20241113@151619.2173 2g55j8354q4e18akvlq9kp14kc Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6734c474896734c2c318',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1843,101621,0,'2024-11-13',39,'euro',0,0,2024 ,?,?)
20241113@151619.2587 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.2590 2g55j8354q4e18akvlq9kp14kc Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151619.2612 2g55j8354q4e18akvlq9kp14kc 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.646.00.01'
20241113@151619.2628 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.2645 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.2673 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.2698 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.2708 2g55j8354q4e18akvlq9kp14kc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151619.2722 2g55j8354q4e18akvlq9kp14kc Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151619.2749 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.2765 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.2777 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c703096734c2c343','aut6734c474896734c2c318' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151619.2782 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.2801 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.2835 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c703096734c2c343',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6734c474896734c2c318' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241113@151619.3134 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3152 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.3179 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3198 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.3208 2g55j8354q4e18akvlq9kp14kc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151619.3222 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3238 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.3252 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c182856734c2c34e','aut6734c474896734c2c318' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151619.3257 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3272 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.3302 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c182856734c2c34e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c474896734c2c318' ,0,0 ,2,23.00,20000,?,?,?)
20241113@151619.3618 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.3621 2g55j8354q4e18akvlq9kp14kc Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151619.3641 2g55j8354q4e18akvlq9kp14kc 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.646.00.01'
20241113@151619.3656 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3672 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.3698 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3715 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.3725 2g55j8354q4e18akvlq9kp14kc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151619.3738 2g55j8354q4e18akvlq9kp14kc Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151619.3752 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3769 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.3781 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c486896734c2c35b','aut6734c474896734c2c318' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151619.3786 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.3802 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.3832 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6734c486896734c2c35b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6734c474896734c2c318' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241113@151619.4160 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.4177 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.4205 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.4221 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.4230 2g55j8354q4e18akvlq9kp14kc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151619.4244 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.4259 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.4271 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c715036734c2c367','aut6734c474896734c2c318' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151619.4276 2g55j8354q4e18akvlq9kp14kc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.4301 2g55j8354q4e18akvlq9kp14kc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.4330 2g55j8354q4e18akvlq9kp14kc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6734c715036734c2c367',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6734c474896734c2c318' ,0,0 ,2,23.00,50000,?,?,?)
20241113@151619.4627 2g55j8354q4e18akvlq9kp14kc Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6734c474896734c2c318','2407548','wait',39,'adm09112754980.682000002')
20241113@151619.4702 2g55j8354q4e18akvlq9kp14kc Query : use flama_phc
20241113@151619.4706 2g55j8354q4e18akvlq9kp14kc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241113@151619.4738 2g55j8354q4e18akvlq9kp14kc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3285';
20241113@151619.4778 2g55j8354q4e18akvlq9kp14kc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3285';
20241113@151619.4827 2g55j8354q4e18akvlq9kp14kc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3285';
20241113@151619.4859 2g55j8354q4e18akvlq9kp14kc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3285';
20241113@151619.5369 ucslcohsjavoog7gl4ch7c8vsj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241113@151619.5380 ucslcohsjavoog7gl4ch7c8vsj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241113@151619.5442 ucslcohsjavoog7gl4ch7c8vsj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3286';
20241113@151619.5501 ucslcohsjavoog7gl4ch7c8vsj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3286';
20241113@151619.5557 ucslcohsjavoog7gl4ch7c8vsj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3286';
20241113@151619.5588 ucslcohsjavoog7gl4ch7c8vsj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3286';
20241113@151619.5639 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.5643 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241113@151619.5707 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.5711 ucslcohsjavoog7gl4ch7c8vsj Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20241113@151619.5809 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151619.5829 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407549 and bi.ref ='324.646.00.01' and bi.lordem =1
20241113@151619.6203 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20241113@151619.6223 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407549 and bi.ref ='324.646.00.01' and bi.lordem =2
20241113@151619.6626 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241113@151619.6647 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2075 and bo.obrano = 2407549 and bi.ref ='324.5343.00.1' and bi.lordem =3
20241113@151619.6979 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.6983 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241113@151619.7018 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.7021 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 1 valor from td where td.ndoc = 39
20241113@151619.7049 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.7052 ucslcohsjavoog7gl4ch7c8vsj 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')
20241113@151619.7080 ucslcohsjavoog7gl4ch7c8vsj 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
20241113@151619.7113 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.7116 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241113@151619.7155 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.7158 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241113@151619.7187 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.7189 ucslcohsjavoog7gl4ch7c8vsj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241113@151619.7234 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.7238 ucslcohsjavoog7gl4ch7c8vsj Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - corroios'
20241113@151619.7287 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.7290 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from td where ndoc = 39
20241113@151619.7303 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241113@151619.7317 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.7333 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151619.7358 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.7380 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151619.7413 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.7430 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151619.7448 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151619.7510 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241113@151619.7523 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.7538 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241113@151619.7570 ucslcohsjavoog7gl4ch7c8vsj Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6734c887436734c2c3b5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241113@151619.7779 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.7797 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241113@151619.7840 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241113@151619.7852 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241113@151619.7864 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241113@151619.7877 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241113@151619.7888 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241113@151619.7909 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241113@151619.7920 ucslcohsjavoog7gl4ch7c8vsj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6734c887436734c2c3b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241113@151619.8258 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 fno valor from wsftdata order by fno desc
20241113@151619.8364 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.8379 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241113@151619.8441 ucslcohsjavoog7gl4ch7c8vsj Query : select 'normal' from dummy
20241113@151619.8490 ucslcohsjavoog7gl4ch7c8vsj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6734c887436734c2c3b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1844,101621,0,'2024-11-13',39,'euro',0,0,2024 ,?,?)
20241113@151619.8840 ucslcohsjavoog7gl4ch7c8vsj Query : use flama_phc
20241113@151619.8843 ucslcohsjavoog7gl4ch7c8vsj Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20241113@151619.8876 ucslcohsjavoog7gl4ch7c8vsj 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.646.00.01'
20241113@151619.8890 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.8908 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241113@151619.8936 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.8952 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.8967 ucslcohsjavoog7gl4ch7c8vsj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241113@151619.9019 ucslcohsjavoog7gl4ch7c8vsj Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400228100a'
20241113@151619.9046 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241113@151619.9062 ucslcohsjavoog7gl4ch7c8vsj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241113@151619.9078 ucslcohsjavoog7gl4ch7c8vsj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6734c199726734c2c3dc','aut6734c887436734c2c3b5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241113@151619.9127 ucslcohsjavoog7gl4ch7c8vsj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
