20240319@073028.8760 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402183 and bi.ref ='324.4961.00.1' and bi.lordem =5
20240319@073028.9089 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20240319@073028.9243 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402183 and bi.ref ='324.2221.00.1' and bi.lordem =6
20240319@073028.9683 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9687 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240319@073028.9700 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9703 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 1 valor from td where td.ndoc = 39
20240319@073028.9713 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9715 t5r67k2kpec70d6gstkp3dffbs Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240319@073028.9726 t5r67k2kpec70d6gstkp3dffbs 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
20240319@073028.9740 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9743 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20240319@073028.9753 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9755 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240319@073028.9765 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9768 t5r67k2kpec70d6gstkp3dffbs Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240319@073028.9778 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9781 t5r67k2kpec70d6gstkp3dffbs Query : select szadrsstamp valor from szadrs where szadrsdesc='central de compras de herramientas, s.l.'
20240319@073028.9793 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073028.9796 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from td where ndoc = 39
20240319@073028.9805 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240319@073028.9815 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073028.9830 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240319@073028.9846 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073028.9859 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240319@073028.9884 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073028.9897 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240319@073028.9906 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073029.6000 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073029.1500 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073029.2800 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240319@073029.3800 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240319@073029.2480 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073029.2630 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240319@073029.2920 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240319@073029.2970 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240319@073029.3020 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240319@073029.3070 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240319@073029.3110 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240319@073029.3160 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240319@073029.3200 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f935273265f93f14f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240319@073029.5860 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 fno valor from wsft039data order by fno desc
20240319@073029.6030 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073029.6170 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240319@073029.6350 t5r67k2kpec70d6gstkp3dffbs 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 ('aut65f935273265f93f14f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',501,200500,0,'2024-03-19',39,'euro',0,0,2024 ,'20240319','0800',?,?,?,?)
20240319@073029.9340 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.9380 t5r67k2kpec70d6gstkp3dffbs Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20240319@073029.9500 t5r67k2kpec70d6gstkp3dffbs 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.1684.00.1'
20240319@073029.1099 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.1114 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073029.1137 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.1150 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073029.1154 t5r67k2kpec70d6gstkp3dffbs Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2301217200a'
20240319@073029.1165 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073029.1175 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.1187 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073029.1209 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f934607365f93f151c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f935273265f93f14f1' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240319@073029.1718 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.2235 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073029.2443 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f934607365f93f151c','aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073029.2650 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.2691 t5r67k2kpec70d6gstkp3dffbs Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20240319@073029.2850 t5r67k2kpec70d6gstkp3dffbs 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.1608.00.1'
20240319@073029.3015 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.3030 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073029.3055 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.3068 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073029.3072 t5r67k2kpec70d6gstkp3dffbs Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2200658200a'
20240319@073029.3088 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073029.3099 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.3111 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073029.3135 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f934515765f93f154b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f935273265f93f14f1' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240319@073029.3383 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.3397 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073029.3403 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f934515765f93f154b','aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073029.3408 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.3411 t5r67k2kpec70d6gstkp3dffbs Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240319@073029.3425 t5r67k2kpec70d6gstkp3dffbs 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.4421.00.1'
20240319@073029.3577 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.3590 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073029.3611 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.3623 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073029.3627 t5r67k2kpec70d6gstkp3dffbs Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2200226300a'
20240319@073029.3649 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073029.3658 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.3671 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073029.3694 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f938814565f93f1559',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut65f935273265f93f14f1' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240319@073029.3973 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.3988 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073029.3992 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f938814565f93f1559','aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073029.3996 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.4000 t5r67k2kpec70d6gstkp3dffbs Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20240319@073029.4010 t5r67k2kpec70d6gstkp3dffbs 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.4421.00.1'
20240319@073029.4024 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.4050 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073029.4072 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.4087 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073029.4091 t5r67k2kpec70d6gstkp3dffbs Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2200226300a'
20240319@073029.4101 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073029.4111 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.4123 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073029.4151 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f932463365f93f1564',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f935273265f93f14f1' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240319@073029.4501 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.4517 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073029.4522 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f932463365f93f1564','aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073029.4527 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.4530 t5r67k2kpec70d6gstkp3dffbs Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20240319@073029.4542 t5r67k2kpec70d6gstkp3dffbs 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'
20240319@073029.4710 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.4724 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073029.4749 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.4763 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073029.4767 t5r67k2kpec70d6gstkp3dffbs Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2300829100a'
20240319@073029.4779 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073029.4789 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.4802 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073029.4827 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f936468665f93f1574',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut65f935273265f93f14f1' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240319@073029.5207 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.5291 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073029.5296 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f936468665f93f1574','aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073029.5301 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.5305 t5r67k2kpec70d6gstkp3dffbs Query : select st.usalote valor from st where st.ref = '324.4961.00.1'
20240319@073029.5319 t5r67k2kpec70d6gstkp3dffbs 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'
20240319@073029.5575 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.5590 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073029.5612 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.5626 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073029.5631 t5r67k2kpec70d6gstkp3dffbs Query : select sestamp valor from se where ref ='324.4961.00.1' and lote = 'r2101092200a'
20240319@073029.5642 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073029.5651 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.5663 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073029.5687 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f935517065f93f1589',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut65f935273265f93f14f1' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240319@073029.5945 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.5960 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073029.5964 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f935517065f93f1589','aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073029.5968 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.5971 t5r67k2kpec70d6gstkp3dffbs Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240319@073029.5982 t5r67k2kpec70d6gstkp3dffbs 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'
20240319@073029.6131 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.6144 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073029.6170 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.6184 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073029.6189 t5r67k2kpec70d6gstkp3dffbs Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20240319@073029.6201 t5r67k2kpec70d6gstkp3dffbs Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073029.6210 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073029.6222 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073029.6246 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f934679565f93f1597',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut65f935273265f93f14f1' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240319@073029.6568 t5r67k2kpec70d6gstkp3dffbs Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073029.6586 t5r67k2kpec70d6gstkp3dffbs Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073029.6591 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f934679565f93f1597','aut65f935273265f93f14f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073029.6596 t5r67k2kpec70d6gstkp3dffbs Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f935273265f93f14f1','2402183','wait',39,'ari17112337378,753000005')
20240319@073029.6612 t5r67k2kpec70d6gstkp3dffbs Query : use flama_phc
20240319@073029.6616 t5r67k2kpec70d6gstkp3dffbs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240319@073029.6626 t5r67k2kpec70d6gstkp3dffbs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='676';
20240319@073029.6643 t5r67k2kpec70d6gstkp3dffbs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='676';
20240319@073029.6656 t5r67k2kpec70d6gstkp3dffbs Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='676';
20240319@073029.6668 t5r67k2kpec70d6gstkp3dffbs Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='676';
20240319@073029.7263 uanl74p84sao546oe1j5o8geu2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240319@073029.7361 uanl74p84sao546oe1j5o8geu2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240319@073029.7576 uanl74p84sao546oe1j5o8geu2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='677';
20240319@073029.7816 uanl74p84sao546oe1j5o8geu2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='677';
20240319@073029.7902 uanl74p84sao546oe1j5o8geu2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='677';
20240319@073029.8143 uanl74p84sao546oe1j5o8geu2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='677';
20240319@073029.8252 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073029.8333 uanl74p84sao546oe1j5o8geu2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240319@073029.8544 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073029.8548 uanl74p84sao546oe1j5o8geu2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240319@073029.8638 uanl74p84sao546oe1j5o8geu2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1675.00.2'
20240319@073029.8851 uanl74p84sao546oe1j5o8geu2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402185 and bi.ref ='324.1675.00.2' and bi.lordem =1
20240319@073029.9536 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073029.9540 uanl74p84sao546oe1j5o8geu2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240319@073029.9987 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.1420 uanl74p84sao546oe1j5o8geu2 Query : select top 1 1 valor from td where td.ndoc = 39
20240319@073030.8140 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.9810 uanl74p84sao546oe1j5o8geu2 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240319@073030.1199 uanl74p84sao546oe1j5o8geu2 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
20240319@073030.1223 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.1226 uanl74p84sao546oe1j5o8geu2 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240319@073030.1471 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.1474 uanl74p84sao546oe1j5o8geu2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240319@073030.1487 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.1497 uanl74p84sao546oe1j5o8geu2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240319@073030.1508 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.1595 uanl74p84sao546oe1j5o8geu2 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240319@073030.1791 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.1794 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from td where ndoc = 39
20240319@073030.1807 uanl74p84sao546oe1j5o8geu2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240319@073030.2060 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073030.2271 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240319@073030.2642 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073030.2725 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240319@073030.2865 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073030.2888 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240319@073030.3064 uanl74p84sao546oe1j5o8geu2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073030.3265 uanl74p84sao546oe1j5o8geu2 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073030.3447 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073030.3657 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240319@073030.3864 uanl74p84sao546oe1j5o8geu2 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f935062165f93f164a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240319@073030.4291 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073030.4387 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240319@073030.4468 uanl74p84sao546oe1j5o8geu2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240319@073030.4479 uanl74p84sao546oe1j5o8geu2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240319@073030.4484 uanl74p84sao546oe1j5o8geu2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240319@073030.4488 uanl74p84sao546oe1j5o8geu2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240319@073030.4615 uanl74p84sao546oe1j5o8geu2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240319@073030.4698 uanl74p84sao546oe1j5o8geu2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240319@073030.4763 uanl74p84sao546oe1j5o8geu2 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f935062165f93f164a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240319@073030.5290 uanl74p84sao546oe1j5o8geu2 Query : select top 1 fno valor from wsft039data order by fno desc
20240319@073030.5501 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073030.5956 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240319@073030.7077 uanl74p84sao546oe1j5o8geu2 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 ('aut65f935062165f93f164a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',502,100810,0,'2024-03-19',39,'euro',0,0,2024 ,'20240319','0800',?,?,?,?)
20240319@073030.8015 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073030.8099 uanl74p84sao546oe1j5o8geu2 Query : select st.usalote valor from st where st.ref = '324.1675.00.2'
20240319@073030.8309 uanl74p84sao546oe1j5o8geu2 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.1675.00.2'
20240319@073030.8937 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073030.9148 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073030.9349 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073030.9395 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073030.9399 uanl74p84sao546oe1j5o8geu2 Query : select sestamp valor from se where ref ='324.1675.00.2' and lote = 'r2300536200a'
20240319@073030.9421 uanl74p84sao546oe1j5o8geu2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073030.9634 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073030.9703 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073031.1300 uanl74p84sao546oe1j5o8geu2 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f933816965f93f16eb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut65f935062165f93f164a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240319@073031.6310 uanl74p84sao546oe1j5o8geu2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073031.8330 uanl74p84sao546oe1j5o8geu2 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073031.8390 uanl74p84sao546oe1j5o8geu2 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f933816965f93f16eb','aut65f935062165f93f164a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073031.8440 uanl74p84sao546oe1j5o8geu2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f935062165f93f164a','2402185','wait',39,'ari17112337378,753000005')
20240319@073031.9340 uanl74p84sao546oe1j5o8geu2 Query : use flama_phc
20240319@073031.9740 uanl74p84sao546oe1j5o8geu2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240319@073031.1007 uanl74p84sao546oe1j5o8geu2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='677';
20240319@073031.1024 uanl74p84sao546oe1j5o8geu2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='677';
20240319@073031.1039 uanl74p84sao546oe1j5o8geu2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='677';
20240319@073031.1136 uanl74p84sao546oe1j5o8geu2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='677';
20240319@073031.2128 q2i02cs2di4mospn6lgor94cvk Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240319@073031.2191 q2i02cs2di4mospn6lgor94cvk Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240319@073031.2328 q2i02cs2di4mospn6lgor94cvk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='678';
20240319@073031.2396 q2i02cs2di4mospn6lgor94cvk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='678';
20240319@073031.2492 q2i02cs2di4mospn6lgor94cvk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='678';
20240319@073031.2685 q2i02cs2di4mospn6lgor94cvk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='678';
20240319@073031.2700 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073031.2704 q2i02cs2di4mospn6lgor94cvk Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240319@073031.2919 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073031.2960 q2i02cs2di4mospn6lgor94cvk Query : select no, estab,szadrsdesc from szadrs where u_coddest=4537
20240319@073031.3282 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1406.00.1'
20240319@073031.4435 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.1406.00.1' and bi.lordem =1
20240319@073031.5166 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20240319@073031.5177 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.1407.00.1' and bi.lordem =2
20240319@073031.5860 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20240319@073031.6067 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.1462.00.1' and bi.lordem =3
20240319@073031.6730 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20240319@073031.7085 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.497.00.01' and bi.lordem =4
20240319@073031.7964 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240319@073031.9117 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.5342.00.1' and bi.lordem =5
20240319@073031.9853 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20240319@073032.1580 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.5343.00.1' and bi.lordem =6
20240319@073032.1193 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240319@073032.1402 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.5396.00.1' and bi.lordem =7
20240319@073032.2030 q2i02cs2di4mospn6lgor94cvk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20240319@073032.2388 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402190 and bi.ref ='324.945.00.01' and bi.lordem =8
20240319@073032.3036 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.3078 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240319@073032.3353 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.3445 q2i02cs2di4mospn6lgor94cvk Query : select top 1 1 valor from td where td.ndoc = 39
20240319@073032.3651 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.3693 q2i02cs2di4mospn6lgor94cvk Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240319@073032.3708 q2i02cs2di4mospn6lgor94cvk 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
20240319@073032.3857 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.3861 q2i02cs2di4mospn6lgor94cvk Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20240319@073032.3871 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.3874 q2i02cs2di4mospn6lgor94cvk Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240319@073032.3891 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.3894 q2i02cs2di4mospn6lgor94cvk Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240319@073032.4102 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.4143 q2i02cs2di4mospn6lgor94cvk Query : select szadrsstamp valor from szadrs where szadrsdesc='novaem distec, s.l.u-entrega'
20240319@073032.4157 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.4164 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from td where ndoc = 39
20240319@073032.4385 q2i02cs2di4mospn6lgor94cvk Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240319@073032.4640 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073032.4855 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240319@073032.5027 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073032.5172 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240319@073032.5210 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073032.5422 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240319@073032.5482 q2i02cs2di4mospn6lgor94cvk Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073032.6004 q2i02cs2di4mospn6lgor94cvk Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073032.6210 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073032.6420 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240319@073032.6503 q2i02cs2di4mospn6lgor94cvk Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240319@073032.6830 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073032.6849 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240319@073032.7124 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240319@073032.7129 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240319@073032.7255 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240319@073032.7336 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240319@073032.7419 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240319@073032.7566 q2i02cs2di4mospn6lgor94cvk Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240319@073032.7649 q2i02cs2di4mospn6lgor94cvk Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f937185165f93f1885',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240319@073032.8249 q2i02cs2di4mospn6lgor94cvk Query : select top 1 fno valor from wsft039data order by fno desc
20240319@073032.8345 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073032.8438 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240319@073032.8502 q2i02cs2di4mospn6lgor94cvk 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 ('aut65f937185165f93f1885',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',503,200500,0,'2024-03-19',39,'euro',0,0,2024 ,'20240319','0800',?,?,?,?)
20240319@073032.9302 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073032.9331 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.1406.00.1'
20240319@073032.9956 q2i02cs2di4mospn6lgor94cvk 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.1406.00.1'
20240319@073033.2120 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073033.4240 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073033.6350 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073033.6940 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073033.6980 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.1406.00.1' and lote = '10/20'
20240319@073033.7090 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073033.7250 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073033.9340 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073033.1220 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f930480065f93f1911',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240319@073033.2051 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073033.2260 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073033.2342 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f930480065f93f1911','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073033.2385 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073033.2572 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.1407.00.1'
20240319@073033.4258 q2i02cs2di4mospn6lgor94cvk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1407.00.1'
20240319@073033.4749 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073033.4775 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073033.5242 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073033.5521 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073033.5603 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.1407.00.1' and lote = 'r2100703100a'
20240319@073033.5664 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073033.5754 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073033.5815 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073033.5846 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f932491865f93f198c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240319@073033.6388 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073033.6567 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073033.6802 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f932491865f93f198c','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073033.6928 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073033.7088 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.1462.00.1'
20240319@073033.7846 q2i02cs2di4mospn6lgor94cvk 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.1462.00.1'
20240319@073033.8187 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073033.8201 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073033.8351 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073033.8488 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073033.8493 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.1462.00.1' and lote = 'r2101096200a'
20240319@073033.8503 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073033.8751 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073033.8998 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073033.9370 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f932768965f93f19d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240319@073033.9883 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.4090 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073034.4250 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f932768965f93f19d5','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073034.4500 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073034.6170 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.497.00.01'
20240319@073034.8540 q2i02cs2di4mospn6lgor94cvk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.497.00.01'
20240319@073034.1328 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.1502 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073034.1653 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.1667 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073034.1677 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.497.00.01' and lote = 'r2300022100a'
20240319@073034.1965 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073034.2041 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.2057 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073034.2582 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f938965165f93f1a31',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240319@073034.3108 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.3265 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073034.3270 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f938965165f93f1a31','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073034.3275 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073034.3279 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240319@073034.3298 q2i02cs2di4mospn6lgor94cvk 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.5342.00.1'
20240319@073034.3693 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.3710 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073034.4130 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.4342 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073034.4424 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20240319@073034.4556 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073034.4688 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.4720 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073034.4756 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f931437865f93f1a72',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240319@073034.5475 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.5799 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073034.5882 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f931437865f93f1a72','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073034.5928 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.6138 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073034.6363 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.6503 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073034.6508 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073034.6520 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.6540 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073034.6809 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f938050465f93f1a9f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,60000,?,?,?)
20240319@073034.7472 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.8087 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073034.8414 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f938050465f93f1a9f','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073034.8471 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073034.8477 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.5343.00.1'
20240319@073034.8492 q2i02cs2di4mospn6lgor94cvk 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.5343.00.1'
20240319@073034.8783 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.8805 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073034.9093 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073034.9268 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073034.9349 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.5343.00.1' and lote = 'r2300915100a'
20240319@073034.9558 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073034.9763 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073034.9892 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073035.4600 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f931669365f93f1aee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20240319@073035.5510 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073035.7440 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073035.7510 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f931669365f93f1aee','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073035.7570 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073035.1013 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073035.1548 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073035.1644 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073035.1693 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073035.1707 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073035.1729 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073035.2041 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f930947265f93f1b29',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,90000,?,?,?)
20240319@073035.2651 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073035.2862 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073035.2944 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f930947265f93f1b29','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073035.2988 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073035.3029 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240319@073035.3115 q2i02cs2di4mospn6lgor94cvk 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.5396.00.1'
20240319@073035.3258 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073035.3275 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073035.3553 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073035.3583 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073035.3588 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240319@073035.3802 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073035.4009 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073035.4221 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073035.4571 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f938338465f93f1b61',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20240319@073035.5296 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073035.5890 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073035.6124 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f938338465f93f1b61','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073035.6132 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073035.6316 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073035.6856 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073035.6973 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073035.6978 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073035.7125 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073035.7140 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073035.7301 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f933806765f93f1bad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,120000,?,?,?)
20240319@073035.7976 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073035.8187 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073035.8268 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f933806765f93f1bad','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073035.8314 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073035.8356 q2i02cs2di4mospn6lgor94cvk Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20240319@073035.8566 q2i02cs2di4mospn6lgor94cvk 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.945.00.01'
20240319@073035.8948 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073035.8964 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073035.9509 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073036.1096 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073036.1102 q2i02cs2di4mospn6lgor94cvk Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2200799100a'
20240319@073036.1365 q2i02cs2di4mospn6lgor94cvk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073036.1617 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073036.1871 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073036.2082 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f932213965f93f1c27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65f937185165f93f1885' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20240319@073036.2666 q2i02cs2di4mospn6lgor94cvk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073036.2804 q2i02cs2di4mospn6lgor94cvk Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073036.2809 q2i02cs2di4mospn6lgor94cvk Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f932213965f93f1c27','aut65f937185165f93f1885' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073036.2814 q2i02cs2di4mospn6lgor94cvk Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f937185165f93f1885','2402190','wait',39,'ari17112337378,753000005')
20240319@073036.3038 q2i02cs2di4mospn6lgor94cvk Query : use flama_phc
20240319@073036.3079 q2i02cs2di4mospn6lgor94cvk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240319@073036.3165 q2i02cs2di4mospn6lgor94cvk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='678';
20240319@073036.3380 q2i02cs2di4mospn6lgor94cvk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='678';
20240319@073036.3471 q2i02cs2di4mospn6lgor94cvk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='678';
20240319@073036.3685 q2i02cs2di4mospn6lgor94cvk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='678';
20240319@073036.4136 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240319@073036.4149 fokdmpv3tl5pkmeo1m9321gql0 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240319@073036.4168 fokdmpv3tl5pkmeo1m9321gql0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='679';
20240319@073036.4210 fokdmpv3tl5pkmeo1m9321gql0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='679';
20240319@073036.4224 fokdmpv3tl5pkmeo1m9321gql0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='679';
20240319@073036.4240 fokdmpv3tl5pkmeo1m9321gql0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='679';
20240319@073036.4253 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.4257 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240319@073036.4269 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.4273 fokdmpv3tl5pkmeo1m9321gql0 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1404
20240319@073036.4363 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1825.00.2'
20240319@073036.4635 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402191 and bi.ref ='324.1825.00.2' and bi.lordem =1
20240319@073036.4980 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20240319@073036.4991 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402191 and bi.ref ='324.691.00.01' and bi.lordem =3
20240319@073036.5328 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20240319@073036.5339 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402191 and bi.ref ='324.691.00.01' and bi.lordem =4
20240319@073036.5668 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.698.00.01'
20240319@073036.5825 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402191 and bi.ref ='324.698.00.01' and bi.lordem =5
20240319@073036.6161 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.658.00.01'
20240319@073036.6320 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402191 and bi.ref ='324.658.00.01' and bi.lordem =6
20240319@073036.6655 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20240319@073036.6812 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402191 and bi.ref ='304.4320.00.1' and bi.lordem =7
20240319@073036.7136 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7140 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240319@073036.7155 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7158 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 1 valor from td where td.ndoc = 39
20240319@073036.7170 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7176 fokdmpv3tl5pkmeo1m9321gql0 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240319@073036.7186 fokdmpv3tl5pkmeo1m9321gql0 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
20240319@073036.7200 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7203 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 ~inactivo valor from cl where no = '102206' and estab = 0 order by inactivo desc
20240319@073036.7310 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7314 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240319@073036.7324 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7327 fokdmpv3tl5pkmeo1m9321gql0 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240319@073036.7338 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7341 fokdmpv3tl5pkmeo1m9321gql0 Query : select szadrsstamp valor from szadrs where szadrsdesc='manuel domingos cavaco & filhos, lda.'
20240319@073036.7354 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.7356 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from td where ndoc = 39
20240319@073036.7365 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240319@073036.7377 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073036.7393 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240319@073036.7410 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073036.7425 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240319@073036.7449 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073036.7462 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240319@073036.7471 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073036.7649 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073036.7660 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073036.7674 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240319@073036.7684 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240319@073036.7911 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073036.7927 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240319@073036.7953 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240319@073036.7958 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240319@073036.7962 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240319@073036.7967 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240319@073036.7971 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240319@073036.7977 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240319@073036.7982 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f932585065f93f1cb6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240319@073036.8493 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 fno valor from wsft039data order by fno desc
20240319@073036.8586 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073036.8602 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240319@073036.8624 fokdmpv3tl5pkmeo1m9321gql0 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 ('aut65f932585065f93f1cb6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',504,102206,0,'2024-03-19',39,'euro',0,0,2024 ,'20240319','0800',?,?,?,?)
20240319@073036.8983 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073036.8987 fokdmpv3tl5pkmeo1m9321gql0 Query : select st.usalote valor from st where st.ref = '324.1825.00.2'
20240319@073036.9000 fokdmpv3tl5pkmeo1m9321gql0 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.1825.00.2'
20240319@073036.9204 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073036.9225 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073036.9249 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073036.9263 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073036.9268 fokdmpv3tl5pkmeo1m9321gql0 Query : select sestamp valor from se where ref ='324.1825.00.2' and lote = 'r2300179200a'
20240319@073036.9284 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073036.9294 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073036.9308 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073036.9332 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f935933865f93f1ce2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240319@073036.9633 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073036.9649 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073036.9654 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f935933865f93f1ce2','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073036.9660 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073036.9678 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073036.9705 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073036.9718 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073036.9743 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073036.9753 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073036.9767 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073036.9790 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f937247165f93f1cee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,20000,?,?,?)
20240319@073037.1160 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.1340 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.1390 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f937247165f93f1cee','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.1440 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073037.1470 fokdmpv3tl5pkmeo1m9321gql0 Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240319@073037.1570 fokdmpv3tl5pkmeo1m9321gql0 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.691.00.01'
20240319@073037.1690 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.2060 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.2330 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.2500 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.2550 fokdmpv3tl5pkmeo1m9321gql0 Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240319@073037.2670 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.2800 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.2970 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.3310 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f939733865f93f1d06',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240319@073037.7020 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.7180 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.7230 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f939733865f93f1d06','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.7290 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.7450 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.7680 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.7810 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.7860 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.7960 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.8110 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.8390 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f931884865f93f1d13',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,50000,?,?,?)
20240319@073037.1285 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.1303 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.1307 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f931884865f93f1d13','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.1312 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073037.1315 fokdmpv3tl5pkmeo1m9321gql0 Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240319@073037.1324 fokdmpv3tl5pkmeo1m9321gql0 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.691.00.01'
20240319@073037.1335 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.1363 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.1387 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.1400 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.1404 fokdmpv3tl5pkmeo1m9321gql0 Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240319@073037.1414 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.1423 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.1438 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.1462 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f932294065f93f1d22',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240319@073037.1807 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.1987 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.1993 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f932294065f93f1d22','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.1999 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.2014 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.2039 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.2052 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.2057 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.2066 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.2079 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.2103 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f939218165f93f1d32',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,80000,?,?,?)
20240319@073037.2422 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.2438 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.2462 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f939218165f93f1d32','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.2467 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073037.2470 fokdmpv3tl5pkmeo1m9321gql0 Query : select st.usalote valor from st where st.ref = '324.698.00.01'
20240319@073037.2481 fokdmpv3tl5pkmeo1m9321gql0 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.698.00.01'
20240319@073037.2671 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.2685 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.2710 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.2723 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.2728 fokdmpv3tl5pkmeo1m9321gql0 Query : select sestamp valor from se where ref ='324.698.00.01' and lote = 'r2301182200a'
20240319@073037.2740 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.2753 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.2768 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.2805 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f932170065f93f1d43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240319@073037.3101 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.3116 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.3121 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f932170065f93f1d43','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.3126 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.3139 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.3162 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.3175 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.3179 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.3189 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.3202 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.3224 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f932022565f93f1d4d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,110000,?,?,?)
20240319@073037.3664 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.3681 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.3686 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f932022565f93f1d4d','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.3691 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073037.3694 fokdmpv3tl5pkmeo1m9321gql0 Query : select st.usalote valor from st where st.ref = '324.658.00.01'
20240319@073037.3710 fokdmpv3tl5pkmeo1m9321gql0 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.658.00.01'
20240319@073037.3867 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.3882 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.3908 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.3922 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.3928 fokdmpv3tl5pkmeo1m9321gql0 Query : select sestamp valor from se where ref ='324.658.00.01' and lote = 'r2300819200a'
20240319@073037.3942 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.3953 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.3968 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.3993 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f934269665f93f1d60',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240319@073037.4287 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.4303 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.4307 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f934269665f93f1d60','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.4313 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.4329 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.4353 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.4365 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.4370 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.4380 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.4393 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.4518 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f939909165f93f1d6a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,140000,?,?,?)
20240319@073037.4831 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.4847 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.4851 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f939909165f93f1d6a','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.4856 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073037.4860 fokdmpv3tl5pkmeo1m9321gql0 Query : select st.usalote valor from st where st.ref = '304.4320.00.1'
20240319@073037.4871 fokdmpv3tl5pkmeo1m9321gql0 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.4320.00.1'
20240319@073037.5033 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.5049 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073037.5078 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.5092 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073037.5096 fokdmpv3tl5pkmeo1m9321gql0 Query : select sestamp valor from se where ref ='304.4320.00.1' and lote = '230741'
20240319@073037.5122 fokdmpv3tl5pkmeo1m9321gql0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073037.5132 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073037.5145 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073037.5167 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f934371465f93f1d7d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut65f932585065f93f1cb6' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20240319@073037.5445 fokdmpv3tl5pkmeo1m9321gql0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073037.5476 fokdmpv3tl5pkmeo1m9321gql0 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073037.5481 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f934371465f93f1d7d','aut65f932585065f93f1cb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073037.5485 fokdmpv3tl5pkmeo1m9321gql0 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut65f932585065f93f1cb6','2402191','wait',39,'ari17112337378,753000005')
20240319@073037.5507 fokdmpv3tl5pkmeo1m9321gql0 Query : use flama_phc
20240319@073037.5510 fokdmpv3tl5pkmeo1m9321gql0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240319@073037.5521 fokdmpv3tl5pkmeo1m9321gql0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='679';
20240319@073037.5538 fokdmpv3tl5pkmeo1m9321gql0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='679';
20240319@073037.5551 fokdmpv3tl5pkmeo1m9321gql0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='679';
20240319@073037.5567 fokdmpv3tl5pkmeo1m9321gql0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='679';
20240319@073037.6063 rp56cq2rqnju7fdts7auc7ml7q Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240319@073037.6127 rp56cq2rqnju7fdts7auc7ml7q Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240319@073037.6234 rp56cq2rqnju7fdts7auc7ml7q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='680';
20240319@073037.6431 rp56cq2rqnju7fdts7auc7ml7q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='680';
20240319@073037.6448 rp56cq2rqnju7fdts7auc7ml7q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='680';
20240319@073037.6471 rp56cq2rqnju7fdts7auc7ml7q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='680';
20240319@073037.6568 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073037.6609 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240319@073037.6757 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073037.6761 rp56cq2rqnju7fdts7auc7ml7q Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240319@073037.7009 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073037.7455 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073037.8384 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073037.9506 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073037.9513 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073037.9730 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073037.9790 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073037.9801 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073037.9808 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.2900 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.1110 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.3190 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.4680 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.6770 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.7290 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.7410 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.7860 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.9850 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.9920 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.1003 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.1015 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.1285 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.1454 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240319@073038.1805 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2021 and bo.obrano = 2402192 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240319@073038.1888 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.1930 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240319@073038.2184 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.2320 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 1 valor from td where td.ndoc = 39
20240319@073038.2649 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.2690 rp56cq2rqnju7fdts7auc7ml7q Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240319@073038.2773 rp56cq2rqnju7fdts7auc7ml7q 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
20240319@073038.2930 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.2937 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240319@073038.2949 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.2953 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240319@073038.2972 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.2978 rp56cq2rqnju7fdts7auc7ml7q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240319@073038.3191 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.3232 rp56cq2rqnju7fdts7auc7ml7q Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240319@073038.3262 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.3266 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from td where ndoc = 39
20240319@073038.3521 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240319@073038.3774 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073038.4031 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240319@073038.4171 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073038.4323 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240319@073038.4366 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073038.4741 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240319@073038.4767 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073038.5154 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240319@073038.5361 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240319@073038.5573 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240319@073038.5719 rp56cq2rqnju7fdts7auc7ml7q Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut65f936311365f93f1e74' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240319@073038.6322 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240319@073038.6626 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240319@073038.6940 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240319@073038.7067 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240319@073038.7170 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240319@073038.7422 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240319@073038.7591 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240319@073038.7730 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240319@073038.7810 rp56cq2rqnju7fdts7auc7ml7q Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut65f936311365f93f1e74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240319@073038.8408 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 fno valor from wsft039data order by fno desc
20240319@073038.8521 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240319@073038.8538 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240319@073038.8567 rp56cq2rqnju7fdts7auc7ml7q 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 ('aut65f936311365f93f1e74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',505,100810,0,'2024-03-19',39,'euro',0,0,2024 ,'20240319','0800',?,?,?,?)
20240319@073038.9251 rp56cq2rqnju7fdts7auc7ml7q Query : use flama_phc
20240319@073038.9294 rp56cq2rqnju7fdts7auc7ml7q Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240319@073038.9506 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20240319@073038.9987 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073039.1490 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073039.3150 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073039.3320 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073039.3430 rp56cq2rqnju7fdts7auc7ml7q Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301096100a'
20240319@073039.3540 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073039.6120 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073039.6480 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073039.1160 rp56cq2rqnju7fdts7auc7ml7q Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut65f933763665f93f1f0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut65f936311365f93f1e74' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240319@073039.2033 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073039.2276 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073039.2281 rp56cq2rqnju7fdts7auc7ml7q Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f933763665f93f1f0e','aut65f936311365f93f1e74' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240319@073039.2287 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073039.2301 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240319@073039.2536 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073039.2615 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240319@073039.2704 rp56cq2rqnju7fdts7auc7ml7q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240319@073039.2912 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240319@073039.3124 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240319@073039.3757 rp56cq2rqnju7fdts7auc7ml7q Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut65f938626565f93f1f47',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut65f936311365f93f1e74' ,0,0 ,2,23.00,20000,?,?,?)
20240319@073039.4245 rp56cq2rqnju7fdts7auc7ml7q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240319@073039.4324 rp56cq2rqnju7fdts7auc7ml7q Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240319@073039.4330 rp56cq2rqnju7fdts7auc7ml7q Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut65f938626565f93f1f47','aut65f936311365f93f1e74' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
