--清空账套管理密码

use KDacctDB

update t_users set FPassword ='' where fname='admin'

--清楚用户缓存

delete from t_userprofile  where fuserid in (select fuserid from t_user where fname like 'administrator')

--异常用户清理

delete from t_UserProfile where 

FCategory='FlowChart_POS' and FKey='LastPos'

and FUserID in(select fuserid from t_user where FName='用户名')

--网上报销隐藏差旅费和出差申请单

update t_dataflowDetailfunc set FShowSysType=0 where fsubfuncid=26202

update t_dataflowDetailfunc set FShowSysType=0 where fsubfuncid=26204

update t_DataFlowSubFunc set FShowSysType=0  where FSubFuncID=26202 

update t_DataFlowSubFunc set FShowSysType=0  where FSubFuncID=26204 

update t_DataFlowTimeStamp set fname=fname

--应收款明细表未设置变量

delete t_userprofile where fuserid =(select fuserid from t_user where fname='administrator');

delete t_LedgerPageSetup where fuserid =(select fuserid from t_user where fname='administrator');

delete icreportprofile where fuserid =(select fuserid from t_user where fname='administrator');

上传个k3wise常用数据库表，目前只会查找、更新

SELECT * FROM ICClassType WHERE FName_CHS LIKE '%供货%' --用此表基本上可以查询到所有的表

--隐藏我的消息广告

UPDATE t_SystemProfile SET FValue='none' where FCategory='BASE' AND FKey='MessageURL'

---固定资产卡片已经删除领用单无法驳回

select * from CIP_AssetsApplication where FBillNo in ('ZCLY-20200617-0000002')

select FFAQty,FFAAmount,FFATaxAmt,* from CIP_AssetsApplicationEntry where fid=2171

select * from CIP_AssetsApplicationHook where FBillID=2171

update  CIP_AssetsApplicationEntry  set FFAQty=0,FFAAmount=0  where fid=2171

delete from  CIP_AssetsApplicationHook where FBillID=2171

--查询供应链单据自定义字段

select* from ICTransactionType

select * from ICTemplate where fid = 'A01'

select * from ICTemplateEntry where fid = 'A01'

--隐藏网页端子系统只保留网上报销

D:\Program Files (x86)\Kingdee\K3ERP\KDHR\SITEFILE\WEBUI

文本打开login把下面的代码放到最后面 保存重启iis

<script type="text/javascript">

var sysnames = 'E-BOS,客户关系管理,内控管理,经销商门户';//在此添加要删除的子系统名称，并使用逗号,分隔

var sysCom = document.getElementById('ddlSystems');

for(var i=0;i<sysCom.options.length;i++){

if(sysnames.indexOf(sysCom.options[i].text) >= 0){

sysCom.options.removeChild(sysCom.options[i]);

i--;

}

}

</script>

--现金付款单取消登账

UPDATE t_RP_NewReceiveBill set FAccountingStatus=0,FMakeJournalDate_CN=NULL WHERE FNumber='00000151'

转发金蝶K3wise常用数据库表.doc

谢谢分享，很有用的表

清理异常用户