你的位置：
首页
>
IT圈
>
U8数据字典整理表
2024年5月9日发(作者：查惜)
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)启用会计日期
datetime 8 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] 上机日志
2024年5月9日发(作者：查惜)
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)启用会计日期
datetime 8 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] 上机日志