20240408@180758.9183 j83uvl6792seu8otjs8tgsp7da Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142186696614246ed7','aut66142901606614246eb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180758.9189 j83uvl6792seu8otjs8tgsp7da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180758.9203 j83uvl6792seu8otjs8tgsp7da Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180758.9226 j83uvl6792seu8otjs8tgsp7da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180758.9241 j83uvl6792seu8otjs8tgsp7da Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180758.9245 j83uvl6792seu8otjs8tgsp7da Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180758.9257 j83uvl6792seu8otjs8tgsp7da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180758.9270 j83uvl6792seu8otjs8tgsp7da Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180758.9293 j83uvl6792seu8otjs8tgsp7da Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66142194626614246ee2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66142901606614246eb6' ,0,0 ,2,23.00,20000,?,?,?)
20240408@180758.9604 j83uvl6792seu8otjs8tgsp7da Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180758.9620 j83uvl6792seu8otjs8tgsp7da Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180758.9624 j83uvl6792seu8otjs8tgsp7da Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142194626614246ee2','aut66142901606614246eb6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180758.9630 j83uvl6792seu8otjs8tgsp7da Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66142901606614246eb6','2402626','wait',39,'ari17112337378,753000005')
20240408@180758.9646 j83uvl6792seu8otjs8tgsp7da Query : use flama_phc
20240408@180758.9650 j83uvl6792seu8otjs8tgsp7da Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240408@180758.9662 j83uvl6792seu8otjs8tgsp7da Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1028';
20240408@180758.9682 j83uvl6792seu8otjs8tgsp7da Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1028';
20240408@180758.9697 j83uvl6792seu8otjs8tgsp7da Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1028';
20240408@180758.9714 j83uvl6792seu8otjs8tgsp7da Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1028';
20240408@180759.8700 mgb9029f6bhpbkv4489tncqv2p Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240408@180759.1000 mgb9029f6bhpbkv4489tncqv2p Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240408@180759.1220 mgb9029f6bhpbkv4489tncqv2p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1029';
20240408@180759.1680 mgb9029f6bhpbkv4489tncqv2p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1029';
20240408@180759.1840 mgb9029f6bhpbkv4489tncqv2p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1029';
20240408@180759.1970 mgb9029f6bhpbkv4489tncqv2p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1029';
20240408@180759.2110 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.2140 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240408@180759.2270 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.2300 mgb9029f6bhpbkv4489tncqv2p Query : select no, estab,szadrsdesc from szadrs where u_coddest=3145
20240408@180759.3180 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20240408@180759.4690 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402630 and bi.ref ='324.1643.00.1' and bi.lordem =1
20240408@180759.7630 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.7660 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240408@180759.7820 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.7840 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 1 valor from td where td.ndoc = 39
20240408@180759.7940 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.7970 mgb9029f6bhpbkv4489tncqv2p Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240408@180759.8070 mgb9029f6bhpbkv4489tncqv2p 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
20240408@180759.8220 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.8240 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240408@180759.8350 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.8380 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240408@180759.8480 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.8510 mgb9029f6bhpbkv4489tncqv2p Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240408@180759.8610 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.8640 mgb9029f6bhpbkv4489tncqv2p Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - caldas da rainha'
20240408@180759.8770 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.8790 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from td where ndoc = 39
20240408@180759.8890 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240408@180759.9000 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180759.9140 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240408@180759.9310 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180759.9450 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240408@180759.9720 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180759.9850 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240408@180759.9950 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180759.1091 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180759.1100 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180759.1113 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240408@180759.1123 mgb9029f6bhpbkv4489tncqv2p Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66142212486614246f18' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240408@180759.1317 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180759.1332 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240408@180759.1359 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240408@180759.1364 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240408@180759.1369 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240408@180759.1373 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240408@180759.1378 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240408@180759.1383 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240408@180759.1387 mgb9029f6bhpbkv4489tncqv2p Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66142212486614246f18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240408@180759.1692 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 fno valor from wsft039data order by fno desc
20240408@180759.1712 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180759.1726 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240408@180759.1744 mgb9029f6bhpbkv4489tncqv2p 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 ('aut66142212486614246f18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',793,101621,0,'2024-04-08',39,'euro',0,0,2024 ,'20240408','1837',?,?,?,?)
20240408@180759.2084 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.2088 mgb9029f6bhpbkv4489tncqv2p Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240408@180759.2101 mgb9029f6bhpbkv4489tncqv2p 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.1643.00.1'
20240408@180759.2258 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.2272 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180759.2295 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.2308 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180759.2314 mgb9029f6bhpbkv4489tncqv2p Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240408@180759.2331 mgb9029f6bhpbkv4489tncqv2p Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180759.2340 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.2353 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180759.2376 mgb9029f6bhpbkv4489tncqv2p Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66142456006614246f39',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66142212486614246f18' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240408@180759.2692 mgb9029f6bhpbkv4489tncqv2p Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.2709 mgb9029f6bhpbkv4489tncqv2p Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180759.2714 mgb9029f6bhpbkv4489tncqv2p Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142456006614246f39','aut66142212486614246f18' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180759.2719 mgb9029f6bhpbkv4489tncqv2p Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66142212486614246f18','2402630','wait',39,'ari17112337378,753000005')
20240408@180759.2736 mgb9029f6bhpbkv4489tncqv2p Query : use flama_phc
20240408@180759.2739 mgb9029f6bhpbkv4489tncqv2p Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240408@180759.2751 mgb9029f6bhpbkv4489tncqv2p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1029';
20240408@180759.2772 mgb9029f6bhpbkv4489tncqv2p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1029';
20240408@180759.2787 mgb9029f6bhpbkv4489tncqv2p Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1029';
20240408@180759.2802 mgb9029f6bhpbkv4489tncqv2p Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1029';
20240408@180759.3192 aroor347b3ocmjom3v76kij0io Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240408@180759.3207 aroor347b3ocmjom3v76kij0io Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240408@180759.3234 aroor347b3ocmjom3v76kij0io Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1030';
20240408@180759.3295 aroor347b3ocmjom3v76kij0io Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1030';
20240408@180759.3314 aroor347b3ocmjom3v76kij0io Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1030';
20240408@180759.3329 aroor347b3ocmjom3v76kij0io Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1030';
20240408@180759.3343 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.3347 aroor347b3ocmjom3v76kij0io Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240408@180759.3362 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.3365 aroor347b3ocmjom3v76kij0io Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20240408@180759.3483 aroor347b3ocmjom3v76kij0io 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'
20240408@180759.3673 aroor347b3ocmjom3v76kij0io Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402631 and bi.ref ='324.691.00.01' and bi.lordem =1
20240408@180759.4043 aroor347b3ocmjom3v76kij0io 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'
20240408@180759.4055 aroor347b3ocmjom3v76kij0io Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402631 and bi.ref ='324.691.00.01' and bi.lordem =2
20240408@180759.5020 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5074 aroor347b3ocmjom3v76kij0io Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240408@180759.5408 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5532 aroor347b3ocmjom3v76kij0io Query : select top 1 1 valor from td where td.ndoc = 39
20240408@180759.5690 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5694 aroor347b3ocmjom3v76kij0io Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240408@180759.5706 aroor347b3ocmjom3v76kij0io 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
20240408@180759.5721 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5724 aroor347b3ocmjom3v76kij0io Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240408@180759.5735 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5737 aroor347b3ocmjom3v76kij0io Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240408@180759.5748 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5751 aroor347b3ocmjom3v76kij0io Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240408@180759.5761 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5764 aroor347b3ocmjom3v76kij0io Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - corroios'
20240408@180759.5779 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.5782 aroor347b3ocmjom3v76kij0io Query : select 1 valor from td where ndoc = 39
20240408@180759.5793 aroor347b3ocmjom3v76kij0io Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240408@180759.5805 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180759.5836 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240408@180759.5853 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180759.5866 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240408@180759.5892 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180759.5906 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240408@180759.5916 aroor347b3ocmjom3v76kij0io Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180759.6023 aroor347b3ocmjom3v76kij0io Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180759.6033 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180759.6047 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240408@180759.6060 aroor347b3ocmjom3v76kij0io Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66142679526614246f90' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240408@180759.6291 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180759.6308 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240408@180759.6337 aroor347b3ocmjom3v76kij0io Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240408@180759.6342 aroor347b3ocmjom3v76kij0io Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240408@180759.6347 aroor347b3ocmjom3v76kij0io Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240408@180759.6351 aroor347b3ocmjom3v76kij0io Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240408@180759.6356 aroor347b3ocmjom3v76kij0io Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240408@180759.6361 aroor347b3ocmjom3v76kij0io Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240408@180759.6365 aroor347b3ocmjom3v76kij0io Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66142679526614246f90',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240408@180759.6697 aroor347b3ocmjom3v76kij0io Query : select top 1 fno valor from wsft039data order by fno desc
20240408@180759.6719 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180759.6758 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240408@180759.6777 aroor347b3ocmjom3v76kij0io 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 ('aut66142679526614246f90',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',794,101621,0,'2024-04-08',39,'euro',0,0,2024 ,'20240408','1837',?,?,?,?)
20240408@180759.7129 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.7133 aroor347b3ocmjom3v76kij0io Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240408@180759.7148 aroor347b3ocmjom3v76kij0io 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'
20240408@180759.7345 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.7360 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180759.7384 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.7399 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180759.7405 aroor347b3ocmjom3v76kij0io Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240408@180759.7418 aroor347b3ocmjom3v76kij0io Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180759.7430 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.7444 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180759.7469 aroor347b3ocmjom3v76kij0io Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66142959846614246fb5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66142679526614246f90' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240408@180759.7805 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.7824 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180759.7830 aroor347b3ocmjom3v76kij0io Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142959846614246fb5','aut66142679526614246f90' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180759.7838 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.7856 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180759.7882 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.7896 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180759.7901 aroor347b3ocmjom3v76kij0io Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180759.7918 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.7932 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180759.7954 aroor347b3ocmjom3v76kij0io Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66142689706614246fc1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66142679526614246f90' ,0,0 ,2,23.00,20000,?,?,?)
20240408@180759.8267 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.8286 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180759.8293 aroor347b3ocmjom3v76kij0io Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142689706614246fc1','aut66142679526614246f90' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180759.8297 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.8300 aroor347b3ocmjom3v76kij0io Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240408@180759.8312 aroor347b3ocmjom3v76kij0io 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'
20240408@180759.8324 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.8338 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180759.8361 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.8373 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180759.8379 aroor347b3ocmjom3v76kij0io Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2301201200a'
20240408@180759.8390 aroor347b3ocmjom3v76kij0io Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180759.8400 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.8413 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180759.8438 aroor347b3ocmjom3v76kij0io Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66142546916614246fcd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66142679526614246f90' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240408@180759.8856 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.8873 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180759.8878 aroor347b3ocmjom3v76kij0io Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142546916614246fcd','aut66142679526614246f90' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180759.8884 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.8898 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180759.8923 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.8936 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180759.8941 aroor347b3ocmjom3v76kij0io Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180759.8953 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180759.8965 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180759.8993 aroor347b3ocmjom3v76kij0io Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66142013246614246fda',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66142679526614246f90' ,0,0 ,2,23.00,50000,?,?,?)
20240408@180759.9332 aroor347b3ocmjom3v76kij0io Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180759.9349 aroor347b3ocmjom3v76kij0io Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180759.9354 aroor347b3ocmjom3v76kij0io Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142013246614246fda','aut66142679526614246f90' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180759.9360 aroor347b3ocmjom3v76kij0io Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66142679526614246f90','2402631','wait',39,'ari17112337378,753000005')
20240408@180759.9378 aroor347b3ocmjom3v76kij0io Query : use flama_phc
20240408@180759.9382 aroor347b3ocmjom3v76kij0io Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240408@180759.9398 aroor347b3ocmjom3v76kij0io Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1030';
20240408@180759.9419 aroor347b3ocmjom3v76kij0io Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1030';
20240408@180759.9436 aroor347b3ocmjom3v76kij0io Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1030';
20240408@180759.9453 aroor347b3ocmjom3v76kij0io Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1030';
20240408@180759.9897 mgfvtfcmm03vldoig2col8iven Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240408@180759.9912 mgfvtfcmm03vldoig2col8iven Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240408@180759.9936 mgfvtfcmm03vldoig2col8iven Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1031';
20240408@180759.9982 mgfvtfcmm03vldoig2col8iven Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1031';
20240408@180800.0000 mgfvtfcmm03vldoig2col8iven Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1031';
20240408@180800.1400 mgfvtfcmm03vldoig2col8iven Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1031';
20240408@180800.2700 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.3100 mgfvtfcmm03vldoig2col8iven Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240408@180800.4400 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.4700 mgfvtfcmm03vldoig2col8iven Query : select no, estab,szadrsdesc from szadrs where u_coddest=4500
20240408@180800.1390 mgfvtfcmm03vldoig2col8iven Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20240408@180800.2980 mgfvtfcmm03vldoig2col8iven Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402633 and bi.ref ='304.421.00.04' and bi.lordem =1
20240408@180800.6290 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.6330 mgfvtfcmm03vldoig2col8iven Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240408@180800.6480 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.6520 mgfvtfcmm03vldoig2col8iven Query : select top 1 1 valor from td where td.ndoc = 39
20240408@180800.6640 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.6670 mgfvtfcmm03vldoig2col8iven Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240408@180800.6780 mgfvtfcmm03vldoig2col8iven 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
20240408@180800.6930 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.6960 mgfvtfcmm03vldoig2col8iven Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20240408@180800.7070 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.7100 mgfvtfcmm03vldoig2col8iven Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240408@180800.7210 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.7240 mgfvtfcmm03vldoig2col8iven Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240408@180800.7370 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.7410 mgfvtfcmm03vldoig2col8iven Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - portimão'
20240408@180800.7560 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.7590 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from td where ndoc = 39
20240408@180800.7700 mgfvtfcmm03vldoig2col8iven Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240408@180800.7870 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180800.8020 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240408@180800.8220 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180800.8390 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240408@180800.8690 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180800.8840 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240408@180800.8960 mgfvtfcmm03vldoig2col8iven Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180800.9920 mgfvtfcmm03vldoig2col8iven Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180800.1003 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180800.1018 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240408@180800.1030 mgfvtfcmm03vldoig2col8iven Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66142649566614247015' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240408@180800.1230 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180800.1246 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240408@180800.1277 mgfvtfcmm03vldoig2col8iven Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240408@180800.1284 mgfvtfcmm03vldoig2col8iven Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240408@180800.1290 mgfvtfcmm03vldoig2col8iven Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240408@180800.1295 mgfvtfcmm03vldoig2col8iven Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240408@180800.1300 mgfvtfcmm03vldoig2col8iven Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240408@180800.1306 mgfvtfcmm03vldoig2col8iven Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240408@180800.1311 mgfvtfcmm03vldoig2col8iven Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66142649566614247015',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240408@180800.1607 mgfvtfcmm03vldoig2col8iven Query : select top 1 fno valor from wsft039data order by fno desc
20240408@180800.1626 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180800.1642 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240408@180800.1662 mgfvtfcmm03vldoig2col8iven 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 ('aut66142649566614247015',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',795,101621,0,'2024-04-08',39,'euro',0,0,2024 ,'20240408','1837',?,?,?,?)
20240408@180800.2000 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.2004 mgfvtfcmm03vldoig2col8iven Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20240408@180800.2018 mgfvtfcmm03vldoig2col8iven Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '304.421.00.04'
20240408@180800.2206 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180800.2225 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180800.2253 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180800.2269 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180800.2274 mgfvtfcmm03vldoig2col8iven Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '240432'
20240408@180800.2295 mgfvtfcmm03vldoig2col8iven Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180800.2309 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180800.2324 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180800.3576 mgfvtfcmm03vldoig2col8iven Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66142618516614247038',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66142649566614247015' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240408@180800.3861 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180800.3878 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180800.3884 mgfvtfcmm03vldoig2col8iven Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142618516614247038','aut66142649566614247015' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180800.3890 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180800.3904 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180800.3926 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180800.3938 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180800.3942 mgfvtfcmm03vldoig2col8iven Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180800.3952 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180800.3964 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180800.3988 mgfvtfcmm03vldoig2col8iven Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66142101166614247060',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66142649566614247015' ,0,0 ,2,23.00,20000,?,?,?)
20240408@180800.4277 mgfvtfcmm03vldoig2col8iven Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180800.4293 mgfvtfcmm03vldoig2col8iven Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180800.4297 mgfvtfcmm03vldoig2col8iven Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142101166614247060','aut66142649566614247015' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180800.4302 mgfvtfcmm03vldoig2col8iven Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66142649566614247015','2402633','wait',39,'ari17112337378,753000005')
20240408@180800.4318 mgfvtfcmm03vldoig2col8iven Query : use flama_phc
20240408@180800.4321 mgfvtfcmm03vldoig2col8iven Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240408@180800.4332 mgfvtfcmm03vldoig2col8iven Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1031';
20240408@180800.4351 mgfvtfcmm03vldoig2col8iven Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1031';
20240408@180800.4365 mgfvtfcmm03vldoig2col8iven Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1031';
20240408@180800.4379 mgfvtfcmm03vldoig2col8iven Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1031';
20240408@180800.4787 hde8gnvto132geffk2eqek0g44 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240408@180800.4801 hde8gnvto132geffk2eqek0g44 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240408@180800.4823 hde8gnvto132geffk2eqek0g44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1032';
20240408@180800.4872 hde8gnvto132geffk2eqek0g44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1032';
20240408@180800.4889 hde8gnvto132geffk2eqek0g44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1032';
20240408@180800.4903 hde8gnvto132geffk2eqek0g44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1032';
20240408@180800.4920 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.4924 hde8gnvto132geffk2eqek0g44 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240408@180800.4938 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.4943 hde8gnvto132geffk2eqek0g44 Query : select no, estab,szadrsdesc from szadrs where u_coddest=376
20240408@180800.5046 hde8gnvto132geffk2eqek0g44 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1547.00.1'
20240408@180800.5223 hde8gnvto132geffk2eqek0g44 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402634 and bi.ref ='324.1547.00.1' and bi.lordem =1
20240408@180800.5566 hde8gnvto132geffk2eqek0g44 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1536.00.1'
20240408@180800.5719 hde8gnvto132geffk2eqek0g44 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402634 and bi.ref ='324.1536.00.1' and bi.lordem =2
20240408@180800.6167 hde8gnvto132geffk2eqek0g44 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240408@180800.6354 hde8gnvto132geffk2eqek0g44 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402634 and bi.ref ='324.948.00.01' and bi.lordem =3
20240408@180800.6717 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6723 hde8gnvto132geffk2eqek0g44 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240408@180800.6740 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6743 hde8gnvto132geffk2eqek0g44 Query : select top 1 1 valor from td where td.ndoc = 39
20240408@180800.6757 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6761 hde8gnvto132geffk2eqek0g44 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240408@180800.6774 hde8gnvto132geffk2eqek0g44 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
20240408@180800.6791 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6794 hde8gnvto132geffk2eqek0g44 Query : select top 1 ~inactivo valor from cl where no = '100403' and estab = 0 order by inactivo desc
20240408@180800.6923 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6927 hde8gnvto132geffk2eqek0g44 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240408@180800.6943 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6948 hde8gnvto132geffk2eqek0g44 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240408@180800.6961 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6965 hde8gnvto132geffk2eqek0g44 Query : select szadrsstamp valor from szadrs where szadrsdesc='mario ventura'
20240408@180800.6981 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.6985 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from td where ndoc = 39
20240408@180800.6996 hde8gnvto132geffk2eqek0g44 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240408@180800.7009 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180800.7030 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240408@180800.7051 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180800.7069 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240408@180800.7102 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180800.7117 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240408@180800.7129 hde8gnvto132geffk2eqek0g44 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180800.7270 hde8gnvto132geffk2eqek0g44 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180800.7283 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180800.7300 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240408@180800.7314 hde8gnvto132geffk2eqek0g44 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661424375766142470ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240408@180800.7522 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180800.7539 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240408@180800.7592 hde8gnvto132geffk2eqek0g44 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240408@180800.7598 hde8gnvto132geffk2eqek0g44 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240408@180800.7603 hde8gnvto132geffk2eqek0g44 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240408@180800.7609 hde8gnvto132geffk2eqek0g44 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240408@180800.7615 hde8gnvto132geffk2eqek0g44 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240408@180800.7620 hde8gnvto132geffk2eqek0g44 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240408@180800.7626 hde8gnvto132geffk2eqek0g44 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661424375766142470ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240408@180800.7920 hde8gnvto132geffk2eqek0g44 Query : select top 1 fno valor from wsft039data order by fno desc
20240408@180800.7944 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180800.7965 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240408@180800.7988 hde8gnvto132geffk2eqek0g44 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 ('aut661424375766142470ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',796,100403,0,'2024-04-08',39,'euro',0,0,2024 ,'20240408','1838',?,?,?,?)
20240408@180800.8364 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.8369 hde8gnvto132geffk2eqek0g44 Query : select st.usalote valor from st where st.ref = '324.1547.00.1'
20240408@180800.8385 hde8gnvto132geffk2eqek0g44 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.1547.00.1'
20240408@180800.8554 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180800.8570 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180800.8598 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180800.8640 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180800.8644 hde8gnvto132geffk2eqek0g44 Query : select sestamp valor from se where ref ='324.1547.00.1' and lote = 'r2100242100a'
20240408@180800.8656 hde8gnvto132geffk2eqek0g44 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180800.8666 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180800.8681 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180800.8708 hde8gnvto132geffk2eqek0g44 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut661428576066142470d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut661424375766142470ae' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240408@180800.9088 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180800.9110 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180800.9114 hde8gnvto132geffk2eqek0g44 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut661428576066142470d3','aut661424375766142470ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180800.9119 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180800.9123 hde8gnvto132geffk2eqek0g44 Query : select st.usalote valor from st where st.ref = '324.1536.00.1'
20240408@180800.9135 hde8gnvto132geffk2eqek0g44 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.1536.00.1'
20240408@180801.4260 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180801.4430 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180801.4670 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180801.4820 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180801.5030 hde8gnvto132geffk2eqek0g44 Query : select sestamp valor from se where ref ='324.1536.00.1' and lote = 'r2100240100a'
20240408@180801.5180 hde8gnvto132geffk2eqek0g44 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180801.5300 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180801.5420 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180801.5650 hde8gnvto132geffk2eqek0g44 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6614234390661424710c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut661424375766142470ae' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240408@180801.8620 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180801.8820 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180801.8870 hde8gnvto132geffk2eqek0g44 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6614234390661424710c','aut661424375766142470ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180801.8910 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180801.8940 hde8gnvto132geffk2eqek0g44 Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240408@180801.9050 hde8gnvto132geffk2eqek0g44 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.948.00.01'
20240408@180801.1061 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180801.1077 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180801.1100 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180801.1113 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180801.1117 hde8gnvto132geffk2eqek0g44 Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2300909200a'
20240408@180801.1128 hde8gnvto132geffk2eqek0g44 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180801.1139 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180801.1153 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180801.1176 hde8gnvto132geffk2eqek0g44 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6614201800661424711b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut661424375766142470ae' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240408@180801.1506 hde8gnvto132geffk2eqek0g44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180801.1525 hde8gnvto132geffk2eqek0g44 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180801.1530 hde8gnvto132geffk2eqek0g44 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6614201800661424711b','aut661424375766142470ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180801.1535 hde8gnvto132geffk2eqek0g44 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut661424375766142470ae','2402634','wait',39,'ari17112337378,753000005')
20240408@180801.1551 hde8gnvto132geffk2eqek0g44 Query : use flama_phc
20240408@180801.1557 hde8gnvto132geffk2eqek0g44 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240408@180801.1568 hde8gnvto132geffk2eqek0g44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1032';
20240408@180801.1590 hde8gnvto132geffk2eqek0g44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1032';
20240408@180801.1605 hde8gnvto132geffk2eqek0g44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1032';
20240408@180801.1618 hde8gnvto132geffk2eqek0g44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1032';
20240408@180801.2087 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240408@180801.2110 4o5mt5k92tv7ujteaifmi5e9l1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240408@180801.2160 4o5mt5k92tv7ujteaifmi5e9l1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1033';
20240408@180801.2205 4o5mt5k92tv7ujteaifmi5e9l1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1033';
20240408@180801.2222 4o5mt5k92tv7ujteaifmi5e9l1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1033';
20240408@180801.2236 4o5mt5k92tv7ujteaifmi5e9l1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1033';
20240408@180801.2251 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.2256 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240408@180801.2270 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.2311 4o5mt5k92tv7ujteaifmi5e9l1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2588
20240408@180801.2451 4o5mt5k92tv7ujteaifmi5e9l1 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'
20240408@180801.2462 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.5342.00.1' and bi.lordem =1
20240408@180801.2826 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4902.00.1'
20240408@180801.2983 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.4902.00.1' and bi.lordem =2
20240408@180801.3305 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20240408@180801.3317 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.958.00.01' and bi.lordem =3
20240408@180801.3711 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20240408@180801.3902 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.681.00.01' and bi.lordem =4
20240408@180801.4270 4o5mt5k92tv7ujteaifmi5e9l1 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'
20240408@180801.4286 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.1879.00.1' and bi.lordem =5
20240408@180801.4901 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2907.00.1'
20240408@180801.4917 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.2907.00.1' and bi.lordem =6
20240408@180801.5326 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20240408@180801.5389 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.4970.00.1' and bi.lordem =7
20240408@180801.5759 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20240408@180801.5774 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.642.00.01' and bi.lordem =8
20240408@180801.6142 4o5mt5k92tv7ujteaifmi5e9l1 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'
20240408@180801.6154 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.1407.00.1' and bi.lordem =9
20240408@180801.6546 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2231.00.1'
20240408@180801.6712 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.2231.00.1' and bi.lordem =10
20240408@180801.7030 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20240408@180801.7185 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.2232.00.1' and bi.lordem =11
20240408@180801.7721 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5365.00.1'
20240408@180801.7879 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.5365.00.1' and bi.lordem =12
20240408@180801.8292 4o5mt5k92tv7ujteaifmi5e9l1 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'
20240408@180801.8479 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2026 and bo.obrano = 2402636 and bi.ref ='324.5396.00.1' and bi.lordem =13
20240408@180801.8797 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.8802 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240408@180801.8817 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.8821 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 1 valor from td where td.ndoc = 39
20240408@180801.8833 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.8837 4o5mt5k92tv7ujteaifmi5e9l1 Query : select descricao ,case when valor='s' then 1 else 0 end usalotes from para1 where descricao in ('st_lote')
20240408@180801.8850 4o5mt5k92tv7ujteaifmi5e9l1 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
20240408@180801.8867 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.8870 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 ~inactivo valor from cl where no = '102561' and estab = 0 order by inactivo desc
20240408@180801.8976 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.8981 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240408@180801.8993 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.8996 4o5mt5k92tv7ujteaifmi5e9l1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240408@180801.9008 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.9011 4o5mt5k92tv7ujteaifmi5e9l1 Query : select szadrsstamp valor from szadrs where szadrsdesc='caisdis sociedade de distribuiÇÃo s a'
20240408@180801.9026 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180801.9029 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from td where ndoc = 39
20240408@180801.9041 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240408@180801.9052 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180801.9066 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft039fields
20240408@180801.9083 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180801.9098 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft2039fields
20240408@180801.9123 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180801.9172 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsft3039fields
20240408@180801.9183 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180801.9277 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 ft.fno valor from wsft039data ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240408@180801.9287 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft3039fields'
20240408@180801.9302 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft3039fields
20240408@180801.9312 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsft3039data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut661426835866142471e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240408@180801.9513 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft2039fields'
20240408@180801.9534 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft2039fields
20240408@180801.9563 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240408@180801.9568 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240408@180801.9573 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240408@180801.9578 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240408@180801.9583 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240408@180801.9587 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240408@180801.9591 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsft2039data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut661426835866142471e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240408@180801.9894 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 fno valor from wsft039data order by fno desc
20240408@180801.9914 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsft039fields'
20240408@180801.9930 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsft039fields
20240408@180801.9964 4o5mt5k92tv7ujteaifmi5e9l1 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 ('aut661426835866142471e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',797,102561,0,'2024-04-08',39,'euro',0,0,2024 ,'20240408','1838',?,?,?,?)
20240408@180802.3620 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180802.3680 4o5mt5k92tv7ujteaifmi5e9l1 Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240408@180802.3830 4o5mt5k92tv7ujteaifmi5e9l1 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'
20240408@180802.3990 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.4130 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180802.4430 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.4570 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180802.4620 4o5mt5k92tv7ujteaifmi5e9l1 Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2301282200a'
20240408@180802.4720 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180802.4820 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.4950 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180802.5200 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6614250769661424720b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut661426835866142471e0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240408@180802.8680 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.8850 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180802.8890 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6614250769661424720b','aut661426835866142471e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180802.8940 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.9080 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180802.9380 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.9540 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180802.9590 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180802.9700 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.9850 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180802.1009 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66142817086614247217',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut661426835866142471e0' ,0,0 ,2,23.00,20000,?,?,?)
20240408@180802.1318 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.1347 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180802.1351 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142817086614247217','aut661426835866142471e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180802.1355 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180802.1359 4o5mt5k92tv7ujteaifmi5e9l1 Query : select st.usalote valor from st where st.ref = '324.4902.00.1'
20240408@180802.1372 4o5mt5k92tv7ujteaifmi5e9l1 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.4902.00.1'
20240408@180802.1554 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.1568 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180802.1593 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.1607 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180802.1613 4o5mt5k92tv7ujteaifmi5e9l1 Query : select sestamp valor from se where ref ='324.4902.00.1' and lote = 'r2300206100a'
20240408@180802.1624 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180802.1634 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.1650 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180802.1674 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66142447956614247227',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut661426835866142471e0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240408@180802.1995 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.2011 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180802.2016 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142447956614247227','aut661426835866142471e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180802.2020 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.2037 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180802.2061 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.2075 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180802.2079 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180802.2091 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.3312 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180802.3339 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66142116606614247233',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut661426835866142471e0' ,0,0 ,2,23.00,50000,?,?,?)
20240408@180802.3780 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.3795 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi2039fields
20240408@180802.3800 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi2039data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66142116606614247233','aut661426835866142471e0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240408@180802.3804 4o5mt5k92tv7ujteaifmi5e9l1 Query : use flama_phc
20240408@180802.3807 4o5mt5k92tv7ujteaifmi5e9l1 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240408@180802.3821 4o5mt5k92tv7ujteaifmi5e9l1 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.958.00.01'
20240408@180802.3834 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.3851 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi039fields
20240408@180802.3874 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi2039fields'
20240408@180802.3887 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,mandatory from wsfi2039fields
20240408@180802.3892 4o5mt5k92tv7ujteaifmi5e9l1 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2301081100a'
20240408@180802.3903 4o5mt5k92tv7ujteaifmi5e9l1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240408@180802.3913 4o5mt5k92tv7ujteaifmi5e9l1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wsfi039fields'
20240408@180802.3925 4o5mt5k92tv7ujteaifmi5e9l1 Query : select fieldkey,fieldname,fieldtype,calcformula from wsfi039fields
20240408@180802.3949 4o5mt5k92tv7ujteaifmi5e9l1 Query : insert into wsfi039data (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6614209391661424725f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut661426835866142471e0' ,0,0 ,2,23.00,70000,?,?,?,?,?)
