用友维护常用SQL语句脚本(上篇).docVIP

用友维护人员常用SQL语句 （上）--查询用友版本号use ufsystemgoselect * from UA_Version go-------------------------------------------------------------------查看系统用户信息表use ufsystemselect ?cUser_Id as 操作员编码cUser_Name as 操作员名称nState as 是否停用 iAdmin as 是否帐套主管理cDept as 所属部门cBelongGrp as 所在组nState as 是否停用from UA_User--查看具有帐套主管身份的操作员select ?cUser_Id as 操作员编码cUser_Name as 操作员名称from UA_User where iAdmin=1;--查看被停用的操作员select ?cUser_Id as 操作员编码cUser_Name as 操作员名称from UA_User where nState=1;--帐套主子表相关信息use ufsystem--帐套主表select?cAcc_Id as 账套号?cAcc_Name as 账套名称?cAcc_Path as 账套路径?iYear as 启用会计期年?iMonth as 启用会计期月?cAcc_Master as 账套主管?cCurCode as 本币代码?cCurName as 本币名称?cUnitName as 单位名称?cUnitAbbre as 单位简称?cUnitAddr as 单位地址?cUnitZap as ?邮政编码?cUnitTel as ?联系电话?cUnitFax as ?传真?cUnitEMail as ?电子邮件?cUnitTaxNo as ?税号?cUnitLP as ?法人?cEntType as ?企业类型?cTradeKind as ?行业类型?cIsCompanyVer as ?是否集团版?cDomain as ?域名 ??cDescxription as 备注 ??cOrgCode as 机构编码?iSysID as 账套内部标识from ua_account--帐套子表select cAcc_Id as 账套号iYear as 账套年度?cSub_Id as 模块标识?bIsDelete as 是否删除?bClosing as 是否关闭?iModiPeri as 会计期间?dSubSysUsed as 启用会计日期?cUser_Id as 操作员?dSubOriDate as 启用自然日期from ua_account_sub--当客户的数据在其它机器上做的升级然后拷回到原机器/*拷回的数据，通过‘系统管理’在原机器上引入后，并不会在ufsystem数据库中的ua_account_sub这个帐套子表中回写上一年度的bClosing字段来关闭上一年度*/--比如002帐套结转后年度为2010则用于关闭上一(2009)年度的sql如下：select * from ua_account_sub where cAcc_Id=002 and iYear=2008update ua_account_sub set bclosing=0where cAcc_Id=002 and iYear=2008-------------------------------------------------------------------清除异常任务及单据锁定use ufsystemdelete from ua_taskdelete from ua_taskloggodelete from ufsystem..ua_taskdelete from ufsystem..ua_taskloggoSelect * From ua_task Where(cacc_id=***) ?--注：（***为账套号） --科目锁定的解决/*XX科目已经被用户[XX]锁定”或“(xxxxxx)正在被机器(xxxx)上的用户(xxx)进行(xxxx)操作锁定请稍候再试”。*/use UFDATA_002_2008select ?ccode as 科目编码?cauth as 功能名称?cuser as 用户名?cmachine as 机器名from GL_mccontroldelete from GL_mccontrol----------------------------------