20241029@181922.9710 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181922.9930 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407081 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241029@181922.1020 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1025 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241029@181922.1090 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1094 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 1 valor from td where td.ndoc = 39
20241029@181922.1217 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1221 4kmohhtuj2e0tkd5eqifvr68i0 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')
20241029@181922.1250 4kmohhtuj2e0tkd5eqifvr68i0 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
20241029@181922.1286 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1290 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241029@181922.1320 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1323 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241029@181922.1381 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1384 4kmohhtuj2e0tkd5eqifvr68i0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241029@181922.1423 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1426 4kmohhtuj2e0tkd5eqifvr68i0 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241029@181922.1473 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.1477 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from td where ndoc = 39
20241029@181922.1492 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241029@181922.1511 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.1527 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181922.1546 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.1564 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181922.1599 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.1617 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181922.1633 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181922.1698 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181922.1714 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.1736 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181922.1752 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241029@181922.1935 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.1955 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181922.1988 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241029@181922.2001 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241029@181922.2012 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241029@181922.2023 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241029@181922.2035 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241029@181922.2047 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241029@181922.2059 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67212631196721272a27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241029@181922.2306 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 fno valor from wsftdata order by fno desc
20241029@181922.2333 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.2351 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181922.2375 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 'normal' from dummy
20241029@181922.2390 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67212631196721272a27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1549,100810,0,'2024-10-29',39,'euro',0,0,2024 ,?,?)
20241029@181922.2685 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.2688 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181922.2710 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181922.2723 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.2739 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.2766 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.2781 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.2790 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.2803 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181922.2816 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.2830 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.2844 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212724566721272a44','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.2849 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.2864 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.2893 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212724566721272a44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241029@181922.4236 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4255 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.4280 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4294 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.4303 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.4315 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4328 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.4339 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212003066721272a69','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.4343 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4357 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.4382 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212003066721272a69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,20000,?,?,?)
20241029@181922.4634 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.4637 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181922.4659 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181922.4673 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4689 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.4718 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4733 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.4742 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.4755 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181922.4767 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4783 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.4795 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212793886721272a74','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.4799 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.4815 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.4844 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212793886721272a74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241029@181922.5128 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5145 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.5175 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5190 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.5199 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.5214 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5231 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.5243 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212804186721272a7f','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.5249 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5266 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.5325 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212804186721272a7f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,50000,?,?,?)
20241029@181922.5583 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.5587 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181922.5608 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181922.5623 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5640 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.5668 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5683 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.5692 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.5715 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181922.5730 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5751 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.5763 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212099886721272a8b','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.5767 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.5783 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.5815 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212099886721272a8b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241029@181922.6084 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6102 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.6220 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6240 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.6252 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.6268 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6284 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.6298 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212077316721272a99','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.6303 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6324 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.6357 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212077316721272a99',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,80000,?,?,?)
20241029@181922.6619 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.6623 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181922.6643 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181922.6660 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6676 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.6702 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6718 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.6729 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.6744 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181922.6764 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6783 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.6796 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212439476721272aa5','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.6802 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.6817 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.6847 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212439476721272aa5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241029@181922.7105 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.7123 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.7193 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.7219 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.7230 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.7243 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.7260 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.7319 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212546406721272ab0','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.7324 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.7342 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.7542 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212546406721272ab0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,110000,?,?,?)
20241029@181922.7813 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.7843 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181922.7868 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181922.7901 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.7919 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.7973 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.7991 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.8000 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.8022 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181922.8035 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.8052 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.8068 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212008766721272ac4','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.8073 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.8087 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.8116 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212008766721272ac4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241029@181922.8374 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.8391 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.8418 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.8433 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.8441 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.8454 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.8471 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.8483 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212549396721272ace','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.8487 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.8502 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.8530 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212549396721272ace',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,140000,?,?,?)
20241029@181922.8906 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181922.8910 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181922.8953 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181922.8970 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.8987 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.9279 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.9298 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.9316 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.9329 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181922.9344 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.9364 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.9376 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212823546721272ae4','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181922.9381 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.9405 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.9434 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212823546721272ae4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241029@181922.9758 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.9832 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181922.9861 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.9882 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181922.9892 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181922.9923 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181922.9964 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.3600 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212580296721272af2','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.4100 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.5900 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.8600 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212580296721272af2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,170000,?,?,?)
20241029@181923.3490 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181923.3530 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181923.3740 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181923.3900 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.4070 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.4500 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.4670 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.4780 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.4920 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181923.5070 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.5370 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.5500 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212648526721272b0c','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.5550 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.5720 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.6020 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212648526721272b0c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241029@181923.9260 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.9480 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.9830 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1005 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.1016 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.1031 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1052 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.1067 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212129786721272b19','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.1072 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1100 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.1132 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212129786721272b19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,200000,?,?,?)
20241029@181923.1395 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181923.1399 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181923.1423 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181923.1438 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1456 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.1484 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1499 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.1508 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.1536 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181923.1550 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1566 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.1579 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212774856721272b25','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.1583 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1600 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.1629 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212774856721272b25',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241029@181923.1887 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1904 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.1931 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1947 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.1956 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.1970 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.1988 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.2013 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212893396721272b30','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.2017 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2033 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.2063 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212893396721272b30',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,230000,?,?,?)
20241029@181923.2321 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181923.2324 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181923.2344 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181923.2362 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2379 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.2406 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2421 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.2430 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.2442 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181923.2456 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2471 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.2483 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212174356721272b3b','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.2487 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2502 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.2533 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212174356721272b3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20241029@181923.2792 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2809 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.2836 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2857 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.2866 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.2879 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2893 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.2905 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212407286721272b46','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.2909 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.2923 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.2951 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212407286721272b46',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,260000,?,?,?)
20241029@181923.3209 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181923.3213 4kmohhtuj2e0tkd5eqifvr68i0 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241029@181923.3234 4kmohhtuj2e0tkd5eqifvr68i0 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'
20241029@181923.3249 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.3265 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.3291 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.3309 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.3320 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.3337 4kmohhtuj2e0tkd5eqifvr68i0 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20241029@181923.3353 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.3395 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.3409 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212994756721272b51','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.3414 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.3429 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.3462 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212994756721272b51',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67212631196721272a27' ,0,0 ,2,23.00,280000,?,?,?,?,?)
20241029@181923.3746 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.3765 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.4138 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.4157 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.4167 4kmohhtuj2e0tkd5eqifvr68i0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.4182 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.4200 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.4214 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212530336721272b66','aut67212631196721272a27' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.4218 4kmohhtuj2e0tkd5eqifvr68i0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.4233 4kmohhtuj2e0tkd5eqifvr68i0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.4260 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212530336721272b66',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212631196721272a27' ,0,0 ,2,23.00,290000,?,?,?)
20241029@181923.4585 4kmohhtuj2e0tkd5eqifvr68i0 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67212631196721272a27','2407081','wait',39,'adm09112754980.682000002')
20241029@181923.4654 4kmohhtuj2e0tkd5eqifvr68i0 Query : use flama_phc
20241029@181923.4658 4kmohhtuj2e0tkd5eqifvr68i0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241029@181923.4686 4kmohhtuj2e0tkd5eqifvr68i0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2973';
20241029@181923.4720 4kmohhtuj2e0tkd5eqifvr68i0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2973';
20241029@181923.4763 4kmohhtuj2e0tkd5eqifvr68i0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2973';
20241029@181923.4793 4kmohhtuj2e0tkd5eqifvr68i0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2973';
20241029@181923.5496 0rlt22cmju2quq8nbst3a74ur0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241029@181923.5507 0rlt22cmju2quq8nbst3a74ur0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241029@181923.5611 0rlt22cmju2quq8nbst3a74ur0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2974';
20241029@181923.5731 0rlt22cmju2quq8nbst3a74ur0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2974';
20241029@181923.5792 0rlt22cmju2quq8nbst3a74ur0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2974';
20241029@181923.5825 0rlt22cmju2quq8nbst3a74ur0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2974';
20241029@181923.5880 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.5883 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241029@181923.5943 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.5946 0rlt22cmju2quq8nbst3a74ur0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1957
20241029@181923.6029 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1290.1003'
20241029@181923.6184 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407096 and bi.ref ='325.1290.1003' and bi.lordem =1
20241029@181923.6512 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6515 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241029@181923.6547 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6551 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 1 valor from td where td.ndoc = 39
20241029@181923.6580 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6582 0rlt22cmju2quq8nbst3a74ur0 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')
20241029@181923.6609 0rlt22cmju2quq8nbst3a74ur0 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
20241029@181923.6649 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6652 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 ~inactivo valor from cl where no = '199530' and estab = 0 order by inactivo desc
20241029@181923.6770 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6773 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241029@181923.6803 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6806 0rlt22cmju2quq8nbst3a74ur0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241029@181923.6844 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6847 0rlt22cmju2quq8nbst3a74ur0 Query : select szadrsstamp valor from szadrs where szadrsdesc='pingo doce-distribuiÇÃo alimentar, s.a.- valongo1'
20241029@181923.6895 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.6898 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from td where ndoc = 39
20241029@181923.6910 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241029@181923.6924 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.6940 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181923.6959 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.6973 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181923.6999 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.7015 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181923.7026 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181923.7091 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181923.7115 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.7130 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181923.7146 0rlt22cmju2quq8nbst3a74ur0 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67212404636721272bab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241029@181923.7314 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.7331 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181923.7364 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241029@181923.7376 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241029@181923.7388 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241029@181923.7400 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241029@181923.7413 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241029@181923.7425 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241029@181923.7436 0rlt22cmju2quq8nbst3a74ur0 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67212404636721272bab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241029@181923.7720 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 fno valor from wsftdata order by fno desc
20241029@181923.7746 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.7762 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181923.7786 0rlt22cmju2quq8nbst3a74ur0 Query : select 'normal' from dummy
20241029@181923.7802 0rlt22cmju2quq8nbst3a74ur0 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67212404636721272bab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1550,199530,0,'2024-10-29',39,'euro',0,0,2024 ,?,?)
20241029@181923.8126 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.8130 0rlt22cmju2quq8nbst3a74ur0 Query : select st.usalote valor from st where st.ref = '325.1290.1003'
20241029@181923.8153 0rlt22cmju2quq8nbst3a74ur0 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 = '325.1290.1003'
20241029@181923.8294 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.8311 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.8337 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.8354 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.8364 0rlt22cmju2quq8nbst3a74ur0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181923.8378 0rlt22cmju2quq8nbst3a74ur0 Query : select sestamp valor from se where ref ='325.1290.1003' and lote = 'r2400796200a'
20241029@181923.8399 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.8416 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181923.8429 0rlt22cmju2quq8nbst3a74ur0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212626936721272bcd','aut67212404636721272bab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181923.8433 0rlt22cmju2quq8nbst3a74ur0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181923.8449 0rlt22cmju2quq8nbst3a74ur0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181923.8480 0rlt22cmju2quq8nbst3a74ur0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212626936721272bcd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1728.000 ,'aut67212404636721272bab' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241029@181923.8741 0rlt22cmju2quq8nbst3a74ur0 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67212404636721272bab','2407096','wait',39,'adm09112754980.682000002')
20241029@181923.8811 0rlt22cmju2quq8nbst3a74ur0 Query : use flama_phc
20241029@181923.8815 0rlt22cmju2quq8nbst3a74ur0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241029@181923.8843 0rlt22cmju2quq8nbst3a74ur0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2974';
20241029@181923.8879 0rlt22cmju2quq8nbst3a74ur0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2974';
20241029@181923.8923 0rlt22cmju2quq8nbst3a74ur0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2974';
20241029@181923.9019 0rlt22cmju2quq8nbst3a74ur0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2974';
20241029@181923.9523 ptolto4lvso1e5n1lprihl126d Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241029@181923.9537 ptolto4lvso1e5n1lprihl126d Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241029@181923.9599 ptolto4lvso1e5n1lprihl126d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2975';
20241029@181923.9662 ptolto4lvso1e5n1lprihl126d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2975';
20241029@181923.9718 ptolto4lvso1e5n1lprihl126d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2975';
20241029@181923.9746 ptolto4lvso1e5n1lprihl126d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2975';
20241029@181923.9802 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181923.9805 ptolto4lvso1e5n1lprihl126d Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241029@181923.9873 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181923.9877 ptolto4lvso1e5n1lprihl126d Query : select no, estab,szadrsdesc from szadrs where u_coddest=1549
20241029@181923.9958 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2334.00.1'
20241029@181924.1070 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.2334.00.1' and bi.lordem =1
20241029@181924.1587 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241029@181924.1731 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.2326.00.1' and bi.lordem =2
20241029@181924.2056 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241029@181924.2195 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.1321.00.1' and bi.lordem =3
20241029@181924.2513 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241029@181924.2655 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.1317.00.1' and bi.lordem =4
20241029@181924.2975 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241029@181924.2996 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.1317.00.1' and bi.lordem =4
20241029@181924.3014 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1329.00.1'
20241029@181924.3156 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.1329.00.1' and bi.lordem =5
20241029@181924.3580 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241029@181924.3735 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.1332.00.1' and bi.lordem =6
20241029@181924.4093 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241029@181924.4303 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.2335.00.1' and bi.lordem =7
20241029@181924.4680 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241029@181924.4834 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.2330.00.1' and bi.lordem =8
20241029@181924.5180 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241029@181924.5367 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.2340.00.1' and bi.lordem =9
20241029@181924.5702 ptolto4lvso1e5n1lprihl126d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2318.00.1'
20241029@181924.5885 ptolto4lvso1e5n1lprihl126d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407097 and bi.ref ='324.2318.00.1' and bi.lordem =10
20241029@181924.6208 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6212 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241029@181924.6249 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6254 ptolto4lvso1e5n1lprihl126d Query : select top 1 1 valor from td where td.ndoc = 39
20241029@181924.6285 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6288 ptolto4lvso1e5n1lprihl126d 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')
20241029@181924.6317 ptolto4lvso1e5n1lprihl126d 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
20241029@181924.6351 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6355 ptolto4lvso1e5n1lprihl126d Query : select top 1 ~inactivo valor from cl where no = '101557' and estab = 0 order by inactivo desc
20241029@181924.6477 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6480 ptolto4lvso1e5n1lprihl126d Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241029@181924.6512 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6515 ptolto4lvso1e5n1lprihl126d Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241029@181924.6557 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6561 ptolto4lvso1e5n1lprihl126d Query : select szadrsstamp valor from szadrs where szadrsdesc='jomafal'
20241029@181924.6611 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.6614 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from td where ndoc = 39
20241029@181924.6628 ptolto4lvso1e5n1lprihl126d Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241029@181924.6642 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.6734 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181924.6766 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.6803 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181924.6839 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.7059 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181924.7213 ptolto4lvso1e5n1lprihl126d Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181924.7283 ptolto4lvso1e5n1lprihl126d Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181924.7309 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.7430 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181924.7664 ptolto4lvso1e5n1lprihl126d Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241029@181924.7831 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.7853 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181924.7892 ptolto4lvso1e5n1lprihl126d Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241029@181924.7911 ptolto4lvso1e5n1lprihl126d Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241029@181924.7953 ptolto4lvso1e5n1lprihl126d Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241029@181924.7968 ptolto4lvso1e5n1lprihl126d Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241029@181924.7982 ptolto4lvso1e5n1lprihl126d Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241029@181924.7994 ptolto4lvso1e5n1lprihl126d Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241029@181924.8013 ptolto4lvso1e5n1lprihl126d Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67212102206721272cb0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241029@181924.8264 ptolto4lvso1e5n1lprihl126d Query : select top 1 fno valor from wsftdata order by fno desc
20241029@181924.8292 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.8311 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181924.8337 ptolto4lvso1e5n1lprihl126d Query : select 'normal' from dummy
20241029@181924.8354 ptolto4lvso1e5n1lprihl126d Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67212102206721272cb0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1551,101557,0,'2024-10-29',39,'euro',0,0,2024 ,?,?)
20241029@181924.8639 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.8643 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.2334.00.1'
20241029@181924.8671 ptolto4lvso1e5n1lprihl126d 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.2334.00.1'
20241029@181924.8830 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.8851 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181924.8880 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.8904 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181924.8915 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181924.8928 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.2334.00.1' and lote = 'r2100585400a'
20241029@181924.8942 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.8959 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181924.8971 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212258326721272cda','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181924.8975 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.8990 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181924.9028 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212258326721272cda',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241029@181924.9282 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.9285 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241029@181924.9307 ptolto4lvso1e5n1lprihl126d 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.2326.00.1'
20241029@181924.9454 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.9472 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181924.9501 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.9519 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181924.9528 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181924.9540 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2100576400a'
20241029@181924.9562 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.9578 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181924.9589 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212880806721272ce9','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181924.9593 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181924.9607 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181924.9634 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212880806721272ce9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241029@181924.9953 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181924.9956 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241029@181924.9977 ptolto4lvso1e5n1lprihl126d 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.1321.00.1'
20241029@181925.1210 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.1360 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.1610 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.1760 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.1860 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.2000 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241029@181925.2210 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.2390 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.2520 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212547226721272d05','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.2560 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.2740 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.3030 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212547226721272d05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241029@181925.5730 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.5770 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241029@181925.5970 ptolto4lvso1e5n1lprihl126d 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.1317.00.1'
20241029@181925.7300 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.7460 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.7730 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.7880 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.7970 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.8100 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20241029@181925.8250 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.8400 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.8530 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212054006721272d14','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.8580 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.8760 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.9100 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212054006721272d14',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241029@181925.1245 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.1290 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241029@181925.1891 ptolto4lvso1e5n1lprihl126d 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.1317.00.1'
20241029@181925.2777 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.2795 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.2823 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.2839 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.2849 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.2862 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20241029@181925.2876 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.2890 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.2902 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212183576721272d46','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.2907 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.2922 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.2950 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212183576721272d46',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241029@181925.3217 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.3220 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.1329.00.1'
20241029@181925.3241 ptolto4lvso1e5n1lprihl126d 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.1329.00.1'
20241029@181925.3376 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.3391 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.3438 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.3454 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.3463 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.3475 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.1329.00.1' and lote = 'r2400496300a'
20241029@181925.3488 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.3503 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.3514 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212421946721272d55','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.3518 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.3532 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.3562 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212421946721272d55',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241029@181925.3824 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.3828 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241029@181925.3856 ptolto4lvso1e5n1lprihl126d 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.1332.00.1'
20241029@181925.4029 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4048 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.4074 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4089 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.4097 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.4110 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241029@181925.4131 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4146 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.4159 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212709586721272d64','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.4163 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4179 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.4209 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212709586721272d64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241029@181925.4486 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.4489 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241029@181925.4513 ptolto4lvso1e5n1lprihl126d Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241029@181925.4658 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4675 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.4704 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4720 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.4730 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.4744 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241029@181925.4759 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4774 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.4786 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212997896721272d74','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.4790 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.4805 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.4834 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212997896721272d74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241029@181925.5083 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.5087 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241029@181925.5113 ptolto4lvso1e5n1lprihl126d 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.2330.00.1'
20241029@181925.5255 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5271 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.5296 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5311 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.5319 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.5331 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241029@181925.5344 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5358 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.5369 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212596626721272d82','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.5373 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5387 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.5416 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212596626721272d82',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241029@181925.5660 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.5663 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241029@181925.5685 ptolto4lvso1e5n1lprihl126d 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.2340.00.1'
20241029@181925.5834 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5855 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.5886 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5903 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.5912 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.5924 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241029@181925.5938 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5954 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.5966 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212658286721272d90','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.5970 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.5985 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.6013 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212658286721272d90',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241029@181925.6417 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.6499 ptolto4lvso1e5n1lprihl126d Query : select st.usalote valor from st where st.ref = '324.2318.00.1'
20241029@181925.6918 ptolto4lvso1e5n1lprihl126d 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.2318.00.1'
20241029@181925.8604 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.8623 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.8650 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.8667 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.8676 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.8690 ptolto4lvso1e5n1lprihl126d Query : select sestamp valor from se where ref ='324.2318.00.1' and lote = 'r2100669100a'
20241029@181925.8712 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.8727 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.8740 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212016246721272dd4','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.8745 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.8760 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.8791 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212016246721272dd4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241029@181925.9072 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.9088 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.9117 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.9134 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.9144 ptolto4lvso1e5n1lprihl126d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181925.9159 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.9176 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181925.9190 ptolto4lvso1e5n1lprihl126d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212476736721272ddf','aut67212102206721272cb0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181925.9196 ptolto4lvso1e5n1lprihl126d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181925.9216 ptolto4lvso1e5n1lprihl126d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181925.9247 ptolto4lvso1e5n1lprihl126d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67212476736721272ddf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67212102206721272cb0' ,0,0 ,2,23.00,120000,?,?,?)
20241029@181925.9514 ptolto4lvso1e5n1lprihl126d Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67212102206721272cb0','2407097','wait',39,'adm09112754980.682000002')
20241029@181925.9582 ptolto4lvso1e5n1lprihl126d Query : use flama_phc
20241029@181925.9585 ptolto4lvso1e5n1lprihl126d Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241029@181925.9615 ptolto4lvso1e5n1lprihl126d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2975';
20241029@181925.9651 ptolto4lvso1e5n1lprihl126d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2975';
20241029@181925.9694 ptolto4lvso1e5n1lprihl126d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2975';
20241029@181925.9722 ptolto4lvso1e5n1lprihl126d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2975';
20241029@181926.1142 l5c05q394oklpittijgi136qs6 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241029@181926.1153 l5c05q394oklpittijgi136qs6 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241029@181926.1214 l5c05q394oklpittijgi136qs6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2976';
20241029@181926.1271 l5c05q394oklpittijgi136qs6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2976';
20241029@181926.1338 l5c05q394oklpittijgi136qs6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2976';
20241029@181926.1375 l5c05q394oklpittijgi136qs6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2976';
20241029@181926.1429 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.1432 l5c05q394oklpittijgi136qs6 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241029@181926.1496 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.1500 l5c05q394oklpittijgi136qs6 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20241029@181926.1586 l5c05q394oklpittijgi136qs6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241029@181926.1744 l5c05q394oklpittijgi136qs6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407098 and bi.ref ='324.600.94.01' and bi.lordem =1
20241029@181926.2155 l5c05q394oklpittijgi136qs6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241029@181926.2176 l5c05q394oklpittijgi136qs6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407098 and bi.ref ='324.600.94.01' and bi.lordem =1
20241029@181926.2193 l5c05q394oklpittijgi136qs6 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'
20241029@181926.2340 l5c05q394oklpittijgi136qs6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407098 and bi.ref ='324.2000.94.1' and bi.lordem =2
20241029@181926.2712 l5c05q394oklpittijgi136qs6 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'
20241029@181926.2899 l5c05q394oklpittijgi136qs6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407098 and bi.ref ='324.900.94.01' and bi.lordem =3
20241029@181926.3936 l5c05q394oklpittijgi136qs6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.700.94.01'
20241029@181926.4569 l5c05q394oklpittijgi136qs6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407098 and bi.ref ='324.700.94.01' and bi.lordem =4
20241029@181926.4894 l5c05q394oklpittijgi136qs6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2200.94.1'
20241029@181926.5043 l5c05q394oklpittijgi136qs6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2070 and bo.obrano = 2407098 and bi.ref ='324.2200.94.1' and bi.lordem =5
20241029@181926.5428 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5431 l5c05q394oklpittijgi136qs6 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241029@181926.5467 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5471 l5c05q394oklpittijgi136qs6 Query : select top 1 1 valor from td where td.ndoc = 39
20241029@181926.5500 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5503 l5c05q394oklpittijgi136qs6 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')
20241029@181926.5531 l5c05q394oklpittijgi136qs6 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
20241029@181926.5565 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5569 l5c05q394oklpittijgi136qs6 Query : select top 1 ~inactivo valor from cl where no = '199800' and estab = 0 order by inactivo desc
20241029@181926.5707 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5711 l5c05q394oklpittijgi136qs6 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241029@181926.5743 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5747 l5c05q394oklpittijgi136qs6 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241029@181926.5792 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5795 l5c05q394oklpittijgi136qs6 Query : select szadrsstamp valor from szadrs where szadrsdesc='740 ent vnr bligeiro'
20241029@181926.5849 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.5853 l5c05q394oklpittijgi136qs6 Query : select 1 valor from td where ndoc = 39
20241029@181926.5867 l5c05q394oklpittijgi136qs6 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241029@181926.5881 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.5900 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181926.5921 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.5936 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181926.5984 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.6002 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181926.6016 l5c05q394oklpittijgi136qs6 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181926.6081 l5c05q394oklpittijgi136qs6 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241029@181926.6096 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.6113 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241029@181926.6130 l5c05q394oklpittijgi136qs6 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67212538726721272e92' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241029@181926.6352 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.6378 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241029@181926.6416 l5c05q394oklpittijgi136qs6 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241029@181926.6427 l5c05q394oklpittijgi136qs6 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241029@181926.6439 l5c05q394oklpittijgi136qs6 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241029@181926.6490 l5c05q394oklpittijgi136qs6 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241029@181926.6502 l5c05q394oklpittijgi136qs6 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241029@181926.6514 l5c05q394oklpittijgi136qs6 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241029@181926.6525 l5c05q394oklpittijgi136qs6 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67212538726721272e92',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241029@181926.6845 l5c05q394oklpittijgi136qs6 Query : select top 1 fno valor from wsftdata order by fno desc
20241029@181926.6874 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.6894 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241029@181926.6922 l5c05q394oklpittijgi136qs6 Query : select 'normal' from dummy
20241029@181926.6938 l5c05q394oklpittijgi136qs6 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67212538726721272e92',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1552,199800,0,'2024-10-29',39,'euro',0,0,2024 ,?,?)
20241029@181926.7261 l5c05q394oklpittijgi136qs6 Query : use flama_phc
20241029@181926.7264 l5c05q394oklpittijgi136qs6 Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241029@181926.7290 l5c05q394oklpittijgi136qs6 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'
20241029@181926.7482 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.7501 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181926.7528 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.7544 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181926.7553 l5c05q394oklpittijgi136qs6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241029@181926.7565 l5c05q394oklpittijgi136qs6 Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241029@181926.7586 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.7605 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241029@181926.7618 l5c05q394oklpittijgi136qs6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67212542556721272eb9','aut67212538726721272e92' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241029@181926.7623 l5c05q394oklpittijgi136qs6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241029@181926.7639 l5c05q394oklpittijgi136qs6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241029@181926.7672 l5c05q394oklpittijgi136qs6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67212542556721272eb9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut67212538726721272e92' ,0,0 ,2,23.00,10000,?,?,?,?,?)
