20240925@113655.4576 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1705.00.1'
20240925@113655.4716 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1705.00.1'
20240925@113655.4741 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2028.00.2'
20240925@113655.4884 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5500.00.1'
20240925@113655.5013 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5540.00.1'
20240925@113655.5142 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5540.00.1'
20240925@113655.5171 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5501.00.1'
20240925@113655.5306 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5501.00.1'
20240925@113655.5323 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5396.00.1'
20240925@113655.5447 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5396.00.1'
20240925@113655.5465 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1462.00.1'
20240925@113655.5599 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1824.00.1'
20240925@113655.5733 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1690.00.1'
20240925@113655.5899 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1690.00.1'
20240925@113655.5920 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1608.00.1'
20240925@113655.6050 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1642.00.2'
20240925@113655.6209 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.4320.00.1'
20240925@113655.6336 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4751.00.1'
20240925@113655.6482 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4421.00.1'
20240925@113655.6618 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4521.00.1'
20240925@113655.6751 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4585.00.1'
20240925@113655.6886 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4961.00.1'
20240925@113655.7001 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4980.00.1'
20240925@113655.7121 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.958.00.01'
20240925@113655.7241 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.969.00.01'
20240925@113655.7348 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.969.00.01'
20240925@113655.7366 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.948.00.01'
20240925@113655.7486 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.948.00.01'
20240925@113655.7509 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.988.00.01'
20240925@113655.7619 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.988.00.01'
20240925@113655.7655 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.946.00.01'
20240925@113655.7800 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4970.00.1'
20240925@113655.7914 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.421.00.04'
20240925@113655.8094 vkpm3alvf93tl1btdjs23mf2jk Query : use flama_phc
20240925@113655.8097 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 1 valor from ts where ts.ndos = 5
20240925@113655.8198 vkpm3alvf93tl1btdjs23mf2jk Query : use flama_phc
20240925@113655.8208 vkpm3alvf93tl1btdjs23mf2jk Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240925@113655.8251 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240925@113655.8423 vkpm3alvf93tl1btdjs23mf2jk Query : use flama_phc
20240925@113655.8431 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 ~inactivo valor from fl where no = '102245' and estab = 0 order by inactivo desc
20240925@113655.8582 vkpm3alvf93tl1btdjs23mf2jk Query : use flama_phc
20240925@113655.8585 vkpm3alvf93tl1btdjs23mf2jk Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20240925@113655.8716 vkpm3alvf93tl1btdjs23mf2jk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2211';
20240925@113655.8793 vkpm3alvf93tl1btdjs23mf2jk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2211';

