20240418@191951.6634 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191951.6653 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191951.6668 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191951.6946 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191951.6995 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191951.7008 juo272o95abphana22p3appj51 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191951.7107 juo272o95abphana22p3appj51 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191951.7119 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191951.7146 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191951.7158 juo272o95abphana22p3appj51 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662162944066216447ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191951.7312 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191951.7334 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191951.7388 juo272o95abphana22p3appj51 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191951.7397 juo272o95abphana22p3appj51 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191951.7404 juo272o95abphana22p3appj51 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191951.7411 juo272o95abphana22p3appj51 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191951.7419 juo272o95abphana22p3appj51 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191951.7452 juo272o95abphana22p3appj51 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191951.7457 juo272o95abphana22p3appj51 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662162944066216447ab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191951.7710 juo272o95abphana22p3appj51 Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191951.7740 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191951.7756 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191951.7776 juo272o95abphana22p3appj51 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662162944066216447ab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',982,101621,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191951.9456 juo272o95abphana22p3appj51 Query : use flama_phc
20240418@191951.9499 juo272o95abphana22p3appj51 Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20240418@191951.9654 juo272o95abphana22p3appj51 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8261.00.1'
20240418@191951.9670 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191951.9685 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191951.9713 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191951.9729 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191951.9735 juo272o95abphana22p3appj51 Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2400077100a'
20240418@191951.9750 juo272o95abphana22p3appj51 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191951.9764 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191951.9799 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191951.9840 juo272o95abphana22p3appj51 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662163903466216447ee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut662162944066216447ab' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191952.1540 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.1790 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191952.1840 juo272o95abphana22p3appj51 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662163903466216447ee','aut662162944066216447ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191952.1890 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.2050 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191952.2360 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.2490 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191952.2590 juo272o95abphana22p3appj51 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191952.2850 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.3100 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191952.3400 juo272o95abphana22p3appj51 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66216557896621644806',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut662162944066216447ab' ,0,0 ,2,23.00,20000,?,?,?)
20240418@191952.5990 juo272o95abphana22p3appj51 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.6190 juo272o95abphana22p3appj51 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191952.6240 juo272o95abphana22p3appj51 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216557896621644806','aut662162944066216447ab' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191952.6290 juo272o95abphana22p3appj51 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662162944066216447ab','2402910','wait',39,'ari17112337378,753000005')
20240418@191952.6450 juo272o95abphana22p3appj51 Query : use flama_phc
20240418@191952.6720 juo272o95abphana22p3appj51 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240418@191952.6870 juo272o95abphana22p3appj51 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1252';
20240418@191952.7110 juo272o95abphana22p3appj51 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1252';
20240418@191952.7280 juo272o95abphana22p3appj51 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1252';
20240418@191952.7450 juo272o95abphana22p3appj51 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1252';
20240418@191952.1176 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240418@191952.1194 1pur182jv1knq7lkk6h3c4bfa3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240418@191952.1227 1pur182jv1knq7lkk6h3c4bfa3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1253';
20240418@191952.1272 1pur182jv1knq7lkk6h3c4bfa3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1253';
20240418@191952.1292 1pur182jv1knq7lkk6h3c4bfa3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1253';
20240418@191952.1315 1pur182jv1knq7lkk6h3c4bfa3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1253';
20240418@191952.1331 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1338 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240418@191952.1357 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1360 1pur182jv1knq7lkk6h3c4bfa3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=908
20240418@191952.1440 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240418@191952.1482 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402911 and bi.ref ='324.727.00.01' and bi.lordem =1
20240418@191952.1833 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1837 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240418@191952.1865 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1868 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 1 valor from td where td.ndoc = 39
20240418@191952.1889 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1892 1pur182jv1knq7lkk6h3c4bfa3 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240418@191952.1904 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240418@191952.1923 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1927 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240418@191952.1941 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1944 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240418@191952.1981 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.1984 1pur182jv1knq7lkk6h3c4bfa3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240418@191952.1998 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.2001 1pur182jv1knq7lkk6h3c4bfa3 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda-aveiro'
20240418@191952.2035 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.2038 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from td where ndoc = 39
20240418@191952.2049 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240418@191952.2061 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191952.2085 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191952.2105 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191952.2120 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191952.2176 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191952.2190 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191952.2201 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191952.2314 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191952.2325 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191952.2340 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191952.2351 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66216329056621644835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191952.2584 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191952.2730 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191952.2786 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191952.2792 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191952.2804 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191952.2809 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191952.2823 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191952.2831 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191952.2848 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66216329056621644835',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191952.3099 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191952.3120 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191952.3138 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191952.3163 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut66216329056621644835',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',983,101621,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191952.3473 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.3484 1pur182jv1knq7lkk6h3c4bfa3 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240418@191952.3507 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240418@191952.3522 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.3538 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191952.3569 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.3583 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191952.3588 1pur182jv1knq7lkk6h3c4bfa3 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240418@191952.3601 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191952.3626 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.3651 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191952.3704 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66216206326621644858',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66216329056621644835' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191952.3961 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.3993 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191952.3999 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216206326621644858','aut66216329056621644835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191952.4004 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.4024 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191952.4050 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.4065 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191952.4070 1pur182jv1knq7lkk6h3c4bfa3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191952.4081 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.4101 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191952.4144 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66216929816621644863',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66216329056621644835' ,0,0 ,2,23.00,20000,?,?,?)
20240418@191952.4410 1pur182jv1knq7lkk6h3c4bfa3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.4442 1pur182jv1knq7lkk6h3c4bfa3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191952.4448 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216929816621644863','aut66216329056621644835' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191952.4461 1pur182jv1knq7lkk6h3c4bfa3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66216329056621644835','2402911','wait',39,'ari17112337378,753000005')
20240418@191952.4479 1pur182jv1knq7lkk6h3c4bfa3 Query : use flama_phc
20240418@191952.4482 1pur182jv1knq7lkk6h3c4bfa3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240418@191952.4495 1pur182jv1knq7lkk6h3c4bfa3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1253';
20240418@191952.4518 1pur182jv1knq7lkk6h3c4bfa3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1253';
20240418@191952.4535 1pur182jv1knq7lkk6h3c4bfa3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1253';
20240418@191952.4550 1pur182jv1knq7lkk6h3c4bfa3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1253';
20240418@191952.4955 io7ctehpjfhi559ufu9hqt763f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240418@191952.4970 io7ctehpjfhi559ufu9hqt763f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240418@191952.4994 io7ctehpjfhi559ufu9hqt763f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1254';
20240418@191952.5059 io7ctehpjfhi559ufu9hqt763f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1254';
20240418@191952.5088 io7ctehpjfhi559ufu9hqt763f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1254';
20240418@191952.5108 io7ctehpjfhi559ufu9hqt763f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1254';
20240418@191952.5124 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.5130 io7ctehpjfhi559ufu9hqt763f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240418@191952.5161 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.5166 io7ctehpjfhi559ufu9hqt763f Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20240418@191952.5248 io7ctehpjfhi559ufu9hqt763f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240418@191952.5260 io7ctehpjfhi559ufu9hqt763f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402912 and bi.ref ='327.8261.00.1' and bi.lordem =1
20240418@191952.6584 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6606 io7ctehpjfhi559ufu9hqt763f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240418@191952.6625 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6629 io7ctehpjfhi559ufu9hqt763f Query : select top 1 1 valor from td where td.ndoc = 39
20240418@191952.6640 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6643 io7ctehpjfhi559ufu9hqt763f Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240418@191952.6655 io7ctehpjfhi559ufu9hqt763f Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240418@191952.6680 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6689 io7ctehpjfhi559ufu9hqt763f Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240418@191952.6742 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6759 io7ctehpjfhi559ufu9hqt763f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240418@191952.6819 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6860 io7ctehpjfhi559ufu9hqt763f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240418@191952.6920 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6924 io7ctehpjfhi559ufu9hqt763f Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - corroios'
20240418@191952.6942 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.6946 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from td where ndoc = 39
20240418@191952.6986 io7ctehpjfhi559ufu9hqt763f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240418@191952.7003 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191952.7018 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191952.7036 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191952.7061 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191952.7110 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191952.7125 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191952.7137 io7ctehpjfhi559ufu9hqt763f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191952.7266 io7ctehpjfhi559ufu9hqt763f Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191952.7280 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191952.7321 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191952.7343 io7ctehpjfhi559ufu9hqt763f Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut662169419966216448ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191952.7520 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191952.7537 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191952.7579 io7ctehpjfhi559ufu9hqt763f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191952.7585 io7ctehpjfhi559ufu9hqt763f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191952.7599 io7ctehpjfhi559ufu9hqt763f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191952.7605 io7ctehpjfhi559ufu9hqt763f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191952.7611 io7ctehpjfhi559ufu9hqt763f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191952.7616 io7ctehpjfhi559ufu9hqt763f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191952.7621 io7ctehpjfhi559ufu9hqt763f Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut662169419966216448ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191952.7904 io7ctehpjfhi559ufu9hqt763f Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191952.7938 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191952.7958 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191952.7983 io7ctehpjfhi559ufu9hqt763f Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut662169419966216448ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',984,101621,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191952.8319 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.8328 io7ctehpjfhi559ufu9hqt763f Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20240418@191952.8348 io7ctehpjfhi559ufu9hqt763f Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8261.00.1'
20240418@191952.8364 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.8383 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191952.8442 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.8457 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191952.8463 io7ctehpjfhi559ufu9hqt763f Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2400077100a'
20240418@191952.8494 io7ctehpjfhi559ufu9hqt763f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191952.8514 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.8538 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191952.8590 io7ctehpjfhi559ufu9hqt763f Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662167130866216448cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut662169419966216448ae' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191952.8929 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.8950 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191952.9035 io7ctehpjfhi559ufu9hqt763f Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662167130866216448cf','aut662169419966216448ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191952.9089 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.9215 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191952.9265 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.9292 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191952.9297 io7ctehpjfhi559ufu9hqt763f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191952.9309 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191952.9338 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191952.9374 io7ctehpjfhi559ufu9hqt763f Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut662163007066216448e3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut662169419966216448ae' ,0,0 ,2,23.00,20000,?,?,?)
20240418@191952.9658 io7ctehpjfhi559ufu9hqt763f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191952.9675 io7ctehpjfhi559ufu9hqt763f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191952.9681 io7ctehpjfhi559ufu9hqt763f Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662163007066216448e3','aut662169419966216448ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191952.9686 io7ctehpjfhi559ufu9hqt763f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut662169419966216448ae','2402912','wait',39,'ari17112337378,753000005')
20240418@191952.9703 io7ctehpjfhi559ufu9hqt763f Query : use flama_phc
20240418@191952.9707 io7ctehpjfhi559ufu9hqt763f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240418@191952.9720 io7ctehpjfhi559ufu9hqt763f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1254';
20240418@191952.9745 io7ctehpjfhi559ufu9hqt763f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1254';
20240418@191952.9772 io7ctehpjfhi559ufu9hqt763f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1254';
20240418@191952.9859 io7ctehpjfhi559ufu9hqt763f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1254';
20240418@191953.3120 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240418@191953.3310 ucg8pj1nec5tgq30rg9q1h5nvs Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240418@191953.3570 ucg8pj1nec5tgq30rg9q1h5nvs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1255';
20240418@191953.4090 ucg8pj1nec5tgq30rg9q1h5nvs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1255';
20240418@191953.4310 ucg8pj1nec5tgq30rg9q1h5nvs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1255';
20240418@191953.4490 ucg8pj1nec5tgq30rg9q1h5nvs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1255';
20240418@191953.4640 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.4690 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240418@191953.4980 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.5020 ucg8pj1nec5tgq30rg9q1h5nvs Query : select no, estab,szadrsdesc from szadrs where u_coddest=4500
20240418@191953.5930 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240418@191953.6050 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402913 and bi.ref ='327.8261.00.1' and bi.lordem =1
20240418@191953.9770 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.9980 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240418@191953.1020 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.1024 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 1 valor from td where td.ndoc = 39
20240418@191953.1035 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.1039 ucg8pj1nec5tgq30rg9q1h5nvs Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240418@191953.1051 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240418@191953.1081 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.1084 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240418@191953.1096 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.1099 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240418@191953.1132 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.1136 ucg8pj1nec5tgq30rg9q1h5nvs Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240418@191953.1253 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.1257 ucg8pj1nec5tgq30rg9q1h5nvs Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - portimão'
20240418@191953.1274 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.1277 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from td where ndoc = 39
20240418@191953.1289 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240418@191953.1328 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191953.1348 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191953.1366 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191953.1398 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191953.1455 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191953.1475 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191953.1512 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191953.1604 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191953.1614 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191953.1651 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191953.1663 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66216299146621644924' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191953.1825 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191953.1845 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191953.1881 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191953.1887 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191953.1892 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191953.1944 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191953.1952 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191953.1958 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191953.1963 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66216299146621644924',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191953.2249 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191953.2278 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191953.2299 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191953.2323 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut66216299146621644924',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',985,101621,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191953.2622 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.2633 ucg8pj1nec5tgq30rg9q1h5nvs Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20240418@191953.2650 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8261.00.1'
20240418@191953.2667 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.2683 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191953.2721 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.2739 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191953.2744 ucg8pj1nec5tgq30rg9q1h5nvs Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2400077100a'
20240418@191953.2761 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191953.2775 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.2790 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191953.2852 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66216229606621644943',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66216299146621644924' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191953.3120 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.3147 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191953.3152 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216229606621644943','aut66216299146621644924' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191953.3158 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.3175 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191953.3210 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.3232 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191953.3237 ucg8pj1nec5tgq30rg9q1h5nvs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191953.3247 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.3262 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191953.3302 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6621696361662164494f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66216299146621644924' ,0,0 ,2,23.00,20000,?,?,?)
20240418@191953.3566 ucg8pj1nec5tgq30rg9q1h5nvs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.3593 ucg8pj1nec5tgq30rg9q1h5nvs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191953.3598 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6621696361662164494f','aut66216299146621644924' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191953.3604 ucg8pj1nec5tgq30rg9q1h5nvs Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66216299146621644924','2402913','wait',39,'ari17112337378,753000005')
20240418@191953.3622 ucg8pj1nec5tgq30rg9q1h5nvs Query : use flama_phc
20240418@191953.3626 ucg8pj1nec5tgq30rg9q1h5nvs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240418@191953.3637 ucg8pj1nec5tgq30rg9q1h5nvs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1255';
20240418@191953.3659 ucg8pj1nec5tgq30rg9q1h5nvs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1255';
20240418@191953.3680 ucg8pj1nec5tgq30rg9q1h5nvs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1255';
20240418@191953.3704 ucg8pj1nec5tgq30rg9q1h5nvs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1255';
20240418@191953.4124 eu4msu7j72gubdnsgcsfrt9iun Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240418@191953.4143 eu4msu7j72gubdnsgcsfrt9iun Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240418@191953.4170 eu4msu7j72gubdnsgcsfrt9iun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1256';
20240418@191953.4239 eu4msu7j72gubdnsgcsfrt9iun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1256';
20240418@191953.4258 eu4msu7j72gubdnsgcsfrt9iun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1256';
20240418@191953.4282 eu4msu7j72gubdnsgcsfrt9iun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1256';
20240418@191953.4334 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.4369 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240418@191953.4384 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.4388 eu4msu7j72gubdnsgcsfrt9iun Query : select no, estab,szadrsdesc from szadrs where u_coddest=2014
20240418@191953.4646 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240418@191953.4675 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402914 and bi.ref ='327.8261.00.1' and bi.lordem =1
20240418@191953.5198 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5209 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240418@191953.5260 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5263 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 1 valor from td where td.ndoc = 39
20240418@191953.5276 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5279 eu4msu7j72gubdnsgcsfrt9iun Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240418@191953.5323 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240418@191953.5345 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5349 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240418@191953.5360 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5364 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240418@191953.5388 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5391 eu4msu7j72gubdnsgcsfrt9iun Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240418@191953.5413 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5420 eu4msu7j72gubdnsgcsfrt9iun Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - guarda'
20240418@191953.5444 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.5447 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from td where ndoc = 39
20240418@191953.5460 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240418@191953.5473 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191953.5492 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191953.5519 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191953.5537 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191953.5578 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191953.5601 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191953.5613 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191953.5722 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191953.5734 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191953.5759 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191953.5771 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66216441196621644989' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191953.6148 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191953.6278 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191953.6312 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191953.6318 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191953.6323 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191953.6329 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191953.6334 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191953.6340 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191953.6344 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66216441196621644989',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191953.6599 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191953.6625 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191953.6640 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191953.6680 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut66216441196621644989',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',986,101621,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191953.6976 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.6981 eu4msu7j72gubdnsgcsfrt9iun Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20240418@191953.6997 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8261.00.1'
20240418@191953.7014 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.7031 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191953.7063 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.7079 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191953.7084 eu4msu7j72gubdnsgcsfrt9iun Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2400077100a'
20240418@191953.7098 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191953.7110 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.7124 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191953.7154 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut662161890266216449ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66216441196621644989' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191953.7428 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.7460 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191953.7465 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662161890266216449ad','aut66216441196621644989' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191953.7470 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.7491 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191953.7581 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.7597 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191953.7616 eu4msu7j72gubdnsgcsfrt9iun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191953.7628 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191953.7670 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191953.7698 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut662160737766216449ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66216441196621644989' ,0,0 ,2,23.00,20000,?,?,?)
20240418@191953.7955 eu4msu7j72gubdnsgcsfrt9iun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191953.7975 eu4msu7j72gubdnsgcsfrt9iun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191953.7981 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut662160737766216449ba','aut66216441196621644989' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191953.7986 eu4msu7j72gubdnsgcsfrt9iun Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66216441196621644989','2402914','wait',39,'ari17112337378,753000005')
20240418@191953.8010 eu4msu7j72gubdnsgcsfrt9iun Query : use flama_phc
20240418@191953.8014 eu4msu7j72gubdnsgcsfrt9iun Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240418@191953.8028 eu4msu7j72gubdnsgcsfrt9iun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1256';
20240418@191953.8050 eu4msu7j72gubdnsgcsfrt9iun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1256';
20240418@191953.8067 eu4msu7j72gubdnsgcsfrt9iun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1256';
20240418@191953.8084 eu4msu7j72gubdnsgcsfrt9iun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1256';
20240418@191953.8487 7debcnkr67vodus7kiba9n9k3f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240418@191953.8505 7debcnkr67vodus7kiba9n9k3f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240418@191953.8537 7debcnkr67vodus7kiba9n9k3f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1257';
20240418@191953.8589 7debcnkr67vodus7kiba9n9k3f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1257';
20240418@191953.8607 7debcnkr67vodus7kiba9n9k3f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1257';
20240418@191953.8627 7debcnkr67vodus7kiba9n9k3f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1257';
20240418@191953.8643 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191953.8648 7debcnkr67vodus7kiba9n9k3f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240418@191953.8666 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191953.8669 7debcnkr67vodus7kiba9n9k3f Query : select no, estab,szadrsdesc from szadrs where u_coddest=997
20240418@191953.8761 7debcnkr67vodus7kiba9n9k3f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240418@191953.8774 7debcnkr67vodus7kiba9n9k3f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402915 and bi.ref ='327.8261.00.1' and bi.lordem =1
20240418@191953.9824 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.1000 7debcnkr67vodus7kiba9n9k3f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240418@191954.6480 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.6600 7debcnkr67vodus7kiba9n9k3f Query : select top 1 1 valor from td where td.ndoc = 39
20240418@191954.6760 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.6790 7debcnkr67vodus7kiba9n9k3f Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240418@191954.6930 7debcnkr67vodus7kiba9n9k3f Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240418@191954.7100 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.7130 7debcnkr67vodus7kiba9n9k3f Query : select top 1 ~inactivo valor from cl where no = '102205' and estab = 0 order by inactivo desc
20240418@191954.8250 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.8290 7debcnkr67vodus7kiba9n9k3f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240418@191954.8400 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.8430 7debcnkr67vodus7kiba9n9k3f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240418@191954.8620 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.8650 7debcnkr67vodus7kiba9n9k3f Query : select szadrsstamp valor from szadrs where szadrsdesc='carlos alberto antunes martins'
20240418@191954.8790 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.9030 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from td where ndoc = 39
20240418@191954.9250 7debcnkr67vodus7kiba9n9k3f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240418@191954.9370 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191954.9530 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191954.9860 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191954.9990 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191954.1028 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191954.1041 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191954.1062 7debcnkr67vodus7kiba9n9k3f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191954.1217 7debcnkr67vodus7kiba9n9k3f Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191954.1229 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191954.1248 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191954.1263 7debcnkr67vodus7kiba9n9k3f Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66216300076621644a19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191954.1419 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191954.1438 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191954.1481 7debcnkr67vodus7kiba9n9k3f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191954.1486 7debcnkr67vodus7kiba9n9k3f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191954.1491 7debcnkr67vodus7kiba9n9k3f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191954.1501 7debcnkr67vodus7kiba9n9k3f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191954.1506 7debcnkr67vodus7kiba9n9k3f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191954.1512 7debcnkr67vodus7kiba9n9k3f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191954.1522 7debcnkr67vodus7kiba9n9k3f Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66216300076621644a19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191954.1786 7debcnkr67vodus7kiba9n9k3f Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191954.1813 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191954.1827 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191954.1855 7debcnkr67vodus7kiba9n9k3f Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut66216300076621644a19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',987,102205,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191954.2353 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.2401 7debcnkr67vodus7kiba9n9k3f Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20240418@191954.2467 7debcnkr67vodus7kiba9n9k3f Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8261.00.1'
20240418@191954.2481 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.2520 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191954.2547 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.2561 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191954.2568 7debcnkr67vodus7kiba9n9k3f Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2400077100a'
20240418@191954.2588 7debcnkr67vodus7kiba9n9k3f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191954.2600 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.2614 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191954.2640 7debcnkr67vodus7kiba9n9k3f Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66216822086621644a3f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66216300076621644a19' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191954.2907 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.2924 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191954.2930 7debcnkr67vodus7kiba9n9k3f Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216822086621644a3f','aut66216300076621644a19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191954.2935 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.2949 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191954.2984 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.3000 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191954.3005 7debcnkr67vodus7kiba9n9k3f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191954.3016 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.3041 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191954.3090 7debcnkr67vodus7kiba9n9k3f Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66216779986621644a49',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66216300076621644a19' ,0,0 ,2,23.00,20000,?,?,?)
20240418@191954.3430 7debcnkr67vodus7kiba9n9k3f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.3449 7debcnkr67vodus7kiba9n9k3f Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191954.3454 7debcnkr67vodus7kiba9n9k3f Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216779986621644a49','aut66216300076621644a19' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191954.3459 7debcnkr67vodus7kiba9n9k3f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66216300076621644a19','2402915','wait',39,'ari17112337378,753000005')
20240418@191954.3476 7debcnkr67vodus7kiba9n9k3f Query : use flama_phc
20240418@191954.3480 7debcnkr67vodus7kiba9n9k3f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240418@191954.3491 7debcnkr67vodus7kiba9n9k3f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1257';
20240418@191954.3521 7debcnkr67vodus7kiba9n9k3f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1257';
20240418@191954.3537 7debcnkr67vodus7kiba9n9k3f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1257';
20240418@191954.3559 7debcnkr67vodus7kiba9n9k3f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1257';
20240418@191954.4006 qsge592gpna4hq5skdc4ql9dbo Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240418@191954.4023 qsge592gpna4hq5skdc4ql9dbo Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240418@191954.4069 qsge592gpna4hq5skdc4ql9dbo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1258';
20240418@191954.4148 qsge592gpna4hq5skdc4ql9dbo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1258';
20240418@191954.4167 qsge592gpna4hq5skdc4ql9dbo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1258';
20240418@191954.4189 qsge592gpna4hq5skdc4ql9dbo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1258';
20240418@191954.4204 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4209 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240418@191954.4236 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4239 qsge592gpna4hq5skdc4ql9dbo Query : select no, estab,szadrsdesc from szadrs where u_coddest=1030
20240418@191954.4333 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240418@191954.4349 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402916 and bi.ref ='327.8261.00.1' and bi.lordem =1
20240418@191954.4681 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4685 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240418@191954.4699 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4702 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 1 valor from td where td.ndoc = 39
20240418@191954.4713 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4716 qsge592gpna4hq5skdc4ql9dbo Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240418@191954.4727 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240418@191954.4742 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4745 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 ~inactivo valor from cl where no = '101871' and estab = 0 order by inactivo desc
20240418@191954.4852 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4856 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240418@191954.4873 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4876 qsge592gpna4hq5skdc4ql9dbo Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240418@191954.4888 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4892 qsge592gpna4hq5skdc4ql9dbo Query : select szadrsstamp valor from szadrs where szadrsdesc='carlos filipe ciÊncia pereira'
20240418@191954.4907 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.4910 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from td where ndoc = 39
20240418@191954.4921 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240418@191954.4933 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191954.4949 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191954.4979 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191954.4994 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191954.5035 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191954.5058 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191954.5071 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191954.5165 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191954.5176 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191954.5192 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191954.5203 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66216466296621644a7b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191954.5348 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191954.5365 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191954.5427 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191954.5432 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191954.5438 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191954.5454 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191954.5460 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191954.5465 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191954.5470 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66216466296621644a7b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191954.5738 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191954.5760 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191954.5776 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191954.5825 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut66216466296621644a7b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',988,101871,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191954.6122 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.6130 qsge592gpna4hq5skdc4ql9dbo Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20240418@191954.6144 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8261.00.1'
20240418@191954.6159 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.6175 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191954.6203 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.6219 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191954.6224 qsge592gpna4hq5skdc4ql9dbo Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2400077100a'
20240418@191954.6243 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191954.6254 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.6269 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191954.6297 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66216575016621644a98',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66216466296621644a7b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191954.6556 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.6573 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191954.6578 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216575016621644a98','aut66216466296621644a7b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191954.6583 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.6622 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191954.6659 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.6685 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191954.6690 qsge592gpna4hq5skdc4ql9dbo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191954.6700 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191954.6721 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191954.6747 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66216101736621644aa3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66216466296621644a7b' ,0,0 ,2,23.00,20000,?,?,?)
20240418@191954.7014 qsge592gpna4hq5skdc4ql9dbo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191954.7031 qsge592gpna4hq5skdc4ql9dbo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191954.7036 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216101736621644aa3','aut66216466296621644a7b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191954.7041 qsge592gpna4hq5skdc4ql9dbo Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66216466296621644a7b','2402916','wait',39,'ari17112337378,753000005')
20240418@191954.7059 qsge592gpna4hq5skdc4ql9dbo Query : use flama_phc
20240418@191954.7062 qsge592gpna4hq5skdc4ql9dbo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240418@191954.7075 qsge592gpna4hq5skdc4ql9dbo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1258';
20240418@191954.7113 qsge592gpna4hq5skdc4ql9dbo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1258';
20240418@191954.7137 qsge592gpna4hq5skdc4ql9dbo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1258';
20240418@191954.7195 qsge592gpna4hq5skdc4ql9dbo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1258';
20240418@191954.7588 0jgl8jb2171v2urvdqc093ks72 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240418@191954.7602 0jgl8jb2171v2urvdqc093ks72 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240418@191954.7636 0jgl8jb2171v2urvdqc093ks72 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1259';
20240418@191954.7689 0jgl8jb2171v2urvdqc093ks72 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1259';
20240418@191954.7707 0jgl8jb2171v2urvdqc093ks72 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1259';
20240418@191954.7729 0jgl8jb2171v2urvdqc093ks72 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1259';
20240418@191954.7767 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.7770 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240418@191954.7785 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.7788 0jgl8jb2171v2urvdqc093ks72 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2262
20240418@191954.7944 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20240418@191954.8140 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402917 and bi.ref ='327.8261.00.1' and bi.lordem =1
20240418@191954.8486 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9306.00.1'
20240418@191954.8634 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2029 and bo.obrano = 2402917 and bi.ref ='328.9306.00.1' and bi.lordem =2
20240418@191954.9025 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9031 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240418@191954.9047 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9050 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 1 valor from td where td.ndoc = 39
20240418@191954.9073 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9077 0jgl8jb2171v2urvdqc093ks72 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240418@191954.9091 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240418@191954.9134 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9139 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 ~inactivo valor from cl where no = '100361' and estab = 0 order by inactivo desc
20240418@191954.9290 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9294 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240418@191954.9312 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9315 0jgl8jb2171v2urvdqc093ks72 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240418@191954.9361 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9364 0jgl8jb2171v2urvdqc093ks72 Query : select szadrsstamp valor from szadrs where szadrsdesc='antonio ramos barata nunes-novo'
20240418@191954.9392 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191954.9395 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from td where ndoc = 39
20240418@191954.9406 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240418@191954.9428 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191954.9456 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240418@191954.9533 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191954.9559 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240418@191954.9589 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191954.9607 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240418@191954.9619 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191954.9725 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240418@191954.9740 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240418@191954.9763 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240418@191954.9781 0jgl8jb2171v2urvdqc093ks72 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66216729706621644aea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240418@191954.9935 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240418@191954.9951 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240418@191955.8000 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240418@191955.3100 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240418@191955.3700 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240418@191955.5000 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240418@191955.5500 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240418@191955.6100 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240418@191955.6600 0jgl8jb2171v2urvdqc093ks72 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66216729706621644aea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240418@191955.3310 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 fno valor from wsft039data order by fno desc
20240418@191955.3740 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240418@191955.3920 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240418@191955.4360 0jgl8jb2171v2urvdqc093ks72 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut66216729706621644aea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',989,100361,0,'2024-04-18',39,'euro',0,0,2024 ,'20240418','1949',?,?,?,?)
20240418@191955.7550 0jgl8jb2171v2urvdqc093ks72 Query : use flama_phc
20240418@191955.7580 0jgl8jb2171v2urvdqc093ks72 Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20240418@191955.7720 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8261.00.1'
20240418@191955.8250 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191955.8630 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191955.9100 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191955.9320 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191955.9440 0jgl8jb2171v2urvdqc093ks72 Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2400077100a'
20240418@191955.9590 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240418@191955.9780 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191955.9930 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240418@191955.1031 0jgl8jb2171v2urvdqc093ks72 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66216030216621644b17',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66216729706621644aea' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240418@191955.1298 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191955.1314 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240418@191955.1325 0jgl8jb2171v2urvdqc093ks72 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66216030216621644b17','aut66216729706621644aea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240418@191955.1330 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240418@191955.1369 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240418@191955.1427 0jgl8jb2171v2urvdqc093ks72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240418@191955.1472 0jgl8jb2171v2urvdqc093ks72 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240418@191955.1492 0jgl8jb2171v2urvdqc093ks72 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
