2024年3月21日发(作者：)

用友erp常用SQL语句

go

-----------------------------------------------------------------

--查看系统用户信息表

use ufsystem

select 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

字段来关闭上一年度

*/