20240507@171356.1176 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403234 and bi.ref ='324.1461.00.1' and bi.lordem =3
20240507@171356.1974 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1256.00.1'
20240507@171356.2686 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403234 and bi.ref ='324.1256.00.1' and bi.lordem =4
20240507@171356.3007 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4902.00.1'
20240507@171356.3160 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403234 and bi.ref ='324.4902.00.1' and bi.lordem =5
20240507@171356.3458 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20240507@171356.3603 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403234 and bi.ref ='324.642.00.01' and bi.lordem =6
20240507@171356.3894 oc94v70o43jdq4gnev6qglcfqf 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'
20240507@171356.4028 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403234 and bi.ref ='324.4421.00.1' and bi.lordem =7
20240507@171356.4319 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240507@171356.4459 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403234 and bi.ref ='324.5396.00.1' and bi.lordem =8
20240507@171356.4756 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20240507@171356.4906 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403234 and bi.ref ='324.945.00.01' and bi.lordem =9
20240507@171356.5207 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5210 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240507@171356.5223 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5226 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 1 valor from td where td.ndoc = 39
20240507@171356.5236 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5239 oc94v70o43jdq4gnev6qglcfqf Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240507@171356.5252 oc94v70o43jdq4gnev6qglcfqf 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
20240507@171356.5265 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5268 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20240507@171356.5367 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5370 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240507@171356.5380 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5383 oc94v70o43jdq4gnev6qglcfqf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240507@171356.5393 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5396 oc94v70o43jdq4gnev6qglcfqf Query : select szadrsstamp valor from szadrs where szadrsdesc='eldisser - mesur'
20240507@171356.5410 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.5413 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from td where ndoc = 39
20240507@171356.5423 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240507@171356.5434 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240507@171356.5447 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240507@171356.5466 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240507@171356.5478 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240507@171356.5504 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240507@171356.5518 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240507@171356.5527 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240507@171356.5604 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240507@171356.5614 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240507@171356.5627 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240507@171356.5636 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240507@171356.5771 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240507@171356.5784 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240507@171356.5812 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240507@171356.5818 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240507@171356.5824 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240507@171356.5829 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240507@171356.5834 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240507@171356.5839 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240507@171356.5843 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut663a533734663a534486',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240507@171356.6057 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 fno valor from wsft039data order by fno desc
20240507@171356.6072 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240507@171356.6085 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240507@171356.6103 oc94v70o43jdq4gnev6qglcfqf 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 ('aut663a533734663a534486',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1229,200500,0,'2024-05-07',39,'euro',0,0,2024 ,'20240507','1743',?,?,?,?)
20240507@171356.6325 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.6366 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.1470.00.1'
20240507@171356.6467 oc94v70o43jdq4gnev6qglcfqf 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'
20240507@171356.6619 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.6633 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171356.6656 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.6669 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171356.6673 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.1470.00.1' and lote = 'r2100312200a'
20240507@171356.6690 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171356.6699 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.6711 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171356.6736 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a538158663a5344a3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240507@171356.6933 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.6947 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171356.6952 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a538158663a5344a3','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171356.6957 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.6960 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.1417.00.1'
20240507@171356.6971 oc94v70o43jdq4gnev6qglcfqf 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.1417.00.1'
20240507@171356.7110 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.7122 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171356.7143 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.7154 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171356.7159 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.1417.00.1' and lote = 'r2101088200a'
20240507@171356.7176 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171356.7185 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.7196 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171356.7217 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a529883663a5344af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240507@171356.7439 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.7452 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171356.7456 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a529883663a5344af','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171356.7461 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.7473 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171356.7493 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.7504 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171356.7508 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171356.7517 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.7528 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171356.7548 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a576036663a5344b7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a533734663a534486' ,0,0 ,2,23.00,30000,?,?,?)
20240507@171356.7742 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.7754 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171356.7758 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a576036663a5344b7','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171356.7763 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.7765 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20240507@171356.7775 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1461.00.1'
20240507@171356.7785 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.7797 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171356.7818 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.7829 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171356.7833 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100463200a'
20240507@171356.7842 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171356.7851 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.7863 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171356.7885 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a552738663a5344bf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240507@171356.8080 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.8092 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171356.8096 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a552738663a5344bf','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171356.8100 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.8103 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.1256.00.1'
20240507@171356.8113 oc94v70o43jdq4gnev6qglcfqf 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.1256.00.1'
20240507@171356.8255 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.8267 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171356.8288 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.8301 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171356.8305 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.1256.00.1' and lote = 'r210135200a'
20240507@171356.8322 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171356.8331 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.8342 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171356.8363 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a566185663a5344cb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240507@171356.8562 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.8576 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171356.8580 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a566185663a5344cb','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171356.8584 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.8597 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171356.8619 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.8630 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171356.8634 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171356.8642 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.8653 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171356.8673 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a555806663a5344d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a533734663a534486' ,0,0 ,2,23.00,70000,?,?,?)
20240507@171356.8856 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.8868 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171356.8872 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a555806663a5344d3','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171356.8876 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171356.8879 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.4902.00.1'
20240507@171356.8889 oc94v70o43jdq4gnev6qglcfqf 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.4902.00.1'
20240507@171356.9032 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.9044 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171356.9065 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171356.9077 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171356.9081 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.4902.00.1' and lote = 'r2300206100a'
20240507@171356.9100 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171356.9109 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171356.9120 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171356.9142 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a563385663a5344de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20240507@171356.9520 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.3980 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171357.4030 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a563385663a5344de','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171357.4090 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.4220 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171357.4430 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.4540 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171357.4580 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171357.4690 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.4800 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171357.5000 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a558285663a53450b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a533734663a534486' ,0,0 ,2,23.00,100000,?,?,?)
20240507@171357.7090 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.7220 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171357.7270 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a558285663a53450b','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171357.7310 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171357.7340 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240507@171357.7460 oc94v70o43jdq4gnev6qglcfqf 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.642.00.01'
20240507@171357.8950 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.9090 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171357.9330 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.9460 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171357.9500 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240507@171357.9690 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171357.9780 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.9900 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171357.1136 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a559438663a534517',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20240507@171357.1348 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.1363 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171357.1367 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a559438663a534517','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171357.1371 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171357.1374 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240507@171357.1386 oc94v70o43jdq4gnev6qglcfqf 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'
20240507@171357.1535 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.1548 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171357.1570 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.1582 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171357.1586 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2200226300a'
20240507@171357.1608 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171357.1617 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.1629 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171357.1652 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a505458663a534527',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240507@171357.1855 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.1869 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171357.1874 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a505458663a534527','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171357.1878 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171357.1882 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240507@171357.1894 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5396.00.1'
20240507@171357.2035 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.2047 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171357.2069 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.2081 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171357.2085 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240507@171357.2103 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171357.2112 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.2123 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171357.2143 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a547813663a534533',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20240507@171357.2341 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.2357 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171357.2363 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a547813663a534533','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171357.2370 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.2383 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171357.2407 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.2420 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171357.2424 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171357.2434 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.2447 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171357.2471 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a542645663a53453b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a533734663a534486' ,0,0 ,2,23.00,150000,?,?,?)
20240507@171357.2679 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.2693 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171357.2698 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a542645663a53453b','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171357.2702 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171357.2706 oc94v70o43jdq4gnev6qglcfqf Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240507@171357.2717 oc94v70o43jdq4gnev6qglcfqf 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.945.00.01'
20240507@171357.2863 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.2877 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171357.2901 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.2914 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171357.2919 oc94v70o43jdq4gnev6qglcfqf Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240507@171357.2931 oc94v70o43jdq4gnev6qglcfqf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171357.2941 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171357.2954 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171357.2980 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a511094663a534547',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a533734663a534486' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20240507@171357.3189 oc94v70o43jdq4gnev6qglcfqf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171357.3204 oc94v70o43jdq4gnev6qglcfqf Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171357.3209 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a511094663a534547','aut663a533734663a534486' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171357.3213 oc94v70o43jdq4gnev6qglcfqf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut663a533734663a534486','2403234','wait',39,'ari17112337378,753000005')
20240507@171357.3233 oc94v70o43jdq4gnev6qglcfqf Query : use flama_phc
20240507@171357.3236 oc94v70o43jdq4gnev6qglcfqf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240507@171357.3252 oc94v70o43jdq4gnev6qglcfqf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1543';
20240507@171357.3267 oc94v70o43jdq4gnev6qglcfqf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1543';
20240507@171357.3289 oc94v70o43jdq4gnev6qglcfqf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1543';
20240507@171357.3301 oc94v70o43jdq4gnev6qglcfqf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1543';
20240507@171357.3667 dq8i71g4udqlsshf86igc952t8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240507@171357.3681 dq8i71g4udqlsshf86igc952t8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240507@171357.3700 dq8i71g4udqlsshf86igc952t8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1544';
20240507@171357.3740 dq8i71g4udqlsshf86igc952t8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1544';
20240507@171357.3758 dq8i71g4udqlsshf86igc952t8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1544';
20240507@171357.3771 dq8i71g4udqlsshf86igc952t8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1544';
20240507@171357.3788 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171357.3791 dq8i71g4udqlsshf86igc952t8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240507@171357.3805 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171357.3808 dq8i71g4udqlsshf86igc952t8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=5187
20240507@171357.3876 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20240507@171357.4033 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.1608.00.1' and bi.lordem =1
20240507@171357.4348 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1417.00.1'
20240507@171357.4359 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.1417.00.1' and bi.lordem =2
20240507@171357.4654 dq8i71g4udqlsshf86igc952t8 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'
20240507@171357.4666 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.1470.00.1' and bi.lordem =3
20240507@171357.4981 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1461.00.1'
20240507@171357.4992 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.1461.00.1' and bi.lordem =4
20240507@171357.6286 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1256.00.1'
20240507@171357.6301 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.1256.00.1' and bi.lordem =5
20240507@171357.6634 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4902.00.1'
20240507@171357.6645 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.4902.00.1' and bi.lordem =6
20240507@171357.6959 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20240507@171357.7108 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.2221.00.1' and bi.lordem =7
20240507@171357.7423 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20240507@171357.7569 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.2222.00.1' and bi.lordem =8
20240507@171357.7872 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20240507@171357.8021 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.2224.00.1' and bi.lordem =9
20240507@171357.8331 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20240507@171357.8343 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.642.00.01' and bi.lordem =10
20240507@171357.8653 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20240507@171357.8665 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.642.00.01' and bi.lordem =10
20240507@171357.8671 dq8i71g4udqlsshf86igc952t8 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'
20240507@171357.8682 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.4421.00.1' and bi.lordem =11
20240507@171357.9022 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1536.00.1'
20240507@171357.9181 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.1536.00.1' and bi.lordem =12
20240507@171357.9503 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240507@171357.9515 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.5396.00.1' and bi.lordem =13
20240507@171357.9889 dq8i71g4udqlsshf86igc952t8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20240507@171357.9900 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403235 and bi.ref ='324.945.00.01' and bi.lordem =14
20240507@171358.2370 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.2410 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240507@171358.2540 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.2570 dq8i71g4udqlsshf86igc952t8 Query : select top 1 1 valor from td where td.ndoc = 39
20240507@171358.2670 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.2690 dq8i71g4udqlsshf86igc952t8 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240507@171358.2800 dq8i71g4udqlsshf86igc952t8 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
20240507@171358.2930 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.2960 dq8i71g4udqlsshf86igc952t8 Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20240507@171358.3060 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.3090 dq8i71g4udqlsshf86igc952t8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240507@171358.3190 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.3220 dq8i71g4udqlsshf86igc952t8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240507@171358.3320 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.3350 dq8i71g4udqlsshf86igc952t8 Query : select szadrsstamp valor from szadrs where szadrsdesc='eldisser, s.a. - grucoga'
20240507@171358.3470 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.3490 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from td where ndoc = 39
20240507@171358.3590 dq8i71g4udqlsshf86igc952t8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240507@171358.3700 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240507@171358.3840 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240507@171358.4000 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240507@171358.4120 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240507@171358.4370 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240507@171358.4500 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240507@171358.4590 dq8i71g4udqlsshf86igc952t8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240507@171358.5640 dq8i71g4udqlsshf86igc952t8 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240507@171358.5730 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240507@171358.5850 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240507@171358.5950 dq8i71g4udqlsshf86igc952t8 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240507@171358.7370 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240507@171358.7510 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240507@171358.7780 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240507@171358.7830 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240507@171358.7870 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240507@171358.7920 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240507@171358.7970 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240507@171358.8020 dq8i71g4udqlsshf86igc952t8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240507@171358.8070 dq8i71g4udqlsshf86igc952t8 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut663a572921663a53460b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240507@171358.1019 dq8i71g4udqlsshf86igc952t8 Query : select top 1 fno valor from wsft039data order by fno desc
20240507@171358.1036 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240507@171358.1143 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240507@171358.1163 dq8i71g4udqlsshf86igc952t8 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 ('aut663a572921663a53460b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1230,200500,0,'2024-05-07',39,'euro',0,0,2024 ,'20240507','1743',?,?,?,?)
20240507@171358.1413 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.1417 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20240507@171358.1495 dq8i71g4udqlsshf86igc952t8 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.1608.00.1'
20240507@171358.1654 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.1667 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.1689 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.1702 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.1706 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2200658200a'
20240507@171358.1719 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.1729 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.1740 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.1763 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a583763663a53462a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240507@171358.1971 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.1984 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.1989 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a583763663a53462a','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.1993 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.1996 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.1417.00.1'
20240507@171358.2006 dq8i71g4udqlsshf86igc952t8 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.1417.00.1'
20240507@171358.2016 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.2028 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.2050 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.2061 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.2066 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.1417.00.1' and lote = 'r2101088200a'
20240507@171358.2076 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.2085 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.2096 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.2117 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a590051663a534632',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240507@171358.2459 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.3384 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.3388 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a590051663a534632','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.3394 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.3407 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.3451 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.3463 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.3468 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.3477 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.3488 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.3515 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a517832663a534654',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,30000,?,?,?)
20240507@171358.3734 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.3748 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.3752 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a517832663a534654','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.3756 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.3759 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.1470.00.1'
20240507@171358.3769 dq8i71g4udqlsshf86igc952t8 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'
20240507@171358.3780 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.3791 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.3813 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.3824 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.3828 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.1470.00.1' and lote = 'r2100312200a'
20240507@171358.3837 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.3846 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.3857 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.3879 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a500631663a53465d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240507@171358.4078 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.4090 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.4094 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a500631663a53465d','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.4098 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.4101 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20240507@171358.4110 dq8i71g4udqlsshf86igc952t8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1461.00.1'
20240507@171358.4121 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.4132 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.4153 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.4165 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.4169 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100463200a'
20240507@171358.4177 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.4187 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.4199 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.4224 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a538045663a534666',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240507@171358.4512 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.4527 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.4531 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a538045663a534666','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.4536 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.4539 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.1256.00.1'
20240507@171358.4548 dq8i71g4udqlsshf86igc952t8 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.1256.00.1'
20240507@171358.4559 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.4572 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.4595 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.4606 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.4611 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.1256.00.1' and lote = 'r210135200a'
20240507@171358.4621 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.4630 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.4641 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.4663 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a598210663a534671',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240507@171358.4875 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.4888 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.4893 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a598210663a534671','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.4898 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.4910 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.4933 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.4944 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.4948 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.4958 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.4969 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.4992 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a591232663a534679',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,80000,?,?,?)
20240507@171358.5225 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.5239 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.5243 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a591232663a534679','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.5247 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.5250 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.4902.00.1'
20240507@171358.5260 dq8i71g4udqlsshf86igc952t8 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.4902.00.1'
20240507@171358.5271 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.5283 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.5305 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.5317 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.5321 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.4902.00.1' and lote = 'r2300206100a'
20240507@171358.5330 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.5340 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.5353 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.5376 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a542115663a534682',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240507@171358.5575 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.5588 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.5592 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a542115663a534682','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.5597 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.5609 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.5631 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.5642 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.5646 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.5695 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.5734 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.5756 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a589056663a53468b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,110000,?,?,?)
20240507@171358.5976 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.5991 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.5995 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a589056663a53468b','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.6000 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.6003 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240507@171358.6014 dq8i71g4udqlsshf86igc952t8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2221.00.1'
20240507@171358.6159 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.6172 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.6194 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.6205 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.6210 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301281300a'
20240507@171358.6226 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.6235 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.6246 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.6269 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a570124663a534698',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240507@171358.6550 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.6565 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.6569 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a570124663a534698','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.6573 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.6576 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20240507@171358.6587 dq8i71g4udqlsshf86igc952t8 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.2222.00.1'
20240507@171358.6756 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.6769 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.6790 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.6803 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.6807 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2300829100a'
20240507@171358.6817 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.6826 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.6837 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.6859 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a533542663a5346a6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20240507@171358.7071 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.7083 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.7087 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a533542663a5346a6','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.7091 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.7095 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240507@171358.7107 dq8i71g4udqlsshf86igc952t8 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.2224.00.1'
20240507@171358.7279 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.7294 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.7317 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.7331 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.7335 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301281600a'
20240507@171358.7346 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.7356 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.7368 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.7389 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a544228663a5346b3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20240507@171358.7599 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.7612 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.7616 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a544228663a5346b3','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.7620 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.7623 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240507@171358.7633 dq8i71g4udqlsshf86igc952t8 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.642.00.01'
20240507@171358.7644 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.7657 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.7679 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.7690 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.7695 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240507@171358.7704 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.7713 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.7724 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.7747 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a569002663a5346bc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240507@171358.7945 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.7959 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.7965 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a569002663a5346bc','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.7969 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.7972 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240507@171358.7981 dq8i71g4udqlsshf86igc952t8 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.642.00.01'
20240507@171358.7992 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.8005 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.8027 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.8039 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.8043 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240507@171358.8052 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.8127 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.8140 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.8165 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a527262663a5346c6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20240507@171358.8377 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.8393 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.8397 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a527262663a5346c6','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.8402 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.8405 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240507@171358.8415 dq8i71g4udqlsshf86igc952t8 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'
20240507@171358.8425 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.8439 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.8461 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.8473 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.8477 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2200226300a'
20240507@171358.8487 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.8496 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.8508 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.8530 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a587444663a5346cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',33.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,180000,?,?,?,?,?)
20240507@171358.8731 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.8744 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171358.8748 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a587444663a5346cf','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171358.8752 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171358.8755 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.1536.00.1'
20240507@171358.8766 dq8i71g4udqlsshf86igc952t8 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.1536.00.1'
20240507@171358.8916 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.8929 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171358.8955 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171358.8968 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171358.8973 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.1536.00.1' and lote = 'r2100240100a'
20240507@171358.8983 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171358.8993 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171358.9005 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171358.9029 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a529047663a5346db',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20240507@171358.9440 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.3670 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171359.3820 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a529047663a5346db','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171359.3880 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171359.3920 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240507@171359.4040 dq8i71g4udqlsshf86igc952t8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5396.00.1'
20240507@171359.4150 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.4290 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171359.4530 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.4680 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171359.4720 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240507@171359.4830 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171359.4930 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.5050 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171359.5260 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a509739663a53470c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,200000,?,?,?,?,?)
20240507@171359.7380 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.7540 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171359.7580 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a509739663a53470c','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171359.7630 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.7760 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171359.7980 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.8100 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171359.8150 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171359.8240 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.8350 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171359.8570 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut663a565913663a534714',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,210000,?,?,?)
20240507@171359.1162 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.1177 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171359.1182 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a565913663a534714','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171359.1186 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171359.1190 dq8i71g4udqlsshf86igc952t8 Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240507@171359.1201 dq8i71g4udqlsshf86igc952t8 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.945.00.01'
20240507@171359.1212 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.1225 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171359.1247 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.1259 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171359.1263 dq8i71g4udqlsshf86igc952t8 Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240507@171359.1273 dq8i71g4udqlsshf86igc952t8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171359.1282 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.1293 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171359.1316 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a548551663a53471f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut663a572921663a53460b' ,0,0 ,2,23.00,230000,?,?,?,?,?)
20240507@171359.1595 dq8i71g4udqlsshf86igc952t8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.1610 dq8i71g4udqlsshf86igc952t8 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171359.1615 dq8i71g4udqlsshf86igc952t8 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a548551663a53471f','aut663a572921663a53460b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171359.1619 dq8i71g4udqlsshf86igc952t8 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut663a572921663a53460b','2403235','wait',39,'ari17112337378,753000005')
20240507@171359.1636 dq8i71g4udqlsshf86igc952t8 Query : use flama_phc
20240507@171359.1638 dq8i71g4udqlsshf86igc952t8 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240507@171359.1650 dq8i71g4udqlsshf86igc952t8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1544';
20240507@171359.1664 dq8i71g4udqlsshf86igc952t8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1544';
20240507@171359.1681 dq8i71g4udqlsshf86igc952t8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1544';
20240507@171359.1693 dq8i71g4udqlsshf86igc952t8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1544';
20240507@171359.2153 i0vpjpb2vi9vte4sp934gitunu Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240507@171359.2170 i0vpjpb2vi9vte4sp934gitunu Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240507@171359.2187 i0vpjpb2vi9vte4sp934gitunu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1545';
20240507@171359.2230 i0vpjpb2vi9vte4sp934gitunu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1545';
20240507@171359.2251 i0vpjpb2vi9vte4sp934gitunu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1545';
20240507@171359.2263 i0vpjpb2vi9vte4sp934gitunu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1545';
20240507@171359.2277 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2280 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240507@171359.2292 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2294 i0vpjpb2vi9vte4sp934gitunu Query : select no, estab,szadrsdesc from szadrs where u_coddest=4774
20240507@171359.2364 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1461.00.1'
20240507@171359.2374 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403252 and bi.ref ='324.1461.00.1' and bi.lordem =1
20240507@171359.2683 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2687 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240507@171359.2699 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2702 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 1 valor from td where td.ndoc = 39
20240507@171359.2711 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2714 i0vpjpb2vi9vte4sp934gitunu Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240507@171359.2724 i0vpjpb2vi9vte4sp934gitunu 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
20240507@171359.2737 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2740 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 ~inactivo valor from cl where no = '100800' and estab = 0 order by inactivo desc
20240507@171359.2838 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2841 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240507@171359.2850 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2853 i0vpjpb2vi9vte4sp934gitunu Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240507@171359.2863 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2865 i0vpjpb2vi9vte4sp934gitunu Query : select szadrsstamp valor from szadrs where szadrsdesc='100800 - modelo continente hipermercados, sa'
20240507@171359.2877 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.2880 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from td where ndoc = 39
20240507@171359.2890 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240507@171359.2901 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240507@171359.2915 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240507@171359.2936 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240507@171359.2949 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240507@171359.2978 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240507@171359.2991 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240507@171359.3001 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240507@171359.3077 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240507@171359.3086 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240507@171359.3098 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240507@171359.3107 i0vpjpb2vi9vte4sp934gitunu Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut663a563944663a534749' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240507@171359.3248 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240507@171359.3260 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240507@171359.3285 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240507@171359.3290 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240507@171359.3294 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240507@171359.3299 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240507@171359.3304 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240507@171359.3308 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240507@171359.3312 i0vpjpb2vi9vte4sp934gitunu Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut663a563944663a534749',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240507@171359.3515 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 fno valor from wsft039data order by fno desc
20240507@171359.3531 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240507@171359.3544 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240507@171359.3561 i0vpjpb2vi9vte4sp934gitunu 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 ('aut663a563944663a534749',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1231,100800,0,'2024-05-07',39,'euro',0,0,2024 ,'20240507','1743',?,?,?,?)
20240507@171359.3804 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.3808 i0vpjpb2vi9vte4sp934gitunu Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20240507@171359.3819 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1461.00.1'
20240507@171359.3829 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.3842 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240507@171359.3863 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.3875 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240507@171359.3879 i0vpjpb2vi9vte4sp934gitunu Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100463200a'
20240507@171359.3889 i0vpjpb2vi9vte4sp934gitunu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240507@171359.3898 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240507@171359.3909 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240507@171359.3931 i0vpjpb2vi9vte4sp934gitunu Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut663a565391663a53475f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut663a563944663a534749' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240507@171359.4128 i0vpjpb2vi9vte4sp934gitunu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240507@171359.4146 i0vpjpb2vi9vte4sp934gitunu Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240507@171359.4150 i0vpjpb2vi9vte4sp934gitunu Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut663a565391663a53475f','aut663a563944663a534749' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240507@171359.4154 i0vpjpb2vi9vte4sp934gitunu Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut663a563944663a534749','2403252','wait',39,'ari17112337378,753000005')
20240507@171359.4179 i0vpjpb2vi9vte4sp934gitunu Query : use flama_phc
20240507@171359.4181 i0vpjpb2vi9vte4sp934gitunu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240507@171359.4199 i0vpjpb2vi9vte4sp934gitunu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1545';
20240507@171359.4216 i0vpjpb2vi9vte4sp934gitunu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1545';
20240507@171359.4240 i0vpjpb2vi9vte4sp934gitunu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1545';
20240507@171359.4251 i0vpjpb2vi9vte4sp934gitunu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1545';
20240507@171359.4612 qu48hd5lk9tqn1cnjq2oddelov Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240507@171359.4625 qu48hd5lk9tqn1cnjq2oddelov Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240507@171359.4642 qu48hd5lk9tqn1cnjq2oddelov Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1546';
20240507@171359.4683 qu48hd5lk9tqn1cnjq2oddelov Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1546';
20240507@171359.4702 qu48hd5lk9tqn1cnjq2oddelov Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1546';
20240507@171359.4713 qu48hd5lk9tqn1cnjq2oddelov Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1546';
20240507@171359.4729 qu48hd5lk9tqn1cnjq2oddelov Query : use flama_phc
20240507@171359.4732 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240507@171359.4743 qu48hd5lk9tqn1cnjq2oddelov Query : use flama_phc
20240507@171359.4745 qu48hd5lk9tqn1cnjq2oddelov Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20240507@171359.4810 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2000.94.1'
20240507@171359.4961 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403253 and bi.ref ='324.2000.94.1' and bi.lordem =1
20240507@171359.5264 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.900.94.02'
20240507@171359.5394 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403253 and bi.ref ='324.900.94.02' and bi.lordem =2
20240507@171359.5686 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.900.94.02'
20240507@171359.5690 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403253 and bi.ref ='324.900.94.02' and bi.lordem =2
20240507@171359.5695 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.700.94.01'
20240507@171359.5846 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403253 and bi.ref ='324.700.94.01' and bi.lordem =3
20240507@171359.6154 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2200.94.1'
20240507@171359.6293 qu48hd5lk9tqn1cnjq2oddelov Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403253 and bi.ref ='324.2200.94.1' and bi.lordem =4
