20240403@074601.9885 k86jo21sgpp1894mfoklcoshi9 Query : use flama_phc
20240403@074601.9889 k86jo21sgpp1894mfoklcoshi9 Query : select st.usalote valor from st where st.ref = '324.499.00.01'
20240403@074601.9901 k86jo21sgpp1894mfoklcoshi9 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.499.00.01'
20240403@074601.9912 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074601.9926 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074601.9949 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074601.9963 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074601.9968 k86jo21sgpp1894mfoklcoshi9 Query : select sestamp valor from se where ref ='324.499.00.01' and lote = 'r2100869200a'
20240403@074601.9984 k86jo21sgpp1894mfoklcoshi9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074601.9994 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.8000 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074602.3200 k86jo21sgpp1894mfoklcoshi9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf63600660cfb29f4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660cf61683660cfb29d8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@074602.3090 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.3360 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074602.3430 k86jo21sgpp1894mfoklcoshi9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf63600660cfb29f4','aut660cf61683660cfb29d8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074602.3500 k86jo21sgpp1894mfoklcoshi9 Query : use flama_phc
20240403@074602.3550 k86jo21sgpp1894mfoklcoshi9 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240403@074602.3760 k86jo21sgpp1894mfoklcoshi9 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'
20240403@074602.3890 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.4120 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074602.4390 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.4530 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074602.4580 k86jo21sgpp1894mfoklcoshi9 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240403@074602.4760 k86jo21sgpp1894mfoklcoshi9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074602.4950 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.5100 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074602.5360 k86jo21sgpp1894mfoklcoshi9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf26810660cfb2a0c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut660cf61683660cfb29d8' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@074602.8270 k86jo21sgpp1894mfoklcoshi9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.8440 k86jo21sgpp1894mfoklcoshi9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074602.8500 k86jo21sgpp1894mfoklcoshi9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf26810660cfb2a0c','aut660cf61683660cfb29d8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074602.8540 k86jo21sgpp1894mfoklcoshi9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660cf61683660cfb29d8','2402463','wait',39,'ari17112337378,753000005')
20240403@074602.8770 k86jo21sgpp1894mfoklcoshi9 Query : use flama_phc
20240403@074602.8800 k86jo21sgpp1894mfoklcoshi9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@074602.8970 k86jo21sgpp1894mfoklcoshi9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='910';
20240403@074602.9260 k86jo21sgpp1894mfoklcoshi9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='910';
20240403@074602.9410 k86jo21sgpp1894mfoklcoshi9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='910';
20240403@074602.9550 k86jo21sgpp1894mfoklcoshi9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='910';
20240403@074602.1331 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@074602.1345 t7g3t9p6bq2tdmnh558skkpq71 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@074602.1369 t7g3t9p6bq2tdmnh558skkpq71 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='911';
20240403@074602.1425 t7g3t9p6bq2tdmnh558skkpq71 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='911';
20240403@074602.1446 t7g3t9p6bq2tdmnh558skkpq71 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='911';
20240403@074602.1466 t7g3t9p6bq2tdmnh558skkpq71 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='911';
20240403@074602.1487 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.1491 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@074602.1505 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.1508 t7g3t9p6bq2tdmnh558skkpq71 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4920
20240403@074602.1605 t7g3t9p6bq2tdmnh558skkpq71 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'
20240403@074602.1619 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402464 and bi.ref ='324.4970.00.1' and bi.lordem =1
20240403@074602.1954 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240403@074602.1969 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402464 and bi.ref ='324.4990.00.1' and bi.lordem =2
20240403@074602.2311 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240403@074602.3275 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402464 and bi.ref ='324.727.00.01' and bi.lordem =3
20240403@074602.3852 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.3856 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@074602.3869 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.3873 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 1 valor from td where td.ndoc = 39
20240403@074602.3882 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.3884 t7g3t9p6bq2tdmnh558skkpq71 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@074602.3894 t7g3t9p6bq2tdmnh558skkpq71 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
20240403@074602.3907 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.3910 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 ~inactivo valor from cl where no = '101711' and estab = 0 order by inactivo desc
20240403@074602.4167 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.4171 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@074602.4181 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.4184 t7g3t9p6bq2tdmnh558skkpq71 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@074602.4193 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.4196 t7g3t9p6bq2tdmnh558skkpq71 Query : select szadrsstamp valor from szadrs where szadrsdesc='101711 - media markt benfica -prod.inf.elect., lda'
20240403@074602.4208 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.4210 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from td where ndoc = 39
20240403@074602.4225 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@074602.4236 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074602.4249 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@074602.4265 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074602.4277 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@074602.4302 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074602.4314 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@074602.4323 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074602.4417 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074602.4427 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074602.4440 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@074602.4449 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660cf31367660cfb2a69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@074602.4607 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074602.4623 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@074602.4650 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@074602.4655 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@074602.4659 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@074602.4664 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@074602.4668 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@074602.4673 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@074602.4677 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660cf31367660cfb2a69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@074602.4914 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 fno valor from wsft039data order by fno desc
20240403@074602.4932 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074602.4945 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@074602.4962 t7g3t9p6bq2tdmnh558skkpq71 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 ('aut660cf31367660cfb2a69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',694,101711,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','0816',?,?,?,?)
20240403@074602.5243 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.5247 t7g3t9p6bq2tdmnh558skkpq71 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240403@074602.5257 t7g3t9p6bq2tdmnh558skkpq71 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'
20240403@074602.5269 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.5281 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074602.5302 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.5316 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074602.5320 t7g3t9p6bq2tdmnh558skkpq71 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240403@074602.5329 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074602.5347 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.5360 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074602.5385 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf34156660cfb2a82',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut660cf31367660cfb2a69' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@074602.5733 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.5749 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074602.5753 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf34156660cfb2a82','aut660cf31367660cfb2a69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074602.5757 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.5760 t7g3t9p6bq2tdmnh558skkpq71 Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20240403@074602.5772 t7g3t9p6bq2tdmnh558skkpq71 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.4990.00.1'
20240403@074602.5784 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.5796 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074602.5819 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.5832 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074602.5836 t7g3t9p6bq2tdmnh558skkpq71 Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20240403@074602.5844 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074602.5853 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.5865 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074602.5888 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf75693660cfb2a8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut660cf31367660cfb2a69' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@074602.6148 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.6163 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074602.6167 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf75693660cfb2a8e','aut660cf31367660cfb2a69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074602.6171 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.6174 t7g3t9p6bq2tdmnh558skkpq71 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240403@074602.6185 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240403@074602.6323 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.6335 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074602.6357 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.6369 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074602.6373 t7g3t9p6bq2tdmnh558skkpq71 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2300534200a'
20240403@074602.6384 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074602.6393 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.6405 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074602.6427 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf79485660cfb2a9c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut660cf31367660cfb2a69' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240403@074602.6671 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.6685 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074602.6689 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf79485660cfb2a9c','aut660cf31367660cfb2a69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074602.6695 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.6707 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074602.6730 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.6747 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074602.6751 t7g3t9p6bq2tdmnh558skkpq71 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074602.6761 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074602.6774 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074602.6797 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut660cf13855660cfb2aa5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut660cf31367660cfb2a69' ,0,0 ,2,23.00,40000,?,?,?)
20240403@074602.7033 t7g3t9p6bq2tdmnh558skkpq71 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074602.7048 t7g3t9p6bq2tdmnh558skkpq71 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074602.7052 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf13855660cfb2aa5','aut660cf31367660cfb2a69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074602.7056 t7g3t9p6bq2tdmnh558skkpq71 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660cf31367660cfb2a69','2402464','wait',39,'ari17112337378,753000005')
20240403@074602.7074 t7g3t9p6bq2tdmnh558skkpq71 Query : use flama_phc
20240403@074602.7077 t7g3t9p6bq2tdmnh558skkpq71 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@074602.7087 t7g3t9p6bq2tdmnh558skkpq71 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='911';
20240403@074602.7104 t7g3t9p6bq2tdmnh558skkpq71 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='911';
20240403@074602.7118 t7g3t9p6bq2tdmnh558skkpq71 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='911';
20240403@074602.7131 t7g3t9p6bq2tdmnh558skkpq71 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='911';
20240403@074602.7469 lg39ok1sa00a6sm6art7gsgj65 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@074602.7483 lg39ok1sa00a6sm6art7gsgj65 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@074602.7502 lg39ok1sa00a6sm6art7gsgj65 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='912';
20240403@074602.7546 lg39ok1sa00a6sm6art7gsgj65 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='912';
20240403@074602.7562 lg39ok1sa00a6sm6art7gsgj65 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='912';
20240403@074602.7575 lg39ok1sa00a6sm6art7gsgj65 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='912';
20240403@074602.7587 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.7591 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@074602.7603 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.7606 lg39ok1sa00a6sm6art7gsgj65 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4789
20240403@074602.7693 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20240403@074602.7704 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402465 and bi.ref ='324.4421.00.1' and bi.lordem =1
20240403@074602.8030 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240403@074602.8041 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402465 and bi.ref ='324.727.00.01' and bi.lordem =2
20240403@074602.8362 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240403@074602.8373 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402465 and bi.ref ='324.4960.00.1' and bi.lordem =3
20240403@074602.8704 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8708 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@074602.8725 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8728 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 1 valor from td where td.ndoc = 39
20240403@074602.8746 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8749 lg39ok1sa00a6sm6art7gsgj65 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@074602.8760 lg39ok1sa00a6sm6art7gsgj65 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
20240403@074602.8776 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8779 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 ~inactivo valor from cl where no = '101987' and estab = 0 order by inactivo desc
20240403@074602.8876 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8879 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@074602.8890 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8893 lg39ok1sa00a6sm6art7gsgj65 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@074602.8905 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8908 lg39ok1sa00a6sm6art7gsgj65 Query : select szadrsstamp valor from szadrs where szadrsdesc='101987 - media markt nascente, lda.'
20240403@074602.8922 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074602.8925 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from td where ndoc = 39
20240403@074602.8936 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@074602.8948 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074602.8961 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@074602.8977 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074602.8990 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@074602.9016 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074602.9029 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@074602.9038 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074602.9132 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074602.9141 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074602.9154 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@074602.9164 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660cf57143660cfb2adc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@074603.1000 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074603.1160 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@074603.5250 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@074603.5300 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@074603.5340 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@074603.5390 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@074603.5430 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@074603.5480 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@074603.5550 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660cf57143660cfb2adc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@074603.7830 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 fno valor from wsft039data order by fno desc
20240403@074603.8000 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074603.8120 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@074603.8330 lg39ok1sa00a6sm6art7gsgj65 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 ('aut660cf57143660cfb2adc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',695,101987,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','0816',?,?,?,?)
20240403@074603.1112 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074603.1116 lg39ok1sa00a6sm6art7gsgj65 Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240403@074603.1127 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4421.00.1'
20240403@074603.1139 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.1153 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074603.1182 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.1196 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074603.1200 lg39ok1sa00a6sm6art7gsgj65 Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2200226300a'
20240403@074603.1210 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074603.1220 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.1233 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074603.1257 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf29987660cfb2b1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut660cf57143660cfb2adc' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@074603.1505 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.1520 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074603.1525 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf29987660cfb2b1d','aut660cf57143660cfb2adc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074603.1529 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074603.1532 lg39ok1sa00a6sm6art7gsgj65 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240403@074603.1544 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240403@074603.1554 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.1567 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074603.1589 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.1601 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074603.1605 lg39ok1sa00a6sm6art7gsgj65 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2300534200a'
20240403@074603.1617 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074603.1626 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.1638 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074603.1659 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf39473660cfb2b27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut660cf57143660cfb2adc' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@074603.1910 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.1926 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074603.1930 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf39473660cfb2b27','aut660cf57143660cfb2adc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074603.1935 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.1949 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074603.1974 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.1987 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074603.1991 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074603.2001 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.2014 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074603.2037 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut660cf69667660cfb2b30',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut660cf57143660cfb2adc' ,0,0 ,2,23.00,30000,?,?,?)
20240403@074603.2276 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.2290 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074603.2295 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf69667660cfb2b30','aut660cf57143660cfb2adc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074603.2299 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074603.2302 lg39ok1sa00a6sm6art7gsgj65 Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240403@074603.2312 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20240403@074603.2324 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.2337 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074603.2360 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.2374 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074603.2378 lg39ok1sa00a6sm6art7gsgj65 Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240403@074603.2387 lg39ok1sa00a6sm6art7gsgj65 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074603.2396 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.2408 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074603.2433 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf01801660cfb2b3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut660cf57143660cfb2adc' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240403@074603.2691 lg39ok1sa00a6sm6art7gsgj65 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.2705 lg39ok1sa00a6sm6art7gsgj65 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074603.2710 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf01801660cfb2b3a','aut660cf57143660cfb2adc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074603.2714 lg39ok1sa00a6sm6art7gsgj65 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660cf57143660cfb2adc','2402465','wait',39,'ari17112337378,753000005')
20240403@074603.2729 lg39ok1sa00a6sm6art7gsgj65 Query : use flama_phc
20240403@074603.2732 lg39ok1sa00a6sm6art7gsgj65 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@074603.2743 lg39ok1sa00a6sm6art7gsgj65 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='912';
20240403@074603.2760 lg39ok1sa00a6sm6art7gsgj65 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='912';
20240403@074603.2774 lg39ok1sa00a6sm6art7gsgj65 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='912';
20240403@074603.2804 lg39ok1sa00a6sm6art7gsgj65 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='912';
20240403@074603.3173 de2e5j80f04clf7n2jvm2kpgpn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@074603.3185 de2e5j80f04clf7n2jvm2kpgpn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@074603.3210 de2e5j80f04clf7n2jvm2kpgpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='913';
20240403@074603.3251 de2e5j80f04clf7n2jvm2kpgpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='913';
20240403@074603.3266 de2e5j80f04clf7n2jvm2kpgpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='913';
20240403@074603.3279 de2e5j80f04clf7n2jvm2kpgpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='913';
20240403@074603.3291 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.3295 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@074603.3307 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.3310 de2e5j80f04clf7n2jvm2kpgpn Query : select no, estab,szadrsdesc from szadrs where u_coddest=4784
20240403@074603.3390 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.499.00.01'
20240403@074603.3400 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402466 and bi.ref ='324.499.00.01' and bi.lordem =1
20240403@074603.3740 de2e5j80f04clf7n2jvm2kpgpn 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'
20240403@074603.3751 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402466 and bi.ref ='324.4970.00.1' and bi.lordem =2
20240403@074603.4079 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4743.00.1'
20240403@074603.4258 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402466 and bi.ref ='324.4743.00.1' and bi.lordem =3
20240403@074603.4620 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1470.00.1'
20240403@074603.4632 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402466 and bi.ref ='324.1470.00.1' and bi.lordem =4
20240403@074603.4960 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1470.00.1'
20240403@074603.4971 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402466 and bi.ref ='324.1470.00.1' and bi.lordem =4
20240403@074603.4977 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20240403@074603.4986 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402466 and bi.ref ='324.4421.00.1' and bi.lordem =5
20240403@074603.5412 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240403@074603.6443 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402466 and bi.ref ='324.4960.00.1' and bi.lordem =6
20240403@074603.6791 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.6795 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@074603.6807 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.6810 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 1 valor from td where td.ndoc = 39
20240403@074603.6819 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.6822 de2e5j80f04clf7n2jvm2kpgpn Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@074603.6833 de2e5j80f04clf7n2jvm2kpgpn 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
20240403@074603.6847 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.6850 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 ~inactivo valor from cl where no = '102410' and estab = 0 order by inactivo desc
20240403@074603.7203 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.7206 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@074603.7217 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.7220 de2e5j80f04clf7n2jvm2kpgpn Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@074603.7230 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.7233 de2e5j80f04clf7n2jvm2kpgpn Query : select szadrsstamp valor from szadrs where szadrsdesc='102410 - media markt matosinhos - prod inform e el'
20240403@074603.7246 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.7249 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from td where ndoc = 39
20240403@074603.7258 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@074603.7269 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074603.7282 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@074603.7297 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074603.7309 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@074603.8217 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074603.8233 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@074603.8243 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074603.8339 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074603.8349 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074603.8361 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@074603.8371 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@074603.8529 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074603.8544 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@074603.8570 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@074603.8575 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@074603.8586 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@074603.8590 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@074603.8594 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@074603.8598 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@074603.8602 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660cf15863660cfb2bc9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@074603.8847 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 fno valor from wsft039data order by fno desc
20240403@074603.8865 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074603.8880 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@074603.8897 de2e5j80f04clf7n2jvm2kpgpn 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 ('aut660cf15863660cfb2bc9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',696,102410,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','0816',?,?,?,?)
20240403@074603.9173 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.9177 de2e5j80f04clf7n2jvm2kpgpn Query : select st.usalote valor from st where st.ref = '324.499.00.01'
20240403@074603.9189 de2e5j80f04clf7n2jvm2kpgpn 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.499.00.01'
20240403@074603.9200 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.9216 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074603.9239 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.9251 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074603.9256 de2e5j80f04clf7n2jvm2kpgpn Query : select sestamp valor from se where ref ='324.499.00.01' and lote = 'r2100869200a'
20240403@074603.9265 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074603.9274 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.9286 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074603.9308 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf15315660cfb2be2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660cf15863660cfb2bc9' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@074603.9715 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.9730 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074603.9735 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf15315660cfb2be2','aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074603.9740 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074603.9744 de2e5j80f04clf7n2jvm2kpgpn Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240403@074603.9754 de2e5j80f04clf7n2jvm2kpgpn 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'
20240403@074603.9765 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.9778 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074603.9801 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074603.9814 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074603.9818 de2e5j80f04clf7n2jvm2kpgpn Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240403@074603.9830 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074603.9839 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074603.9884 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074603.9990 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf08342660cfb2bf0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut660cf15863660cfb2bc9' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@074604.2520 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.2670 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074604.2720 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf08342660cfb2bf0','aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074604.2760 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074604.2790 de2e5j80f04clf7n2jvm2kpgpn Query : select st.usalote valor from st where st.ref = '324.4743.00.1'
20240403@074604.2900 de2e5j80f04clf7n2jvm2kpgpn 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.4743.00.1'
20240403@074604.4330 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.4470 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074604.4870 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.5000 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074604.5050 de2e5j80f04clf7n2jvm2kpgpn Query : select sestamp valor from se where ref ='324.4743.00.1' and lote = 'r2200085100a'
20240403@074604.5280 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074604.5370 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.5500 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074604.5730 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf21814660cfb2c0d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut660cf15863660cfb2bc9' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240403@074604.8210 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.8360 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074604.8400 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf21814660cfb2c0d','aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074604.8440 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074604.8470 de2e5j80f04clf7n2jvm2kpgpn Query : select st.usalote valor from st where st.ref = '324.1470.00.1'
20240403@074604.8570 de2e5j80f04clf7n2jvm2kpgpn 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.1470.00.1'
20240403@074604.8690 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.8820 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074604.9040 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.9170 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074604.9210 de2e5j80f04clf7n2jvm2kpgpn Query : select sestamp valor from se where ref ='324.1470.00.1' and lote = 'r2100312200a'
20240403@074604.9300 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074604.9400 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.9520 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074604.1054 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf31238660cfb2c16',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660cf15863660cfb2bc9' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240403@074604.1507 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.1523 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074604.1534 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf31238660cfb2c16','aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074604.1539 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074604.1542 de2e5j80f04clf7n2jvm2kpgpn Query : select st.usalote valor from st where st.ref = '324.1470.00.1'
20240403@074604.1552 de2e5j80f04clf7n2jvm2kpgpn 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.1470.00.1'
20240403@074604.1563 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.1576 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074604.1598 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.1613 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074604.1617 de2e5j80f04clf7n2jvm2kpgpn Query : select sestamp valor from se where ref ='324.1470.00.1' and lote = 'r2100312200a'
20240403@074604.1627 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074604.1636 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.1649 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074604.1672 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf35456660cfb2c27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut660cf15863660cfb2bc9' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240403@074604.2020 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.2925 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074604.3054 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf35456660cfb2c27','aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074604.3139 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074604.3505 de2e5j80f04clf7n2jvm2kpgpn Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240403@074604.3960 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4421.00.1'
20240403@074604.3972 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.3984 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074604.4005 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.4018 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074604.4022 de2e5j80f04clf7n2jvm2kpgpn Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2200226300a'
20240403@074604.4030 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074604.4039 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.4053 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074604.4076 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf74281660cfb2c62',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut660cf15863660cfb2bc9' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240403@074604.4373 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.4388 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074604.4392 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf74281660cfb2c62','aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074604.4396 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074604.4400 de2e5j80f04clf7n2jvm2kpgpn Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240403@074604.4410 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20240403@074604.4421 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.4433 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074604.4456 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.4469 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074604.4474 de2e5j80f04clf7n2jvm2kpgpn Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240403@074604.4483 de2e5j80f04clf7n2jvm2kpgpn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074604.4492 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074604.4505 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074604.4528 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf42548660cfb2c6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut660cf15863660cfb2bc9' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240403@074604.4786 de2e5j80f04clf7n2jvm2kpgpn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074604.4801 de2e5j80f04clf7n2jvm2kpgpn Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074604.4806 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf42548660cfb2c6d','aut660cf15863660cfb2bc9' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074604.4810 de2e5j80f04clf7n2jvm2kpgpn Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660cf15863660cfb2bc9','2402466','wait',39,'ari17112337378,753000005')
20240403@074604.4828 de2e5j80f04clf7n2jvm2kpgpn Query : use flama_phc
20240403@074604.4831 de2e5j80f04clf7n2jvm2kpgpn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@074604.4842 de2e5j80f04clf7n2jvm2kpgpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='913';
20240403@074604.4859 de2e5j80f04clf7n2jvm2kpgpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='913';
20240403@074604.4873 de2e5j80f04clf7n2jvm2kpgpn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='913';
20240403@074604.4888 de2e5j80f04clf7n2jvm2kpgpn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='913';
20240403@074604.5303 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@074604.5322 onl2tav0mdjvgd2a2f6nn4bj9c Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@074604.5341 onl2tav0mdjvgd2a2f6nn4bj9c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='914';
20240403@074604.5390 onl2tav0mdjvgd2a2f6nn4bj9c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='914';
20240403@074604.5413 onl2tav0mdjvgd2a2f6nn4bj9c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='914';
20240403@074604.5428 onl2tav0mdjvgd2a2f6nn4bj9c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='914';
20240403@074604.5455 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.5653 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@074604.5670 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.5673 onl2tav0mdjvgd2a2f6nn4bj9c Query : select no, estab,szadrsdesc from szadrs where u_coddest=4786
20240403@074604.5753 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.499.00.01'
20240403@074604.5764 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402467 and bi.ref ='324.499.00.01' and bi.lordem =1
20240403@074604.6102 onl2tav0mdjvgd2a2f6nn4bj9c 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'
20240403@074604.6114 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402467 and bi.ref ='304.4320.00.1' and bi.lordem =2
20240403@074604.6437 onl2tav0mdjvgd2a2f6nn4bj9c 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'
20240403@074604.6451 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402467 and bi.ref ='324.4970.00.1' and bi.lordem =3
20240403@074604.6776 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4860.00.1'
20240403@074604.6922 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402467 and bi.ref ='304.4860.00.1' and bi.lordem =4
20240403@074604.7242 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240403@074604.7253 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402467 and bi.ref ='324.4990.00.1' and bi.lordem =5
20240403@074604.7698 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240403@074604.7865 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402467 and bi.ref ='324.4960.00.1' and bi.lordem =6
20240403@074604.8185 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20240403@074604.8330 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402467 and bi.ref ='324.691.00.01' and bi.lordem =7
20240403@074604.8685 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8689 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@074604.8702 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8704 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 1 valor from td where td.ndoc = 39
20240403@074604.8714 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8717 onl2tav0mdjvgd2a2f6nn4bj9c Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@074604.8727 onl2tav0mdjvgd2a2f6nn4bj9c 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
20240403@074604.8741 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8744 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 ~inactivo valor from cl where no = '101847' and estab = 0 order by inactivo desc
20240403@074604.8846 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8849 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@074604.8859 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8862 onl2tav0mdjvgd2a2f6nn4bj9c Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@074604.8872 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8875 onl2tav0mdjvgd2a2f6nn4bj9c Query : select szadrsstamp valor from szadrs where szadrsdesc='101847 - media markt aveiro-prod.inf.e elect.,lda'
20240403@074604.8888 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074604.8890 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from td where ndoc = 39
20240403@074604.8900 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@074604.8911 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074604.8925 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@074604.8942 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074604.8954 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@074604.8979 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074604.8992 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@074604.9002 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074604.9098 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074604.9108 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074604.9126 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@074604.9136 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@074604.9308 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074604.9324 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@074604.9353 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@074604.9358 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@074604.9364 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@074604.9369 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@074604.9375 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@074604.9380 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@074604.9386 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660cf91313660cfb2cdb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@074604.9897 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 fno valor from wsft039data order by fno desc
20240403@074604.9975 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074604.9989 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@074605.7670 onl2tav0mdjvgd2a2f6nn4bj9c 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 ('aut660cf91313660cfb2cdb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',697,101847,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','0816',?,?,?,?)
20240403@074605.1186 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.1190 onl2tav0mdjvgd2a2f6nn4bj9c Query : select st.usalote valor from st where st.ref = '324.499.00.01'
20240403@074605.1201 onl2tav0mdjvgd2a2f6nn4bj9c 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.499.00.01'
20240403@074605.1211 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.1348 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.1375 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.1389 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.1394 onl2tav0mdjvgd2a2f6nn4bj9c Query : select sestamp valor from se where ref ='324.499.00.01' and lote = 'r2100869200a'
20240403@074605.1403 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.1412 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.1426 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.1450 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf64866660cfb2d22',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@074605.1699 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.1714 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.1719 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf64866660cfb2d22','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.1723 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.1726 onl2tav0mdjvgd2a2f6nn4bj9c Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240403@074605.1735 onl2tav0mdjvgd2a2f6nn4bj9c 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'
20240403@074605.1746 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.1759 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.1785 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.1798 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.1803 onl2tav0mdjvgd2a2f6nn4bj9c Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '240350'
20240403@074605.1817 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.1842 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.1856 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.1878 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf43819660cfb2d2c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@074605.2135 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.2150 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.2154 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf43819660cfb2d2c','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.2159 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.2162 onl2tav0mdjvgd2a2f6nn4bj9c Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240403@074605.2172 onl2tav0mdjvgd2a2f6nn4bj9c 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'
20240403@074605.2184 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.2201 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.2226 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.2239 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.2243 onl2tav0mdjvgd2a2f6nn4bj9c Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2301074200a'
20240403@074605.2252 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.2262 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.2275 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.2298 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf71808660cfb2d37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240403@074605.2557 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.2572 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.2576 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf71808660cfb2d37','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.2580 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.2583 onl2tav0mdjvgd2a2f6nn4bj9c Query : select st.usalote valor from st where st.ref = '304.4860.00.1'
20240403@074605.2594 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.4860.00.1'
20240403@074605.2745 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.2759 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.2823 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.3037 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.3075 onl2tav0mdjvgd2a2f6nn4bj9c Query : select sestamp valor from se where ref ='304.4860.00.1' and lote = '20210802'
20240403@074605.3104 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.3115 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.3136 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.3160 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf04046660cfb2d4c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240403@074605.3430 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.3444 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.3448 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf04046660cfb2d4c','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.3453 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.3456 onl2tav0mdjvgd2a2f6nn4bj9c Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20240403@074605.3468 onl2tav0mdjvgd2a2f6nn4bj9c 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.4990.00.1'
20240403@074605.3479 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.3491 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.3513 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.3525 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.3529 onl2tav0mdjvgd2a2f6nn4bj9c Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20240403@074605.3538 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.3552 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.3564 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.3587 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf07876660cfb2d56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240403@074605.3838 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.3852 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.3857 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf07876660cfb2d56','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.3864 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.3867 onl2tav0mdjvgd2a2f6nn4bj9c Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240403@074605.3877 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20240403@074605.3888 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.3900 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.3923 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.3935 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.3939 onl2tav0mdjvgd2a2f6nn4bj9c Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240403@074605.3948 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.3957 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.3970 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.3992 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf12050660cfb2d60',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240403@074605.4281 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.4296 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.4301 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf12050660cfb2d60','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.4305 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.4308 onl2tav0mdjvgd2a2f6nn4bj9c Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240403@074605.4320 onl2tav0mdjvgd2a2f6nn4bj9c 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.691.00.01'
20240403@074605.4490 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.4506 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.4533 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.4546 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.4550 onl2tav0mdjvgd2a2f6nn4bj9c Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240403@074605.4560 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.4574 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.4591 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.4621 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf65598660cfb2d6f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240403@074605.4874 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.4891 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.4896 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf65598660cfb2d6f','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.4901 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.4915 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.4942 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.4956 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.4960 onl2tav0mdjvgd2a2f6nn4bj9c Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.4972 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.4986 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.5011 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut660cf15643660cfb2d79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut660cf91313660cfb2cdb' ,0,0 ,2,23.00,80000,?,?,?)
20240403@074605.5264 onl2tav0mdjvgd2a2f6nn4bj9c Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.5301 onl2tav0mdjvgd2a2f6nn4bj9c Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.5306 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf15643660cfb2d79','aut660cf91313660cfb2cdb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.5311 onl2tav0mdjvgd2a2f6nn4bj9c Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut660cf91313660cfb2cdb','2402467','wait',39,'ari17112337378,753000005')
20240403@074605.5328 onl2tav0mdjvgd2a2f6nn4bj9c Query : use flama_phc
20240403@074605.5331 onl2tav0mdjvgd2a2f6nn4bj9c Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240403@074605.5342 onl2tav0mdjvgd2a2f6nn4bj9c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='914';
20240403@074605.5359 onl2tav0mdjvgd2a2f6nn4bj9c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='914';
20240403@074605.5375 onl2tav0mdjvgd2a2f6nn4bj9c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='914';
20240403@074605.5390 onl2tav0mdjvgd2a2f6nn4bj9c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='914';
20240403@074605.5880 5k36suctal7nfql63v460n6lg7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240403@074605.5894 5k36suctal7nfql63v460n6lg7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240403@074605.5915 5k36suctal7nfql63v460n6lg7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='915';
20240403@074605.6107 5k36suctal7nfql63v460n6lg7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='915';
20240403@074605.6125 5k36suctal7nfql63v460n6lg7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='915';
20240403@074605.6142 5k36suctal7nfql63v460n6lg7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='915';
20240403@074605.6155 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.6159 5k36suctal7nfql63v460n6lg7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240403@074605.6178 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.6181 5k36suctal7nfql63v460n6lg7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240403@074605.6271 5k36suctal7nfql63v460n6lg7 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'
20240403@074605.6580 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.958.00.01' and bi.lordem =1
20240403@074605.6914 5k36suctal7nfql63v460n6lg7 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'
20240403@074605.6927 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.958.00.01' and bi.lordem =1
20240403@074605.6933 5k36suctal7nfql63v460n6lg7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240403@074605.7139 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.988.00.01' and bi.lordem =2
20240403@074605.7466 5k36suctal7nfql63v460n6lg7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240403@074605.7506 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.988.00.01' and bi.lordem =2
20240403@074605.7711 5k36suctal7nfql63v460n6lg7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240403@074605.7724 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.988.00.01' and bi.lordem =2
20240403@074605.7730 5k36suctal7nfql63v460n6lg7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240403@074605.7741 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.988.00.01' and bi.lordem =2
20240403@074605.7747 5k36suctal7nfql63v460n6lg7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240403@074605.7757 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.988.00.01' and bi.lordem =2
20240403@074605.7767 5k36suctal7nfql63v460n6lg7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240403@074605.7779 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.988.00.01' and bi.lordem =2
20240403@074605.7784 5k36suctal7nfql63v460n6lg7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.988.00.01'
20240403@074605.7795 5k36suctal7nfql63v460n6lg7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2024 and bo.obrano = 2402468 and bi.ref ='324.988.00.01' and bi.lordem =2
20240403@074605.7800 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.7804 5k36suctal7nfql63v460n6lg7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240403@074605.7816 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.7820 5k36suctal7nfql63v460n6lg7 Query : select top 1 1 valor from td where td.ndoc = 39
20240403@074605.7830 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.7834 5k36suctal7nfql63v460n6lg7 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240403@074605.7846 5k36suctal7nfql63v460n6lg7 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
20240403@074605.7861 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.7867 5k36suctal7nfql63v460n6lg7 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240403@074605.7980 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.7984 5k36suctal7nfql63v460n6lg7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240403@074605.7995 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.7999 5k36suctal7nfql63v460n6lg7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240403@074605.8010 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.8014 5k36suctal7nfql63v460n6lg7 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240403@074605.8029 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.8032 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from td where ndoc = 39
20240403@074605.8043 5k36suctal7nfql63v460n6lg7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240403@074605.8054 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074605.8068 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240403@074605.8085 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074605.8099 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240403@074605.8129 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074605.8144 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240403@074605.8155 5k36suctal7nfql63v460n6lg7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074605.8251 5k36suctal7nfql63v460n6lg7 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240403@074605.8262 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240403@074605.8276 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240403@074605.8288 5k36suctal7nfql63v460n6lg7 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut660cf94539660cfb2dc7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240403@074605.8451 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240403@074605.8473 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240403@074605.8504 5k36suctal7nfql63v460n6lg7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240403@074605.8509 5k36suctal7nfql63v460n6lg7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240403@074605.8515 5k36suctal7nfql63v460n6lg7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240403@074605.8520 5k36suctal7nfql63v460n6lg7 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240403@074605.8525 5k36suctal7nfql63v460n6lg7 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240403@074605.8530 5k36suctal7nfql63v460n6lg7 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240403@074605.8535 5k36suctal7nfql63v460n6lg7 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut660cf94539660cfb2dc7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240403@074605.8779 5k36suctal7nfql63v460n6lg7 Query : select top 1 fno valor from wsft039data order by fno desc
20240403@074605.8797 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240403@074605.8812 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240403@074605.8831 5k36suctal7nfql63v460n6lg7 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 ('aut660cf94539660cfb2dc7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',698,100810,0,'2024-04-03',39,'euro',0,0,2024 ,'20240403','0816',?,?,?,?)
20240403@074605.9105 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.9109 5k36suctal7nfql63v460n6lg7 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240403@074605.9125 5k36suctal7nfql63v460n6lg7 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'
20240403@074605.9282 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.9295 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.9319 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.9331 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.9336 5k36suctal7nfql63v460n6lg7 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2301081100a'
20240403@074605.9346 5k36suctal7nfql63v460n6lg7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.9356 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.9368 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.9392 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf49990660cfb2de4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28.000 ,'aut660cf94539660cfb2dc7' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240403@074605.9651 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.9666 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074605.9671 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf49990660cfb2de4','aut660cf94539660cfb2dc7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074605.9675 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074605.9678 5k36suctal7nfql63v460n6lg7 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240403@074605.9688 5k36suctal7nfql63v460n6lg7 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'
20240403@074605.9699 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.9711 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074605.9735 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074605.9748 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074605.9752 5k36suctal7nfql63v460n6lg7 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2301081100a'
20240403@074605.9762 5k36suctal7nfql63v460n6lg7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074605.9772 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074605.9784 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074605.9806 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf16980660cfb2dee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut660cf94539660cfb2dc7' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240403@074606.1890 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074606.1187 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074606.1249 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf16980660cfb2dee','aut660cf94539660cfb2dc7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074606.1255 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074606.1259 5k36suctal7nfql63v460n6lg7 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240403@074606.1272 5k36suctal7nfql63v460n6lg7 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.988.00.01'
20240403@074606.1427 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074606.1440 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074606.1467 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074606.1482 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074606.1487 5k36suctal7nfql63v460n6lg7 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2301090200a'
20240403@074606.1499 5k36suctal7nfql63v460n6lg7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074606.1510 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074606.1525 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074606.1554 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf23138660cfb2e24',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut660cf94539660cfb2dc7' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240403@074606.1833 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074606.1849 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074606.1854 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf23138660cfb2e24','aut660cf94539660cfb2dc7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074606.1859 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074606.1870 5k36suctal7nfql63v460n6lg7 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240403@074606.1893 5k36suctal7nfql63v460n6lg7 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.988.00.01'
20240403@074606.1906 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074606.1921 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074606.1956 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074606.1970 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074606.1992 5k36suctal7nfql63v460n6lg7 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2301090200a'
20240403@074606.2004 5k36suctal7nfql63v460n6lg7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074606.2016 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074606.2031 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074606.2080 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf70585660cfb2e31',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28.000 ,'aut660cf94539660cfb2dc7' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240403@074606.2352 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074606.2368 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240403@074606.2373 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut660cf70585660cfb2e31','aut660cf94539660cfb2dc7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240403@074606.2378 5k36suctal7nfql63v460n6lg7 Query : use flama_phc
20240403@074606.2382 5k36suctal7nfql63v460n6lg7 Query : select st.usalote valor from st where st.ref = '324.988.00.01'
20240403@074606.2394 5k36suctal7nfql63v460n6lg7 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.988.00.01'
20240403@074606.2438 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074606.2453 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240403@074606.2490 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240403@074606.2505 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240403@074606.2510 5k36suctal7nfql63v460n6lg7 Query : select sestamp valor from se where ref ='324.988.00.01' and lote = 'r2301090200a'
20240403@074606.2519 5k36suctal7nfql63v460n6lg7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240403@074606.2545 5k36suctal7nfql63v460n6lg7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240403@074606.2558 5k36suctal7nfql63v460n6lg7 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240403@074606.2638 5k36suctal7nfql63v460n6lg7 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut660cf15043660cfb2e3e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut660cf94539660cfb2dc7' ,0,0 ,2,23.00,50000,?,?,?,?,?)
