20240403@183742.2080 4vhri1t179h5vvonksc1raf5pu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183742.2130 4vhri1t179h5vvonksc1raf5pu Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240350'
20240403@183742.2300 4vhri1t179h5vvonksc1raf5pu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183742.2430 4vhri1t179h5vvonksc1raf5pu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.2550 4vhri1t179h5vvonksc1raf5pu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183742.2800 4vhri1t179h5vvonksc1raf5pu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d991864660d93e605',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660d910163660d93e5db' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183742.5330 4vhri1t179h5vvonksc1raf5pu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.5520 4vhri1t179h5vvonksc1raf5pu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183742.5570 4vhri1t179h5vvonksc1raf5pu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d991864660d93e605','aut660d910163660d93e5db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183742.5610 4vhri1t179h5vvonksc1raf5pu Query : use flama_phc
20240403@183742.5650 4vhri1t179h5vvonksc1raf5pu Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240403@183742.5780 4vhri1t179h5vvonksc1raf5pu Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240403@183742.7300 4vhri1t179h5vvonksc1raf5pu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.7450 4vhri1t179h5vvonksc1raf5pu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183742.7720 4vhri1t179h5vvonksc1raf5pu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.7890 4vhri1t179h5vvonksc1raf5pu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183742.7940 4vhri1t179h5vvonksc1raf5pu Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240403@183742.8060 4vhri1t179h5vvonksc1raf5pu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183742.8220 4vhri1t179h5vvonksc1raf5pu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.8360 4vhri1t179h5vvonksc1raf5pu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183742.8610 4vhri1t179h5vvonksc1raf5pu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d938201660d93e614',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660d910163660d93e5db' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@183742.1114 4vhri1t179h5vvonksc1raf5pu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.1130 4vhri1t179h5vvonksc1raf5pu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183742.1135 4vhri1t179h5vvonksc1raf5pu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d938201660d93e614','aut660d910163660d93e5db' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183742.1139 4vhri1t179h5vvonksc1raf5pu Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d910163660d93e5db','2402497','wait',39,'ari17112337378,753000005')
20240403@183742.1156 4vhri1t179h5vvonksc1raf5pu Query : use flama_phc
20240403@183742.1159 4vhri1t179h5vvonksc1raf5pu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183742.1171 4vhri1t179h5vvonksc1raf5pu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='942';
20240403@183742.1189 4vhri1t179h5vvonksc1raf5pu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='942';
20240403@183742.1210 4vhri1t179h5vvonksc1raf5pu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='942';
20240403@183742.1225 4vhri1t179h5vvonksc1raf5pu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='942';
20240403@183742.1638 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183742.1652 2qmu6gjfmqppko2a0l3qj2pjjm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183742.1679 2qmu6gjfmqppko2a0l3qj2pjjm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='943';
20240403@183742.1722 2qmu6gjfmqppko2a0l3qj2pjjm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='943';
20240403@183742.1738 2qmu6gjfmqppko2a0l3qj2pjjm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='943';
20240403@183742.1752 2qmu6gjfmqppko2a0l3qj2pjjm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='943';
20240403@183742.1766 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.1769 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183742.1782 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.1786 2qmu6gjfmqppko2a0l3qj2pjjm Query : select no, estab,szadrsdesc from szadrs where u_coddest=4781
20240403@183742.1867 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240403@183742.1881 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402498 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240403@183742.2442 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240403@183742.2459 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402498 and bi.ref ='324.4970.00.1' and bi.lordem =2
20240403@183742.2999 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1470.00.1'
20240403@183742.3160 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402498 and bi.ref ='324.1470.00.1' and bi.lordem =3
20240403@183742.3500 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.3504 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183742.3517 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.3519 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183742.3529 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.3532 2qmu6gjfmqppko2a0l3qj2pjjm Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183742.3546 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183742.3908 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.3912 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 ~inactivo valor from cl where no = '102040' and estab = 0 order by inactivo desc
20240403@183742.4079 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.4082 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183742.4093 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.4097 2qmu6gjfmqppko2a0l3qj2pjjm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183742.4108 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.4110 2qmu6gjfmqppko2a0l3qj2pjjm Query : select szadrsstamp valor from szadrs where szadrsdesc='102040 - media markt gaia-prod.inf.e electrÓnicos,lda.'
20240403@183742.4127 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.4130 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from td where ndoc = 39
20240403@183742.4141 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183742.4152 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183742.4166 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@183742.4184 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183742.4197 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@183742.4224 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183742.4237 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@183742.4247 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183742.4338 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183742.4349 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183742.4364 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@183742.4374 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660d953062660d93e667' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@183742.4553 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183742.4567 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@183742.4596 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@183742.4601 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@183742.4606 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@183742.4610 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@183742.4615 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@183742.4619 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@183742.4624 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660d953062660d93e667',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@183742.4951 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 fno valor from wsft039data order by fno desc
20240403@183742.4970 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183742.4985 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@183742.5004 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut660d953062660d93e667',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',722,102040,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','1907',?,?,?,?)
20240403@183742.5312 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.5316 2qmu6gjfmqppko2a0l3qj2pjjm Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240403@183742.5328 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240403@183742.5341 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.5356 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183742.5382 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.5396 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183742.5401 2qmu6gjfmqppko2a0l3qj2pjjm Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240350'
20240403@183742.5413 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183742.5424 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.5436 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183742.5465 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d975769660d93e684',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660d953062660d93e667' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183742.5728 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.5746 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183742.5750 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d975769660d93e684','aut660d953062660d93e667' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183742.5755 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.5760 2qmu6gjfmqppko2a0l3qj2pjjm Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240403@183742.5784 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240403@183742.5796 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.5810 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183742.5841 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.5857 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183742.5862 2qmu6gjfmqppko2a0l3qj2pjjm Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240403@183742.5872 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183742.5883 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.5897 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183742.5921 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d941029660d93e68f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660d953062660d93e667' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@183742.6184 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.6201 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183742.6206 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d941029660d93e68f','aut660d953062660d93e667' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183742.6211 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.6214 2qmu6gjfmqppko2a0l3qj2pjjm Query : select st.usalote valor from st where st.ref = '324.1470.00.1'
20240403@183742.6226 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1470.00.1'
20240403@183742.6375 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.6389 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183742.6415 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.6429 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183742.6433 2qmu6gjfmqppko2a0l3qj2pjjm Query : select sestamp valor from se where ref ='324.1470.00.1' and lote = 'r2100312200a'
20240403@183742.6452 2qmu6gjfmqppko2a0l3qj2pjjm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183742.6462 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183742.6475 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183742.6503 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d962943660d93e69d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660d953062660d93e667' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240403@183742.6761 2qmu6gjfmqppko2a0l3qj2pjjm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183742.6777 2qmu6gjfmqppko2a0l3qj2pjjm Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183742.6781 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d962943660d93e69d','aut660d953062660d93e667' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183742.6785 2qmu6gjfmqppko2a0l3qj2pjjm Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d953062660d93e667','2402498','wait',39,'ari17112337378,753000005')
20240403@183742.6804 2qmu6gjfmqppko2a0l3qj2pjjm Query : use flama_phc
20240403@183742.6807 2qmu6gjfmqppko2a0l3qj2pjjm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183742.6821 2qmu6gjfmqppko2a0l3qj2pjjm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='943';
20240403@183742.6838 2qmu6gjfmqppko2a0l3qj2pjjm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='943';
20240403@183742.6855 2qmu6gjfmqppko2a0l3qj2pjjm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='943';
20240403@183742.6870 2qmu6gjfmqppko2a0l3qj2pjjm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='943';
20240403@183742.7248 rohauqd1ie1jelqcimr18d1sek Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183742.7261 rohauqd1ie1jelqcimr18d1sek Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183742.7284 rohauqd1ie1jelqcimr18d1sek Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='944';
20240403@183742.7329 rohauqd1ie1jelqcimr18d1sek Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='944';
20240403@183742.7345 rohauqd1ie1jelqcimr18d1sek Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='944';
20240403@183742.7360 rohauqd1ie1jelqcimr18d1sek Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='944';
20240403@183742.7378 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.7381 rohauqd1ie1jelqcimr18d1sek Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183742.7394 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.7397 rohauqd1ie1jelqcimr18d1sek Query : select no, estab,szadrsdesc from szadrs where u_coddest=4783
20240403@183742.7477 rohauqd1ie1jelqcimr18d1sek Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.499.00.01'
20240403@183742.7628 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402499 and bi.ref ='324.499.00.01' and bi.lordem =1
20240403@183742.7980 rohauqd1ie1jelqcimr18d1sek Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240403@183742.7992 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402499 and bi.ref ='304.4320.00.1' and bi.lordem =2
20240403@183742.8319 rohauqd1ie1jelqcimr18d1sek Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240403@183742.8330 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402499 and bi.ref ='324.4970.00.1' and bi.lordem =3
20240403@183742.8671 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8675 rohauqd1ie1jelqcimr18d1sek Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183742.8688 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8692 rohauqd1ie1jelqcimr18d1sek Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183742.8702 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8705 rohauqd1ie1jelqcimr18d1sek Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183742.8715 rohauqd1ie1jelqcimr18d1sek Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183742.8729 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8732 rohauqd1ie1jelqcimr18d1sek Query : select top 1 ~inactivo valor from cl where no = '102011' and estab = 0 order by inactivo desc
20240403@183742.8835 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8839 rohauqd1ie1jelqcimr18d1sek Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183742.8850 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8853 rohauqd1ie1jelqcimr18d1sek Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183742.8864 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8866 rohauqd1ie1jelqcimr18d1sek Query : select szadrsstamp valor from szadrs where szadrsdesc='102011 - media markt alfragide, lda.'
20240403@183742.8879 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183742.8882 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from td where ndoc = 39
20240403@183742.8969 rohauqd1ie1jelqcimr18d1sek Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183742.8981 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183742.9269 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@183742.9403 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183742.9417 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@183742.9778 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183742.9811 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@183742.9822 rohauqd1ie1jelqcimr18d1sek Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183742.9922 rohauqd1ie1jelqcimr18d1sek Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183742.9933 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183742.9948 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@183742.9959 rohauqd1ie1jelqcimr18d1sek Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660d968622660d93e6ef' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@183743.2300 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183743.4560 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@183743.4840 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@183743.4890 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@183743.5190 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@183743.5230 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@183743.5280 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@183743.5320 rohauqd1ie1jelqcimr18d1sek Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@183743.5360 rohauqd1ie1jelqcimr18d1sek Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660d968622660d93e6ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@183743.8060 rohauqd1ie1jelqcimr18d1sek Query : select top 1 fno valor from wsft039data order by fno desc
20240403@183743.8220 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183743.8370 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@183743.8530 rohauqd1ie1jelqcimr18d1sek Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut660d968622660d93e6ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',723,102011,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','1907',?,?,?,?)
20240403@183743.1139 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183743.1144 rohauqd1ie1jelqcimr18d1sek Query : select st.usalote valor from st where st.ref = '324.499.00.01'
20240403@183743.1157 rohauqd1ie1jelqcimr18d1sek Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.499.00.01'
20240403@183743.1310 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.1324 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183743.1348 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.1363 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183743.1367 rohauqd1ie1jelqcimr18d1sek Query : select sestamp valor from se where ref ='324.499.00.01' and lote = 'r2100869200a'
20240403@183743.1384 rohauqd1ie1jelqcimr18d1sek Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183743.1394 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.1407 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183743.1433 rohauqd1ie1jelqcimr18d1sek Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d942165660d93e722',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660d968622660d93e6ef' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183743.1892 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.2686 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183743.2692 rohauqd1ie1jelqcimr18d1sek Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d942165660d93e722','aut660d968622660d93e6ef' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183743.2698 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183743.2701 rohauqd1ie1jelqcimr18d1sek Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240403@183743.2713 rohauqd1ie1jelqcimr18d1sek Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240403@183743.2724 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.2739 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183743.2761 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.2773 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183743.2777 rohauqd1ie1jelqcimr18d1sek Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240350'
20240403@183743.2787 rohauqd1ie1jelqcimr18d1sek Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183743.2796 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.2811 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183743.2835 rohauqd1ie1jelqcimr18d1sek Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d989271660d93e744',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660d968622660d93e6ef' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@183743.3109 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.3124 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183743.3128 rohauqd1ie1jelqcimr18d1sek Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d989271660d93e744','aut660d968622660d93e6ef' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183743.3132 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183743.3135 rohauqd1ie1jelqcimr18d1sek Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240403@183743.3146 rohauqd1ie1jelqcimr18d1sek Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240403@183743.3157 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.3169 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183743.3191 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.3203 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183743.3207 rohauqd1ie1jelqcimr18d1sek Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240403@183743.3217 rohauqd1ie1jelqcimr18d1sek Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183743.3225 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.3237 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183743.3266 rohauqd1ie1jelqcimr18d1sek Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d940585660d93e74e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660d968622660d93e6ef' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240403@183743.3520 rohauqd1ie1jelqcimr18d1sek Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.3535 rohauqd1ie1jelqcimr18d1sek Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183743.3542 rohauqd1ie1jelqcimr18d1sek Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d940585660d93e74e','aut660d968622660d93e6ef' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183743.3546 rohauqd1ie1jelqcimr18d1sek Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d968622660d93e6ef','2402499','wait',39,'ari17112337378,753000005')
20240403@183743.3564 rohauqd1ie1jelqcimr18d1sek Query : use flama_phc
20240403@183743.3567 rohauqd1ie1jelqcimr18d1sek Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183743.3579 rohauqd1ie1jelqcimr18d1sek Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='944';
20240403@183743.3597 rohauqd1ie1jelqcimr18d1sek Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='944';
20240403@183743.3611 rohauqd1ie1jelqcimr18d1sek Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='944';
20240403@183743.3623 rohauqd1ie1jelqcimr18d1sek Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='944';
20240403@183743.4027 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183743.4040 38vgt2go2mjqn6qkbpdhrkkdja Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183743.4062 38vgt2go2mjqn6qkbpdhrkkdja Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='945';
20240403@183743.4104 38vgt2go2mjqn6qkbpdhrkkdja Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='945';
20240403@183743.4121 38vgt2go2mjqn6qkbpdhrkkdja Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='945';
20240403@183743.4133 38vgt2go2mjqn6qkbpdhrkkdja Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='945';
20240403@183743.4149 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4152 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183743.4165 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4168 38vgt2go2mjqn6qkbpdhrkkdja Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240403@183743.4254 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9006.00.1'
20240403@183743.4408 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402500 and bi.ref ='328.9006.00.1' and bi.lordem =1
20240403@183743.4742 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4746 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183743.4759 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4762 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183743.4772 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4774 38vgt2go2mjqn6qkbpdhrkkdja Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183743.4784 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183743.4799 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4802 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240403@183743.4912 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4915 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183743.4925 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4928 38vgt2go2mjqn6qkbpdhrkkdja Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183743.4940 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4943 38vgt2go2mjqn6qkbpdhrkkdja Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20240403@183743.4956 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.4959 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from td where ndoc = 39
20240403@183743.4968 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183743.4979 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183743.4999 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@183743.5017 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183743.5029 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@183743.5056 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183743.5069 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@183743.5079 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183743.5204 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183743.5214 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183743.5227 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@183743.5240 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660d980258660d93e77b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@183743.5423 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183743.5438 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@183743.5465 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@183743.5470 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@183743.5475 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@183743.5480 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@183743.5484 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@183743.5489 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@183743.5493 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660d980258660d93e77b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@183743.5757 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 fno valor from wsft039data order by fno desc
20240403@183743.5773 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183743.5789 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@183743.5808 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut660d980258660d93e77b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',724,100810,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','1907',?,?,?,?)
20240403@183743.6114 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.6118 38vgt2go2mjqn6qkbpdhrkkdja Query : select st.usalote valor from st where st.ref = '328.9006.00.1'
20240403@183743.6131 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9006.00.1'
20240403@183743.6283 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.6298 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183743.6325 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.6339 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183743.6343 38vgt2go2mjqn6qkbpdhrkkdja Query : select sestamp valor from se where ref ='328.9006.00.1' and lote = 'r2300691200a'
20240403@183743.6354 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183743.6364 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.6377 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183743.6401 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d907951660d93e79b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660d980258660d93e77b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183743.6679 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.6694 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183743.6700 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d907951660d93e79b','aut660d980258660d93e77b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183743.6705 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.6718 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183743.6744 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.6758 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183743.6764 38vgt2go2mjqn6qkbpdhrkkdja Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183743.6774 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183743.6834 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183743.6861 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut660d939900660d93e7a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut660d980258660d93e77b' ,0,0 ,2,23.00,20000,?,?,?)
20240403@183743.7203 38vgt2go2mjqn6qkbpdhrkkdja Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183743.7220 38vgt2go2mjqn6qkbpdhrkkdja Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183743.7224 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d939900660d93e7a5','aut660d980258660d93e77b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183743.7228 38vgt2go2mjqn6qkbpdhrkkdja Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d980258660d93e77b','2402500','wait',39,'ari17112337378,753000005')
20240403@183743.7244 38vgt2go2mjqn6qkbpdhrkkdja Query : use flama_phc
20240403@183743.7285 38vgt2go2mjqn6qkbpdhrkkdja Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183743.7306 38vgt2go2mjqn6qkbpdhrkkdja Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='945';
20240403@183743.7323 38vgt2go2mjqn6qkbpdhrkkdja Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='945';
20240403@183743.7338 38vgt2go2mjqn6qkbpdhrkkdja Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='945';
20240403@183743.7354 38vgt2go2mjqn6qkbpdhrkkdja Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='945';
20240403@183743.7773 4uj632875h42n354fj8bgkt42g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183743.7788 4uj632875h42n354fj8bgkt42g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183743.7809 4uj632875h42n354fj8bgkt42g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='946';
20240403@183743.7864 4uj632875h42n354fj8bgkt42g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='946';
20240403@183743.7884 4uj632875h42n354fj8bgkt42g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='946';
20240403@183743.7904 4uj632875h42n354fj8bgkt42g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='946';
20240403@183743.7920 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.7925 4uj632875h42n354fj8bgkt42g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183743.7940 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.7945 4uj632875h42n354fj8bgkt42g Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240403@183743.8083 4uj632875h42n354fj8bgkt42g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1578.00.1'
20240403@183743.8267 4uj632875h42n354fj8bgkt42g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402501 and bi.ref ='324.1578.00.1' and bi.lordem =1
20240403@183743.8611 4uj632875h42n354fj8bgkt42g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20240403@183743.8763 4uj632875h42n354fj8bgkt42g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402501 and bi.ref ='324.1643.00.1' and bi.lordem =2
20240403@183743.9110 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9114 4uj632875h42n354fj8bgkt42g Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183743.9126 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9130 4uj632875h42n354fj8bgkt42g Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183743.9140 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9142 4uj632875h42n354fj8bgkt42g Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183743.9153 4uj632875h42n354fj8bgkt42g Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183743.9170 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9173 4uj632875h42n354fj8bgkt42g Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240403@183743.9182 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9186 4uj632875h42n354fj8bgkt42g Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183743.9198 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9201 4uj632875h42n354fj8bgkt42g Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183743.9211 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9214 4uj632875h42n354fj8bgkt42g Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240403@183743.9234 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183743.9237 4uj632875h42n354fj8bgkt42g Query : select 1 valor from td where ndoc = 39
20240403@183743.9247 4uj632875h42n354fj8bgkt42g Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183743.9258 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183743.9272 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@183743.9289 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183743.9302 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@183743.9328 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183743.9341 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@183743.9351 4uj632875h42n354fj8bgkt42g Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183743.9448 4uj632875h42n354fj8bgkt42g Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183743.9458 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183743.9474 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@183743.9485 4uj632875h42n354fj8bgkt42g Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660d925475660d93e7e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@183743.9666 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183743.9681 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@183743.9709 4uj632875h42n354fj8bgkt42g Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@183743.9714 4uj632875h42n354fj8bgkt42g Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@183743.9719 4uj632875h42n354fj8bgkt42g Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@183743.9724 4uj632875h42n354fj8bgkt42g Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@183743.9729 4uj632875h42n354fj8bgkt42g Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@183743.9733 4uj632875h42n354fj8bgkt42g Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@183743.9738 4uj632875h42n354fj8bgkt42g Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660d925475660d93e7e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@183743.9998 4uj632875h42n354fj8bgkt42g Query : select top 1 fno valor from wsft039data order by fno desc
20240403@183744.1500 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183744.3000 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@183744.4900 4uj632875h42n354fj8bgkt42g Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut660d925475660d93e7e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',725,100810,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','1907',?,?,?,?)
20240403@183744.3560 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183744.3610 4uj632875h42n354fj8bgkt42g Query : select st.usalote valor from st where st.ref = '324.1578.00.1'
20240403@183744.3730 4uj632875h42n354fj8bgkt42g Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1578.00.1'
20240403@183744.5300 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.5440 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183744.5680 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.5800 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183744.5840 4uj632875h42n354fj8bgkt42g Query : select sestamp valor from se where ref ='324.1578.00.1' and lote = 'r2100121100a'
20240403@183744.6190 4uj632875h42n354fj8bgkt42g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183744.6290 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.6420 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183744.6640 4uj632875h42n354fj8bgkt42g Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d933657660d93e80f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660d925475660d93e7e4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183744.9240 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.9400 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183744.9450 4uj632875h42n354fj8bgkt42g Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d933657660d93e80f','aut660d925475660d93e7e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183744.9500 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183744.9530 4uj632875h42n354fj8bgkt42g Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240403@183744.9640 4uj632875h42n354fj8bgkt42g Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20240403@183744.1119 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.1132 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183744.1158 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.1171 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183744.1176 4uj632875h42n354fj8bgkt42g Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240403@183744.1199 4uj632875h42n354fj8bgkt42g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183744.1209 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.1221 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183744.1245 4uj632875h42n354fj8bgkt42g Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d967379660d93e81d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660d925475660d93e7e4' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@183744.1513 4uj632875h42n354fj8bgkt42g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.1528 4uj632875h42n354fj8bgkt42g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183744.1532 4uj632875h42n354fj8bgkt42g Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d967379660d93e81d','aut660d925475660d93e7e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183744.1536 4uj632875h42n354fj8bgkt42g Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d925475660d93e7e4','2402501','wait',39,'ari17112337378,753000005')
20240403@183744.1553 4uj632875h42n354fj8bgkt42g Query : use flama_phc
20240403@183744.1555 4uj632875h42n354fj8bgkt42g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183744.1567 4uj632875h42n354fj8bgkt42g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='946';
20240403@183744.1600 4uj632875h42n354fj8bgkt42g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='946';
20240403@183744.1617 4uj632875h42n354fj8bgkt42g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='946';
20240403@183744.1632 4uj632875h42n354fj8bgkt42g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='946';
20240403@183744.2243 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183744.2290 vha29vad2q5l2rbqgj1a0rj3jl Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183744.2378 vha29vad2q5l2rbqgj1a0rj3jl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='947';
20240403@183744.2426 vha29vad2q5l2rbqgj1a0rj3jl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='947';
20240403@183744.2443 vha29vad2q5l2rbqgj1a0rj3jl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='947';
20240403@183744.2459 vha29vad2q5l2rbqgj1a0rj3jl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='947';
20240403@183744.2472 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.2476 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183744.2488 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.2491 vha29vad2q5l2rbqgj1a0rj3jl Query : select no, estab,szadrsdesc from szadrs where u_coddest=4779
20240403@183744.2578 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4901.00.1'
20240403@183744.2731 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402502 and bi.ref ='324.4901.00.1' and bi.lordem =1
20240403@183744.3100 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4901.00.1'
20240403@183744.3112 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402502 and bi.ref ='324.4901.00.1' and bi.lordem =1
20240403@183744.3117 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3121 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183744.3135 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3138 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183744.3148 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3152 vha29vad2q5l2rbqgj1a0rj3jl Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183744.3163 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183744.3178 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3181 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 ~inactivo valor from cl where no = '101900' and estab = 0 order by inactivo desc
20240403@183744.3289 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3293 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183744.3304 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3308 vha29vad2q5l2rbqgj1a0rj3jl Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183744.3321 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3324 vha29vad2q5l2rbqgj1a0rj3jl Query : select szadrsstamp valor from szadrs where szadrsdesc='101900 - pd - alcochete'
20240403@183744.3338 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.3341 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from td where ndoc = 39
20240403@183744.3350 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183744.3361 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183744.3375 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@183744.3390 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183744.3403 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@183744.3428 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183744.3441 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@183744.3450 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183744.3542 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183744.3551 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183744.3565 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@183744.3574 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660d985322660d93e854' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@183744.3757 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183744.3772 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@183744.3800 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@183744.3805 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@183744.3810 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@183744.3815 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@183744.3819 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@183744.3824 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@183744.3828 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660d985322660d93e854',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@183744.4096 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 fno valor from wsft039data order by fno desc
20240403@183744.4113 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183744.4126 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@183744.4145 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut660d985322660d93e854',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',726,101900,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','1907',?,?,?,?)
20240403@183744.4425 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.4428 vha29vad2q5l2rbqgj1a0rj3jl Query : select st.usalote valor from st where st.ref = '324.4901.00.1'
20240403@183744.4442 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4901.00.1'
20240403@183744.4588 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.4602 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183744.4626 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.4638 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183744.4642 vha29vad2q5l2rbqgj1a0rj3jl Query : select sestamp valor from se where ref ='324.4901.00.1' and lote = 'r2200240200a'
20240403@183744.4659 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183744.4668 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.4680 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183744.4704 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d918792660d93e871',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut660d985322660d93e854' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183744.4970 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.4985 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183744.4994 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d918792660d93e871','aut660d985322660d93e854' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183744.4999 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.5012 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183744.5033 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.5045 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183744.5049 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183744.5058 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.5069 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183744.5091 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut660d956736660d93e87b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut660d985322660d93e854' ,0,0 ,2,23.00,20000,?,?,?)
20240403@183744.5350 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.5364 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183744.5368 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d956736660d93e87b','aut660d985322660d93e854' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183744.5373 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.5376 vha29vad2q5l2rbqgj1a0rj3jl Query : select st.usalote valor from st where st.ref = '324.4901.00.1'
20240403@183744.5386 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4901.00.1'
20240403@183744.5397 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.5409 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183744.5432 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.5444 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183744.5448 vha29vad2q5l2rbqgj1a0rj3jl Query : select sestamp valor from se where ref ='324.4901.00.1' and lote = 'r2200240200a'
20240403@183744.5461 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183744.5474 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.5487 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183744.5508 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d924826660d93e885',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',60.000 ,'aut660d985322660d93e854' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240403@183744.5763 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.5777 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183744.5781 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d924826660d93e885','aut660d985322660d93e854' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183744.5786 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.5799 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183744.5821 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.5832 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183744.5837 vha29vad2q5l2rbqgj1a0rj3jl Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183744.5846 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.5860 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183744.5881 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut660d949002660d93e88e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut660d985322660d93e854' ,0,0 ,2,23.00,50000,?,?,?)
20240403@183744.6164 vha29vad2q5l2rbqgj1a0rj3jl Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.6179 vha29vad2q5l2rbqgj1a0rj3jl Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183744.6183 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d949002660d93e88e','aut660d985322660d93e854' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183744.6187 vha29vad2q5l2rbqgj1a0rj3jl Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d985322660d93e854','2402502','wait',39,'ari17112337378,753000005')
20240403@183744.6203 vha29vad2q5l2rbqgj1a0rj3jl Query : use flama_phc
20240403@183744.6206 vha29vad2q5l2rbqgj1a0rj3jl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183744.6217 vha29vad2q5l2rbqgj1a0rj3jl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='947';
20240403@183744.6233 vha29vad2q5l2rbqgj1a0rj3jl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='947';
20240403@183744.6249 vha29vad2q5l2rbqgj1a0rj3jl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='947';
20240403@183744.6263 vha29vad2q5l2rbqgj1a0rj3jl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='947';
20240403@183744.7901 hbbutmun04aalnl0lpqp9t9ntq Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183744.7914 hbbutmun04aalnl0lpqp9t9ntq Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183744.7933 hbbutmun04aalnl0lpqp9t9ntq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='948';
20240403@183744.7978 hbbutmun04aalnl0lpqp9t9ntq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='948';
20240403@183744.7995 hbbutmun04aalnl0lpqp9t9ntq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='948';
20240403@183744.8010 hbbutmun04aalnl0lpqp9t9ntq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='948';
20240403@183744.8024 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8029 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183744.8044 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8048 hbbutmun04aalnl0lpqp9t9ntq Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240403@183744.8119 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9006.00.1'
20240403@183744.8131 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402509 and bi.ref ='328.9006.00.1' and bi.lordem =1
20240403@183744.8467 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8471 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183744.8484 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8487 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183744.8498 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8502 hbbutmun04aalnl0lpqp9t9ntq Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183744.8513 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183744.8526 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8530 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240403@183744.8540 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8543 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183744.8553 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8556 hbbutmun04aalnl0lpqp9t9ntq Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183744.8565 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8569 hbbutmun04aalnl0lpqp9t9ntq Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20240403@183744.8632 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.8635 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from td where ndoc = 39
20240403@183744.8645 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183744.8656 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183744.8669 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@183744.8684 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183744.8696 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@183744.8721 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183744.8734 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@183744.8744 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183744.8840 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183744.8849 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183744.8862 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@183744.8872 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660d926142660d93e8d5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@183744.9053 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183744.9068 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@183744.9097 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@183744.9103 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@183744.9109 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@183744.9113 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@183744.9118 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@183744.9123 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@183744.9127 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660d926142660d93e8d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@183744.9436 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 fno valor from wsft039data order by fno desc
20240403@183744.9455 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183744.9472 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@183744.9489 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut660d926142660d93e8d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',727,100810,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','1907',?,?,?,?)
20240403@183744.9778 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183744.9829 hbbutmun04aalnl0lpqp9t9ntq Query : select st.usalote valor from st where st.ref = '328.9006.00.1'
20240403@183744.9840 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9006.00.1'
20240403@183744.9851 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.9865 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183744.9886 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183744.9899 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183744.9904 hbbutmun04aalnl0lpqp9t9ntq Query : select sestamp valor from se where ref ='328.9006.00.1' and lote = 'r2300691200a'
20240403@183744.9913 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183744.9922 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183744.9934 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183744.9960 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d946155660d93e8f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660d926142660d93e8d5' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183745.2500 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183745.3140 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183745.3200 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d946155660d93e8f2','aut660d926142660d93e8d5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183745.3250 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183745.3380 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183745.3610 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183745.3730 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183745.3770 hbbutmun04aalnl0lpqp9t9ntq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183745.3880 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183745.4020 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183745.4310 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut660d953557660d93e909',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut660d926142660d93e8d5' ,0,0 ,2,23.00,20000,?,?,?)
20240403@183745.6980 hbbutmun04aalnl0lpqp9t9ntq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183745.7600 hbbutmun04aalnl0lpqp9t9ntq Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183745.7650 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d953557660d93e909','aut660d926142660d93e8d5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183745.7700 hbbutmun04aalnl0lpqp9t9ntq Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d926142660d93e8d5','2402509','wait',39,'ari17112337378,753000005')
20240403@183745.7880 hbbutmun04aalnl0lpqp9t9ntq Query : use flama_phc
20240403@183745.7910 hbbutmun04aalnl0lpqp9t9ntq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183745.8030 hbbutmun04aalnl0lpqp9t9ntq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='948';
20240403@183745.8210 hbbutmun04aalnl0lpqp9t9ntq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='948';
20240403@183745.8350 hbbutmun04aalnl0lpqp9t9ntq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='948';
20240403@183745.8510 hbbutmun04aalnl0lpqp9t9ntq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='948';
20240403@183745.1700 vncv0aq7c9nq8m9cgqs56md610 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183745.1716 vncv0aq7c9nq8m9cgqs56md610 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183745.1739 vncv0aq7c9nq8m9cgqs56md610 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='949';
20240403@183745.1782 vncv0aq7c9nq8m9cgqs56md610 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='949';
20240403@183745.1799 vncv0aq7c9nq8m9cgqs56md610 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='949';
20240403@183745.1813 vncv0aq7c9nq8m9cgqs56md610 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='949';
20240403@183745.1828 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.1831 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183745.1848 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.1852 vncv0aq7c9nq8m9cgqs56md610 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240403@183745.1934 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20240403@183745.2095 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402510 and bi.ref ='324.1685.00.1' and bi.lordem =1
20240403@183745.2530 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20240403@183745.2544 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402510 and bi.ref ='324.642.00.01' and bi.lordem =2
20240403@183745.2887 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.2892 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183745.2907 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.2910 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183745.2921 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.2924 vncv0aq7c9nq8m9cgqs56md610 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183745.2935 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183745.2951 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.2954 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240403@183745.2965 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.2968 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183745.2979 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.2982 vncv0aq7c9nq8m9cgqs56md610 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183745.2993 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.2996 vncv0aq7c9nq8m9cgqs56md610 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240403@183745.3009 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.3012 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from td where ndoc = 39
20240403@183745.3022 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183745.3033 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183745.3049 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@183745.3066 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183745.3080 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@183745.3109 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183745.3122 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@183745.3133 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183745.3227 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@183745.3236 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@183745.3249 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@183745.3259 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660d999092660d93e94c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@183745.3459 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@183745.3521 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@183745.3551 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@183745.3556 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@183745.3561 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@183745.3567 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@183745.3572 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@183745.3577 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@183745.3581 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660d999092660d93e94c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@183745.3846 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 fno valor from wsft039data order by fno desc
20240403@183745.3867 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@183745.3880 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@183745.3900 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut660d999092660d93e94c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',728,100810,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','1907',?,?,?,?)
20240403@183745.4197 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.4202 vncv0aq7c9nq8m9cgqs56md610 Query : select st.usalote valor from st where st.ref = '324.1685.00.1'
20240403@183745.4215 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1685.00.1'
20240403@183745.4374 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183745.4390 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183745.4466 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183745.4481 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183745.4485 vncv0aq7c9nq8m9cgqs56md610 Query : select sestamp valor from se where ref ='324.1685.00.1' and lote = 'r2100384300a'
20240403@183745.4497 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183745.4506 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183745.4520 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183745.4545 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d928612660d93e96e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660d999092660d93e94c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@183745.4804 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183745.4819 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183745.4823 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d928612660d93e96e','aut660d999092660d93e94c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183745.4828 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.4831 vncv0aq7c9nq8m9cgqs56md610 Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240403@183745.4845 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.642.00.01'
20240403@183745.4856 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183745.4869 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@183745.4895 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183745.4909 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@183745.4914 vncv0aq7c9nq8m9cgqs56md610 Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240403@183745.4923 vncv0aq7c9nq8m9cgqs56md610 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@183745.4933 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@183745.4946 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@183745.4969 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660d921829660d93e978',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut660d999092660d93e94c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@183745.5284 vncv0aq7c9nq8m9cgqs56md610 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@183745.5300 vncv0aq7c9nq8m9cgqs56md610 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@183745.5306 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660d921829660d93e978','aut660d999092660d93e94c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@183745.5310 vncv0aq7c9nq8m9cgqs56md610 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660d999092660d93e94c','2402510','wait',39,'ari17112337378,753000005')
20240403@183745.5327 vncv0aq7c9nq8m9cgqs56md610 Query : use flama_phc
20240403@183745.5330 vncv0aq7c9nq8m9cgqs56md610 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@183745.5341 vncv0aq7c9nq8m9cgqs56md610 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='949';
20240403@183745.5359 vncv0aq7c9nq8m9cgqs56md610 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='949';
20240403@183745.5373 vncv0aq7c9nq8m9cgqs56md610 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='949';
20240403@183745.5390 vncv0aq7c9nq8m9cgqs56md610 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='949';
20240403@183745.5863 gcgj9o1egpdnpibqprl3uui9fh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@183745.5877 gcgj9o1egpdnpibqprl3uui9fh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@183745.5897 gcgj9o1egpdnpibqprl3uui9fh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='950';
20240403@183745.5940 gcgj9o1egpdnpibqprl3uui9fh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='950';
20240403@183745.5957 gcgj9o1egpdnpibqprl3uui9fh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='950';
20240403@183745.5972 gcgj9o1egpdnpibqprl3uui9fh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='950';
20240403@183745.5987 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.5991 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@183745.6005 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.6008 gcgj9o1egpdnpibqprl3uui9fh Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20240403@183745.6095 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240403@183745.6259 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402511 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240403@183745.6596 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240403@183745.6607 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2025 and bo.obrano = 2402511 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240403@183745.6985 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.6989 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@183745.7002 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.7005 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 1 valor from td where td.ndoc = 39
20240403@183745.7016 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.7019 gcgj9o1egpdnpibqprl3uui9fh Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@183745.7029 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240403@183745.7044 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.7047 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240403@183745.7157 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.7160 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@183745.7170 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.7173 gcgj9o1egpdnpibqprl3uui9fh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@183745.7185 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.7188 gcgj9o1egpdnpibqprl3uui9fh Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - corroios'
20240403@183745.7200 gcgj9o1egpdnpibqprl3uui9fh Query : use flama_phc
20240403@183745.7203 gcgj9o1egpdnpibqprl3uui9fh Query : select 1 valor from td where ndoc = 39
20240403@183745.7212 gcgj9o1egpdnpibqprl3uui9fh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@183745.7223 gcgj9o1egpdnpibqprl3uui9fh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
