20240321@165029.6677 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.6680 37gf4vh63j3kjmos8gn3lnnm20 Query : select no, estab,szadrsdesc from szadrs where u_coddest=928
20240321@165029.6764 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240321@165029.6924 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2022 and bo.obrano = 2402289 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240321@165029.7254 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240321@165029.7435 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2022 and bo.obrano = 2402289 and bi.ref ='324.5396.00.1' and bi.lordem =2
20240321@165029.7753 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1461.00.1'
20240321@165029.7905 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2022 and bo.obrano = 2402289 and bi.ref ='324.1461.00.1' and bi.lordem =3
20240321@165029.8260 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240321@165029.8271 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2022 and bo.obrano = 2402289 and bi.ref ='304.4320.00.1' and bi.lordem =4
20240321@165029.8763 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8767 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240321@165029.8779 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8782 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 1 valor from td where td.ndoc = 39
20240321@165029.8791 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8794 37gf4vh63j3kjmos8gn3lnnm20 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240321@165029.8815 37gf4vh63j3kjmos8gn3lnnm20 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
20240321@165029.8830 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8833 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 ~inactivo valor from cl where no = '100709' and estab = 0 order by inactivo desc
20240321@165029.8944 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8948 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240321@165029.8959 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8962 37gf4vh63j3kjmos8gn3lnnm20 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240321@165029.8972 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8975 37gf4vh63j3kjmos8gn3lnnm20 Query : select szadrsstamp valor from szadrs where szadrsdesc='aderito de jesus gonÇalves'
20240321@165029.8988 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165029.8991 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from td where ndoc = 39
20240321@165029.9001 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240321@165029.9013 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240321@165029.9027 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240321@165029.9043 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240321@165029.9059 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240321@165029.9086 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240321@165029.9101 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240321@165029.9111 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240321@165029.9202 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240321@165029.9212 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240321@165029.9224 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240321@165029.9234 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65fc61955665fc6555de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240321@165029.9419 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240321@165029.9432 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240321@165029.9461 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240321@165029.9466 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240321@165029.9471 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240321@165029.9475 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240321@165029.9480 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240321@165029.9485 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240321@165029.9519 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65fc61955665fc6555de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240321@165029.9756 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 fno valor from wsft039data order by fno desc
20240321@165029.9772 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240321@165029.9787 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240321@165029.9804 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65fc61955665fc6555de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',569,100709,0,'2024-03-21',39,'euro',0,0,2024 ,'20240321','1720',?,?,?,?)
20240321@165030.1070 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165030.1110 37gf4vh63j3kjmos8gn3lnnm20 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240321@165030.1230 37gf4vh63j3kjmos8gn3lnnm20 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.4970.00.1'
20240321@165030.2730 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.2870 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.3120 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.3250 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.3290 37gf4vh63j3kjmos8gn3lnnm20 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240321@165030.3400 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.3500 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.3620 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.4150 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65fc67771265fc655608',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65fc61955665fc6555de' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240321@165030.6660 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.6810 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.6860 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc67771265fc655608','aut65fc61955665fc6555de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.6900 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165030.6930 37gf4vh63j3kjmos8gn3lnnm20 Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240321@165030.7060 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5396.00.1'
20240321@165030.8560 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.8700 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.8940 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.9070 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.9110 37gf4vh63j3kjmos8gn3lnnm20 Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240321@165030.9220 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.9310 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.9450 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.9690 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65fc67593665fc655616',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65fc61955665fc6555de' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240321@165030.1238 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.1253 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.1257 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc67593665fc655616','aut65fc61955665fc6555de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.1262 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.1277 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.1301 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.1315 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.1320 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.1329 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.1343 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.1368 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65fc60689165fc655620',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65fc61955665fc6555de' ,0,0 ,2,23.00,30000,?,?,?)
20240321@165030.1629 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.1643 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.1649 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc60689165fc655620','aut65fc61955665fc6555de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.1653 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165030.1656 37gf4vh63j3kjmos8gn3lnnm20 Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20240321@165030.1668 37gf4vh63j3kjmos8gn3lnnm20 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.1461.00.1'
20240321@165030.1816 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.1831 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.1857 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.1870 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.1874 37gf4vh63j3kjmos8gn3lnnm20 Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100463200a'
20240321@165030.1893 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.1903 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.1915 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.1938 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65fc69502165fc65562e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut65fc61955665fc6555de' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240321@165030.2183 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.2239 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.2244 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc69502165fc65562e','aut65fc61955665fc6555de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.2248 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165030.2251 37gf4vh63j3kjmos8gn3lnnm20 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240321@165030.2263 37gf4vh63j3kjmos8gn3lnnm20 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.4320.00.1'
20240321@165030.2275 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.2288 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.2312 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.2325 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.2329 37gf4vh63j3kjmos8gn3lnnm20 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '231890'
20240321@165030.2339 37gf4vh63j3kjmos8gn3lnnm20 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.2349 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.2363 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.2390 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65fc67821365fc655639',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65fc61955665fc6555de' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240321@165030.2630 37gf4vh63j3kjmos8gn3lnnm20 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.2645 37gf4vh63j3kjmos8gn3lnnm20 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.2649 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc67821365fc655639','aut65fc61955665fc6555de' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.2653 37gf4vh63j3kjmos8gn3lnnm20 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65fc61955665fc6555de','2402289','wait',39,'ari17112337378,753000005')
20240321@165030.2669 37gf4vh63j3kjmos8gn3lnnm20 Query : use flama_phc
20240321@165030.2672 37gf4vh63j3kjmos8gn3lnnm20 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240321@165030.2684 37gf4vh63j3kjmos8gn3lnnm20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='758';
20240321@165030.2699 37gf4vh63j3kjmos8gn3lnnm20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='758';
20240321@165030.2742 37gf4vh63j3kjmos8gn3lnnm20 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='758';
20240321@165030.2757 37gf4vh63j3kjmos8gn3lnnm20 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='758';
20240321@165030.3169 baqn1hdacqhtdeal6lcanupna7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240321@165030.3182 baqn1hdacqhtdeal6lcanupna7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240321@165030.3199 baqn1hdacqhtdeal6lcanupna7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='759';
20240321@165030.3239 baqn1hdacqhtdeal6lcanupna7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='759';
20240321@165030.3253 baqn1hdacqhtdeal6lcanupna7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='759';
20240321@165030.3265 baqn1hdacqhtdeal6lcanupna7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='759';
20240321@165030.3277 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.3280 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240321@165030.3293 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.3297 baqn1hdacqhtdeal6lcanupna7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2163
20240321@165030.3420 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240321@165030.3574 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2022 and bo.obrano = 2402294 and bi.ref ='324.1816.00.1' and bi.lordem =1
20240321@165030.3937 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20240321@165030.3950 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2022 and bo.obrano = 2402294 and bi.ref ='324.1834.00.1' and bi.lordem =2
20240321@165030.4304 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240321@165030.4315 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2022 and bo.obrano = 2402294 and bi.ref ='324.1816.00.1' and bi.lordem =3
20240321@165030.4623 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4627 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240321@165030.4640 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4643 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 1 valor from td where td.ndoc = 39
20240321@165030.4652 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4655 baqn1hdacqhtdeal6lcanupna7 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240321@165030.4665 baqn1hdacqhtdeal6lcanupna7 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
20240321@165030.4678 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4682 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 ~inactivo valor from cl where no = '100204' and estab = 0 order by inactivo desc
20240321@165030.4774 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4777 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240321@165030.4787 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4790 baqn1hdacqhtdeal6lcanupna7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240321@165030.4801 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4803 baqn1hdacqhtdeal6lcanupna7 Query : select szadrsstamp valor from szadrs where szadrsdesc='eurolouÇas, lda'
20240321@165030.4816 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.4819 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from td where ndoc = 39
20240321@165030.4828 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240321@165030.4838 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240321@165030.4851 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240321@165030.4867 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240321@165030.4879 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240321@165030.4906 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240321@165030.4918 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240321@165030.4938 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240321@165030.5088 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240321@165030.5098 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240321@165030.5112 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240321@165030.5122 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65fc60191365fc655678' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240321@165030.5340 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240321@165030.5355 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240321@165030.5383 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240321@165030.5388 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240321@165030.5393 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240321@165030.5398 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240321@165030.5403 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240321@165030.5407 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240321@165030.5411 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65fc60191365fc655678',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240321@165030.5645 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 fno valor from wsft039data order by fno desc
20240321@165030.5661 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240321@165030.5675 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240321@165030.5691 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65fc60191365fc655678',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',570,100204,0,'2024-03-21',39,'euro',0,0,2024 ,'20240321','1720',?,?,?,?)
20240321@165030.5971 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.5975 baqn1hdacqhtdeal6lcanupna7 Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240321@165030.5987 baqn1hdacqhtdeal6lcanupna7 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.1816.00.1'
20240321@165030.6145 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.6158 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.6188 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.6201 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.6205 baqn1hdacqhtdeal6lcanupna7 Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2301090200a'
20240321@165030.6215 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.6226 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.6240 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.6262 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65fc67228465fc655697',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut65fc60191365fc655678' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240321@165030.6508 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.6522 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.6527 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc67228465fc655697','aut65fc60191365fc655678' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.6531 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.6544 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.6565 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.6577 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.6581 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.6590 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.6601 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.6625 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65fc68313265fc6556a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65fc60191365fc655678' ,0,0 ,2,23.00,20000,?,?,?)
20240321@165030.6867 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.6912 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.6917 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc68313265fc6556a0','aut65fc60191365fc655678' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.6921 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.6923 baqn1hdacqhtdeal6lcanupna7 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20240321@165030.6933 baqn1hdacqhtdeal6lcanupna7 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.1834.00.1'
20240321@165030.6943 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.6956 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.6987 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.6998 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.7002 baqn1hdacqhtdeal6lcanupna7 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2300974200a'
20240321@165030.7013 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.7022 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.7033 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.7056 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65fc61906265fc6556ab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65fc60191365fc655678' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240321@165030.7302 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.7316 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.7320 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc61906265fc6556ab','aut65fc60191365fc655678' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.7324 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.7337 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.7358 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.7405 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.7409 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.7418 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.7429 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.7451 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65fc62384565fc6556b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65fc60191365fc655678' ,0,0 ,2,23.00,50000,?,?,?)
20240321@165030.7697 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.7712 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.7716 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc62384565fc6556b5','aut65fc60191365fc655678' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.7720 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.7723 baqn1hdacqhtdeal6lcanupna7 Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240321@165030.7733 baqn1hdacqhtdeal6lcanupna7 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.1816.00.1'
20240321@165030.7746 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.7759 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.7779 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.7791 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.7795 baqn1hdacqhtdeal6lcanupna7 Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2301090200a'
20240321@165030.7804 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.7812 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.7823 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.7843 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65fc68462465fc6556be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut65fc60191365fc655678' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240321@165030.8088 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.8101 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.8106 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc68462465fc6556be','aut65fc60191365fc655678' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.8111 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.8123 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240321@165030.8144 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.8156 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240321@165030.8160 baqn1hdacqhtdeal6lcanupna7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240321@165030.8169 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240321@165030.8180 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240321@165030.8202 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65fc68569765fc6556c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65fc60191365fc655678' ,0,0 ,2,23.00,80000,?,?,?)
20240321@165030.8440 baqn1hdacqhtdeal6lcanupna7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240321@165030.8455 baqn1hdacqhtdeal6lcanupna7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240321@165030.8459 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fc68569765fc6556c7','aut65fc60191365fc655678' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240321@165030.8463 baqn1hdacqhtdeal6lcanupna7 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65fc60191365fc655678','2402294','wait',39,'ari17112337378,753000005')
20240321@165030.8483 baqn1hdacqhtdeal6lcanupna7 Query : use flama_phc
20240321@165030.8486 baqn1hdacqhtdeal6lcanupna7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240321@165030.8497 baqn1hdacqhtdeal6lcanupna7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='759';
20240321@165030.8512 baqn1hdacqhtdeal6lcanupna7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='759';
20240321@165030.8528 baqn1hdacqhtdeal6lcanupna7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='759';
20240321@165030.8539 baqn1hdacqhtdeal6lcanupna7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='759';

