20241203@151201.7767 btmmksakgj84jeu5d1rbindu34 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408141 and bi.ref ='328.9075.00.1' and bi.lordem =2
20241203@151201.8108 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8113 btmmksakgj84jeu5d1rbindu34 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241203@151201.8148 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8151 btmmksakgj84jeu5d1rbindu34 Query : select top 1 1 valor from td where td.ndoc = 39
20241203@151201.8184 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8188 btmmksakgj84jeu5d1rbindu34 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')
20241203@151201.8254 btmmksakgj84jeu5d1rbindu34 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
20241203@151201.8293 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8296 btmmksakgj84jeu5d1rbindu34 Query : select top 1 ~inactivo valor from cl where no = '102170' and estab = 0 order by inactivo desc
20241203@151201.8439 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8443 btmmksakgj84jeu5d1rbindu34 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241203@151201.8478 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8481 btmmksakgj84jeu5d1rbindu34 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241203@151201.8528 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8538 btmmksakgj84jeu5d1rbindu34 Query : select szadrsstamp valor from szadrs where szadrsdesc='eugÉnio antÓnio guerreiro dos santos & filho,lda.'
20241203@151201.8602 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151201.8605 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from td where ndoc = 39
20241203@151201.8621 btmmksakgj84jeu5d1rbindu34 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241203@151201.8644 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151201.8672 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151201.8697 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151201.8715 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151201.8754 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151201.8771 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151201.8788 btmmksakgj84jeu5d1rbindu34 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151201.8851 btmmksakgj84jeu5d1rbindu34 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151201.8869 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151201.8885 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151201.8908 btmmksakgj84jeu5d1rbindu34 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674f118622674f1fc1d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241203@151201.9228 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151201.9250 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151201.9290 btmmksakgj84jeu5d1rbindu34 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241203@151201.9303 btmmksakgj84jeu5d1rbindu34 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241203@151201.9350 btmmksakgj84jeu5d1rbindu34 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241203@151201.9369 btmmksakgj84jeu5d1rbindu34 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241203@151201.9384 btmmksakgj84jeu5d1rbindu34 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241203@151201.9398 btmmksakgj84jeu5d1rbindu34 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241203@151201.9412 btmmksakgj84jeu5d1rbindu34 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674f118622674f1fc1d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241203@151201.9709 btmmksakgj84jeu5d1rbindu34 Query : select top 1 fno valor from wsftdata order by fno desc
20241203@151201.9750 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151201.9775 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151201.9828 btmmksakgj84jeu5d1rbindu34 Query : select 'normal' from dummy
20241203@151201.9848 btmmksakgj84jeu5d1rbindu34 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674f118622674f1fc1d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2161,102170,0,'2024-12-03',39,'euro',0,0,2024 ,?,?)
20241203@151202.1810 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151202.1880 btmmksakgj84jeu5d1rbindu34 Query : select st.usalote valor from st where st.ref = '324.644.00.01'
20241203@151202.2160 btmmksakgj84jeu5d1rbindu34 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.644.00.01'
20241203@151202.3900 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.4190 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.4640 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.4840 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.4950 btmmksakgj84jeu5d1rbindu34 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151202.5100 btmmksakgj84jeu5d1rbindu34 Query : select sestamp valor from se where ref ='324.644.00.01' and lote = 'r2400749200a'
20241203@151202.5560 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.5740 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.5880 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f133259674f1fc20d','aut674f118622674f1fc1d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151202.5930 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.6110 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.6690 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f133259674f1fc20d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut674f118622674f1fc1d6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241203@151202.1074 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151202.1110 btmmksakgj84jeu5d1rbindu34 Query : select st.usalote valor from st where st.ref = '324.644.00.01'
20241203@151202.1134 btmmksakgj84jeu5d1rbindu34 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.644.00.01'
20241203@151202.1150 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.1168 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.1202 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.1225 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.1235 btmmksakgj84jeu5d1rbindu34 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151202.1324 btmmksakgj84jeu5d1rbindu34 Query : select sestamp valor from se where ref ='324.644.00.01' and lote = 'r2400749200a'
20241203@151202.1343 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.1378 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.1393 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f124640674f1fc220','aut674f118622674f1fc1d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151202.1398 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.1424 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.1457 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f124640674f1fc220',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut674f118622674f1fc1d6' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241203@151202.1742 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151202.1747 btmmksakgj84jeu5d1rbindu34 Query : select st.usalote valor from st where st.ref = '328.9075.00.1'
20241203@151202.2126 btmmksakgj84jeu5d1rbindu34 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 = '328.9075.00.1'
20241203@151202.2299 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.2318 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.2352 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.2370 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.2393 btmmksakgj84jeu5d1rbindu34 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151202.2416 btmmksakgj84jeu5d1rbindu34 Query : select sestamp valor from se where ref ='328.9075.00.1' and lote = 'r2400212150a'
20241203@151202.2439 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.2467 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.2483 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f171944674f1fc23b','aut674f118622674f1fc1d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151202.2488 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.2771 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.2808 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f171944674f1fc23b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674f118622674f1fc1d6' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241203@151202.3094 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.3112 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.3142 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.3160 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.3177 btmmksakgj84jeu5d1rbindu34 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151202.3193 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.3210 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151202.3228 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f174918674f1fc24d','aut674f118622674f1fc1d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151202.3243 btmmksakgj84jeu5d1rbindu34 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.3268 btmmksakgj84jeu5d1rbindu34 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151202.3314 btmmksakgj84jeu5d1rbindu34 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f174918674f1fc24d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f118622674f1fc1d6' ,0,0 ,2,23.00,40000,?,?,?)
20241203@151202.3639 btmmksakgj84jeu5d1rbindu34 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674f118622674f1fc1d6','2408141','wait',39,'adm09112754980.682000002')
20241203@151202.3717 btmmksakgj84jeu5d1rbindu34 Query : use flama_phc
20241203@151202.3720 btmmksakgj84jeu5d1rbindu34 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241203@151202.3754 btmmksakgj84jeu5d1rbindu34 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3639';
20241203@151202.3805 btmmksakgj84jeu5d1rbindu34 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3639';
20241203@151202.3866 btmmksakgj84jeu5d1rbindu34 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3639';
20241203@151202.3905 btmmksakgj84jeu5d1rbindu34 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3639';
20241203@151202.4461 beedqbn7tf6ena7l32dhvs35dc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241203@151202.4474 beedqbn7tf6ena7l32dhvs35dc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241203@151202.4549 beedqbn7tf6ena7l32dhvs35dc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3640';
20241203@151202.4629 beedqbn7tf6ena7l32dhvs35dc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3640';
20241203@151202.4694 beedqbn7tf6ena7l32dhvs35dc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3640';
20241203@151202.4754 beedqbn7tf6ena7l32dhvs35dc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3640';
20241203@151202.4812 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.4817 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241203@151202.4883 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.4888 beedqbn7tf6ena7l32dhvs35dc Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20241203@151202.5745 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20241203@151202.5936 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408156 and bi.ref ='324.945.00.01' and bi.lordem =1
20241203@151202.6280 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241203@151202.6342 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408156 and bi.ref ='324.1832.00.2' and bi.lordem =3
20241203@151202.6712 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241203@151202.6741 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408156 and bi.ref ='324.1832.00.2' and bi.lordem =4
20241203@151202.7174 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20241203@151202.7345 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408156 and bi.ref ='324.1833.00.2' and bi.lordem =5
20241203@151202.8014 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20241203@151202.8200 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408156 and bi.ref ='324.1833.00.2' and bi.lordem =6
20241203@151202.8564 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.8567 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241203@151202.8600 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.8603 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 1 valor from td where td.ndoc = 39
20241203@151202.8668 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.8671 beedqbn7tf6ena7l32dhvs35dc 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')
20241203@151202.8702 beedqbn7tf6ena7l32dhvs35dc 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
20241203@151202.8738 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.8741 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241203@151202.8885 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.8888 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241203@151202.8925 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.8929 beedqbn7tf6ena7l32dhvs35dc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241203@151202.8972 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.8975 beedqbn7tf6ena7l32dhvs35dc Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - caldas da rainha'
20241203@151202.9027 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151202.9030 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from td where ndoc = 39
20241203@151202.9044 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241203@151202.9060 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.9078 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151202.9257 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.9276 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151202.9323 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.9348 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151202.9367 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151202.9426 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151202.9443 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151202.9461 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151202.9480 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241203@151202.9782 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3800 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151203.1890 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241203@151203.2010 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241203@151203.2140 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241203@151203.2290 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241203@151203.2440 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241203@151203.2570 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241203@151203.2700 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674f118955674f1fc2e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241203@151203.5420 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 fno valor from wsftdata order by fno desc
20241203@151203.5720 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.5920 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151203.6200 beedqbn7tf6ena7l32dhvs35dc Query : select 'normal' from dummy
20241203@151203.6420 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674f118955674f1fc2e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2162,101621,0,'2024-12-03',39,'euro',0,0,2024 ,?,?)
20241203@151203.9890 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151203.9930 beedqbn7tf6ena7l32dhvs35dc Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20241203@151203.1033 beedqbn7tf6ena7l32dhvs35dc 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.945.00.01'
20241203@151203.1220 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.1239 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.1270 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.1286 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.1296 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151203.1322 beedqbn7tf6ena7l32dhvs35dc Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20241203@151203.1337 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.1359 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.1413 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f109875674f1fc320','aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151203.1424 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.1440 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.1471 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f109875674f1fc320',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut674f118955674f1fc2e4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241203@151203.1780 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151203.1784 beedqbn7tf6ena7l32dhvs35dc Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241203@151203.1805 beedqbn7tf6ena7l32dhvs35dc 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.1832.00.2'
20241203@151203.1825 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.1860 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.1898 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.1921 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.1932 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151203.1955 beedqbn7tf6ena7l32dhvs35dc Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241203@151203.1979 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.2029 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.2043 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f136866674f1fc330','aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151203.2048 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.2080 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.2123 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f136866674f1fc330',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut674f118955674f1fc2e4' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241203@151203.2428 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.2447 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.2477 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.2494 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.2504 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151203.2518 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.2534 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.2553 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f172241674f1fc33d','aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151203.2558 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.2586 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.2624 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f172241674f1fc33d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f118955674f1fc2e4' ,0,0 ,2,23.00,30000,?,?,?)
20241203@151203.2909 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151203.2912 beedqbn7tf6ena7l32dhvs35dc Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241203@151203.2935 beedqbn7tf6ena7l32dhvs35dc 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.1832.00.2'
20241203@151203.2954 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.2973 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.3003 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3023 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.3033 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151203.3048 beedqbn7tf6ena7l32dhvs35dc Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241203@151203.3063 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3080 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.3092 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f106313674f1fc34a','aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151203.3097 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3117 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.3149 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f106313674f1fc34a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674f118955674f1fc2e4' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241203@151203.3517 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3539 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.3568 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3585 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.3597 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151203.3613 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3630 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.3645 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f154262674f1fc358','aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151203.3650 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.3687 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.3728 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f154262674f1fc358',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f118955674f1fc2e4' ,0,0 ,2,23.00,60000,?,?,?)
20241203@151203.4130 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151203.4140 beedqbn7tf6ena7l32dhvs35dc Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20241203@151203.4163 beedqbn7tf6ena7l32dhvs35dc 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.1833.00.2'
20241203@151203.4331 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.4351 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.4380 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.4398 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.4438 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151203.4454 beedqbn7tf6ena7l32dhvs35dc Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20241203@151203.4469 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.4486 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.4499 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f125640674f1fc36d','aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151203.4504 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.4529 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.4754 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f125640674f1fc36d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut674f118955674f1fc2e4' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241203@151203.5648 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151203.6106 beedqbn7tf6ena7l32dhvs35dc Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20241203@151203.6146 beedqbn7tf6ena7l32dhvs35dc 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.1833.00.2'
20241203@151203.6171 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.6191 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.6569 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.6587 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.6597 beedqbn7tf6ena7l32dhvs35dc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151203.6612 beedqbn7tf6ena7l32dhvs35dc Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20241203@151203.6627 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.6644 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151203.6655 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f186514674f1fc3a1','aut674f118955674f1fc2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151203.6661 beedqbn7tf6ena7l32dhvs35dc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151203.6676 beedqbn7tf6ena7l32dhvs35dc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151203.6718 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f186514674f1fc3a1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674f118955674f1fc2e4' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241203@151203.7013 beedqbn7tf6ena7l32dhvs35dc Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674f118955674f1fc2e4','2408156','wait',39,'adm09112754980.682000002')
20241203@151203.7118 beedqbn7tf6ena7l32dhvs35dc Query : use flama_phc
20241203@151203.7121 beedqbn7tf6ena7l32dhvs35dc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241203@151203.7156 beedqbn7tf6ena7l32dhvs35dc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3640';
20241203@151203.7209 beedqbn7tf6ena7l32dhvs35dc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3640';
20241203@151203.7259 beedqbn7tf6ena7l32dhvs35dc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3640';
20241203@151203.7293 beedqbn7tf6ena7l32dhvs35dc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3640';
20241203@151203.7831 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241203@151203.7842 8rgnp0hchs4hg6ud2nfe0sursl Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241203@151203.7938 8rgnp0hchs4hg6ud2nfe0sursl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3641';
20241203@151203.8009 8rgnp0hchs4hg6ud2nfe0sursl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3641';
20241203@151203.8079 8rgnp0hchs4hg6ud2nfe0sursl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3641';
20241203@151203.8130 8rgnp0hchs4hg6ud2nfe0sursl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3641';
20241203@151203.8197 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151203.8200 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241203@151203.8267 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151203.8270 8rgnp0hchs4hg6ud2nfe0sursl Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20241203@151203.8372 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20241203@151203.8395 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408160 and bi.ref ='327.8253.00.1' and bi.lordem =1
20241203@151204.1268 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241203@151204.1299 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408160 and bi.ref ='324.1832.00.2' and bi.lordem =2
20241203@151204.1664 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241203@151204.1689 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408160 and bi.ref ='324.1832.00.2' and bi.lordem =3
20241203@151204.2054 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2057 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241203@151204.2092 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2095 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 1 valor from td where td.ndoc = 39
20241203@151204.2136 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2139 8rgnp0hchs4hg6ud2nfe0sursl 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')
20241203@151204.2173 8rgnp0hchs4hg6ud2nfe0sursl 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
20241203@151204.2220 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2224 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241203@151204.2270 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2277 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241203@151204.2313 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2316 8rgnp0hchs4hg6ud2nfe0sursl Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241203@151204.2373 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2376 8rgnp0hchs4hg6ud2nfe0sursl Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - corroios'
20241203@151204.2511 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.2515 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from td where ndoc = 39
20241203@151204.2529 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241203@151204.2549 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.2601 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151204.2625 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.2668 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151204.2709 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.2730 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151204.2747 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151204.2809 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151204.2826 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.2848 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151204.2866 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674f100171674f1fc443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241203@151204.3068 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.3118 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151204.3160 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241203@151204.3176 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241203@151204.3191 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241203@151204.3207 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241203@151204.3220 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241203@151204.3240 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241203@151204.3253 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674f100171674f1fc443',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241203@151204.3567 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 fno valor from wsftdata order by fno desc
20241203@151204.3682 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.3709 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151204.4129 8rgnp0hchs4hg6ud2nfe0sursl Query : select 'normal' from dummy
20241203@151204.4153 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674f100171674f1fc443',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2163,101621,0,'2024-12-03',39,'euro',0,0,2024 ,?,?)
20241203@151204.4477 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.4480 8rgnp0hchs4hg6ud2nfe0sursl Query : select st.usalote valor from st where st.ref = '327.8253.00.1'
20241203@151204.4503 8rgnp0hchs4hg6ud2nfe0sursl 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 = '327.8253.00.1'
20241203@151204.4522 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.4571 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.4604 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.4620 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.4630 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151204.4643 8rgnp0hchs4hg6ud2nfe0sursl Query : select sestamp valor from se where ref ='327.8253.00.1' and lote = 'r2400073100b'
20241203@151204.4660 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.4683 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.4698 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f115958674f1fc471','aut674f100171674f1fc443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151204.4704 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.4722 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.4756 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f115958674f1fc471',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674f100171674f1fc443' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241203@151204.5208 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.5463 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.5561 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.5580 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.5590 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151204.5610 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.5631 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.5648 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f164991674f1fc488','aut674f100171674f1fc443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151204.5653 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.5670 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.5710 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f164991674f1fc488',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f100171674f1fc443' ,0,0 ,2,23.00,20000,?,?,?)
20241203@151204.6014 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.6018 8rgnp0hchs4hg6ud2nfe0sursl Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241203@151204.6043 8rgnp0hchs4hg6ud2nfe0sursl 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.1832.00.2'
20241203@151204.6058 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6085 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.6126 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6143 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.6153 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151204.6166 8rgnp0hchs4hg6ud2nfe0sursl Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241203@151204.6182 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6199 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.6213 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f105908674f1fc496','aut674f100171674f1fc443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151204.6218 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6234 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.6273 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f105908674f1fc496',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut674f100171674f1fc443' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241203@151204.6580 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6599 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.6656 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6674 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.6684 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151204.6699 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6718 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.6739 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f167256674f1fc4a3','aut674f100171674f1fc443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151204.6744 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.6761 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.6794 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f167256674f1fc4a3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f100171674f1fc443' ,0,0 ,2,23.00,50000,?,?,?)
20241203@151204.7085 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.7088 8rgnp0hchs4hg6ud2nfe0sursl Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241203@151204.7109 8rgnp0hchs4hg6ud2nfe0sursl 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.1832.00.2'
20241203@151204.7127 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7148 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.7179 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7196 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.7206 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151204.7221 8rgnp0hchs4hg6ud2nfe0sursl Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241203@151204.7236 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7254 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.7267 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f154164674f1fc4b0','aut674f100171674f1fc443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151204.7272 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7287 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.7331 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f154164674f1fc4b0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674f100171674f1fc443' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241203@151204.7733 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7753 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.7784 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7801 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.7811 8rgnp0hchs4hg6ud2nfe0sursl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151204.7824 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7841 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151204.7854 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f148788674f1fc4bf','aut674f100171674f1fc443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151204.7858 8rgnp0hchs4hg6ud2nfe0sursl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151204.7874 8rgnp0hchs4hg6ud2nfe0sursl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151204.7911 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f148788674f1fc4bf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f100171674f1fc443' ,0,0 ,2,23.00,80000,?,?,?)
20241203@151204.8224 8rgnp0hchs4hg6ud2nfe0sursl Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674f100171674f1fc443','2408160','wait',39,'adm09112754980.682000002')
20241203@151204.8311 8rgnp0hchs4hg6ud2nfe0sursl Query : use flama_phc
20241203@151204.8314 8rgnp0hchs4hg6ud2nfe0sursl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241203@151204.8349 8rgnp0hchs4hg6ud2nfe0sursl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3641';
20241203@151204.8389 8rgnp0hchs4hg6ud2nfe0sursl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3641';
20241203@151204.8440 8rgnp0hchs4hg6ud2nfe0sursl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3641';
20241203@151204.8486 8rgnp0hchs4hg6ud2nfe0sursl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3641';
20241203@151204.9075 r753ojdf0l0oii28f5ctv27mn9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241203@151204.9100 r753ojdf0l0oii28f5ctv27mn9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241203@151204.9269 r753ojdf0l0oii28f5ctv27mn9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3642';
20241203@151204.9333 r753ojdf0l0oii28f5ctv27mn9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3642';
20241203@151204.9453 r753ojdf0l0oii28f5ctv27mn9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3642';
20241203@151204.9503 r753ojdf0l0oii28f5ctv27mn9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3642';
20241203@151204.9577 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151204.9581 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241203@151204.9657 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151204.9660 r753ojdf0l0oii28f5ctv27mn9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2014
20241203@151204.9753 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241203@151205.1098 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408164 and bi.ref ='324.5343.00.1' and bi.lordem =1
20241203@151205.1647 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241203@151205.1672 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408164 and bi.ref ='324.1832.00.2' and bi.lordem =3
20241203@151205.2046 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241203@151205.2069 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408164 and bi.ref ='324.1832.00.2' and bi.lordem =4
20241203@151205.2418 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.2429 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241203@151205.2468 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.2472 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 1 valor from td where td.ndoc = 39
20241203@151205.2618 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.2660 r753ojdf0l0oii28f5ctv27mn9 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')
20241203@151205.2748 r753ojdf0l0oii28f5ctv27mn9 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
20241203@151205.2791 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.2795 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241203@151205.2831 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.2835 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241203@151205.2889 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.2893 r753ojdf0l0oii28f5ctv27mn9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241203@151205.2936 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.2939 r753ojdf0l0oii28f5ctv27mn9 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - guarda'
20241203@151205.3009 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.3013 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from td where ndoc = 39
20241203@151205.3077 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241203@151205.3108 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.3128 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151205.3179 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.3204 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151205.3247 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.3262 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151205.3278 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151205.3346 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151205.3362 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.3387 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151205.3406 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674f129975674f1fc550' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241203@151205.3590 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.3612 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151205.3657 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241203@151205.3675 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241203@151205.3693 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241203@151205.3707 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241203@151205.3732 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241203@151205.3752 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241203@151205.3768 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674f129975674f1fc550',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241203@151205.4072 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 fno valor from wsftdata order by fno desc
20241203@151205.4112 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.4136 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151205.4165 r753ojdf0l0oii28f5ctv27mn9 Query : select 'normal' from dummy
20241203@151205.4187 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674f129975674f1fc550',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2164,101621,0,'2024-12-03',39,'euro',0,0,2024 ,?,?)
20241203@151205.4502 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.4506 r753ojdf0l0oii28f5ctv27mn9 Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20241203@151205.4559 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5343.00.1'
20241203@151205.4742 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.4761 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.4798 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.4819 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.4831 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151205.4846 r753ojdf0l0oii28f5ctv27mn9 Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20241203@151205.4877 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.4903 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.4920 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f194044674f1fc577','aut674f129975674f1fc550' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151205.4926 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.4983 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.5032 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f194044674f1fc577',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut674f129975674f1fc550' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241203@151205.5339 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.5359 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.5446 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.5465 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.5544 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151205.5691 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.5852 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.5898 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f183497674f1fc58a','aut674f129975674f1fc550' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151205.5904 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.5936 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.5989 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f183497674f1fc58a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f129975674f1fc550' ,0,0 ,2,23.00,20000,?,?,?)
20241203@151205.6292 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.6296 r753ojdf0l0oii28f5ctv27mn9 Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241203@151205.6324 r753ojdf0l0oii28f5ctv27mn9 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.1832.00.2'
20241203@151205.6346 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.6367 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.6402 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.6426 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.6438 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151205.6459 r753ojdf0l0oii28f5ctv27mn9 Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241203@151205.6477 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.6498 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.6516 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f194514674f1fc59e','aut674f129975674f1fc550' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151205.6523 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.6546 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.6588 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f194514674f1fc59e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut674f129975674f1fc550' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241203@151205.6890 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.6912 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.6957 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.6978 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.6991 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151205.7023 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.7046 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.7062 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f157643674f1fc5ab','aut674f129975674f1fc550' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151205.7068 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.7091 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.7138 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f157643674f1fc5ab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f129975674f1fc550' ,0,0 ,2,23.00,50000,?,?,?)
20241203@151205.7436 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.7442 r753ojdf0l0oii28f5ctv27mn9 Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241203@151205.7489 r753ojdf0l0oii28f5ctv27mn9 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.1832.00.2'
20241203@151205.7510 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.7533 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.7572 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.7591 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.7602 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151205.7624 r753ojdf0l0oii28f5ctv27mn9 Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241203@151205.7648 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.7670 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.7687 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f190483674f1fc5ba','aut674f129975674f1fc550' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151205.7693 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.7714 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.7757 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f190483674f1fc5ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674f129975674f1fc550' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241203@151205.8069 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.8095 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.8138 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.8161 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.8171 r753ojdf0l0oii28f5ctv27mn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151205.8187 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.8204 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151205.8219 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f100417674f1fc5c7','aut674f129975674f1fc550' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151205.8224 r753ojdf0l0oii28f5ctv27mn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151205.8243 r753ojdf0l0oii28f5ctv27mn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151205.8277 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f100417674f1fc5c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f129975674f1fc550' ,0,0 ,2,23.00,80000,?,?,?)
20241203@151205.8556 r753ojdf0l0oii28f5ctv27mn9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674f129975674f1fc550','2408164','wait',39,'adm09112754980.682000002')
20241203@151205.8641 r753ojdf0l0oii28f5ctv27mn9 Query : use flama_phc
20241203@151205.8645 r753ojdf0l0oii28f5ctv27mn9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241203@151205.8682 r753ojdf0l0oii28f5ctv27mn9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3642';
20241203@151205.8724 r753ojdf0l0oii28f5ctv27mn9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3642';
20241203@151205.8775 r753ojdf0l0oii28f5ctv27mn9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3642';
20241203@151205.8806 r753ojdf0l0oii28f5ctv27mn9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3642';
20241203@151205.9355 srjgudlbhg4s05m1f2aoieqppl Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241203@151205.9366 srjgudlbhg4s05m1f2aoieqppl Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241203@151205.9444 srjgudlbhg4s05m1f2aoieqppl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3643';
20241203@151205.9510 srjgudlbhg4s05m1f2aoieqppl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3643';
20241203@151205.9575 srjgudlbhg4s05m1f2aoieqppl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3643';
20241203@151205.9608 srjgudlbhg4s05m1f2aoieqppl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3643';
20241203@151205.9671 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151205.9675 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241203@151205.9755 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151205.9759 srjgudlbhg4s05m1f2aoieqppl Query : select no, estab,szadrsdesc from szadrs where u_coddest=9128
20241203@151205.9851 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241203@151205.9877 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408169 and bi.ref ='324.5343.00.1' and bi.lordem =1
20241203@151206.2280 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.2350 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241203@151206.2770 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.2820 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 1 valor from td where td.ndoc = 39
20241203@151206.3200 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.3250 srjgudlbhg4s05m1f2aoieqppl 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')
20241203@151206.3570 srjgudlbhg4s05m1f2aoieqppl 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
20241203@151206.4340 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.4620 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241203@151206.5050 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.5110 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241203@151206.5490 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.5540 srjgudlbhg4s05m1f2aoieqppl Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241203@151206.6020 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.6060 srjgudlbhg4s05m1f2aoieqppl Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - v. castelo (nova)'
20241203@151206.6660 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.6700 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from td where ndoc = 39
20241203@151206.7050 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241203@151206.7230 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.7450 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151206.7700 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.7860 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151206.8530 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.8720 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151206.8870 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151206.9650 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151206.9880 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.1009 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151206.2265 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674f106227674f1fc615' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241203@151206.2473 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.2803 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151206.2856 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241203@151206.2873 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241203@151206.2890 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241203@151206.2907 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241203@151206.2922 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241203@151206.2948 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241203@151206.2972 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674f106227674f1fc615',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241203@151206.3261 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 fno valor from wsftdata order by fno desc
20241203@151206.3291 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.3311 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151206.3350 srjgudlbhg4s05m1f2aoieqppl Query : select 'normal' from dummy
20241203@151206.3373 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674f106227674f1fc615',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2165,101621,0,'2024-12-03',39,'euro',0,0,2024 ,?,?)
20241203@151206.3714 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.3718 srjgudlbhg4s05m1f2aoieqppl Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20241203@151206.3755 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5343.00.1'
20241203@151206.3774 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.3801 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151206.3842 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.3863 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151206.3881 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151206.3908 srjgudlbhg4s05m1f2aoieqppl Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20241203@151206.3933 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.3961 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151206.3981 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f115940674f1fc660','aut674f106227674f1fc615' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151206.3986 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.4010 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151206.4091 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f115940674f1fc660',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut674f106227674f1fc615' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241203@151206.4387 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.4410 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151206.4450 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.4469 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151206.4479 srjgudlbhg4s05m1f2aoieqppl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151206.4497 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.4545 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151206.4562 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f144073674f1fc66d','aut674f106227674f1fc615' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151206.4566 srjgudlbhg4s05m1f2aoieqppl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.4587 srjgudlbhg4s05m1f2aoieqppl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151206.4631 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f144073674f1fc66d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f106227674f1fc615' ,0,0 ,2,23.00,20000,?,?,?)
20241203@151206.4937 srjgudlbhg4s05m1f2aoieqppl Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674f106227674f1fc615','2408169','wait',39,'adm09112754980.682000002')
20241203@151206.5029 srjgudlbhg4s05m1f2aoieqppl Query : use flama_phc
20241203@151206.5034 srjgudlbhg4s05m1f2aoieqppl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241203@151206.5073 srjgudlbhg4s05m1f2aoieqppl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3643';
20241203@151206.5118 srjgudlbhg4s05m1f2aoieqppl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3643';
20241203@151206.5174 srjgudlbhg4s05m1f2aoieqppl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3643';
20241203@151206.5228 srjgudlbhg4s05m1f2aoieqppl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3643';
20241203@151206.5778 jok8k5uh2qdlpd633rpeii0038 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241203@151206.5790 jok8k5uh2qdlpd633rpeii0038 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241203@151206.5868 jok8k5uh2qdlpd633rpeii0038 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3644';
20241203@151206.5939 jok8k5uh2qdlpd633rpeii0038 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3644';
20241203@151206.6011 jok8k5uh2qdlpd633rpeii0038 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3644';
20241203@151206.6245 jok8k5uh2qdlpd633rpeii0038 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3644';
20241203@151206.6534 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.6538 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241203@151206.6618 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.6621 jok8k5uh2qdlpd633rpeii0038 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6855
20241203@151206.6728 jok8k5uh2qdlpd633rpeii0038 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'
20241203@151206.6918 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408174 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241203@151206.7285 jok8k5uh2qdlpd633rpeii0038 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'
20241203@151206.7328 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408174 and bi.ref ='324.1831.00.2' and bi.lordem =2
20241203@151206.7746 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9902.00.1'
20241203@151206.7781 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2081 and bo.obrano = 2408174 and bi.ref ='328.9902.00.1' and bi.lordem =3
20241203@151206.8173 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8177 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241203@151206.8247 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8256 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 1 valor from td where td.ndoc = 39
20241203@151206.8311 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8314 jok8k5uh2qdlpd633rpeii0038 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')
20241203@151206.8358 jok8k5uh2qdlpd633rpeii0038 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
20241203@151206.8415 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8419 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241203@151206.8461 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8465 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241203@151206.8498 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8501 jok8k5uh2qdlpd633rpeii0038 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241203@151206.8570 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8576 jok8k5uh2qdlpd633rpeii0038 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - montijo nova'
20241203@151206.8672 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151206.8676 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from td where ndoc = 39
20241203@151206.8699 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241203@151206.8718 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.8746 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151206.8778 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.8805 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151206.8854 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.8873 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151206.8896 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151206.8957 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241203@151206.8983 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.9001 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241203@151206.9027 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674f128530674f1fc6d9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241203@151206.9302 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151206.9327 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241203@151206.9373 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241203@151206.9392 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241203@151206.9408 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241203@151206.9424 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241203@151206.9444 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241203@151206.9461 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241203@151206.9477 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674f128530674f1fc6d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241203@151206.9993 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 fno valor from wsftdata order by fno desc
20241203@151207.2400 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.4500 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241203@151207.7500 jok8k5uh2qdlpd633rpeii0038 Query : select 'normal' from dummy
20241203@151207.9500 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674f128530674f1fc6d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2166,101621,0,'2024-12-03',39,'euro',0,0,2024 ,?,?)
20241203@151207.4200 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151207.4230 jok8k5uh2qdlpd633rpeii0038 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241203@151207.4730 jok8k5uh2qdlpd633rpeii0038 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'
20241203@151207.6310 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.6520 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151207.6910 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.7090 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151207.7200 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151207.7410 jok8k5uh2qdlpd633rpeii0038 Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20241203@151207.7630 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.7860 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151207.8010 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f141402674f1fc712','aut674f128530674f1fc6d9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151207.8070 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.8280 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151207.8680 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f141402674f1fc712',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut674f128530674f1fc6d9' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241203@151207.1194 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.1220 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151207.1260 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.1285 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151207.1296 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151207.1312 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.1334 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151207.1380 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f191455674f1fc720','aut674f128530674f1fc6d9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151207.1385 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.1409 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151207.1455 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674f191455674f1fc720',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674f128530674f1fc6d9' ,0,0 ,2,23.00,20000,?,?,?)
20241203@151207.1772 jok8k5uh2qdlpd633rpeii0038 Query : use flama_phc
20241203@151207.1776 jok8k5uh2qdlpd633rpeii0038 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241203@151207.1801 jok8k5uh2qdlpd633rpeii0038 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'
20241203@151207.1828 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.1852 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151207.1891 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.1908 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151207.1919 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241203@151207.1942 jok8k5uh2qdlpd633rpeii0038 Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20241203@151207.1961 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.1982 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151207.2000 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674f123406674f1fc72f','aut674f128530674f1fc6d9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241203@151207.2005 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.2025 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151207.2075 jok8k5uh2qdlpd633rpeii0038 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674f123406674f1fc72f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut674f128530674f1fc6d9' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241203@151207.2369 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.2393 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241203@151207.2432 jok8k5uh2qdlpd633rpeii0038 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241203@151207.2454 jok8k5uh2qdlpd633rpeii0038 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241203@151207.2493 jok8k5uh2qdlpd633rpeii0038 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
