20240930@181838.2655 ap2h7cuj1o7em35erakv74g7m9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1803.00.1'
20240930@181838.2671 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.2687 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.2715 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.2730 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.2739 ap2h7cuj1o7em35erakv74g7m9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181838.2751 ap2h7cuj1o7em35erakv74g7m9 Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301274200a'
20240930@181838.2763 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.2779 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.2792 ap2h7cuj1o7em35erakv74g7m9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad8088266fadd6e43','aut66fad9781466fadd6e02' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181838.2796 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.2811 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.2844 ap2h7cuj1o7em35erakv74g7m9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad8088266fadd6e43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad9781466fadd6e02' ,0,0 ,2,23.00,40000,?,?,?,?)
20240930@181838.3084 ap2h7cuj1o7em35erakv74g7m9 Query : use flama_phc
20240930@181838.3087 ap2h7cuj1o7em35erakv74g7m9 Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20240930@181838.3108 ap2h7cuj1o7em35erakv74g7m9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1803.00.1'
20240930@181838.3122 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.3137 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.3165 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.3181 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.3190 ap2h7cuj1o7em35erakv74g7m9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181838.4322 ap2h7cuj1o7em35erakv74g7m9 Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301274200a'
20240930@181838.4336 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.4354 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.4366 ap2h7cuj1o7em35erakv74g7m9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad9799866fadd6e69','aut66fad9781466fadd6e02' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181838.4371 ap2h7cuj1o7em35erakv74g7m9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.4386 ap2h7cuj1o7em35erakv74g7m9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.4416 ap2h7cuj1o7em35erakv74g7m9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad9799866fadd6e69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad9781466fadd6e02' ,0,0 ,2,23.00,50000,?,?,?,?)
20240930@181838.4672 ap2h7cuj1o7em35erakv74g7m9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fad9781466fadd6e02','2406300','wait',39,'adm09112754980.682000002')
20240930@181838.4743 ap2h7cuj1o7em35erakv74g7m9 Query : use flama_phc
20240930@181838.4747 ap2h7cuj1o7em35erakv74g7m9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240930@181838.4775 ap2h7cuj1o7em35erakv74g7m9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2306';
20240930@181838.4807 ap2h7cuj1o7em35erakv74g7m9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2306';
20240930@181838.4846 ap2h7cuj1o7em35erakv74g7m9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2306';
20240930@181838.4871 ap2h7cuj1o7em35erakv74g7m9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2306';
20240930@181838.5451 juk3d4tn0rao62vjsf47f3p0tp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240930@181838.5462 juk3d4tn0rao62vjsf47f3p0tp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240930@181838.5518 juk3d4tn0rao62vjsf47f3p0tp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2307';
20240930@181838.5572 juk3d4tn0rao62vjsf47f3p0tp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2307';
20240930@181838.5625 juk3d4tn0rao62vjsf47f3p0tp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2307';
20240930@181838.5655 juk3d4tn0rao62vjsf47f3p0tp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2307';
20240930@181838.5710 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.5713 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240930@181838.5773 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.5776 juk3d4tn0rao62vjsf47f3p0tp Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240930@181838.5818 juk3d4tn0rao62vjsf47f3p0tp 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'
20240930@181838.5991 juk3d4tn0rao62vjsf47f3p0tp 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'
20240930@181838.6013 juk3d4tn0rao62vjsf47f3p0tp 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'
20240930@181838.6034 juk3d4tn0rao62vjsf47f3p0tp 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'
20240930@181838.6056 juk3d4tn0rao62vjsf47f3p0tp 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'
20240930@181838.6077 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6080 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240930@181838.6113 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6116 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 1 valor from td where td.ndoc = 39
20240930@181838.6151 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6154 juk3d4tn0rao62vjsf47f3p0tp Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240930@181838.6182 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240930@181838.6217 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6220 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240930@181838.6252 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6255 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240930@181838.6285 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6288 juk3d4tn0rao62vjsf47f3p0tp Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240930@181838.6330 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6333 juk3d4tn0rao62vjsf47f3p0tp Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240930@181838.6380 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.6383 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from td where ndoc = 39
20240930@181838.6406 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240930@181838.6422 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.6438 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181838.6458 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.6473 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181838.6504 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.6519 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181838.6534 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181838.6601 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181838.6615 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.6631 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181838.6647 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240930@181838.6818 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.6834 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181838.6869 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240930@181838.6881 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240930@181838.6894 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240930@181838.6906 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240930@181838.6919 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240930@181838.6931 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240930@181838.6959 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fad5339466fadd6e9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240930@181838.7207 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 fno valor from wsftdata order by fno desc
20240930@181838.7229 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.7246 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181838.7292 juk3d4tn0rao62vjsf47f3p0tp Query : select 'normal' from dummy
20240930@181838.7581 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fad5339466fadd6e9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1002,100810,0,'2024-09-30',39,'euro',0,0,2024 ,?,?)
20240930@181838.8013 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.8016 juk3d4tn0rao62vjsf47f3p0tp Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240930@181838.8038 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240930@181838.8181 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8197 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.8222 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8236 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.8245 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181838.8257 juk3d4tn0rao62vjsf47f3p0tp Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20240930@181838.8271 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8285 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.8298 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad4784266fadd6ec9','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181838.8313 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8327 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.8356 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad4784266fadd6ec9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,10000,?,?,?,?)
20240930@181838.8619 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8634 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.8660 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8675 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.8684 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181838.8696 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8710 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.8721 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad6675266fadd6ed4','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181838.8725 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.8739 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.8767 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad6675266fadd6ed4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,20000,?,?,?)
20240930@181838.9020 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.9024 juk3d4tn0rao62vjsf47f3p0tp Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240930@181838.9042 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240930@181838.9056 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9070 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.9097 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9113 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.9121 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181838.9133 juk3d4tn0rao62vjsf47f3p0tp Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20240930@181838.9145 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9160 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.9171 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad9115966fadd6edf','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181838.9175 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9189 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.9218 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad9115966fadd6edf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,40000,?,?,?,?)
20240930@181838.9492 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9508 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.9533 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9548 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.9556 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181838.9568 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9582 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181838.9593 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad0847066fadd6ee9','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181838.9598 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9614 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.9643 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad0847066fadd6ee9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,50000,?,?,?)
20240930@181838.9923 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181838.9926 juk3d4tn0rao62vjsf47f3p0tp Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240930@181838.9945 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240930@181838.9958 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181838.9974 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181838.9999 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.1300 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.2100 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.3300 juk3d4tn0rao62vjsf47f3p0tp Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20240930@181839.4500 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.5900 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.7000 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad3363466fadd6f01','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.7300 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8700 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.1140 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad3363466fadd6f01',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,70000,?,?,?,?)
20240930@181839.3890 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.4050 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.4300 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.4450 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.4530 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.4650 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.4820 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.4940 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad5838666fadd6f0b','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.4980 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.5120 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.6800 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad5838666fadd6f0b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,80000,?,?,?)
20240930@181839.1242 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181839.1607 juk3d4tn0rao62vjsf47f3p0tp Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240930@181839.1875 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240930@181839.1890 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.1908 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.1935 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.1949 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.1958 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.1986 juk3d4tn0rao62vjsf47f3p0tp Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20240930@181839.1998 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2012 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.2025 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad8907866fadd6f30','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.2029 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2043 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.2071 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad8907866fadd6f30',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,100000,?,?,?,?)
20240930@181839.2339 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2354 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.2380 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2394 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.2402 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.2414 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2429 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.2440 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad9213666fadd6f3a','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.2443 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2457 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.2484 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad9213666fadd6f3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,110000,?,?,?)
20240930@181839.2746 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181839.2749 juk3d4tn0rao62vjsf47f3p0tp Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240930@181839.2767 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240930@181839.2781 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2799 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.2824 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2839 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.2847 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.2859 juk3d4tn0rao62vjsf47f3p0tp Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20240930@181839.2872 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2885 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.2896 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad8157466fadd6f46','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.2900 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.2915 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.2943 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad8157466fadd6f46',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,130000,?,?,?,?)
20240930@181839.3214 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.3229 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.3255 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.3269 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.3278 juk3d4tn0rao62vjsf47f3p0tp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.3289 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.3304 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.3315 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad6654766fadd6f50','aut66fad5339466fadd6e9f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.3319 juk3d4tn0rao62vjsf47f3p0tp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.3337 juk3d4tn0rao62vjsf47f3p0tp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.3366 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad6654766fadd6f50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad5339466fadd6e9f' ,0,0 ,2,23.00,140000,?,?,?)
20240930@181839.3619 juk3d4tn0rao62vjsf47f3p0tp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fad5339466fadd6e9f','2406301','wait',39,'adm09112754980.682000002')
20240930@181839.3693 juk3d4tn0rao62vjsf47f3p0tp Query : use flama_phc
20240930@181839.3697 juk3d4tn0rao62vjsf47f3p0tp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240930@181839.3728 juk3d4tn0rao62vjsf47f3p0tp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2307';
20240930@181839.3760 juk3d4tn0rao62vjsf47f3p0tp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2307';
20240930@181839.3810 juk3d4tn0rao62vjsf47f3p0tp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2307';
20240930@181839.3835 juk3d4tn0rao62vjsf47f3p0tp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2307';
20240930@181839.4511 sicm9aktri9monu4621ao1077u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240930@181839.4524 sicm9aktri9monu4621ao1077u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240930@181839.4579 sicm9aktri9monu4621ao1077u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2308';
20240930@181839.4636 sicm9aktri9monu4621ao1077u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2308';
20240930@181839.4690 sicm9aktri9monu4621ao1077u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2308';
20240930@181839.4714 sicm9aktri9monu4621ao1077u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2308';
20240930@181839.4766 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.4769 sicm9aktri9monu4621ao1077u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240930@181839.4893 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.4896 sicm9aktri9monu4621ao1077u Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240930@181839.4958 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5116 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5135 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5154 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5174 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5193 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5215 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5235 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5254 sicm9aktri9monu4621ao1077u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240930@181839.5275 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5279 sicm9aktri9monu4621ao1077u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240930@181839.5312 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5315 sicm9aktri9monu4621ao1077u Query : select top 1 1 valor from td where td.ndoc = 39
20240930@181839.5346 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5349 sicm9aktri9monu4621ao1077u Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240930@181839.5381 sicm9aktri9monu4621ao1077u Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240930@181839.5418 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5422 sicm9aktri9monu4621ao1077u Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240930@181839.5455 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5458 sicm9aktri9monu4621ao1077u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240930@181839.5491 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5494 sicm9aktri9monu4621ao1077u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240930@181839.5540 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5543 sicm9aktri9monu4621ao1077u Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240930@181839.5591 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.5595 sicm9aktri9monu4621ao1077u Query : select 1 valor from td where ndoc = 39
20240930@181839.5609 sicm9aktri9monu4621ao1077u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240930@181839.5626 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.5643 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181839.5667 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.5684 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181839.5719 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.5736 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181839.5751 sicm9aktri9monu4621ao1077u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181839.5818 sicm9aktri9monu4621ao1077u Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181839.5833 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.5850 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181839.5868 sicm9aktri9monu4621ao1077u Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240930@181839.6050 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.6068 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181839.6107 sicm9aktri9monu4621ao1077u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240930@181839.6120 sicm9aktri9monu4621ao1077u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240930@181839.6132 sicm9aktri9monu4621ao1077u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240930@181839.6147 sicm9aktri9monu4621ao1077u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240930@181839.6160 sicm9aktri9monu4621ao1077u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240930@181839.6174 sicm9aktri9monu4621ao1077u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240930@181839.6188 sicm9aktri9monu4621ao1077u Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fad8971866fadd6f8c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240930@181839.6430 sicm9aktri9monu4621ao1077u Query : select top 1 fno valor from wsftdata order by fno desc
20240930@181839.6451 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.6466 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181839.6487 sicm9aktri9monu4621ao1077u Query : select 'normal' from dummy
20240930@181839.6503 sicm9aktri9monu4621ao1077u Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fad8971866fadd6f8c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1003,100810,0,'2024-09-30',39,'euro',0,0,2024 ,?,?)
20240930@181839.6786 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.6788 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181839.6810 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181839.8061 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8077 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.8101 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8115 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.8124 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.8136 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181839.8156 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8170 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.8181 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad6507466fadd6fc7','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.8185 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8199 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.8226 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad6507466fadd6fc7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,10000,?,?,?,?)
20240930@181839.8491 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8506 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.8531 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8545 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.8555 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.8567 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8581 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.8593 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad4796566fadd6fd1','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.8597 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8612 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.8640 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad4796566fadd6fd1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,20000,?,?,?)
20240930@181839.8897 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181839.8899 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181839.8918 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181839.8932 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8947 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.8974 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.8990 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.9065 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.9078 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181839.9092 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.9344 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.9478 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad7686866fadd6fdd','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.9482 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.9499 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.9528 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad7686866fadd6fdd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,40000,?,?,?,?)
20240930@181839.9792 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.9810 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.9834 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.9847 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.9855 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181839.9866 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.9881 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181839.9892 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad2132366fadd6ff0','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181839.9896 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181839.9911 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181839.9936 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad2132366fadd6ff0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,50000,?,?,?)
20240930@181840.1820 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.1850 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181840.2050 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181840.2230 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2380 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.2650 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2790 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.2870 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.2990 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181840.3110 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3250 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.3360 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad2792566fadd7007','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.3400 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3540 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.3810 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad2792566fadd7007',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,70000,?,?,?,?)
20240930@181840.6420 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.6580 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.6880 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.7030 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.7120 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.7250 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.7400 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.7510 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad1704366fadd7011','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.7560 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.7710 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.8000 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad1704366fadd7011',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,80000,?,?,?)
20240930@181840.1054 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.1057 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181840.1075 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181840.1089 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1104 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.1132 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1148 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.1158 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.1173 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181840.1185 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1202 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.1214 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad5862666fadd701c','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.1218 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1235 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.1263 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad5862666fadd701c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,100000,?,?,?,?)
20240930@181840.1526 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1545 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.1572 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1588 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.1598 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.1610 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1625 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.1637 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad7698266fadd7027','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.1641 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1656 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.1684 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad7698266fadd7027',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,110000,?,?,?)
20240930@181840.1937 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.1941 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181840.1961 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181840.1975 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.1991 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.2017 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2032 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.2041 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.2053 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181840.2065 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2080 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.2093 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad3293766fadd7032','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.2097 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2112 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.2141 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad3293766fadd7032',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,130000,?,?,?,?)
20240930@181840.2411 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2427 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.2453 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2467 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.2475 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.2487 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2504 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.2516 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad4762266fadd703c','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.2520 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2536 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.2564 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad4762266fadd703c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,140000,?,?,?)
20240930@181840.2854 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.2857 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181840.2878 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181840.2894 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2910 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.2937 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2951 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.2959 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.2971 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181840.2984 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.2998 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.3010 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad0907766fadd7048','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.3014 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3029 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.3060 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad0907766fadd7048',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,160000,?,?,?,?)
20240930@181840.3428 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3446 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.3471 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3486 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.3494 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.3507 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3522 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.3533 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad7623166fadd7055','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.3538 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3555 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.3584 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad7623166fadd7055',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,170000,?,?,?)
20240930@181840.3833 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.3836 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181840.3855 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181840.3869 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3887 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.3913 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3928 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.3937 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.3949 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181840.3961 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.3975 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.3987 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad9412666fadd7060','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.3990 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4004 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.4034 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad9412666fadd7060',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,190000,?,?,?,?)
20240930@181840.4294 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4312 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.4341 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4356 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.4365 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.4377 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4397 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.4410 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad8479166fadd706a','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.4414 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4430 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.4461 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad8479166fadd706a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,200000,?,?,?)
20240930@181840.4742 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.4746 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181840.4766 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181840.4782 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4801 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.4828 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4843 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.4851 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.4864 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181840.4876 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4891 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.4903 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad2219166fadd7077','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.4907 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.4921 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.4954 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad2219166fadd7077',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,220000,?,?,?,?)
20240930@181840.5214 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5234 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.5284 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5303 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.5315 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.5330 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5350 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.5364 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad4707766fadd7082','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.5369 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5387 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.5422 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad4707766fadd7082',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,230000,?,?,?)
20240930@181840.5730 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.5733 sicm9aktri9monu4621ao1077u Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20240930@181840.5752 sicm9aktri9monu4621ao1077u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1889.00.1'
20240930@181840.5765 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5781 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.5806 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5823 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.5832 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.5844 sicm9aktri9monu4621ao1077u Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20240930@181840.5857 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5872 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.5884 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad6884066fadd708f','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.5887 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.5903 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.5932 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad6884066fadd708f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,250000,?,?,?,?)
20240930@181840.6184 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.6199 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.6226 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.6241 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.6250 sicm9aktri9monu4621ao1077u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181840.6264 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.6279 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181840.6291 sicm9aktri9monu4621ao1077u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad3985966fadd7098','aut66fad8971866fadd6f8c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181840.6295 sicm9aktri9monu4621ao1077u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.6310 sicm9aktri9monu4621ao1077u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181840.6339 sicm9aktri9monu4621ao1077u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fad3985966fadd7098',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fad8971866fadd6f8c' ,0,0 ,2,23.00,260000,?,?,?)
20240930@181840.6608 sicm9aktri9monu4621ao1077u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fad8971866fadd6f8c','2406302','wait',39,'adm09112754980.682000002')
20240930@181840.6683 sicm9aktri9monu4621ao1077u Query : use flama_phc
20240930@181840.6686 sicm9aktri9monu4621ao1077u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240930@181840.6720 sicm9aktri9monu4621ao1077u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2308';
20240930@181840.6751 sicm9aktri9monu4621ao1077u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2308';
20240930@181840.6795 sicm9aktri9monu4621ao1077u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2308';
20240930@181840.6821 sicm9aktri9monu4621ao1077u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2308';
20240930@181840.7359 qbhh5mum1s1fd7qmokimk5827a Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240930@181840.7373 qbhh5mum1s1fd7qmokimk5827a Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240930@181840.7444 qbhh5mum1s1fd7qmokimk5827a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2309';
20240930@181840.7497 qbhh5mum1s1fd7qmokimk5827a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2309';
20240930@181840.7551 qbhh5mum1s1fd7qmokimk5827a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2309';
20240930@181840.7586 qbhh5mum1s1fd7qmokimk5827a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2309';
20240930@181840.7636 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.7639 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240930@181840.7705 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.7708 qbhh5mum1s1fd7qmokimk5827a Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240930@181840.7750 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20240930@181840.8086 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20240930@181840.8110 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8113 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240930@181840.8161 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8165 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 1 valor from td where td.ndoc = 39
20240930@181840.8195 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8199 qbhh5mum1s1fd7qmokimk5827a Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240930@181840.8228 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240930@181840.8268 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8271 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240930@181840.8300 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8303 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240930@181840.8336 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8340 qbhh5mum1s1fd7qmokimk5827a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240930@181840.8393 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8396 qbhh5mum1s1fd7qmokimk5827a Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240930@181840.8439 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181840.8442 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from td where ndoc = 39
20240930@181840.8456 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240930@181840.8471 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.8488 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181840.8508 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.8523 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181840.9708 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.9725 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181840.9738 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181840.9807 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181840.9820 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181840.9835 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181840.9850 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fad6116966fadd70ed' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240930@181841.2300 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.3800 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181841.7000 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240930@181841.8100 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240930@181841.9300 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240930@181841.1050 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240930@181841.1290 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240930@181841.1400 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240930@181841.1520 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fad6116966fadd70ed',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240930@181841.4060 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 fno valor from wsftdata order by fno desc
20240930@181841.4290 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.4450 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181841.4690 qbhh5mum1s1fd7qmokimk5827a Query : select 'normal' from dummy
20240930@181841.4870 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fad6116966fadd70ed',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1004,100810,0,'2024-09-30',39,'euro',0,0,2024 ,?,?)
20240930@181841.7830 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181841.7860 qbhh5mum1s1fd7qmokimk5827a Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20240930@181841.8080 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20240930@181841.9530 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.9690 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.9960 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.1011 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.1020 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181841.1032 qbhh5mum1s1fd7qmokimk5827a Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20240930@181841.1048 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.1063 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.1075 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad6366466fadd7119','aut66fad6116966fadd70ed' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181841.1079 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.1093 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.1123 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad6366466fadd7119',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut66fad6116966fadd70ed' ,0,0 ,2,23.00,10000,?,?,?,?)
20240930@181841.1377 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181841.1380 qbhh5mum1s1fd7qmokimk5827a Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20240930@181841.1399 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20240930@181841.1413 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.1428 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.1453 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.1467 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.1476 qbhh5mum1s1fd7qmokimk5827a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181841.1493 qbhh5mum1s1fd7qmokimk5827a Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20240930@181841.1506 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.1520 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.1532 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad2459666fadd7124','aut66fad6116966fadd70ed' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181841.1536 qbhh5mum1s1fd7qmokimk5827a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.1550 qbhh5mum1s1fd7qmokimk5827a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.1581 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad2459666fadd7124',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28.000 ,'aut66fad6116966fadd70ed' ,0,0 ,2,23.00,20000,?,?,?,?)
20240930@181841.1837 qbhh5mum1s1fd7qmokimk5827a Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fad6116966fadd70ed','2406304','wait',39,'adm09112754980.682000002')
20240930@181841.1914 qbhh5mum1s1fd7qmokimk5827a Query : use flama_phc
20240930@181841.1917 qbhh5mum1s1fd7qmokimk5827a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240930@181841.1946 qbhh5mum1s1fd7qmokimk5827a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2309';
20240930@181841.1978 qbhh5mum1s1fd7qmokimk5827a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2309';
20240930@181841.2023 qbhh5mum1s1fd7qmokimk5827a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2309';
20240930@181841.2053 qbhh5mum1s1fd7qmokimk5827a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2309';
20240930@181841.2590 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240930@181841.2601 tjlbpd1l5ut1i5ad2825u815t7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240930@181841.2656 tjlbpd1l5ut1i5ad2825u815t7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2310';
20240930@181841.2711 tjlbpd1l5ut1i5ad2825u815t7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2310';
20240930@181841.2763 tjlbpd1l5ut1i5ad2825u815t7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2310';
20240930@181841.2791 tjlbpd1l5ut1i5ad2825u815t7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2310';
20240930@181841.2837 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.2840 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240930@181841.2918 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.2921 tjlbpd1l5ut1i5ad2825u815t7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2021
20240930@181841.2997 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20240930@181841.3017 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20240930@181841.3039 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3042 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240930@181841.3074 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3077 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 1 valor from td where td.ndoc = 39
20240930@181841.3107 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3110 tjlbpd1l5ut1i5ad2825u815t7 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240930@181841.3138 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240930@181841.3175 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3178 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240930@181841.3301 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3304 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240930@181841.3336 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3339 tjlbpd1l5ut1i5ad2825u815t7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240930@181841.3380 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3383 tjlbpd1l5ut1i5ad2825u815t7 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m corroios'
20240930@181841.3431 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.3433 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from td where ndoc = 39
20240930@181841.3445 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240930@181841.3472 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.3488 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181841.3507 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.3521 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181841.3552 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.3569 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181841.3581 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181841.3648 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240930@181841.3662 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.3676 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240930@181841.3692 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fad9309766fadd7157' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240930@181841.3866 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.3883 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240930@181841.3915 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240930@181841.3927 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240930@181841.3939 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240930@181841.3950 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240930@181841.3963 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240930@181841.3977 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240930@181841.3988 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fad9309766fadd7157',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240930@181841.4234 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 fno valor from wsftdata order by fno desc
20240930@181841.4266 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.4281 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240930@181841.4304 tjlbpd1l5ut1i5ad2825u815t7 Query : select 'normal' from dummy
20240930@181841.4319 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fad9309766fadd7157',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1005,101621,0,'2024-09-30',39,'euro',0,0,2024 ,?,?)
20240930@181841.4629 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.4632 tjlbpd1l5ut1i5ad2825u815t7 Query : select st.usalote valor from st where st.ref = '324.4751.00.1'
20240930@181841.4653 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4751.00.1'
20240930@181841.4667 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.4683 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.4709 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.4724 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.4733 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181841.4756 tjlbpd1l5ut1i5ad2825u815t7 Query : select sestamp valor from se where ref ='324.4751.00.1' and lote = 'r2400049200a'
20240930@181841.4769 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.4785 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.4798 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad9030166fadd7174','aut66fad9309766fadd7157' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181841.4803 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.4818 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.4847 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad9030166fadd7174',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fad9309766fadd7157' ,0,0 ,2,23.00,10000,?,?,?,?)
20240930@181841.5106 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.5109 tjlbpd1l5ut1i5ad2825u815t7 Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20240930@181841.5129 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20240930@181841.5143 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.5159 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.5186 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.5200 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.5209 tjlbpd1l5ut1i5ad2825u815t7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240930@181841.5221 tjlbpd1l5ut1i5ad2825u815t7 Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20240930@181841.5234 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.5248 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240930@181841.5261 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fad7542066fadd717f','aut66fad9309766fadd7157' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240930@181841.5265 tjlbpd1l5ut1i5ad2825u815t7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240930@181841.5280 tjlbpd1l5ut1i5ad2825u815t7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240930@181841.5311 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fad7542066fadd717f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fad9309766fadd7157' ,0,0 ,2,23.00,20000,?,?,?,?)
20240930@181841.5890 tjlbpd1l5ut1i5ad2825u815t7 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fad9309766fadd7157','2406305','wait',39,'adm09112754980.682000002')
20240930@181841.7120 tjlbpd1l5ut1i5ad2825u815t7 Query : use flama_phc
20240930@181841.7123 tjlbpd1l5ut1i5ad2825u815t7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240930@181841.7156 tjlbpd1l5ut1i5ad2825u815t7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2310';
20240930@181841.7187 tjlbpd1l5ut1i5ad2825u815t7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2310';
20240930@181841.7229 tjlbpd1l5ut1i5ad2825u815t7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2310';
20240930@181841.7254 tjlbpd1l5ut1i5ad2825u815t7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2310';
20240930@181841.7780 bj0bougi60dh6baqg975vm8k5q Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240930@181841.7790 bj0bougi60dh6baqg975vm8k5q Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240930@181841.7844 bj0bougi60dh6baqg975vm8k5q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2311';
20240930@181841.7908 bj0bougi60dh6baqg975vm8k5q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2311';
20240930@181841.7961 bj0bougi60dh6baqg975vm8k5q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2311';
20240930@181841.7985 bj0bougi60dh6baqg975vm8k5q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2311';
20240930@181841.8039 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8043 bj0bougi60dh6baqg975vm8k5q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240930@181841.8241 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8244 bj0bougi60dh6baqg975vm8k5q Query : select no, estab,szadrsdesc from szadrs where u_coddest=1328
20240930@181841.8327 bj0bougi60dh6baqg975vm8k5q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20240930@181841.8348 bj0bougi60dh6baqg975vm8k5q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20240930@181841.8369 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8372 bj0bougi60dh6baqg975vm8k5q Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240930@181841.8403 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8406 bj0bougi60dh6baqg975vm8k5q Query : select top 1 1 valor from td where td.ndoc = 39
20240930@181841.8437 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8441 bj0bougi60dh6baqg975vm8k5q Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240930@181841.8469 bj0bougi60dh6baqg975vm8k5q Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240930@181841.8502 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8505 bj0bougi60dh6baqg975vm8k5q Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240930@181841.8534 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8537 bj0bougi60dh6baqg975vm8k5q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240930@181841.8569 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8572 bj0bougi60dh6baqg975vm8k5q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240930@181841.8612 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8615 bj0bougi60dh6baqg975vm8k5q Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - mealhada'
20240930@181841.8663 bj0bougi60dh6baqg975vm8k5q Query : use flama_phc
20240930@181841.8666 bj0bougi60dh6baqg975vm8k5q Query : select 1 valor from td where ndoc = 39
