20240916@142301.6186 nn9q1sl7imrksjjepenskiluq3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e834508366e8313596','aut66e837777666e83132c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142301.6191 nn9q1sl7imrksjjepenskiluq3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142301.6204 nn9q1sl7imrksjjepenskiluq3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142301.6231 nn9q1sl7imrksjjepenskiluq3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e834508366e8313596',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e837777666e83132c7' ,0,0 ,2,23.00,260000,?,?,?)
20240916@142301.6584 nn9q1sl7imrksjjepenskiluq3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e837777666e83132c7','2405928','wait',39,'adm09112754980.682000002')
20240916@142301.7081 nn9q1sl7imrksjjepenskiluq3 Query : use flama_phc
20240916@142301.7125 nn9q1sl7imrksjjepenskiluq3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240916@142301.8008 nn9q1sl7imrksjjepenskiluq3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2020';
20240916@142301.8039 nn9q1sl7imrksjjepenskiluq3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2020';
20240916@142301.8080 nn9q1sl7imrksjjepenskiluq3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2020';
20240916@142301.8104 nn9q1sl7imrksjjepenskiluq3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2020';
20240916@142301.9022 66ovduj0f6nheoebmvorj5hk14 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240916@142301.9032 66ovduj0f6nheoebmvorj5hk14 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240916@142301.9081 66ovduj0f6nheoebmvorj5hk14 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2021';
20240916@142301.9135 66ovduj0f6nheoebmvorj5hk14 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2021';
20240916@142301.9183 66ovduj0f6nheoebmvorj5hk14 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2021';
20240916@142301.9207 66ovduj0f6nheoebmvorj5hk14 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2021';
20240916@142301.9254 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142301.9257 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240916@142301.9328 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142301.9334 66ovduj0f6nheoebmvorj5hk14 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240916@142301.9373 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240916@142301.9536 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405929 and bi.ref ='324.948.00.01' and bi.lordem =1
20240916@142301.9847 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240916@142301.9870 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405929 and bi.ref ='324.948.00.01' and bi.lordem =1
20240916@142301.9888 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142301.9891 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240916@142301.9922 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142301.9925 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 1 valor from td where td.ndoc = 39
20240916@142301.9953 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142301.9956 66ovduj0f6nheoebmvorj5hk14 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240916@142301.9984 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240916@142302.1800 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.2100 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240916@142302.5100 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.5400 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240916@142302.8300 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.8600 66ovduj0f6nheoebmvorj5hk14 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240916@142302.1240 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.1270 66ovduj0f6nheoebmvorj5hk14 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240916@142302.1720 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.1750 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from td where ndoc = 39
20240916@142302.1910 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240916@142302.2050 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.2210 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142302.2400 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.2540 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142302.2800 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.2940 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142302.3060 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142302.3760 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142302.3960 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.4120 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142302.4280 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e837559866e8313607' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240916@142302.5990 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.6160 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142302.6470 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240916@142302.6590 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240916@142302.6710 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240916@142302.6840 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240916@142302.6970 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240916@142302.7090 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240916@142302.7260 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e837559866e8313607',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240916@142302.9850 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 fno valor from wsftdata order by fno desc
20240916@142302.1006 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.1979 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142302.2269 66ovduj0f6nheoebmvorj5hk14 Query : select 'normal' from dummy
20240916@142302.2285 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e837559866e8313607',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',767,100810,0,'2024-09-16',39,'euro',0,0,2024 ,?,?)
20240916@142302.2602 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.2605 66ovduj0f6nheoebmvorj5hk14 Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240916@142302.2627 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.948.00.01'
20240916@142302.2779 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.2795 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142302.2820 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.2834 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142302.2843 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142302.2854 66ovduj0f6nheoebmvorj5hk14 Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240916@142302.2868 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.2882 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142302.2893 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e833892866e8313646','aut66e837559866e8313607' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142302.2897 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.2912 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142302.2940 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e833892866e8313646',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut66e837559866e8313607' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240916@142302.3197 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.3201 66ovduj0f6nheoebmvorj5hk14 Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240916@142302.3220 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.948.00.01'
20240916@142302.3234 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.3252 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142302.3277 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.3300 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142302.3310 66ovduj0f6nheoebmvorj5hk14 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142302.3322 66ovduj0f6nheoebmvorj5hk14 Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240916@142302.3335 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.3349 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142302.3360 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e837242466e8313651','aut66e837559866e8313607' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142302.3365 66ovduj0f6nheoebmvorj5hk14 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.3379 66ovduj0f6nheoebmvorj5hk14 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142302.3407 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e837242466e8313651',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66e837559866e8313607' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240916@142302.3672 66ovduj0f6nheoebmvorj5hk14 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e837559866e8313607','2405929','wait',39,'adm09112754980.682000002')
20240916@142302.3741 66ovduj0f6nheoebmvorj5hk14 Query : use flama_phc
20240916@142302.3744 66ovduj0f6nheoebmvorj5hk14 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240916@142302.3773 66ovduj0f6nheoebmvorj5hk14 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2021';
20240916@142302.3800 66ovduj0f6nheoebmvorj5hk14 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2021';
20240916@142302.3846 66ovduj0f6nheoebmvorj5hk14 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2021';
20240916@142302.3873 66ovduj0f6nheoebmvorj5hk14 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2021';
20240916@142302.4463 pvkltmlht2ouhh6t6kdrlteeq5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240916@142302.4474 pvkltmlht2ouhh6t6kdrlteeq5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240916@142302.4526 pvkltmlht2ouhh6t6kdrlteeq5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2022';
20240916@142302.4579 pvkltmlht2ouhh6t6kdrlteeq5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2022';
20240916@142302.4628 pvkltmlht2ouhh6t6kdrlteeq5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2022';
20240916@142302.4652 pvkltmlht2ouhh6t6kdrlteeq5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2022';
20240916@142302.4698 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.4701 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240916@142302.4761 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.4764 pvkltmlht2ouhh6t6kdrlteeq5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240916@142302.4805 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20240916@142302.4967 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405930 and bi.ref ='324.4980.00.1' and bi.lordem =1
20240916@142302.6732 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.6738 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240916@142302.6771 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.6774 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 1 valor from td where td.ndoc = 39
20240916@142302.6802 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.6805 pvkltmlht2ouhh6t6kdrlteeq5 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240916@142302.6832 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240916@142302.6864 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.6866 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240916@142302.6894 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.6897 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240916@142302.6925 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.6928 pvkltmlht2ouhh6t6kdrlteeq5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240916@142302.6965 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.6968 pvkltmlht2ouhh6t6kdrlteeq5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240916@142302.7013 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.7016 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from td where ndoc = 39
20240916@142302.7027 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240916@142302.7040 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.7055 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142302.7079 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.7095 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142302.7122 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.7137 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142302.7149 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142302.7216 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142302.7228 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.7244 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142302.7259 pvkltmlht2ouhh6t6kdrlteeq5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e838354166e83136ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240916@142302.7432 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.7450 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142302.7482 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240916@142302.7507 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240916@142302.7518 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240916@142302.7529 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240916@142302.7540 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240916@142302.7551 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240916@142302.7561 pvkltmlht2ouhh6t6kdrlteeq5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e838354166e83136ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240916@142302.7797 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 fno valor from wsftdata order by fno desc
20240916@142302.7816 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.7833 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142302.7854 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 'normal' from dummy
20240916@142302.7868 pvkltmlht2ouhh6t6kdrlteeq5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e838354166e83136ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',768,100810,0,'2024-09-16',39,'euro',0,0,2024 ,?,?)
20240916@142302.8154 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.8157 pvkltmlht2ouhh6t6kdrlteeq5 Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20240916@142302.8179 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4980.00.1'
20240916@142302.8323 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.8339 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142302.8362 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.8376 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142302.8384 pvkltmlht2ouhh6t6kdrlteeq5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142302.8395 pvkltmlht2ouhh6t6kdrlteeq5 Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2301092100a'
20240916@142302.8408 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.8422 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142302.8432 pvkltmlht2ouhh6t6kdrlteeq5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e832699266e83136cd','aut66e838354166e83136ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142302.8436 pvkltmlht2ouhh6t6kdrlteeq5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142302.8450 pvkltmlht2ouhh6t6kdrlteeq5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142302.8476 pvkltmlht2ouhh6t6kdrlteeq5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e832699266e83136cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80.000 ,'aut66e838354166e83136ae' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240916@142302.8722 pvkltmlht2ouhh6t6kdrlteeq5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e838354166e83136ae','2405930','wait',39,'adm09112754980.682000002')
20240916@142302.8789 pvkltmlht2ouhh6t6kdrlteeq5 Query : use flama_phc
20240916@142302.8793 pvkltmlht2ouhh6t6kdrlteeq5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240916@142302.8821 pvkltmlht2ouhh6t6kdrlteeq5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2022';
20240916@142302.8853 pvkltmlht2ouhh6t6kdrlteeq5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2022';
20240916@142302.9175 pvkltmlht2ouhh6t6kdrlteeq5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2022';
20240916@142302.9204 pvkltmlht2ouhh6t6kdrlteeq5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2022';
20240916@142302.9764 7gddudvu53g4rnoubnu81ilc76 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240916@142302.9775 7gddudvu53g4rnoubnu81ilc76 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240916@142302.9827 7gddudvu53g4rnoubnu81ilc76 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2023';
20240916@142302.9879 7gddudvu53g4rnoubnu81ilc76 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2023';
20240916@142302.9927 7gddudvu53g4rnoubnu81ilc76 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2023';
20240916@142302.9951 7gddudvu53g4rnoubnu81ilc76 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2023';
20240916@142302.9996 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.3800 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240916@142303.1110 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.1140 7gddudvu53g4rnoubnu81ilc76 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240916@142303.1530 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.711.00.01'
20240916@142303.3420 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405933 and bi.ref ='324.711.00.01' and bi.lordem =1
20240916@142303.2630 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.711.00.01'
20240916@142303.2842 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405933 and bi.ref ='324.711.00.01' and bi.lordem =1
20240916@142303.2864 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.2869 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240916@142303.2907 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.2910 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 1 valor from td where td.ndoc = 39
20240916@142303.2942 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.2945 7gddudvu53g4rnoubnu81ilc76 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240916@142303.2974 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240916@142303.3013 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.3016 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240916@142303.3048 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.3053 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240916@142303.3108 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.3112 7gddudvu53g4rnoubnu81ilc76 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240916@142303.3153 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.3156 7gddudvu53g4rnoubnu81ilc76 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240916@142303.3216 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.3219 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from td where ndoc = 39
20240916@142303.3233 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240916@142303.3252 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.3270 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142303.3293 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.3310 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142303.3343 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.3360 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142303.3389 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142303.3458 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142303.3473 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.3490 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142303.3508 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e831127666e8313752' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240916@142303.3686 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.3822 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142303.3856 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240916@142303.3869 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240916@142303.3883 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240916@142303.3897 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240916@142303.3909 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240916@142303.3922 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240916@142303.3935 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e831127666e8313752',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240916@142303.4175 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 fno valor from wsftdata order by fno desc
20240916@142303.4196 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.4213 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142303.4236 7gddudvu53g4rnoubnu81ilc76 Query : select 'normal' from dummy
20240916@142303.4253 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e831127666e8313752',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',769,100810,0,'2024-09-16',39,'euro',0,0,2024 ,?,?)
20240916@142303.4540 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.4543 7gddudvu53g4rnoubnu81ilc76 Query : select st.usalote valor from st where st.ref = '324.711.00.01'
20240916@142303.4574 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.711.00.01'
20240916@142303.4733 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.4751 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.4783 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.4800 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.4810 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142303.4824 7gddudvu53g4rnoubnu81ilc76 Query : select sestamp valor from se where ref ='324.711.00.01' and lote = 'r2301222100a'
20240916@142303.4839 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.4854 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.4867 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e830830466e8313776','aut66e831127666e8313752' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142303.4871 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.4889 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.4923 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e830830466e8313776',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66e831127666e8313752' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240916@142303.5189 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5206 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.5235 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5251 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.5260 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142303.5273 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5291 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.5306 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e837465866e8313780','aut66e831127666e8313752' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142303.5310 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5325 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.5361 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e837465866e8313780',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e831127666e8313752' ,0,0 ,2,23.00,20000,?,?,?)
20240916@142303.5629 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.5633 7gddudvu53g4rnoubnu81ilc76 Query : select st.usalote valor from st where st.ref = '324.711.00.01'
20240916@142303.5654 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.711.00.01'
20240916@142303.5668 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5685 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.5710 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5725 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.5733 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142303.5745 7gddudvu53g4rnoubnu81ilc76 Query : select sestamp valor from se where ref ='324.711.00.01' and lote = 'r2301222100a'
20240916@142303.5761 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5776 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.5788 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e834819966e831378c','aut66e831127666e8313752' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142303.5792 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.5806 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.5835 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e834819966e831378c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',56.000 ,'aut66e831127666e8313752' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240916@142303.6088 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.6103 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.6128 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.6142 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.6150 7gddudvu53g4rnoubnu81ilc76 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142303.6162 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.6177 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142303.6189 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e837782966e8313796','aut66e831127666e8313752' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142303.6194 7gddudvu53g4rnoubnu81ilc76 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.6208 7gddudvu53g4rnoubnu81ilc76 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142303.6238 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e837782966e8313796',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e831127666e8313752' ,0,0 ,2,23.00,50000,?,?,?)
20240916@142303.6552 7gddudvu53g4rnoubnu81ilc76 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e831127666e8313752','2405933','wait',39,'adm09112754980.682000002')
20240916@142303.6621 7gddudvu53g4rnoubnu81ilc76 Query : use flama_phc
20240916@142303.6625 7gddudvu53g4rnoubnu81ilc76 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240916@142303.6654 7gddudvu53g4rnoubnu81ilc76 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2023';
20240916@142303.6684 7gddudvu53g4rnoubnu81ilc76 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2023';
20240916@142303.6724 7gddudvu53g4rnoubnu81ilc76 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2023';
20240916@142303.6750 7gddudvu53g4rnoubnu81ilc76 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2023';
20240916@142303.7393 c4ca4j57opam4l9jc4gtd26c7d Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240916@142303.7410 c4ca4j57opam4l9jc4gtd26c7d Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240916@142303.7467 c4ca4j57opam4l9jc4gtd26c7d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2024';
20240916@142303.7529 c4ca4j57opam4l9jc4gtd26c7d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2024';
20240916@142303.7595 c4ca4j57opam4l9jc4gtd26c7d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2024';
20240916@142303.7621 c4ca4j57opam4l9jc4gtd26c7d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2024';
20240916@142303.7671 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.7674 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240916@142303.7740 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.7743 c4ca4j57opam4l9jc4gtd26c7d Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240916@142303.7799 c4ca4j57opam4l9jc4gtd26c7d 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.2'
20240916@142303.7964 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405935 and bi.ref ='324.2231.00.2' and bi.lordem =1
20240916@142303.8285 c4ca4j57opam4l9jc4gtd26c7d 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.2'
20240916@142303.8306 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405935 and bi.ref ='324.2231.00.2' and bi.lordem =1
20240916@142303.8323 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8326 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240916@142303.8357 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8360 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 1 valor from td where td.ndoc = 39
20240916@142303.8389 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8392 c4ca4j57opam4l9jc4gtd26c7d Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240916@142303.8420 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240916@142303.8454 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8457 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240916@142303.8486 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8488 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240916@142303.8517 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8520 c4ca4j57opam4l9jc4gtd26c7d Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240916@142303.8561 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8564 c4ca4j57opam4l9jc4gtd26c7d Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240916@142303.8609 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142303.8611 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from td where ndoc = 39
20240916@142303.8624 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240916@142303.8638 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.8653 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142303.8672 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.8687 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142303.8717 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.8733 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142303.9042 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142303.9109 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142303.9122 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.9138 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142303.9154 c4ca4j57opam4l9jc4gtd26c7d Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e833007766e83137dc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240916@142303.9335 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.9350 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142303.9384 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240916@142303.9398 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240916@142303.9410 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240916@142303.9422 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240916@142303.9434 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240916@142303.9445 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240916@142303.9457 c4ca4j57opam4l9jc4gtd26c7d Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e833007766e83137dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240916@142303.9699 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 fno valor from wsftdata order by fno desc
20240916@142303.9719 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142303.9735 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142303.9756 c4ca4j57opam4l9jc4gtd26c7d Query : select 'normal' from dummy
20240916@142303.9771 c4ca4j57opam4l9jc4gtd26c7d Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e833007766e83137dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',770,100810,0,'2024-09-16',39,'euro',0,0,2024 ,?,?)
20240916@142304.1763 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142304.1777 c4ca4j57opam4l9jc4gtd26c7d Query : select st.usalote valor from st where st.ref = '324.2231.00.2'
20240916@142304.1801 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2231.00.2'
20240916@142304.2005 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.2034 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142304.2071 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.2088 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142304.2099 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142304.2112 c4ca4j57opam4l9jc4gtd26c7d Query : select sestamp valor from se where ref ='324.2231.00.2' and lote = 'r2300389200a'
20240916@142304.2122 c4ca4j57opam4l9jc4gtd26c7d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.2143 c4ca4j57opam4l9jc4gtd26c7d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142304.2156 c4ca4j57opam4l9jc4gtd26c7d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e832097666e8313833','aut66e833007766e83137dc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142304.2174 c4ca4j57opam4l9jc4gtd26c7d Query : use flama_phc
20240916@142304.2177 c4ca4j57opam4l9jc4gtd26c7d Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240916@142304.2268 c4ca4j57opam4l9jc4gtd26c7d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2024';
20240916@142304.2300 c4ca4j57opam4l9jc4gtd26c7d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2024';
20240916@142304.3154 9o13sf6ane7sjfkd9ppb0kj06i Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240916@142304.3165 9o13sf6ane7sjfkd9ppb0kj06i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240916@142304.3217 9o13sf6ane7sjfkd9ppb0kj06i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2025';
20240916@142304.3274 9o13sf6ane7sjfkd9ppb0kj06i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2025';
20240916@142304.3326 9o13sf6ane7sjfkd9ppb0kj06i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2025';
20240916@142304.3353 9o13sf6ane7sjfkd9ppb0kj06i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2025';
20240916@142304.3400 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.3403 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240916@142304.3462 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.3465 9o13sf6ane7sjfkd9ppb0kj06i Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240916@142304.3505 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4988.00.1'
20240916@142304.3669 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405936 and bi.ref ='324.4988.00.1' and bi.lordem =1
20240916@142304.4121 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4124 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240916@142304.4155 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4159 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 1 valor from td where td.ndoc = 39
20240916@142304.4189 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4193 9o13sf6ane7sjfkd9ppb0kj06i Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240916@142304.4222 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240916@142304.4279 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4283 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240916@142304.4313 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4316 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240916@142304.4347 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4350 9o13sf6ane7sjfkd9ppb0kj06i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240916@142304.4432 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4435 9o13sf6ane7sjfkd9ppb0kj06i Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240916@142304.4505 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.4508 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from td where ndoc = 39
20240916@142304.4521 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240916@142304.4536 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.4553 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142304.4573 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.4589 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142304.4642 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.4658 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142304.4671 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142304.4741 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142304.4754 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.4771 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142304.4789 9o13sf6ane7sjfkd9ppb0kj06i Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e835934766e8313872' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240916@142304.4983 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.5002 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142304.5039 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240916@142304.5053 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240916@142304.5066 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240916@142304.5080 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240916@142304.5099 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240916@142304.5113 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240916@142304.5126 9o13sf6ane7sjfkd9ppb0kj06i Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e835934766e8313872',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240916@142304.5381 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 fno valor from wsftdata order by fno desc
20240916@142304.5402 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.5419 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142304.5444 9o13sf6ane7sjfkd9ppb0kj06i Query : select 'normal' from dummy
20240916@142304.5459 9o13sf6ane7sjfkd9ppb0kj06i Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e835934766e8313872',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',770,100810,0,'2024-09-16',39,'euro',0,0,2024 ,?,?)
20240916@142304.5764 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.5767 9o13sf6ane7sjfkd9ppb0kj06i Query : select st.usalote valor from st where st.ref = '324.4988.00.1'
20240916@142304.5789 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4988.00.1'
20240916@142304.6198 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.6215 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142304.6241 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.6255 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142304.6263 9o13sf6ane7sjfkd9ppb0kj06i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142304.6285 9o13sf6ane7sjfkd9ppb0kj06i Query : select sestamp valor from se where ref ='324.4988.00.1' and lote = 'r2100754100a'
20240916@142304.6298 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.6313 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142304.6324 9o13sf6ane7sjfkd9ppb0kj06i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e836596166e8313899','aut66e835934766e8313872' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142304.6328 9o13sf6ane7sjfkd9ppb0kj06i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.6342 9o13sf6ane7sjfkd9ppb0kj06i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142304.6369 9o13sf6ane7sjfkd9ppb0kj06i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e836596166e8313899',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',60.000 ,'aut66e835934766e8313872' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240916@142304.6639 9o13sf6ane7sjfkd9ppb0kj06i Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e835934766e8313872','2405936','wait',39,'adm09112754980.682000002')
20240916@142304.6706 9o13sf6ane7sjfkd9ppb0kj06i Query : use flama_phc
20240916@142304.6709 9o13sf6ane7sjfkd9ppb0kj06i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240916@142304.6737 9o13sf6ane7sjfkd9ppb0kj06i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2025';
20240916@142304.6767 9o13sf6ane7sjfkd9ppb0kj06i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2025';
20240916@142304.6806 9o13sf6ane7sjfkd9ppb0kj06i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2025';
20240916@142304.6829 9o13sf6ane7sjfkd9ppb0kj06i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2025';
20240916@142304.7416 kat9hafqq83tef40eluuapa534 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240916@142304.7428 kat9hafqq83tef40eluuapa534 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240916@142304.7479 kat9hafqq83tef40eluuapa534 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2026';
20240916@142304.7539 kat9hafqq83tef40eluuapa534 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2026';
20240916@142304.7592 kat9hafqq83tef40eluuapa534 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2026';
20240916@142304.7619 kat9hafqq83tef40eluuapa534 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2026';
20240916@142304.7667 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.7671 kat9hafqq83tef40eluuapa534 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240916@142304.7735 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.7739 kat9hafqq83tef40eluuapa534 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240916@142304.7781 kat9hafqq83tef40eluuapa534 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240916@142304.7943 kat9hafqq83tef40eluuapa534 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405937 and bi.ref ='324.988.00.01' and bi.lordem =1
20240916@142304.8254 kat9hafqq83tef40eluuapa534 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240916@142304.8275 kat9hafqq83tef40eluuapa534 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405937 and bi.ref ='324.988.00.01' and bi.lordem =1
20240916@142304.8293 kat9hafqq83tef40eluuapa534 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240916@142304.8314 kat9hafqq83tef40eluuapa534 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405937 and bi.ref ='324.988.00.01' and bi.lordem =1
20240916@142304.8333 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8337 kat9hafqq83tef40eluuapa534 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240916@142304.8371 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8374 kat9hafqq83tef40eluuapa534 Query : select top 1 1 valor from td where td.ndoc = 39
20240916@142304.8405 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8408 kat9hafqq83tef40eluuapa534 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240916@142304.8441 kat9hafqq83tef40eluuapa534 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240916@142304.8478 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8482 kat9hafqq83tef40eluuapa534 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240916@142304.8513 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8517 kat9hafqq83tef40eluuapa534 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240916@142304.8552 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8556 kat9hafqq83tef40eluuapa534 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240916@142304.8596 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8600 kat9hafqq83tef40eluuapa534 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240916@142304.8649 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.8652 kat9hafqq83tef40eluuapa534 Query : select 1 valor from td where ndoc = 39
20240916@142304.8667 kat9hafqq83tef40eluuapa534 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240916@142304.8684 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.8702 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142304.8725 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.8741 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142304.8774 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.8790 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142304.8804 kat9hafqq83tef40eluuapa534 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142304.8871 kat9hafqq83tef40eluuapa534 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142304.8885 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.8903 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142304.8920 kat9hafqq83tef40eluuapa534 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e833949166e83138d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240916@142304.9113 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.9131 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142304.9162 kat9hafqq83tef40eluuapa534 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240916@142304.9174 kat9hafqq83tef40eluuapa534 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240916@142304.9184 kat9hafqq83tef40eluuapa534 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240916@142304.9197 kat9hafqq83tef40eluuapa534 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240916@142304.9208 kat9hafqq83tef40eluuapa534 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240916@142304.9219 kat9hafqq83tef40eluuapa534 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240916@142304.9230 kat9hafqq83tef40eluuapa534 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e833949166e83138d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240916@142304.9491 kat9hafqq83tef40eluuapa534 Query : select top 1 fno valor from wsftdata order by fno desc
20240916@142304.9515 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142304.9531 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142304.9553 kat9hafqq83tef40eluuapa534 Query : select 'normal' from dummy
20240916@142304.9567 kat9hafqq83tef40eluuapa534 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e833949166e83138d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',771,100810,0,'2024-09-16',39,'euro',0,0,2024 ,?,?)
20240916@142304.9877 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142304.9880 kat9hafqq83tef40eluuapa534 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240916@142304.9901 kat9hafqq83tef40eluuapa534 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.988.00.01'
20240916@142305.4900 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.6500 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.9200 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1160 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.1250 kat9hafqq83tef40eluuapa534 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142305.1370 kat9hafqq83tef40eluuapa534 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20240916@142305.1560 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1700 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.1820 kat9hafqq83tef40eluuapa534 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e834271966e8313903','aut66e833949166e83138d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142305.1850 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1990 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.2270 kat9hafqq83tef40eluuapa534 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e834271966e8313903',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66e833949166e83138d6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240916@142305.5520 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142305.5570 kat9hafqq83tef40eluuapa534 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240916@142305.6060 kat9hafqq83tef40eluuapa534 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.988.00.01'
20240916@142305.7640 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1065 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.1163 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1198 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.1208 kat9hafqq83tef40eluuapa534 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142305.1263 kat9hafqq83tef40eluuapa534 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20240916@142305.1307 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1326 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.1339 kat9hafqq83tef40eluuapa534 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e836261966e831391f','aut66e833949166e83138d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142305.1347 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1389 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.1469 kat9hafqq83tef40eluuapa534 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e836261966e831391f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66e833949166e83138d6' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240916@142305.1790 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142305.1794 kat9hafqq83tef40eluuapa534 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240916@142305.1838 kat9hafqq83tef40eluuapa534 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.988.00.01'
20240916@142305.1865 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1893 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.1956 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.1986 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.2006 kat9hafqq83tef40eluuapa534 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142305.2037 kat9hafqq83tef40eluuapa534 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2400410200a'
20240916@142305.2062 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.2100 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.2123 kat9hafqq83tef40eluuapa534 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e834541566e8313932','aut66e833949166e83138d6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142305.2133 kat9hafqq83tef40eluuapa534 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.2167 kat9hafqq83tef40eluuapa534 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.2214 kat9hafqq83tef40eluuapa534 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e834541566e8313932',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66e833949166e83138d6' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240916@142305.2502 kat9hafqq83tef40eluuapa534 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66e833949166e83138d6','2405937','wait',39,'adm09112754980.682000002')
20240916@142305.2910 kat9hafqq83tef40eluuapa534 Query : use flama_phc
20240916@142305.2933 kat9hafqq83tef40eluuapa534 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240916@142305.3137 kat9hafqq83tef40eluuapa534 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2026';
20240916@142305.3315 kat9hafqq83tef40eluuapa534 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2026';
20240916@142305.3507 kat9hafqq83tef40eluuapa534 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2026';
20240916@142305.3722 kat9hafqq83tef40eluuapa534 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2026';
20240916@142305.4351 4j5ojsu8f57siv961p4mj5m89v Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240916@142305.4362 4j5ojsu8f57siv961p4mj5m89v Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240916@142305.4413 4j5ojsu8f57siv961p4mj5m89v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2027';
20240916@142305.4467 4j5ojsu8f57siv961p4mj5m89v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2027';
20240916@142305.4519 4j5ojsu8f57siv961p4mj5m89v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2027';
20240916@142305.4544 4j5ojsu8f57siv961p4mj5m89v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2027';
20240916@142305.4590 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.4593 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240916@142305.4653 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.4656 4j5ojsu8f57siv961p4mj5m89v Query : select no, estab,szadrsdesc from szadrs where u_coddest=2427
20240916@142305.4744 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20240916@142305.4937 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.4930.00.1' and bi.lordem =1
20240916@142305.5287 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20240916@142305.5308 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.4930.00.1' and bi.lordem =1
20240916@142305.5325 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240916@142305.5490 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.958.00.01' and bi.lordem =2
20240916@142305.5830 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240916@142305.5850 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.958.00.01' and bi.lordem =2
20240916@142305.5866 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240916@142305.5885 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.958.00.01' and bi.lordem =2
20240916@142305.5901 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240916@142305.5920 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.958.00.01' and bi.lordem =2
20240916@142305.5936 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240916@142305.5955 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.958.00.01' and bi.lordem =2
20240916@142305.5971 4j5ojsu8f57siv961p4mj5m89v 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'
20240916@142305.6126 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.5342.00.1' and bi.lordem =3
20240916@142305.6633 4j5ojsu8f57siv961p4mj5m89v 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'
20240916@142305.6653 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2059 and bo.obrano = 2405951 and bi.ref ='324.5342.00.1' and bi.lordem =3
20240916@142305.6669 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.6672 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240916@142305.6703 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.6706 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 1 valor from td where td.ndoc = 39
20240916@142305.6734 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.6737 4j5ojsu8f57siv961p4mj5m89v Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240916@142305.6764 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240916@142305.6801 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.6803 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20240916@142305.6923 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.6926 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240916@142305.6955 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.6957 4j5ojsu8f57siv961p4mj5m89v Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240916@142305.6996 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.7003 4j5ojsu8f57siv961p4mj5m89v Query : select szadrsstamp valor from szadrs where szadrsdesc='electrodomesticos divelsa,s.a'
20240916@142305.7048 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.7052 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from td where ndoc = 39
20240916@142305.7064 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240916@142305.7077 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.7093 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142305.7111 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.7125 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142305.7153 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.7168 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142305.7181 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142305.7249 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240916@142305.7277 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.7292 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240916@142305.7308 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240916@142305.7519 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.7538 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240916@142305.7573 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240916@142305.7584 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240916@142305.7596 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240916@142305.7609 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240916@142305.7622 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240916@142305.7634 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240916@142305.7646 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66e831068866e83139af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240916@142305.8179 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 fno valor from wsftdata order by fno desc
20240916@142305.8423 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.8460 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240916@142305.8946 4j5ojsu8f57siv961p4mj5m89v Query : select 'normal' from dummy
20240916@142305.8962 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66e831068866e83139af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',772,200500,0,'2024-09-16',39,'euro',0,0,2024 ,?,?)
20240916@142305.9374 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142305.9424 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.4930.00.1'
20240916@142305.9474 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4930.00.1'
20240916@142305.9667 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.9703 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.9777 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.9809 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.9826 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142305.9862 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.4930.00.1' and lote = 'r2400066200a'
20240916@142305.9888 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.9904 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142305.9915 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e838172966e83139f1','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142305.9920 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142305.9936 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142305.9967 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e838172966e83139f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',60.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240916@142306.2400 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.2440 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.4930.00.1'
20240916@142306.2650 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4930.00.1'
20240916@142306.2800 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2980 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.3260 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3420 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.3510 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.3650 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.4930.00.1' and lote = 'r2400066200a'
20240916@142306.3780 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.4030 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.4170 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e835941266e8313a09','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.4220 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.4640 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.5100 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e835941266e8313a09',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',144.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240916@142306.8080 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.8140 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240916@142306.8410 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20240916@142306.1017 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1035 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.1062 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1077 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.1090 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.1103 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240916@142306.1118 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1134 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.1146 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e838628766e8313a1b','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.1150 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1167 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.1196 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e838628766e8313a1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240916@142306.1462 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.1465 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240916@142306.1487 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20240916@142306.1502 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1519 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.1547 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1561 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.1569 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.1581 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240916@142306.1594 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1610 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.1622 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e830563566e8313a26','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.1626 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.1640 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.1667 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e830563566e8313a26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240916@142306.1940 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.1944 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240916@142306.1977 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20240916@142306.1991 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2009 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.2037 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2053 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.2075 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.2088 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240916@142306.2101 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2117 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.2129 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e830304666e8313a33','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.2134 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2148 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.2175 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e830304666e8313a33',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240916@142306.2684 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.2687 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240916@142306.2709 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20240916@142306.2724 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2741 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.2767 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2784 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.2792 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.2804 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240916@142306.2816 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2830 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.2842 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e838853466e8313a44','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.2847 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.2861 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.2889 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e838853466e8313a44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240916@142306.3155 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.3159 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240916@142306.3180 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.958.00.01'
20240916@142306.3194 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3211 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.3237 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3254 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.3264 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.3277 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240916@142306.3292 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3307 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.3320 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e835559766e8313a50','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.3324 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3340 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.3370 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e835559766e8313a50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240916@142306.3654 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.3657 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240916@142306.3678 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20240916@142306.3827 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3845 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.3869 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3883 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.3892 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.3905 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2301282200a'
20240916@142306.3924 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3940 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.3951 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e834442166e8313a5f','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.3956 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.3971 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.4000 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e834442166e8313a5f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',66.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240916@142306.4342 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.4399 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.4495 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.4516 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.4533 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.4556 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.4582 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.4603 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e831495766e8313a6f','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.4611 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.4643 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.4701 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66e831495766e8313a6f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,90000,?,?,?)
20240916@142306.4975 4j5ojsu8f57siv961p4mj5m89v Query : use flama_phc
20240916@142306.4983 4j5ojsu8f57siv961p4mj5m89v Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240916@142306.5023 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20240916@142306.5066 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.5110 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.5166 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.5202 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.5223 4j5ojsu8f57siv961p4mj5m89v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240916@142306.5241 4j5ojsu8f57siv961p4mj5m89v Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2301282200a'
20240916@142306.5257 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.5279 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240916@142306.5294 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66e839456066e8313a80','aut66e831068866e83139af' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240916@142306.5299 4j5ojsu8f57siv961p4mj5m89v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240916@142306.5317 4j5ojsu8f57siv961p4mj5m89v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240916@142306.5353 4j5ojsu8f57siv961p4mj5m89v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66e839456066e8313a80',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',54.000 ,'aut66e831068866e83139af' ,0,0 ,2,23.00,110000,?,?,?,?,?)
