20240923@181119.4522 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.4549 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.4564 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.4573 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.4587 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181119.4600 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.4615 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.4639 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a2464866f1a13770','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.4643 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.4659 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.4696 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a2464866f1a13770',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,520000,?,?,?,?,?)
20240923@181119.4969 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.4986 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.5013 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5031 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.5040 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.5052 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5068 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.5081 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a2883066f1a1377b','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.5085 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5102 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.5144 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a2883066f1a1377b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,530000,?,?,?)
20240923@181119.5422 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181119.5437 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181119.5460 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181119.5474 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5492 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.5522 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5536 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.5544 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.5556 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181119.5569 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5583 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.5595 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7887866f1a13787','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.5599 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5613 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.5642 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a7887866f1a13787',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,550000,?,?,?,?,?)
20240923@181119.5921 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5937 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.5965 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.5979 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.5987 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.6000 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6014 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.6025 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9085066f1a13792','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.6029 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6043 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.6071 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a9085066f1a13792',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,560000,?,?,?)
20240923@181119.6345 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181119.6348 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181119.6367 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181119.6386 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6402 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.6427 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6441 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.6449 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.6461 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181119.6476 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6506 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.6518 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a2545066f1a1379e','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.6522 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6546 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.6574 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a2545066f1a1379e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,580000,?,?,?,?,?)
20240923@181119.6841 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6859 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.6885 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6904 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.6913 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.6925 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6939 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.6950 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a2069166f1a137a9','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.6954 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.6969 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.6996 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a2069166f1a137a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,590000,?,?,?)
20240923@181119.7258 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181119.7264 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181119.7284 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181119.7299 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.7315 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.7340 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.7355 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.7364 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.7376 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181119.7388 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.7402 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.7414 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7402266f1a137b4','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.7418 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.7432 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.7459 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a7402266f1a137b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,610000,?,?,?,?,?)
20240923@181119.7921 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.7956 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.7982 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.7997 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.8006 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.8019 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.8033 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.8045 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1995566f1a137c3','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.8049 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.8063 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.8095 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a1995566f1a137c3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,620000,?,?,?)
20240923@181119.8354 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181119.8357 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181119.8377 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181119.8407 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.8424 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.8450 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.8469 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.8478 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.8490 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181119.8502 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.8517 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.8529 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a6747866f1a137cf','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.8533 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.8556 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.8588 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a6747866f1a137cf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,640000,?,?,?,?,?)
20240923@181119.9042 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9059 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.9086 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9105 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.9113 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.9125 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9139 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.9150 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7066466f1a137de','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.9154 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9169 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.9208 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a7066466f1a137de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,650000,?,?,?)
20240923@181119.9460 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181119.9462 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181119.9482 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181119.9495 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9510 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.9537 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9552 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.9563 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.9577 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181119.9590 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9604 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.9615 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1408466f1a137ea','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181119.9619 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9633 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.9673 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a1408466f1a137ea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,670000,?,?,?,?,?)
20240923@181119.9923 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9939 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181119.9964 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181119.9978 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181119.9986 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181119.9999 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.2600 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.3800 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3018166f1a137f4','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.4100 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6000 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.8700 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a3018166f1a137f4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,680000,?,?,?)
20240923@181120.3390 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.3420 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.3610 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.3740 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3890 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.4140 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4290 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.4510 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.4630 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.4760 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5160 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.5270 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a5610966f1a1380b','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.5310 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5450 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.9620 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a5610966f1a1380b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,700000,?,?,?,?,?)
20240923@181120.2581 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.2598 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.2623 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.2637 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.2645 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.2657 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.2671 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.2683 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1257666f1a13840','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.2688 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.2702 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.2731 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a1257666f1a13840',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,710000,?,?,?)
20240923@181120.2997 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.3000 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.3019 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.3032 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3047 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.3071 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3086 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.3094 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.3105 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.3135 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3150 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.3162 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a4387366f1a1384c','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.3166 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3181 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.3208 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a4387366f1a1384c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,730000,?,?,?,?,?)
20240923@181120.3485 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3499 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.3525 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3539 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.3556 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.3568 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3583 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.3595 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0602666f1a13857','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.3599 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3613 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.3646 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a0602666f1a13857',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,740000,?,?,?)
20240923@181120.3907 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.3911 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.3929 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.3944 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.3961 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.3986 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4000 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.4009 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.4021 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.4034 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4048 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.4059 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3982866f1a13862','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.4063 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4078 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.4105 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3982866f1a13862',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,760000,?,?,?,?,?)
20240923@181120.4457 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4474 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.4504 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4518 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.4527 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.4538 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4552 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.4564 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a8662566f1a1386e','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.4568 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4598 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.4628 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a8662566f1a1386e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,770000,?,?,?)
20240923@181120.4883 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.4886 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.4905 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.4919 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4934 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.4959 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.4974 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.4982 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.4999 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.5012 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5026 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.5037 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a2025366f1a1387a','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.5041 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5055 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.5107 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a2025366f1a1387a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,790000,?,?,?,?,?)
20240923@181120.5374 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5389 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.5414 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5428 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.5437 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.5450 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5484 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.5495 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9254266f1a13885','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.5499 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5517 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.5544 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a9254266f1a13885',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,800000,?,?,?)
20240923@181120.5797 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.5800 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.5820 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.5836 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5851 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.5891 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5906 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.5914 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.5925 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.5937 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5951 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.5963 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a6497966f1a13890','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.5967 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.5981 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.6008 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a6497966f1a13890',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,820000,?,?,?,?,?)
20240923@181120.6263 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6279 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.6305 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6319 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.6328 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.6360 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6374 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.6387 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7680466f1a1389b','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.6391 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6405 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.6434 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a7680466f1a1389b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,830000,?,?,?)
20240923@181120.6708 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.6711 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.6732 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.6745 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6760 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.6785 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6816 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.6825 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.6838 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.6850 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6865 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.6876 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9065566f1a138a7','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.6880 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.6895 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.6922 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a9065566f1a138a7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,850000,?,?,?,?,?)
20240923@181120.7191 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7206 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.7232 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7246 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.7255 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.7267 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7298 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.7311 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a6991466f1a138b1','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.7316 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7371 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.7426 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a6991466f1a138b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,860000,?,?,?)
20240923@181120.7714 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.7717 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.7736 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.7749 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7765 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.7790 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7805 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.7813 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.7825 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.7837 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7851 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.7863 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3450866f1a138bf','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.7867 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.7881 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.7907 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3450866f1a138bf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,880000,?,?,?,?,?)
20240923@181120.9313 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9331 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.9355 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9370 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.9378 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.9389 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9409 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.9420 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7296166f1a138e5','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.9425 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9439 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.9466 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a7296166f1a138e5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,890000,?,?,?)
20240923@181120.9745 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181120.9749 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181120.9767 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181120.9781 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9796 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.9821 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9838 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.9846 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181120.9858 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181120.9870 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9883 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181120.9894 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a5511966f1a138f0','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181120.9898 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181120.9912 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181120.9938 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a5511966f1a138f0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,910000,?,?,?,?,?)
20240923@181121.1990 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.2140 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.2380 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.2520 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.2600 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.2720 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.2860 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.2970 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a6039066f1a13906','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.3010 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.3160 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.3430 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a6039066f1a13906',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,920000,?,?,?)
20240923@181121.5870 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181121.5900 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181121.6090 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181121.6220 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.6500 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.6760 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.6910 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.6990 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.7100 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181121.7230 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.7370 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.7480 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3269766f1a13911','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.7520 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.7660 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.7930 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3269766f1a13911',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,940000,?,?,?,?,?)
20240923@181121.1072 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1094 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.1119 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1134 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.1142 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.1153 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1167 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.1179 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0690266f1a1391c','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.1183 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1213 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.1242 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a0690266f1a1391c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,950000,?,?,?)
20240923@181121.1501 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181121.1504 9mocrfkjgik2japdmert0bebri Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20240923@181121.1523 9mocrfkjgik2japdmert0bebri Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1824.00.1'
20240923@181121.1535 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1550 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.1574 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1605 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.1613 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.1625 9mocrfkjgik2japdmert0bebri Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2301209200a'
20240923@181121.1638 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1652 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.1663 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a6240366f1a13928','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.1667 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1681 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.1709 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a6240366f1a13928',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,970000,?,?,?,?,?)
20240923@181121.1961 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.1976 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.2000 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.2014 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.2022 9mocrfkjgik2japdmert0bebri Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.2034 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.2063 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.2076 9mocrfkjgik2japdmert0bebri Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1517266f1a13931','aut66f1a2334366f1a13560' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.2081 9mocrfkjgik2japdmert0bebri Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.2097 9mocrfkjgik2japdmert0bebri Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.2148 9mocrfkjgik2japdmert0bebri Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a1517266f1a13931',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a2334366f1a13560' ,0,0 ,2,23.00,980000,?,?,?)
20240923@181121.2421 9mocrfkjgik2japdmert0bebri Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a2334366f1a13560','2406165','wait',39,'adm09112754980.682000002')
20240923@181121.2531 9mocrfkjgik2japdmert0bebri Query : use flama_phc
20240923@181121.2535 9mocrfkjgik2japdmert0bebri Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181121.2563 9mocrfkjgik2japdmert0bebri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2178';
20240923@181121.2593 9mocrfkjgik2japdmert0bebri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2178';
20240923@181121.2637 9mocrfkjgik2japdmert0bebri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2178';
20240923@181121.2665 9mocrfkjgik2japdmert0bebri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2178';
20240923@181121.4404 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181121.4414 cnd7lr5trpv0oqcsa9kf9arij8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181121.4469 cnd7lr5trpv0oqcsa9kf9arij8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2179';
20240923@181121.4540 cnd7lr5trpv0oqcsa9kf9arij8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2179';
20240923@181121.4595 cnd7lr5trpv0oqcsa9kf9arij8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2179';
20240923@181121.4620 cnd7lr5trpv0oqcsa9kf9arij8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2179';
20240923@181121.4669 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.4672 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181121.4784 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.4788 cnd7lr5trpv0oqcsa9kf9arij8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=5546
20240923@181121.4880 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4930.00.1'
20240923@181121.5062 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406169 and bi.ref ='324.4930.00.1' and bi.lordem =1
20240923@181121.5403 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.727.00.01'
20240923@181121.5426 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406169 and bi.ref ='324.727.00.01' and bi.lordem =2
20240923@181121.5734 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240923@181121.5756 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406169 and bi.ref ='324.5343.00.1' and bi.lordem =3
20240923@181121.6064 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6067 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181121.6142 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6145 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181121.6178 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6181 cnd7lr5trpv0oqcsa9kf9arij8 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240923@181121.6209 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240923@181121.6246 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6249 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 ~inactivo valor from cl where no = '199506' and estab = 0 order by inactivo desc
20240923@181121.6370 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6373 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181121.6422 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6426 cnd7lr5trpv0oqcsa9kf9arij8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181121.6470 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6474 cnd7lr5trpv0oqcsa9kf9arij8 Query : select szadrsstamp valor from szadrs where szadrsdesc='199506 - itmp alimentar, s.a.'
20240923@181121.6521 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.6524 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from td where ndoc = 39
20240923@181121.6536 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181121.6551 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.6566 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181121.6586 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.6602 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181121.6642 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.6658 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181121.6671 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181121.6738 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181121.6751 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.6766 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181121.6781 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a6528266f1a139a2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181121.6957 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.6988 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181121.7021 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181121.7033 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181121.7245 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181121.7360 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181121.7375 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181121.7388 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181121.7403 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a6528266f1a139a2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181121.7657 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181121.7677 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.7694 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181121.7718 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 'normal' from dummy
20240923@181121.7763 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a6528266f1a139a2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',910,199506,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181121.8062 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.8065 cnd7lr5trpv0oqcsa9kf9arij8 Query : select st.usalote valor from st where st.ref = '324.4930.00.1'
20240923@181121.8086 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4930.00.1'
20240923@181121.8248 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8264 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.8291 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8309 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.8317 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.8331 cnd7lr5trpv0oqcsa9kf9arij8 Query : select sestamp valor from se where ref ='324.4930.00.1' and lote = 'r2400066200a'
20240923@181121.8345 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8359 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.8371 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3654166f1a139cb','aut66f1a6528266f1a139a2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.8383 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8397 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.8438 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a3654166f1a139cb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66f1a6528266f1a139a2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181121.8714 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.8717 cnd7lr5trpv0oqcsa9kf9arij8 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240923@181121.8737 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240923@181121.8754 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8769 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.8823 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8838 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.8848 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.8862 cnd7lr5trpv0oqcsa9kf9arij8 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2400239200a'
20240923@181121.8877 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8892 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.8906 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a9449366f1a139d8','aut66f1a6528266f1a139a2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.8911 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.8940 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.8982 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a9449366f1a139d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a6528266f1a139a2' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240923@181121.9404 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.9445 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.9474 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.9495 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.9512 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181121.9525 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.9539 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181121.9550 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0009466f1a139e8','aut66f1a6528266f1a139a2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181121.9561 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.9578 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.9617 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a0009466f1a139e8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a6528266f1a139a2' ,0,0 ,2,23.00,30000,?,?,?)
20240923@181121.9911 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181121.9914 cnd7lr5trpv0oqcsa9kf9arij8 Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240923@181121.9932 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5343.00.1'
20240923@181121.9947 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181121.9963 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181121.9992 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.6000 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.1500 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181122.2600 cnd7lr5trpv0oqcsa9kf9arij8 Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240923@181122.3800 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.5200 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.8000 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a5554266f1a13a00','aut66f1a6528266f1a139a2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181122.8400 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.9800 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181122.1250 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a5554266f1a13a00',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66f1a6528266f1a139a2' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240923@181122.4290 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.4440 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181122.4680 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.4920 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.5020 cnd7lr5trpv0oqcsa9kf9arij8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181122.5160 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.5310 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.5420 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a3994666f1a13a0c','aut66f1a6528266f1a139a2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181122.5460 cnd7lr5trpv0oqcsa9kf9arij8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.5590 cnd7lr5trpv0oqcsa9kf9arij8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181122.5870 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a3994666f1a13a0c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a6528266f1a139a2' ,0,0 ,2,23.00,60000,?,?,?)
20240923@181122.8390 cnd7lr5trpv0oqcsa9kf9arij8 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a6528266f1a139a2','2406169','wait',39,'adm09112754980.682000002')
20240923@181122.9360 cnd7lr5trpv0oqcsa9kf9arij8 Query : use flama_phc
20240923@181122.9410 cnd7lr5trpv0oqcsa9kf9arij8 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181122.9730 cnd7lr5trpv0oqcsa9kf9arij8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2179';
20240923@181122.1016 cnd7lr5trpv0oqcsa9kf9arij8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2179';
20240923@181122.1070 cnd7lr5trpv0oqcsa9kf9arij8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2179';
20240923@181122.1136 cnd7lr5trpv0oqcsa9kf9arij8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2179';
20240923@181122.1909 vhsbqpp6qtb8fleeldehasp054 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181122.1923 vhsbqpp6qtb8fleeldehasp054 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181122.1980 vhsbqpp6qtb8fleeldehasp054 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2180';
20240923@181122.2033 vhsbqpp6qtb8fleeldehasp054 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2180';
20240923@181122.2090 vhsbqpp6qtb8fleeldehasp054 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2180';
20240923@181122.2114 vhsbqpp6qtb8fleeldehasp054 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2180';
20240923@181122.2172 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.2175 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181122.2247 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.2250 vhsbqpp6qtb8fleeldehasp054 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3080
20240923@181122.2293 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5501.00.1'
20240923@181122.2454 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406174 and bi.ref ='324.5501.00.1' and bi.lordem =2
20240923@181122.2779 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.2782 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181122.2829 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.2832 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181122.2867 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.2871 vhsbqpp6qtb8fleeldehasp054 Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240923@181122.2909 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240923@181122.2945 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.2948 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240923@181122.2979 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.2982 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181122.3011 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.3014 vhsbqpp6qtb8fleeldehasp054 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181122.3074 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.3077 vhsbqpp6qtb8fleeldehasp054 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda- barcelos entrega'
20240923@181122.3126 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.3129 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from td where ndoc = 39
20240923@181122.3141 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181122.3154 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.3170 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181122.3188 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.3202 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181122.3241 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.3255 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181122.3268 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181122.3337 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181122.3349 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.3363 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181122.3378 vhsbqpp6qtb8fleeldehasp054 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a0507966f1a13a4f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181122.3563 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.3593 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181122.3624 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181122.3660 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181122.3672 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181122.3683 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181122.3695 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181122.3706 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181122.3717 vhsbqpp6qtb8fleeldehasp054 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a0507966f1a13a4f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181122.3994 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181122.4015 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.4030 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181122.4051 vhsbqpp6qtb8fleeldehasp054 Query : select 'normal' from dummy
20240923@181122.4065 vhsbqpp6qtb8fleeldehasp054 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a0507966f1a13a4f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',911,101621,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181122.4371 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.4374 vhsbqpp6qtb8fleeldehasp054 Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20240923@181122.4394 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5501.00.1'
20240923@181122.4560 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.4579 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181122.4609 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.4624 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.4632 vhsbqpp6qtb8fleeldehasp054 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181122.4643 vhsbqpp6qtb8fleeldehasp054 Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2300908100a'
20240923@181122.4663 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.4678 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.4689 vhsbqpp6qtb8fleeldehasp054 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a7875766f1a13a71','aut66f1a0507966f1a13a4f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181122.4693 vhsbqpp6qtb8fleeldehasp054 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.4724 vhsbqpp6qtb8fleeldehasp054 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181122.4754 vhsbqpp6qtb8fleeldehasp054 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a7875766f1a13a71',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a0507966f1a13a4f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181122.5027 vhsbqpp6qtb8fleeldehasp054 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66f1a0507966f1a13a4f','2406174','wait',39,'adm09112754980.682000002')
20240923@181122.5113 vhsbqpp6qtb8fleeldehasp054 Query : use flama_phc
20240923@181122.5116 vhsbqpp6qtb8fleeldehasp054 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240923@181122.5150 vhsbqpp6qtb8fleeldehasp054 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2180';
20240923@181122.5186 vhsbqpp6qtb8fleeldehasp054 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2180';
20240923@181122.5235 vhsbqpp6qtb8fleeldehasp054 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2180';
20240923@181122.5259 vhsbqpp6qtb8fleeldehasp054 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2180';
20240923@181122.5768 f1gjl0f456in7kagdbalu5momt Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240923@181122.5780 f1gjl0f456in7kagdbalu5momt Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240923@181122.5862 f1gjl0f456in7kagdbalu5momt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2181';
20240923@181122.6010 f1gjl0f456in7kagdbalu5momt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2181';
20240923@181122.6076 f1gjl0f456in7kagdbalu5momt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2181';
20240923@181122.6105 f1gjl0f456in7kagdbalu5momt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2181';
20240923@181122.6155 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.6159 f1gjl0f456in7kagdbalu5momt Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240923@181122.6225 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.6228 f1gjl0f456in7kagdbalu5momt Query : select no, estab,szadrsdesc from szadrs where u_coddest=737
20240923@181122.6306 f1gjl0f456in7kagdbalu5momt Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240923@181122.6468 f1gjl0f456in7kagdbalu5momt Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406178 and bi.ref ='304.421.00.04' and bi.lordem =1
20240923@181122.6805 f1gjl0f456in7kagdbalu5momt 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'
20240923@181122.6826 f1gjl0f456in7kagdbalu5momt Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406178 and bi.ref ='324.1824.00.1' and bi.lordem =2
20240923@181122.7143 f1gjl0f456in7kagdbalu5momt Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4020.00.1'
20240923@181122.7303 f1gjl0f456in7kagdbalu5momt Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406178 and bi.ref ='304.4020.00.1' and bi.lordem =3
20240923@181122.7645 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.7648 f1gjl0f456in7kagdbalu5momt Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240923@181122.7682 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.7685 f1gjl0f456in7kagdbalu5momt Query : select top 1 1 valor from td where td.ndoc = 39
20240923@181122.7715 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.7718 f1gjl0f456in7kagdbalu5momt Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240923@181122.7746 f1gjl0f456in7kagdbalu5momt Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240923@181122.7784 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.7787 f1gjl0f456in7kagdbalu5momt Query : select top 1 ~inactivo valor from cl where no = '101249' and estab = 0 order by inactivo desc
20240923@181122.7927 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.7930 f1gjl0f456in7kagdbalu5momt Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240923@181122.7961 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.7964 f1gjl0f456in7kagdbalu5momt Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240923@181122.8005 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.8008 f1gjl0f456in7kagdbalu5momt Query : select szadrsstamp valor from szadrs where szadrsdesc='somusica-comercio de som, lda.'
20240923@181122.8060 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.8063 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from td where ndoc = 39
20240923@181122.8093 f1gjl0f456in7kagdbalu5momt Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240923@181122.8106 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.8123 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181122.8142 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.8172 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181122.8201 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.8216 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181122.8230 f1gjl0f456in7kagdbalu5momt Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181122.8295 f1gjl0f456in7kagdbalu5momt Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240923@181122.8307 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.8323 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240923@181122.8342 f1gjl0f456in7kagdbalu5momt Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f1a0827866f1a13ac8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240923@181122.8520 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.8536 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240923@181122.8569 f1gjl0f456in7kagdbalu5momt Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240923@181122.8581 f1gjl0f456in7kagdbalu5momt Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240923@181122.8593 f1gjl0f456in7kagdbalu5momt Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240923@181122.8605 f1gjl0f456in7kagdbalu5momt Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240923@181122.8616 f1gjl0f456in7kagdbalu5momt Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240923@181122.8629 f1gjl0f456in7kagdbalu5momt Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240923@181122.8640 f1gjl0f456in7kagdbalu5momt Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66f1a0827866f1a13ac8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240923@181122.8896 f1gjl0f456in7kagdbalu5momt Query : select top 1 fno valor from wsftdata order by fno desc
20240923@181122.8916 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.8933 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240923@181122.8960 f1gjl0f456in7kagdbalu5momt Query : select 'normal' from dummy
20240923@181122.8975 f1gjl0f456in7kagdbalu5momt Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66f1a0827866f1a13ac8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',912,101249,0,'2024-09-23',39,'euro',0,0,2024 ,?,?)
20240923@181122.9285 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181122.9288 f1gjl0f456in7kagdbalu5momt Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240923@181122.9311 f1gjl0f456in7kagdbalu5momt Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240923@181122.9605 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.9645 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181122.9670 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.9685 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.9694 f1gjl0f456in7kagdbalu5momt Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181122.9706 f1gjl0f456in7kagdbalu5momt Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '241001'
20240923@181122.9720 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.9735 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181122.9747 f1gjl0f456in7kagdbalu5momt Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a1872966f1a13aed','aut66f1a0827866f1a13ac8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181122.9751 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181122.9766 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181122.9796 f1gjl0f456in7kagdbalu5momt Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66f1a1872966f1a13aed',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66f1a0827866f1a13ac8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240923@181123.8300 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181123.9800 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181123.1250 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181123.1440 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181123.1540 f1gjl0f456in7kagdbalu5momt Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240923@181123.1680 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181123.1830 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240923@181123.1960 f1gjl0f456in7kagdbalu5momt Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f1a0929966f1a13b04','aut66f1a0827866f1a13ac8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240923@181123.2000 f1gjl0f456in7kagdbalu5momt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240923@181123.2160 f1gjl0f456in7kagdbalu5momt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240923@181123.2470 f1gjl0f456in7kagdbalu5momt Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66f1a0929966f1a13b04',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66f1a0827866f1a13ac8' ,0,0 ,2,23.00,20000,?,?,?)
20240923@181123.5080 f1gjl0f456in7kagdbalu5momt Query : use flama_phc
20240923@181123.5110 f1gjl0f456in7kagdbalu5momt Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