20240322@080259.6080 lsdcjj2ht2u8qul18bqbi6h642 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='760';
20240322@080259.6110 lsdcjj2ht2u8qul18bqbi6h642 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='760';
20240322@080259.6127 lsdcjj2ht2u8qul18bqbi6h642 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='760';

20240322@103300.8617 qshm4qas5cgag456mii4jb3uva Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='761';
20240322@103300.8651 qshm4qas5cgag456mii4jb3uva Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='761';
20240322@103300.8668 qshm4qas5cgag456mii4jb3uva Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='761';
20240322@103300.8681 qshm4qas5cgag456mii4jb3uva Query : use flama_phc
20240322@103300.8685 qshm4qas5cgag456mii4jb3uva Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240322@103300.8736 qshm4qas5cgag456mii4jb3uva Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.421.00.04'
20240322@103300.8863 qshm4qas5cgag456mii4jb3uva Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2024 and bo.obrano = 5 and bi.ref ='304.421.00.04' and bi.lordem =1
20240322@103300.9220 qshm4qas5cgag456mii4jb3uva Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.422.00.07'
20240322@103300.9337 qshm4qas5cgag456mii4jb3uva Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2024 and bo.obrano = 5 and bi.ref ='304.422.00.07' and bi.lordem =2
20240322@103300.9674 qshm4qas5cgag456mii4jb3uva Query : use flama_phc
20240322@103300.9678 qshm4qas5cgag456mii4jb3uva Query : select top 1 1 valor from ts where ts.ndos = 61
20240322@103300.9749 qshm4qas5cgag456mii4jb3uva Query : use flama_phc
20240322@103300.9753 qshm4qas5cgag456mii4jb3uva Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240322@103300.9868 qshm4qas5cgag456mii4jb3uva Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when (cmstocks>50 or cm2stocks>50 ) then 1 else 0 end saida ,stneg validatestock ,tiposaft from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =61
20240322@103301.1300 qshm4qas5cgag456mii4jb3uva Query : use flama_phc
20240322@103301.1700 qshm4qas5cgag456mii4jb3uva Query : select top 1 ~inactivo valor from fl where no = '1626' and estab = 26 order by inactivo desc
20240322@103301.9700 qshm4qas5cgag456mii4jb3uva Query : use flama_phc
20240322@103301.1010 qshm4qas5cgag456mii4jb3uva Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20240322@103301.1580 qshm4qas5cgag456mii4jb3uva Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='761';
20240322@103301.1780 qshm4qas5cgag456mii4jb3uva Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='761';