20240925@162619.8737 tfd19umiehonvlb4e2mjv9hvcm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2212';
20240925@162619.8803 tfd19umiehonvlb4e2mjv9hvcm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2212';
20240925@162619.8827 tfd19umiehonvlb4e2mjv9hvcm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2212';
20240925@162619.9699 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240925@162619.9710 kvfsop3m9ki13enmnn4mo8k5ps Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240925@162619.9763 kvfsop3m9ki13enmnn4mo8k5ps Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2213';
20240925@162619.9821 kvfsop3m9ki13enmnn4mo8k5ps Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2213';
20240925@162619.9874 kvfsop3m9ki13enmnn4mo8k5ps Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2213';
20240925@162619.9898 kvfsop3m9ki13enmnn4mo8k5ps Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2213';
20240925@162619.9936 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162619.9939 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240925@162620.4600 kvfsop3m9ki13enmnn4mo8k5ps Query : select no, estab,szadrsdesc from szadrs where u_coddest=23
20240925@162620.1760 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5540.00.1'
20240925@162620.3470 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.5540.00.1' and bi.lordem =10000
20240925@162620.7290 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351699,025000001 ' 
20240925@162620.1057 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1716.00.1'
20240925@162620.1922 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.1716.00.1' and bi.lordem =20000
20240925@162620.2332 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351739,384000002 ' 
20240925@162620.2704 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1317.00.1'
20240925@162620.2842 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.1317.00.1' and bi.lordem =30000
20240925@162620.3431 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351764,895000003 ' 
20240925@162620.3769 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1321.00.1'
20240925@162620.3898 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.1321.00.1' and bi.lordem =40000
20240925@162620.4479 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351782,541000004 ' 
20240925@162620.4798 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1329.00.1'
20240925@162620.4921 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.1329.00.1' and bi.lordem =50000
20240925@162620.5302 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351796,264000005 ' 
20240925@162620.5644 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '328.9902.00.1'
20240925@162620.5780 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='328.9902.00.1' and bi.lordem =60000
20240925@162620.6117 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351805,359000006 ' 
20240925@162620.6421 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1879.00.1'
20240925@162620.6540 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.1879.00.1' and bi.lordem =70000
20240925@162620.6875 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351835,126000007 ' 
20240925@162620.7197 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1879.00.1'
20240925@162620.7220 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.1879.00.1' and bi.lordem =70000
20240925@162620.7243 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351835,126000007 ' 
20240925@162620.7265 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.969.00.01'
20240925@162620.7415 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.969.00.01' and bi.lordem =80000
20240925@162620.8167 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351912,078000008 ' 
20240925@162620.8673 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.691.00.01'
20240925@162620.9047 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.691.00.01' and bi.lordem =90000
20240925@162620.9456 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351945,547000009 ' 
20240925@162620.9753 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.691.00.01'
20240925@162620.9774 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='324.691.00.01' and bi.lordem =90000
20240925@162620.9794 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351945,547000009 ' 
20240925@162620.9814 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '323.318.09.00'
20240925@162621.1670 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='323.318.09.00' and bi.lordem =100000
20240925@162621.7110 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351993,114000010 ' 
20240925@162621.1046 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '323.318.09.00'
20240925@162621.1069 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000037 and bi.ref ='323.318.09.00' and bi.lordem =100000
20240925@162621.1091 kvfsop3m9ki13enmnn4mo8k5ps Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24092351993,114000010 ' 
20240925@162621.1125 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.1129 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 1 valor from ts where ts.ndos = 5
20240925@162621.1238 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.1241 kvfsop3m9ki13enmnn4mo8k5ps Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240925@162621.1313 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20240925@162621.1474 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.1477 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 ~inactivo valor from fl where no = '100999' and estab = 0 order by inactivo desc
20240925@162621.1592 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.1595 kvfsop3m9ki13enmnn4mo8k5ps Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240925@162621.1670 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.1672 kvfsop3m9ki13enmnn4mo8k5ps Query : select szadrsstamp valor from szadrs where szadrsdesc='flama-fab.louÇas e electrodomesticos,sa'
20240925@162621.1720 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.1723 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from ts where ndos = 5
20240925@162621.1804 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.2157 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20240925@162621.2228 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.2242 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20240925@162621.2251 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.2265 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20240925@162621.2274 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20240925@162621.2408 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240925@162621.2557 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240925@162621.2777 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.3041 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100999' and estab=0
20240925@162621.3185 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.3202 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20240925@162621.3243 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66f426460466f42b9d43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240925@162621.3319 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.3338 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20240925@162621.3350 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut66f426460466f42b9d43','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20240925','16:56',?,?)
20240925@162621.4151 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.4172 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20240925@162621.4192 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut66f426460466f42b9d43','trf entre armazéns a','2024-09-25',5,471,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20240925@162621.6281 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.6323 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.5540.00.1'
20240925@162621.6608 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.6612 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.5540.00.1'
20240925@162621.6736 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.6739 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.5540.00.1' and sa.armazem = 133 
20240925@162621.6810 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.6812 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.5540.00.1'
20240925@162621.6844 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5540.00.1'
20240925@162621.6993 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.7013 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162621.7027 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.7043 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162621.7052 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.5540.00.1' and lote = 'r2300830100a'
20240925@162621.7130 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162621.7168 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.7183 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162621.7197 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f425008466f42b9dae','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162621.7563 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.7580 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162621.7597 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f425008466f42b9dae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 12.000, 12.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,159.99,159.99*200.48,159.99,159.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,159.99*12.000,159.99*12.000*200.48 ,36.952000,36.952000*200.48 ,36.952000,36.952000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,159.99,159.99*200.48,159.99*12.000,159.99*12.000*200.48,'pll24092351699,025000001 ',159.99,159.99*12.000,159.99,159.99*12.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162621.8446 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.8535 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.1716.00.1'
20240925@162621.8596 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.8638 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1716.00.1'
20240925@162621.9244 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.9248 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1716.00.1' and sa.armazem = 133 
20240925@162621.9326 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162621.9329 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1716.00.1'
20240925@162621.9350 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1716.00.1'
20240925@162621.9501 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.9517 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162621.9530 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.9545 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162621.9554 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.1716.00.1' and lote = 'r2100312300a'
20240925@162621.9583 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162621.9595 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.9610 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162621.9621 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f429803266f42b9dea','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162621.9790 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162621.9805 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162621.9821 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f429803266f42b9dea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 8.000, 8.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,44.99,44.99*200.48,44.99,44.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,44.99*8.000,44.99*8.000*200.48 ,11.292000,11.292000*200.48 ,11.292000,11.292000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,44.99,44.99*200.48,44.99*8.000,44.99*8.000*200.48,'pll24092351739,384000002 ',44.99,44.99*8.000,44.99,44.99*8.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.2400 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.2440 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20240925@162622.2640 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.2670 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1317.00.1'
20240925@162622.4870 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.5030 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1317.00.1' and sa.armazem = 133 
20240925@162622.7030 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.7070 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1317.00.1'
20240925@162622.7280 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1317.00.1'
20240925@162622.9180 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.9340 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.9460 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.9600 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.9680 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20240925@162622.9810 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162622.9920 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.1006 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.1017 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f428061666f42b9e18','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.1186 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.1206 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.1223 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f428061666f42b9e18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,30000 ,179.99,179.99*200.48,179.99,179.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,179.99*6.000,179.99*6.000*200.48 ,51.816000,51.816000*200.48 ,51.816000,51.816000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,179.99,179.99*200.48,179.99*6.000,179.99*6.000*200.48,'pll24092351764,895000003 ',179.99,179.99*6.000,179.99,179.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.1832 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.1837 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20240925@162622.1853 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.1855 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1321.00.1'
20240925@162622.1871 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.1873 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1321.00.1' and sa.armazem = 133 
20240925@162622.1944 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.1947 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1321.00.1'
20240925@162622.1964 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1321.00.1'
20240925@162622.2117 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.2133 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.2146 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.2160 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.2168 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20240925@162622.2181 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162622.2194 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.2208 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.2220 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f420070466f42b9e35','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.2467 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.2579 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.2596 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f420070466f42b9e35',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,40000 ,189.99,189.99*200.48,189.99,189.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,189.99*6.000,189.99*6.000*200.48 ,52.005000,52.005000*200.48 ,52.005000,52.005000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,189.99,189.99*200.48,189.99*6.000,189.99*6.000*200.48,'pll24092351782,541000004 ',189.99,189.99*6.000,189.99,189.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.2948 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.2953 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.1329.00.1'
20240925@162622.2970 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.2973 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1329.00.1'
20240925@162622.2993 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.2996 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1329.00.1' and sa.armazem = 133 
20240925@162622.3073 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.3076 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1329.00.1'
20240925@162622.3095 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1329.00.1'
20240925@162622.3248 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.3264 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.3279 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.3294 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.3303 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.1329.00.1' and lote = 'r2400496300a'
20240925@162622.3317 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162622.3329 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.3344 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.3355 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f422680466f42b9e51','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.3506 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.3521 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.3537 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f422680466f42b9e51',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,50000 ,279.99,279.99*200.48,279.99,279.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,279.99*6.000,279.99*6.000*200.48 ,73.389000,73.389000*200.48 ,73.389000,73.389000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,279.99,279.99*200.48,279.99*6.000,279.99*6.000*200.48,'pll24092351796,264000005 ',279.99,279.99*6.000,279.99,279.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.3876 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.3880 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '328.9902.00.1'
20240925@162622.3896 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.3899 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '328.9902.00.1'
20240925@162622.3914 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.3916 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '328.9902.00.1' and sa.armazem = 133 
20240925@162622.3984 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.3987 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '328.9902.00.1'
20240925@162622.4006 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9902.00.1'
20240925@162622.4158 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.4175 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.4188 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.4202 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.4210 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='328.9902.00.1' and lote = 'r2301241100a'
20240925@162622.4230 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162622.4242 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.4258 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.4269 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f425550266f42b9e67','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.4559 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.4588 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.4642 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f425550266f42b9e67',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2.000, 2.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,60000 ,549.99,549.99*200.48,549.99,549.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,549.99*2.000,549.99*2.000*200.48 ,164.541000,164.541000*200.48 ,164.541000,164.541000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,549.99,549.99*200.48,549.99*2.000,549.99*2.000*200.48,'pll24092351805,359000006 ',549.99,549.99*2.000,549.99,549.99*2.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.4983 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.4987 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240925@162622.5001 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.5004 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1879.00.1'
20240925@162622.5020 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.5023 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1879.00.1' and sa.armazem = 133 
20240925@162622.5090 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.5092 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1879.00.1'
20240925@162622.5111 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20240925@162622.5256 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.5272 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.5284 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.6446 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.6458 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2300643200a'
20240925@162622.6481 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162622.6493 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.6509 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.6521 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f420339666f42b9e9e','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.6773 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.6939 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.6956 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f420339666f42b9e9e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2.000, 2.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,70000 ,84.99,84.99*200.48,84.99,84.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,84.99*2.000,84.99*2.000*200.48 ,27.528000,27.528000*200.48 ,27.528000,27.528000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,84.99,84.99*200.48,84.99*2.000,84.99*2.000*200.48,'pll24092351835,126000007 ',84.99,84.99*2.000,84.99,84.99*2.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.7282 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.7286 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240925@162622.7300 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.7303 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1879.00.1'
20240925@162622.7318 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.7321 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1879.00.1' and sa.armazem = 133 
20240925@162622.7344 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.7347 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.1879.00.1'
20240925@162622.7367 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20240925@162622.7381 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.7397 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.7409 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.7423 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.7431 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2300643200a'
20240925@162622.7445 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162622.7459 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.7473 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.7485 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f422086566f42b9eb6','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.7735 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.7899 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.7917 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f422086566f42b9eb6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,80000 ,84.99,84.99*200.48,84.99,84.99*200.48 ,0,0,'un ','' ,bo.marcada,1 ,84.99*4.000,84.99*4.000*200.48 ,27.528000,27.528000*200.48 ,27.528000,27.528000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,84.99,84.99*200.48,84.99*4.000,84.99*4.000*200.48,'pll24092351835,126000007 ',84.99,84.99*4.000,84.99,84.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.8266 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.8271 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20240925@162622.8286 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.8288 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.969.00.01'
20240925@162622.8304 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.8307 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.969.00.01' and sa.armazem = 133 
20240925@162622.8373 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.8376 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.969.00.01'
20240925@162622.8394 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.969.00.01'
20240925@162622.8543 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.8559 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.8571 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.8585 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.8594 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20240925@162622.8613 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162622.8625 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.8639 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162622.8651 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f422499166f42b9ed2','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.8807 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162622.8826 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162622.8841 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f422499166f42b9ed2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,90000 ,54.99,54.99*200.48,54.99,54.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,54.99*6.000,54.99*6.000*200.48 ,15.817000,15.817000*200.48 ,15.817000,15.817000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,54.99,54.99*200.48,54.99*6.000,54.99*6.000*200.48,'pll24092351912,078000008 ',54.99,54.99*6.000,54.99,54.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162622.9161 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.9165 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240925@162622.9180 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.9182 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.691.00.01'
20240925@162622.9198 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.9201 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.691.00.01' and sa.armazem = 133 
20240925@162622.9268 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162622.9271 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.691.00.01'
20240925@162622.9289 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.691.00.01'
20240925@162623.1110 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.1421 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.1434 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.1450 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.1458 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2400209200a'
20240925@162623.1482 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162623.1495 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.1509 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.1521 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f426686166f42b9f24','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.1719 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.1737 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.1766 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f426686166f42b9f24',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2.000, 2.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,100000 ,149.99,149.99*200.48,149.99,149.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,149.99*2.000,149.99*2.000*200.48 ,31.778000,31.778000*200.48 ,31.778000,31.778000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,149.99,149.99*200.48,149.99*2.000,149.99*2.000*200.48,'pll24092351945,547000009 ',149.99,149.99*2.000,149.99,149.99*2.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.2097 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.2102 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20240925@162623.2144 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.2147 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.691.00.01'
20240925@162623.2163 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.2166 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.691.00.01' and sa.armazem = 133 
20240925@162623.2259 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.2261 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '324.691.00.01'
20240925@162623.2308 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.691.00.01'
20240925@162623.2323 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.2340 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.2353 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.2368 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.2376 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2400209200a'
20240925@162623.2388 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162623.2401 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.2416 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.2429 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f425946166f42b9f3a','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.2609 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.2628 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.2763 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f425946166f42b9f3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,110000 ,149.99,149.99*200.48,149.99,149.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,149.99*4.000,149.99*4.000*200.48 ,31.778000,31.778000*200.48 ,31.778000,31.778000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,149.99,149.99*200.48,149.99*4.000,149.99*4.000*200.48,'pll24092351945,547000009 ',149.99,149.99*4.000,149.99,149.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.3232 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.3237 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240925@162623.3254 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.3257 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '323.318.09.00'
20240925@162623.3275 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.3278 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '323.318.09.00' and sa.armazem = 133 
20240925@162623.3352 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.3355 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '323.318.09.00'
20240925@162623.3378 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '323.318.09.00'
20240925@162623.3805 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.3826 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.3841 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.3861 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.3871 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2400053200a'
20240925@162623.3887 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162623.3901 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.3919 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.3931 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f422709666f42b9f5f','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.4120 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.4147 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.4167 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f422709666f42b9f5f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 5.000, 5.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,120000 ,219.99,219.99*200.48,219.99,219.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,219.99*5.000,219.99*5.000*200.48 ,67.424000,67.424000*200.48 ,67.424000,67.424000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,219.99,219.99*200.48,219.99*5.000,219.99*5.000*200.48,'pll24092351993,114000010 ',219.99,219.99*5.000,219.99,219.99*5.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.4504 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.4508 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.usalote valor from st where st.ref = '323.318.09.00'
20240925@162623.4524 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.4527 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '323.318.09.00'
20240925@162623.4542 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.4545 kvfsop3m9ki13enmnn4mo8k5ps Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '323.318.09.00' and sa.armazem = 133 
20240925@162623.4569 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.4572 kvfsop3m9ki13enmnn4mo8k5ps Query : select st.stns valor from st where st.ref = '323.318.09.00'
20240925@162623.4591 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '323.318.09.00'
20240925@162623.4605 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.4630 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.4644 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.4661 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.4670 kvfsop3m9ki13enmnn4mo8k5ps Query : select sestamp valor from se where ref ='323.318.09.00' and lote = 'r2400053200a'
20240925@162623.4684 kvfsop3m9ki13enmnn4mo8k5ps Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240925@162623.4697 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.4712 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240925@162623.4724 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut66f422471766f42b9f72','aut66f426460466f42b9d43',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.4887 kvfsop3m9ki13enmnn4mo8k5ps Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240925@162623.4907 kvfsop3m9ki13enmnn4mo8k5ps Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240925@162623.4923 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut66f422471766f42b9f72',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 5.000, 5.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,130000 ,219.99,219.99*200.48,219.99,219.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,219.99*5.000,219.99*5.000*200.48 ,67.424000,67.424000*200.48 ,67.424000,67.424000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,219.99,219.99*200.48,219.99*5.000,219.99*5.000*200.48,'pll24092351993,114000010 ',219.99,219.99*5.000,219.99,219.99*5.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut66f426460466f42b9d43'
20240925@162623.5253 kvfsop3m9ki13enmnn4mo8k5ps Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut66f426460466f42b9d43','','wait',5,'adm12071144683,938000003','')
20240925@162623.5351 kvfsop3m9ki13enmnn4mo8k5ps Query : use flama_phc
20240925@162623.5354 kvfsop3m9ki13enmnn4mo8k5ps Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240925@162623.5473 kvfsop3m9ki13enmnn4mo8k5ps Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2213';
20240925@162623.5583 kvfsop3m9ki13enmnn4mo8k5ps Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2213';

