20230512@154850.8203 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.8206 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154850.8220 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.8228 jtb9cmtadrer3sgknd8ug4ip2q Query : select no, estab,szadrsdesc from szadrs where u_coddest=1161
20230512@154850.8303 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4860.00.1'
20230512@154850.8314 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000169 and bi.ref ='304.4860.00.1' and bi.lordem =20000
20230512@154850.8677 jtb9cmtadrer3sgknd8ug4ip2q Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051243197,4320000-2 ' 
20230512@154850.9025 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9028 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154850.9041 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9044 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154850.9054 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9057 jtb9cmtadrer3sgknd8ug4ip2q Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154850.9068 jtb9cmtadrer3sgknd8ug4ip2q 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
20230512@154850.9081 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9084 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20230512@154850.9095 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9098 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154850.9108 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9111 jtb9cmtadrer3sgknd8ug4ip2q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154850.9122 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9125 jtb9cmtadrer3sgknd8ug4ip2q Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - Évora'
20230512@154850.9142 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154850.9145 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from td where ndoc = 39
20230512@154850.9154 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230512@154850.9167 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154850.9181 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230512@154850.9198 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154850.9212 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230512@154850.9246 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154850.9259 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230512@154850.9270 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154850.9312 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154850.9322 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154850.9334 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230512@154850.9346 jtb9cmtadrer3sgknd8ug4ip2q Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645e561092645e51d2e2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230512@154850.9515 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154850.9528 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230512@154850.9557 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051235260,514000002 '
20230512@154850.9664 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051235260,514000002 '
20230512@154850.9754 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051235260,514000002 '
20230512@154851.0000 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051235260,514000002 '
20230512@154851.1010 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051235260,514000002 '
20230512@154851.1840 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051235260,514000002 '
20230512@154851.2850 jtb9cmtadrer3sgknd8ug4ip2q Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut645e561092645e51d2e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230512@154851.5680 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 fno valor from wsft039data order by fno desc
20230512@154851.5830 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154851.5980 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230512@154851.6170 jtb9cmtadrer3sgknd8ug4ip2q 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 ,encomenda ) values ('aut645e561092645e51d2e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',215,101621,0,'2023-05-12',39,'euro',0,0,2023 ,'20230512','1618',?,?,?,?,?)
20230512@154851.1072 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154851.1157 jtb9cmtadrer3sgknd8ug4ip2q Query : select st.usalote valor from st where st.ref = '304.4860.00.1'
20230512@154851.1174 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4860.00.1'
20230512@154851.1185 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154851.1200 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154851.1225 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154851.1238 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154851.1243 jtb9cmtadrer3sgknd8ug4ip2q Query : select sestamp valor from se where ref ='304.4860.00.1' and lote = '20210723'
20230512@154851.1253 jtb9cmtadrer3sgknd8ug4ip2q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154851.1266 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154851.1280 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154851.1304 jtb9cmtadrer3sgknd8ug4ip2q Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e534155645e51d31e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut645e561092645e51d2e2' ,51.200000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230512@154851.1563 jtb9cmtadrer3sgknd8ug4ip2q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154851.1581 jtb9cmtadrer3sgknd8ug4ip2q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154851.1588 jtb9cmtadrer3sgknd8ug4ip2q Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e534155645e51d31e','aut645e561092645e51d2e2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154851.1593 jtb9cmtadrer3sgknd8ug4ip2q Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645e561092645e51d2e2','119230000169','wait',39,'ari17112337378,753000005')
20230512@154851.1615 jtb9cmtadrer3sgknd8ug4ip2q Query : use flama_phc
20230512@154851.1618 jtb9cmtadrer3sgknd8ug4ip2q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230512@154851.1633 jtb9cmtadrer3sgknd8ug4ip2q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='329';
20230512@154851.1649 jtb9cmtadrer3sgknd8ug4ip2q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='329';
20230512@154851.1662 jtb9cmtadrer3sgknd8ug4ip2q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='329';
20230512@154851.1676 jtb9cmtadrer3sgknd8ug4ip2q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='329';
20230512@154851.2935 1h0qjb327itv1t3qrhnschnkmo Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230512@154851.2955 1h0qjb327itv1t3qrhnschnkmo Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230512@154851.3034 1h0qjb327itv1t3qrhnschnkmo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='330';
20230512@154851.3071 1h0qjb327itv1t3qrhnschnkmo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='330';
20230512@154851.3092 1h0qjb327itv1t3qrhnschnkmo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='330';
20230512@154851.3103 1h0qjb327itv1t3qrhnschnkmo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='330';
20230512@154851.3124 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.3127 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154851.3140 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.3143 1h0qjb327itv1t3qrhnschnkmo Query : select no, estab,szadrsdesc from szadrs where u_coddest=1452
20230512@154851.3216 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4860.00.1'
20230512@154851.3228 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000171 and bi.ref ='304.4860.00.1' and bi.lordem =20000
20230512@154851.3653 1h0qjb327itv1t3qrhnschnkmo Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051243381,6660000-2 ' 
20230512@154851.3986 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.3990 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154851.4004 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.4007 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154851.4018 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.4021 1h0qjb327itv1t3qrhnschnkmo Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154851.4032 1h0qjb327itv1t3qrhnschnkmo 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
20230512@154851.4047 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.4050 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20230512@154851.4062 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.4065 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154851.4076 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.4079 1h0qjb327itv1t3qrhnschnkmo Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154851.4090 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.4093 1h0qjb327itv1t3qrhnschnkmo Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. - castelo branco'
20230512@154851.4108 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.4111 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from td where ndoc = 39
20230512@154851.4122 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230512@154851.4135 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154851.4149 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230512@154851.4167 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154851.4181 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230512@154851.4210 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154851.4224 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230512@154851.4234 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154851.4275 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154851.4285 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154851.4298 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230512@154851.4307 1h0qjb327itv1t3qrhnschnkmo Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645e563400645e51d367' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230512@154851.4473 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154851.4487 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230512@154851.4515 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051233819,834000002 '
20230512@154851.4612 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051233819,834000002 '
20230512@154851.4692 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051233819,834000002 '
20230512@154851.4776 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051233819,834000002 '
20230512@154851.4876 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051233819,834000002 '
20230512@154851.4958 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051233819,834000002 '
20230512@154851.5037 1h0qjb327itv1t3qrhnschnkmo Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut645e563400645e51d367',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230512@154851.5306 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 fno valor from wsft039data order by fno desc
20230512@154851.5320 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154851.5333 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230512@154851.5351 1h0qjb327itv1t3qrhnschnkmo 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 ,encomenda ) values ('aut645e563400645e51d367',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',216,101621,0,'2023-05-12',39,'euro',0,0,2023 ,'20230512','1618',?,?,?,?,?)
20230512@154851.5690 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.5697 1h0qjb327itv1t3qrhnschnkmo Query : select st.usalote valor from st where st.ref = '304.4860.00.1'
20230512@154851.5714 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4860.00.1'
20230512@154851.5729 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154851.5748 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154851.5773 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154851.5787 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154851.5791 1h0qjb327itv1t3qrhnschnkmo Query : select sestamp valor from se where ref ='304.4860.00.1' and lote = '20210723'
20230512@154851.5803 1h0qjb327itv1t3qrhnschnkmo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154851.5814 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154851.5828 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154851.5853 1h0qjb327itv1t3qrhnschnkmo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e522049645e51d38d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut645e563400645e51d367' ,51.200000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230512@154851.6116 1h0qjb327itv1t3qrhnschnkmo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154851.6131 1h0qjb327itv1t3qrhnschnkmo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154851.6136 1h0qjb327itv1t3qrhnschnkmo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e522049645e51d38d','aut645e563400645e51d367' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154851.6140 1h0qjb327itv1t3qrhnschnkmo Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645e563400645e51d367','119230000171','wait',39,'ari17112337378,753000005')
20230512@154851.6157 1h0qjb327itv1t3qrhnschnkmo Query : use flama_phc
20230512@154851.6160 1h0qjb327itv1t3qrhnschnkmo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230512@154851.6171 1h0qjb327itv1t3qrhnschnkmo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='330';
20230512@154851.6184 1h0qjb327itv1t3qrhnschnkmo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='330';
20230512@154851.6195 1h0qjb327itv1t3qrhnschnkmo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='330';
20230512@154851.6207 1h0qjb327itv1t3qrhnschnkmo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='330';
20230512@154851.6586 kglq2o9bt0msc4s14ieveg492s Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230512@154851.6604 kglq2o9bt0msc4s14ieveg492s Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230512@154851.6655 kglq2o9bt0msc4s14ieveg492s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='331';
20230512@154851.6728 kglq2o9bt0msc4s14ieveg492s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='331';
20230512@154851.6743 kglq2o9bt0msc4s14ieveg492s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='331';
20230512@154851.6788 kglq2o9bt0msc4s14ieveg492s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='331';
20230512@154851.6799 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.6802 kglq2o9bt0msc4s14ieveg492s Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154851.6815 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.6849 kglq2o9bt0msc4s14ieveg492s Query : select no, estab,szadrsdesc from szadrs where u_coddest=161
20230512@154851.6967 kglq2o9bt0msc4s14ieveg492s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5347.00.1'
20230512@154851.7154 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000173 and bi.ref ='324.5347.00.1' and bi.lordem =20000
20230512@154851.7612 kglq2o9bt0msc4s14ieveg492s Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250283,1380000-2 ' 
20230512@154851.8057 kglq2o9bt0msc4s14ieveg492s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.551.00.15'
20230512@154851.8243 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000173 and bi.ref ='325.551.00.15' and bi.lordem =30000
20230512@154851.8699 kglq2o9bt0msc4s14ieveg492s Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250283,1570000-3 ' 
20230512@154851.9157 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9161 kglq2o9bt0msc4s14ieveg492s Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154851.9173 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9176 kglq2o9bt0msc4s14ieveg492s Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154851.9217 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9220 kglq2o9bt0msc4s14ieveg492s Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154851.9231 kglq2o9bt0msc4s14ieveg492s 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
20230512@154851.9278 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9281 kglq2o9bt0msc4s14ieveg492s Query : select top 1 ~inactivo valor from cl where no = '101663' and estab = 0 order by inactivo desc
20230512@154851.9292 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9295 kglq2o9bt0msc4s14ieveg492s Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154851.9305 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9308 kglq2o9bt0msc4s14ieveg492s Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154851.9353 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9357 kglq2o9bt0msc4s14ieveg492s Query : select szadrsstamp valor from szadrs where szadrsdesc='jose de freitas & freitas, lda'
20230512@154851.9370 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154851.9373 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from td where ndoc = 39
20230512@154851.9416 kglq2o9bt0msc4s14ieveg492s Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230512@154851.9427 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154851.9472 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230512@154851.9488 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154851.9533 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230512@154851.9559 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154852.1310 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230512@154852.6640 kglq2o9bt0msc4s14ieveg492s Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154852.8380 kglq2o9bt0msc4s14ieveg492s Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154852.1117 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154852.1133 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230512@154852.1177 kglq2o9bt0msc4s14ieveg492s Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645e511099645e51d410' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230512@154852.1393 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154852.1443 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230512@154852.1472 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='754f0b92c0746aadd1bb1f '
20230512@154852.1658 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='754f0b92c0746aadd1bb1f '
20230512@154852.1758 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='754f0b92c0746aadd1bb1f '
20230512@154852.1838 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='754f0b92c0746aadd1bb1f '
20230512@154852.1910 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bo.trab5 valor from bo where bo.bostamp='754f0b92c0746aadd1bb1f '
20230512@154852.1982 kglq2o9bt0msc4s14ieveg492s Query : select top 1 bo.serie valor from bo where bo.bostamp='754f0b92c0746aadd1bb1f '
20230512@154852.2058 kglq2o9bt0msc4s14ieveg492s Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut645e511099645e51d410',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230512@154852.2335 kglq2o9bt0msc4s14ieveg492s Query : select top 1 fno valor from wsft039data order by fno desc
20230512@154852.2352 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154852.2367 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230512@154852.2384 kglq2o9bt0msc4s14ieveg492s 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 ,encomenda ) values ('aut645e511099645e51d410',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',217,101663,0,'2023-05-12',39,'euro',0,0,2023 ,'20230512','1618',?,?,?,?,?)
20230512@154852.2660 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154852.2664 kglq2o9bt0msc4s14ieveg492s Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20230512@154852.2676 kglq2o9bt0msc4s14ieveg492s Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5347.00.1'
20230512@154852.2823 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.2838 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154852.2862 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.2875 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154852.2880 kglq2o9bt0msc4s14ieveg492s Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2200658100a'
20230512@154852.2898 kglq2o9bt0msc4s14ieveg492s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154852.2908 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.2920 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154852.2944 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e586437645e51d447',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut645e511099645e51d410' ,18.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230512@154852.3202 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.3217 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154852.3222 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e586437645e51d447','aut645e511099645e51d410' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154852.3227 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.3242 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154852.3265 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.3277 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154852.3281 kglq2o9bt0msc4s14ieveg492s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154852.3291 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.3305 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154852.3328 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e597281645e51d450',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e511099645e51d410' ,0,0 ,2,23.00,20000,?,?,?)
20230512@154852.3607 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.3622 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154852.3626 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e597281645e51d450','aut645e511099645e51d410' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154852.3631 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154852.3638 kglq2o9bt0msc4s14ieveg492s Query : select st.usalote valor from st where st.ref = '325.551.00.15'
20230512@154852.3650 kglq2o9bt0msc4s14ieveg492s Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '325.551.00.15'
20230512@154852.3808 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.3821 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154852.3843 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.3856 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154852.3860 kglq2o9bt0msc4s14ieveg492s Query : select sestamp valor from se where ref ='325.551.00.15' and lote = 'r210109070'
20230512@154852.3871 kglq2o9bt0msc4s14ieveg492s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154852.3880 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.3893 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154852.3918 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e514528645e51d45e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut645e511099645e51d410' ,4.100000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230512@154852.4178 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.4194 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154852.4198 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e514528645e51d45e','aut645e511099645e51d410' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154852.4206 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.4229 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154852.4256 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.4269 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154852.4274 kglq2o9bt0msc4s14ieveg492s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154852.4285 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154852.4298 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154852.4321 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e548089645e51d468',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e511099645e51d410' ,0,0 ,2,23.00,50000,?,?,?)
20230512@154852.4581 kglq2o9bt0msc4s14ieveg492s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154852.4596 kglq2o9bt0msc4s14ieveg492s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154852.4600 kglq2o9bt0msc4s14ieveg492s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e548089645e51d468','aut645e511099645e51d410' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154852.4605 kglq2o9bt0msc4s14ieveg492s Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645e511099645e51d410','119230000173','wait',39,'ari17112337378,753000005')
20230512@154852.4623 kglq2o9bt0msc4s14ieveg492s Query : use flama_phc
20230512@154852.4626 kglq2o9bt0msc4s14ieveg492s Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230512@154852.4640 kglq2o9bt0msc4s14ieveg492s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='331';
20230512@154852.4653 kglq2o9bt0msc4s14ieveg492s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='331';
20230512@154852.4666 kglq2o9bt0msc4s14ieveg492s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='331';
20230512@154852.4676 kglq2o9bt0msc4s14ieveg492s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='331';
20230512@154852.4981 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230512@154852.5002 3tar4q6e4sujoeqcc9vppbdq4k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230512@154852.5019 3tar4q6e4sujoeqcc9vppbdq4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='332';
20230512@154852.5062 3tar4q6e4sujoeqcc9vppbdq4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='332';
20230512@154852.5075 3tar4q6e4sujoeqcc9vppbdq4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='332';
20230512@154852.5086 3tar4q6e4sujoeqcc9vppbdq4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='332';
20230512@154852.5097 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154852.5100 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154852.5112 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154852.5115 3tar4q6e4sujoeqcc9vppbdq4k Query : select no, estab,szadrsdesc from szadrs where u_coddest=716
20230512@154852.5196 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20230512@154852.5349 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000174 and bi.ref ='304.421.00.04' and bi.lordem =20000
20230512@154852.5696 3tar4q6e4sujoeqcc9vppbdq4k Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250287,9880000-2 ' 
20230512@154852.6071 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20230512@154852.6745 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000174 and bi.ref ='324.1643.00.1' and bi.lordem =30000
20230512@154852.7090 3tar4q6e4sujoeqcc9vppbdq4k Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250288,0000000-3 ' 
20230512@154852.7437 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20230512@154852.7450 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000174 and bi.ref ='324.1643.00.1' and bi.lordem =40000
20230512@154852.7783 3tar4q6e4sujoeqcc9vppbdq4k Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250288,0190000-4 ' 
20230512@154852.8943 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20230512@154852.9102 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000174 and bi.ref ='324.4960.00.1' and bi.lordem =50000
20230512@154852.9428 3tar4q6e4sujoeqcc9vppbdq4k Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250288,0300000-5 ' 
20230512@154852.9781 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20230512@154852.9934 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000174 and bi.ref ='324.2066.00.1' and bi.lordem =70000
20230512@154853.4460 3tar4q6e4sujoeqcc9vppbdq4k Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250288,0620000-7 ' 
20230512@154853.8420 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.8460 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154853.8620 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.8650 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154853.8760 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.8790 3tar4q6e4sujoeqcc9vppbdq4k Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154853.8930 3tar4q6e4sujoeqcc9vppbdq4k 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
20230512@154853.9090 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.9130 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 ~inactivo valor from cl where no = '102291' and estab = 0 order by inactivo desc
20230512@154853.1100 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.1105 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154853.1119 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.1123 3tar4q6e4sujoeqcc9vppbdq4k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154853.1134 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.1137 3tar4q6e4sujoeqcc9vppbdq4k Query : select szadrsstamp valor from szadrs where szadrsdesc='vaga d`imagens unipessoal, lda.'
20230512@154853.1216 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.1221 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from td where ndoc = 39
20230512@154853.1236 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230512@154853.1251 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154853.1269 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230512@154853.1291 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154853.1307 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230512@154853.1341 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154853.1358 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230512@154853.1371 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154853.1417 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154853.1428 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154853.1444 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230512@154853.1456 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230512@154853.1629 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154853.1648 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230512@154853.1691 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='8b4c4ca4b7d9caa6135720 '
20230512@154853.1837 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='8b4c4ca4b7d9caa6135720 '
20230512@154853.1944 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='8b4c4ca4b7d9caa6135720 '
20230512@154853.2641 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='8b4c4ca4b7d9caa6135720 '
20230512@154853.2760 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bo.trab5 valor from bo where bo.bostamp='8b4c4ca4b7d9caa6135720 '
20230512@154853.2871 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 bo.serie valor from bo where bo.bostamp='8b4c4ca4b7d9caa6135720 '
20230512@154853.2972 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut645e559077645e51d521',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230512@154853.3492 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 fno valor from wsft039data order by fno desc
20230512@154853.3545 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154853.3640 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230512@154853.3701 3tar4q6e4sujoeqcc9vppbdq4k 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 ,encomenda ) values ('aut645e559077645e51d521',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',218,102291,0,'2023-05-12',39,'euro',0,0,2023 ,'20230512','1618',?,?,?,?,?)
20230512@154853.4085 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.4089 3tar4q6e4sujoeqcc9vppbdq4k Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20230512@154853.4102 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20230512@154853.4252 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.4267 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154853.4291 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.4304 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154853.4308 3tar4q6e4sujoeqcc9vppbdq4k Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '230336'
20230512@154853.4325 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154853.4337 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.4349 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154853.4372 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e558519645e51d569',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut645e559077645e51d521' ,25.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230512@154853.4652 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.4668 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154853.4673 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e558519645e51d569','aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154853.4678 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.4691 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154853.4718 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.4732 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154853.4736 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154853.4745 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.4757 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154853.4779 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e527527645e51d573',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e559077645e51d521' ,0,0 ,2,23.00,20000,?,?,?)
20230512@154853.5035 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.5050 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154853.5054 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e527527645e51d573','aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154853.5058 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.5061 3tar4q6e4sujoeqcc9vppbdq4k Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20230512@154853.5073 3tar4q6e4sujoeqcc9vppbdq4k 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.1643.00.1'
20230512@154853.5212 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.5226 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154853.5270 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.5283 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154853.5287 3tar4q6e4sujoeqcc9vppbdq4k Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20230512@154853.5297 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154853.5306 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.5317 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154853.5341 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e565227645e51d581',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut645e559077645e51d521' ,96.000000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230512@154853.5579 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.5596 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154853.5600 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e565227645e51d581','aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154853.5604 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.5607 3tar4q6e4sujoeqcc9vppbdq4k Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20230512@154853.5616 3tar4q6e4sujoeqcc9vppbdq4k 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.1643.00.1'
20230512@154853.5626 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.5639 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154853.5661 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.5672 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154853.5677 3tar4q6e4sujoeqcc9vppbdq4k Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20230512@154853.5686 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154853.5696 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.5708 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154853.5736 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e510024645e51d58b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut645e559077645e51d521' ,.000000,0 ,2,23.00,50000,?,?,?,?,?,?,?,?,?)
20230512@154853.5997 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.6013 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154853.6018 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e510024645e51d58b','aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154853.6022 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.6025 3tar4q6e4sujoeqcc9vppbdq4k Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20230512@154853.6038 3tar4q6e4sujoeqcc9vppbdq4k 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.4960.00.1'
20230512@154853.6314 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.6327 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154853.6411 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.6425 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154853.6429 3tar4q6e4sujoeqcc9vppbdq4k Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20230512@154853.6440 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154853.6450 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.6461 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154853.6483 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e518063645e51d59d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut645e559077645e51d521' ,.000000,0 ,2,23.00,60000,?,?,?,?,?,?,?,?,?)
20230512@154853.6902 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.7580 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154853.7585 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e518063645e51d59d','aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154853.7589 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.7592 3tar4q6e4sujoeqcc9vppbdq4k Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20230512@154853.7611 3tar4q6e4sujoeqcc9vppbdq4k 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.2066.00.1'
20230512@154853.7760 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.7773 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154853.7800 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.8348 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154853.8354 3tar4q6e4sujoeqcc9vppbdq4k Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2100893200a'
20230512@154853.8365 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154853.8374 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.8390 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154853.8412 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e526660645e51d5cc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut645e559077645e51d521' ,32.000000,0 ,2,23.00,70000,?,?,?,?,?,?,?,?,?)
20230512@154853.8659 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.8673 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154853.8677 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e526660645e51d5cc','aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154853.8682 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.8694 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154853.8717 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.8728 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154853.8732 3tar4q6e4sujoeqcc9vppbdq4k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154853.8743 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154853.8755 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154853.8777 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e550846645e51d5d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e559077645e51d521' ,0,0 ,2,23.00,80000,?,?,?)
20230512@154853.9009 3tar4q6e4sujoeqcc9vppbdq4k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154853.9024 3tar4q6e4sujoeqcc9vppbdq4k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154853.9029 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e550846645e51d5d5','aut645e559077645e51d521' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154853.9033 3tar4q6e4sujoeqcc9vppbdq4k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645e559077645e51d521','119230000174','wait',39,'ari17112337378,753000005')
20230512@154853.9050 3tar4q6e4sujoeqcc9vppbdq4k Query : use flama_phc
20230512@154853.9052 3tar4q6e4sujoeqcc9vppbdq4k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230512@154853.9064 3tar4q6e4sujoeqcc9vppbdq4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='332';
20230512@154853.9079 3tar4q6e4sujoeqcc9vppbdq4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='332';
20230512@154853.9092 3tar4q6e4sujoeqcc9vppbdq4k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='332';
20230512@154853.9105 3tar4q6e4sujoeqcc9vppbdq4k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='332';
20230512@154853.9429 p7f0tdc0972sbkri72730fe5e3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230512@154853.9443 p7f0tdc0972sbkri72730fe5e3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230512@154853.9459 p7f0tdc0972sbkri72730fe5e3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='333';
20230512@154853.9499 p7f0tdc0972sbkri72730fe5e3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='333';
20230512@154853.9512 p7f0tdc0972sbkri72730fe5e3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='333';
20230512@154853.9523 p7f0tdc0972sbkri72730fe5e3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='333';
20230512@154853.9533 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154853.9536 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154853.9550 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154853.9554 p7f0tdc0972sbkri72730fe5e3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=770
20230512@154853.9586 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9116.00.1'
20230512@154853.9730 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000175 and bi.ref ='328.9116.00.1' and bi.lordem =20000
20230512@154854.5500 p7f0tdc0972sbkri72730fe5e3 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250404,9350000-2 ' 
20230512@154854.5330 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.5740 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154854.6070 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.6100 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154854.6190 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.6220 p7f0tdc0972sbkri72730fe5e3 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154854.6360 p7f0tdc0972sbkri72730fe5e3 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
20230512@154854.6500 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.6530 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230512@154854.6620 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.6650 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154854.6750 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.6770 p7f0tdc0972sbkri72730fe5e3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154854.6870 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.6940 p7f0tdc0972sbkri72730fe5e3 Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- azambuja'
20230512@154854.7050 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.7070 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from td where ndoc = 39
20230512@154854.7160 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230512@154854.7270 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154854.7400 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230512@154854.7550 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154854.7680 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230512@154854.7950 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154854.8080 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230512@154854.8180 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154854.8610 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154854.8700 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154854.8850 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230512@154854.8940 p7f0tdc0972sbkri72730fe5e3 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645e597712645e51d613' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230512@154854.1057 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154854.1071 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230512@154854.1098 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051234841,023000001 '
20230512@154854.1205 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051234841,023000001 '
20230512@154854.1301 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051234841,023000001 '
20230512@154854.1381 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051234841,023000001 '
20230512@154854.1481 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051234841,023000001 '
20230512@154854.1575 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051234841,023000001 '
20230512@154854.1667 p7f0tdc0972sbkri72730fe5e3 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut645e597712645e51d613',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230512@154854.1941 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 fno valor from wsft039data order by fno desc
20230512@154854.1957 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154854.1970 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230512@154854.1987 p7f0tdc0972sbkri72730fe5e3 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 ,encomenda ) values ('aut645e597712645e51d613',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',219,100810,0,'2023-05-12',39,'euro',0,0,2023 ,'20230512','1618',?,?,?,?,?)
20230512@154854.2261 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.2265 p7f0tdc0972sbkri72730fe5e3 Query : select st.usalote valor from st where st.ref = '328.9116.00.1'
20230512@154854.2277 p7f0tdc0972sbkri72730fe5e3 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 = '328.9116.00.1'
20230512@154854.2441 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.2454 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154854.2475 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.2487 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154854.2492 p7f0tdc0972sbkri72730fe5e3 Query : select sestamp valor from se where ref ='328.9116.00.1' and lote = 'r2001441300a'
20230512@154854.2511 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154854.2521 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.2533 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154854.2555 p7f0tdc0972sbkri72730fe5e3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e530870645e51d63d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut645e597712645e51d613' ,266.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230512@154854.2818 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.2835 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154854.2850 p7f0tdc0972sbkri72730fe5e3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e530870645e51d63d','aut645e597712645e51d613' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154854.2855 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.2868 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154854.2890 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.2901 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154854.2905 p7f0tdc0972sbkri72730fe5e3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154854.2914 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.2926 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154854.2948 p7f0tdc0972sbkri72730fe5e3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e550880645e51d647',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e597712645e51d613' ,0,0 ,2,23.00,20000,?,?,?)
20230512@154854.3209 p7f0tdc0972sbkri72730fe5e3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.3225 p7f0tdc0972sbkri72730fe5e3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154854.3230 p7f0tdc0972sbkri72730fe5e3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e550880645e51d647','aut645e597712645e51d613' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154854.3234 p7f0tdc0972sbkri72730fe5e3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645e597712645e51d613','119230000175','wait',39,'ari17112337378,753000005')
20230512@154854.3251 p7f0tdc0972sbkri72730fe5e3 Query : use flama_phc
20230512@154854.3254 p7f0tdc0972sbkri72730fe5e3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230512@154854.3265 p7f0tdc0972sbkri72730fe5e3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='333';
20230512@154854.3278 p7f0tdc0972sbkri72730fe5e3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='333';
20230512@154854.3289 p7f0tdc0972sbkri72730fe5e3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='333';
20230512@154854.3301 p7f0tdc0972sbkri72730fe5e3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='333';
20230512@154854.4021 pfpcf1jnipv1635s03b9i0sa2j Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230512@154854.4034 pfpcf1jnipv1635s03b9i0sa2j Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230512@154854.4049 pfpcf1jnipv1635s03b9i0sa2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='334';
20230512@154854.4089 pfpcf1jnipv1635s03b9i0sa2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='334';
20230512@154854.4101 pfpcf1jnipv1635s03b9i0sa2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='334';
20230512@154854.4111 pfpcf1jnipv1635s03b9i0sa2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='334';
20230512@154854.4123 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.4126 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154854.4137 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.4140 pfpcf1jnipv1635s03b9i0sa2j Query : select no, estab,szadrsdesc from szadrs where u_coddest=770
20230512@154854.4171 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20230512@154854.4321 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000178 and bi.ref ='327.8253.00.1' and bi.lordem =20000
20230512@154854.4681 pfpcf1jnipv1635s03b9i0sa2j Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250496,9330000-2 ' 
20230512@154854.5056 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20230512@154854.5066 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000178 and bi.ref ='327.8253.00.1' and bi.lordem =20000
20230512@154854.5078 pfpcf1jnipv1635s03b9i0sa2j Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250496,9330000-2 ' 
20230512@154854.5089 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5092 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154854.5105 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5108 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154854.5118 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5121 pfpcf1jnipv1635s03b9i0sa2j Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154854.5132 pfpcf1jnipv1635s03b9i0sa2j 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
20230512@154854.5146 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5149 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230512@154854.5158 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5161 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154854.5171 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5174 pfpcf1jnipv1635s03b9i0sa2j Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154854.5184 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5187 pfpcf1jnipv1635s03b9i0sa2j Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- azambuja'
20230512@154854.5198 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.5201 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from td where ndoc = 39
20230512@154854.5211 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230512@154854.5223 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154854.5245 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230512@154854.5262 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154854.5276 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230512@154854.5304 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154854.5317 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230512@154854.5327 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154854.5372 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154854.5383 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154854.5395 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230512@154854.5405 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645e505275645e51d682' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230512@154854.5581 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154854.5597 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230512@154854.5628 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051234839,461000001 '
20230512@154854.5751 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051234839,461000001 '
20230512@154854.5865 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051234839,461000001 '
20230512@154854.5978 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051234839,461000001 '
20230512@154854.6056 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051234839,461000001 '
20230512@154854.6128 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051234839,461000001 '
20230512@154854.7107 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut645e505275645e51d682',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230512@154854.7390 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 fno valor from wsft039data order by fno desc
20230512@154854.7404 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154854.7418 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230512@154854.7440 pfpcf1jnipv1635s03b9i0sa2j 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 ,encomenda ) values ('aut645e505275645e51d682',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',220,100810,0,'2023-05-12',39,'euro',0,0,2023 ,'20230512','1618',?,?,?,?,?)
20230512@154854.7707 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.7711 pfpcf1jnipv1635s03b9i0sa2j Query : select st.usalote valor from st where st.ref = '327.8253.00.1'
20230512@154854.7723 pfpcf1jnipv1635s03b9i0sa2j 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.8253.00.1'
20230512@154854.7863 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.7876 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154854.7902 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.7916 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154854.7920 pfpcf1jnipv1635s03b9i0sa2j Query : select sestamp valor from se where ref ='327.8253.00.1' and lote = 'r210093300a'
20230512@154854.7931 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154854.7941 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.7953 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154854.7978 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e526223645e51d6c1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut645e505275645e51d682' ,252.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230512@154854.8229 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.8245 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154854.8250 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e526223645e51d6c1','aut645e505275645e51d682' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154854.8255 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.8269 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154854.8294 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.8309 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154854.8314 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154854.8325 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.8339 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154854.8365 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e520099645e51d6cb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e505275645e51d682' ,0,0 ,2,23.00,20000,?,?,?)
20230512@154854.8703 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.8718 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154854.8723 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e520099645e51d6cb','aut645e505275645e51d682' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154854.8727 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.8730 pfpcf1jnipv1635s03b9i0sa2j Query : select st.usalote valor from st where st.ref = '327.8253.00.1'
20230512@154854.8742 pfpcf1jnipv1635s03b9i0sa2j 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.8253.00.1'
20230512@154854.8753 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.8767 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154854.8793 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.8807 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154854.8811 pfpcf1jnipv1635s03b9i0sa2j Query : select sestamp valor from se where ref ='327.8253.00.1' and lote = 'r210093300a'
20230512@154854.8823 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154854.8835 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.8847 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154854.8872 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e575832645e51d6d7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut645e505275645e51d682' ,252.000000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230512@154854.9171 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.9187 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154854.9192 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e575832645e51d6d7','aut645e505275645e51d682' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154854.9196 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.9210 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154854.9235 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.9247 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154854.9252 pfpcf1jnipv1635s03b9i0sa2j Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154854.9262 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154854.9274 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154854.9299 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e510006645e51d6e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e505275645e51d682' ,0,0 ,2,23.00,50000,?,?,?)
20230512@154854.9888 pfpcf1jnipv1635s03b9i0sa2j Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154854.9958 pfpcf1jnipv1635s03b9i0sa2j Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154854.9963 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e510006645e51d6e2','aut645e505275645e51d682' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154854.9967 pfpcf1jnipv1635s03b9i0sa2j Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645e505275645e51d682','119230000178','wait',39,'ari17112337378,753000005')
20230512@154854.9985 pfpcf1jnipv1635s03b9i0sa2j Query : use flama_phc
20230512@154854.9988 pfpcf1jnipv1635s03b9i0sa2j Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230512@154855.2000 pfpcf1jnipv1635s03b9i0sa2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='334';
20230512@154855.1600 pfpcf1jnipv1635s03b9i0sa2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='334';
20230512@154855.2700 pfpcf1jnipv1635s03b9i0sa2j Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='334';
20230512@154855.3800 pfpcf1jnipv1635s03b9i0sa2j Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='334';
20230512@154855.4190 kubrbkot04vcm04bbcj8dagqlo Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230512@154855.4310 kubrbkot04vcm04bbcj8dagqlo Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230512@154855.4460 kubrbkot04vcm04bbcj8dagqlo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='335';
20230512@154855.4920 kubrbkot04vcm04bbcj8dagqlo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='335';
20230512@154855.5060 kubrbkot04vcm04bbcj8dagqlo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='335';
20230512@154855.5180 kubrbkot04vcm04bbcj8dagqlo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='335';
20230512@154855.5280 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.5320 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154855.5470 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.5510 kubrbkot04vcm04bbcj8dagqlo Query : select no, estab,szadrsdesc from szadrs where u_coddest=1161
20230512@154855.7210 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9316.00.1'
20230512@154855.9140 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000179 and bi.ref ='328.9316.00.1' and bi.lordem =20000
20230512@154855.1305 kubrbkot04vcm04bbcj8dagqlo Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250503,5130000-2 ' 
20230512@154855.1745 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9316.00.1'
20230512@154855.1756 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000179 and bi.ref ='328.9316.00.1' and bi.lordem =20000
20230512@154855.1769 kubrbkot04vcm04bbcj8dagqlo Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250503,5130000-2 ' 
20230512@154855.1779 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1782 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154855.1795 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1798 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154855.1808 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1811 kubrbkot04vcm04bbcj8dagqlo Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154855.1821 kubrbkot04vcm04bbcj8dagqlo 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
20230512@154855.1834 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1837 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20230512@154855.1847 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1849 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154855.1859 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1862 kubrbkot04vcm04bbcj8dagqlo Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154855.1872 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1875 kubrbkot04vcm04bbcj8dagqlo Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - Évora'
20230512@154855.1886 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.1890 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from td where ndoc = 39
20230512@154855.1899 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230512@154855.1911 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154855.1924 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230512@154855.1941 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154855.1953 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230512@154855.1977 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154855.1990 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230512@154855.2000 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154855.2039 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230512@154855.2049 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230512@154855.2062 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230512@154855.2072 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut645e521047645e51d730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230512@154855.2224 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230512@154855.2602 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230512@154855.3336 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051244798,807000002 '
20230512@154855.3434 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051244798,807000002 '
20230512@154855.3514 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051244798,807000002 '
20230512@154855.3595 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051244798,807000002 '
20230512@154855.3673 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051244798,807000002 '
20230512@154855.3744 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051244798,807000002 '
20230512@154855.3830 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut645e521047645e51d730',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230512@154855.4097 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 fno valor from wsft039data order by fno desc
20230512@154855.4111 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230512@154855.4124 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230512@154855.4142 kubrbkot04vcm04bbcj8dagqlo 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 ,encomenda ) values ('aut645e521047645e51d730',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',221,101621,0,'2023-05-12',39,'euro',0,0,2023 ,'20230512','1618',?,?,?,?,?)
20230512@154855.4423 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.4427 kubrbkot04vcm04bbcj8dagqlo Query : select st.usalote valor from st where st.ref = '328.9316.00.1'
20230512@154855.4440 kubrbkot04vcm04bbcj8dagqlo 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 = '328.9316.00.1'
20230512@154855.4577 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.4591 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154855.4614 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.4628 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154855.4634 kubrbkot04vcm04bbcj8dagqlo Query : select sestamp valor from se where ref ='328.9316.00.1' and lote = 'r2101101100a'
20230512@154855.4652 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154855.4661 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.4673 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154855.4695 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e565070645e51d771',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut645e521047645e51d730' ,83.200000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230512@154855.4945 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.4959 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154855.4963 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e565070645e51d771','aut645e521047645e51d730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154855.4968 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.4981 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154855.5003 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.5014 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154855.5018 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154855.5027 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.5039 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154855.5060 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e556706645e51d77a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e521047645e51d730' ,0,0 ,2,23.00,20000,?,?,?)
20230512@154855.5444 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.5782 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154855.5787 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e556706645e51d77a','aut645e521047645e51d730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154855.5792 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.5795 kubrbkot04vcm04bbcj8dagqlo Query : select st.usalote valor from st where st.ref = '328.9316.00.1'
20230512@154855.5804 kubrbkot04vcm04bbcj8dagqlo 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 = '328.9316.00.1'
20230512@154855.5815 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.5827 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154855.5849 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.5860 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154855.5864 kubrbkot04vcm04bbcj8dagqlo Query : select sestamp valor from se where ref ='328.9316.00.1' and lote = 'r2101101100a'
20230512@154855.5873 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154855.5885 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.5896 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154855.5917 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut645e552137645e51d78f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut645e521047645e51d730' ,83.200000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230512@154855.6171 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.6187 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154855.6192 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e552137645e51d78f','aut645e521047645e51d730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154855.6197 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.6209 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230512@154855.6239 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.6250 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230512@154855.6254 kubrbkot04vcm04bbcj8dagqlo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230512@154855.6263 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230512@154855.6275 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230512@154855.6298 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut645e504354645e51d798',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut645e521047645e51d730' ,0,0 ,2,23.00,50000,?,?,?)
20230512@154855.6539 kubrbkot04vcm04bbcj8dagqlo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230512@154855.6552 kubrbkot04vcm04bbcj8dagqlo Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230512@154855.6556 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut645e504354645e51d798','aut645e521047645e51d730' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230512@154855.6560 kubrbkot04vcm04bbcj8dagqlo Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut645e521047645e51d730','119230000179','wait',39,'ari17112337378,753000005')
20230512@154855.6579 kubrbkot04vcm04bbcj8dagqlo Query : use flama_phc
20230512@154855.6582 kubrbkot04vcm04bbcj8dagqlo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230512@154855.6593 kubrbkot04vcm04bbcj8dagqlo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='335';
20230512@154855.6606 kubrbkot04vcm04bbcj8dagqlo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='335';
20230512@154855.6618 kubrbkot04vcm04bbcj8dagqlo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='335';
20230512@154855.6629 kubrbkot04vcm04bbcj8dagqlo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='335';
20230512@154855.6920 c32vunaelt787k0u0s817vko4c Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230512@154855.6933 c32vunaelt787k0u0s817vko4c Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230512@154855.6950 c32vunaelt787k0u0s817vko4c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='336';
20230512@154855.6993 c32vunaelt787k0u0s817vko4c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='336';
20230512@154855.7005 c32vunaelt787k0u0s817vko4c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='336';
20230512@154855.7018 c32vunaelt787k0u0s817vko4c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='336';
20230512@154855.7031 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154855.7034 c32vunaelt787k0u0s817vko4c Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230512@154855.7047 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154855.7051 c32vunaelt787k0u0s817vko4c Query : select no, estab,szadrsdesc from szadrs where u_coddest=4779
20230512@154855.7143 c32vunaelt787k0u0s817vko4c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20230512@154855.7154 c32vunaelt787k0u0s817vko4c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000180 and bi.ref ='324.4960.00.1' and bi.lordem =20000
20230512@154855.7543 c32vunaelt787k0u0s817vko4c Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250505,6520000-2 ' 
20230512@154855.7903 c32vunaelt787k0u0s817vko4c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20230512@154855.7915 c32vunaelt787k0u0s817vko4c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000180 and bi.ref ='304.421.00.04' and bi.lordem =30000
20230512@154855.8506 c32vunaelt787k0u0s817vko4c Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250505,6640000-3 ' 
20230512@154855.8860 c32vunaelt787k0u0s817vko4c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20230512@154855.8871 c32vunaelt787k0u0s817vko4c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000180 and bi.ref ='304.421.00.04' and bi.lordem =30000
20230512@154855.8884 c32vunaelt787k0u0s817vko4c Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250505,6640000-3 ' 
20230512@154855.8895 c32vunaelt787k0u0s817vko4c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20230512@154855.8908 c32vunaelt787k0u0s817vko4c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000180 and bi.ref ='304.421.00.04' and bi.lordem =30000
20230512@154855.8922 c32vunaelt787k0u0s817vko4c Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250505,6640000-3 ' 
20230512@154855.8939 c32vunaelt787k0u0s817vko4c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2034.00.2'
20230512@154855.9095 c32vunaelt787k0u0s817vko4c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000180 and bi.ref ='324.2034.00.2' and bi.lordem =40000
20230512@154855.9457 c32vunaelt787k0u0s817vko4c Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250505,6780000-4 ' 
20230512@154856.2150 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154856.2200 c32vunaelt787k0u0s817vko4c Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230512@154856.2360 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154856.2400 c32vunaelt787k0u0s817vko4c Query : select top 1 1 valor from td where td.ndoc = 39
20230512@154856.2520 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154856.2550 c32vunaelt787k0u0s817vko4c Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230512@154856.2680 c32vunaelt787k0u0s817vko4c 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
20230512@154856.2860 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154856.2890 c32vunaelt787k0u0s817vko4c Query : select top 1 ~inactivo valor from cl where no = '101900' and estab = 0 order by inactivo desc
20230512@154856.4010 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154856.4040 c32vunaelt787k0u0s817vko4c Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230512@154856.4160 c32vunaelt787k0u0s817vko4c Query : use flama_phc
20230512@154856.4190 c32vunaelt787k0u0s817vko4c Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230512@154856.4300 c32vunaelt787k0u0s817vko4c Query : use flama_phc
