20240514@172155.1158 ndr90ib6ll79dsugatgjb5e3oc Query : use flama_phc
20240514@172155.1172 ndr90ib6ll79dsugatgjb5e3oc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@172155.1183 ndr90ib6ll79dsugatgjb5e3oc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1678';
20240514@172155.1198 ndr90ib6ll79dsugatgjb5e3oc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1678';
20240514@172155.1214 ndr90ib6ll79dsugatgjb5e3oc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1678';
20240514@172155.1230 ndr90ib6ll79dsugatgjb5e3oc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1678';
20240514@172155.3034 3vvn2k7g0bp21vbrl5keo0stve Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@172155.3060 3vvn2k7g0bp21vbrl5keo0stve Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@172155.3101 3vvn2k7g0bp21vbrl5keo0stve Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1679';
20240514@172155.3159 3vvn2k7g0bp21vbrl5keo0stve Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1679';
20240514@172155.3178 3vvn2k7g0bp21vbrl5keo0stve Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1679';
20240514@172155.3207 3vvn2k7g0bp21vbrl5keo0stve Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1679';
20240514@172155.3223 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.3227 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@172155.3241 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.3244 3vvn2k7g0bp21vbrl5keo0stve Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20240514@172155.3272 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2223.00.1'
20240514@172155.3421 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403412 and bi.ref ='324.2223.00.1' and bi.lordem =1
20240514@172155.3765 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2223.00.1'
20240514@172155.3865 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403412 and bi.ref ='324.2223.00.1' and bi.lordem =1
20240514@172155.3897 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.3925 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@172155.4046 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.4050 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 1 valor from td where td.ndoc = 39
20240514@172155.4065 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.4069 3vvn2k7g0bp21vbrl5keo0stve Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@172155.4132 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@172155.4149 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.4166 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20240514@172155.4216 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.4227 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@172155.4714 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.4719 3vvn2k7g0bp21vbrl5keo0stve Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@172155.4731 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.4733 3vvn2k7g0bp21vbrl5keo0stve Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20240514@172155.4745 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.4748 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from td where ndoc = 39
20240514@172155.4780 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@172155.4801 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172155.4830 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@172155.4847 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172155.4862 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@172155.4924 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172155.4943 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@172155.4953 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172155.5050 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172155.5064 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172155.5082 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@172155.5101 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664382027966438fa378' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@172155.5257 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172155.5304 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@172155.5339 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@172155.5364 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@172155.5370 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@172155.5375 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@172155.5380 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@172155.5386 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@172155.5390 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664382027966438fa378',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@172155.5634 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 fno valor from wsft039data order by fno desc
20240514@172155.5657 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172155.5677 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@172155.5712 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664382027966438fa378',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1352,101597,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','1751',?,?,?,?)
20240514@172155.5960 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.5965 3vvn2k7g0bp21vbrl5keo0stve Query : select st.usalote valor from st where st.ref = '324.2223.00.1'
20240514@172155.5987 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2223.00.1'
20240514@172155.6145 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172155.6184 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172155.6235 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172155.6258 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172155.6262 3vvn2k7g0bp21vbrl5keo0stve Query : select sestamp valor from se where ref ='324.2223.00.1' and lote = 'r2301281500a'
20240514@172155.6276 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172155.6292 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172155.6305 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172155.6340 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664385042566438fa399',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut664382027966438fa378' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@172155.6560 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172155.6584 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172155.6588 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664385042566438fa399','aut664382027966438fa378' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172155.6593 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.6597 3vvn2k7g0bp21vbrl5keo0stve Query : select st.usalote valor from st where st.ref = '324.2223.00.1'
20240514@172155.6614 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2223.00.1'
20240514@172155.6626 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172155.6645 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172155.6706 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172155.6721 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172155.6725 3vvn2k7g0bp21vbrl5keo0stve Query : select sestamp valor from se where ref ='324.2223.00.1' and lote = 'r2301281500a'
20240514@172155.6745 3vvn2k7g0bp21vbrl5keo0stve Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172155.6766 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172155.6798 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172155.6850 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664387024066438fa3a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut664382027966438fa378' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240514@172155.7082 3vvn2k7g0bp21vbrl5keo0stve Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172155.7107 3vvn2k7g0bp21vbrl5keo0stve Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172155.7112 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664387024066438fa3a5','aut664382027966438fa378' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172155.7118 3vvn2k7g0bp21vbrl5keo0stve Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664382027966438fa378','2403412','wait',39,'ari17112337378,753000005')
20240514@172155.7138 3vvn2k7g0bp21vbrl5keo0stve Query : use flama_phc
20240514@172155.7149 3vvn2k7g0bp21vbrl5keo0stve Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@172155.7162 3vvn2k7g0bp21vbrl5keo0stve Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1679';
20240514@172155.7181 3vvn2k7g0bp21vbrl5keo0stve Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1679';
20240514@172155.7201 3vvn2k7g0bp21vbrl5keo0stve Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1679';
20240514@172155.7215 3vvn2k7g0bp21vbrl5keo0stve Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1679';
20240514@172155.7585 023uml279n3lvjv2hmmmvrp31k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@172155.7606 023uml279n3lvjv2hmmmvrp31k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@172155.7638 023uml279n3lvjv2hmmmvrp31k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1680';
20240514@172155.7677 023uml279n3lvjv2hmmmvrp31k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1680';
20240514@172155.7698 023uml279n3lvjv2hmmmvrp31k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1680';
20240514@172155.7723 023uml279n3lvjv2hmmmvrp31k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1680';
20240514@172155.7742 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.7752 023uml279n3lvjv2hmmmvrp31k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@172155.7769 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.7772 023uml279n3lvjv2hmmmvrp31k Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20240514@172155.7806 023uml279n3lvjv2hmmmvrp31k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20240514@172155.7972 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403413 and bi.ref ='324.2224.00.1' and bi.lordem =1
20240514@172155.8323 023uml279n3lvjv2hmmmvrp31k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20240514@172155.8354 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403413 and bi.ref ='324.2224.00.1' and bi.lordem =1
20240514@172155.8371 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8376 023uml279n3lvjv2hmmmvrp31k Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@172155.8426 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8430 023uml279n3lvjv2hmmmvrp31k Query : select top 1 1 valor from td where td.ndoc = 39
20240514@172155.8477 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8481 023uml279n3lvjv2hmmmvrp31k Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@172155.8495 023uml279n3lvjv2hmmmvrp31k Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@172155.8536 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8540 023uml279n3lvjv2hmmmvrp31k Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20240514@172155.8553 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8557 023uml279n3lvjv2hmmmvrp31k Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@172155.8572 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8575 023uml279n3lvjv2hmmmvrp31k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@172155.8593 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8596 023uml279n3lvjv2hmmmvrp31k Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20240514@172155.8610 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172155.8614 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from td where ndoc = 39
20240514@172155.8625 023uml279n3lvjv2hmmmvrp31k Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@172155.8638 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172155.8667 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@172155.8687 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172155.8701 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@172155.8755 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172155.8778 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@172155.8789 023uml279n3lvjv2hmmmvrp31k Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172155.8880 023uml279n3lvjv2hmmmvrp31k Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172155.8892 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172155.8914 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@172155.8927 023uml279n3lvjv2hmmmvrp31k Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664380317666438fa3d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@172155.9118 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172155.9143 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@172155.9179 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@172155.9186 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@172155.9191 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@172155.9196 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@172155.9201 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@172155.9206 023uml279n3lvjv2hmmmvrp31k Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@172155.9217 023uml279n3lvjv2hmmmvrp31k Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664380317666438fa3d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@172155.9458 023uml279n3lvjv2hmmmvrp31k Query : select top 1 fno valor from wsft039data order by fno desc
20240514@172155.9980 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172156.4220 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@172156.6780 023uml279n3lvjv2hmmmvrp31k Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664380317666438fa3d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1353,101597,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','1751',?,?,?,?)
20240514@172156.9290 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172156.9340 023uml279n3lvjv2hmmmvrp31k Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240514@172156.9480 023uml279n3lvjv2hmmmvrp31k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2224.00.1'
20240514@172156.1589 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.1788 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172156.1812 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.1827 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172156.1832 023uml279n3lvjv2hmmmvrp31k Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301281600a'
20240514@172156.1844 023uml279n3lvjv2hmmmvrp31k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172156.1853 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.1866 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172156.1889 023uml279n3lvjv2hmmmvrp31k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664380936766438fa42d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut664380317666438fa3d6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@172156.2111 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.2126 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172156.2130 023uml279n3lvjv2hmmmvrp31k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664380936766438fa42d','aut664380317666438fa3d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172156.2134 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172156.2137 023uml279n3lvjv2hmmmvrp31k Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240514@172156.2147 023uml279n3lvjv2hmmmvrp31k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2224.00.1'
20240514@172156.2156 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.2169 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172156.2196 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.2216 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172156.2220 023uml279n3lvjv2hmmmvrp31k Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301281600a'
20240514@172156.2229 023uml279n3lvjv2hmmmvrp31k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172156.2237 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.2249 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172156.2280 023uml279n3lvjv2hmmmvrp31k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664380092066438fa436',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut664380317666438fa3d6' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240514@172156.2502 023uml279n3lvjv2hmmmvrp31k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.2516 023uml279n3lvjv2hmmmvrp31k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172156.2522 023uml279n3lvjv2hmmmvrp31k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664380092066438fa436','aut664380317666438fa3d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172156.2525 023uml279n3lvjv2hmmmvrp31k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664380317666438fa3d6','2403413','wait',39,'ari17112337378,753000005')
20240514@172156.2541 023uml279n3lvjv2hmmmvrp31k Query : use flama_phc
20240514@172156.2544 023uml279n3lvjv2hmmmvrp31k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@172156.2559 023uml279n3lvjv2hmmmvrp31k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1680';
20240514@172156.2576 023uml279n3lvjv2hmmmvrp31k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1680';
20240514@172156.2594 023uml279n3lvjv2hmmmvrp31k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1680';
20240514@172156.2606 023uml279n3lvjv2hmmmvrp31k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1680';
20240514@172156.2994 76rrkujeae2cmsinv6bfehk2t0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@172156.3022 76rrkujeae2cmsinv6bfehk2t0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@172156.3044 76rrkujeae2cmsinv6bfehk2t0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1681';
20240514@172156.3090 76rrkujeae2cmsinv6bfehk2t0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1681';
20240514@172156.3119 76rrkujeae2cmsinv6bfehk2t0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1681';
20240514@172156.3131 76rrkujeae2cmsinv6bfehk2t0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1681';
20240514@172156.3147 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.3151 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@172156.3164 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.3167 76rrkujeae2cmsinv6bfehk2t0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240514@172156.3194 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5347.00.1'
20240514@172156.3342 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403426 and bi.ref ='324.5347.00.1' and bi.lordem =1
20240514@172156.3644 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5347.00.1'
20240514@172156.3656 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403426 and bi.ref ='324.5347.00.1' and bi.lordem =1
20240514@172156.3662 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240514@172156.3806 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403426 and bi.ref ='324.5342.00.1' and bi.lordem =2
20240514@172156.4116 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.16901.001'
20240514@172156.4256 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403426 and bi.ref ='325.16901.001' and bi.lordem =3
20240514@172156.4567 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240514@172156.4855 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403426 and bi.ref ='324.5396.00.1' and bi.lordem =4
20240514@172156.5180 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240514@172156.5191 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403426 and bi.ref ='324.5396.00.1' and bi.lordem =4
20240514@172156.5196 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5199 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@172156.5212 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5214 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 1 valor from td where td.ndoc = 39
20240514@172156.5224 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5227 76rrkujeae2cmsinv6bfehk2t0 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@172156.5237 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@172156.5250 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5253 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240514@172156.5263 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5266 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@172156.5282 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5285 76rrkujeae2cmsinv6bfehk2t0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@172156.5301 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5304 76rrkujeae2cmsinv6bfehk2t0 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240514@172156.5316 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.5318 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from td where ndoc = 39
20240514@172156.5328 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@172156.5347 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172156.5359 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@172156.5383 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172156.5396 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@172156.5422 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172156.5434 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@172156.5444 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172156.5525 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172156.5534 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172156.5546 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@172156.5574 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@172156.5796 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172156.6309 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@172156.6866 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@172156.6872 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@172156.6879 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@172156.6884 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@172156.6889 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@172156.6894 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@172156.6899 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664380309766438fa484',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@172156.7194 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 fno valor from wsft039data order by fno desc
20240514@172156.7671 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172156.7727 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@172156.7747 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664380309766438fa484',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1354,100810,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','1751',?,?,?,?)
20240514@172156.8005 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.8009 76rrkujeae2cmsinv6bfehk2t0 Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20240514@172156.8021 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5347.00.1'
20240514@172156.8158 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.8173 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172156.8200 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.8219 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172156.8224 76rrkujeae2cmsinv6bfehk2t0 Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2300915100a'
20240514@172156.8242 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172156.8251 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.8264 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172156.8291 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664382069366438fa4c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',60.000 ,'aut664380309766438fa484' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@172156.8517 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.8535 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172156.8540 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664382069366438fa4c9','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172156.8544 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.8559 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172156.8599 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.8618 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172156.8623 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172156.8633 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.8645 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172156.8678 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664384667866438fa4d2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664380309766438fa484' ,0,0 ,2,23.00,20000,?,?,?)
20240514@172156.8887 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.8911 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172156.8916 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664384667866438fa4d2','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172156.8920 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.8923 76rrkujeae2cmsinv6bfehk2t0 Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20240514@172156.8935 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5347.00.1'
20240514@172156.8946 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.8959 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172156.8985 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.9000 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172156.9004 76rrkujeae2cmsinv6bfehk2t0 Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2300915100a'
20240514@172156.9017 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172156.9028 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.9040 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172156.9073 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664380075866438fa4dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',192.000 ,'aut664380309766438fa484' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240514@172156.9294 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.9309 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172156.9315 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664380075866438fa4dc','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172156.9320 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.9334 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172156.9372 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.9385 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172156.9390 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172156.9401 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.9415 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172156.9442 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664389738666438fa4e5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664380309766438fa484' ,0,0 ,2,23.00,50000,?,?,?)
20240514@172156.9666 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.9681 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172156.9685 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664389738666438fa4e5','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172156.9690 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172156.9693 76rrkujeae2cmsinv6bfehk2t0 Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240514@172156.9705 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20240514@172156.9850 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.9876 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172156.9905 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172156.9920 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172156.9925 76rrkujeae2cmsinv6bfehk2t0 Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2301282200a'
20240514@172156.9936 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172156.9947 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172156.9965 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172157.1000 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664382441266438fa4f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',60.000 ,'aut664380309766438fa484' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240514@172157.2340 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.2540 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172157.2580 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664382441266438fa4f2','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172157.2620 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.2890 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172157.3190 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.3320 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172157.3420 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172157.3560 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.3680 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172157.3970 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664380476466438fa508',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664380309766438fa484' ,0,0 ,2,23.00,80000,?,?,?)
20240514@172157.6000 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.6180 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172157.6220 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664380476466438fa508','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172157.6270 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172157.6300 76rrkujeae2cmsinv6bfehk2t0 Query : select st.usalote valor from st where st.ref = '325.16901.001'
20240514@172157.6460 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '325.16901.001'
20240514@172157.7790 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.8020 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172157.8270 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.8500 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172157.8550 76rrkujeae2cmsinv6bfehk2t0 Query : select sestamp valor from se where ref ='325.16901.001' and lote = '25/11'
20240514@172157.8760 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172157.8880 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.9020 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172157.9320 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664385360266438fa515',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut664380309766438fa484' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240514@172157.1143 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.1161 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172157.1166 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664385360266438fa515','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172157.1173 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172157.1176 76rrkujeae2cmsinv6bfehk2t0 Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240514@172157.1187 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5396.00.1'
20240514@172157.1327 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.1348 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172157.1376 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.1399 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172157.1403 76rrkujeae2cmsinv6bfehk2t0 Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240514@172157.1420 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172157.1438 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.1450 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172157.1481 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664387032666438fa523',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',54.000 ,'aut664380309766438fa484' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20240514@172157.1909 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.2337 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172157.2590 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664387032666438fa523','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172157.2676 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.2785 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172157.2807 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.2819 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172157.2823 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172157.2834 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.2850 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172157.3036 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664381518766438fa545',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664380309766438fa484' ,0,0 ,2,23.00,120000,?,?,?)
20240514@172157.3554 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.3577 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172157.3581 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664381518766438fa545','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172157.3585 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172157.3588 76rrkujeae2cmsinv6bfehk2t0 Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240514@172157.3598 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5396.00.1'
20240514@172157.3608 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.3621 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172157.3654 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.3672 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172157.3676 76rrkujeae2cmsinv6bfehk2t0 Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240514@172157.3686 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172157.3695 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.3706 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172157.3733 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664383605166438fa55a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut664380309766438fa484' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20240514@172157.3950 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.3966 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172157.3971 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664383605166438fa55a','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172157.3978 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.3991 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172157.4018 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.4032 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172157.4036 76rrkujeae2cmsinv6bfehk2t0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172157.4047 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172157.4059 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172157.4085 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664382556966438fa562',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664380309766438fa484' ,0,0 ,2,23.00,150000,?,?,?)
20240514@172157.4310 76rrkujeae2cmsinv6bfehk2t0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172157.4332 76rrkujeae2cmsinv6bfehk2t0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172157.4337 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664382556966438fa562','aut664380309766438fa484' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172157.4347 76rrkujeae2cmsinv6bfehk2t0 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664380309766438fa484','2403426','wait',39,'ari17112337378,753000005')
20240514@172157.4374 76rrkujeae2cmsinv6bfehk2t0 Query : use flama_phc
20240514@172157.4377 76rrkujeae2cmsinv6bfehk2t0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@172157.4412 76rrkujeae2cmsinv6bfehk2t0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1681';
20240514@172157.4444 76rrkujeae2cmsinv6bfehk2t0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1681';
20240514@172157.4462 76rrkujeae2cmsinv6bfehk2t0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1681';
20240514@172157.4483 76rrkujeae2cmsinv6bfehk2t0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1681';
20240514@172157.5452 ppiolop0i7em8i6a3emdcdudna Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@172157.5468 ppiolop0i7em8i6a3emdcdudna Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@172157.5497 ppiolop0i7em8i6a3emdcdudna Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1682';
20240514@172157.5543 ppiolop0i7em8i6a3emdcdudna Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1682';
20240514@172157.5562 ppiolop0i7em8i6a3emdcdudna Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1682';
20240514@172157.5579 ppiolop0i7em8i6a3emdcdudna Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1682';
20240514@172157.5596 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.5599 ppiolop0i7em8i6a3emdcdudna Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@172157.5616 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.5618 ppiolop0i7em8i6a3emdcdudna Query : select no, estab,szadrsdesc from szadrs where u_coddest=3155
20240514@172157.5682 ppiolop0i7em8i6a3emdcdudna Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20240514@172157.5846 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403433 and bi.ref ='324.2232.00.1' and bi.lordem =1
20240514@172157.6172 ppiolop0i7em8i6a3emdcdudna Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.719.00.01'
20240514@172157.6323 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403433 and bi.ref ='324.719.00.01' and bi.lordem =2
20240514@172157.6628 ppiolop0i7em8i6a3emdcdudna Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20240514@172157.6767 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403433 and bi.ref ='324.642.00.01' and bi.lordem =3
20240514@172157.7072 ppiolop0i7em8i6a3emdcdudna Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20240514@172157.7210 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403433 and bi.ref ='324.1685.00.1' and bi.lordem =4
20240514@172157.7595 ppiolop0i7em8i6a3emdcdudna Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1646.00.1'
20240514@172157.7767 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403433 and bi.ref ='324.1646.00.1' and bi.lordem =5
20240514@172157.8105 ppiolop0i7em8i6a3emdcdudna Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20240514@172157.8267 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403433 and bi.ref ='324.5365.00.1' and bi.lordem =7
20240514@172157.8574 ppiolop0i7em8i6a3emdcdudna Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2231.00.1'
20240514@172157.8769 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403433 and bi.ref ='324.2231.00.1' and bi.lordem =9
20240514@172157.9112 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9116 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@172157.9129 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9137 ppiolop0i7em8i6a3emdcdudna Query : select top 1 1 valor from td where td.ndoc = 39
20240514@172157.9152 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9155 ppiolop0i7em8i6a3emdcdudna Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@172157.9166 ppiolop0i7em8i6a3emdcdudna Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@172157.9180 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9183 ppiolop0i7em8i6a3emdcdudna Query : select top 1 ~inactivo valor from cl where no = '101176' and estab = 0 order by inactivo desc
20240514@172157.9284 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9287 ppiolop0i7em8i6a3emdcdudna Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@172157.9352 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9356 ppiolop0i7em8i6a3emdcdudna Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@172157.9366 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9369 ppiolop0i7em8i6a3emdcdudna Query : select szadrsstamp valor from szadrs where szadrsdesc='soares & filhos, lda.-entrega'
20240514@172157.9399 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172157.9402 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from td where ndoc = 39
20240514@172157.9445 ppiolop0i7em8i6a3emdcdudna Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@172157.9473 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172157.9501 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@172157.9556 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172157.9569 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@172157.9677 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172157.9696 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@172157.9706 ppiolop0i7em8i6a3emdcdudna Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172157.9821 ppiolop0i7em8i6a3emdcdudna Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172157.9839 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172157.9859 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@172157.9870 ppiolop0i7em8i6a3emdcdudna Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@172158.2700 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172158.4500 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@172158.8100 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@172158.9900 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@172158.1120 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@172158.1360 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@172158.1440 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@172158.1490 ppiolop0i7em8i6a3emdcdudna Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@172158.1530 ppiolop0i7em8i6a3emdcdudna Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664384019166438fa5ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@172158.3740 ppiolop0i7em8i6a3emdcdudna Query : select top 1 fno valor from wsft039data order by fno desc
20240514@172158.4070 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172158.4430 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@172158.4810 ppiolop0i7em8i6a3emdcdudna Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664384019166438fa5ec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1355,101176,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','1751',?,?,?,?)
20240514@172158.7320 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.7530 ppiolop0i7em8i6a3emdcdudna Query : select st.usalote valor from st where st.ref = '324.2232.00.1'
20240514@172158.7690 ppiolop0i7em8i6a3emdcdudna Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2232.00.1'
20240514@172158.1198 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.1212 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.1739 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.1788 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.1793 ppiolop0i7em8i6a3emdcdudna Query : select sestamp valor from se where ref ='324.2232.00.1' and lote = 'r2301141300a'
20240514@172158.1809 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.1818 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.1830 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.1898 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664382246166438fa62c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@172158.2136 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.2150 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.2154 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664382246166438fa62c','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.2163 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.2166 ppiolop0i7em8i6a3emdcdudna Query : select st.usalote valor from st where st.ref = '324.719.00.01'
20240514@172158.2176 ppiolop0i7em8i6a3emdcdudna Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.719.00.01'
20240514@172158.2337 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.2349 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.2414 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.2427 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.2432 ppiolop0i7em8i6a3emdcdudna Query : select sestamp valor from se where ref ='324.719.00.01' and lote = 'r2300383300a'
20240514@172158.2455 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.2467 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.2494 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.2523 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664381740566438fa63c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240514@172158.2761 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.2798 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.2803 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664381740566438fa63c','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.2809 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.2828 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.2884 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.2906 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.2912 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.2940 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.2963 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.2997 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664383462966438fa647',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,30000,?,?,?)
20240514@172158.3221 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.3245 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.3274 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664383462966438fa647','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.3279 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.3282 ppiolop0i7em8i6a3emdcdudna Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240514@172158.3306 ppiolop0i7em8i6a3emdcdudna Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.642.00.01'
20240514@172158.3454 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.3480 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.3506 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.3522 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.3527 ppiolop0i7em8i6a3emdcdudna Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240514@172158.3544 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.3555 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.3613 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.3668 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664384849166438fa656',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240514@172158.3912 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.3927 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.3944 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664384849166438fa656','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.3958 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.3973 ppiolop0i7em8i6a3emdcdudna Query : select st.usalote valor from st where st.ref = '324.1685.00.1'
20240514@172158.3987 ppiolop0i7em8i6a3emdcdudna Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1685.00.1'
20240514@172158.4131 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.4145 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.4174 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.4189 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.4209 ppiolop0i7em8i6a3emdcdudna Query : select sestamp valor from se where ref ='324.1685.00.1' and lote = 'r2100529200a'
20240514@172158.4226 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.4237 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.4249 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.4275 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664382736166438fa667',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240514@172158.4502 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.4556 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.4561 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664382736166438fa667','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.4566 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.4569 ppiolop0i7em8i6a3emdcdudna Query : select st.usalote valor from st where st.ref = '324.1646.00.1'
20240514@172158.4619 ppiolop0i7em8i6a3emdcdudna Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1646.00.1'
20240514@172158.4778 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.4829 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.4857 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.4871 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.4876 ppiolop0i7em8i6a3emdcdudna Query : select sestamp valor from se where ref ='324.1646.00.1' and lote = 'r2101259200a'
20240514@172158.4893 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.4922 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.4945 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.4969 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664383209166438fa678',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240514@172158.5335 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.5363 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.5368 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664383209166438fa678','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.5374 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.5382 ppiolop0i7em8i6a3emdcdudna Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20240514@172158.5407 ppiolop0i7em8i6a3emdcdudna Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5365.00.1'
20240514@172158.5550 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.5565 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.5595 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.5615 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.5620 ppiolop0i7em8i6a3emdcdudna Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20240514@172158.5633 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.5645 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.5659 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.5686 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664384639366438fa689',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240514@172158.5911 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.5927 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.5962 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664384639366438fa689','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.5976 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.6064 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.6132 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.6145 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.6150 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.6216 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.6233 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.6261 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664384341866438fa697',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,90000,?,?,?)
20240514@172158.6493 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.6509 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172158.6514 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664384341866438fa697','aut664384019166438fa5ec' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172158.6519 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.6522 ppiolop0i7em8i6a3emdcdudna Query : select st.usalote valor from st where st.ref = '324.2231.00.1'
20240514@172158.6534 ppiolop0i7em8i6a3emdcdudna Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2231.00.1'
20240514@172158.6680 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.6693 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172158.6724 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172158.6753 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172158.6758 ppiolop0i7em8i6a3emdcdudna Query : select sestamp valor from se where ref ='324.2231.00.1' and lote = 'r2301141275a'
20240514@172158.6769 ppiolop0i7em8i6a3emdcdudna Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172158.6787 ppiolop0i7em8i6a3emdcdudna Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172158.6799 ppiolop0i7em8i6a3emdcdudna Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172158.6824 ppiolop0i7em8i6a3emdcdudna Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664387277166438fa6a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut664384019166438fa5ec' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20240514@172158.7061 ppiolop0i7em8i6a3emdcdudna Query : use flama_phc
20240514@172158.7066 ppiolop0i7em8i6a3emdcdudna Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240514@172158.7128 ppiolop0i7em8i6a3emdcdudna Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1682';
20240514@172158.7153 ppiolop0i7em8i6a3emdcdudna Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1682';
20240514@172158.7672 mfj7ur9noi2dou35hq5agkvbsh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@172158.7684 mfj7ur9noi2dou35hq5agkvbsh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@172158.7708 mfj7ur9noi2dou35hq5agkvbsh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1683';
20240514@172158.7753 mfj7ur9noi2dou35hq5agkvbsh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1683';
20240514@172158.7778 mfj7ur9noi2dou35hq5agkvbsh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1683';
20240514@172158.7791 mfj7ur9noi2dou35hq5agkvbsh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1683';
20240514@172158.7807 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172158.7811 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@172158.7823 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172158.7826 mfj7ur9noi2dou35hq5agkvbsh Query : select no, estab,szadrsdesc from szadrs where u_coddest=227
20240514@172158.8314 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240514@172158.8811 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403436 and bi.ref ='304.421.00.04' and bi.lordem =1
20240514@172158.9288 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20240514@172158.9310 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403436 and bi.ref ='324.4421.00.1' and bi.lordem =3
20240514@172158.9634 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20240514@172158.9776 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403436 and bi.ref ='323.318.09.00' and bi.lordem =5
20240514@172159.6760 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20240514@172159.7980 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403436 and bi.ref ='323.318.09.00' and bi.lordem =5
20240514@172159.8040 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20240514@172159.8140 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403436 and bi.ref ='323.318.09.00' and bi.lordem =6
20240514@172159.1151 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20240514@172159.1292 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403436 and bi.ref ='324.1462.00.1' and bi.lordem =7
20240514@172159.1601 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1605 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240514@172159.1619 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1622 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 1 valor from td where td.ndoc = 39
20240514@172159.1635 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1638 mfj7ur9noi2dou35hq5agkvbsh Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240514@172159.1649 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240514@172159.1662 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1665 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 ~inactivo valor from cl where no = '100041' and estab = 0 order by inactivo desc
20240514@172159.1777 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1780 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240514@172159.1790 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1793 mfj7ur9noi2dou35hq5agkvbsh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240514@172159.1803 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1806 mfj7ur9noi2dou35hq5agkvbsh Query : select szadrsstamp valor from szadrs where szadrsdesc='radiobela som, lda'
20240514@172159.1830 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.1834 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from td where ndoc = 39
20240514@172159.1853 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240514@172159.1869 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172159.1882 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240514@172159.1898 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172159.1910 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240514@172159.1948 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172159.1959 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240514@172159.1968 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172159.2048 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240514@172159.2057 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240514@172159.2076 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240514@172159.2085 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240514@172159.2233 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240514@172159.2252 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240514@172159.2305 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240514@172159.2352 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240514@172159.2356 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240514@172159.2366 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240514@172159.2370 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240514@172159.2412 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240514@172159.2416 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut664384793566438fa730',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240514@172159.2626 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 fno valor from wsft039data order by fno desc
20240514@172159.2715 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240514@172159.2727 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240514@172159.2758 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut664384793566438fa730',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1355,100041,0,'2024-05-14',39,'euro',0,0,2024 ,'20240514','1751',?,?,?,?)
20240514@172159.3004 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.3008 mfj7ur9noi2dou35hq5agkvbsh Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240514@172159.3030 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240514@172159.3073 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.3085 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172159.3108 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.3120 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172159.3124 mfj7ur9noi2dou35hq5agkvbsh Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240432'
20240514@172159.3141 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172159.3169 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.3183 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172159.3209 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664387596866438fa74d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut664384793566438fa730' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240514@172159.3433 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.3466 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172159.3472 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664387596866438fa74d','aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172159.3478 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.3502 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172159.3544 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.3584 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172159.3589 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172159.3629 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.3672 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172159.3699 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut664386397166438fa758',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut664384793566438fa730' ,0,0 ,2,23.00,20000,?,?,?)
20240514@172159.3961 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.3980 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172159.3985 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664386397166438fa758','aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172159.3989 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.3997 mfj7ur9noi2dou35hq5agkvbsh Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240514@172159.4009 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4421.00.1'
20240514@172159.4157 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.4181 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172159.4246 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.4281 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172159.4285 mfj7ur9noi2dou35hq5agkvbsh Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2200226300a'
20240514@172159.4297 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172159.4338 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.4350 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172159.4399 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664389937466438fa769',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut664384793566438fa730' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240514@172159.4628 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.4654 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172159.4659 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664389937466438fa769','aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172159.4666 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.4670 mfj7ur9noi2dou35hq5agkvbsh Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240514@172159.4683 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '323.318.09.00'
20240514@172159.4839 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.4853 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172159.4876 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.4909 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172159.4934 mfj7ur9noi2dou35hq5agkvbsh Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2300384200a'
20240514@172159.4946 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172159.4974 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.5011 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172159.5035 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664382309466438fa779',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut664384793566438fa730' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240514@172159.5272 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.5434 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172159.5439 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664382309466438fa779','aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172159.5444 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.5464 mfj7ur9noi2dou35hq5agkvbsh Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240514@172159.5532 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '323.318.09.00'
20240514@172159.5580 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.5594 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172159.5643 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.5656 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172159.5660 mfj7ur9noi2dou35hq5agkvbsh Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2300384200a'
20240514@172159.5671 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172159.5682 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.5696 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172159.5729 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664386865966438fa78a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut664384793566438fa730' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240514@172159.5965 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.5998 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172159.6003 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664386865966438fa78a','aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172159.6007 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.6010 mfj7ur9noi2dou35hq5agkvbsh Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240514@172159.6034 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '323.318.09.00'
20240514@172159.6077 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.6095 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172159.6124 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.6142 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172159.6148 mfj7ur9noi2dou35hq5agkvbsh Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2300384200a'
20240514@172159.6163 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172159.6182 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.6196 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172159.6228 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664389414266438fa796',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut664384793566438fa730' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240514@172159.6585 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.6905 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172159.7122 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664389414266438fa796','aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172159.7182 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.7192 mfj7ur9noi2dou35hq5agkvbsh Query : select st.usalote valor from st where st.ref = '324.1462.00.1'
20240514@172159.7204 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1462.00.1'
20240514@172159.7353 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.7375 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240514@172159.7426 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.7470 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240514@172159.7477 mfj7ur9noi2dou35hq5agkvbsh Query : select sestamp valor from se where ref ='324.1462.00.1' and lote = 'r2101096200a'
20240514@172159.7545 mfj7ur9noi2dou35hq5agkvbsh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240514@172159.7582 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240514@172159.7597 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240514@172159.7626 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut664380250166438fa7b9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut664384793566438fa730' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240514@172159.7883 mfj7ur9noi2dou35hq5agkvbsh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240514@172159.7933 mfj7ur9noi2dou35hq5agkvbsh Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240514@172159.7938 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut664380250166438fa7b9','aut664384793566438fa730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240514@172159.7942 mfj7ur9noi2dou35hq5agkvbsh Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut664384793566438fa730','2403436','wait',39,'ari17112337378,753000005')
20240514@172159.7963 mfj7ur9noi2dou35hq5agkvbsh Query : use flama_phc
20240514@172159.7965 mfj7ur9noi2dou35hq5agkvbsh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240514@172159.7978 mfj7ur9noi2dou35hq5agkvbsh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1683';
20240514@172159.7998 mfj7ur9noi2dou35hq5agkvbsh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1683';
20240514@172159.8016 mfj7ur9noi2dou35hq5agkvbsh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1683';
20240514@172159.8040 mfj7ur9noi2dou35hq5agkvbsh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1683';
20240514@172159.8825 f1115l1b6kbragtrqqm202vmer Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240514@172159.8840 f1115l1b6kbragtrqqm202vmer Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240514@172159.8887 f1115l1b6kbragtrqqm202vmer Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1684';
20240514@172159.8925 f1115l1b6kbragtrqqm202vmer Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1684';
20240514@172159.8944 f1115l1b6kbragtrqqm202vmer Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1684';
20240514@172159.8959 f1115l1b6kbragtrqqm202vmer Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1684';
20240514@172159.8975 f1115l1b6kbragtrqqm202vmer Query : use flama_phc
20240514@172159.8978 f1115l1b6kbragtrqqm202vmer Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240514@172159.8990 f1115l1b6kbragtrqqm202vmer Query : use flama_phc
20240514@172159.8993 f1115l1b6kbragtrqqm202vmer Query : select no, estab,szadrsdesc from szadrs where u_coddest=2138
20240514@172159.9059 f1115l1b6kbragtrqqm202vmer Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1675.00.2'
20240514@172159.9244 f1115l1b6kbragtrqqm202vmer Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403438 and bi.ref ='324.1675.00.2' and bi.lordem =1
20240514@172159.9547 f1115l1b6kbragtrqqm202vmer Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5347.00.1'
20240514@172159.9572 f1115l1b6kbragtrqqm202vmer Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2034 and bo.obrano = 2403438 and bi.ref ='324.5347.00.1' and bi.lordem =2
