20240910@181149.4326 nmifjmdk1kp3v6dl89o6mfut60 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')
20240910@181149.4356 nmifjmdk1kp3v6dl89o6mfut60 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
20240910@181149.4395 nmifjmdk1kp3v6dl89o6mfut60 Query : use flama_phc
20240910@181149.4398 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181149.4431 nmifjmdk1kp3v6dl89o6mfut60 Query : use flama_phc
20240910@181149.4434 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181149.4464 nmifjmdk1kp3v6dl89o6mfut60 Query : use flama_phc
20240910@181149.4467 nmifjmdk1kp3v6dl89o6mfut60 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181149.4507 nmifjmdk1kp3v6dl89o6mfut60 Query : use flama_phc
20240910@181149.4510 nmifjmdk1kp3v6dl89o6mfut60 Query : select szadrsstamp valor from szadrs where szadrsdesc='joaquim oliveira mendes,lda jom - covilhã'
20240910@181149.4558 nmifjmdk1kp3v6dl89o6mfut60 Query : use flama_phc
20240910@181149.4561 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from td where ndoc = 39
20240910@181149.4575 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181149.4591 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.4623 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181149.4644 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.4661 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181149.4693 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.4709 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181149.4724 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181149.4798 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181149.4813 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.4830 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181149.4847 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e075556666e07dd573' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181149.5064 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.5085 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181149.5123 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181149.5136 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181149.5150 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181149.5164 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181149.5177 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181149.5190 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181149.5202 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e075556666e07dd573',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181149.5503 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181149.5528 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.5546 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181149.5570 nmifjmdk1kp3v6dl89o6mfut60 Query : select 'normal' from dummy
20240910@181149.5586 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e075556666e07dd573',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',701,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181149.5929 nmifjmdk1kp3v6dl89o6mfut60 Query : use flama_phc
20240910@181149.5933 nmifjmdk1kp3v6dl89o6mfut60 Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240910@181149.5957 nmifjmdk1kp3v6dl89o6mfut60 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.2031.00.1'
20240910@181149.5973 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.5993 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181149.6022 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.6037 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181149.6046 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181149.6059 nmifjmdk1kp3v6dl89o6mfut60 Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240910@181149.6076 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.6093 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181149.6107 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e071415066e07dd594','aut66e075556666e07dd573' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181149.6113 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.6129 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181149.6162 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e071415066e07dd594',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66e075556666e07dd573' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240910@181149.6487 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.6506 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181149.6535 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.6552 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181149.6561 nmifjmdk1kp3v6dl89o6mfut60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181149.6575 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.6591 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181149.7793 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e073655366e07dd5a0','aut66e075556666e07dd573' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181149.7799 nmifjmdk1kp3v6dl89o6mfut60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181149.7818 nmifjmdk1kp3v6dl89o6mfut60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181149.7849 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e073655366e07dd5a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e075556666e07dd573' ,0,0 ,2,23.00,20000,?,?,?)
20240910@181149.8155 nmifjmdk1kp3v6dl89o6mfut60 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e075556666e07dd573','2405873','wait',39,'adm09112754980.682000002')
20240910@181149.8226 nmifjmdk1kp3v6dl89o6mfut60 Query : use flama_phc
20240910@181149.8229 nmifjmdk1kp3v6dl89o6mfut60 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240910@181149.8260 nmifjmdk1kp3v6dl89o6mfut60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1945';
20240910@181149.8292 nmifjmdk1kp3v6dl89o6mfut60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1945';
20240910@181149.8333 nmifjmdk1kp3v6dl89o6mfut60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1945';
20240910@181149.8359 nmifjmdk1kp3v6dl89o6mfut60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1945';
20240910@181149.8936 9aa2eg691553o19hhq9astln1b Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240910@181149.8948 9aa2eg691553o19hhq9astln1b Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240910@181149.9009 9aa2eg691553o19hhq9astln1b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1946';
20240910@181149.9069 9aa2eg691553o19hhq9astln1b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1946';
20240910@181149.9124 9aa2eg691553o19hhq9astln1b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1946';
20240910@181149.9150 9aa2eg691553o19hhq9astln1b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1946';
20240910@181149.9202 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181149.9205 9aa2eg691553o19hhq9astln1b Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240910@181149.9268 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181149.9271 9aa2eg691553o19hhq9astln1b Query : select no, estab,szadrsdesc from szadrs where u_coddest=1453
20240910@181149.9365 9aa2eg691553o19hhq9astln1b Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240910@181149.9391 9aa2eg691553o19hhq9astln1b Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405874 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240910@181149.9746 9aa2eg691553o19hhq9astln1b Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240910@181149.9766 9aa2eg691553o19hhq9astln1b Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405874 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240910@181150.1050 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.1090 9aa2eg691553o19hhq9astln1b Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240910@181150.1420 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.1450 9aa2eg691553o19hhq9astln1b Query : select top 1 1 valor from td where td.ndoc = 39
20240910@181150.1750 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.1780 9aa2eg691553o19hhq9astln1b 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')
20240910@181150.2060 9aa2eg691553o19hhq9astln1b 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
20240910@181150.3960 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.3990 9aa2eg691553o19hhq9astln1b Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181150.4300 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.4320 9aa2eg691553o19hhq9astln1b Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181150.4640 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.4660 9aa2eg691553o19hhq9astln1b Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181150.5060 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.5090 9aa2eg691553o19hhq9astln1b Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - batalha'
20240910@181150.5560 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.5580 9aa2eg691553o19hhq9astln1b Query : select 1 valor from td where ndoc = 39
20240910@181150.5710 9aa2eg691553o19hhq9astln1b Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181150.5850 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.6020 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181150.6220 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.6370 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181150.6670 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.6820 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181150.7000 9aa2eg691553o19hhq9astln1b Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181150.7710 9aa2eg691553o19hhq9astln1b Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181150.7840 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.8000 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181150.8160 9aa2eg691553o19hhq9astln1b Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e074034366e07dd611' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181150.1039 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.1058 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181150.1092 9aa2eg691553o19hhq9astln1b Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181150.1105 9aa2eg691553o19hhq9astln1b Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181150.1117 9aa2eg691553o19hhq9astln1b Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181150.1130 9aa2eg691553o19hhq9astln1b Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181150.1142 9aa2eg691553o19hhq9astln1b Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181150.1155 9aa2eg691553o19hhq9astln1b Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181150.1168 9aa2eg691553o19hhq9astln1b Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e074034366e07dd611',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181150.1464 9aa2eg691553o19hhq9astln1b Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181150.1486 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.1576 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181150.1599 9aa2eg691553o19hhq9astln1b Query : select 'normal' from dummy
20240910@181150.1615 9aa2eg691553o19hhq9astln1b Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e074034366e07dd611',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',702,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181150.1974 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.1978 9aa2eg691553o19hhq9astln1b Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240910@181150.2001 9aa2eg691553o19hhq9astln1b 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.1831.00.2'
20240910@181150.2024 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2044 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.2074 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2088 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.2097 9aa2eg691553o19hhq9astln1b Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181150.2110 9aa2eg691553o19hhq9astln1b Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240910@181150.2123 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2137 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.2148 9aa2eg691553o19hhq9astln1b Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e071608066e07dd633','aut66e074034366e07dd611' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181150.2158 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2173 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.2201 9aa2eg691553o19hhq9astln1b Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e071608066e07dd633',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66e074034366e07dd611' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240910@181150.2514 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2531 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.2557 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2571 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.2579 9aa2eg691553o19hhq9astln1b Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181150.2591 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2605 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.2619 9aa2eg691553o19hhq9astln1b Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e073415966e07dd63f','aut66e074034366e07dd611' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181150.2623 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.2638 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.2666 9aa2eg691553o19hhq9astln1b Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e073415966e07dd63f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e074034366e07dd611' ,0,0 ,2,23.00,20000,?,?,?)
20240910@181150.2957 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.2961 9aa2eg691553o19hhq9astln1b Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240910@181150.2980 9aa2eg691553o19hhq9astln1b 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.1831.00.2'
20240910@181150.2995 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.3011 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.3038 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.3053 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.3061 9aa2eg691553o19hhq9astln1b Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181150.3073 9aa2eg691553o19hhq9astln1b Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240910@181150.3086 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.3100 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.3113 9aa2eg691553o19hhq9astln1b Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e078283166e07dd64b','aut66e074034366e07dd611' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181150.3117 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.3132 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.3161 9aa2eg691553o19hhq9astln1b Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e078283166e07dd64b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66e074034366e07dd611' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240910@181150.3500 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.3520 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.3546 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.3561 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.3570 9aa2eg691553o19hhq9astln1b Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181150.3583 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.3599 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.4935 9aa2eg691553o19hhq9astln1b Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e072075866e07dd657','aut66e074034366e07dd611' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181150.4945 9aa2eg691553o19hhq9astln1b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.4964 9aa2eg691553o19hhq9astln1b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.4995 9aa2eg691553o19hhq9astln1b Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e072075866e07dd657',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e074034366e07dd611' ,0,0 ,2,23.00,50000,?,?,?)
20240910@181150.5315 9aa2eg691553o19hhq9astln1b Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e074034366e07dd611','2405874','wait',39,'adm09112754980.682000002')
20240910@181150.5394 9aa2eg691553o19hhq9astln1b Query : use flama_phc
20240910@181150.5398 9aa2eg691553o19hhq9astln1b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240910@181150.5428 9aa2eg691553o19hhq9astln1b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1946';
20240910@181150.5460 9aa2eg691553o19hhq9astln1b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1946';
20240910@181150.5503 9aa2eg691553o19hhq9astln1b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1946';
20240910@181150.5528 9aa2eg691553o19hhq9astln1b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1946';
20240910@181150.6050 jdeirf768tdc19c1s387st36g7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240910@181150.6062 jdeirf768tdc19c1s387st36g7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240910@181150.6119 jdeirf768tdc19c1s387st36g7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1947';
20240910@181150.6180 jdeirf768tdc19c1s387st36g7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1947';
20240910@181150.6232 jdeirf768tdc19c1s387st36g7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1947';
20240910@181150.6258 jdeirf768tdc19c1s387st36g7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1947';
20240910@181150.6307 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.6311 jdeirf768tdc19c1s387st36g7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240910@181150.6374 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.6377 jdeirf768tdc19c1s387st36g7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6855
20240910@181150.6495 jdeirf768tdc19c1s387st36g7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240910@181150.6516 jdeirf768tdc19c1s387st36g7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405875 and bi.ref ='324.2031.00.1' and bi.lordem =1
20240910@181150.6876 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.6880 jdeirf768tdc19c1s387st36g7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240910@181150.6914 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.6917 jdeirf768tdc19c1s387st36g7 Query : select top 1 1 valor from td where td.ndoc = 39
20240910@181150.6946 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.6949 jdeirf768tdc19c1s387st36g7 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')
20240910@181150.6978 jdeirf768tdc19c1s387st36g7 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
20240910@181150.7013 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.7016 jdeirf768tdc19c1s387st36g7 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181150.7047 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.7049 jdeirf768tdc19c1s387st36g7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181150.7081 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.7084 jdeirf768tdc19c1s387st36g7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181150.7123 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.7126 jdeirf768tdc19c1s387st36g7 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - montijo nova'
20240910@181150.7174 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.7177 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from td where ndoc = 39
20240910@181150.7189 jdeirf768tdc19c1s387st36g7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181150.7205 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.7222 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181150.7241 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.7256 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181150.7287 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.7304 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181150.7317 jdeirf768tdc19c1s387st36g7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181150.7390 jdeirf768tdc19c1s387st36g7 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181150.7403 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.7419 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181150.7434 jdeirf768tdc19c1s387st36g7 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e073500466e07dd6b2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181150.7636 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.7653 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181150.7688 jdeirf768tdc19c1s387st36g7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181150.7701 jdeirf768tdc19c1s387st36g7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181150.7714 jdeirf768tdc19c1s387st36g7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181150.7728 jdeirf768tdc19c1s387st36g7 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181150.7741 jdeirf768tdc19c1s387st36g7 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181150.7753 jdeirf768tdc19c1s387st36g7 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181150.7766 jdeirf768tdc19c1s387st36g7 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e073500466e07dd6b2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181150.8034 jdeirf768tdc19c1s387st36g7 Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181150.8056 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.8073 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181150.8095 jdeirf768tdc19c1s387st36g7 Query : select 'normal' from dummy
20240910@181150.8113 jdeirf768tdc19c1s387st36g7 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e073500466e07dd6b2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',703,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181150.8424 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.8427 jdeirf768tdc19c1s387st36g7 Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240910@181150.8456 jdeirf768tdc19c1s387st36g7 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.2031.00.1'
20240910@181150.8472 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.8489 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.8515 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.8531 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.8539 jdeirf768tdc19c1s387st36g7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181150.8551 jdeirf768tdc19c1s387st36g7 Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240910@181150.8568 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.8583 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.8594 jdeirf768tdc19c1s387st36g7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e077098566e07dd6d1','aut66e073500466e07dd6b2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181150.8599 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.8614 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.8644 jdeirf768tdc19c1s387st36g7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e077098566e07dd6d1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66e073500466e07dd6b2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240910@181150.8937 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.8955 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.8983 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.9004 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.9014 jdeirf768tdc19c1s387st36g7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181150.9027 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.9041 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181150.9053 jdeirf768tdc19c1s387st36g7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e079452366e07dd6dc','aut66e073500466e07dd6b2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181150.9058 jdeirf768tdc19c1s387st36g7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181150.9074 jdeirf768tdc19c1s387st36g7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181150.9104 jdeirf768tdc19c1s387st36g7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e079452366e07dd6dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e073500466e07dd6b2' ,0,0 ,2,23.00,20000,?,?,?)
20240910@181150.9391 jdeirf768tdc19c1s387st36g7 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e073500466e07dd6b2','2405875','wait',39,'adm09112754980.682000002')
20240910@181150.9460 jdeirf768tdc19c1s387st36g7 Query : use flama_phc
20240910@181150.9464 jdeirf768tdc19c1s387st36g7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240910@181150.9493 jdeirf768tdc19c1s387st36g7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1947';
20240910@181150.9525 jdeirf768tdc19c1s387st36g7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1947';
20240910@181150.9563 jdeirf768tdc19c1s387st36g7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1947';
20240910@181150.9587 jdeirf768tdc19c1s387st36g7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1947';
20240910@181151.6400 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240910@181151.6510 gbvapgn7e8b7t6nfucl4pt9k7i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240910@181151.7070 gbvapgn7e8b7t6nfucl4pt9k7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1948';
20240910@181151.7700 gbvapgn7e8b7t6nfucl4pt9k7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1948';
20240910@181151.8220 gbvapgn7e8b7t6nfucl4pt9k7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1948';
20240910@181151.8470 gbvapgn7e8b7t6nfucl4pt9k7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1948';
20240910@181151.8940 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.8970 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240910@181151.9630 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.9660 gbvapgn7e8b7t6nfucl4pt9k7i Query : select no, estab,szadrsdesc from szadrs where u_coddest=1161
20240910@181151.1065 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240910@181151.1085 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405876 and bi.ref ='324.2031.00.1' and bi.lordem =1
20240910@181151.1451 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1455 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240910@181151.1491 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1494 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 1 valor from td where td.ndoc = 39
20240910@181151.1524 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1528 gbvapgn7e8b7t6nfucl4pt9k7i 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')
20240910@181151.1558 gbvapgn7e8b7t6nfucl4pt9k7i 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
20240910@181151.1600 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1603 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181151.1632 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1635 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181151.1665 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1668 gbvapgn7e8b7t6nfucl4pt9k7i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181151.1707 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1709 gbvapgn7e8b7t6nfucl4pt9k7i Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - Évora'
20240910@181151.1755 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.1758 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from td where ndoc = 39
20240910@181151.1771 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181151.1786 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.1803 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181151.1823 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.1838 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181151.1868 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.1883 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181151.1896 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181151.3103 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181151.3119 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.3137 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181151.3154 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e072124766e07dd72e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181151.3363 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.3385 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181151.3419 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181151.3432 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181151.3443 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181151.3456 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181151.3469 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181151.3481 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181151.3494 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e072124766e07dd72e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181151.3775 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181151.3800 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.3821 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181151.3844 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 'normal' from dummy
20240910@181151.3861 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e072124766e07dd72e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',704,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181151.4193 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.4197 gbvapgn7e8b7t6nfucl4pt9k7i Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240910@181151.4223 gbvapgn7e8b7t6nfucl4pt9k7i 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.2031.00.1'
20240910@181151.4238 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4256 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.4284 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4298 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.4307 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181151.4320 gbvapgn7e8b7t6nfucl4pt9k7i Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240910@181151.4333 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4349 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.4361 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e075392766e07dd769','aut66e072124766e07dd72e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181151.4366 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4382 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.4412 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e075392766e07dd769',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66e072124766e07dd72e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240910@181151.4720 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4738 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.4764 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4786 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.4795 gbvapgn7e8b7t6nfucl4pt9k7i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181151.4807 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4822 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.4833 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e070726466e07dd775','aut66e072124766e07dd72e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181151.4838 gbvapgn7e8b7t6nfucl4pt9k7i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.4852 gbvapgn7e8b7t6nfucl4pt9k7i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.4880 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e070726466e07dd775',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e072124766e07dd72e' ,0,0 ,2,23.00,20000,?,?,?)
20240910@181151.5172 gbvapgn7e8b7t6nfucl4pt9k7i Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e072124766e07dd72e','2405876','wait',39,'adm09112754980.682000002')
20240910@181151.5243 gbvapgn7e8b7t6nfucl4pt9k7i Query : use flama_phc
20240910@181151.5246 gbvapgn7e8b7t6nfucl4pt9k7i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240910@181151.5278 gbvapgn7e8b7t6nfucl4pt9k7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1948';
20240910@181151.5311 gbvapgn7e8b7t6nfucl4pt9k7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1948';
20240910@181151.5352 gbvapgn7e8b7t6nfucl4pt9k7i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1948';
20240910@181151.5378 gbvapgn7e8b7t6nfucl4pt9k7i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1948';
20240910@181151.5938 aku7mb749v1r3p39ec11npjl20 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240910@181151.5950 aku7mb749v1r3p39ec11npjl20 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240910@181151.6011 aku7mb749v1r3p39ec11npjl20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1949';
20240910@181151.6074 aku7mb749v1r3p39ec11npjl20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1949';
20240910@181151.6126 aku7mb749v1r3p39ec11npjl20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1949';
20240910@181151.6152 aku7mb749v1r3p39ec11npjl20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1949';
20240910@181151.6201 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6204 aku7mb749v1r3p39ec11npjl20 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240910@181151.6267 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6270 aku7mb749v1r3p39ec11npjl20 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1899
20240910@181151.6363 aku7mb749v1r3p39ec11npjl20 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240910@181151.6384 aku7mb749v1r3p39ec11npjl20 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405877 and bi.ref ='324.2031.00.1' and bi.lordem =1
20240910@181151.6743 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6746 aku7mb749v1r3p39ec11npjl20 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240910@181151.6779 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6782 aku7mb749v1r3p39ec11npjl20 Query : select top 1 1 valor from td where td.ndoc = 39
20240910@181151.6816 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6819 aku7mb749v1r3p39ec11npjl20 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')
20240910@181151.6847 aku7mb749v1r3p39ec11npjl20 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
20240910@181151.6881 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6884 aku7mb749v1r3p39ec11npjl20 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181151.6913 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6916 aku7mb749v1r3p39ec11npjl20 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181151.6945 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6948 aku7mb749v1r3p39ec11npjl20 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181151.6987 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.6990 aku7mb749v1r3p39ec11npjl20 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m'
20240910@181151.7036 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.7038 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from td where ndoc = 39
20240910@181151.7050 aku7mb749v1r3p39ec11npjl20 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181151.7064 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.7081 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181151.7101 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.7115 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181151.7143 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.7158 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181151.7171 aku7mb749v1r3p39ec11npjl20 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181151.7241 aku7mb749v1r3p39ec11npjl20 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181151.7256 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.7273 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181151.7289 aku7mb749v1r3p39ec11npjl20 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e078468766e07dd7af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181151.7498 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.7522 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181151.7559 aku7mb749v1r3p39ec11npjl20 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181151.7571 aku7mb749v1r3p39ec11npjl20 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181151.7584 aku7mb749v1r3p39ec11npjl20 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181151.7596 aku7mb749v1r3p39ec11npjl20 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181151.7608 aku7mb749v1r3p39ec11npjl20 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181151.7620 aku7mb749v1r3p39ec11npjl20 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181151.7633 aku7mb749v1r3p39ec11npjl20 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e078468766e07dd7af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181151.7898 aku7mb749v1r3p39ec11npjl20 Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181151.7920 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.7937 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181151.7961 aku7mb749v1r3p39ec11npjl20 Query : select 'normal' from dummy
20240910@181151.7977 aku7mb749v1r3p39ec11npjl20 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e078468766e07dd7af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',705,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181151.8294 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181151.8297 aku7mb749v1r3p39ec11npjl20 Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240910@181151.8321 aku7mb749v1r3p39ec11npjl20 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.2031.00.1'
20240910@181151.8336 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8356 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.8385 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8401 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.8410 aku7mb749v1r3p39ec11npjl20 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181151.8422 aku7mb749v1r3p39ec11npjl20 Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240910@181151.8436 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8450 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.8463 aku7mb749v1r3p39ec11npjl20 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e073144266e07dd7cd','aut66e078468766e07dd7af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181151.8468 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8483 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.8524 aku7mb749v1r3p39ec11npjl20 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e073144266e07dd7cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66e078468766e07dd7af' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240910@181151.8821 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8840 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.8867 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8884 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.8893 aku7mb749v1r3p39ec11npjl20 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181151.8906 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8921 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181151.8933 aku7mb749v1r3p39ec11npjl20 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e071052766e07dd7d9','aut66e078468766e07dd7af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181151.8938 aku7mb749v1r3p39ec11npjl20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181151.8952 aku7mb749v1r3p39ec11npjl20 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181151.8981 aku7mb749v1r3p39ec11npjl20 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e071052766e07dd7d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e078468766e07dd7af' ,0,0 ,2,23.00,20000,?,?,?)
20240910@181151.9847 aku7mb749v1r3p39ec11npjl20 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e078468766e07dd7af','2405877','wait',39,'adm09112754980.682000002')
20240910@181152.4340 aku7mb749v1r3p39ec11npjl20 Query : use flama_phc
20240910@181152.4380 aku7mb749v1r3p39ec11npjl20 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240910@181152.4680 aku7mb749v1r3p39ec11npjl20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1949';
20240910@181152.5000 aku7mb749v1r3p39ec11npjl20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1949';
20240910@181152.5460 aku7mb749v1r3p39ec11npjl20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1949';
20240910@181152.5700 aku7mb749v1r3p39ec11npjl20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1949';
20240910@181152.1233 ks0pa01oldbjtmdjadmt0pp4mj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240910@181152.1244 ks0pa01oldbjtmdjadmt0pp4mj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240910@181152.1303 ks0pa01oldbjtmdjadmt0pp4mj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1950';
20240910@181152.1364 ks0pa01oldbjtmdjadmt0pp4mj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1950';
20240910@181152.1416 ks0pa01oldbjtmdjadmt0pp4mj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1950';
20240910@181152.1441 ks0pa01oldbjtmdjadmt0pp4mj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1950';
20240910@181152.1486 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.1489 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240910@181152.1554 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.1558 ks0pa01oldbjtmdjadmt0pp4mj Query : select no, estab,szadrsdesc from szadrs where u_coddest=6600
20240910@181152.1649 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240910@181152.1670 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405878 and bi.ref ='324.4960.00.1' and bi.lordem =1
20240910@181152.2033 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2037 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240910@181152.2071 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2074 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 1 valor from td where td.ndoc = 39
20240910@181152.2105 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2108 ks0pa01oldbjtmdjadmt0pp4mj 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')
20240910@181152.2138 ks0pa01oldbjtmdjadmt0pp4mj 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
20240910@181152.2179 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2182 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181152.2212 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2215 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181152.2246 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2249 ks0pa01oldbjtmdjadmt0pp4mj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181152.2294 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2297 ks0pa01oldbjtmdjadmt0pp4mj Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. braga retail'
20240910@181152.2353 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.2356 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from td where ndoc = 39
20240910@181152.2369 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181152.2384 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.2401 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181152.2421 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.2437 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181152.2468 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.2484 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181152.2498 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181152.2571 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181152.2584 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.2600 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181152.2618 ks0pa01oldbjtmdjadmt0pp4mj Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e077907966e07dd83c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181152.2825 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.2844 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181152.2879 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181152.2893 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181152.2904 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181152.2917 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181152.2930 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181152.2942 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181152.2955 ks0pa01oldbjtmdjadmt0pp4mj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e077907966e07dd83c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181152.3240 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181152.3262 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.3279 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181152.3302 ks0pa01oldbjtmdjadmt0pp4mj Query : select 'normal' from dummy
20240910@181152.3319 ks0pa01oldbjtmdjadmt0pp4mj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e077907966e07dd83c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',706,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181152.3642 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.3645 ks0pa01oldbjtmdjadmt0pp4mj Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240910@181152.3667 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20240910@181152.3682 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.3698 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.3724 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.3739 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.3748 ks0pa01oldbjtmdjadmt0pp4mj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181152.3762 ks0pa01oldbjtmdjadmt0pp4mj Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240910@181152.3779 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.3795 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.3808 ks0pa01oldbjtmdjadmt0pp4mj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e077008966e07dd85c','aut66e077907966e07dd83c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181152.3813 ks0pa01oldbjtmdjadmt0pp4mj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.3828 ks0pa01oldbjtmdjadmt0pp4mj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.3856 ks0pa01oldbjtmdjadmt0pp4mj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e077008966e07dd85c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66e077907966e07dd83c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240910@181152.4127 ks0pa01oldbjtmdjadmt0pp4mj Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e077907966e07dd83c','2405878','wait',39,'adm09112754980.682000002')
20240910@181152.4200 ks0pa01oldbjtmdjadmt0pp4mj Query : use flama_phc
20240910@181152.4204 ks0pa01oldbjtmdjadmt0pp4mj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240910@181152.4235 ks0pa01oldbjtmdjadmt0pp4mj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1950';
20240910@181152.4264 ks0pa01oldbjtmdjadmt0pp4mj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1950';
20240910@181152.4304 ks0pa01oldbjtmdjadmt0pp4mj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1950';
20240910@181152.4329 ks0pa01oldbjtmdjadmt0pp4mj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1950';
20240910@181152.4875 nheqehftji1eheu19p466us08n Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240910@181152.4886 nheqehftji1eheu19p466us08n Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240910@181152.4943 nheqehftji1eheu19p466us08n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1951';
20240910@181152.5001 nheqehftji1eheu19p466us08n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1951';
20240910@181152.5055 nheqehftji1eheu19p466us08n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1951';
20240910@181152.5078 nheqehftji1eheu19p466us08n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1951';
20240910@181152.5129 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.5132 nheqehftji1eheu19p466us08n Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240910@181152.5198 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.5201 nheqehftji1eheu19p466us08n Query : select no, estab,szadrsdesc from szadrs where u_coddest=886
20240910@181152.5288 nheqehftji1eheu19p466us08n Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240910@181152.5309 nheqehftji1eheu19p466us08n Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405880 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240910@181152.5666 nheqehftji1eheu19p466us08n Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240910@181152.5687 nheqehftji1eheu19p466us08n Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405880 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240910@181152.6053 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6056 nheqehftji1eheu19p466us08n Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240910@181152.6089 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6092 nheqehftji1eheu19p466us08n Query : select top 1 1 valor from td where td.ndoc = 39
20240910@181152.6121 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6124 nheqehftji1eheu19p466us08n 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')
20240910@181152.6151 nheqehftji1eheu19p466us08n 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
20240910@181152.6184 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6187 nheqehftji1eheu19p466us08n Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181152.6215 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6218 nheqehftji1eheu19p466us08n Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181152.6248 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6250 nheqehftji1eheu19p466us08n Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181152.6294 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6297 nheqehftji1eheu19p466us08n Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda coimbra'
20240910@181152.6343 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.6346 nheqehftji1eheu19p466us08n Query : select 1 valor from td where ndoc = 39
20240910@181152.6358 nheqehftji1eheu19p466us08n Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181152.6372 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.6389 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181152.6408 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.6422 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181152.6455 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.6470 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181152.6483 nheqehftji1eheu19p466us08n Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181152.6555 nheqehftji1eheu19p466us08n Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181152.6569 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.6584 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181152.6600 nheqehftji1eheu19p466us08n Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e078606966e07dd89e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181152.6795 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.6812 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181152.6848 nheqehftji1eheu19p466us08n Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181152.6862 nheqehftji1eheu19p466us08n Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181152.6876 nheqehftji1eheu19p466us08n Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181152.6888 nheqehftji1eheu19p466us08n Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181152.6900 nheqehftji1eheu19p466us08n Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181152.6913 nheqehftji1eheu19p466us08n Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181152.6933 nheqehftji1eheu19p466us08n Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e078606966e07dd89e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181152.7216 nheqehftji1eheu19p466us08n Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181152.7239 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.7256 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181152.7281 nheqehftji1eheu19p466us08n Query : select 'normal' from dummy
20240910@181152.7297 nheqehftji1eheu19p466us08n Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e078606966e07dd89e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',707,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181152.7629 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.7633 nheqehftji1eheu19p466us08n Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240910@181152.7657 nheqehftji1eheu19p466us08n 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.1831.00.2'
20240910@181152.7671 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.7691 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.7718 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.7733 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.7742 nheqehftji1eheu19p466us08n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181152.7755 nheqehftji1eheu19p466us08n Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240910@181152.7767 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.7783 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.7796 nheqehftji1eheu19p466us08n Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e079307066e07dd8bd','aut66e078606966e07dd89e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181152.7801 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.7816 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.7851 nheqehftji1eheu19p466us08n Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e079307066e07dd8bd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66e078606966e07dd89e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240910@181152.9071 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9236 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.9263 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9280 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.9290 nheqehftji1eheu19p466us08n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181152.9303 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9318 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.9330 nheqehftji1eheu19p466us08n Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e079637666e07dd8e3','aut66e078606966e07dd89e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181152.9335 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9350 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.9381 nheqehftji1eheu19p466us08n Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e079637666e07dd8e3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e078606966e07dd89e' ,0,0 ,2,23.00,20000,?,?,?)
20240910@181152.9663 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181152.9667 nheqehftji1eheu19p466us08n Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240910@181152.9688 nheqehftji1eheu19p466us08n 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.1831.00.2'
20240910@181152.9702 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9720 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.9748 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9764 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.9781 nheqehftji1eheu19p466us08n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181152.9795 nheqehftji1eheu19p466us08n Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240910@181152.9808 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9823 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181152.9835 nheqehftji1eheu19p466us08n Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e078406566e07dd8ef','aut66e078606966e07dd89e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181152.9840 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181152.9855 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181152.9886 nheqehftji1eheu19p466us08n Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e078406566e07dd8ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66e078606966e07dd89e' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240910@181153.1840 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.2020 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181153.2310 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.2470 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181153.2560 nheqehftji1eheu19p466us08n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240910@181153.2690 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.2840 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240910@181153.2960 nheqehftji1eheu19p466us08n Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e074781666e07dd906','aut66e078606966e07dd89e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240910@181153.3010 nheqehftji1eheu19p466us08n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.3260 nheqehftji1eheu19p466us08n Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181153.3550 nheqehftji1eheu19p466us08n Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e074781666e07dd906',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e078606966e07dd89e' ,0,0 ,2,23.00,50000,?,?,?)
20240910@181153.6360 nheqehftji1eheu19p466us08n Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e078606966e07dd89e','2405880','wait',39,'adm09112754980.682000002')
20240910@181153.7080 nheqehftji1eheu19p466us08n Query : use flama_phc
20240910@181153.7120 nheqehftji1eheu19p466us08n Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240910@181153.7420 nheqehftji1eheu19p466us08n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1951';
20240910@181153.9340 nheqehftji1eheu19p466us08n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1951';
20240910@181153.9760 nheqehftji1eheu19p466us08n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1951';
20240910@181153.1005 nheqehftji1eheu19p466us08n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1951';
20240910@181153.1533 m8e1jou8eqbr7pl0oi9ojdled1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240910@181153.1545 m8e1jou8eqbr7pl0oi9ojdled1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240910@181153.1607 m8e1jou8eqbr7pl0oi9ojdled1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1952';
20240910@181153.1671 m8e1jou8eqbr7pl0oi9ojdled1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1952';
20240910@181153.1722 m8e1jou8eqbr7pl0oi9ojdled1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1952';
20240910@181153.1747 m8e1jou8eqbr7pl0oi9ojdled1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1952';
20240910@181153.1794 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.1798 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240910@181153.1861 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.1864 m8e1jou8eqbr7pl0oi9ojdled1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20240910@181153.1954 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240910@181153.1974 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405881 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240910@181153.2335 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240910@181153.2356 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2058 and bo.obrano = 2405881 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240910@181153.2892 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.2918 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240910@181153.2953 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.2956 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 1 valor from td where td.ndoc = 39
20240910@181153.2987 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.2990 m8e1jou8eqbr7pl0oi9ojdled1 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')
20240910@181153.3020 m8e1jou8eqbr7pl0oi9ojdled1 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
20240910@181153.3055 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.3058 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240910@181153.3089 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.3092 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240910@181153.3123 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.3126 m8e1jou8eqbr7pl0oi9ojdled1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240910@181153.3167 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.3170 m8e1jou8eqbr7pl0oi9ojdled1 Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - caldas da rainha'
20240910@181153.3217 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.3220 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from td where ndoc = 39
20240910@181153.3232 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240910@181153.3247 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.3264 m8e1jou8eqbr7pl0oi9ojdled1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181153.3284 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.3298 m8e1jou8eqbr7pl0oi9ojdled1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181153.3330 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.3345 m8e1jou8eqbr7pl0oi9ojdled1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181153.3357 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181153.3428 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240910@181153.3443 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.3459 m8e1jou8eqbr7pl0oi9ojdled1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240910@181153.3476 m8e1jou8eqbr7pl0oi9ojdled1 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e074752966e07dd951' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240910@181153.3682 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.3702 m8e1jou8eqbr7pl0oi9ojdled1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240910@181153.3740 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240910@181153.3752 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240910@181153.3768 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240910@181153.3780 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240910@181153.3794 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240910@181153.3806 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240910@181153.3819 m8e1jou8eqbr7pl0oi9ojdled1 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e074752966e07dd951',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240910@181153.4091 m8e1jou8eqbr7pl0oi9ojdled1 Query : select top 1 fno valor from wsftdata order by fno desc
20240910@181153.4115 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.4133 m8e1jou8eqbr7pl0oi9ojdled1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240910@181153.4157 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 'normal' from dummy
20240910@181153.4173 m8e1jou8eqbr7pl0oi9ojdled1 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e074752966e07dd951',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',708,101621,0,'2024-09-10',39,'euro',0,0,2024 ,?,?)
20240910@181153.4501 m8e1jou8eqbr7pl0oi9ojdled1 Query : use flama_phc
20240910@181153.4505 m8e1jou8eqbr7pl0oi9ojdled1 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240910@181153.4531 m8e1jou8eqbr7pl0oi9ojdled1 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.1831.00.2'
20240910@181153.4548 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240910@181153.4567 m8e1jou8eqbr7pl0oi9ojdled1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240910@181153.4594 m8e1jou8eqbr7pl0oi9ojdled1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
