20241016@175747.7662 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175747.7678 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175747.7712 f7p97c8gcao09v7dk8sno1laik Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175747.7724 f7p97c8gcao09v7dk8sno1laik Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175747.7736 f7p97c8gcao09v7dk8sno1laik Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175747.7748 f7p97c8gcao09v7dk8sno1laik Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175747.7760 f7p97c8gcao09v7dk8sno1laik Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175747.7773 f7p97c8gcao09v7dk8sno1laik Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175747.7785 f7p97c8gcao09v7dk8sno1laik Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff41689670ff08bb4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175747.7997 f7p97c8gcao09v7dk8sno1laik Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175747.8023 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175747.8041 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175747.8066 f7p97c8gcao09v7dk8sno1laik Query : select 'normal' from dummy
20241016@175747.8082 f7p97c8gcao09v7dk8sno1laik Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff41689670ff08bb4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1312,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175747.8330 f7p97c8gcao09v7dk8sno1laik Query : use flama_phc
20241016@175747.8333 f7p97c8gcao09v7dk8sno1laik Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175747.8356 f7p97c8gcao09v7dk8sno1laik 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.2335.00.1'
20241016@175747.8370 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175747.8388 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175747.8418 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175747.8433 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175747.8442 f7p97c8gcao09v7dk8sno1laik Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175747.8455 f7p97c8gcao09v7dk8sno1laik Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500b'
20241016@175747.8469 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175747.8484 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175747.8497 f7p97c8gcao09v7dk8sno1laik Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff25026670ff08bce','aut670ff41689670ff08bb4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175747.8501 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175747.8516 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175747.8548 f7p97c8gcao09v7dk8sno1laik Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff25026670ff08bce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut670ff41689670ff08bb4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241016@175747.8767 f7p97c8gcao09v7dk8sno1laik Query : use flama_phc
20241016@175747.8771 f7p97c8gcao09v7dk8sno1laik Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175747.8840 f7p97c8gcao09v7dk8sno1laik 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.2335.00.1'
20241016@175747.8855 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175747.8873 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175747.8902 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.1800 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.2900 f7p97c8gcao09v7dk8sno1laik Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175748.4200 f7p97c8gcao09v7dk8sno1laik Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500b'
20241016@175748.5500 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.7300 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.8500 f7p97c8gcao09v7dk8sno1laik Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff40367670ff08c01','aut670ff41689670ff08bb4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175748.8900 f7p97c8gcao09v7dk8sno1laik Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.1040 f7p97c8gcao09v7dk8sno1laik Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.1330 f7p97c8gcao09v7dk8sno1laik Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff40367670ff08c01',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut670ff41689670ff08bb4' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241016@175748.3520 f7p97c8gcao09v7dk8sno1laik Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670ff41689670ff08bb4','2406746','wait',39,'adm09112754980.682000002')
20241016@175748.4270 f7p97c8gcao09v7dk8sno1laik Query : use flama_phc
20241016@175748.4300 f7p97c8gcao09v7dk8sno1laik Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241016@175748.4590 f7p97c8gcao09v7dk8sno1laik Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2710';
20241016@175748.4920 f7p97c8gcao09v7dk8sno1laik Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2710';
20241016@175748.5340 f7p97c8gcao09v7dk8sno1laik Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2710';
20241016@175748.5620 f7p97c8gcao09v7dk8sno1laik Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2710';
20241016@175748.1067 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175748.1078 f3gblcr05oko2nndhhsj7fkpq2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175748.1136 f3gblcr05oko2nndhhsj7fkpq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2711';
20241016@175748.1194 f3gblcr05oko2nndhhsj7fkpq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2711';
20241016@175748.1271 f3gblcr05oko2nndhhsj7fkpq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2711';
20241016@175748.1299 f3gblcr05oko2nndhhsj7fkpq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2711';
20241016@175748.1351 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.1354 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175748.1419 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.1422 f3gblcr05oko2nndhhsj7fkpq2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175748.1464 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175748.1484 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406747 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175748.1836 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175748.1856 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406747 and bi.ref ='324.2335.00.1' and bi.lordem =2
20241016@175748.2137 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2140 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241016@175748.2176 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2178 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 1 valor from td where td.ndoc = 39
20241016@175748.2235 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2238 f3gblcr05oko2nndhhsj7fkpq2 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')
20241016@175748.2266 f3gblcr05oko2nndhhsj7fkpq2 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
20241016@175748.2300 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2303 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241016@175748.2335 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2338 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241016@175748.2370 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2373 f3gblcr05oko2nndhhsj7fkpq2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241016@175748.2410 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2413 f3gblcr05oko2nndhhsj7fkpq2 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241016@175748.2460 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.2463 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from td where ndoc = 39
20241016@175748.2476 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241016@175748.2513 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.2529 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175748.2548 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.2563 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175748.2591 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.2605 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175748.2617 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175748.2682 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175748.2694 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.2710 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175748.2726 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670ff45101670ff08c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241016@175748.2870 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.2885 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175748.2918 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175748.2934 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175748.2945 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175748.2957 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175748.2968 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175748.3004 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175748.3015 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff45101670ff08c3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175748.3250 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175748.3276 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.3291 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175748.3314 f3gblcr05oko2nndhhsj7fkpq2 Query : select 'normal' from dummy
20241016@175748.3329 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff45101670ff08c3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1313,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175748.3679 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.3683 f3gblcr05oko2nndhhsj7fkpq2 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175748.3704 f3gblcr05oko2nndhhsj7fkpq2 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.2335.00.1'
20241016@175748.3718 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.3734 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.3760 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.3776 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.3785 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175748.3798 f3gblcr05oko2nndhhsj7fkpq2 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500b'
20241016@175748.3812 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.3828 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.3842 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff81784670ff08c5d','aut670ff45101670ff08c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175748.3847 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.3861 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.3891 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff81784670ff08c5d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut670ff45101670ff08c3f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241016@175748.4116 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.4119 f3gblcr05oko2nndhhsj7fkpq2 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175748.4140 f3gblcr05oko2nndhhsj7fkpq2 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.2335.00.1'
20241016@175748.4155 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.4201 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.4228 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.4243 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.4253 f3gblcr05oko2nndhhsj7fkpq2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175748.4266 f3gblcr05oko2nndhhsj7fkpq2 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500b'
20241016@175748.4279 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.4294 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.4309 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff88264670ff08c68','aut670ff45101670ff08c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175748.4313 f3gblcr05oko2nndhhsj7fkpq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.4329 f3gblcr05oko2nndhhsj7fkpq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.4361 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff88264670ff08c68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut670ff45101670ff08c3f' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241016@175748.4582 f3gblcr05oko2nndhhsj7fkpq2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670ff45101670ff08c3f','2406747','wait',39,'adm09112754980.682000002')
20241016@175748.4649 f3gblcr05oko2nndhhsj7fkpq2 Query : use flama_phc
20241016@175748.4653 f3gblcr05oko2nndhhsj7fkpq2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241016@175748.4685 f3gblcr05oko2nndhhsj7fkpq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2711';
20241016@175748.4718 f3gblcr05oko2nndhhsj7fkpq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2711';
20241016@175748.4761 f3gblcr05oko2nndhhsj7fkpq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2711';
20241016@175748.4791 f3gblcr05oko2nndhhsj7fkpq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2711';
20241016@175748.5393 p6ognu6bbcbrjajvihhgog1u0r Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175748.5404 p6ognu6bbcbrjajvihhgog1u0r Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175748.5499 p6ognu6bbcbrjajvihhgog1u0r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2712';
20241016@175748.5585 p6ognu6bbcbrjajvihhgog1u0r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2712';
20241016@175748.5642 p6ognu6bbcbrjajvihhgog1u0r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2712';
20241016@175748.5671 p6ognu6bbcbrjajvihhgog1u0r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2712';
20241016@175748.5721 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.5724 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175748.5814 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.5816 p6ognu6bbcbrjajvihhgog1u0r Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175748.5855 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175748.5875 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406748 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175748.6166 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175748.6188 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406748 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175748.6206 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175748.6228 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406748 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175748.6248 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6275 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241016@175748.6310 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6313 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 1 valor from td where td.ndoc = 39
20241016@175748.6343 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6345 p6ognu6bbcbrjajvihhgog1u0r 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')
20241016@175748.6374 p6ognu6bbcbrjajvihhgog1u0r 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
20241016@175748.6408 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6411 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241016@175748.6443 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6445 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241016@175748.6477 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6480 p6ognu6bbcbrjajvihhgog1u0r Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241016@175748.6520 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6523 p6ognu6bbcbrjajvihhgog1u0r Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241016@175748.6571 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.6574 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from td where ndoc = 39
20241016@175748.6608 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241016@175748.6622 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.6641 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175748.6660 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.6677 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175748.6705 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.6720 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175748.6733 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175748.6797 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175748.6810 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.6826 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175748.6842 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670ff13388670ff08ca4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241016@175748.7024 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.7042 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175748.7076 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175748.7088 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175748.7100 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175748.7112 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175748.7123 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175748.7135 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175748.7146 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff13388670ff08ca4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175748.7359 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175748.7380 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.7396 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175748.7419 p6ognu6bbcbrjajvihhgog1u0r Query : select 'normal' from dummy
20241016@175748.7434 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff13388670ff08ca4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1314,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175748.7709 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.7712 p6ognu6bbcbrjajvihhgog1u0r Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175748.7736 p6ognu6bbcbrjajvihhgog1u0r 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.2335.00.1'
20241016@175748.7750 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.7768 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.7793 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.7809 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.7818 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175748.7829 p6ognu6bbcbrjajvihhgog1u0r Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500b'
20241016@175748.7841 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.7858 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.7871 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff32831670ff08cbf','aut670ff13388670ff08ca4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175748.7881 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.7897 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.7930 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff32831670ff08cbf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut670ff13388670ff08ca4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241016@175748.8157 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.8160 p6ognu6bbcbrjajvihhgog1u0r Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175748.8180 p6ognu6bbcbrjajvihhgog1u0r 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.2335.00.1'
20241016@175748.8195 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.8212 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.8237 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.8252 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.8264 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175748.8276 p6ognu6bbcbrjajvihhgog1u0r Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241016@175748.8288 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.8303 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.8314 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff79636670ff08cca','aut670ff13388670ff08ca4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175748.8319 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.8334 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.8363 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff79636670ff08cca',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut670ff13388670ff08ca4' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241016@175748.8578 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.8581 p6ognu6bbcbrjajvihhgog1u0r Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175748.8624 p6ognu6bbcbrjajvihhgog1u0r 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.2335.00.1'
20241016@175748.8638 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.8657 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.9051 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.9068 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.9139 p6ognu6bbcbrjajvihhgog1u0r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175748.9152 p6ognu6bbcbrjajvihhgog1u0r Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241016@175748.9166 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.9185 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175748.9197 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff64364670ff08cdf','aut670ff13388670ff08ca4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175748.9202 p6ognu6bbcbrjajvihhgog1u0r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175748.9218 p6ognu6bbcbrjajvihhgog1u0r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175748.9245 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff64364670ff08cdf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut670ff13388670ff08ca4' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241016@175748.9457 p6ognu6bbcbrjajvihhgog1u0r Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670ff13388670ff08ca4','2406748','wait',39,'adm09112754980.682000002')
20241016@175748.9534 p6ognu6bbcbrjajvihhgog1u0r Query : use flama_phc
20241016@175748.9537 p6ognu6bbcbrjajvihhgog1u0r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241016@175748.9568 p6ognu6bbcbrjajvihhgog1u0r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2712';
20241016@175748.9600 p6ognu6bbcbrjajvihhgog1u0r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2712';
20241016@175748.9649 p6ognu6bbcbrjajvihhgog1u0r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2712';
20241016@175748.9675 p6ognu6bbcbrjajvihhgog1u0r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2712';
20241016@175749.1840 hg987ae1a3df00pvu4ls6osvgr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175749.1950 hg987ae1a3df00pvu4ls6osvgr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175749.2530 hg987ae1a3df00pvu4ls6osvgr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2713';
20241016@175749.3060 hg987ae1a3df00pvu4ls6osvgr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2713';
20241016@175749.3620 hg987ae1a3df00pvu4ls6osvgr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2713';
20241016@175749.3900 hg987ae1a3df00pvu4ls6osvgr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2713';
20241016@175749.4400 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.4430 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175749.5090 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.5110 hg987ae1a3df00pvu4ls6osvgr Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175749.5540 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175749.5730 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406749 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175749.8710 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175749.9660 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406749 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175749.1030 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1033 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241016@175749.1070 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1073 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 1 valor from td where td.ndoc = 39
20241016@175749.1103 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1106 hg987ae1a3df00pvu4ls6osvgr 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')
20241016@175749.1135 hg987ae1a3df00pvu4ls6osvgr 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
20241016@175749.1170 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1173 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241016@175749.1201 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1204 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241016@175749.1233 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1236 hg987ae1a3df00pvu4ls6osvgr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241016@175749.1276 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1279 hg987ae1a3df00pvu4ls6osvgr Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241016@175749.1324 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.1327 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from td where ndoc = 39
20241016@175749.1339 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241016@175749.1353 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.1368 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175749.1387 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.1401 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175749.1430 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.1446 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175749.1460 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175749.1522 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175749.1535 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.1549 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175749.1564 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670ff14634670ff08d23' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241016@175749.1714 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.1731 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175749.1767 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175749.1780 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175749.1793 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175749.1805 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175749.1818 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175749.1831 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175749.1843 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff14634670ff08d23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175749.2050 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175749.2076 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.2094 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175749.2119 hg987ae1a3df00pvu4ls6osvgr Query : select 'normal' from dummy
20241016@175749.2136 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff14634670ff08d23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1315,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175749.2447 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.2451 hg987ae1a3df00pvu4ls6osvgr Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175749.2476 hg987ae1a3df00pvu4ls6osvgr 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.2335.00.1'
20241016@175749.2512 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.2768 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.2896 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.2914 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.2952 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175749.2965 hg987ae1a3df00pvu4ls6osvgr Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241016@175749.2978 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.2993 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.3005 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff18438670ff08d48','aut670ff14634670ff08d23' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175749.3010 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.3024 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.3053 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff18438670ff08d48',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut670ff14634670ff08d23' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241016@175749.3271 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.3274 hg987ae1a3df00pvu4ls6osvgr Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175749.3293 hg987ae1a3df00pvu4ls6osvgr 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.2335.00.1'
20241016@175749.3308 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.3324 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.3349 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.3363 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.3371 hg987ae1a3df00pvu4ls6osvgr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175749.3384 hg987ae1a3df00pvu4ls6osvgr Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241016@175749.3396 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.3410 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.3421 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff14254670ff08d52','aut670ff14634670ff08d23' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175749.3425 hg987ae1a3df00pvu4ls6osvgr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.3439 hg987ae1a3df00pvu4ls6osvgr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.3469 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff14254670ff08d52',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut670ff14634670ff08d23' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241016@175749.3739 hg987ae1a3df00pvu4ls6osvgr Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670ff14634670ff08d23','2406749','wait',39,'adm09112754980.682000002')
20241016@175749.3812 hg987ae1a3df00pvu4ls6osvgr Query : use flama_phc
20241016@175749.3815 hg987ae1a3df00pvu4ls6osvgr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241016@175749.3845 hg987ae1a3df00pvu4ls6osvgr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2713';
20241016@175749.3879 hg987ae1a3df00pvu4ls6osvgr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2713';
20241016@175749.3922 hg987ae1a3df00pvu4ls6osvgr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2713';
20241016@175749.3948 hg987ae1a3df00pvu4ls6osvgr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2713';
20241016@175749.4483 t7klao7rl3c78e12r218ppoht5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175749.4495 t7klao7rl3c78e12r218ppoht5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175749.4553 t7klao7rl3c78e12r218ppoht5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2714';
20241016@175749.5694 t7klao7rl3c78e12r218ppoht5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2714';
20241016@175749.5756 t7klao7rl3c78e12r218ppoht5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2714';
20241016@175749.5787 t7klao7rl3c78e12r218ppoht5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2714';
20241016@175749.5842 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.5845 t7klao7rl3c78e12r218ppoht5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175749.5907 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.5910 t7klao7rl3c78e12r218ppoht5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175749.5951 t7klao7rl3c78e12r218ppoht5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175749.5970 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406750 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175749.6298 t7klao7rl3c78e12r218ppoht5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241016@175749.6321 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406750 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241016@175749.6339 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6342 t7klao7rl3c78e12r218ppoht5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241016@175749.6375 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6378 t7klao7rl3c78e12r218ppoht5 Query : select top 1 1 valor from td where td.ndoc = 39
20241016@175749.6411 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6415 t7klao7rl3c78e12r218ppoht5 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')
20241016@175749.6445 t7klao7rl3c78e12r218ppoht5 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
20241016@175749.6481 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6484 t7klao7rl3c78e12r218ppoht5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241016@175749.6517 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6520 t7klao7rl3c78e12r218ppoht5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241016@175749.6549 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6552 t7klao7rl3c78e12r218ppoht5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241016@175749.6593 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6596 t7klao7rl3c78e12r218ppoht5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241016@175749.6640 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.6643 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from td where ndoc = 39
20241016@175749.6655 t7klao7rl3c78e12r218ppoht5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241016@175749.6671 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.6689 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175749.6708 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.6722 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175749.6750 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.6765 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175749.6778 t7klao7rl3c78e12r218ppoht5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175749.6842 t7klao7rl3c78e12r218ppoht5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175749.6855 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.6870 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175749.6885 t7klao7rl3c78e12r218ppoht5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670ff20154670ff08da5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241016@175749.7032 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.7073 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175749.7107 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175749.7235 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175749.7251 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175749.7263 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175749.7275 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175749.7287 t7klao7rl3c78e12r218ppoht5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175749.7298 t7klao7rl3c78e12r218ppoht5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff20154670ff08da5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175749.7497 t7klao7rl3c78e12r218ppoht5 Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175749.7519 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.7535 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175749.7558 t7klao7rl3c78e12r218ppoht5 Query : select 'normal' from dummy
20241016@175749.7574 t7klao7rl3c78e12r218ppoht5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff20154670ff08da5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1316,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175749.7899 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.7902 t7klao7rl3c78e12r218ppoht5 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175749.7923 t7klao7rl3c78e12r218ppoht5 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.2335.00.1'
20241016@175749.7940 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.7956 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.7981 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.7996 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.8004 t7klao7rl3c78e12r218ppoht5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175749.8016 t7klao7rl3c78e12r218ppoht5 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241016@175749.8029 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.8043 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.8054 t7klao7rl3c78e12r218ppoht5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff80852670ff08dc4','aut670ff20154670ff08da5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175749.8058 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.8073 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.8126 t7klao7rl3c78e12r218ppoht5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff80852670ff08dc4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut670ff20154670ff08da5' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241016@175749.8410 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.8414 t7klao7rl3c78e12r218ppoht5 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241016@175749.8434 t7klao7rl3c78e12r218ppoht5 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.2335.00.1'
20241016@175749.8448 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.8464 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.8490 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.8504 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.8512 t7klao7rl3c78e12r218ppoht5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175749.8524 t7klao7rl3c78e12r218ppoht5 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241016@175749.8536 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.8550 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175749.8561 t7klao7rl3c78e12r218ppoht5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff05312670ff08dd0','aut670ff20154670ff08da5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175749.8565 t7klao7rl3c78e12r218ppoht5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175749.8607 t7klao7rl3c78e12r218ppoht5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175749.8635 t7klao7rl3c78e12r218ppoht5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff05312670ff08dd0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut670ff20154670ff08da5' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241016@175749.8849 t7klao7rl3c78e12r218ppoht5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670ff20154670ff08da5','2406750','wait',39,'adm09112754980.682000002')
20241016@175749.8922 t7klao7rl3c78e12r218ppoht5 Query : use flama_phc
20241016@175749.8925 t7klao7rl3c78e12r218ppoht5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241016@175749.8956 t7klao7rl3c78e12r218ppoht5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2714';
20241016@175749.8987 t7klao7rl3c78e12r218ppoht5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2714';
20241016@175749.9042 t7klao7rl3c78e12r218ppoht5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2714';
20241016@175749.9067 t7klao7rl3c78e12r218ppoht5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2714';
20241016@175749.9706 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175749.9718 mhi5dk6uh6u64vrn3mb22g25vl Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175749.9775 mhi5dk6uh6u64vrn3mb22g25vl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2715';
20241016@175749.9829 mhi5dk6uh6u64vrn3mb22g25vl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2715';
20241016@175749.9907 mhi5dk6uh6u64vrn3mb22g25vl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2715';
20241016@175749.9935 mhi5dk6uh6u64vrn3mb22g25vl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2715';
20241016@175749.9986 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175749.9989 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175750.6100 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.6400 mhi5dk6uh6u64vrn3mb22g25vl Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175750.1260 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241016@175750.2430 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406751 and bi.ref ='324.5365.00.1' and bi.lordem =1
20241016@175750.5550 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241016@175750.5770 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406751 and bi.ref ='324.5365.00.1' and bi.lordem =1
20241016@175750.5940 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20241016@175750.6130 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406751 and bi.ref ='324.5365.00.1' and bi.lordem =1
20241016@175750.6290 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.6320 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241016@175750.6640 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.6670 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 1 valor from td where td.ndoc = 39
20241016@175750.6980 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.7010 mhi5dk6uh6u64vrn3mb22g25vl 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')
20241016@175750.7280 mhi5dk6uh6u64vrn3mb22g25vl 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
20241016@175750.7640 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.7670 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241016@175750.7980 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.8010 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241016@175750.8310 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.8330 mhi5dk6uh6u64vrn3mb22g25vl Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241016@175750.8960 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.8990 mhi5dk6uh6u64vrn3mb22g25vl Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241016@175750.9450 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.9480 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from td where ndoc = 39
20241016@175750.9600 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241016@175750.9740 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.9900 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175750.1007 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.1150 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175750.1182 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.1197 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175750.1209 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175750.1272 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175750.1285 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.1325 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175750.1340 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670ff31424670ff08e1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241016@175750.1493 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.1511 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175750.1543 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175750.1554 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175750.1566 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175750.1577 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175750.1588 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175750.1599 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175750.1610 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff31424670ff08e1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175750.1812 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175750.1858 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.1873 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175750.1896 mhi5dk6uh6u64vrn3mb22g25vl Query : select 'normal' from dummy
20241016@175750.1911 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff31424670ff08e1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1317,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175750.2156 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.2159 mhi5dk6uh6u64vrn3mb22g25vl Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241016@175750.2181 mhi5dk6uh6u64vrn3mb22g25vl 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.5365.00.1'
20241016@175750.2290 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2305 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.2329 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2344 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.2378 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175750.2389 mhi5dk6uh6u64vrn3mb22g25vl Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241016@175750.2402 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2483 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.2496 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff21634670ff08e3a','aut670ff31424670ff08e1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175750.2500 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2517 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.2545 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff21634670ff08e3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',36.000 ,'aut670ff31424670ff08e1d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241016@175750.2771 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2813 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.2841 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2856 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.2864 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175750.2877 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2891 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.2902 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff76247670ff08e46','aut670ff31424670ff08e1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175750.2906 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.2920 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.2951 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670ff76247670ff08e46',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670ff31424670ff08e1d' ,0,0 ,2,23.00,20000,?,?,?)
20241016@175750.3160 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.3163 mhi5dk6uh6u64vrn3mb22g25vl Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241016@175750.3183 mhi5dk6uh6u64vrn3mb22g25vl 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.5365.00.1'
20241016@175750.3234 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3250 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.3275 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3291 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.3299 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175750.3311 mhi5dk6uh6u64vrn3mb22g25vl Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241016@175750.3323 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3337 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.3348 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff35023670ff08e51','aut670ff31424670ff08e1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175750.3352 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3366 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.3394 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff35023670ff08e51',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut670ff31424670ff08e1d' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241016@175750.3636 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3651 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.3677 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3691 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.3700 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175750.3712 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3726 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.3738 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff60313670ff08e5a','aut670ff31424670ff08e1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175750.3741 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.3755 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.3783 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670ff60313670ff08e5a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670ff31424670ff08e1d' ,0,0 ,2,23.00,50000,?,?,?)
20241016@175750.4009 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.4012 mhi5dk6uh6u64vrn3mb22g25vl Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20241016@175750.4030 mhi5dk6uh6u64vrn3mb22g25vl 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.5365.00.1'
20241016@175750.4045 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4060 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.4087 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4101 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.4110 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175750.4121 mhi5dk6uh6u64vrn3mb22g25vl Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20241016@175750.4133 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4146 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.4158 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff68360670ff08e64','aut670ff31424670ff08e1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175750.4162 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4178 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.4232 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff68360670ff08e64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',144.000 ,'aut670ff31424670ff08e1d' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241016@175750.4459 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4473 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.4499 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4513 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.4521 mhi5dk6uh6u64vrn3mb22g25vl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175750.4533 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4573 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.4585 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff67545670ff08e6e','aut670ff31424670ff08e1d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175750.4589 mhi5dk6uh6u64vrn3mb22g25vl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.4603 mhi5dk6uh6u64vrn3mb22g25vl Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.4631 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670ff67545670ff08e6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670ff31424670ff08e1d' ,0,0 ,2,23.00,80000,?,?,?)
20241016@175750.4846 mhi5dk6uh6u64vrn3mb22g25vl Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670ff31424670ff08e1d','2406751','wait',39,'adm09112754980.682000002')
20241016@175750.4916 mhi5dk6uh6u64vrn3mb22g25vl Query : use flama_phc
20241016@175750.4919 mhi5dk6uh6u64vrn3mb22g25vl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241016@175750.4949 mhi5dk6uh6u64vrn3mb22g25vl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2715';
20241016@175750.4980 mhi5dk6uh6u64vrn3mb22g25vl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2715';
20241016@175750.5024 mhi5dk6uh6u64vrn3mb22g25vl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2715';
20241016@175750.5078 mhi5dk6uh6u64vrn3mb22g25vl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2715';
20241016@175750.5602 6uvlflpcumv2ah4kvrvirhe1fm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175750.5614 6uvlflpcumv2ah4kvrvirhe1fm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175750.5672 6uvlflpcumv2ah4kvrvirhe1fm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2716';
20241016@175750.5726 6uvlflpcumv2ah4kvrvirhe1fm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2716';
20241016@175750.5799 6uvlflpcumv2ah4kvrvirhe1fm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2716';
20241016@175750.5828 6uvlflpcumv2ah4kvrvirhe1fm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2716';
20241016@175750.5878 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.5881 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175750.5943 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.5945 6uvlflpcumv2ah4kvrvirhe1fm Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175750.6007 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '326.595.00.01'
20241016@175750.6124 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406754 and bi.ref ='326.595.00.01' and bi.lordem =1
20241016@175750.6411 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6416 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241016@175750.6449 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6452 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 1 valor from td where td.ndoc = 39
20241016@175750.6505 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6508 6uvlflpcumv2ah4kvrvirhe1fm 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')
20241016@175750.6536 6uvlflpcumv2ah4kvrvirhe1fm 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
20241016@175750.6572 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6575 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241016@175750.6609 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6612 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241016@175750.6658 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6661 6uvlflpcumv2ah4kvrvirhe1fm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241016@175750.6699 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6702 6uvlflpcumv2ah4kvrvirhe1fm Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241016@175750.6750 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.6752 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from td where ndoc = 39
20241016@175750.6767 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241016@175750.6781 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.6798 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175750.6833 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.6848 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175750.6876 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.6890 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175750.6902 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175750.6966 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175750.6979 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.6995 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175750.8080 6uvlflpcumv2ah4kvrvirhe1fm Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670ff92609670ff08ea8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241016@175750.8246 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.8263 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175750.8323 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175750.8336 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175750.8347 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175750.8358 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175750.8370 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175750.8382 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175750.8393 6uvlflpcumv2ah4kvrvirhe1fm Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff92609670ff08ea8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175750.8619 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175750.8643 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.8660 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175750.8683 6uvlflpcumv2ah4kvrvirhe1fm Query : select 'normal' from dummy
20241016@175750.8700 6uvlflpcumv2ah4kvrvirhe1fm Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff92609670ff08ea8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1318,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175750.8945 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.8948 6uvlflpcumv2ah4kvrvirhe1fm Query : select st.usalote valor from st where st.ref = '326.595.00.01'
20241016@175750.8970 6uvlflpcumv2ah4kvrvirhe1fm 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 = '326.595.00.01'
20241016@175750.9166 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.9185 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.9210 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.9225 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.9233 6uvlflpcumv2ah4kvrvirhe1fm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175750.9245 6uvlflpcumv2ah4kvrvirhe1fm Query : select sestamp valor from se where ref ='326.595.00.01' and lote = 'r2400411200a'
20241016@175750.9265 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.9279 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175750.9290 6uvlflpcumv2ah4kvrvirhe1fm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff04212670ff08ee2','aut670ff92609670ff08ea8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175750.9294 6uvlflpcumv2ah4kvrvirhe1fm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175750.9308 6uvlflpcumv2ah4kvrvirhe1fm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175750.9374 6uvlflpcumv2ah4kvrvirhe1fm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670ff04212670ff08ee2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut670ff92609670ff08ea8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241016@175750.9651 6uvlflpcumv2ah4kvrvirhe1fm Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670ff92609670ff08ea8','2406754','wait',39,'adm09112754980.682000002')
20241016@175750.9727 6uvlflpcumv2ah4kvrvirhe1fm Query : use flama_phc
20241016@175750.9731 6uvlflpcumv2ah4kvrvirhe1fm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241016@175750.9761 6uvlflpcumv2ah4kvrvirhe1fm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2716';
20241016@175750.9795 6uvlflpcumv2ah4kvrvirhe1fm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2716';
20241016@175750.9840 6uvlflpcumv2ah4kvrvirhe1fm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2716';
20241016@175750.9868 6uvlflpcumv2ah4kvrvirhe1fm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2716';
20241016@175751.4390 kvka128i1due7uhv66kfckus41 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175751.4490 kvka128i1due7uhv66kfckus41 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175751.5100 kvka128i1due7uhv66kfckus41 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2717';
20241016@175751.5630 kvka128i1due7uhv66kfckus41 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2717';
20241016@175751.6170 kvka128i1due7uhv66kfckus41 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2717';
20241016@175751.6460 kvka128i1due7uhv66kfckus41 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2717';
20241016@175751.7000 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.7030 kvka128i1due7uhv66kfckus41 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175751.7690 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.7720 kvka128i1due7uhv66kfckus41 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175751.8120 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.9570 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1362 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1383 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1401 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1419 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1435 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1477 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1493 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1513 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1530 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1548 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1566 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1585 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1600 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1618 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1634 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1651 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1669 kvka128i1due7uhv66kfckus41 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241016@175751.1690 kvka128i1due7uhv66kfckus41 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406774 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241016@175751.1706 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.1710 kvka128i1due7uhv66kfckus41 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241016@175751.1741 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.1744 kvka128i1due7uhv66kfckus41 Query : select top 1 1 valor from td where td.ndoc = 39
20241016@175751.1776 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.1778 kvka128i1due7uhv66kfckus41 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')
20241016@175751.1807 kvka128i1due7uhv66kfckus41 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
20241016@175751.1840 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.1843 kvka128i1due7uhv66kfckus41 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241016@175751.1899 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.1902 kvka128i1due7uhv66kfckus41 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241016@175751.2097 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.2107 kvka128i1due7uhv66kfckus41 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241016@175751.2227 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.2254 kvka128i1due7uhv66kfckus41 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241016@175751.2301 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.2303 kvka128i1due7uhv66kfckus41 Query : select 1 valor from td where ndoc = 39
20241016@175751.2316 kvka128i1due7uhv66kfckus41 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241016@175751.2330 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.2348 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175751.2367 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.2382 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175751.2408 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.2422 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175751.2435 kvka128i1due7uhv66kfckus41 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175751.2526 kvka128i1due7uhv66kfckus41 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241016@175751.2538 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.2553 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241016@175751.2569 kvka128i1due7uhv66kfckus41 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670ff19863670ff08f3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241016@175751.2716 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.2734 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241016@175751.2766 kvka128i1due7uhv66kfckus41 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241016@175751.2778 kvka128i1due7uhv66kfckus41 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241016@175751.2790 kvka128i1due7uhv66kfckus41 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241016@175751.2802 kvka128i1due7uhv66kfckus41 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241016@175751.2814 kvka128i1due7uhv66kfckus41 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241016@175751.2826 kvka128i1due7uhv66kfckus41 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241016@175751.2837 kvka128i1due7uhv66kfckus41 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670ff19863670ff08f3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241016@175751.3040 kvka128i1due7uhv66kfckus41 Query : select top 1 fno valor from wsftdata order by fno desc
20241016@175751.3061 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.3077 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241016@175751.3098 kvka128i1due7uhv66kfckus41 Query : select 'normal' from dummy
20241016@175751.3138 kvka128i1due7uhv66kfckus41 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670ff19863670ff08f3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1319,100810,0,'2024-10-16',39,'euro',0,0,2024 ,?,?)
20241016@175751.3376 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.3380 kvka128i1due7uhv66kfckus41 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241016@175751.3402 kvka128i1due7uhv66kfckus41 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.1879.00.1'
20241016@175751.3516 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.3532 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241016@175751.3558 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.3573 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175751.3583 kvka128i1due7uhv66kfckus41 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241016@175751.3596 kvka128i1due7uhv66kfckus41 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301097100b'
20241016@175751.3607 kvka128i1due7uhv66kfckus41 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241016@175751.3647 kvka128i1due7uhv66kfckus41 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241016@175751.3659 kvka128i1due7uhv66kfckus41 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670ff26577670ff08f58','aut670ff19863670ff08f3b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241016@175751.3677 kvka128i1due7uhv66kfckus41 Query : use flama_phc
20241016@175751.3680 kvka128i1due7uhv66kfckus41 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241016@175751.3712 kvka128i1due7uhv66kfckus41 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2717';
20241016@175751.3743 kvka128i1due7uhv66kfckus41 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2717';
20241016@175751.5114 6l46lmjgbq0oblitqob06ot085 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241016@175751.5125 6l46lmjgbq0oblitqob06ot085 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241016@175751.5184 6l46lmjgbq0oblitqob06ot085 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2718';
20241016@175751.5238 6l46lmjgbq0oblitqob06ot085 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2718';
20241016@175751.5294 6l46lmjgbq0oblitqob06ot085 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2718';
20241016@175751.5318 6l46lmjgbq0oblitqob06ot085 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2718';
20241016@175751.5383 6l46lmjgbq0oblitqob06ot085 Query : use flama_phc
20241016@175751.5386 6l46lmjgbq0oblitqob06ot085 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241016@175751.5449 6l46lmjgbq0oblitqob06ot085 Query : use flama_phc
20241016@175751.5452 6l46lmjgbq0oblitqob06ot085 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241016@175751.5494 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.5608 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.5892 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.5911 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.5927 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.5946 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.5961 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.5979 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.5995 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.6014 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.6029 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.6049 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.6065 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.6084 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.6101 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
20241016@175751.6123 6l46lmjgbq0oblitqob06ot085 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406775 and bi.ref ='324.1847.00.1' and bi.lordem =1
20241016@175751.6139 6l46lmjgbq0oblitqob06ot085 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1847.00.1'
