20230515@090743.2222 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230515@090743.2233 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230515@090743.2272 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230515@090743.2282 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230515@090743.2436 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230515@090743.2456 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230515@090743.2485 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='e6460b87b2681127086436 '
20230515@090743.2584 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='e6460b87b2681127086436 '
20230515@090743.2675 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='e6460b87b2681127086436 '
20230515@090743.2755 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='e6460b87b2681127086436 '
20230515@090743.2828 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp='e6460b87b2681127086436 '
20230515@090743.2933 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 bo.serie valor from bo where bo.bostamp='e6460b87b2681127086436 '
20230515@090743.3006 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6461e342386461e84f35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230515@090743.3209 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 fno valor from wsft039data order by fno desc
20230515@090743.3257 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230515@090743.3273 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230515@090743.3294 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6461e342386461e84f35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',270,102068,0,'2023-05-15',39,'euro',0,0,2023 ,'20230515','0937',?,?,?,?,?)
20230515@090743.3577 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090743.3609 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '304.422.00.07'
20230515@090743.3622 3j477qrko0l7phcvvs1h2gitn3 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.422.00.07'
20230515@090743.3760 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.3774 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.3798 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.3812 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.3817 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='304.422.00.07' and lote = '230222'
20230515@090743.3829 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.3839 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.3882 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.3910 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e631616461e84f5d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6461e342386461e84f35' ,18.600000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230515@090743.4155 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.4206 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.4211 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e631616461e84f5d','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.4216 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090743.4219 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20230515@090743.4232 3j477qrko0l7phcvvs1h2gitn3 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'
20230515@090743.4404 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.4419 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.4458 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.4472 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.4477 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '230223'
20230515@090743.4488 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.4534 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.4547 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.4574 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e301346461e84f6e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,20000,?,?,?,?,?,?,?,?,?)
20230515@090743.4815 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.4876 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.4880 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e301346461e84f6e','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.4886 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.4901 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.4929 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.4942 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.4947 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.4957 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.4969 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.4995 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6461e580216461e84f79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6461e342386461e84f35' ,0,0 ,2,23.00,30000,?,?,?)
20230515@090743.5271 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.5288 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.5293 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e580216461e84f79','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.5297 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090743.5301 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20230515@090743.5312 3j477qrko0l7phcvvs1h2gitn3 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'
20230515@090743.5365 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.5379 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.6359 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.6373 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.6378 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r2101251200a'
20230515@090743.6390 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.6402 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.6415 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.6439 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e107866461e84f9c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,50000,?,?,?,?,?,?,?,?,?)
20230515@090743.6710 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.6726 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.6731 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e107866461e84f9c','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.6737 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.6767 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.6798 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.7191 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.7196 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.7207 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.7221 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.7246 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6461e627086461e84faf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6461e342386461e84f35' ,0,0 ,2,23.00,60000,?,?,?)
20230515@090743.7530 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.7545 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.7550 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e627086461e84faf','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.7555 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090743.7558 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.724.00.01'
20230515@090743.7570 3j477qrko0l7phcvvs1h2gitn3 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.724.00.01'
20230515@090743.7715 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.7740 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.7764 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.7810 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.7815 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.724.00.01' and lote = '11/18'
20230515@090743.7840 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.7853 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.7867 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.7898 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e510376461e84fbf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6461e342386461e84f35' ,20.300000,0 ,2,23.00,80000,?,?,?,?,?,?,?,?,?)
20230515@090743.8157 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.8172 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.8176 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e510376461e84fbf','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.8181 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090743.8204 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.4964.00.1'
20230515@090743.8216 3j477qrko0l7phcvvs1h2gitn3 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.4964.00.1'
20230515@090743.8589 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.8602 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.8625 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.8638 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.8642 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.4964.00.1' and lote = 'r2101092100a'
20230515@090743.8661 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.8673 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.8687 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.8709 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e823776461e84fd3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,90000,?,?,?,?,?,?,?,?,?)
20230515@090743.8982 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.8998 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.9003 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e823776461e84fd3','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.9007 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090743.9010 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.4962.00.1'
20230515@090743.9030 3j477qrko0l7phcvvs1h2gitn3 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.4962.00.1'
20230515@090743.9170 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.9186 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.9213 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.9228 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.9232 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.4962.00.1' and lote = 'r2101091100a'
20230515@090743.9247 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.9259 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.9274 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.9300 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e930986461e84fe2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,100000,?,?,?,?,?,?,?,?,?)
20230515@090743.9604 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.9620 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090743.9626 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e930986461e84fe2','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090743.9631 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090743.9666 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.4963.00.1'
20230515@090743.9681 3j477qrko0l7phcvvs1h2gitn3 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.4963.00.1'
20230515@090743.9819 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.9834 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090743.9863 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090743.9876 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090743.9881 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.4963.00.1' and lote = 'r2101091100a'
20230515@090743.9927 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090743.9938 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090743.9953 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090743.9979 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e641316461e84ff2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e342386461e84f35' ,26.100000,0 ,2,23.00,110000,?,?,?,?,?,?,?,?,?)
20230515@090744.2320 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.2490 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.2530 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e641316461e84ff2','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.2710 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.2750 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20230515@090744.2870 3j477qrko0l7phcvvs1h2gitn3 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.2221.00.1'
20230515@090744.4500 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.1249 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.1569 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.1618 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.1623 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2101297200a'
20230515@090744.1637 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.1649 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.1662 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.1685 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e439106461e85028',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e342386461e84f35' ,23.200000,0 ,2,23.00,120000,?,?,?,?,?,?,?,?,?)
20230515@090744.1970 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.1986 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.1991 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e439106461e85028','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.1995 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.1998 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.734.00.01'
20230515@090744.2010 3j477qrko0l7phcvvs1h2gitn3 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.734.00.01'
20230515@090744.2153 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.2166 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.2190 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.2204 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.2209 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.734.00.01' and lote = 'r210072300a'
20230515@090744.2222 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.2237 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.2251 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.2276 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e685316461e85036',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,130000,?,?,?,?,?,?,?,?,?)
20230515@090744.2540 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.2561 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.2567 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e685316461e85036','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.2574 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.2577 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.4961.00.1'
20230515@090744.2599 3j477qrko0l7phcvvs1h2gitn3 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.4961.00.1'
20230515@090744.2843 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.2873 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.2932 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.2955 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.2963 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.4961.00.1' and lote = 'r2101091200a'
20230515@090744.2979 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.2993 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.3018 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.3057 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e778256461e85049',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e342386461e84f35' ,26.100000,0 ,2,23.00,140000,?,?,?,?,?,?,?,?,?)
20230515@090744.3341 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.3387 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.3396 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e778256461e85049','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.3403 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.3407 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20230515@090744.3421 3j477qrko0l7phcvvs1h2gitn3 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.2222.00.1'
20230515@090744.3605 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.3618 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.3643 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.3660 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.3666 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2101297100a'
20230515@090744.3679 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.3691 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.3703 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.3729 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e244736461e8505a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,150000,?,?,?,?,?,?,?,?,?)
20230515@090744.3972 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.3987 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.3992 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e244736461e8505a','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.3999 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.4003 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20230515@090744.4014 3j477qrko0l7phcvvs1h2gitn3 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.5501.00.1'
20230515@090744.4179 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.4195 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.4220 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.4235 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.4240 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2200800200a'
20230515@090744.4252 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.4262 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.4275 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.4328 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e598366461e85068',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,160000,?,?,?,?,?,?,?,?,?)
20230515@090744.4684 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.4699 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.4704 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e598366461e85068','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.4708 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.4712 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20230515@090744.4724 3j477qrko0l7phcvvs1h2gitn3 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.5501.00.1'
20230515@090744.4735 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.4749 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.4815 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.4829 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.4834 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2200800200a'
20230515@090744.4869 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.4880 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.4893 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.4920 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e999566461e85077',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,170000,?,?,?,?,?,?,?,?,?)
20230515@090744.5163 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.5219 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.5224 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e999566461e85077','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.5229 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.5232 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20230515@090744.5245 3j477qrko0l7phcvvs1h2gitn3 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.5501.00.1'
20230515@090744.5258 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.5272 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.5296 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.5324 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.5330 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2200800200a'
20230515@090744.5341 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.5352 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.5366 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.5421 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e944256461e85082',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut6461e342386461e84f35' ,.000000,0 ,2,23.00,180000,?,?,?,?,?,?,?,?,?)
20230515@090744.5671 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.5732 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.5737 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e944256461e85082','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.5742 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.5745 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.719.00.01'
20230515@090744.5758 3j477qrko0l7phcvvs1h2gitn3 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.719.00.01'
20230515@090744.5769 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.5807 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.5836 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.5850 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.5854 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.719.00.01' and lote = 'r2100602100a'
20230515@090744.5866 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.5877 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.5890 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.5951 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e773336461e8508f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6461e342386461e84f35' ,14.500000,0 ,2,23.00,190000,?,?,?,?,?,?,?,?,?)
20230515@090744.6221 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.6238 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.6243 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e773336461e8508f','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.6248 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.6301 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.6329 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.6342 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.6347 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.6357 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.6376 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.6458 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6461e140166461e8509b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6461e342386461e84f35' ,0,0 ,2,23.00,200000,?,?,?)
20230515@090744.6784 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.6801 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.6806 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e140166461e8509b','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.6810 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.6813 3j477qrko0l7phcvvs1h2gitn3 Query : select st.usalote valor from st where st.ref = '324.719.00.01'
20230515@090744.6827 3j477qrko0l7phcvvs1h2gitn3 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.719.00.01'
20230515@090744.6839 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.6854 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.6880 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.6892 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.6897 3j477qrko0l7phcvvs1h2gitn3 Query : select sestamp valor from se where ref ='324.719.00.01' and lote = 'r2100602100a'
20230515@090744.6909 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.6918 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.6931 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.6957 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e294256461e850a8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e342386461e84f35' ,14.500000,0 ,2,23.00,220000,?,?,?,?,?,?,?,?,?)
20230515@090744.7207 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.7221 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.7228 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e294256461e850a8','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.7241 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.7256 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090744.7281 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.7294 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090744.7298 3j477qrko0l7phcvvs1h2gitn3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090744.7309 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090744.7324 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090744.7348 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6461e036646461e850b2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6461e342386461e84f35' ,0,0 ,2,23.00,230000,?,?,?)
20230515@090744.7598 3j477qrko0l7phcvvs1h2gitn3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090744.7612 3j477qrko0l7phcvvs1h2gitn3 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090744.7617 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e036646461e850b2','aut6461e342386461e84f35' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090744.7621 3j477qrko0l7phcvvs1h2gitn3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6461e342386461e84f35','119230000177','wait',39,'ari17112337378,753000005')
20230515@090744.7639 3j477qrko0l7phcvvs1h2gitn3 Query : use flama_phc
20230515@090744.7642 3j477qrko0l7phcvvs1h2gitn3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20230515@090744.7653 3j477qrko0l7phcvvs1h2gitn3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='384';
20230515@090744.7668 3j477qrko0l7phcvvs1h2gitn3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='384';
20230515@090744.7680 3j477qrko0l7phcvvs1h2gitn3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='384';
20230515@090744.7692 3j477qrko0l7phcvvs1h2gitn3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='384';
20230515@090744.8040 tbvm8lqrtkc3speud90vkuokn9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20230515@090744.8053 tbvm8lqrtkc3speud90vkuokn9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20230515@090744.8069 tbvm8lqrtkc3speud90vkuokn9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='385';
20230515@090744.8108 tbvm8lqrtkc3speud90vkuokn9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='385';
20230515@090744.8161 tbvm8lqrtkc3speud90vkuokn9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='385';
20230515@090744.8187 tbvm8lqrtkc3speud90vkuokn9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='385';
20230515@090744.8207 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090744.8211 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20230515@090744.8289 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090744.8292 tbvm8lqrtkc3speud90vkuokn9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=770
20230515@090744.8366 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1839.00.1'
20230515@090744.8566 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000183 and bi.ref ='324.1839.00.1' and bi.lordem =20000
20230515@090744.8887 tbvm8lqrtkc3speud90vkuokn9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250571,5980000-2 ' 
20230515@090744.9403 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1846.00.1'
20230515@090744.9593 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000183 and bi.ref ='324.1846.00.1' and bi.lordem =30000
20230515@090745.1000 tbvm8lqrtkc3speud90vkuokn9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250571,6280000-3 ' 
20230515@090745.4620 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1846.00.1'
20230515@090745.4720 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000183 and bi.ref ='324.1846.00.1' and bi.lordem =30000
20230515@090745.4840 tbvm8lqrtkc3speud90vkuokn9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250571,6280000-3 ' 
20230515@090745.4940 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1846.00.1'
20230515@090745.5030 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000183 and bi.ref ='324.1846.00.1' and bi.lordem =30000
20230515@090745.5130 tbvm8lqrtkc3speud90vkuokn9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250571,6280000-3 ' 
20230515@090745.5230 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20230515@090745.6610 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000183 and bi.ref ='324.1834.00.1' and bi.lordem =40000
20230515@090745.1067 tbvm8lqrtkc3speud90vkuokn9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250571,7430000-4 ' 
20230515@090745.1996 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20230515@090745.2205 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =119 and bo.boano =2023 and bo.obrano = 0000183 and bi.ref ='324.1834.00.1' and bi.lordem =40000
20230515@090745.2363 tbvm8lqrtkc3speud90vkuokn9 Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc23051250571,7430000-4 ' 
20230515@090745.2374 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2378 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20230515@090745.2412 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2415 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 1 valor from td where td.ndoc = 39
20230515@090745.2425 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2428 tbvm8lqrtkc3speud90vkuokn9 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20230515@090745.2438 tbvm8lqrtkc3speud90vkuokn9 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
20230515@090745.2451 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2454 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20230515@090745.2463 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2465 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20230515@090745.2475 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2478 tbvm8lqrtkc3speud90vkuokn9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20230515@090745.2490 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2492 tbvm8lqrtkc3speud90vkuokn9 Query : select szadrsstamp valor from szadrs where szadrsdesc='worten-equipamentos para o lar,sa.- azambuja'
20230515@090745.2506 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.2509 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from td where ndoc = 39
20230515@090745.2518 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20230515@090745.2562 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230515@090745.2579 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20230515@090745.2595 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230515@090745.2608 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20230515@090745.2635 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230515@090745.2647 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20230515@090745.2657 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230515@090745.2713 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2023 order by fno desc
20230515@090745.2723 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20230515@090745.2734 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20230515@090745.2743 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6461e515366461e85140' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20230515@090745.3053 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20230515@090745.3125 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20230515@090745.3152 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc23051234835,343000001 '
20230515@090745.3257 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc23051234835,343000001 '
20230515@090745.3363 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc23051234835,343000001 '
20230515@090745.3440 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc23051234835,343000001 '
20230515@090745.3546 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc23051234835,343000001 '
20230515@090745.3639 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 bo.serie valor from bo where bo.bostamp='evc23051234835,343000001 '
20230515@090745.3718 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6461e515366461e85140',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20230515@090745.3913 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 fno valor from wsft039data order by fno desc
20230515@090745.3927 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20230515@090745.3939 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20230515@090745.3957 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsft039data (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,cdata,chora,carga,descar,site ,classe ,encomenda ) values ('aut6461e515366461e85140',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',271,100810,0,'2023-05-15',39,'euro',0,0,2023 ,'20230515','0937',?,?,?,?,?)
20230515@090745.4215 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.4240 tbvm8lqrtkc3speud90vkuokn9 Query : select st.usalote valor from st where st.ref = '324.1839.00.1'
20230515@090745.4260 tbvm8lqrtkc3speud90vkuokn9 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.1839.00.1'
20230515@090745.4452 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.4469 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090745.4492 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.4504 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090745.4509 tbvm8lqrtkc3speud90vkuokn9 Query : select sestamp valor from se where ref ='324.1839.00.1' and lote = 'r220007200a'
20230515@090745.4519 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090745.4529 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.4541 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090745.4563 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e033736461e8516e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6461e515366461e85140' ,66.300000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20230515@090745.4819 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.4832 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090745.4836 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e033736461e8516e','aut6461e515366461e85140' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090745.4841 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.4853 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090745.4875 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.4887 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090745.4891 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090745.4920 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.4932 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090745.4955 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6461e677366461e85178',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6461e515366461e85140' ,0,0 ,2,23.00,20000,?,?,?)
20230515@090745.5191 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.5207 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090745.5212 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e677366461e85178','aut6461e515366461e85140' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090745.5216 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.5219 tbvm8lqrtkc3speud90vkuokn9 Query : select st.usalote valor from st where st.ref = '324.1846.00.1'
20230515@090745.5230 tbvm8lqrtkc3speud90vkuokn9 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.1846.00.1'
20230515@090745.5361 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.5373 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090745.5397 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.5409 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090745.5413 tbvm8lqrtkc3speud90vkuokn9 Query : select sestamp valor from se where ref ='324.1846.00.1' and lote = 'r2200670200a'
20230515@090745.5424 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090745.5434 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.5449 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090745.5473 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e283856461e85184',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6461e515366461e85140' ,57.850000,0 ,2,23.00,40000,?,?,?,?,?,?,?,?,?)
20230515@090745.5705 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.5737 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090745.5741 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e283856461e85184','aut6461e515366461e85140' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090745.5746 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.5760 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090745.5782 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.5797 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090745.5801 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090745.5810 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.5822 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090745.5845 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6461e343096461e8518d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6461e515366461e85140' ,0,0 ,2,23.00,50000,?,?,?)
20230515@090745.6114 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.6130 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090745.6134 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e343096461e8518d','aut6461e515366461e85140' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090745.6139 tbvm8lqrtkc3speud90vkuokn9 Query : use flama_phc
20230515@090745.6142 tbvm8lqrtkc3speud90vkuokn9 Query : select st.usalote valor from st where st.ref = '324.1846.00.1'
20230515@090745.6154 tbvm8lqrtkc3speud90vkuokn9 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.1846.00.1'
20230515@090745.7132 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.7149 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090745.7169 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.7181 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090745.7185 tbvm8lqrtkc3speud90vkuokn9 Query : select sestamp valor from se where ref ='324.1846.00.1' and lote = 'r2200670200a'
20230515@090745.7194 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090745.7204 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.7215 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090745.7237 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut6461e119026461e851af',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6461e515366461e85140' ,57.850000,0 ,2,23.00,70000,?,?,?,?,?,?,?,?,?)
20230515@090745.7471 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.7503 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20230515@090745.7507 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6461e119026461e851af','aut6461e515366461e85140' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20230515@090745.7512 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.7524 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20230515@090745.7546 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20230515@090745.7557 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20230515@090745.7561 tbvm8lqrtkc3speud90vkuokn9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20230515@090745.7570 tbvm8lqrtkc3speud90vkuokn9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20230515@090745.7582 tbvm8lqrtkc3speud90vkuokn9 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20230515@090745.7604 tbvm8lqrtkc3speud90vkuokn9 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6461e129806461e851b8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6461e515366461e85140' ,0,0 ,2,23.00,80000,?,?,?)
