20240802@184235.9041 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184235.9062 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184235.9073 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184235.9089 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240802@184235.9106 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184235.9122 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184235.9135 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad19001366ad1a8bde','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184235.9139 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184235.9154 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184235.9208 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad19001366ad1a8bde',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,130000,?,?,?,?)
20240802@184235.9479 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184235.9497 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184235.9526 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184235.9542 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184235.9551 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184235.9564 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184235.9582 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184235.9595 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad13152666ad1a8be9','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184235.9600 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184235.9615 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184235.9646 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad13152666ad1a8be9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,140000,?,?,?)
20240802@184235.9955 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184235.9958 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240802@184235.9980 af8tqcp8i61c9ufdc39j1ukrlp 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.1816.00.1'
20240802@184235.9995 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1100 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.3900 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.5600 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.6600 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.7900 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240802@184236.9300 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1080 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.1200 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad19034566ad1a8c02','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.1250 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1400 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.1700 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad19034566ad1a8c02',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,160000,?,?,?,?)
20240802@184236.4790 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4970 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.5270 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.5430 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.5520 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.5650 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.5810 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.5930 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad16806066ad1a8c0d','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.5980 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.6130 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.6440 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad16806066ad1a8c0d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,170000,?,?,?)
20240802@184236.9130 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.9160 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240802@184236.9380 af8tqcp8i61c9ufdc39j1ukrlp 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.1816.00.1'
20240802@184236.9530 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.9700 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.1028 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1043 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.1053 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.1066 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240802@184236.1080 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1095 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.1107 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad13648566ad1a8c1a','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.1112 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1127 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.1163 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad13648566ad1a8c1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,190000,?,?,?,?)
20240802@184236.1456 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1473 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.1501 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1516 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.1525 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.1538 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.1556 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.1569 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad17265366ad1a8c25','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.1574 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.2723 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.2758 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad17265366ad1a8c25',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,200000,?,?,?)
20240802@184236.3373 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.3513 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240802@184236.3541 af8tqcp8i61c9ufdc39j1ukrlp 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.1816.00.1'
20240802@184236.3556 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.3573 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.3598 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.3613 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.3622 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.3635 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240802@184236.3651 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.3670 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.3682 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad12231066ad1a8c59','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.3687 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.3701 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.3730 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad12231066ad1a8c59',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,220000,?,?,?,?)
20240802@184236.4024 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4042 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.4071 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4086 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.4095 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.4108 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4123 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.4136 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad11279666ad1a8c64','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.4140 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4155 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.4184 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad11279666ad1a8c64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,230000,?,?,?)
20240802@184236.4443 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.4447 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240802@184236.4470 af8tqcp8i61c9ufdc39j1ukrlp 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.1816.00.1'
20240802@184236.4486 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4505 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.4549 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4565 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.4575 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.4589 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240802@184236.4603 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4618 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.4630 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad14055966ad1a8c70','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.4635 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4650 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.4681 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad14055966ad1a8c70',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,250000,?,?,?,?)
20240802@184236.4977 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.4995 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.5022 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.5037 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.5046 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.5059 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.5074 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.5087 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad14780566ad1a8c7b','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.5091 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.5106 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.5136 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad14780566ad1a8c7b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,260000,?,?,?)
20240802@184236.5420 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.5966 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.4962.00.1'
20240802@184236.6483 af8tqcp8i61c9ufdc39j1ukrlp 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.4962.00.1'
20240802@184236.6783 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.6800 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.6827 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.6842 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.6851 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.6863 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.4962.00.1' and lote = 'r2101092100a'
20240802@184236.6898 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.6915 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.6929 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad15075466ad1a8ca8','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.6934 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.6951 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.6980 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad15075466ad1a8ca8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,280000,?,?,?,?)
20240802@184236.7278 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.7282 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20240802@184236.7305 af8tqcp8i61c9ufdc39j1ukrlp 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.4970.00.1'
20240802@184236.7320 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.7339 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.7365 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.7387 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.7396 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.7409 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20240802@184236.7422 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.7437 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.7451 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad13328966ad1a8cb5','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.7456 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.7479 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.7513 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad13328966ad1a8cb5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,290000,?,?,?,?)
20240802@184236.7808 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.7812 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240802@184236.7837 af8tqcp8i61c9ufdc39j1ukrlp 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.4521.00.1'
20240802@184236.8005 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8024 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.8055 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8073 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.8083 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.8096 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240802@184236.8113 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8131 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.8144 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad14010966ad1a8cc6','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.8149 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8168 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.8200 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad14010966ad1a8cc6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,300000,?,?,?,?)
20240802@184236.8501 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.8505 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240802@184236.8527 af8tqcp8i61c9ufdc39j1ukrlp 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.4521.00.1'
20240802@184236.8543 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8562 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.8591 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8609 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.8620 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.8634 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240802@184236.8649 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8666 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.8685 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad18266866ad1a8cd3','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.8691 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.8707 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.8741 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad18266866ad1a8cd3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,310000,?,?,?,?)
20240802@184236.9070 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.9073 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20240802@184236.9096 af8tqcp8i61c9ufdc39j1ukrlp 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.966.00.01'
20240802@184236.9112 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.9130 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.9160 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.9178 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.9189 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184236.9204 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2301193200a'
20240802@184236.9220 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.9237 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184236.9250 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad15767266ad1a8ce1','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184236.9255 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184236.9275 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184236.9306 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad15767266ad1a8ce1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,320000,?,?,?,?)
20240802@184236.9577 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184236.9581 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240802@184236.9602 af8tqcp8i61c9ufdc39j1ukrlp 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.945.00.01'
20240802@184236.9618 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.7390 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184237.8100 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.9570 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.9670 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184237.9810 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240802@184237.9940 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.1010 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.1046 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad15771866ad1a8d18','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184237.1052 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.1070 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184237.1144 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad15771866ad1a8d18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,330000,?,?,?,?)
20240802@184237.1728 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184237.1887 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.1406.00.1'
20240802@184237.1912 af8tqcp8i61c9ufdc39j1ukrlp 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.1406.00.1'
20240802@184237.1929 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.1947 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184237.1977 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.1993 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.2003 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184237.2016 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.1406.00.1' and lote = '10/20'
20240802@184237.2030 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.2046 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.2059 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad18082766ad1a8d31','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184237.2064 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.2080 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184237.2113 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad18082766ad1a8d31',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66ad15624466ad1a8add' ,0,0 ,2,23.00,340000,?,?,?,?)
20240802@184237.2427 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184237.2430 af8tqcp8i61c9ufdc39j1ukrlp Query : select st.usalote valor from st where st.ref = '324.2231.00.2'
20240802@184237.2453 af8tqcp8i61c9ufdc39j1ukrlp 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.2231.00.2'
20240802@184237.2469 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.2489 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184237.2518 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.2534 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.2544 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184237.2573 af8tqcp8i61c9ufdc39j1ukrlp Query : select sestamp valor from se where ref ='324.2231.00.2' and lote = 'r2300389200a'
20240802@184237.2582 af8tqcp8i61c9ufdc39j1ukrlp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.2599 af8tqcp8i61c9ufdc39j1ukrlp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.2611 af8tqcp8i61c9ufdc39j1ukrlp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad19010766ad1a8d3f','aut66ad15624466ad1a8add' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184237.2640 af8tqcp8i61c9ufdc39j1ukrlp Query : use flama_phc
20240802@184237.2643 af8tqcp8i61c9ufdc39j1ukrlp Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20240802@184237.2680 af8tqcp8i61c9ufdc39j1ukrlp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1384';
20240802@184237.2708 af8tqcp8i61c9ufdc39j1ukrlp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1384';
20240802@184237.3310 e659pti5p00jbma92t0gutnccd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240802@184237.3342 e659pti5p00jbma92t0gutnccd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240802@184237.3402 e659pti5p00jbma92t0gutnccd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240802@184237.3457 e659pti5p00jbma92t0gutnccd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240802@184237.3518 e659pti5p00jbma92t0gutnccd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240802@184237.3545 e659pti5p00jbma92t0gutnccd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240802@184237.3608 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.3612 e659pti5p00jbma92t0gutnccd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240802@184237.3691 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.3695 e659pti5p00jbma92t0gutnccd Query : select no, estab,szadrsdesc from szadrs where u_coddest=435
20240802@184237.3786 e659pti5p00jbma92t0gutnccd Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4521.00.1'
20240802@184237.3811 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.3815 e659pti5p00jbma92t0gutnccd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240802@184237.3864 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.3867 e659pti5p00jbma92t0gutnccd Query : select top 1 1 valor from td where td.ndoc = 39
20240802@184237.3905 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.3908 e659pti5p00jbma92t0gutnccd 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')
20240802@184237.3945 e659pti5p00jbma92t0gutnccd 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
20240802@184237.3990 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.3994 e659pti5p00jbma92t0gutnccd Query : select top 1 ~inactivo valor from cl where no = '101646' and estab = 0 order by inactivo desc
20240802@184237.4137 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.4141 e659pti5p00jbma92t0gutnccd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240802@184237.4179 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.4182 e659pti5p00jbma92t0gutnccd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240802@184237.4235 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.4249 e659pti5p00jbma92t0gutnccd Query : select szadrsstamp valor from szadrs where szadrsdesc='normendes-equipamento domesticos,lda'
20240802@184237.4310 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.4313 e659pti5p00jbma92t0gutnccd Query : select 1 valor from td where ndoc = 39
20240802@184237.4326 e659pti5p00jbma92t0gutnccd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240802@184237.4342 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.4358 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240802@184237.4379 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.4396 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240802@184237.4426 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.4442 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240802@184237.4456 e659pti5p00jbma92t0gutnccd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240802@184237.4598 e659pti5p00jbma92t0gutnccd Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240802@184237.4613 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.4630 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240802@184237.4649 e659pti5p00jbma92t0gutnccd Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66ad14360166ad1a8d6c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240802@184237.4838 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.5512 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240802@184237.5716 e659pti5p00jbma92t0gutnccd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240802@184237.5732 e659pti5p00jbma92t0gutnccd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240802@184237.5748 e659pti5p00jbma92t0gutnccd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240802@184237.5763 e659pti5p00jbma92t0gutnccd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240802@184237.5778 e659pti5p00jbma92t0gutnccd Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240802@184237.5792 e659pti5p00jbma92t0gutnccd Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240802@184237.5804 e659pti5p00jbma92t0gutnccd Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66ad14360166ad1a8d6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240802@184237.6071 e659pti5p00jbma92t0gutnccd Query : select top 1 fno valor from wsftdata order by fno desc
20240802@184237.6090 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.6113 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240802@184237.6137 e659pti5p00jbma92t0gutnccd Query : select 'normal' from dummy
20240802@184237.6155 e659pti5p00jbma92t0gutnccd Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66ad14360166ad1a8d6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',213,101646,0,'2024-08-02',39,'euro',0,0,2024 ,?,?)
20240802@184237.7507 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.7513 e659pti5p00jbma92t0gutnccd Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240802@184237.7537 e659pti5p00jbma92t0gutnccd 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.4521.00.1'
20240802@184237.7555 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.7573 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184237.7605 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.7621 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.7630 e659pti5p00jbma92t0gutnccd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184237.7643 e659pti5p00jbma92t0gutnccd Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240802@184237.7656 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.7671 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184237.7683 e659pti5p00jbma92t0gutnccd Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad12010666ad1a8dba','aut66ad14360166ad1a8d6c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184237.7688 e659pti5p00jbma92t0gutnccd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184237.7704 e659pti5p00jbma92t0gutnccd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184237.7739 e659pti5p00jbma92t0gutnccd Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad12010666ad1a8dba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66ad14360166ad1a8d6c' ,0,0 ,2,23.00,10000,?,?,?,?)
20240802@184237.8009 e659pti5p00jbma92t0gutnccd Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66ad14360166ad1a8d6c','2405209','wait',39,'adm09112754980.682000002')
20240802@184237.8083 e659pti5p00jbma92t0gutnccd Query : use flama_phc
20240802@184237.8087 e659pti5p00jbma92t0gutnccd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240802@184237.8118 e659pti5p00jbma92t0gutnccd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240802@184237.8147 e659pti5p00jbma92t0gutnccd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240802@184237.8189 e659pti5p00jbma92t0gutnccd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1385';
20240802@184237.8255 e659pti5p00jbma92t0gutnccd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1385';
20240802@184237.8853 6oitjl5rg41jgoe58aei2qq24h Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240802@184237.8864 6oitjl5rg41jgoe58aei2qq24h Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240802@184237.8913 6oitjl5rg41jgoe58aei2qq24h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1386';
20240802@184237.8965 6oitjl5rg41jgoe58aei2qq24h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1386';
20240802@184237.9013 6oitjl5rg41jgoe58aei2qq24h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1386';
20240802@184237.9039 6oitjl5rg41jgoe58aei2qq24h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1386';
20240802@184237.9298 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184237.9301 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240802@184237.9364 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184237.9367 6oitjl5rg41jgoe58aei2qq24h Query : select no, estab,szadrsdesc from szadrs where u_coddest=8962
20240802@184237.9454 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240802@184238.2300 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20240802@184238.2600 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20240802@184238.4250 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20240802@184238.4450 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20240802@184238.4640 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1670.00.1'
20240802@184238.6120 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1675.00.2'
20240802@184238.7520 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1675.00.2'
20240802@184238.7710 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20240802@184238.9110 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1670.3015'
20240802@184238.1052 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.1675.3015'
20240802@184238.1208 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2907.00.1'
20240802@184238.1352 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9326.00.1'
20240802@184238.1509 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9306.00.1'
20240802@184238.1679 6oitjl5rg41jgoe58aei2qq24h 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'
20240802@184238.1700 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '325.551.00.15'
20240802@184238.1846 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8152.00.1'
20240802@184238.2020 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8152.00.1'
20240802@184238.2041 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20240802@184238.2063 6oitjl5rg41jgoe58aei2qq24h 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'
20240802@184238.2235 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4743.00.1'
20240802@184238.2392 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20240802@184238.2413 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20240802@184238.2434 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240802@184238.2454 6oitjl5rg41jgoe58aei2qq24h 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'
20240802@184238.2475 6oitjl5rg41jgoe58aei2qq24h 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'
20240802@184238.2495 6oitjl5rg41jgoe58aei2qq24h 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'
20240802@184238.2516 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240802@184238.2537 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240802@184238.2557 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1832.00.2'
20240802@184238.2579 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240802@184238.2601 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20240802@184238.2766 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20240802@184238.2786 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1896.00.1'
20240802@184238.2954 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.2185.00.1'
20240802@184238.3121 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4901.00.1'
20240802@184238.3960 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4906.00.1'
20240802@184238.3983 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240802@184238.4159 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4960.00.1'
20240802@184238.4180 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20240802@184238.4201 6oitjl5rg41jgoe58aei2qq24h 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'
20240802@184238.4355 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240802@184238.4376 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20240802@184238.4397 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20240802@184238.4559 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20240802@184238.4579 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240802@184238.4739 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20240802@184238.4943 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.367.09.00'
20240802@184238.5140 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240802@184238.7107 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7114 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240802@184238.7153 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7156 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 1 valor from td where td.ndoc = 39
20240802@184238.7199 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7203 6oitjl5rg41jgoe58aei2qq24h 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')
20240802@184238.7231 6oitjl5rg41jgoe58aei2qq24h 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
20240802@184238.7268 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7270 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 ~inactivo valor from cl where no = '100080' and estab = 0 order by inactivo desc
20240802@184238.7416 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7421 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240802@184238.7456 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7459 6oitjl5rg41jgoe58aei2qq24h Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240802@184238.7504 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7507 6oitjl5rg41jgoe58aei2qq24h Query : select szadrsstamp valor from szadrs where szadrsdesc='sorefoz - santa iria'
20240802@184238.7556 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.7559 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from td where ndoc = 39
20240802@184238.7571 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240802@184238.7588 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.7605 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240802@184238.7625 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.7639 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240802@184238.7670 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.7685 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240802@184238.7699 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240802@184238.7773 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240802@184238.7787 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.7805 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240802@184238.7820 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240802@184238.8019 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.8040 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240802@184238.8075 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240802@184238.8089 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240802@184238.8101 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240802@184238.8113 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240802@184238.8125 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240802@184238.8137 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240802@184238.8149 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66ad15200066ad1a8ebb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240802@184238.8404 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 fno valor from wsftdata order by fno desc
20240802@184238.8422 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.8456 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240802@184238.8481 6oitjl5rg41jgoe58aei2qq24h Query : select 'normal' from dummy
20240802@184238.8498 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66ad15200066ad1a8ebb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',214,100080,0,'2024-08-02',39,'euro',0,0,2024 ,?,?)
20240802@184238.9421 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184238.9425 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20240802@184238.9471 6oitjl5rg41jgoe58aei2qq24h 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.1676.00.1'
20240802@184238.9631 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.9652 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184238.9680 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.9696 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184238.9705 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184238.9718 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20240802@184238.9734 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.9753 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184238.9767 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad11069866ad1a8eed','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184238.9771 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184238.9787 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184238.9817 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad11069866ad1a8eed',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,10000,?,?,?,?)
20240802@184239.1000 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.1040 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20240802@184239.1250 6oitjl5rg41jgoe58aei2qq24h 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.1676.00.1'
20240802@184239.1400 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.1570 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.1860 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2020 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.2110 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.2240 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20240802@184239.2370 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2530 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.2650 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad10335866ad1a8f05','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.2700 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2880 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.3240 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad10335866ad1a8f05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,20000,?,?,?,?)
20240802@184239.6030 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.6060 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1685.00.1'
20240802@184239.6300 6oitjl5rg41jgoe58aei2qq24h 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.1685.00.1'
20240802@184239.8660 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.8830 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.9120 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9270 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.9360 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.9500 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1685.00.1' and lote = 'r2400173100a'
20240802@184239.9640 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9810 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.9950 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad11264766ad1a8f17','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.1000 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.1018 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.1051 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad11264766ad1a8f17',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,30000,?,?,?,?)
20240802@184239.1364 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.1367 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20240802@184239.1389 6oitjl5rg41jgoe58aei2qq24h 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.1684.00.1'
20240802@184239.1552 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.1569 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.1596 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.1612 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.1623 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.1636 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2301217200a'
20240802@184239.1650 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.1666 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.1679 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad11813966ad1a8f28','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.1683 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.1699 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.1728 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad11813966ad1a8f28',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,40000,?,?,?,?)
20240802@184239.2032 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.2036 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20240802@184239.2057 6oitjl5rg41jgoe58aei2qq24h 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.1684.00.1'
20240802@184239.2073 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2091 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.2118 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2133 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.2142 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.2155 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2301217200a'
20240802@184239.2168 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2186 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.2201 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad17550566ad1a8f34','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.2207 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2225 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.2263 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad17550566ad1a8f34',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,50000,?,?,?,?)
20240802@184239.2553 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.2557 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1670.00.1'
20240802@184239.2581 6oitjl5rg41jgoe58aei2qq24h 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.1670.00.1'
20240802@184239.2760 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2777 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.2811 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2826 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.2835 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.2848 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1670.00.1' and lote = 'r2301213200a'
20240802@184239.2862 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2877 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.2906 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad12413866ad1a8f45','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.2910 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.2927 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.2968 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad12413866ad1a8f45',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,60000,?,?,?,?)
20240802@184239.3265 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.3269 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1675.00.2'
20240802@184239.3296 6oitjl5rg41jgoe58aei2qq24h 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.1675.00.2'
20240802@184239.3463 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.3482 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.3513 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.3530 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.3540 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.3555 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1675.00.2' and lote = 'r2200299200a'
20240802@184239.3583 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.3600 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.3614 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad16662766ad1a8f57','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.3618 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.3636 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.3670 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad16662766ad1a8f57',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,70000,?,?,?,?)
20240802@184239.3991 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.3995 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1675.00.2'
20240802@184239.4022 6oitjl5rg41jgoe58aei2qq24h 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.1675.00.2'
20240802@184239.4038 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4058 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.4084 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4099 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.4108 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.4121 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1675.00.2' and lote = 'r2200299200a'
20240802@184239.4135 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4151 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.4164 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad18134366ad1a8f64','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.4169 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4184 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.4214 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad18134366ad1a8f64',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,80000,?,?,?,?)
20240802@184239.4482 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.4485 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20240802@184239.4514 6oitjl5rg41jgoe58aei2qq24h 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.1667.00.1'
20240802@184239.4673 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4691 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.4719 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4735 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.4745 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.4758 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2400065200a'
20240802@184239.4773 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4789 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.4803 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad15330066ad1a8f74','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.4807 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.4823 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.4853 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad15330066ad1a8f74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,90000,?,?,?,?)
20240802@184239.5146 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.5164 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.5192 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.5208 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.5218 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.5232 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.5249 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.5261 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad17135666ad1a8f7f','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.5266 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.5281 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.5314 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad17135666ad1a8f7f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,100000,?,?,?)
20240802@184239.5586 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.5590 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '325.1670.3015'
20240802@184239.5613 6oitjl5rg41jgoe58aei2qq24h 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 = '325.1670.3015'
20240802@184239.6243 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.6608 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.6638 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.6656 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.6665 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.6678 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='325.1670.3015' and lote = 'r2301133100a'
20240802@184239.6701 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.6717 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.6730 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad12829966ad1a8fa3','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.6735 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.6756 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.6788 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad12829966ad1a8fa3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,120000,?,?,?,?)
20240802@184239.7059 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.7063 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '325.1675.3015'
20240802@184239.7085 6oitjl5rg41jgoe58aei2qq24h 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 = '325.1675.3015'
20240802@184239.7238 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.7255 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.7284 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.7300 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.7310 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.7323 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='325.1675.3015' and lote = '801'
20240802@184239.7350 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.7364 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.7377 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad11865066ad1a8fb3','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.7381 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.7396 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.7428 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad11865066ad1a8fb3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,130000,?,?,?,?)
20240802@184239.7685 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.7688 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.2907.00.1'
20240802@184239.7716 6oitjl5rg41jgoe58aei2qq24h 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.2907.00.1'
20240802@184239.7870 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.7903 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.7935 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.7952 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.7962 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.7976 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.2907.00.1' and lote = 'r2400091200a'
20240802@184239.7990 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.8054 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.8066 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad11837466ad1a8fc3','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.8070 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.8087 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.8116 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad11837466ad1a8fc3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,140000,?,?,?,?)
20240802@184239.8366 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.8369 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '328.9326.00.1'
20240802@184239.8390 6oitjl5rg41jgoe58aei2qq24h 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 = '328.9326.00.1'
20240802@184239.8552 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.8568 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.8595 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.8612 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.8620 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.8633 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='328.9326.00.1' and lote = 'r2300691100a'
20240802@184239.8653 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.8667 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.8680 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad15964166ad1a8fd3','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.8684 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.8700 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.8728 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad15964166ad1a8fd3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,150000,?,?,?,?)
20240802@184239.8988 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9005 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.9032 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9047 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.9059 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.9073 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9089 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.9102 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad14055166ad1a8fdd','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.9107 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9122 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.9152 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad14055166ad1a8fdd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,160000,?,?,?)
20240802@184239.9401 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184239.9404 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '328.9306.00.1'
20240802@184239.9426 6oitjl5rg41jgoe58aei2qq24h 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 = '328.9306.00.1'
20240802@184239.9701 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9719 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.9748 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9763 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.9773 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184239.9791 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='328.9306.00.1' and lote = 'r2300691300a'
20240802@184239.9807 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9822 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184239.9835 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad18990866ad1a8fef','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184239.9840 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184239.9856 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184239.9891 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad18990866ad1a8fef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,180000,?,?,?,?)
20240802@184240.1580 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184240.1620 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240802@184240.1880 6oitjl5rg41jgoe58aei2qq24h 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'
20240802@184240.3450 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.3630 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.3970 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.4130 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.4230 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184240.4360 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240802@184240.4530 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.4680 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.4830 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad14859466ad1a900b','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184240.4880 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.5040 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.5380 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad14859466ad1a900b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,190000,?,?,?,?)
20240802@184240.8090 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.8270 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.8560 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.8710 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.8810 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184240.8950 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.9110 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.9250 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad11531266ad1a9015','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184240.9290 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.9450 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.9770 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad11531266ad1a9015',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,200000,?,?,?)
20240802@184240.1237 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184240.1241 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '325.551.00.15'
20240802@184240.1274 6oitjl5rg41jgoe58aei2qq24h 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 = '325.551.00.15'
20240802@184240.1429 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.1446 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.1474 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.1489 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.1500 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184240.1513 6oitjl5rg41jgoe58aei2qq24h Query : select sestamp valor from se where ref ='325.551.00.15' and lote = 'r210109070'
20240802@184240.1528 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.1544 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.1560 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad18842366ad1a9025','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184240.1564 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.1595 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.1632 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66ad18842366ad1a9025',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,220000,?,?,?,?)
20240802@184240.1909 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.1928 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.1957 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.1978 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.1988 6oitjl5rg41jgoe58aei2qq24h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240802@184240.2003 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.2018 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240802@184240.2031 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66ad13977266ad1a9030','aut66ad15200066ad1a8ebb' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240802@184240.2036 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.2053 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240802@184240.2086 6oitjl5rg41jgoe58aei2qq24h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66ad13977266ad1a9030',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66ad15200066ad1a8ebb' ,0,0 ,2,23.00,230000,?,?,?)
20240802@184240.2367 6oitjl5rg41jgoe58aei2qq24h Query : use flama_phc
20240802@184240.2370 6oitjl5rg41jgoe58aei2qq24h Query : select st.usalote valor from st where st.ref = '327.8152.00.1'
20240802@184240.2395 6oitjl5rg41jgoe58aei2qq24h 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 = '327.8152.00.1'
20240802@184240.2550 6oitjl5rg41jgoe58aei2qq24h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240802@184240.2567 6oitjl5rg41jgoe58aei2qq24h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
