20240514@080337.9082 ihsf4o2hden5pgvq930t9lemch Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080337.9098 ihsf4o2hden5pgvq930t9lemch Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080337.9103 ihsf4o2hden5pgvq930t9lemch Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664300766966430cc9d5','aut664301565866430cc98a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080337.9108 ihsf4o2hden5pgvq930t9lemch Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664301565866430cc98a','2403371','wait',39,'ari17112337378,753000005')
20240514@080337.9123 ihsf4o2hden5pgvq930t9lemch Query : use flama_phc
20240514@080337.9126 ihsf4o2hden5pgvq930t9lemch Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@080337.9137 ihsf4o2hden5pgvq930t9lemch Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1640';
20240514@080337.9153 ihsf4o2hden5pgvq930t9lemch Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1640';
20240514@080337.9171 ihsf4o2hden5pgvq930t9lemch Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1640';
20240514@080337.9185 ihsf4o2hden5pgvq930t9lemch Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1640';
20240514@080337.9554 r72fe80dh29i679ok3r8120894 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@080337.9566 r72fe80dh29i679ok3r8120894 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@080337.9585 r72fe80dh29i679ok3r8120894 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1641';
20240514@080337.9634 r72fe80dh29i679ok3r8120894 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1641';
20240514@080337.9653 r72fe80dh29i679ok3r8120894 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1641';
20240514@080337.9668 r72fe80dh29i679ok3r8120894 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1641';
20240514@080337.9684 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080337.9687 r72fe80dh29i679ok3r8120894 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@080337.9703 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080337.9706 r72fe80dh29i679ok3r8120894 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240514@080337.9736 r72fe80dh29i679ok3r8120894 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240514@080337.9748 r72fe80dh29i679ok3r8120894 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403372 and bi.ref ='324.727.00.01' and bi.lordem =1
20240514@080338.7200 r72fe80dh29i679ok3r8120894 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240514@080338.8400 r72fe80dh29i679ok3r8120894 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403372 and bi.ref ='324.727.00.01' and bi.lordem =1
20240514@080338.9000 r72fe80dh29i679ok3r8120894 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240514@080338.1560 r72fe80dh29i679ok3r8120894 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403372 and bi.ref ='324.727.00.01' and bi.lordem =1
20240514@080338.1620 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.1650 r72fe80dh29i679ok3r8120894 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@080338.1930 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.1960 r72fe80dh29i679ok3r8120894 Query : select top 1 1 valor from td where td.ndoc = 39
20240514@080338.2070 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2100 r72fe80dh29i679ok3r8120894 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@080338.2220 r72fe80dh29i679ok3r8120894 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@080338.2370 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2400 r72fe80dh29i679ok3r8120894 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240514@080338.2520 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2550 r72fe80dh29i679ok3r8120894 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@080338.2660 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2690 r72fe80dh29i679ok3r8120894 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@080338.2800 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2830 r72fe80dh29i679ok3r8120894 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240514@080338.2950 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2980 r72fe80dh29i679ok3r8120894 Query : select 1 valor from td where ndoc = 39
20240514@080338.3080 r72fe80dh29i679ok3r8120894 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@080338.3200 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080338.3330 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@080338.3490 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080338.3610 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@080338.3860 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080338.3980 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@080338.4070 r72fe80dh29i679ok3r8120894 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080338.5640 r72fe80dh29i679ok3r8120894 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080338.5720 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080338.5840 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@080338.5940 r72fe80dh29i679ok3r8120894 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664307583166430cca09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@080338.7480 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080338.7610 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@080338.7880 r72fe80dh29i679ok3r8120894 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@080338.7920 r72fe80dh29i679ok3r8120894 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@080338.7980 r72fe80dh29i679ok3r8120894 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@080338.8020 r72fe80dh29i679ok3r8120894 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@080338.8130 r72fe80dh29i679ok3r8120894 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@080338.8170 r72fe80dh29i679ok3r8120894 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@080338.8210 r72fe80dh29i679ok3r8120894 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664307583166430cca09',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@080338.1041 r72fe80dh29i679ok3r8120894 Query : select top 1 fno valor from wsft039data order by fno desc
20240514@080338.1057 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080338.1070 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@080338.1097 r72fe80dh29i679ok3r8120894 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664307583166430cca09',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1315,100810,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','0833',?,?,?,?)
20240514@080338.1347 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.1355 r72fe80dh29i679ok3r8120894 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240514@080338.1366 r72fe80dh29i679ok3r8120894 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240514@080338.1377 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.1389 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.1411 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.1423 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.1427 r72fe80dh29i679ok3r8120894 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240514@080338.1436 r72fe80dh29i679ok3r8120894 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.1445 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.1456 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.1477 r72fe80dh29i679ok3r8120894 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664304335066430cca23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',88.000 ,'aut664307583166430cca09' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@080338.1689 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.1704 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.1708 r72fe80dh29i679ok3r8120894 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664304335066430cca23','aut664307583166430cca09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.1713 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.1726 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.1748 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.1759 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.1763 r72fe80dh29i679ok3r8120894 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.1773 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.1784 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.1807 r72fe80dh29i679ok3r8120894 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664303154266430cca2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664307583166430cca09' ,0,0 ,2,23.00,20000,?,?,?)
20240514@080338.2023 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.2037 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.2041 r72fe80dh29i679ok3r8120894 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664303154266430cca2b','aut664307583166430cca09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.2045 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2048 r72fe80dh29i679ok3r8120894 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240514@080338.2058 r72fe80dh29i679ok3r8120894 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240514@080338.2068 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.2079 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.2101 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.2112 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.2116 r72fe80dh29i679ok3r8120894 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240514@080338.2125 r72fe80dh29i679ok3r8120894 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.2134 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.2145 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.2166 r72fe80dh29i679ok3r8120894 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664302818866430cca34',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut664307583166430cca09' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240514@080338.2378 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.2394 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.2400 r72fe80dh29i679ok3r8120894 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664302818866430cca34','aut664307583166430cca09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.2405 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.2417 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.2437 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.2448 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.2452 r72fe80dh29i679ok3r8120894 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.2461 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.2472 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.2494 r72fe80dh29i679ok3r8120894 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664301522866430cca3c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664307583166430cca09' ,0,0 ,2,23.00,50000,?,?,?)
20240514@080338.2754 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.2768 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.2772 r72fe80dh29i679ok3r8120894 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664301522866430cca3c','aut664307583166430cca09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.2776 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.2787 r72fe80dh29i679ok3r8120894 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240514@080338.2798 r72fe80dh29i679ok3r8120894 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240514@080338.2808 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.2819 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.2862 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.2875 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.2878 r72fe80dh29i679ok3r8120894 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240514@080338.2887 r72fe80dh29i679ok3r8120894 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.2932 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.2946 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.2997 r72fe80dh29i679ok3r8120894 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664308741466430cca47',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut664307583166430cca09' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240514@080338.3222 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.3237 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.3245 r72fe80dh29i679ok3r8120894 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664308741466430cca47','aut664307583166430cca09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.3250 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.3262 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.3283 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.3295 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.3299 r72fe80dh29i679ok3r8120894 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.3308 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.3318 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.3344 r72fe80dh29i679ok3r8120894 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664303396466430cca50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664307583166430cca09' ,0,0 ,2,23.00,80000,?,?,?)
20240514@080338.3569 r72fe80dh29i679ok3r8120894 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.3583 r72fe80dh29i679ok3r8120894 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.3597 r72fe80dh29i679ok3r8120894 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664303396466430cca50','aut664307583166430cca09' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.3602 r72fe80dh29i679ok3r8120894 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664307583166430cca09','2403372','wait',39,'ari17112337378,753000005')
20240514@080338.3617 r72fe80dh29i679ok3r8120894 Query : use flama_phc
20240514@080338.3620 r72fe80dh29i679ok3r8120894 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@080338.3631 r72fe80dh29i679ok3r8120894 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1641';
20240514@080338.3649 r72fe80dh29i679ok3r8120894 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1641';
20240514@080338.3665 r72fe80dh29i679ok3r8120894 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1641';
20240514@080338.3677 r72fe80dh29i679ok3r8120894 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1641';
20240514@080338.4103 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@080338.4116 oej174klrg0jrm4m9bu5ok8jd1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@080338.4135 oej174klrg0jrm4m9bu5ok8jd1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1642';
20240514@080338.4183 oej174klrg0jrm4m9bu5ok8jd1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1642';
20240514@080338.4202 oej174klrg0jrm4m9bu5ok8jd1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1642';
20240514@080338.4216 oej174klrg0jrm4m9bu5ok8jd1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1642';
20240514@080338.4232 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4235 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@080338.4248 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4251 oej174klrg0jrm4m9bu5ok8jd1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240514@080338.4281 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240514@080338.4299 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403373 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240514@080338.4622 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240514@080338.4706 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403373 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240514@080338.4713 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240514@080338.4723 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403373 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240514@080338.4729 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240514@080338.4738 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403373 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240514@080338.4751 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240514@080338.4761 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403373 and bi.ref ='304.4320.00.1' and bi.lordem =1
20240514@080338.4766 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4769 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@080338.4783 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4785 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 1 valor from td where td.ndoc = 39
20240514@080338.4796 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4799 oej174klrg0jrm4m9bu5ok8jd1 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@080338.4808 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@080338.4822 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4825 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240514@080338.4834 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4837 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@080338.4846 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4849 oej174klrg0jrm4m9bu5ok8jd1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@080338.4858 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4861 oej174klrg0jrm4m9bu5ok8jd1 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240514@080338.4872 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.4874 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from td where ndoc = 39
20240514@080338.4883 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@080338.4893 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080338.4917 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@080338.4933 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080338.4946 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@080338.4970 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080338.4982 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@080338.4991 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080338.5066 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080338.5074 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080338.5086 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@080338.5095 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664300939766430cca79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@080338.5232 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080338.5246 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@080338.5272 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@080338.5277 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@080338.5282 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@080338.5286 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@080338.5293 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@080338.5298 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@080338.5302 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664300939766430cca79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@080338.5526 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 fno valor from wsft039data order by fno desc
20240514@080338.5543 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080338.5557 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@080338.5572 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664300939766430cca79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1316,100810,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','0833',?,?,?,?)
20240514@080338.5821 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.5824 oej174klrg0jrm4m9bu5ok8jd1 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240514@080338.5835 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240514@080338.5846 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.5859 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.5880 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.5892 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.5896 oej174klrg0jrm4m9bu5ok8jd1 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240350'
20240514@080338.5905 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.5914 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.5925 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.5946 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664305342066430cca90',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut664300939766430cca79' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@080338.6157 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.6171 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.6175 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664305342066430cca90','aut664300939766430cca79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.6179 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.6182 oej174klrg0jrm4m9bu5ok8jd1 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240514@080338.6192 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240514@080338.6203 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.6215 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.6237 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.6249 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.6252 oej174klrg0jrm4m9bu5ok8jd1 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240444'
20240514@080338.6269 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.6278 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.6290 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.6313 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664308162666430cca99',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',56.000 ,'aut664300939766430cca79' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240514@080338.6548 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.6563 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.6568 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664308162666430cca99','aut664300939766430cca79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.6572 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.6611 oej174klrg0jrm4m9bu5ok8jd1 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240514@080338.6623 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240514@080338.6634 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.6648 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.6704 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.6719 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.6739 oej174klrg0jrm4m9bu5ok8jd1 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240444'
20240514@080338.6749 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.6759 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.6772 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.6814 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664300868466430ccaa5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut664300939766430cca79' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240514@080338.7041 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.7056 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.7061 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664300868466430ccaa5','aut664300939766430cca79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.7065 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.7068 oej174klrg0jrm4m9bu5ok8jd1 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240514@080338.7078 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240514@080338.7089 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.7105 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.7140 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.7170 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.7175 oej174klrg0jrm4m9bu5ok8jd1 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240444'
20240514@080338.7184 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.7201 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.7214 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.7236 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664302431466430ccaaf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut664300939766430cca79' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240514@080338.7458 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.7473 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.7477 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664302431466430ccaaf','aut664300939766430cca79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.7482 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.7485 oej174klrg0jrm4m9bu5ok8jd1 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240514@080338.7496 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4320.00.1'
20240514@080338.7507 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.7522 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080338.7552 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.7570 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080338.7575 oej174klrg0jrm4m9bu5ok8jd1 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240444'
20240514@080338.7588 oej174klrg0jrm4m9bu5ok8jd1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080338.7600 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080338.7614 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080338.7643 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664306952966430ccab9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut664300939766430cca79' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240514@080338.7862 oej174klrg0jrm4m9bu5ok8jd1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080338.7878 oej174klrg0jrm4m9bu5ok8jd1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080338.7883 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664306952966430ccab9','aut664300939766430cca79' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080338.7887 oej174klrg0jrm4m9bu5ok8jd1 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664300939766430cca79','2403373','wait',39,'ari17112337378,753000005')
20240514@080338.7904 oej174klrg0jrm4m9bu5ok8jd1 Query : use flama_phc
20240514@080338.7907 oej174klrg0jrm4m9bu5ok8jd1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@080338.7918 oej174klrg0jrm4m9bu5ok8jd1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1642';
20240514@080338.7934 oej174klrg0jrm4m9bu5ok8jd1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1642';
20240514@080338.7951 oej174klrg0jrm4m9bu5ok8jd1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1642';
20240514@080338.7964 oej174klrg0jrm4m9bu5ok8jd1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1642';
20240514@080338.8343 v61ju42ntkd9l3c7poevkvdj4g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@080338.8356 v61ju42ntkd9l3c7poevkvdj4g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@080338.8374 v61ju42ntkd9l3c7poevkvdj4g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1643';
20240514@080338.8417 v61ju42ntkd9l3c7poevkvdj4g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1643';
20240514@080338.8435 v61ju42ntkd9l3c7poevkvdj4g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1643';
20240514@080338.8448 v61ju42ntkd9l3c7poevkvdj4g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1643';
20240514@080338.8464 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.8469 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@080338.8482 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.8485 v61ju42ntkd9l3c7poevkvdj4g Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240514@080338.8513 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20240514@080338.8667 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403374 and bi.ref ='324.1837.00.1' and bi.lordem =1
20240514@080338.9070 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20240514@080338.9082 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403374 and bi.ref ='324.1837.00.1' and bi.lordem =1
20240514@080338.9087 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20240514@080338.9098 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403374 and bi.ref ='324.1837.00.1' and bi.lordem =1
20240514@080338.9103 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20240514@080338.9113 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403374 and bi.ref ='324.1837.00.1' and bi.lordem =2
20240514@080338.9577 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9581 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@080338.9594 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9597 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 1 valor from td where td.ndoc = 39
20240514@080338.9606 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9610 v61ju42ntkd9l3c7poevkvdj4g Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@080338.9620 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@080338.9634 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9637 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240514@080338.9647 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9650 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@080338.9660 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9662 v61ju42ntkd9l3c7poevkvdj4g Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@080338.9673 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9675 v61ju42ntkd9l3c7poevkvdj4g Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240514@080338.9687 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080338.9690 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from td where ndoc = 39
20240514@080338.9701 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@080338.9713 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080338.9729 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@080338.9749 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080338.9764 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@080338.9801 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080338.9819 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@080338.9830 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080338.9942 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080338.9953 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080338.9969 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@080338.9980 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664308436666430ccaf0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@080339.3170 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080339.6440 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@080339.1730 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@080339.1745 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@080339.1750 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@080339.1756 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@080339.1761 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@080339.1767 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@080339.1772 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664308436666430ccaf0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@080339.1984 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 fno valor from wsft039data order by fno desc
20240514@080339.2003 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080339.2016 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@080339.2031 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664308436666430ccaf0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1317,100810,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','0833',?,?,?,?)
20240514@080339.2263 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080339.2267 v61ju42ntkd9l3c7poevkvdj4g Query : select st.usalote valor from st where st.ref = '324.1837.00.1'
20240514@080339.2280 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1837.00.1'
20240514@080339.2423 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.2437 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.2460 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.2471 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.2476 v61ju42ntkd9l3c7poevkvdj4g Query : select sestamp valor from se where ref ='324.1837.00.1' and lote = 'r2300658200a'
20240514@080339.2492 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.2501 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.2513 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.2537 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664303891966430ccb3d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut664308436666430ccaf0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@080339.2743 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.2758 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.2762 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664303891966430ccb3d','aut664308436666430ccaf0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.2767 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080339.2770 v61ju42ntkd9l3c7poevkvdj4g Query : select st.usalote valor from st where st.ref = '324.1837.00.1'
20240514@080339.2780 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1837.00.1'
20240514@080339.2792 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.2811 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.2833 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.2845 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.2865 v61ju42ntkd9l3c7poevkvdj4g Query : select sestamp valor from se where ref ='324.1837.00.1' and lote = 'r2301207300a'
20240514@080339.2876 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.2885 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.2898 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.3083 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664305347866430ccb46',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut664308436666430ccaf0' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240514@080339.3310 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.3325 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.3330 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664305347866430ccb46','aut664308436666430ccaf0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.3375 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080339.3379 v61ju42ntkd9l3c7poevkvdj4g Query : select st.usalote valor from st where st.ref = '324.1837.00.1'
20240514@080339.3391 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1837.00.1'
20240514@080339.3403 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.3418 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.3442 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.3455 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.3460 v61ju42ntkd9l3c7poevkvdj4g Query : select sestamp valor from se where ref ='324.1837.00.1' and lote = 'r2301207300a'
20240514@080339.3470 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.3480 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.3503 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.3527 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664309960066430ccb54',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut664308436666430ccaf0' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240514@080339.3750 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.3768 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.3778 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664309960066430ccb54','aut664308436666430ccaf0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.3783 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080339.3787 v61ju42ntkd9l3c7poevkvdj4g Query : select st.usalote valor from st where st.ref = '324.1837.00.1'
20240514@080339.3800 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1837.00.1'
20240514@080339.3814 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.3827 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.3861 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.3874 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.3878 v61ju42ntkd9l3c7poevkvdj4g Query : select sestamp valor from se where ref ='324.1837.00.1' and lote = 'r2301207300a'
20240514@080339.3890 v61ju42ntkd9l3c7poevkvdj4g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.3901 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.3915 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.3939 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664306573766430ccb5f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut664308436666430ccaf0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240514@080339.4161 v61ju42ntkd9l3c7poevkvdj4g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.4180 v61ju42ntkd9l3c7poevkvdj4g Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.4185 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664306573766430ccb5f','aut664308436666430ccaf0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.4191 v61ju42ntkd9l3c7poevkvdj4g Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664308436666430ccaf0','2403374','wait',39,'ari17112337378,753000005')
20240514@080339.4208 v61ju42ntkd9l3c7poevkvdj4g Query : use flama_phc
20240514@080339.4212 v61ju42ntkd9l3c7poevkvdj4g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@080339.4223 v61ju42ntkd9l3c7poevkvdj4g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1643';
20240514@080339.4238 v61ju42ntkd9l3c7poevkvdj4g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1643';
20240514@080339.4266 v61ju42ntkd9l3c7poevkvdj4g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1643';
20240514@080339.4282 v61ju42ntkd9l3c7poevkvdj4g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1643';
20240514@080339.4752 keag7kovmqdfbm1bdts6lm1man Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@080339.4765 keag7kovmqdfbm1bdts6lm1man Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@080339.4785 keag7kovmqdfbm1bdts6lm1man Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1644';
20240514@080339.4826 keag7kovmqdfbm1bdts6lm1man Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1644';
20240514@080339.4844 keag7kovmqdfbm1bdts6lm1man Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1644';
20240514@080339.4859 keag7kovmqdfbm1bdts6lm1man Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1644';
20240514@080339.4874 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.4877 keag7kovmqdfbm1bdts6lm1man Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@080339.4892 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.4895 keag7kovmqdfbm1bdts6lm1man Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240514@080339.4925 keag7kovmqdfbm1bdts6lm1man Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240514@080339.5078 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403375 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240514@080339.5395 keag7kovmqdfbm1bdts6lm1man Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240514@080339.5405 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403375 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240514@080339.5411 keag7kovmqdfbm1bdts6lm1man Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240514@080339.5421 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403375 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240514@080339.5542 keag7kovmqdfbm1bdts6lm1man Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240514@080339.5577 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403375 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240514@080339.5583 keag7kovmqdfbm1bdts6lm1man Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240514@080339.5592 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403375 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240514@080339.5597 keag7kovmqdfbm1bdts6lm1man Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240514@080339.5624 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403375 and bi.ref ='324.1832.00.2' and bi.lordem =2
20240514@080339.5948 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.5952 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@080339.5992 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.5995 keag7kovmqdfbm1bdts6lm1man Query : select top 1 1 valor from td where td.ndoc = 39
20240514@080339.6004 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.6007 keag7kovmqdfbm1bdts6lm1man Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@080339.6017 keag7kovmqdfbm1bdts6lm1man Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@080339.6097 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.6101 keag7kovmqdfbm1bdts6lm1man Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240514@080339.6111 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.6114 keag7kovmqdfbm1bdts6lm1man Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@080339.6125 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.6128 keag7kovmqdfbm1bdts6lm1man Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@080339.6138 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.6141 keag7kovmqdfbm1bdts6lm1man Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240514@080339.6155 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.6158 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from td where ndoc = 39
20240514@080339.6167 keag7kovmqdfbm1bdts6lm1man Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@080339.6179 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080339.6192 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@080339.6207 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080339.6219 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@080339.6244 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080339.6257 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@080339.6266 keag7kovmqdfbm1bdts6lm1man Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080339.6343 keag7kovmqdfbm1bdts6lm1man Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080339.6352 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080339.6364 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@080339.6375 keag7kovmqdfbm1bdts6lm1man Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@080339.6519 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080339.6534 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@080339.6563 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@080339.6567 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@080339.6572 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@080339.6576 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@080339.6581 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@080339.6585 keag7kovmqdfbm1bdts6lm1man Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@080339.6589 keag7kovmqdfbm1bdts6lm1man Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664302144066430ccb98',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@080339.6821 keag7kovmqdfbm1bdts6lm1man Query : select top 1 fno valor from wsft039data order by fno desc
20240514@080339.6836 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080339.6852 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@080339.6869 keag7kovmqdfbm1bdts6lm1man Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664302144066430ccb98',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1318,100810,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','0833',?,?,?,?)
20240514@080339.7111 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.7114 keag7kovmqdfbm1bdts6lm1man Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240514@080339.7126 keag7kovmqdfbm1bdts6lm1man Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240514@080339.7268 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.7281 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.7303 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.7315 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.7319 keag7kovmqdfbm1bdts6lm1man Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240514@080339.7329 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.7338 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.7349 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.7370 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664300338566430ccbb3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@080339.7586 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.7601 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.7605 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664300338566430ccbb3','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.7609 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.7621 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.7643 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.7655 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.7704 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.7726 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.7739 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.7763 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664309031466430ccbbc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,20000,?,?,?)
20240514@080339.8034 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.8053 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.8056 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664309031466430ccbbc','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.8061 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.8064 keag7kovmqdfbm1bdts6lm1man Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240514@080339.8073 keag7kovmqdfbm1bdts6lm1man Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240514@080339.8112 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.8125 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.8146 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.8158 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.8162 keag7kovmqdfbm1bdts6lm1man Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240514@080339.8170 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.8179 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.8190 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.8211 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664300885566430ccbc7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240514@080339.8430 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.8444 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.8448 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664300885566430ccbc7','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.8452 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.8465 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.8487 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.8498 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.8502 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.8511 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.8521 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.8544 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664301045366430ccbcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,50000,?,?,?)
20240514@080339.8763 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.8777 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.8782 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664301045366430ccbcf','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.8786 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.8789 keag7kovmqdfbm1bdts6lm1man Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240514@080339.8800 keag7kovmqdfbm1bdts6lm1man Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240514@080339.8810 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.8821 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.8845 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.8856 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.8860 keag7kovmqdfbm1bdts6lm1man Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240514@080339.8876 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.8885 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.8896 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.8917 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664305532066430ccbd8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240514@080339.9144 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.9163 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.9168 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664305532066430ccbd8','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.9173 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.9186 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.9209 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.9221 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.9225 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.9234 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.9246 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.9266 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664301060666430ccbe1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,80000,?,?,?)
20240514@080339.9496 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.9510 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.9514 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664301060666430ccbe1','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.9519 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080339.9522 keag7kovmqdfbm1bdts6lm1man Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240514@080339.9532 keag7kovmqdfbm1bdts6lm1man Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240514@080339.9544 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.9558 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080339.9581 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.9594 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080339.9601 keag7kovmqdfbm1bdts6lm1man Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240514@080339.9611 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080339.9621 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.9633 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080339.9732 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664303216666430ccbea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240514@080339.9955 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080339.9970 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080339.9974 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664303216666430ccbea','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080339.9980 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080339.9992 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080340.1500 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.2700 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080340.3100 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080340.4200 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.5400 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080340.7700 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664305749166430ccc01',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,110000,?,?,?)
20240514@080340.3010 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.3150 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080340.3200 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664305749166430ccc01','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080340.3240 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080340.3270 keag7kovmqdfbm1bdts6lm1man Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240514@080340.3370 keag7kovmqdfbm1bdts6lm1man Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240514@080340.3490 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.3620 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080340.3840 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.3970 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080340.4010 keag7kovmqdfbm1bdts6lm1man Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240514@080340.4120 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080340.4220 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.4340 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080340.4580 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664305482966430ccc0a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240514@080340.6810 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.6980 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080340.7030 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664305482966430ccc0a','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080340.7080 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.7220 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080340.7530 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.7650 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080340.7690 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080340.7780 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.7910 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080340.8150 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664301677566430ccc13',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,140000,?,?,?)
20240514@080340.1062 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.1081 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080340.1086 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664301677566430ccc13','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080340.1090 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080340.1093 keag7kovmqdfbm1bdts6lm1man Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240514@080340.1106 keag7kovmqdfbm1bdts6lm1man Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240514@080340.1118 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.1132 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080340.1165 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.1177 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080340.1181 keag7kovmqdfbm1bdts6lm1man Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240514@080340.1192 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080340.1202 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.1213 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080340.1236 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664301543366430ccc1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240514@080340.1494 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.1510 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080340.1514 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664301543366430ccc1d','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080340.1520 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.1532 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@080340.1557 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.1569 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@080340.1573 keag7kovmqdfbm1bdts6lm1man Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@080340.1583 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@080340.1596 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@080340.1619 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664301378366430ccc26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664302144066430ccb98' ,0,0 ,2,23.00,170000,?,?,?)
20240514@080340.1841 keag7kovmqdfbm1bdts6lm1man Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@080340.1856 keag7kovmqdfbm1bdts6lm1man Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@080340.1861 keag7kovmqdfbm1bdts6lm1man Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664301378366430ccc26','aut664302144066430ccb98' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@080340.1865 keag7kovmqdfbm1bdts6lm1man Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664302144066430ccb98','2403375','wait',39,'ari17112337378,753000005')
20240514@080340.1881 keag7kovmqdfbm1bdts6lm1man Query : use flama_phc
20240514@080340.1884 keag7kovmqdfbm1bdts6lm1man Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@080340.1897 keag7kovmqdfbm1bdts6lm1man Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1644';
20240514@080340.1912 keag7kovmqdfbm1bdts6lm1man Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1644';
20240514@080340.1929 keag7kovmqdfbm1bdts6lm1man Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1644';
20240514@080340.1942 keag7kovmqdfbm1bdts6lm1man Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1644';
20240514@080340.2372 o31qekk6qohnheav7gg8dbpjlh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@080340.2385 o31qekk6qohnheav7gg8dbpjlh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@080340.2405 o31qekk6qohnheav7gg8dbpjlh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1645';
20240514@080340.2447 o31qekk6qohnheav7gg8dbpjlh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1645';
20240514@080340.2471 o31qekk6qohnheav7gg8dbpjlh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1645';
20240514@080340.2487 o31qekk6qohnheav7gg8dbpjlh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1645';
20240514@080340.2507 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.2510 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@080340.2524 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.2527 o31qekk6qohnheav7gg8dbpjlh Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240514@080340.2569 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240514@080340.2739 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403376 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240514@080340.3061 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240514@080340.3075 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403376 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240514@080340.3082 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240514@080340.3092 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403376 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240514@080340.3097 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240514@080340.3110 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2033 and bo.obrano = 2403376 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240514@080340.3116 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3119 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@080340.3131 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3134 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 1 valor from td where td.ndoc = 39
20240514@080340.3144 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3148 o31qekk6qohnheav7gg8dbpjlh Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@080340.3159 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@080340.3175 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3178 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240514@080340.3193 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3196 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@080340.3206 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3209 o31qekk6qohnheav7gg8dbpjlh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@080340.3220 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3223 o31qekk6qohnheav7gg8dbpjlh Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240514@080340.3237 o31qekk6qohnheav7gg8dbpjlh Query : use flama_phc
20240514@080340.3240 o31qekk6qohnheav7gg8dbpjlh Query : select 1 valor from td where ndoc = 39
20240514@080340.3249 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@080340.3260 o31qekk6qohnheav7gg8dbpjlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@080340.3278 o31qekk6qohnheav7gg8dbpjlh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@080340.3296 o31qekk6qohnheav7gg8dbpjlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080340.3311 o31qekk6qohnheav7gg8dbpjlh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@080340.3342 o31qekk6qohnheav7gg8dbpjlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080340.3354 o31qekk6qohnheav7gg8dbpjlh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@080340.3428 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080340.3559 o31qekk6qohnheav7gg8dbpjlh Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@080340.3638 o31qekk6qohnheav7gg8dbpjlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@080340.3667 o31qekk6qohnheav7gg8dbpjlh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@080340.3677 o31qekk6qohnheav7gg8dbpjlh Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664305081566430ccc53' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@080340.3925 o31qekk6qohnheav7gg8dbpjlh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@080340.3943 o31qekk6qohnheav7gg8dbpjlh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
