20230518@112854.6269 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.6284 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.6310 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f911516465fde691','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.6354 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112854.6358 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20230518@112854.6369 7lmee9v4bi43b15o203kh2ph5r 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.1803.00.1'
20230518@112854.6520 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.6534 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.6558 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.6571 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.6575 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2200669200a'
20230518@112854.6586 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.6595 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.6607 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.6630 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f184566465fde6a1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut6465f135836465fde63c' ,71.300000,0 ,2,23.00,20000,?,?,?,?,?,?,?,?,?)
20230518@112854.6878 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.6893 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.6897 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f184566465fde6a1','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.6901 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112854.6904 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20230518@112854.6916 7lmee9v4bi43b15o203kh2ph5r 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.1676.00.1'
20230518@112854.7100 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.7113 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.7137 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.7151 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.7156 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2200299100a'
20230518@112854.7175 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.7185 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.7196 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.7220 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f203886465fde6af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6465f135836465fde63c' ,57.600000,0 ,2,23.00,30000,?,?,?,?,?,?,?,?,?)
20230518@112854.7466 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.7481 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.7485 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f203886465fde6af','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.7489 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112854.7492 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20230518@112854.7503 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5347.00.1'
20230518@112854.7658 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.7671 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.7694 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.7707 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.7712 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2200658100a'
20230518@112854.7723 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.7732 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.7746 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.7775 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f825296465fde6bc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6465f135836465fde63c' ,20.500000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230518@112854.8025 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.8041 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.8045 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f825296465fde6bc','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.8050 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.8065 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.8088 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.8099 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.8104 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.8113 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.8124 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.8146 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f304906465fde6c6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,50000,?,?,?)
20230518@112854.8387 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.8401 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.8405 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f304906465fde6c6','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.8410 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112854.8415 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20230518@112854.8426 7lmee9v4bi43b15o203kh2ph5r 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.1824.00.1'
20230518@112854.8573 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.8586 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.8608 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.8622 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.8626 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2200671200a'
20230518@112854.8637 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.8647 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.8660 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.8682 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f677166465fde6d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6465f135836465fde63c' ,54.800000,0 ,2,23.00,70000,?,?,?,?,?,?,?,?,?)
20230518@112854.8945 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.8960 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.8965 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f677166465fde6d3','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.8970 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.8983 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.9010 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.9022 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.9026 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.9036 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.9048 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.9071 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f763386465fde6dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,80000,?,?,?)
20230518@112854.9321 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.9336 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.9341 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f763386465fde6dc','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.9346 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112854.9349 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20230518@112854.9361 7lmee9v4bi43b15o203kh2ph5r 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.1824.00.1'
20230518@112854.9373 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.9385 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.9410 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.9422 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.9426 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2200671200a'
20230518@112854.9436 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.9445 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.9457 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.9482 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f055796465fde6e6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6465f135836465fde63c' ,54.800000,0 ,2,23.00,100000,?,?,?,?,?,?,?,?,?)
20230518@112854.9734 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.9748 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112854.9753 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f055796465fde6e6','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112854.9758 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.9771 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112854.9794 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112854.9807 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112854.9811 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112854.9821 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112854.9832 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112854.9856 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f762996465fde6ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,110000,?,?,?)
20230518@112855.9800 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.1120 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.1170 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f762996465fde6ef','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.1210 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112855.1240 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20230518@112855.1340 7lmee9v4bi43b15o203kh2ph5r 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.1824.00.1'
20230518@112855.1460 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.1580 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.1820 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.1930 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.1970 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2200671200a'
20230518@112855.2080 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.2170 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.2280 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.2530 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f144776465fde705',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6465f135836465fde63c' ,.000000,0 ,2,23.00,130000,?,?,?,?,?,?,?,?,?)
20230518@112855.5090 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.5250 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.5290 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f144776465fde705','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.5340 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.5480 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.5720 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.5840 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.5880 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.5980 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.6100 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.6330 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f489426465fde70e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,140000,?,?,?)
20230518@112855.8870 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.9030 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.9080 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f489426465fde70e','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.9120 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112855.9150 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20230518@112855.9270 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20230518@112855.1072 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.1086 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.1115 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.1128 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.1132 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2200647200a'
20230518@112855.1143 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.1153 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.1166 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.1192 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f867556465fde71c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut6465f135836465fde63c' ,52.500000,0 ,2,23.00,160000,?,?,?,?,?,?,?,?,?)
20230518@112855.1439 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.1452 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.1457 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f867556465fde71c','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.1463 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.1476 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.1504 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.1518 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.1523 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.1533 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.1546 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.1569 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f966456465fde725',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,170000,?,?,?)
20230518@112855.1829 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.1848 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.1853 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f966456465fde725','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.1857 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112855.1860 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20230518@112855.1871 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20230518@112855.1882 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.2919 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.2947 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.2962 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.2966 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2200647200a'
20230518@112855.2978 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.2989 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.3003 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.3038 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f145666465fde748',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6465f135836465fde63c' ,.000000,0 ,2,23.00,190000,?,?,?,?,?,?,?,?,?)
20230518@112855.3324 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.3346 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.3352 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f145666465fde748','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.3357 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.3375 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.3406 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.3422 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.3429 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.3442 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.3457 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.3487 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f625646465fde754',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,200000,?,?,?)
20230518@112855.3776 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.3793 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.3799 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f625646465fde754','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.3805 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112855.3809 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230518@112855.3823 7lmee9v4bi43b15o203kh2ph5r 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.1879.00.1'
20230518@112855.3978 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.3995 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.4023 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.4036 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.4040 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230518@112855.4052 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.4063 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.4094 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.4122 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f015966465fde763',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6465f135836465fde63c' ,.000000,0 ,2,23.00,220000,?,?,?,?,?,?,?,?,?)
20230518@112855.4380 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.4395 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.4400 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f015966465fde763','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.4405 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.4420 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.4444 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.4456 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.4460 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.4469 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.4481 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.4504 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f013076465fde76d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,230000,?,?,?)
20230518@112855.4758 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.4774 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.4778 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f013076465fde76d','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.4782 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112855.4785 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20230518@112855.4796 7lmee9v4bi43b15o203kh2ph5r 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.1879.00.1'
20230518@112855.4807 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.4820 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.4844 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.4857 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.4861 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2100526100a'
20230518@112855.4870 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.4880 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.4892 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.4916 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f229476465fde777',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6465f135836465fde63c' ,63.800000,0 ,2,23.00,250000,?,?,?,?,?,?,?,?,?)
20230518@112855.5173 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.5188 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.5193 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f229476465fde777','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.5198 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.5211 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.5234 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.5248 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.5252 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.5262 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.5301 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.5324 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6465f874176465fde780',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6465f135836465fde63c' ,0,0 ,2,23.00,260000,?,?,?)
20230518@112855.5576 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.5591 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.5596 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f874176465fde780','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.5600 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112855.5604 7lmee9v4bi43b15o203kh2ph5r Query : select st.usalote valor from st where st.ref = '324.1705.00.1'
20230518@112855.5616 7lmee9v4bi43b15o203kh2ph5r 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.1705.00.1'
20230518@112855.5802 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.5818 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@112855.5841 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.5855 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@112855.5860 7lmee9v4bi43b15o203kh2ph5r Query : select sestamp valor from se where ref ='324.1705.00.1' and lote = 'r2200112200a'
20230518@112855.5871 7lmee9v4bi43b15o203kh2ph5r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@112855.5884 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@112855.5899 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@112855.5927 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6465f676696465fde78f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6465f135836465fde63c' ,32.000000,0 ,2,23.00,280000,?,?,?,?,?,?,?,?,?)
20230518@112855.6179 7lmee9v4bi43b15o203kh2ph5r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@112855.6195 7lmee9v4bi43b15o203kh2ph5r Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@112855.6201 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6465f676696465fde78f','aut6465f135836465fde63c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@112855.6206 7lmee9v4bi43b15o203kh2ph5r Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6465f135836465fde63c','119230000301','wait',39,'ari17112337378,753000005')
20230518@112855.6238 7lmee9v4bi43b15o203kh2ph5r Query : use flama_phc
20230518@112855.6242 7lmee9v4bi43b15o203kh2ph5r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@112855.6269 7lmee9v4bi43b15o203kh2ph5r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='496';
20230518@112855.6284 7lmee9v4bi43b15o203kh2ph5r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='496';
20230518@112855.6298 7lmee9v4bi43b15o203kh2ph5r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='496';
20230518@112855.6310 7lmee9v4bi43b15o203kh2ph5r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='496';
20230518@113014.9388 vo29ab0gms9cnnra6avmb5ignt Query : use flama_phc
20230518@113014.9420 vo29ab0gms9cnnra6avmb5ignt Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@113014.9508 vo29ab0gms9cnnra6avmb5ignt Query : use flama_phc
20230518@113014.9512 vo29ab0gms9cnnra6avmb5ignt Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@120017.7545 2qnkr20pbas4rh0i26e4taqmge Query : use flama_phc
20230518@120017.7549 2qnkr20pbas4rh0i26e4taqmge Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@120017.7565 2qnkr20pbas4rh0i26e4taqmge Query : use flama_phc
20230518@120017.7568 2qnkr20pbas4rh0i26e4taqmge Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@123009.9653 5ikvjc7s1lg5jvn40ubekbllkg Query : use flama_phc
20230518@123009.9659 5ikvjc7s1lg5jvn40ubekbllkg Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@123009.9676 5ikvjc7s1lg5jvn40ubekbllkg Query : use flama_phc
20230518@123009.9680 5ikvjc7s1lg5jvn40ubekbllkg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@123011.1982 70frnrslehsl2gevj6np442sp7 Query : use flama_phc
20230518@123011.1987 70frnrslehsl2gevj6np442sp7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@123011.2001 70frnrslehsl2gevj6np442sp7 Query : use flama_phc
20230518@123011.2004 70frnrslehsl2gevj6np442sp7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@123012.4767 q09vr3nhpf61lu6h7fdnebklp7 Query : use flama_phc
20230518@123012.4771 q09vr3nhpf61lu6h7fdnebklp7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@123012.4869 q09vr3nhpf61lu6h7fdnebklp7 Query : use flama_phc
20230518@123012.4875 q09vr3nhpf61lu6h7fdnebklp7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@123014.1494 ocjun0lfbeup43pk8n2hkhrj85 Query : use flama_phc
20230518@123014.1498 ocjun0lfbeup43pk8n2hkhrj85 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@123014.1511 ocjun0lfbeup43pk8n2hkhrj85 Query : use flama_phc
20230518@123014.1514 ocjun0lfbeup43pk8n2hkhrj85 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@123015.6736 l64nd9s1r69if5g5q3p90v4sc6 Query : use flama_phc
20230518@123015.6740 l64nd9s1r69if5g5q3p90v4sc6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@123015.6761 l64nd9s1r69if5g5q3p90v4sc6 Query : use flama_phc
20230518@123015.6764 l64nd9s1r69if5g5q3p90v4sc6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@123017.8492 46hdfatccbfntkk3a4sna2fll6 Query : use flama_phc
20230518@123017.8495 46hdfatccbfntkk3a4sna2fll6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@123017.8510 46hdfatccbfntkk3a4sna2fll6 Query : use flama_phc
20230518@123017.8536 46hdfatccbfntkk3a4sna2fll6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@130014.4967 u84rbh62hdspcqm0137oi5c1p3 Query : use flama_phc
20230518@130014.4970 u84rbh62hdspcqm0137oi5c1p3 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@130014.4986 u84rbh62hdspcqm0137oi5c1p3 Query : use flama_phc
20230518@130014.4988 u84rbh62hdspcqm0137oi5c1p3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@133007.2720 q2ridmg0f4fe17qqed6uthjjfn Query : use flama_phc
20230518@133007.2726 q2ridmg0f4fe17qqed6uthjjfn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@133007.2745 q2ridmg0f4fe17qqed6uthjjfn Query : use flama_phc
20230518@133007.2748 q2ridmg0f4fe17qqed6uthjjfn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@140011.5022 h0hpho3826fbi931q1ff8b7q26 Query : use flama_phc
20230518@140011.5026 h0hpho3826fbi931q1ff8b7q26 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@140011.5041 h0hpho3826fbi931q1ff8b7q26 Query : use flama_phc
20230518@140011.5044 h0hpho3826fbi931q1ff8b7q26 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@143011.4540 gj50unno25l0l1t1tboeuel6oo Query : use flama_phc
20230518@143011.4590 gj50unno25l0l1t1tboeuel6oo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@143011.4740 gj50unno25l0l1t1tboeuel6oo Query : use flama_phc
20230518@143011.4770 gj50unno25l0l1t1tboeuel6oo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@143022.9894 enlb61e9912bimml57p2gjhtl6 Query : use flama_phc
20230518@143022.9899 enlb61e9912bimml57p2gjhtl6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@143022.9915 enlb61e9912bimml57p2gjhtl6 Query : use flama_phc
20230518@143022.9918 enlb61e9912bimml57p2gjhtl6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@150008.1239 qb9omibrtd38g4t12tu858c72m Query : use flama_phc
20230518@150008.1362 qb9omibrtd38g4t12tu858c72m Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20230518@150008.1457 qb9omibrtd38g4t12tu858c72m Query : use flama_phc
20230518@150008.1460 qb9omibrtd38g4t12tu858c72m Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@150408.8399 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230518@150408.8416 9ibu0gia8ub4ttle7t2mml0f79 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230518@150408.8436 9ibu0gia8ub4ttle7t2mml0f79 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='497';
20230518@150408.8477 9ibu0gia8ub4ttle7t2mml0f79 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='497';
20230518@150408.8492 9ibu0gia8ub4ttle7t2mml0f79 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='497';
20230518@150408.8505 9ibu0gia8ub4ttle7t2mml0f79 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='497';
20230518@150408.8518 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150408.8522 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230518@150408.8538 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150408.8542 9ibu0gia8ub4ttle7t2mml0f79 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20230518@150408.8618 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20230518@150408.8782 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000309 and bi.ref ='324.1667.00.1' and bi.lordem =20000
20230518@150408.9120 9ibu0gia8ub4ttle7t2mml0f79 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850838,2090000-2 ' 
20230518@150408.9490 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20230518@150408.9501 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000309 and bi.ref ='324.1667.00.1' and bi.lordem =20000
20230518@150408.9515 9ibu0gia8ub4ttle7t2mml0f79 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850838,2090000-2 ' 
20230518@150408.9526 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20230518@150408.9539 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000309 and bi.ref ='324.1667.00.1' and bi.lordem =20000
20230518@150408.9551 9ibu0gia8ub4ttle7t2mml0f79 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850838,2090000-2 ' 
20230518@150408.9563 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20230518@150408.9575 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000309 and bi.ref ='324.1667.00.1' and bi.lordem =20000
20230518@150408.9587 9ibu0gia8ub4ttle7t2mml0f79 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850838,2090000-2 ' 
20230518@150408.9599 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150408.9602 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230518@150408.9738 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150408.9750 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 1 valor from td where td.ndoc = 39
20230518@150408.9764 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150408.9767 9ibu0gia8ub4ttle7t2mml0f79 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230518@150408.9780 9ibu0gia8ub4ttle7t2mml0f79 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
20230518@150408.9803 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150408.9806 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20230518@150409.1230 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.1360 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230518@150409.1560 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.1590 9ibu0gia8ub4ttle7t2mml0f79 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230518@150409.1770 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.1800 9ibu0gia8ub4ttle7t2mml0f79 Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20230518@150409.1970 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.2000 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from td where ndoc = 39
20230518@150409.2190 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230518@150409.2410 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150409.2640 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230518@150409.2890 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150409.3090 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230518@150409.3450 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150409.3590 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230518@150409.3710 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150409.4150 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150409.4370 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150409.4500 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230518@150409.4760 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230518@150409.7570 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150409.8550 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230518@150409.8860 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051557346,697000001 '
20230518@150409.1178 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051557346,697000001 '
20230518@150409.1295 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051557346,697000001 '
20230518@150409.1392 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051557346,697000001 '
20230518@150409.1480 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051557346,697000001 '
20230518@150409.1577 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051557346,697000001 '
20230518@150409.1662 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut64663584986466305909',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230518@150409.1884 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 fno valor from wsft039data order by fno desc
20230518@150409.1901 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150409.1917 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230518@150409.1938 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut64663584986466305909',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',352,101597,0,'2023-05-18',39,'euro',0,0,2023 ,'20230518','1534',?,?,?,?,?)
20230518@150409.2254 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.2258 9ibu0gia8ub4ttle7t2mml0f79 Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20230518@150409.2294 9ibu0gia8ub4ttle7t2mml0f79 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.1667.00.1'
20230518@150409.2491 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.2508 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.2549 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.2564 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.2569 9ibu0gia8ub4ttle7t2mml0f79 Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2300059200a'
20230518@150409.2587 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.2599 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.2613 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.2642 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6466383544646630593f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut64663584986466305909' ,82.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230518@150409.2942 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.2958 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.2963 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6466383544646630593f','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.2969 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.2984 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.3012 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.3026 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.3031 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.3042 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.3056 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.3084 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6466398662646630594a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64663584986466305909' ,0,0 ,2,23.00,20000,?,?,?)
20230518@150409.3339 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.3353 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.3358 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6466398662646630594a','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.3363 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.3366 9ibu0gia8ub4ttle7t2mml0f79 Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20230518@150409.3378 9ibu0gia8ub4ttle7t2mml0f79 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.1667.00.1'
20230518@150409.3390 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.3404 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.3432 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.3447 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.3453 9ibu0gia8ub4ttle7t2mml0f79 Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2300059200a'
20230518@150409.3466 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.3478 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.3493 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.3519 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut64663179666466305954',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut64663584986466305909' ,82.600000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230518@150409.3796 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.3811 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.3816 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64663179666466305954','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.3823 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.3839 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.3868 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.3882 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.3889 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.3902 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.3915 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.3941 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6466381741646630595f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64663584986466305909' ,0,0 ,2,23.00,50000,?,?,?)
20230518@150409.4188 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.4202 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.4207 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6466381741646630595f','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.4212 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.4215 9ibu0gia8ub4ttle7t2mml0f79 Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20230518@150409.4226 9ibu0gia8ub4ttle7t2mml0f79 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.1667.00.1'
20230518@150409.4239 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.4255 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.4283 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.4322 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.4328 9ibu0gia8ub4ttle7t2mml0f79 Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2300059200a'
20230518@150409.4340 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.4350 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.4365 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.4390 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6466344179646630596a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut64663584986466305909' ,82.600000,0 ,2,23.00,70000,?,?,?,?,?,?,?,?,?)
20230518@150409.4639 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.5641 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.5647 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6466344179646630596a','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.5654 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.5668 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.5695 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.5713 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.5720 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.5733 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.5748 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.5774 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6466338667646630598b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64663584986466305909' ,0,0 ,2,23.00,80000,?,?,?)
20230518@150409.6153 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.6218 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.6223 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6466338667646630598b','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.6228 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.6233 9ibu0gia8ub4ttle7t2mml0f79 Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20230518@150409.6270 9ibu0gia8ub4ttle7t2mml0f79 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.1667.00.1'
20230518@150409.6283 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.6299 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.6325 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.6340 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.6345 9ibu0gia8ub4ttle7t2mml0f79 Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2300059200a'
20230518@150409.6357 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.6368 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.6392 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.6421 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6466365516646630599b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut64663584986466305909' ,82.600000,0 ,2,23.00,100000,?,?,?,?,?,?,?,?,?)
20230518@150409.6678 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.6695 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.6702 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6466365516646630599b','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.6725 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.6741 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150409.6768 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.6781 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150409.6786 9ibu0gia8ub4ttle7t2mml0f79 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150409.6798 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150409.6811 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150409.6845 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut646635370464663059a5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64663584986466305909' ,0,0 ,2,23.00,110000,?,?,?)
20230518@150409.7093 9ibu0gia8ub4ttle7t2mml0f79 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150409.7108 9ibu0gia8ub4ttle7t2mml0f79 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150409.7113 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut646635370464663059a5','aut64663584986466305909' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150409.7117 9ibu0gia8ub4ttle7t2mml0f79 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut64663584986466305909','119230000309','wait',39,'ari17112337378,753000005')
20230518@150409.7136 9ibu0gia8ub4ttle7t2mml0f79 Query : use flama_phc
20230518@150409.7139 9ibu0gia8ub4ttle7t2mml0f79 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@150409.7155 9ibu0gia8ub4ttle7t2mml0f79 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='497';
20230518@150409.7171 9ibu0gia8ub4ttle7t2mml0f79 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='497';
20230518@150409.7183 9ibu0gia8ub4ttle7t2mml0f79 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='497';
20230518@150409.7202 9ibu0gia8ub4ttle7t2mml0f79 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='497';
20230518@150409.7582 gf7arnioh4hp0uc9t4k643mll1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230518@150409.7596 gf7arnioh4hp0uc9t4k643mll1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230518@150409.7613 gf7arnioh4hp0uc9t4k643mll1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='498';
20230518@150409.7653 gf7arnioh4hp0uc9t4k643mll1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='498';
20230518@150409.7672 gf7arnioh4hp0uc9t4k643mll1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='498';
20230518@150409.7685 gf7arnioh4hp0uc9t4k643mll1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='498';
20230518@150409.7700 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150409.7704 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230518@150409.7717 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150409.7721 gf7arnioh4hp0uc9t4k643mll1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=233
20230518@150409.7795 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20230518@150409.7950 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000310 and bi.ref ='327.8253.00.1' and bi.lordem =20000
20230518@150409.9990 gf7arnioh4hp0uc9t4k643mll1 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850840,8740000-2 ' 
20230518@150410.3290 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.3330 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230518@150410.3470 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.3500 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 1 valor from td where td.ndoc = 39
20230518@150410.3620 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.3650 gf7arnioh4hp0uc9t4k643mll1 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230518@150410.3760 gf7arnioh4hp0uc9t4k643mll1 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
20230518@150410.3920 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.3950 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20230518@150410.5080 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.5110 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230518@150410.5230 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.5260 gf7arnioh4hp0uc9t4k643mll1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230518@150410.5370 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.5410 gf7arnioh4hp0uc9t4k643mll1 Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - tudo para o seu lar'
20230518@150410.5540 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.5570 gf7arnioh4hp0uc9t4k643mll1 Query : select 1 valor from td where ndoc = 39
20230518@150410.5680 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230518@150410.5810 gf7arnioh4hp0uc9t4k643mll1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150410.5960 gf7arnioh4hp0uc9t4k643mll1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230518@150410.6350 gf7arnioh4hp0uc9t4k643mll1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150410.6500 gf7arnioh4hp0uc9t4k643mll1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230518@150410.6790 gf7arnioh4hp0uc9t4k643mll1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150410.6930 gf7arnioh4hp0uc9t4k643mll1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230518@150410.7030 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150410.7460 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150410.7580 gf7arnioh4hp0uc9t4k643mll1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150410.7720 gf7arnioh4hp0uc9t4k643mll1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230518@150410.7830 gf7arnioh4hp0uc9t4k643mll1 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut64663175276466305a11' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230518@150410.9560 gf7arnioh4hp0uc9t4k643mll1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150410.9720 gf7arnioh4hp0uc9t4k643mll1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230518@150410.1004 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='264e18a9b04c465d69423b '
20230518@150410.1103 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='264e18a9b04c465d69423b '
20230518@150410.1179 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='264e18a9b04c465d69423b '
20230518@150410.1255 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='264e18a9b04c465d69423b '
20230518@150410.1337 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp='264e18a9b04c465d69423b '
20230518@150410.1423 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 bo.serie valor from bo where bo.bostamp='264e18a9b04c465d69423b '
20230518@150410.1514 gf7arnioh4hp0uc9t4k643mll1 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut64663175276466305a11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230518@150410.1732 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 fno valor from wsft039data order by fno desc
20230518@150410.1747 gf7arnioh4hp0uc9t4k643mll1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150410.1763 gf7arnioh4hp0uc9t4k643mll1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230518@150410.1782 gf7arnioh4hp0uc9t4k643mll1 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut64663175276466305a11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',353,101621,0,'2023-05-18',39,'euro',0,0,2023 ,'20230518','1534',?,?,?,?,?)
20230518@150410.2059 gf7arnioh4hp0uc9t4k643mll1 Query : use flama_phc
20230518@150410.2063 gf7arnioh4hp0uc9t4k643mll1 Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -700
20230518@150410.2115 gf7arnioh4hp0uc9t4k643mll1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='498';
20230518@150410.2130 gf7arnioh4hp0uc9t4k643mll1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='498';
20230518@150410.3321 rn1mo4u9e919qecjqonidsdok3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230518@150410.3334 rn1mo4u9e919qecjqonidsdok3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230518@150410.3352 rn1mo4u9e919qecjqonidsdok3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='499';
20230518@150410.3465 rn1mo4u9e919qecjqonidsdok3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='499';
20230518@150410.3521 rn1mo4u9e919qecjqonidsdok3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='499';
20230518@150410.3536 rn1mo4u9e919qecjqonidsdok3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='499';
20230518@150410.3549 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.3552 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230518@150410.3568 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.3571 rn1mo4u9e919qecjqonidsdok3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=822
20230518@150410.3651 rn1mo4u9e919qecjqonidsdok3 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'
20230518@150410.3834 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000311 and bi.ref ='324.1461.00.1' and bi.lordem =30000
20230518@150410.4169 rn1mo4u9e919qecjqonidsdok3 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850842,9790000-3 ' 
20230518@150410.4500 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4504 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230518@150410.4519 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4523 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 1 valor from td where td.ndoc = 39
20230518@150410.4534 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4537 rn1mo4u9e919qecjqonidsdok3 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230518@150410.4551 rn1mo4u9e919qecjqonidsdok3 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
20230518@150410.4568 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4572 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 ~inactivo valor from cl where no = '101811' and estab = 0 order by inactivo desc
20230518@150410.4679 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4682 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230518@150410.4694 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4698 rn1mo4u9e919qecjqonidsdok3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230518@150410.4710 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4713 rn1mo4u9e919qecjqonidsdok3 Query : select szadrsstamp valor from szadrs where szadrsdesc='acacio antunes pereira'
20230518@150410.4728 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.4731 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from td where ndoc = 39
20230518@150410.4743 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230518@150410.4755 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150410.4769 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230518@150410.4787 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150410.4801 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230518@150410.4834 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150410.4848 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230518@150410.4882 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150410.4926 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150410.4937 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150410.4950 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230518@150410.4962 rn1mo4u9e919qecjqonidsdok3 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut64663297986466305a77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230518@150410.5137 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150410.5159 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230518@150410.5196 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='6146ba8f32898957b967a3 '
20230518@150410.5321 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='6146ba8f32898957b967a3 '
20230518@150410.5423 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='6146ba8f32898957b967a3 '
20230518@150410.5532 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='6146ba8f32898957b967a3 '
20230518@150410.5628 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp='6146ba8f32898957b967a3 '
20230518@150410.5710 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 bo.serie valor from bo where bo.bostamp='6146ba8f32898957b967a3 '
20230518@150410.5814 rn1mo4u9e919qecjqonidsdok3 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut64663297986466305a77',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230518@150410.6053 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 fno valor from wsft039data order by fno desc
20230518@150410.6070 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150410.6086 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230518@150410.6109 rn1mo4u9e919qecjqonidsdok3 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut64663297986466305a77',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',353,101811,0,'2023-05-18',39,'euro',0,0,2023 ,'20230518','1534',?,?,?,?,?)
20230518@150410.6406 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.6410 rn1mo4u9e919qecjqonidsdok3 Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20230518@150410.6424 rn1mo4u9e919qecjqonidsdok3 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'
20230518@150410.6578 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150410.6593 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150410.6622 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150410.6640 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150410.6647 rn1mo4u9e919qecjqonidsdok3 Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100211200a'
20230518@150410.6660 rn1mo4u9e919qecjqonidsdok3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150410.6672 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150410.6705 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150410.6733 rn1mo4u9e919qecjqonidsdok3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut64663741896466305aa2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut64663297986466305a77' ,64.000000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230518@150410.6980 rn1mo4u9e919qecjqonidsdok3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150410.7002 rn1mo4u9e919qecjqonidsdok3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150410.7007 rn1mo4u9e919qecjqonidsdok3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64663741896466305aa2','aut64663297986466305a77' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150410.7013 rn1mo4u9e919qecjqonidsdok3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut64663297986466305a77','119230000311','wait',39,'ari17112337378,753000005')
20230518@150410.7049 rn1mo4u9e919qecjqonidsdok3 Query : use flama_phc
20230518@150410.7052 rn1mo4u9e919qecjqonidsdok3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@150410.7065 rn1mo4u9e919qecjqonidsdok3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='499';
20230518@150410.7081 rn1mo4u9e919qecjqonidsdok3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='499';
20230518@150410.7098 rn1mo4u9e919qecjqonidsdok3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='499';
20230518@150410.7113 rn1mo4u9e919qecjqonidsdok3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='499';
20230518@150410.7585 n43fcou96vvfo78t26r6sbqg24 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230518@150410.7601 n43fcou96vvfo78t26r6sbqg24 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230518@150410.7622 n43fcou96vvfo78t26r6sbqg24 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='500';
20230518@150410.7663 n43fcou96vvfo78t26r6sbqg24 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='500';
20230518@150410.7681 n43fcou96vvfo78t26r6sbqg24 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='500';
20230518@150410.7695 n43fcou96vvfo78t26r6sbqg24 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='500';
20230518@150410.7707 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.7710 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230518@150410.7724 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.7728 n43fcou96vvfo78t26r6sbqg24 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3674
20230518@150410.7800 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20230518@150410.7953 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000312 and bi.ref ='324.5343.00.1' and bi.lordem =20000
20230518@150410.8275 n43fcou96vvfo78t26r6sbqg24 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850852,6180000-2 ' 
20230518@150410.9484 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20230518@150410.9496 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000312 and bi.ref ='324.5343.00.1' and bi.lordem =20000
20230518@150410.9510 n43fcou96vvfo78t26r6sbqg24 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051850852,6180000-2 ' 
20230518@150410.9522 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9526 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230518@150410.9539 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9542 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 1 valor from td where td.ndoc = 39
20230518@150410.9554 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9557 n43fcou96vvfo78t26r6sbqg24 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230518@150410.9569 n43fcou96vvfo78t26r6sbqg24 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
20230518@150410.9656 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9659 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 ~inactivo valor from cl where no = '199524' and estab = 0 order by inactivo desc
20230518@150410.9773 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9777 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230518@150410.9787 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9790 n43fcou96vvfo78t26r6sbqg24 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230518@150410.9801 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9804 n43fcou96vvfo78t26r6sbqg24 Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- az'
20230518@150410.9819 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150410.9822 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from td where ndoc = 39
20230518@150410.9832 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230518@150410.9845 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150410.9859 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230518@150410.9876 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150410.9889 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230518@150410.9916 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150410.9929 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230518@150410.9940 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150410.9980 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230518@150410.9990 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230518@150411.5000 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230518@150411.1500 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut64663922746466305af2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230518@150411.1750 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230518@150411.1890 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230518@150411.2170 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23050850464,114000001 '
20230518@150411.3180 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23050850464,114000001 '
20230518@150411.3970 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23050850464,114000001 '
20230518@150411.4770 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23050850464,114000001 '
20230518@150411.5530 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23050850464,114000001 '
20230518@150411.6260 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23050850464,114000001 '
20230518@150411.7030 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut64663922746466305af2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230518@150411.9280 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 fno valor from wsft039data order by fno desc
20230518@150411.9430 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230518@150411.9560 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230518@150411.9720 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut64663922746466305af2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',354,199524,0,'2023-05-18',39,'euro',0,0,2023 ,'20230518','1534',?,?,?,?,?)
20230518@150411.1270 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150411.1311 n43fcou96vvfo78t26r6sbqg24 Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20230518@150411.1384 n43fcou96vvfo78t26r6sbqg24 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.5343.00.1'
20230518@150411.1538 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.1551 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150411.1575 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.1587 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150411.1591 n43fcou96vvfo78t26r6sbqg24 Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2100244100a'
20230518@150411.1609 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150411.1619 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.1631 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150411.1654 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut64663567116466305b27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',90.000 ,'aut64663922746466305af2' ,19.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230518@150411.1926 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.1940 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150411.1944 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64663567116466305b27','aut64663922746466305af2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150411.1949 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.1963 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150411.1987 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.1999 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150411.2004 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150411.2014 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.2026 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150411.2048 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut64663586316466305b31',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64663922746466305af2' ,0,0 ,2,23.00,20000,?,?,?)
20230518@150411.2274 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.2288 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150411.2292 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64663586316466305b31','aut64663922746466305af2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150411.2296 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150411.2299 n43fcou96vvfo78t26r6sbqg24 Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20230518@150411.2310 n43fcou96vvfo78t26r6sbqg24 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.5343.00.1'
20230518@150411.2321 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.2333 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150411.2356 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.2367 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150411.2371 n43fcou96vvfo78t26r6sbqg24 Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2100244100a'
20230518@150411.2381 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150411.2390 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.2401 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150411.2426 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut64663302596466305b3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut64663922746466305af2' ,19.600000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230518@150411.2755 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.2768 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150411.2772 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64663302596466305b3a','aut64663922746466305af2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150411.2777 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.2788 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230518@150411.2810 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.2824 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230518@150411.2828 n43fcou96vvfo78t26r6sbqg24 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230518@150411.2838 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230518@150411.2852 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230518@150411.2877 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut64663975826466305b45',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut64663922746466305af2' ,0,0 ,2,23.00,50000,?,?,?)
20230518@150411.3134 n43fcou96vvfo78t26r6sbqg24 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230518@150411.3272 n43fcou96vvfo78t26r6sbqg24 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230518@150411.3423 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut64663975826466305b45','aut64663922746466305af2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230518@150411.3428 n43fcou96vvfo78t26r6sbqg24 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut64663922746466305af2','119230000312','wait',39,'ari17112337378,753000005')
20230518@150411.3449 n43fcou96vvfo78t26r6sbqg24 Query : use flama_phc
20230518@150411.3452 n43fcou96vvfo78t26r6sbqg24 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230518@150411.3523 n43fcou96vvfo78t26r6sbqg24 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='500';
20230518@150411.3537 n43fcou96vvfo78t26r6sbqg24 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='500';
20230518@150411.3558 n43fcou96vvfo78t26r6sbqg24 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='500';
20230518@150411.3703 n43fcou96vvfo78t26r6sbqg24 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='500';
20230518@150411.4172 fdn0u6ji8ahsmjurp7l5ajbgug Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230518@150411.4184 fdn0u6ji8ahsmjurp7l5ajbgug Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230518@150411.4199 fdn0u6ji8ahsmjurp7l5ajbgug Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='501';
20230518@150411.4278 fdn0u6ji8ahsmjurp7l5ajbgug Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='501';
20230518@150411.4291 fdn0u6ji8ahsmjurp7l5ajbgug Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='501';
20230518@150411.4302 fdn0u6ji8ahsmjurp7l5ajbgug Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='501';
20230518@150411.4313 fdn0u6ji8ahsmjurp7l5ajbgug Query : use flama_phc
20230518@150411.4316 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230518@150411.4327 fdn0u6ji8ahsmjurp7l5ajbgug Query : use flama_phc
20230518@150411.4330 fdn0u6ji8ahsmjurp7l5ajbgug Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20230518@150411.4360 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20230518@150411.4515 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='324.4751.00.1' and bi.lordem =20000
20230518@150411.4859 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,5860000-2 ' 
20230518@150411.5185 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4751.00.1'
20230518@150411.5195 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='324.4751.00.1' and bi.lordem =20000
20230518@150411.5206 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,5860000-2 ' 
20230518@150411.5216 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4964.00.1'
20230518@150411.6314 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='324.4964.00.1' and bi.lordem =30000
20230518@150411.6632 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,6150000-3 ' 
20230518@150411.6943 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1416.00.1'
20230518@150411.7337 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='324.1416.00.1' and bi.lordem =40000
20230518@150411.7733 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,6450000-4 ' 
20230518@150411.8154 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1416.00.1'
20230518@150411.8164 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='324.1416.00.1' and bi.lordem =40000
20230518@150411.8176 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,6450000-4 ' 
20230518@150411.8186 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4005.00.2'
20230518@150411.8336 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='304.4005.00.2' and bi.lordem =50000
20230518@150411.8694 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,6760000-5 ' 
20230518@150411.9020 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4005.00.2'
20230518@150411.9030 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='304.4005.00.2' and bi.lordem =50000
20230518@150411.9042 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,6760000-5 ' 
20230518@150411.9052 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4005.00.2'
20230518@150411.9062 fdn0u6ji8ahsmjurp7l5ajbgug Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000313 and bi.ref ='304.4005.00.2' and bi.lordem =50000
20230518@150411.9072 fdn0u6ji8ahsmjurp7l5ajbgug Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051851420,6760000-5 ' 
