20240513@080330.7661 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080330.7665 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 1 valor from td where td.ndoc = 39
20240513@080330.7749 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080330.7752 72d4kg9n95ugh5s5ndgedi5r5k Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240513@080330.7792 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240513@080330.7894 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080330.7898 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 ~inactivo valor from cl where no = '101900' and estab = 0 order by inactivo desc
20240513@080330.8013 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080330.8016 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240513@080330.8308 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080330.8312 72d4kg9n95ugh5s5ndgedi5r5k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240513@080330.8370 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080330.8375 72d4kg9n95ugh5s5ndgedi5r5k Query : select szadrsstamp valor from szadrs where szadrsdesc='101900 - pd - alcochete'
20240513@080330.8387 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080330.8390 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from td where ndoc = 39
20240513@080330.8466 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240513@080330.8526 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240513@080330.8811 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240513@080330.8859 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240513@080330.9132 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240513@080330.9190 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240513@080330.9481 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240513@080330.9528 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240513@080330.9856 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240513@080330.9928 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240513@080330.9941 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240513@080330.9970 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6641b802846641bb42e8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240513@080331.4570 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240513@080331.4720 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240513@080331.5210 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240513@080331.6120 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240513@080331.7260 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240513@080331.8120 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240513@080331.8830 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240513@080331.9550 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240513@080331.1031 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6641b802846641bb42e8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240513@080331.1389 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 fno valor from wsft039data order by fno desc
20240513@080331.1459 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240513@080331.1479 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240513@080331.1518 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6641b802846641bb42e8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1262,101900,0,'2024-05-13',39,'euro',0,0,2024 ,'20240513','0833',?,?,?,?)
20240513@080331.2011 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080331.2016 72d4kg9n95ugh5s5ndgedi5r5k Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240513@080331.2127 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240513@080331.2264 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.2542 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080331.2597 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.2927 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080331.2949 72d4kg9n95ugh5s5ndgedi5r5k Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240432'
20240513@080331.3032 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080331.3070 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.3082 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080331.3123 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b203366641bb434a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',32.000 ,'aut6641b802846641bb42e8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240513@080331.4377 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.4899 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080331.4924 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b203366641bb434a','aut6641b802846641bb42e8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080331.5023 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.5038 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080331.5066 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.5079 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080331.5083 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080331.5094 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.5107 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080331.5132 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b098896641bb437c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b802846641bb42e8' ,0,0 ,2,23.00,20000,?,?,?)
20240513@080331.5359 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.5373 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080331.5377 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b098896641bb437c','aut6641b802846641bb42e8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080331.5381 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080331.5384 72d4kg9n95ugh5s5ndgedi5r5k Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240513@080331.5395 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240513@080331.5406 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.5418 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080331.5449 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.5515 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080331.5520 72d4kg9n95ugh5s5ndgedi5r5k Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240432'
20240513@080331.5531 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080331.5541 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.5567 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080331.5591 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b044306641bb4387',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',36.000 ,'aut6641b802846641bb42e8' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240513@080331.5833 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.5848 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080331.5852 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b044306641bb4387','aut6641b802846641bb42e8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080331.5857 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.5870 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080331.5894 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.5988 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080331.5994 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080331.6004 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.6024 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080331.6135 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b225366641bb4392',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b802846641bb42e8' ,0,0 ,2,23.00,50000,?,?,?)
20240513@080331.6348 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.6361 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080331.6366 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b225366641bb4392','aut6641b802846641bb42e8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080331.6370 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080331.6372 72d4kg9n95ugh5s5ndgedi5r5k Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240513@080331.6383 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4960.00.1'
20240513@080331.6531 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.6544 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080331.6567 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.6580 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080331.6584 72d4kg9n95ugh5s5ndgedi5r5k Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240513@080331.6648 72d4kg9n95ugh5s5ndgedi5r5k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080331.6696 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080331.6709 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080331.6731 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b104956641bb43a3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.000 ,'aut6641b802846641bb42e8' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240513@080331.6949 72d4kg9n95ugh5s5ndgedi5r5k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080331.6964 72d4kg9n95ugh5s5ndgedi5r5k Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080331.6969 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b104956641bb43a3','aut6641b802846641bb42e8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080331.6973 72d4kg9n95ugh5s5ndgedi5r5k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6641b802846641bb42e8','2403280','wait',39,'ari17112337378,753000005')
20240513@080331.7008 72d4kg9n95ugh5s5ndgedi5r5k Query : use flama_phc
20240513@080331.7011 72d4kg9n95ugh5s5ndgedi5r5k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240513@080331.7022 72d4kg9n95ugh5s5ndgedi5r5k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1585';
20240513@080331.7037 72d4kg9n95ugh5s5ndgedi5r5k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1585';
20240513@080331.7055 72d4kg9n95ugh5s5ndgedi5r5k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1585';
20240513@080331.7068 72d4kg9n95ugh5s5ndgedi5r5k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1585';
20240513@080331.7435 p4522keofcru9l5ibcpej1vpun Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240513@080331.7449 p4522keofcru9l5ibcpej1vpun Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240513@080331.7466 p4522keofcru9l5ibcpej1vpun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1586';
20240513@080331.7507 p4522keofcru9l5ibcpej1vpun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1586';
20240513@080331.7526 p4522keofcru9l5ibcpej1vpun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1586';
20240513@080331.7539 p4522keofcru9l5ibcpej1vpun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1586';
20240513@080331.7555 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.7559 p4522keofcru9l5ibcpej1vpun Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240513@080331.7582 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.7585 p4522keofcru9l5ibcpej1vpun Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20240513@080331.7650 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.7799 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8128 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8139 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8144 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8154 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8160 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8172 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8177 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8187 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8193 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8204 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8210 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8224 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8230 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8240 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1832.00.2' and bi.lordem =1
20240513@080331.8246 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8404 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8744 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8756 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8762 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8772 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8777 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8786 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8791 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8801 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8806 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8816 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8821 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8830 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8836 p4522keofcru9l5ibcpej1vpun 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'
20240513@080331.8847 p4522keofcru9l5ibcpej1vpun Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403281 and bi.ref ='324.1831.00.2' and bi.lordem =2
20240513@080331.8852 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.8855 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240513@080331.8869 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.8872 p4522keofcru9l5ibcpej1vpun Query : select top 1 1 valor from td where td.ndoc = 39
20240513@080331.8882 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.8892 p4522keofcru9l5ibcpej1vpun Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240513@080331.8903 p4522keofcru9l5ibcpej1vpun Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240513@080331.8917 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.8920 p4522keofcru9l5ibcpej1vpun Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20240513@080331.9052 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.9055 p4522keofcru9l5ibcpej1vpun Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240513@080331.9066 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.9069 p4522keofcru9l5ibcpej1vpun Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240513@080331.9080 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.9083 p4522keofcru9l5ibcpej1vpun Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20240513@080331.9126 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080331.9132 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from td where ndoc = 39
20240513@080331.9171 p4522keofcru9l5ibcpej1vpun Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240513@080331.9182 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240513@080331.9196 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240513@080331.9227 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240513@080331.9240 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240513@080331.9275 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240513@080331.9288 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240513@080331.9298 p4522keofcru9l5ibcpej1vpun Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240513@080331.9377 p4522keofcru9l5ibcpej1vpun Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240513@080331.9388 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240513@080331.9402 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240513@080331.9412 p4522keofcru9l5ibcpej1vpun Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240513@080331.9557 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240513@080331.9596 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240513@080331.9642 p4522keofcru9l5ibcpej1vpun Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240513@080331.9648 p4522keofcru9l5ibcpej1vpun Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240513@080331.9653 p4522keofcru9l5ibcpej1vpun Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240513@080331.9658 p4522keofcru9l5ibcpej1vpun Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240513@080331.9663 p4522keofcru9l5ibcpej1vpun Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240513@080331.9669 p4522keofcru9l5ibcpej1vpun Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240513@080331.9673 p4522keofcru9l5ibcpej1vpun Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6641b129306641bb43e3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240513@080332.5800 p4522keofcru9l5ibcpej1vpun Query : select top 1 fno valor from wsft039data order by fno desc
20240513@080332.8000 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240513@080332.9400 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240513@080332.1680 p4522keofcru9l5ibcpej1vpun Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6641b129306641bb43e3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1263,101597,0,'2024-05-13',39,'euro',0,0,2024 ,'20240513','0833',?,?,?,?)
20240513@080332.4390 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.4430 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.4550 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.6220 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.6360 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.6650 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.6780 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.6820 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.7120 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.7220 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.7350 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.7580 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b104536641bb4411',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240513@080332.9650 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.9800 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.9840 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b104536641bb4411','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.9890 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.1002 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.1026 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.1038 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.1043 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.1053 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.1066 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.1090 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b603186641bb4419',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,20000,?,?,?)
20240513@080332.1309 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.1324 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.1328 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b603186641bb4419','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.1332 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.1336 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.1347 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.1358 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.1371 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.1394 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.1406 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.1410 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.1421 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.1430 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.1442 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.1466 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b401696641bb4422',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240513@080332.1677 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.1692 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.1697 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b401696641bb4422','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.1702 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.1715 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.1740 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.1752 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.1757 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.1768 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.1780 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.1804 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b785806641bb442b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,50000,?,?,?)
20240513@080332.2019 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.2035 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.2039 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b785806641bb442b','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.2044 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.2047 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.2057 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.2068 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.2082 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.2107 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.2120 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.2126 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.2137 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.2148 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.2161 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.2185 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b327976641bb4434',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240513@080332.2399 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.2415 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.2420 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b327976641bb4434','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.2425 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.2438 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.2462 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.2474 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.2479 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.2489 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.2501 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.2524 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b980506641bb443c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,80000,?,?,?)
20240513@080332.2759 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.2774 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.2779 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b980506641bb443c','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.2784 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.2787 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.2799 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.2811 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.2824 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.2847 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.2858 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.2863 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.2873 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.2882 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.2895 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.2918 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b600726641bb4446',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240513@080332.3127 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.3141 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.3146 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b600726641bb4446','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.3150 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.3163 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.3188 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.3201 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.3206 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.3216 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.3229 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.3253 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b045576641bb444e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,110000,?,?,?)
20240513@080332.3475 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.3490 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.3495 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b045576641bb444e','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.3506 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.3509 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.3520 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.3532 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.3545 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.3571 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.3644 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.3650 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.3695 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.3845 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.3860 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.3883 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b888736641bb445d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240513@080332.4153 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.4280 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.4285 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b888736641bb445d','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.4290 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.4304 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.4327 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.4341 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.4345 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.4355 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.4368 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.4395 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b701516641bb446a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,140000,?,?,?)
20240513@080332.4623 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.4747 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.4752 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b701516641bb446a','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.4757 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.4760 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.4771 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.4782 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.4795 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.4817 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.4829 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.4833 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.4842 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.4854 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.4867 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.5009 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b863846641bb4476',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240513@080332.5235 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.5250 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.5340 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b863846641bb4476','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.5351 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.5366 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.5461 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.5476 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.5480 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.5490 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.5503 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.5525 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b496156641bb4486',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,170000,?,?,?)
20240513@080332.5736 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.5750 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.5754 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b496156641bb4486','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.5758 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.5761 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.5771 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.5781 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.5793 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.5815 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.5826 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.5830 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.5839 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.5849 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.5860 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.5881 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b946166641bb448e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20240513@080332.6213 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.6491 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.6496 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b946166641bb448e','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.6502 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.6799 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.7415 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.7430 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.7434 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.7444 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.7457 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.7480 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b783626641bb44b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,200000,?,?,?)
20240513@080332.7726 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.7744 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.7766 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b783626641bb44b5','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.7771 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.7775 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1832.00.2'
20240513@080332.7787 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1832.00.2'
20240513@080332.7799 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.7815 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.7837 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.7930 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.7935 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1832.00.2' and lote = 'r2301256100a'
20240513@080332.7946 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.7955 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.7975 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.7997 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b710526641bb44c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20240513@080332.8227 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.8280 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.8285 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b710526641bb44c2','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.8290 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.8304 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.8329 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.8341 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.8345 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.8355 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.8367 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.8390 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b013356641bb44cb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,230000,?,?,?)
20240513@080332.8608 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.8622 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.8627 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b013356641bb44cb','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.8631 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.8634 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080332.8649 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080332.8804 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.8818 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.8842 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.8854 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.8858 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080332.8868 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.8878 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.8889 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.8911 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b311436641bb44d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20240513@080332.9145 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.9159 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.9163 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b311436641bb44d8','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.9169 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.9182 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.9206 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.9219 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.9223 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.9233 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.9245 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.9268 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b333326641bb44e1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,260000,?,?,?)
20240513@080332.9481 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.9495 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.9499 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b333326641bb44e1','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.9504 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080332.9506 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080332.9516 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080332.9527 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.9539 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.9561 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.9573 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.9577 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080332.9588 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.9597 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.9608 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.9631 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b502446641bb44ea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,280000,?,?,?,?,?)
20240513@080332.9841 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.9858 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080332.9862 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b502446641bb44ea','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080332.9867 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.9880 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080332.9902 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080332.9913 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080332.9917 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080332.9926 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080332.9937 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080332.9958 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b587426641bb44f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,290000,?,?,?)
20240513@080333.2560 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.2700 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.2740 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b587426641bb44f2','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.2790 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080333.2900 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080333.3000 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080333.3100 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.3220 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.3600 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.3730 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.3770 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080333.3920 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.4010 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.4140 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.4370 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b767696641bb4509',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,310000,?,?,?,?,?)
20240513@080333.6880 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.7210 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.7260 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b767696641bb4509','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.7310 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.7440 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.7700 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.7820 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.7860 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.7950 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.8080 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.8300 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b651566641bb4513',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,320000,?,?,?)
20240513@080333.1052 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.1075 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.1079 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b651566641bb4513','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.1084 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080333.1087 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080333.1100 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080333.1121 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.1134 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.1169 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.1181 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.1185 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080333.1195 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.1204 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.1223 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.1246 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b683336641bb451d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,340000,?,?,?,?,?)
20240513@080333.1469 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.1483 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.1488 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b683336641bb451d','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.1493 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.1505 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.1528 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.1540 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.1544 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.1580 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.1594 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.1615 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b009946641bb4526',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,350000,?,?,?)
20240513@080333.1820 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.1833 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.1837 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b009946641bb4526','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.1841 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080333.1844 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080333.1854 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080333.1864 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.1876 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.1897 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.1908 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.1912 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080333.1921 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.1930 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.1941 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.1961 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b868946641bb452f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,370000,?,?,?,?,?)
20240513@080333.2169 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.2184 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.2189 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b868946641bb452f','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.2194 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.2207 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.2231 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.2244 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.2248 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.2258 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.2270 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.2293 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b797356641bb4537',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,380000,?,?,?)
20240513@080333.2508 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.2524 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.2529 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b797356641bb4537','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.2533 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080333.2556 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080333.2568 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080333.2580 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.2594 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.2627 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.2639 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.2644 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080333.2656 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.2667 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.2747 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.2773 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b137486641bb4541',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,400000,?,?,?,?,?)
20240513@080333.2999 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.3015 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.3019 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b137486641bb4541','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.3025 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.3049 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.3074 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.3087 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.3123 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.3134 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.3149 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.3190 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b110006641bb454c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,410000,?,?,?)
20240513@080333.3411 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.3425 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.3471 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b110006641bb454c','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.3517 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080333.3529 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080333.3540 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080333.3550 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.3563 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.3585 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.3600 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.3604 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080333.3614 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.3623 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.3634 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.3656 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b796406641bb4558',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,430000,?,?,?,?,?)
20240513@080333.3868 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.3882 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.3886 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b796406641bb4558','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.3891 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.3903 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.3925 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.3936 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.3940 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.3950 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.3963 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.3994 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b559486641bb4560',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,440000,?,?,?)
20240513@080333.4207 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.4221 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.4225 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b559486641bb4560','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.4229 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080333.4232 p4522keofcru9l5ibcpej1vpun Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240513@080333.4242 p4522keofcru9l5ibcpej1vpun Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1831.00.2'
20240513@080333.4254 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.4266 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.4432 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.4445 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.4449 p4522keofcru9l5ibcpej1vpun Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301257200a'
20240513@080333.4459 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.4468 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.4479 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.4501 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b590906641bb456d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,460000,?,?,?,?,?)
20240513@080333.4797 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.4811 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.4815 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b590906641bb456d','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.4820 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.4833 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.4859 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.4871 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.4876 p4522keofcru9l5ibcpej1vpun Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.4885 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.4897 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.4919 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b755126641bb4577',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b129306641bb43e3' ,0,0 ,2,23.00,470000,?,?,?)
20240513@080333.5137 p4522keofcru9l5ibcpej1vpun Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.5150 p4522keofcru9l5ibcpej1vpun Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.5155 p4522keofcru9l5ibcpej1vpun Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b755126641bb4577','aut6641b129306641bb43e3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.5159 p4522keofcru9l5ibcpej1vpun Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6641b129306641bb43e3','2403281','wait',39,'ari17112337378,753000005')
20240513@080333.5175 p4522keofcru9l5ibcpej1vpun Query : use flama_phc
20240513@080333.5178 p4522keofcru9l5ibcpej1vpun Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240513@080333.5189 p4522keofcru9l5ibcpej1vpun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1586';
20240513@080333.5203 p4522keofcru9l5ibcpej1vpun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1586';
20240513@080333.5221 p4522keofcru9l5ibcpej1vpun Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1586';
20240513@080333.5233 p4522keofcru9l5ibcpej1vpun Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1586';
20240513@080333.5612 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240513@080333.5626 sr0j3qnm17er9m8rkjvcnhrp98 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240513@080333.5643 sr0j3qnm17er9m8rkjvcnhrp98 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1587';
20240513@080333.5686 sr0j3qnm17er9m8rkjvcnhrp98 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1587';
20240513@080333.5704 sr0j3qnm17er9m8rkjvcnhrp98 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1587';
20240513@080333.5719 sr0j3qnm17er9m8rkjvcnhrp98 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1587';
20240513@080333.5734 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.5738 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240513@080333.5751 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.5755 sr0j3qnm17er9m8rkjvcnhrp98 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4743
20240513@080333.5783 sr0j3qnm17er9m8rkjvcnhrp98 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'
20240513@080333.5961 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403283 and bi.ref ='324.727.00.01' and bi.lordem =1
20240513@080333.6289 sr0j3qnm17er9m8rkjvcnhrp98 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'
20240513@080333.6303 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403283 and bi.ref ='324.727.00.01' and bi.lordem =1
20240513@080333.6308 sr0j3qnm17er9m8rkjvcnhrp98 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'
20240513@080333.6318 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2032 and bo.obrano = 2403283 and bi.ref ='324.727.00.01' and bi.lordem =1
20240513@080333.6323 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6327 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240513@080333.6378 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6382 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 1 valor from td where td.ndoc = 39
20240513@080333.6393 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6396 sr0j3qnm17er9m8rkjvcnhrp98 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240513@080333.6410 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 assinadoc issigned ,td.lancasl stocks ,'cl' origin ,case when (cmsl between 1 and 50 ) then 1 else 0 end entrada ,case when (cmsl>50 ) then 1 else 0 end saida ,~lotestock validatestock ,tiposaft from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc =39
20240513@080333.6425 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6428 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 ~inactivo valor from cl where no = '101597' and estab = 0 order by inactivo desc
20240513@080333.6439 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6442 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240513@080333.6472 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6475 sr0j3qnm17er9m8rkjvcnhrp98 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240513@080333.6492 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6495 sr0j3qnm17er9m8rkjvcnhrp98 Query : select szadrsstamp valor from szadrs where szadrsdesc='101597 - auchan retail portugal , sa'
20240513@080333.6507 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.6510 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from td where ndoc = 39
20240513@080333.6521 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240513@080333.6557 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240513@080333.6573 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240513@080333.6590 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240513@080333.6603 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240513@080333.6799 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240513@080333.6815 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240513@080333.6829 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240513@080333.6905 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240513@080333.6915 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240513@080333.6928 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240513@080333.6938 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6641b022126641bb45a6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240513@080333.7082 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240513@080333.7100 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240513@080333.7130 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240513@080333.7135 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240513@080333.7140 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240513@080333.7145 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240513@080333.7150 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240513@080333.7155 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240513@080333.7159 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6641b022126641bb45a6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240513@080333.7482 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 fno valor from wsft039data order by fno desc
20240513@080333.7534 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240513@080333.7549 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240513@080333.8581 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ) values ('aut6641b022126641bb45a6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1264,101597,0,'2024-05-13',39,'euro',0,0,2024 ,'20240513','0833',?,?,?,?)
20240513@080333.8884 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.8890 sr0j3qnm17er9m8rkjvcnhrp98 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240513@080333.8928 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240513@080333.9088 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.9111 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.9135 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.9151 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.9155 sr0j3qnm17er9m8rkjvcnhrp98 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240513@080333.9168 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.9178 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.9192 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.9214 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b968576641bb45e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',48.000 ,'aut6641b022126641bb45a6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240513@080333.9458 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.9472 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.9476 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b968576641bb45e0','aut6641b022126641bb45a6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.9481 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.9498 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080333.9519 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.9553 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080333.9558 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080333.9571 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.9609 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080333.9663 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b509736641bb45e9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b022126641bb45a6' ,0,0 ,2,23.00,20000,?,?,?)
20240513@080333.9895 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080333.9909 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080333.9913 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b509736641bb45e9','aut6641b022126641bb45a6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080333.9917 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080333.9921 sr0j3qnm17er9m8rkjvcnhrp98 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240513@080333.9936 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240513@080333.9946 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080333.9958 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080334.8800 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080334.1010 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080334.1050 sr0j3qnm17er9m8rkjvcnhrp98 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240513@080334.1150 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080334.1250 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080334.1370 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080334.1590 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b441226641bb4603',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut6641b022126641bb45a6' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240513@080334.3780 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080334.3940 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080334.3990 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b441226641bb4603','aut6641b022126641bb45a6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080334.4070 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080334.4220 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080334.4480 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080334.4610 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080334.4660 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080334.4770 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080334.4910 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080334.5210 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b497856641bb460b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b022126641bb45a6' ,0,0 ,2,23.00,50000,?,?,?)
20240513@080334.7450 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080334.7610 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080334.7660 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b497856641bb460b','aut6641b022126641bb45a6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080334.7710 sr0j3qnm17er9m8rkjvcnhrp98 Query : use flama_phc
20240513@080334.7750 sr0j3qnm17er9m8rkjvcnhrp98 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20240513@080334.7860 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.727.00.01'
20240513@080334.7980 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080334.8110 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080334.8370 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080334.8490 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080334.8540 sr0j3qnm17er9m8rkjvcnhrp98 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2301222100a'
20240513@080334.8640 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080334.8760 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080334.8900 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080334.9140 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6641b971926641bb4615',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',120.000 ,'aut6641b022126641bb45a6' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240513@080334.1131 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080334.1146 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240513@080334.1151 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6641b971926641bb4615','aut6641b022126641bb45a6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240513@080334.1156 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080334.1171 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240513@080334.1196 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240513@080334.1208 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240513@080334.1213 sr0j3qnm17er9m8rkjvcnhrp98 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240513@080334.1223 sr0j3qnm17er9m8rkjvcnhrp98 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240513@080334.1235 sr0j3qnm17er9m8rkjvcnhrp98 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240513@080334.1260 sr0j3qnm17er9m8rkjvcnhrp98 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6641b267846641bb461d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6641b022126641bb45a6' ,0,0 ,2,23.00,80000,?,?,?)