20240926@080330.2844 g8jd72qdjn09j8np32rupqu3ma Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2214';
20240926@080330.2945 g8jd72qdjn09j8np32rupqu3ma Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2214';
20240926@080330.2988 g8jd72qdjn09j8np32rupqu3ma Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2214';
20240926@080330.3042 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.3045 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240926@080330.3178 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.3181 g8jd72qdjn09j8np32rupqu3ma Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240926@080330.3322 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.3514 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.3873 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.3892 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.3909 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.3934 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.3950 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.3974 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.3990 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.4019 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.4035 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.4059 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.4093 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.4112 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.4136 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.4183 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.4209 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.645.00.01'
20240926@080330.4228 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2061 and bo.obrano = 2406182 and bi.ref ='324.645.00.01' and bi.lordem =1
20240926@080330.4263 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.4268 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240926@080330.4560 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.4578 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 1 valor from td where td.ndoc = 39
20240926@080330.4690 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.4694 g8jd72qdjn09j8np32rupqu3ma Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20240926@080330.4817 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20240926@080330.5018 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.5022 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240926@080330.5190 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.5194 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240926@080330.5291 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.5294 g8jd72qdjn09j8np32rupqu3ma Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240926@080330.5407 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.5411 g8jd72qdjn09j8np32rupqu3ma Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240926@080330.5490 g8jd72qdjn09j8np32rupqu3ma Query : use flama_phc
20240926@080330.5494 g8jd72qdjn09j8np32rupqu3ma Query : select 1 valor from td where ndoc = 39
20240926@080330.5635 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240926@080330.5717 g8jd72qdjn09j8np32rupqu3ma Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@080330.6167 g8jd72qdjn09j8np32rupqu3ma Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240926@080330.6270 g8jd72qdjn09j8np32rupqu3ma Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@080330.6287 g8jd72qdjn09j8np32rupqu3ma Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240926@080330.6346 g8jd72qdjn09j8np32rupqu3ma Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@080330.6362 g8jd72qdjn09j8np32rupqu3ma Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@080330.6381 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@080330.6700 g8jd72qdjn09j8np32rupqu3ma Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240926@080330.6881 g8jd72qdjn09j8np32rupqu3ma Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240926@080330.6900 g8jd72qdjn09j8np32rupqu3ma Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240926@080330.6950 g8jd72qdjn09j8np32rupqu3ma Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66f502215366f507429b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240926@080330.7204 g8jd72qdjn09j8np32rupqu3ma Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
