20240730@191840.1229 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2000.94.1'
20240730@191840.1378 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405072 and bi.ref ='324.2000.94.1' and bi.lordem =4
20240730@191840.1717 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.900.94.01'
20240730@191840.1868 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405072 and bi.ref ='324.900.94.01' and bi.lordem =5
20240730@191840.2177 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2181 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240730@191840.2216 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2219 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 1 valor from td where td.ndoc = 39
20240730@191840.2250 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2253 tk00fvrmbk4vlbf3afg3ochja7 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240730@191840.2281 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240730@191840.2321 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2324 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 ~inactivo valor from cl where no = '199800' and estab = 0 order by inactivo desc
20240730@191840.2449 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2452 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240730@191840.2485 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2489 tk00fvrmbk4vlbf3afg3ochja7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240730@191840.2530 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2533 tk00fvrmbk4vlbf3afg3ochja7 Query : select szadrsstamp valor from szadrs where szadrsdesc='740 ent vnr bligeiro'
20240730@191840.2583 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.2586 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from td where ndoc = 39
20240730@191840.2599 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240730@191840.2614 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.2631 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240730@191840.2654 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.2670 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240730@191840.2703 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.2720 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240730@191840.2737 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240730@191840.2815 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240730@191840.2831 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.2848 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240730@191840.2866 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240730@191840.3043 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.3062 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240730@191840.3098 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240730@191840.3111 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240730@191840.3124 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240730@191840.3138 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240730@191840.3151 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240730@191840.3168 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240730@191840.3182 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a926950066a92e8042',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240730@191840.3468 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 fno valor from wsftdata order by fno desc
20240730@191840.3627 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.3645 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240730@191840.3672 tk00fvrmbk4vlbf3afg3ochja7 Query : select 'normal' from dummy
20240730@191840.3689 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a926950066a92e8042',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',106,199800,0,'2024-07-30',39,'euro',0,0,2024 ,?,?)
20240730@191840.3991 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.3994 tk00fvrmbk4vlbf3afg3ochja7 Query : select st.usalote valor from st where st.ref = '324.700.94.01'
20240730@191840.4020 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.700.94.01'
20240730@191840.4170 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4188 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.4217 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4232 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.4242 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191840.4259 tk00fvrmbk4vlbf3afg3ochja7 Query : select sestamp valor from se where ref ='324.700.94.01' and lote = 'r2300913100a'
20240730@191840.4275 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4292 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.4305 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a920770666a92e8068','aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191840.4311 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4328 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.4368 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a920770666a92e8068',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28.000 ,'aut66a926950066a92e8042' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240730@191840.4636 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.4640 tk00fvrmbk4vlbf3afg3ochja7 Query : select st.usalote valor from st where st.ref = '324.2200.94.1'
20240730@191840.4667 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2200.94.1'
20240730@191840.4812 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4831 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.4859 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4875 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.4888 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191840.4902 tk00fvrmbk4vlbf3afg3ochja7 Query : select sestamp valor from se where ref ='324.2200.94.1' and lote = 'r2400046200a'
20240730@191840.4918 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4935 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.4949 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a920060766a92e8078','aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191840.4955 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.4980 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.5014 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a920060766a92e8078',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66a926950066a92e8042' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240730@191840.5271 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.5274 tk00fvrmbk4vlbf3afg3ochja7 Query : select st.usalote valor from st where st.ref = '324.2200.94.1'
20240730@191840.5294 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2200.94.1'
20240730@191840.5310 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.5327 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.5423 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.5533 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.5805 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191840.5901 tk00fvrmbk4vlbf3afg3ochja7 Query : select sestamp valor from se where ref ='324.2200.94.1' and lote = 'r2400046200a'
20240730@191840.6014 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.6035 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.6095 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a924776966a92e8092','aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191840.6109 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.6313 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.6484 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a924776966a92e8092',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut66a926950066a92e8042' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240730@191840.6824 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.7005 tk00fvrmbk4vlbf3afg3ochja7 Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20240730@191840.7303 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.600.94.01'
20240730@191840.7453 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.7470 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.7495 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.7511 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.7519 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191840.7531 tk00fvrmbk4vlbf3afg3ochja7 Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20240730@191840.7545 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.7564 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.7576 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a929327666a92e80b8','aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191840.7580 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.7594 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.7621 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a929327666a92e80b8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66a926950066a92e8042' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240730@191840.7880 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.7897 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.7923 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.7938 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.7947 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191840.7959 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.7975 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.7987 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a927083666a92e80c2','aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191840.7991 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.8006 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.8038 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a927083666a92e80c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a926950066a92e8042' ,0,0 ,2,23.00,50000,?,?,?)
20240730@191840.8321 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.8325 tk00fvrmbk4vlbf3afg3ochja7 Query : select st.usalote valor from st where st.ref = '324.2000.94.1'
20240730@191840.8346 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2000.94.1'
20240730@191840.8688 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.8706 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.8734 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.8749 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.8758 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191840.8771 tk00fvrmbk4vlbf3afg3ochja7 Query : select sestamp valor from se where ref ='324.2000.94.1' and lote = 'r2300916200a'
20240730@191840.8788 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.8803 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.8815 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a926445666a92e80d6','aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191840.8819 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.8833 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.8862 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a926445666a92e80d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut66a926950066a92e8042' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240730@191840.9116 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.9120 tk00fvrmbk4vlbf3afg3ochja7 Query : select st.usalote valor from st where st.ref = '324.900.94.01'
20240730@191840.9145 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.900.94.01'
20240730@191840.9290 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.9309 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.9339 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.9359 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.9370 tk00fvrmbk4vlbf3afg3ochja7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191840.9385 tk00fvrmbk4vlbf3afg3ochja7 Query : select sestamp valor from se where ref ='324.900.94.01' and lote = 'r2300952200a'
20240730@191840.9439 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.9457 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191840.9472 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a923350666a92e80e6','aut66a926950066a92e8042' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191840.9476 tk00fvrmbk4vlbf3afg3ochja7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191840.9496 tk00fvrmbk4vlbf3afg3ochja7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191840.9531 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a923350666a92e80e6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',44.000 ,'aut66a926950066a92e8042' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240730@191840.9800 tk00fvrmbk4vlbf3afg3ochja7 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a926950066a92e8042','2405072','wait',39,'adm09112754980.682000002')
20240730@191840.9883 tk00fvrmbk4vlbf3afg3ochja7 Query : use flama_phc
20240730@191840.9887 tk00fvrmbk4vlbf3afg3ochja7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240730@191840.9920 tk00fvrmbk4vlbf3afg3ochja7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1266';
20240730@191840.9948 tk00fvrmbk4vlbf3afg3ochja7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1266';
20240730@191840.9984 tk00fvrmbk4vlbf3afg3ochja7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1266';
20240730@191841.9000 tk00fvrmbk4vlbf3afg3ochja7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1266';
20240730@191841.7070 ntjj3qfa602f24caj14meatm12 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240730@191841.7190 ntjj3qfa602f24caj14meatm12 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240730@191841.7790 ntjj3qfa602f24caj14meatm12 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1267';
20240730@191841.8310 ntjj3qfa602f24caj14meatm12 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1267';
20240730@191841.8810 ntjj3qfa602f24caj14meatm12 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1267';
20240730@191841.9070 ntjj3qfa602f24caj14meatm12 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1267';
20240730@191841.9560 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.9600 ntjj3qfa602f24caj14meatm12 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240730@191841.1037 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.1041 ntjj3qfa602f24caj14meatm12 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1743
20240730@191841.1132 ntjj3qfa602f24caj14meatm12 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'
20240730@191841.1161 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='304.421.00.04' and bi.lordem =1
20240730@191841.2672 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4860.00.1'
20240730@191841.2849 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='304.4860.00.1' and bi.lordem =3
20240730@191841.3233 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240730@191841.3610 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='324.5396.00.1' and bi.lordem =4
20240730@191841.3947 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20240730@191841.4104 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='324.2232.00.1' and bi.lordem =6
20240730@191841.4426 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1578.00.1'
20240730@191841.4580 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='324.1578.00.1' and bi.lordem =8
20240730@191841.4913 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1896.00.1'
20240730@191841.5076 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='324.1896.00.1' and bi.lordem =10
20240730@191841.5410 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1896.00.1'
20240730@191841.5434 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='324.1896.00.1' and bi.lordem =10
20240730@191841.5454 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20240730@191841.5619 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='324.1608.00.1' and bi.lordem =12
20240730@191841.6915 ntjj3qfa602f24caj14meatm12 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20240730@191841.7078 ntjj3qfa602f24caj14meatm12 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405080 and bi.ref ='324.969.00.01' and bi.lordem =13
20240730@191841.7399 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7404 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240730@191841.7441 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7445 ntjj3qfa602f24caj14meatm12 Query : select top 1 1 valor from td where td.ndoc = 39
20240730@191841.7480 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7484 ntjj3qfa602f24caj14meatm12 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240730@191841.7522 ntjj3qfa602f24caj14meatm12 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240730@191841.7561 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7564 ntjj3qfa602f24caj14meatm12 Query : select top 1 ~inactivo valor from cl where no = '102366' and estab = 0 order by inactivo desc
20240730@191841.7691 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7694 ntjj3qfa602f24caj14meatm12 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240730@191841.7727 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7731 ntjj3qfa602f24caj14meatm12 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240730@191841.7775 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7778 ntjj3qfa602f24caj14meatm12 Query : select szadrsstamp valor from szadrs where szadrsdesc='polo electrodomÉsticos, lda.'
20240730@191841.7832 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.7875 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from td where ndoc = 39
20240730@191841.8035 ntjj3qfa602f24caj14meatm12 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240730@191841.8054 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.8075 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240730@191841.8099 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.8117 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240730@191841.8153 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.8174 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240730@191841.8190 ntjj3qfa602f24caj14meatm12 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240730@191841.8264 ntjj3qfa602f24caj14meatm12 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240730@191841.8280 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.8299 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240730@191841.8318 ntjj3qfa602f24caj14meatm12 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240730@191841.8497 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.8518 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240730@191841.8561 ntjj3qfa602f24caj14meatm12 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240730@191841.8577 ntjj3qfa602f24caj14meatm12 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240730@191841.8593 ntjj3qfa602f24caj14meatm12 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240730@191841.8610 ntjj3qfa602f24caj14meatm12 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240730@191841.8627 ntjj3qfa602f24caj14meatm12 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240730@191841.8642 ntjj3qfa602f24caj14meatm12 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240730@191841.8657 ntjj3qfa602f24caj14meatm12 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a920888766a92e81c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240730@191841.8898 ntjj3qfa602f24caj14meatm12 Query : select top 1 fno valor from wsftdata order by fno desc
20240730@191841.8919 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.8939 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240730@191841.8966 ntjj3qfa602f24caj14meatm12 Query : select 'normal' from dummy
20240730@191841.8985 ntjj3qfa602f24caj14meatm12 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a920888766a92e81c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',107,102366,0,'2024-07-30',39,'euro',0,0,2024 ,?,?)
20240730@191841.9278 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191841.9283 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240730@191841.9313 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240730@191841.9333 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9353 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191841.9383 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9408 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191841.9418 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191841.9438 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240896'
20240730@191841.9452 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9468 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191841.9480 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a923073866a92e81e6','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191841.9484 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9499 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191841.9529 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a923073866a92e81e6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240730@191841.9807 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9826 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191841.9856 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9871 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191841.9879 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191841.9892 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9908 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191841.9920 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a925250666a92e81f1','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191841.9924 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191841.9939 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191841.9968 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a925250666a92e81f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,20000,?,?,?)
20240730@191842.2270 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.2300 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '304.4860.00.1'
20240730@191842.2510 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4860.00.1'
20240730@191842.3960 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4250 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.4520 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4670 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.4750 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.4880 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='304.4860.00.1' and lote = '241006'
20240730@191842.5080 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.5250 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.5380 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a926289166a92e820c','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.5420 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.5570 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.5870 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a926289166a92e820c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240730@191842.8610 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.9040 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240730@191842.2014 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5396.00.1'
20240730@191842.2164 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2181 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.2207 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2222 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.2231 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.2244 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240730@191842.2258 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2275 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.2288 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a922112666a92e8237','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.2293 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2310 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.2343 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a922112666a92e8237',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240730@191842.2618 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2636 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.2662 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2677 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.2686 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.2699 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2714 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.2726 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a927443166a92e8241','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.2730 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.2745 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.2776 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a927443166a92e8241',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,60000,?,?,?)
20240730@191842.3059 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.3101 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '324.2232.00.1'
20240730@191842.3280 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2232.00.1'
20240730@191842.3451 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.3468 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.3496 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.3511 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.3519 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.3532 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='324.2232.00.1' and lote = 'r2400241100a'
20240730@191842.3547 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.3561 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.3573 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a928869966a92e8256','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.3577 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.3592 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.3623 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a928869966a92e8256',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240730@191842.3905 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.3908 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '324.1578.00.1'
20240730@191842.3931 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1578.00.1'
20240730@191842.4079 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4096 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.4126 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4143 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.4152 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.4165 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='324.1578.00.1' and lote = 'r2100121100a'
20240730@191842.4192 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4208 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.4220 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a922720466a92e8266','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.4224 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4243 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.4274 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a922720466a92e8266',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20240730@191842.4530 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.4534 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '324.1896.00.1'
20240730@191842.4556 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1896.00.1'
20240730@191842.4706 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4724 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.4751 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4767 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.4776 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.4788 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='324.1896.00.1' and lote = 'r2101190100a'
20240730@191842.4810 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4825 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.4837 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a928332166a92e8275','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.4841 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.4856 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.4886 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a928332166a92e8275',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240730@191842.5134 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.5137 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '324.1896.00.1'
20240730@191842.5157 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1896.00.1'
20240730@191842.5170 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.5186 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.5214 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.5228 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.5237 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.5249 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='324.1896.00.1' and lote = 'r2101190100a'
20240730@191842.5261 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.5276 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.5287 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a923143966a92e8280','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.5291 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.5305 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.5333 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a923143966a92e8280',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20240730@191842.6067 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.6072 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20240730@191842.6093 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1608.00.1'
20240730@191842.6255 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.6272 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.6297 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.6312 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.6320 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.6332 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2200658200a'
20240730@191842.6354 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.6369 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.6380 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a923263466a92e829b','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.6384 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.6398 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.6423 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a923263466a92e829b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20240730@191842.6700 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.6703 ntjj3qfa602f24caj14meatm12 Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20240730@191842.6803 ntjj3qfa602f24caj14meatm12 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.969.00.01'
20240730@191842.7124 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.7141 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.7167 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.7181 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.7189 ntjj3qfa602f24caj14meatm12 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191842.7201 ntjj3qfa602f24caj14meatm12 Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20240730@191842.7214 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.7228 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191842.7240 ntjj3qfa602f24caj14meatm12 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a927881666a92e82b0','aut66a920888766a92e81c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191842.7244 ntjj3qfa602f24caj14meatm12 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191842.7261 ntjj3qfa602f24caj14meatm12 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191842.7289 ntjj3qfa602f24caj14meatm12 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a927881666a92e82b0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a920888766a92e81c7' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240730@191842.7552 ntjj3qfa602f24caj14meatm12 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a920888766a92e81c7','2405080','wait',39,'adm09112754980.682000002')
20240730@191842.7622 ntjj3qfa602f24caj14meatm12 Query : use flama_phc
20240730@191842.7625 ntjj3qfa602f24caj14meatm12 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240730@191842.7661 ntjj3qfa602f24caj14meatm12 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1267';
20240730@191842.7687 ntjj3qfa602f24caj14meatm12 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1267';
20240730@191842.7724 ntjj3qfa602f24caj14meatm12 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1267';
20240730@191842.7747 ntjj3qfa602f24caj14meatm12 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1267';
20240730@191842.8372 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240730@191842.8384 gh6ik7q8nck2r9mmi5remr9tc0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240730@191842.8435 gh6ik7q8nck2r9mmi5remr9tc0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1268';
20240730@191842.8490 gh6ik7q8nck2r9mmi5remr9tc0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1268';
20240730@191842.8539 gh6ik7q8nck2r9mmi5remr9tc0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1268';
20240730@191842.8565 gh6ik7q8nck2r9mmi5remr9tc0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1268';
20240730@191842.8611 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191842.8614 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240730@191842.8679 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191842.8682 gh6ik7q8nck2r9mmi5remr9tc0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2136
20240730@191842.8762 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1705.00.1'
20240730@191842.8926 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405092 and bi.ref ='324.1705.00.1' and bi.lordem =1
20240730@191842.9239 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240730@191842.9389 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405092 and bi.ref ='324.1676.00.1' and bi.lordem =2
20240730@191842.9720 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191842.9723 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240730@191842.9760 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191842.9763 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 1 valor from td where td.ndoc = 39
20240730@191842.9796 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191842.9799 gh6ik7q8nck2r9mmi5remr9tc0 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240730@191842.9829 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240730@191842.9867 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191842.9870 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 ~inactivo valor from cl where no = '102415' and estab = 0 order by inactivo desc
20240730@191843.5000 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191843.8000 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240730@191843.9700 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191843.5830 gh6ik7q8nck2r9mmi5remr9tc0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240730@191843.1237 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191843.1240 gh6ik7q8nck2r9mmi5remr9tc0 Query : select szadrsstamp valor from szadrs where szadrsdesc='filipe ventura electrodomÉsticos unipessoal lda'
20240730@191843.1288 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191843.1290 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from td where ndoc = 39
20240730@191843.1303 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240730@191843.1317 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.1440 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240730@191843.1459 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.1474 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240730@191843.1504 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.1518 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240730@191843.1531 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240730@191843.1602 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240730@191843.1615 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.1632 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240730@191843.1648 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a922563966a92e8325' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240730@191843.1839 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.1858 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240730@191843.1892 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240730@191843.1907 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240730@191843.1919 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240730@191843.1932 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240730@191843.1944 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240730@191843.1957 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240730@191843.1969 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a922563966a92e8325',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240730@191843.2443 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 fno valor from wsftdata order by fno desc
20240730@191843.2460 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.2480 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240730@191843.2504 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 'normal' from dummy
20240730@191843.2519 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a922563966a92e8325',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',108,102415,0,'2024-07-30',39,'euro',0,0,2024 ,?,?)
20240730@191843.2817 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191843.2820 gh6ik7q8nck2r9mmi5remr9tc0 Query : select st.usalote valor from st where st.ref = '324.1705.00.1'
20240730@191843.2843 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1705.00.1'
20240730@191843.2998 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3015 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191843.3041 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3055 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191843.3064 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191843.3076 gh6ik7q8nck2r9mmi5remr9tc0 Query : select sestamp valor from se where ref ='324.1705.00.1' and lote = 'r2400050500a'
20240730@191843.3089 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3103 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191843.3115 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a926519566a92e834b','aut66a922563966a92e8325' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191843.3119 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3136 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191843.3167 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a926519566a92e834b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a922563966a92e8325' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240730@191843.3428 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191843.3431 gh6ik7q8nck2r9mmi5remr9tc0 Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20240730@191843.3452 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1676.00.1'
20240730@191843.3602 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3619 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191843.3644 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3659 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191843.3667 gh6ik7q8nck2r9mmi5remr9tc0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240730@191843.3679 gh6ik7q8nck2r9mmi5remr9tc0 Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20240730@191843.3693 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3707 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240730@191843.3719 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a920268966a92e835a','aut66a922563966a92e8325' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240730@191843.3723 gh6ik7q8nck2r9mmi5remr9tc0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240730@191843.3738 gh6ik7q8nck2r9mmi5remr9tc0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240730@191843.3768 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a920268966a92e835a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut66a922563966a92e8325' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240730@191843.4023 gh6ik7q8nck2r9mmi5remr9tc0 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a922563966a92e8325','2405092','wait',39,'adm09112754980.682000002')
20240730@191843.4099 gh6ik7q8nck2r9mmi5remr9tc0 Query : use flama_phc
20240730@191843.4102 gh6ik7q8nck2r9mmi5remr9tc0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240730@191843.4146 gh6ik7q8nck2r9mmi5remr9tc0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1268';
20240730@191843.4171 gh6ik7q8nck2r9mmi5remr9tc0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1268';
20240730@191843.4210 gh6ik7q8nck2r9mmi5remr9tc0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1268';
20240730@191843.4233 gh6ik7q8nck2r9mmi5remr9tc0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1268';