20240322@121823.9362 lc2247nhttjuc9t43s3ihbj286 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='762';
20240322@121823.9378 lc2247nhttjuc9t43s3ihbj286 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='762';
20240322@121823.9392 lc2247nhttjuc9t43s3ihbj286 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='762';

20240322@155003.5214 ro3le9u5jl6jvr6br4qmpbqm4l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='763';
20240322@155003.5249 ro3le9u5jl6jvr6br4qmpbqm4l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='763';
20240322@155003.5265 ro3le9u5jl6jvr6br4qmpbqm4l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='763';
20240322@155003.5281 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155003.5284 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240322@155003.5422 ro3le9u5jl6jvr6br4qmpbqm4l Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20240322@155003.5509 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2221.00.1'
20240322@155003.5624 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2222.00.1'
20240322@155003.5815 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2223.00.1'
20240322@155003.5970 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2224.00.1'
20240322@155003.6084 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5343.00.1'
20240322@155003.6199 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6396 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6530 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6536 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6540 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6545 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6549 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6553 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '*multi*'
20240322@155003.6558 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155003.6562 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 1 valor from ts where ts.ndos = 5
20240322@155003.6973 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155003.6983 ro3le9u5jl6jvr6br4qmpbqm4l Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240322@155003.7031 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when (cmstocks>50 or cm2stocks>50 ) then 1 else 0 end saida ,stneg validatestock ,tiposaft from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240322@155003.7198 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155003.7202 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20240322@155003.7304 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155003.7307 ro3le9u5jl6jvr6br4qmpbqm4l Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240322@155003.7353 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155003.7357 ro3le9u5jl6jvr6br4qmpbqm4l Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20240322@155003.7369 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155003.7372 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from ts where ndos = 5
20240322@155003.7451 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbo005fields'
20240322@155003.7875 ro3le9u5jl6jvr6br4qmpbqm4l Query : select fieldkey,fieldname,fieldtype,mandatory from wsbo005fields
20240322@155003.7924 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbo2005fields'
20240322@155003.8280 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbo3005fields'
20240322@155003.8583 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20240322@155003.8738 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240322@155003.9916 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 bo.obrano valor from wsbo005data bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240322@155004.7200 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.7700 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20240322@155004.1690 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbo3005fields'
20240322@155004.1780 ro3le9u5jl6jvr6br4qmpbqm4l Query : insert into wsbo3005data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fda6053265fda8ac01',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240322@155004.3200 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbo2005fields'
20240322@155004.3300 ro3le9u5jl6jvr6br4qmpbqm4l Query : insert into wsbo2005data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut65fda6053265fda8ac01','ga','bo','0',0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20240322','16:20',?,?)
20240322@155004.7580 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbo005fields'
20240322@155004.7780 ro3le9u5jl6jvr6br4qmpbqm4l Query : select fieldkey,fieldname,fieldtype,calcformula from wsbo005fields
20240322@155004.1099 ro3le9u5jl6jvr6br4qmpbqm4l Query : insert into wsbo005data (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut65fda6053265fda8ac01','trf entre armazéns a','2024-03-22',5,192,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20240322@155004.2009 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.2013 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240322@155004.2141 ro3le9u5jl6jvr6br4qmpbqm4l 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.2221.00.1'
20240322@155004.2307 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbi005fields'
20240322@155004.2873 ro3le9u5jl6jvr6br4qmpbqm4l Query : select fieldkey,fieldname,fieldtype,mandatory from wsbi005fields
20240322@155004.3017 ro3le9u5jl6jvr6br4qmpbqm4l Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsbi2005fields'
20240322@155004.3348 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3353 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20240322@155004.3366 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3370 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '324.2223.00.1'
20240322@155004.3382 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3385 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240322@155004.3397 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3401 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240322@155004.3414 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3418 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3424 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3428 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3434 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3438 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3444 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3447 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3451 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3455 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3539 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3543 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3549 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3552 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3558 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3561 ro3le9u5jl6jvr6br4qmpbqm4l Query : select st.usalote valor from st where st.ref = '*multi*'
20240322@155004.3573 ro3le9u5jl6jvr6br4qmpbqm4l Query : use flama_phc
20240322@155004.3576 ro3le9u5jl6jvr6br4qmpbqm4l Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -150
20240322@155004.3641 ro3le9u5jl6jvr6br4qmpbqm4l Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='763';
20240322@155004.3659 ro3le9u5jl6jvr6br4qmpbqm4l Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='763';

20240322@173504.2528 40en85rl4409v6ert6g8laairn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='764';
20240322@173504.2546 40en85rl4409v6ert6g8laairn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='764';
20240322@173504.2563 40en85rl4409v6ert6g8laairn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='764';
20240322@173504.2580 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.2584 40en85rl4409v6ert6g8laairn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240322@173504.2599 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.2603 40en85rl4409v6ert6g8laairn Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20240322@173504.2700 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1293.00.1'
20240322@173504.2856 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240322@173504.3029 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240322@173504.3226 40en85rl4409v6ert6g8laairn 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'
20240322@173504.4504 40en85rl4409v6ert6g8laairn 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'
20240322@173504.4519 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20240322@173504.4707 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20240322@173504.4877 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20240322@173504.4888 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240322@173504.5055 40en85rl4409v6ert6g8laairn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20240322@173504.5228 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5232 40en85rl4409v6ert6g8laairn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240322@173504.5405 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5409 40en85rl4409v6ert6g8laairn Query : select top 1 1 valor from td where td.ndoc = 39
20240322@173504.5493 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5497 40en85rl4409v6ert6g8laairn Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240322@173504.5509 40en85rl4409v6ert6g8laairn 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
20240322@173504.5634 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5638 40en85rl4409v6ert6g8laairn Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20240322@173504.5769 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5773 40en85rl4409v6ert6g8laairn Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240322@173504.5856 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5860 40en85rl4409v6ert6g8laairn Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240322@173504.5872 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5875 40en85rl4409v6ert6g8laairn Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20240322@173504.5890 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173504.5893 40en85rl4409v6ert6g8laairn Query : select 1 valor from td where ndoc = 39
20240322@173504.5982 40en85rl4409v6ert6g8laairn Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240322@173504.6071 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240322@173504.6377 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240322@173504.6442 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240322@173504.6764 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240322@173504.6857 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240322@173504.7174 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240322@173504.7224 40en85rl4409v6ert6g8laairn Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240322@173504.7469 40en85rl4409v6ert6g8laairn Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240322@173504.7621 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240322@173504.7637 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240322@173504.7672 40en85rl4409v6ert6g8laairn Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240322@173504.8313 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240322@173504.8329 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240322@173504.8387 40en85rl4409v6ert6g8laairn Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240322@173504.8504 40en85rl4409v6ert6g8laairn Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240322@173504.8680 40en85rl4409v6ert6g8laairn Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240322@173504.8963 40en85rl4409v6ert6g8laairn Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240322@173504.9153 40en85rl4409v6ert6g8laairn Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240322@173504.9252 40en85rl4409v6ert6g8laairn Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240322@173504.9364 40en85rl4409v6ert6g8laairn Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65fdc7443765fdc148b0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240322@173504.9992 40en85rl4409v6ert6g8laairn Query : select top 1 fno valor from wsft039data order by fno desc
20240322@173505.1360 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240322@173505.1670 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240322@173505.2100 40en85rl4409v6ert6g8laairn Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut65fdc7443765fdc148b0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',571,101597,0,'2024-03-22',39,'euro',0,0,2024 ,'20240322','1805',?,?,?,?)
20240322@173505.1085 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173505.1090 40en85rl4409v6ert6g8laairn Query : select st.usalote valor from st where st.ref = '324.1293.00.1'
20240322@173505.1105 40en85rl4409v6ert6g8laairn 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.1293.00.1'
20240322@173505.1267 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.1584 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.1648 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.1984 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.2012 40en85rl4409v6ert6g8laairn Query : select sestamp valor from se where ref ='324.1293.00.1' and lote = 'r2101042200a'
20240322@173505.2083 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.2121 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.2135 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.2184 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut65fdc6547165fdc14933',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,10000,?,?,?,?)
20240322@173505.2833 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.2849 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.2874 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc6547165fdc14933','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.2967 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.2983 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.3023 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.3037 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.3042 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.3051 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.3063 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.3090 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65fdc9396665fdc1494a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,20000,?,?,?)
20240322@173505.3367 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.3385 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.3390 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc9396665fdc1494a','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.3395 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173505.3399 40en85rl4409v6ert6g8laairn Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240322@173505.3411 40en85rl4409v6ert6g8laairn 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.958.00.01'
20240322@173505.4378 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.4794 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.4820 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.4915 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.4920 40en85rl4409v6ert6g8laairn Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2301081100a'
20240322@173505.4932 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.4945 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.4961 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.4987 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut65fdc0483765fdc14978',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,40000,?,?,?,?)
20240322@173505.5282 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.5435 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.5442 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc0483765fdc14978','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.5447 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173505.5451 40en85rl4409v6ert6g8laairn Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240322@173505.5463 40en85rl4409v6ert6g8laairn 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.948.00.01'
20240322@173505.5633 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.5647 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.5679 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.5695 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.5700 40en85rl4409v6ert6g8laairn Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240322@173505.5714 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.5726 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.5744 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.5772 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut65fdc3380065fdc1498b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,50000,?,?,?,?)
20240322@173505.6038 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.6058 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.6064 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc3380065fdc1498b','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.6068 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173505.6072 40en85rl4409v6ert6g8laairn Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240322@173505.6086 40en85rl4409v6ert6g8laairn 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'
20240322@173505.6265 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.6287 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.6319 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.6336 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.6342 40en85rl4409v6ert6g8laairn Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240073'
20240322@173505.6355 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.6367 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.6384 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.6414 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut65fdc1186965fdc1499b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,60000,?,?,?,?)
20240322@173505.6833 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.6853 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.6860 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc1186965fdc1499b','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.6867 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.6885 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.6912 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.6927 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.6932 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.6943 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.6972 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.7001 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65fdc6200965fdc149a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,70000,?,?,?)
20240322@173505.7397 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.7416 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.7420 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc6200965fdc149a9','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.7426 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173505.7430 40en85rl4409v6ert6g8laairn Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240322@173505.7443 40en85rl4409v6ert6g8laairn 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'
20240322@173505.7456 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.7471 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.7498 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.7514 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.7519 40en85rl4409v6ert6g8laairn Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240073'
20240322@173505.7530 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.7543 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.7558 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.7586 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut65fdc2836365fdc149b8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28.000 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,90000,?,?,?,?)
20240322@173505.7868 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.7887 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.7892 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc2836365fdc149b8','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.7898 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.7915 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.7945 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.7964 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.7971 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.7985 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.8003 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.8036 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65fdc1894365fdc149c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,100000,?,?,?)
20240322@173505.8304 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.8323 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.8328 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc1894365fdc149c2','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.8334 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173505.8338 40en85rl4409v6ert6g8laairn Query : select st.usalote valor from st where st.ref = '304.422.00.07'
20240322@173505.8367 40en85rl4409v6ert6g8laairn 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.422.00.07'
20240322@173505.8533 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.8550 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.8582 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.8596 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.8608 40en85rl4409v6ert6g8laairn Query : select sestamp valor from se where ref ='304.422.00.07' and lote = '240338'
20240322@173505.8625 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.8636 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.8713 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.8743 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut65fdc4700265fdc149d2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,120000,?,?,?,?)
20240322@173505.9120 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.9171 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240322@173505.9176 40en85rl4409v6ert6g8laairn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65fdc4700265fdc149d2','aut65fdc7443765fdc148b0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240322@173505.9183 40en85rl4409v6ert6g8laairn Query : use flama_phc
20240322@173505.9187 40en85rl4409v6ert6g8laairn Query : select st.usalote valor from st where st.ref = '324.681.00.01'
20240322@173505.9203 40en85rl4409v6ert6g8laairn 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.681.00.01'
20240322@173505.9359 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.9374 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240322@173505.9401 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240322@173505.9417 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240322@173505.9421 40en85rl4409v6ert6g8laairn Query : select sestamp valor from se where ref ='324.681.00.01' and lote = 'r2301180300a'
20240322@173505.9436 40en85rl4409v6ert6g8laairn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240322@173505.9447 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240322@173505.9463 40en85rl4409v6ert6g8laairn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240322@173505.9494 40en85rl4409v6ert6g8laairn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut65fdc8965865fdc149e6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut65fdc7443765fdc148b0' ,0,0 ,2,23.00,130000,?,?,?,?)
20240322@173505.9744 40en85rl4409v6ert6g8laairn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
