20241017@182832.3823 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241017@182832.3897 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.3901 9bavaqqul4mnn4acjbejntmla9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241017@182832.3983 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241017@182832.4112 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406776 and bi.ref ='324.2301.00.3' and bi.lordem =1
20241017@182832.4418 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241017@182832.4441 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406776 and bi.ref ='324.2301.00.3' and bi.lordem =1
20241017@182832.4482 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241017@182832.4596 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406776 and bi.ref ='324.2335.00.1' and bi.lordem =2
20241017@182832.4901 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241017@182832.4922 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406776 and bi.ref ='324.2335.00.1' and bi.lordem =2
20241017@182832.4938 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241017@182832.4958 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406776 and bi.ref ='324.2335.00.1' and bi.lordem =2
20241017@182832.4976 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.4979 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241017@182832.5018 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.5029 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 1 valor from td where td.ndoc = 39
20241017@182832.5130 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.5134 9bavaqqul4mnn4acjbejntmla9 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241017@182832.5179 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241017@182832.5306 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.5348 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241017@182832.5531 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.5534 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241017@182832.5575 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.5578 9bavaqqul4mnn4acjbejntmla9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241017@182832.5735 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.5746 9bavaqqul4mnn4acjbejntmla9 Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241017@182832.5799 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.5801 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from td where ndoc = 39
20241017@182832.5820 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241017@182832.5842 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.5869 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182832.5917 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.5933 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182832.5960 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.5976 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182832.5988 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182832.6060 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182832.6091 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.6105 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182832.6127 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67114350896711494092' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241017@182832.6444 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.6461 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182832.6510 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241017@182832.6522 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241017@182832.6542 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241017@182832.6554 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241017@182832.6566 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241017@182832.6577 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241017@182832.6589 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67114350896711494092',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241017@182832.7208 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 fno valor from wsftdata order by fno desc
20241017@182832.7242 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.7259 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182832.7283 9bavaqqul4mnn4acjbejntmla9 Query : select 'normal' from dummy
20241017@182832.7314 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67114350896711494092',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1344,102253,0,'2024-10-17',39,'euro',0,0,2024 ,?,?)
20241017@182832.7761 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.7764 9bavaqqul4mnn4acjbejntmla9 Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241017@182832.7794 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241017@182832.7911 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.7928 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182832.7956 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.7971 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182832.7979 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182832.7997 9bavaqqul4mnn4acjbejntmla9 Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241017@182832.8013 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.8028 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182832.8047 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671148346067114940c3','aut67114350896711494092' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182832.8080 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.8096 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182832.8129 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671148346067114940c3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut67114350896711494092' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241017@182832.8693 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.8696 9bavaqqul4mnn4acjbejntmla9 Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241017@182832.8718 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241017@182832.8734 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.8751 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182832.8780 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.8797 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182832.8831 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182832.8847 9bavaqqul4mnn4acjbejntmla9 Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241017@182832.8860 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.8876 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182832.8890 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671142649867114940d8','aut67114350896711494092' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182832.8895 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.8910 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182832.9138 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671142649867114940d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut67114350896711494092' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241017@182832.9373 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.9377 9bavaqqul4mnn4acjbejntmla9 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241017@182832.9398 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241017@182832.9511 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.9528 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182832.9571 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.9586 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182832.9595 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182832.9608 9bavaqqul4mnn4acjbejntmla9 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241017@182832.9622 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.9639 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182832.9650 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671140162767114940ea','aut67114350896711494092' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182832.9654 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.9670 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182832.9699 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671140162767114940ea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67114350896711494092' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241017@182832.9933 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182832.9936 9bavaqqul4mnn4acjbejntmla9 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241017@182832.9957 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241017@182832.9970 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182832.9986 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.1400 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.3000 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.3800 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182833.6100 9bavaqqul4mnn4acjbejntmla9 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241017@182833.7300 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.9200 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.7200 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114634396711494101','aut67114350896711494092' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182833.7250 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.7410 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.7720 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67114634396711494101',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut67114350896711494092' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241017@182833.9970 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182833.1000 9bavaqqul4mnn4acjbejntmla9 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241017@182833.1046 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241017@182833.1059 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.1075 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.1099 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.1113 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.1121 9bavaqqul4mnn4acjbejntmla9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182833.1133 9bavaqqul4mnn4acjbejntmla9 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241017@182833.1145 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.1166 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.1179 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711449997671149411b','aut67114350896711494092' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182833.1183 9bavaqqul4mnn4acjbejntmla9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.1199 9bavaqqul4mnn4acjbejntmla9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.1228 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6711449997671149411b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut67114350896711494092' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241017@182833.1463 9bavaqqul4mnn4acjbejntmla9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67114350896711494092','2406776','wait',39,'adm09112754980.682000002')
20241017@182833.1592 9bavaqqul4mnn4acjbejntmla9 Query : use flama_phc
20241017@182833.1595 9bavaqqul4mnn4acjbejntmla9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241017@182833.1631 9bavaqqul4mnn4acjbejntmla9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2747';
20241017@182833.1673 9bavaqqul4mnn4acjbejntmla9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2747';
20241017@182833.1723 9bavaqqul4mnn4acjbejntmla9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2747';
20241017@182833.1752 9bavaqqul4mnn4acjbejntmla9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2747';
20241017@182833.2847 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241017@182833.2858 16cnmgaqrpbl7q6o3fru1ddr2u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241017@182833.2943 16cnmgaqrpbl7q6o3fru1ddr2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2748';
20241017@182833.3156 16cnmgaqrpbl7q6o3fru1ddr2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2748';
20241017@182833.3251 16cnmgaqrpbl7q6o3fru1ddr2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2748';
20241017@182833.3303 16cnmgaqrpbl7q6o3fru1ddr2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2748';
20241017@182833.3358 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.3361 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241017@182833.3426 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.3429 16cnmgaqrpbl7q6o3fru1ddr2u Query : select no, estab,szadrsdesc from szadrs where u_coddest=4779
20241017@182833.3520 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20241017@182833.3658 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406818 and bi.ref ='324.2232.00.1' and bi.lordem =1
20241017@182833.3967 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20241017@182833.4099 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406818 and bi.ref ='324.4980.00.1' and bi.lordem =2
20241017@182833.4394 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4397 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241017@182833.4445 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4448 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 1 valor from td where td.ndoc = 39
20241017@182833.4480 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4483 16cnmgaqrpbl7q6o3fru1ddr2u Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241017@182833.4551 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241017@182833.4592 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4596 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 ~inactivo valor from cl where no = '101900' and estab = 0 order by inactivo desc
20241017@182833.4694 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4704 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241017@182833.4736 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4739 16cnmgaqrpbl7q6o3fru1ddr2u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241017@182833.4802 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4805 16cnmgaqrpbl7q6o3fru1ddr2u Query : select szadrsstamp valor from szadrs where szadrsdesc='101900 - pd - alcochete'
20241017@182833.4863 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.4866 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from td where ndoc = 39
20241017@182833.4881 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241017@182833.4896 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.4913 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182833.4934 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.4961 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182833.5000 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.5018 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182833.5033 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182833.5113 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182833.5128 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.5144 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182833.5161 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6711466927671149417a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241017@182833.5323 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.5340 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182833.5375 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241017@182833.5387 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241017@182833.5399 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241017@182833.5426 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241017@182833.5439 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241017@182833.5450 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241017@182833.5461 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6711466927671149417a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241017@182833.5664 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 fno valor from wsftdata order by fno desc
20241017@182833.5694 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.5708 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182833.5732 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 'normal' from dummy
20241017@182833.5888 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6711466927671149417a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1345,101900,0,'2024-10-17',39,'euro',0,0,2024 ,?,?)
20241017@182833.6154 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.6157 16cnmgaqrpbl7q6o3fru1ddr2u Query : select st.usalote valor from st where st.ref = '324.2232.00.1'
20241017@182833.6183 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2232.00.1'
20241017@182833.6316 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.6334 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.6368 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.6385 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.6395 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182833.6410 16cnmgaqrpbl7q6o3fru1ddr2u Query : select sestamp valor from se where ref ='324.2232.00.1' and lote = 'r2400241100a'
20241017@182833.6442 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.6461 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.6474 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711438742671149419d','aut6711466927671149417a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182833.6479 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.6497 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.6550 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6711438742671149419d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6711466927671149417a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241017@182833.6778 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.6782 16cnmgaqrpbl7q6o3fru1ddr2u Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241017@182833.6806 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4980.00.1'
20241017@182833.6936 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.6954 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.6984 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.7001 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.7011 16cnmgaqrpbl7q6o3fru1ddr2u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182833.7026 16cnmgaqrpbl7q6o3fru1ddr2u Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2400145100a'
20241017@182833.7058 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.7076 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182833.7090 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671146992667114941ac','aut6711466927671149417a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182833.7095 16cnmgaqrpbl7q6o3fru1ddr2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182833.7111 16cnmgaqrpbl7q6o3fru1ddr2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182833.7158 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671146992667114941ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6711466927671149417a' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241017@182833.7380 16cnmgaqrpbl7q6o3fru1ddr2u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6711466927671149417a','2406818','wait',39,'adm09112754980.682000002')
20241017@182833.7462 16cnmgaqrpbl7q6o3fru1ddr2u Query : use flama_phc
20241017@182833.7466 16cnmgaqrpbl7q6o3fru1ddr2u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241017@182833.7506 16cnmgaqrpbl7q6o3fru1ddr2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2748';
20241017@182833.7539 16cnmgaqrpbl7q6o3fru1ddr2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2748';
20241017@182833.7584 16cnmgaqrpbl7q6o3fru1ddr2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2748';
20241017@182833.7615 16cnmgaqrpbl7q6o3fru1ddr2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2748';
20241017@182833.9053 05gk7dc5blb1asc9881lngna4q Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241017@182833.9064 05gk7dc5blb1asc9881lngna4q Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241017@182833.9124 05gk7dc5blb1asc9881lngna4q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2749';
20241017@182833.9203 05gk7dc5blb1asc9881lngna4q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2749';
20241017@182833.9260 05gk7dc5blb1asc9881lngna4q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2749';
20241017@182833.9289 05gk7dc5blb1asc9881lngna4q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2749';
20241017@182833.9350 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182833.9354 05gk7dc5blb1asc9881lngna4q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241017@182833.9416 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182833.9420 05gk7dc5blb1asc9881lngna4q Query : select no, estab,szadrsdesc from szadrs where u_coddest=171
20241017@182833.9496 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241017@182833.9682 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.692.00.01' and bi.lordem =1
20241017@182834.1500 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.644.00.01'
20241017@182834.1480 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.644.00.01' and bi.lordem =2
20241017@182834.4400 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241017@182834.5490 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.2317.00.1' and bi.lordem =3
20241017@182834.8640 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2318.00.1'
20241017@182834.9740 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.2318.00.1' and bi.lordem =4
20241017@182834.1276 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2300.00.1'
20241017@182834.1408 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.2300.00.1' and bi.lordem =5
20241017@182834.1745 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241017@182834.2057 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.2366.00.1' and bi.lordem =6
20241017@182834.2384 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241017@182834.2406 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.2366.00.1' and bi.lordem =7
20241017@182834.2719 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20241017@182834.2841 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.2388.00.1' and bi.lordem =8
20241017@182834.3349 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20241017@182834.3809 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='323.318.09.00' and bi.lordem =9
20241017@182834.4188 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.678.00.01'
20241017@182834.4313 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.678.00.01' and bi.lordem =10
20241017@182834.4621 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.678.00.01'
20241017@182834.4641 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.678.00.01' and bi.lordem =10
20241017@182834.4659 05gk7dc5blb1asc9881lngna4q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.648.00.01'
20241017@182834.4767 05gk7dc5blb1asc9881lngna4q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406851 and bi.ref ='324.648.00.01' and bi.lordem =11
20241017@182834.5059 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5062 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241017@182834.5093 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5098 05gk7dc5blb1asc9881lngna4q Query : select top 1 1 valor from td where td.ndoc = 39
20241017@182834.5131 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5134 05gk7dc5blb1asc9881lngna4q Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241017@182834.5163 05gk7dc5blb1asc9881lngna4q Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241017@182834.5219 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5222 05gk7dc5blb1asc9881lngna4q Query : select top 1 ~inactivo valor from cl where no = '101668' and estab = 0 order by inactivo desc
20241017@182834.5314 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5317 05gk7dc5blb1asc9881lngna4q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241017@182834.5349 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5351 05gk7dc5blb1asc9881lngna4q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241017@182834.5403 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5405 05gk7dc5blb1asc9881lngna4q Query : select szadrsstamp valor from szadrs where szadrsdesc='manuel assentiz, lda'
20241017@182834.5467 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.5470 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from td where ndoc = 39
20241017@182834.5482 05gk7dc5blb1asc9881lngna4q Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241017@182834.5496 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.5511 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182834.5529 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.5543 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182834.5570 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.5589 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182834.5602 05gk7dc5blb1asc9881lngna4q Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182834.5667 05gk7dc5blb1asc9881lngna4q Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182834.5680 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.5712 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182834.5727 05gk7dc5blb1asc9881lngna4q Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241017@182834.5887 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.6033 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182834.6066 05gk7dc5blb1asc9881lngna4q Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241017@182834.6079 05gk7dc5blb1asc9881lngna4q Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241017@182834.6090 05gk7dc5blb1asc9881lngna4q Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241017@182834.6102 05gk7dc5blb1asc9881lngna4q Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241017@182834.6131 05gk7dc5blb1asc9881lngna4q Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241017@182834.6142 05gk7dc5blb1asc9881lngna4q Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241017@182834.6154 05gk7dc5blb1asc9881lngna4q Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67114750586711494288',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241017@182834.6374 05gk7dc5blb1asc9881lngna4q Query : select top 1 fno valor from wsftdata order by fno desc
20241017@182834.6411 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.6430 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182834.6453 05gk7dc5blb1asc9881lngna4q Query : select 'normal' from dummy
20241017@182834.6487 05gk7dc5blb1asc9881lngna4q Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67114750586711494288',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1346,101668,0,'2024-10-17',39,'euro',0,0,2024 ,?,?)
20241017@182834.6738 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.6741 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241017@182834.6764 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.692.00.01'
20241017@182834.6916 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.6935 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.6963 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.6979 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.6987 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182834.7000 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400209100a'
20241017@182834.7031 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.7051 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.7068 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671148117667114942ab','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182834.7072 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.7090 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.7146 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671148117667114942ab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241017@182834.7402 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.7422 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.7454 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.7491 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.7502 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182834.7517 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.7534 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.7548 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671147321067114942b7','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182834.7553 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.7570 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.7613 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671147321067114942b7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114750586711494288' ,0,0 ,2,23.00,20000,?,?,?)
20241017@182834.7886 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.7890 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.644.00.01'
20241017@182834.7913 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.644.00.01'
20241017@182834.8038 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8057 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.8088 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8124 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.8134 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182834.8149 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.644.00.01' and lote = 'r2400749200a'
20241017@182834.8164 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8181 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.8194 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671146030367114942c7','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182834.8198 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8214 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.8255 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671146030367114942c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241017@182834.8479 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.8483 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.2317.00.1'
20241017@182834.8504 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2317.00.1'
20241017@182834.8656 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8673 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.8700 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8716 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.8726 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182834.8739 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.2317.00.1' and lote = 'r2100576500a'
20241017@182834.8772 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8789 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.8802 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671147652967114942d6','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182834.8807 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.8823 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.8856 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671147652967114942d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241017@182834.9107 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9123 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.9150 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9174 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.9183 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182834.9198 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9214 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.9226 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671142743367114942e0','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182834.9230 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9245 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.9293 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671142743367114942e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114750586711494288' ,0,0 ,2,23.00,60000,?,?,?)
20241017@182834.9514 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182834.9518 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.2318.00.1'
20241017@182834.9539 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2318.00.1'
20241017@182834.9707 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9723 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.9752 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9766 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.9775 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182834.9787 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.2318.00.1' and lote = 'r2100669100a'
20241017@182834.9801 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9815 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182834.9827 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671147939067114942ef','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182834.9831 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182834.9856 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182834.9885 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671147939067114942ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241017@182835.1150 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1320 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.1590 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1750 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.1840 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.1970 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2380 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.2500 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114586496711494304','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.2550 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2700 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.2990 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67114586496711494304',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114750586711494288' ,0,0 ,2,23.00,90000,?,?,?)
20241017@182835.5250 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.5300 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241017@182835.5500 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2300.00.1'
20241017@182835.6870 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.7040 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.7300 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.7440 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.7550 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.7680 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400499200a'
20241017@182835.7870 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.8020 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.8220 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114128356711494313','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.8260 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.8410 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.8700 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67114128356711494313',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241017@182835.1102 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.1105 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241017@182835.1125 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2366.00.1'
20241017@182835.1262 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1278 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.1326 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1342 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.1353 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.1366 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2300548100a'
20241017@182835.1380 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1394 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.1414 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114659856711494321','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.1419 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1434 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.1477 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67114659856711494321',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20241017@182835.1723 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.1726 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241017@182835.1745 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2366.00.1'
20241017@182835.1759 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1784 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.1811 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1827 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.1838 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.1850 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2300548100a'
20241017@182835.1864 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1898 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.1910 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711477245671149432d','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.1914 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.1929 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.1957 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6711477245671149432d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241017@182835.2200 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.2203 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20241017@182835.2224 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2388.00.1'
20241017@182835.2362 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2378 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.2403 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2418 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.2427 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.2439 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20241017@182835.2453 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2477 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.2488 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711485942671149433b','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.2492 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2510 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.2557 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6711485942671149433b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20241017@182835.2779 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.2784 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20241017@182835.2806 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '323.318.09.00'
20241017@182835.2940 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2956 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.2981 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.2996 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.3004 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.3017 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2400053200a'
20241017@182835.3044 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.3060 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.3073 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711427357671149434a','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.3077 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.3091 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.3123 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6711427357671149434a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20241017@182835.3374 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.3378 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.678.00.01'
20241017@182835.3400 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.678.00.01'
20241017@182835.3516 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.3533 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.3560 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.3587 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.3596 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.3608 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.678.00.01' and lote = 'r2400745200a'
20241017@182835.3622 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.3638 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.3650 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114089136711494358','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.3654 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.3668 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.3697 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67114089136711494358',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241017@182835.3955 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.3972 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.4009 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4026 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.4034 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.4046 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4061 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.4091 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114882226711494362','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.4095 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4110 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.4138 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67114882226711494362',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114750586711494288' ,0,0 ,2,23.00,170000,?,?,?)
20241017@182835.4383 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.4390 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.678.00.01'
20241017@182835.4413 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.678.00.01'
20241017@182835.4430 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4458 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.4486 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4502 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.4511 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.4523 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.678.00.01' and lote = 'r2400745200a'
20241017@182835.4558 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4573 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.4584 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711430269671149436f','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.4588 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4603 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.4630 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6711430269671149436f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241017@182835.4897 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4916 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.4946 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.4961 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.4970 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.5004 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5019 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.5031 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711419776671149437a','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.5035 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5049 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.5077 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6711419776671149437a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114750586711494288' ,0,0 ,2,23.00,200000,?,?,?)
20241017@182835.5301 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.5305 05gk7dc5blb1asc9881lngna4q Query : select st.usalote valor from st where st.ref = '324.648.00.01'
20241017@182835.5326 05gk7dc5blb1asc9881lngna4q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.648.00.01'
20241017@182835.5514 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5531 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.5558 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5573 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.5582 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.5594 05gk7dc5blb1asc9881lngna4q Query : select sestamp valor from se where ref ='324.648.00.01' and lote = 'r2400750200a'
20241017@182835.5608 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5623 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.5635 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114582346711494388','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.5639 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5653 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.5681 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67114582346711494388',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67114750586711494288' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241017@182835.5939 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5955 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.5981 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.5996 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.6004 05gk7dc5blb1asc9881lngna4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182835.6017 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.6161 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182835.6176 05gk7dc5blb1asc9881lngna4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114214746711494392','aut67114750586711494288' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182835.6181 05gk7dc5blb1asc9881lngna4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182835.6198 05gk7dc5blb1asc9881lngna4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182835.6247 05gk7dc5blb1asc9881lngna4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67114214746711494392',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114750586711494288' ,0,0 ,2,23.00,230000,?,?,?)
20241017@182835.6483 05gk7dc5blb1asc9881lngna4q Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67114750586711494288','2406851','wait',39,'adm09112754980.682000002')
20241017@182835.6561 05gk7dc5blb1asc9881lngna4q Query : use flama_phc
20241017@182835.6564 05gk7dc5blb1asc9881lngna4q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241017@182835.6611 05gk7dc5blb1asc9881lngna4q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2749';
20241017@182835.6645 05gk7dc5blb1asc9881lngna4q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2749';
20241017@182835.6690 05gk7dc5blb1asc9881lngna4q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2749';
20241017@182835.6716 05gk7dc5blb1asc9881lngna4q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2749';
20241017@182835.7892 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241017@182835.7903 b36fqafg1o01jrf7pdiqj4ek93 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241017@182835.7968 b36fqafg1o01jrf7pdiqj4ek93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2750';
20241017@182835.8028 b36fqafg1o01jrf7pdiqj4ek93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2750';
20241017@182835.8086 b36fqafg1o01jrf7pdiqj4ek93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2750';
20241017@182835.8117 b36fqafg1o01jrf7pdiqj4ek93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2750';
20241017@182835.8175 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182835.8178 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241017@182835.9061 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182835.9064 b36fqafg1o01jrf7pdiqj4ek93 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1476
20241017@182835.9152 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20241017@182835.9269 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406853 and bi.ref ='324.1643.00.1' and bi.lordem =1
20241017@182835.9589 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20241017@182835.9611 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406853 and bi.ref ='324.1643.00.1' and bi.lordem =2
20241017@182835.9900 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.711.00.01'
20241017@182836.1100 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406853 and bi.ref ='324.711.00.01' and bi.lordem =3
20241017@182836.2890 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20241017@182836.4050 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406853 and bi.ref ='324.681.00.01' and bi.lordem =4
20241017@182836.6980 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20241017@182836.8090 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406853 and bi.ref ='324.1670.00.1' and bi.lordem =5
20241017@182836.1102 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1105 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241017@182836.1142 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1146 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 1 valor from td where td.ndoc = 39
20241017@182836.1176 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1179 b36fqafg1o01jrf7pdiqj4ek93 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20241017@182836.1216 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241017@182836.1256 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1260 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 ~inactivo valor from cl where no = '101638' and estab = 0 order by inactivo desc
20241017@182836.1357 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1359 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241017@182836.1395 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1398 b36fqafg1o01jrf7pdiqj4ek93 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241017@182836.1448 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1451 b36fqafg1o01jrf7pdiqj4ek93 Query : select szadrsstamp valor from szadrs where szadrsdesc='almendre faria dos santos, lda'
20241017@182836.1498 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.1501 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from td where ndoc = 39
20241017@182836.1513 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241017@182836.1535 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.1555 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182836.1581 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.2560 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182836.2744 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.2761 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182836.2775 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182836.2840 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241017@182836.2854 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.2870 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241017@182836.2889 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241017@182836.3103 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.3125 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241017@182836.3164 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241017@182836.3179 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241017@182836.3191 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241017@182836.3205 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241017@182836.3228 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241017@182836.3240 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241017@182836.3253 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67114615116711494443',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241017@182836.3469 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 fno valor from wsftdata order by fno desc
20241017@182836.3493 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.3517 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241017@182836.3541 b36fqafg1o01jrf7pdiqj4ek93 Query : select 'normal' from dummy
20241017@182836.3556 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67114615116711494443',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1347,101638,0,'2024-10-17',39,'euro',0,0,2024 ,?,?)
20241017@182836.3824 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.3828 b36fqafg1o01jrf7pdiqj4ek93 Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241017@182836.3893 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20241017@182836.4042 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4061 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.4088 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4105 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.4114 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182836.4127 b36fqafg1o01jrf7pdiqj4ek93 Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241017@182836.4142 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4157 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.4169 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114119326711494465','aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182836.4173 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4188 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.4217 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67114119326711494465',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut67114615116711494443' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241017@182836.4447 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.4450 b36fqafg1o01jrf7pdiqj4ek93 Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241017@182836.4470 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20241017@182836.4484 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4499 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.4524 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4539 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.4548 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182836.4559 b36fqafg1o01jrf7pdiqj4ek93 Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241017@182836.4575 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4589 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.4600 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6711445614671149446f','aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182836.4604 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.4618 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.4646 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6711445614671149446f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67114615116711494443' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241017@182836.5840 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.5891 b36fqafg1o01jrf7pdiqj4ek93 Query : select st.usalote valor from st where st.ref = '324.711.00.01'
20241017@182836.5916 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.711.00.01'
20241017@182836.6036 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6051 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.6077 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6091 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.6100 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182836.6113 b36fqafg1o01jrf7pdiqj4ek93 Query : select sestamp valor from se where ref ='324.711.00.01' and lote = 'r2301222100a'
20241017@182836.6135 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6150 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.6291 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67114319936711494495','aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182836.6296 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6313 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.6344 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67114319936711494495',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67114615116711494443' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241017@182836.6577 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6595 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.6625 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6640 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.6657 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182836.6670 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6687 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.6699 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671143999567114944a2','aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182836.6703 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.6718 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.6749 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671143999567114944a2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114615116711494443' ,0,0 ,2,23.00,40000,?,?,?)
20241017@182836.6972 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.6977 b36fqafg1o01jrf7pdiqj4ek93 Query : select st.usalote valor from st where st.ref = '324.681.00.01'
20241017@182836.6999 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.681.00.01'
20241017@182836.7141 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7158 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.7186 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7200 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.7210 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182836.7222 b36fqafg1o01jrf7pdiqj4ek93 Query : select sestamp valor from se where ref ='324.681.00.01' and lote = 'r2400057200a'
20241017@182836.7242 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7264 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.7279 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671140183067114944b0','aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182836.7283 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7298 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.7329 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671140183067114944b0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67114615116711494443' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241017@182836.7556 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7571 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.7602 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7625 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.7634 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182836.7648 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7665 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.7678 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671143519467114944ba','aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182836.7683 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.7699 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.7729 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut671143519467114944ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67114615116711494443' ,0,0 ,2,23.00,70000,?,?,?)
20241017@182836.7980 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.7983 b36fqafg1o01jrf7pdiqj4ek93 Query : select st.usalote valor from st where st.ref = '324.1670.00.1'
20241017@182836.8005 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1670.00.1'
20241017@182836.8127 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.8143 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.8184 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.8200 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.8209 b36fqafg1o01jrf7pdiqj4ek93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241017@182836.8223 b36fqafg1o01jrf7pdiqj4ek93 Query : select sestamp valor from se where ref ='324.1670.00.1' and lote = 'r2301213200a'
20241017@182836.8242 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.8257 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241017@182836.8269 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut671145851467114944c9','aut67114615116711494443' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241017@182836.8273 b36fqafg1o01jrf7pdiqj4ek93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241017@182836.8289 b36fqafg1o01jrf7pdiqj4ek93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241017@182836.8319 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut671145851467114944c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67114615116711494443' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241017@182836.8540 b36fqafg1o01jrf7pdiqj4ek93 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67114615116711494443','2406853','wait',39,'adm09112754980.682000002')
20241017@182836.8613 b36fqafg1o01jrf7pdiqj4ek93 Query : use flama_phc
20241017@182836.8617 b36fqafg1o01jrf7pdiqj4ek93 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241017@182836.8647 b36fqafg1o01jrf7pdiqj4ek93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2750';
20241017@182836.8678 b36fqafg1o01jrf7pdiqj4ek93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2750';
20241017@182836.8725 b36fqafg1o01jrf7pdiqj4ek93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2750';
20241017@182836.8761 b36fqafg1o01jrf7pdiqj4ek93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2750';
20241017@182836.9493 ukukqjqjs1l7353l2ck845t4ba Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241017@182836.9504 ukukqjqjs1l7353l2ck845t4ba Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241017@182836.9573 ukukqjqjs1l7353l2ck845t4ba Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2751';
