20241119@074613.6356 enpeqmnue41ph350t4ortpio59 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@074613.6371 enpeqmnue41ph350t4ortpio59 Query : select sestamp valor from se where ref ='324.1462.00.1' and lote = 'r2100211100a'
20241119@074613.6385 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.6401 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074613.6413 enpeqmnue41ph350t4ortpio59 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673c420164673c42459b','aut673c405533673c424569' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@074613.6418 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.6434 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074613.6462 enpeqmnue41ph350t4ortpio59 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673c420164673c42459b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',19.000 ,'aut673c405533673c424569' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241119@074613.6820 enpeqmnue41ph350t4ortpio59 Query : use flama_phc
20241119@074613.6823 enpeqmnue41ph350t4ortpio59 Query : select st.usalote valor from st where st.ref = '324.1462.00.1'
20241119@074613.6844 enpeqmnue41ph350t4ortpio59 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.1462.00.1'
20241119@074613.6859 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.6874 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074613.6902 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.6916 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074613.6924 enpeqmnue41ph350t4ortpio59 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@074613.6937 enpeqmnue41ph350t4ortpio59 Query : select sestamp valor from se where ref ='324.1462.00.1' and lote = 'r2100463100a'
20241119@074613.6956 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.6971 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074613.6984 enpeqmnue41ph350t4ortpio59 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673c464885673c4245a9','aut673c405533673c424569' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@074613.6989 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.7004 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074613.7034 enpeqmnue41ph350t4ortpio59 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673c464885673c4245a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut673c405533673c424569' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241119@074613.7309 enpeqmnue41ph350t4ortpio59 Query : use flama_phc
20241119@074613.7313 enpeqmnue41ph350t4ortpio59 Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20241119@074613.7334 enpeqmnue41ph350t4ortpio59 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'
20241119@074613.7347 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.7364 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074613.7392 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.7410 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074613.7420 enpeqmnue41ph350t4ortpio59 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@074613.7434 enpeqmnue41ph350t4ortpio59 Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2400053200a'
20241119@074613.7448 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.7463 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074613.7474 enpeqmnue41ph350t4ortpio59 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673c484894673c4245b5','aut673c405533673c424569' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@074613.7484 enpeqmnue41ph350t4ortpio59 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074613.7500 enpeqmnue41ph350t4ortpio59 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074613.7527 enpeqmnue41ph350t4ortpio59 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673c484894673c4245b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut673c405533673c424569' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241119@074613.7961 enpeqmnue41ph350t4ortpio59 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673c405533673c424569','2407668','wait',39,'adm09112754980.682000002')
20241119@074613.8113 enpeqmnue41ph350t4ortpio59 Query : use flama_phc
20241119@074613.8117 enpeqmnue41ph350t4ortpio59 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@074613.8160 enpeqmnue41ph350t4ortpio59 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3372';
20241119@074613.8200 enpeqmnue41ph350t4ortpio59 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3372';
20241119@074613.8256 enpeqmnue41ph350t4ortpio59 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3372';
20241119@074613.8294 enpeqmnue41ph350t4ortpio59 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3372';
20241119@074613.8821 s7hvf1revdq2skmlfp2qr8him3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@074613.8833 s7hvf1revdq2skmlfp2qr8him3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@074613.8902 s7hvf1revdq2skmlfp2qr8him3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3373';
20241119@074613.8968 s7hvf1revdq2skmlfp2qr8him3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3373';
20241119@074613.9030 s7hvf1revdq2skmlfp2qr8him3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3373';
20241119@074613.9065 s7hvf1revdq2skmlfp2qr8him3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3373';
20241119@074613.9129 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074613.9133 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@074613.9205 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074613.9210 s7hvf1revdq2skmlfp2qr8him3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2410
20241119@074613.9321 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4005.00.2'
20241119@074613.9505 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407669 and bi.ref ='304.4005.00.2' and bi.lordem =1
20241119@074614.9000 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.658.00.01'
20241119@074614.2840 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407669 and bi.ref ='324.658.00.01' and bi.lordem =2
20241119@074614.6580 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.6620 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@074614.7010 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.7040 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 1 valor from td where td.ndoc = 39
20241119@074614.7380 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.7410 s7hvf1revdq2skmlfp2qr8him3 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')
20241119@074614.7730 s7hvf1revdq2skmlfp2qr8him3 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
20241119@074614.8130 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.8170 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 ~inactivo valor from cl where no = '102553' and estab = 0 order by inactivo desc
20241119@074614.9880 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.9920 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@074614.1029 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.1033 s7hvf1revdq2skmlfp2qr8him3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@074614.1073 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.1076 s7hvf1revdq2skmlfp2qr8him3 Query : select szadrsstamp valor from szadrs where szadrsdesc='tanqueluz - importaÇÃo, exportaÇÃo e comÉrcio de materi'
20241119@074614.1126 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.1130 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from td where ndoc = 39
20241119@074614.1144 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@074614.1159 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.1176 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@074614.1194 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.1209 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@074614.1239 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.1253 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@074614.1266 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@074614.1324 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@074614.1343 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.1359 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@074614.1375 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673c425221673c42461e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@074614.1557 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.1587 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@074614.1621 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@074614.1634 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@074614.1648 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@074614.1661 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@074614.1673 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@074614.1688 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@074614.1714 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673c425221673c42461e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@074614.2000 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 fno valor from wsftdata order by fno desc
20241119@074614.2155 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.2175 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@074614.2213 s7hvf1revdq2skmlfp2qr8him3 Query : select 'normal' from dummy
20241119@074614.2249 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673c425221673c42461e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1924,102553,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@074614.2666 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.2670 s7hvf1revdq2skmlfp2qr8him3 Query : select st.usalote valor from st where st.ref = '304.4005.00.2'
20241119@074614.2792 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4005.00.2'
20241119@074614.2972 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3082 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074614.3117 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3138 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074614.3148 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@074614.3163 s7hvf1revdq2skmlfp2qr8him3 Query : select sestamp valor from se where ref ='304.4005.00.2' and lote = '211257'
20241119@074614.3198 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3233 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074614.3247 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673c489753673c42464e','aut673c425221673c42461e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@074614.3252 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3270 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074614.3302 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673c489753673c42464e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut673c425221673c42461e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@074614.3662 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.3666 s7hvf1revdq2skmlfp2qr8him3 Query : select st.usalote valor from st where st.ref = '324.658.00.01'
20241119@074614.3693 s7hvf1revdq2skmlfp2qr8him3 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.658.00.01'
20241119@074614.3845 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3862 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074614.3888 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3903 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074614.3913 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@074614.3927 s7hvf1revdq2skmlfp2qr8him3 Query : select sestamp valor from se where ref ='324.658.00.01' and lote = 'r2300819200a'
20241119@074614.3943 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3959 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074614.3973 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673c404625673c424660','aut673c425221673c42461e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@074614.3978 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.3995 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074614.4030 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673c404625673c424660',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut673c425221673c42461e' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241119@074614.4310 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.4328 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074614.4423 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.4441 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074614.4451 s7hvf1revdq2skmlfp2qr8him3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@074614.4465 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.4480 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@074614.4493 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673c411281673c42466d','aut673c425221673c42461e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@074614.4498 s7hvf1revdq2skmlfp2qr8him3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@074614.4516 s7hvf1revdq2skmlfp2qr8him3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@074614.4549 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673c411281673c42466d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673c425221673c42461e' ,0,0 ,2,23.00,30000,?,?,?)
20241119@074614.4828 s7hvf1revdq2skmlfp2qr8him3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673c425221673c42461e','2407669','wait',39,'adm09112754980.682000002')
20241119@074614.4905 s7hvf1revdq2skmlfp2qr8him3 Query : use flama_phc
20241119@074614.4909 s7hvf1revdq2skmlfp2qr8him3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@074614.4946 s7hvf1revdq2skmlfp2qr8him3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3373';
20241119@074614.4987 s7hvf1revdq2skmlfp2qr8him3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3373';
20241119@074614.5037 s7hvf1revdq2skmlfp2qr8him3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3373';
20241119@074614.5072 s7hvf1revdq2skmlfp2qr8him3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3373';
20241119@081913.8245 hfspcphpsgaqqb209t6c8vbj1a Query : use flama_phc
20241119@081913.8249 hfspcphpsgaqqb209t6c8vbj1a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@081913.8369 hfspcphpsgaqqb209t6c8vbj1a Query : use flama_phc
20241119@081913.8373 hfspcphpsgaqqb209t6c8vbj1a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@083614.9160 ei6cmttq9n1otevod7474gce97 Query : use flama_phc
20241119@083614.9200 ei6cmttq9n1otevod7474gce97 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@083614.1110 ei6cmttq9n1otevod7474gce97 Query : use flama_phc
20241119@083614.1114 ei6cmttq9n1otevod7474gce97 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@091920.2051 m5pm2ks8cskv5n526ca3u39moi Query : use flama_phc
20241119@091920.2094 m5pm2ks8cskv5n526ca3u39moi Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@091920.2875 m5pm2ks8cskv5n526ca3u39moi Query : use flama_phc
20241119@091920.2917 m5pm2ks8cskv5n526ca3u39moi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@093620.2405 6qp1n5ika2s4shf2tj00oiltsh Query : use flama_phc
20241119@093620.2409 6qp1n5ika2s4shf2tj00oiltsh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@093620.2501 6qp1n5ika2s4shf2tj00oiltsh Query : use flama_phc
20241119@093620.2504 6qp1n5ika2s4shf2tj00oiltsh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@101919.2191 oraij7a8d5jub6o1u9pvr00iut Query : use flama_phc
20241119@101919.2196 oraij7a8d5jub6o1u9pvr00iut Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@101919.2304 oraij7a8d5jub6o1u9pvr00iut Query : use flama_phc
20241119@101919.2307 oraij7a8d5jub6o1u9pvr00iut Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@103618.9099 6riji96fis973h37ctugnl6ava Query : use flama_phc
20241119@103618.9110 6riji96fis973h37ctugnl6ava Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@103618.9255 6riji96fis973h37ctugnl6ava Query : use flama_phc
20241119@103618.9258 6riji96fis973h37ctugnl6ava Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@111917.5569 6hsf882vg6954jrmnea254pjm5 Query : use flama_phc
20241119@111917.5612 6hsf882vg6954jrmnea254pjm5 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@111917.6517 6hsf882vg6954jrmnea254pjm5 Query : use flama_phc
20241119@111917.6559 6hsf882vg6954jrmnea254pjm5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@113617.7880 gmnhhdk7e33uvmf7ubji5pbf84 Query : use flama_phc
20241119@113617.8310 gmnhhdk7e33uvmf7ubji5pbf84 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@113617.1642 gmnhhdk7e33uvmf7ubji5pbf84 Query : use flama_phc
20241119@113617.1684 gmnhhdk7e33uvmf7ubji5pbf84 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@121926.7961 5nihhmgdmoimbe0sp61fg6mov0 Query : use flama_phc
20241119@121926.7965 5nihhmgdmoimbe0sp61fg6mov0 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@121926.8059 5nihhmgdmoimbe0sp61fg6mov0 Query : use flama_phc
20241119@121926.8062 5nihhmgdmoimbe0sp61fg6mov0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@123627.6052 ln62voi4u9hlvp6jbu3joaudas Query : use flama_phc
20241119@123627.6058 ln62voi4u9hlvp6jbu3joaudas Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@123627.6191 ln62voi4u9hlvp6jbu3joaudas Query : use flama_phc
20241119@123627.6194 ln62voi4u9hlvp6jbu3joaudas Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@131917.6520 gbqkabuo2gc5ee7l31q83udgfo Query : use flama_phc
20241119@131917.6524 gbqkabuo2gc5ee7l31q83udgfo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@131917.6615 gbqkabuo2gc5ee7l31q83udgfo Query : use flama_phc
20241119@131917.6618 gbqkabuo2gc5ee7l31q83udgfo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@133617.6839 mvo9js3ol15vi8rr98gh7nqr1r Query : use flama_phc
20241119@133617.6844 mvo9js3ol15vi8rr98gh7nqr1r Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@133617.7083 mvo9js3ol15vi8rr98gh7nqr1r Query : use flama_phc
20241119@133617.7087 mvo9js3ol15vi8rr98gh7nqr1r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@141921.4590 606s9ug9h8ifn0f3ei71fmjjeq Query : use flama_phc
20241119@141921.4595 606s9ug9h8ifn0f3ei71fmjjeq Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@141921.4685 606s9ug9h8ifn0f3ei71fmjjeq Query : use flama_phc
20241119@141921.4688 606s9ug9h8ifn0f3ei71fmjjeq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@143621.7944 6ea9ds914q52vnecgkasrqd544 Query : use flama_phc
20241119@143621.7949 6ea9ds914q52vnecgkasrqd544 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@143621.8058 6ea9ds914q52vnecgkasrqd544 Query : use flama_phc
20241119@143621.8062 6ea9ds914q52vnecgkasrqd544 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@151919.9351 v6sjesct1a8jmipldbfsfi45qs Query : use flama_phc
20241119@151919.9355 v6sjesct1a8jmipldbfsfi45qs Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@151919.9488 v6sjesct1a8jmipldbfsfi45qs Query : use flama_phc
20241119@151919.9491 v6sjesct1a8jmipldbfsfi45qs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@153620.1383 h3tgfk52ardqm6s409ertivfi2 Query : use flama_phc
20241119@153620.1387 h3tgfk52ardqm6s409ertivfi2 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@153620.1549 h3tgfk52ardqm6s409ertivfi2 Query : use flama_phc
20241119@153620.1552 h3tgfk52ardqm6s409ertivfi2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@161918.5990 4kafjdspg4l861487ri940nvu2 Query : use flama_phc
20241119@161918.6030 4kafjdspg4l861487ri940nvu2 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@161918.7420 4kafjdspg4l861487ri940nvu2 Query : use flama_phc
20241119@161918.7450 4kafjdspg4l861487ri940nvu2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@163617.8885 t5csiuooocqhq34jnie6gq19dn Query : use flama_phc
20241119@163617.8889 t5csiuooocqhq34jnie6gq19dn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@163617.8990 t5csiuooocqhq34jnie6gq19dn Query : use flama_phc
20241119@163617.8993 t5csiuooocqhq34jnie6gq19dn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@171915.2230 8is5hpcqf5fmbsl8usc28tt2ml Query : use flama_phc
20241119@171915.2280 8is5hpcqf5fmbsl8usc28tt2ml Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@171915.3370 8is5hpcqf5fmbsl8usc28tt2ml Query : use flama_phc
20241119@171915.3410 8is5hpcqf5fmbsl8usc28tt2ml Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@173615.3270 qt5lvmvgf21l11b5dup05us2q3 Query : use flama_phc
20241119@173615.3275 qt5lvmvgf21l11b5dup05us2q3 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20241119@173615.3418 qt5lvmvgf21l11b5dup05us2q3 Query : use flama_phc
20241119@173615.3438 qt5lvmvgf21l11b5dup05us2q3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@180738.5161 vuna1gb6e318v11qf3vrb43i0k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@180738.5298 vuna1gb6e318v11qf3vrb43i0k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@180738.6140 vuna1gb6e318v11qf3vrb43i0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3374';
20241119@180738.6787 vuna1gb6e318v11qf3vrb43i0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3374';
20241119@180738.7675 vuna1gb6e318v11qf3vrb43i0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3374';
20241119@180738.8521 vuna1gb6e318v11qf3vrb43i0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3374';
20241119@180738.8869 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180738.8910 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@180738.9607 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180738.9648 vuna1gb6e318v11qf3vrb43i0k Query : select no, estab,szadrsdesc from szadrs where u_coddest=2459
20241119@180739.4200 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180739.5390 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407683 and bi.ref ='324.2300.00.1' and bi.lordem =1
20241119@180739.1368 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180739.1657 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407683 and bi.ref ='324.2300.00.1' and bi.lordem =2
20241119@180739.2420 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180739.2721 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407683 and bi.ref ='324.2300.00.1' and bi.lordem =2
20241119@180739.2932 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180739.3225 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407683 and bi.ref ='324.2300.00.1' and bi.lordem =2
20241119@180739.3433 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180739.3722 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407683 and bi.ref ='324.2300.00.1' and bi.lordem =2
20241119@180739.3929 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180739.4217 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407683 and bi.ref ='324.2300.00.1' and bi.lordem =2
20241119@180739.4425 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2308.00.1'
20241119@180739.4926 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407683 and bi.ref ='324.2308.00.1' and bi.lordem =3
20241119@180739.5724 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180739.5766 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@180739.6421 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180739.6463 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 1 valor from td where td.ndoc = 39
20241119@180739.6944 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180739.6986 vuna1gb6e318v11qf3vrb43i0k 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')
20241119@180739.7558 vuna1gb6e318v11qf3vrb43i0k 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
20241119@180739.9344 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180739.9444 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20241119@180740.9200 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180740.1330 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@180740.6110 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180740.6530 vuna1gb6e318v11qf3vrb43i0k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@180740.1139 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180740.1181 vuna1gb6e318v11qf3vrb43i0k Query : select szadrsstamp valor from szadrs where szadrsdesc='eldisser, s.a.'
20241119@180740.1717 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180740.1759 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from td where ndoc = 39
20241119@180740.2112 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@180740.2510 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180740.3482 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180740.4130 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180740.4382 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180740.5052 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180740.5304 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180740.5555 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180740.6137 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180740.7541 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180740.7890 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180740.8215 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@180740.9489 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180740.9739 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180741.4590 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@180741.7850 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@180741.1101 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@180741.1472 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@180741.1794 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@180741.2165 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@180741.2539 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673cd11354673cd3ec87',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@180741.6249 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 fno valor from wsftdata order by fno desc
20241119@180741.7038 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180741.7289 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180741.7744 vuna1gb6e318v11qf3vrb43i0k Query : select 'normal' from dummy
20241119@180741.8161 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673cd11354673cd3ec87',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1925,200500,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@180742.3100 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180742.7300 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241119@180742.6070 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180742.1113 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180742.1364 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180742.1953 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180742.2208 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180742.2376 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180742.2653 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241119@180742.2984 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180742.3235 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180742.3442 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd01161673cd3ee48','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180742.3691 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180742.3955 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180742.4583 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd01161673cd3ee48',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',54.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@180742.8930 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180742.8972 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241119@180742.9314 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180742.9567 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180742.9940 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180743.5300 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180743.7810 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180743.9460 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180743.1193 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241119@180743.1463 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180743.1731 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180743.1941 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd58589673cd3ef23','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180743.2025 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180743.2277 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180743.2903 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd58589673cd3ef23',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',36.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241119@180743.3484 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180743.3525 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241119@180743.3858 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180743.4108 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180743.4359 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180743.6780 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180743.7296 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180743.7462 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180743.7709 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241119@180743.7962 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180743.8215 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180743.8422 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd79164673cd3efc2','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180743.8466 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180743.8718 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180743.9335 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd79164673cd3efc2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241119@180743.9931 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180743.9977 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241119@180744.1143 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180744.1710 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.1961 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180744.2542 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.2805 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180744.2970 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180744.3217 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241119@180744.3464 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.3716 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180744.3927 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd91908673cd3f054','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180744.3970 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.4221 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180744.4840 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd91908673cd3f054',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',108.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241119@180744.5430 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180744.5471 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241119@180744.5809 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180744.6061 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.6312 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180744.6893 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.7343 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180744.7535 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180744.7965 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241119@180744.8301 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.8613 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180744.8820 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd52889673cd3f0ca','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180744.8864 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180744.9115 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180744.9735 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd52889673cd3f0ca',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',108.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241119@180745.3230 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180745.3640 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2300.00.1'
20241119@180745.8320 vuna1gb6e318v11qf3vrb43i0k 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'
20241119@180745.1082 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.1333 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180745.1999 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.2393 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180745.2674 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180745.3167 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2300.00.1' and lote = 'r2400497200a'
20241119@180745.3418 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.3716 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180745.4969 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd40704673cd3f153','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180745.5014 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.5266 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180745.5886 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd40704673cd3f153',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',108.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241119@180745.6479 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180745.6521 vuna1gb6e318v11qf3vrb43i0k Query : select st.usalote valor from st where st.ref = '324.2308.00.1'
20241119@180745.6854 vuna1gb6e318v11qf3vrb43i0k 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.2308.00.1'
20241119@180745.7356 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.7609 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180745.8334 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.8584 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180745.8749 vuna1gb6e318v11qf3vrb43i0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180745.8998 vuna1gb6e318v11qf3vrb43i0k Query : select sestamp valor from se where ref ='324.2308.00.1' and lote = 'r2400475700a'
20241119@180745.9251 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180745.9504 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180745.9711 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd32436673cd3f1e1','aut673cd11354673cd3ec87' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180745.9754 vuna1gb6e318v11qf3vrb43i0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.6000 vuna1gb6e318v11qf3vrb43i0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180746.9620 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd32436673cd3f1e1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut673cd11354673cd3ec87' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241119@180746.1576 vuna1gb6e318v11qf3vrb43i0k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673cd11354673cd3ec87','2407683','wait',39,'adm09112754980.682000002')
20241119@180746.2256 vuna1gb6e318v11qf3vrb43i0k Query : use flama_phc
20241119@180746.2298 vuna1gb6e318v11qf3vrb43i0k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@180746.2546 vuna1gb6e318v11qf3vrb43i0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3374';
20241119@180746.2851 vuna1gb6e318v11qf3vrb43i0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3374';
20241119@180746.3116 vuna1gb6e318v11qf3vrb43i0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3374';
20241119@180746.3420 vuna1gb6e318v11qf3vrb43i0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3374';
20241119@180746.5921 ndmf8qp9ndu45do1dls3v936sb Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@180746.5935 ndmf8qp9ndu45do1dls3v936sb Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@180746.6002 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180746.6061 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180746.6121 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180746.6156 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180746.6216 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6219 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@180746.6293 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6297 ndmf8qp9ndu45do1dls3v936sb Query : select no, estab,szadrsdesc from szadrs where u_coddest=805
20241119@180746.6381 ndmf8qp9ndu45do1dls3v936sb 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'
20241119@180746.6540 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407684 and bi.ref ='324.692.00.01' and bi.lordem =1
20241119@180746.6852 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6856 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@180746.6894 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6897 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 1 valor from td where td.ndoc = 39
20241119@180746.6929 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.6933 ndmf8qp9ndu45do1dls3v936sb 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')
20241119@180746.6966 ndmf8qp9ndu45do1dls3v936sb 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
20241119@180746.7003 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7007 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 ~inactivo valor from cl where no = '100247' and estab = 0 order by inactivo desc
20241119@180746.7136 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7139 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@180746.7174 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7177 ndmf8qp9ndu45do1dls3v936sb Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@180746.7221 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7224 ndmf8qp9ndu45do1dls3v936sb Query : select szadrsstamp valor from szadrs where szadrsdesc='acacio domingues afonso'
20241119@180746.7279 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180746.7282 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from td where ndoc = 39
20241119@180746.7296 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@180746.7351 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.7503 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180746.7840 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.7866 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180746.7927 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.7950 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180746.7977 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180746.8052 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180746.8095 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.8125 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180746.8173 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673cd02974673cd3f2c2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@180746.8399 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.8424 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180746.8518 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@180746.8536 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@180746.8555 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@180746.8574 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@180746.8592 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@180746.8627 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@180746.8653 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673cd02974673cd3f2c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@180746.8980 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 fno valor from wsftdata order by fno desc
20241119@180746.9026 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180746.9054 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180746.9349 ndmf8qp9ndu45do1dls3v936sb Query : select 'normal' from dummy
20241119@180746.9641 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673cd02974673cd3f2c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1926,100247,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@180747.3450 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180747.3490 ndmf8qp9ndu45do1dls3v936sb Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241119@180747.3780 ndmf8qp9ndu45do1dls3v936sb 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'
20241119@180747.6050 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.6250 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.6680 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.6880 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.6990 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180747.7150 ndmf8qp9ndu45do1dls3v936sb Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400210100a'
20241119@180747.7320 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.7510 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.7650 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd75921673cd3f311','aut673cd02974673cd3f2c2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180747.7760 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.7910 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.8200 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd75921673cd3f311',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut673cd02974673cd3f2c2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@180747.1294 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1311 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.1346 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1558 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.1709 ndmf8qp9ndu45do1dls3v936sb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180747.1734 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1757 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180747.1774 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd36334673cd3f32a','aut673cd02974673cd3f2c2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180747.1784 ndmf8qp9ndu45do1dls3v936sb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.1816 ndmf8qp9ndu45do1dls3v936sb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180747.1871 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd36334673cd3f32a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd02974673cd3f2c2' ,0,0 ,2,23.00,20000,?,?,?)
20241119@180747.2162 ndmf8qp9ndu45do1dls3v936sb Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673cd02974673cd3f2c2','2407684','wait',39,'adm09112754980.682000002')
20241119@180747.2286 ndmf8qp9ndu45do1dls3v936sb Query : use flama_phc
20241119@180747.2292 ndmf8qp9ndu45do1dls3v936sb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@180747.2344 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180747.2415 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180747.2470 ndmf8qp9ndu45do1dls3v936sb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3375';
20241119@180747.2518 ndmf8qp9ndu45do1dls3v936sb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3375';
20241119@180747.5151 okouukai4cbof6bsqi6dnir2t6 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@180747.5162 okouukai4cbof6bsqi6dnir2t6 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@180747.5233 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180747.5291 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180747.5348 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180747.5377 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180747.5438 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.5442 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@180747.5517 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.5521 okouukai4cbof6bsqi6dnir2t6 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2117
20241119@180747.5604 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20241119@180747.5760 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407685 and bi.ref ='324.1832.00.2' and bi.lordem =1
20241119@180747.7281 okouukai4cbof6bsqi6dnir2t6 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'
20241119@180747.7452 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407685 and bi.ref ='324.4980.00.1' and bi.lordem =2
20241119@180747.7787 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20241119@180747.7948 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407685 and bi.ref ='324.969.00.01' and bi.lordem =3
20241119@180747.8491 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8495 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@180747.8533 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8536 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 1 valor from td where td.ndoc = 39
20241119@180747.8590 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8594 okouukai4cbof6bsqi6dnir2t6 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')
20241119@180747.8642 okouukai4cbof6bsqi6dnir2t6 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
20241119@180747.8698 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8701 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 ~inactivo valor from cl where no = '102420' and estab = 0 order by inactivo desc
20241119@180747.8846 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8849 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@180747.8895 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8898 okouukai4cbof6bsqi6dnir2t6 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@180747.8969 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.8973 okouukai4cbof6bsqi6dnir2t6 Query : select szadrsstamp valor from szadrs where szadrsdesc='ri - eletrodomesticos lda'
20241119@180747.9047 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180747.9050 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from td where ndoc = 39
20241119@180747.9064 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@180747.9079 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9096 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180747.9117 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9132 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180747.9163 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9178 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180747.9191 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180747.9251 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180747.9265 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9282 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180747.9299 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@180747.9482 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9502 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180747.9543 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@180747.9557 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@180747.9569 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@180747.9582 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@180747.9594 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@180747.9647 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@180747.9660 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673cd20900673cd3f3e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@180747.9933 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 fno valor from wsftdata order by fno desc
20241119@180747.9960 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180747.9978 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180748.1000 okouukai4cbof6bsqi6dnir2t6 Query : select 'normal' from dummy
20241119@180748.1900 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673cd20900673cd3f3e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1927,102420,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@180748.3650 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.3810 okouukai4cbof6bsqi6dnir2t6 Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20241119@180748.4030 okouukai4cbof6bsqi6dnir2t6 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.1832.00.2'
20241119@180748.5520 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.5690 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.5960 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.6110 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.6200 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.6320 okouukai4cbof6bsqi6dnir2t6 Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301257100a'
20241119@180748.6550 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.6700 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.6820 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd66763673cd3f40f','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.6860 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.7000 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.7290 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd66763673cd3f40f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@180748.1026 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1043 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1068 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1084 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1092 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.1104 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1119 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1131 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd75526673cd3f41a','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.1135 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1149 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1179 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd75526673cd3f41a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,20000,?,?,?)
20241119@180748.1445 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.1448 okouukai4cbof6bsqi6dnir2t6 Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241119@180748.1469 okouukai4cbof6bsqi6dnir2t6 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'
20241119@180748.1627 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1644 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1670 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1685 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1693 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.1704 okouukai4cbof6bsqi6dnir2t6 Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2400145100a'
20241119@180748.1727 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1742 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.1754 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd95345673cd3f42a','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.1758 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.1773 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.1803 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd95345673cd3f42a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241119@180748.2098 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.2102 okouukai4cbof6bsqi6dnir2t6 Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241119@180748.2145 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.969.00.01'
20241119@180748.2324 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2341 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.2367 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2382 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.2391 okouukai4cbof6bsqi6dnir2t6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180748.2403 okouukai4cbof6bsqi6dnir2t6 Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241119@180748.2426 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2441 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180748.2454 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd06841673cd3f43b','aut673cd20900673cd3f3e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180748.2459 okouukai4cbof6bsqi6dnir2t6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180748.2474 okouukai4cbof6bsqi6dnir2t6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180748.2503 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd06841673cd3f43b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673cd20900673cd3f3e0' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241119@180748.2773 okouukai4cbof6bsqi6dnir2t6 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673cd20900673cd3f3e0','2407685','wait',39,'adm09112754980.682000002')
20241119@180748.2854 okouukai4cbof6bsqi6dnir2t6 Query : use flama_phc
20241119@180748.2857 okouukai4cbof6bsqi6dnir2t6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241119@180748.2894 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180748.2932 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180748.2987 okouukai4cbof6bsqi6dnir2t6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3376';
20241119@180748.3019 okouukai4cbof6bsqi6dnir2t6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3376';
20241119@180748.3905 unhobca0ioavusr5t6ttmgrjon Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241119@180748.3989 unhobca0ioavusr5t6ttmgrjon Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241119@180748.4472 unhobca0ioavusr5t6ttmgrjon Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3377';
20241119@180748.4846 unhobca0ioavusr5t6ttmgrjon Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3377';
20241119@180748.5202 unhobca0ioavusr5t6ttmgrjon Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3377';
20241119@180748.5507 unhobca0ioavusr5t6ttmgrjon Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3377';
20241119@180748.5896 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180748.5939 unhobca0ioavusr5t6ttmgrjon Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241119@180748.6560 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180748.6601 unhobca0ioavusr5t6ttmgrjon Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20241119@180748.6997 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241119@180748.7517 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.600.94.01' and bi.lordem =1
20241119@180748.8331 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.600.94.01'
20241119@180748.8622 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.600.94.01' and bi.lordem =1
20241119@180748.8834 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2000.94.1'
20241119@180749.3710 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.2000.94.1' and bi.lordem =2
20241119@180749.1173 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.900.94.01'
20241119@180749.1969 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.900.94.01' and bi.lordem =3
20241119@180749.2766 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.700.94.01'
20241119@180749.3276 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.700.94.01' and bi.lordem =4
20241119@180749.4100 unhobca0ioavusr5t6ttmgrjon Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2200.94.1'
20241119@180749.4817 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2076 and bo.obrano = 2407686 and bi.ref ='324.2200.94.1' and bi.lordem =5
20241119@180749.5918 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.5959 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241119@180749.6334 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.6376 unhobca0ioavusr5t6ttmgrjon Query : select top 1 1 valor from td where td.ndoc = 39
20241119@180749.6749 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.6790 unhobca0ioavusr5t6ttmgrjon 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')
20241119@180749.7270 unhobca0ioavusr5t6ttmgrjon 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
20241119@180749.7724 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.7766 unhobca0ioavusr5t6ttmgrjon Query : select top 1 ~inactivo valor from cl where no = '199800' and estab = 0 order by inactivo desc
20241119@180749.9590 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180749.9631 unhobca0ioavusr5t6ttmgrjon Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241119@180750.5000 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180750.4700 unhobca0ioavusr5t6ttmgrjon Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241119@180750.5200 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180750.6040 unhobca0ioavusr5t6ttmgrjon Query : select szadrsstamp valor from szadrs where szadrsdesc='740 ent vnr bligeiro'
20241119@180750.1427 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180750.1472 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from td where ndoc = 39
20241119@180750.1722 unhobca0ioavusr5t6ttmgrjon Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241119@180750.2134 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.2405 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180750.2888 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.3336 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180750.3999 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.4251 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180750.4500 unhobca0ioavusr5t6ttmgrjon Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180750.4836 unhobca0ioavusr5t6ttmgrjon Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241119@180750.5085 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.5335 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241119@180750.5626 unhobca0ioavusr5t6ttmgrjon Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241119@180750.6024 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180750.6276 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241119@180750.6989 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241119@180750.7302 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241119@180750.7577 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241119@180750.7816 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241119@180750.8045 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241119@180750.8254 unhobca0ioavusr5t6ttmgrjon Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241119@180750.8460 unhobca0ioavusr5t6ttmgrjon Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673cd18787673cd3f66d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241119@180750.9248 unhobca0ioavusr5t6ttmgrjon Query : select top 1 fno valor from wsftdata order by fno desc
20241119@180751.5700 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.4000 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241119@180751.8560 unhobca0ioavusr5t6ttmgrjon Query : select 'normal' from dummy
20241119@180751.1145 unhobca0ioavusr5t6ttmgrjon Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673cd18787673cd3f66d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1928,199800,0,'2024-11-19',39,'euro',0,0,2024 ,?,?)
20241119@180751.1877 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180751.1919 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241119@180751.2291 unhobca0ioavusr5t6ttmgrjon Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.600.94.01'
20241119@180751.2977 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.3361 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180751.3940 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.4192 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180751.4360 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180751.4609 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241119@180751.4900 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.5152 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180751.5360 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd85387673cd3f777','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180751.5403 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.5665 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180751.7492 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd85387673cd3f777',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241119@180751.8183 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.8435 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180751.9015 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180751.9268 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180751.9435 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180751.9683 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.1735 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180752.2217 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd85235673cd3f7ec','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180752.2261 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.2513 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180752.3279 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd85235673cd3f7ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,20000,?,?,?)
20241119@180752.4037 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180752.4079 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.600.94.01'
20241119@180752.4413 unhobca0ioavusr5t6ttmgrjon Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.600.94.01'
20241119@180752.4662 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.4939 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180752.5517 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.5770 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180752.5937 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180752.6186 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.600.94.01' and lote = 'r2400047200a'
20241119@180752.6604 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.7991 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180752.8206 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd06430673cd3f8a1','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180752.8250 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180752.8502 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180752.9123 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd06430673cd3f8a1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241119@180752.9838 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.9300 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.6710 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.9230 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.1089 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180753.1337 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.1592 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.1803 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd35572673cd3f920','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180753.1846 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.2102 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.2721 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673cd35572673cd3f920',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,50000,?,?,?)
20241119@180753.3512 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180753.3560 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.2000.94.1'
20241119@180753.3893 unhobca0ioavusr5t6ttmgrjon Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2000.94.1'
20241119@180753.5273 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.5702 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.6286 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.6549 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.6716 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180753.6969 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.2000.94.1' and lote = 'r2300916200a'
20241119@180753.7260 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.7512 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180753.7719 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd37437673cd3f9b1','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180753.7763 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180753.8034 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180753.8669 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd37437673cd3f9b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241119@180753.9362 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180753.9403 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.900.94.01'
20241119@180753.9783 unhobca0ioavusr5t6ttmgrjon Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.900.94.01'
20241119@180754.3180 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.5750 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.1153 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.1407 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.1573 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180754.1820 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.900.94.01' and lote = 'r2300952200a'
20241119@180754.2111 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.2363 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.2574 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd71736673cd3fa33','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180754.2617 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.2870 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.3533 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd71736673cd3fa33',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241119@180754.4976 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180754.5020 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.700.94.01'
20241119@180754.5353 unhobca0ioavusr5t6ttmgrjon Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.700.94.01'
20241119@180754.5879 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.6133 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.6715 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.6967 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.7133 unhobca0ioavusr5t6ttmgrjon Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241119@180754.7381 unhobca0ioavusr5t6ttmgrjon Query : select sestamp valor from se where ref ='324.700.94.01' and lote = 'r2300913100a'
20241119@180754.7632 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.7885 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241119@180754.8092 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673cd25747673cd3faba','aut673cd18787673cd3f66d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241119@180754.8135 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180754.8389 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241119@180754.9008 unhobca0ioavusr5t6ttmgrjon Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673cd25747673cd3faba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut673cd18787673cd3f66d' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241119@180754.9616 unhobca0ioavusr5t6ttmgrjon Query : use flama_phc
20241119@180754.9657 unhobca0ioavusr5t6ttmgrjon Query : select st.usalote valor from st where st.ref = '324.2200.94.1'
20241119@180754.9992 unhobca0ioavusr5t6ttmgrjon Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2200.94.1'
20241119@180755.5190 unhobca0ioavusr5t6ttmgrjon Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241119@180755.7710 unhobca0ioavusr5t6ttmgrjon Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
