20240502@213509.4314 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.4319 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301208200a'
20240502@213509.4330 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.4340 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.4353 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.4379 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f400546633f8fd69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240502@213509.4639 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.4655 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.4660 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f400546633f8fd69','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.4665 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.4680 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.4707 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.4720 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.4725 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.4736 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.4749 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.4771 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f920066633f8fd73',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,30000,?,?,?)
20240502@213509.5022 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.5044 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.5049 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f920066633f8fd73','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.5054 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213509.5057 emeapj7quloct6vl38eia26h9n Query : select st.usalote valor from st where st.ref = '324.1407.00.1'
20240502@213509.5070 emeapj7quloct6vl38eia26h9n 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.1407.00.1'
20240502@213509.5235 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.5250 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.5278 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.5293 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.5297 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.1407.00.1' and lote = 'r2100703100a'
20240502@213509.5320 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.5331 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.5343 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.5366 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f537126633f8fd82',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240502@213509.5628 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.5644 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.5651 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f537126633f8fd82','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.5656 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213509.5659 emeapj7quloct6vl38eia26h9n Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240502@213509.5670 emeapj7quloct6vl38eia26h9n 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.2031.00.1'
20240502@213509.5867 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.5881 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.5903 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.5916 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.5920 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240502@213509.5945 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.5954 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.5967 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.5991 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f163186633f8fd91',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240502@213509.6256 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.6272 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.6277 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f163186633f8fd91','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.6282 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.6296 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.6332 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.6345 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.6349 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.6359 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.6371 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.6399 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f953326633f8fd9b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,70000,?,?,?)
20240502@213509.6765 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.6781 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.6786 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f953326633f8fd9b','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.6791 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213509.6794 emeapj7quloct6vl38eia26h9n Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20240502@213509.6805 emeapj7quloct6vl38eia26h9n 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.966.00.01'
20240502@213509.6816 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.6829 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.6853 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.6865 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.6869 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2301193200a'
20240502@213509.6880 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.6890 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.6903 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.6928 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f615806633f8fda8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20240502@213509.7199 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.7215 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.7219 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f615806633f8fda8','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.7225 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213509.7228 emeapj7quloct6vl38eia26h9n Query : select st.usalote valor from st where st.ref = '324.5365.00.1'
20240502@213509.7241 emeapj7quloct6vl38eia26h9n 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.5365.00.1'
20240502@213509.7400 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.7415 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.7458 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.7472 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.7477 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.5365.00.1' and lote = 'r2300840100a'
20240502@213509.7495 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.7504 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.7517 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.7544 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f175636633f8fdb7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240502@213509.7821 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.7927 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.8222 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f175636633f8fdb7','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.8266 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.8375 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.8400 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.8413 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.8418 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.8428 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.8441 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.8463 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f284526633f8fdcd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,110000,?,?,?)
20240502@213509.8739 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.8757 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.8761 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f284526633f8fdcd','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.8766 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213509.8769 emeapj7quloct6vl38eia26h9n Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20240502@213509.8783 emeapj7quloct6vl38eia26h9n 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.4980.00.1'
20240502@213509.8949 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.8963 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213509.8990 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.9004 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213509.9009 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2301092100a'
20240502@213509.9027 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213509.9038 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213509.9131 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213509.9159 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f933836633f8fddc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240502@213509.9419 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213509.9436 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213509.9441 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f933836633f8fddc','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213509.9445 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213509.9449 emeapj7quloct6vl38eia26h9n Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20240502@213509.9461 emeapj7quloct6vl38eia26h9n 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.1805.00.1'
20240502@213510.6420 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.7500 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213510.7780 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.7950 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213510.7990 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2300831200a'
20240502@213510.8250 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213510.8370 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.8510 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213510.8750 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f038266633f8fe14',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20240502@213510.1146 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.1166 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213510.1171 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f038266633f8fe14','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213510.1177 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213510.1181 emeapj7quloct6vl38eia26h9n Query : select st.usalote valor from st where st.ref = '324.497.00.01'
20240502@213510.1195 emeapj7quloct6vl38eia26h9n 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.497.00.01'
20240502@213510.1384 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.1402 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213510.1427 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.1441 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213510.1445 emeapj7quloct6vl38eia26h9n Query : select sestamp valor from se where ref ='324.497.00.01' and lote = 'r2300022100a'
20240502@213510.1472 emeapj7quloct6vl38eia26h9n Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213510.1485 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.1500 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213510.1537 emeapj7quloct6vl38eia26h9n Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f122306633f8fe24',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6633f739666633f8fd29' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20240502@213510.1805 emeapj7quloct6vl38eia26h9n Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.1821 emeapj7quloct6vl38eia26h9n Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213510.1826 emeapj7quloct6vl38eia26h9n Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f122306633f8fe24','aut6633f739666633f8fd29' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213510.1831 emeapj7quloct6vl38eia26h9n Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6633f739666633f8fd29','2403145','wait',39,'ari17112337378,753000005')
20240502@213510.1849 emeapj7quloct6vl38eia26h9n Query : use flama_phc
20240502@213510.1852 emeapj7quloct6vl38eia26h9n Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240502@213510.1867 emeapj7quloct6vl38eia26h9n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1474';
20240502@213510.1902 emeapj7quloct6vl38eia26h9n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1474';
20240502@213510.1921 emeapj7quloct6vl38eia26h9n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1474';
20240502@213510.1939 emeapj7quloct6vl38eia26h9n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1474';
20240502@213510.2451 8kjaerojtkaeumhos6i7ke6b8u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240502@213510.2466 8kjaerojtkaeumhos6i7ke6b8u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240502@213510.2495 8kjaerojtkaeumhos6i7ke6b8u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1475';
20240502@213510.2543 8kjaerojtkaeumhos6i7ke6b8u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1475';
20240502@213510.2564 8kjaerojtkaeumhos6i7ke6b8u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1475';
20240502@213510.2582 8kjaerojtkaeumhos6i7ke6b8u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1475';
20240502@213510.2598 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.2601 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240502@213510.2615 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.2618 8kjaerojtkaeumhos6i7ke6b8u Query : select no, estab,szadrsdesc from szadrs where u_coddest=170
20240502@213510.2708 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240502@213510.2719 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.1824.00.1' and bi.lordem =1
20240502@213510.3091 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240502@213510.3102 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.1824.00.1' and bi.lordem =1
20240502@213510.3108 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20240502@213510.3118 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.1824.00.1' and bi.lordem =1
20240502@213510.3124 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240502@213510.3135 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.1879.00.1' and bi.lordem =3
20240502@213510.3473 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240502@213510.3485 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.1879.00.1' and bi.lordem =3
20240502@213510.3490 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240502@213510.3500 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.1879.00.1' and bi.lordem =3
20240502@213510.3506 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240502@213510.3668 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.1803.00.1' and bi.lordem =5
20240502@213510.4000 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.646.00.01'
20240502@213510.4165 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403150 and bi.ref ='324.646.00.01' and bi.lordem =7
20240502@213510.4513 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.4517 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240502@213510.4530 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.4534 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 1 valor from td where td.ndoc = 39
20240502@213510.5839 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.6441 8kjaerojtkaeumhos6i7ke6b8u Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240502@213510.6455 8kjaerojtkaeumhos6i7ke6b8u 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
20240502@213510.6470 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.6473 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 ~inactivo valor from cl where no = '102068' and estab = 0 order by inactivo desc
20240502@213510.6621 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.6624 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240502@213510.6634 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.6637 8kjaerojtkaeumhos6i7ke6b8u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240502@213510.6648 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.6651 8kjaerojtkaeumhos6i7ke6b8u Query : select szadrsstamp valor from szadrs where szadrsdesc='magalhÃes & vinha, lda.'
20240502@213510.6664 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.6667 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from td where ndoc = 39
20240502@213510.6676 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240502@213510.6688 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213510.6702 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240502@213510.6719 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213510.6731 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240502@213510.6758 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213510.6771 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240502@213510.6781 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213510.6873 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213510.6884 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213510.6897 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240502@213510.6907 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6633f930836633f8fea5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240502@213510.7091 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213510.7106 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240502@213510.7136 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240502@213510.7141 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240502@213510.7146 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240502@213510.7151 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240502@213510.7156 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240502@213510.7161 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240502@213510.7165 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6633f930836633f8fea5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240502@213510.7413 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 fno valor from wsft039data order by fno desc
20240502@213510.7433 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213510.7447 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240502@213510.7464 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6633f930836633f8fea5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1171,102068,0,'2024-05-02',39,'euro',0,0,2024 ,'20240502','2205',?,?,?,?)
20240502@213510.7911 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.7916 8kjaerojtkaeumhos6i7ke6b8u Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240502@213510.7927 8kjaerojtkaeumhos6i7ke6b8u 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'
20240502@213510.7938 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.7953 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213510.7977 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.7990 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213510.7994 8kjaerojtkaeumhos6i7ke6b8u Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301208200a'
20240502@213510.8005 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213510.8015 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.8029 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213510.8054 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f725926633f8fec3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6633f930836633f8fea5' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240502@213510.8327 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.8342 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213510.8347 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f725926633f8fec3','aut6633f930836633f8fea5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213510.8352 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.8368 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213510.8392 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.8405 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213510.8409 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213510.8419 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.8432 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213510.8456 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f815846633f8fecd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f930836633f8fea5' ,0,0 ,2,23.00,20000,?,?,?)
20240502@213510.9027 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.9527 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213510.9733 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f815846633f8fecd','aut6633f930836633f8fea5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213510.9763 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213510.9767 8kjaerojtkaeumhos6i7ke6b8u Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240502@213510.9779 8kjaerojtkaeumhos6i7ke6b8u 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'
20240502@213510.9791 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.9805 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213510.9827 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213510.9840 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213510.9844 8kjaerojtkaeumhos6i7ke6b8u Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301208200a'
20240502@213510.9853 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213510.9863 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213510.9875 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213510.9901 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f841226633f8fef0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6633f930836633f8fea5' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240502@213511.1810 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.1990 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213511.2040 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f841226633f8fef0','aut6633f930836633f8fea5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213511.2100 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.2260 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213511.2570 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.2710 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213511.2760 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213511.2880 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.3010 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213511.3290 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f973546633f8ff07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f930836633f8fea5' ,0,0 ,2,23.00,50000,?,?,?)
20240502@213511.6050 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.6240 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213511.6290 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f973546633f8ff07','aut6633f930836633f8fea5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213511.6340 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213511.6380 8kjaerojtkaeumhos6i7ke6b8u Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240502@213511.6500 8kjaerojtkaeumhos6i7ke6b8u 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'
20240502@213511.6640 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.6790 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213511.7040 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.7190 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213511.7240 8kjaerojtkaeumhos6i7ke6b8u Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301208200a'
20240502@213511.7370 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213511.7480 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.7640 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213511.7980 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f677576633f8ff12',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6633f930836633f8fea5' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240502@213511.1131 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.1148 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213511.1153 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f677576633f8ff12','aut6633f930836633f8fea5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213511.1158 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.1174 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213511.1199 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.1212 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213511.1216 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213511.1228 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.1243 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213511.1270 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f701916633f8ff1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f930836633f8fea5' ,0,0 ,2,23.00,80000,?,?,?)
20240502@213511.1565 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.1582 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213511.1588 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f701916633f8ff1d','aut6633f930836633f8fea5' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213511.1593 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213511.1596 8kjaerojtkaeumhos6i7ke6b8u Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240502@213511.1608 8kjaerojtkaeumhos6i7ke6b8u 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'
20240502@213511.1622 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.1637 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213511.1670 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.1690 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213511.1696 8kjaerojtkaeumhos6i7ke6b8u Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301097100b'
20240502@213511.1702 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213511.1714 8kjaerojtkaeumhos6i7ke6b8u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.1727 8kjaerojtkaeumhos6i7ke6b8u Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213511.1764 8kjaerojtkaeumhos6i7ke6b8u Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f138406633f8ff29',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6633f930836633f8fea5' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240502@213511.2047 8kjaerojtkaeumhos6i7ke6b8u Query : use flama_phc
20240502@213511.2051 8kjaerojtkaeumhos6i7ke6b8u Query : select top 1 errorresult result ,errornumber errornumber ,errorcode code ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240502@213511.2062 8kjaerojtkaeumhos6i7ke6b8u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1475';
20240502@213511.2088 8kjaerojtkaeumhos6i7ke6b8u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1475';
20240502@213511.2539 2hckcecpgdv4ummkvn781so20e Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240502@213511.2552 2hckcecpgdv4ummkvn781so20e Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240502@213511.2576 2hckcecpgdv4ummkvn781so20e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1476';
20240502@213511.2624 2hckcecpgdv4ummkvn781so20e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1476';
20240502@213511.2643 2hckcecpgdv4ummkvn781so20e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1476';
20240502@213511.2660 2hckcecpgdv4ummkvn781so20e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1476';
20240502@213511.2676 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.2680 2hckcecpgdv4ummkvn781so20e Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240502@213511.2693 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.2696 2hckcecpgdv4ummkvn781so20e Query : select no, estab,szadrsdesc from szadrs where u_coddest=1899
20240502@213511.2786 2hckcecpgdv4ummkvn781so20e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240502@213511.2961 2hckcecpgdv4ummkvn781so20e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403151 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240502@213511.3852 2hckcecpgdv4ummkvn781so20e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240502@213511.4163 2hckcecpgdv4ummkvn781so20e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403151 and bi.ref ='324.1832.00.2' and bi.lordem =2
20240502@213511.4529 2hckcecpgdv4ummkvn781so20e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20240502@213511.4689 2hckcecpgdv4ummkvn781so20e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403151 and bi.ref ='324.1643.00.1' and bi.lordem =3
20240502@213511.5025 2hckcecpgdv4ummkvn781so20e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20240502@213511.5040 2hckcecpgdv4ummkvn781so20e Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403151 and bi.ref ='324.1643.00.1' and bi.lordem =4
20240502@213511.5481 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5485 2hckcecpgdv4ummkvn781so20e Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240502@213511.5498 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5501 2hckcecpgdv4ummkvn781so20e Query : select top 1 1 valor from td where td.ndoc = 39
20240502@213511.5511 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5514 2hckcecpgdv4ummkvn781so20e Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240502@213511.5524 2hckcecpgdv4ummkvn781so20e 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
20240502@213511.5538 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5541 2hckcecpgdv4ummkvn781so20e Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240502@213511.5654 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5657 2hckcecpgdv4ummkvn781so20e Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240502@213511.5667 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5670 2hckcecpgdv4ummkvn781so20e Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240502@213511.5681 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5684 2hckcecpgdv4ummkvn781so20e Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m'
20240502@213511.5696 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.5699 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from td where ndoc = 39
20240502@213511.5708 2hckcecpgdv4ummkvn781so20e Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240502@213511.5719 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213511.5734 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240502@213511.5753 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213511.5766 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240502@213511.5794 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213511.5808 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240502@213511.5817 2hckcecpgdv4ummkvn781so20e Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213511.5908 2hckcecpgdv4ummkvn781so20e Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213511.5918 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213511.5931 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240502@213511.5940 2hckcecpgdv4ummkvn781so20e Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6633f696496633f8ff8e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240502@213511.6121 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213511.6137 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240502@213511.6163 2hckcecpgdv4ummkvn781so20e Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240502@213511.6168 2hckcecpgdv4ummkvn781so20e Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240502@213511.6173 2hckcecpgdv4ummkvn781so20e Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240502@213511.6178 2hckcecpgdv4ummkvn781so20e Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240502@213511.6182 2hckcecpgdv4ummkvn781so20e Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240502@213511.6186 2hckcecpgdv4ummkvn781so20e Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240502@213511.6190 2hckcecpgdv4ummkvn781so20e Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6633f696496633f8ff8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240502@213511.6460 2hckcecpgdv4ummkvn781so20e Query : select top 1 fno valor from wsft039data order by fno desc
20240502@213511.6483 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213511.6498 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240502@213511.6516 2hckcecpgdv4ummkvn781so20e Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6633f696496633f8ff8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1171,101621,0,'2024-05-02',39,'euro',0,0,2024 ,'20240502','2205',?,?,?,?)
20240502@213511.6889 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.7906 2hckcecpgdv4ummkvn781so20e Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240502@213511.7989 2hckcecpgdv4ummkvn781so20e 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.1832.00.2'
20240502@213511.8154 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.8168 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213511.8192 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.8204 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213511.8208 2hckcecpgdv4ummkvn781so20e Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240502@213511.8225 2hckcecpgdv4ummkvn781so20e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213511.8235 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.8246 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213511.8268 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f608516633f8ffc9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6633f696496633f8ff8e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240502@213511.8524 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.8539 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213511.8544 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f608516633f8ffc9','aut6633f696496633f8ff8e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213511.8550 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.8639 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213511.8665 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.8679 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213511.8683 2hckcecpgdv4ummkvn781so20e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213511.8692 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.8993 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213511.9118 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f241376633f8ffd4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f696496633f8ff8e' ,0,0 ,2,23.00,20000,?,?,?)
20240502@213511.9442 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.9683 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213511.9740 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f241376633f8ffd4','aut6633f696496633f8ff8e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213511.9785 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213511.9794 2hckcecpgdv4ummkvn781so20e Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240502@213511.9815 2hckcecpgdv4ummkvn781so20e 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.1832.00.2'
20240502@213511.9827 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.9841 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213511.9916 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213511.9932 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213511.9937 2hckcecpgdv4ummkvn781so20e Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240502@213511.9947 2hckcecpgdv4ummkvn781so20e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213511.9956 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213511.9981 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213512.4000 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f679566633f8fff3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6633f696496633f8ff8e' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240502@213512.2850 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.3030 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213512.3070 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f679566633f8fff3','aut6633f696496633f8ff8e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213512.3130 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.3270 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213512.3780 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.3910 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213512.3960 2hckcecpgdv4ummkvn781so20e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213512.4070 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.4220 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213512.4610 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f057886633f90009',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f696496633f8ff8e' ,0,0 ,2,23.00,50000,?,?,?)
20240502@213512.7320 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.7510 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213512.7550 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f057886633f90009','aut6633f696496633f8ff8e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213512.7600 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213512.7630 2hckcecpgdv4ummkvn781so20e Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240502@213512.7770 2hckcecpgdv4ummkvn781so20e Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20240502@213512.9430 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.9590 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213512.9880 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.1001 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213512.1019 2hckcecpgdv4ummkvn781so20e Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240502@213512.1050 2hckcecpgdv4ummkvn781so20e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213512.1062 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.1077 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213512.1103 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f063826633f90019',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6633f696496633f8ff8e' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240502@213512.1367 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.1383 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213512.1387 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f063826633f90019','aut6633f696496633f8ff8e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213512.1392 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213512.1396 2hckcecpgdv4ummkvn781so20e Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240502@213512.1410 2hckcecpgdv4ummkvn781so20e Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20240502@213512.1422 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.1450 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213512.1477 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.1491 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213512.1495 2hckcecpgdv4ummkvn781so20e Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240502@213512.1505 2hckcecpgdv4ummkvn781so20e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213512.1515 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.1529 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213512.1555 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f036466633f90024',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6633f696496633f8ff8e' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240502@213512.1833 2hckcecpgdv4ummkvn781so20e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.1851 2hckcecpgdv4ummkvn781so20e Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213512.1856 2hckcecpgdv4ummkvn781so20e Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f036466633f90024','aut6633f696496633f8ff8e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213512.1861 2hckcecpgdv4ummkvn781so20e Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6633f696496633f8ff8e','2403151','wait',39,'ari17112337378,753000005')
20240502@213512.1878 2hckcecpgdv4ummkvn781so20e Query : use flama_phc
20240502@213512.1881 2hckcecpgdv4ummkvn781so20e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240502@213512.1893 2hckcecpgdv4ummkvn781so20e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1476';
20240502@213512.1916 2hckcecpgdv4ummkvn781so20e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1476';
20240502@213512.1935 2hckcecpgdv4ummkvn781so20e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1476';
20240502@213512.1952 2hckcecpgdv4ummkvn781so20e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1476';
20240502@213512.2401 g6as1f62otebmlpf65ent8092s Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240502@213512.2414 g6as1f62otebmlpf65ent8092s Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240502@213512.2439 g6as1f62otebmlpf65ent8092s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1477';
20240502@213512.2486 g6as1f62otebmlpf65ent8092s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1477';
20240502@213512.2505 g6as1f62otebmlpf65ent8092s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1477';
20240502@213512.2521 g6as1f62otebmlpf65ent8092s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1477';
20240502@213512.2539 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.2542 g6as1f62otebmlpf65ent8092s Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240502@213512.2556 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.2559 g6as1f62otebmlpf65ent8092s Query : select no, estab,szadrsdesc from szadrs where u_coddest=2014
20240502@213512.2658 g6as1f62otebmlpf65ent8092s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240502@213512.2669 g6as1f62otebmlpf65ent8092s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403156 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240502@213512.3045 g6as1f62otebmlpf65ent8092s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240502@213512.3060 g6as1f62otebmlpf65ent8092s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403156 and bi.ref ='324.1832.00.2' and bi.lordem =2
20240502@213512.3406 g6as1f62otebmlpf65ent8092s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20240502@213512.3418 g6as1f62otebmlpf65ent8092s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403156 and bi.ref ='324.1643.00.1' and bi.lordem =3
20240502@213512.4101 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.4143 g6as1f62otebmlpf65ent8092s Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240502@213512.4802 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.4843 g6as1f62otebmlpf65ent8092s Query : select top 1 1 valor from td where td.ndoc = 39
20240502@213512.5278 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.5442 g6as1f62otebmlpf65ent8092s Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240502@213512.5532 g6as1f62otebmlpf65ent8092s 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
20240502@213512.5550 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.5553 g6as1f62otebmlpf65ent8092s Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240502@213512.5563 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.5566 g6as1f62otebmlpf65ent8092s Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240502@213512.5576 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.5579 g6as1f62otebmlpf65ent8092s Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240502@213512.5589 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.5592 g6as1f62otebmlpf65ent8092s Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - guarda'
20240502@213512.5605 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.5647 g6as1f62otebmlpf65ent8092s Query : select 1 valor from td where ndoc = 39
20240502@213512.5704 g6as1f62otebmlpf65ent8092s Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240502@213512.5718 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213512.5733 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240502@213512.5751 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213512.5766 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240502@213512.5801 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213512.5817 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240502@213512.5829 g6as1f62otebmlpf65ent8092s Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213512.6131 g6as1f62otebmlpf65ent8092s Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213512.6235 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213512.6281 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240502@213512.6293 g6as1f62otebmlpf65ent8092s Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6633f756386633f9008e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240502@213512.6516 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213512.6706 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240502@213512.6860 g6as1f62otebmlpf65ent8092s Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240502@213512.6865 g6as1f62otebmlpf65ent8092s Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240502@213512.6870 g6as1f62otebmlpf65ent8092s Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240502@213512.6875 g6as1f62otebmlpf65ent8092s Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240502@213512.6880 g6as1f62otebmlpf65ent8092s Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240502@213512.6884 g6as1f62otebmlpf65ent8092s Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240502@213512.6889 g6as1f62otebmlpf65ent8092s Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6633f756386633f9008e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240502@213512.7424 g6as1f62otebmlpf65ent8092s Query : select top 1 fno valor from wsft039data order by fno desc
20240502@213512.7501 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213512.7517 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240502@213512.7563 g6as1f62otebmlpf65ent8092s Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6633f756386633f9008e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1172,101621,0,'2024-05-02',39,'euro',0,0,2024 ,'20240502','2205',?,?,?,?)
20240502@213512.7875 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.7879 g6as1f62otebmlpf65ent8092s Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240502@213512.7891 g6as1f62otebmlpf65ent8092s 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.1832.00.2'
20240502@213512.7904 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.8002 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213512.8031 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.8047 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213512.8052 g6as1f62otebmlpf65ent8092s Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240502@213512.8064 g6as1f62otebmlpf65ent8092s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213512.8075 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.8088 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213512.8113 g6as1f62otebmlpf65ent8092s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f902146633f900c5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6633f756386633f9008e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240502@213512.8387 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.8404 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213512.8408 g6as1f62otebmlpf65ent8092s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f902146633f900c5','aut6633f756386633f9008e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213512.8414 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.8427 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213512.8455 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.8469 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213512.8473 g6as1f62otebmlpf65ent8092s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213512.8484 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.8498 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213512.8523 g6as1f62otebmlpf65ent8092s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f129286633f900cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f756386633f9008e' ,0,0 ,2,23.00,20000,?,?,?)
20240502@213512.8790 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.8808 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213512.8823 g6as1f62otebmlpf65ent8092s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f129286633f900cf','aut6633f756386633f9008e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213512.8828 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213512.8831 g6as1f62otebmlpf65ent8092s Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240502@213512.8845 g6as1f62otebmlpf65ent8092s 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.1832.00.2'
20240502@213512.8857 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.8872 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213512.8902 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213512.8916 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213512.8921 g6as1f62otebmlpf65ent8092s Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240502@213512.8932 g6as1f62otebmlpf65ent8092s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213512.8943 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213512.8958 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213512.8984 g6as1f62otebmlpf65ent8092s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f291226633f900da',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6633f756386633f9008e' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240502@213512.9500 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213513.2130 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213513.2180 g6as1f62otebmlpf65ent8092s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f291226633f900da','aut6633f756386633f9008e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213513.2240 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213513.2400 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213513.2650 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213513.2790 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213513.2830 g6as1f62otebmlpf65ent8092s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213513.2940 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213513.3080 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213513.3470 g6as1f62otebmlpf65ent8092s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6633f498136633f90107',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6633f756386633f9008e' ,0,0 ,2,23.00,50000,?,?,?)
20240502@213513.6300 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213513.6500 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213513.6550 g6as1f62otebmlpf65ent8092s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f498136633f90107','aut6633f756386633f9008e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213513.6640 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213513.6690 g6as1f62otebmlpf65ent8092s Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240502@213513.6840 g6as1f62otebmlpf65ent8092s Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20240502@213513.6980 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213513.7120 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213513.7360 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213513.7490 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213513.7540 g6as1f62otebmlpf65ent8092s Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240502@213513.7640 g6as1f62otebmlpf65ent8092s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213513.7740 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213513.7870 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213513.8610 g6as1f62otebmlpf65ent8092s Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f021296633f90112',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut6633f756386633f9008e' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240502@213513.1235 g6as1f62otebmlpf65ent8092s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213513.1346 g6as1f62otebmlpf65ent8092s Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213513.1395 g6as1f62otebmlpf65ent8092s Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f021296633f90112','aut6633f756386633f9008e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213513.1413 g6as1f62otebmlpf65ent8092s Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6633f756386633f9008e','2403156','wait',39,'ari17112337378,753000005')
20240502@213513.1460 g6as1f62otebmlpf65ent8092s Query : use flama_phc
20240502@213513.1465 g6as1f62otebmlpf65ent8092s Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240502@213513.1478 g6as1f62otebmlpf65ent8092s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1477';
20240502@213513.1501 g6as1f62otebmlpf65ent8092s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1477';
20240502@213513.1519 g6as1f62otebmlpf65ent8092s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1477';
20240502@213513.1535 g6as1f62otebmlpf65ent8092s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1477';
20240502@213513.2101 ofsor7v3dcst7hnfpsodh8hucd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240502@213513.2122 ofsor7v3dcst7hnfpsodh8hucd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240502@213513.2148 ofsor7v3dcst7hnfpsodh8hucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1478';
20240502@213513.2199 ofsor7v3dcst7hnfpsodh8hucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1478';
20240502@213513.2218 ofsor7v3dcst7hnfpsodh8hucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1478';
20240502@213513.2236 ofsor7v3dcst7hnfpsodh8hucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1478';
20240502@213513.2251 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.2255 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240502@213513.2269 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.2272 ofsor7v3dcst7hnfpsodh8hucd Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20240502@213513.2362 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20240502@213513.2373 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403157 and bi.ref ='324.1643.00.1' and bi.lordem =1
20240502@213513.2782 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.2826 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240502@213513.2843 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.2847 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 1 valor from td where td.ndoc = 39
20240502@213513.2859 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.2863 ofsor7v3dcst7hnfpsodh8hucd Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240502@213513.2939 ofsor7v3dcst7hnfpsodh8hucd 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
20240502@213513.3108 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.3127 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240502@213513.3210 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.3217 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240502@213513.3324 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.3329 ofsor7v3dcst7hnfpsodh8hucd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240502@213513.3343 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.3346 ofsor7v3dcst7hnfpsodh8hucd Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - caldas da rainha'
20240502@213513.3362 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.3365 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from td where ndoc = 39
20240502@213513.3386 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240502@213513.3399 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213513.3414 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240502@213513.3432 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213513.3446 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240502@213513.3475 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213513.3490 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240502@213513.3502 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213513.3609 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213513.3620 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213513.3641 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240502@213513.3653 ofsor7v3dcst7hnfpsodh8hucd Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6633f643826633f90155' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240502@213513.3903 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213513.3919 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240502@213513.3951 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240502@213513.3956 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240502@213513.3962 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240502@213513.3968 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240502@213513.3973 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240502@213513.3978 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240502@213513.3983 ofsor7v3dcst7hnfpsodh8hucd Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6633f643826633f90155',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240502@213513.4400 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 fno valor from wsft039data order by fno desc
20240502@213513.4422 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213513.4437 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240502@213513.4454 ofsor7v3dcst7hnfpsodh8hucd Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6633f643826633f90155',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1173,101621,0,'2024-05-02',39,'euro',0,0,2024 ,'20240502','2205',?,?,?,?)
20240502@213513.4753 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.4758 ofsor7v3dcst7hnfpsodh8hucd Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240502@213513.4771 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20240502@213513.4788 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213513.4804 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240502@213513.5900 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213513.6000 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240502@213513.6005 ofsor7v3dcst7hnfpsodh8hucd Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240502@213513.6015 ofsor7v3dcst7hnfpsodh8hucd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240502@213513.6025 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240502@213513.6041 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240502@213513.6068 ofsor7v3dcst7hnfpsodh8hucd Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6633f597736633f90193',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut6633f643826633f90155' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240502@213513.6356 ofsor7v3dcst7hnfpsodh8hucd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240502@213513.6373 ofsor7v3dcst7hnfpsodh8hucd Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240502@213513.6378 ofsor7v3dcst7hnfpsodh8hucd Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6633f597736633f90193','aut6633f643826633f90155' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240502@213513.6384 ofsor7v3dcst7hnfpsodh8hucd Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6633f643826633f90155','2403157','wait',39,'ari17112337378,753000005')
20240502@213513.6405 ofsor7v3dcst7hnfpsodh8hucd Query : use flama_phc
20240502@213513.6408 ofsor7v3dcst7hnfpsodh8hucd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240502@213513.6419 ofsor7v3dcst7hnfpsodh8hucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1478';
20240502@213513.6521 ofsor7v3dcst7hnfpsodh8hucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1478';
20240502@213513.6541 ofsor7v3dcst7hnfpsodh8hucd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1478';
20240502@213513.6667 ofsor7v3dcst7hnfpsodh8hucd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1478';
20240502@213513.7065 sls8v0dhmva84huo63idg2bnl9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240502@213513.7080 sls8v0dhmva84huo63idg2bnl9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240502@213513.7105 sls8v0dhmva84huo63idg2bnl9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1479';
20240502@213513.7159 sls8v0dhmva84huo63idg2bnl9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1479';
20240502@213513.7178 sls8v0dhmva84huo63idg2bnl9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1479';
20240502@213513.7194 sls8v0dhmva84huo63idg2bnl9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1479';
20240502@213513.7209 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.7213 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240502@213513.7271 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.7274 sls8v0dhmva84huo63idg2bnl9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240502@213513.7392 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9345.00.1'
20240502@213513.7567 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2031 and bo.obrano = 2403166 and bi.ref ='328.9345.00.1' and bi.lordem =1
20240502@213513.7912 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.7916 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240502@213513.7930 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.7933 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 1 valor from td where td.ndoc = 39
20240502@213513.7945 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.7959 sls8v0dhmva84huo63idg2bnl9 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240502@213513.7971 sls8v0dhmva84huo63idg2bnl9 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
20240502@213513.7990 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.7993 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240502@213513.8003 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.8006 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240502@213513.8017 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.8019 sls8v0dhmva84huo63idg2bnl9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240502@213513.8032 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.8035 sls8v0dhmva84huo63idg2bnl9 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20240502@213513.8050 sls8v0dhmva84huo63idg2bnl9 Query : use flama_phc
20240502@213513.8053 sls8v0dhmva84huo63idg2bnl9 Query : select 1 valor from td where ndoc = 39
20240502@213513.8066 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240502@213513.8078 sls8v0dhmva84huo63idg2bnl9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240502@213513.8096 sls8v0dhmva84huo63idg2bnl9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240502@213513.8112 sls8v0dhmva84huo63idg2bnl9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240502@213513.8127 sls8v0dhmva84huo63idg2bnl9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240502@213513.8157 sls8v0dhmva84huo63idg2bnl9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213513.8171 sls8v0dhmva84huo63idg2bnl9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240502@213513.8181 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213513.8271 sls8v0dhmva84huo63idg2bnl9 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240502@213513.8282 sls8v0dhmva84huo63idg2bnl9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240502@213513.8298 sls8v0dhmva84huo63idg2bnl9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240502@213513.8309 sls8v0dhmva84huo63idg2bnl9 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6633f771246633f901c7' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240502@213513.8553 sls8v0dhmva84huo63idg2bnl9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