20240731@080305.1713 p5gq82cg4fcn6as06h3nob90av Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1269';
20240731@080305.1892 p5gq82cg4fcn6as06h3nob90av Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1269';
20240731@080305.1917 p5gq82cg4fcn6as06h3nob90av Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1269';
20240731@080305.1999 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.2003 p5gq82cg4fcn6as06h3nob90av Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240731@080305.2294 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.2298 p5gq82cg4fcn6as06h3nob90av Query : select no, estab,szadrsdesc from szadrs where u_coddest=170
20240731@080305.2422 p5gq82cg4fcn6as06h3nob90av Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240731@080305.2601 p5gq82cg4fcn6as06h3nob90av Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240731@080305.2625 p5gq82cg4fcn6as06h3nob90av Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240731@080305.2813 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.2816 p5gq82cg4fcn6as06h3nob90av Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240731@080305.3088 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.3092 p5gq82cg4fcn6as06h3nob90av Query : select top 1 1 valor from td where td.ndoc = 39
20240731@080305.3221 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.3224 p5gq82cg4fcn6as06h3nob90av Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240731@080305.3314 p5gq82cg4fcn6as06h3nob90av Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240731@080305.3541 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.3544 p5gq82cg4fcn6as06h3nob90av Query : select top 1 ~inactivo valor from cl where no = '102068' and estab = 0 order by inactivo desc
20240731@080305.3704 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.3708 p5gq82cg4fcn6as06h3nob90av Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240731@080305.3825 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.3829 p5gq82cg4fcn6as06h3nob90av Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240731@080305.3908 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.3912 p5gq82cg4fcn6as06h3nob90av Query : select szadrsstamp valor from szadrs where szadrsdesc='magalhÃes & vinha, lda.'
20240731@080305.3962 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080305.3965 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from td where ndoc = 39
20240731@080305.4054 p5gq82cg4fcn6as06h3nob90av Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240731@080305.4124 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080305.4496 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@080305.5111 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080305.5145 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@080305.5197 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080305.5215 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@080305.5243 p5gq82cg4fcn6as06h3nob90av Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@080305.5592 p5gq82cg4fcn6as06h3nob90av Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240731@080305.5691 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080305.5709 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240731@080305.5766 p5gq82cg4fcn6as06h3nob90av Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a9e5881766a9e1a980' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240731@080305.6867 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080305.6896 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240731@080305.6937 p5gq82cg4fcn6as06h3nob90av Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240731@080305.7052 p5gq82cg4fcn6as06h3nob90av Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240731@080305.7149 p5gq82cg4fcn6as06h3nob90av Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240731@080305.7244 p5gq82cg4fcn6as06h3nob90av Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240731@080305.7337 p5gq82cg4fcn6as06h3nob90av Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240731@080305.7424 p5gq82cg4fcn6as06h3nob90av Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240731@080305.7518 p5gq82cg4fcn6as06h3nob90av Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a9e5881766a9e1a980',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240731@080305.8536 p5gq82cg4fcn6as06h3nob90av Query : select top 1 fno valor from wsftdata order by fno desc
20240731@080305.9381 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080306.3000 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240731@080306.7080 p5gq82cg4fcn6as06h3nob90av Query : select 'normal' from dummy
20240731@080306.7660 p5gq82cg4fcn6as06h3nob90av Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a9e5881766a9e1a980',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',109,102068,0,'2024-07-31',39,'euro',0,0,2024 ,?,?)
20240731@080306.3888 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080306.3902 p5gq82cg4fcn6as06h3nob90av Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240731@080306.4159 p5gq82cg4fcn6as06h3nob90av Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240731@080306.4413 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080306.4524 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080306.4624 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080306.4641 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080306.4654 p5gq82cg4fcn6as06h3nob90av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@080306.4775 p5gq82cg4fcn6as06h3nob90av Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240731@080306.4974 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080306.5313 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080306.5329 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a9e8080866a9e1aa79','aut66a9e5881766a9e1a980' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@080306.5542 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080306.5651 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080306.5693 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66a9e8080866a9e1aa79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a9e5881766a9e1a980' ,0,0 ,2,23.00,10000,?,?,?,?)
20240731@080306.9757 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1030 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.3920 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.4130 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.4250 p5gq82cg4fcn6as06h3nob90av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@080307.4400 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.4590 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.4740 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a9e6979866a9e1ab0a','aut66a9e5881766a9e1a980' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@080307.4800 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.5120 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.5480 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a9e6979866a9e1ab0a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a9e5881766a9e1a980' ,0,0 ,2,23.00,20000,?,?,?)
20240731@080307.9600 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080307.9640 p5gq82cg4fcn6as06h3nob90av Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240731@080307.9880 p5gq82cg4fcn6as06h3nob90av Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240731@080307.1004 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1024 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.1053 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1074 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.1085 p5gq82cg4fcn6as06h3nob90av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@080307.1101 p5gq82cg4fcn6as06h3nob90av Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301210200a'
20240731@080307.1117 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1136 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.1150 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a9e4318266a9e1ab1b','aut66a9e5881766a9e1a980' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@080307.1156 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1379 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.1418 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66a9e4318266a9e1ab1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a9e5881766a9e1a980' ,0,0 ,2,23.00,40000,?,?,?,?)
20240731@080307.1764 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1785 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.1820 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1838 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.1849 p5gq82cg4fcn6as06h3nob90av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@080307.1864 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.1884 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.2056 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a9e4135866a9e1ab2d','aut66a9e5881766a9e1a980' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@080307.2095 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.2115 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.2154 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a9e4135866a9e1ab2d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a9e5881766a9e1a980' ,0,0 ,2,23.00,50000,?,?,?)
20240731@080307.2443 p5gq82cg4fcn6as06h3nob90av Query : use flama_phc
20240731@080307.2447 p5gq82cg4fcn6as06h3nob90av Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240731@080307.2473 p5gq82cg4fcn6as06h3nob90av Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20240731@080307.2636 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.2656 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.2687 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.2704 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.2715 p5gq82cg4fcn6as06h3nob90av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@080307.2729 p5gq82cg4fcn6as06h3nob90av Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2300643200a'
20240731@080307.2744 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.2762 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.2775 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a9e0165266a9e1ab43','aut66a9e5881766a9e1a980' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@080307.2780 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.2797 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.2840 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66a9e0165266a9e1ab43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a9e5881766a9e1a980' ,0,0 ,2,23.00,70000,?,?,?,?)
20240731@080307.3143 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.3163 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.3192 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.3208 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.3217 p5gq82cg4fcn6as06h3nob90av Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240731@080307.3231 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.3247 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240731@080307.3258 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a9e6767466a9e1ab4e','aut66a9e5881766a9e1a980' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240731@080307.3263 p5gq82cg4fcn6as06h3nob90av Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240731@080307.3282 p5gq82cg4fcn6as06h3nob90av Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240731@080307.3308 p5gq82cg4fcn6as06h3nob90av Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a9e6767466a9e1ab4e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a9e5881766a9e1a980' ,0,0 ,2,23.00,80000,?,?,?)
20240731@080307.3599 p5gq82cg4fcn6as06h3nob90av Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a9e5881766a9e1a980','2405103','wait',39,'adm09112754980.682000002')
