用友U8数据字典

UFSystem数据库

UA_Account Table (AA 系统管理) [U861] 账套表

Key Column Name Description Datatype Length Allow Nulls cDescription (U870)备注nvarchar100 True cIndustryCode (U8100)行业编号nvarchar100 True cUnitAddress4En (U870)单位英文地址4 nvarchar60 True cUnitAddress2En (U870)单位英文地址2 nvarchar60 True cCustomBrokerCode (U870)报关行nvarchar20 True cCustomCode (U870)海关代码nvarchar30 True cUnitNameEn (U870)单位英文名称nvarchar40 True cUnitAddress3En (U870)单位英文地址3 nvarchar60 True cOrgCode (U870)机构编码nvarchar50 True cPortCode (U870)发运港编码nvarchar10 True cUnitAddress1En (U870)单位英文地址1 nvarchar60 True iSysID (U861)账套内部标识nvarchar50 False cAcc_Id (U861)账套号nvarchar 3 False cAcc_Name (U861)账套名称nvarchar40 False cAcc_Path (U861)账套路径nvarchar128 False iYear (U861)启用会计期年smallint 2 False iMonth (U861)启用会计期月smallint 2 False cAcc_Master (U861)账套主管nvarchar20 True cCurCode (U861)本币代码nvarchar 4 False cCurName (U861)本币名称nvarchar8 False cUnitName (U861)单位名称nvarchar40 False cUnitAbbre (U861)单位简称nvarchar40 True cUnitAddr (U861)单位地址nvarchar80 True cUnitZap (U861)邮政编码nvarchar 6 True cUnitTel (U861)联系电话nvarchar30 True cUnitFax (U861)传真nvarchar30 True cUnitEMail (U861)电子邮件nvarchar40 True cUnitTaxNo (U861)税号nvarchar20 True cUnitLP (U861)法人nvarchar16 True cFinKind (U861)备注二nvarchar16 True cFinType (U861)备注一nvarchar16 True cEntType (U861)企业类型nvarchar12 False cTradeKind (U861)行业类型nvarchar100 True cIsCompanyVer (U861)是否集团版nchar 1 False cDomain (U861)域名nvarchar40 True UA_Account_sub Table (AA 系统管理) [U861] 账套年度表

Key Column Name Description Datatype Length Allow Nulls cAcc_Id (U861)账套号nvarchar 3 False iYear (U861)账套年度smallint 2 False cSub_Id (U861)模块标识nvarchar 2 False bIsDelete (U861)是否删除bit 1 False bClosing (U861)是否关闭bit 1 True

iModiPeri (U861)会计期间tinyint 1 True dSubSysUsed (U861)启用会计日期datetime8 True cUser_Id (U861)操作员nvarchar20 True dSubOriDate (U861)启用自然日期datetime8 True UA_Period Table (AA 系统管理) [U861] 会计期间表

Column Name Description Datatype Length Allow Nulls cAcc_Id (U861)账套号nvarchar 3 False iYear (U861)账簿年度smallint 2 False iId (U861)会计期间tinyint 1 False dBegin (U861)开始日期datetime8 False dEnd (U861)结束日期datetime8 False bIsDelete (U861)是否删除bit 1 True UA_TaskLog Table (AA 系统管理) [U861]站点网络控制表

Column Name Description Datatype Length Allow Nulls uuid (U872)guid nvarchar40 True cLSSubId (U872)子系统标示对应的加密号nvarchar 4 True cStationSerial (U872)工作站唯一标识nvarchar255 True cSub_Id (U861)模块标识nvarchar 2 True cSub_Name (U861)模块名称nvarchar40 True cStation (U861)机器名nvarchar255 True dInTime (U861)进入日期datetime8 True cTaskId (U861)任务标识nvarchar20 False TaskState (U861)任务状态nvarchar40 True cAppServer (U861)应用服务器名称nvarchar80 True UA_Log Table (AA 系统管理) [U861] 上机日志

Column Name Description Datatype Length Allow Nulls cAcc_Id (U861)账套号nvarchar 3 False cSub_Id (U861)模块标识nvarchar 2 False cUser_Id (U861)操作员nvarchar20 False cAuth_Id (U861)功能编号nvarchar100 False cStation (U861)机器名nvarchar255 False dInTime (U861)进入日期datetime8 True dOutTime (U861)退出日期datetime8 True iLogId (U861)登录标识float8 True iyear (U861)账簿年度nvarchar 4 True Success (U861)成功标志smallint 2 True UA_AALog_base Table (AA 系统管理) [U870] 系统管理日志信息

Column Name Description Datatype Length Allow Nulls cSub_Id (U870)产品号nvarchar 2 False cLogItem_ID (U890)日志内容号nvarchar100 True cLog_Txt (U870)日志信息nvarchar3000 False iyear (U870)年度nvarchar 4 True cLog_ID (U870)日志编码nvarchar100 False cAcc_Id (U870)账套号nvarchar 3 False cUser_Id (U870)用户编号nvarchar20 False