20240429@094931.7448 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.7463 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094931.7489 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.7503 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094931.7508 v3pvd7hvufojmdht5pd8m159hn Query : select sestamp valor from se where ref ='324.4161.00.1' and lote = 'r2100973100a'
20240429@094931.7532 v3pvd7hvufojmdht5pd8m159hn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094931.7543 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.7557 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094931.7581 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f574048662f5f1bb8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut662f550883662f5f1b99' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094931.7821 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.7837 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094931.7841 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f574048662f5f1bb8','aut662f550883662f5f1b99' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094931.7846 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.7860 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094931.7895 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.7908 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094931.7913 v3pvd7hvufojmdht5pd8m159hn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094931.7923 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.7936 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094931.7959 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut662f524041662f5f1bc1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut662f550883662f5f1b99' ,0,0 ,2,23.00,20000,?,?,?)
20240429@094931.8216 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.8233 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094931.8237 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f524041662f5f1bc1','aut662f550883662f5f1b99' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094931.8242 v3pvd7hvufojmdht5pd8m159hn Query : use flama_phc
20240429@094931.8245 v3pvd7hvufojmdht5pd8m159hn Query : select st.usalote valor from st where st.ref = '324.4161.00.1'
20240429@094931.8259 v3pvd7hvufojmdht5pd8m159hn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4161.00.1'
20240429@094931.8270 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.8285 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094931.8313 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.8329 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094931.8334 v3pvd7hvufojmdht5pd8m159hn Query : select sestamp valor from se where ref ='324.4161.00.1' and lote = 'r2100973100a'
20240429@094931.8345 v3pvd7hvufojmdht5pd8m159hn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094931.8356 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.8370 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094931.8396 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f587295662f5f1bcc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut662f550883662f5f1b99' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240429@094931.8784 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.8801 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094931.8805 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f587295662f5f1bcc','aut662f550883662f5f1b99' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094931.8811 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.8824 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094931.8853 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.8866 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094931.8871 v3pvd7hvufojmdht5pd8m159hn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094931.8882 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094931.8895 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094931.8923 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut662f516346662f5f1bd8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut662f550883662f5f1b99' ,0,0 ,2,23.00,50000,?,?,?)
20240429@094931.9226 v3pvd7hvufojmdht5pd8m159hn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094931.9241 v3pvd7hvufojmdht5pd8m159hn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094931.9246 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f516346662f5f1bd8','aut662f550883662f5f1b99' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094931.9250 v3pvd7hvufojmdht5pd8m159hn Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f550883662f5f1b99','2403034','wait',39,'ari17112337378,753000005')
20240429@094931.9269 v3pvd7hvufojmdht5pd8m159hn Query : use flama_phc
20240429@094931.9272 v3pvd7hvufojmdht5pd8m159hn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094931.9284 v3pvd7hvufojmdht5pd8m159hn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1383';
20240429@094931.9303 v3pvd7hvufojmdht5pd8m159hn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1383';
20240429@094931.9319 v3pvd7hvufojmdht5pd8m159hn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1383';
20240429@094931.9334 v3pvd7hvufojmdht5pd8m159hn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1383';
20240429@094932.4200 adt1o671r3astn20nvoodv2lch Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094932.6200 adt1o671r3astn20nvoodv2lch Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094932.9100 adt1o671r3astn20nvoodv2lch Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1384';
20240429@094932.1370 adt1o671r3astn20nvoodv2lch Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1384';
20240429@094932.1550 adt1o671r3astn20nvoodv2lch Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1384';
20240429@094932.1700 adt1o671r3astn20nvoodv2lch Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1384';
20240429@094932.1850 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.1880 adt1o671r3astn20nvoodv2lch Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094932.2010 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.2050 adt1o671r3astn20nvoodv2lch Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094932.2440 adt1o671r3astn20nvoodv2lch Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4840.00.1'
20240429@094932.3930 adt1o671r3astn20nvoodv2lch Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403035 and bi.ref ='324.4840.00.1' and bi.lordem =1
20240429@094932.7190 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.7230 adt1o671r3astn20nvoodv2lch Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094932.7360 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.7390 adt1o671r3astn20nvoodv2lch Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094932.7500 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.7540 adt1o671r3astn20nvoodv2lch Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094932.7660 adt1o671r3astn20nvoodv2lch Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094932.7810 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.7840 adt1o671r3astn20nvoodv2lch Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094932.7940 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.7970 adt1o671r3astn20nvoodv2lch Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094932.8080 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.8110 adt1o671r3astn20nvoodv2lch Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094932.1020 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.1030 adt1o671r3astn20nvoodv2lch Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094932.1044 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.1047 adt1o671r3astn20nvoodv2lch Query : select 1 valor from td where ndoc = 39
20240429@094932.1058 adt1o671r3astn20nvoodv2lch Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094932.1071 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094932.1092 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094932.1110 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094932.1124 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094932.1152 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094932.1165 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094932.1176 adt1o671r3astn20nvoodv2lch Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094932.1268 adt1o671r3astn20nvoodv2lch Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094932.1279 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094932.1293 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094932.1305 adt1o671r3astn20nvoodv2lch Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f592785662f5f1c1c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094932.1478 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094932.1493 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094932.1525 adt1o671r3astn20nvoodv2lch Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094932.1529 adt1o671r3astn20nvoodv2lch Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094932.1535 adt1o671r3astn20nvoodv2lch Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094932.1541 adt1o671r3astn20nvoodv2lch Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094932.1547 adt1o671r3astn20nvoodv2lch Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094932.1552 adt1o671r3astn20nvoodv2lch Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094932.1557 adt1o671r3astn20nvoodv2lch Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f592785662f5f1c1c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094932.1848 adt1o671r3astn20nvoodv2lch Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094932.1868 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094932.1883 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094932.1900 adt1o671r3astn20nvoodv2lch Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f592785662f5f1c1c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1089,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094932.2232 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.2236 adt1o671r3astn20nvoodv2lch Query : select st.usalote valor from st where st.ref = '324.4840.00.1'
20240429@094932.2250 adt1o671r3astn20nvoodv2lch Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4840.00.1'
20240429@094932.2507 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094932.2528 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094932.2554 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094932.2568 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094932.2573 adt1o671r3astn20nvoodv2lch Query : select sestamp valor from se where ref ='324.4840.00.1' and lote = 'r2101353200a'
20240429@094932.2599 adt1o671r3astn20nvoodv2lch Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094932.2613 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094932.2630 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094932.2656 adt1o671r3astn20nvoodv2lch Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f537798662f5f1c3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut662f592785662f5f1c1c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094932.2997 adt1o671r3astn20nvoodv2lch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094932.3014 adt1o671r3astn20nvoodv2lch Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094932.3018 adt1o671r3astn20nvoodv2lch Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f537798662f5f1c3f','aut662f592785662f5f1c1c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094932.3023 adt1o671r3astn20nvoodv2lch Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f592785662f5f1c1c','2403035','wait',39,'ari17112337378,753000005')
20240429@094932.3039 adt1o671r3astn20nvoodv2lch Query : use flama_phc
20240429@094932.3047 adt1o671r3astn20nvoodv2lch Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094932.3059 adt1o671r3astn20nvoodv2lch Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1384';
20240429@094932.3079 adt1o671r3astn20nvoodv2lch Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1384';
20240429@094932.3096 adt1o671r3astn20nvoodv2lch Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1384';
20240429@094932.3111 adt1o671r3astn20nvoodv2lch Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1384';
20240429@094932.3546 d21g5i4p6etl4t5thschsoo4bc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094932.3567 d21g5i4p6etl4t5thschsoo4bc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094932.3590 d21g5i4p6etl4t5thschsoo4bc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240429@094932.3637 d21g5i4p6etl4t5thschsoo4bc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240429@094932.3656 d21g5i4p6etl4t5thschsoo4bc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240429@094932.3670 d21g5i4p6etl4t5thschsoo4bc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240429@094932.3688 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.3692 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094932.3705 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.3709 d21g5i4p6etl4t5thschsoo4bc Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094932.3750 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4965.00.1'
20240429@094932.3922 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403036 and bi.ref ='324.4965.00.1' and bi.lordem =1
20240429@094932.4264 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4965.00.1'
20240429@094932.4275 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403036 and bi.ref ='324.4965.00.1' and bi.lordem =1
20240429@094932.4280 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4283 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094932.4299 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4302 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094932.4313 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4316 d21g5i4p6etl4t5thschsoo4bc Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094932.4331 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094932.4346 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4348 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094932.4359 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4362 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094932.4372 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4375 d21g5i4p6etl4t5thschsoo4bc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094932.4386 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4389 d21g5i4p6etl4t5thschsoo4bc Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094932.4402 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.4405 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from td where ndoc = 39
20240429@094932.4415 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094932.4428 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094932.4443 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094932.4460 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094932.4472 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094932.4499 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094932.4511 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094932.4521 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094932.4610 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094932.4620 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094932.4634 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094932.4644 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f535603662f5f1c6e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094932.4815 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094932.4830 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094932.4859 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094932.4866 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094932.4870 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094932.4875 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094932.4879 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094932.4883 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094932.4888 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f535603662f5f1c6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094932.5297 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094932.5514 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094932.5528 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094932.5553 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f535603662f5f1c6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1090,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094932.6208 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.6255 d21g5i4p6etl4t5thschsoo4bc Query : select st.usalote valor from st where st.ref = '324.4965.00.1'
20240429@094932.6268 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4965.00.1'
20240429@094932.6412 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094932.6426 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094932.6448 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094932.6460 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094932.6464 d21g5i4p6etl4t5thschsoo4bc Query : select sestamp valor from se where ref ='324.4965.00.1' and lote = 'r2300825100a'
20240429@094932.6597 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094932.6703 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094932.6718 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094932.6740 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f514974662f5f1ca3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',68.000 ,'aut662f535603662f5f1c6e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094932.6974 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094932.6989 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094932.6994 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f514974662f5f1ca3','aut662f535603662f5f1c6e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094932.6998 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.7001 d21g5i4p6etl4t5thschsoo4bc Query : select st.usalote valor from st where st.ref = '324.4965.00.1'
20240429@094932.7011 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4965.00.1'
20240429@094932.7023 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094932.7037 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094932.7100 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094932.7116 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094932.7121 d21g5i4p6etl4t5thschsoo4bc Query : select sestamp valor from se where ref ='324.4965.00.1' and lote = 'r2300825100a'
20240429@094932.7131 d21g5i4p6etl4t5thschsoo4bc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094932.7142 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094932.7156 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094932.7183 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f501134662f5f1cae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut662f535603662f5f1c6e' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240429@094932.7551 d21g5i4p6etl4t5thschsoo4bc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094932.7651 d21g5i4p6etl4t5thschsoo4bc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094932.7656 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f501134662f5f1cae','aut662f535603662f5f1c6e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094932.7662 d21g5i4p6etl4t5thschsoo4bc Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f535603662f5f1c6e','2403036','wait',39,'ari17112337378,753000005')
20240429@094932.7678 d21g5i4p6etl4t5thschsoo4bc Query : use flama_phc
20240429@094932.7681 d21g5i4p6etl4t5thschsoo4bc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094932.7693 d21g5i4p6etl4t5thschsoo4bc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240429@094932.7714 d21g5i4p6etl4t5thschsoo4bc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240429@094932.7731 d21g5i4p6etl4t5thschsoo4bc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240429@094932.7745 d21g5i4p6etl4t5thschsoo4bc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240429@094932.8157 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094932.8178 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094932.8202 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1386';
20240429@094932.8246 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1386';
20240429@094932.8306 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1386';
20240429@094932.8327 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1386';
20240429@094932.8343 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.8347 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094932.8362 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.8365 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094932.8403 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240429@094932.8575 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403037 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240429@094932.8988 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240429@094932.8999 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403037 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240429@094932.9005 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240429@094932.9017 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403037 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240429@094932.9023 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9026 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094932.9042 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9045 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094932.9055 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9059 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094932.9070 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094932.9084 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9088 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094932.9099 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9101 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094932.9112 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9115 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094932.9125 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9128 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094932.9141 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094932.9143 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from td where ndoc = 39
20240429@094932.9153 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094932.9164 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094932.9178 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094932.9196 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094932.9209 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094932.9240 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094932.9253 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094932.9263 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094932.9366 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094932.9379 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094932.9392 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094932.9403 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f550268662f5f1ce2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094932.9572 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094932.9587 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094932.9618 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094932.9623 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094932.9628 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094932.9633 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094932.9638 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094932.9643 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094932.9649 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f550268662f5f1ce2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094932.9895 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094932.9916 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094932.9931 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094932.9947 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f550268662f5f1ce2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1091,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094933.2240 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094933.2280 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240429@094933.2410 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240429@094933.3900 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.4050 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094933.4300 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.4430 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094933.4470 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240429@094933.4580 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094933.4680 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.4820 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094933.5080 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f546247662f5f1d0b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut662f550268662f5f1ce2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094933.1033 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.1815 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094933.1821 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f546247662f5f1d0b','aut662f550268662f5f1ce2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094933.1827 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094933.1830 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240429@094933.1841 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240429@094933.1852 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.1865 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094933.1910 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.1923 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094933.1927 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240429@094933.1937 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094933.1946 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.1958 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094933.1980 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f517621662f5f1d2f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut662f550268662f5f1ce2' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240429@094933.2239 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.2253 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094933.2258 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f517621662f5f1d2f','aut662f550268662f5f1ce2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094933.2262 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094933.2265 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240429@094933.2301 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4970.00.1'
20240429@094933.2326 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.2344 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094933.2369 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.2381 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094933.2386 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240429@094933.2402 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094933.2412 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.2425 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094933.2448 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f599333662f5f1d3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut662f550268662f5f1ce2' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240429@094933.2734 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.2749 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094933.2755 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f599333662f5f1d3a','aut662f550268662f5f1ce2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094933.2759 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f550268662f5f1ce2','2403037','wait',39,'ari17112337378,753000005')
20240429@094933.2775 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : use flama_phc
20240429@094933.2783 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094933.2799 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1386';
20240429@094933.2820 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1386';
20240429@094933.2839 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1386';
20240429@094933.2870 3itn6f3l8ji0fs4v8ls3vgbsj5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1386';
20240429@094933.3722 k9ejihbl21k978400ou6p2l6e2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094933.3743 k9ejihbl21k978400ou6p2l6e2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094933.3785 k9ejihbl21k978400ou6p2l6e2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1387';
20240429@094933.3831 k9ejihbl21k978400ou6p2l6e2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1387';
20240429@094933.3850 k9ejihbl21k978400ou6p2l6e2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1387';
20240429@094933.3869 k9ejihbl21k978400ou6p2l6e2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1387';
20240429@094933.3885 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.3888 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094933.3904 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.3907 k9ejihbl21k978400ou6p2l6e2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094933.3961 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.719.00.01'
20240429@094933.4114 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403038 and bi.ref ='324.719.00.01' and bi.lordem =1
20240429@094933.4673 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4678 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094933.4695 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4699 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094933.4710 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4713 k9ejihbl21k978400ou6p2l6e2 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094933.4724 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094933.4738 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4741 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094933.4752 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4755 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094933.4767 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4770 k9ejihbl21k978400ou6p2l6e2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094933.4781 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4783 k9ejihbl21k978400ou6p2l6e2 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094933.4796 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.4799 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from td where ndoc = 39
20240429@094933.4809 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094933.4824 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094933.4837 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094933.4857 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094933.4870 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094933.4896 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094933.4910 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094933.4920 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094933.5017 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094933.5027 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094933.5068 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094933.5078 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f544053662f5f1d78' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094933.5243 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094933.5259 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094933.5287 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094933.5293 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094933.5297 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094933.5302 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094933.5310 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094933.5315 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094933.5320 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f544053662f5f1d78',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094933.5565 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094933.5608 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094933.5623 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094933.5642 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f544053662f5f1d78',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1092,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094933.5919 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.5923 k9ejihbl21k978400ou6p2l6e2 Query : select st.usalote valor from st where st.ref = '324.719.00.01'
20240429@094933.5935 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.719.00.01'
20240429@094933.6126 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.6140 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094933.6164 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.6181 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094933.6185 k9ejihbl21k978400ou6p2l6e2 Query : select sestamp valor from se where ref ='324.719.00.01' and lote = 'r2300383300a'
20240429@094933.6214 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094933.6223 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.6236 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094933.6258 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f577261662f5f1d97',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut662f544053662f5f1d78' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094933.6505 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.6521 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094933.6525 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f577261662f5f1d97','aut662f544053662f5f1d78' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094933.6530 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.6544 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094933.6569 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.6583 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094933.6588 k9ejihbl21k978400ou6p2l6e2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094933.6597 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094933.6609 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094933.6633 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut662f531104662f5f1da1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut662f544053662f5f1d78' ,0,0 ,2,23.00,20000,?,?,?)
20240429@094933.6870 k9ejihbl21k978400ou6p2l6e2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094933.6886 k9ejihbl21k978400ou6p2l6e2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094933.6891 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f531104662f5f1da1','aut662f544053662f5f1d78' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094933.6895 k9ejihbl21k978400ou6p2l6e2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f544053662f5f1d78','2403038','wait',39,'ari17112337378,753000005')
20240429@094933.6914 k9ejihbl21k978400ou6p2l6e2 Query : use flama_phc
20240429@094933.6918 k9ejihbl21k978400ou6p2l6e2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094933.6934 k9ejihbl21k978400ou6p2l6e2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1387';
20240429@094933.6954 k9ejihbl21k978400ou6p2l6e2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1387';
20240429@094933.6971 k9ejihbl21k978400ou6p2l6e2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1387';
20240429@094933.6986 k9ejihbl21k978400ou6p2l6e2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1387';
20240429@094933.7416 gsal1d4k7idkg7152j035d3hoc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094933.7435 gsal1d4k7idkg7152j035d3hoc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094933.7460 gsal1d4k7idkg7152j035d3hoc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1388';
20240429@094933.7507 gsal1d4k7idkg7152j035d3hoc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1388';
20240429@094933.7528 gsal1d4k7idkg7152j035d3hoc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1388';
20240429@094933.7548 gsal1d4k7idkg7152j035d3hoc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1388';
20240429@094933.7588 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094933.7592 gsal1d4k7idkg7152j035d3hoc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094933.7609 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094933.7613 gsal1d4k7idkg7152j035d3hoc Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094933.8858 gsal1d4k7idkg7152j035d3hoc Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4967.00.1'
20240429@094933.9839 gsal1d4k7idkg7152j035d3hoc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403039 and bi.ref ='324.4967.00.1' and bi.lordem =1
20240429@094934.3570 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.3990 gsal1d4k7idkg7152j035d3hoc Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094934.4640 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.4670 gsal1d4k7idkg7152j035d3hoc Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094934.4770 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.4810 gsal1d4k7idkg7152j035d3hoc Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094934.4920 gsal1d4k7idkg7152j035d3hoc Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094934.5060 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.5100 gsal1d4k7idkg7152j035d3hoc Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094934.5190 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.5220 gsal1d4k7idkg7152j035d3hoc Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094934.5320 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.5350 gsal1d4k7idkg7152j035d3hoc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094934.5450 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.5480 gsal1d4k7idkg7152j035d3hoc Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094934.5590 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.5610 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from td where ndoc = 39
20240429@094934.5710 gsal1d4k7idkg7152j035d3hoc Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094934.5820 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094934.5960 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094934.6220 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094934.6360 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094934.6630 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094934.6780 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094934.6890 gsal1d4k7idkg7152j035d3hoc Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094934.7770 gsal1d4k7idkg7152j035d3hoc Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094934.7870 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094934.8010 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094934.8130 gsal1d4k7idkg7152j035d3hoc Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f585075662f5f1e10' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094934.1020 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094934.1195 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094934.1226 gsal1d4k7idkg7152j035d3hoc Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094934.1233 gsal1d4k7idkg7152j035d3hoc Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094934.1238 gsal1d4k7idkg7152j035d3hoc Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094934.1243 gsal1d4k7idkg7152j035d3hoc Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094934.1248 gsal1d4k7idkg7152j035d3hoc Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094934.1253 gsal1d4k7idkg7152j035d3hoc Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094934.1257 gsal1d4k7idkg7152j035d3hoc Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f585075662f5f1e10',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094934.1495 gsal1d4k7idkg7152j035d3hoc Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094934.1515 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094934.1533 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094934.1553 gsal1d4k7idkg7152j035d3hoc Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f585075662f5f1e10',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1093,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094934.1827 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.1833 gsal1d4k7idkg7152j035d3hoc Query : select st.usalote valor from st where st.ref = '324.4967.00.1'
20240429@094934.1845 gsal1d4k7idkg7152j035d3hoc Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4967.00.1'
20240429@094934.2037 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.2051 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094934.2075 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094934.2087 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094934.2092 gsal1d4k7idkg7152j035d3hoc Query : select sestamp valor from se where ref ='324.4967.00.1' and lote = 'r2300825100a'
20240429@094934.2103 gsal1d4k7idkg7152j035d3hoc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094934.2118 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.2131 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094934.2156 gsal1d4k7idkg7152j035d3hoc Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f555589662f5f1e33',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut662f585075662f5f1e10' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094934.2408 gsal1d4k7idkg7152j035d3hoc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094934.2424 gsal1d4k7idkg7152j035d3hoc Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094934.2429 gsal1d4k7idkg7152j035d3hoc Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f555589662f5f1e33','aut662f585075662f5f1e10' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094934.2433 gsal1d4k7idkg7152j035d3hoc Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f585075662f5f1e10','2403039','wait',39,'ari17112337378,753000005')
20240429@094934.2452 gsal1d4k7idkg7152j035d3hoc Query : use flama_phc
20240429@094934.2455 gsal1d4k7idkg7152j035d3hoc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094934.2466 gsal1d4k7idkg7152j035d3hoc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1388';
20240429@094934.2486 gsal1d4k7idkg7152j035d3hoc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1388';
20240429@094934.2504 gsal1d4k7idkg7152j035d3hoc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1388';
20240429@094934.2520 gsal1d4k7idkg7152j035d3hoc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1388';
20240429@094934.3032 vac8bdplmqt6ra4d4huim5thj7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094934.3052 vac8bdplmqt6ra4d4huim5thj7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094934.3074 vac8bdplmqt6ra4d4huim5thj7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1389';
20240429@094934.3118 vac8bdplmqt6ra4d4huim5thj7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1389';
20240429@094934.3136 vac8bdplmqt6ra4d4huim5thj7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1389';
20240429@094934.3152 vac8bdplmqt6ra4d4huim5thj7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1389';
20240429@094934.3167 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.3170 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094934.3183 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.3186 vac8bdplmqt6ra4d4huim5thj7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094934.3232 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4968.00.1'
20240429@094934.3375 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403040 and bi.ref ='324.4968.00.1' and bi.lordem =1
20240429@094934.3702 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4968.00.1'
20240429@094934.3724 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403040 and bi.ref ='324.4968.00.1' and bi.lordem =1
20240429@094934.3730 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.3734 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094934.3748 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.3751 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094934.3761 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.3764 vac8bdplmqt6ra4d4huim5thj7 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094934.3816 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094934.4926 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.4930 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094934.4941 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.4943 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094934.4954 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.4956 vac8bdplmqt6ra4d4huim5thj7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094934.4967 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.4970 vac8bdplmqt6ra4d4huim5thj7 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094934.4987 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.4990 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from td where ndoc = 39
20240429@094934.5000 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094934.5012 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094934.5026 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094934.5043 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094934.5056 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094934.5083 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094934.5098 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094934.5109 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094934.5231 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094934.5241 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094934.5261 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094934.5270 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f535494662f5f1e7c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094934.5443 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094934.5459 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094934.5492 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094934.5498 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094934.5503 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094934.5508 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094934.5514 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094934.5520 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094934.5524 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f535494662f5f1e7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094934.5754 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094934.5775 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094934.5794 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094934.5813 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f535494662f5f1e7c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1094,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094934.6108 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.6113 vac8bdplmqt6ra4d4huim5thj7 Query : select st.usalote valor from st where st.ref = '324.4968.00.1'
20240429@094934.6126 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4968.00.1'
20240429@094934.6269 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.6283 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094934.6308 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094934.6323 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094934.6327 vac8bdplmqt6ra4d4huim5thj7 Query : select sestamp valor from se where ref ='324.4968.00.1' and lote = 'r2301277100a'
20240429@094934.6340 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094934.6358 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.6371 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094934.6396 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f535731662f5f1e9b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut662f535494662f5f1e7c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094934.6639 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094934.6655 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094934.6660 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f535731662f5f1e9b','aut662f535494662f5f1e7c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094934.6665 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.6669 vac8bdplmqt6ra4d4huim5thj7 Query : select st.usalote valor from st where st.ref = '324.4968.00.1'
20240429@094934.6681 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4968.00.1'
20240429@094934.6692 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.6708 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094934.6734 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094934.6748 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094934.6758 vac8bdplmqt6ra4d4huim5thj7 Query : select sestamp valor from se where ref ='324.4968.00.1' and lote = 'r2301277100a'
20240429@094934.6769 vac8bdplmqt6ra4d4huim5thj7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094934.6779 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.6791 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094934.6813 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f529876662f5f1ea5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',56.000 ,'aut662f535494662f5f1e7c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240429@094934.7056 vac8bdplmqt6ra4d4huim5thj7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094934.7072 vac8bdplmqt6ra4d4huim5thj7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094934.7076 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f529876662f5f1ea5','aut662f535494662f5f1e7c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094934.7081 vac8bdplmqt6ra4d4huim5thj7 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f535494662f5f1e7c','2403040','wait',39,'ari17112337378,753000005')
20240429@094934.7097 vac8bdplmqt6ra4d4huim5thj7 Query : use flama_phc
20240429@094934.7100 vac8bdplmqt6ra4d4huim5thj7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094934.7111 vac8bdplmqt6ra4d4huim5thj7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1389';
20240429@094934.7138 vac8bdplmqt6ra4d4huim5thj7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1389';
20240429@094934.7154 vac8bdplmqt6ra4d4huim5thj7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1389';
20240429@094934.7168 vac8bdplmqt6ra4d4huim5thj7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1389';
20240429@094934.7580 5gh0edc6fsivkmu9gftnvffnpn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094934.7601 5gh0edc6fsivkmu9gftnvffnpn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094934.7631 5gh0edc6fsivkmu9gftnvffnpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1390';
20240429@094934.7675 5gh0edc6fsivkmu9gftnvffnpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1390';
20240429@094934.7693 5gh0edc6fsivkmu9gftnvffnpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1390';
20240429@094934.7708 5gh0edc6fsivkmu9gftnvffnpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1390';
20240429@094934.7724 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.7728 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094934.7741 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.7745 5gh0edc6fsivkmu9gftnvffnpn Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094934.7795 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20240429@094934.7944 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403041 and bi.ref ='324.4988.00.1' and bi.lordem =1
20240429@094934.8273 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8277 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094934.8290 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8293 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094934.8302 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8305 5gh0edc6fsivkmu9gftnvffnpn Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094934.8316 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094934.8330 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8333 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094934.8342 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8345 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094934.8355 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8358 5gh0edc6fsivkmu9gftnvffnpn Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094934.8368 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8371 5gh0edc6fsivkmu9gftnvffnpn Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094934.8382 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.8385 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from td where ndoc = 39
20240429@094934.8395 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094934.8407 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094934.8421 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094934.8438 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094934.8451 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094934.8479 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094934.8492 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094934.8502 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094934.8590 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094934.8599 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094934.8614 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094934.8630 5gh0edc6fsivkmu9gftnvffnpn Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f528782662f5f1ecf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094934.8790 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094934.8806 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094934.8838 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094934.8843 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094934.8850 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094934.8854 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094934.8860 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094934.8864 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094934.8869 5gh0edc6fsivkmu9gftnvffnpn Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f528782662f5f1ecf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094934.9137 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094934.9196 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094934.9210 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094934.9229 5gh0edc6fsivkmu9gftnvffnpn Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f528782662f5f1ecf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1095,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094934.9497 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094934.9501 5gh0edc6fsivkmu9gftnvffnpn Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20240429@094934.9515 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4988.00.1'
20240429@094934.9655 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.9670 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094934.9703 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094934.9718 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094934.9723 5gh0edc6fsivkmu9gftnvffnpn Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100743100a'
20240429@094934.9750 5gh0edc6fsivkmu9gftnvffnpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094934.9762 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094934.9777 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094934.9805 5gh0edc6fsivkmu9gftnvffnpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f560026662f5f1eee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',52.000 ,'aut662f528782662f5f1ecf' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094935.6100 5gh0edc6fsivkmu9gftnvffnpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094935.1030 5gh0edc6fsivkmu9gftnvffnpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094935.1070 5gh0edc6fsivkmu9gftnvffnpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f560026662f5f1eee','aut662f528782662f5f1ecf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094935.1120 5gh0edc6fsivkmu9gftnvffnpn Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f528782662f5f1ecf','2403041','wait',39,'ari17112337378,753000005')
20240429@094935.1300 5gh0edc6fsivkmu9gftnvffnpn Query : use flama_phc
20240429@094935.1330 5gh0edc6fsivkmu9gftnvffnpn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094935.1440 5gh0edc6fsivkmu9gftnvffnpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1390';
20240429@094935.1680 5gh0edc6fsivkmu9gftnvffnpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1390';
20240429@094935.1850 5gh0edc6fsivkmu9gftnvffnpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1390';
20240429@094935.2000 5gh0edc6fsivkmu9gftnvffnpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1390';
20240429@094935.6300 vfk8v4gbo47fuu5h2p70kack8p Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094935.6490 vfk8v4gbo47fuu5h2p70kack8p Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094935.6730 vfk8v4gbo47fuu5h2p70kack8p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1391';
20240429@094935.7260 vfk8v4gbo47fuu5h2p70kack8p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1391';
20240429@094935.7450 vfk8v4gbo47fuu5h2p70kack8p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1391';
20240429@094935.7610 vfk8v4gbo47fuu5h2p70kack8p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1391';
20240429@094935.7760 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.7800 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094935.7960 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.7990 vfk8v4gbo47fuu5h2p70kack8p Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240429@094935.8380 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.736.00.01'
20240429@094935.9780 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403042 and bi.ref ='324.736.00.01' and bi.lordem =1
20240429@094935.1357 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.736.00.01'
20240429@094935.1372 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403042 and bi.ref ='324.736.00.01' and bi.lordem =1
20240429@094935.1378 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.736.00.01'
20240429@094935.1390 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403042 and bi.ref ='324.736.00.01' and bi.lordem =1
20240429@094935.1396 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1400 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094935.1418 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1421 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094935.1433 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1437 vfk8v4gbo47fuu5h2p70kack8p Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094935.1450 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094935.1466 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1470 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240429@094935.1480 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1483 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094935.1493 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1496 vfk8v4gbo47fuu5h2p70kack8p Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094935.1506 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1510 vfk8v4gbo47fuu5h2p70kack8p Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240429@094935.1522 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.1525 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from td where ndoc = 39
20240429@094935.1535 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094935.1546 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094935.1560 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094935.1577 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094935.1591 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094935.1619 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094935.1632 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094935.1642 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094935.1736 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094935.1745 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094935.1758 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094935.1767 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f569280662f5f1f28' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094935.1929 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094935.1944 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094935.1972 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094935.1977 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094935.1981 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094935.1986 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094935.1991 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094935.1996 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094935.2000 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f569280662f5f1f28',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094935.2235 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094935.2254 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094935.2268 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094935.2289 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f569280662f5f1f28',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1096,100810,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094935.2628 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.2632 vfk8v4gbo47fuu5h2p70kack8p Query : select st.usalote valor from st where st.ref = '324.736.00.01'
20240429@094935.2645 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.736.00.01'
20240429@094935.2899 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094935.2915 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094935.2958 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094935.2982 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094935.2987 vfk8v4gbo47fuu5h2p70kack8p Query : select sestamp valor from se where ref ='324.736.00.01' and lote = 'r2100297200a'
20240429@094935.3009 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094935.3020 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094935.3033 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094935.3055 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f561970662f5f1f49',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',52.000 ,'aut662f569280662f5f1f28' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240429@094935.3319 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094935.3335 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094935.3340 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f561970662f5f1f49','aut662f569280662f5f1f28' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094935.3344 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.3347 vfk8v4gbo47fuu5h2p70kack8p Query : select st.usalote valor from st where st.ref = '324.736.00.01'
20240429@094935.3360 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.736.00.01'
20240429@094935.3372 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094935.3385 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094935.3412 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094935.3467 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094935.3509 vfk8v4gbo47fuu5h2p70kack8p Query : select sestamp valor from se where ref ='324.736.00.01' and lote = 'r2100297200a'
20240429@094935.3520 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094935.3529 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094935.3544 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094935.3569 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f557374662f5f1f56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut662f569280662f5f1f28' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240429@094935.3923 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094935.3963 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094935.4044 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f557374662f5f1f56','aut662f569280662f5f1f28' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094935.4050 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.4054 vfk8v4gbo47fuu5h2p70kack8p Query : select st.usalote valor from st where st.ref = '324.736.00.01'
20240429@094935.4065 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.736.00.01'
20240429@094935.4077 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094935.4129 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240429@094935.4154 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094935.4167 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240429@094935.4171 vfk8v4gbo47fuu5h2p70kack8p Query : select sestamp valor from se where ref ='324.736.00.01' and lote = 'r2100297200a'
20240429@094935.4180 vfk8v4gbo47fuu5h2p70kack8p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240429@094935.4189 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240429@094935.4201 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240429@094935.4224 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662f526379662f5f1f66',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',100.000 ,'aut662f569280662f5f1f28' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240429@094935.4470 vfk8v4gbo47fuu5h2p70kack8p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240429@094935.4532 vfk8v4gbo47fuu5h2p70kack8p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240429@094935.4538 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662f526379662f5f1f66','aut662f569280662f5f1f28' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240429@094935.4544 vfk8v4gbo47fuu5h2p70kack8p Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662f569280662f5f1f28','2403042','wait',39,'ari17112337378,753000005')
20240429@094935.4637 vfk8v4gbo47fuu5h2p70kack8p Query : use flama_phc
20240429@094935.4641 vfk8v4gbo47fuu5h2p70kack8p Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240429@094935.4654 vfk8v4gbo47fuu5h2p70kack8p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1391';
20240429@094935.4675 vfk8v4gbo47fuu5h2p70kack8p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1391';
20240429@094935.4692 vfk8v4gbo47fuu5h2p70kack8p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1391';
20240429@094935.4708 vfk8v4gbo47fuu5h2p70kack8p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1391';
20240429@094935.5114 g1ne7uua62sahib00r5d2eehhf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240429@094935.5128 g1ne7uua62sahib00r5d2eehhf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240429@094935.5150 g1ne7uua62sahib00r5d2eehhf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1392';
20240429@094935.5291 g1ne7uua62sahib00r5d2eehhf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1392';
20240429@094935.5399 g1ne7uua62sahib00r5d2eehhf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1392';
20240429@094935.5430 g1ne7uua62sahib00r5d2eehhf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1392';
20240429@094935.5451 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.5455 g1ne7uua62sahib00r5d2eehhf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240429@094935.5470 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.5473 g1ne7uua62sahib00r5d2eehhf Query : select no, estab,szadrsdesc from szadrs where u_coddest=4804
20240429@094935.5634 g1ne7uua62sahib00r5d2eehhf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240429@094935.5870 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403044 and bi.ref ='304.421.00.04' and bi.lordem =1
20240429@094935.6236 g1ne7uua62sahib00r5d2eehhf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240429@094935.6388 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2030 and bo.obrano = 2403044 and bi.ref ='324.4960.00.1' and bi.lordem =2
20240429@094935.6743 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.6748 g1ne7uua62sahib00r5d2eehhf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240429@094935.6763 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.6766 g1ne7uua62sahib00r5d2eehhf Query : select top 1 1 valor from td where td.ndoc = 39
20240429@094935.6778 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.6781 g1ne7uua62sahib00r5d2eehhf Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240429@094935.6793 g1ne7uua62sahib00r5d2eehhf Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240429@094935.6808 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.6812 g1ne7uua62sahib00r5d2eehhf Query : select top 1 ~inactivo valor from cl where no = '101900' and estab = 0 order by inactivo desc
20240429@094935.6956 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.6960 g1ne7uua62sahib00r5d2eehhf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240429@094935.6971 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.6974 g1ne7uua62sahib00r5d2eehhf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240429@094935.6985 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.6988 g1ne7uua62sahib00r5d2eehhf Query : select szadrsstamp valor from szadrs where szadrsdesc='101900 - pd - alfena n/p'
20240429@094935.7001 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.7004 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from td where ndoc = 39
20240429@094935.7015 g1ne7uua62sahib00r5d2eehhf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240429@094935.7028 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094935.7042 g1ne7uua62sahib00r5d2eehhf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240429@094935.7060 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094935.7076 g1ne7uua62sahib00r5d2eehhf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240429@094935.7107 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094935.7121 g1ne7uua62sahib00r5d2eehhf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240429@094935.7132 g1ne7uua62sahib00r5d2eehhf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094935.7226 g1ne7uua62sahib00r5d2eehhf Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240429@094935.7236 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240429@094935.7250 g1ne7uua62sahib00r5d2eehhf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240429@094935.7259 g1ne7uua62sahib00r5d2eehhf Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662f564557662f5f1fae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240429@094935.7451 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240429@094935.7469 g1ne7uua62sahib00r5d2eehhf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240429@094935.7505 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240429@094935.7510 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240429@094935.7515 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240429@094935.7520 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240429@094935.7524 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240429@094935.7530 g1ne7uua62sahib00r5d2eehhf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240429@094935.7534 g1ne7uua62sahib00r5d2eehhf Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662f564557662f5f1fae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240429@094935.7790 g1ne7uua62sahib00r5d2eehhf Query : select top 1 fno valor from wsft039data order by fno desc
20240429@094935.7823 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240429@094935.7841 g1ne7uua62sahib00r5d2eehhf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240429@094935.7862 g1ne7uua62sahib00r5d2eehhf Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662f564557662f5f1fae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1097,101900,0,'2024-04-29',39,'euro',0,0,2024 ,'20240429','1019',?,?,?,?)
20240429@094935.8184 g1ne7uua62sahib00r5d2eehhf Query : use flama_phc
20240429@094935.8188 g1ne7uua62sahib00r5d2eehhf Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240429@094935.8227 g1ne7uua62sahib00r5d2eehhf Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240429@094935.8378 g1ne7uua62sahib00r5d2eehhf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
